Topicm5b1159ce82d0f9d7_1528449000663_0Topic

Creating and copying formulas

Levelm5b1159ce82d0f9d7_1528449084556_0Level

Second

Core curriculumm5b1159ce82d0f9d7_1528449076687_0Core curriculum

Grades 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 the worksheet, formatting cells, defining simple formulas and selecting appropriate charts for the data and the objectives of calculations.

Timingm5b1159ce82d0f9d7_1528449068082_0Timing

45 minutes

General objectivem5b1159ce82d0f9d7_1528449523725_0General objective

- To use a spreadsheet to solve tasks.

Specific objectivesm5b1159ce82d0f9d7_1528449552113_0Specific objectives

- To create formulas.
- To use basic built‑in functions.

Learning outcomesm5b1159ce82d0f9d7_1528450430307_0Learning outcomes

- Student creates simple formulas.
- Student uses basic built‑in functions.

Methodsm5b1159ce82d0f9d7_1528449534267_0Methods

- Learning through observation.

Forms of workm5b1159ce82d0f9d7_1528449514617_0Forms of work

- Individual work.
- Class work.

Lesson stages

Introductionm5b1159ce82d0f9d7_1528450127855_0Introduction

[application 1]

Revision: data types in Excel (text, number, date, time, currency).

Procedurem5b1159ce82d0f9d7_1528446435040_0Procedure

Task
Using the ‘Help’ menu of the programme, learn arithmetic operators available in Excel. Memorise them.

A mathematical formula – an expression that allows us to perform a calculation. It always begins with the ‘Equals’ sign (=), which is followed by numbers, operators (e.g. +, -), references and functions.

The reference is the address of the cell whose content you want to use in your calculations.

Always remember to use references, not values, in formulas, if it is possible. Your worksheet will be universal and you will be able to use it many times.

Task
Analyse the interactive picture. Create a new worksheet and name it ‘Calculations’.
After finishing the worksheet change the values of the numbers and see how the worksheet recalculates them.

[application 2]

While entering formulas into cells, you can insert references into the formula using the following methods:

- writing the cell address by using the keyboard,

- pointing the cell with the mouse,

- pointing the cell with the keyboard arrow keys.

The order of operations – the priorities of operations in Excel are the same as in mathematics. If you want to change the default order of operations, use round brackets (). Of course, they can be multiply nested.

Simple functions – on the main tool ribbon you will find an option marked with the Greek sign ∑. By using it you will enter the sum function into the formula.m5b1159ce82d0f9d7_1527752263647_0Simple functions – on the main tool ribbon you will find an option marked with the Greek sign ∑. By using it you will enter the sum function into the formula.

Task
Enter any 5 numbers into cells A1:E1. Using the functions of the programme calculate their sum and their arithmetic mean, and give the greatest and the smallest number.

Copying formulas
Mathematical formulas can be copied, just like texts. In order to correctly copy formulas, you must learn different types of cell referencing: relative, absolute and mixed.m5b1159ce82d0f9d7_1527752256679_0Copying formulas
Mathematical formulas can be copied, just like texts. In order to correctly copy formulas, you must learn different types of cell referencing: relative, absolute and mixed.

Lesson summarym5b1159ce82d0f9d7_1528450119332_0Lesson summary

When creating formulas, remember to use references, not values. Do not forget about the order of operations.

Selected words and expressions used in the lesson plan

equal signequals signequal sign

asteriskasteriskasterisk

formulaformulaformula

forward slashforward slashforward slash

functionfunctionfunction

referencereferencereference