Laboratory work in informatics Collection of laboratory work in informatics Application of laboratory work in informatics

LABORATORIES OF ROBOTICS OF INFORMATICS

FOR ECONOMIC AND MATHEMATICAL FACULTY

(Potik Mbd, Mkbd - 1 course)

Laboratory work 1. Introduction and editing to the Writer text processor (OpenOffice.org) 3

Processor upgrade .................................................. ................................................. ........... 3

Typing text .................................................. ................................................. ................................... 3

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

Operations search for and replace ............................................... ................................................. ..... 6

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

Styling .......................................................................... ................................................. ................ 7

Right for independent work...................................................... .............................. 8

Control food on the topic: ............................................... ............... ................................... .............. 8

2. Laboratory work ...... nine

Work with tables .......................................................... ................................................. ................. nine

Creation of little ones and schemes ............................................... ................................................. ...... nine

Methods for budding objects, preparation in other supplements .................................. 10

Adjusting the image .................................................. ................................................. ....... eleven

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

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

Right for independent work...................................................... ............................ 12

Control food on the topic: ............................................... ............... ................................... ............ 12

Laboratory work 3. Preparing the document before the next .............................................................................. 13

Spelling .................................................................. ................................................. ..... 13

Installing headers and footers .................................................. ................................................. .... 13

Mixed wines and final wines.................................................................. ............... ................................... ... 13

Numbering of sides .................................................. ................................................. ............. 13

Signet................................................. ................................................. ................................... fourteen

Control food on the topic: ............................................... ............... ................................... ............ fourteen

Laboratory work 4. Calculation in Calc .............................................. ....................................... 15

Formula wiki.................................................................. ................................................. ........ 17

Inserting Functions................................................... ................................................. .................. eighteen

Table formatting .............................................................. ................................................. .......... 19

Control food on the topic: ............................................... ............... ................................... ............ 19

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

Pobudov with diagrams .............................................. ................................................. ....... twenty

Editing with diagrams .............................................. ................................................. twenty

Right for independent work...................................................... ...................................... 21

Control food on the topic: ............................................... ............... ................................... ............ 21

Lab work 6. Functions of OpenOffice.org Calc.................................................. .... 22

Date and hour ............................................... ................................................. ........................... 22

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

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

Control food on the topic: ............................................... ............... ................................... ............ 24

Laboratory work 7. Statistical analysis of data .............................................. ................... 25

Numerical characteristics of the vibrator ............................................................... ...................................... 25

Laboratory work 8. Functions that match the criteria .............................................. ............. 26

Mathematical functions. SUMIF function (SUMIF) .............................................................. 28

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

Creation list .................................................. ................................................. ................... 34

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

Ask for help of a standard filter .............................................. ............................... 35

Data autofiltering .............................................................. ................................................. ..... 36

Extended filtering .............................................. ................................................. .... 36

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

Creation of databases ............................................................... ................................................. .......... 37

Changing the data base ............................................... ................................................. ...... 39

Application processing .................................................................. ................................................. .............. 40

Control food on the topic: ............................................... ............... ................................... ............ 40

Lab work 1. Introduction to editing in the Writer text processor (OpenOffice.org)

Processor upgrade

Get the Writer (OpenOffice.org) word processor for help Start / Programs / Writer (OpenOffice.org).

Zavantage advanced system . Get familiar with the advanced system: the structure is the same as that of the advanced Windows operating system.

Take a look at the elements of the Writer window. For help menu View install display mode - Razmіka storіnki, perekonayut nayavnostі lines (for consumption, connect їх, vicorist menu View). Try other modes of fermentation as a help menu View, and for the help of buttons at the left lower part of the window: recognition of the skin button can be assigned for a hint. Reverse the appearance of two panels. standard і Formatting. If additional panels are installed, turn them off (View / Toolbars). Install scale 100% image (View / Zoom / 100% / OK or the Zoom field in the list of what is displayed in the standard toolbar).

For installation robotic parameters text processor select Services/Parameters. /OpenOffice.Writer On tabs View invert the visibility of the orders of the teams Show graphic objectsі Splicing Tips, and for all teams Vikna(I’ll stand in a row, vertical line, twisted smuzhki); on deposit Zagalni set the unit of the world - centimeters, on tabs spelling enable commands Automatically check spellingі Automatically check grammar– qi reverifications to support the work, they can be carried out if the document is ready to go. On deposit saving Choose Autosave skin 10 quills. Take a look at the settings on the other tabs. To implement the modified settings, press the OK button.

Side parameters check out the additional menu Format / Sides and, where can be installed the size of the archway and that yogo orientation, fields and other parameters. Vicorist tabs of the dialogue window Side parameters, install paper size A4, orientation - book, margins - 20 mm from the sides, then press OK.

Type text

At the formatting panel, change the settings: style - Zvichayny, font (typeface) - Times New Roman, rosemir font - 10. In the working area, enter the text below the guidance, the vicarious buttons are displayed in the center (for the bottom), in the width (for the main part of the text), on the right edge (name). Druk dots at the Russian layout - pressing the rightmost key in the bottom row (sign?), which - this key when pressed Shift. To skip a row, press the enter key Enter.

For remote pardon the entered text vikoristovyte keys away backspace or Delete. As a rule, a word processor works in insert modes , if the character is to be re-entered into the text, it is already entered characters. IN change modes, symbols, which are to be entered again, are replaced earlier. To increase or disable the changeover mode, click on the indicator ZAM I will stand in a row.

Writer allows you to automate daily operations for typing. Words that are repeatedly repeated can be saved by looking autotext , and stinks will be introduced later after the first characters or special characters. Add, for example, the autotext word "Informatics". For this purpose, read this way: instruct the word Informatics in the text and copy it to the clipboard, then select the Edit \ AutoText menu, enter from the clipboard into the autotext panel - copy the word Informatics, redirect, the category is assigned standard, click on the button autotext, select split menu - create text, then click on the button add. Now to correct the entry of which word in the text that is being typed - the computer will automatically insert the correct word; just press the key to insert Enter.

In a similar rank, Writer corrects deeds of typical pardons: viroblya autocorrect . For example, an incorrectly entered word bulletin will be automatically replaced by the correct one - bulletin. You can set up autochange for the additional menu Service / Autochange / Replace. Replace the DIV symbols with the text Ivan Ivanovich. Menu autocorrect Look over the list of such corrections, add new words to the new ones.

Enter the text (do not use extreme caution between paragraphs, they will be changed later):

Shanovny to Ivan Petrovich!

I would like to inform you that on the 10th of June at 10.00 at the conference hall of the opening joint-stock company "Integral" there will be a round of creditors' selection in the order of the day:

Confirmation of changes to the plan of the city management of BAT "Integral".

When you need a mother:

passport

handover

act of signing the rakhunkiv of your undertaking from BAT "Integral"

Zovnishniy keruyuchy BAT "Integral"

A.A. Aleksandrov

When editing a document, sometimes it is necessary to clear it, de press the key Enter, how many times the key was pressed, I tried it again. - so that special non-handed symbols are used. For which wink button Non-handed symbols at the standard toolbar (¶). Press this button and look at the meaning and placement of such symbols. Disable button Non-handed symbols.

formatting

The sight of a fragment of the text, as it was intended, should be held out to the mouse. For vision of a green row squirming seams of evil in the row, okremy word - subway clattering on the first letter of the word . See paragraph as a whole you can click the levoruch in the beginning of the paragraph. Try all the ways of seeing fragments.

rescheduled or copied through the clipboard as if there was a place in the active document, and in another document. Vikoristovuetsya be-what of the previously looked at methods: buttons Virizati, Copy, Paste; visible commands of the context menu of the menu Edit; lower keyboard keys: Ctrl+X- Virizati, ctrl+c- Copy to clipboard, ctrl+v- Paste from buffer. When transferring a fragment to a small window, there is a better way: place the mouse in the mouse box near the area you see (the view of the box is an arrow) and drag the fragment with the left button of the mouse in the required area (the indicator is changed to look - now the arrow with a rectangle at the bottom). The fragment can be copied in a similar order: the same order can be engraved when the key is pressed Ctrl.

Vision fragment can be seen pushing the keys away Delete. Copy with a path dragging a fragment of another speech " about 10.00" be it another place of the same row. View the copied fragment.

See all text. Change font size to 12.

To install left and right between the text wick markers on the line. For installation indentation (in the first row in a paragraph) you can press the tab key Tab. The value of the steps can be adjusted with a variable marker on the horizontal line.

Set line spacing using the line spacing menu Format/Paragraph tab – Set the spacing to the value one and a half. Take a look, if you can see more intervals available to you. You can also set the inter-row interval using the same buttons on the toolbar formatting. Find the buttons, see the paragraph of the text and try the different values of the row spacing.

Take a look at the different ways to align text in a paragraph: align left, align right, center, justify, double-click buttons on the formatting panel or adjust the paragraph menu.

To fine-tune the parameters of a paragraph, you can tweak the Format/Paragraph menu, tab - Spacing options. Find out on the tab to improve text alignment, yogo style (main text); the entry is set for the designated paragraph:

ü levoruch. Tse entry of the entire paragraph to the left in between the text;

ü Pravoruch. Tse v_dstupu paragraph to the right in the cordon text;

ü Front. Tse vіdstup paragraph down vіd front paragraph;

ü After. Tse v_dstupu paragraph vіd vіd nastupnuyu paragraph.

See the paragraph that starts with the words “I am telling you” and set the indentation of the line - 1cm, the indentation on the right - 1cm, the interval before the paragraph - 1cm, the interval after the paragraph - 1cm. Marvel at how the text has changed.

You can see the first row in the fragment view and design it in a different font and font size, vicorist toolbar and context menu. Specify the font for the row of divisions, vicorist menu Format/Symbol. Look over all the possible settings displayed on the tabs of this menu and find out how to adjust the inter-character spacing. Install 3-point (pt.) font. Wonder how the writing of the row has changed. Try installing a different font type.

For skasuvannya paromilkovo vikonanih diy vikoristovyte button Skasuwati at the standard toolbar: there will be a rest for the rest of the day. If necessary, specifying how many stinks can be seen in the list, which is shown for the help of the right-handed arrows on the button Skasuwati the one with a one-time pressing of the button. Pomilkovo canceled the operation, but it can be renewed for an additional button turn. To transfer the first proposition of the document in case of a transfer to the mouse. Say qiu diyu for the help button Skasuwati.

Operations

Let's say that the name of the organization has a pardon: BAT is not called "Integral", but, for example, "Interval". How to make a change, without pre-rukovuyuchi schorazu pardon typed word? Scroll down the Edit/Replace menu. In the dialog box, type the word Integral next to the Know field, and the word Interval in the Replace field (to activate the required field, click the mouse). Press the button Know distances, and then - Replace. If you are convinced that it is necessary to replace everything, press the button on the withdrawal button.

Lists

Most of the simple design of the list is followed by additional buttons on the formatting toolbar. See in the prepared document at the visual block two points in the order of the day: issue them at the visual numbered list . For whom click on the button Numbering perelik at the formatting panel.

Transfer of documents, as it is necessary for the mother with her, to issue at sight bulleted list : see three rows, then click on the button Markery. If you do not control the type of markers, you can change them using the Format/Marker and Numbering menu (or a similar context menu) and select one of the obvious options. For help tab Image you can choose other markers. The list can be adjusted using additional buttons Change / Change access.

Vicorist menu, you can organize rich list . For this, in the Format/List menu, you can change the view of the list, the type of numbering, the input and other parameters. Then you create a simple numbering change, where all the numbering is one equal. Dali for help keys on the keyboard TAB or buttons Change / Change access we pass to the required level at the skin point.

The Marker panel and numbering can be tweaked to make changes to the lists.

Assume that in the sequence of automatically numbered paragraphs you need one paragraph without numbering, like in an appendix:

1) first paragraph

2) another paragraph

third paragraph without numbering

3) fourth paragraph

Tse can be robiti in such ways:

Method 1: all paragraphs are numbered without blaming; then place the cursor before the third paragraph and press the key to erase one character right-handed. The paragraph contains its own number.

Method 2: number all paragraphs without blaming; Then place the cursor before the third paragraph and click on the Numbering icon on the toolbar. The paragraph contains its own number and access to the text.

Method 3: number paragraphs 1 and 2 after the additional numbering icon in the toolbar. Let's move on to paragraph 4, choose Format - Marker and numbering - tab Adjustment and set the number 3 in the head of the cob value.

Create three lists and in the skin try the skin from the ways to include an element from the head list.

Save the creations of the document.

Styling of styles

You can make out a leather paragraph okay, but for a great document, it’s a lot of time. Therefore, all modern office packages make it easier for you to do this procedure for choosing the right style. The style of a paragraph sets the formatting like the paragraph itself (steps, intervals, alignment thinly), and the formatting of the characters in the paragraph (font, expanding thinly.).

To insert a style for a paragraph, place the cursor on a new one and click the mouse on the style and formatting buttons in the toolbar, or select it in the Format/Styles menu. Next, select the required style from the list.

To change the current style, you need to select the style button and formatting, right-click on the mouse button and select the menu Change.

To create your own style of the paragraph, wrap the text of the formations behind your text. Open the style menu and formatting and click on the button Create a style from what you see.

Create your own paragraph style and demonstrate yoga zastosuvanya.

Look again at the PARAGRAPH and CHARACTER menu settings, calling them for the help of the context menu or from the FORMAT window menu. Try all the possibilities in them to improve and learn how to draw up a text for their help.

Create a new document (Create button) with side parameters - A4 format, orientation - book, margins on the right 3 cm, top and bottom - 2 cm; type in a new text for the distribution Lists. Center the title. Make two copies of the text in this document. For the first copy, change the font type (typeface) and its size. Set a spacing interval between characters. Zbіshte vіdstupi lіvoruch i pravoruch. For the other copy, change the single interval between subways. Set the interval before another paragraph 1 cm, after the new one - 2 cm.

Create a file from several paragraphs of the text, for the skin paragraph, set your own font, image, line spacing and revise the text. See the words around the text, putting in them the crosses - bold, italic, under the cross. Add three lists to the text: markings, numberings and bugatory. Save document under name Lists in My Documents folder.

To review a document, click on a new name in the View menu: This menu command allows you to activate any of the Writer Documents and sort them all at once on the screen for the help item Arrange All. If necessary, you can change the roztashuvannya vіkon, changing the rozmіrі vіkon vіkon zatyaguvannyam їх between and moving at the need for the position of the title row. Stash the documents in the List in different ways.

Control nutrition on the topic:

1. Setting parameters on the side;

2. Setting up autotext and autocorrect;

3. Adjustment of the text font;

4. Adjustment of parameters in a paragraph;

5. Style of the document, the creation of a personal style.

Creation of little ones and schemes

The little ones can be created for the help of a graphic editor and the introduction of a document. Clumsy little ones and schemes are often easier to prepare, vikoristovuyuchi in the hands of a word processor. Enable the painting toolbar View / Toolbars / Painting (or the Painting toolbar button on the standard toolbar).

Show the structural diagram of the Faculty of Economics and Mathematics. Select Auto Shapes / Basic Shapes / Rounding Rectangle, stretch the mouse from the upper left to the lower right corner of the rectangle, which is displayed, release the button of the mouse (when the figure is drawn, the figure is not visible: by the square / marker in the middle) Align/ Expand / Align Center: rounded rectangles will appear in the image centered in the document. To edit the line of a rectangle, see and click on the button Line type: select the desired type. Without knowing the vision, click on the Write button, and then use the middle of the figure to type the text: Faculty of Economics and Mathematics. To see the text I will write and format it: center, choose the correct type and font size.

Below the rounded rectangle, by analogy, draw two identical ovals (you can speed it up without the middle using the Oval button in the Painting panel): in one, enter the words Straight lines and specialties, in the other - Departments. To avoid ovals, see insulting figures (for which, use the key Shift), pinch Diya: Align along the upper edge (with which the oval will be aligned along the upper edge of the side), and then pull them at the required position with the mouse; center if necessary. Draw arrows between a rounded rectangle and skin ovals: press the Arrow button and stretch the mouse from the cob of the arrow of the rounded rectangle to the end of the oval. To format the arrow, press the Line type button.

Under the skin of the ovals, to depict at the sight of the right-angled cross-sections of the similar structures, for example, for the departments: Applied Mathematics and Informatics, Economics and Management, Economic Theory, CAD, Higher Mathematics.

If you didn’t have mercy, hit the Skasuvati button; visions of an object can be seen by pressing keys Delete.

Image enhancement

In the wake of the little ones, there may be movements: after seeing the clatter of the mouse, the wines are pulled over at the place of the document. To change the rozmіrіv, the little one is pulled over one yogo between for the right square ( change size marker ). Try tsі dії on a budding little one.

Different methods of customizing the image can be done using the additional image toolbar or the context menu. Install this panel and try out the possibilities of these tools: change the contrast and brightness. The most important tool for setting up an image is a button that ensures wrapping a baby inserted into the document with the text: above and below the baby next to the frame, along the contour, etc. Enter any text (for example, copy the text from the Information file), put on a new one before the clipart and try different wrapping options. For consumption, use the context menu / Obtikannya.

Formula editing

To enter simple formulas, use the Style / Lower or Upper index (step) menu options. For the new file, enter the formula y i ¹a+b x 3 (for the introduction of the character nerіvnostі that gretskih lіter vikoristovuyte insert simvolіv: perevіrte vstanovlennya font Symbol's, klatsnіt misheyu for vіdpovіdnim symbol potіm on knoptsі Vstaviti; pіslya Introduction vsіh neobhіdnih simvolіv klatsnіt Closed-To Introduction іndeksu that stage natisnіt klavіshі lіteru that vstanovіt Nizhnіy іndeks abo. Upper index. xі y see in italics.

For the introduction of folding formulas, special formula editor (Menu Insert/Object/Formula). Enter the validity of the function according to the normal law

To select the form and enter the left part of the formula from the keyboard in the best way. To enter a fraction before the integral, use the Patterns of Fractions and Radicals, to enter Greek letters use the Small Greek Letters button. In the same order, choose different templates for the integral, steps, the symbol of inconsistency. To move between the fields of the formula, use the mouse. If necessary, change the style, expand the symbols. To complete the introduction of the formula, click after it. If you need to edit the double formula, click on it.

Auto-numbering of objects

Before the objects that mean numbering, lie down: little ones, formulas and tables. Let's take a look at the numbering of the little ones in the text. From the context menu of the inserted baby, select the Name item. The numbering style and the distributor can be set appropriately before the document can be executed. After a number of little ones, I will automatically take the black number. To send in the text to the little ones, we write a message like "as shown in the little one", we select the command of the main menu Insert - Cross the line. In the dialog window, select the type of the field Malyunki and the little ones we need. After pressing the Insert button, the number of the baby is written to the cursor position. When adding or removing small numbers, the numbers are changed automatically.

The best way to number the little ones without wrapping in text.

Number three little ones and insert messages on them in the text.

Right for independent work

In your file, insert a table with the results of your compilation of the rest of the session: discipline, date of assignment, assessment. Spend sorting(ordering of data) tables according to the alphabet of disciplines, after the dates of the assignment, after the subtractive marks (Table / Sorting ...). Add a new row to the table. At once and under the column with estimates, give your sum total score to the sumi function (Table \ Sum toolbar). Until the middle of the sumi, insert a note (Insert \ Note) With the details of these operations, decide on your own, vikoristovuyuchi dovodka.

Control nutrition

Ministry of Education of the Republic of Bashkortostan GAPOU Ufa Fire and Energy College STATEMENT Intercessor of the director from the initial job: Ponomarova L.F. ______________ 2016 Price not specified Metodichnі schodo organіzatsії that conducting laboratory robіt uchnіv navchalnoї distsiplіni of computer science that ІKT 15.02.07 automation tehnologіchnih protsesіv that virobnitstv 2.21.02 Burіnnya naphtha gases that sverdlovin 21/02/00 2 SKHVALENO methodically cyclic komіsієyu (naymenuvannya komіsії) protocol number ________ od "_________________" 2016 Broken down on the basis of the Federal State Lighting Standard of Secondary Professional Education for the Primary Discipline Informatics and ICT of the Federal State Lighting Standard of Secondary Professional Education for the profession/specialty Ponomarova P.I.B. Organizer: Shaibakova L.M. vikladach DAPOU Ufimsk fire and energy college. 3 Explanatory note 1. The main goals of the task 1. The students of the laboratory work and practical tasks are carried out with the method: systematization, formation of the mind, practical completion in professional module; zagalnennya, theoretical knowledge; thoroughly reduce the stagnation of knowledge in practice, the implementation of the unity of intellectual and practical activity; development of intellectual skills among future specialists: oil companies, energy companies and others; vyroblennya pіd hvіshennya vyvіshennya zavdanіh zavdan such professionally significant yakost, like self-reliance, vіdpovidalnіst, accuracy, creative initiative. fixed otrimanih burying; 2. When carrying out laboratory work (practical work), the initial group can be divided into subgroups, so the number is not less than 16 individuals. 3. Razpodil on the subgroup for the hour of laboratory work is being studied: for the disciplines of higher education, higher professional, MDK, modules 2. Rules for conducting laboratory work and raising awareness 1. The presence of students is not allowed in the office of informatics: at the upper street dress (for the presence of a practical wardrobe); zheyu, drink too much. 2. For an hour of conducting laboratory work, take a stylish telephone and may be set to silent or silent mode. 3. Students are not allowed to take part if they are late for more than 5 minutes. 4. Only students are allowed to attend laboratory work, they have been instructed for the Rules of Safety Techniques and are not well trained. 5. ATTENTION! At the time of violation of the Rules of Safety Engineering, the student is used in viconnance of laboratory work and builds the Rules of Safety Engineering again. 6. Laboratory robots are vibrated individually; 7. An hour of laboratory work - 2 years. Home tasks after laboratory work - registration of a star. 8. Necessary mental admission to in-line employment є: readiness to zahistu advanced laboratory work (obviousness of the degree issued for her) that openness of preparation 4 to future laboratory work (knowledge of the theoretical foundations, methods of conducting work, in order of vikonannya in the end). 9. ATTENTION! We obligated laboratory work for a certain amount of time and we will give the right to change the vikladach. 10. Before the laboratory work, you can proceed only with the permission of the work after the completion of the general briefing at the work station. 11. When carrying out laboratory work, the following are obstructed: scum on computer tables, as well as rotting third-party objects on them; violate the rules and procedures for conducting laboratory work, 12. ATTENTION! Nevikonannya students vykladenih at tsomu pointі could cause usunennia їх vіd vikonannya laboratory work. 13. Awareness of that violation of the computer is only possible with the permission of the vikladach. 14. The sound of laboratory work can be individual, so. push on the zahist with a skin student. 15. The sound of laboratory work in a wild type can take revenge: title page (div. p. Addendum No. 2); viklad teme ta meti roboti; zmist conducted work; vidpovіdі control nutrition; visnovok about vikonana robot; butt zvitu at the addendum No. 1. 16. Design: letter (black ink) on A4 paper, on one side of the arch. 17. The student, for whatever reason, without having succumbed to the laboratory work at the lines, is guilty of the nobility, that: I have the right to practice laboratory work; in the practice of laboratory work carried out at a special inspection for that hour. 3. Criteria for evaluation: The maximum number of points "remarkably" is taken into account, as follows: give the correct formulation, exact definition, understanding of the terms; you can round up your own evidence, bring the necessary butts; correctly show on the supplementary nutrition of the vikladach, as if on the basis of the method of understanding the steps of the mind of the one who learns this material; zvіt registrations zgidno z vimogami, presence of all necessary rozrahunki, tables, little ones. The assessment of “good” is taken away by the student, for example: it is not correct, but the task was correctly stated; 12 unsatisfactory pardons were allowed during the vikladі, which were corrected after respect for the vikladach; give the correct formulation, exact designation, terms; you can round up your own evidence, bring the necessary butts; it is correct to show on the supplementary nutrition of the vikladach, as if on the other hand, to understand the steps of understanding of the one who learns this material. 5 The appraisal is “perfectly” taken away by the student, as follows: incorrectly, but the assignment was correctly written; when vikladі bula allowed 1 day pardon; knows that understanding of the basic provisions of those, but allows inaccuracies in the formula to understand; vyklada vykonannya zavdannya insufficiently logically and consequently; become more difficult when the diet changes. Evaluation is “unsatisfactory” for the one who learns to take it, for example: the assignment was incorrectly posted; at the vikladі it was allowed to grant a pardon, tobto. as if it doesn’t seem to be viable, we’ll install a vikladach to this kind of work. 6 Laboratory work No. 1 Topic: Information resources of the society. Illuminating information resources. Work with software security Meta: learn how to find information about information resources, find information you need for help; opanuvati methods of work with software security. THEORETICAL VISIBILITY The concept of "information resource society" (IRO) is one of the key to understand social informatics. A wider understanding of this understanding began after the publication of the 1984 book by Gromov G.R. "National information resources: problems of industrial exploitation". "Information resource - the value of knowledge, presented in a project form", - such a short and insufficient presentation was suggested by Professor Yu.M. Kaniginim. In this rank, information resources are knowledge, prepared for the docile social selection. The understanding of the IRO, accumulated in the know-how, can be looked at in a narrow and broad meaning of the word. IRO for a higher meaning of the word is knowledge, already ready for a pre-civil social essay, so that it is familiar to the wearer and materialized knowledge. IRO in the broad sense of the word includes all the foreigners in the nose and included in the information exchange of knowledge, which is understood both in the conventional and in the materialized form. The understanding of the resource is taken from the Glossary of the Russian S.I. Ozhegova like a reserve, dzherelo chogos. What is up with information resources, ce understanding is equal to new. It is only beginning to enter into the life of modern society, although the remaining fates become more and more living not only in the scientific literature, but also in the social and political activity. The reason for this, insanely, is the global informatization of society, where more and more the role of information and scientific knowledge is becoming more and more important. For the classification of information resources, one can choose the most important parameters: the subject of information that is collected in them;  form of power - sovereign (federal, sub'ject of the federation, municipal), community organizations, joint-stock, private; availability of information - open, closed, confidential; archival, scientific and technical; - reliability to the singing information system - library, dzherelo information - official information, publications in ZMI, statistical soundness, results of sociological reports; 7  recognition of the nature of the selection of information - mass regional, domestic;  form of submission of information - text, digital, graphic, multimedia; type of carrying information - paper, electronic.  Under the illumination of informational resources, the world understands textual, graphical and multimedia information, as well as programs that are used (distribution kits), that are electronic resources, created especially for the recording process in the process of learning at the singing level. Pratsyuyuchi s osvіtnіmi resources are blamed for such understanding, as the subject and object of these resources. The classification of the subject in informational activities can be described as follows: the subject, who creates objects (all the corystuvach illuminating systems of vikladach, student); subject, a kind of vicorist object (all coristuvachs of the lighting system); the subject, which is the administrator of the objects, to ensure that the middle of the work with the objects of other subjects (administrators of the merezhі); subject, which controls the selection of objects by subjects (engineers). Before the introduction of electronic resources, you can add: • basic materials (electronic manuals, basic manuals, abstracts, diplomas), basic and methodical materials (electronic methods, basic programs), scientific and methodological (dissertations, candidate texts and work), laboratory work, lectures), testing systems (tests - electronic re-verification of knowledge), electronic full-text libraries; electronic periodic vision of illumination; electronic media and annotations of articles of periodical publications in the field of education, electronic archives of releases. XID ROBOTY Manager No. 1. 1. Take over the Internet. 2. In a row, promptly enter the phrase "Catalog of lighting resources." 3. Perekhuyte, yakі distributed include illuminating resources of the Internet. 4. Describe whether there are three. Task #2. For the help of the Universal Guide to the Encyclopedia, find out about the following questions: 8 1. Enter the hour of the confirmation of the Gregorian calendar. 2. what is the diameter of Saturn. 3. enter a death sound. 4. What is the temperature of the boiling room. 5. What is the melting point of iodine. 6. indicate the speed of the wrapping of the Earth around the Sun. 7. yak mass of Jupiter. 8. like a mountain in Africa, the most beautiful. 9. What is HTTP? 10. state the fates of the reign of Ivan III. 11. state the fates of the reign of Katherine II. 12. When was Blaise Pascal born? 13. Tell the fate of Khrushchov N.S. 14. The first wooden bicycle was found at the hands of some roci. Task #3. Give advice on the request: 1. What do you understand about information resources? 2. Change the classification parameters of information resources. 3. What should be learned about the enlightened information resources? 4. What can be brought to the light of electronic resources? Evaluation criteria: the head of the vikonan is correct and in full communication; Vіdpovіdі on control nutrition reading, zmіstovnі; the sound of buildings at the rows. 9 Laboratory work №2 Topic: Discrete (digital) submission of textual, graphic, audio and video information. Meta: learn how to present textual, graphical, audio and video information, learn how to write numbers in different number systems. Discrete representation of information: coding of a color image on a computer (raster image). Submission to sound and video image. THEORETICAL VIDOMOSTI All information, as processed by a computer, is due to buti represented by a two-digit code for the help of two digits 0 and 1. Two characters are usually called two-digit numbers or bits. For the help of two digits 0 and 1, you can code whether you need help. This was the reason why two important processes can be organized in the computer language: coding and decoding. Coding - transformation of input information into the form, which is accepted by the computer, that is a double code. Decoding is the transformation of data from a double code into a form that understands people. From a glance of the technical implementation of the double numbering system for coding information, it turned out to be much simpler, lowering the cost of other methods. In fact, manually encode the information in the sequence of zeros and one, to reveal the value of two possible positions of the electronic element: 0 - the presence of the electric signal; 1 - the presence of an electrical signal. Qi become easy to separate. Nestacha dviykovogo koduvannya - dovgi kody. But in technique it is easier than mother on the right with a great number of simple elements, and a small number of folding ones. Ways to encode and decode information in a computer should be stored in the form of information, and what can be encoded: numbers, text, graphics or sound. Analog and discrete method of coding Lyudina is able to capture and store information from the forms of images (sight, sound, dotik, smakov and scent). Zoro images can be saved from looking at images (drawings, photographs thinly), and sound images can be fixed on plates, magnetic lines, laser disks thinly. Information, including graphic and sound, can be presented in analog and discrete form. With an analog input, the physical value is filled with an indefinitely impersonal value, and these values change without interruption. With a discrete input of a physical value, the value of the terminal multiplier is increased, and the value changes like a string. 10 Converting graphical and audio information from analog to discrete form is carried out by a discretization path, so that a continuous graphic image and a continuous (analogue) audio signal are broken on the edge of the element. In the discretization process, the coding is changed, so that the specific value of the form code is assigned to the skin element. Discretization is the transformation of uninterrupted images and sound into a set of discrete values in the form of codes. Coding an image There are two ways to create and save graphic objects in a computer - as a raster image or as a vector image. For the skin type of the image, the coding method is used. Coding of raster images A raster image is a collection of dots (pixels) of different colors. A pixel is a minimal piece of an image, the color of which can be set to an independent rank. In the process of coding the image, there is a lot of discretization. The spacious discretization of the image can be compared with the image of the mosaic (a large number of a small, different-colored rock). The image is divided into several small fragments (dots), and the skin fragment is assigned the value of the color, which is the code of the color (red, green, blue thin.). For a black-and-white image, the information is limited to one point equal to one bit (either black, or white - or 1 or 0). For chotiriokh kolorovikh - 2 beats. For 8 colors it is necessary - 3 bits. For 16 colors - 4 bits. For 256 colors - 8 bits (1 byte). The quality of the image is to lie in the number of points (the less the number of points i, the smaller the number of points, the greater the number, the more beautiful the number) and the number of victorious colors (the more colors, the more the image is encoded). In order to form an image on the screen of the monitor, information about the skin point (the code for the color of the point) is to be stored in the video memory of the computer. Let's analyze the necessary video memory for one of the graphic modes. For modern computers, the screen size is different, set to 1280x1024 pixels. Tobto. 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. Raster images are more sensitive to scaling (enlargement or change). When the raster image is changed, a sprinkling of sustant points are converted to one, so the separation of the finer details of the image is used. With an increase in the image, the expansion of the skin point increases, and there are stages of the effect, which can be treated with an invisible eye. Encoding of vector images Vector image is not a collection of graphic primitives (dot, dot, ellipse ...). The skin primitive is described by mathematical formulas. Koduvannya to deposit from the applied medium. The advantage of vector graphics is those files that take vector graphics images can be quite small. It is also important that the graphic images can be enlarged or changed without loss of clarity. Double coding of the sound Computer's sound processing for sound processing began later, lower numbers, texts and graphics. Sound - whistle with amplitude and frequency, which changes without interruption. The greater the amplitude, the more voice for the person, the greater the frequency, the greater the tone. Sound signals in the usual world are supersonic different. Folding, uninterrupted signals can be represented with sufficient accuracy as the sum of the simplest sinusoidal signals. Moreover, the skin dodanok, that is, the skin sinusoid, can be precisely set by a certain set of numerical parameters - amplitude, phase and frequency, which can be seen as a code to the sound at the singing moment of the hour. At the process of coding the sound signal, one temporal discretization is carried out - without interruption, small temporal cells are broken up, and in the skin of such a cell, the same amplitude value is restored. In this way, the uninterrupted stagnation of the signal amplitude changes from time to time to a discrete sequence of equal amplitude. The skin level of density is given a yoga code. The greater the number of equalities of density will be seen in the coding process, the more information will carry the meaning of skin equalities and the lesser the sound will be. The quality of double coding to the sound is determined by the depth of coding and sampling frequency. Sampling frequency - the number of samples equal to the signal per hour. The number of equals in density determines the depth of coding. Modern sound cards provide 16-bit sound encoding depth. At the same time, the number of equal numbers is more expensive N = 216 = 65536. The simplest such robot is reviewing films and videoclips. It should be clearly stated that the processing of video information requires a high-speed computer system. What is a movie about informatics? Nasampered, tse poddnannya sound and graphic information. In addition, for the creation on the screen of the effect of movement, a discrete technology is used to change static images. Studies have shown that in one second it changes over 1012 frames, then the human eye catches the change on them as if without interruption. HID ROBOTS. Zavdannya No. 1. Using the symbol table, write down the sequence of tens of numeric codes in the Windows encoding for PIB. The symbol table is displayed in the MS Word editor for an additional command: Insert Symbol Other symbols → → Select Times New Roman for the Font field, Cyrillic for the field. For example, for the letter "A" (Russian great) the character code is 192. Butt: I V A N O V A R T E M 200 194 192 205 206 194 192 208 210 197 204 13 P I T R O V I H 20 197210208206194200215 Plant manager No. 2. Vykorivuyuchi standard program NOTEBOOK, signify that the phrase in Windows encoding is set to a sequence of numeric codes and continue the code. Launch NOTEBOOK. For the help of the additional numeric keypad, for the help of the pressed ALT key, enter the code, release the ALT key. The document has an optional symbol. 0255 0252 0226 0243 02210 0221 0226 0239 0238 0241 0239 0229 0246 0232 25 20 30 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 Pass Task #4. Convert tenth number to two number system and convert: 1. 2. Task №5. Nutritional information: 1. What is the information? 2. Override the power of information. 3. What information do you see? 4. Provide examples of analog representation of graphic information. 5. What is a pixel? 6. What is the number system? 7. Write a rule for translating tens of numbers in a double code. 8. Recycle single items of information. 15

Laboratory robot No. 6 "Creation of tables from the tables of the spreadsheet processor Microsoft Excel"

Meta work: familiarization with the Microsoft Excel interface, practical knowledge of entering information, formula and functions in the spreadsheet.

1 BASIC THEORETICAL PROVISIONS

1.1 Microsoft Excel interface

1.1.1. Books and lists

Spreadsheets, up to the class of which the Microsoft Excel program belongs, are recognized until the end of any periodic calculations.

Launch this program.

Its interface is similar to the Microsoft Word interface, but instead of a clean arc (working field) we have a table, with which we can practice. A Microsoft Excel file is organized like a book, which is compiled into a table (archives). A Microsoft Excel workbook is a file that is compiled for processing and saving data. A leather book can be folded from dekіlkoh arkushіv, to that in one file it is possible to place various vіdomosti and insert between them the necessary links.

Arkush serve to organize and analyze data. One hour at a time you can enter, correct, and work with them on the number of arkushas. In the book, you can insert arcade diagrams for a graphical presentation of data and modules for creating and saving macros, which are selected when typing special tasks.

The names of arkushivs are found on labels, stashed at the bottom of the window of the book. To move from one arcush to another, you need to indicate a different yarlik. The name of the flow sheet is always shown in bold type. Sheets can be changed, inserted, deleted, moved, or copied between the same book or from one book to another.

1.1.2 Entry of data before the end

In the middle of the spreadsheet, you can have data of a different type (text, number, date, etc.), and type the formulas of the function to work with them. In order to enter something in the chosen room, it is necessary to place the cursor on it and simply enter the input from the keyboard. After the completion of data entry, it is necessary to exit the editing mode by pressing the Enter key. If you need to change the data in the middle, you can use two ways: place new data on top of the old data, or switch to the editing mode instead of the middle.

1.1.3 Entering formulas at the office

For work with danim, which are in the middle, the formulas of that function are drawn up. The introduction of any formula starts with the “=” sign. Centers in the electronic table are indicated by a letter (stovpets) and a number (row number). It is permissible, for example, that we have two numbers in the middles A1 and B1, and it is necessary to enter a formula for adding them up in the middle C1. For this, it is necessary to place the cursor on the C1 box and enter the “=” sign. After that, in principle, it would be possible to switch to the Latin script and type in the words “A1 + B1”. After pressing Enter at the middle of the formula, the value of sumi appeared. However, Excel has a simple mechanism for entering formulas. After that, as the “=” sign is typed, to enter the formula of the name of any middle, it is necessary to click on the middle of the mouse. Formulas are recommended to be typed in this way.

1.2 Using the functions of Microsoft Excel.

For typing on the arcs of the book and on the arcs of the macros, you can count the standard functions of Microsoft Excel. The values that are calculated for calculating the values of functions are called arguments. Values that are the result of counting functions are called values that are rotated. The sequence in which the arguments of a function are sorted out is called the syntax of the function. In order to win the function, it is necessary to enter as part of the formula into the sheet. The formula is due to start with an equal sign (=), following a set of values, operators and functions. As a function to stand on the cob of a formula, it is your responsibility to change the sign of equality, like in any other formula.

The arches are vikoristovuyutsya for the recognition of the cob and the list of arguments. The bows are to be blamed for being boys, walk in front of the bows, otherwise they are not allowed. Use the middle of the bow to blame but the arguments. The list of arguments can be made up of numbers, text, logical values, arrays, the value of pardons chi silan. the arguments that are being asked are valid for the value given to the argument. Arguments can be either constants or formulas. Qi formulas, with their own calling, can avenge other functions. Functions that are the argument of another function are called attachments. Microsoft Excel formulas can be twisted with equal nesting of functions.

For example, let's look at the syntax and the order of subsuming instead of the middle ones from G2 to G18. To reach the necessary result, it is necessary to enter the row “= SUM (G2: G18)” into the middle (sound the middle without a middle under the column, which is added up). The order of entering attacks: enter "=", then manually type in "SUM" and open the bow, click the bear on the middle G2, put a two-mark, click the bear on the middle G18, close the bow, press "Enter". The SUM function itself can be seen more clearly, but the other way can be looked at later.

2 HID ROBOTS

(Look at the skin of the task on the creamy arch of the working book).

Task 1. To remove cob sprouts, enter information and formulas in the electronic spreadsheet box, put two full numbers in the box A1 and B1. Then enter several formulas for the simplest arithmetic diy (“+”, “-”, “*”, “/”, “^” - steps into steps) with these numbers. To clarify: The character "/" can be typed with the key, right-handed in the keys = = through Shift, the character "" should be typed after the auxiliary key "6" in the Latin layout of the keyboard when the Shift key is pressed. You can expand the formula, for example, in the middle from C1 to C5. In the middle of D1 - D5, write comments up to these formulas.

Task 2. Create an electronic spreadsheet for the monthly salary payment at the enterprises with 10 practitioners. The table structure is shown below:

The table will be loaded by 10 people. In the lower part of the table, the SUM functions are used to add sums in all columns.

Task 3.

Follow the calculation for the formulas pointed out by Dodatku B.

Task 4.

Follow the calculation for the formulas introduced in Addendum A. Write down the function of one change, the function of how many changes, and the function with the reverification operator of the mind (=yxcho()). Variants of the manager seem to be a vikladach.

With a different function YAKSHO, the command format may look like:

=yakscho(log_viraz;value_yaksto_truth;meaning_yakscho_nonsense)

log_viraz- tse be-like meaning or viraz, what is the meaning of TRUE or FALSE. For example, A10=100 - whole virase; if the value in the middle of A10 is 100, then the value is set to TRUE. Inakshe is nonsense. This argument can be beaten by the operators, whether they are equal or not.

Value_yakshoe_true- the same meaning, as it turns, as if the log_viraz is more true. For example, as an argument - the row "In the boundaries of the budget" and log_virase is more TRUE, then the same function as the text "In the boundaries of the budget". If the log_virase is equal to TRUE, and the value_yakscho_ist is empty, then the value 0 is rotated. The value_of_yakshto_istina can be a formula.

Meaning_yakscho_nonsense- tse meaning, as it turns, as if the log_viraz is bullshit. For example, if the argument is the "Budget transfer" row and log_virase is more than a BLESS, then the JACKSHO function displays the text "Budget transfer". If the log_virase is more bullshit, and the meaning_yakshcho_nonsense is omitted (because the meaning_yakshcho_ista doesn’t have a point beyond it), then the logical meaning of bullshit turns. If the log_virase is more bullshit, and the value_yakshcho_nonsense is empty (so if the value_yakshcho_true is a speck behind it with an offensive curve), then the value 0 is rotated. The value_yakshcho_nonsense can be a formula.

3 CONTROL POWER

What are the books and sheets in Excel?

How are table elements addressed?

What is autosumming?

How to send a formula to a table?

How to save data at tables?

4 BIBLIOGRAPHIC LIST

1.K.Karlberg. Business - analysis from the help of Excel. Kiev.Moscow. "Dialectics", 1997. -440 C.

2. Microsoft Excel 2000: dovіdnik. For red. Yu.Kolesnikova.- St. Petersburg: Peter, 1999,352 s.

3.Informatics: assistant. For red. N. Makarova. - M.: Financial statistics, 2000, 768 p.

4. Karpov B. MS Office 2000: dovidnik. - St. Petersburg: Peter, 2000, 448 p.

ADDENDUM A - "Variant assignment"

APPENDIX B - "Apply Excel Mathematical Functions"

The simplest math functions

Rounding functions

Specific math functions

LABORATORIES OF ROBOTICS OF INFORMATICS

Laboratory work in informatics Collection of laboratory work in informatics Application of laboratory work in informatics

Sense of Aries and Devi: energy against pedantry

Zadishka with obstructive and acute bronchitis: rejoicing with faces and folk remedies

Mysterious burial of people-Bliznyukiv: misinterpreted signs of suffocation

Yak quickly tidy up the belly of a man and a girl

Flower jasmine describes the color of power

Laboratory work in informatics Collection of laboratory work in informatics Application of laboratory work in informatics

Similar articles