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
This looks like a little excel spreadsheet with a magnifying glass on it.
Step 4: Select the ST students Table
- Click Minor on the left of the table select window
- Scroll down to ST Students and select it
- Then click ok
Step 5: Select the fields required.
Double click the fields required for the csv file.
- REGISTRATION (NB-This is required for Government schools who use our SPAreporter Software)
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 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
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