Skip to content
Academic Calendar cover: a sample sheet with milestones, average progress and exams and a bar chart, beside the Dashboard, Terms and Grades tabs

Academic Calendar

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The academic calendar suits students and course leaders who plan a term with several modules at once. The Terms tab is a gantt timeline of 18 weeks from mid January, with milestones for deadlines, exams, readings and breaks, each marked with its course and percentage done. The Grades tab lists each graded piece with its weight and score, and the dashboard shows milestones and average progress by course, along with the grade so far.

Enter the real term dates on the first milestone, then add each deadline as the syllabus is published. Update the Done percentage every week so the bars show what is finished. When a grade comes back, type its score as a percentage on the Grades tab, and check that each course's weights add up to 100 percent before you rely on the grade so far.

Useful for

  • Mapping deadlines for four modules across one term
  • Working out the score needed on a final exam
  • Showing a study group the milestones for the spring term

What's included

  • 4 tabs: Dashboard, Terms, Grades, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Terms: a Gantt timeline
  • Grades: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Terms tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How is the grade so far calculated?

Each graded piece's weight is multiplied by its score, and the total is divided by the weight graded so far. Only pieces with a score count, so the figure is your average for work already marked, not your final grade.

How do I work out what I need on the final exam?

Suppose graded work adds 48 percentage points from 60 percent of the course. To finish at 70, you need 22 more points from the last 40 percent, which means a score of 55 percent on the final.

Can the term timeline hold projects instead of courses?

Yes. Replace the course names with projects, placements or training blocks. The timeline reads only the start, end and progress columns, so any milestone with dates shows as a bar.

  • #calendar
  • #academic-calendar-2027
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More calendar templates

See all 510

Also in Business operations

All business operations templates
Get this template

Preparing your template…