.Table 31.7 shows the person ability and summary scores for each item classification selected by DPF=
TABLE 31.7 An MCQ Test: administration was Compu ZOU749WS.TXT Apr 30 2017 13:11
INPUT: 30 STUDENT 69 TOPIC REPORTED: 30 STUDENT 48 TOPIC 2 CATS WINSTEPS 3.93.0
-----------------------------------------------------------------------------------
DPF class specification is: DPF=1
-----------------------------------------------------------------------------------------------------------
| * ALL TOPIC ON STUDENT | i TOPIC CLASS | n TOPIC CLASS | STUDENT |
| COUNT T.SCORE MEASURE S.E. | COUNT T.SCORE MEASURE S.E. | COUNT T.SCORE MEASURE S.E. | ENTRY LABEL |
|-----------------------------+-----------------------------+-----------------------------+---------------|
| 21 9 -1.92 .00 | 5 0 -3.39 1.64 | 16 9 -1.50 .59 | 2 NM KAT |
| 9 2 -3.09 .00 | 3 1 -2.18 1.40 | 6 1 -3.63 1.19 | 5 NL SMI |
same with BOXSHOW=No, useful for pasting into Excel:
* ALL TOPIC ON STUDENT i TOPIC CLASS n TOPIC CLASS STUDENT
COUNT T.SCORE MEASURE S.E. COUNT T.SCORE MEASURE S.E. COUNT T.SCORE MEASURE S.E. ENTRY LABEL
21 9 -1.92 .00 5 0 -3.39 1.64 16 9 -1.50 .59 2 NM KAT
9 2 -3.09 .00 3 1 -2.18 1.40 6 1 -3.63 1.19 5 NL SMI
For the MEASUREs, ">" (maximum score), "<" (minimum score), "E" (extreme score) indicate measures corresponding to extreme scores.
Excel procedure:
1. Output Table 31.7
2. Paste into a new Excel worksheet
3. In Excel, "Data", "Text to Columns", "Fixed width"
4. "Insert", "Line Chart with Markers"
5. "Select Data", the Excel spreadsheet row. "Category labels", the top row of the Excel spreadsheet.
6. X-axis, text labels.
Here is the plot for Example0.txt across items with different first letters:
This can be automated with an Excel macro:
Sub Profile()
firstsubtest = "A" ' in Excel spreadsheet, delete unwanted columns. First subtest column
lastsubtest = "H" ' total score + 7 subtests
firstperson = 2 ' first person in row 2 of the worksheet
lastperson = 5 ' last person in row 76 of the spreadsheet
personname = "I" ' person name in co.umn 9 = I
For thisperson = lastperson To firstperson Step -1
thispersonrow = Trim(thisperson)
Set objchart = Charts.Add
objchart.ChartType = xlLineMarkers
objchart.SeriesCollection.NewSeries
objchart.SeriesCollection(1).Values = "='Sheet1'!$" + firstsubtest + "$" + thispersonrow + ":$" + lastsubtest + "$" + thispersonrow
objchart.SeriesCollection(1).Name = "='Sheet1'!$" + personname + "$" + thispersonrow
objchart.SeriesCollection(1).XValues = "='Sheet1'!$" + firstsubtest + "$1:$" + lastsubtest + "$1"
Next thisperson
' and to print the charts
For Each ch In ActiveWorkbook.Charts
ch.PrintOut
Next ch
End Sub
