Weighted Gradebook
Free weighted gradebook for Excel. Enter scores for homework, quizzes, projects and exams; weighted totals, bands and class rank calculate automatically.
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.
Mock exam results
Enter marks out of the maximum. Percentages and change appear automatically.
| No. | Student name | Marks available | Target % | Mock 1 marks | Mock 2 marks | Mock 3 marks | Mock 1 % | Mock 2 % | Mock 3 % | Change first to latest | Gap to target | Follow-up |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example: Linh Nguyen | 80 | 0.7 | 44 | 52 | 58 | None | ||||||
| Example: Omar Haddad | 80 | 0.75 | 48 | 45 | Revision plan | |||||||
Sheet: Mock results · 30 rows
Free weighted gradebook for Excel. Enter scores for homework, quizzes, projects and exams; weighted totals, bands and class rank calculate automatically.
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.
Track mock exam results for a class or year group. Enter each student's marks for up to three mocks; the sheet works out percentages, the change from the first mock and whether they are on target.
Comments