Follow the instructions below to extract a list of prior Victorian Curriculum results from CASES, which can then easily be imported into GradeXpert.
1. In CASES21, click Utilities and View & Report Data.
2. Double-click “Worksheet - Display SQL table”
3. When the screen below is displayed, click “SQL”.
4. Copy and paste (Ctrl+V) the SQL below to extract AusVELS data into the empty window and click Apply. If you cannot copy this query (ensure you select the Text tool in your PDF viewer to copy), you can download this query from this link.
This query below must be used, otherwise the required data will not be extracted.
IMPORTANT: Ensure you change the last numbers to the correct year and semester to extract, e.g. for 2021 semester 2, use ‘2021.2’.
SELECT st.FIRST_NAME, st.SURNAME,stvdi.SKEY AS STUDENTNUMBER,
RIGHT(STVDI.SCHOOL_YEAR, 2) AS GRADE, CASE RIGHT(STVDI.SCHOOL_YEAR, 2)
WHEN '00' THEN 'Prep' ELSE 'Year ' + RIGHT(STVDI.SCHOOL_YEAR, 2) END As
Class, LEFT(STVDI.YEAR_SEMESTER, 4) AS YEAR, RIGHT(YEAR_SEMESTER, 1) AS
SEMESTER, CASE WHEN stvdi.VDIMENSION = 'VCHPEPE' THEN stvdi.VDIMENSION +
'_VC' WHEN stvdi.VDIMENSION = 'VCEW' THEN stvdi.VDIMENSION + '_VC' WHEN
stvdi.VDIMENSION = 'VCESL' THEN stvdi.VDIMENSION + '_VC' WHEN
stvdi.VDIMENSION = 'VCERV' THEN stvdi.VDIMENSION + '_VC' WHEN
stvdi.VDIMENSION = 'VCMSP' THEN stvdi.VDIMENSION + '_VC' WHEN
stvdi.VDIMENSION = 'VCMMG' THEN stvdi.VDIMENSION + '_VC' WHEN
stvdi.VDIMENSION = 'VCMNA' THEN stvdi.VDIMENSION + '_VC' ELSE
stvdi.VDOMAIN + '_VC' END AS ASSESSMENTCODE, replace(stvdi.SCORE, '.0',
'') AS ProgPoint FROM stvdi left join st on st.stkey = stvdi.skey WHERE
(st.Status = 'ACTV' or st.Status = 'LVNG') and stvdi.SCORE <> 'NA' and
stvdi.year_semester = '2021.2'
5. When the Victorian Curriculum data is displayed, click the top left cell to select all rows and columns, then click Copy to Excel file.
6. Ignore this message below if it is displayed:
7. On the resulting “Select Excel spreadsheet file”, right-click in the file list window and select New, then select “Microsoft Excel Worksheet”.
8. Name this new worksheet using the semester and term you are extracting data for, e.g. “Victorian Curriculum 2017 semester 1”.
9. The Victorian Curriculum data will then be placed into the new Excel file you have just created.
10. Answer Yes to this prompt to replace the blank Excel file with the new Victorian Curriculum data.
11. This Excel file needs to be saved as a CSV file (which is the format that GradeXpert can import). In the newly created Victorian Curriculum worksheet, click Save As and select ‘CSV’ as the file type.
12. If you get a message saying “select file does not support workbooks that contain multiple sheets”, click OK to save anyway, as we only need the first sheet. Also answer Yes to the next prompt that asks, “keep the workbook in the csv format when saving”.
13. Save this file to a location that is accessible to you at the school, such as your U drive.
14. This CSV file can then be imported into GradeXpert by going into GradeXpert, clicking Import and browsing to this CSV file.