Student Academic Planner | Google Sheets Template

Stay on top of every class, deadline and grade with this student planner for Google Sheets. See what is due in the next 7 days, track every assignment with its weight and grade, and watch your course grades and semester GPA calculate themselves.

WHAT'S INSIDE

- Dashboard: % of work completed, overdue count, things due in the next 7 days, semester GPA, a semester progress bar, a due-next list, current grade per course chart, workload by week chart, upcoming exams and grades at a glance

- Assignments: course, title, type (essay, exam, quiz, lab, project, reading, presentation), due date, weight %, status, grade %, days left and urgency colours (overdue, this week, later)

- Grades: weighted average for each course, letter grade, GPA points, credits and your semester GPA

- Timetable: Monday to Sunday, 8:00 to 20:00. Type a course code and the cell takes that course's colour

- Exams: course, date, time, room, topics, weight, a prep done tick box and a countdown

- Setup: semester name and dates, up to 8 courses with code, name, credits and instructor, and your own grade scale

- Start Here tab with simple instructions

TWO VERSIONS

You get a sample version filled with an example semester so you can see how everything works, and a blank version ready for your own classes.

HOW IT WORKS

1. After purchase, download the PDF from the link in your confirmation email.

2. Click the link in the PDF. Google asks you to make a copy, which is saved to your own Google Drive.

3. Add your semester dates and courses on the Setup tab, then your assignments.

GOOD TO KNOW

- Works for college, university and high school, any semester or term

- Works in Google Sheets on computer, tablet and phone (editing is easiest on a computer)

- A free Google account is needed

- Not made for Excel or Numbers

- This is a digital product. No physical item will be shipped

- For personal use only. Please do not share or resell

- Because this is a digital download, returns are not accepted. If you have any problem, email me and I will be happy to help