Lesson plan

Topicmf91f87f3f4019242_1529569707003_0Topic

Entering data into a spreadsheet

Levelmf91f87f3f4019242_1529569747309_0Level

Second

Core curriculummf91f87f3f4019242_1529569758662_0Core curriculum

Grade IV - VI

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.

Timingmf91f87f3f4019242_1529569766754_0Timing

45 minutes

General objectivemf91f87f3f4019242_1529569789751_0General objective

To use a spreadsheet to solve tasks.

Specific objectivesmf91f87f3f4019242_1529569875670_0Specific objectives

1. To enter data into a spreadsheet.

2. To define the address of a cell in a spreadsheet.

3. To define data typesdata typesdata types in Excel.

Learning outcomesmf91f87f3f4019242_1529569800993_0Learning outcomes

- enters data into a spreadsheet to a specified address.

- identifies various types of data.

Methodsmf91f87f3f4019242_1529569811928_0Methods

1. Learning through observation.

2. Flipped classroom.

Forms of workmf91f87f3f4019242_1529569825953_0Forms of work

1. Individual work.

2. Class work.

Lesson stages

Introductionmf91f87f3f4019242_1529569836422_0Introduction

Before the lesson learn the concept of the spreadsheetvaluespreadsheet. Think of where spreadsheets can be used.

Discussion:

What does a spreadsheetspreadsheetspreadsheetlook like?
Give examples of popular spreadsheets used in various operating systems.
Specify cloud solutions.
Give examples of the application of spreadsheets.
When will the use of a spreadsheet be most effective?

On the basis of the discussion students formulate the definition of the spreadsheet.

Definition:

A spreadsheet is a computer programme for presenting data in the form of two‑dimensional tables which enables to process data and display them in various forms. Most often it is used for calculations.mf91f87f3f4019242_1527751267401_0A spreadsheet is a computer programme for presenting data in the form of two‑dimensional tables which enables to process data and display them in various forms. Most often it is used for calculations.

Proceduremf91f87f3f4019242_1529569857336_0Procedure

Definition – cell addressmf91f87f3f4019242_1527751317064_0cell address

A spreadsheet contains columns and cells. Columns are represented by consecutive letters of the alphabet, while rows - by consecutive numbers. Every intersection of a row and a column in Excel constitutes a cell which has a unique address consisting of the name of the column and the number of the row, e.g. A7, AX167.mf91f87f3f4019242_1527751317064_0A spreadsheet contains columns and cells. Columns are represented by consecutive letters of the alphabet, while rows - by consecutive numbers. Every intersection of a row and a column in Excel constitutes a cell which has a unique address consisting of the name of the column and the number of the row, e.g. A7, AX167.

[application - Elements of the spreadsheet]

Instruction:

Learn the rules of navigating a spreadsheetspreadsheetspreadsheetby using the mouse and the keyboard. What is the name of the columncolumncolumn following the column Z? Give the name of the last column and the last row.

The user interface of Office programmes is almost identical. In Excel you will find ribbons, known from other Office applications. A new element of the spreadsheetspreadsheetspreadsheetis the formula bar – which is below the ribbons. It contains the address of the active cellcellcelland displays its content.

Every Excel document can contain many worksheets. You can add worksheets, change their names and move them to another place.

Instruction:

Add two new worksheets in an open document. Name them: New1, New2. Change their order. Make a copy of worksheet New2 and rename it as Copy1.

Data types - Excel automatically identifies the types of data entered into cells. Basic built‑in data types are: text, number, date, time, currency. Numbers can be presented in the form of a fraction or a percent.mf91f87f3f4019242_1527751335116_0Data types - Excel automatically identifies the types of data entered into cells. Basic built‑in data types are: text, number, date, time, currency. Numbers can be presented in the form of a fraction or a percent.

Instruction:

spreadsheetspreadsheetCreate a spreadsheet presented below.

[application - Data types in the spreadsheet]

You can edit the content of the cells:

- by using the formulaformulaformula bar,
- directly in a cellcellcell(mouse),
- by using function key F2.

Instruction:

Practice the above methods by changing the values in the previous spreadsheet.

A spreadsheet enables the user to select, move and copy cells.

You can copy and move cells by using:

- cut, copy and paste tool,
- mouse,
- keyboard shortcuts: CTRL+C, CTRL+X, CTRL+V.

Note what the cursor looks like during the above operations. Practise copying and moving cells containing numbers or texts. You will learn later how to copy mathematical formulas

Lesson summarymf91f87f3f4019242_1529569864352_0Lesson summary

Creating a spreadsheet is sometimes more time‑consuming than making calculations by using other tools. However, spreadsheets are invaluable in the case of their multiple use for different input data. Spreadsheets are also ideal for more difficult multi‑stage calculations.

mf91f87f3f4019242_1527751267401_0

mf91f87f3f4019242_1527751317064_0

mf91f87f3f4019242_1527751335116_0

mf91f87f3f4019242_1529569707003_0

mf91f87f3f4019242_1529569747309_0

mf91f87f3f4019242_1529569758662_0

mf91f87f3f4019242_1529569766754_0

mf91f87f3f4019242_1529569789751_0

mf91f87f3f4019242_1529569875670_0

mf91f87f3f4019242_1529569800993_0

mf91f87f3f4019242_1529569811928_0

mf91f87f3f4019242_1529569825953_0

mf91f87f3f4019242_1529569871794_0

mf91f87f3f4019242_1529569836422_0

mf91f87f3f4019242_1529569857336_0

mf91f87f3f4019242_1529569864352_0

cell1

column1

data types1

formula1

row1

spreadsheet1

value1

Scenariusz

Topicmf91f87f3f4019242_1529569707003_0Topic

Lesson stages