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 Examples:
China HS Example
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.
I can’t thank you enough. I’m not a big Excel fan but this will patch up what I need to prneset until I get through some MATLAB code or R. Thanks a ton.