In a text editor, the execution of the copy operation becomes. The tests test both theoretical knowledge and practical skills of teachers in computer and information literacy. For the convenience of the teacher, the tests are divided into topics. What are we going to do

the ability to work rationally with information: know the features of information flows in your subject area, master the basics of analytical and synthetic processing of information;

mastering technologies for preparing pedagogical information products;

the use of new information and communication technologies and the possession of specific skills in the use of technical means both directly in the educational process and in independent work to improve professional qualifications.

126. In the Word text editor, the Copy operation becomes possible after:

A. setting the cursor to a certain position

B. file saving

B. Printing the file

D. highlighting a piece of text

127. The My Computer icon in Windows is used to:

A. access to the Internet

B. access to computer devices

B. access to user documents

D. turning off the computer

128. When formatting a text document,...

A. processing associated with changing the form of information, but not changing its content

B. processing associated with receiving new content, new information

B. processing related to printing of information

D. processing associated with changes in information content

129. The main characteristics of the processor include

A. amount of RAM

B. number of ports and their purpose

B. hard drive capacity

G. clock frequency

130. "The World Wide Web is a globally distributed... hyperconnected."

A. World Wide Web

B. operating system

B. email

D. information system

Literature:

Constitution of the Russian Federation Art. 43

Decree of the Government of the Russian Federation of March 19, 2001 No. 196 “On approval of the standard regulations on a general education institution” (as amended for 2009).

Decree of the Government of the Russian Federation of July 5, 2001 No. 505 “On approval of the Rules for the provision of paid educational services.”

Decree of the Government of St. Petersburg dated December 4, 2007 No. 1535 “On the program for the development of a regional system for assessing the quality of general education in St. Petersburg for 2008-2010.”

Dick N.F. Safety of the educational process and labor protection at school, lyceum. – Rostov-n/Don, Phoenix, 2007.

Dick N.F. Licensing, certification and accreditation of educational institutions. - Rostov-on-Don, Phoenix, 2007.

Bratchenko S.L. Introduction to humanitarian examination of education. - M., 19

EDUCATIONAL RESOURCES ON THE INTERNET

http://www.mon.gov.ru

Federal Service for Supervision in Education and Science

(Rosobrnadzor)

http://www.obrnadzor.gov.ru

Federal Agency for Education (Rosobrazovanie)

http://www.ed.gov.ru

Federal Agency for Science and Innovation (Rosnauka)

http://www.fasi.gov.ru

Priority national projects: website of the Council under the President of the Russian Federation for the implementation of priority national projects and demographic policy

http://www.rost.ru

National Training Foundation. Priority national

project "Education" and project "Informatization of the education system"

http://portal.ntf.ru

Russian education statistics

http://stat.edu.ru

Academy of Advanced Training and Professional Retraining of Education Workers of the Russian Federation

http://www.apkppro.ru

State Research Institute of Information

technologies and telecommunications (GNII ITT "Informika")

http://www.informika.ru

National accreditation agency in the field of education

http://www.nica.ru

Federal Institute of Pedagogical Measurements

http://www.fipi.ru

Federal Council for Textbooks of the Ministry of Education and Science of the Russian Federation

http://fsu.mto.ru

Federal Center for Educational Legislation

http://www.lexed.ru

Federal Testing Center

http://www.rustest.ru

Federal portal "Russian Education"

http://www.edu.ru

Russian general education portal

http://www.school.edu.ru

Information support portal for the Unified State Exam

http://ege.edu.ru

Natural science educational portal

http://www.en.edu.ru

Federal educational portal "Economics. Sociology.

Management"

http://www.ecsocman.edu.ru

Federal portal "Engineering Education"

http://www.techno.edu.ru

Federal portal "Social, humanitarian and political science"

education"

http://www.humanities.edu.ru/

Federal legal portal "Legal Russia"

http://www.law.edu.ru

Federal portal "Information and communication technologies

in education"

http://www.ict.edu.ru

Russian Open Education Portal

http://www.openet.edu.ru

Educational portal to support learning processes in the CIS countries

Tasks to complete

Run the program with the command Start LibreOffice LibreOffice Writer Programs.

Task 1: Converting text to a table

1. Open in the program LibreOffice Writer file created in a previous job.

2. Run the command

3. Enter the main title Working with tables, and under it the subtitle Table 1. List of friends.

4. Copy the bulleted list into the free space under the subheading. In each line of the list to the name using the key add the appropriate last name.

5. Select the list using the button Bulleted list on the panel Formatting give up the token and then execute the command Table Convert Text to Table. In the window of the same name, select the text separator Tabulation and press the button OK. You should end up with a table of two columns.

6. Add a header to the new table. To do this: select the first line and run the command Table Insert Rows Quantity – 1, Position – before OK.

7. Add a third column in the same way, selecting the second column and using the command Table Insert Columns Number – 1, Position – after OK.

8. Title the columns “First Name”, “Last Name” and “Phone” respectively.

9. Give a name and fill in the third column with the appropriate data.

10. Format the table using window commands Format Paragraph ( frame the table, match the fill to the first line, emphasize the characters of the first line).

Table 1. List of friends

Task 2. Creation and calculations in a simple table

1. Using a button (Table), located on the toolbar Standard, create a table of 8 rows and 4 columns according to the example of table 2 (names Column A, B, C, D, Cell addresses D2…D5 do not print).

2. In the table, carry out calculations in the last column D, where there is an “x” sign. To do this, place the cursor in the corresponding cell (with the expected result, for example in D2), using the menu command Table Formula enter formulas in the dialog box Formula(for example, for cell D2 you can enter the formula = *). When entering a cell address into a formula, use the technique of selecting the desired cell with the mouse, and enter the “*” operator from the keyboard. When you finish entering the formula, press the key .

Table 2. Calculation of equipment cost

(Column A Column B Column C Column D)

3. To calculate the total cost in a cell D5 use function Sum (Table Formula f(x) Sum) sum:(when entering a function argument with the mouse, you must select the desired range of cells) . Similarly, in cells D6, D7, D8, calculate the corresponding values, functions for which select from the category Table Formula f(x) Statistical.

4. Using a command Table AutoFormat o Format the table using one of the formats offered by the editor.

Task 3. Creating a complex table

1. Create a table of complex structure “Payment order”, presented as an example below. For this:

Enter a title in the empty space on the page Table 3. Payment order.

Create table using command Table Insert table of 8 columns and 15 rows. When inserting a table, a toolbar will appear Table(if the panel does not appear, install it using the View command Toolbars Table) .

Move the cursor to all panel buttons one by one Table and become familiar with their functions using tooltips next to the icons.

Alternately selecting groups of cells, combine them in accordance with the sample payment order (Table 3).

Table 3. Payment order

2. Fill in the text fields of the table.

3. Apply the desired alignment method (one of three), which is located in the command window Table Table properties On the page Vertical alignment. For cells with the text "Payer" ... "Recipient" apply text alignment Along the bottom edge, d for cells with the text "M.P." use alignment In the middle.

Task 4: Creating charts based on tables

1. Run the command Insert Break Page break OK.

2. On the new page, enter a title Building charts.

3. Create a diagram based on the data in the table. 4 about the average number of new car registrations per week in different cities of Russia. There is no need to type the table itself in Writer! For this:

Table 4. Weekly new vehicle registrations

Use command Insert Object Diagram. A basic diagram is inserted into the document (Fig. 3.1 a), with which a certain basic data table is associated (Fig. 3.2 a), and then it is configured with the necessary data.

Double-click the Basic Chart object (the toolbar will change) and execute the command Chart data table view.

In the window that opens Data table(Fig. 3.2.a) edit the data (Fig. 3.2.b) in accordance with table 4. In the window Data table place the cursor in the desired cell and enter the original data in place of the proposed ones. Thus, fill in 4 columns and 8 rows in accordance with the original table 4.

b)

A)

Rice. 3.1. Inserted diagram: a) basic, b) according to table data. 4.

7. Having completed editing, close the window and check the changes in the diagram.

8. Using Toolbar Commands Standard And Formatting add a title to the diagram, the name of the axes, the location of the legend (list of cities), and the color scheme of the plotting area (see Fig. 3.1 b).

Rice. 3.2. The “Data Table” window: a – with the proposed data, b – with the edited (original) data.

Task 5. Creating a Table of Contents

To create a table of contents in a document, you must:

1. Go to the beginning of the document and execute the command Insert Break Page break OK.

3. Assign styles to all headings that should be in the table of contents (select the text with the heading and select from the list of panel styles Formatting style Heading 1 or Heading 2). Style Heading 1 assign headings: Test text, Working with drawings, Working with formulas, Working with tables, Building charts. Style Heading 2 assign table headings 1, 2, 3.

4. Place the cursor at the beginning of the new page and activate the command Box Table of Contents and Indexes Table of Contents and Indexes. Get to know the window Table of contents and indexes and click on the OK button.

5. Make sure that a two-level table of contents is inserted with page numbers for the headings.

Changes to the table of contents after it has been created can be made using the command Update table of contents, located in the context menu of the table of contents.

Example of a control test "Text editor"

clipboard

A) Microsoft Excel; B) Microsoft Graph 2000; C) Microsoft Equation 3.0; D) Microsoft Diagram; E) WordArt.

23. In a text editor, performing the “Copy text” operation becomes possible after

A) Setting the cursor to a certain position; B) Saving the file; C) Printouts of the document; D) Selecting a text fragment; E) Table inserts.

24. Which of the following transformations cannot be done using the Font dialog box?

A) Make the letters slanted; B) Change the spacing between letters; C) Move text down or up relative to the line; D) Make the first letter in the line a Drop Cap; E) Add text animation.

End of work -

This topic belongs to the section:

Guidelines for SRSP classes

Ministry of Education and Science of the Republic.. Pavlodar State University named after Toraigyrov..

If you need additional material on this topic, or you did not find what you were looking for, we recommend using the search in our database of works:

What will we do with the received material:

If this material was useful to you, you can save it to your page on social networks:

Tweet

All topics in this section:

Spreadsheet Columns
A) are named by the user in an arbitrary manner; B) are designated by letters of the Russian alphabet; C) are designated by letters of the Latin alphabet; D) are numbered; E) are indicated by letters of the Greek alphabet.

Find the correct statement in MS Excel
A) The formula begins with the "=" sign, can contain up to 240 characters and must not contain spaces; B) The formula begins with the "=" sign and can contain up to 240 characters and spaces;

Specify the correct formula in MS Excel to find the maximum data value from the specified range
C) =MAX(A1:A3); B) =MAX(B1:B3); C) =MAX(A1:C1); D) =MAX(A1:C3); E) =MAX(C1:C3).

The working window is

Provide an absolute reference to the column name in the cell name
A) $A$1; B) $A1; C) A$1; D) A1; E) $$A1. 13. The information in the cell of the Excel table in the form of 99% is presented in the form of A) Fractional format; B) Monetary format; C) Percent

Cell ranges in Excel are indicated as follows
A) D3-H16; B) DЗ;Н16; C) D3+H16; D) D3/H16; E) D3:H16. 4. Find among the listed functions a function that belongs to the Date and Time category? A) IF; B) CO

The control line is
A) A string that contains the name of the application, the name of the active document and window control buttons; B) The current document window, through which you can view, create and edit a document; C)

To select data according to the desired criterion, use the command
A) Find; B) Format; C) Sampling; D) Filter; E) Criterion. 13. The information in a 5/3 Excel table cell is presented in A) Fractional format; B) Monetary

Specify a formula in MS Excel that tells the program that it is necessary to perform an operation on arrays
A) =A1*5; B) (=A1:D4*5); C) =IF(X<0;A1+2;A1+5); D) =А1/(В2+5); E) =SIN(B1)*3+C2. 22. Какая из перечисленных функций MS Excel определяет обратную матрицу? A)

The access emblem is
A) Text; B) Table; C) Schedule; D) W; E) Key. 20. Which object of the ACCESS DBMS allows you to create virtual tables consisting of calculated fields or fields taken from other tables

In MS Access, double-click a control in design mode
A) Changes its size and appearance; C) Calls up the properties window for this control; C) Calls up editing mode; D) Makes it stand out; E) Calls up the filtering mode. 23.

Table Wizard mode allows you to
A) Edit the structure of old tables; B) Create new tables; C) Enter data into a table; D) Print tables; E) Edit data in the table.

Sorting alphabetically is equivalent
A) Sort in descending order; B) Sorting by rows; C) Sorting by records; D) Sort in ascending order; E) Diagonal sorting. 18. What is a key? A) Od

The MS Access processing object is
A) Table; B) Database; C) Text file; D) A document containing data about real world objects; E) A database file with an arbitrary name and extension *.mdb. 24. Kaku

From the following list, select a data type that is not a Microsoft Access data type
A) Numeric; B) Text; C) Real; D) Monetary; E) Logical. 4. Table Wizard mode allows you to: A) Edit the structure of old tables; B) Create

In MS Access, in the New Report dialog box, the Report Wizard option
A) Allows you to create a report from scratch; B) Displays one record at a time in vertical format; C) Helps create a report by asking questions and using pre-designed templates; D) Displays several at once

A relational database file record may contain
A) Heterogeneous information (data of different types); B) Extremely homogeneous information (data of only one type); C) Text information only; D) Purely numerical information; E) Only

The backbone topology of information and computer networks is characterized by
A) The presence of many nodes connected to a central node that manages the flow of information and messages; B) A set of nodes connected into a closed system with control,

Internet is
A) Global computer network; B) User interface; C) Regional computer network; D) Hyperlink; E) Local computer network. 17. Word Wide Web (WWW or simply Web

Information protection is generally understood as
A) Ensuring the physical integrity of information, i.e. eliminating the possibility of distortion or destruction of information elements; B) Elimination of the possibility of substitution (modification) of information elements

A way to use the Internet, which allows for the instant transfer of files, documents, and programs over any distance, is
A) Search service; B) Email; C) Navigator; D) News; E) IP telephony. 21. What are protocols? A) Established and agreed rules for complete

A topology whose nodes are connected by lines to a central node is called
A) Tire; B) Volumetric; C) Star-shaped; D) Radial; E) Tabular. 4. In the NTERNET network and its services, the “To” and “Where” sections are separated by the sign: A) &; B) $; WITH

A set of hardware and software that allows computers to exchange data is
A) Highway; B) Interface; C) Data buses; D) Adapter; E) Computer network. 19. Which of the listed methods of connecting to the Internet provides the greatest opportunities for

The tasks presented on this page can be used to help 11th grade students prepare for the Informatics Olympiad. Real tests and tasks included in the set of Olympiad tasks were selected as examples. By using these tasks during a computer science lesson, you can help students determine how well they prepared for the Olympiad, which sections they should repeat, and what level of difficulty the computer science Olympiad tasks have.

But 11th grade students can also use assignments to prepare for the Informatics Olympiad for independent preparation. The correct answers to all questions and problems are listed at the bottom of this page.

Olympiad in Informatics 11th grade

Download the assignments by filling out the form!

After you provide the data, the download button will become active.

Test tasks

1. What are the names of programs that allow you to view Web pages?
A) Adapters
B) Operating systems
B) Browsers
D) Translators

2. What is HTTP?
A) A network connecting electronic bulletin boards
B) Hypertext Transfer Protocol
C) A group of messages dedicated to a specific topic
D) Computer connected to the network

3. What is needed to publish a Web site?
A) URL
B) User's mailing address
B) User's email address
D) Username and password

4. What can be used as an object when creating a hyperlink?
A) Provider company
B) Network protocol
B) Picture
D) Tag

5. If, when searching for information, you are not sure of the spelling of the word BEAR, then which search option is suitable for this case?
A) M*TWO
B) M TWO
B) M#TWO
D) M?TWO

6. A computer connected to the Internet must have...
A) IP address
B) Web server
B) Home Web page
D) Domain name

7. A modem is...
A) Mail program
B) Network protocol
B) Internet Server
D) Technical device

8. In a text editor, the Copy operation becomes possible after:
A) Setting the cursor to a specific position
B) Saving the file
B) File printouts
D) Selecting a text fragment.

9. What is a chip?
A) Electron tube
B) Integrated circuit
B) Information highway
D) Processor type

10. Are polyphages viruses or antivirus programs?
A) Antivirus programs
B) Viruses
B) Browser
D) Search engine

Open questions

Question 1
Two friends - Petya and Vasya - share an Internet access channel with a bandwidth of 4 KB per second. The load balancing system is configured in such a way that if only one person is using the channel at a given time, then the file is downloaded at a speed equal to the channel’s bandwidth, and if both friends are using the channel, the channel’s bandwidth is equally divided between users. Petya started downloading a musical composition. After 8 seconds, Vasya began downloading the graphic file. Petya finished downloading the music composition 34 seconds after he started downloading his file. The musical composition was digitized in mono mode with a sampling frequency of 1024 Hz and 65536 quantization levels. The graphics file contained 8192 pixels, encoded using a palette of 256 colors. Both the music file and the graphics file did not use data compression. Apart from the downloaded files mentioned, there was no other load on the Internet access channel. How many seconds does the music composition that Petya downloaded last? Please indicate the number in your answer.

Question 2
How many natural numbers are there for which the following conditions are simultaneously satisfied:
1) Writing a number in the decimal number system has exactly three significant digits.
2) If you convert this number to the six-digit number system, then the number will remain three-digit, but the value of each place will increase by one compared to the values ​​of the corresponding bits in the number written in the septal number system.
Please provide an integer in your answer.

Question 3
The representation of a certain natural number X in the hexadecimal number system has exactly three significant digits. This number was doubled, and it turned out that the hexadecimal representation of the resulting number Y also has exactly three significant digits, and the sum of the hexadecimal digits of the original number X is equal to the sum of the hexadecimal digits of the resulting number Y. How many numbers X are there that satisfy the specified conditions and at the same time contain at least one digit 2 in their hexadecimal notation? Please provide an integer in your answer.

Question 4
Petya designed a device consisting of a sensor and memory. The sensor takes readings in the range from 0 to 1 with an accuracy of 0.1 and stores each value separately in memory. Only an integer number of bytes can be written to memory, so each sensor reading takes exactly 1 byte. Vasya suggested adding a buffer to the device that accumulates N readings. Once the buffer is completely filled, the resulting combination of readings is encoded with the minimum possible number of bits and written to memory, occupying an integer number of bytes. At what minimum buffer size will the amount of information written after it is filled be 10 bytes less than it would take to record the same number of readings in the absence of a buffer? In the answer, indicate an integer - the buffer size, defined as the number
sensor readings that can be accumulated in it.

Question 5
A young intern in the technical department, Vasechkin, received his first independent task: to install drivers for peripheral devices on the director’s new computer. Going on his assignment, Vasechkin received parting words from his more experienced work colleagues in what order the drivers should be installed. But the colleagues had a sense of humor and decided to give advice in which only half was true, and the rest was a deliberate lie.
Wizard's assistant: Only the scanner can be installed first, and the external hard drive can be installed second to last.
Dispatcher: Be sure to install the monitor second, and the fourth should be an external hard drive.
Head of department: The monitor must be installed second, and the scanner only third.
Senior foreman: Never put a printer third, and don’t put a musical keyboard last.
Junior master: The musical keyboard can be placed first, and the printer second.
Help Vasechkin restore the exact sequence of driver installation. In your answer, indicate the first letters of the devices in a row in the order in which you need to install drivers for them. (B – external hard drive, K – musical keyboard, M – monitor, P – printer, C – scanner)