GRADER III and its item analysis component produce seven reports, which are sent to instructors as email attachments.
Overview of Attachment Reports
Each attachment report file name contains the four digit number (#### in the report names below) of the instructor’s GRADER III account. All these reports are in text format.
The GRADER III reports are titled:
- EERR####.TXT – This GRADER III error report lists any problems encountered with your data.
- UERR####.TXT – This report lists any updates you made to your GRADER III account and any problems which may have occurred.
- REPT####.TXT – A standard GRADER III report, consisting of:
- Cover page – to check header information
- Distribution of scores – for total score and individual test scores
- Histogram of scores – for total score and individual test scores
- Student lists – alpha, PID, and score order as requested
- Summary page – mean and standard deviation for all tests
- IRPT####.TXT – Item analysis reports include:
- Cover page
- Distribution of scores
- Item performance report
- Standard form item analysis – one test item per line
- Long form item analysis – three test items per page with additional item statistics
- Summary page – difficulty, discrimination and reliability indices
- FEED####.TXT – Feedback reports which could not be emailed to students because of student name/PID problems
- TOTS####.DAT – Total scores in a fixed-format text file, including:
- Student name
- Section number
- Grade – if assigned
- Total score in selected format
- Scores on each individual test
- ILBL####.LBL – Basic Item analysis statistics. This file indicates test items with multiple correct responses.
Viewing & Printing Reports
All the reports with the file extensions .TXT, .DAT, or .LBL are in ASCII text format. The reports that have the .TXT extension may not display correctly in word processing software, like Microsoft Word. The lines may wrap around and the text may not be formatted correctly by default.
To display the reports correctly follow these steps:
- Open the report in your word processing software.
- Change the page layout to landscape orientation.
- Make the left and right margins as small as possible.
- Select all the text in the document and change the font to a fixed font like Courier or Courier New and the font size to 8.
Your GRADER III report is now more easily viewed. The first page is a blank page in some of the reports.
Using the Total Scores File with Microsoft Excel
One of the GRADER III reports you receive as an email attachment is a Total Scores file, named TOTS####.DAT, where #### is the number of your GRADER III account. The Total Scores file can be opened as an Excel spreadsheet that then can be sorted and other spreadsheet functions can be performed on the scores.
To open as an Excel spreadsheet follow these steps:
- With Microsoft Excel open, select “File” on the upper menu bar and select “Open” on the drop-down menu.
- In the “Look in:” area, locate the name of the folder holding your GRADER III email attachment reports. This attachment file should be in the folder you normally receive attachments.
- When you have the appropriate folder in the “Look in:” area, select “All Files (*.*)” from the drop-down menu for the “Files of type” area at the bottom the “Open” dialog box. Your GRADER III email attachment files will be listed in the area below the “Name” header.
- Double click on the TOTS####.DAT file you wish to open.
- The Excel Text Wizard panel will appear, stating that your data is in fixed-width format and showing you a preview of the first half-dozen records in your file. Click the “Next” button in the Text Wizard dialog box.
- The next dialog box allows you to set field widths. Select “Next.”
- The next dialog box allows you to set the “Data Format” for each column. Click the “Finish” button.
Excel will display the data in your TOTS####.DAT file. Click on the rectangle above row 1 and to the left of column A to mark the entire spreadsheet.
Click “Format” in the upper toolbar, move your cursor to “Column” on the drop-down menu and then to the right to “AutoFit” Selection. When you release the cursor, Excel will adjust the widths of all columns so that student names, PIDs, and scores are entirely visible.
If you feel that the score columns on the right are too narrow, place your cursor on the letter heading of the left-most or right-most score column, hold the cursor button down and drag it across the range of columns you wish to widen. Then select “Format,” “Column,” and then “Width.” Set the column width to 5 or 6 and click “OK.”
When the spreadsheet is formatted to your liking, save it as an Excel Workbook file with an .XLS or .XLSX extension. Now you may access it directly with Excel without going through the formatting process.