MS Excel 2

• 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.

• Discuss advantages of smartart in Excel
• Difference between smartart and graphical representation of data
• Effectiveness of graphical representation of data 

• 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

• 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

• 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:

• 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

• 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