Notes from “Electronic GPA Calculator”

Electronic GPA Calculator: Fast and Accurate GPAs

Presented at the 2010 NAFSA Region VI Conference

by Kristen (Leciejewski) Summers, International Admissions Counselor, Kent State University
and Dave Kokandy, Graduate Intern, Kent State University
moderated by David DiMaria, Director, International Student Recruitment, Admissions and Advising, Kent State University

View our presentation:
Electronic GPA Calculator on Prezi

Download the GPA Calculator:
The calculator is available below in Excel 2007 format or in template format. I strongly recommend using the Template format. Saving it as a template ensures that you will never accidentally save a completed form over the blank spreadsheet. Saving the template in the template folder (on Vista, usually  C:Users<your name>AppDataRoamingMicrosoftTemplates) will allow you the choice to create a new document based on the template any time you start a new document.

For information on Excel templates, please see Create and use an Excel template.  

• .xlsx format (requires Excel 2007)
• Excel 2007 Template (.xltx format)

The following versions of the calculator have been saved in a format that should be compatible with Excel 97-2003, but has not received the same level of testing in the office.

• .xls format (compatible with ‘97-2003)
• Excel 97-2003 Template (.xlt format)

Download the Handout

Download the Examples:

China-TUC

• Transcript
• Calculated

India-US Transfer

• India Transcript
• India Calculated
• US Transcript
• US Calculated

China HS Example

• Transcript
• Calculated

Resources for transcript evaluation:
WES Tools – WES provides free grading scales, country profiles, and additional information to assist credential evaluators in converting rough grades into equivalent US grades.
AACRAO Edge – Edge is a paid, subscription service that provides detailed information on diplomas and degrees, educational ladders, and many other resources.

Excel tutorials and information:
Excel Tutorial – A basic introduction to Microsoft Excel and its functions.
Microsoft’s Office Website – Microsoft provides plenty of free information about Excel and its formulas.
Excel Formulas – This Pearson website explains some advanced Excel functions.
Mr. Excel’s Podcast – This free video podcast details one Excel trick per episode. Archives are available.
Check also your institution’s library for print and electronic materials. OhioLink lists excellent print materials, including many available instantly online.