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. If the left column is not visible, open it by clicking the 3-line menu at the upper left.

click-on-grades

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

Choose Export

  • In the top row, click on Export.
  • In the next row, click on Plain Text File (for a .csv spreadsheet that any program can open).
  • A page will open with a lot of options on it. Ignore them, skip to the bottom and click Export.
  • Quickly, the small text file containing your gradebook will download. Your browser will probably display its name, and it will appear wherever your browser puts downloads.

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.

The first 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."