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.
Student progress by term
Enter scores as percentages (for example 72%). Growth compares the latest term with Term 1.
| No. | Student name | Target % | Term 1 % | Term 2 % | Term 3 % | Average | Growth since Term 1 | Gap to target | Effort | Working at |
|---|---|---|---|---|---|---|---|---|---|---|
| Example: Hana Kim | 0.75 | 0.64 | 0.7 | 0.77 | Good | At expected | ||||
| Example: Diego Ruiz | 0.7 | 0.52 | 0.5 | Variable | Below expected | |||||
Sheet: Progress · 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.
A class record of student progress across the year. Enter each student's percentage score per term, with effort and a working-at level, and see growth and whether they are on track.
Comments