How to Download Your Gradebook

How to Download Your Gradebook

Be sure to download your gradebook when class is over, so you can keep a copy for your records.

Here's how to download your Newsroom 101 gradebook. It's not complicated.

Open your gradebook. Open your section of Newsroom 101. From the front page, in the left column, select Course Administration / Grades, to open the gradebook. 



You'll see a gradebook labeled Grader Report. This view allows the teacher to see all student grades. 

Choose Export. In the top left is a drowdown menu. Open it and slide down to Export / Excel Spreadsheet. (If you can't open an Excel file, choose Plain Text File instead).

export gradebook

A page will open with a lot of options on it. Ignore them and click SUBMIT.

A new page will show a preview of the first 10 rows of your download. Click the DOWNLOAD button at the top of the page. OK this in the popup. Then look for the grades file in the downloads directory on your personal computer.

Now You Have It. You can open this file in any spreadsheet. It is quite wide, but it contains all your grades. If you expand the columns, you will be able to read the name of each quiz in the top row.

Remember that the first column gives the student's course average, which will not be particularly useful because the quizzes require 80 percent or higher.

The second column is a count of the number of quizzes each student completed. This is the most useful number in the gradebook. It tells you how much of Newsroom 101 a student completed. You can also scroll to the right to see exactly which quizzes each student completed.

How to Freeze the Name Column in Excel. This link opens to Microsoft's page on how to freeze the first column in Excel, so that, when you scroll to the right, you can still see student names at the start of each row. To use this function, you will click the "Freeze Pane" icon in Excel.

Keep a file copy of your Newsroom 101 gradebook just as do with other grades.


Note: We use the spelling "gradebook" because it is spelled that way in the software that delivers Newsroom 101. AP style prefers it as two words, "grade book."