Laboratory work in informatics 1. Collection of laboratory work in informatics. Find and replace operations

Ministry of Education of the Republic of Bashkortostan GAPOU Ufa Fuel and Energy College APPROVED Deputy Director for Academic Affairs: Ponomareva L.F. ______________ 2016 Methodical instructions for organizing and conducting laboratory work of students in the academic discipline Computer science and ICT 2 APPROVED by the Methodical Cycle Commission (name of the Commission) Minutes No. ________ dated "_________________" 2016. Developed on the basis of the Federal State Educational Standard of Secondary General Education for the academic discipline Informatics and ICT of the Federal State Educational Standard of Secondary Vocational Education by Profession / Specialty Chairman of the MCC ________________ / _____________ Deputy Director for SD _________________ / L.F. Ponomareva F.I.O. Compiled by L. M. Shaibakova lecturer at GAPOU Ufa Fuel and Energy College. 3 Explanatory note 1. The main goals and objectives 1. The implementation of laboratory work and practical tasks by students is carried out with the aim of: systematization, formation of skills, practical experience in accordance with the requirements for the results of mastering the discipline, professional module and on the basis of the list of formed competencies established by the work program discipline, professional module; generalizations, theoretical knowledge; improving the skills to apply the acquired knowledge in practice, realizing the unity of intellectual and practical activities; development of intellectual skills among future specialists: oilmen, power engineers, etc .; development of such professionally significant qualities as independence, responsibility, accuracy, creative initiative in solving the assigned tasks. consolidation of the received deepenings, 2. When carrying out laboratory work (practical exercises), the study group can be divided into subgroups if its number is at least 16 people. 3. Division into subgroups during laboratory work is carried out: by disciplines of general education, general professional, MDK, modules 4. The list of disciplines by which the division into subgroups is carried out is reflected in the annual curriculum, annually approved by the director of the college. 2. Rules for laboratory work and reporting requirements 1. The presence of students in the computer science room is not allowed: in outdoor outerwear (if there is a working wardrobe); with food, drinks, etc. 2. Cell phones should be set to silent or switched off during labs. 3. Students who are more than 5 minutes late are not allowed to attend classes. 4. Only students who have been instructed in the Safety Rules and strictly follow them are allowed to perform laboratory work. 5. ATTENTION! In case of violation of the Safety Rules, the student is suspended from performing laboratory work and re-submits the Safety Rules. 6. Laboratory work is performed individually, in exceptional cases in groups of two. 7. Time for laboratory work - 2 hours. Homework after laboratory classes - report preparation. 8. A prerequisite for admission to the current lesson is: the readiness to defend the previous completed laboratory work (the presence of a fully completed report on it) and the availability of preparation 4 for the upcoming laboratory work (knowledge of theoretical foundations, methods of work, order of execution, etc.) ... 9. ATTENTION! The volume of laboratory work by the number of tasks performed and individual exercises can be changed by the teacher. 10. Laboratory work can only be started with the permission of the teacher after receiving general instructions at the workplace. 11. When carrying out laboratory work, it is prohibited to: lean on computer tables, as well as place foreign objects on them; violate the rules and procedures for laboratory work; 12. ATTENTION! Failure by students to meet the requirements set out in this paragraph entails their suspension from laboratory work. 13. Turning on and off the computer is done only with the permission of the teacher. 14. The report on laboratory work should be individual, ie. provided for protection by each student. 15. The report on laboratory work in the general case should contain: title page (see p. Appendix # 2); presentation of the topic and purpose of the work; the content of the work done; answers to security questions; conclusion about the work done; an example of a report is in Appendix # 1. 16. Design: in writing (black paste) on A4 paper, on one side of the sheet. 17. A student who, for some reason, has not completed laboratory work on time, must know that: he has the right to practice laboratory work; development of laboratory work is carried out at a time specially allotted for these purposes. 3. Evaluation criteria: The student receives the maximum number of points "excellent" if: gives correct formulations, precise definitions, concepts of terms; can justify his answer, give the necessary examples; correctly answers additional questions of the teacher, aimed at finding out the degree of understanding of the student of this material; the report is drawn up according to the requirements, all the necessary calculations, tables, figures are present. The student receives a mark "good" if: the task is incomplete, but correctly stated; during the presentation, 12 insignificant mistakes were made, which he corrects after the teacher's remarks; gives correct formulations, precise definitions, concepts of terms; can justify his answer, give the necessary examples; correctly answers the additional questions of the teacher, aimed at finding out the degree of understanding of the student of this material. 5 The student receives the mark "satisfactory" if: the task is incomplete, but correctly stated; 1 significant error was made in the presentation; knows and understands the main provisions of this topic, but admits inaccuracies in the formulation of concepts; sets out the performance of the assignment not logically and consistently enough; finds it difficult to answer the teacher's questions. The student receives the mark "unsatisfactory" if: the task is incompletely stated; significant errors were made in the presentation; if it does not meet the requirements established by the teacher for this type of work. 6 Laboratory work No. 1 Topic: Information resources of society. Educational information resources. Working with software Purpose: to learn how to use educational information resources, to search for the necessary information with their help; master the methods of working with software. THEORETICAL INFORMATION The concept of the "information resource of society" (IRO) is one of the key concepts of social informatics. The widespread use of this concept began after the publication in 1984 of the book by G.R. Gromov. "National information resources: problems of industrial exploitation". “An information resource is knowledge presented in a project form” - such a short and insufficiently strict definition was proposed by Professor Yu.M. Kanygin. Thus, information resources are knowledge prepared for appropriate social use. The concept of IRO accumulated in the knowledge society can be considered in the narrow and broad sense of the word. IRO in the narrow sense of the word is knowledge that is already ready for expedient social use, that is, alienated from the carriers and materialized knowledge. IRO in the broad sense of the word includes all knowledge alienated from carriers and included in the information exchange, existing both in oral and in materialized form. The concept of a resource is defined in the Dictionary of the Russian language S.I. Ozhegova as a reserve, a source of something. As for information resources, this concept is relatively new. It is just beginning to enter the life of modern society, although in recent years it has become more and more used not only in scientific literature, but also in social and political activity. The reason for this, of course, is the global informatization of society, in which the especially important role of information and scientific knowledge is becoming increasingly recognized. To classify information resources, the following most important parameters can be used: subject of information stored in them;   form of ownership - state (federal, subject of the federation,    municipal), public organizations, joint-stock, private; availability of information - open, closed, confidential; archival, scientific and technical;  Belonging to a certain information system - library, source of information - official information, publications in the media, statistical reporting, results of sociological research; 7  purpose and nature of use of information - massive regional, departmental;  form of information presentation - text, digital, graphic, multimedia; type of information carrier - paper, electronic.  By educational information resources, we mean textual, graphic and multimedia information, as well as executable programs (distributions), that is, electronic resources created specifically for use in the learning process at a certain level of education and for a certain subject area. When working with educational resources, such concepts as the subject and object of these resources appear. We will classify the subjects of information activity as follows:     the subject that creates objects (all users of the educational system are a teacher, a student); subject using objects (all users of the educational system); a subject administering objects, that is, providing an environment for working with objects of other subjects (network administrators); a subject that controls the use of objects by subjects (engineers). Educational electronic resources include:          educational materials (electronic textbooks, teaching aids, abstracts, diplomas), educational materials (electronic methods, curricula), scientific and methodological (dissertations, candidate works), additional text and illustrative materials (laboratory works, lectures), testing systems (tests - electronic knowledge check), electronic full-text libraries; electronic periodicals in the field of education; electronic tables of contents and abstracts of articles of periodicals in the sphere of education, electronic archives of issues. WORK PROCESS Task number 1. 1. Download the Internet. 2. In the search bar, enter the phrase "catalog of educational resources." 3. List which sections include educational resources on the Internet. 4. Describe any three. Task number 2. Use the Universal Reference Encyclopedia to find answers to the following questions: 8 1. Specify the time when the Gregorian calendar was approved. 2. what is the diameter of Saturn. 3. Specify the lethal sound level. 4. what is the boiling point of iron. 5. what is the melting point of iodine. 6. Indicate the speed of rotation of the Earth around the Sun. 7. what is the mass of Jupiter. 8. which mountain is the highest in Africa. 9.What is HTTP? 10. Indicate the years of the reign of Ivan III. 11. Indicate the years of the reign of Catherine II. 12.When was Blaise Pascal born? 13. Indicate the years of Khrushchev N.S. 14. what year was the first wooden bicycle invented. Task number 3. Answer the questions: 1. What do you mean by information resources? 2. List the parameters for classifying information resources. 3. What is meant by educational information resources? 4. What can be attributed to educational electronic resources? Evaluation criteria: the tasks were completed correctly and in full; answers to control questions are clear, meaningful; the report was delivered on time. 9 Laboratory work No. 2 Topic: Discrete (digital) presentation of text, graphic, sound information and video information. Purpose: to study ways of presenting text, graphic, sound information and video information, to learn how to write numbers in various number systems. Discrete representation of information: coding a color image in a computer (raster approach). Sound and video presentation and processing. THEORETICAL INFORMATION All information that the computer processes must be represented in binary code using two digits 0 and 1. These two characters are usually called binary digits or bits. Any message can be encoded with two digits 0 and 1. This was the reason that two important processes must be organized in a computer: encoding and decoding. Encoding is the transformation of input information into a form that can be perceived by a computer, that is, a binary code. Decoding - converting data from binary code into a human-readable form. From the point of view of technical implementation, the use of a binary number system for encoding information turned out to be much simpler than the use of other methods. Indeed, it is convenient to encode information in the form of a sequence of zeros and ones, if these values ​​are presented as two possible stable states of an electronic element: 0 - no electrical signal; 1 - presence of an electrical signal. These conditions are easy to distinguish. The disadvantage of binary encoding is long codes. But in technology it is easier to deal with a large number of simple elements than with a small number of complex ones. Methods of encoding and decoding information in a computer, first of all, depends on the type of information, namely, what should be encoded: numbers, text, graphics or sound. Analog and discrete coding A person is able to perceive and store information in the form of images (visual, sound, tactile, gustatory and olfactory). Visual images can be saved as images (drawings, photographs, and so on), and sound images can be recorded on records, magnetic tapes, laser disks, and so on. Information, including graphic and sound, can be presented in analog or discrete form. With an analog representation, a physical quantity takes on an infinite set of values, and its values ​​change continuously. With a discrete representation, a physical quantity takes on a finite set of values, and its value changes abruptly. 10 Conversion of graphic and audio information from analog to discrete form is carried out by sampling, that is, dividing a continuous graphic image and a continuous (analog) audio signal into separate elements. In the sampling process, coding is performed, that is, the assignment of each element to a specific value in the form of a code. Sampling is the transformation of continuous images and sound into a set of discrete values ​​in the form of codes. Image encoding There are two ways to create and store graphic objects in your computer - as a raster image or as a vector image. For each type of images, a different coding method is used. Bitmap coding A bitmap is a collection of dots (pixels) of different colors. Pixel is the smallest area of ​​the image, the color of which can be set independently. In the process of image encoding, its spatial sampling is performed. Spatial sampling of an image can be compared to building an image from a mosaic (a large number of small multi-colored glasses). The image is divided into separate small fragments (dots), and each fragment is assigned a value for its color, that is, a color code (red, green, blue, and so on). For a black and white image, the information volume of one point is equal to one bit (either black or white - either 1 or 0). For four colors - 2 bits. For 8 colors, 3 bits are required. For 16 colors, 4 bits. For 256 colors - 8 bits (1 byte). The image quality depends on the number of dots (the smaller the dot size and, accordingly, the larger the number, the better the quality) and the number of colors used (the more colors, the better the image is encoded). In order to form an image on the monitor screen, information about each point (point color code) must be stored in the video memory of the computer. Let's calculate the required amount of video memory for one of the graphics modes. In modern computers, the screen resolution is usually 1280x1024 pixels. Those. total 1280 * 1024 = 1310720 points. With a color depth of 32 bits per point, the required amount of video memory is: 32 * 1310720 = 41943040 bits = 5242880 bytes = 5120 KB = 5 MB. Bitmaps are very sensitive to scaling (zoom in or 11 out). When reducing a raster image, several neighboring points are converted into one, therefore, the distinguishability of small details of the image is lost. As the image is zoomed in, the size of each dot increases and a stepped effect appears that can be seen with the naked eye. Coding of vector images A vector image is a collection of graphic primitives (point, line, ellipse ...). Each primitive is described by mathematical formulas. The encoding depends on the application environment. The advantage of vector graphics is that the files that store vector graphics are relatively small. It is also important that vector graphics can be enlarged or reduced without loss of quality. Binary Coding of Sound The use of computers for sound processing began later than numbers, texts, and graphics. Sound is a wave with continuously changing amplitude and frequency. The larger the amplitude, the louder it is for a person, the higher the frequency, the higher the tone. Sound signals in the world around us are unusually diverse. Complex continuous signals can be represented with sufficient accuracy as the sum of a certain number of the simplest sinusoidal oscillations. Moreover, each term, that is, each sinusoid, can be precisely specified by a certain set of numerical parameters - amplitude, phase and frequency, which can be considered as a sound code at a certain moment in time. In the process of encoding an audio signal, its time sampling is performed - a continuous wave is divided into separate small time sections and a certain amplitude value is set for each such section. Thus, the continuous dependence of the signal amplitude on time is replaced by a discrete sequence of loudness levels. Each volume level is assigned a code. The more volume levels will be allocated during the encoding process, the more information will carry the value of each level and the better the sound will be. The quality of binary audio coding is determined by the coding depth and sampling rate. Sampling rate - the number of measurements of the signal level per unit of time. The number of volume levels determines the coding depth. Modern sound cards provide 16-bit audio coding depth. The number of loudness levels is equal to N = 216 = 65536. 12 Presentation of video information Recently, a computer is increasingly used to work with video information. The simplest such job is watching movies and video clips. It should be clearly understood that the processing of video information requires a very high speed of the computer system. What is a film from a computer science point of view? First of all, it is a combination of sound and graphic information. In addition, to create a motion effect on the screen, an inherently discrete technology of fast change of static images is used. Studies have shown that if more than 1012 frames are replaced in one second, then the human eye perceives the changes in them as continuous. WORKING PROCESS. Task number 1. Using the symbol table, write down a sequence of decimal numeric codes in Windows encoding for your full name. The symbol table is displayed in the MS Word editor using the command: Insert tab Symbol Other symbols → → In the Font field, select Times New Roman, in the from field, select the Cyrillic alphabet. For example, for the letter "A" (Russian capital), the character code is 192. Example: I V A N O V A R T E M 200 194 192 205 206 194 192 208 210 197 204 13 P E T R O V I Ch 207 197 210 208 206 194 200 215 Task number 2. Using the standard NOTEBOOK program, determine which Windows-encoded phrase is given by the sequence of numeric codes and continue the code. Launch NOTEBOOK. Using the additional numeric keypad, while holding down the ALT key, enter the code, release the ALT key. The corresponding symbol appears in the document. 0255 0243 0247 0243 0241 0252 0226 0211 0210 0221 0202 0239 0238 0241 0239 0229 0246 0232 0224 0235 0252 0237 0238 0241 0242 0232 fill in the top line with the name of the specialty 14 Task No. 3. Fill in the gaps with numbers: KB KB KB KB = = = byte byte byte = = = bit bit bit Task №4. Convert the decimal number to the binary number system and make a check: 1. 2. Task number 5. Answer the questions: 1. What is information? 2. List the properties of the information. 3. What types of information do you know? 4. Give examples of analog presentation of graphical information. 5. What is a pixel? 6. What is a number system? 7. Write a rule for converting decimal numbers to binary. 8. List the units of measurement of information. fifteen

LABORATORY WORKS ON INFORMATICS

FOR ECONOMIC AND MATHEMATICAL FACULTY

(stream Mbd, MKbd - 1 course)

Lab 1: Writing and Editing in the Writer Word Processor (OpenOffice.org) 3

Processor setting ................................................ .................................................. ........... 3

Typing................................................ .................................................. ............................ 3

Formatting ................................................. .................................................. .................... five

Search and replace operations .............................................. .................................................. ..... 6

Lists ................................................. .................................................. .................................... 6

Applying Styles ................................................ .................................................. ................ 7

Exercises for independent work .............................................. .............................. eight

Control questions on the topic: ............................................. ................................................. eight

Laboratory work 2. Embedding objects in a document .......................................... ................ nine

Working with tables ............................................... .................................................. ................. nine

Creation of drawings and diagrams .............................................. .................................................. ...... nine

Methods for embedding objects prepared in other applications ...................... 10

Adjusting the picture ................................................ .................................................. ....... eleven

Editing formulas ................................................ .................................................. ...... eleven

Auto numbering of objects ................................................ .................................................. .... 12

Exercises for independent work .............................................. ............................ 12

Control questions on the topic: ............................................. ............................................... 12

Laboratory work 3. Preparation of a document for printing .......................................... ............ 13

Check spelling ................................................ .................................................. ..... 13

Setting headers and footers ................................................ .................................................. .... 13

Creating footnotes and endnotes ............................................. ...................................... 13

Pagination................................................ .................................................. ............. 13

Seal................................................. .................................................. ................................... fourteen

Control questions on the topic: ............................................. ............................................... fourteen

Lab 4. Calculation in Calc ........................................... ....................................... fifteen

Using formulas ................................................ .................................................. ........ 17

Inserting functions ................................................ .................................................. .................. 18

Table design ................................................ .................................................. .......... nineteen

Control questions on the topic: ............................................. ............................................... nineteen

Laboratory work 5. Business graphics ............................................ .......................................... twenty

Building a diagram ................................................ .................................................. ....... twenty

Editing a diagram ................................................ .................................................. twenty

Exercises for independent work .............................................. ............................ 21

Control questions on the topic: ............................................. ............................................... 21

Lab 6: Some Features of OpenOffice.org Calc ... .... 22

Date and time............................................... .................................................. ........................... 22

Logic functions ................................................ .................................................. ........... 23

Mathematical functions ................................................ .................................................. ... 24

Control questions on the topic: ............................................. ............................................... 24

Laboratory work 7. Statistical data processing ........................................... ............ 25

Numerical characteristics of the sample ............................................... ...................................... 25

Lab 8. Functions Using Criteria .......................................... ............ 26

Mathematical functions. SUMIF function ........................................... 28

Laboratory work 9. Processing lists in CALC .......................................... ..................... 34

Creating a list ................................................ .................................................. ................... 34

Sorting the list ................................................ .................................................. ............... 35

Searching with a Standard Filter ............................................. ............................... 35

Automatic data filtering ................................................ .................................................. ..... 36

Advanced filtering ................................................ .................................................. .... 36

Laboratory work 10. Basics of work in DBMS BASE ......................................... ................... 37

Database creation............................................... .................................................. .......... 37

Changing the database ............................................... .................................................. ....... 39

Query Processing................................................ .................................................. .............. 40

Control questions on the topic: ............................................. ............................................... 40

Lab 1: Writing and Editing in the Writer Word Processor (OpenOffice.org)

Processor setup

Download the Writer word processor (OpenOffice.org) using Start / Programs / Writer (OpenOffice.org).

Download help system ... Check out the help system: its structure is the same as the help for the Windows operating system.

Consider the elements of the Writer window. Using the View menu, set display mode - Page layout, make sure you have rulers (if necessary, connect them using the menu View). Try other display modes like using the menu View, and using the buttons in the lower left part of the window: the purpose of each button can be determined by the tooltip. Check for two panels - Standard and Formatting. If other panels are installed, disable them (View / Toolbars). Install scale image 100% (View / Scale / 100% / OK or the Scale field with a drop-down list in the standard toolbar).

For installation parameters of work word processor, select Tools / Options. / OpenOffice.Writer Tab View check the checkboxes for the commands Show graphic objects and Tooltips, and all teams Window(status bar, vertical ruler, scroll bars); in the tab General set the units of measurement - centimeters, on the tab Spelling disable commands Check spelling automatically and Check grammar automatically- these checks slow down the work, they can be carried out when the document is finalized. In the tab Preservation choose Autosave every 10 minutes... Review the settings on the other tabs. To implement the settings made, click on the OK button.

Page settings configurable using the menu Format / Pages a, where the sheet size and orientation, margins and other parameters can be set. Using the appropriate dialog box tabs Page settings, set the paper size to A4, orientation - portrait, margins - 20 mm on all sides, then click OK.

Typing

Check the settings in the format bar: style - Usual, font (typeface) - Times New Roman, the size font - 10. In the work area, enter the text below, using the appropriate buttons alignment center (for reference), width (for the body of the text), right (last name). Print a point in the Russian layout - by pressing the extreme right key in the bottom row (sign?), Comma - the same key when pressed Shift... To skip a line, use the enter key Enter.

For deleting erroneously entered text use the delete keys Backspace or Delete... Typically, a word processor works in insert mode , when a newly entered character expands the already entered characters. IN replacement mode, newly entered characters replace previously entered ones. To enable or disable the replacement mode, double-click on the indicator ZAM on the status bar.

Writer allows you to automate some of your typing operations. Repeated words can be saved as autotext , and they will then be entered according to the first characters or special designation. Add, for example, the word "Informatics" to the autotext. To do this, follow these steps: type the word Informatics in the text and copy it to the clipboard, then select the Edit \ Autotext menu, enter the copied word Informatics from the clipboard into the Autotext panel - the copied word Informatics, make sure the category is marked standard, click the button autotext, select from the pop-up menu - create text, then click on the button add... Now start entering this word in the typed text - the computer will offer to automatically insert the corresponding word; just press the key to insert Enter.

Similarly, Writer fixes some common mistakes: it produces autocorrect ... For example, an incorrectly entered word “bulletin” will be automatically replaced with the correct one - “bulletin”. You can set up AutoCorrect using the Service / AutoCorrect / Replace menu. Set up the replacement of the III characters with the text "Ivanov Ivan Ivanovich". On the menu autocorrect review the list of such corrections, add new words to it.

Enter the text (regardless of the paragraph borders, they will be changed further):

Dear Ivan Petrovich!

I inform you that on March 10 at 10.00 in the conference hall of the open joint stock company "Integral" the next meeting of creditors will take place with the agenda:

Approval of changes to the external management plan of OJSC "Integral".

You must have with you:

passport or identity card

power of attorney

statement of reconciliation of your company's accounts with Integral OJSC

External manager of OJSC "Integral"

A.A. Alexandrov

When editing a document, sometimes you need to clearly see where the key is pressed Enter how many times the space bar has been pressed, etc. - that is, to see special non-printable characters. To do this, use the button Non-printable characters in the standard toolbar (¶). Click this button and view the legend and placement of these symbols. Disable button Non-printable characters.

Formatting

Selection of a fragment of text, as already noted, is done by dragging with the mouse. For highlighting a single line silks are made to the left of the line, a single word - double click on the first letter of this word ... Select paragraph the whole can be done by clicking to the left of the beginning of the paragraph. Try all of these methods for selecting fragments.

postponed or copied via the clipboard to any place in the active document, as well as to another document. Any of the previously discussed methods are used: buttons Cut out, Copy, Insert; the corresponding shortcut menu or menu commands Edit; keyboard shortcuts: Ctrl + X- cut out, Ctrl + C- copy to clipboard, Ctrl + V- paste from clipboard. When moving a fragment to a small distance, another method is more convenient: place the mouse pointer in the selected area (pointer view - an arrow) and drag the fragment with the left mouse button to the desired location (the pointer will change its appearance - now it is an arrow with a rectangle at the bottom). Similarly, a fragment can be copied: the same actions are performed while the key is pressed Ctrl.

The selection can be deleted by pressing the delete key Delete... Copy by dragging and dropping the fragment of the second sentence " at 10.00 " anywhere else on the same line. Delete the copied section.

Select all prepared text. Change the font size to 12.

For left and right installation text boundaries use the markers on the ruler. For installation paragraph indentation (first line indent in a paragraph) you can press the tab key Tab... The amount of indents can be adjusted with the corresponding marker on the horizontal ruler.

Set the line spacing using the Format / Paragraph menu tab - Indents and spacing, to the value one and a half... See what other types of line spacing are available to you. You can also set the line spacing using the corresponding buttons on the toolbar formatting... Find these buttons, select a paragraph of text, and try different line spacing values.

View different ways to align text in a paragraph: left, right, center, justified, using the appropriate buttons on the format bar or the paragraph settings menu.

To fine-tune the parameters of the paragraph, you can use the Format / Paragraph menu tab - Indents and spacing. Find on the tab the text alignment setting, its style (main text); indentation set for the specified paragraph:

ü Left... This is the indentation of the entire paragraph to the left of the text border;

ü On right... This is the indentation of the entire paragraph to the right of the text border;

ü Front... This is the indentation of the entire paragraph down from the previous paragraph;

ü After... This is the indentation of the entire paragraph upward from the subsequent paragraph.

Select the paragraph starting with the words "I inform you" and set the indent on the left - 1cm, indent on the right - 1cm, the interval before the paragraph - 1cm, the interval after the paragraph - 1cm. See how the text has changed.

Select the first line as a fragment and style it with a different font and font size using the toolbars and the context menu. Set this line to a sparse font, for this use the menu Format / Symbol... Review all the possible settings reflected on the tabs of this menu and find the setting for the character spacing. Set the font sparse to 3 points (pt.). See how the spelling of the string has changed. Try setting the condensed font type.

For canceling of wrongly performed actions use the button Cancel in the standard toolbar: it undoes the last performed action. If several actions need to be canceled, they can be selected in the list opened using the arrow to the right of the button Cancel and canceled by pressing this button once. An incorrectly canceled operation can be restored using the button. Return... Drag and drop the first sentence of the document anywhere. Cancel this action with the button Cancel.

Find and replace operations

Suppose that a mistake is made in the name of the organization: the JSC is called not "Integral", but, for example, "Interval". How to make changes without retyping a misspelled word every time? Use the Edit / Replace menu. In the dialog box, enter the word Integral in the Find field, and the word Interval in the Replace field (click on it to activate the required field). Click Find Next, then Replace. If you are sure that everything needs to be replaced, click the appropriate button.

Lists

The simplest way to style the list is to use the buttons on the formatting toolbar. Highlight two agenda items in the prepared document in the form of a block: arrange them in the form numbered list ... To do this, click on the button Numbered list in the format bar.

The list of documents that you need to have with you, fill out in the form bulleted list : select the corresponding three lines, and click on the button Markers... If you are not satisfied with the look of the markers, you can change them using the Format / Bullets and Numbering menu (or a similar context menu) and select one of the available options. Using a tab Images other markers can be selected. The indentation of the list can be adjusted using the buttons Decrease / Increase Indent.

Using the same menu, you can organize and tiered list ... To do this, in the Format / List menu, you can configure the type of levels of the created list, the type of their numbering, indents and other parameters. Next, create a regular numbered list, where all the numbering will turn out to be one level. Next, use the TAB key on your keyboard or the buttons Decrease / Increase Indent go to the desired level at each point.

You can use the Bullets and Numbering panel to make changes to lists.

Suppose that in a sequence of automatically numbered paragraphs, you need one unnumbered paragraph, as in the example:

1) first paragraph

2) second paragraph

third paragraph without numbering

3) fourth paragraph

This can be done in the following ways:

Method 1: we number all paragraphs without exception; then we place the cursor in front of the third paragraph and press the key , to erase one character to the right. The paragraph loses its number.

Method 2: we number all paragraphs without exception; then place the cursor in front of the third paragraph and click on the Numbering icon in the toolbar. The paragraph loses its number and text indentation.

Method 3: number paragraphs 1 and 2 using the Numbering icon in the toolbar. Next, go to paragraph 4, select Format - Markers and numbering - Settings tab and set the number 3 in the counter of the initial value.

Create three lists and in each try each of the ways to exclude an item from the general list.

Save the created document.

Applying Styles

You can style each paragraph separately, but for a large document it takes a lot of time. Therefore, all modern office suites simplify this procedure through the use of styles. A paragraph style determines the formatting of both the paragraph itself (indents, spacing, alignment, etc.) and the formatting of characters in the paragraph (font, size, etc.).

To set a paragraph style, place the cursor on it and click on the Styles and Formatting button in the toolbar or select Format / Styles from the menu. Next, the desired style is selected from the list.

To change an existing style, select it in the Styles and Formatting button in the window, right-click and select the menu Change.

To create your own paragraph style, select the text formed according to your requirements in the text. Open the Styles and Formatting menu and click the button Create style from selection.

Create and demonstrate your own paragraph style.

Review the settings of the INDEX and SYMBOL menu by calling them using the context menu or from the FORMAT window menu. Try all the possible settings in them and learn how to style the text with them.

Create a new document (Create button) with page parameters - A4 format, orientation - portrait, left and right margins 3 cm each, top and bottom - 2 cm each; type the text of the Lists section in it. Center the heading. Make two copies of the text in the same document. In the first copy, change the font type (typeface) and size. Set sparse spacing between characters. Increase the left and right margins. In the second copy, change the single line spacing to double. Set the spacing before the second paragraph 1 cm, after it - 2 cm.

Create a file of four paragraphs of text, for each paragraph set a different font, style, line spacing and text alignment. Highlight individual words in the text by setting their style - bold, italic, underline. Add three lists to the text: bulleted, numbered, and tiered. Save the document as Lists in the My Documents folder.

To view a Notification document, click on its name in the Window menu: this menu command activates any of the documents loaded in Writer and arranges them all at the same time on the screen using the Arrange All item. If necessary, you can change the position of the windows by resizing the windows by dragging their borders and moving them to the desired position behind the title bar. Arrange the document windows Notification and List in different ways.

Control questions on the topic:

1. Setting page parameters;

2. Setting up autotext and autocorrect;

3. Setting the font of the text;

4. Setting the parameters of the paragraph;

5. Document style, creating your own style.

Creation of drawings and diagrams

The drawing can be created using a graphics editor and embedded in the document. Simple drawings and diagrams are often more convenient to prepare using the built-in word processor tools. Connect the toolbar for drawing View / Toolbars / Draw (or the Draw button in the standard toolbar).

Draw a block diagram of the Faculty of Economics and Mathematics. Select AutoShapes / Basic Shapes / Rounded Rectangle, drag the mouse pointer from the upper left to the lower right corner of the drawn rectangle, release the mouse button (while the drawn shape remains selected: at its corners and midpoints - squares-markers), select Action / Align / Distribute / Align Center: The rounded rectangle will appear exactly in the center of the document. To edit the contour line of a rectangle, select it and click on the Line type button: select the required type. Without removing the selection, click on the Inscription button, and then inside the shape, type the text: Faculty of Economics and Mathematics. Select the text of the label and format it: center it, choose the appropriate font type and size.

Below the rounded rectangle, by analogy, draw two identical ovals (you can use the Oval button directly in the Drawing panel): in one enter the inscription Directions and specialties, in the other - Departments. To align the ovals, select both shapes (to do this, hold down the Shift), do Action: Align Top (this will align the ovals with the top of the page), and then drag them to the desired position with the mouse; center if necessary. Draw arrows between the rounded rectangle and each of the ovals: press the Arrow button and drag the mouse from the beginning of the arrow at the rounded rectangle to its end at the oval. Use the Linetype button to format the arrow.

Under each of the ovals, draw in the form of rectangles a list of the corresponding structures, for example, for the departments: Applied Mathematics and Informatics, Economics and Management, Economic Theory, CAD, Higher Mathematics.

If an action was taken by mistake, use the Cancel button; the selected object can be deleted by pressing the key Delete.

Image Adjustment

An inline picture can be moved: once selected, it is dragged and dropped anywhere in the document with a mouse click. To resize the picture, drag one of its borders by the corresponding square ( resize handle ). Try these steps in the inline illustration.

Various methods of image adjustment are possible using the Images toolbar or the context menu. Install this panel and try out the possibilities of its tools: change the contrast and brightness. The most important image adjustment tool is the button, which provides flow around a picture embedded in the document with text: above and below the picture, around the frame, along the contour, etc. Enter any text (for example, copy the text from the Notice file), overlay the previously embedded clipart on it and try out various options for wrapping. Use the context menu / Wrap if necessary.

Editing formulas

To enter simple formulas, the Style / Subscript or Superscript (degree) menu options are sufficient. In the new file, enter the formula y i ¹a + b x 3 (To enter an inequality sign and Greek letters, use the insertion of symbols: check the setting of the Symbol font, click on the corresponding symbol, then click the Insert button; after entering all the necessary characters, click Close. To enter the index and degree, press the keys of the desired letters on the keyboard, select letter and set Subscript or Superscript. x and y highlight in italics.

To enter more complex formulas, use a special formula editor (menu Insert / Object / Formula). Enter the dependence for the distribution function of the normal law

To do this, load the formula editor and enter the left side of the formula from the keyboard in the usual way. To enter a fraction before an integral, use Fraction and Radical Templates, to enter Greek letters, use the Greek lowercase button. Similarly, choose the appropriate templates for the integral, degrees, infinity symbol. Use the mouse to navigate between formula fields. Redefine the style and sizes of symbols if necessary. Click outside the formula to finish entering the formula. If you want to edit the formula, double-click it.

Auto numbering of objects

Objects that require numbering include: figures, formulas and tables. Let's consider the sequential numbering of figures in the text. In the context menu of the inserted picture, select the Title item. Set the numbering style and separator in accordance with the requirements for document design. After that, the drawing automatically gets the next number. For a link in the text to a figure, write a link of the type "as shown in the figure", select the main menu command Insert - Cross-reference. In the dialog box, select the field type Pictures and the picture we need. After pressing the Insert button, the figure number is written to the cursor position. When you add or delete drawings, the numbers change automatically.

It is most convenient to number figures without text wrapping.

Number the three figures and insert links to them in the text.

Exercises for independent work

Insert a table with the results of your last session in your file: discipline, date of delivery, grade. Spend sorting(ordering of data) tables in alphabetical order of disciplines, by dates of delivery, by received grades (Table / Sorting…). Add a new row Total to the table and, under the column with grades, calculate your total score using the sum function (Table \ Sum toolbar). To the cell of the sum, insert a corresponding note (Insert \ Note) Deal with the details of these operations yourself, using the help.

test questions

(KBd stream - 1 course)

Lab 1: Writing and Editing in the Writer Word Processor (OpenOffice.org) 3

Processor setup 3

Typing 3

Formatting 5

Find and replace operations 6

Applying Styles 7

Self-study exercises 8

Control questions on the topic: 8

Lab 2: Embedding Objects in a Document 8

Working with tables 8

Creation of pictures and diagrams 9

Methods for embedding objects prepared in other applications 10

Image Adjustment 11

Editing formulas 11

Auto numbering of objects 11

Self-study exercises 12

Control questions on the topic: 12

Lab 3. Preparing a document for printing 12

Spell check 12

Setting up headers and footers 13

Creating Footnotes and Endnotes 13

Page Numbering 13

Control questions on the topic: 14

Lab 4: Calculating in Calc 14

Using formulas 17

Inserting Functions 18

Table design 19

Control questions on the topic: 19

Lab 5. Business graphics 19

Building a diagram 19

Editing Chart 20

Self-study exercises 20

Control questions on the topic: 21

Lab 6: Some Features of OpenOffice.org Calc 21

Date and time 21

Logic functions 22

Math functions 23

Control questions on the topic: 24

Laboratory work 7. Statistical processing of data 24

Numerical characteristics of the sample 24

Lab 8. Functions Using Criteria 25

Mathematical functions. SUMIF Function 28

Lab 9. Processing Lists in CALC 34

List creation 34

Sorting List 35

Search using a standard filter 35

Data Autofiltration 35

Advanced filtering 36

1. Lab 1. Writing and Editing in the Writer Word Processor (OpenOffice.Org)

   1. Processor setup

Download the Writer word processor (OpenOffice.org) using Start / Programs / Writer (OpenOffice.org).

Download help system ... Check out the help system: its structure is the same as the help for the Windows operating system.

Consider the elements of the Writer window. Using the View menu, set display mode - Page layout, make sure you have rulers (if necessary, connect them using the menu View). Try other display modes like using the menu View, and using the buttons in the lower left part of the window: the purpose of each button can be determined by the tooltip. Check for two panels - Standard and Formatting. If other panels are installed, disable them (View / Toolbars). Install scale image 100% (View / Scale / 100% / OK or the Scale field with a drop-down list in the standard toolbar).

For installation parameters of work word processor, select Tools / Options. / OpenOffice.Writer Tab View check the checkboxes for the commands Show graphic objects and Tooltips, and all teams Window(status bar, vertical ruler, scroll bars); in the tab General set the units of measurement - centimeters, on the tab Spelling disable commands Check spelling automatically and Check grammar automatically- these checks slow down the work, they can be carried out when the document is finalized. In the tab Preservation choose Autosave every 10 minutes... Review the settings on the other tabs. To implement the settings made, click on the OK button.

Page settings configurable using the menu Format / Pages a, where the sheet size and orientation, margins and other parameters can be set. Using the appropriate dialog box tabs Page settings, set the paper size to A4, orientation - portrait, margins - 20 mm on all sides, then click OK.

Collection of laboratory works on "Informatics" and guidelines for their implementation

Section 1. System Software....................................................................................................................................
Laboratory work No. 1. Basic Techniques for Working with MS-DOS .......................................... ...............
Laboratory work No. 2. Basic techniques for working in Windows: Explorer, shortcuts ......................
Laboratory work No. 3. Basic techniques for working in Windows: file search, recovery
information ................................................. .................................................. .................................................. ...
Laboratory work No. 4. Basic methods of working in Windows OS: Total Commander .........................
Laboratory work No. 5. Archiving ................................................. .................................................. .........
Section 2. Application software...............................................................................................................................
Laboratory work No. 6. Formatting text in MS Word editor ............................................ ..
Laboratory work No. 7. MS Word: lists, insertion and formatting of autoshapes. ............................

Laboratory work No. 8. MS Word: splitting text into columns, inserting and formatting a picture.

..........................................................................................................................................................................
Laboratory work No. 10. MS Word: Insert and Format a Table, Insert Formula into
document, insertion and formatting of the caption and picture. .................................................. ......................
Laboratory work No. 11. MS Word: drawing flowcharts, labels and autoshapes ............................
Laboratory work No. 12. MS Word: inserting various objects into a document .....................................
Laboratory work No. 13. MS Word: pasting and formatting and tables, formulas. .........................
Laboratory work No. 14. MS Word: creating document templates using PI "Forms" .....
Laboratory work No. 15. MS PowerPoint: creating a presentation. .................................................. .......
Laboratory work No. 15. MS PowerPoint: adding animation. .................................................. .......
Laboratory work No. 16. MS Excel: creating and formatting a simple table. .................................
Laboratory work No. 17. MS Excel: the simplest calculations in MS Excel, cell format. ........................
Laboratory work No. 18. MS Excel: absolute and relative addressing ......................................
Laboratory work No. 19. MS Excel: functions. .................................................. .......................................
Laboratory work No. 20. MS Excel: data analysis functions. .................................................. ...........
Laboratory work No. 21. MS Excel: building charts. .................................................. .................
Laboratory work No. 22. MS Excel: graphing ............................................. ........................
Laboratory work No. 23. MS Excel: independent work on charting. ...................
Laboratory work No. 24. MS Excel: sorting and filtering data ........................................... .....
Section 3. Working on the Internet..................................................................................................................
Laboratory work No. 25. Searching for information on the Internet ............................................. ................
Laboratory work No. 26. Email................................................ ..........................................
Methodical instructions for laboratory work No. 1 .......................................... ..................
Methodical instructions for laboratory work No. 2 .......................................... ..................
Methodical instructions for laboratory work No. 3 .......................................... ..................
Methodical instructions for laboratory work No. 4 .......................................... ..................

Methodical instructions for laboratory work No. 5 .......................................... ..................
Methodical instructions for laboratory work No. 6 .......................................... ..................
Methodical instructions for laboratory work No. 7 .......................................... ..................
Methodical instructions for laboratory work No. 8 .......................................... ..................
Methodical instructions for laboratory work No. 9 .......................................... ..................
Methodical instructions for laboratory work No. 10 .......................................... ................
Methodical instructions for laboratory work No. 11 .......................................... ................
Methodical instructions for laboratory work No. 13 .......................................... ................
Methodical instructions for laboratory work No. 14 .......................................... ................
Methodical instructions for laboratory work No. 15 .......................................... ................
Methodical instructions for laboratory work No. 16 .......................................... ................
Methodical instructions for laboratory work No. 17 .......................................... ................
Methodical instructions for laboratory work No. 18 .......................................... ................
Methodical instructions for laboratory work No. 19 .......................................... ................
Methodical instructions for laboratory work No. 20 .......................................... ................
Methodical instructions for laboratory work No. 21 .......................................... ................
Methodical instructions for laboratory work No. 22 .......................................... ................
Methodical instructions for laboratory work No. 24 .......................................... ................
Methodical instructions for laboratory work No. 25 .......................................... ................
Methodical instructions for laboratory work No. 26 .......................................... ................

Section 1. System Software

Laboratory work No. 1. Basic techniques of work in MS-DOS OS.

Purpose of work: to learn how to view the contents of disks and folders, create directories, copy, move, rename, delete files and directories.

1 Create file 1.txt, 2.txt on C drive.

2 Create file 3.txt on drive D.

3 Create MSDOS directory on C drive.

4 Create a Txt directory in the MSDOS directory.

5 Copy files 1.txt, 2.txt, 3.txt to the Txt directory.

6 Delete files 1.txt, 2.txt, 3.txt from drives C and D.

7 Copy files with the .jpg extension from the C: \ Pictures directory to the MSDOS directory.

8 Copy to the Txt directory all files with the .dcu extension from the C: \ Pictures directory.

9 Delete all files with the .dcu extension from the C: \ Pictures directory

10 Browse the C: \ Pictures directory.

11 Rename files from this directory to files 1.jpg, 2.jpg, 3.jpg, 4.jpg, 5.jpg.

13 Delete the MSDOS directory from the C drive.

Test questions:

1 Operating system (definition, functions, classifications, composition, OS examples);

2 File (definition, file identifier, file attributes, file path);

3 Cluster (definition);

4 Defragmentation;

5 Formatting (definition);

6 Composition of MS-DOS OS;

7 Common MS-DOS Commands.

Laboratory work No. 2. Basic methods of working in Windows: Explorer, shortcuts.

Purpose of work: to master the basic techniques of working with files in Explorer. Learn to create shortcuts.

Option 1.

1 Create folders "1", "2" on disk D.

2 Create folders "11", "111", "1111" inside the folder "1".

3 Create folders "First", "Second", "Third" inside the folder "2"

4 Create a Shortcuts folder on your desktop.

5 Create a shortcut for the Paint program inside the "Shortcuts" folder (the path to the program file is

C: \ Windows \ System32 \ mspaint.exe).

6 Create a shortcut for the Explorer program inside the "Shortcuts" folder (the path to the program file is C: \ Windows \ explorer.exe). Use any of the options.

7 Create a shortcut for the C and D drives inside the "Shortcuts" folder.

8 Create a shortcut for Calculator programs (C: \ Windows \ system32 \ Calc.exe)

9 ON DESKTOP create shortcuts for Notepad programs ( C: \ Windows \ system32 \ notepad.exe) and

Explorer (C: \ Windows \ explorer.exe)

10 Remove the Shortcuts folder and Explorer and Notepad shortcuts from the desktop.

11 Delete folders "1" and "2" from drive D.

Option 2.

1 Using the third option for creating a shortcut, create a shortcut for the Explorer program on the desktop (the path to the program file is C: \ Windows \ Explorer.exe);

2 Create folder "Test task" on disk D;

3 Using the second option for creating a shortcut, create a shortcut for the Paint program (the path to the program file is C: \ Windows \ Pbrush.exe) in the D: \ Test task;

4 Copy the shortcut for the Explorer program from the desktop and place it in the D: \ Test task. Use the first copy option;

5 Remove the shortcut for the Explorer program from the desktop;

6 Copy all files with the extension to the D: \ Test task folder.jpg from the Network folder

environment \ All network \ Lan \ Server_lan \ Users \ Student \ SUSU \ Pudovkina T.A. \ Work

using any of the copy options;

7 Create a "Pictures" folder in the D: \ Test task folder and move there all files with the .jpg extension from the D: \ Test task folder;

8 Rename files 1.jpg, 2.jpg, 3.jpg located in the D: \ Test \ Pictures folder.

New names: 11.jpg, 22.jpg, 33.jpg;

9 Create a shortcut on the desktop for the D: \ Test task using the second option for creating a shortcut;

10 Arrange (sort) files in the explorer by type, by name (View \ Arrange icons \ select the desired option);

11 Configure the way files are displayed in the explorer (command View \ List or View \ Table);

Option 3.

1 Copy the folder " Files "from My Network Places \ All Network \ Microsoft Windows Network \ Lan \ Server_lan \ Users \ Student \ SUSU \ Pudovkina T.A. \

2 Create folders in the following paths (the folder name is indicated at the end of the path):

	C: \ TEMP \ 1		C: \ 10
	D: \ Image \ DOS \ 2
	C: \ PROGRAMS \ BC \ 3		C: \ TOOLS \ 12
	C: \ PROGRAMS \ NC \ 4	m) D: \ 13
	C: \ Documents and Settings \ Student \ Worker		A: \ 14
	table \ 5		C: \ Temp \ 1 \ 15
	D: \ Install \ 6		C: \ 10 \ 16
	C: \ Program Files \ Windows NT \ 7		D: \ 13 \ 17
	D: \ Install \ WInXP \ 8		A: \ 14 \ 18
	C: \ Program Files \ Solo \ 9

3 Copy the following files from the "Files" folder to the created folders (the folder is on the desktop)

File name (s)
Wolf and Calf.avi	C: \ TEMP \ 1
Calc.exe and sol.exe	D: \ Image \ DOS \ 2
floppy.gif and earth.gif	C: \ PROGRAMS \ BC \ 3
leopard.gif and space.gif	C: \ PROGRAMS \ NC \ 4
Security questions.hlp	C: \ Documents and Settings \ Student \ Desktop \ 5
Key # 1.hlp, Key # 2.hlp, Key # 3.hlp	D: \ Install \ 6
Gods of Egypt.txt	D: \ Install \ WInXP \ 8
Keyboard.doc	C: \ Program Files \ Solo \ 9
Crosswords.xls	C: \ 10
.Htm formats	C: \ Program Files \ Common Files \ 11
Hieroglyph1.jpg, Hieroglyph2.jpg	C: \ TOOLS \ 12
All files of type .bmp	D: \ 13
PC circuit.rtf	A: \ 14
All text files (type .txt)	C: \ Temp \ 1 \ 15
All sound files (type .wav)	C: \ 10 \ 16

4 Rename the following files from the Files folder (the folder is located on the desktop)

5 Create shortcuts for the following programs:

Notepad programs (program path: C: \ Windows \ system32 \ notepad.exe) MS Word programs (C: \ Program Files \ Microsoft Office \ Office10 \ WinWord.exe path)

Programs Calculator (program path: C: \ Windows \ system32 \ calc.exe)

Option 4.

1 Copy files from the specified folders to the "Files" folder. Files folder to beon the desktop. When copying, useRIGHT MOUSE BUTTON.

			D: \ My Music \ Sample Music \ 9
	C: \ Program Files \ 2		C: \ Programs \ BC \ 10
			D: \ Image \ Drivers \ 11
			C: \ My Documents \ 12
	C: \ Windows \ Temp \ 5		C: \ Program Files \ Solo \ Save \ 13
	C: \ Windows \ Help \ Tours \ 6
	D: \ 1C_Kucherenko \ 7		Desktop \ 15
	C: \ GARANT \ USER0 \ 8

2 Copy the Keyboard.doc file from the Files folder to the floppy disk.

3 Copy the folder Network Neighborhood \ All Network \ Microsoft Windows Network \ Lan \ Server_lan \ Users \ Student \ SUSU \ Pudovkina T.A. \ CCO

4 In the folder "Files" create folders "Pictures", "Text", "Music", "Help", "Internet"

5 REMOVE:

a) to the folder Desktop: \ Files \ Pictures picture files from the folder D: \ CCO

b) to the Desktop: \ Files \ Text folder; text files from the D: \ CCO folder

c) to the Desktop folder: \ Files \ Internet Internet files from the D: \ CCO folder

d) to the Desktop: \ Files \ Music folder - music files from the D: \ CCO folder

e) to the Desktop: \ Files \ Help folder, help files from the D: \ CCO folder

Option 5.

1 Create a folder "Check" on the desktop

2 Copy all image files from the Files folder to the Scan folder (the Files folder is located at:Network Neighborhood \ All Network \ Microsoft Windows Network \ Lan \ Server_lan \ Users \ Student \ SUSU \ T.A. Pudovkina.)

3 Copy all text files from the Files folder to the Scan folder (the Files folder is located at: see point 2)

4 Copy to the "Check" folder all music files from the "Files" folder (the "Files" folder is located at: see point 2)

5 Create INSIDE folder "Check" folders "Pictures", "Text" and "Music"

6 Move all picture files from the "Check" folder to the "Pictures" folder

7 Move all text files from the Scan folder to the Text folder

8 Move all music files from Check folder to Music folder

9 Create INSIDE folder "Checkout" folder "Shortcuts"

10 Create shortcuts inside the "Shortcuts" folder for the following programs:

10.1.

10.2. MS Word programs (path C: \ Program Files \ Microsoft Office \ Office10 \ WinWord.exe)

10.3. Disk C

10.4.

Option 6

Create a Shortcuts folder on your desktop. Create shortcuts inside the "Shortcuts" folder for the following files and programs:

1 Notepad programs (program path: C: \ Windows \ system32 \ notepad.exe)

2 MS Word programs (program path: C: \ Program Files \ Microsoft Office \ Office11 \ WinWord.exe)

3 MS Excel programs (program path: C: \ Program Files \ Microsoft Office \ Office11 \ Excel.exe)

4 Disk C

5 Drive D

6 Disc A

7 My Documents folders

8 File "Keyboard.doc" (the file is on a floppy disk)

9 Explorer Programs (Program Path: C: \ Windows \ Explorer.exe)

10 MS Paint Programs (Program Path: C: \ Windows \ system32 \ mspaint.exe)

11 Programs Calculator (program path: C: \ Windows \ system32 \ calc.exe)

Test questions:

1 How do I start the program?

2 How can I view the contents of PC drives?

3 How do I create a folder? How many ways are there to create folders?

4 What is a shortcut, what is its purpose, and how do I create one?

5 After deleting a shortcut, does the file [shortcut] point to disappear? Why?

6 What is the file path?

7 How many shortcuts can point to the same file? Why?

8 What are the main file types? Indicate their extensions.

Laboratory work No. 3. Basic techniques for working in Windows: searching for files, recovering information

Purpose of work: to learn how to search for files using various search options and special characters. Learn to recover deleted files.

Option 1.

1 Find the following files using Start → Search and write down the path to them in a notebook.

b) Winword.exe c) WordPad.exe d) MsPaint.exe e) Excel.exe

f) Explorer.exe

2 Create shortcuts on the desktop for the files specified in task 1.

3 Delete files from task 2 and restore them.

Option 2.

1 Find all files on the C drive file extension starting with the letter s can be any file extension.

2 Find all files on the C drive starting with win, the file extension can be anything.

3 Find all files on the C driveending with the letter s, the file extension can be anything.

4 Find all files on drive Din whose name there is letter w, file extension can be any.

5 Find all text files in the C: \ Windows folder (the extension of text files is .txt)

6 Find all on C drive MS Word documents (file extension - .doc)

7 Find all on C drivefiles named from 4 letters, extension can be any.

8 Find on C drive all text files(extension of text files - .txt) with 4 letter name

9 Find in the C: \ Windows folder all files whose name consists of 7 letters and begins with win (file extension can be any)

10 Delete all files from task 6 and restore them

Test questions:

1 What type of files are searchable?

2 What special characters are used for searching?

3 What are some examples of queries using special characters?

4 How can you limit the search range if the name of the file you are looking for is unknown?

5 Where are the files placed after deletion?

6 How to delete files bypassing the "trash"

Laboratory work No. 4. Basic techniques for working in Windows: Total Commander

Purpose of work: to master the basic techniques of working with files in the file manager Total Commander.

1 Create folder Total on drive D

2 Copy to D: \ Total folder D: \ Dttoys

3 Delete folder D: \ Dttoys

4 Create a folder Pictures in the Total folder

5 Copy to D: \ Total \ Pictures all files with extension .wmf from D: \ Work

6 Move all .bmp files from D: \ Work to D: \ Total \ Pictures.

7 Zip folder D: \ Total \ Dttoys. Name the archive Arch1.rar and place it on the C drive.

8 Create a self-extracting archive for D: \ Total \ Dttoys on disk D. Set option - delete source files after packing.

9 Unpack archive C: \ Arch1.rar to drive D: \ Total \ Unpack. You must first create the Unpacking folder.

10 Delete archive C: \ Arch1.rar.

11 Create an archive for the Total folder on disk D. Name the archive Total.zip

12 Show the result of the work to the teacher.

13 Delete folders that you were working with (D: \ Total, D: \ Dttoys, D: \ Work)

Note: all of the above actions must be carried out using the keyboard.

Test questions:

1 What type of software is Total Commander?

2 Provide examples of similar programs.

3 Specify keys and keyboard shortcuts for working in Total Commander.

Laboratory work No. 5. Archiving

Purpose of work: to learn how to create various types of archives (ordinary, self-extracting and multivolume).

Option 1.

1 Create self-extracting archive for the D: \ Dttoys folder. The name of the archive to be created is Arch1.exe. Create an archive in the D: \ Archiving folder.

Archiving options

2 Extract files from the created archive to disk D.

3 Create an archive for the D: \ Dttoys folder. The name of the archive to be created is Arch2.rar. Create an archive in the D: \ Archiving folder.

Archiving options: do not install; Compression method: high-speed (fastest).

4 Extract the files from the Arch2.rar archive to the D: \ Unzip folder. You must first create the Unarchive folder: in the Extraction path field (see point 2) write D: \ Unarchive.

5 Create archive for D: \ Unarchive \ Dttoys Arch3.rar in folder D: \ Archive.

Archiving options : do not install;

6 Create multivolume floppy disk archive for D: \ Unzip \ Dttoys. Archive name Arch.rarArchiving options: delete files after archiving;

Compression method: high-speed (fastest).

Volume size: autodetect.

7 Extract files from multivolume Arch.rar to D: \ Unzip.

8 Format the floppy disk containing the first archive volume using full formatting.

9 Format the floppy disk with the second archive volume using quick format.

10 Create archive from explorer for D: \ Unzip \ Dttoys. Name the archive Arch4.rar and place it on a floppy disk.

Archiving options: delete files after archiving;

Compression method: maximum (best).

11 From the explorer, unpack the created archive Arch4.rar to D: \ Unzip

12 In explorer create an archive for D: \ Unzip \ Dttoys.

13 From Explorer, unpack the archive created in step 12 to disk D

14 Delete folders: D: \ Dttoys, D: \ Archive, D: \ Unarchive.

Option 2.

1 Create folder "Reserve" on disk D

2 Copy to the "Backup" folder the "Security" folder fromNetwork Neighborhood \ Entire Network \ Lan \

Server_lan \ Users \ Student \ SUSU \ T.A. Pudovkina

3 In Explorer, look at the size of the "Security" folder and write this size in a notebook.

4 Open the WinRar program → go to the "Backup" folder and select the "Security" folder.

5 Security1 → specify the compression method SPEED

→ book "OK".

6 book "Add" → specify the name of the archive - Security2 → specify the compression method FAST → book. "OK".

7 book "Add" → specify the name of the archive - Security3 → specify the compression method NORMAL → book. "OK".

8 book "Add" → specify the name of the archive - Security4 → specify the compression method GOOD → book. "OK".

9 book "Add" → specify the name of the archive - Security5 -> specify compression method

MAXIMUM → book. "OK".

10 kn. "Add" → archive name - Security1 → "Create Sfx archive" option → compression method

SPEED

11 kn. "Add" → archive name - Security2 → "Create Sfx archive" option → compression method

12 kn. "Add" → archive name - Security3 → "Create Sfx archive" option → compression method

13 kn. "Add" → archive name - Security4 → "Create Sfx archive" option → compression method

14 kn. "Add" → archive name - Security5 → "Create Sfx archive" option → compression method

MAXIMUM

Enter the result of the work in a notebook in the form of a table:

15 Create folders “1”, “2”, “3”, “4” and “5” in the folder “Reserve”.

16 Select the file Security1.rar → kn. "Extract to" → select folder "1" → book. "OK"

17 Select file Security2.rar → book. "Extract to" → select folder "2" → book. "OK"

18 Open File Explorer→ go to the D: \ Backup folder → double-click the Security3.exe file → use the “Browse” button to specify the folder “3” → book. "OK" → book. Checkout

19 In Explorer → go to the folder D: \ Backup → double-click on the Security4.exe file → use the “Browse” button to specify the folder “4” → book. "OK" → book. Checkout

20 In the explorer → go to the folder D: \ Reserve → click the right button. mouse on the file Security5.rar → select "Extract files" → specify the folder "5" → kn. "OK".

21 Format two floppy disks (to do this, in the explorer, click the pr. Mouse button on the floppy disk icon→ Format → specify "Fast").

22 Create a folder called "Floppy" in the "Reserve" folder.

23 Create a multivolume archive: a. Insert the first floppy disk

b.Open WinRar program

c. Go to the "Reserve" folder and select the "Security" folder

d. book. “Add” → using the Overview book, specify Disk 3.5 (A :) → compression method SPEED → volume size AUTO DETECTION → book. "OK".

e. → insert a floppy disk and press the button to continue archiving (book. "OK" or "Yes" or

"Proceed").

24 Extract files from a multivolume archive:

f. Insert the first floppy disk

g. In Explorer, go to Disk 3.5 (A :) and click on the file icon → select “Extract files” → specify “Desktop” → book. "OK"

h. After a while, a message will appear asking you to insert a second floppy disk→ insert the floppy disk and press the continue extraction button (book "OK" or "Yes" or "Continue").

25 Open WinRar Help and WRITE OUT in a notebook: what is an Sfx archive and how is it convenient, what is a multivolume archive.

Test questions:

1 Archiving (definition);

2 Compression ratio (types, what it depends on);

3 Features of self-extracting archive;

4 What is a multivolume archive for?

5 Specify archiving parameters;

Section 2. Application software

Laboratory work No. 6. Formatting text in MS Word editor

Purpose of work: to learn how to format text (adjust font parameters, margins, spacing). Learn to copy the format of a certain piece of text.

Report on π

Laboratory work No. 6 "Creating tables using a Microsoft Excel spreadsheet processor"

Purpose of work: familiarization with the Microsoft Excel interface, gaining practical skills for entering information, formulas and functions into the cells of a spreadsheet.

1 BASIC THEORETICAL PROVISIONS

1.1 Microsoft Excel interface

1.1.1. Books and sheets

Spreadsheets, to which the Microsoft Excel program belongs, are designed to perform any periodic calculations.

Run this app.

Its interface is somewhat similar to that of Microsoft Word, however, instead of a blank sheet (working field), we see a table with which the user must work. A Microsoft Excel file is organized as a workbook, consisting of such tables (sheets). A workbook in Microsoft Excel is a file used to process and store data. Each book can consist of several sheets, so you can put a variety of information in one file and establish the necessary links between them.

Sheets are used to organize and analyze data. Simultaneously, on several sheets, data can be entered, edited, and calculated with them. You can insert chart sheets into a workbook to graphically represent data and modules for creating and storing macros used to perform special tasks.

Sheet names are located on tabs located at the bottom of the book window. To move from one sheet to another, you must specify the appropriate tab. The name of the current sheet is always in bold. Sheets can be renamed, inserted, deleted, moved, or copied within one book or from one book to another.

1.1.2 Entering data into cells

The cells of a spreadsheet can contain data of various types (text, number, date, etc.), as well as formulas or functions for working with them. In order to enter something into the selected cell, you need to stand on it with the cursor and simply enter from the keyboard. After completing the data entry, exit the editing mode by pressing the Enter key. If you need to change the data in a cell, you can go in two ways: place the new data on top of the old data, or double-click to switch to the edit mode for the cell contents.

1.1.3 Entering Formulas in Cells

Formulas and functions are used to work with the data contained in cells. Entering any formula begins with the "=" sign. Cells in a spreadsheet are identified by a letter (column) and a number (row number). Let's say, for example, that we have two numbers in cells A1 and B1, and we need to enter the formula that adds them into cell C1. To do this, place the cursor on cell C1 and enter the "=" sign. After that, in principle, it would be possible to switch to the Latin script and fill in the expression: "A1 + B1". After pressing Enter, the value of the sum would appear in the cell with the formula. However, Excel has a simpler mechanism for entering formulas. After the "=" sign is typed, to enter the name of a cell in the formula, you need to click on the corresponding cell. It is recommended to type formulas only in this way.

1.2 Using Microsoft Excel functions.

You can use standard Microsoft Excel functions to perform calculations on workbook sheets and macro sheets. The quantities that are used to calculate the values ​​of functions are called arguments. The values ​​that are the result of evaluating functions are called return values. The sequence in which the arguments to a function should appear is called the function syntax. To use a function, it must be entered as part of a formula in a worksheet cell. A formula must begin with an equal sign (=) followed by a set of values, operators, and functions. If the function is at the very beginning of a formula, it must be preceded by an equal sign, as with any other formula.

Brackets are used to indicate the beginning and end of an argument list. The parentheses must be paired, spaces before or after the parentheses are not allowed. Arguments must be inside the parentheses. The argument list can be numbers, text, booleans, arrays, error values, or references. The arguments supplied must have valid values ​​for the given argument. Arguments can be both constants and formulas. These formulas, in turn, can contain other functions. Functions that are an argument to another function are called nested. You can use up to seven levels of function nesting in Microsoft Excel formulas.

For example, consider the syntax and order of summing the contents of a range of cells G2 through G18. To achieve the desired result, you must enter the line "= SUM (G2: G18)" in any cell (usually the cell directly below the column to be folded). The order of entry is as follows: enter “=”, then manually type “SUM” and open the bracket, click on cell G2, put a colon, click on cell G18, close the bracket, press “Enter”. It is the SUM function that can be obtained even faster, but we will consider the second method later.

2 PROGRESS

(Complete each task on a separate sheet of the workbook).

Task 1. To get the basic skills of entering information and formulas in the cells of a spreadsheet, put two arbitrary numbers in cells A1 and B1. Then enter four formulas for the simplest arithmetic operations ("+", "-", "*", "/", "^" - exponentiation) with these numbers. For reference: The “/” character can be typed with the key to the right of the “=” key through “Shift”, the “” character can be typed using the “6” key in the Latin keyboard layout with the “Shift” key pressed. You can arrange formulas, for example, in cells C1 through C5. Write your comments for these formulas in cells D1 through D5.

Task 2. Create a spreadsheet for calculating monthly wages in a company with 10 employees. The table structure is shown below:

The table is filled in for 10 people. At the bottom of the table, the SUM functions summarize the totals for all columns.

Task 3.

Perform the calculation using the formulas in Appendix B.

Task 4.

Perform the calculation using the formulas given in Appendix A. Write the function of one variable, the function of several variables, and the function, with the operator for checking the condition (= IF ()). Options for assignments are given by the teacher.

When using the IF function, the command format is:

= IF(log_expression;value_if_true; value_if_false)

Log_Expression is any value or expression that evaluates to TRUE or FALSE. For example, A10 = 100 is a boolean expression; if the value in cell A10 is 100, then the expression evaluates to TRUE. Otherwise - FALSE. This argument can be used in any comparison operator.

Value_if_true is the value returned if boolean_test is TRUE. For example, if this argument is the string "Within budget" and the log_test is TRUE, then the IF function displays the text "Within budget". If boolean_test is TRUE and value_if_true is empty, then the value 0 is returned. To display the word TRUE, you must use the boolean value TRUE for this argument. Value_if_true can be a formula.

Value_if_false is the value returned if logical_test is FALSE. For example, if this argument is the string "Over budget" and the logical_test is FALSE, then the IF function displays the text "Over budget". If boolean_test is FALSE and value_if_false is omitted (that is, there is no semicolon after value_if_true), then the boolean value FALSE is returned. If boolean_test is FALSE and value_if_false is empty (that is, value_if_true is followed by a semicolon followed by a closing parenthesis), then value 0 is returned. Value_if_false can be a formula.

3 CONTROL QUESTIONS

What are Excel workbooks and worksheets?

How are table elements addressed?

What is auto-summation?

How do I enter a formula into a spreadsheet?

How to save data in a table?

4 REFERENCES

1.K. Karlberg. Business analysis using Excel. Kiev, Moscow. "Dialectics", 1997. –440 p.

2.Microsoft Excel 2000: reference. Ed. Kolesnikov, St. Petersburg: Peter, 1999, 352 p.

3. Informatics: textbook. Ed. N. Makarova. - M .: Finance and statistics, 2000, 768 p.

4. Karpov B. MS Office 2000: reference book. - SPb .: Peter, 2000,448 p.

APPENDIX A - "Task Options"

APPENDIX B - "Examples of Excel Mathematical Functions"

Simplest math functions

Rounding functions

Specific math functions

LABORATORY WORKS ON INFORMATICS