About This Site
On this site, instructors will learn how to use this Microsoft Excel to record and manage student grades.
Topics will include:
- revised Penn State privacy policy against posting grades by student ID.
- importing and formatting an eLion class roster
- setting up columns to enter assignment scores
- formulas and functions for calculating grades
- exporting quiz grades from ANGEL
- techniques for diagnosing course problem spots based on reported grades
Looking for Sample Files?
The Sample Files page contains example data and spreadsheet templates for fictitious students.
Best viewed in Internet Explorer, Firefox, Mozilla, Safari, Opera or Netscape Version 7+.
© 1998-2005 The Pennsylvania State University. All rights reserved.
This site includes
material originally created by Roxanne Toto and others.
Alternative Media - Nondiscrimination Statement
This site maintained by Teaching and Learning with Technology, a unit of Information Technology Services.
For assistance please write to the Webmaster (ejp10@psu.edu)
Last Update:
May 8, 2006