TeachThought
We grow teachers.

20+ Excel Spreadsheet Templates For Teachers

0 268

20+ Free Excel Spreadsheet Templates For Teachers

by TeachThought Staff

Spreadsheets aren’t exactly the most progressive, compelling, innovative, or gee-whiz-cool teaching resources around, but the right spreadsheet and template at the right time can come in handy. That they’re free, usable across Microsoft Excel, Google Sheets, Apple Numbers, and other open-source spreadsheet platforms doesn’t hurt.

So below we’ve gathered 20 of the best–and free–‘general education’ spreadsheet templates for teachers. We’ve linked to the Microsoft Excel file in each case (Still the standard for spreadsheet creation and function), but they can be exported to other platforms (often with a few font substitutions or other minor changes).

For more templates, resources. frameworks, models, and more, follow TeachThought on Pinterest.

20+ Free Excel Spreadsheet Templates For Teachers

1. Teacher’s Gradebook Template Spreadsheet (Points-Based)

Teachers can track students’ grades with this accessible grade book template. Just enter each assignment, quiz, and test along with the total available points for each, and as you enter each student’s scores the average, letter grade, and GPA will be calculated for you. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

2. Teacher’s Gradebook Template Spreadsheet (Percentage-Based)

Track your students’ grades with this accessible grade book based on percentages. Record each assignment, quiz, and test along with its percentage of the total grade, and as you enter student scores, the letter grade and GPA will be calculated automatically. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

3. Teacher’s Gradebook Spreadsheet Template (Average-Based)

Use this grade book to calculate grades when all assignments contribute equally to the final grade. The template includes instructions for use.

Download

4. Project-Management Timeline Spreadsheet

Visualize a full project with this timeline template. Help students plan their own next project-based learning unit. Plot milestones and tasks along a timeline and see task dependencies using scatter charts and other tools. This could also be used for a project of your own–professionally, your department, a committee, etc. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

5. Weekly Attendance Record Spreadsheet

Related Posts

Track weekly attendance for up to 30 students with this report template. Present, tardy, unexcused, and excused are listed as options for each day of the week. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

6. A Back-To-School Checklist Spreadsheet

Exactly what it sounds like–a back-to-school checklist useful for teachers, parents, students, etc. Simple and shareable, to boot. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes. (We included two alternatives below if the first doesn’t fit your needs.)

Download

Download Alternative Back-To-School Checklist Template

Download Yet Another Alternative Back-To-School Checklist Template

7. Student Randomizer

Conquer classroom management with this student randomizer. This accessible template is fully customizable to fit your school’s needs. Includes instructions.

Download

8. Group Assignment Task List Spreadsheet

Set goals, list group members, assign tasks, and more–get everyone on the same page for group tasks, projects, etc. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

9. Ice Breakers Collection & Organizing Template

Just a simple spreadsheet for organizing ice breakers, but really could be used to organize class discussion strategies, team-building games, etc.  Export it to Google Sheets, print, or use locally and track changes.

Download

10. Multiplication Table (1-10) Spreadsheet

This is fairly narrow in its usefulness (for younger students learning very early multiplication), but it does exactly what it says it does. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

11. School Team/Club Budget Spreadsheet

Set your club’s budget or goal for the year and track revenue and expenses. See at a glance which revenue streams and costs are high or low with this visually enhanced accessible template. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

12. Student Hall Pass Spreadsheet

Teachers can use this template to log when students use the hall pass to leave the classroom. This spreadsheet keeps track of student name, destination, departure time, and return time.  Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

13. Class Roster Template Spreadsheet

Teachers can use this accessible template to keep track of all the pertinent information about their students including emergency contact and medical info. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

14. Infographic Spreadsheet Template

Teachers (or anyone, really) can track five milestones of your product or project’s development with this timeline. Includes a worksheet for entering data which automatically updates the roadmap. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

15. Homeschooling Progress Record Template

While not for K-12 in-school teachers, this spreadsheet template tracks a student’s homeschooling progress with this accessible record template composed of nine subjects with room for five assignments each. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

16. General Semester Overview & Course List Template

Stay on top of your class schedule and assignments with this functional semester calendar. This four-month calendar highlights due dates in an at-a-glance view and more.

Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

17. Standard Graph Paper Template

Print out your own graph paper with this accessible template for Excel. Useful for graphing equations, drawing charts, or plotting layouts.

Download

18. Library Book Checkout Sheet

More for librarians and elementary school classrooms where there’s an in-class library of books, this template allows you to keep track of books or other resources from your lending library with this accessible checkout sheet.

List the borrower’s name, contact information, book title, date borrowed, and date returned. The number of days until the book is returned is automatically calculated, and a red warning displays for books about to become overdue. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

19. Teaching Idea Planner

Plan a classroom project from start to finish with this accessible template by listing the steps you need to take, which tasks are assigned to various team members, task status, and project resources. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

20. Class Schedule Spreadsheet Template

Keep your weekly class schedule up to date with this handy accessible template. Enter the start time and time interval for your schedule, and time slots will be created automatically. Color code as desired, and even block out time to study.

Download

21. A General Household Monthly Budget Spreadsheet

Teachers have lives and living is expensive. With this Microsoft Excel spreadsheet template, you can track monthly income and expenses for your household with this accessible budget template, which allows for projected and actual amounts. Enter a category for each expense and use the handy filtering buttons to focus in on specific types of expenses. Export it to Google Sheets, collaborate online, print a physical copy, or use locally and track changes.

Download

22. Another Monthly Budget Spreadsheet Template

Compare your estimated monthly income and expenses with the actual values using this accessible budget template. The differences, as well as your monthly balance, are calculated automatically.

Download

20+ Excel Spreadsheet Templates For Teachers

Please Login to comment
  Subscribe  
Notify of