Top
Download PDF

MS Excel 2

Digital Literacy (21st Century Literacies)
MS Excel 2
Lesson Plan

Objective:
 Participants will be able to understand, apply and interpret basic smartart and graphical representation of data in MS Excel 
Total Time: 90 Minutes
Materials Required: 
Computer lab with projector and screen, MS Excel installed on all the computers for students
Instructor Note: 
After understanding and using basics of MS Excel in the previous session, participants will learn and apply graphical representation of data to make their excel sheets more relevant and effective. 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 previous session by asking 1-2 participants to share with the class what they learnt and did in the previous session.
5 Minutes
Concept Discussion:
  • Discuss advantages of smartart in Excel
  • Difference between smartart and graphical representation of data
  • Effectiveness of graphical representation of data 
10 Minutes
Activity 1 :
  • Ask students to open the MS Excel lesson in their handbooks and read the instructions for Activity named SmartArt
  • Ask them to check the 2 graphics given in the handbook and create both the graphics in excel using SmartArts. Tell them that they need to go to Insert Menu to add SmartArt 
  • Give them 5 minutes to do that
  • After students have created basic SmartArts, demonstrate how they can change the colours, shapes and how they can add or delete shapes
  • Also, demonstrate adding, removing or formatting text in SmartArt
  • Ask students to practice these features on the basic SmartArt they had created in excel

20 Minutes
Concept discussion and demonstration:
  • Using the PPT, explain the following:-
  • Types of SmartArt
  • Basic graphs
  • Advantages of using graphs
  • Demonstrate creating following charts in excel-
  • Donut chart
  • Pie chart
  • Line graph
  • Bar graph
15 Minutes

Activity 2:
  • Ask students to read the instructions for “create dashboard” activity in the handbook
  • Ask them to create charts to represent the information given in the table
  • Help students if they find it difficult
  • Go to all the students and check their work
  • After students have created charts, ask them to check the outcome of the activity in their handbook and give the format of a dashboard to the 4 charts they have created
  • After students have tried making a dashboard
  • Stop them and demonstrate making the same dashboard using a projector. Either the trainer or any students who has completed the activity successfully can demonstrate making dashboard in front of the class

Outcome:

25 Minutes
Closing/Debrief:
  • Demonstrate how to talk about data using the dashboard students have created. Use statements like “which month had the most sales:”, “which month had the most profit?”
  • Ask one volunteer to come and present the dashboard infront of the class
  • Take students’ questions, if they have any
  • Encourage them to practice graphical representation of data. Tell them that they can insert charts in MS PPT and MS Word as well
10 Minutes
Closing Protocol: 
  • 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