 "CLICKERS" - exporting PRS gradebook to webct
To export the PRS gradebook
- Open the PRS software and click the Gradebooks tab.
- Select the gradebook you wish to export. Once highlighted, click Export Gradebook.
- From the choices for Export Format, select WebCT (with Net ID). Click OK.
- Type a file name with the .txt file type (name.txt). Click Select.
- Click OK when you see the Export Gradebook confirmation message.
Prepare the file for WebCT
- In Excel, from the File menu, select Open.
- For the Files of type, select All Files (*.*).
- Look in My Documents\PRS\Exports to find the file you just exported (name.txt). Click OK.
- Use the Text Import Wizard to specify
- Original data type - Delimited. Click Next.
- Delimiters - check only Comma. Click Next.
- Select the Student ID column to highlight it. Column data format - Text.
- Click Finish.
- Delete Name and First columns by right-clicking the letter of each column and selecting Delete.
- From the File menu, select Save. When you see the message that features are not compatible, click Yes.
Upload to WebCT
- Logon to WebCT and access your course.
- Click the Control Panel | Manage Course | Manage Students.
- Under Options: Records select Import student data. Click Go.
- Browse to your name.txt file, and upload the file into MyFiles. Click Add selected.
- For Separator, select Tab. Click Import.
- You should see Import Confirmation messages regarding your columns. For each column you want created, select Create New and click Continue. For any column you don't need, select Ignore and click Continue.
- Below the box with the Import Confirmation: Field Names Resolved select Continue.
- For the Import Confirmation: Final Confirmation page, if the Student ID field does not exist, make it Alphanumeric and select the appropriate type for your other columns.
- Once you have reviewed the updates and made a note of any field errors, click Continue. Your gradebook will now show with the updated columns.
|
