How to Import Scores from Moodle to PowerTeacher

1. Click Gradebook Setup from your course administration menu

2. Click the Gradebook setup dropdown menu and select Excel spreadsheet from below the Export heading

3. Select a class period to export

4. Scroll to the bottom of the page and click Select all/None

5. Now check the box only for the assignment you want to export

7. Click Download

8. Open the downloaded Excel file

9. Edit the score sheet accordingly:

• Delete all columns except for ID number and assignment scores
• Replace all dashes with a 0 value

10. Click File > Save as and change the Save as type: to CSV (Comma delimited) (*.csv), then click Save. Save the file in place you can easily find it, like your Desktop.

11. Click Yes when prompted

12. Now, watch these steps for importing the .csv file into PowerTeacher Pro

• Video should start at 0:59
• Select points, not percent