Replicating the ORS Display

1. Select the appropriate year
   Features & Tools – Change Reporting Time Period

2. Use the Filters (left navigation) to select the appropriate Test Groups – select Apply

3. From the Performance Distribution dashboard, select the subject card to view individual assessments

4. Export the Report from the CRS
   Click the icon to the left of the test name (green arrow icon)
   Select the option:
   Overall Test, Reporting Category and Item Performance of all students
   CSV format

5. From the Secure Inbox, select the hyperlink to save to your device

6. Save (or identify) where this file is located on your device

1. Import spreadsheet into Item Analysis Template

2. File – Import – Upload

3. Select File from Device

4. Identify where you would like the file imported
   Import Location: Insert New Sheet
   Separator Type: Detect Automatically

From the Item Analysis menu in the top ribbon,

• Select the appropriate function:
  Get Percents ELA 3^rd Grade is for the fall and spring 3^rd grade OST Only
  Get Percents ALL OTHERS is for all other OSTs, and all benchmark assessments

• Authorization is required to allow the script to run:
  Select Continue
  Log in to your Google Account
  Allow the script library ItemAnlysisV2helpers (where the script is stored) to access your google account.

• Once you have provided authorization run the script again by selecting the function from the Item Analysis menu.

• Rename “theData” and “theResults” tabs to identify the test subject/grade.

• Continue in this manner to add additional tests.