Table 31.7 Person measure profiles for classes of items

 

.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