Skip to content
Homework Planner cover: a sample sheet with open tasks, due this week and finished and a bar chart, beside the Dashboard, Homework and Week plan tabs

Homework Planner

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

The Homework Planner suits students in middle and high school who want one place for every task. The Homework tab lists each assignment with its subject, due date, estimated minutes and status, with a days-left countdown until it is marked Done. The Week plan grid lets you block the minutes you intend to spend on each subject from Monday to Sunday, with totals for each day and subject. The Dashboard shows open tasks, what is due this week and the total estimated minutes.

Enter tasks as soon as they are set, and give each one an honest minute estimate. Start the week with the Week plan grid, filling in one subject at a time rather than trying to plan every hour. Any task that turns red needs a smaller first step, so split it into two rows and mark the first one In progress.

Useful for

  • Planning homework across five subjects for one week
  • Seeing which assignments are due before a weekend
  • Blocking study time before a big test

What's included

  • 4 tabs: Dashboard, Homework, Week plan, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Homework: a table
  • Week plan: a grid
  • 1 chart 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 Homework 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 do I plan homework for the week?

List every task on the Homework tab with its due date, then fill in the Week plan grid with the minutes you will spend on each subject each day. Start with the tasks due soonest, and leave some Sunday time for catching up.

How long should homework take?

Many schools suggest a rough guide of about ten minutes per grade level each night, but real times vary by task and student. Use the minutes column for your own estimates, compare them with how long tasks take in practice, and adjust.

What shows me which assignments are overdue?

Rows go red for any assignment past its deadline that is still open. Switch the status to Done after handing it in; the row then stops counting as overdue and only unfinished work stays red.

  • #grade-tracker
  • #homework-planner
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More grade tracker templates

See all 8

Also in Careers

All careers templates
Get this template

Preparing your template…