Topicm54812589e8406043_1528449000663_0Topic

Creating a chartchartchart based on multiple data seriesdata seriesdata series

Levelm54812589e8406043_1528449084556_0Level

Second

Core curriculumm54812589e8406043_1528449076687_0Core curriculum

Grade VII and VIII

II. Programming and solving problems by using the computer and other digital devices. Using computer applications the student:

3) creates documents and presentations, including those in a cloud in order to solve problems and create papers from various fields (subjects), adjusts the format and the appearance of the research papers to their content/purpose and demonstrates the following skills:

c) performing calculations specified in the curriculum of various subjects within the scope of primary school and useful in everyday life and implementing selected algorithms in a spreadsheet: entering data in a worksheet table, using basic functions, using relative, absolute and mixed references, presenting data in the form of various charts, ordering and filtering data.

Timingm54812589e8406043_1528449068082_0Timing

45 minutes

General objectivem54812589e8406043_1528449523725_0General objective

Designing a spreadsheet.

Specific objectivesm54812589e8406043_1528449552113_0Specific objectives

1. Creating appropriate charts for presenting data based on multiple data series.

2. Formatting charts.

Learning outcomesm54812589e8406043_1528450430307_0Learning outcomes

The student:

- creates appropriate charts for presenting data based on multiple data series,

- formats a chart.

Methodsm54812589e8406043_1528449534267_0Methods

1. Discussion.

2. Learning through observation.

Forms of workm54812589e8406043_1528449514617_0Forms of work

1. Individual work.

2. Class work.

Lesson stages

Introductionm54812589e8406043_1528450127855_0Introduction

The task of the students is to revise the information about charts.

At the beginning of the lesson the students answer the questions:

- What is a chartchartchart?
- What is it intended for?
- What chart types do you know?
- Should the chart type be adjusted to the presented data?

[Illustration 1]

A data series is a rowrowrow or columncolumncolumn of numbers that are entered in a worksheet and represented in a chart. It is very often the case that after creating the chart, you might need to modify it so that it includes another added data series.

Procedurem54812589e8406043_1528446435040_0Procedure

A chartchartchart created in Excel is always based on a certain range of datarange of datarange of data which was selected in a worksheet before creating the chart. Thus already during creating the chart you can decide which data will be plotted in it. If you want to modify the range of data after creating the chart, use the option Select Data, which you can find on the Design tab under Chart Tools or on the pop‑up menu. In the Select Data Sourcedata sourceData Source dialogue box, which appears on the worksheet, you can edit the datadata seriesdata series which are used for creating the chart.

[Illustration 2]

[Illustration 3]

If your chart is on the same worksheet as the data you used to create it, the two quick methods of adding a data series to a chart are available:

Method 1

After selecting a chart, the source data are selected on the worksheet as areasareasareas with sizing handleshandleshandles shown. Drag the sizing handles to include the new data.

Method 2

Select the cells with the data series you want to include in your chart, copy it to the clipboard, select the chart and paste the data.

[Slideshow]

Task 1

Create charts in a spreadsheet based on the slides.

Task 2

On the Internet, find the data presenting the average daily temperatures and precipitation for Suwałki and Tarnów in every month of the last year. Create a table in a spreadsheet in which you will enter the data. For each city calculate the average yearly temperature and the sum of yearly precipitation. Create charts that compare the temperature and precipitation in both cities. Select chart types so that the charts are the most readable in your opinion. By using a combo chart, include the data related to the temperature and precipitation in one chart.m54812589e8406043_1527752263647_0On the Internet, find the data presenting the average daily temperatures and precipitation for Suwałki and Tarnów in every month of the last year. Create a table in a spreadsheet in which you will enter the data. For each city calculate the average yearly temperature and the sum of yearly precipitation. Create charts that compare the temperature and precipitation in both cities. Select chart types so that the charts are the most readable in your opinion. By using a combo chart, include the data related to the temperature and precipitation in one chart.

Lesson summarym54812589e8406043_1528450119332_0Lesson summary

Presenting data, numbers, forecasts or trends in the form of charts makes them easy to understand by an audience.

Selected words and expressions used in the lesson plan

areasareasareas

chartchartchart

columncolumncolumn

data seriesdata seriesdata series

data sourcedata sourcedata source

handleshandleshandles

range of datarange of datarange of data

rowrowrow