Follow

Exporting Student Data out Of CASE21

In this section we are going to learn how to export the data need for the student ID file from inside CASES21.

Step 1: Log into CASES 21

Step 2: Click on the Worksheet- Display SQL Tables Link

Step 2: Click on the Worksheet- Display SQL Tables Link

This looks like a little excel spreadsheet with a magnifying glass on it.

Step 3: Click Add Table ( you may have to click design mode first)

Step 3: Click Add Table ( you may have to click design mode first)

Step 4: Select the ST students Table

Step 4: Select the ST students Table
  1. Click Minor on the left of the table select window
  2. Scroll down to ST Students and select it
  3. Then click ok

Step 5: Select the fields required.

Step 5: Select the fields required.

Double click the fields required for the csv file.

  1. SCHOOL_YEAR
  2. SURNAME
  3. FIRST_NAME
  4. STKEY
  5. VSN
  6. REGISTRATION (NB-This is required for Government schools who use our SPAreporter Software)
  7. MID_NAME
  8. PREF_NAME
  9. GENDER
  10. BIRTHDATE
  11. KOORI
  12. PSDREQ
  13. ENG_SPEAK
  14. HOME_GROUP
  15. STATUS

Step 6: Select Only the Active Students

Step 6: Select Only the Active Students

IMPORTANT NOTE: You must enter the following =’ACTV’ in the criteria cell under STATUS or you will get all your past students not just the active ones.

Step 7: Un-tick Show under the * and Status Cells.

Step 7: Un-tick Show under the * and Status Cells.

Step 8: Click Apply

Step 8: Click Apply

Step 9: Select the data to export to excel.

Step 9: Select the data to export to excel.

Click the box in the top corner to select all the records

Step 10: Click Export to excel

Step 10: Click Export to excel

Click yes if prompted to trust the VB code

Click yes if prompted to trust the VB code

This will open up excel with the data in it

Step 11: Remove any unused columns

Make sure to remove any un used columns and only keep the required fileds

  1. SCHOOL_YEAR
  2. SURNAME
  3. FIRST_NAME
  4. STKEY
  5. VSN
  6. REGISTRATION
  7. MID_NAME
  8. PREF_NAME
  9. GENDER
  10. BIRTHDATE
  11. KOORI
  12. PSDREQ
  13. ENG_SPEAK
  14. HOME_GROUP
  15. STATUS

Step 12: Open up the Excel file and copy your data into our Student Tracker File.

To access the Student Tracker File file for SPAstandard click here, or for SPAplatform (SPAmarkbook and SPAreporter) click here.

Step 12: Save the file on your computer.

You are now ready to upload the template to SPA.

To upload the file to SPAstandard click here, or for SPAplatform (SPAmarkbook and SPAreporter) click here.

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

Comments

Powered by Zendesk