This is a comprehensive Google Sheet for education courses and project timeline planning, and tracking.
It includes:
-
Project Timelines in a Gantt chart style, with start and due dates, duration, and color-coded progress.
-
Fall and Spring semester sheets showing months, weeks, and weekdays—highlighting the current day.
-
Attendance sheets for both semesters to track student participation.
-
A Course Overview page summarizing key course details.
-
A Grading Helper sheet to streamline grade calculation.
- Conditional Formatting & Color Coding for organization at a glance
This sheet is designed to keep projects, deadlines, and student data organized and easy to manage throughout the academic year.
Here’s a video on how I created the template to assist you with making updates.
Step 1: Download the provided .zip after purchase. Open the text file containing the Google Sheet URL. Make sure you are logged into Google when you open the URL. Then go to File > Make a copy so you can edit and save your personalized sheet. You may want to make an additional copy of the original before you begin editing.











