Increasing Observational Learning using Google Sheets

Screenshot 2015-06-14 12.53.02Observational learning is an important part of the social learning experience and considered beneficial in increasing self-efficacy[cite num=”1″]. Increasing visibility in social learning is therefore an important fundamental. Google Sheets can be a useful tool for increasing observational learning as it allows for editing permissions to be set for individual cells in a spreadsheet.

When using Google Docs as a text editor, we can share the entire document in a variety of forms, but we cannot share individual sections of the document. However, using Google Sheets, we can change the editing permissions of individual cells.

So, for example, a student could fill in an individual table describing their own project plan while the entire spreadsheet could be made visible to the whole class. This provides an easy way to increase observational learning while avoiding accidental changes being made to other student’s sections.

The video below provides a brief tutorial in the setting of individual cell permissions.


1.[cite num=”1″ return=TRUE] Bandura, A. (1977). Self-efficacy: toward a unifying theory of behavioral change. Psychological review, 84(2), 191-215. DOI 10.1037//0033-295x.84.2.191

Tech for Teach

Awesome Tables: Easy Database Querying with Google


For anyone who has ever tried to create a web interface for a database, you know that doing it yourself means either coding using a PHP/MySQL pairing, or using something like Microsoft Access in conjunction with a SharePoint site. However, I┬áhave recently discovered a free and extremely easy way to set up a database querying web interface using Google Sheets in conjunction with a Google Gadget called Awesome Tables. The best part is, you don’t even need to mess around with Google Apps Script!

Continue reading “Awesome Tables: Easy Database Querying with Google”