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 value
Cause
#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.
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?
9
2
What is the value of y = x² – 2 at x = 3?
7
3
Write a formula that multiplies B5 on the sheet “Mart” by B5 on the sheet “Aprel”.
=Mart!B5*Aprel!B5
4
In a test, A1 = 10 and A2 = 0, and =A1/A2 was written. Which error appears and how can it be fixed?
#DIV/0!; put a non-zero number in A2 or write =IF(A2=0,"",A1/A2).