Digital Literacy (21st Century Literacies)
G Suite-1
Lesson Plan
Objective:
Participants will be able to understand and use Google Drive, Google Docs and Google Sheets |
Total Time: 90 Minutes |
Materials Required:
Computer lab with projector and screen, computers for students with internet connection |
Instructor Note:
After understanding and using the Microsoft office in the previous sessions, participants will now understand and use Google tools. These tools are a part of work life and our participants should know how to use these tools. Use demonstration as the training method and make students practice as much as possible. |
Opening Protocol:
-
Greet the participants
-
Take attendance
-
In pairs, ask participants to share with each other how they are feeling
-
Recap the Microsoft office sessions by asking 1-2 participants to share with the class, what they learnt and did in the previous sessions
|
5 Minutes |
Opening Activity :
-
Ask Students to log into their Gmail accounts
-
If some students don’t have Gmail accounts, give them 5 minutes to create their accounts. To help them, demonstrate the process of creating Gmail account on projector and ask them to create account real time on using computers or phones
|
10 Minutes |
Concept Discussion: Google Tools
-
Ask students to sit/stand with their group members
-
Give them 5 minutes to revise/read the Google Suite concept from their handbook
-
After 5 minutes, ask each group representative to summarise their learning in 1 minute
-
Correct students if they make mistake
-
Ensure that they understand and see Google tools in their computers
|
10 Minutes |
Demonstration and Practice : Google Drive and Google Docs
Demonstrate the following steps and ask students to do the same on their computers:-
Drive
-
Open Google Drive
-
Create a folder and name it “Google Tools”
-
Star the folder
-
Try to upload any random files in the folder
While students follow these steps to use Google Drive, engage them in a discussion on how Google drive folders are useful.
Google Docs
-
Create a Google Doc in the folder and title the document “ Google Doc”
-
Copy an essay from Google search and paste it on the doc
-
Insert a picture on the document
-
Add your friend as a collaborator
-
Explore the options of editing, viewing and commenting.
Ensure that all students do these steps on their computers. Students who complete the steps first can help other students.
|
25 Minutes |
Demonstration and Practice: Google Sheets
Demonstrate the following steps and ask students to do the same on their computers:-
-
Open a Google Sheet in the drive
-
Title the sheet as “my finances”
-
Generate pocket money data (should include months, Money received, Money spent)
-
Using commands calculate Total Expenditure and Savings
-
Insert graphs for the data you’ve generated
-
Move the sheet in the “Google Tools” folder they had created
Outcome:

|
25 Minutes |
Closing/Debrief:
-
Divide the class in two groups
-
Ask group 1 to read/discuss the similarities and differences between MS Word and Google Docs
-
Group 2 will discuss the similarities and differences between MS Excel and Google Sheets
-
Give them 5 minutes for this discussion
-
After 5 minutes give 2 minutes to each group to present their points
-
Conclude the session by encouraging participants to use Google tools for all the work they do on computers
|
10 Minutes |
Closing Protocol:
-
Contemplate Using Google Sheets as a tracking app
-
Thank the participants for their time
-
Announce the next time you will be visiting them
-
Share the topic of the next session
-
Collect 1-2 most interesting activity sheets/artefacts from students and show to Nodal officer and institution head after session
-
Click pictures of the artefacts for documentation
|
5 Minutes |