Topicmbc1bb8505a927a5b_1528449000663_0Topic

Filling a spreadsheet with data series

Levelmbc1bb8505a927a5b_1528449084556_0Level

Second

Core curriculummbc1bb8505a927a5b_1528449076687_0Core curriculum

Grades IV‑VII.

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

3) develops and presents solutions to problems by using basic applications (a text and image editor, a spreadsheet, a programme for creating a multimedia presentation) on the computer or in a cloud to demonstrate the following skills:

c) using a spreadsheet for solving tasks associated with simple calculations, entering data into a worksheet, formating cells, defining simple formulas and selecting appropriate charts for the data and the objectives of calculations.

Timingmbc1bb8505a927a5b_1528449068082_0Timing

45 minutes

General objectivembc1bb8505a927a5b_1528449523725_0General objective

To enter data in a spreadsheet.

Specific objectivesmbc1bb8505a927a5b_1528449552113_0Specific objectives

1. To enter data in a spreadsheet using data series.
2. To enter data in a spreadsheet using flash fill.

Learning outcomesmbc1bb8505a927a5b_1528450430307_0Learning outcomes

The student:

- fills in cells with a series of numbers, dates and values from built‑in lists or custom lists,
- uses flash fill.

Methodsmbc1bb8505a927a5b_1528449534267_0Methods

1. Learning through observation.
2. Using the knowledge in practical situations.

Forms of workmbc1bb8505a927a5b_1528449514617_0Forms of work

1. Individual work.
2. Class work.

Lesson stages

Introductionmbc1bb8505a927a5b_1528450127855_0Introduction

Instruction (Revision: number, date and time format in Excel, abbreviations of the days of the week and months used in Excel).

Students create a calendar page with the current month in the spreadsheet.

Procedurembc1bb8505a927a5b_1528446435040_0Procedure

When do we use filling a worksheet with data series?
The data in a worksheet often form an ordered string of values.
Such strings have the following features:
- they consist of countable elements,- they have their start and end value,
- the step between all subsequent values of the string is constant.mbc1bb8505a927a5b_1527752263647_0When do we use filling a worksheet with data series?
The data in a worksheet often form an ordered string of values.
Such strings have the following features:
- they consist of countable elements,- they have their start and end value,
- the step between all subsequent values of the string is constant.

Task
Give examples of data series that you use or come across everyday.

Task
Watch the slideshow which presents filling a worksheet with a data series and then create your own examples of data series in the worksheet.

[Slideshow 1]

The methods of filling in a data series:
- type the starting value for the series,
- type two starting values for the series,
- use the tool Fill Series.mbc1bb8505a927a5b_1527752256679_0The methods of filling in a data series:
- type the starting value for the series,
- type two starting values for the series,
- use the tool Fill Series.

If the number of the cells containing a series is high, it is convenient to adjust the length of the series to the data in adjacent cells.

The lists of the names of the days and the months are built in Excel. If the standard build‑in list does not meet our needs, we can define our own custom list.

Task
Analyse the interactive picture and create a worksheet in which you will define your own custom list containing the days of the week in English.

[Interactive Picture 1]

Task
Analyse the interactive picture presenting flash fill. Suggest data series in which it can be used.

[Interactive Picture 2]

Lesson summarymbc1bb8505a927a5b_1528450119332_0Lesson summary

Using data series reduces the time of creating a worksheet.

Selected words and expressions used in the lesson plan

auto fillauto fillauto fill

custom listcustom listcustom list

data seriesdata seriesdata series

flash fillflash fillflash fill

starting vaulestarting valuestarting vaule

stepstepstep

step valuestop valuestep value