Designer Help Student Management Create and Save Results in Excel

Create and Save Results in Excel

An Excel file is used to upload data (eg student grades) into the student database. You can either create a new file in Excel or download the student database from WebCT and modify the file in Excel.

The top row of your Excel file must contain the headings of the columns. The User ID field must always be present since this ID uniquely identifies the student to be updated. Students whose User ID already exists in the database will have their information updated from the data in the uploaded file. If the student database contains columns which do not appear in the uploaded file, these columns will be left unmodified. Columns in the Excel file which do not exist in WebCT are added to the database.
 
Blank values in an uploaded file will overwrite non-blank values in the student database.
 
Save the spreadsheet in a format suitable for WebCT - either a comma separated (.csv) or tab-separated (.txt) format. The example given below describes saving the file as a .csv file. The best way to do this is to download the class list from the WebCT course. This will ensure that the UserID field is present and correct.
 
To Download the class list from WebCT -

• Select Manage Course link in the Designer Links
• Select Manage Students
• Select Download from the Options: Records pull down menu.
• Click Go.
• Select a separator (comma) for the fields in the Download file.

• Click the Download button to download the file to your computer.

Open this file in Excel and enter the results into column(s) in the spreadsheet.

Save the Excel File as a .csv file

• From the File menu, click on Save As.
• Enter a file name
• Select CSV (comma delimited) format from the list.
• Click Save