G6LP-2MS Excel Charts

Lesson Plan - 1 Computer Science MS Excel: Charts Topic-Different Types of Charts Class: Period: Mode: Classroom/Lab Teacher: ____________________________________________________________________________________ Learning Support Assistant: ____________________________________________________________ S.M.A.R.T. Learning Objectives By the end of this session, students will be able to: 1. Use at least 5 types of charts in Excel. 2. Understand the benefits of charts. 3. Recognize 8 chart components in Excel. Resources 1. video https://www.youtube.com/watch?v=p5HzBXsv08I (0.00-1.56) 2. Use the eContent to show the animated demos of the lesson. Session Conduction Engage: Show them some pictures and a write-up about the picture. For e.g., a triangle and two-three lines paragraph for a triangle. Ask students which one helped them to quickly identify it’s a triangle. Emphasize Humans respond to and process visual data better than any other type of data. In excel a chart can be defined as a pictorial representation or a diagram that represents data or values in an organized manner. Charts help us in finding trends like whether the sale of the product has increased or decreased over time. Concept introduction: In Microsoft Excel, charts are used to make a graphical representation of any set of data. A chart is a visual representation of data, in which the data is represented by symbols such as bars in a bar chart or lines in a line chart. Excel provides a variety of chart options with features of resizing, changing the chart elements, changing the chart text and colour, and repositioning.

Concept Demo/Explanation: Use some data and draw different types of charts in Excel like column charts, line charts, bar charts, pie charts, and area charts. Ask students to observe the differences in them. Give insights into when we should use a particular chart. Explain Column charts use vertical bars to show a comparison between categories or things. For e.g., we can use column charts to find out have to find out the population of age groups, 10-20, 20-30,30-40 and 40-60 in the year 2000, 2005,2010,2020. Explain the difference between a line graph and a column graph, Line graph is a common and effective chart because they are simple, easy to understand, and efficient. It is beneficial for showing changes and trends over different periods. We can use both a line chart and a column chart to illustrate a trend over time. However, a line chart is far more effective when many time periods are being measured. For example, if we are measuring fifty-two weeks, a column chart would require fifty-two bars. Bar and column charts enable us to easily summarize and compare values within a data category. They are ideal for such comparison because they provide a snapshot of data at specified points in time. Concept Practice: Show how to create charts from the Insert tab and show what are the chart components. Create a column chart showing the sales volume of the same home appliances ranked by months to show which month sells the most. Create a line chart to show monthly rainfall. Create a bar chart showing average scores ranked by subjects to show which subject students are weak in. Create a pie chart showing the atmospheric constituents. Create an area chart to show many cats and dogs rescued over a period of time. Additionally, discuss what is a funnel chart or a scatter chart. Optional Activity: Students can watch the video https://www.youtube.com/watch?v=p5HzBXsv08I . Practical Application: Complete the do-it-yourself and lab activities. Home Assignments 1)Revise the topic covered. 2) Practice the interactive exercises in Edusoft Smart App. 3) Solve any additional exercises on the playground.edusoft.co.in. Guided Assignment Students can visit https://edu.gcfglobal.org/en/excel/charts/1/ and find out more about the charts in Excel .

Evaluation After completing the lesson solve the exercises given in the book.

Lesson Plan - 2 Computer Science MS Excel: Charts Topic: Formatting Charts Class: Period: Mode: Classroom/Lab Teacher: ____________________________________________________________________________________ Learning Support Assistant: ____________________________________________________________ S.M.A.R.T. Learning Objectives By the end of this session, students will be able to: 1. Resize and move a chart to a new location. 2. Changing chart types. 3. Applying chart styles in Excel. 4. Format a chart to change its appearance. 5. Insert a picture in an Excel worksheet. 6. Use goal seek to do what-if analysis in Excel. Resources 3. video https://www.youtube.com/watch?v=p5HzBXsv08I (1.57 onwards) 4. Use the eContent to show the animated demos of the lesson. Session Conduction Engage: Recap the previous session. Concept introduction: While Excel can automatically handle many of the mundane tasks associated with turning raw data into a chart, we may still want to change some elements of our chart. We can use a variety of formatting techniques to enhance the appearance of a chart once we have created it. Two sets of tools are available for formatting chart elements: the Format task pane and the Chart Tools Ribbon. We can also insert a picture into a Worksheet. Goal seeking is finding the correct input when only the output is known. It is used for What- If analysis in Excel.

Concept Demo/Explanation: Discuss how we can change the appearance of a chart from the format chart area pane. Using the chart option apply a background colour to the chart, and add border and effects like shadow or blur. Change the text colour using the text option. The scale of an axis is the units into which the axis is divided. We may want to change the scale Excel uses along an axis of a chart. The scale automatically chosen by Excel may not represent the possibilities we want to be conveyed in our chart. Use the examples in the book to change the axis scale. Goal Seek is a built-in Excel feature that let us see how one data item in a formula impacts another. We might look at these as cause-and-effect scenarios. Create a worksheet with election result details like following Party Votes % Of A 6000 Votes B 3530 Total 9530 63% 37% Using Goal Seek, change the input value of one cell and see how the results changes. As we can see team A is a majority but shy of the required 2/3 approval to win the election. So as an analyst we need to analyze how close Team A was. What would’ve made a difference? How many more votes were needed by Team A to win? Concept Practice: After showing different types of charts in Excel / move the charts to a new location. Resize the charts by dragging the handles. Using the steps provided in the chapter change the chart types and change the chart styles. Insert a picture in a worksheet. Ask students to check if we can copy and paste an Image from other sources in Excel. Optional Activity: Students can watch the video from the resource sections. Practical Application: Complete the do-it-yourself and lab activities. Home Assignments 1)Revise the topic covered. 2) Practice the interactive exercises in Edusoft Smart App. 3) Solve any additional exercises on the playground.edusoft.co.in. Guided Assignment

Students can visit https://www.myexcelonline.com/blog/top-excel-formulas-function- examples-to-get-better-at-microsoft-excel/ and discuss their findings with the teacher. Evaluation After completing the lesson solve the exercises given in the book.