Download 2 - Quia

Transcript
Input & Output
6.2
255
Data sheet
The name of the Excel worksheet where data are recorded for Lertap analysis has to
be "Data". The first two rows of the Data worksheet are for header information, as
described in the definition 253 of a Lertap workbook.
Have a look at the top of a typical Lertap Data sheet:
Row 1 is a general "header", or title, which can contain any information you wish,
including nothing at all. Whatever is typed in this row will not appear anywhere else;
Lertap doesn't read this row. This row is for your own use -- we use it to provide a
brief reminder of the information contained in the Data sheet.
Row 2 also has header information. Each column has been given a header, or label:
ID; Position; Experience; Gender; Q1; Q2; and so on.
For your information, the CCs sheet corresponding to this workbook had these two
lines:
*col (c5-c64)
*sub aff, res=(1,2,3,4)
Item responses begin in column 5 of the Data sheet, and continue through column 64.
Lertap will use the labels found in row 2, columns 5 through 64, as item IDs. That is,
the ID for the first item will be Q1; for the second item Q2; ... and Q60 for the last
item (not shown above).
Item IDs can be anything, and in theory can have any length. However, we strongly
suggest that items IDs be short -- not greater than 8 characters in length. Valid
examples of item IDs: Item1; Preg.2; Soal3; Ques2b; SD204; Likrt17a. Having short
item IDs makes parts of Lertap's output easier to read; for example, the Stats1f report
has a section which looks like this:
© 2003-2011, Curtin University, West Australia