Overview
If your SAT tests have been read by an optical reader you can paste the results into an import.
Article Sections
- Import Time
- Prepare Template
- Test ID's
- Import Template
- Trouble Shooting
- View Imported Data
- Print SAT Report
- Edit Answers
Import Time
There is no time to be gained by importing test answers unless the SAT has already been converted to a list of student answers by optical software or other means. If you will be typing the student answers into the template you should enter the student answers directly into Oases following tutorial STP02.
Prepare Template
1. Download and prepare the import template by by going to Setup.
2. In the Data Import section select Template Import.
3. Select the Program for which you wish to import data.
4. On the right side select and download the Test Results Import Template.
5. Open the import template and save it to your computer with a new name. Review the template and sample data. Green columns are required items and blue columns are optional.
6. When familiar select rows 5 - 10 and right click delete to remove the example data from the template.
7. Add the name of your student/s for whom you wish to import results. There will be 5 rows per SAT test to represent Reading, Writing & Language, Math No Calculator, Math Calculator so add the student name 5 times for each SAT. (4 if the essay portion was not attempted)
8. Add the date the test was taken as shown above - Add for each test section in the Test Date column.
Test ID's
9. Add your test ID's for each section. Find your Test Type ID's from the Oases import page beneath the templates.
10. When the ID list opens locate the SAT taken and highlight and copy the Oases Test ID's. In the example below I require the 5 ID's for the SAT 1. The image below is an example only and does not necessarily represent the accurate Oases ID's for SAT 1 in your database.
11. Paste these into the import template next to the relevant student in the Test Type ID column.
12. To ensure you put the student answers in the correct row you may wish to add yourself a note in the comment section as shown above.
13. Now copy and paste the student answers into the relevant row for each test.
The answers the student gave will begin in column M as shown below.
(If you are hand typing them into this template then there is no time to be gained by importing results and entering the answers directly into the student record in Oases will be just as fast see STP02)
14. For the essay portion place the score into column I.
15. In Column A of the template add the student ID from within the student record in Oases.
You will find the ID number on the second tab of the student record in the ID field.
The student number is also available in various reports in the report area of Oases.
16. Repeat the above process for any other students and test answers that need to be imported. There is no limit to the quantity of data that may be imported on one template. The only restriction is that you import per program so all students on the template must be in the program to which you import.
17. When complete save your template file.
Import Template
18. On the Oases Template Import page next to Import Tests press on Select File and grab your new template from its saved location.
19. When selected press upload.
20. You will receive a message at the top of the screen when complete.
Trouble Shooting
21. If there is a problem the message will be red and will tell you the exact problem so you may adjust your template and try again.
View Imported Data
22. In the student record the tests will be entered exactly as if you had added them by hand directly to the student record.
Print SAT Report
23. To print the student's score report press any of the download icons to the left of the test name.
Edit Answers
24. To change answers press the test name.
25. To change the Essay score change the score directly in the Essay score field.
Link To
STP01. SAT Practice Test Papers & Information
STP02. Scoring an SAT Test in Oases and Producing Report