...
| Page Properties | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
If you have a unique grading system, have class assignments in external sites, or just prefer a different grade editing environment, you may wish to download your Grade Center and work on it in Excel. These instructions will give you the information that you need to do so.
Downloading your
...
To download your Grade Center, first go to the Full Grade Center in your course on Scholar.
From Work Offline, choose Download.
You’ll be brought to a screen where you can choose some parameters for the download. First, choose what data you’d like to downloaded:
Next, you’ll need to choose information about the file itself. Change Delimiter Type to “Comma”. If you want to include columns that you’ve hidden from your view in the Grade Center, change Include Hidden Information to “Yes”. Otherwise, leave it as “no”.
Choose My Computer for the Download Location. You do not have to click the browse button when you do this.
Click Submit, and you’ll be taken to a page with a download button. Click the button to download the file.
Editing your Grade Center
...
Gradebook
In the course, use the control panel to access the full Gradebook.
On the upper right there are a series of icons, right below the Student Preview button. Select the Download button.
On the sidebar that comes up, you can choose a number of settings:
- you will be able to download either the full grade center or a specific column or columns.
- You can also select to download the Grade History, which provides the history of changes made to individual grades.
- You will also be able to select the file type of the download; select a .csv file for the file type, as there are problems importing the tab delimited (.xls) format into newer versions of Excel.
When you have chosen all your settings, click 'Download' to download the file to your computer.
Editing your Gradebook
Once you’ve downloaded your Gradebook, it’s time to edit it.
Do not change the column headers, or the file won’t import correctly.
You can also add columns at the end and they’ll be added to the Grade CenterGradebook. However, they will be added as Text columns and not included in any calculations. You’ll have to go in and change the column settings if you want them.
When you’re done with your edits, save the file. In the Save as Type: dropdown, choose CSV or Comma Separated Values. You may get a couple of popups asking if you’re sure; choose yes.
Uploading your Edited File
Once you’ve saved your edited file, you can upload it to Scholar. Return to your Grade Center and choose Upload from the Work Offline menu.
Click Browse My Computer, and find the file.
Click Submit, and you’ll be taken to a page where you can see how the grades will update.
Click submit again, and the new columns will be created.
If you want to use any columns that you created in Excel in calculations within the Grade Center, you’ll need to convert them to a Score or Percentage column. To do that, click the dropdown at the top of the column and choose Edit Column Information.
Change Primary Display to either Score or Percentage.
Then enter the number of points possible.
Click Submit, and your new column will now be included in the Grade Center calculations.
You can either drag and drop the file, or use "Upload Local File" to upload the file onto your computer. Note that only .csv or .xls files can be uploaded for this process. but we recommend that you use .csv files, as there are current issues with .xls file uploading.
Once the file has loaded, it will appear in the sidebar, along with a summary of the changes that will be made by uploading this file onto your Gradebook. You may select or deselect any changes you wish. Once your settings are complete, click Upload and the file will be uploaded into your gradebook with all selected changes overwritten.
