This free version of the Data Management Tool was inspired, created and used by a Special Education Teacher, but it has also been used by peer regular education teachers and therapists alike. It is a scaled-down version to show you how well this tool will help you organize, track, and manage the data necessary to manage your classroom(s) information. As the administrator of this form, it will allow you to track any piece of parent/student information as the headers are customizable. Dynamic fields are used to derive the child's age, number of days until they reach a specific birth date, average grade per assignment/period/year.
There is a considerable amount of automation included on the full version that will help you eliminate a significant amount of duplication. Using common fields, the full version will allow you to enter the information one time and then have the Daily Notes for each child ready to print without having to re-key the same information multiple times. Names, Dates, Daily assignments that were completed. Find it here: http://www.teacherspayteachers.com/Product/Child-Roster-with-Grades-Full-Version-1_0-749094
Instructions for this version:
'Child Roster and Classroom note" tab: If the field is green on the GREEN 'Child Roster and Classroom note" tab, you should populate the data there which will then auto-populate similar fields on the Grades and Daily Report tabs. Fields that are white should not be modified as they are derived fields (and unprotected). The workbook is also easy to update and additional columns can be added to accommodate additional categories of data.
"Grades" tab: Notice that the names from the Child Roster tab are automatically populated. Do not add names here (do that on the Child Roster tab). Rename the header row where it asks you to "Enter Assignment Name Here". Each of the "Period Average" sections can be renamed to anything you like (e.g. Quarter Summary; Semester Summary; Test Average; Homework Average, etc.). If you need more than 10 assignments per 'period', simply use the right-click on the column header (e.g. G column header) and click insert. This should insert a new column without affecting the horizontal formulas (average per child) but it will require you to copy the vertical formula in from an adjacent cell (using the same example, copy F24 and paste into G24).
Created using PC Excel version 2010, but this version should be backwards compatible to 2007.
Please feel free to email me if you need help making adjustments and I will assist as best I can. firstname.lastname@example.org