Importing+student+information+from+CASES+-+Secondary+Version

STEP 1: Exporting students from CASES21

 * 1) Log on to the CASES machine in your school
 * 2) Download and complete the steps in [|this video tutorial], kindly created by Wendy Jeffery of Wodonga Primary School (Open with Internet Explorer)**PLEASE NOTE**: In the video, Wendy exports the columns STKEY, SURNAME, FIRST_NAME and CAMPUS, however for the purpose of this database, we'd like you to export the following columns: **STKEY, SURNAME, FIRST_NAME, HOME_GROUP, SCHOOL_YEAR, GENDER, ENG_SPEAK, KOORIE, DISABILITY, MEDICAL_ALERT, BIRTHDATE**
 * 3) Highlight and copy the entire contents of the eleven columns of the spreadsheet you exported from CASES.
 * 4) Download the [|SRD Conversion spreadsheet - Secondary version] (developed by Luke Cohrs)
 * 5) Open the spreadsheet in Microsoft Excel and make sure you are in the sheet called '**CASES-Paste'** (using tabs along the bottom).
 * 6) Paste your columns A-K over the first eleven columns in this conversion spreadsheet

STEP 2: Export timetable data from First Class or other timetabling program

 * 1) Export the following columns: **CASES ID**, **BLOCK A**, **BLOCK B**, **BLOCK C**, **BLOCK D**, **BLOCK E**, **BLOCK F** into a blank spreadsheet
 * 2) Highlight and copy all the cells in the seven columns of the spreadsheet
 * 3) Go back to the S**RD Conversion spreadsheet-Secondary version** again and go to the tab called **First Class.**
 * 4) Paste in your seven columns from your First Class export over columns A-G in this sheet

Now that you have exported your data to spreadsheets...

 * 1) Now switch to the sheet called '**Student Info-SharePoint'** and you will see that your data has been converted into the correct format to be pasted into SharePoint.
 * 2) Highlight the **L column** in this sheet (Medical Alerts) and **filter it by records displaying 'Y'**
 * 3) For all **'Y'** records (i.e. students with medical issues), enter **brief details in the M column.**
 * 4) **REMEMBER to undo the filter on the L column before continuing.**
 * 5) Now, **highlight the content of the 19 columns** in the '**Student Info-SharePoint' sheet**- __excluding__ the heading row (Be careful to ONLY highlight cells with content as any empty rows will create blank entries in your database) then press **Ctrl+C** to copy the contents
 * 6) Go to the SRD Template in your SharePoint site, and click on **View all Site Content** at the top of the Quick Launch bar on the left
 * 7) Click on the **Student Information** list.
 * 8) Change the view to **'All Items'** using the orange drop-down box at the top-right of the list.
 * 9) In the **Actions** menu for the list, select **Edit in** **Datasheet** (NB: this only works on computers with Microsoft Office 2007 installed)
 * 10) You will see one row filled with ****. This will make sure that the database defaults to this name, instead of the poor student who has a surname starting with 'A' being the one to have their results splashed over the page as the default! Ignore this row and click on the next row in the **Surname** column.
 * 11) Click on the cell in the second row, under the column of CASES ID (Ignore the ID column) and press **Ctrl+V** to paste in the cells you copied earlier. All columns should now be filled with your data from CASES21 and FIRST CLASS

IMPORTANT NOTE:

 * Do NOT overwrite student names. The database stores information based on the ID numbers in this list, so if you changed the name Student A to Student B in the Student Information list, all of student A's results will be now be 'owned' by Student B.**

Download the [|SRD Conversion Spreadsheet] (developed by Luke Cohrs, TSSP, Mildura)