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

Practice and chapter test

Lessons 18–19 · 2 lessons · N. I. Taylaqov (general editor), A. B. Akhmedov, M. D. Pardayeva, A. A. Abdug‘aniyev, U. M. Mirsanov. Informatics and Information Technologies, Grade 10, 1st edition. “Extremum-Press”, Tashkent, 2017
19

Test work

Textbook: p. 42
GoalCompletes a test variant on the Excel chapter: references, functions, text, IF, statistics, graph and equation.
New words
variant: one version of a test · variantorder of solution: the steps from data to answer · yechim tartibiself-check: testing your own answer by another method · o‘z-o‘zini tekshirishinterpreting the result: saying what the number means · natijani izohlash
Explanation

The chapter test checks the Excel skills together: formulas and the types of references, a reference to another sheet, text and logical functions, statistical functions, the graph of a function and the approximate solution of an equation. Before starting, read all the tasks and mark which functions are needed. Check the result by a second method (for example by hand or with another formula) and, if an error value appears, write its cause. At the end check the file name and the order of the sheets. When writing formulas, answer in the form typical of national-test and attestation tasks: “exact formula + short comment”.

💡 Where will I use this?
In real life

Before filling in a long application form, a pupil read all the questions from start to finish. After writing the answers, the pupil checked the dates a second way, by adding them up again. Because of this the form was accepted the first time.

Who uses it

Bank clerks, surveyors and proofreaders check important work in two different ways to catch mistakes early.

Try it today

In your next homework, check one answer a second way, for example with a rough estimate.

Worked examples
xy−2−112−4−22460y = 2x² – 3
Sample variant: 1) Find the largest number in the range B2:F7 – =MAX(B2:F7). 2) On the “Hisobot” sheet multiply the number in cell A4 of the “Narxlar” sheet by the number in cell A4 of the “Soni” sheet – =Narxlar!A4*Soni!A4. 3) Draw the graph of y = 2x² – 3 for x = –2…2, step 1: y = 5, –1, –3, –1, 5.
B2Result
85a’lo
80oddiy
4) A city name is in A2 and a district name in B2; join them in C2 as “City, district” – =A2&", "&B2. 5) For a mark above 80 write “a’lo” (excellent), otherwise “oddiy” (ordinary) – =IF(B2>80,"a’lo","oddiy"). Checking the answer: with B2 = 85 the result is “a’lo”, with B2 = 80 it is “oddiy” (the condition is a strict inequality).
Class activity

“After the test”: students name the task where they made the most mistakes; the class writes one model formula on that topic together in 3 minutes.

Practice
1
What is =SQRT(16)+SQRT(49)?
2
Find the volume of a cube with side 4 with =4^3.
3
In =IF(B2>80,"a’lo","oddiy"), what is the result if B2 = 80?
4
Why is it useful in a test to check the result by a second method?
Story of the Week · The Khwarizmi WayHalf yellow, half green?Close the week: all of this week’s subjects in one storyRead →