Practical work on the computer operator course. Book: Natalya Vasilievna Strumpe “Computer Operator. Practical work. Textbook for students of secondary vocational education. Statement of the Ministry of Defense of the Russian Federation. See also in other dictionaries

Computer's operator. Practical work. Strumpe N.V.

7 ed. - M.: 2015. - 112 p.

Complex practical tasks for independent execution on a personal computer contains sections: operating system Windows text editor MS Word, table processor MS Excel, MS Access database management system, MS PowerPoint presentation development system. It is recommended for independent practical work of students on a personal computer and serves to consolidate the theoretical knowledge acquired as part of the study of computer science disciplines, as well as to acquire skills in practical work on a PC.

Format: pdf

Size: 10 MB

Watch, download: google.drive

TABLE OF CONTENTS
Preface 3
Chapter 1. Windows 4 operating system
1.1. Operating system. File system 4
1.2. Graphic Windows interface 5
1.3. Standard Windows programs 6
1.4. Graphics editor Paint 7
Chapter 2. Text editor MS Word 9
2.1. Font formatting 9
2.2. Paragraph 11 formatting
2.3. Force end of line. Non-breaking space 15
2.4. Creating a drop cap 18
2.5. Page formatting. Columns 20
2.6. Numbered lists 22
2.7. Bulleted lists 23
2.8. Multi-level lists 23
2.9. Working with indexes 25
2.10. Creating footnotes 26
2.11. Inserting characters 27
2.12. Incorporating graphics into a document 28
2.13. Drawing Toolbar 30
2.14. Creating tables 32
2.15. Formatting tables 34
2.16. Calculations in table 36
2.17. Document styles 40
2.18. Working with templates 41
2.19. Creating a term index 42
2.20. Writing Math Formulas 44
2.21. WordArt Toolbar 45
2.22. Creating a table of contents 46
Chapter 3. MS Excel Spreadsheets 47
3.1. Basic concepts of MS Excel. Data types. Formatting a table 47
3.2. Autofill function 50
3.3. Diagramming 51
3.4. Entering a formula. Calculations using formulas 52
3.5. Standard Features. Calculation of mathematical functions. Graphing 54
3.6. Using MS Excel to solve mathematical problems 57
3.7. Construction of surfaces 58
3.8. Using MS Excel to solve accounting problems 60
3.9. Working with Multiple Worksheets 65
3.10. Calculation automation function Parameter selection 68
3.11. Logic functions 69
3.12. Processing of data sets 72
3.13. Sorting and filtering data 75
3.14. Usage spreadsheet as a database 79
3.15. Using MS Excel for numerical modeling. Finding a solution 83
Chapter 4. MS Access database management system 86
4.1. Basic concepts. Data types 86
4.2. Developing a structure and creating a table in Design mode 87
4.3. Creating a table using the Wizard 88
4.4. Sorting records. Finding and replacing values ​​in a table 89
4.5. Filtering records 90
4.6. Forms. Creating a Form Using the Wizard 91
4.7. Table relationships 93
4.8. Creating forms from multiple tables 94
4.9. Requests. Creating a request using the Wizard. Creating a Query in Design Mode 97
4.10. Calculated fields in query 100
4.11. Reports. Creating a report using Wizard 102
Chapter 5. Program for creating computer presentations MS PowerPoint 104
5.1. Create a presentation using Template 104
5.2. Creating hyperlinks in a presentation 105
5.3. Create a presentation using graphic objects, animation and hyperlinks 106
References 107

Practical work in computer science

Text WORD processor

PRACTICAL WORK

Practical work 1

Topic: Basic interface concepts Windows

Lesson objectives:

- educational - to introduce students to the basic concepts, interface and main menu of the Windows OS.

Developmental – formation new system concepts related to graphical representation interface

1. Customize the Desktop as you wish: in the desktop context menu Windows desktop select the Properties command and set the design style, select the background and screen saver.
2. Open the Windows Main Menu and create shortcuts on the Desktop Paint programs and MS WORD and place them in the lower right corner of the screen.
3. In the taskbar context menu, select the Date/Time Settings command and specify current date and time.
4. From the taskbar context menu, select Properties and set the taskbar to automatically disappear from the screen.
5. In the context menu of the taskbar, select the Properties command and remove the language indicator from the taskbar, change the switching of keyboard layouts.

Practical work 2

Topic: STANDARD WINDOWS PROGRAMS “Notepad” and WordPad,

Lesson objectives:

- educational - introduce students to basic techniques for entering text, formatting fonts and copying text fragments

Educational – nurturing personal qualities that ensure the success of performing activities: discipline, attentiveness, hard work

Answer the questions:

1. List standard programs WINDOWS.

2. List utilities WINDOWS

3. Give a comparative description of the capabilities of text editors Notepad and WordPad

4. Launch Notepad and type the following text:

In the second half of the last century, computers appeared, which were created to facilitate the work of mathematicians. The study of computer science and computer technology was necessary for scientists, software engineers and computer maintenance personnel.

With the advent of the personal computer and information technologies Gradually, accountants and clerks, writers, journalists and publishers, designers and architects, artists and designers, teachers and students were added to this category. What is computer science?

Computer science is the comprehensive science of information and information processes, hardware and software informatization, information and communication technologies, as well as the social aspects of the informatization process.

5. Copy the typed text and run WordPad program, paste it.

7. Add a title “Practice”, center it using the toolbar.

8. Using the Format - Font command, change the title font: color - red; type - Arial; style - bold with underlining.

9. Change the font style and size of the main text to 16 italics.

Using the Insert - Object command, insert a drawing or photo from the file after the text.

Practical work 3

Topic: GRAPHIC EDITOR PAINT

Lesson objectives:

- educational - to introduce students to the basic techniques of creating and converting a computer drawing

Developmental – the formation of a new system of concepts related to the creation of a graphic document

Educational – nurturing personal qualities that ensure the success of performing activities: discipline, attentiveness, hard work, creativity

Answer the questions:

1. List the types of computer graphics.

2. What type of graphics are drawings created using Paint?

3. In what format are files created in Paint saved by default?

4. List the computer graphics file formats you know.

Practice 1

1. Launch the Paint program.

2. Create a drawing according to the proposed sample using: commands; text attributes panel; colored eraser.

3. Save the drawing in a personal folder under the name “Apples”.

4. Select the picture, copy it, open the file Text 1 in your personal folder and paste the picture after the second paragraph. Close the Text 1 file, saving your changes.

5. Create a “Pictures” folder in your personal folder and send the file to it Apples.

Practice 2

1. Create a Domino drawing according to the proposed sample.

Note. While holding down a key, using tools Ellipse and Rectangle gives a circle and a square, respectively, and a straight line will be vertical, horizontal or at an angle of 45°.

Save the drawing in your Drawings folder under the name Domino.

Create a drawing “Driving map” according to the proposed sample.

Save the drawing in the "Drawings" folder under the name "Driving".

Rice. 1.3

Practice 3

Create a drawing according to the sample (Fig. 1.4) using the tool Curve.

Save the drawing in your Drawings folder under the name “Sea.”

Complete the following drawing (Fig. 1.5) using the tool Curve, teams Copy, Paste, Flip/Rotate.

rice. 1.4 Fig. 1.5

Practical work 4.

Topic: WORD TEXT EDITOR. FONT FORMATTING

Lesson objectives:

- educational - teach students the basic techniques of formatting fonts in a WORD text editor

Developmental – the formation of a new system of concepts related to the creation of a text document

Educational – nurturing personal qualities that ensure the success of performing activities: discipline, attentiveness, hard work.

Formulate a definition:

A text editor is __________________________________________

Answer the questions:

1. What text editors do you know?

2. Which software package includes the WORD text editor?

3. List the main features of the WORD text editor

4. What font formatting tools do you know?

Practice 1

Create a “Documents” folder in your personal folder.

Launch the WORD program.

Start completing the assignment with the title “Practical Assignment.” Continue to do so in the future.

4. Type the text using all formatting elements using the Font dialog box or the corresponding buttons on the toolbar

Fonts

A font is a set of letters, numbers, special characters and punctuation marks displayed in a certain way. The concept of a font includes: font type, font size, style, color, special effects.

The most common fonts in Russia are Times ET, Times New Roman Schoolbook, Optima, Arial New, etc.

Size is usually expressed in points, or point. One point corresponds to 0.376 mm (American unit - Pica Point corresponds to 0.351 mm).

For the main text, size 12, 14 is usually chosen, for headings - larger sizes (16 and above), for footnotes and notes - 10.

The formatting process boils down to setting the required parameters for characters. You can format previously entered text or make settings, after which the entered text will be formatted as required.

Basic font parameters (type, size and style) are assigned using the command Format , Formatting toolbar, keys and context menu.

WORD capabilities when working with fonts

Selecting a typeface (font type). Select Various types font for one sentence, indicate the name of the font in brackets:

A modern personal computer can be implemented in a desktop (desktop), portable (notebook) or pocket (handheld) version.

A modern personal computer can be implemented in a desktop (desktop), portable (notebook) or pocket (handheld) version.

A modern personal computer can be implemented in a desktop (desktop), portable (notebook) or pocket (handheld) version.

A modern personal computer can be implemented in a desktop (desktop), portable (notebook) or pocket (handheld) version.

A modern personal computer can be implemented in a desktop (desktop), portable (notebook) or pocket (handheld) version.

II. Different styles of letters (zh, k, h):

You can use different combinations of styles.

III.Choice of font size. Font size is measured in special units - points. The more points, the more letters.

Print the numbers, setting the font size to the number:

16 18 20 22 24 26 28 29 30

IV. Type the phrase using each letter in a different color:

Bits and bytes.

V. Type the formulas using superscripts and subscripts:

CH 4 + 20 2 = C0 2 + 2H 2 0

(a + b) 2 = a 2 + 2ab + b 2.

VI. Type the phrase using different letter spacing(font menu, Spacing tab):

Word processor - regular spacing.

Word processor - 2 pt sparse.

Word processor - 4 pt sparse.

Word processor - 1 pt condensed.

Practical work 5

Topic: FORMATTING A PARAGRAPH

Lesson objectives:

- educational - teach students the basic techniques of creating and formatting a paragraph

Developmental – the formation of a new system of concepts related to the creation of a text document

Educational – nurturing personal qualities that ensure the success of performing activities: discipline, attentiveness, hard work

Answer the questions:

1. What is a paragraph?

2. Which command should you run to set all paragraph options?

3. What are the functions of ruler sliders?

the upper left triangle sets...

lower left triangle...

right triangle...

rectangle …

4. What is the name of the tool that allows you to repeat all the parameters

formatting a paragraph for other paragraphs in the document?

Practice 1

1. Type text containing information about the PC and the WORD program, following the formatting options indicated in brackets and text alignment.

The word "computer" means "calculator", i.e. a device for calculation. This is due to the fact that the first computers were created as devices for computing: advanced automatic adding machines. (On the left edge.)

The fundamental difference between computers and adding machines and other counting devices (counting, slide rules, etc.) was that adding machines could only perform certain computational operations.

(On the right edge.)

Computers allow complex sequences of computational operations to be carried out without human intervention according to a predetermined instruction - a program. Although the computer was created for numerical calculations, it soon turned out that they could process other types of information. (In width.)

Line spacing

Microsoft Word- a powerful text editor designed to perform all text processing processes: from typing and layout to spell checking, inserting graphics into text, and printing text. MS Word allows you to work with many fonts. MS WORD has many useful properties, for example: automatic text correction along borders, automatic transfer words and correcting the spelling of words, saving text for a certain set period of time, the presence of text wizards and templates that allow you to create business letter, fax, autobiography, schedule, calendar and much more.(Single spaced.)

MS Word provides search for a given word or text fragment, replacing it with a specified fragment, deleting, copying or replacing by font, typeface or font size, as well as by superscript or subscript characters. The presence of a bookmark in the text allows you to quickly go to the bookmarked place in the text. You can also automatically include the date, time of creation, return address, and name of the person who wrote the text.(One and a half interval.)

MS Word allows you to include databases or graphic objects, music modules in *wav format into the text using macro commands. To restrict access to a document, you can set a password for the text, which MS Word will ask when loading the text in order to perform any actions with it. MS Word allows you to open different windows for simultaneous work with several texts, as well as split one active window horizontally by two.(Interval “exactly” 12 pt.)

Practice 2

Type the text using the formatting options in parentheses and text alignment.

Indentations

Practical work 2.2.2

1. Type poems by A.A. Akhmatova, observing all formatting elements.

Attention. There is only one space between words.

Practice 3

1. Type poems by A.A. Akhmatova, observing all formatting elements.

Attention . There is only one space between words.

2.3. FORCED END OF LINE.Non-breaking space

Answer the questions:

1. In what cases should it be used? non-breaking space?

2. What keyboard shortcut produces a non-breaking space?

3. In what cases should you use forced line ending?

4. What keyboard shortcut forces a line end?

Practical work 2.3.1

1. Create a document according to the proposed template, using a non-breaking space when writing dates, names and surnames.

In 1642, Blaise Pascal invented a device that mechanically performed the addition of numbers. In 1673, Gottfried Wilhelm Leibniz designed an adding machine that made it possible to mechanically perform four arithmetic operations. Since the 19th century. adding machines have become very widely used. Even complex calculations were performed on them, for example, calculations of ballistic tables for artillery firing. There was also a special profession - a counter, a person who works with an adding machine.

In the first half of the 19th century. English mathematician Charles Babbage made an attempt to build a universal computing device - an analytical engine, which was supposed to perform calculations without human intervention.

C. Babbage was unable to complete the work on creating the Analytical Engine - it turned out to be too complex for the technology of that time. But he developed all the basic ideas, and in 1943, the American Howard Aiken, with the help of Babbage’s work based on electromechanical relays, was able to build a machine called “Mark-1” at one of the IBM enterprises. Even earlier, the ideas of Ch. Babbage were rethought by the German engineer Konrad Zuse, who built a similar machine in 1941.

In 1943, a group of specialists led by John Mauchly and Presper Eckert in the USA began to construct a similar machine based on vacuum tubes, not a relay. Their machine, called ENIAC, was a thousand times faster than the Mark 1, but it took hours or even days to wire the wires to program it. To simplify the process, Mauchly and P. Eckert began to design a machine that could store a program in its memory. In 1945, the famous mathematician John von Neumann was involved in the work, who prepared a report on this machine. The report was sent to many scientists and became widely known because in it J. von Neumann clearly and simply formulated the general principles of the functioning of universal computing devices, i.e. computers.

The first computer, which embodied the principles of J. von Neumann, was built in 1949 by the English researcher Maurice Wilkes. Since then, computers have become much more powerful, but the vast majority of them are made in accordance with the principles that J. von Neumann outlined in his report in 1945.

2. Save the file in the “Documents” folder under the name “VT History”.

Practical work 2.3.2

Sometimes it is convenient to pre-set all paragraph formatting options and then type the text. Create a document using the suggested template, using a forced line ending.

1. Before you start typing the first poem, you should run the Format - Paragraph command and fill in the fields of the dialog box (Fig. 2.1).

(Fig. 2.1)

2. When typing a poem, use a forced line end and a normal line end. When the button is pressedπ the first poem should look like this:

More ⬪in⬪the⬪fields⬪the⬪snow⬪whites,
A The ⬪waters⬪are⬪noisy already in the spring -
They're running ⬪and⬪wake up the⬪sleepy⬪shore,
They're running ⬪and⬪shine⬪and⬪say... π

They ⬪they ⬪read ⬪in ⬪all ⬪ends:
"Spring ⬪it’s coming, ⬪spring⬪is coming!
We ⬪young⬪spring⬪messengers,
She ⬪sent⬪us⬪ahead!”π

3. Apply similar instructions for the second poem (Fig. 2.2).

It sounded ⬪above⬪the⬪clear⬪river,
It rang ⬪in⬪the⬪faded⬪meadow,
It took a ride ⬪above⬪the silent⬪grove,
lit up ⬪on⬪that⬪shore.π

Far, ⬪in ⬪darkness, ⬪meadows
Runs away ⬪to⬪west⬪river.
Having burned ⬪golden⬪edges
Scattered ⬪like⬪smoke, ⬪clouds.π

4. For the third and fourth poems, do your own formatting.

* * *

IN in the crimson glow the sunset is effervescent and foamy,
White birch trees burn in their crowns.
My verse greets the young princesses
And youthful meekness in their tender hearts.

Where are the pale shadows and sorrowful torment,
They are for the one who came to suffer for us,
Regal hands stretch out,
Blessing them for the hereafter hour.

On a white bed, in a bright glare of light,
The one whose life they want to return is crying...
And the walls of the infirmary tremble
From pity that their chest tightens.

Pulls them closer and closer with an irresistible hand
There, where grief puts its stamp on the forehead.
Oh, pray, Saint Magdalene, for their fate.

Sergey Yesenin

* * *

Wait! it is nice here! Serrated and wide
A shadow bordered the pine trees in the moonlight...
What silence! Because of the high mountain
There is no access for rebellious sounds here.

I will not go where the treacherous stone is,
Sliding from under your heel from the steep banks,
Flies on sea cartilage; where there is a huge shaft in the sea
He will come and run away into the arms of the shafts.

Alone in front of me, under the peaceful stars,
You are here, queen of feelings, ruler of thoughts...
And then a wave will come and crash between us...
I won’t go there: there is eternal splashing and noise!

Afanasy Fet

5. Save the file in the Documents folder under the name Poems.

EXERCISE

Create a document according to the proposed template (the title and drop caps are in green ScriptC font).

Split text into individual pages: 1 paragraph on each page

Number the pages in the right margin. On each page, create headings and add them using the Heading1 style. At the end of the text on separate sheet add table of contents.

The ult of vegetation, the oldest of cults, dates back to the earliest forms of belief - magic. Observation of plants reflects the most important stage in human knowledge of the world, the stage of understanding the laws of nature. In ancient times, the first law of nature was discovered - the law of life and death. The solution to the semantics of plant ornaments of different peoples and eras convinces us that everywhere it was an illustration of the unity of the destinies of all living things, plants and humans, the change of natural phenomena, i.e. the cycle of life, its continuity. It was demonstrated by nature itself by the continuous alternation of dying and rebirth of the plant and animal world.

asthenia, trees - symbols of motherhood, fertility and embodiment vital energy, multi-valued symbols known to almost all peoples of the world. Each nation worshiped and deified the tree or plant with which it most often came into contact. Everyday life. Many nations have their own shrine trees, symbolic trees. Oak took first place among the ancient Jews, ash - in Scandinavia, among the Germans - linden, among the Russians - birch, the sacred bodhi tree - in India, among the Buryats - pine and larch. A deciduous tree that changes its leaves every year is a symbol of the renewal of life. Pine is one of the most ancient tree species, an evergreen and durable tree, little susceptible to rotting. It can grow in the poorest soil, but it needs space to live. Due to these properties, it serves as a symbol of longevity, immortality, perseverance and overcoming adverse circumstances.

Like a person, a tree or plant is oriented vertically: leaning on the ground, it strives upward, towards the sun and light. The shape of a tree, a plant with its roots in the ground, trunk and crown personified three worlds: the top - the heavenly, the middle trunk - the earthly and the lower roots - the underground world. A tree as a world vertical is ringed with circles in the cut of the trunk, the shape of the crown and leaves. The crown is a haven for birds, animals and clouds; the sky and stars are visible through it. A plant, like a person, is subject to a natural cycle: it reproduces, grows, ages and dies. Just like a person, it lives at the expense of vital juices and energy. When they are lacking or when they run out, it dies. Trees and plants contain a living, inextricable connection between the past, present and future. According to these ideas, the tree embodies the idea of ​​a human ancestor. In the East it was believed that the spirits of the gods and the dead lived in trees.

and no culture knew such tree worship as the culture of the ancient population of India. The sacred books “Vedas” and “Upanishads”, which reflect the religious views, ethical and spiritual standards of the people, glorify the beauty and grandeur of the forests of India. The lotus among the peoples of India has always been a symbol of purity. This flower grows out of dirt, but is never dirty. The lotus is compared to a person to whom no filth sticks.

2. Save the file in the “documents” folder under the name “Bukvitsa”.

2.5. PAGE FORMATTING. SPEAKERS

Practical work 2.5.1

1. Arrange one half of the text in three columns with 0.5 cm spacing between columns, the other half in two columns with 0.6 cm spacing.

Let's talk about the monitor

Although there are no trifles in maintaining health, the monitor, perhaps, has the most impact on it. Savings on good monitor unacceptable. Vision is easy to spoil, but extremely difficult to restore.

Just because a monitor meets the latest safety standards does not mean it is completely harmless. Proof of this is the simple fact that standards are constantly being revised to tighten equipment requirements.

A flat monitor is not a luxury at all and is needed not only by designers for maximum realism of the picture. It is very harmful to the eyes to constantly adjust the sharpness within a small range. Therefore, for example, it is harmful to read in transport, keeping a constantly vibrating book in focus.

With a convex monitor, when the eye moves from the center of the screen to the periphery, the lens muscles perform the most difficult work. Their fatigue ultimately leads to a spasm of accommodation, and up to three units of vision can be lost just due to this spasm without any organic changes. Such loss of vision can be compensated by eye exercises; sometimes wearing glasses with diopters +1, +2 helps. In advanced cases, it is better to consult an ophthalmologist. There are more effective techniques, but they are selected individually.

The muscles of the pupil are tuned to changes in the brightness of the light, and if it changes 60 times per second, then it is not difficult to imagine the work they have to do to adjust. This work is usually not perceived by consciousness, but this does not mean that it does not exist. To check whether you perceive the flickering of the screen and at this particular frequency, you can do this: look away from the screen so as to see it at an angle of about 45°. Lateral vision is more sensitive to flicker. When you stop perceiving flicker, add another 20 Hz. Everyone perceives 72 Hz, 85 Hz is the majority, 100 Hz is a sufficient minimum when flicker is indistinguishable for most people.

Practical work 2.5.2

1. Type the text taking into account the formatting elements (use columns with a separator).

PROFESSIONAL CHARACTERISTICS

Computer's operator

knows:

fundamentals of computer science and computer technology;

basic information about computing systems and automated systems management;

basic functional devices Computers, their connection and purpose;

general information about the software;

structure, functions and capabilities of the operating system (OS);

structure, functions and capabilities of shell programs, rules for working in shell programs;

basic concepts of information banks: principles of construction, types of database management systems (DBMS);

integrated environments for working with databases, security tools;

methodology for working on a PC keyboard using the blind ten-finger method in Russian and Latin registers;

principles of organizing and entering data and programs into a computer;

basics of text editing;

information about spreadsheets and principles of working with them;

sanitary and technical requirements and labor safety requirements;

information about specialized packages application programs; prospects for the development of computer technology (CT);

types and causes of failures in the operation of devices and programs, measures to prevent them

can:

conduct the information processing process;

perform input/output of information from data carriers, communication channels and process this information;

write, read, copy information and rewrite from one medium to another;

use the capabilities of operating systems; load the OS and manage its operation;

work in shell programs;

work with databases;

work with text and graphic editors;

work with spreadsheets;

comply with labor safety standards and regulations;

master new software products;

establish the causes of failures in the information processing process and decide on further actions.

2. Save the file in the documents folder under the name “Lists 1”.

2.7. BULLET LISTS

Practical work 2.7.1

1. Create a document with bulleted list according to the proposed model.

2. Save the file in the Documents folder under the name Lists 2.

2.8. MULTILEVEL LISTS

Practical work 2.8.1

Test on WORD topic

1. What extension is given by default? text files in Word format.

1. What is a document template?

1. a means of storing the format, styles and text of standard documents;
2. sample form for a number of standard documents;
3. form for standard documents;
4. file with extension DOT.

1. What is paragraph style?

1. a named set of character and paragraph design parameters;
2. a way to quickly format typical text fragments;
3. button on the formatting panel; Format menu command.

1. How to set double spacing between lines of text?

1. command Format → Indents and spacing;
2. command Format → Paragraph;
3. add a line of spaces;
4. this is done automatically.

1. How to quickly increase the size of letters in text?

1. command Format → Font;
2. using the Font Size list on the Formatting panel;
3. command View → Scale;
4. impossible.

1. How can I save paragraph formatting and apply it to the entire document?

1. create new styles and replace old styles with new ones;
2. command Format → Autoformat;
3. command Edit → Replace;
4. button Sample format in the Formatting panel.

1. How do I set the margin size and paper size?

1. command Print → Page settings;
2. command File → Page settings;
3. command Format → Indents and spacing;
4. using a scale ruler.

1. How to highlight certain words with underlining?

1. command Format → Font;
2. select the words and execute the command Format → Font;
3. use the underscore character on your keyboard.

1. How to arrange text in columns?

1. team Table →Add table;
2. using the panelTables and borders;

1. How to position table column headers exactly in the middle of the column width?

1. add a few spaces at the beginning of each heading;
2. align all columns to the center;
3. center the header row with the command Format -> Paragraph;
4. using the tab key.

1. How to separate rows and columns of a table with lines?

1. command Table → AutoFormat;
2. command Format → Borders and shading;
3. command Format → Paragraph;
4. using the toolbar Drawing.

1. How to quickly create a table of contents for a large document?

1. command Insert → Table of contents and indexes;
2. copy section headings in the “Main Document” mode;
3. make all text invisible except headings;
4. start printing the document from the table of contents.

Copy the typed text, change the internal lists in the copy to bulleted ones.

Save the file in your Documents folder as “Lists 3.”

2.9. WORKING WITH INDEXES

Answer the questions:

1. What techniques do you know for entering indexes? Answer:

2. How to add tools to the toolbarSuperscript And Subscript! Answer:

Practical work 2.9.1

1. Create a document according to the proposed template.

Mechanics Basics

Hooke's Law: (Rcontrol) X= -kh,in which the proportionality coefficient(To) called rigidity bodies (springs).

Work done by gravity applied to a body:A ~ m%(n\ - I2 ).

Soft hyphenation is used to indicate where to break a word or phrase if it ends up at the end of a line.CTRL+Hyphen

A non-breaking hyphen prevents words, numbers, or phrases containing a hyphen from breaking at the end of a line. For example, you can prevent the number "555-0123" from breaking up. CTRL+SHIFT+HYPHEN.

Conclusive actions(fromlat. concludo- conclude, draw a conclusion) - actions of a person expressing his will to establishlegal relationship (for example, makedeal ), but not in the form of an oral or written expression of will, but by behavior by which one can draw a conclusion about such an intention.

Possibility of conclusiondeals by performing implied actions is providedCivil Code Russian Federation .

In some cases, silence may act as an implied action, which in the strict sense isinaction .

Committing conclusive actions is equivalent to concluding an agreement with all the ensuing legal consequences.

Examples of conclusive actions

• Purchasing goods or exchanging currency through machines
• Purchasing goods in self-service stores
• Paying for travel on public transport
• Giving by transferring a key (symbol)
• Acceptance of inheritance directly

Agreement contractingis a specific type of purchase and sale, which is widespread in the sale of agricultural products, raw materials and food. Under a contracting agreement, a producer of agricultural products undertakes to transfer the agricultural products grown (produced) by him to the procurer - the person purchasing such products for processing or sale.

Inserting a SmartArt Object

2.14. Creating Tables

Answer the questions:

1. What techniques do you know for creating tables?

2. Which toolbar is convenient to use when working with tables?

3. Which team represents greatest opportunities to set tables and fill table cells?

2.15. Formatting tables.

1. Create a document according to the proposed template. Cell size 3.5× 3.5 cm. Font size – 11.

Note. Choose the border and fill of your choice.

Table 2.2

Different direction and alignment of text in a table

Merging and splitting table cells. Numbering of cells.

Table 2.2

2.16. Table calculations

The WORD word processor allows you to perform calculations in a table by writing in individual table cellsformulasusing the commandWorking with tables – Layout – Formulas.For example,=A5*B5, where A, B are conditional names of the columns, 5 is the row number in the table.

In formulas you can use:

• cell block names (for example, A2:B5);
• LEFT – cells located in a row to the left of the cell with the formula;
• RIGHT – cells located in the row to the right of the cell with the formula;
• ABOVE – cells located in the column above the cell with the formula;
• BELOW – cells located in the column below the cell with the formula.
• constants (for example, 3.5); text in double quotes(for example, “rub.”);
• built-in WORD functions(see note);
• Operation signs: (+ - * / % = >=).

Formulas can be copied; After copying, you need to edit the links in the Table – Formulas mode.

After changing the data, you need to select the formula and run the commandUpdate fieldin the cell's context menu.

Practical work 2.16.1

1. Create a document according to the proposed sample and make calculations in the “Cost” column

Note.Examples of built-in functions:

AVERAGE(A1:C20; B25; A30) – calculation of the average value for a range of cells;

MAX(A5:B15; B25:C30) – finding the maximum value in the specified block of cells;

PRODUCT(C1:C20; B25:B30) – product of numbers in the specified range;

SUM(E2:E15) – sum of numbers in the specified range, etc.

Additional task for calculations in tables.

$

rub.

$

Wallet

"Image"

320

40

Briefcase

"Meridian"

2970

20

Children's briefcase

"Meridian"

650

30

Backpack

"Voyage"

1200

45

Lady's bag

"Transit"

1270

25

Suitcase

"Transit"

9650

33

Exchange rate $

31,23

Total:

Practical work 2.16.2

Build a histogram based on product name and price:

- set the pointer to free space leaf;

- execute the command Insert – Diagram;

- select the chart type – OK; A sheet will open workbook EXCEL spreadsheet;

- Select the Product Name column, click Copy, move the pointer to cell A1 EXCEL sheet, execute the Insert command;

- similarly copy the Price column to cell B1.

Select the diagram; Using the menu Design, Layout, Format, change the design, add axes and data labels, change the chart title.

Build a bar chart for the Product Name and Quantity columns.

MACROS

In the application Microsoft Office In Word 2007, you can automate frequently performed tasks by creatingmacros. A macro is a set of commands and instructions grouped together as a single command to automatic execution tasks.

Typically, macros are used for:

• speed up frequently performed editing or formatting operations;
• combining multiple commands, such as inserting a table with specific dimensions, borders, and number of rows and columns;
• simplify access to parameters in dialog boxes;
• automation of complex processing consistent actions in tasks.

You can use a macro recorder likesequences of actionsor create a macro yourself by entering the code in the languageVisual Basic for Applications (VBA (Visual Basic for Applications). A version of the Microsoft Visual Basic macro programming language used for programming applications for Microsoft Windows and included with some Microsoft programs.)VVisual Basic editor.

When creating a macro, you need to determine its name, the document for which it is intended, and the list of actions to be performed. You can create special button on the toolbar to run the macro.

1. On the tabDevelopmentin GroupCodeselect teamRecord a macro.
2. Enter the macro name in the fieldMacro name.

NOTE.If a new macro is given the same name as a macro built into Office application Word 2007, the actions of the new one will be performed instead of the actions of the built-in one. To view a list of built-in macros, selectMacroin GroupCodeon the tabDeveloper. On the listMacros fromselect itemWord Commands.

3. On the listMacro available forclicktemplate (Template. A file or files that contain the structure and tools for creating elements of finished files such as style and page layout. For example, Microsoft Word templates allow you to create individual documents, and Microsoft FrontPage templates allow you to create entire Web sites.)or the document in which you want to save the macro.
4. In fieldDescriptionenter a description for this macro.
5. Perform one of the following actions.

• To start recording a macro without associating it with a button on the panel quick access or keyboard shortcut, press the buttonOK.
• To associate a macro with the Quick Access Toolbar, follow these steps:

1. Click the buttonbutton.
2. In GroupCustomizing the Quick Access ToolbarSelect the document or all documents for which you want to add a macro to the Quick Access Toolbar.
3. In the dialog boxSelect commands fromselect the macro you want to record and click the buttonAdd.
4. OK.

• To assign a keyboard shortcut to a macro, follow these steps:

1. Click the buttonKeyboard.
2. On the listTeamsselect the macro you want to record.
3. In fieldNew keyboard shortcutenter any key sequence and press the buttonAssign.
4. To start recording a macro, click the buttonClose.

6. Complete the actions that should be included in the macro.

NOTE.When recording a macro, you can use the mouse to select commands and options, but not to select text. You must use the keyboard to select text. To select text using the keyboard, seeText selection.

7. To stop recording activities, select the commandStop recordingin GroupCode.

Topic: “Scheme design”

Task: Draw up a diagram according to the sample:

1. Design a diagram using the following WORD tools:

Inserting labels with text;

Inserting lines or arrows;

Copying objects;

Aligning objects;

Design of objects;

Grouping of objects.

2. Present the work to the teacher.

I approve I approve

Deputy Director for SD Head

GOBU SPO VO "BIT" computer center "Alt"

S.S. Prokhorova __________ A.A. Basov

"___" ____________ 20__ "___" ______________ 20___

Examination tasks for

qualifying exam for the specialty “Computer Operator”

« Word. Basic operations with a document"

Task No. 1. (2 points)

Create a Microsoft Word document with your short autobiography (At least 15 lines: name is so-and-so, born then, love this, am interested in this, don’t like this, etc.). Title for your text: Task No. 1. Autobiography.

Format the heading: font size 15, type Bookman old style, bold italic, heading color red, underline (any type), underline color red (Select heading, menu Format  Font).

Format the font of the rest of the text: font size 14, type Arial (select the text, menu Format  Font).

Center the title. Align all text to width.

Set margins to 2 cm. (File  Page Setup)

Set the red line (select all text, menu Format  Paragraph  first line indent 1 cm).

Make the text with one and a half spacing (select text, format  paragraph  line spacing  one and a half).

Insert page numbers (insert  page numbers  select location: top of page, from center  confirm insertion).

Save the file to a floppy disk. The file name is “Task No. 1” (File  Save As  ...). Sign the floppy disk with your name.

Task No. 2. (maximum 2 points)

Write to page header your full name, current date and time (View  Header and Footer).

Save the file to a floppy disk. The file name is “Task No. 2”. Sign the floppy disk.

Task No. 3. (maximum 3 points)

Create a Microsoft Word document with a short story about studying at our institute (at least 15 lines). Heading for your text: Task No. 3. Institute.

Format the text according to points 2 to 8 of task No. 1.

Start each sentence of your text on a new line.

Number the lines of text (highlight text  format  list  numbered).

Add a Drawing toolbar (View  Toolbars  Drawing).

Create the suggested diagram using the Draw panel elements:

Write down your full name, current date and time in the header (View  Header and Footer).

Save the file to a floppy disk. The file name is “Task No. 3”. Sign the floppy disk with your name.

Task No. 4. (maximum 4 points)

Create a Microsoft Word document. Create a table - your schedule for the week - according to the proposed model. Title: Task No. 4. Schedule.

Practice

/lecture

Red Week

Blue week

Cub

Time

Monday

Etc

Nah, Monday

Difficult day!

8 30 - 9 50

There’s a couple here too, I definitely remember.

10 00 - 11 20

Etc

Study

Study

11 50 - 13 10

And study again!

11 50 - 13 10

Tuesday

Well, I don’t go to this couple, it’s hard to wake up...

8 30 - 9 50

I always try not to be late... I have never succeeded

10 00 - 11 20

Hmm, sometimes I’m still capable of something...

11 50 - 13 10

Ooooh, this is unbearable, 4 pairs a day! I want to go home!

13 20 - 14 40

Wednesday

That's it, I'm starting new life, will be studying…

8 30 - 9 50

I'll go anyway next pairs. I promise!

10 00 - 11 20

Lab

Computer science

11 50 – 13 10

Spanish modern information And communication technologies

13 20 – 14 40

Lab

Computer science

14 50 - 16 10

Comment: Make a table for all school days of the week. Fill the table.

Write the time in the table using superscripts (Highlight minutes  Format  font  superscript). Use a fill for table cells (Select the desired cell  Format  Borders and Shading  Fill tab).

Write down your full name, current date and time in the header (View  Header and Footer).

Save the file to a floppy disk. The file name is “Task No. 4”. Sign the floppy disk with your name.

Task No. 5. (maximum 5 points)

Task No. 6. Creative. ( maximum 10 points)

Create a Microsoft Word document on the topic “Me and My Life!” Demonstrate your Word skills: use everything you know: tables 1, pictures 2, Word objects Art 3, formatted text 4, indexes 5, symbols 6, columns 7, diagrams (autoshapes 8, arrows 9, lines 10, labels 11), frames 12, shading 13, page numbers 14, text animation 15, formulas 16, footnotes 17 , markers 18 , footers 19 .

« Excel. Creating tables and formulas"

Create a table like in the picture without filling it with numerical data.

Customize the table name using the menu Format -Cells- Alignment (center and merge cells)

Fill in the grade data (in columns C – F) using the get function random numbers: Enter the formula in cell C8 =INTEGER(RAND()*10). Extend this formula to the block of cells C8: F17.

Perform the count total score using the function Autosum(SUM).

Calculate averages for each applicant and exam using the function AVERAGE (Insert - Functions– Statistical).

In the Enrollment Message column, use the function IF: logical expression G8>$E$5, value if true enrolled, value if false refuse. (The total score for the first student is compared with the passing score, and a message “admitted” or “rejected” is displayed).

Using the menu command Format - Conditional Formatting configure the cells of the Enrollment Message column so that when the words “enrolled” appear in them, they are filled yellow, and the message itself was highlighted in bold blue. To do this: in the first field of the window, select “value”, in the second “equal to”, in the third enter “enrolled” (without quotes) by clicking the button Format select font color and cell color. After clicking OK, don't forget to copy new format to all other cells of this column.

Apply font design and cell fill.

Save your work in your folder under the name Ball . xls .

Compiled by:

Chairman of the Center for Information Technologies _________________ G.V. Torgashin

Teacher _________________ E.G. Triodyne

Computer science, cybernetics and programming

Copy or move a formula. Absolute, relative and mixed links. Arithmetic operators. Give examples. Logic function IF. Syntax, application. Nested IF function. Give examples.

V.A. Kanya

computer in practical problems

Omsk  2007

Federal Agency for Education

Siberian State Automobile and Highway Academy

(SibADI)

V.A. Kanya

Computers in practical problems

Workshop for technical students

Approved by educational educational institutions of universities of the Russian Federation for education in the field of transport vehicles and transport-technological complexes as a teaching aid for university students studying in specialties in areas of training“Transport vehicles and transport-technological complexes”, “Operation of ground transport and transport equipment” And "Organization of transportation and management

on transport"

Omsk

Publishing house SibADI

200 7

UDC 681.3

BBK 32.973

K 19

Reviewers:

Department of Informatics and Computer Science, State Educational Institution of Higher Professional Education, Omsk State Pedagogical University (head of the department, Doctor of Pedagogical Sciences, Prof. Z.V. Semyonova, Candidate of Pedagogical Sciences, Associate Professor L.A. Vnukova); Ph.D. tech. Sciences, Associate Professor Department of Computer Systems, State Educational Institution of Higher Professional Education, Omsk state university them. F.M. Dostoevsky S.S. Efimov.

The work was approved by the Academy's Editorial and Publishing Council as a textbook for students specializing in the areas of training “Transport machines and transport-technological complexes”, “Operation of land transport and transport equipment” and “Organization of transportation and management in transport”

Kanya V.A. Computers in practical problems: Workshop for students of technical specialties. Omsk: SibADI Publishing House, 2007. 42 p.

It contains assignments for students of correspondence and distance learning.

Designed for students of technical universities.

ISBN 978 5 93204 306 6© V.A. Kanya 2007

Assignments for correspondence and distance learning students

In the process of studying the discipline, for better assimilation of the material, the student correspondence form students must complete a test.

The test consists of theoretical and practical parts.

Carrying out the theoretical part test work, each student answers four questions. The questions are divided into groups. From each group, the student selects a question whose number matches the last number of his grade book. If the last digit of the grade book is 0, the student answers the 10th questions.

Answers to questions must be complete and must contain an example.

When completing a test, at the beginning of the answer to the question, the question itself is written down completely without changes.

Answers to the theoretical part of the test should be completed using a computer program. Microsoft Word on A4 sheets in compliance with all requirements of the ESKD.

The practical part of the test consists of completing five tasks, of which three are application tasks Microsoft Word and two application tasks Microsoft Excel . Practical tasks are also divided into groups: Forms, Tables, Drawings, Graphs and Calculations . The selection of a task from each group is made according to the last number of the grade book, similar to the questions in the theoretical part.

Write the completed assignments onto a floppy disk and submit them to the methodological office along with completed answers to the theoretical part of the test.

In addition, group assignments Charts import into application Microsoft Word , format as in the sample assignments in the section “ Microsoft EXCEL "(see p. 95...97), print on A4 sheets in compliance with all requirements of the ESKD and file with the answers to the theoretical part of the test.

Questions from the theoretical part of the test

Group 1

1. Explain the rule for forming long and short file names. Give examples of a long file name and conversion to a short one.
2. What is the extension in a file name? His purpose? Give examples of special extensions, application extensions.
3. File access path. Give examples of the full access path even if the current one is a disk, directory, or subdirectory.
4. Basic techniques for working with a mouse. Give examples.
5. Keyboard: alphanumeric, special, function keys. Their purpose, methods of work. Give examples.
6. The procedure for turning on/off the computer.
7. Keyboard: number keys, keys Shift, Ctrl, Alt. Their purpose. Give examples of use.
8. What is a directory or folder? Forming a folder name. Give examples.
9. Basic file attributes. Give examples.
10. What information is stored in the directory? How is file size measured? Give examples.

Group 2

1. What is a Desktop ? What elements does it contain? What's happened Task bar ? Draw all the elements Desktop and Taskbar.
2. What is an Icon, Label? How to create a Shortcut, Folder using the context menu? How to remove them?
3. What types of windows do you know based on uniformity of design? Give an example of a dialog box Shortcut Properties , describe its elements.
4. The structure of the application window, its elements. Give an example of an application window Microsoft Word.
5. What is Explorer ? Give an example of its two-pane window with all the elements.
6. How to add/remove to Panel Explorer Browser, Tools?What items does the menu contain?Browser panel?
7. In what form can information be displayed in the right panel? Conductor ? What do the +\ signs mean? installed next to Folder in the left pane of Explorer?
8. What is the Main Menu ? What elements does it contain? How to launch it?
9. How to select multiple objects (icons, shortcuts, files, folders)? How to delete, copy, move objects (icons, shortcuts, files, folders)?
10. Name ways to launch programs and open documents.

Group 3

1. How to setup Toolbar? How to return the standardToolbar, create your own? Draw the necessary dialog boxes, give an example.
2. How to adjust page margins, paragraph indents, line spacing? Draw the necessary dialog boxes and give an example.
3. What are tabulators? How to use them? Draw the necessary dialog boxes and give examples.
4. Working with a table: inserting a table; adding rows, columns, cells; highlighting table elements; resizing table elements. Give examples.
5. Working with a table: inserting a formula; repetition of title; merging and splitting; direction of the text. Give examples.
6. Framing and filling. Draw the required dialog box. Describe the required toolbar. Give examples.
7. Page number, footer, footnote, list. Working with them. Give examples.
8. What is an object WordArt ? Give examples.
9. How to draw geometric figures? Draw a dialog box for changing the parameters of geometric shapes. Give examples.
10. How to combine geometric shapes? How to place the shapes relative to each other and the text? Give examples.

Group 4

1. Copy or move a formula. Absolute, relative and mixed links. Arithmetic operators. Give examples.
2. Function syntax. Types of arguments. Comparison operators. Examples
3. Logical functions AND, OR, NOT. Syntax, application. Address operators. Give examples.
4. Logical functions TRUE, FALSE. Syntax, application. Text operator. Titles and names. Give examples.
5. Logical function IF. Syntax, application. Nested IF function. Give examples.
6. Mathematical functions. Syntax. Nested functions. Construction of formulas. Give examples.
7. Trigonometric functions. Syntax. The order of actions in formulas. Circular links. Give examples.
8. Logarithmic functions. Syntax. Links R 1 C 1. Give examples.
9. Rounding functions. Syntax. Function Wizard. Give examples.
10. Wrong values. Syntax. Give examples.

Assignments for the practical part of the test

When performing the practical part of the test, you must:

1. Place the student's full name, group number and the date the file was created in the header or footer.
2. In all tasks set:
   1. Margins, cm: top- 2.5; lower - 3.0; left 2.5; right 2.5.
   2. From the footer, cm 1.25.
   3. Paragraph boundaries and alignment as in the sample.
3. All task parameters (font size and style, line type and thickness, external borders and filling method, sizes of figures in drawings, etc.) should be maintained as in the sample.
4. Numbering of items in tasks is done using the menu item Format List of search...
5. Explanations for the tasks are given in the footnotes.
6. All names, positions, names of departments, dates, etc. can be changed.

Other books on similar topics:

See also in other dictionaries:

Unknown... Spelling dictionary-reference book

- [unknown], unknown, unknown; unknown, unknown, unknown. 1. One about which nothing is known yet, about which there is no information, unknown, unstudied. Unknown island. Some unknown citizen. Man of the unknown... ... Dictionary Ushakova

Unknown, unknown, unknown, unknown, unfamiliar, someone, someone, x (x); nameless, anonymous, dark. This is unknown to me, this is terra incognita for me, history is silent about this, it is covered in the darkness of the unknown. Unsolved...... Synonym dictionary

Unknown: Unknown is the title of several films. Unknown, Ernst Iosifovich Soviet and American sculptor ... Wikipedia

UNKNOWN, oh, oh; ten, tna. 1. Something about which they do not know, there is no information, which has not been defined, has not been studied. Unknown heroes. N. island. An equation with many unknowns (noun; unknown quantities; also transl.: about something very unclear, ... ... Ozhegov's Explanatory Dictionary

Man, stranger. Unknown time. Unknown side. Unknown, in the form of a noun. someone, a stranger. The unknown, in the form of a noun, mat. the required, claim, number that needs to be found by calculation, calculation. The unknown is tormenting. Intelligent... ... Dahl's Explanatory Dictionary Wikipedia

Ernst Iosifovich Neizvestny (born April 9, 1925 in the city of Sverdlovsk) Soviet and American sculptor. Biography Born into the family of doctor Joseph Moiseevich Neizvestny and children's poetess Bella Abramovna Dizhur (1903 2006), repressed in ... ... Wikipedia