{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Directions","Data","Report Generator","Information for Help Box"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Directions","index":0,"n_rows":49,"n_cols":21,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Student Score Report Generator for the Idaho Alternate Assessment in Science\n\nThis report generator allows you to produce individual student score reports for students who took the Alternate Science Assessment, using data from the Assessment Data Export Application (ADEA). To produce these reports, follow the directions below.\n\n"]
["Step 1\n• Make sure macros are enabled. Macros are the automated code underlying this report generator. Macros are generally not enabled by default. When you opened this Excel file, you may have seen a yellow bar at the top of the spreadsheet with a security warning saying that macros have been disabled. If you did not click \"Enable Content\" at that time, re-open the file and enable the macros for this report generator to work.\n"]
["Step 2\n• Download your school's Science alternate assessment data from the ADEA application \n• Open the data file you downloaded in Excel (i.e. not in Notepad or another program)\n• Copy the entire Excel worksheet of your school's data. Not sure how to copy the data...\n\n"]
["Step 3\n• Load your data using the button to the right"]
["Step 4\n• Does your computer allow you to save files to your Desktop?"]
["Step 5\n• Run the student score reports using the button to the right"]
["If your computer allows you to save files to your Desktop, individual student reports will appear as PDF files, saved in a new folder the report generator will create on your Desktop called \"Science Alternate Assessment Student Score Reports.\" After the reports are complete, the report generator will automatically close. \n\nIf your computer does not allow you to save files to your Desktop, the reports will appear as separate Excel files in this document. You can print each spreadsheet as needed or the entire active Workbook. \n\nFor any questions or technical issues, contact Kevin Whitman at kwhitman@sde.idaho.gov. \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Data","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Paste your data here in cell A1"]

{"sheet":"Report Generator","index":2,"n_rows":60,"n_cols":2,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Report Generator"]
["First Name","."]
["Last Name","."]
["Birth Date","."]
["Grade","."]
["Proficiency Level","."]
["Total Score","."]
["Objective 1","."]
["Objective 2","."]
["Objective 3","."]
["Objective 4","."]
["Objective 5","."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(LEFT(B2, 1), \". \")","v":".. "}]

{"sheet":"Information for Help Box","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["You need to move your school's data into this file for the Report Generator to work. If you are unfamiliar with copying and pasting data, use the following steps:\n\n-With your school's data file open, press CTRL+A. This will select all of the data in the file. You will see a green box appear around the data when this step is successful\n-Press CTRL+C. This step copies the data, making the data available to add to another file \n-To paste the data, which is the next step, go to the \"Data\" worksheet in this Report Generator file. The Data worksheet says \"Paste your school's data here\". Click on cell A1 and then press CTRL+V. Your school's data should now appear\n"]