Banner

Home


TALENT
Manuals
Tutorials
Videos
Resources
web access button
FAQs
Request Space


WebCT Student Orientation
Tutorials
FAQs
Check Browser
Help Guide
WebCT Login

 

Downloading & Exporting the Student Database (either scroll down through page or select from one of the following choices)
About Downloading & Exporting the Database
Downloading Student Database
Adding New Columns via Excel
Importing Database

Download the Text Based Version

Laulima Based Tutorials
WebCT Based Tutorials

> Exporting Existing WebCT Quizzes/Surveys & Importing into Laulima Tests & Quizzes Tool

Stay tuned for additional tutorials!

> Adding a Syllabus
> Adding a new course section (organizer page)
> Adding a single page (single page link to .pdf, .html, .doc, etc.)
> Adding a URL (link to an outside resource site)
> Adding the Student Presentation Tool
> Adding the Assignment Tool
> Adding a TA
(teaching assistant)
> Adding a co-designer
> Adding Guest Accounts
> Adding a PowerPoint presentation (for Windows)
> Adding a PowerPoint presentation (for Macintosh)
> Adding a PowerPoint for Downloading

> Narrating PowerPoint & Processing in Impatica
> Adding a Quiz or Survey

> Importing and Uploading a Quiz via Respondus (for Windows)
> Importing and Uploading Games/Self-Test via StudyMate (for Windows)
> Importing and Uploading a Multiple Choice Quiz via MakeQuiz (for Macintosh)
> Manual Grading of a Quiz
> Assessment Strategies
> Viewing Quiz/Survey Statistics
> Adding a Score (grade) column
> Adding a Final Score (grade) column
> Downloading and Importing e-packs
> Creating and Restoring a Course Backup
> Fast Uploading of multiple Files with WebDAV
> Exporting/Importing the Student Database
> Exporting Final Grades to Banner
> Word 2000 & 2003
> Private (group) Discussions

About Downloading & Importing the Student Database:
Faculty may find a need to import/export to the Student Database when assignments are taking place outside of WebCT, used complicated formulas that are better done within a spreadsheet program or already have an existing gradebook in Excel.

NOTE: prior to working with the Student Database ALWAYS create a backup (Control Panel - Manage Course, select "Create Backup")!

Downloading Student Database:
It is best to export the existing course student database first, then build upon that structure. To download log into the Course and select "Control Panel".

Graphic Image

Select "Manage Course".

Graphic Image

Select "Manage Students".

Graphic Image

Under the header for "Options: Records", use the pull down menu and select "Download" and click "Go".

Graphic Image

Choose for the separator"Tab" and click "Download".

Graphic Image

Select to "Save to disk", and choose a location on the desktop to save the file.

Graphic Image

Adding new Columns via Excel:
Open a spreadsheet program, in this case Excel, go to "File" and choose "Open".

Graphic Image

Locate the downloaded file and select to open. Proceed through the wizard, confirming "Delimited" is selected and click "Next".

Graphic Image

Confirm "Tab" is selected and click "Next".

Graphic Image

Click "Finish".

Graphic Image

Proceed to add additional columns and scores for students (if needed). When done, go to File, select "Save" to overwrite existing file.

Graphic Image

Importing Database:
Log back in the Course, go to "Control Panel", "Manage Course" and select "Add/import students".

Graphic Image

Under the header for "Import From File" select the "Browse" button.

Graphic Image

To upload the file, click "Browse" again.

Graphic Image

Locate the file on the desktop, click once to select, click "Open" and select "Upload".

Graphic Image

Select "Tab" for the Separator and click "Import".

Graphic Image

For each new column added WebCT will ask what to do with it, select "Create New" from the pull down menu and click "Continue". Proceed to do this for each newly added column.

Graphic Image

WebCT confirms columns in the imported file with those it will create in the Student Database, click "Continue".

Graphic Image

For all new columns choose the column type, use the pull down menu and choose "Numeric", click "Continue" when done.

Graphic Image

The column(s) have been successfully imported.

Graphic Image

Return to Main Tutorial Menu

Site managed by Linda Mcconnell
University of Hawaii, Distributed Learning & User Servers
Last Update:10/9/04