Learning outcomes

By the end of the lesson, Ss will

know:

• Work in Microsoft Excel

• The ways it can be automate computing

be able to:

• to work with handouts

• to work in small teams

• to work in pairs

• to create a table and enter the formula in MS Excel

be aware:

• the importance of the program Excel

Communication

Vocabulary

Revisited: table, cell, formula string, column, line

New words: Formula, Addition, Subtraction, Multiplication, Division

Structures: Practice using Present Simple

Functions:

Organize work in pairs, do practice work and be able to give feedback

• Discussing worksheets in pairs and groups

• Check each other

Cognition

• To develop critical thinking skills

• To develop practice work skills

• To practice predicting information

• To brainstorm ideas

• To evaluate own and pair work

Citizenship

• To preserve safety

• To form healthy life style skills

• To develop moral and ethical qualities of students

• Don’t touch the connectors

Recources

• Interactive white board

• Power point presentation

• Vocabulary list

• Flash cards

• Matching schemes

• Worksheets

Procedure

Stage / Stage aim

Procedure

Timing

Interaction patterns

Materials

Organizational moment

Revision: to check the prior knowledge

Lead-in: to set the lesson aims

Pre-listening: to check pre-understanding of students of the topic

Listening: to check the task

Speaking: to practice the introduced vocabulary and grammar

New words:

Detailed understanding: to practice with computers

Homework:

Access:

Reflection:

Teacher greets students and checks attendance.

The teacher shows the task in active board and to revise previous topics and then one student from the group will show on active board.

ICQs

Do you discuss the task in groups or pairs? (groups)

Do you discuss the task for 5 min or 15 min? (5 min)

The teacher elicits the topic by giving students confused words.

Do you discuss the task in groups or pairs? (groups)

Do you discuss the task for 5 min or 15 min? (5 min)

Students will read the statements and mark them True or False. Then they compare their answers with their partners. Keys will be shown on the interactive board.

ISQs

Do you rewrite the sentences or mark them True or False?

Do you work in groups or pairs? (pairs)

1. In Microsoft Excel formulas, constants are numbers, dates or text values. (True)

2. Select a cell where you want to output the result. (True)

3. Type the plus symbol (+), and then type the equation you want to calculate. (False)

4. Press the Enter key to complete your formula. Done! (True)

5. We can write formulas in Excel using cell references. (True)

6. We can not Create Excel formulas using specific names. (False)

Students watch the video about how to create a formula and check their answers for the previous activity.

ISQs

Do you listen to the radio or watch the video?

Do you discuss the questions or check your answers?

Students are divided in groups and each group is assigned to present by selecting a question

1. How to make a simple Excel formula by using constants and operators (In Microsoft Excel formulas, constants are numbers, dates or text values that you enter directly in a formula. To create a simple Excel formula using constants, just do the following: -Select a cell where you want to output the result. -Type the equal symbol (=), and then type the equation you want to calculate. -Press the Enter key to complete your formula. Done!

2. How to write formulas in Excel using cell references (Instead of entering values directly in your Excel formula, you can refer to the cells, containing those values.For example, if you want to subtract a value in cell B2 from the value in cell A2, you write the following subtraction formula: =A2-B2. When making such a formula, you can type the cell references directly in the formula, or click the cell and Excel will insert a corresponding cell reference in your formula. To add range reference, select the range of cells in the sheet.

3. How to copy formula in Excel? (Copying formulas in Excel is one of the easiest tasks that is usually done in a mouse click. I say "usually" because there can be very specific cases that require special tricks, like copying a range of formulas without changing cell references or entering the same formula in multiple non-adjacent cells. Luckily, Microsoft Excel offers many ways to do the same task, and it is true for copying formulas. In this tutorial, we are going to discuss different ways to copy formulas in Excel.

4. Excel formulas not working, not updating, not calculating: fixes & solutions (Can someone imagine using Microsoft Excel without formulas? I believe no one can. And hardly anything could compare to the frustration caused by Excel formulas stop working all of a sudden. When this happens, a bunch of questions immediately flash across your mind. Why is my Excel formula not calculating? Why doesn't this formula update its value automatically? Is my Excel corrupt or is this due to some malicious virus? And how do I get my Excel to calculate and update formulas automatically again? Don't worry, most likely your Excel is all right, and you will get all the answers in a moment. -Excel formulas not working - a formula returns an error or wrong result. -Excel formulas not updating - a formula displays an old value after the values of the dependent cells have been updated. -Excel formulas not calculating - a cell displays a formula, not result.

Formula- fôrmyələ-Формула

Addition- ə’diSHən- прибавление

Subtraction- səb’trakSHən- вычитание

Multiplication- məltəpli’kāSHən- умножение

Division- di’viZHən- деление

Students will seat at the laptops and do practical work.

Create a chart on the model.

To calculate your average estimates for the year

Students access each other.

Students will give feedback.

(2 min)

(3 min)

(5 min)

(5 min)

6 (min)

9(min)

1(min)

10(min)

1(min)

1(min)

1 (min)

T-Ss

T-Ss

Ss-T

PW

Ss

GW

Т-Ss

S

Т

Ss

Ss

Slide 2

Worksheet 1

Worksheet 2

Video

Worksheet 3

Slide

Worksheet 4

Active board

Stickers