About this course credit tracker spreadsheet template
This Course Credit Tracker helps university students and academic advisors monitor degree progress across four integrated sheets. The Course Register logs every course with term, category, credits, grade, quality points, and risk status, while the Academic Action Queue surfaces courses that need immediate attention with suggested actions.
The Credit Dashboard provides an at-a-glance summary of credits earned, course counts, and average grade points broken down by Core, Major, and Elective categories. A dedicated Lists & Guide sheet defines the credit rules, GPA formulas, and risk thresholds that drive the workbook, making the logic transparent and easy to audit.
Every cell, label, and formula is fully editable in WPS Office, Microsoft Excel, and Google Sheets. Replace the sample course data with your own programme requirements, adjust the credit thresholds, and start tracking your academic journey immediately.
4 linked sheets
Course Register, Action Queue, Dashboard, and Rules Guide work together for complete credit tracking.
GPA and risk monitoring
Automatic quality points, GPA calculation, and risk flags help you stay on top of academic standing.
Clean dashboard layout
At-a-glance credit summaries by category with course counts and average grade points.
Standard XLSX format
Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.