Compatible with Excel versions from 2007- current.
Intended to track related service proved minutes for the 2018-2019 school year. *Will be updated yearly for next download.
This is an easy-to-use Excel workbook consisting of 12 spreadsheets and can track up to 50 students.1 spreadsheet is for your caseload and then there is 1 spreadsheet for every month (August to June). It allows the teacher to record information about the session with the student, which includes: session length, student absences, school holidays, special circumstances and more.
HOW TO USE
*Included in the ZIP file is a sample workbook that allows you to alter and play with a simple 2 spreadsheet workbook and not effect any important documents. This sample sheet also has instructions built into each cell to explain the purpose and how to use it.
*Also included in the ZIP file is a how to guide with more explanations and picture diagrams.
*Student Info and service minutes are inputted in the Caseload sheet. Data is then entered on each monthly tab to match session length and notes.
*Service minutes are automatically calculated and displayed in varying fields (Monthly minutes, Weekly Minutes, Yearly Minutes, and Minutes needed for the month and more)
*Click on the tabs on the bar at the bottom of the page to navigate from one worksheet to another.
*Edit colors, fonts, cell size and more to make this minute tracker even more personal
The Caseload sheet requires data entry of required student service minutes. More information is given in the sheet, how-to-guide and sample workbook.
Some data entry is required. This sheet gives quick reference to a monthly schedule and how often that student is seen use the legend and other features to color code the session cells to show the student was absent, testing, with another sped teacher and more.
This workbook has many formulas and macros running to make the workbook happen. Changing the sheet in any way may prevent the spreadsheets from working. Many formulas are hidden and require precise uppercase and lowercase letters to work. Make sure to use all drop downs when given and to refer to the how to guides when questions arise.
Due to the formulas, macros and other parts of the workbook, there are some cells that are not editable and will give you an error if you try to change. These cells are locked in order to keep to formulas safe and other parts running smoothly.
Download today and begin to use this amazing minutes tracker!