AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Contents · Computing

Final review

Lessons 33–34 · 2 lessons · B. Boltayev, A. Azamatov, A. Asqarov, M. Sodiqov, G. Azamatova. Fundamentals of Informatics and Computer Technology, Grade 8. Second edition. “O‘zbekiston milliy ensiklopediyasi” State Scientific Publishing House, Tashkent, 2015
33

Review tasks (1)

Textbook: pp. 134–136
GoalTurns mathematical expressions into sheet formulas and solves tasks combining conditional formulas and text functions.
New words
SQRT(x): the square root of x · SQRTREPLACE(text; start; count; new): swaps a piece of the text for new text · REPLACEMAX(range1; range2; ...): the largest of all the numbers in the ranges · MAXrounding: ROUND(x; n) rounds a number to n decimal places · yaxlitlash
Explanation

When turning a mathematical expression into a formula, write * for multiplication, use ^ for powers, SQRT for the square root and a cell address in place of x: the expression 5x² + 3√x – 4 becomes =5*A1^2+3*SQRT(A1)-4. Testing divisibility: =IF(MOD(A3; 4)=0; "divisible"; "not divisible"). The largest number in several blocks: =MAX(B2:B6; E2:E4). In text, REPLACE("computer"; 4; 3; "XYZ") replaces 3 characters from the 4th and gives "comXYZer". To check whether an equality is an identity, for example (x+3)^2 = x^2+6x+9, we calculate both sides for several values and compare them with IF; with decimals apply ROUND before comparing, because the computer stores fractions approximately. Compound interest: an amount B at M per cent a year after A years is =B*(1+M/100)^A. After writing a formula, test it with edge values.

ExpressionFormula
5x² + 3√x – 4=5*A1^2+3*SQRT(A1)-4
B · (1 + M/100)ᴬ=B*(1+M/100)^A
💡 Where will I use this?
In real life

The teacher said, “Double the number and add 3.” The pupils wrote this as “x·2+3” and also tried it on two other numbers.

Who uses it

Programmers and engineers turn a rule given in words into a formula.

Try it today

Write an everyday rule, such as “triple the number and subtract 2”, as a formula and test it with 3 numbers.

Worked examples
At x = 4, =5*A1^2+3*SQRT(A1)-4: 5 · 16 = 80; 3 · 2 = 6; 80 + 6 – 4 = 82. For 92 : 4, MOD(92; 4) = 0, so “divisible”.
Identity: at x = 2, (2+3)^2 = 25 and 2^2+6·2+9 = 4+12+9 = 25 – equal. At x = 0, 9 and 9. One equal value does not prove an identity, so many values are tried.
Class activity

“Formula translators”: groups write a mathematical expression in a notebook, another group turns it into a sheet formula; then they compare values by hand and in the sheet.

Practice
1
What is =5*A1^2+3*SQRT(A1)-4 when x = 4?
2
What does REPLACE("computer"; 4; 3; "XYZ") give?
3
At x = 3, what is (x+3)^2 and what is x^2+6x+9? Does the identity hold?
4
Why is ROUND applied before comparing decimal numbers with IF?
Story of the Week · The Khwarizmi WayThe summer project decisionClose the week: all of this week’s subjects in one storyRead →