If you click the button above, you will find a spreadsheet that I created for our Middle School. We needed a one stop place for all teachers to be able to access and add information about our students. We struggled with communication on what work students were missing and wanted a place to go to gather vital data without having to search in several different locations. I have taken the names off of the students, but you can see where the teachers can mark off accommodations, list missing work in the referral columns, etc. On further tabs you can see where I have created formulas to have colored flags show up when students have reached too many missing or late assignments and need to have an interventions. We also have a tab that calculates the total amounts for the middle school as a whole. This simple spreadsheet has saved so much time and energy and allows the teachers to communicate on new levels.
The video below is a great tutorial on using a spreadsheet like Google Sheets.
The video below is a great tutorial on using a spreadsheet like Google Sheets.
The Difference with DataBases
Databases are slightly different than a spreadsheet. It is a tool to gather data and then you can use it to make correlations within it.
The data base for a teacher can be a valuable tool. You can create one to keep track of student contact information (like the one above) or book records, etc. The link below is a great article that talks about how to use them with students and the benefits databases can have.