SHARE WITH FRIENDS:
Exam answers for 10th grades in computer science
For the 2020 - 2021 academic year
Answers to 10th grade exam questions in computer science
1-ticket
- Create a table of 9 rows and 6 rows;
Combine the cells of line -2 and write the text "Calculate the power of a given number";
In column -A we enter the values of the number a;
-MsExcel too Insert— insert the formula we choose the sequence, enter the conditionally given values of a;
The square of the given number in cell -B4, ie = $ A4 * A4, is executed. Move the mouse pointer to the lower right corner of this cell, move down the column with the left mouse button pressed, and stop in cell B7;
-B7 Move the mouse pointer to the lower right corner of the cell and move B7: 17 with the left mouse button pressed. As a result, we get the following view.
2. Database Management System (DBMS) is a system of software tools designed by users to create, complete and share MO.
Examples of MOBTs are software tools such as MS Access and Openoffice.org.
3. Applications created in Delphi are called projects and are stored in a special Projects folder. They are more complex than applications created in Pascal, and require multiple files to store them. One file is enough to save a program created in Pascal, and all programs created in it can be stored in one folder. But in delphi this is not possible, because files of the same name from different projects save the other instead of one. It turns out that if we enter the program created in Pascal into Delhi, an error occurs.
-
b) In Excel, the $ symbol is used to represent the absolute address property in spreadsheets.
2-ticket
-
a) After this operation, the answer is 4 in cell C2;
b)GCD function corresponds to EKUB in Uzbek. For example: = GCDIf (6; 2) the answer is 2.
2. The main methods of creating an MO are:
-Hierarchical model - in this model the information is stored in a tree view. The performance unit is the record;
-Network model- although this model has a tree connection, there is no limit to the networking at the nodes;
-Relational model- in this model the data is stored in tabular form.
3.Delphi works with files with the following extensions in the programming environment:
-project file, extension .dpr;
-pascal module file, extension .pas;
-file with components, extension .deu;
-file with forms, extension .dfm;
-database file, extension .dbf.
3-ticket
-
1.
a)
- Create a table of 9 rows and 6 rows;
Combine the cells of line -2 and write the text "Calculate the power of a given number";
In column -A we enter the values of the number a;
-MsExcel too Insert— insert the formula we choose the sequence, enter the conditionally given values of a;
The square of the given number in cell -B4, ie = $ A4 * A4, is executed. Move the mouse pointer to the lower right corner of this cell, move down the column with the left mouse button pressed, and stop in cell B7;
-B7 Move the mouse pointer to the lower right corner of the cell and move B7: 17 with the left mouse button pressed. As a result, we get the following view.
-
b) In Excel, the $ symbol is used to represent the absolute address property in spreadsheets.
-
Hierarchical model - in this model the information is stored in a tree view. The performance unit is the record. The tree method is also called the hierarchical method.
-
The Find command in Delphi is located in the Search section of the main window.
4- ticket
-
a) After this operation, Abdullajonov Arraboy Ibrahim oglu is formed in cell E1
b)Stsepit(text1; text2;…) - converts multiple texts into a single text;
For example = Stsepit(14; ”- February”) = ”February 14”.
2. Data can be obtained using two different methods. These are structured and structured:
-Unstructured- If there is no agreement on how to describe this data, then they are said to be unstructured;
-Structured - If there is an agreement to describe the data, then they are said to be structured.
5-ticket
-
This operation multiplies the numbers in the selected cell.
-
2. Database Management System (DBMS) is a system of software tools designed by users to create, complete and share MO.
Examples of MOBTs are software tools such as MS Access and Openoffice.org.
3.The exam ticket says RTOfloa function, but it will be Floattostr.
The floattostr (n) function converts a real number n to a string representing a line, i.e. a real number.
6-ticket
-
a) You enter Manashu. The result:
-
b) ZAMENIT (old text; from which place to how many; new text) function - replaces the characters of the old text with the new ones from the specified number of characters;
Root the function takes the square root of a given number;
-
2. Database Management System (DBMS) is a system of software tools designed by users to create, complete and share MO.
Examples of MOBTs are software tools such as MS Access and Openoffice.org.
-
The floattostr (n) function converts a real number n to a string representing a line, i.e. a real number.
7-ticket
1.a) Enter: Result:
-
b) If the following error occurs in Ms Excel ########## you know that the data will not fit in the cell
-
The sequence of main menus in Ms Access: 1-File, 2-Home, 3-Creation, 4-External, 5-Work with database data
6-fields , 7-Table .
3. In the Delphi programming language as in Pascal 1) for I: = N1 to N2 do
2) while do
3) repeat until .
8-ticket
1.A) will be B3.
-
b) #PUSTO! When an error occurs, a value is entered in the cell in the wrong range.
-
The sequence of main menus in Ms Access:
3.Implementation-module means the beginning of the closed, ie invisible part for programs and modules. Here, the procedure and functions defined in the interface section must be specified again (their titles must be the same).
9-ticket
-
a) In cell C1 we enter the formula = A1 + B1 and for the case where A1 = 15 B1 = 10 we get 1 results in cell C25.
-
b) # 3HAЧ! If an error occurs, it means that the cell contains expressions that are not possible in the formula, for example: variables may be used in krill.
-
2. The main methods of creating an MO are:
-Hierarchical model - in this model the information is stored in a tree view. The performance unit is the record;
-Network model- although this model has a tree connection, there is no limit to the networking at the nodes;
-Relational model- in this model the data is stored in tabular form.
3.Implementation-module means the beginning of the closed, ie invisible part for programs and modules. Here, the procedure and functions defined in the interface section must be specified again (their titles must be the same).
10-ticket
-
a) Enter: Result:
-
b) CCHYOTESLI (block; condition) - determines the number of non-empty cells in the block that satisfies the condition.
11- ticket
-
a) Enter: Result:
-
b) CCHYOTESLI (block; condition) - determines the number of non-empty cells in the block that satisfies the condition.
-
In the program "MS Access 2010"Logical»Of the field to be described
Function- Saves the values "Yes" or "No" in this field. Used in MS Access when "1" - "Yes" and "0" - "No".
-
// this character is often used to write comments in Delphi. For example, when you enter a program code, what the code means is written down.
12-ticket
-
a) #PUSTO! When an error occurs, a value is entered in the cell in the wrong range.
-
b) #NAME? Ms Excel could not determine the name of the variable in the formula.
-
«Numerical»Field to be described-Digital field type stores numeric values, the range of which is determined in the field size parameter.
3. In Delphi, logical operations such as true and false are common. Because the values of many program components are true and false
13-ticket
1.a) #LINKThe! error occurs when a cell is incorrectly referenced.
b)
-
In the program "MS Access 2010"date/time»Of the field to be described
Position-
3. To add a new form to a project created in Delphi:
Select New in the File section and select Form from the resulting menu
14-ticket
-
a. What files in MS Excel 2010 have the extension .xlsx;
b. ############ We know that the data did not fit in the cell when an error occurred
-
Delete Sorted Data in MS Access 2010
for Tables command is selected.
3.
Object-oriented programming languages in Delphi:
An object-oriented approach (OMO) was not invented overnight. Its emergence is just another step in the natural development of software. Over time, it has become easier to determine which styles are comfortable to work with and which are inconvenient. OMYo effectively incorporates the most successful, time-tested methods.
Initially, programming was a rather confusing invention, allowing programmers to enter programs directly into the computer's main memory via a switching block. Programs were written in binary form in machine languages. Mistakes were often made when writing programs in machine language, and it was almost impossible to keep track of the code because of the inability to structure them. Also, the programming in machine codes was extremely complex to understand.
Over time, computers became more widely used and higher-level procedural languages emerged. The first of these was the FORTRAN language. However, the main influence on the development of the object-oriented approach was shown by procedural languages, such as ALGOL, which emerged later. Procedural languages allow a programmer to break down an information processing program into several lower-level procedures. Such lower-level procedures determine the overall structure of the program. Consistent access to these procedures governs the execution of programs that consist of procedures.
This new paradigm of programming was much more advanced than the programming paradigm of machine language, to which procedures were added, which were the main means of structuring, making the smaller functions not only easier to understand but also easier to configure. However, on the other hand, procedural programming limits the possibility of reusing code. On top of that, programmers often wrote “pasta” programs, the execution of which was like separating a pile of spaghetti on a plate. And finally, it became clear that focusing on the data itself in the development of programs with procedural programming methods was causing problems. Because data and procedure are separated, data is not encapsulated. What does this lead to? As a result, each procedure will need to know what to do with the data and where they are located. If the procedure behaves badly and performs incorrect actions on the data, it can corrupt the data. Since each procedure had to program the data access methods, a change in the data presentation would result in a change in all the places in the program where this access is performed. Thus, even the slightest correction would result in a number of changes throughout the program.
Attempts have been made to overcome some of the shortcomings found in procedural programming in modular programming languages, such as Modula2. Modular programming breaks a program into several components, or, in other words, modules. If procedural programming separates data and procedures, modular programming, on the other hand, combines them. The module consists of the data itself and the procedures for processing the data. If other parts of the program need to use the module, they will be able to access the module interface. The modules hide all internal information in other parts of the program.
However, modular programming is not without its drawbacks. The modules are non-expandable, which means that it is not possible to modify the module step by step without direct access to the code and without modifying it directly. In addition, when developing one module, it is not possible to use another without transferring its functions to another (without delegating). Again, although a type can be specified in a module, one module cannot use a specified type in another.
Structured and unstructured data in modular and procedural programming languages have their own "type". However, the method of species expansion does not exist, except for the creation of other species using a method called ‘aggregation’.
And finally, modular programming is again a hybrid scheme for a procedure, in which the program is divided into several procedures. However, now the procedures do not perform operations on the raw data, but manage the modules.
Object-oriented programming (OMD) takes a logical step after modular programming, which adds generation to generation and polymorphism to the module. When using OMD, the programmer systematizes the program by dividing it into a number of higher-level objects. Each object models a specific aspect of the problem being solved. OMD no longer focuses the programmer’s attention on compiling a sequence call sequence of procedures to manage the program execution process. Instead, the objects interact. The program developed with the help of OMYo serves as a practical model of the problem being solved.
Describing a program with object terms is the most understandable way to develop software. Objects force us to perceive everything in terms of what the object is doing, that is, to imaginatively model its behavior. Because of this, when approaching an object, it can be a bit distracting in terms of how it is used during the execution of the program. Thus, it is possible to use real-world natural terms in the process of writing a program. Instead of building a program in the form of separate procedures and data (in terms of the computer world), it is possible to build a program consisting of objects. Objects allow you to model the real world in a program using horses, verbs, and adjectives. Implementation determines how actions are performed. Introduction in programming terms is programming code.
By thinking in terms of the problem to be solved, one can avoid the risk of getting bogged down in the small details of implementation. Of course, some high-end objects need to use low-level, machine-designed methods when communicating with a computer. However, the object isolates this connection from other parts of the system.
An object is a program structure in which state and behavior are encapsulated. Object status is the sum of the values of these internal object variables.
An internal variable is a value that is stored inside an object.
In essence, an object is an instance (one of the copies) of this class.
OMD, like the real world, is made up of objects. In a pure object-oriented programming language, everything from the most basic, basic, whole, logical types to the more complex versions of classes is an object. However, not all object-oriented languages are so profound. In some languages (such as Java), simple primitives such as int and float are not considered objects.
OMD objects, like real-world objects, are classified according to their properties and behavior.
In biology, dogs, cats, elephants, and humans are mammals. It is the common features that unite the different animals. Similarly, in the software world, objects belong to one or more classes.
Objects belonging to the same class have common features. In other words, the class defines the features and behaviors that describe the object, as well as, and most importantly, the messages to which the object responds. When an object influences the behavior of another object, it does not show this effect directly, but asks it to self-modify using some additional information. Usually this is called ‘sending a message’.
A class combines objects that have common characteristics and behaviors. Objects belonging to the same class have the same properties and exhibit the same behavior.
Classes are like a template: they are used to make copies of objects.
Characters are properties that are visible from the outside of the class.
An object can only display its characters when it provides direct access to an internal variable or returns a value using a method.
Behavior is an action performed by an object in response to a message or a change in situation. It tells you what the object is doing.
One object can perform actions on another object and influence its behavior. Instead of the term "behavior", the terms "method call", "function call" or "message transmission" are used. What matters is not which of these terms is used, of course, the important thing is that these behaviors encourage the object to exhibit behavior.
Communication between objects is an important part of object-oriented programming. There are two main ways in which objects interact.
The first method: one of the objects exists independently of the other. If individual objects need interaction, they send a message to each other.
Objects communicate with each other using messages. The object that receives the message performs certain actions.
Messaging is the process of invoking a style or using one of the behavioral models to change the state of an object.
The second method: the object may contain other objects. Just as in OMD, objects can be aggregated from other objects using aggregation, just as a program is made up of objects. Each of these objects will have an interface with style and characters.
Message is an important concept of object-oriented approach. Thanks to the message mechanism, objects can maintain their independence. For an object that sends a message to another object, it does not matter how the object receiving the message performs the required behavior. It is important to him that the action is performed.
15-ticket
1.a) To create simple and complex function graphs in MS Excel 2010 Insert from the department Timetable is formed by
-
b) #NULL! When an error occurs, a value is entered in the cell in the wrong range.
2.Add (Investment) - this field allows you to work with mathematical functions
3.Apps in Delphi 7 application also referred to as To create a new application in Delphi, select the New item in the File section and the Application item in the new menu that appears.
16-ticket
1.a) in MS Excel 2010 FACTOR function: Calculates the factorial of an integer given as an argument.
-
b) function in excel
x ^ 2 + x * 2 + is written as COREN (3)
-
Addition - This field allows you to work with mathematical functions
-
Implementation-module means the beginning of the closed, ie invisible part for the application and modules. Here, the procedure and functions defined in the interface section must be specified again (their titles must be the same).
17-ticket
1.a) The LN function in MS Excel 2010 is used to get the Natural Lgarithm from an argument.
-
b) To create graphs of simple and complex functions in MS Excel 2010 Insert from the department Timetable is formed by
2.
3. To translate the text of the program into machine code that the computer understands, a program called a specially designed translator executes
18-ticket
1a) The EXP function in MS Excel 2010 calculates the exponential of an argument.
-
b) a) You enter Manashu. The result:
-
Actions in MS Access 2010:
-Mathematical operations
-Mathematical relations operations
-Logical actions
Also features:
-Mathematical functions
-Statistical functions
3.
19-ticket
-
a)The SIN function in MS Excel 2010 calculates the sine of a number.
-
b) First enter the code given below in Ms Excel and then press ENTER. The result is 9
-
Actions in MS Access 2010:
-Mathematical operations
-Mathematical relations operations
-Logical actions
Also features:
-Mathematical functions
-Statistical functions
3.
20-ticket
-
a)GCD function corresponds to EKUB in Uzbek. For example: = GCDIf (6; 2) the answer is 2.
-
b) In the process of working in MS Excel 2010 in the calculation formula in the case of dividing by the number 0 #BUSINESS/ 0 error occurs
21-ticket
-
a)NOC function EKU in UzbekК corresponds to. For example: = GCDIf (6; 2) the answer is 6.
b) Enter the formula shown in the figure: result:
2.
22-ticket
1a)PRoizved function multiplies the numbers in the entered cell.
b)A1=5, B1=3 C1=MAXIf (A1: B1) the result in cell C1 is 5. Because the Makc function finds the largest of the numbers in a cell.
2.Ms Access 2010 can create tables and enter data into them in 3 different ways:
-Direct data entry;
—Mode—Constructor
-Sozdanie-Konstruktor tablits.
3.
23-ticket
-
a)NOC function EKU in UzbekК corresponds to. For example: = GCDIf (6; 2) the answer is 6.
b) A block of 10 cells is taken.
2.Ms Access 2010 can create tables and enter data into them in 3 different ways:
-Direct data entry;
—Mode—Constructor
—Creation—Constructor tables.
3. As you can see from the picture, the ObjectTREEVIEW item can be activated while standing in the View menu, as well as by pressing Shift + Alt + F11.
24-ticket
-
a) In MS Excel 2010 ROOT The function is used to get the square root of a number.
b) Absolute and relative appeals are called mixed appeals.
3.
25-ticket
1a)
b) In cell C1 we enter the formula = a1 + b1. Given the calculation of the values given to us, C1 = 25.
-
Additional changes to the form window in MS Access 2010
if you need to enter it is done by selecting the constructor item from the Mode section.
26-ticket
-
a) Designed to work with text in cells in MS Excel 2010
"DLSTR”Function: Determines the number of characters in the text. For example: = DLSTR (“I”) = 3.
-
b)
- Create a table of 9 rows and 6 rows;
Combine the cells of line -2 and write the text "Calculate the power of a given number";
In column -A we enter the values of the number a;
-MsExcel too Insert— insert the formula we choose the sequence, enter the conditionally given values of a;
The square of the given number in cell -B4, ie = $ A4 * A4, is executed. Move the mouse pointer to the lower right corner of this cell, move down the column with the left mouse button pressed, and stop in cell B7;
-B7 Move the mouse pointer to the lower right corner of the cell and move B7: 17 with the left mouse button pressed. As a result, we get the following view.
-
The given template in the database in MS Access 2010
to search and process on Home from the menu Videlenie section is selected.
-
In Delphi To run the application after creating the program
You need to press F9.
27-ticket
1a) Designed to work with text in cells in MS Excel 2010
"ZAMENIT”Function ZAMENIT(old text; from which place instead of how many; new text) function - replaces the characters of the old text with a new number of characters from the specified location;
-
b) If we enter in the same order in Excel, the answer will be Rebellious.
2.
-
In Delphi, the button is called a Button in Delphi.
28-ticket
1a) Designed to work with text in cells in MS Excel 2010
ZNAChEN function of the function- ZNAChEN(text) Converts a number from a text view to a number. For example: ZNAChEN (“1024.25”) = 1024.25
-
b) Writing a mathematical expression in MS Ecxcel
specify: x ^ 2 + x * 2 + ROOT (3)
-
The most popular query in MS Access 2010 is the Query query;
3.Applications Application again,application also referred to as
29-ticket
-
a) Designed to work with text in cells in MS Excel 2010
STsEPIT function function-Combines multiple texts into a single text.
-
b) A1 = 5, B1 = 3 C1 =MAX(A1: B1) then the result in cell C1 - the result is c1 = 5.
Because the McC function finds the largest of the numbers in the cell.
-
From the main table as a result of the query in MS Excel 2010
An additional table is created.
-
When working in the Delphi programming environment, it is processed with files with the following extensions:
-project file, extension .dpr;
-pascal module file, extension .pas;
-file with components, extension .deu;
-file with forms, extension .dfm;
-database file, extension .dbf.
30-ticket
-
a) In an MS Excel spreadsheet, the expression B2: C5 defines 8 cells.
-
b) First enter the code given below in Ms Excel and then press ENTER. The result is 9