Memorandum to Schools 113/2008
28 November 2008
On Demand Testing - Importing Students from CASES
The new VMware installation for the VCAA On Demand Testing application was rolled out to all government schools as part of the CASES rollout.
On Demand School users and technicians please note: the Synchronise from CASES button is no long functioning and should not be used. If you click on this button then all the students will be deleted from the On Demand database and will require VCAA remote access to restore student details.
This is because the On Demand Testing application is now a VMware and is not linked to the CASES server.
A patch will be released early next year to either fix or deactivate the Synchronise from CASES button.
All schools using the VMware version of On Demand must either enter student details manually by data entry or Import the student details into On Demand via .csv file and the Import Students button.
All Government Technicians have access to the CASES upgrade DVD containing the On Demand VMware, installation and restore data instructions and a VBS file which extracts the data in the correct format (.csv) from the CASES database.
This file is then saved in an appropriate place on the PC hard drive or USB. Technicians and On Demand Administrators can then log into the On Demand School Server Administration System link and follow the menu options Student Tracking → School → Search.
Highlight the school (your school name) and select the VIEW option. Click on Import Students and Browse to the saved .csv file click on OPEN then IMPORT.
If entering an individual student by data entry, Student Tracking →Student→. New.
Enter the students details into the appropriate fields and click on Apply
Importing Student from CASES
A Student Details data file can be created as a 13 column Excel file with the following data in columns.
|
Field |
Name of field |
Information |
Mandatory |
|---|---|---|---|
|
1 A |
Student Code |
CASES student code eg: SM0001 |
Yes |
|
2 B |
First Name |
Students first name |
Yes |
|
3 C |
Middle Name |
Can be left blank but column must stay. |
No |
|
4 D |
Surname |
Student’s surname |
Yes |
|
5 E |
Gender |
Student’s gender |
Yes |
|
6 F |
Date of Birth |
Student’s date of birth |
Yes |
|
7 G |
LBOTE |
Y or 1 =True, N or 0 = false |
Yes |
|
8 H |
ATSI |
Y or 1 =True, N or 0 = false |
Yes |
|
9 I |
Disability |
Y or 1 =True, N or 0 = false |
Yes |
|
10 J |
EMA |
Y or 1 =True, N or 0 = false |
Yes |
|
11 K |
ESL |
Y or 1 =True, N or 0 = false |
Yes |
|
12 L |
Home Group |
Can be left blank but column must stay. |
Yes |
|
13 M |
Year level |
Year level |
Yes |
Then save as a comma delimited (.csv) file see below, and import the file. (Note: the file should not contain field heading)
Attached is a copy or instructions for importing student details from CASES into the On Demand Testing application:
- Import Students from CASES (DOC - 872KB)
Contact Details
Any queries regarding VCAA Assessment Online On Demand Testing should be directed to the Administrative Support Unit on 1800 827 721 or 9651 4482.
Please leave a message on our Voice Mail service if we are unable to answer your call immediately. Alternatively Fax enquiries to 9651 4551 or E-mail to vcaa.ondemand.support@edumail.vic.gov.au
