Lertap uses a special worksheet to tell Excel how to process student responses.  It's called "CCs".

 

 

The *col "card" (or line) indicates that item responses are located in columns 5 through 28 of the Data worksheet.

 

The *sub card provides Name and Title information which will be used when Lertap creates its various reports.  Name and Title are optional fields on the *sub line; this being the case, this CCs worksheet could have had just two lines: *col and *key -- Lertap will use its innate intelligence to supply what it thinks might be a suitable Name and Title if you don't supply this information.

 

The *key card indicates the "keyed-correct answer" for each of the 24 items.  The correct answer to the first item was C; it was B for the second and third items; A for the fourth item; D for the fifth; A for the sixth, and so on.

 

The spaces seen in this card are not important. A long string, *key CBBADAAACDADBBCABBACBDC, would have been quite okay.  Here at Lertap Central we usually group item keys by fives as it makes finding the 14th item's key a lot easier (for example).

 

Is it possible for an item to have more than one keyed-correct answer?  Yes, you bet.  I demonstrate how in a later topic.  If that's not enough, you can read much more about CCs worksheets and "control cards" by clicking here.

 

Jump to the next topic with a click here.