ЖИ көмекші
Презентация Make formulas in Microsoft Excel
Материал туралы қысқаша түсінік
8 сыныпқа Информатика пәнін ағылшын тілінде беретін мұғалімдерге Microsoft Excel-де формуламен жұмыс тақырыбына дайын презентация.
ЖИ арқылы жасау
Бұл бетте материалдың қысқаша нұсқасы ұсынылған. Материалдың толық нұсқасын жүктеп алып, көруге болады
1 / 15
ЖИ арқылы жасау
Материалдың қысқаша түсінігі
1 слайд
1 слайд
2 слайд
1. Introduce students with how to make
formulas.
2. Learn about the create a table and enter the
formula in MS Excel.
3. Develop skills Content, Cognition,
Communication, Culture .
2 слайд
1. Introduce students with how to make formulas. 2. Learn about the create a table and enter the formula in MS Excel. 3. Develop skills Content, Cognition, Communication, Culture .
3 слайд
F O R M E V
B G T U X S
A C A L C D
Q E B A E N
I L L K L P
H L E T I O
C A L C U L
M N O I T A
Confused words:
Find 5 words
3 слайд
F O R M E V B G T U X S A C A L C D Q E B A E N I L L K L P H L E T I O C A L C U L M N O I T A Confused words: Find 5 words
4 слайд
C S H E E T
A T A Y M F
L I N S E O
C G C J R R
U B A R T M
L S V E Q U
A T I O N L
Z L X C P A
Confused words:
Find 5 words
4 слайд
C S H E E T A T A Y M F L I N S E O C G C J R R U B A R T M L S V E Q U A T I O N L Z L X C P A Confused words: Find 5 words
5 слайд
1.In Microsoft Excel formulas, constants are numbers, dates or
text values.
2.Select a cell where you want to output the result.
3.Type the plus symbol (+), and then type the equation you
want to calculate.
4.Press the Enter key to complete your formula. Done!
5.We can write formulas in Excel using cell references.
6.We can not Create Excel formulas using specific names.
Task-2
Read the statements and mark them True or
False
5 слайд
1.In Microsoft Excel formulas, constants are numbers, dates or text values. 2.Select a cell where you want to output the result. 3.Type the plus symbol (+), and then type the equation you want to calculate. 4.Press the Enter key to complete your formula. Done! 5.We can write formulas in Excel using cell references. 6.We can not Create Excel formulas using specific names. Task-2 Read the statements and mark them True or False
6 слайд
Answers:
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)
6 слайд
Answers: 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)
7 слайд
How to create formulas in
Excel?
7 слайд
How to create formulas in Excel?
8 слайд
Task-3
1)How to make a simple Excel formula by
using constants and operators?
2)How to write formulas in Excel using cell
references
3)How to copy formula in Excel?
4)Excel formulas not working, not updating,
not calculating: fixes & solutions.
8 слайд
Task-3 1)How to make a simple Excel formula by using constants and operators? 2)How to write formulas in Excel using cell references 3)How to copy formula in Excel? 4)Excel formulas not working, not updating, not calculating: fixes & solutions.
9 слайд
New words:
№ Word Transcription Transfer
1.Formula ‘fôrmyələ Формула
2.Addition ə’diSHən Прибавление
3.Subtraction səb’trakSHən Вычитание
4.Multiplication məltəpli’kāSHənУмножение
5.Division di’viZHən Деление
9 слайд
New words: № Word Transcription Transfer 1.Formula ‘fôrmyələ Формула 2.Addition ə’diSHən Прибавление 3.Subtraction səb’trakSHən Вычитание 4.Multiplication məltəpli’kāSHənУмножение 5.Division di’viZHən Деление
10 слайд
Approved:
10 слайд
Approved:
11 слайд
Practice work
№ Foods PriceQuantitySoldRemainderProfit
1.Bread 70 50 42
2.Milk 250 30 21
3.juice 350 80 67
4.chocolate150 200 132
5.Ice-cream145 350 269
Create a chart on the model.
11 слайд
Practice work № Foods PriceQuantitySoldRemainderProfit 1.Bread 70 50 42 2.Milk 250 30 21 3.juice 350 80 67 4.chocolate150 200 132 5.Ice-cream145 350 269 Create a chart on the model.
12 слайд
To calculate your average estimates
for the year.
Home work
Home work
To calculate your
average estimates
for the year.
12 слайд
To calculate your average estimates for the year. Home work Home work To calculate your average estimates for the year.
13 слайд
Team
name
Home
work
Groups
work
Pairs
work
Practic
e work
Mark
Laptop
Compute
r
Access table
13 слайд
Team name Home work Groups work Pairs work Practic e work Mark Laptop Compute r Access table
14 слайд
What do you know?
What was new for you?
What will you want to
study?
Reflection:
14 слайд
What do you know? What was new for you? What will you want to study? Reflection:
Жариялаған:
Сулейменова Гаухар Суйындыковна
05 Қараша 2018
497
Сайтқа 5 материал жариялап, тегін АЛҒЫС ХАТ алыңыз!
Сайтқа 25 материал жариялап, тегін ҚҰРМЕТ ГРОМАТАСЫН алыңыз!
