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

%d bloggers like this: