Mr. Adam's Schedule in Google Spreadsheet

Last month, I wanted to meet with our new Debate Coach and English teacher, and, to my surprise, he suggested to signup using his online schedule, a Google spreadsheet file shared with our faculty and students. I found this schedule very useful and decided to create the Technology Integration spreadsheet for our faculty as a convenient and easy way to signup for training sessions with us. 

Please watch a video with Mr. Adams. 

According to Mr. Adams, "students (and the faculty) have 24-hour access to my schedule, so they don't need to track me down. Students sign up themselves so no questions about whether the time or date is right. I offer them the chance to sign up in class during writing assignments, etc. You have to monitor the schedule and keep it up-to-date."

How to Create a Google Spreadsheet?

Click on Create and select Spreadsheet




To change the cell color:



Click on the cell that you wish to change the color of, then click on the paint bucket tool to alter the color of your cell.

To change the font size:



Click on the cell you wish to alter the font size in, then click on the box shown above with a number in it, then select your desired font size.

Copying Columns

To avoid having to re-enter your class schedule and having to re-color the cells, copy and past the columns from week to week.

Notifications

You can set notifications to find out when your collaborators have modified your spreadsheets, and learn what sheets or cells they've modified. You can also choose how often you'd like to be notified. Here's how you can enable notifications:

1. Go to the Tools menu and select "Notification rules."
2. In the window that appears, select when and how often you want to receive notifications.
3. Click Save.
   

To see the additional resources on Google spreadsheet, please visit our wiki.