Exam Results Analysis
Free Excel exam results analysis. Enter marks across subjects and see each student's average, passes, rank and the class average, highest and lowest.
KiwiBee uses optional Google Analytics, Google Ads, and Meta Pixel cookies to understand adult visitors, measure completed sign-ups, and improve campaigns. Essential cookies always stay on. OpenAI’s ChatGPT Ads Pixel also measures page views and completed enquiries after advertising consent, and may use hashed contact details for matching. Privacy policy
A preview of the first rows. The file adds drop-down lists, formulas that fill in by themselves and room for more rows.
Weighted gradebook
Weights: Homework 20%, Quizzes 20%, Project 20%, Midterm 15%, Final exam 25%. Enter every score out of 100. Band: 5 = 90+, 4 = 75-89, 3 = 60-74, 2 = 50-59, 1 = below 50.
| No. | Student name | Homework (20%) | Quizzes (20%) | Project (20%) | Midterm (15%) | Final exam (25%) | Weighted total | Band (1-5) | Class rank |
|---|---|---|---|---|---|---|---|---|---|
| Example: Mai Tran | 92 | 85 | 88 | 79 | 84 | ||||
Sheet: Gradebook · 40 rows
Free Excel exam results analysis. Enter marks across subjects and see each student's average, passes, rank and the class average, highest and lowest.
Free Excel test question analysis. Enter right or wrong for each question to see scores, percentages and which questions were hardest for the class.
Free Excel formative assessment tracker. Record quick checks as not yet, developing, secure or exceeding and see who is on track at a glance.
Free Excel rubric scoring sheet. Score each student on up to six criteria from 1 to 4, with totals and percentages, plus a sheet to write your rubric.
A weighted gradebook for one class and subject. Enter each student's scores out of 100 and the sheet works out the weighted total, a performance band and the class rank.
Comments