In this section we are going to learn how to create the data needed to import your Observation Survey Data into SPA.
Step 1: Download the Observation Survey template.
1b: Save the file to your computer
Once you have clicked on the template your computer will either download the file directly to your downloads folder or it will ask you where you would like to save the file.
Save the file to a location where you can easily access it.
Step 2: Open the Template
Open the downloaded template. Making sure to click "Enable Macros" when opening the file.
Once opened it should look like this.
Step 3: Select the test you would like to mark.
Step 4: Fill out all of the information in student details in the first few columns marked 'required'.
For each student
- Enter the test date (eg-08/02/18)
- Date of Birth
- Year Level
- Home Group (optional)
- First Name
- Student ID (Student Number)
Step 5: Entering the student responses or raw score
OPTION 1: For each student can can either choose to input a 'y' for a correct response or a 'n' for a wrong response. If you choose this option, the raw score and Stanine score will be automatically calculated for you.
OPTION 2: For each student can can choose to enter a raw score. The Stanine score will be automatically calculated for you.
Please Note! These are self marking templates. Please be very careful not to remove the formatting on the cells and any formulas that are in them otherwise the templates will not work correctly.
Step 6: Save the file and return to the main menu
Once you have entered all the results into the template you are now ready to save the file to your computer.