Top
Download PDF

G Suite

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 

  1. Open Google Drive 
  2. Create a folder and name it “Google Tools”
  3. Star the folder 
  4. 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

  1. Create a Google Doc in the folder and title the document “ Google Doc”
  2. Copy an essay from Google search and paste it on the doc
  3. Insert a picture on the document
  4. Add your friend as a collaborator 
  5. 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:-

  1. Open a Google Sheet in the drive 
  2. Title the sheet as “my finances”
  3. Generate pocket money data (should include months, Money received, Money spent)
  4. Using commands calculate Total Expenditure and Savings 
  5. Insert graphs for the data you’ve generated
  6. 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