ANGEL Help

eGrade Work Around, ANGEL 7.2

Upgrade > eGrade Work Around, ANGEL 7.2

eGrade Work Around, ANGEL 7.2

In order to submit your grades to the Registrar’s Office, you will need to prepare a spreadsheet in the format specified by the Registrar, and then insert the grades from your ANGEL gradebook into that spreadsheet.  This will involve downloading the class list from the Registrar, delete several columns of data and adding two new columns, downloading the gradbook from ANGEL, and copying the final grade information into the Registrar specified format spreadsheet. Presented below are the steps that you will need to follow.

  1. Go to the Office of the Registrar page at http://www.reg.msu.edu and click on the “Instructor Systems Menu” (located in the left-hand column, about two-thirds of the way down under the “Faculty/Staff” heading.
  1. Log in to the Instructor Systems.
  1. Download your Instructor System Class List
    1. Accept the default values of arranged by Name
    2. The file will be in .csv format, so that it can be opened by Excel or any comparable spreadsheet program.
  1. Open the file in Microsoft Excel or comparable spreadsheet program (make sure that you save it).  It will have the same format as the example below, except that there will not be any entries in the “Grade” column (column P).

classlist

  1. Verify that the class list is arranged by student last name, ascending (A-Z), otherwise sort the list so that it is arranged by student last name.
  1. You will need to delete all but the following columns – Term, Subj_Code, Crse_Code, Sctn_Code, PID, and Grade.
  1. A suggested approach is to first delete columns E (Sctn_Id_Code), F (Course_Title), & G (Instructor_Name), and the delete the “new” columns F (Student_Name), G (MSUNet_ID), H (Honor), I (Student_Level), J (Class_Code), K (Primary_Major), L (Credit). The net effect is that the “Grade” column will become column F.
  1. You will need to create two columns (detailed in steps 9 & 10). When you are finished the spreadsheet should look like the figure below:

gradebook

  1. Create a new Column G labeled as “Reason” and make sure that the column is formatted as text with a length of 3. (In Excel, highlight the column, select Format, then Cells, then Text.)  In this column you will need to specify whether the student completed the class if they are assigned a 0.0 grade.  The valid options are “YES”, “NO”, and “NR”.
  1. Create a new Column H labeled as “Date” and make sure that the column is formatted as text.  This column is used to specify the date of last attendance if the student did not complete the class.  The date information must be entered in “mm/dd/yy” format.
  1. You have now created the basic grade reporting form needed to upload the grades to the Registrar’s Office.  The next step is to obtain the grades from your ANGEL gradebook and integrated the final grades into this spreadsheet.
  1. Export ANGEL Gradebook in comma separated format:
    1. Click Manage
    2. Click Gradebook
    3. Click Export Grades
    4. Select Comma Separated
    5. Click on Export
  1. Open the gradebook.csv file that you just downloaded.
  1. Find and copy the column containing the final course grade.

image1

  1. Next, go to the file that you created to report the grades to the Registrar’s Office. Highlight the Grade column of that spreadsheet, and paste the column from the ANGEL gradebook.

image2

  1. Make sure that you provide the required information for 0.0 grades (Reason and Date student last attended the class).  Also make sure that all the fields in spreadsheet are in text format.
  2. Save the file, and upload via Submit final grades to the Office of the Registrar at http://www.reg.msu.edu.
    1. For more information on Registrar’s Office Upload Specifications, please visit http://www.reg.msu.edu/Forms/Instructor/specifications.asp

 

Top of page
Section toc
ANGEL Online Documentation

 

© 2007 Michigan State University Board of Trustees .
MSU is an affirmative-action, equal-opportunity employer. East Lansing MI 48824