Education template
Class schedule
A weekly class timetable with color coded courses and a course list with rooms and instructors. Sessions, hours and credits are counted for you.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
2 sheets
- Timetable
- Courses
28 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 110 filled cells in all.
Built in
- Conditional formatting
- Dropdowns
- 6 conditional format rules
- 1 validation rule
A look at the Timetable sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Class schedule | |||||||
| 2 | Type course codes into the timetable. Names, rooms and totals come from the Courses tab. | |||||||
| 3 | Term | Spring 2027 | ||||||
| 4 | ||||||||
| 5 | Time | Monday | Tuesday | Wednesday | Thursday | Friday | ||
| 6 | 8:00 AM | BIO 110 | BIO 110 | BIO 110 | ||||
| 7 | 9:00 AM | CHEM 120 | CHEM 120 | |||||
| 8 | 10:00 AM | MATH 140 | MATH 140 | MATH 140 | MATH 140 | |||
| 9 | 11:00 AM | Lunch | Lunch | Lunch | Lunch | Lunch | ||
| 10 | 12:00 PM | ENG 105 | ENG 105 | PSY 101 | ||||
| 11 | 1:00 PM | CHEM 120L | PSY 101 | |||||
| 12 | 2:00 PM | CHEM 120L | ||||||
- school
- timetable
- college
- classes
- student
More education templates
EducationGrade bookWeighted grades for a whole class with letter grades, ranks and class statistics. Change the weights or the grading scale and every grade updates.
EducationAttendance trackerMark each student present, late or absent for every class date. Attendance rates per student and per session are calculated for you.
EducationSurvey results summarySummarize course feedback survey responses with counts, percentages and charts. Paste new responses and the summary updates.
FinancePersonal monthly budgetPlan income and spending for the month and see what is left at a glance. Compare planned and actual amounts by category with a chart.
Start your class schedule now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.