Export a Grade Book to Excel
You can export a grade book to an Excel spreadsheet and download it to your desktop computer for editing, printing, or archiving. The Excel spreadsheet includes both the grade sheet with student scores and the sheet containing detailed student information.
You can choose to export the entire grade book, or just the current, filtered view of the grade sheet.
To export a grade book, follow these steps:
- From the Catalyst account page, click the name of the grade book you want to export. You will move to the main view of the grade book.
- Click Export or Import, which is at the top center of the grade sheet. The drop-down menu will open.
- Select Export and then choose either Entire grade book or Current view of grade sheet.
Tip: If you do not wish to include dropped students in the export, deselect them from the Students menu, and then export the current view of the grade sheet.
- Depending on your browser settings, a “File download” dialog box might appear prompting you to open or save the file. Click Open to view the grade book contents, or click Save to save the file to your desktop computer.
Tip: When the Excel spreadsheet is first opened, the score sheet will display by default. To navigate between the score sheet and the student information sheet, use the tabs located at the bottom of the Excel spreadsheet.
Learning from feedback
As well as marking the work, your tutor provides comments and advice on the content of your assignment, and on your skills in communicating your ideas.
Marking assignments is how we assess progress and ensure that students process the module material and learn. It's easy to just look at the grade and put the assignment away but the feedback I give is individual to each student. It's important to address misunderstandings so they aren't repeated in other assignments or in the exam.
When you get your assignment back, you’ll no doubt look at the grade first and then look at your tutor’s comments. Try to be objective in how you react and use the suggestions below to build on your skills.
- Read carefully your tutor’s comments on the assignment and the PT3 form.
- Mark anything that you don’t understand and want to ask your tutor about.
- Take note of issues to do with your structure and presentation.
- Use a TMA review form to note any suggestions for future improvement.
- Keep your feedback in one place and occasionally return to it to identify themes that keep coming up.
- Speak to your tutor, or review material on this site for ideas on how to improve.
Take twenty minutes to review your assignment. If you want to check how you are doing on the module so far, you can use the assessment calculator. You can also find out about general assessment matters, including assignments and examinations.
The assignments listed below are from the discontinued 'Openings' programme of modules, which are designed as introductions to studying at university level. Tutors tailor any feedback according to the needs of each particular student, however, the comments here are designed to coach students in general assignment writing skills. To get a sense of how OU tutors give feedback on such modules, look at the tutors’ comments (on the right hand side of the later pages).