Q: Do I need any paid software?
A: No. The app uses Google Sheets and Google Apps Script.
Education & Student Productivity template
Student Assignment & Study Planner
A simple Student Assignment & Study Planner built with Google Sheets and Google Apps Script. Track assignments, subjects, deadlines, priorities, completion status, scores, and weekly study sessions from a clean responsive dashboard. Ideal for high school and college students who want an easy way to organize schoolwork without complicated software.
student plannerassignment trackerstudy plannerhomework trackerschool organizerGoogle Sheets student plannerApps Script study planner
Template capabilities
What Student Assignment & Study Planner helps you automate
Assignment tracking with due dates, priorities, status, scores and notes
Included as part of this template workflow.
Subject management with progress tracking
Included as part of this template workflow.
Dashboard with total, completed, upcoming and overdue assignments
Included as part of this template workflow.
Weekly study planner with study sessions by subject
Included as part of this template workflow.
Upcoming deadline indicators
Included as part of this template workflow.
Search and filter assignments by subject, status, priority and date
Included as part of this template workflow.
Progress tracking by subject
Included as part of this template workflow.
Responsive mobile-friendly dashboard
Included as part of this template workflow.
Automatic Google Sheets database setup
Included as part of this template workflow.
Sample starter data included
Included as part of this template workflow.
Settings for student name, school name and deadline warning period
Included as part of this template workflow.
Common use cases
Built for practical education & student productivity work
- Track homework and assignments for multiple subjects
- Organize college coursework and deadlines
- Monitor overdue and upcoming assignments
- Plan weekly study sessions
- Track assignment completion progress
- Record assignment scores
- Manage school subjects and instructors
- Create a simple personal academic dashboard
- Replace a paper homework planner with a digital system
How to use it
From access request to working automation
- 1
Make a copy of the Google Sheet and Apps Script project
- 2
Open the Apps Script editor and add the 4 provided files
- 3
Deploy the project as a Web App
- 4
Open the Web App URL
- 5
Add or edit your subjects
- 6
Add assignments with due dates, priorities and status
- 7
Schedule study sessions in the weekly planner
- 8
Use the dashboard to monitor deadlines and progress
Setup checklist
Before using the template
Use the correct Google account
Create or copy the Google Sheet
Open Extensions → Apps Script
Add Code.gs
Add Index.html
Add Styles.html
Add Scripts.html
Save the project
Run setupDatabase once if needed and approve permissions
Deploy as a Web App
Set Execute as: Me
Choose the desired Web App access setting
Open the deployed URL
Test adding a subject, assignment and study session
FAQ
Questions about Student Assignment & Study Planner
Q: Can I customize the subjects?
A: Yes. You can add, edit and delete your own subjects.
Q: Can I track assignment scores?
A: Yes. Each assignment can store an optional score from 0 to 100.
Q: Does it show overdue assignments?
A: Yes. The dashboard automatically identifies incomplete assignments past their due date.
Q: Can I plan study sessions?
A: Yes. The weekly study planner lets you schedule sessions by date, time, subject and topic.
Q: Does it work on mobile?
A: Yes. The interface is responsive and designed for desktop, tablet and mobile screens.
Q: Does it connect to Google Classroom or an LMS?
A: No. This MVP is intentionally simple and does not use external APIs or LMS integrations.
Q: Is login required?
A: No custom login system is included. Access depends on the Google Apps Script Web App deployment settings.
Q: Where is the data stored?
A: Data is stored in the Google Sheet using SUBJECTS, ASSIGNMENTS, STUDY_PLAN and SETTINGS sheets.
Related templates
Continue exploring Apps Script automation
Finance & Billing Automation
Smart Invoice & Payment Reminder Tracker
A Google Sheets + Apps Script invoice tracker that helps freelancers, consultants, and small businesses create invoices, track payment status, send email reminders, and manage overdue payments. It solves the problem of forgotten invoices, late payments, and messy billing records.
CRM & Sales Automation
Lightweight CRM + Follow-Up Automation
A lightweight CRM built with Google Sheets and Apps Script to manage leads, clients, status pipelines, notes, and automated follow-up reminders. It helps freelancers, agencies, and small businesses keep track of prospects and improve response consistency. It solves the problem of lost leads, forgotten follow-ups, and disorganized client data.
Booking & Scheduling
Appointment Booking + Email Reminder System
A booking and scheduling app built with Google Sheets and Apps Script that helps service businesses manage appointments, customer details, time slots, and automatic email reminders. It helps reduce no-shows, keeps bookings organized, and makes scheduling easier. It solves the problem of manual appointment handling and forgotten reminders.