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

Practice and test work

Lessons 11–12 · 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
12

Test work

Textbook: pp. 30–32
GoalApplies the knowledge of lessons 1–11 in a test variant: expression, reference, function, text, IF and graph.
New words
expression value: the number a formula produces · ifoda qiymatireference type: relative, absolute or mixed · murojaat turigraph: the picture of a function drawn from a table of values · grafikchecklist: a list of points to check before handing in the work · tekshirish ro‘yxati
Explanation

The test covers the first part of the chapter: writing and calculating formulas, relative and absolute references, a reference to another sheet, text and logical functions, and the graph of a function. Each task is done in Excel and then the result is also checked by hand. Before handing in, go through the checklist: does the formula begin with “=”, are the brackets paired, is there a $ in the references that need it, is the text in quotation marks, has the chart been given a title. Analyse any error value by its sign: #DIV/0!, #NAME?, #VALUE!, #REF!. Put your own name in the file name, but do not enter personal data (phone, address).

Error valueCause
#DIV/0!division by zero
#NAME?unknown name
#VALUE!wrong type of value
#REF!a reference to a cell that does not exist
💡 Where will I use this?
In real life

Before handing in an important task, a pupil went through a checklist and then gave the work to a classmate. The classmate found a mistake the pupil had not seen. Two pairs of eyes made the work much more reliable.

Who uses it

Pilots use checklists, editors have another person read the text, and engineers have a colleague review their work.

Try it today

Give a page of your homework to a friend and ask them to find two mistakes, then do the same with a page of theirs.

Worked examples
Sample variant, task 1: calculate =(8-2)^2/4. Solution: the bracket gives 6; 6^2 = 36; 36/4 = 9. Task 2: in cell B2 of the “Jami” sheet take the sum of B2 on the “Yanvar” sheet and B2 on the “Fevral” sheet: =Yanvar!B2+Fevral!B2.
xy−2−112−3−2−11230y = x² – 2(0; –2)
Task 3: tabulate y = x² – 2 for x from –2 to 2 (step 1): y = 2, –1, –2, –1, 2 (formula =A2^2-2). A smooth scatter chart gives a parabola with vertex (0; –2). Task 4: in =IF(LEN(A1)>5,"uzun","qisqa") with A1 = “Excel”, LEN = 5, the condition is false and the result is “qisqa”.
Class activity

“Two pairs of eyes”: students swap their finished tests and look for mistakes using the checklist; then everyone discusses the most common mistake together.

Practice
1
What is the value of =(8-2)^2/4?
2
What is the value of y = x² – 2 at x = 3?
3
Write a formula that multiplies B5 on the sheet “Mart” by B5 on the sheet “Aprel”.
4
In a test, A1 = 10 and A2 = 0, and =A1/A2 was written. Which error appears and how can it be fixed?
Story of the Week · The Khwarizmi WayThe “doubled in 7 years” advertClose the week: all of this week’s subjects in one storyRead →