Lertap is a short name for the Laboratory of Educational Research Test Analysis Package.


The present Lertap, "Lertap5", is a system which works as an application running within Microsoft's Excel program.


To get a quick idea of what Lertap5 does, move forward and select from our smorgasbord of samples.
To have some immediate hands-on fun, jump right into the action part of the Cook's Tour.


The main purpose of this website is to provide paths to sample datasets for use with Lertap.


The "Cook's Tour" of Lertap5 is also found here, in this website. It has a description of the Lertap5.xlsm workbook, and its five worksheets: Comments, Data, CCs, System, and Syntax. The Cook's Tour also gets into an actual run of Lertap5, with steps to follow on your own computer to keep from falling asleep.


A bit of history, and some important links to other resources:


Lertap dates back to 1972, when it made its first appearance at the University of Colorado in the United States. It was written in the FORTRAN computer language, and ran on mainframe computers generally situated in a special, single-purpose building, often called the "Computing Centre". Mainframe computers were very large, usually occupying at least half of one of the building's floors.


When microcomputers became popular in the 1980s, versions of Lertap were made to run on them. Most of these were written in the BASIC computer language.


In the late 1990s a new genre, "Lertap5", was created to run as an Excel application. This version was made at Curtin University in Western Australia. It is written in VBA, Visual Basic for Applications.


Excel is a spreadsheet program created by Microsoft. It's a member of the suite of programs known as "Microsoft Office", a collection of programs which includes Word, PowerPoint, Outlook, Access, and, of course, Excel.


Numerous versions of Excel have emerged over the years. As of March, 2019, editions of Lertap5 were available for Excel 2007 (Windows), Excel 2010(Windows), Excel 2013(Windows), and Excel 2016(Windows and Macintosh).


The Excel 2010 version of Lertap5 was used to create the charts and reports in this document. Had one of the other editions been used, the results would have been much the same.


Here are some links to other Lertap resources:



A PDF copy of this website's topics. A CHM copy (compiled help file for Windows). An iBook copy, ready for reading on an iPad or an iPhone. A link to the website itself.


A small set of PowerPoint slides with a quick introduction to Lertap5. These are also available as a PDF file.


The main Lertap5 website. Has more examples and samples, with links to videos, the manual, and a variety of riveting technical papers (also known as "erudite epistles").


Some "Tips & Tricks" for users. Demonstrates the use of quintile plots; showcases selected Excel and Lertap features.


The online help system for Lertap5. A primary source for finding out how to obtain Lertap5, how to get it running, and understanding features added after the manual was printed.


Larry's QUIA website, our developmental site. At times has a variety of special tidbits and morsels, especially for instructors and students.


The e-store for Lertap5, the place which sells licenses for Lertap5 users when they have more than 100 cases to process.


Please direct questions or comments to:

Last update: 4 September 2019