AVSD settlements are connected by time roads. Test tasks for self-control
1. Choose the correct statement:
- a) One object can have only one model
- b) Different objects cannot be described by the same model
- c) An electrical circuit is a model of an electrical circuit
- d) The model completely repeats the object under study
2. Choose the wrong statement:
- a) Full-scale models - real objects, in a reduced or enlarged form, reproducing the appearance, structure or behavior of the modeled object
- b) Information models describe the original object in one of the information encoding languages
- c) Dynamic models reflect the processes of change and development of objects in time
- d) Only the subject area to which they belong can be taken as the basis for classifying models.
3. What features of the object should be reflected in the student's information model, which allows obtaining the following information: the age of students who are fond of swimming; the number of girls involved in dancing; surnames and names of students over 14 years old?
- a) name, surname, hobby
- b) first name, last name, gender, singing, swimming, age
- c) name, hobby, gender, age
- d) name, surname, gender, hobby, age
4. Select the element of the student's information model that is relevant for scoring the student on the computer science test:
- a) having a home computer
- b) the number of correctly completed tasks
- c) the time spent on the performance of the control work
- d) average score for previous computer science lessons
5. Replacing a real object with its formal description is:
- a) analysis
- b) modeling
- c) formalization
- d) algorithmization
6. Select iconic model:
- a) drawing
- b) scheme
- c) table
- d) formula
7. Select figurative model:
- a) photograph
- b) scheme
- c) text
- d) formula
8. Choose mixed model:
- a) photograph
- b) scheme
- c) text
- d) formula
9. Descriptions of objects, situations, events, processes in natural languages are:
- a) verbal patterns
- b) logical models
- c) geometric models
- d) algebraic models
10. Models implemented using programming systems, spreadsheets, specialized mathematical packages and modeling software are called:
- a) mathematical models
- b) computer models
- c) simulation models
- d) economic models
11. The file system of a personal computer can most adequately be described as:
- a) mathematical model
- b) tabular model
- c) natural model
- d) hierarchical model
12. The graphical model of a hierarchical system is:
- a) chain
- b) network
- c) family tree
- d) tree
13. The timetable for electric trains can be considered as an example:
- a) tabular model
- b) graphic model
- c) simulation model
- d) natural model
14. What is the triplet of concepts in the relationship "object - full-scale model - information model"?
- a) human - anatomical skeleton - mannequin
- b) person - medical record - photograph
- c) car - an advertising booklet with the technical characteristics of the car - an atlas of roads
- d) car - toy car - technical description of the car
15. The diagram shows the roads between settlements A, B, C, D and the length of these roads.
Determine which two points are the farthest from each other. Specify the length of the shortest path between them.
- a) 17
- b) 15
- c) 13
16. Settlements A, B, C, D are connected by roads. The travel time by car from city to city on the corresponding roads is indicated in the table:
A tourist leaving point A wants to visit all the cities in the shortest possible time. Specify the appropriate route.
- a) ABCD
- b) ACBD
- c) ADCB
- d) ABDC
17. Four students study at the school - Andreev, Ivanov, Petrov, Sidorov, who have different hobbies. One of them is fond of tennis, the other - ballroom dancing, the third - painting, the fourth - singing. Known about them:
- Ivanov and Sidorov were present at the concert of the choir when their friend sang;
- Petrov and the tennis player posed for the artist;
- the tennis player is friends with Andreev and wants to meet Ivanov.
What is Andreev interested in?
- a) tennis
- b) painting
- c) dancing
- d) singing
18. Two players play the following game. In front of them are three piles of stones, the first of which has 2 stones, the second - 3 stones, the third - 4 stones. Each player has an unlimited number of stones. The players take turns. The move consists in the fact that the player either doubles the number of stones in a heap, or adds two stones to each of the heaps. The player wins, after whose move either one of the piles becomes at least 15 stones, or the total number of stones in all three piles becomes at least 25. Who wins if both players play without mistakes?
- a) the player making the first move
- b) the player making the second move
- c) each player has the same chance of winning
- d) there is no winning strategy for this game
19. The database is:
- a) a set of data collected on a single floppy disk
- b) a table that allows you to store and process data and formulas
- c) application program for processing user information
- d) a set of data organized according to certain rules, intended for storage in the external memory of a computer and permanent use
20. What database is based on a tabular representation of information about objects?
- a) hierarchical
- b) network
- c) distributed
- d) relational
21. A table row containing information about one specific object is:
- a) field
- b) record
- c) report
- d) form
22. A table column containing a certain characteristic of an object is:
- a) field
- b) record
- c) report
- d) key
23. Database management systems are used for:
- a) creating databases, storing and searching for the necessary information in them
- b) data sorting
- c) organizing access to information in a computer network
- d) creating databases
24. Which word is NOT the name of a database?
- a) Microsoft Access
- b) OpenOffice.org Base
- c) OpenOffice.org Writer
- d) FoxPro
25. Below is a fragment of the database in tabular form:
What position will the product “Scanner flatbed” be in if this table is sorted in ascending order of the QUANTITY column?
26. Below in tabular form is a fragment of the database "Sale of stationery":
How many records in this fragment satisfy the condition PRICE>20 OR SOLD?
Size: px
Start impression from page:
transcript
1 Task 3. Formal descriptions of real objects and processes 3.1. Roads were built between settlements A, B, C, D, E, the length of which (in kilometers) is given 1) 5 2) 6 3) 7 4) Roads were built between settlements A, B, C, D, E, the length of which (in kilometers) is given 1) 7 2) 8 3) 9 4) Roads are built between settlements A, B, C, D, E, the length of which (in kilometers) is given 1) 9 2) 10 3) 11 4) Between settlements A, B, C, D, E built roads, the length of which (in kilometers) is given 1) 5 2) 6 3) 7 4) Roads were built between settlements A, B, C, D, E, the length of which ( in kilometers) is given
2 1) 8 2) 9 3) 10 4) Roads were built between settlements A, B, C, D, E, the length of which (in kilometers) is given 1) 9 2) 10 3) 11 4) Between settlements A, B, C, D, E roads are built, the length of which (in kilometers) is given 1) 9 2) 8 3) 7 4) Roads are built between settlements A, B, C, D, E, the length of which (in kilometers) is given 1) 4 2) 5 3) 6 4) Roads were built between settlements A, B, C, D, E, the length of which (in kilometers) is given 1) 6 2) 7 3) 8 4) Between settlements A, B , C, D, E roads are built, the length of which (in kilometers) is given
3 1) 5 2) 6 3) 7 4) Roads were built between settlements A, B, C, D, E, the length of which (in kilometers) is given 1) 6 2) 7 3) 8 4) Between settlements A, B, C, D, E roads are built, the length of which (in kilometers) is given 1) 6 2) 7 3) 8 4) Roads are built between settlements A, B, C, D, E, the length of which (in kilometers) is given 1) 6 2) 7 3) 8 4) Roads were built between settlements A, B, C, D, E, the length of which (in kilometers) is given 1) 4 2) 5 3) 6 4) Between settlements A, B , C, D, E roads are built, the length of which (in kilometers) is given
4 1) 7 2) 8 3) 9 4) Roads were built between settlements A, B, C, D, E, the length of which (in kilometers) is given 1) 13 2) 12 3) 11 4) Between settlements A, Roads B, C, D, E are built, the length of which (in kilometers) is given Determine the length of the shortest path between points A and F. You can only move along roads, the length is 1) 9 2) 11 3) 13 4) Between settlements A, Roads B, C, D, E are built, the length of which (in kilometers) is given Determine the length of the shortest path between points A and F. You can only move along roads, the length is 1) 5 2) 6 3) 7 4) Between settlements A, B, C, D, E, F roads are built, the length of which is given Determine the length of the shortest path between points A and F. You can only move along roads, the length
5 1) 5 2) 6 3) 7 4) Roads were built between settlements A, B, C, D, E, F, the length of which (in kilometers) is given Determine the length of the shortest path between points A and F. You can only move along roads, length 1) 5 2) 6 3) 7 4) Roads were built between settlements A, B, C, D, E, F, the length of which is given Determine the length of the shortest path between points A and F. You can only move along roads, length 1) 5 2) 6 3) 7 4) Roads were built between settlements A, B, C, D, E, F, the length of which is given Determine the length of the shortest path between points A and F. You can only move along roads, length 1 ) 6 2) 7 3) 8 4) Roads were built between settlements A, B, C, D, E, F, the length of which is given
6 Determine the length of the shortest path between points A and F. You can only move along roads, the length of 1) 6 2) 7 3) 8 4) Roads were built between settlements A, B, C, D, E, F, the length of which is given Determine the length of the shortest path between points A and F (assuming that you can only move along the constructed roads). 1) 5 2) 6 3) 3 4) Task Roads were built between settlements A, B, C, D, E, F, the length of which is given Determine the length of the shortest path between points A and F (provided that you can only move along constructed roads). 1) 5 2) 6 3) 7 4) Roads are built between settlements A, B, C, D, E, F, the length of which is given Determine the length of the shortest path between points A and F (provided that you can only move along the constructed roads).
7 1) 5 2) 7 3) 3 4) Roads were built between settlements A, B, C, D, E, F, the length of which is given Determine the length of the shortest path between points A and F (provided that you can only move along constructed roads). 1) 6 2) 8 3) 10 4) Ivan Tsarevich hurries to rescue Marya Tsarevna from the captivity of Koshchei. The table shows the length of the roads between the points through which he can pass. Specify the length of the longest section of the shortest path from Ivan Tsarevich to Marya Tsarevna (from point I to point M). You can only move along the roads indicated 1) 1 2) 2 3) 3 4) Ivan Tsarevich hurries to rescue Marya Tsarevna from Koshchei's captivity. The table shows the length of the roads between the points through which he can pass. Specify the length of the shortest section of the shortest path from Ivan Tsarevich to Marya Tsarevna (from point I to point M). You can only move along the roads indicated 1) 1 2) 2 3) 3 4) Petya Ivanov's relatives live in 5 different cities of Russia. The distances between cities are included in the table: Petya redrawn it in a notebook in the form of a graph. Assuming that the boy did not make a mistake when copying, indicate which graph Petya has in his notebook.
8 1) 2) 3) 4) Katya Yevtushenko has relatives living in 5 different cities of Russia. Distances between cities are included in the table: Katya redrawn it in a notebook in the form of a graph. Assuming that the girl did not make a mistake when copying, indicate which graph Katya has in her notebook. 1) 2) 3) 4) Teacher Ivan Petrovich lives at Antonovka station, and works at Druzhba station. In order to be in time for lessons in the morning, he must take the shortest road. Analyze the table and indicate the length of the shortest path from Antonovka station to Druzhba station: 1) 6 2) 2 3) 8 4) Teacher Marya Petrovna lives at Vasilki station and works at Druzhba station. In order to be in time for lessons in the morning, she must take the shortest road. Analyze the table and indicate the length of the shortest path from Vasilki station to Druzhba station: 1) 5 2) 6 3) 8 4) The rural ungraded school is located in the village of Ivanovskoye. Kolya Ivanov lives in the village of Vershki. Determine the minimum distance he needs to walk to get to school:
9 1) 6 2) 9 3) 12 4) The rural ungraded school is located in the village of Vershki. Roma Orlov lives in the village of Dalnee. Determine the minimum distance he needs to walk to get to school: 1) 6 2) 8 3) 11 4) Roads are built between settlements A, B, C, D, E, the length of which (in kilometers) is given 1) 4 2) 5 3) 6 4) The car driver must get from point A to point D in 5 hours. From the presented tables, select the one according to which the driver will be able to get from point A to point D in this time. The cells of the table indicate the time (in hours) it takes to get from one point to another. You can only travel on the roads indicated in the tables. 1) 1 2) 2 3) 3 4) The driver of the car must get from point A to point C in 6 hours. From the presented tables, select the one according to which the driver will be able to get from point A to point C in this time. The cells of the table indicate the time (in hours) it takes to get from one point to another. You can only travel on the roads indicated in the tables.
10 1) 1 2) 2 3) 3 4) Roads are built between settlements A, B, C, D, E, the length of which (in kilometers) is given Determine the length of the shortest path between points A and B. You can only move along roads, length 1) 4 2) 6 3) 10 4) Roads were built between settlements A, B, C, D, E, the length of which (in kilometers) is given Determine the length of the shortest path between points A and B. You can only move along roads, length 1) 1 2) 5 3) 3 4) Roads are built between settlements A, B, C, D, E, the length of which (in kilometers) is given Determine the length of the shortest path between points A and B (provided that it is possible to move only on built roads). 1) 11 2) 12 3) 13 4) Roads are built between settlements A, B, C, D, E, the length of which (in kilometers) is given Determine the length of the shortest path between points A and C (provided that you can only move built roads).
11 1) 6 2) 7 3) 8 4) Roads are built between settlements A, B, C, D, E, the length of which (in kilometers) is given Determine the length of the shortest path between points A and D. You can only move along roads, length 1) 5 2) 6 3) 7 4) Roads are built between settlements A, B, C, D, E, the length of which (in kilometers) is given Determine the length of the shortest path between points A and E. You can only move along roads, length 1) 4 2) 6 3) 8 4) Roads are built between settlements A, B, C, D, E, the length of which (in kilometers) is given Determine the length of the shortest path between points A and C. You can only move along roads, length 1) 3 2) 5 3) 8 4) Roads were built between settlements A, B, C, D, E, the length of which (in km) is given in the table. Determine the length of the shortest path between points A and C. You can only move along roads, the length is 1) 7 2) 8 3) 9 4) The driver of the electric train must get from point A to point C in 6 hours. From the presented tables, select the one according to which the driver will be able to get from point A to point C in this time. The cells of the table indicate the time (in hours) it takes to get from one point to another. You can only travel on the roads indicated in the tables.
12 3.48. The train driver must get from point A to point C in 4 hours. From the presented tables, select the one according to which the driver will be able to get from point A to point C in this time. The cells of the table indicate the time (in hours) it takes to get from one point to another. You can travel only on the roads indicated in the tables The table shows the cost of transportation between the five railway stations, marked with the letters A, B, C, D and E. Indicate the scheme that corresponds to the table.
13 3.50. The table shows the cost of transportation between five railway stations, labeled A, B, C, D, and E. Indicate the scheme that corresponds to the table.
Tasks 3. Formal descriptions of real objects and processes 1. A 1 B 1 2 2 7 C 2 3 D 2 4 E 7 3 4 which is indicated in 2. 4) 8 3. 1) 7 2) 8 3) 9 4) 10 4. 1) 9 2) 10 3) 11 4) 12 2019-04-28 1/20 5. 6. 1) 8
Tasks 3. Formal descriptions of real objects and processes 1. Task 3 3. Roads were built between settlements A, B, C, D, E, the length of which (in kilometers) A B C D E A 1 B 1 2 2 7 C
Tasks A3. Formal descriptions of real objects and processes
Option 1 1. Roads are built between settlements A, B, C, D, E, the length of which (in kilometers) is shown in the table. Determine the length of the shortest path between points A and E. You can move
Exercise. Information modeling (basic level, time min) Tasks for self-solving :) The diagram shows roads between five cities, and the lengths of the roads are indicated. Define,
Option 15 1. To receive a yearly grade in history, the student was required to write a report of 16 pages. Performing this task on a computer, he typed text in Windows encoding. How much memory (in
Starting control grade 10 Option 1 (Tasks 1-12 for 1 point) Part 1 (circle the number of the correct answer) 1. The editor-in-chief of the journal edited the article, and its volume was reduced by two pages. Each
Information Models What you need to know: It is useful to know what a graph is (it is a set of vertices and edges connecting them) and how it is described in the form of a table, although, as a rule, all the necessary explanations are given in
Demo version Informatics, Grade 9 TASK A. A1. The article typed on a computer contains 16 pages, each page has 32 lines, each line has 25 characters. Determine the information volume
Option 20 1 (592) In one of the editions of M.A. Bulgakov "Master and Margarita" 256 pages. What amount of memory (in MB) would this book take if Mikhail Afanasyevich typed it on a computer and saved
10. Information processing 10.1 Processed objects: strings of symbols, numbers, lists, trees. Tasks of the GIA 1. (2009) The table shows the cost of transportation between five railway stations, indicated
Tasks for movement towards and in opposite directions. Purpose: to form the ability to solve problems of this type. 1. Organizational moment. 2. Oral work. Calculate: The course of the lesson. a) 170+180; b) 330-90;
3. Analysis of information models Demonstration version of the USE 2018 task 3 In the figure on the right, the road map of the N-sky district is shown as a graph, the table contains information about the length of each
Option 1 1. The abstract typed on the computer contains 16 pages, each page has 50 lines, each line has 64 characters. Characters are encoded using the Unicode encoding, in which each
Demonstration version of the entrance test in grade 9 Task 1 To obtain an annual grade for the MHC, the student was required to write a report on 8 pages. While doing this task on the computer, he typed
Option 18 1 (590) To receive an annual grade in history, the student was required to write a report of 16 pages. Performing this task on a computer, he typed text in Windows encoding. What is the amount of memory
K. Polyakov, 009-06 (basic level, time min) Topic: Using information models (tables, diagrams, graphs). Enumeration of options, choosing the best for some reason. What you need to know: Basically,
OGE option 19 1 In one of the editions of the book by L.N. Tolstoy "War and Peace" 1024 pages. What amount of memory (in MB) would this book take if Lev Nikolaevich typed it on a computer in KOI-8 encoding?
The equation of motion. Uniform movement. 1. At 4 p.m., a train passenger drove past a kilometer post on which 1456 km was written, and at 7 a.m. the next day past a post with the inscription
MATHEMATICS, class, EMC 1 Option 1, May 2012 (EMC secondary school of the city (district), class OPTION 1 minutes. 1. When performing 1 - tasks, only answers must be indicated. When MATHEMATICS, class, EMC 1 Option 1, May 2012 2. From
Option 203243 1. B 3 404. Roads were built between settlements C, D, E, F, the length of which is given in the table: Determine the length of the shortest path between points and F. You can move
MATHEMATICS, grade 4 Option 1, April 2012 Secondary School of the city (district), grade 4 OPTION 1 1. Sixty thousand fifteen is ... 1) 60015 2) 6015 3) 6000015 4) 615 April 2012 2. Complete
Checking work in MATHEMATICS 5 CLASS Option 12 Instructions for performing work 60 minutes are given to complete the work in mathematics. The work contains 14 tasks. In tasks, after which there is a field with
Math testing. 6th grade. 2011 Option 1 Group A 1. Solve the equation: 8 x \u003d 3 A. 4 2 9 B. 2 C. 4 2 9 D. 3 2. Find the value of the expression 3 2 A. B. C. D. 3. Which of the numbers is greater 1 but less
Option 19. 1 (591) In one of the editions of L.H. Tolstoy "War and Peace" 1024 pages. What amount of memory (in MB) would this book take if Lev Nikolaevich typed it on a computer in encoding
Attention! The Moscow Methodological Commission for Informatics organizes seminars to prepare for the Olympiads. Schoolchildren of 7-8 grades are invited, who have become winners and prize-winners of the district stage of the All-Russian
Topic: Using information models (tables, charts, graphs). Enumeration of options, choosing the best for some reason. What you need to know: in principle, special additional knowledge, except for common sense
Diagnostic work 1. Option 0011 (without logarithms) October 3, 008 Instructions for performing the work 90 minutes are given to complete the work. The work contains 11 tasks (1B 9B, 10C, 11C). In tasks 1B
Variant 718051 1. Task 3 624. Teacher Ivan Petrovich lives at Antonovka station, and works at Druzhba station. In order to be in time for lessons in the morning, he must take the shortest road. Analyze
Speed. Time. Distance LESSON Task. Misha skied a distance of 80 m in 0 s, and Igor 45 m in 5 s. Which one was faster? (By distance we mean the length of the road connecting the beginning and
Spreadsheet Materials for the site on informatics Grade 9 (immersion 2) Teachers: Alexandrova T.A. Topic Know Be able Job bank What is a spreadsheet, the main parameters of spreadsheets,
Mathematics Movement problems 1. Write only the answers in the problems. a) A camel travels 35 km every hour. How fast is he going? b) A bee flies 6 m every second. What is the bee's speed? c)
K. Polyakov, 009 0 (basic level, time min) Topic: Using information models (tables, diagrams, graphs). Enumeration of options, choosing the best for some reason. What you need to know: Basically,
Task 1. Alphabet Quite recently, Lyosha began to study English at school. As often happens, in some aspects of the study of this subject he reached unsurpassed heights, while in others, on the contrary, he faced
Movement schedules 1. At the physical education lesson, Petya and Masha ran together along a straight path, starting from the school. Then Petya ran faster, and Masha went. After a while, the guys turned back at the same time
To make chains, beads marked with letters: A, B, C, are used. In the first place in the chain is one of the beads A, C,. On the second, any vowel if the first letter is a vowel, and any consonant if
The scientist Ivanov leaves Moscow for a conference at St. Petersburg University. The conference starts at 10:00. The table shows the schedule of night trains from Moscow to Saint Petersburg. train number
Option 1 1. The student during the week wrote down the time he spends on preparing lessons: Day of the week Mon Tue Wed Thu Fri Time (in minutes) 120 80 100 90 110
0 Topic: Using information models (tables, charts, graphs). Enumeration of options, choosing the best for some reason. What you need to know: in principle, special additional knowledge, except for common sense
Lesson 1 Speed. Time. Distance 1 Misha skied a distance of 8 m in 2 s, and Igor 45 m in 15 s. Which of them traveled a greater distance, and who less Who walked more time, and who less Who walked faster,
«How to get to us» By car From Odessa Drive along the Odessa-Nikolaev highway for about 45 km to the CENTER of Koblevo village. We pay attention to 2 significant points: 1. You need to get to
(basic level, time min) Topic: Use of information models (tables, charts, graphs). Enumeration of options, choosing the best for some reason. What you need to know: in principle, special additional
7m7 Speed. Time. Distance Tutorial L.G. Peterson, III class L.V. SELKINA, Candidate of Pedagogical Sciences, Associate Professor D.I. TARASOVA, student, Perm State Pedagogical University Goals:
Sheet 2 DEPARTMENT OF INDUSTRY AND TRANSPORT OF THE VORONEZH REGION (full name of the carrier) "APPROVED" (authorized official) MP (signature) (full name) 20 PASSPORT of the intermunicipal bus
Checking work in MATHEMATICS 5 CLASS Option 13 Instructions for performing work 60 minutes are given to complete the work in mathematics. The work contains 14 tasks. In tasks, after which there is a field with
Contents Topic: using information models (tables, diagrams, graphs).... Homework 0... 0 Topic: rafy. Pathfinding... 5 Homework 0... 7 Topic: Using Information Models
Checking work in MATHEMATICS 5 CLASS Option 14 Instructions for performing work 60 minutes are given to complete the work in mathematics. The work contains 14 tasks. In tasks, after which there is a field with
The computer science test Modeling and Formalization is intended for 9th grade students. The test contains 26 questions. There are answers at the end of the test.
1. Choose the correct statement:
a) One object can have only one model
b) Different objects cannot be described by the same model
c) An electrical circuit is a model of an electrical circuit
d) The model completely repeats the object under study
2. Choose the wrong statement:
a) Full-scale models - real objects, in a reduced or enlarged form, reproducing the appearance, structure or behavior of the modeled object
b) Information models describe the original object in one of the information encoding languages
c) Dynamic models reflect the processes of change and development of objects in time
d) Only the subject area to which they belong can be taken as the basis for classifying models.
3. What features of the object should be reflected in the student's information model, which allows obtaining the following information: the age of students who are fond of swimming; the number of girls involved in dancing; surnames and names of students over 14 years old?
a) name, surname, hobby
b) first name, last name, gender, singing, swimming, age
c) name, hobby, gender, age
d) name, surname, gender, hobby, age
4. Select the element of the student's information model that is relevant for scoring the student on the computer science test:
a) having a home computer
b) the number of correctly completed tasks
c) the time spent on the performance of the control work
d) average score for previous computer science lessons
5. Replacing a real object with its formal description is:
a) analysis
b) modeling
c) formalization
d) algorithmization
6. Select iconic model:
a) drawing
b) scheme
c) table
d) formula
7. Select figurative model:
a) photograph
b) scheme
c) text
d) formula
8. Choose mixed model:
a) photograph
b) scheme
c) text
d) formula
9. Descriptions of objects, situations, events, processes in natural languages are:
a) verbal patterns
b) logical models
c) geometric models
d) algebraic models
10. Models implemented using programming systems, spreadsheets, specialized mathematical packages and modeling software are called:
a) mathematical models
b) computer models
c) simulation models
d) economic models
11. The file system of a personal computer can most adequately be described as:
a) mathematical model
b) tabular model
c) natural model
d) hierarchical model
12. The graphical model of a hierarchical system is:
a) chain
b) network
c) family tree
d) tree
13. The timetable for electric trains can be considered as an example:
a) tabular model
b) graphic model
c) simulation model
d) natural model
14. What is the triplet of concepts in the relationship "object - full-scale model - information model"?
a) human - anatomical skeleton - mannequin
b) person - medical record - photograph
c) car - an advertising booklet with the technical characteristics of the car - an atlas of roads
d) car - toy car - technical description of the car
15. The diagram shows the roads between settlements A, B, C, D and the lengths of these roads are indicated.
Determine which two points are the farthest from each other. Specify the length of the shortest path between them.
a) 17
b) 15
c) 13
d) 9
16. Settlements A, B, C, D connected by roads. The travel time by car from city to city on the corresponding roads is indicated in the table:
Tourist leaving the point A wants to visit all the cities in the shortest time. Specify the appropriate route.
a) ABCD
b) ACBD
c) ADCB
d) ABDC
17.
Four students study at the school - Andreev, Ivanov, Petrov, Sidorov, who have different hobbies. One of them is fond of tennis, the other - ballroom dancing, the third - painting, the fourth - singing. Known about them:
- Ivanov and Sidorov were present at the concert of the choir when their friend sang;
- Petrov and the tennis player posed for the artist;
The tennis player is friends with Andreev and wants to meet Ivanov. What is Andreev interested in?
a) tennis
b) painting
c) dancing
d) singing
18. Two players play the following game. In front of them are three piles of stones, the first of which has 2 stones, the second - 3 stones, the third - 4 stones. Each player has an unlimited number of stones. The players take turns. The move consists in the fact that the player either doubles the number of stones in a heap, or adds two stones to each of the heaps. The player wins, after whose move either one of the piles becomes at least 15 stones, or the total number of stones in all three piles becomes at least 25. Who wins if both players play without mistakes?
a) the player making the first move
b) the player making the second move
c) each player has the same chance of winning
d) there is no winning strategy for this game
19. The database is:
a) a set of data collected on a single floppy disk
b) a table that allows you to store and process data and formulas
c) application program for processing user information
d) a set of data organized according to certain rules, intended for storage in the external memory of a computer and permanent use
20. What database is based on a tabular representation of information about objects?
a) hierarchical
b) network
c) distributed
d) relational
21. A table row containing information about one specific object is:
a) field
b) record
c) report
d) form
22. A table column containing a certain characteristic of an object is:
a) field
b) record
c) report
d) key
23. Database management systems are used for:
a) creating databases, storing and searching for the necessary information in them
b) data sorting
c) organizing access to information in a computer network
d) creating databases
24. Which word is NOT the name of a database?
a) Microsoft Access
b) OpenOffice.org Base
c) OpenOffice.org Writer
d) FoxPro
25. Below is a fragment of the database in tabular form:
What position will the product “Scanner flatbed” be in if this table is sorted in ascending order of the QUANTITY column?
a) 5
b) 2
at 3
d) 6
26. Below in tabular form is a fragment of the database "Sale of stationery":
| Name | Price | Sales |
| Pencil | 5 | 60 |
| Ruler | 18 | 7 |
| Folder | 20 | 32 |
| Pen | 25 | 40 |
| Notebook | 15 | 500 |
How many records in this fragment satisfy the condition PRICE>20 OR SOLD
a) 1
b) 2
at 3
d) 4
Answers to the computer science test Modeling and formalization
1-c, 2-d, 3-d, 4-b, 5-c, 6-d, 7-a, 8-b, 9-a, 10-b, 11-d, 12-d, 13- a, 14-d, 15-c, 16-d, 17-b, 18-a, 19-d, 20-c, 21-b, 22-a, 23-a, 24-c, 25-c, 26-in
The dirt road passes successively through the settlements A, B, C and D. The length of the dirt road between A and B is 40 km, between B and C - 25 km, and between C and D - 10 km. There is no road between A and D. Between A and C, a new asphalt highway 30 km long was built. Estimate the minimum possible time for a cyclist to travel from point A to point D if his speed on a dirt road is 20 km/h and on a highway 30 km/h.
Solution
For the convenience of the solution, we will build a graph connecting the settlements.
Let's find the time of movement between points.
1. From A to B(dirt road). The length is 40 km. Speed 20 km/h.
40: 20 = 2
Will take 2 hours.
2. From B to C(dirt road). The length is 25 km. Speed 20 km/h.
25: 20 = 1,25
It will take 1.25 hours.
3. From A to C(highway). The length is 30 km. Speed 30 km/h
30: 30 = 1
Will take 1 hour.
4. From C to D(dirt road). The length is 10 km. Speed 20 km/h.
10: 20 = 0,5
It will take 0.5 hours.
Possible movement options
ABCD = 2 + 1.25 + 0.5 = 3.75 hours
ACD = 1 + 0.5 = 1.5 hours
Answer: the minimum possible time for a cyclist to travel from point A to point B is 1.5 hours
