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


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


To get a quick idea of what Lertap 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 Lertap is also found here, in this website. It has a description of the Lertap5.xlsm workbook, and its six worksheets: Comments, Data, CCs, System, Syntax, and OldCCs. The Cook's Tour also gets into an actual run of Lertap, 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, "Lertap 5", 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. A special edition of Lertap 5 has been created for every version of Excel for Windows. As of June, 2012, editions of Lertap 5 were available for Excel 2003, Excel 2007, and Excel 2010. Lertap 5 has also been adapted to run under Excel X, Excel 2004, and Excel 2011 with Macintosh computers.


The Excel 2010 version of Lertap 5 was used to create the charts and reports in this document. Had the Excel 2007 or Excel 2011 versions 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 Lertap. These are also available as a PDF file.


The main Lertap 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 Lertap. A primary source for finding out how to obtain Lertap, 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 Lertap 5, the place which sells licenses for Lertap 5 users when they have more than 50 cases to process.


Please direct questions or comments to:

Last update: 8 October 2018