So, the installation package of LibreOffice is obtained from the official site and is successfully installed. Using the familiar "Start" button, launch the program LibreOffice Writer.. What can I do here?

First impression - everything is very similar to MS Word. Sample 2003. The top drop-down menu, in which there is no rigid "ribbon". Dynamic sections of this menu can be missed by the mouse and transfer from one screen to another. A ruler, scaling, a status bar - everything is simple and familiar so much that even causes lunizing. And the first opinion that may appear: LibreOffice Writer may be more powerful notepad, but is clearly weaker than all recognized Word.

Fig. 1 First impression from LibreOffice Writer

We continue to acquaintance

Laped LibreOffice Writer by default creates an empty document on the screen. On this clean sheet and try to dial some text, and then compare the possibilities of free and pay packages.

We see that default settings: Liberation Serif 12 Kell. Without changing anything, we recruit the text:

Fig. 2. First text

Everything is simple and understandable. However, in most text editors, the text set does not represent any complexity. Let's see what can do with the text type LibreOffice Writer..

Pay attention to the two menus: "Standard" and "Formatting". They are active by default and when you first start the program are located at the top of the screen.

Fig. 3. Menu "Standard" and "Formatting"

If these menus are no on site (unlikely, but possible), you must execute the command View → Toolbar. And put the ticks on the strokes standard and formatting.

Fig. 4. Turn on the required menus

Work with text

After examining the menu of a quick look, we find familiar buttons in the "Standard" menu:

• open
• save
• print
• copy
• insert
• cancel action.

And no less familiar tools to work with the text in the "Formatting" menu:

• bold
• italics
• underline
• kehel size
• all types of alignment
• text color and background.

By using these buttons, we recognize that the action of them leads to the same results. Difference only in one: the "background color" button changes the color of the entire paragraph in which the cursor at the moment.

Fig. 5. Formatted text

If you still work with the "Formatting" menu, you can find all the necessary fonts for work. True, most of them work only if they are present in the operating system (however, as for Word). But the styles work great, and barely bothering, you can bring the document to the next sample:

Fig. 6. Work with styles. Install headlines

Similarly, the "Save" and "Open" buttons are also operating here, which write ready-made text for long-term storage and open the previously saved file. The only thing you can stay a bit in more detail - when saving a file you can use several different formats. And the choice is quite wide here: from "native" ODF. (by default), to the usual DOC and RTF. (for Word). There are even formats TXT. (Notepad) and HTML. (browser).

Fig. 7. We save the text using different formats.

Insert the image into the text

Similarly, as it is in Word, the LibreOffice Writer allows you to insert images into a text document. And in the same way for this you can use several ways.

• Complete the menu command: Insertion → Image → From File (see drawing)
• Upload a picture directly from the scanner (this is not in Word)
• Use the exchange buffer by copying the file directly from the directory, and clicking on the "Paste" button.

All methods are familiar, and let's not stop on them in detail.

Fig. 8. Insert images into text

It is only worth mentioning that in LibreOffice Writer. present full set Tools for working with an image that allows you to change the location of the picture (on the front and back plan), change the flow around the text (see Figure 9), set a variety of frames. And even tie to images hyperlinks.

Fig. 9 menu for image formatting

We continue to master LibreOffice Writer

On this, it would seem, you can finish. What else needs a wide range of users from text editorexcept for a set of text, formatting it (bold, italic, inclined), the ability to work with images, and also save, open and print the file? But opportunities LibreOffice Writer. much wider than the standard set of operations that are necessary for schoolboy or secretary to create the simplest text files.

While the menu items (so far without going into special details) can be found that LibreOffice Writer. It is possible to create letters and faxes using the "creation wizard". You can connect internal and external sources Data that store information and in the program itself and in external files. You can create tables of any complexity and use the simplest formulas for them. Can be created hyperlinksthat indicate partitions inside the document or external files that can be stored and on local computer, and on the Internet servers.

In a word, the user who will choose to work LibreOffice Writer.However, it will not feel impelled in choosing tools to realize their goal.

Lesson number 1.
Topic: spreadsheets. Purpose. Spreadsheets LibreOffice. Calc.
Cells and cell ranges. Enter and edit data.
Enter formulas.

Spreadsheets

ELECTRONIC TABLE (TH) - These are special programs designed to work with data in tabular form:

For calculations on the data,

To build diagrams based on tabular data,

For sorting and searching for data based on a specific criterion,

To analyze the data and miscarriage of the type "What, if?",

To create databases,

For printing tables and their graphic representation.

The first efforts appeared in 1979.

Generally accepted sprinkler of spreadsheets as separate class Software is Dan Bricklinwhich together with Bob Frankston Developed a program Visicalc. In 1979, this spreadsheet for a computer Apple II. It became very popular, turning a personal computer from toys for technofils into a massive tool for business.

Purpose.

These are intended for economists, accountants, engineers, scientists - all those who have to work with large arrays of numerical information.

3. LibreOffice. Calc.

LibreOffice Calc. - partLibreOffice.. With it, you can analyze the entered data, to calculate, predict, reduce data from different sheets and tables, build diagrams and graphs. In addition to this program in the packageLibreOffice. Other office programs include.

Office packageLibreOffice. It can be freely installed and used in schools, offices, universities, home computers, state, budget and commercial organizations and institutions of Russia and CIS countries .

Package composition LibreOffice.

Module

Notes

LibreOffice Writer.

LibreOffice Calc.

LibreOffice impress.

Preparation program

LibreOffice Base.

Connection mechanism for external and built-in DBMS

LibreOffice Draw.

LibreOffice Math.

View of the screen

The screen view is standard for Windows applications:

The header string containing the name of the program and the current document.

Line menu with basic commands.

Toolbar - Standard, Formatting and Line of Formulas.

Working field that consists of cells. Each cell has its own address: the name of the column and the line number, at the intersection of which it is located. For example: A1, C8, P15. The columns are only 256 (last IV), strings - 65636.

On the left and at the bottom of the screen are scroll bars. To the left of the bottom scroll bar are tabs with the names of working sheets. Thus, we only see a piece of a huge table that is formed in PC memory.

Documentation LibreOffice. Calc.

Documents that are created using LibreOffice. Calc. Called working books And have an extension . ODS. . The new workbook has three working sheets, which are called sheet1, sheet2 and sheet3. These names are listed on sheets of sheets at the bottom of the screen. To go to another sheet, you need to click on the name of this sheet. On the work sheet can be located

data tables

charts (as a table element or on a separate sheet).

Actions with work sheets:

Renaming the working sheet. Set the mouse pointer to the operating sheet root and twice the left key or call the context menu and select the command rename.

Insert working sheet. Select the sheet label, in front of which you need to insert a new sheet, insert  sheet, or using the context menu.

Removing the working sheet. Select a sheet label, Edit Delete, or with the context menu.

Moving and copying a desktop. Select the sheet label and drag to the desired location (with the CTRL key pressed - copy) or through the clipboard.

Cells and cell ranges.

The working field consists of rows and columns. Rows are numbered from 1 to 65536. The columns are latin letters: a, in, s, ..., aa, av, ..., iv, total - 256. At the intersection of the string and column there is a cell. Each cell has an address consisting of a column name and cell number. The cell address is written only in English - it is important

To work with several cells, they are conveniently combined into "ranges".

Range are cells located in the form of a rectangle. For example, A3, A4, A5, B3, B4, B5. To record the range used " : ": A3: B5

Examples: A1: C4, B6: E12, G8: H10

The task:

- Select the following ranges of cellsB. 2: D. 7; A. 1: G. 2; D. 4: H. 8

- write ranges

7 . Enter and edit data.

IN LibreOffice. Calc. You can enter the following data types:

• Text (for example, headlines and explanatory material).

  Functions (for example, sum, sinus, root).

Data is entered into cells. To enter the data, the desired cell must be highlighted. There are two data entry methods:

Just click in the cell and print the desired data.

Click in the cell and in the formula row and enter data into the formula string.

Press ENTER.

Change data.

Select the cell  Press F 2  Change data.

Select the cell  click on the formula string and change the data there.

To change the formulas, you can only use the second method.

Enter formulas.

Formula is an arithmetic or logical expressionwhich produces calculations in the table. Formulas consist of references to cells, operations and functions. LibreOffice. Calc. It has a very large set of built-in features. With their help, you can calculate the amount or average arithmetic values \u200b\u200bfrom a certain range of cells, calculate interest on deposits, etc.

Enter formula always begins with the sign of equality. After entering the formula, the result of the calculation appears in the corresponding cell, and the formula itself can be seen in the formula row.

Act

Examples

Addition

Subtraction

Multiplication

A1 / B5.

Erend into degree

A4 ^ 3.

=, <,>,<=,>=,<>

Signs of relationship

In formulas, you can use brackets to change the procedures for action.

The task:

Enter the following data

Make sure the active is English font.

Set the table cursor in the D2 cell.

Click the left mouse button in the formula row.

Enter the equality sign, and then the formula: B2 * C2. Press the key<ENTER>.

Make sure that the D2 cell appeared numeric value

The task:

Fill out the following table, in the field "Amount" to record formulas for calculating the summary amount

Lesson number 2.
Topic: auto completion of the cells of the spreadsheet.
Auto confillment cells formulas. Using the "Amount" function

1. Autocomplete.

Very convenient tool is autofill adjacent cells. For example, you need to enter the names of the year in the column or string. This can be done manually. But there is a much more convenient way:

Enter the desired month in the first cell, for example, January.

Highlight this cell. In the lower right corner of the selection frame is a small square - filling marker.

Move the mouse pointer to the fill marker (it will take a cross type), holding down the left mouse button, stretch the marker in the right direction. At the same time, the current cell value will be seen glad to the frame.

If you need to fill out some numeric number, then you need to enter the first two numbers in the neighboring two cells (for example, to enter 1, and in B4 - 2), select these two cells and extend for the marker (from the lower right corner of the second cell) Selection area to the desired size.

The task:

- Using auto fill to build rows

- from 1 to 50,

- from 2 to 100,

- January December

Autofill Formulas

Construction of the simplest series of data is possible by the method described above. If the dependence is more complicated, the formula is used as the initial value of the range.

Example: The legend of the inventor of Chess, who asked as a reward for his invention as much grain how much will be released, if on the first cell of the chessboard, put 1 grains, on the second - 2, on the third - 4, on the fourth - 8, etc., that is For each next 2 times more than the previous one. Total cells on chessboard 64.

On the first cell - 1 grains

Next - 2, i.e. Twice more, however, instead of the number 2 in the cell B 2, we introduce the formula. Since the pattern is described by the equation y \u003d 2x, then the formula will be similar \u003d A 1 * 2

Press Enter and stretch the second cell for the marker down on 64 cells

We now consider the amount of all cells in the example. To do this, select the required range (in our case, from 1 to 64 cells (A 1 - A 64)). We find the "sum" button above and click on it

The value of the amount will be recorded in the following cell. If the amount value must be in a separate cell, then you need to activate this cell, click the sum icon, select the range and press "ENTER".

The task:

- find the sum of all natural numbers from 1 to 100 inclusive

- find the amount of all odd numbers from 1 to 99

- Find the sum of the squares of natural numbers from 1 to 10 (1 2 + 2 2 +3 2 +…)

Lesson number 3.
Topic: Relative and Absolute Addressing

The spreadsheet may contain as maintenance (source) and derivatives (Calculated) data. The advantage of spreadsheets is that they allow you to organize an automatic calculation of data derivatives. For this purpose in the cells of the table use formulas. In this case, if the initial data is changed, the derivatives are also changed.

In the cell D 3, we will make a formula according to which the amount of numbers in cells B 2 and C2 is considered.

If you now change the data, for example, in the B 2 cell, the amount value is automatically recalculated.

Let's try now to copy the formula down by "dragging" by

Note, after copying the formula to another cell, it has changed it, i.e. in it, instead of references to cells B 2 and C 2, there are references to cells B 3 and C 3.

This method called relative addressing. It is convenient to apply when filling the same type of data.

However, there are situations where use this method leads to an incorrect calculation. Consider an example:

Suppose we need to make a transfer of money from dollars to rubles, the current dollar exchange rate writes to one of the cells.

In other cells, we introduce the amount in dollars

Calculate in cell B 3 formula for the transfer of dollars in rubles

P turn around to copy the formula into the lower cells

We see that the result is incorrect (should not be 0 A 1200 and 3000)

With a careful study of the resulting formula, it can be seen that the cell A 3 "turned" into the cell A 4 (which is correct, as the value of "40") is now substituted), but the cell that C 2 cells can now be automatically stunted below - cell C 3, In which is empty, and, therefore, the second multiplier becomes the number 0. So that the result is correct, it is necessary to fix the second cell in some way, without letting it be recorded.

This can be done using the so-called absolute addressing. The essence of this method is that in the formula entry in front of the letter or the digit is a $ sign that does not give to change the corresponding letter or digit. If this sign stands and in front of the letter and in front of the number, we are dealing with absolute addressing And if only before the letter or only before the number - with mixed addressing (In this case, part of the references of the formula when copying may vary)

Change our initial formula by the method of absolute addressing

And copy it down

Take the part of the formula that is enclosed in "Dollars" has not changed!

The method of absolute and mixed references will demonstrate on the example of the preparation of the multiplication table

You can fill all the cells of the table formulas manually, it is easier to do this using autofill, the truth here should be neat, since when copying the links are shifted.

Let's just try to copy the formula in cell B 2 down

As you can see, the result, as expected, is incorrect. Let's try to understand what the case, analyzing the formula, for example in the cell B 3

It should correctly be \u003d a 3 * b 1, it means that the number "1" in the formula in the cell B 2 must be "fixed"

Let's try to copy the formula down

Now everything is considered correctly, note that the figure in the right part of the formula has not changed

The task:

Create a multiplication table 10 to 10

-

Lesson number 4.
Subject: Standard Functions B. LibreOffice. Calc.

1. Standard functions.

Calculations that allow programCalc.are not limited to the simplest arithmetic operations. It is possible to use a large number of built-in standard functions and perform very complex calculations.Functions in OpenOffice.org Calc, they call merging several computing operations to solve a specific task. The values \u200b\u200bthat are used to calculate the functions are calledarguments . The values \u200b\u200breturned by the features as an answer are calledresults .

When we start the formula (by pressing the "\u003d" key), the field name in the formula row is replaced by the drop-down list of standard functions.

This list contains ten functions used by the latter, as well as the item Other functions with which you can open the Function Master dialog box.

This dialog box allows you to choose any standard feature From the CALC available.

· financial (functions for calculating a variety of economic indicators, such as profit rate, depreciation, rate of profitability, etc.);

· date and time (With the help of the Date and Time functions, you can solve almost any tasks associated with the date or time, in particular, to determine the age, calculate the work experience, determine the number of working days at any time of time, for example: Today () - Enters the current date of the computer) ;

· mathematical (functions for performing various arithmetic and algebraic actions, for example: ABS () - returns the number module, sum () - summation of the range of cells, SQRT () - the value of square root, etc.);

· statistical (In this category, various functions are collected with which such sections of mathematics are working as probabilities theory, mathematical statistics, combinatorics);

· textic (With the help of text functions, it is possible to process the text: Remove characters, find the desired, write characters in a strictly defined text place and much more, for example: Lowel () - makes all the letters in the line string line);

· brain teaser (These features help to create complex formulas, which, depending on the implementation of certain conditions will be performed different kinds Data processing or executing branching calculations, for example: if (), and (), or ()).

When choosing a function, it appears short description, so you can easily find the desired function. At first, you quite have enough mathematical and logical functions.

Formulas and functions can be entered manually, simply gaining their names in the formula row.

If the function appears at the very beginning of the formula, it must be preceded by a sign of equality, as in any other formula. Remember that when recording functions, the opening and closing brackets must be present, while you should not insert spaces between the name and brackets.

For example, if a formula is recorded in the A5 cell with a degree function \u003d POWER (A 4; 3), the value of this cell will be the value of A4, erected into a degree 3.

In the future, we will often apply tomathematical functions to which include such well-known school mathematics functions asSin.() - sinus, Cos.() - cosine, Tan.() - Tangent, LN.() - natural logarithm, SQRT () - a square root of the number, etc.

Let's consider an example:

You need to find the highest range of cells. Without using the function, this calculation is impossible. Below is a function that allows you to find the most largest in the range of cells:

Max (A1: A10), where

MAX - the function of determining the greatest value;

A1: A10 - Range of cells, among which you want to find the greatest value.

As another example, consider building a table of values \u200b\u200bof some function at a specified interval and with a given step.

Make a table of values \u200b\u200bof the function of the sine on the range from 1 to 2 in increments of 0.1

Initially, we build a number of values \u200b\u200bof an independent argument ( x. ), given the specified parameters

In the cell B 2 insert the function of the sine (by any method) from the argument of the cell a 2

Copy the formula down

The result is ready!

The task:

Make a table of values \u200b\u200bof the cosine function at the interval from 1 to 3 in increments of 0.2

Make a table of function values y. = x. 2 on the interval from 0 to 3 in increments of 0.1

Lesson number 5.
Subject: "Use of logical functions.
Building graphs and charts »

1.Logical functions functionIf.

The IF function is used to verify the conditions when calculating.

Recording format:

If. (log_Miz; meaning_If_istin; value_If_nut)

Log_Production is any value or expression that makes the values \u200b\u200bof truth or false. For example, A10 \u003d 100 is a logical expression; If the value in the cell A10 is 100, the expression takes the value of the truth. Otherwise - Lies.

The table calculates the salary of each employee, it is determined by the salary (the same for all), and experience (different)

The coefficient is calculated in this way:

If experience\u003e \u003d 10 years, then it is 2, otherwise - 1.

In the E Column insert such a formula: \u003d if (c2\u003e \u003d 10; 2; 1),

Accordingly, in the column f: \u003d d2 * e2

In the same example, we will calculate the coefficient as follows:

Starting up to 10 years - 1,

From 10 to 20 - 1.5,

Consequently, here you need to choose from 3 options. Using nested functions IF.

In the column e insert the formula: \u003d if (C2<10;1;IF (C2>=20;2;1,5))

Please note that in the formula, the second IF is inside the brackets

The table will take the form:

2. Building diagrams

LibreOffice Calc provides wide opportunities To create business graphics - charts and graphs. They display the data is visually than the numbers in the table cells. Considering charts or graphics, you can immediately analyze data in the table.

Diagram - This is a graphical representation of data in the table.

Charts are built on the basis of already ready-made tables.

Graphs and charts are built using masters Chart

Master Chart - This is a series dialog boxesallowing you to create a new diagram or edit the already existing one.

In the number 1 dialog box, select the type of chart.

In the dialog number 2, you can clarify the range of data for which the diagram is built.

Row switches in rows or columns allow you to select the direction of data for constructing a chart if the selected range is a rectangular area.

Rows of Data - Data sets represented by graphic columns, sectors or chart lines.

In the dialog number 4, the chart parameters are set.

Common elements for all types:

Title - You can enter the chart header.

Legend - A area in which colors and patterns corresponding to specific data in the chart are decrypted. In order for in the legend to be meaningful notation, it is necessary to allocate numeric data with the headings of the rows and columns in the table.

Data signatures are numeric, percentage or text signatures near each chart item.

Data Table - A fragment of the source table with data for the diagram is placed under the diagram.

Order order:

Enter the source set of data (cellular set)

Select the desired range (in the simplest case one column or string)

Press the diagram button

In the wizard opened on the steps to determine the structure of the future chart or schedule

In more complex cases, another (or several) column with text (or data) is added to the diagram, which in the diagram is converted into signatures of rows, columns, sectors, etc.

Please note that the ready diagram can be edited by changing data, color chart, signature, legend, etc.

The task:

create a chart of the cost of products purchased in the store according to the following template, the total cost to calculate it yourself, allocate only columns B and E (through the key ctrl )

3. Building graphs

As an example, consider the order of constructing the function of the function y. = sin. (x. ) on the interval from 0 to 6.3 in increments of 0.1

1) Preparing the source data

2
) We allocate the entire range of data and call the Master of Charts

3) In the first step of the wizard, choose the following items:

4) You can click the "Finish" button. Graph is ready!

The task :

Build a chart function y. = x. 2 on the range from -3 to 3 in increments of 0.1

Build a graph of the COS function ( x. /2 ) on the interval from -1 to 4 in increments of 0.1

Lesson number 6.
Subject: "Electronic tables - as a means of computer simulation"

Our model that we will develop on the basis of this will biological rhythms.

What are biological rhythms?

We all live according to certain laws. There is a theory that human life is subject to three cyclic processes called biorhythms. Speaking strictly scientifically, biorhythms are periodically repetitive changes in the nature and intensity of biological processes and phenomena in a living organism. These are reflected by the organism of the cyclicity of phenomena walking in nature. A simpler and well-known concept is the "biological clock". Greek doctor Herofil (300 years BC) found that the pulse in a healthy person changes during the day. Subconsciously man chooses the time when it is easier for it. Approximately 400 - 500 years ago, a person began to live on the clock, and before that there was no need for them, since natural and biological clock worked. Biorhythms of the body - daily, monthly, annual - practically remained unchanged from primitive times and can not keep up with the rhythms of modern life.

In recent years, the theory of "three rhythms" has become wide popularity. The starting mechanism of these exceptional rhythms is only the moment of human birth. A man was born, and rhythms arose with a period of 23, 28 and 33 days, determining its level physical, emotional and intellectual activity.

The physical biorhythm characterizes the vital forces of a person, i.e. His physical condition.

An emotional biorhythm characterizes the inner mood of a person, his excitability, the ability of the emotional perception of the surrounding.

Third biorhythm characterizes mental abilities, intellectual state of a person.

The graphic image of these rhythms is sinusoid. Many believe that the "takeoff" of the graphics representing a sinusoidal dependence correspond to more favorable days. One-day periods in which the phase shift occurs ("zero" points on the chart) and which are allegedly distinguished by a decrease in the corresponding level of activity, the name "Critical days", i.e. unfavorable. If one and the same "zero" point intersect two or three sinusoids simultaneously, then such "double" or "triple" critical days are especially dangerous. Moreover, in some countries, on such days, people of risky professions (pilots, cascadeurs, etc.) provide a day off.

According to the theory of biorhythms, the possibility of the human body varies periodically. After a certain number of days (period), the body returns at the same state.

There are several cycles of the body: physical, intellectual, emotional.

It does not depend on the age or from the floor, nor from the nationality of a person.

The beginning of each biorhythm coincides with the date of birth.

It is known that:

The physical cycle lasts 23 days,

Emotional - 28 days,

Intellectual - 33 days.

We will proceed to creating a model of biological rhythms.

1) Creating a mathematical model:

These cycles can be described in the expressions below, in which the variable X is the number of days lived by a person:

Physical Cycle Piz (x) \u003d SIN (2p x / 23)

Emotional cycle emo (x) \u003d sin (2p x / 28)

Intelligent int (x) \u003d sin cycle (2p x / 33)

It is clear that all these functions periodically change their value from -1 to 1 (function of function values sin. (x. ) ).

Knowing how many days have passed since the birth of a person, you can easily calculate the value of the above functions for the current day. To track the change of functions you need x. Increase on the desired number of days.

Having a function of function values, you can build its schedule for which it is easy to track its appearance.

To find out how many days have passed from the day of birth, you need to subtract the date of birth from the current date

Finally the formula will be

SIN (2. (T K --T 0) / K), where

T 0 - Human birth date

T K - Estimated date

K - cycle period

It makes sense in one coordinate system to build all 3 graphics of functions corresponding to each cycle

2) compiling computer model

Fill table:

In cell A1 Introduce the name of the column - date of birth

In B1 Introduce - the estimated date

In C1 Introduce - Physical Cycle

In D 1 Introduce - Emotional Cycle

In E1 Introduce - Intelligent Cycle

Cap table ready.

Data input.

In A2 - the date of birth of a person, for example 01.01.2000

In B2 - the estimated date, for example, February 19, 2004

In C2, the formula for determining the physical cycle \u003d sin (2 * Pi () * (B2-A2) / 23)

In D 2, the formula for determining the emotional cycle \u003d sin (2 * Pi () * (B2-A2) / 28)

In E2, the formula for determining the intelligent cycle \u003d sin (2 * Pi () * (B2-A2) / 33)

For the current day, the data is obtained. We introduce several calculated dates, for example, a week ahead of the current date. To do this, the calculation date will copy down to the desired value of the position.

It remains to copy down the formula for cycles. True here you need to be attentive, as one of the links (try to guess what!) Fixed and, therefore, the formulas must be modified.

The final schedule may turn out about this type.

The task:

Try to expand the scope of the schedule, extending the date to 1 month. Build the graphics obtained

3) Analysis of modeling results.

Look at the graphics received. The higher the sinusoid rises, the higher the corresponding abilities and vice versa. Exceptions can be those days in which the schedule crosses the X axis. Then the abilities can be unpredictable: or wonderful, or very bad.

The task:

1. After analyzing the chart, choose "unfavorable" days for physical education

2. Clear days when the answers in the lessons will be the most (least) successful.

3. Check your mood when the emotional biorhythm indicators are on a decline or on the rise.

Size: px.

Start showing from page:

Transcript.

1 Test Control by LibreOffice Student Course, Group, Specialty Questions to LibreOffice Writer, Math, Calc 1. Spell check in LibreOffice. Writer is executed by the command sequence: a. Service / spelling and grammar b. Format / spelling and grammar c. Edit / Spelling and grammar window / spelling and grammar d. View / spelling and grammar 2. How to open a text document for processing in LibreOffice. Writer? but. Open LibreOffice. Writer and click the Out button b. Select the file and make a double click right-click. Select a file and make a double-click of the left mouse button. File / browser in the browser 3. From which item of the main menu item is set to the toolbars in LibreOffice. Writer? but. File b. Edit in. The format is the d. Service 4. How to create a lower index in LibreOffice. Writer? but. Box / footer b. Edit / change / Lower index in. Type / Fields / Lower index. Format / Sill / Position / Lower index d. Service / Numbering structure / Lower index 5. How to create a marked list with a marker that is not in the standard set of LibreOffice list markers. Writer? but. Run the commands of the Markers / Markers and Numbering / Settings / Symbol / Select / OK b. This list is not possible to create. Edit / change / New marker Insert / image / file / Select marker / OK d. Create a list with default marker, then edit / marker / position / characters / Select marker / OK 6. What software module is included in the LibreOffice package .? but. Notepad b. Calculator in. Word G. Calc d. Mathcad 7. Yak Install the interval between characters in the words LibreOffice. Writer?

2 a. Service / font / interval b. Format / paragraph / intersomymbol interval / interval B. Format / Edit / Interval of Edit / Font / Interval / D. Format / Symbols / Position / InterSimvol Interval 8. How can you switch between LibreOffice documents. If some of them are not visible on the screen? but. File / Open / Select the desired file. b. Press the ALT + TAB key simultaneously to select the desired file in. Service / Gallery / Select the desired window of the window / New window / Select the desired file d. Navigator / Ole objects // Select the desired file 9. How to save the LibreOffice document. With a new name. but. Insert / object / insert a new name b. Edit / Paste How / Insert a new name in. File / Save How / Paste New Name File / Export / Insert New Name D. File / Rename / Insert New Name 11. What extension has a document created by the LibreOffice application. Writer? a..txt b..ott in..doc g..odt d. RTF 12. From which menu item are set to the toolbar at LibreOffice. Writer? but. File / browser b. Format / page in. Type / Toolbar Service / Parameters D. View / Parameters Page 13. As the dimensions and orientation of the LibreOffice page are specified. Writer? but. File/ Preview Pages b. Edit / Change in. View / Toolbar / Design Molds Service / Parameters d. Format / Page 14. How to install LibreOffice page fields. Writer? but. File / Preview Page b. Edit / Change in. Type / Tool Tool / Design Service / Parameters D. Format / Page 15. Which command cannot be created a labreoffice document. Writer? but. Format / markers and numbering b. Press the numbered list button. Press the marked list of Service / Numbering structure, click right-click / markers and numbering

3 16. Spell check in LibreOffice. Writer is executed by a team? but. Service / spelling and grammar b. Format / spelling and grammar c. Edit / Change 17. What modules are not included in libreoffice.? but. Writer b. Calc in. Math G. Mathcad d. Base 18. How to display all non-printable characters on the screen in LibreOffice. Writer? but. Insert/ Special symbols b. View / marking print in. Service / Setup. Type / Unprintable Symbols, Edit / Change / Unprintable Symbols 19. How to display / Hide the horizontal line in LibreOffice. Writer? but. Edit / Paste a line b. View / line in. Insert / line of the format / horizontal line d. Press the line button on the toolbar 20. How to cancel the action performed in LibreOffice.? but. Press the ESC B key. Press the backspase key. Press the Cancel key / From the drop-down menu, select the necessary action of the city. Edit / Change d. Edit / Cut 21. What you need to do to LibreOffice. Writer automatically performed word transfers? but. Service / Language / Language Settings / Linguistics / Automatic Transport Settings b. Service / spelling and grammar / alignment of transfer in. Edit / Change / Alignment of the Magnifies / Paragraph / Automatic Transportation of Transmissions d. Insertion / Special Symbols / Transport Movements 22. How many alignment options are used in LibreOffice. Writer? but. Not one b 1 in. 2 g. 3 d What command is not used to cancel changes? but. Press Ctrl + Z b. Press the icon to cancel on the toolbar. Edit / Return Edit / Cancel / Change / Change / Take or Reject 24. How to establish conditional transfer within the word LibreOffice document. Writer? but. Ctrl + minus sign

4 b. Insert / gap in. Format / Symbols of service / spelling and grammar d. Edit / AutoText 25. How can I set the scale of displaying the document LibreOffice.? but. Box / scale b. Service / scale in. View / scale of the city view / toolbar d. Only using the toolbar 26. As in the LibreOffice application. Display the desired toolbar on the screen, for example, formatting? but. Insert / toolbar b. Service / Toolbar in. Type / Toolbar Add a panel to the list of toolbars using the context menu (right mouse key) d. If the desired toolbar is missing, then you must reinstall LibreOffice 27. What is the difference between the commands to save and save how? but. Nothing b. The Save command does not allow you to save a document with built-in objects (diagrams, figures, etc.) in. The Save command how to change the name and location of the Document command. Save how it does not allow you to change the type of document d. The Save command allows you to create a copy of the file with a new name 28. How to select a text fragment in the LibreOffice document. Writer using the keyboard? but. Using the keyboard it is not possible to highlight, the selection is made only with the mouse b. Click the Shitf key and use the cursor move keys. Click the Ctrl key and use the cursor move keys to use the Tab key. Enable the selection mode using the keyboard in the Service / Options menu and highlight the text using the cursor move keys 29. How to set the font size in the LibreOffice document. Writer? but. In the View / Scale menu b. Only using the size list on the formatting toolbar. In the Insert / Formatting Symbols menu in the Edit / Font menu. In the Format / Symbols menu / Font / Size 30. How to add a table to the LibreOffice document. Writer? but. In the Insert / Table B menu. It is impossible to do it. You need to create a table using a tabular processor (for example, Ooo Calc), and then copy it into the Ooo Writer document. In the Insert / Object / Table Table in the Tools menu / Special Features / Tables d. On the Table / Paste / Table 31 menu. How to turn on the toolbar Elements formulas (Select) in the editor mathematical formulas LibreOffice. Math?

5 a. The View / Selection menu (formulas) b. In the Tool View / Panel menu / Selection (Formula Items) in. In the Toolbar / Toolbar menu / Select (Formula Items), in the Insert / Toolbar menu / Selection (Formula Items). This is not possible. If the toolbar is missing, it will have to use only keyboard 32 for a set of special mathematical symbols. There is an opportunity to insert Greek letters when creating mathematical formulas in the LibreOffice editor. Math? but. Yes, for this you need to open the Service / Catalog b dialog box. There is no such possibility. Yes, for this you need to open the Insert / Special Symbols dialog box, if the Greek font is installed on the computer. Yes, it is necessary to use the Format / Symbols menu / font menu. It is possible to insert a Greek letter in the LibreOffice document. Writer? but. Yes, for this you need to use the insert / object menu. There is no such possibility. Yes, for this you need to open the Insert / Special Symbols dialog box, if a Greek font is installed on the computer. Yes, it is necessary to use the format / symbols menu / font. Writer? but. With the help of the keyboard it is impossible to do this, only with the mouse b. With the help of the keyboard it is impossible to do this, only with the help of special buttons on the scroll bar. Use the CTRL key combination +. Use the Ctrl + Home shortcut. Use the SHIFT + HOME 35 key combination. How to move the cursor using the keyboard to the end of the LibreOffice document. Writer? but. With the help of the keyboard it is impossible to do this, only with the mouse b. With the help of the keyboard it is impossible to do this, only with the help of special buttons on the scroll bar. Use the CTRL + key combination to use the Ctrl + End key combination. Use the Shift + End key combination. How to move the cursor using the keyboard to the beginning of the string in the LibreOffice document. Writer? but. Press the B key. Use the Ctrl + Home key combination. Press the HOME key to press the Pagep d key. Use the SHIFT + 37 key combination. How to move the cursor using the keyboard to the end of the line in the LibreOffice document. Writer? but. Press the B key. Use the Handing of the Ctrl + End key. Press the End key to use the Hands of the Ctrl + d key. Use the SHIFT + 38 keys. Which type of data from the LibreOffice spreadsheet format is not available. Calc?.

6 a. Numeric b. Text in. Dates of the city d. Telephone 39. Specify the scientific format of the data in LibreOffice. Calc?. but. 2,5E-03 b. 2/3 V. 30/12/2010 5% d. 524 $ 40. How to type text in libreOffice cell. Calc in a few lines? but. It is impossible. The text in the cell is recruited only in one line b. Format / alignment / in the middle. Service / Cell Contents Format / Cell / Alignment / Move according to the words d. View / Toolbar / Formatting 41. Specify an item that cannot be contained in LibreOffice formulas. Calc. but. Mathematical operator b. Operator recalculated in. The comparison operator G. Text operator d. Link operator 42. From what sign the formula is beginning to enter the LibreOffice. Calc? but. f (x) b. Δ in. \u003d σ d. 43. What does the record "Taxes!" In the link cell. but. This is the name of the sheet on which the cell b. This is the name of the function by which the value is calculated in the cell. This error message is a new name, which was set by the cell. This means that the number in the cell will be displayed in cash 44. What extension has a document created by the LibreOffice application. Calc? A..mcd b..math in..ods g..odt d. ODB 45. The spreadsheet is designed for: a. Processing predominantly numeric data structured using tables b. Streamlined storage and processing of significant data arrays; visualization of structural links between data presented in tables in. Editing graphic representations of large amounts of information 46. Rows of the spreadsheet:

7 a. Referred to as users randomly b. Denoted by the letters of the Russian alphabet in. Denotees of the Latin alphabet of the city are numbered. 47. In the general case of a spreadsheet: a. Denoted by the letters of the Latin alphabet b. Numbers in. The letters of the Russian alphabet of the city are referred to by users of an arbitrary manner 48. For the user cell of the spreadsheet, identifies: a. By sequentially specifying the name of the column and the number of the string, on the intersection of which the cell is located. Machine address address random access memoryDisorded under the cell. A special code word in the name of an arbitrarily asked user 49. Computational formulas in the cells of the spreadsheet are recorded: a. With the help of editors of mathematical formulas b. In the usual mathematical record in. Special with the use of embedded functions and according to the rules adopted to record expressions in the programming languages \u200b\u200baccording to the rules adopted exclusively for spreadsheets. According to the rules adopted exclusively for databases 50. Select the correct formula to write to the spreadsheet: a. C3 + 4 * D4 b. C3 \u003d C1 + 2 * C2. A5B5 + 23 g. \u003d A2 * A3-A4 51. When moving or copying an absolute links to the electronic table: a. Do not change b. Converted regardless of the new position of formula B. Depending on the new position of the formula, the formula is converted depending on the length of the formula d. Converted depending on the rules specified in formula 52. When moving or copying relative references in the electronic table: a. Converts regardless of the new position of formula b. Converted depending on the length of the formula B. Do not change. G. are converted depending on the new position of formula d. Converted depending on the built-in functions 53. The range is: a. The totality of the cells forming the area of \u200b\u200bthe rectangular form b. All cells of one row in. All cells of one column of G. Many permissible values \u200b\u200bof the d. Arguments function 54. Active cell is a cell: a. To record commands

8 b. Containing the formula that includes the name of the cell in which data is entered in. The first cell sheet of the formula in which references to the contents of the dependent cell d. The cell in which 55 is performed. What will be the value of the C1 cell, if to enter the formula \u003d a1 + b1 a. 20 b. 15 V. 10 g. 30 d. Error message appears 56. What formula will be obtained when copying into a C3 cell of the C2 cell: a. \u003d A1 * A2 + B2 b. \u003d $ A $ 1 * $ A $ 2 + $ B $ 2 V. \u003d $ A $ 1 * A3 + B3 G. \u003d $ A $ 2 * A3 + B3 d. \u003d $ B $ 2 * A3 + B4

Test on spreadsheet 1. Network Table This: 1) Device personal computer, managing its resources in the processing of data in tabular form; 2) Application program for processing

IOPD, Utvosov V.V., 2009 Complex test on OpenOffice.org Calc spreadsheets 1. Network Table This: Select all the right answers to test questions 1) Personal computer device,

1. Text processor OpenOffice.org Writer. Text input and formatting General The Writer text processor is currently the most famous OpenOffice.org application. As text

Section 1 Text Processor MS WORD Table of Contents Section 1 Text Processor MS Word ... 1 1 MS Word Window ... 3 1.1 Office Button 4 1.2 Panel quick access and tuning panel ... 5 1.3 window setup

Document Structure The MicrosOFTexcel document is called a book (sometimes use the term "workbook"). MicrosoftExcel's book consists of individual sheets (sometimes used the term "work list"). Revenge

Knowledge Control Test Microsoft Word. Task 1 Font size This ... 1. Headset 2. Interlignague 3. Kell 4. Handers. Task 2 Font type (Graphic image of font symbols) This is ... 1. Headset 2.

Laboratory work 3 Working with Word The goal of the work: Getting practical skills to work with a text processor. Brief theoretical information Working environment Word text processor includes funds

Practical work 3 Working with Microsoft Office Word 2003 text processor. Enter and edit text. Formatting a document The purpose of the work: 1. Getting practical skills to create and edit

Vertical ruler Vertical scroll bar Theme 1.2. Text information processing technologies Curriculum content 1. MS Word text processor, its purpose, possibilities. Formatting

IKTO OZO 1.Select the correct record of the formula for the spreadsheet: 1) C3 + 4 * D4 2) A5B5 + 23 3) C3 \u003d C1 + 2 * C2 4) \u003d A2 * A3-A4 2. Active cell is a cell: 1 ) to record commands; 2) the formula in which is contained

6.1. Microsoft Word 2000 Text Processor. Enter and formatting text 6.1.1. General Information The Microsoft Word Text Processor is currently the world's most popular text editor.

Word 2007 Text Editor Program Interface Text Editor (Processor) This is a universal application program designed to create and process texts using a computer that allows

Practical work 15 Enter, editing, formatting and saving text. Lists goal: Get the initial skills of working with a text document, get acquainted with the main editing techniques

Laboratory work 9 Integrated Wednesday OpenOffice.org Calc. Data input. Actions on cells. Formatting a table. Print table. Work area CALC OCALC module is a system

1 Word makes it easy to format characters and paragraphs. Built-in spelling and grammar check programs check the document not only after its completion, but also in the process of creating. Existing means

Independent work lists. Preparing a text document to print header. Build an associative bush to the concept of "numbered list." Numbered list. Write down the sequence of creating

Tambov Regional State Budget educational institution Average vocational education "Instrument-making college" Lecture materials on the topic "Text editor Microsoft

Procedure for performing work Practical work 1 1. Exercises 1, 2, 3, 4, 5, 6. Exercise 1 1. Create new document. Save the document named text1.doc. 2. Set page settings

Total test, applied informatics, tank. OZO (2727) 1. (45C.) To close the document, press keys 1) Alt + F4 2) SHIFT + F4 3) Ctrl + F4 4) F4 2. (45C.) Formula \u003d SRNVOV (A1: A5) Apply in the program 1) Word.

Basic ways of formatting characters, paragraphs and pages Operation Symbol formatting 1. Changing the type and size of font 2. Changing the color of the symbol 3. Text underscore

L. L. Boltko, E. V. Kremin, Yu. A. Flint Working with text editors (on example Microsoft WORD 2002) Module 3 Minsk Academy of Postgraduate Education 2003 UDC 37 (075.8) BBK 32.973.26-018.2

90 Chapter 5 Inscription This tab is available for objects within which the text has been dialed. With it, you can adjust the internal fields and specify whether the object size will change if the text does not fit

Basics of working with LibreOffice applications. LibreOffice is a package (set) of applications to work with documents of various types, text processing tool, spreadsheets, presentations, etc.

Test tasks for testing on the discipline "Informatics" for students of the specialty "Nursing" (evening compartment) 2 course, 4 semester 1. To create and edit a text file in Windows

FULL NAME DISTRICT OU Testing on the definition of overall hooking ICT competence 1) Which of the listed menu commands can be used to add slide numbers to the presentation? 1. Insert; 2. Design;

Creating Tables, Pictures and Implementing Objects in Text Document Operation Creating and Change formulas Microsoft. Word Performing 1. Run the command insert command Insert MS Equation object

Basic teams and operations! Check how you remember the studied material windows system 7 and text processor MS WORD Basic actions when working in Windows 7. Select the icon click

Practical work 3.2. Working with MS Word. Presentation of text in lists format. Working with tables goal. After completing this work, you will learn: form labeled and numbered

Topic 6 Working with AMI objects Let's call the elements of the document that are not text: drawings, formulas, diagrams, figure text. x a 3 2 5 b b a f (x) dx insert and in document diagram there are two

Tabular processor 1 Purpose and functionality Excel Tabular processor This is a program that provides the creation and automatic processing of the spreadsheet. The spreadsheet is automated

Practical work 3.3. Working with MS Word. Creating and editing graphic objects. Insert to the formula document. Structuring the document The purpose of the work. By completing this work, you will learn:

Workshop 5.2.1. Tableware Processor Interface Interface Wednesday Tabular Processor ... 1 Office Button ... 1 Tape and tabs ... 1 groups ... 2 Quick Access Bar ... 3 Workbook Interface ... 3

Laboratory work 6 "Basics of creating spreadsheets" Operation: Studying the basic rules for creating and editing spreadsheets in the OpenOffice.org Calc table processor environment. Brief

Work technology in text editor Microsoft Word 1. Launching Microsoft. Word Starting Programs Microsoft Office. Microsoft Word. 2. Text set rules in Microsoft Word: when typing in Word adheres

Spreadsheets Computer programsDesigned for storing and processing data presented in table form are called spreadsheets. Advantages of spreadsheets: 1. Data,

Topic: Purpose: Time: Task: Literature: Practical work 8. Fundamentals of editing. Formatting text, paragraph. Work with multiple documents. Get practical skills in working with fragments

Microsoft Excel. 2010 Ayupov R.X. Acquaintance with MS Excel spreadsheet this table in electronic form, in the cells of which data recorded different types: Texts, dates, formulas, numbers. For driving

Basics of work in a text editor. Basic programs for working with the text WordPad (there is in all windows computers) MS Word Open Office Open the program double-click on the program icon on the working

Task for performing laboratory work 2 Creating and editing documents in the Microsoft Word text editor environment General requirements for registration of laboratory work and the procedure for its protection laboratory

Text Preparing Systems Text Processor Microsoft Word 2010 Plan - Functions and Classification of Text Preparing Systems - Text Editor MicrosoftWord: General Information, Window Structure. - Work

The table editor OpenOffice.org Calc (hereinafter simply CALC) is designed to work with spreadsheets, it can be calculated, analyze and manage data. For data processing

Ministry of Education Russian Federation Penza state University E.G. Sheremetyeva Basics of working with Microsoft Excel spreadsheets 2003/2007/2010 Set of questions for testing

Work time: 2 hours. 1. Extracurric preparation to issue a title page. See Appendix 1 2. Work in the laboratory Basic information immediately after the launch of Word automatically creates a new document

Table of Contents Introduction ................................................ .. 13 Part 1. The rule of the right mouse button, with which it starts to get acquainted with Windows ...................... 16 Chapter 1. Azi System

Excel Data Formatting In Cell Introduction The spreadsheet is a data processing program presented as a rectangular table. It allows you to perform various calculations and clearly illustrate

Practical work 9 Theme: Creating documents in the MS Word editor. Formatting fonts. Objective: Study information technology creating, formatting and saving documents in MS Word.

Laboratory work 2 Editing and document formatting Operation Operation: To form the skill to perform the main techniques for editing and formatting text (selection, copying, movement

The first acquaintance with the Microsoft Excel Microsoft Excel tabular processor is the most popular table processor in the world. With it, it is possible to carry out the automation of all kinds of calculations, building a business

TEXT EDITOR Word text Word Editor Program for creating, editing, formatting, saving and printing text documents, spell checks in the document. Launch Word Run Word

Laboratory work 7 Topic: Style formatting documents. Creating a table of contents. Using styles in the process of creating a document often have to deal with headlines. As a rule, headlines

General information about the MS WORD editor Main features of the test processor Creating a document by: input and format text; Creating tables I. table forms; Text layouts in several

Working with Microsoft Excel Tablet Purpose Brief Theoretical Information Windows application Excel allows you to form and print documents presented in tabular form, perform calculations

Ministry of Health of the Russian Federation GBOU Higher Professional Education Amur State Medical Camemic E.V. EXCEL CSEE ELECTRONIC TABLE. Methodical instructions

Federal State Educational Institution of Higher Professional Education "Southern Federal University" Ostrovskaya I.V. Test tasks on the topic: Work with Excel spreadsheels

Practical work 6 Preparation of documents using text processors type Microsoft Word Objective: familiarity with features electronic documents and their editing medium

Basics of work in the MS Word 2007 program Description of the program window After starting the MS WORD program, it opens its window. The title window writes name open File or Document1, Document2, if

Text Processor Microsoft Word Creating text documents in the Microsoft Word Editor Start and Exit Editor Start Editor After downloading the Windows shell in the Microsoft Office window, double-click

Practical work 14. Topic: Insert objects in the document. Print preparation. The purpose of the lesson. Studying information technology inserting objects to text in MS Word. Task 14.1. Inserting Wordart objects.

Information technologies in professional activity Example of test tasks 1. The imaged fragment of the Excel user interface element is ... 1. Status String 2. Line of Formula 3. Panel

Creating and editing a text document in Microsoft Word 2003 Text editor is a program that allows you to create a document with text data. Text processor is an input program

Tasks on computer science 8 class Bank questions for testing 1. Some number in the binary number system is written as 11011010. Record this number in the decimal system. 2. Translate the number 126

Main tasks in Word 2010 General information about the Word Microsoft Word 2010 application is a text processor designed to create professionally decorated documents. Combining the best means

Processing data to the Microsoft Excel tabular processor tools for data presentation in a convenient form uses tables, which makes it possible not only to display, but also process data. Class

Electronic tables Variety of spreadsheets in MS Excel applications (Digital Tables) Sulsim (Data Output in Excel) HYSYS (Nets. Electric Tables) Maple (Symval Tables) Introduction Scope

Ministry of Education of the Russian Federation Penza State University E.G. Sheremetyeva Basics of working with text processor MS WORD 2003/2007/2010 A set of questions for testing Penza

Practical lesson 4 Topic: Registration of formulas Editor MS Equation. The goal of the work is to learn to operate the library of mathematical symbols when inserting into a document of mathematical formulas using an object

1 Practical lesson 11 concept of spreadsheet. Appointment of an electronic processor. Table structure: cells, columns, strings. Types of data in the spreadsheet The purpose of the work: to get acquainted with the concept

Ministry of Education and Science of the Russian Federation

Federal State Budgetary Educational

Establishment of higher education

"Tula State University"

Institute of Applied Mathematics and Computer Sciences

Department of Information Security

COMPUTER SCIENCE

Methodical instructions

for laboratory work

for students of day form training in the direction (specialty) of training

090303 (05/10/03) "Information Security of Automated Systems"

Introduction Procedure for performing work

Previously, before the beginning of the laboratory classes, students get acquainted with the goals and objectives of laboratory work, with a job task, as well as study the explanations set out in the "Theoretical Information" method of methodological instructions for the fulfillment of the next work.

During the class, students perform the task (see "Task for work") in the sequence set out in the "Procedure for Work Officer". For most works, it is planned to perform assignments for individual options. The option is appointed by a teacher conducted by occupation.

According to the results of the work, a report on the implementation of laboratory work is issued. The report requirements are specified in the methodological instructions for each work. The report is issued at the beginning in electronic form (in class), then printed to the next lesson.

Each laboratory work provides for protection. To defend, the student must present: the result of the task (general and in its version), the report in electronic form and in paper. During the protection of work, the student is asked questions in the course of the tasks or theoretical materialconsidered in work. If the student gives satisfactory answers to all questions, work is considered a protected and teacher puts the corresponding number of points on the title page of the report (from 0 to 3) and its signature.

Laboratory work 1. Text editor MS Word. General principles of work.

Objective and work tasks

This paper studies the basic principles and techniques of work in the MS Word text editor.

Theoretical information

Launch MS Word.. To start MS Word through the button Startyou must perform the following steps: Test the mouse to the button Start and press the left key; From the list that appears to select item Programs; Click the menu item - Microsoft Word..

In this operation mode, the MS WORD editor is launched with the creation of a new document. Figure 1 shows general form MS Word windows (depending on the MS Word version, the view of the window may be different).

Menu item - File. When you click the file button, the drop-down menu appears, with points:

- "Create" - creates a new MS Word file, (Ctrl-N);

- "Open"- Opens the dialog box in which you are invited to select a file for work, (Ctrl-O);

- "Close"- closes the working file;

- "Page settings" - opens a dialog box with page parameters;

- "Preview" - opens the document window in which the type of document is shown when printing on the printer;

- "Print" - Opens the document print dialog box.

- "Properties" - Opens a window containing information about the work document.

- "Output"- Closes the MS Word application. If, when you click on the output, the document is not saved, then the menu drops with a proposal to save the document.

This menu also shows a list of several recent documents with which work was performed. When you click on them, they open in the editor.

Setting the document page settings. To configure the document parameters, press Menu → File → Page Settings, after which the window will open in Figure 2.

In the tab "Fields" Customizable: field values \u200b\u200b(top, left, lower, right and binding); orientation of the document (book and album); Document type on page - "Pages"; Scope of the page parameters in relation to the document.

In the tab "Paper size": Selects paper size list; Installed accurate paper size; The scope of the application parameters in relation to the document is determined.

In the tab "Paper Source"customize: Rules for the start of a new section; Rules of the difference of footers; Scope of the page parameters in relation to the document.

Menu item is editing. Pressing the button EditOpens the menu shown in Figure 3.

Actions:

- "Cancel" - Cancellation of actions, on the principle of the stack,
(Ctrl-Z);

- "Repeat" - repetitions of the last action (Ctrl-y);

- "Cut" - removes the selected fragment and places it in the buffer,
(Ctrl-x);

- "Copy" - copies the selected fragment in the buffer, (Ctrl-C);

- "Paste" - inserts information from the buffer to the document, (Ctrl-V);

- "Select all" - allocates all the contents of the document, (CTRL-A);

Menu item - View. When you click on the menu item View The menu opens in Figure 4.

This window uses a document presentation on the screen.

Menu item - Window. When you click on the menu item Window The menu opens in Figure 5.

Actions:

- "New" - opens the current document in a new window;

- “Sort all " - distributes all the Open MS Word window on the computer screen;

- "Split" - Allows you to divide the screen into several working zones containing open documents in MS Word.

Menu item - Help. When you open this menu, a list of items containing reference information And various assistants in working with MS Word.

Setting up MS Word.

Setting up MS WORD panels through the Tools menu item → Setup. After clicking on this item, a window opens with the settings, Figure 6. The window contains bookmarks: Toolbar, Commands and Parameters.

The "Toolbar" tab indicates which panels must be on the screen. The "Commands" tab is specified which commands should be on the screen. The "Parameters" tab contains additional parameters of the properties of the panels.

Insert objects.

Inserting objects in MS Word is carried out through the Insert → Object menu. A window with two bookmarks appears on the screen: Creating and creating from the file. If you select the "Creating" section, a new object is added to the document, and when you click from the "Creating Flah" item already from an existing object / file. See Figure 7.

Task for work

Remember the main features of the text processor (Microsoft Word) to create simple documents. Create a report in electronic form.

Registration of the report

The work report is issued in electronic and paper form.

The report must contain: the title page, the goal and task of work, job task, the results of the task execution (in its version). The title-sheet sample is represented in annex to these methodological instructions.

Procedure for performing work

1. Run MS Word with the creation of a new file. Start the registration of the report on laboratory work. The title page (sample) is presented in the application to this methodical instructions. Dial the text of the title page of the report on the work (for each student individual) and save the file on the disk. Open a file from a disk and configure the MS Word page settings to the following parameters (paper size - A4; page orientation - books; fields (left - 2.5 cm; right -1.5 cm; upper - 2 cm; Lower - 2 cm.))

2. Familiarize in practice with the material set out in paragraph "Theoretical Information", remember the hot keys of the main commands.

3. Adjust the panels. Display panels - standard and formatting. To get acquainted with the functional set of commands, for example, the "Fonts" commands, "Kerning" and "text alignment".

4. Cell the objects "Microsoft Equation 3.0". Dial formulas by your option. Create a list of designations to the formula, for example, as follows:

5. Make the Microsoft Word Figure Object. Create a drawing explaining the formulas (the drawing must be created on your own, and not inserted ready, for example, from the Internet). Sign the drawing as - Figure 1 - Description of the picture. If necessary, create several drawings

Options for tasks

№ Var.	Formula description
	Relations that bind the lengths of the sides of the rectangular triangle with a degree of angles (through sinus and cosine)
	Relations for determining the area of \u200b\u200btrapezoid, the area of \u200b\u200bthe parallelogram and the Roma Square.
	The cosine theorem and the sinus theorem
	Pythagoreo theorem, height calculation in a rectangular triangle.
	Calculation of the triangle area (at least two formulas)
	Calculation of a quadrangle area (at least two formulas)
	Finding the radius inscribed and described circle (for a triangle)
	The height of the pyramid, the volume of the pyramid.
	Cone volume, cone surface area.
	Cylinder volume, cylinder surface area.
	Relations between trigonometric functions of one argument (at least three formulas)
	Equation direct on the plane (at least two options)
	The distance from the point to direct on the plane, from the point to the plane in space, the distance between two direct in space.

Laboratory operation 2. OpenOffice text processor (LibreOffice) Writer. Interface OpenOffice Writer.

Objective and work tasks

In this paper, the basic principles and techniques of work in the OpenOffice text editor (LibreOffice) Writer are being studied.

Theoretical information

The main workspace of the Writer text editor is shown in Figure 1.

Writer includes several context-dependent toolbars that default appear as floating in response to the current position of the cursor or selection. For example, when the cursor is in the table, a floating toolbar appears Table, and when the cursor is in a numbered or marked list, the markers and numbering toolbar appears.

To show or hide the rules, you need to choose View\u003e ruler .

The status bar displays the following information:

· current page number and total number of pages in the document. Double-clicking the left mouse button on this window opens the navigator with which you can navigate through the document. By right-clicking, all tabs are displayed in the document;

· current page style. Double-clicking the left mouse button opens the page formatting window. Click right-click allows you to select a style from the pop-up list;

· display scale. Click right-click allows you to select another scale from the list;

· displays the current text set mode - insert or replacement;

· displays the current selection mode - standard, advanced or add mode;

· hyperssril's mode allows you to translate them from an active state to change mode;

· sign of conservation of changes. If the changes made in the document were not saved, the stars symbol (*) will be displayed in this window;

· digital signature window. With it, you can add or remove digital signature to a document (right-click right-click);

LibreOffice is a package office programsextended by free based and having an open source code. Since the first prototypes of computers were ordinary printing machines and accounts, so far their main functionality remains sharpened on the set of texts and conducting various calculations.

Libreofiice is actively used in government institutions. Some countries (including military). This office package includes text, tabular, vector editors, Tools for creating presentations and work with databases. The functionality is not inferior to its commercial analogue - MS Office, but at the same time consumes significantly less computer resources.

Also, LibreOffice packages are regularly updated, so all the "new items" will be available sooner or later.

general information

The first versions of LibreOffice appeared in the 2010 and originally intended for operating linux systems. However, soon appeared versions and Windows with Mac OS. Today, this office package is included with the majority of popular Linux distributions.

Working with text documents

The program embedded in this package and the text document responsible for working with text documents is LibreOffice Writer. By default, all documents created in this program will have format - ODT. However, the editor copes without any problems with other popular text file formats, such as DocX, TXT, etc. True, sometimes "not native" formats can open a little crooked, that is, there can be marked, fonts, etc., but it is quickly restored.

A remarkable feature of the program is the ability to immediately convert the created document into a PDF file. In Word, this requires install a special plugin and program.

All major editing tools are located in the top toolbar. Sometimes it is not very convenient, as you can look for the right tool for a long time. In Word, for example, all tools are distributed by category and look for them easier. With the help of additional plugins and add-ons you can change appearance top toolbar, add new elements, etc.

However, the LibreOffice Write toolbar has some advantages over Word. For example, from there it is easy to change styles, as you need to press literally a few buttons, while in Word will have to climb into settings of styles.

The area for a set of text is not distinguished by any remarkable. Also, the user can configure the sidebar tool. By default, in some versions it is not at all, or there are very few items.

At the bottom there are elements for counting pages, words and symbols in the document, language and scale switch buttons. There is nothing to change there.

In general, in LibreOffice Write there are all the necessary function to the usual user. The only problem may arise with automatic check Spells, since in earlier versions it is disabled by default and you have to include it in the top toolbar yourself.

Working with tables

Here we are talking about an analogue of Excel - Libre Office Calc. It also creates and works with documents in its own format - ODS, but it supports working with other common tabl formats, for example, XHTML, XML, etc. It should be borne in mind that sometimes there may be small failures in working with outsidated formats, but this is mainly expressed in small cosmetic defects.

The main part of the interface is occupied by table cells that you can edit and change under your discretion. In the upper part there is a panel with tools similar to the one that is presented in Libre Office Write, however, most of the tools are adapted for work with tables. Here you can create diagrams, produce various manipulations with cells, etc. From here you can immediately display a document in the PDF format, send to print, etc. Plus, there are functions for sorting tabular values \u200b\u200bin many parameters, for example, alphabetically, decrease in the order, etc.

Some versions are present side panel from small quantity Available tools. At the bottom of the window, you can switch between sheets, changing the scale, view formulas.

When you press the right mouse button, the context menu appears. Parts It duplicates controls located on the top panel.

In any tabular editor, it will be necessary to work with formulas. There are no special differences from Excel. The input process and formulas are the same.

The only drawback of Libre Office Calc is the complexity with the formatting of the cells, since all the necessary tools need to be sought in special submenu.

Work with presentations

For presentations in Libre Office, the Impress program is replied, which with its tasks is not working as good as Microsoft PowerPoint. On functionality and interface latest version Impress reminds something average between PowerPoint 2003 and 2007. Main working format files - ODP. There are support and other formats, but only the formats of older versions of PowerPoint work correctly.

The functionality and animation in this program is not so much, but it is quite enough to develop simple presentations. You can create animation, add musical accompaniment, various effects.

The main part of the interface occupies a working area with slides, and the other half the area with the slide settings. Basically, the side part of the interface is responsible for adding and processing effects and animation.

In the top panel there are several items for quick insertion into the slide, plus, tools for processing the document itself (button of saving, export, search by document, etc.).

The functionality can be expanded at the expense of plugins and additions, but their installation is much more complicated than in the same PowerPoint, and their number is extremely limited.

Working with vector drawings

In the standard Microsoft Office package there are no programs specifically designed for drawing and processing vector Images. However, LIBRE Office Draw (this program in the package is responsible for working with vector graphics) is often compared with PAINT. Their functional is somewhat similar, but on this similarity ends. Libre Office Draw works with ODG format.

Here you can work in multitasking mode, while in Paint work simultaneously with multiple files is very uncomfortable.
The Libre Office Draw interface is conditionally divided into two main panels with tools and the panel, from where you can control the document and add different items to the workspace. On the right there is a window with the properties of the document and a small panel with tools (in some versions it is not).

This program is convenient to compile flowcharts and work with 3D objects, while Paint This functionality is only implemented.

Work with formulas

Libre Office Package special program For accurate calculations using formulas - Math. This software works with ODF format files. The program can use both prepared in advance formulas and compile them with code. For the production of calculations, a computer algebra based on the Mathematica system is used. This system is very often used in engineering, especially when accurate calculations need to perform.

The program interface includes windows for entering code, output formulas and select operations in the central part. All formulas are divided into sections, which simplifies work with them. Work in the code editor occurs using the Mathml language. At the top there is a panel with document management elements (save, send to print, etc.).

In MS Office no separate program To work with formulas, but simplified formula editors are embedded in Word and Excel. Separate professional editor of mathematical formulas will first be useful for engineers and mathematicians. Conventional users could easily get around and built-in editors in Writer and / or Calc.

The functionality of this program can be expanded due to additional plug-ins from the Internet.

Working with databases

In this office package provides its analogue MS Access - Libre Office Base. Working format - ODB, but there is the possibility of supporting other formats, however, some of them can be processed incorrectly.

The program has several table creating modes:

• Master mode;
• Designer mode;
• Presentation mode.

The program interface is divided into several main parts:

• Left panel. Here schematically indicates the structure of the database. From here you can switch between requests, tables, forms, reports;
• The central part is divided into two windows - "tasks" and "Tables". In the first case, you can choose some kind of task for one of the database structure segment, and in the second one to see the result in the form of tables;
• At the top there is a panel with the main tools to work with the document (save button, printing, searching for the document, etc.).

Also, the database manager supports work with MySQL and SQL. The process of creating some elements in this program may differ from similar in MS Access. However, the interface of this program is much easier than its counterpart from Microsoft.

Conclusion

Based on all the above, you can note the advantages and disadvantages. office package Libre Office.

Benefits

• The interface of almost all programs in the package is simplified as much as possible, there is a detailed "Help", so that this package is perfect for inexperienced PC users;
• This is completely free Product open source;
• There is support for the Russian language;
• Supported work on many UNIX-compatible systems, and these are MS Windows, Mac, Linux;
• Low requirements for the "gland" of the computer. Without problems, start and will work even on very old cars.

disadvantages

• The functionality of some programs from the package is inferior to the functionality. similar programs From the MS Office package;
• Some programs that are in MS Office have no analogues in this package.

Of course, in some aspects of Libre Office inferior to its competitor from Microsoft, but at the same time it has the entire functionality that needs to work is undemanding to the "gland" and easier to master.