Study smarter by planning ahead and tracking what you actually do. This study planner template combines a color-coded weekly study plan, a study log and a dashboard with weekly hour goals and a countdown to every exam.
Who this template is for
- High school and college students
- Anyone preparing for exams or certifications
- Parents helping kids plan study time
Features
- Up to 8 subjects, each with its own color, a weekly study goal in hours and an exam date.
- Weekly plan: 7 days × 15 hourly slots (7 AM–9 PM). Pick a subject from the drop-down and the slot takes its color. Planned hours are counted per day and week.
- Study log (600 lines): date, subject, minutes, topic, study method and a Reviewed checkbox.
- Dashboard: hours studied this week vs. your goal, progress bars, hours this month and days left to each exam (red within 2 weeks).
- Goal vs. studied chart. Pick any week by its Monday date. No macros.
How to use it
- Download the file and open it in Excel or upload it to Google Sheets.
- Enter your subjects, weekly goals and exam dates on the Dashboard.
- Plan your study slots for the week.
- Log each session and check your progress.
What’s included
- 1 .xlsx file with 4 tabs: Start Here, Dashboard, Weekly Plan and Study Log.
- Example subjects, a planned week and sample sessions (clear them to start fresh).
Compatibility
Works in Microsoft Excel (desktop, Mac and Excel online) and Google Sheets. No add-ons or macros required.
FAQ
Is it for high school or college?
Both — and for certification exams too. Use any subjects you like.
Can I plan a different week?
Yes. Change the “week of” date and the plan, totals and dashboard update.
Can I print my weekly plan?
Yes. The week fits on one landscape page.
Does it work in the free version of Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. A free Google account is all you need.
Can I use it on a Mac, iPad or phone?
Yes. It works in Excel for Mac and Windows, Excel online and the Google Sheets app. For editing, a computer or tablet is the most comfortable.
How do I get the file?
Right after checkout you get a download link on the confirmation page and by email.
More templates like this: Student Planners.
This is a digital product. No physical item will be shipped.
Reviews
There are no reviews yet.