Follow

Observation Survey-Marie Clay

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

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.

Once opened it should look like this.

Step 3: Select the test you would like to mark.

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'.

Step 4: Fill out all of the information in Column A-F

For each student

  1. Enter the test date (eg-08/02/18)
  2. Date of Birth
  3. Year Level
  4. Home Group (optional)
  5. Surname
  6. First Name
  7. Student ID (Student Number)

Step 5: Entering the student responses or raw score

Step 4: Fill out all of the information in Column A-F

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.

Step 7: Repeat steps 3-6 until you have filled in results for each assessment template you students have undertaken. If they have not completed all assessments, leave the template/s blank. Make sure you don't have student details listed in templates where they have not undertaken the assessment.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk