Problem solving. excel
Task #1
The results of pentathlon athletes are evaluated by the sum of points scored for each of the five events, plus 10% of the score for athletes under 16 years of age.
values in column H (use the logical function "IF");
average values in cells C14, D14, E14, F14, G14.
Based on the results obtained, establish a correspondence between sports:
fencing
shooting
jumping
From the data in the original table, build charts that display the results of the top five athletes in each sport.
Sort in ET by the column "Sum of points" in descending order.
Determine the athlete who showed the best result among the participants.
Fig.1 Data for task1
Task #2
Students take 5 computer science tests. For each test, you can get from 0 to 10 points. If at least 6 points are received for test No. 3, then this result is increased by 20%. If the total number of points obtained during testing is less than 20, then this corresponds to a score of "2"; score "3" corresponds to the number of points from 20 to 29; score "4" - from 30 to 39; score 25 "- 40 points and above.
Enter the original data into the spreadsheet.
Enter into ET formulas for calculation:
values in columns G and H (use the logical function "IF");
the average value in cell G15;
According to the received calculations, establish a correspondence between the following participants of the Olympiad:
Bondarenko
Ignatiev
Kudinov
According to the original table, build a graph that displays the results of Denisov, Filatov, Ignatiev.
Determine the number of students whose score falls between 30 and 40.
Fig 2. Data for task 2
Task #3
The Programming Olympiad is evaluated by the sum of the points received for each of the three problems, plus 10% of the total for students under 10th grade. A participant who scores 27 points or more receives a diploma of the 1st degree. 25-26 points - diploma of the 2nd degree, 23-24 points - diploma of the 3rd degree. The participant who scored less than 23 points will receive incentive letters.
Enter the original data into the spreadsheet.
Enter into ET formulas for calculation:
Values in columns G and H (in both cases, use the logical function "IF ()");
average values in cells D16, E16, F16;
total points for all participants in G17.
According to the calculations obtained, establish a correspondence between the scores of the Olympiad:
Based on the data in the original table, build a histogram that displays the contribution of points for each task to the overall result of the winner.
Identify the student with the worst result.
Fig.3 Data for task 3
Task #4
To enroll in college, applicants take four tests. If the total score is not less than 250, applicants receive the message "Enroll", otherwise - "Reject".
Fill in the spreadsheet with the original data.
Enter formulas in ET to calculate values in columns F and G and cells B14, C14, D14, E14, F14.
According to the calculations obtained, establish a correspondence between the following items:
maths;
Russian language;
English language.
Construct charts showing the scores of the top five weakest applicants in each subject.
Sort in the ET by the column "Sum of points" in descending order.
Identify the student who scored fourth among college-admitted students.
Fig 4. Data for task 4
DE Case-tasks
OPTION 1
Case 1 subtask 1
– values in columns G and H (use the logical function "IF");
- the average value in cell G15.
Based on the calculations obtained, establish a correspondence between the following participants in the Olympiad and the number of points they scored:
Avilova O.S.
Vasilyeva K. A.
Denisov A. M.
Solution:
The values in column G are calculated using the formula: =IF(D4>=6,B4+C4+D4*1,2+E4+F4,SUM(B4:F4))
.
The values in column H are calculated using the formula: =IF(G4<20;2;ЕСЛИ(G4<30;3;ЕСЛИ(G4<40;4;5)))
.
The value in cell G15 is calculated using the formula: =AVERAGE(G4:G13)
.
Thus, Avilova O.S. scored 19 points, Vasilyeva K.A. - 43.4 points, Denisov A.M. - 44.8 points.
Case 1 subtask 2
Students take 5 computer science tests. For each test, you can get from 0 to 10 points. If at least 6 points are received for test No. 3, then this result is increased by 20%. If the total number of points obtained during testing is less than 20, then this corresponds to a score of "2"; score "3" corresponds to the number of points from 20 to 29; score "4" - from 30 to 39; grade "5" - 40 points and above.
According to the original table, establish a correspondence between the names of students:
1) Serova T. V.,
2) Bondarenko D. A.,
3) Golubev V.V.
and colors of graphs built according to their estimates. 
"Extra"
Solution:
"Extra" the graph is blue.
Case 1 subtask 3
Students take 5 computer science tests. For each test, you can get from 0 to 10 points. If at least 6 points are received for test No. 3, then this result is increased by 20%. If the total number of points obtained during testing is less than 20, then this corresponds to a score of "2"; score "3" corresponds to the number of points from 20 to 29; score "4" - from 30 to 39; grade "5" - 40 points and above.
Sort in the spreadsheet by the Grade column in descending order. Determine the total number of students who received grades "3" and "2".
Solution:
After performing all the calculations and sorting by the "Score" column in descending order, the source table will look like this: 
Thus, the total number of students who received grades "3" and "2" is 4.
OPTION 2
Case 1 subtask 1
Enter the original data into the spreadsheet (words can be abbreviated). 
Enter the formulas for calculation into the spreadsheet:
– values in columns G and H (in both cases, use the logical function "IF");
– average values in cells D15, E15, F15;
- the total score for all participants in cell G16.
According to the calculations obtained, establish a correspondence between the numbers of tasks and the average results of their solution:
task number 1
task number 2
task number 3
Solution:
Values in cells D15, E15, F15 are calculated according to the formulas:
=AVERAGE(D4:D13)
,
=AVERAGE(E4:E13)
,
=AVERAGE(F4:F13)
.
After performing all the calculations, the original table will take the form:
Case 1 subtask 2
The Programming Olympiad is evaluated by the sum of the points received for each of the three problems, plus 10% of the accumulated amount for students under the 10th grade. Participants who score 27 points or more receive a diploma of the 1st degree, 25-26 points - a diploma of the 2nd degree, 23-24 points - a diploma of the 3rd degree. Participants who score less than 23 points receive incentive certificates.
Analyze the diagram below according to the suggested answers. 
The diagram shown in the figure shows ...
Solution:
The option "distribution of participants by grades" is not suitable, since in this case the pie chart should have two sectors of equal size (for grades 8 and 10), and not three.
The option “the contribution of points for each task to the overall result of the winner” is not suitable, because there were three tasks, so there should be three sectors on the diagram, not four.
The option "best results in each category" is not suitable, because all four results are different. In addition, to compare individual values, it is more expedient to use histograms.
Let's consider the remaining option "distribution of participants by categories of awardees." Diploma of the 1st degree was awarded to 3 participants, 2nd degree - 3, 3rd degree - 1, diplomas - 3.
So, the diagram shown in the figure shows the distribution of participants by categories of awardees.
Case 1 subtask 3
The Programming Olympiad is evaluated by the sum of the points received for each of the three problems, plus 10% of the accumulated amount for students under the 10th grade. Participants who score 27 points or more receive a diploma of the 1st degree, 25-26 points - a diploma of the 2nd degree, 23-24 points - a diploma of the 3rd degree. Participants who score less than 23 points receive incentive certificates.
The total result for all participants is ...
Round the result to one decimal place, such as 225.5.
Solution:
After performing the calculations, the initial table will take the form: 
Thus, the total result for all participants is 241.2.
OPTION 3
Case 1 subtask 1
- scores in each subject are above the “threshold” value (in mathematics, more than 24 points, in physics - more than 28 points, in computer science - more than 25 points, in the Russian language - more than 34 points);
Enter the original data into the spreadsheet (words can be abbreviated). 
Enter the formulas for calculation into the spreadsheet:
– values in columns F and G (to calculate the values in column G, use the logical function "IF");
– average values in cells B14, C14, D14, E14;
According to the calculations obtained, establish a correspondence between the subjects and the average results of passing the exam for them:
maths
Informatics
Russian language
Solution:
The values in column F are calculated using the formula (for row 3): =SUM(B3:E3)
The values in column G are calculated using the formula (for row 3):
=IF(AND(B3>24,C3>28,D3>25,E3>34,F3>=240);
"Enroll"; "refuse")
The values in cells B14, C14, D14, E14 are calculated according to the formulas:
=AVERAGE(B3:B12)
,
=AVERAGE(C3:C12)
,
=AVERAGE(D3:D12)
,
=AVERAGE(E3:E12)
,
After performing the calculations, the initial table will take the form: 
Thus, the average result of passing the exam in mathematics is 60.8 points, in computer science - 53.8 points, in the Russian language - 58.3 points.
Case 1 subtask 2
Applicants take four exams in the form of the Unified State Examination. The message “Enroll” will be sent to those applicants who have:
- scores in each subject are above the “threshold” value (in mathematics, more than 24 points, in physics - more than 28 points, in computer science - more than 25 points, in the Russian language - more than 34 points);
- the total score in all subjects is not less than 240.
The rest of the applicants will receive a "Reject" message.
According to the source table, establish a correspondence between the names of applicants: Chernova P., Khasanov R., Denisov V. - and the colors of the graphs built according to the points they received. 
"Extra" the graph has ______________ color.
Solution:
Golubeva, 246
Solution:
After performing all the calculations and sorting by the column "Sum of points" in descending order, the original table will look like this: 
Thus, the last enrolled applicant will be V. Golubeva with a score of 246.
Send a request to receive the content of the test
No. 3120 Information technology in management - 127 questions. ORIGiz217
1. Applicants take four exams in the form of the Unified State Examination. The message "Enroll" will be sent to those applicants who: - scores for each subject are higher than the "threshold" value (in mathematics more than 24 points, in physics - more than 28 points, in computer science - more than 25 points, in the Russian language - more than 34 points) ; - the sum of points in all subjects is not less than 240. The rest of the applicants will receive a message "Refuse". Enter the source data into the spreadsheet (words can be abbreviated)
2. Applicants take four exams in the form of the Unified State Examination. The message "Enroll" will be sent to those applicants who: - scores for each subject are higher than the "threshold" value (in mathematics more than 24 points, in physics - more than 28 points, in computer science - more than 25 points, in the Russian language - more than 34 points) ; - the sum of points in all subjects is not less than 240. The rest of the applicants will receive a message "Refuse". According to the source table, establish a correspondence between the names of applicants: Chernova P., Khasanov R., Denisov V. - and the colors of the graphs built according to the points they received
3. Applicants take four exams in the form of the Unified State Examination. The message "Enroll" will be sent to those applicants who: - scores for each subject are higher than the "threshold" value (in mathematics more than 24 points, in physics - more than 28 points, in computer science - more than 25 points, in the Russian language - more than 34 points) ; - the sum of points in all subjects is not less than 240. The rest of the applicants will receive a message "Refuse". Sort in the spreadsheet by the Score column in descending order. Determine the last enrolled applicant and its result. In the answer field, enter the surname of this applicant and the amount of his points, separated by commas without spaces (for example, Ivanov, 35)
4. Most experts in the field of business communications believe that etiquette in its most vivid and complete form has developed and developed in such a country as
5. In the 60s of the last century, IS was used for control and management, in the 70s - for planning and modeling, and by the 80s they were already used for decision making and strategic planning
6. The following types of diagrams are distinguished in UML
7. In business communications, an afront is a violation of the rules of politeness.
8. In business communications, the size of a business card for men is traditionally accepted.
9. In the IDEFO model, the function of a particular system, represented graphically by a box, is
10. Within the framework of the UML modeling language, diagrams are used to model the behavior of system objects during the transition from one state to another.
11. Within the framework of the UML modeling language, diagrams are used to model the behavior of the system under various use cases.
12. Within the framework of the UML modeling language, diagrams are used to model the physical architecture of the system.
13. Due to the fact that label marks are bilateral in nature, they can be highlighted
14. In decision support systems, the component that provides simple interaction between system users, the database, and the reference is
15. In decision support systems, a collection of mathematical and analytical models is
16. In decision support systems, a collection of current or historical data from a number of applications or groups organized for easy access to application areas is
17. Important in business etiquette is the relative position of the interlocutors in space, the choice of a certain distance, the presence or absence of physical contact between them. This organization of space in etiquette is called etiquette _____
18. An evening reception that starts between 17.00 and 18.00 and lasts about two hours without seating at the table is called _____
19. The return of the processed data to the subject of management takes place in the process
20. Enter the terms corresponding to the process of perception, mutual understanding of the participants in communication: 1. a way of knowing another person, in which an assumption about his internal state is based on attempts to put himself in the place of a communication partner - _____. 2. emotional empathy for another person - _____. 3. the mechanism of self-knowledge in the process of communication, which is based on the ability of a person to imagine how he is perceived by a communication partner _____. 4. mechanism for interpreting the actions and feelings of another person (finding out the reasons for the behavior of the object) - casual _____
21. Choice (the development of algorithms for calculating the transformation of input information into output information is carried out within the framework of the following set of operations for setting the problem
22. The division of information systems into strategic, managerial, knowledge and operational is a classification according to
23. Let's say that you get a job. Among the requirements for the applicant, one of the main ones is his ICT competence. At the interview, you must demonstrate knowledge, skills and abilities when working with graphic and text editors, confident use of the Internet. To encode the color of a pixel in the 24-bit RGB model, hexadecimal intensity values of the color components of the RRGGBB format are used, where RR is the red color code, GG is the green color code, and BB is the blue color code. Pixel with code 808080 will match _____ color
24. Let's say that you get a job. Among the requirements for the applicant, one of the main ones is his ICT competence. At the interview, you must demonstrate knowledge, skills and abilities when working with graphic and text editors, confident use of the Internet. The user is going to download mp3 music files from a file hosting service. The data transfer rate via an ADSL connection is 512 Kbps. Free connection time is limited to 5 minutes. The average size of one music file is 4 MB. Calculate the maximum number of files that he will be able to download for free in one connection session. The time spent on requests is not taken into account; consider that files can be uploaded one after another continuously; a file that is not completely downloaded will not be saved. Assume that 1 Kbps = 1000 bps
25. Let's say that you get a job. Among the requirements for the applicant, one of the main ones is his ICT competence. At the interview, you must demonstrate knowledge, skills and abilities when working with graphic and text editors, confident use of the Internet. The user is going to download mp3 music files from a file sharing service. The data transfer rate via an ADSL connection is 512 Kbps. Free connection time is limited to 5 minutes. The average size of one music file is 4 MB. Calculate the largest number of files that he can download for free in one connection session. The time spent on requests is not taken into account; consider that files can be uploaded one after another continuously; a file that is not fully loaded will not be saved. Assume that 1 Kbps = 1000 bps. Answer: _____
26. Let's say that you get a job. Among the requirements for the applicant, one of the main ones is his ICT competence. At the interview, you must demonstrate knowledge, skills and abilities when working with graphic and text editors, confident use of the Internet. To encode the color of a pixel in the 24-bit RGB model, hexadecimal intensity values of the color components of the RRGGBB format are used, where RR is the red color code, GG is the green color code, and BB is the blue color code. Pixel with code 808080 will match _____ color
27. Let's say that you get a job. Among the requirements for the applicant, one of the main ones is his ICT competence. At the interview, you must demonstrate knowledge, skills and abilities when working with graphic and text editors, confident use of the Internet. The user is going to download mp3 music files from a file hosting service. The data transfer rate via an ADSL connection is 512 Kbps. Free connection time is limited to 5 minutes. The average size of one music file is 4 MB. Calculate the maximum number of files that he will be able to download for free in one connection session. The time spent on requests is not taken into account; consider that files can be uploaded one after another continuously; a file that is not completely downloaded will not be saved. Assume that 1 Kbps = 1000 bps
28. If married couples meet, then the greeting order is set as follows: (Set the sequence of events according to business etiquette)
29. The tough method of negotiating in business communications is characterized by such a feature as
30. Information systems in the twentieth century. began to be used for control and management in
31. Information systems in the twentieth century. evolved into custom-made decision support systems and early strategic planning systems in
32. Information systems in the twentieth century began to be used to control and manage in
33. Information systems in the twentieth century began to be used for planning and modeling in
34. Information systems in the 20th century evolved as operational level systems designed to perform elementary operations in
35. Information systems in the 20th century evolved as operational level systems designed to perform elementary operations in
36. Information systems in the 20th century evolved into custom decision support systems and early strategic planning systems in
37. The organization of space in negotiations includes
38. Speech etiquette includes
39. Control of the professional level of staff members, their training is carried out in the following direction of development of the AIS
40. Brief summary of the most important facts and arguments; An expression of sincere gratitude for your attention; Suggestion to ask questions. All of this applies to _____
41. Team leaders for programmers and analysts, project managers, physical asset managers, data communications managers, and heads of office automation teams are
42. The method of building an enterprise model, which begins with a general overview of the object of study, and then involves its consistent detailing is called
43. A model that always starts with a representation of the process as a single functional block with interface arcs that go beyond the area under consideration is obtained using the methodology
44. The gentle method of negotiating in business communications is to
45. At business meetings, a man from jewelry can only wear etiquette
46. At international negotiations, the program of stay does not include
47. It is not customary to indicate on the business cards of ladies
48. Unverified information is captured or collected within the organization or from external environments in the course of
49. The processed data is transferred to the personnel or processes where it will be used in the process
50. One of the positive consequences of the introduction of information technology is that the processing of initial data and calculations are entrusted to
51. The Programming Olympiad is evaluated by the sum of the points received for each of the three problems, plus 10% of the total for students under the 10th grade. Participants who score 27 points or more receive a diploma of the 1st degree, 25-26 points - a diploma of the 2nd degree, 23-24 points - a diploma of the 3rd degree. Participants who score less than 23 points receive incentive certificates. Enter the source data into the spreadsheet (words can be abbreviated)
52. The Programming Olympiad is evaluated by the sum of the points received for each of the three problems, plus 10% of the total for students under the 10th grade. Participants who score 27 points or more receive a diploma of the 1st degree, 25-26 points - a diploma of the 2nd degree, 23-24 points - a diploma of the 3rd degree. Participants who score less than 23 points receive incentive certificates. Analyze the diagram below according to the suggested answers.
53. The Programming Olympiad is evaluated by the sum of the points obtained for each of the three problems, plus 10% of the total for students under the 10th grade. Participants who score 27 points or more receive a diploma of the 1st degree, 25-26 points - a diploma of the 2nd degree, 23-24 points - a diploma of the 3rd degree. Participants who score less than 23 points receive incentive certificates. The total result for all participants is ... Round the result to one decimal place, for example 225.5
54. Operations to determine the purpose of the task, its purpose, frequency and deadlines are carried out as part of the following set of task setting operations
55. Operations to determine the composition of the details of the output information, the location of the details of the output information with the reflection of the control example, the description of the fields (the details of the output document are carried out as part of the following set of operations for setting the task
56. Operations to determine the composition of the details of the output information, the location of the details of the output information with the reflection of the control example, the description of the fields (the details of the output document are carried out as part of the following set of operations for setting the task
57. Determine the correspondence - 7 questions
58. The peculiarity of building an enterprise model, which consists in the hierarchical ordering of the selected elements of the system with the definition of the relationship between them, is inherent in the following method
59. The peculiarity of building an enterprise model, which consists in using a graphical representation of the relationship of system elements, is inherent in the following method
60. The peculiarity of building an enterprise model, which consists in dividing a complex system into parts, represented as "black boxes", each "black box" implements a certain function of the control system, is inherent in the following method
61. An evaluation factor in appearance for a business woman is
62. The first step to establishing a business acquaintance is
63. According to the protocol, when seating passengers, sits next to the driver
64. The concepts of "functional block", "interface arc", "decomposition", "glossary" are the main ones in the methodology
65. Representatives of departments for which applications are created, with the exception of the information systems group, are
66. The transformation of information into a form convenient for the user occurs in the process
67. When designing business cards, it is necessary to take into account that business cards are usually served
68. Greeting - one of the manifestations of politeness, is a special form of mutual respect. Such an element as a handshake came to us from time immemorial. At one time, he demonstrated the absence of _____ in his hands
69. The duration of the presentation should be
70. The negotiation process consists of
71. Working with a PC leads to (two correct answers)
72. Work to improve the forms of documents processed in the AIS circuit is carried out in the following direction of AIS development
73. Place the following AIS classes in chronological order of their appearance
74. A variety of AIS, which is characterized by a large amount of initial data and the simplicity of algorithms for their processing is called
75. A variety of AIS that provides data processing according to the optimization algorithm for solving an economic problem is called
76. A variety of AIS designed to generate new knowledge that is not explicitly contained in the source data is called
77. A variety of AIS designed to search and issue information at the request of the consumer is called
78. Development and implementation of methods for monitoring the reliability and completeness of data are carried out in the following direction of development of AIS
79. Rationalization of technical means in terms of bandwidth, the use of progressive tools in the technology of recording and storing information are carried out in the following direction of development of AIS
80. A Roman citizen could be recognized by such an obligatory type of clothing as
81. From the point of view of microeconomic theory, information technologies should affect the size of contracts of firms using them as follows
82. From the point of view of microeconomic theory, information technologies should affect the size of management costs of firms using them as follows
83. From the point of view of microeconomic theory, information technology should affect the number of middle managers and employees as follows
84. From the point of view of microeconomic theory, information technologies affect the size of contracts of firms using them as follows
85. From the point of view of microeconomic theory, information technologies affect the size of management costs of firms using them as follows
86. Information fixed on a material carrier in a formalized form is called
87. Information fixed on a material carrier in a formalized form is called
88. Information that reduces the a priori uncertainty of the user in any area is called
89. Reducing time spent (due to automation of management) for information processing should lead to
90. Improvement and development of new data processing software are carried out in the following direction of AIS development
91. According to Moore's rule, the computing power of computers doubles every
92. Drawing up a list of input information and the composition of the details of each type of input information, the location of the details of the input information, a description of the fields (the details of the input documents are carried out as part of the following set of task setting operations
93. Compilation of a list of input information and the composition of the details of each type of input information, the location of the details of the input information, a description of the fields (the details of the input documents are carried out as part of the following set of task setting operations
94. Information systems personnel who communicate between the information system group and the rest of the organization are
95. Information systems employees who communicate between the information system group and the rest of the organization are
96. Information systems employees who develop computer software are
97. The combination of equipment (computers, software, procedures, documentation, forms and personnel responsible for the entry, movement, management and distribution of data and information is
98. The combination of equipment (computers, software, procedures, documentation, forms and personnel responsible for the entry, movement, management and distribution of data and information is
99. The specifics of interaction is that each of its participants retains its autonomy and can ensure self-regulation of its communicative actions. R. Bales combined the observed patterns of interaction into four global categories that fix the form of interaction: Group the following areas of interaction and the main behavioral manifestations
100. The standard abbreviation "p.c. (pour condoleance)", which is usually done with a simple pencil in the lower left corner of the card, means _____. (write one or two words)
101. Students complete 5 computer science tests. For each test, you can get from 0 to 10 points. If at least 6 points are received for test No. 3, then this result is increased by 20%. If the total number of points obtained during testing is less than 20, then this corresponds to a score of "2"; score "3" corresponds to the number of points from 20 to 29; score "4" - from 30 to 39; grade "5" - 40 points and above. Sort in the spreadsheet by the Grade column in descending order. Determine the total number of students who received grades "3" and "2"
102. Students complete 5 computer science tests. For each test, you can get from 0 to 10 points. If at least 6 points are received for test No. 3, then this result is increased by 20%. If the total number of points obtained during testing is less than 20, then this corresponds to a score of "2"; score "3" corresponds to the number of points from 20 to 29; score "4" - from 30 to 39; grade "5" - 40 points and above. Enter the source data into the spreadsheet (words can be abbreviated)
103. Students complete 5 computer science tests. For each test, you can get from 0 to 10 points. If at least 6 points are received for test No. 3, then this result is increased by 20%. If the total number of points obtained during testing is less than 20, then this corresponds to a score of "2"; score "3" corresponds to the number of points from 20 to 29; score "4" - from 30 to 39; grade "5" - 40 points and above. According to the original table, establish a correspondence between the names of students: 1) Serova T.V., 2) Bondarenko D.A., 3) Golubev V.V. and the colors of the graphs built according to their estimates
104. Students complete 5 computer science tests. For each test, you can get from 0 to 10 points. If at least 6 points are received for test No. 3, then this result is increased by 20%. If the total number of points obtained during testing is less than 20, then this corresponds to a score of "2"; score "3" corresponds to the number of points from 20 to 29; score "4" - from 30 to 39; grade "5" - 40 points and above. Sort in the spreadsheet by the Grade column in descending order. Determine the total number of students who received grades "3" and "2". Answer: _____
105. Students complete 5 computer science tests. For each test, you can get from 0 to 10 points. If at least 6 points are received for test No. 3, then this result is increased by 20%. If the total number of points obtained during testing is less than 20, then this corresponds to a score of "2"; score "3" corresponds to the number of points from 20 to 29; score "4" - from 30 to 39; grade "5" - 40 points and above. Enter the original data into the spreadsheet (words can be abbreviated). Enter formulas into the spreadsheet to calculate: – the values in columns G and H (use the logical function "IF"); - the average value in cell G15. According to the calculations, establish a correspondence between the following participants of the Olympiad: 1) Bondarenko D. A., 2) Ignatiev S. A., 3) Kudinov V. S. and the number of points they scored
106. The theory of communication is being developed by a number of sciences, in particular
107. The type of letter below: “Please let us know when and under what conditions you can supply us with 200 sets of equipment” is of type _____. (two words, in the nominative case)
108. A typical issue solved by decision support systems, which is the ability to record, execute, save for later use, regularly executed series of commands and messages is formulated as _____ _____. (write two words
109. A typical issue solved by decision support systems, which is the ability to record, execute, save for later use a regularly executed series of commands and messages, is formulated as command _____
110. A typical question solved by decision support systems, which consists in identifying for the selected resulting variable all input variables that affect its value, and estimating the amount of change in the resulting variable for a given change in the input variable, for example, by 1%, is formulated as an analysis of _____
111. A typical question solved by decision support systems, which is to combine the results obtained from different forecasts or for different models, is formulated as
112. A typical question solved by decision support systems, which is to combine the results obtained from different forecasts or for different models, is formulated as _____
113. A typical question solved by decision support systems, which consists in assessing the change in output variables with random changes in input values, is formulated as an analysis of _____
114. A typical question solved by decision support systems, which is to find the values of controlled input variables that provide the best value for one or more resulting variables, is formulated as _____
115. A typical question solved by decision support systems, which consists in directly entering previously available data into the model and manipulating them when forecasting, is formulated as an analysis of _____
116. A typical problem solved by decision support systems, which is the direct input into the model of previously available data and the manipulation of them in forecasting, is the analysis of _____
117. A typical question solved by decision support systems, which is to compare the results of two or more forecasts made with different input assumptions, or to compare the predicted results with the actual ones, is called _____
118. A typical issue solved by decision support systems is to study the behavior of the resulting variables depending on the change in the values of one or more input variables
119. A typical issue solved by decision support systems, which consists in studying the behavior of the resulting variables depending on the change in the values of one or more input variables, is the analysis
120. A typical issue addressed by decision support systems is to find the values of an input variable that provide the desired end result is
121. A typical problem solved by decision support systems, which is to find values of an input variable that provide the desired end result, is the analysis
122. A typical problem solved by decision support systems, which consists in estimating the values of output quantities for a given set of values of input variables, is
123. A typical issue addressed by decision support systems, which is to evaluate the behavior of output quantities when the values of input variables change, is
124. Specify the correct sequence of stages in the design of automated information systems
125. Indicate the correct sequence of stages in the design of forms of input and output documents of AIS
126. Successful communication presupposes feedback – the receipt by the subject of information about the results of interaction. Establish correspondence between communication functions in the joint activities of workers in the labor process
127. Most often, difficulties in negotiations arise due to
No. 3038 Information technology management - 135 questions. ORIGiz156
1. (DB) is a collection of structured data stored in the memory of a computing system and reflecting the state of objects and their relationships in the subject area under consideration
2. ... is a set of special software tools designed to manage the loading, launch and execution of other (user) programs, as well as to manage computer computing resources called
3. An automated system, which is a software package that includes an array of legal information and tools for working with it, is called
4. An alphabetical list of descriptors with their dictionary entries is called
5. A database stored in different nodes of a computer network and logically connected in such a way as to constitute a single set of data is called
6. An intra-company or inter-company computer network with enhanced capabilities due to the use of Internet technologies in it is called
7. A dedicated workstation for organizing multicast facsimile communication, with several fax-modem cards is called
8. A dedicated workstation for organizing e-mail, with electronic mailboxes is called
9. Computing systems with limiting characteristics of computing power and information resources are called
10. An urban or rural settlement, municipal district, urban district or intra-urban territory of a city of federal significance is called
11. A group of keywords that are equivalent or close in meaning is called
12. Documented information, access to which is limited in accordance with the legislation of the Russian Federation, is called
13. The sufficiency of information for making a decision is called
14. Availability of information - this is the degree of the possibility of obtaining information is called
15. Task. The study of age-related criminal activity presents data reflecting the relationship between age and change in the percentage of persons who committed a crime. Information about age-related criminal activity
16. The conclusion of transactions for the purchase or sale of securities or foreign exchange assets via the Internet, in real time is called
17. Fill in the charts
18. Fill in the table
19. Registered signals, observations are called
20. Information recorded on a material carrier with details that allow it to be identified is called
21. Changing any signal parameter in the communication channel in accordance with the current values of the transmitted data is called
22. Integrated information management systems for a geographically distributed corporation based on in-depth data analysis, widespread use of information decision support systems, and electronic office work are called
23. Information system - a single repository of documents with tools for searching and issuing documents necessary for the user is called
24. An information system, which is a comprehensive integrated automated information system designed for information and analytical support of state and municipal governments, is called
25. Information technology, as a system of methods and ways of transmitting, processing, storing, and providing information based on the use of technical means, is called
26. Picture
27. Picture
28. Picture
29. Picture
30. Picture
31. Picture
32. Picture
33. Picture
34. Picture
35. Picture
36. Commercial activity aimed at making a profit and based on the complex automation of the commercial cycle through the use of computer networks is called
37. A set of language and software tools designed to create, maintain and share databases with many users is called
38. A computer (program) that uses a specific resource in a computer network is called
39. A computer (program) that manages a specific resource in a computer network is called
40. A computer that has direct access to the global network is called
41. The computer through which the user accesses network resources is called
42. Computers, which are computing systems designed to organize a multi-user environment, are called
43. Models involving the organization of interaction between authorities and citizens are called
44. The data model of a certain subject area, which is a set of relationships that change over time, is called
45. A model involving the organization of state and municipal procurement via the Internet is called
46. The model that involves the provision of information and services by state and municipal authorities to business entities and entrepreneurs through state and municipal Internet portals is called
48. A set of devices and programs that allows you to effectively organize the procedures for creating, accumulating, storing, processing and sending electronic documents is called
49. The most significant words and phrases that have a naming function for displaying the content of a document are called
50. The largest theoretically achievable amount of information that can be transmitted through the system per unit of time is called
51. The accumulated information about the surrounding reality, recorded on material carriers that ensure the transfer of information in time and space between consumers to solve specific problems is called
52. The presence of information in excess of what is necessary to achieve the goal of perception is called
53. The science of managing, communicating and processing information is called
54. Some digital information that is the real equivalent of paper money is called
55. Some formalized semantic system designed to express the content of a document and a search query is called
56. Providing a client with the ability to manage a bank account via the Internet based on electronic payment systems is called
57. The inverse transformation of a modulated signal into a modulating signal is called
58. The objective unity of objects, phenomena, information, knowledge about nature, society naturally related to each other is called
59. Match the 19 questions
60. An organizationally ordered set of documents (arrays of document and information technologies, including using computer technology and communication tools that implement information processes is called
61. Organizational, socio-economic and scientific and technical process of creating optimal conditions for meeting information needs and exercising the rights of citizens, public authorities, local governments, organizations - _____
62. The organization of textual information, in which the text is a set of fragments with explicitly indicated associative links between these fragments, is called
63. Individual documents and individual arrays of documents, documents and arrays of documents in information systems (libraries, archives, funds, data banks, other information systems) are called
64. A data packet (message) that contains in its header the information necessary to transmit it from the source to the recipient, regardless of all previous and subsequent messages, is called
65. A pair of programs interacting with each other according to certain rules is called
66. A subsystem, about which it is known only what data enters its input and what data is obtained at the output; about the same way the data is processed inside it, nothing is known
67. Designed to process requests from all network workstations, a multi-user computer that provides these stations with access to shared system resources is called
68. A software and hardware complex that provides the collection, storage, analysis and provision of territorially coordinated data based on electronic geographical maps is called
69. A software and hardware complex designed to process documents and automate the work of users in control systems is called
70. Programs designed to organize facilitated user interaction with a computer system in a windowed dialog mode are called
71. The processes of collecting, processing, accumulating, storing, searching and disseminating information are called
72. A high-power computer operating on a network that has software (applications) that network clients can work with is called
b) Retelling of the text
Instruction: Listen carefully to the story and get ready to retell it.
"GALKA AND DOVES"
The jackdaw heard that the pigeons were well fed. She turned white and flew into the dovecote. Pigeons did not recognize her and accepted. But the jackdaw could not stand it and screamed like a tick. The pigeons understood everything and kicked her out. Then she returned to her. But they also did not recognize her and kicked her out.
At the end of the retelling, questions are asked to judge how much the child understood the meaning of the situation:
- why didn't they recognize the jackdaw as their own?
- Did you like the behavior of the jackdaw and why?
Criteria of semantic adequacy and independence of implementation.
15 points - correct and independent retelling, correct understanding of the meaning of what is happening;
10 points - an inaccurate description of the situation with correct answers to questions indicating an understanding of the hidden meaning, or a correct and complete description of the situation with an understanding of the meaning after clarifying questions;
5 points - a correct description of the situation with a literal understanding of the meaning of the story, even after clarifying questions;
0 points - distortion of the situation during retelling, inadequate interpretation of the meaning even in the conditions of assistance.
Criteria for the possibility of text programming.
15 points - the retelling contains all the main semantic links in the correct sequence, there are connections between them, there are no difficulties in switching;
10 points - omission of individual semantic links or the absence of connecting links, or unjustified repetitions of the same type of connecting element;
5 points - a tendency to text fragmentation, to enumeration of events without a generalizing storyline, repeated unreasonable repetitions of words or grammatical structures (stereotypical design), the need for leading questions to build a text, or a combination of several errors from the previous paragraph;
0 points - the impossibility of constructing a coherent text even with help in the form of questions;
Grammar criteria.
15 points - the retelling is grammatically correct using complex and diverse grammatical structures;
10 points - the retelling is grammatically correct, but monotonous, or there are violations of word order;
5 points - there are single non-rough agrammatisms or paragrammatisms (non-compliance with grammatical obligations);
0 points - multiple agrammatisms.
Criteria for lexical design.
15 points – adequate use of verbal means;
10 points - search for words using unproductive vocabulary or single close verbal substitutions;
5 points - pronounced poverty of the dictionary, repeated verbal substitutions (semantically close), distortion of the sound composition of the word (“knocked out” instead of “kicked out”, “primrose” instead of “accepted”, etc.);
0 points - distant verbal paraphasias, inadequate use of verbal means.
Total score for the task with the most successful execution is equal to 60 points.
As additional marks that do not affect the score for the series, but are taken into account when calculating the indices, the following are calculated:
1. The number of verbal substitutions, i.e. substitutions of one word for another, often semantically close (for example, "swans" instead of "pigeons", "saw" instead of "heard", etc.). This type of error is evaluated on a 15-point scale with a negative sign. The penalty score is included in the back index. To convert the number of errors into points, the following scale is used:
0 points - in the absence of errors or one error;
5 points - for 2 - 3 mistakes;
10 points - for 4 - 5 mistakes;
2. Average text length. It is determined by the total count of words in both texts (all words are taken into account, including service words) and dividing the result by 2. The resulting number correlates with the score:
15 points - 32 words or more;
10 points - 25-31.9 words;
5 points - 18-24.9 words;
0 points - 17 or less words.
We included this indicator in the front index with a “+” sign. The short length of the text indicates the difficulties of semantic programming and grammatical structuring.
3. Index of pronominalization. It is the ratio of the proportion of pronouns to the proportion of nouns. To calculate this indicator, the total number of pronouns in both texts should be divided by the total number of nouns, and the result should be divided by 2. The average value of pronominalization indices is presented in the table of average group indicators of additional assessments. This parameter is not included in any of the indexes, but may be useful in qualitative analysis of the results. A high pronominalization index, as a rule, is observed when the paradigmatic connections of the language, based on the work of the posterior parts of the brain, are weakened. Difficulties in choosing the right word in this case are compensated by the use of pronouns. We do not offer a scoring for this indicator. For younger students, an index of 1.0 and above can be considered relatively high, and low - less than 0.7.
4. The average length of the syntagma (the segment of speech between two pauses). It is calculated by dividing the total number of words in two independent texts by the number of syntagmas, the result is divided by 2. The average length of syntagmas for each group is presented in the table of average group indicators of additional assessments. A value above the average can be conditionally assessed as a large, and below - as a small length of the syntagma. The short length of syntagmas indicates syntagmatic difficulties, i.e. functional insufficiency of the anterior parts of the cerebral cortex. the parameter is not included in the indices, but is used for qualitative analysis.
5. Stereotypical grammatical formulation of the statement. The number of stereotyped grammatical constructions is counted. Assessed through a scoring system:
0 points - for 0-1 mistake;
5 points - for 2-3 mistakes;
10 points - for 4-5 mistakes;
15 points - for 6 or more mistakes.
A large number of such errors indicates inertia, difficulties in grammatical structuring, which can be regarded as a manifestation of "front" problems. The indicator is also not included in the indices, but can be used in the qualitative interpretation of data.
Russian leaders
1.1. The competition is held in three stages. At each stage, participants complete tasks and undergo a comprehensive assessment of competencies.
1.2. A unique set of tasks has been developed for each stage:
1.2.1. Qualifying online stage - potential test. It is carried out by all participants who have passed the survey (selection according to formal criteria).
1.2.2. Face-to-face semi-final - assessment conference for group work assessment, business profile test for individual assessment.
1.2.3. Face-to-face final - evaluation conference to evaluate group work; conducting peer assessments for individual assessment.
1.3. The criterion for evaluating participants is the level of manifestation by them during the performance of competitive tasks of five managerial competencies and leadership skills, such as:
- Leadership: the ability to see the big picture, compare alternatives, make strategic decisions.
- Making informed decisions: analysis of information, taking into account various aspects of solving a problem (including financial and economic ones), working with various stakeholders, argumentation when expressing one's point of view.
- Result orientation: a clear definition of priorities, the ability to make assumptions and make decisions in conditions of lack of information and time.
- Teamwork: distribution of roles and responsibilities, determination of the sequence of tasks to achieve the goal.
- Communication: the ability to work with the multidirectional interests of stakeholders, show team leadership, the ability to unite and motivate people.
1.4. According to the results of each task, the participant receives points that form the value of his individual rating.
1.5. Based on the results of the selection, the participants with the highest rating go to the next stage. The rating of participants is announced publicly on the Competition website.
2. The mechanics of the online qualifying stage
2.1. The qualifying stage begins after the end of the collection of applications for participation simultaneously for all persons registered on the site.
2.2. Persons who have completely filled out the registration form for participation in the competition and meet the formal participation criteria, which are given in the Regulations for this Competition, are allowed to the qualifying stage.
2.3. Participants are given one week to complete the potential test. In this case, the participant can start the test at any time.
2.4. As part of the qualifying stage, the participant must pass a test to identify leadership competencies.
2.5. One participant can take the test only once.
2.6. Time to pass the test is strictly limited.
2.7. The following competencies are assessed during the capacity test:
- Speed of thinking: speed of thinking, the ability to quickly process information in standard situations according to given instructions and patterns.
- Critical thinking: depth of thinking, the ability to draw correct causal conclusions in the presence of ambiguous conditions and many solutions.
- Motivation for development: ability to draw conclusions, improve own results.
- Openness of thinking: effective decision-making in conditions of uncertainty, the ability to act rationally, overcoming one's own stereotypes, to rebuild and adapt to new conditions.
- Motivation for leadership: willingness and desire to take on managerial positions and bear the costs that lead people.
- Social intelligence: the ability to understand other people, determine their motives and feelings and influence them without the use of administrative levers.
- Drive: purposefulness, willingness to achieve results, ambitious goals, perseverance in overcoming barriers and responsibility for the result.
2.9. Based on the results of the test, the participants who scored the maximum number of points are selected. Objectivity is ensured by assessing the results not on a fixed scale, but in relation to the results of other participants who take the test. All test results are automatically checked against the correct answers, and a point is assigned for the correct answer.
2.10. Selection transparency. The results of the selection will be publicly published. Based on the results of the testing, each participant gets access to the rating, where he can see his own results and the results of other participants.
2.11. The maximum score for the test is 100 points (the score of the best participant).
2.12. Feedback is sent to participants automatically in the form of a .pdf report on the test competencies, indicating strengths and weaknesses and further recommendations for improving results.
2.13. The participant can dispute his results by sending an application to the e-mail address of the organizers within three days from the date of official receipt of the results. The application must indicate the motive for challenging and the vision of the correct results. In response, to substantiate the results, the performer can give up to three answers to the question of each competence.
3.
The mechanics of the semi-finals
3.1 300 participants who have taken the highest places in the rating according to the results of the selection test in each of the federal districts are invited to the semi-finals.
3.2 Based on the results of the qualifying round, “waiting lists” are formed
of the participants with high rating values, but not included
to the number of semi-finalists due to the limited number of participants. If a semi-finalist included in the list of invitees from a given federal district refuses to take part in the semi-finals, he is replaced by a participant from the "waiting list" with the highest rating.
3.3 Semi-final stages are held in person in the center of each of the eight federal districts: Moscow, Nizhny Novgorod, St. Petersburg, Pyatigorsk, Yekaterinburg, Rostov-on-Don, Novosibirsk and Khabarovsk.
3.4 The mechanics of the full-time semi-final stage for each federal district is the same and is an assessment conference and a test to assess individual skills. As part of the assessment conference, participants are invited to solve a real business or social problem (case) in teams.
3.5 Assessment Conference aims to test the following competencies:
- leadership;
- making informed decisions;
- result orientation;
- teamwork;
- communications, etc.
3.4.2 The Assessment Conference consists of a sequence of steps:
Step 1: Divide the participants into teams of 6-10 people. Teams are divided into zones and receive a case assignment. Time - 15 minutes.
Step 2: assigning one assessor to each team, who evaluates the individual achievements of the participants in accordance with the selected competencies, and one volunteer who helps the participants. Time - 5 minutes.
Step 3: the work of the participants with the task of the case in a team. All participants study the task of the case, mark useful information. Time - 15 minutes.
Step 4: group work with a case assignment. Participants start discussing the case as a team. Time - 60 minutes.
Step 5: Preparing the decision and presentation. Participants draw up a decision on a flipchart and prepare for the presentation. Time - 30 minutes.
Step 6: performance of teams in mini-clusters. All participants are divided into three mini-clusters of five teams. In each cluster, teams perform and evaluate them. 5 minutes are allotted for the presentation. Evaluation is made by voting teams. The best team in the cluster is selected based on the number of votes received. The opinions of all participants are taken into account, which ensures transparency in the selection of the best solution and team. The winning team has the opportunity to refine their decision based on feedback from other teams. Time - 30 minutes.
3.4.3 The procedure for evaluating the results:
1. Evaluation of group work on the case. It is carried out by assessors using evaluation sheets, where they mark the most active participants on a scale from 0 to 3 according to specified criteria.
2. Evaluation of the public presentation of the best decisions in front of the judges. The winning teams from each cluster present their decision to the judges. Evaluation is performed on the basis of evaluation sheets for each team by assigning points from 0 to 3 according to the selected criteria. Three teams are compared according to their points, the team with the most points wins. Time - 30 minutes.
3.4.4 The maximum score for the evaluation conference is 200 points (a 3-point score from assessors for each of the five competencies is translated into a 40-point scale, scores for all competencies are summed up) plus 20 points for each participant - the winner in the presentation of the solution to the judges.
3.6 Performing an individual business profile test to assess potential. The test can only be taken once in the allotted time. Participants' responses are compared to benchmark responses on the test. For each correct answer, the participant receives a point.
3.5.1 The performer performs the calculation of the results and receives a list of participants with their scores for the test.
3.5.2 According to the results of the test, the participants who have scored the maximum number of points are selected.
3.5.3 Passing conditions: participants pass the test in a limited time, they can do it only once using a unique link sent to them.
3.5.4 Transparency of the selection: the results of the selection will be publicly published.
3.5.5 The maximum score for the test is 100 points (the score of the best participant).
3.5.6 Feedback is sent to participants automatically in the form of a report based on the results of completing the test.
3.7 The results of the semi-final are the total mark for participation in the evaluation conference and passing the test.
3.8 The maximum score that a participant can have by the end of the semi-final is 390 points.
4.4 Assessment Conference. The mechanics are similar to the mechanics of the semi-final selection.
4.5 Evaluation of colleagues represents the assessment of each participant by his teammates. Time to conduct - 25 minutes. Format - participants fill out an online assessment form.
4.5.1 Participants evaluate each other on all aggregated criteria based on their overall impression of their participation in the final competition.
4.5.2 Evaluation is carried out after the team task in their teams of 10 people with one assessor and one volunteer. Everyone receives an assessment from all teammates with whom he participated in the assessment conference. Time - 5 minutes.
4.5.3 Mechanics consists of the following steps:
Step 1: Each participant has access to an electronic assessment form and assessment instructions. Time - 10 minutes.
Step 2: The participant selects the number of his team in the grading form and gives each team member a score from 0 to 3. Assessors control that the participants do not interact with each other during grading. Time - 10 minutes.
Step 3: summarizing the evaluation of colleagues occurs automatically in the system. The final score for each participant is the average score of all his colleagues and is measured in points from 0 to 3. Time - 30 minutes.
4.5.4 Maximum score: 50 points (3-point assessment of colleagues is translated into a 50-point scale, marks for all competencies are summed up).
4.6 The results of the final are the total score for the evaluation conference (individual score for teamwork based on the results of assessors' observation, the group score of the winning teams for the presentation of the solution) and the results of evaluation of colleagues.
4.7 The maximum score that a participant can have by the end of the final is 1000.
4.8 At the end of the final selection, all results are entered into the rating table for each participant. Based on the results, 100 best participants are selected in accordance with the rating.
