Manage your Grades Electronically with Excel Skip Main Menu

Penn State Privacy Policy for Grades

Grade Record Encryption

Instructors are responsible for ensuring that files containing student grades are secured appropriately (preferably on a location with a password). Encrypting the data, for example, is one way to help protect student records and to mitigate the risk of exposure. Check with your local IT staff to learn more about encryption and other security measures that can be applied.

More policy information can be found at Policy AD 23 Use of Institutional Data and Policy AD 11 Confidentiality of Student Records. The ITS Security Operations and Services contains additional information.

Posting Student ID's

In the past Penn State Policy allowed instructors to post grades by the last four digits of a student ID number. As of January 2005, you can no longer post a list of grades by student ID number.

Under interpretations of Family Educational Rights and Privacy Act of 1974 (FERPA) regulations, the PSU ID cannot be used to display a student's scores or grades publicly. This also precludes posting grades using only the last four digits of the PSU ID.

— From Penn State Policy A.D. 19

Grades must be reported or sent to each student individually. See Policy A.D. 19 use of the Penn State Identification Number for further details.

Using ANGEL To Report and Publish Grades to eLion

See the ANGEL Help and Information Guide for more details on using ANGEL to Import Grades from a comma delimited (.csv) file and Publish Grades them to eLion.

Note: All Gradebook documentation is found in the ANGEL Help and Information Guide under Courses >> Manage >> Gradebook in the folder based navigation.

Create a Comma Delimited File in Excel

To create a comma delimited file, open your Excel file then do the following.

Windows (Office 2007)

  1. Open the file.
  2. Click the Office Button (upper left), then select Save As.
  3. Scroll to Other Formats and select select CSV (Comma delimited) (*.csv) from the Save as type format menu.

Mac and Windows (pre Office 2003)

  1. Open the file.
  2. Select File >> Save As and select the comma delimited file option in the format menu.

 

Top of Page

© 1998-2010. The Pennsylvania State University.
Contact the Webmaster (ejp10@psu.edu) for questions or comments. Material based on content prepared by Roxanne Toto and others.

Last Update: January 11, 2010