MyGateway System Help
Upload Grade Book Entries
MyGateway allows instructors to modify a downloaded class grade book (edit grade or create a new item) in Excel or another program and then upload the modified entries or new item back into the Mygateway course site grade book. To modify a grade book, first download a copy of the grade book. You can download the gradebook as a comma-delimited or tab-delimited file. Open the downloaded comma-delimited or tab-delimited file in Excel (or another program). If you are a Windows user, simply clicking on the downloaded .csv or .xls file should open it in Excel. If you use the "File Open" option in Excel or another spreadsheet program you will have to change the file type you are look for to "Comma-delimited (.csv) in order to "see" the file in the "Open file" dialog window.
Once you have the file open, you can modify grades, or insert a new grade
book item (column). Do not add students. Registered students
are automatically added to class sites via daily enrollment scripts. If
you need to add a non-registered student to your class site, please use
the "Enroll Users" link from the
Control Panel. When you are finished modifying grades, save the file--be
sure to save the file as a comma-delimited (.csv) file. If your file type is tab-delimited the default is already set to .xls. Return to the
spreadsheet view ("Gradebook" link from the control panel) for
your class, and click the "
Upload
Grades" link located at the top of the spreadsheet.
You will be prompted to browse for the modified file. Select the file and click "Submit."
Under item 1 of the next screen you will need to select the column of the revised file that you wish to upload. Under item 2, select an existing column to replace, or, if you are creating a new column, select: "Create New Gradebook Item" at the end of the list. Click submit.
- If you are replacing an existing item, you'll be taken to a screen
that allows you to choose which students to include in the upload (there
is a "select all" option). You can also review existing scores,
as well as modified scores. When you are satisfied with your selection,
click "Submit," and the modified scores will be uploaded into
your MyGateway grade book.
- If you are creating a new grade book item, you will be taken to the "Add/Modify Item" screen to create the item's settings. Click "Submit" when completed, and you will be taken to the screen that allows you to choose which students' scores will be included (see #1 above).
This process will need to be repeated for each grade book column you wish to add or modify.