Открытый урок на тему Excel

The bell rings ,

we begin

our lesson

Epigraph to the lesson : Tell me and I will forget. Show me and I will remember. Let me do it and I will understand.

Brainstorm

What it is?

If the calculation is a lot, but the time is short, then trust the spreadsheets

Spreadsheets

The purpose of the lesson:

• Pupils have new knowledge on the topic “Excel Spreadsheet. Environment and principles of work, develop students skills in a desktop processor environment.

Spreadsheets have been using computer technology for about 40 years.

Open the program

Microsoft Excel-

The history of spreadsheets

start-all programs-

Ms.office-Ms.Excel

Spreadsheets or table processor-is

application program designed

to work with numbers

presented in a table form

heading

Spreadsheet window structure

menu

control buttons

the books

the columns

workspace

lines

cell

sheets

C4- active cell

C4 and B6 – cell address

The main operations with spreadsheet

elements are paste and delete

These commands are in the cell menu

The main information objects processed by the table are the following data types

Text

Formula

Number

symbol

Sound and drawing cannot be entered into

the cell

With numbers in a spreadsheet, you can perform various mathematical actions (addition, multiplication, subtraction, division) and calculation of arithmetic mean, calculation of maximum / minimum value, etc.

Formatting cells

The formula starts with «=» for example: =A5*B3 =C6/D2 =A1+D6-B2

Послушал-забыл, посмотрел-запомнил, сделал-понял.

Listened-forgot, looked-remembered, done-understood.

Конфуций

Practical work

Task 1 .

Work in group

You must find the right answers .

Activity

Multiplication table

Task 2 .

Individual work

You must fill in the table using AutoFill

Task 3 .

Check the task.

Test “Kahoot”

Feedback «Free microphone»

• I found out…
• It was interesting…
• It was easy…
• I understood, what..
• Now I can…
• I felt, what…
• I learned…
• I could…
• I was surprised…
• I wanted…

Thank you for attention.