Importing+student+names+from+CASES

STEP 1: Exporting students from CASES21 to a spreadsheet
[|**cases-export-wendy-jeffery.swf**] (Open with Internet Explorer)
 * 1) Log on to the CASES machine in your school
 * 2) Download and complete the steps in the video tutorial below, kindly created by Wendy Jeffery of Wodonga Primary School.


 * 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**

**Scroll down to view screencast**
Now that you have exported your data to a spreadsheet,
 * 1) Highlight and copy the entire contents of the eleven columns of the spreadsheet you exported from CASES.
 * 2) Download this spreadsheet ([|convert-CASES-to-SharePoint-FINAL.xls)]
 * 3) Open the 'convert-CASES-to-SharePoint' spreadsheet in Microsoft Excel and make sure you are in the sheet called **'Paste your CASES data here'** (using tabs along the bottom).
 * 4) Paste your columns A-K over the first eleven columns in this spreadsheet.
 * 5) Now switch to the sheet called **'Data ready for SharePoint'** and you will see that your data has been converted into the correct format to be pasted into SharePoint.
 * 6) Now, **highlight the content of the eleven columns** in the new 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
 * 7) Go to the Student Results SharePoint Database, and click on **View all Site Content** at the top of the Quick Launch bar on the left
 * 8) Click on the **Student Information** list.
 * 9) Change the view to **'All Items'** using the orange drop-down box at the top-right of the list.
 * 10) In the **Actions** menu for the list, select **Edit in** **Datasheet** (NB: this only works on computers with Microsoft Office 2007 installed)
 * 11) 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.
 * 12) Press **Ctrl+V** to paste in the cells you copied earlier. All columns should now be filled with your data from CASES21

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.**

media type="custom" key="3787775"