Virtual Data Wall: Manage and Upload Assessment Scores

After logging into Insights access the "Assessments" tab on the left, then the "Manage" page

Select the "+New" button on this page to begin your manual upload

Type in a title for your Assessment in the "Name" field

Make sure your assessment title is unique. Assessments with the same Name will be overwritten if multiple sets of scores are uploaded.

Select the School Year from the drop down menu

Check the "Enable Import" checkbox

Click the "Edit Sites" button and choose at least one site/grade level. For uploaded assessments this does not have to match the students as they will be matched via their unique identifier, either District or State ID.

"Open Import Template" button

The following window will appear. You have the option of importing all columns of your Excel or .csv file, or unchecking the "Import columns to assessment"(usually used in spreadsheets with many columns such as state assessment files)checkbox and manually add the values you wish to include to the Data Wall. Browse your hard drive for the file by clicking the "Select File" button

You must map the Student ID column to the correct type of ID, either District (local/OSIS) or State (SSID).

Below the Student Id column is linked to the column of the spreadsheet that contains the Student ID "B_District_Student_ID"

​Under the "Score Column" drop down menus, choose the data to merge into the data wall. Each row corresponds to a column in your data file. If you chose to "Import columns to assessment" they will already be imported. If you unchecked that box, you will have to use the "+" to add a row, give it a Name, Score Type, and map it to the correct Score Column.

Select the "Score type" from the drop down menu. The options are Letter or Numeric.

See below the "Score Column" was linked to the column of the spreadsheet that contained the student scores "E_Scale_Score"

More scores can be added to the Data Wall, such as Common Core State Standard scores or scores to a part of the test. To do so click the "+" button on the top next to the exam name.

Link the values as done in the prior step. You can also drag and drop the placement of each score, as well as add subscores. To add a subscore, click the"+" button next to the "Parent thread." This will add a dropdown when in the Virtual Data Wall.

You can also drag and drop rows to change the order.

Once complete click the "Save" button at the top of the page.

You will be redirected to the following page to upload the test with the questions

Click the drop down menu to the right of "Edit" then import.

Browse your hard drive for the digital copy of the assessment.

Leave the browser open until you are notified that 100% of the file has been uploaded.

Ready for more? Check out our Virtual Data Walls help chapter.