Create an Excel Gradebook with Percentage Grading (College Setup)
Create an Excel gradebook with percentage grading for a college course: Start Here habits, Names and Grades sheets, and a final percentage column you can defend at midterm.
To create excel gradebook percentage workflows that survive a real term, think in sheets, not in a single crowded grid. College courses need a roster you can re-paste, a grades matrix tied to the syllabus, and a place to write policies so TAs do not improvise.
This setup guide is for percentage grading. Leave class attendance and class schedules in other workbooks.
Compare ready-made options in the Excel gradebook template hub.
Key takeaway: Create Start Here + Names + Grades sheets first; wire percentage formulas second; only then add letters, weights, and conditional formatting.
Sheet Plan
- Start Here — course name, term, letter scale, weight legend, excused codes, “do not type over formulas.”
- Names — StudentID | Last | First | Section | Email (optional). This is the paste target for registrar/LMS exports.
- Grades — pulls or mirrors names; holds assignments, earned/possible, percentage, letter.
- Optional Gradebook summary — one-row-per-student dashboard for advising printouts.
College percentage gradebook setup
- Create the four sheet tabs and rename them clearly.
- On Start Here, type the letter scale and category weights (sum to 100%).
- On Names, paste the roster; remove blank rows; freeze the header.
- On Grades, link names with formulas (
=Names!B2) or paste values once if the roster is final. - Add assignment headers and a Possible row.
- Enter formulas for earned, possible, percentage, letter (see formula article).
- Add category weights if the syllabus requires them.
- Protect formula ranges; leave score cells editable.
- Save a dated template copy before the first real scores.
- Run the three-student stress test from the how-to guide.
Paste Discipline
LMS exports rearrange. Always:
- Match on Student ID when possible
- Sort Names the same way as Grades
- Paste scores as Values
- Spot-check three students against the LMS UI
Ole Miss–style campus notes still show the simple idea: a percentage column from total points divided by a course constant—or better, a live possible-points sum that updates when assignments appear.
Percentage Grading Defaults for College
- Store Percentage as a true percent value
- Put weights on Start Here, referenced by absolute cells
- Record late penalties in the score with a comment, not a hidden multiplier
- Keep a Raw % and Official % if you curve
Free Template vs Structured Product
Microsoft’s template gallery and campus free files can start you quickly. QA them against the selection checklist in the pillar. If you want a packaged Gradebook / Names / Grades layout with Start Here onboarding, the College Gradebook Percentage Excell workbook (PlanoNest — disclosure: we sell it) is offered as a one-time purchase with instant download—see the product page for pricing. Works in Excel, Google Sheets, and WPS for typical formulas.
Continue with how to make a gradebook in excel, excel gradebook percentages, and weighted gradebook excel.
Term Timeline
Week 0: Build sheets and weights.
Week 1: Paste roster; enter first quiz.
Week 4: Audit blanks vs zeros after drop/add.
Midterm: Export backup; publish advising printouts.
Finals: Lock Official %; archive workbook as COURSE-TERM-final.xlsx.
Collaboration Notes
If multiple TAs grade, give each a date-stamped import sheet rather than letting five people type into the same live matrix. One owner merges into Grades after QA. Shared Google Sheets need clear edit rights on score columns only.
Extra Implementation Notes
Keep a semester archive folder with dated copies after each major grade release. Name files with course code, term, and purpose so January-you can find December's official sheet. When you add assignments mid-term, extend Tables rather than inserting columns inside unprotected ranges that break neighboring SUM formulas. Teach TAs a two-minute paste ritual: staging sheet, values only, spot-check three IDs, then protect. If a student challenges a percentage, export the row to PDF with formula text visible rather than arguing from memory. Percentage gradebooks earn credibility when the audit trail is boring and complete. Revisit weights only when the syllabus changes; do not silently edit weights after scores exist without notifying the class. Finally, separate emotional curves from mechanical percentages: curve on a clearly labeled column so raw math remains inspectable.
Import Mapping Sheet
Add a fourth utility sheet called Import Map listing LMS column headers → Grades columns. When the LMS renames “Assignment 3” to a long rubric title, you update the map once instead of breaking every formula. This is especially helpful for multi-section courses that share a master template.
Protection and Backup Ritual
- Protect Grades formula columns with a password your co-instructor knows.
- Allow editing on score cells only.
- After each major paste, File → Save a Copy to
Archives/YYYY-MM-DD. - Once a term, export PDF of Start Here + weight panel for the department file.
Accessibility and Printing
Print student progress with large percentage and letter columns. Avoid light gray text. If you distribute individual progress, filter to one student or use a print view that hides classmates’ names—FERPA basics apply even in Excel.
When DIY setup is done but fragile, validate against the pillar checklist. For a ready Gradebook / Names / Grades layout, open the College Gradebook Percentage Excell product page for one-time-purchase details. Skill deep-dives: DIY how-to, percentages, formulas, weights.
Keep documentation boring on purpose: date every policy change, archive every official export, and refuse to edit live percentages during office hours. Create a duplicate sheet for what-if scenarios so the official gradebook remains stable. Train every TA on the blank-versus-zero rule in the first week, not after complaints arrive. Percentage gradebooks reward instructors who treat the spreadsheet like assessment infrastructure, not like a scratch pad that gets rebuilt each Sunday night under deadline pressure.
Keep documentation boring on purpose: date every policy change, archive every official export, and refuse to edit live percentages during office hours. Create a duplicate sheet for what-if scenarios so the official gradebook remains stable. Train every TA on the blank-versus-zero rule in the first week, not after complaints arrive. Percentage gradebooks reward instructors who treat the spreadsheet like assessment infrastructure, not like a scratch pad that gets rebuilt each Sunday night under deadline pressure.
Keep documentation boring on purpose: date every policy change, archive every official export, and refuse to edit live percentages during office hours. Create a duplicate sheet for what-if scenarios so the official gradebook remains stable. Train every TA on the blank-versus-zero rule in the first week, not after complaints arrive. Percentage gradebooks reward instructors who treat the spreadsheet like assessment infrastructure, not like a scratch pad that gets rebuilt each Sunday night under deadline pressure.
Keep documentation boring on purpose: date every policy change, archive every official export, and refuse to edit live percentages during office hours. Create a duplicate sheet for what-if scenarios so the official gradebook remains stable. Train every TA on the blank-versus-zero rule in the first week, not after complaints arrive. Percentage gradebooks reward instructors who treat the spreadsheet like assessment infrastructure, not like a scratch pad that gets rebuilt each Sunday night under deadline pressure.
Frequently Asked Questions
How do I create an Excel gradebook with percentages?
Build Names + Grades, enter possible points, compute earned/possible, format as percentage, then map letters.
How do I give a grade based on percentage in Excel?
Use IFS/IF on the percentage cell against your catalog cutoffs.
Can I start from a blank sheet every term?
Yes—or save a master template with formulas and clear scores only. Clearing is safer than rebuilding weights.
Disclosure: PlanoNest sells digital Excel, Google Sheets, and Notion templates. Links to our products go to the shop; we do not hard-code prices in this article.
