8-A-1: Web Applications

My work days consist of teaching, tutoring, meetings, grading, answering emails and phone calls.  My days can fill up very quickly.  On any given school day, I have students contacting me to see when a good time would be to meet with them in the virtual classroom for tutoring.  While I typically have daily tutoring times available, students may not be able to attend those times due to a scheduling conflict.  By the time the student sends me an email and the chain continues to see when we both are available for tutoring, we have wasted a lot of precious time.  Emails can get lost in the mix, too!

One way to save time and help to meet my students’ needs is by using a Google Doc’s spreadsheet for student “contact” sign-ups.  As the teacher I can create a scheduling spreadsheet.  I can block off dates and times that I know I will be unable to help students.  Students can then view the document and add their name, what he or she needs help with, and contact preference.

A sample spreadsheet could look like this…

Monday, July 21, 2014
Tutoring or Teacher Contact Sign Ups

TIME AVAILABILITY Please help me with… Please contact me by…
8 AM – 8:30 AM      Bob Jones Solving Equations


8:30 AM – 9 AM      Anna Smith Exponents

Virtual Classroom

9 AM – 9:30 AM




The schedule can continue throughout the day and week.  The key would be for the teacher to continually monitor the spreadsheet.  To help keep track of changes, the teacher could have an email sent after any updates so the teacher can view cancelled or added appointments.

This app can also be used for students to sign up for peer tutoring or parent for a conference with the teacher.  The teacher can secure the app and prevent others outside the classroom for viewing and changing the document, too.  For peer tutoring, students could sign up to be a tutor during a certain day and time or to receive help similar to the manner used for tutoring with the teacher.  The teacher can also use the spreadsheet to keep track of who is helping others, those that need extra help, and when to open the virtual classroom for students to meet.  For parent-teacher conferences, the parents or guardians can also use this same set up to request a conference with the teacher.  This way efficiently helps to pick a date and time that both parties are available.

By using an app such as Google Doc’s spreadsheets, this will help the entire class run more efficiently and therefor promotes student learning and understanding.  In my experience, staying organized and up to date supports a successful classroom.