MINISTRY OF EDUCATION AND SCIENCE OF THE RUSSIAN FEDERATION
FEDERAL STATE BUDGET EDUCATIONAL
INSTITUTION OF HIGHER EDUCATION
"TULA STATE UNIVERSITY"
Institute of Applied Mathematics and Computer Science
Department of Information Security
COMPUTER SCIENCE
METHODOLOGICAL INSTRUCTIONS
for laboratory work
for full-time students in the direction (specialty) of training
090303 (10.05.03) “Information Security automated systems”
Introduction. Work order
Previously, before the start of the laboratory session, students get acquainted with the goals and objectives of the laboratory work, with the assignment for work, and also study the explanations set forth in the paragraph "Theoretical information" of the methodological instructions for performing the next work.
During the lesson, students complete the task (see paragraphs "task for work") in the sequence set out in the paragraph "Order of the work". For most of the work provided for the implementation of tasks for individual options. The option is assigned by the teacher conducting the lesson.
Based on the results of the work, a report on the implementation of laboratory work is drawn up. The requirements for the report are specified in the guidelines for each work. The report is first drawn up in electronic form (at the lesson), then printed out for the next lesson.
Each laboratory work provides protection. For protection, the student must present: the result of the assignment (general and in its own version), a report in electronic form and in paper form. During the defense of the work, the student is asked questions in the course of completing assignments or on the theoretical material considered in the work. If the student gives satisfactory answers to all questions, the work is considered protected and the teacher puts the appropriate number of points (from 0 to 3) and his signature on the title page of the report.
Laboratory work 1. Text editor MS WORD. General principles work.
Purpose and tasks of the work
In this paper, we study the basic principles and techniques of working in the MS Word text editor.
THEORETICAL DATA
Launching MS Word. To launch MS Word via a button Start you need to do the following: move the mouse to the button Start and press left key; select an item from the list that appears Programs; click on the menu item Microsoft Word .
In this mode of operation, the MS Word editor starts with the creation of a new document. Figure 1 shows general form MS Word windows (depending on the version of MS Word, the appearance of the window may be different).
Menu item - File. When you click on the File button, a drop-down menu appears with the following items:
- "Create"– Creates a new MS Word file, (Ctrl-N);
- “Open”– Opens a dialog box that prompts you to select a file to work with (Ctrl-O);
- “Close”– Closes the working file;
- "Page settings"– Opens a dialog box with page settings;
- "Preview"– Opens the document window, which shows the type of document when printed on a printer;
- "Seal"– Opens the print document dialog box.
- "Properties"– Opens a window containing information about the working document.
- "Exit"– closes the MS Word application. If the document is not saved when you click on the exit, then a menu appears asking you to save the document.
This menu also shows a list of the last few documents you have worked on. When you click on them, they open in the editor.
Set document page settings. To configure the document settings, click - Menu→File→Page settings, after which the window shown in Figure 2 will open.
Bookmarked "Fields" configurable: margin values (top, left, bottom, right and binding); document orientation (portrait and landscape); document type on the page – “Pages”; the scope of the page settings in relation to the document.
Bookmarked “Paper Size”: paper size is selected from the list; set the exact paper size; determines the scope of the page settings in relation to the document.
Bookmarked “Paper Source” configurable: rules for starting a new section; rules for distinguishing headers and footers; the scope of the page settings in relation to the document.
Menu item - Edit. By pressing the button Edit, the menu shown in Figure 3 opens.
Actions:
- "Cancel"– actions are canceled, according to the stack principle,
(Ctrl-Z);
- "Repeat"- makes repetition last action, (Ctrl-Y);
- "Cut out"- deletes the selected fragment and places it in the buffer,
(Ctrl-X);
- "Copy"– copies the selected fragment to the clipboard, (Ctrl-C);
- "Insert"– inserts information from the clipboard into the document, (Ctrl-V);
- "Select all"- selects the entire contents of the document, (Ctrl-A);
Menu item - View. Clicking on a menu item View The menu shown in Figure 4 opens.
In this window, you can configure the presentation of the document on the screen.
Menu item - Window. Clicking on a menu item Window the menu shown in Figure 5 opens.
Actions:
- "New"– opens the current document in a new window;
- “Organize everything”– distributes the entire open MS Word window on the computer screen;
- "Divide"– allows you to split the screen into several work areas containing open documents in MS Word.
Menu item - Help. When opening this menu a list of items containing background information and various assistants in working with MS Word.
Setting up MS Word.
Setting up MS Word panels is carried out through the menu item Tools→Settings. After clicking on this item, a window with settings opens, Figure 6. The window contains tabs: toolbars, commands, and parameters.
The “Toolbars” tab specifies which toolbars should be on the screen. The “Commands” tab indicates which commands should be on the screen. The “Parameters” tab contains additional parameters for panel properties.
Inserting objects.
Inserting objects in MS Word is carried out through the menu Insert→Object. A window with two tabs appears on the screen: Create and Create from file. When selected from the “Create” section, a new object is added to the document, and when clicked from the “Create from File” item, from an existing object / file. See figure 7.
JOB TASK
Recall the main features of a word processor (Microsoft Word) for creating simple documents. Create an electronic report.
Report design
The work report is issued in electronic and paper form.
The report should contain: the title page, the purpose and objectives of the work, the task for the work, the results of the task (in its own version). A sample title page is provided in the appendix to these guidelines.
WORK PROCEDURE
1. Run MS Word to create a new file. Start writing a lab report. The title page (sample) is presented in the appendix to these guidelines. Type the text of the title page of the work report (individual for each student) and save the file on disk. Open the file from the disk and configure the MS Word page settings for the following parameters (paper size - A4; page orientation - portrait; Margins (left - 2.5 cm; right -1.5 cm; top - 2 cm; bottom - 2 cm))
2. Get acquainted in practice with the material set out in the "Theoretical Information" paragraph, memorize the hot keys of the main commands.
3. Set up the panels. Display panels - Standard and Formatting. Familiarize yourself with a functional set of commands, such as fonts, kerning, and text alignment commands.
4. Insert "Microsoft Equation 3.0" objects. Type in the formulas of your choice. Give a list of symbols to the formula, for example, like this:
5. Insert the “Microsoft Word Picture” object. Create a picture explaining the formulas (the picture must be created by yourself, and not inserted ready-made, for example, from the Internet). Sign the figure as - Figure 1 - Description of the figure. Create multiple drawings if necessary
Task options
| var. no. | Formula Description |
| Relationships connecting the lengths of the sides of a right triangle with the degree measure of angles (via sine and cosine) | |
| Relationships for determining the area of a trapezoid, the area of a parallelogram, and the area of a rhombus. | |
| Cosine theorem and sine theorem | |
| Pythagorean theorem, calculation of heights in a right triangle. | |
| Calculating the area of a triangle (at least two formulas) | |
| Calculating the area of a quadrilateral (at least two formulas) | |
| Finding the radius of the inscribed and circumscribed circle (for a triangle) | |
| The height of the pyramid, the volume of the pyramid. | |
| Volume of a cone, surface area of a cone. | |
| Volume of a cylinder, surface area of a cylinder. | |
| Relations between trigonometric functions of one argument (at least three formulas) | |
| Equation of a straight line on a plane (at least two options) | |
| The distance from a point to a line in a plane, from a point to a plane in space, the distance between two lines in space. |
Laboratory work 2. Word processor OpenOffice (LibreOffice) Writer. OpenOffice Writer Interface
Purpose and tasks of the work
In this paper, we study the basic principles and techniques of working in the text editor OpenOffice (LibreOffice) Writer.
THEORETICAL DATA
Main working space text editor Writer shown in Figure 1.
Writer includes several context-sensitive toolbars that appear floating by default in response to the current cursor or selection position. For example, when the cursor is in a table, the floating Table toolbar appears, and when the cursor is in a numbered or bulleted list, the Bullets and Numbering toolbar appears.
To show or hide rulers, select View > Ruler .
The status bar displays the following information:
· the current page number and the 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. On Click right click mouse click displays all bookmarks in the document;
· current page style. Double-clicking the left mouse button opens the page setup formatting window. Clicking the right mouse button allows you to select a style from a pop-up list;
· display scale. Clicking the right mouse button allows you to select a different scale from the list;
· display current typing mode– insertion or replacement;
· display current selection mode– standard, extended or add mode;
· hyperlink mode allows you to transfer them from the active state to the change mode;
· sign of saving changes. If the changes made to the document have not been saved, this window will display an asterisk (*);
· digital signature window. It can be used to add or remove digital signature to the document (right-click);
LibreOffice is a package office programs distributed free of charge and open source. Since the first prototypes of computers were ordinary typewriters and abacus, their main functionality is still focused on typing and performing various calculations.
LibreOfiice is actively used in government agencies in some countries (including the military). This office suite includes text, spreadsheet, vector editor s, tools for creating presentations and working with databases. In terms of functionality, it is not inferior to its commercial counterpart - MS Office, but it consumes significantly less computer resources.
Also, LibreOffice packages are regularly updated, so all the “new items” will become available sooner or later anyway.
The first versions of LibreOffice appeared in the 2010s and were originally intended for operating Linux systems. However, versions for Windows with Mac OS soon appeared. Today, this office suite comes bundled with most popular Linux distributions.
The program built into this package and responsible for working with text documents is called - LibreOffice Writer. By default, all documents created in this program will be in the ODT format. However, the editor can handle other popular text file formats without any problems, such as DOCX, TXT, etc. True, sometimes “non-native” formats can open a little crookedly, that is, markup, fonts, etc. can move out there, but this is quickly restored.
A notable feature of the program is the ability to immediately convert the created document into a PDF file. In Word, this requires the installation of a special plug-in and program.
The top toolbar contains all the main editing tools available. Sometimes this is not very convenient, since you can search for the right tool for a long time. In Word, for example, all tools are categorized and easier to find. With the help of additional plugins and add-ons, you can change the appearance of the top toolbar, add new elements, etc.
However, the LibreOffice Write toolbar has some advantages over Word. For example, it is easy to change styles from there, since you need to press just a few buttons, while in Word you have to go into the style settings.
The area for typing is no different. The user can also customize the side toolbar. By default, in some versions it is not there at all, or there are very few elements.
At the bottom there are elements for counting pages, words and characters in a document, buttons for switching the language and scale. There is nothing much to change there.
In general, LibreOffice Write has all the features that the average user needs. The only problem may arise with automatic check spelling, because early versions it is disabled by default and you have to enable it in the top toolbar yourself.
Here we are already talking about the analogue of Excel - Libre Office Calc. It also creates and works with documents in its own format - ODS, but at the same time it supports working with other common tabular formats, such as XHTML, XML, etc. It should be borne in mind that sometimes there may be minor failures in working with foreign formats, but this is mainly expressed in minor cosmetic defects.
The main part of the interface is occupied by tabular cells, which you can edit and change at your discretion. At the top is a toolbar similar to the one in Libre Office Write, although most of the tools are adapted for working with spreadsheets. Here you can create charts, perform various manipulations with cells, etc. From here, you can immediately output the document to PDF format, send it to print, etc. Plus, there are functions for sorting table values by many parameters, such as alphabetically, descending order, and so on.
In some versions, there is also a sidebar with a small number of tools available. In the lower part of the window, you can switch between sheets, change the scale, view formulas.
When you right-click on a cell, a context menu appears. Parts of it duplicates the controls located on the top panel.
Any spreadsheet editor must have the ability to work with formulas. There are no special differences from Excel here. The input process and formulas are the same.
The only drawback of Libre Office Calc is the difficulty with cell formatting, since everything necessary tools you need to look in special submenus.
Presentations in Libre Office are handled by Impress, which does not do its job as well as Microsoft PowerPoint. Functionality and interface latest version Impress is like a cross between PowerPoint 2003 and 2007. The main working file format is ODP. There is support for other formats, but only the formats of older versions of PowerPoint work correctly.
There is not much functionality and animation in this program, but it is quite enough for developing simple presentations. You can create animation, add music, various effects.
The main part of the interface is occupied by the work area with slides, and the other half by the area with slide settings. Basically, the side part of the interface is responsible for adding and processing effects and animations.
The top panel has several elements for quick insertion into a slide, plus tools for processing the document itself (button for saving, exporting, searching through the document, etc.).
The functionality can be expanded with plug-ins and add-ons, but their installation is much more difficult than in the same PowerPoint, and their number is extremely limited.
In standard package Microsoft office 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 to Paint. Their functionality is somewhat similar to each other, but the similarities end there. Libre Office Draw works with the ODG format.
Here you can work in multitasking mode, while in Paint it is very inconvenient to work with several files at the same time.
The Libre Office Draw interface is conditionally divided into two main toolbars and a panel from where you can manage the document and add various elements to the workspace. On the right is a window with document properties and a small toolbar (some versions don't have it).
In this program, it is convenient to draw up flowcharts and work with 3D objects, while this functionality is only being introduced in Paint.
The Libre Office package has special program for precise calculations using formulas - Math. This software works with ODF format files. In the program, you can use both formulas prepared in advance, and compose them using code. For the production of calculations, computer algebra based on the Mathematica system is used. This system is very often used in engineering, especially when you need to perform accurate calculations.
The program interface includes windows for entering code, displaying formulas and selecting operations in the central part. All formulas are divided into sections, which makes it easier to work with them. Work in the code editor is done using the MathML language. At the top is a panel with document controls (save, send to print, etc.).
Not in MS Office separate program for working with formulas, but simplified formula editors are built into Word and Excel. A separate professional editor of mathematical formulas will primarily be useful for engineers and mathematicians. Ordinary users could well bypass the built-in editors in Writer and / or Calc.
The functionality of this program can be expanded by additional plug-ins from the Internet.
This office suite has its own analogue of MS Access - Libre Office Base. The working format is ODB, but it is possible to support other formats, however, some of them may not be processed correctly.
The program has several modes for creating tables:
The program interface is divided into several main parts:
The database manager also supports MySQL and SQL. The process of creating some elements in this program may differ from that in MS Access. However, the interface of this program is much simpler than that of its counterpart from Microsoft.
Based on all of the above, we can note the advantages and disadvantages of the Libre Office office suite.
Of course, in some aspects, Libre Office is inferior to its competitor from Microsoft, but at the same time it has all the functionality necessary for work, is undemanding to hardware and is easier to learn.
Department of Education of the City of Moscow
State educational institution
Secondary vocational education
College of Entrepreneurship #15
"spreadsheet libreo ffice c alc.
Work in a spreadsheetlibreo office c alc »
by disciplines:"Informatics and ICT"
"Computer science"
"Informatics and ICT in professional activity"
for specialties: 080114"Economics and Accounting"
101401 "Tourism"
101101"Hotel service"
120714"Land and property relations"
230401 « Information Systems»
080110 "Economics and accounting"
080501 "Management"
080114"
Moscow, 2011
Methodical instructions contain instructions for practical work by disciplines: "Informatics and ICT", "Informatics", "Informatics and ICT in professional activity" for specialties: 080114 "Economics and Accounting", 101401 "Tourism", 101101 "Hotel service", 120714"Land and property relations", 230401"Information Systems", 080110 "Economics and Accounting", 080501 "Management", 080114"Land and property relations» . This manual contains instructions for practical work on the section "Technologies for creating and transforming information objects» (Informatics and ICT), «Applied software" (Computer science), « Information processes And Information society. Information processing technology” (Computer science and ICT in professional activities)studied inII, II, AndIsemesters, respectively.
© GOU SPO "College of Entrepreneurship No. 15"
libreoffice.org - free alternative package of office Microsoft applications office. LibreOffice is the new name of OpenOffice.org
One of the extremely positive qualities- possibility of work of all these applications with the corresponding documents of MS Office formats.
Compound libreoffice.org. Includes six program components:
text editor and web page editor Writer;
spreadsheet editor Calc;
tool for creating and demonstrating Impress presentations;
vector editor Draw;
database management system Base;
editor for creating and editing Math formulas.
All components are integrated into a common core and thus have good compatibility with each other. The functionality of all components provides all the necessary tools and allows you to solve the main tasks of the user. To store the results of the work, the ODF file format (ISO / IEC 26300:2006), based on XML and received the status of an international standard, is used.
Main peculiarities libreoffice.org. LibreOffice.org has a number of interesting features that are partially or completely absent in other office suites:
Cross-platform.
Currently, LibreOffice.org can be used on all popular platforms: Linux (on 32-bit and 64-bit systems), Windows (2000 and later), MacOS, FreeBSD, and Solaris.
Tools that make it easy to create, edit and manage documents:
Gallery for inserting images;
Navigator for moving around the document and searching;
Stylist for creating, editing and managing document formatting styles;
Data sources for importing data from databases or spreadsheets.
Support for MS Office formats.
You can easily open and save documents in MS Office 97-2003 formats. It also supports importing files in the Office OpenXML format (MS Office 2007).
Export to PDF.
Export to given format supported from all components (except Base). With a special extension, it is also possible to import PDF into LibreOffice.org Draw.
Extension support.
LibreOffice.org provides the ability to develop independent third-party extensions that provide additional functionality to the end user. Extensions are easy to install and remove.
The Java Environment (JRE) must be installed on the computer for LibreOffice.org to work.
Release year: 2011.
File size: 189 MB.
Activation|reg code: Does not require.
Interface Language: Russian + English.
Platform/OS: Win XP, Vista, 7.
The Calc module is a spreadsheet system. Spreadsheets are housed in a workbook, which in Calc is a file used to process and store data. Each book can consist of several sheets, so you can put a variety of information in one file and establish the necessary links between them.
The basis of the book is worksheet- space for storing data, divided into cells. In the usual sense, this is a table, the rows and columns of which make up the structure of the worksheet. The columns are named with Latin letters from A, B, C, etc., then by combinations of letters from AA to AMJ, and the lines are numbered from 1 to 65536, i.e. 108864 cells.
Most often, Calc users have to deal with workbook files of the .ods type and .ots templates.
Spreadsheet worksheet view
Operations with sheets of the workbook.
You can work with the sheets of the current book as with other Calc objects using
teams menu Edit, Insert, Format or context menu their labels.
Sheets of the book can be given your own names, using the context menu, or through commands Format-Sheet-Rename.
The pages of the book can delete By context command Delete when you click on the sheet tab.
Add sheets in the book can be through the command Insert-Sheet, either through context menu.
Highlight all sheets in the workbook allows the command Select all context menu, selecting sheet tabs while pressing the key allows you to select several in a row, while pressing - several randomly.
Sometimes you have to hide some columns and / or rows, sheets. For example, when printing, sometimes it is not necessary to display all the information contained in a table. Columns and rows that you do not want to print can be temporarily removed from the screen. They will not be visible and will not be printed (the printed document looks the same as it is displayed on the screen).
Hiding rows and columns does not affect the values calculated in formulas.
To hide columns/rows:
1. Select the row(s) or column(s).
2. Right-click on the column header or row number you want to hide.
3. In the context menu that appears, select the command Hide.
A column or row is hidden if the column heading or row number is not visible on the screen.
To hide sheet, highlight the desired sheet, select the command Format-Sheet-Hide.
Hidden rows and columns can easily again display on the screen if you want to change the data they contain.
1. Select the columns surrounding a hidden column or the rows surrounding a hidden row.
2. Right-click on one of the highlighted columns or rows. In the context menu that appears, select the command Show.
Similarly, one can display sheets books using the command: Format-List-Show.
If in the course of work the user has to create documents of the same type, then a template should be used to speed up the work. When you create a new workbook based on a template, it will immediately be updated according to the information contained in the template. To create template:
1. Create a workbook containing worksheets, standard text (such as page titles, row and column labels), formulas, macros, styles, and other formatting that should be in workbooks based on the template.
2. Choose a team File-Templates-Save.
3. Specify a name and folder where you want to save the template. To be able to use a template to create new books, it must be saved in the My Templates folder.
Another way to save a table as a template is to run the command File-Save as well as selecting in the Save dialog box File Type of Template (*.ots).
To use template to create a document:
1) Select the item from the main menu File-Create-Templates and Documents. The Templates and Documents dialog box will open.
2) In the left pane of the window, click on the Templates icon if it is not already selected. A list of folders will appear in the central block.
3) Double click on the folder containing the required template.
A list of all templates in this folder will appear in the central block.
4) Click on the template you want to use. You can view the template of your choice or view its properties. Click the Preview icon to view the template, click the Document Properties icon to view its properties. The template properties and template preview are displayed in the right block.
5) Click the button Open. A new document will be created based on the selected template, which you can then edit and save this new document as usual.
Calc restricts other users' rights to use the workbooks you've created by setting up password protection to open the file. To do this, select the command File-Save As in the dialog box that opens, click the Save with Password checkbox.
Password protected file, opens just like any other file. However, before the workbook is displayed, Calc will ask you to enter the password that has been assigned to the file. If you forget your password, you will not be able to open the book.
Calc provides several options for restricting access to data in your documents.
Can protect columns, rows, formulas on the sheet from viewing and from changing. It is recommended that you set the protection mode to only allow access to certain cells and ranges, and then protect the entire worksheet. It is important to note that cell protection will only be activated after sheet and document protection is enabled.
1. Select the cells and ranges you want to share. The data in these cells and ranges can be changed.
2. Choose a team Format-Cells... either in context menu Format Cell and in the dialog box that opens, click on the Cell Protection tab.
3. After clearing/checking the Protected and/or Hide formulas checkboxes, click the OK button.
Can restrict other users access to individual worksheets in a Calc workbook. However, they will still be able to open the workbook file and make changes to unprotected sheets.
1. Go to the worksheet you want to protect. Choose a team Service-Protect document-List.
2. Enter the password in the Protect Sheet dialog box (remember that uppercase and lowercase letters are different).
3. Re-enter the password in the Confirm password field and click the OK button.
4. To disable sheet protection, select the command Service-Protection document, click the Sheet...
Comment. Passwords should not be forgotten. If you have enabled sheet protection, write down the password and keep it in a safe place. Without a password, you yourself will not be able to open and edit the worksheet.
Table cells can contain text, numbers, dates, and formulas.
In the cell itself on the sheet, only a part of the characters will be displayed, and the remaining characters will be visible in the input field on the formula bar.
Entering text
In Calc text is any sequence consisting of digits, spaces, and non-numeric characters, for example, the following entries are interpreted as text: 10AA109, 127AXY, 12-976, 208 4675.
By default, text is aligned to the left of the cell.
To display all text spanning multiple lines in a cell, select the check box Move by word(or Move over syllables) on the Alignment tab of the Format Cells context menu.
Comment. To enter a number in a cell in an unformatted form (for example, starting with 0), you need to set the Text parameter via the Format Cells command on the Numbers tab in the Category group.
Entering numbers
Numbers are entered using the top row of the keyboard or the numeric keypad. A hyphen is used to enter a negative number. A comma is used as the decimal separator. If you enter 0 or + before a number, Calc will remove it. By default, numbers are aligned to the right of the cell.
In Calc, a number can only consist of the following characters: 0 1 2 3 4 5 6 7 8 9 + - () , / $ % . All other key combinations consisting of numbers and non-numeric characters are treated as text.
Entering dates and times of day
Date and time are entered using numbers (18.11.08) and text (18.Nov.08).
The separator is a period, colon, slash (/), or hyphen (-).
The external representation of a time or date on a worksheet depends on the number format assigned to the cell (Cell Format-Numbers).
Entering a formula
Formula in a spreadsheet Calc is a collection of values, references to other cells, functions and operators that allows you to get new values from existing ones.
The formula always starts with the = sign.
To enter a formula, select the cell where you want to enter the formula, type = (equal sign), and write the formula.
If you press the button Function or Function Wizard, an equal sign is automatically inserted into the cell.
Autofill marker view
With drag and drop autocomplete token cells, you can copy it to other cells in the same row or the same column.
If a cell contains a number, a date or a period of time that can be part of a series, then when copying, its value is incremented (an arithmetic or geometric progression, a list of dates is obtained).
For creating arithmetic progression you can enter the desired numbers in two adjacent cells, select the cells, and use the fill handle to extend the progression to the desired number of cells.
Also for assignment arithmetic progression enter the initial value of the progression series to be created in the first cell of the range, select the range of cells in which the arithmetic progression will be located, use the command Edit-Fill-Rows, activate item Arithmetic Growth and in the graph Increment
For creating geometric progression enter the initial value of the progression series to be created in the first cell of the range, select the range of cells in which the geometric progression will be located, use the command Edit-Fill-Rows, activate item geometric growth and in the graph Increment set the number by which the value in the previous cell will increase with each step.
Similarly, the sequence of days of the month, working days is set.
Team Tools-AutoCorrect Options-Replace is designed to automatically replace one set of character combinations with others during the input process.
Auto-completion of input information
When entering frequently repeated words, the Calc program suggests completion of the typed word. If the continuation of the word suits you, press the key and it will be automatically completed.
Auto input
Designed for 2000 cells or 200 lines. To set up automatic data entry, use the command Service-Cell Content-AutoInput. When entering the desired text in a cell, press, to view other options, use the key.
The selection of cells, rows, columns is used to enter, copy, move and delete data, place links to cells in formulas and dialog boxes.
To select cells, place the cursor in the desired position and select adjacent cells with the left mouse button.
To select a range of cells, place the cursor in the upper left corner of the range, while holding the key, position the cursor in the lower right corner of the range. The block of cells between these positions will be highlighted.
To select nonadjacent cells, start selecting the desired cells while pressing the key.
To select row/column, place the cursor on the row number/column name.
To select multiple adjacent rows/columns, place the cursor on the line number/column name of the beginning of the range, while holding down the key, move the cursor to the line number/column name of the end of the range.
To highlight nonadjacent rows/columns, start highlighting the desired rows/columns while pressing the key.
To select all cells in a sheet, apply the command Edit-Select All or key combination<Ctrl+A>.
To copy data Copy, then Insert Edit-Copy And Edit-Paste, or keyboard shortcuts<Ctrl+Insert> or<ctrl+c>(for copying) and<Shift+Insert> or<ctrl+v>
To move data from a cell/row/column, you need to select the required element and context menu select an item by clicking the right mouse button Cut, then Insert by moving the cursor and highlighting the desired insertion point. You can also use the menu commands Edit-Cut And Edit-Paste, or keyboard shortcuts<Shift+Delete> or(for cutting) and<Shift+Insert> or<ctrl+v>(for pasting), or the corresponding buttons on the toolbar.
Comment. Data that has been copied can be pasted to a new location on the sheet with certain options. To do this, when pasting the copied data, use the command Paste as. In the dialog box that opens, you can select the desired paste options. In the same window, you can set transposition cells, i.e. changing the arrangement of data in them from horizontal to vertical and vice versa. If you want to insert a cell range, row, or column with a cell shift, you can set the option Move cells according to the desired location.
To merge cells, rows, columns, you need to select the required number of objects, then select the tab Format - Merge Cells - Merge Cells
To split cells, rows, columns, you must select the already previously merged object, then select the tab Format - Merge Cells - Split Cells or through the corresponding button on the Formatting panel.
Change cell format
The cell is the fundamental building block of the entire Calc spreadsheet. Dialog window Cell Format is the key to all change appearance cells. To open this dialog box, first select the desired cell (or range of cells), and then do one of the following:
Choose a team Format-Cells() .
Right-click on the selected cells and select from the menu that appears Cell format.
Cell Format Window
On the presented tabs, you can set various options for displaying cells and data in them.
Numbers tab. Allows you to set the format for displaying numbers - the number of decimal places, displaying a number as a percentage, date, time, etc.
Numeric format- for the main display of numbers. In its settings, you can set the number of displayed decimal places, the use of a separator for groups of digits, and the way negative numbers are displayed.
Percent Format– to display a number with a percent sign.
Money format- to denote monetary values. In this case, a currency symbol is displayed next to the value. Default currency format determined by regional settings operating system.
Date format– to display the date as a number (according to type and language – location).
Time Format– to display the time as a number (according to type and language – location).
Scientific format– to display a number in exponential notation.
Fractional format– to display a number as a fraction according to the specified fraction type.
Boolean format– to use logic functions.
Text format- to display the data entered in the cell as text, while both text and numbers are displayed in the same way as they were entered.
Font tab. Allows you to change the font, size, and style of both the entire cell text and a few characters.
Font Effects tab. Allows you to set some effects for the font design.
Alignment tab. Allows you to set the type of alignment of the contents of the cell vertically and horizontally and the possibility of using wrapping, as well as set the angle of inclination of the text in the cell.
Framing tab. Allows you to apply a border to either side of a cell or range. You can also create and/or remove borders around cells using the Border button on the toolbar Formatting. Here you can also set the distance from the borders of the cell to the text inscribed in it - item Indentation from content.
Background tab. Allows you to change the background color and fill of the cell.
Protection tab. Allows you to block the ability to edit the cell and hide the formula.
Changing the format of rows, columns
Since rows and columns in Calc are a collection of cells, their basic design is set through the command Cell Format. Separately, you can change the parameters for the height and width of columns/rows.
In Calc, you can resize rows and columns by dragging the right border of the column header or the bottom border of the row header, or by using the command Format-Column(Row)-Width(Height).
How many rows can fit on a Calc sheet?
How can I hide a sheet, a column on a sheet?
How to create your book template?
How can you protect the data on a worksheet from being changed?
What is a cell style, how to create your own style?
What can conditional formatting be used for?
How can the column width be changed?
openoffice.org. Guide to Calc / Per. from English. – 2007.
OpenOffice.org: Theory and Practice / I. Khakhaev, V. Mashkov, G. Gubkina et al. - M.: ALT Linux; BINOMIAL. Knowledge Lab, 2008. - (ALT Linux Library).
OpenOffice.org for the professional: [transl. from English / team of authors; lit. text processing: A. E. Kharlamenkov]. - 2nd ed., Rev. and additional - M. : DMK Press, 2008. - 425 p.
Kultin , N. B. OpenOffice.org 3. 0 Calc / N. B. Kultin. - St. Petersburg. : BHV-Petersburg, 2009. - (The most necessary). - 178 p. 48 Educational edition
So, the LibreOffice installation package was obtained from the official site and successfully installed. Using the familiar "Start" button, run the program LibreOffice Writer. What can be done here?
First impression - everything is very similar to MS Word sample of 2003. A top dropdown menu that does not have a hard-wired "ribbon". The dynamic sections of this menu can be grabbed with the mouse and moved from one place on the screen to another. Ruler, scaling, status bar - everything is so simple and familiar that it even causes tenderness. And the first opinion that may appear is that LibreOffice Writer may be more powerful than Notepad, but it is clearly weaker than the generally recognized Word.
Rice. 1 First impression of LibreOffice Writer
Launched LibreOffice Writer by default creates a blank document on the screen. On this blank sheet, we will try to type some text, and then compare the features of the free and paid packages.
We see that the default settings are: Liberation Serif 12 pt. Without changing anything, we type the text:
Rice. 2. First text
Everything is simple and clear. However, in most text editors, typing is not difficult. Let's see what it can do with the typed text LibreOffice Writer.
Let's look at two menus: "Standard" And "Formatting". They are active by default and are located at the top of the screen when you first start the program.
Rice. 3. Menu "Standard" and "Formatting"
If these menus are not in place (unlikely, but possible), you should run the command View → Toolbar. And check the boxes for Standard and Formatting.
Rice. 4. Turn on the necessary menus
Having studied the menu with a cursory glance, we find familiar buttons in the "Standard" menu:
And no less familiar tools for working with text in the Formatting menu:
Having used these buttons, we recognize that their action leads to the same results. The only difference is that the "Background Color" button changes the color of the ENTIRE paragraph in which this moment the cursor was.
Rice. 5. Formatted text
If you work a little more with the Formatting menu, you can find all the fonts you need to work. True, most of them work only if they are present in the operating system (however, as for Word). But styles work great, and with a little work, you can bring the document to the following sample:
Rice. 6. Working with styles. Setting headers
In the same way, the "Save" and "Open" buttons work here, which record the finished text for long-term storage and open the previously saved file. The only thing worth dwelling on in a little more detail is that when saving a file, you can use several different formats. And the choice here is quite wide: from "native" ODF(default) to normal DOC And RTF(for Word). There are even formats TXT(Notepad) and HTML(browser).
Rice. 7. Save text using different formats
Just like it is in Word, the LibreOffice Writer program allows you to insert images into a text document. And in the same way, you can use several methods for this.
All methods are familiar, and we will not dwell on them in detail.
Rice. 8. Insert image into text
It is only worth mentioning that in LibreOffice Writer present full set tools for working with an image, which allows you to change the location of the image (foreground and background), change the text wrapping (see Figure 9), set various frames. And even bind to images hyperlinks.
Rice. 9 Menu for image formatting
On this, it would seem, we can finish. What else do a wide range of users need from a text editor, besides typing, formatting it (bold, italic, italic), the ability to work with images, and save, open and print a file? But the possibilities LibreOffice Writer much wider standard set operations that are necessary for a student or a secretary to create simple text files.
Having traveled through the menu items (for the time being without going into special details), you can find out that in LibreOffice Writer it is possible to create letters and faxes using the "Wizard of creation". You can connect internal and external data sources that store information both in the program itself and in external files. You can create tables of any complexity and use the simplest formulas for counting in them. Can create hyperlinks, which point to sections within the document or to external files that can be stored on local computer, and on Internet servers.
In a word, the user who chooses for his work LibreOffice Writer, in no way feel disadvantaged in the choice of tools for the realization of its goal.
MINISTRY OF EDUCATION AND SCIENCE OF THE RUSSIAN FEDERATION
vocational education
TOMSK STATE UNIVERSITY OF CONTROL SYSTEMS AND RADIO ELECTRONICS
DEPARTMENT OF AUTOMATED CONTROL SYSTEMS
Laboratory workshop for the course "Informatics and programming"
developer Ph.D., associate professor of the department of automated control systems
Sukhanov A.Ya.
Sukhanov A.Ya.
Informatics and programming: Teaching manual for laboratory work - 226 p.
The training manual contains a program and tasks for laboratory classes, as well as all the necessary forms of documents for completing tasks.
(c) Sukhanov A.Ya., 2010
1 Lab #1. LibreOffice................................................... ............................................... |
|
1.1.Launching LibreOffice Writer.................................................... ................................................. ............... |
|
1.2 Entering text................................................... ................................................. .................................... |
|
1.3 Formatting text............................................................... ................................................. ................ |
|
1.4 Saving a document.............................................. ................................................. ................. |
|
1.5.Using toolbars............................................................... ................................................ |
|
1.6.Adding new features to the toolbar............................................................... ......... |
|
1.7.Editing text............................................................... ................................................. ................ |
|
1.8.Page settings.............................................. ................................................. ................. |
|
1.9.Formation of paragraphs (Paragraphs) .............................................. ................................................. . |
|
1.10 Sections and breaks .................................................................. ................................................. ....... |
|
1.12 Inserting a picture into text............................................... ................................................. .............. |
|
1.13.Formulas............................................... ................................................. ................................... |
|
1.14 Styles and formatting............................................... ................................................. ........... |
|
1.15..AutoCorrect and AutoCorrect Options............................................................... ......................................... |
|
1.16. Task ............................................... ................................................. ...................................... |
|
2 Study LibreOffice macros Writer................................................. ............................................... |
|
2.1.Objects and classes. ................................................. ................................................. ................. |
|
2.2. Variables and objects in Basic....................................................... ................................................. ..... |
|
2.3.Basic statements.................................................... ................................................. ......................... |
|
2.4 Procedures and functions. ................................................. ................................................. .......... |
|
2.5.Creating a macro in LibreOffice .............................................. ................................................. ... |
|
2.6 Tasks LibreOffice Writer macros.................................................................. ............................................... |
|
3 Lab #2 Exploring LibreOffice Calc Spreadsheets.................................................. ..... |
|
3.1.General information about the LibreOffice Calc spreadsheet............................................................... |
|
3.2 Structure of the spreadsheet............................................................... ................................................. |
|
3.3.Construction of diagrams ............................................... ................................................. ................. |
|
3.4. Task 1. ............................................... ................................................. ................................................ |
|
3.5. Task 2. ............................................... ................................................. ................................................ |
|
4 Lab #3 Using Calc as a Database, Exploring Macros.................................. |
|
4.1.Filtration of data............................................................... ................................................. ................... |
|
4.2. Pivot tables. ................................................. ................................................. ................. |
|
4.3.Final fields and grouping....................................................... ................................................. ..... |
|
4.4 Study Macro Calc Basic ................................................. ................................................. |
|
4.4.1 Calculation of bonus interest ............................................................... ............................... |
|
4.4.2 Calculation of bonuses. Function usage. ................................................. .. |
|
4.4.3 Calculation of formulas, implementation of computational functions. ...................................... |
|
5 Laboratory work No. 4 Studying the MS-DOS operating system and working in a command |
|
line ................................................. ................................................. ................................................. . |
|
5.2. What is an operating system? .............................................. ............................................... |
|
5.3.DOS operating system.................................................... ................................................. ........ |
|
5.4. What is meant by a file. ................................................. ................................................. |
|
5.5.TASK....................................................... ................................................. ................................... |
|
6 Laboratory work No. 5 Study of the operating room Windows systems and shells Far............. |
|
6.1. Appearance of Far ............................................... ................................................. ......................... |
|
6.2.Basic Far manager commands............................................... ................................................. .. |
|
6.3.Working with panels....................................................... ................................................. ......................... |
|
6.5.Viewing the contents of a disc.................................................... ................................................. ..... |
|
6.6.Sorting the list of files.................................................... ................................................. .......... |
|
6.7.Starting programs............................................................... ................................................. ......................... |
|
6.8.Creating folders............................................................... ................................................. ............................... |
|
6.9.Viewing the folder tree.................................................... ................................................. ................ |
|
6.10.Copying files............................................................... ................................................. ................. |
|
6.11.Deleting files............................................................... ................................................. ....................... |
|
6.12.Working with multiple files............................................................... ................................................. . |
|
6.13.Searching for files............................................... ................................................. ............................... |
|
6.14.Quick file search............................................................... ................................................. ................ |
|
6.15.Creating text files............................................................... ................................................. ...... |
|
6.16.Viewing text files............................................................... ................................................. ..... |
|
6.17.Editing text files............................................................... ............................................... |
|
6.18.Quick view mode............................................................... ................................................. ....... |
|
6.19.Searching for a folder............................................... ................................................. ............................... |
|
6.20.Using the filter............................................................... ................................................. ............ |
|
6.21.Changing file attributes............................................................... ................................................. ... |
|
6.22.User command menu............................................................... ................................................. ...... |
|
6.23.Determining Far Actions Depending on the File Name Extension.................................................. |
|
6.24.Working with the FTP client............................................................... ................................................. ............... |
|
7 Learning the Windows operating system. ................................................. ................................ |
|
8 Learning Forms and Visual Controls in OpenOffice or LibreOffice. ............... |
|
8.1.Exploring msgbox.................................................... ................................................. ......................... |
|
8.2.Creating a Dialog Box with an Input Line. ................................................. ................... |
|
8.3.Creating a dialog............................................................... ................................................. ......................... |
|
8.4. Implementation of a dialog with a button............................................... ................................................. ... |
|
8.5.Object model............................................................... ................................................. ......................... |
|
8.6 Learning Forms and Controls....................................................... .................................... |
|
8.7. Study of flags. ................................................. ................................................. ............... |
|
8.8 Study of Switches. ................................................. ................................................. . |
|
8.9.Text fields............................................................... ................................................. ......................... |
|
8.10.List ............................................................... ................................................. ................................................ |
|
8.11 Combo box............................................................... ................................................. ...................... |
|
8.12.Macro implementing the use of a text field and lists.................................................................. |
|
8.13.Counter element.............................................. ................................................. ................... |
|
8.14.Independent task .............................................................. ................................................. ...... |
|
9 Learning Java.................................................... ................................................. ................................. |
|
9.1.Three principles of OOP.................................................... ................................................. .................... |
|
9.2 Implementation of the program in Java....................................................... ................................................. .. |
|
9.3 Using NetBeans............................................................... ................................................. .......... |
|
9.4 What are interfaces............................................... ................................................. ................ |
|
9.5.Swing System............................................... ................................................. ...................... |
|
9.5.1 The Japplet class............................................... ................................................. ....................... |
|
9.5.2 Icons and labels............................................... ................................................. .................... |
|
9.5.3 Text fields.................................................... ................................................. ................. |
|
9.5.4 Buttons............................................... ................................................. ............................... |
|
9.5.5 The JButton class............................................... ................................................. ...................... |
|
9.5.6 Flags.................................................... ................................................. ............................... |
|
9.5.7 Switches............................................................... ................................................. ................. |
|
9.5.8 Combo boxes............................................................... ................................................. ................. |
|
9.5.9 Tabbed panes............................................................... ................................................. .......... |
|
9.5.10 Scrollbars............................................................... ................................................. ............ |
10 Applications - Help with the first and second labs, learning Writer and Calc. ................................................. ................................................. .................................171
10.1.LibreOffice............................................... ................................................. ............................... |
|
10.1.1 Starting LibreOffice Writer.................................................... ................................................. . |
|
10.1.2 Entering text............................................... ................................................. ....................... |
|
10.1.3 Editing text............................................... ................................................. ................... |
|
10.1.4 Formatting text............................................................... ................................................. ... |
|
10.1.5 Saving a document............................................................... ................................................. .... |
|
10.1.6 Using toolbars............................................................... ............................... |
|
10.1.7 Adding new features to the toolbar....................................................... |
|
10.1.8 Editing text............................................................... ................................................. .... |
|
10.1.9 Page Options............................................................... ................................................. ....... |
|
10.1.10 Formatting paragraphs (Paragraphs) .............................................. ................................................ |
|
10.1.11 Sections and Breaks .............................................................. ............................................... |
|
10.1.13. Inserting a picture into text............................................................... ............................................... |
|
10.1.14. Formulas ................................................. ................................................. ................... |
|
10.1.15 Styles and formatting.................................................... .................................................. |
|
10.1.16 Task............................................... ................................................. ...................... |
|
10.2.Learning LibreOffice Calc Spreadsheets.................................................................. ....................... |
|
10.2.1 General information about the LibreOffice Calc spreadsheet .............................................................. |
|
10.2.2 Structure of the spreadsheet............................................................... ............................................... |
|
10.2.3 Plotting .................................................................. ................................................. ........... |
|
10.2.4 Task 1. ............................................... ................................................. ............................... |
|
10.2.5 Task 2 ............................................... ................................................. ............................... |
LibreOffice Writer is a word processor designed to create, view and edit text documents, with the possibility of applying the simplest forms of algorithms in the form of macros. LibreOffice is a free, independent, open source office suite developed by The Document Foundation as an offshoot of the OpenOffice.org development, which includes the Writer word processor. Quite detailed information about the LibreOffice package can be found at http://help.libreoffice.org/Writer/Welcome_to_the_Writer_Help/en.
Any word processor is an application computer program designed for production, including the operations of typing, editing, formatting, printing, any type of printed information. Sometimes a word processor is called a text editor of the second kind.
Word processors in the 1970s - 1980s were called machines for typing and printing texts for individual and office use, consisting of a keyboard, a built-in computer for simple text editing, and an electric printing device. Later, the name "word processor" was used for computer programs intended for similar use. Word processors, unlike text editors, have more options for formatting text, embedding graphics, formulas, tables, and other objects into it. Therefore, they can be used not only for typing, but also for creating various kinds of documents, including official ones. Word processing programs can also be divided into simple word processors, powerful word processors, and publishing systems.
First of all, you need to launch the LibreOffice Writer program.
IN depending on the operating system used, for example, Linux or Windows, you need to act according to the following algorithm, in many respects it is the same for these operating systems:
IN Start menu (Windows) select Programs + LibreOffice and start WordProcessor LibreOffice Writer or Office LibreOffice, in graphical shell KDE or GNOME Linux can be selected from the Application Launcher menu and from the Applications submenu of Office and LibreOffice. When you select LibreOffice, a window for creating LibreOffice documents will open (Figure 1), among which are Writer documents, in the specified window, Writer documents are marked as Text Document. When you select WordProcessor LibreOffice Writer, a window with an empty document form will immediately open (Figure 2).
Figure 1 - LibreOffice
Figure 2 - LibreOffice Writer document window
The main component of LibreOffice Writer documents: letters, notes, posters, business papers - is usually text. Type some text into the new Writer document that opens when you start the program.
1 . Please enter some suggestion.
2. Press the Enter key.
To switch from the Russian keyboard layout to English, you need to press the Ctrl + Shift or Alt + Shift keys - depending on Windows settings or Linux. The keyboard indicator appears in the taskbar next to the clock. You can switch layout
also with the mouse. To do this, left-click on the indicator and select the desired layout from the menu that appears. To delete the character to the left of the cursor (the blinking vertical bar), press the Backspace key. To delete the character to the right of the cursor, press the Delete key.
Editing text After entering text for the first time, you will probably need to edit it. Let's
Let's try to add and then delete text in the document. The cursor shows where in the document the characters entered from the keyboard will appear. Click once with the left mouse button in the document to change the position of the cursor. The cursor can also be moved using the arrow keys.
By default, Writer runs in insert mode. This means that as you type, all text to the right of the cursor is shifted to make room for new text.
4. Double click on some word.
5. Press the Delete key.
Existing text will move back and fill the vacated space.
1. Left click on the page margin.
2. Click Symbols in the menu bar.
3. Select the Font (Character) tab.
4. In the Family list, select the font called Liberation Serif.
5. In the Style list, select Bold.
6. Scroll through the Size list using the scrollbar and select a value
7. In the Font Effects area, check the Shadow box.
8. Click the OK button.
9. Click anywhere in the document to deselect the text.
In addition, you can compact the font, this is done, for example, so that the text occupies a certain number of pages or a certain volume, if suddenly the received volume is more than required (Position and Spacing tab, select sparse or compacted (Scale Width)).
The same character options page can be selected from the Format menu.
You can also format paragraph and page settings separately, and they can also be selected from the Format menu. Page and paragraph options are discussed next.
Documents must be kept. The frequency with which you save a document corresponds to the amount of time you are willing to spend recovering data lost in the event of a computer failure.
2. Select the Save command. The Save As dialog box shown in Figure 3 will appear on the screen. Writer automatically suggests a name for the document (usually Untitled 1). Enter any other name
Figure 3 - Save window LibreOffice file(KDE)
3. In the File name (name) text box, enter a file name.
4. The text you enter will replace the text selected in the File name (name) field.
5. In addition, you can also use the backspace keys to delete text here.
and delete.
6. Expand the Save in list at the top of the dialog box.
7. Select any of your drive or folder.
Let's say you decide to add a couple more words to your document. How to open it again?
1. Select File from the menu bar.
2. Select the Open command.
3. Select a drive. Expand the list of Folders and Files.
4. Click on your folder icon.
5. Highlight your document icon
6. Click the Open button.
Toolbars provide access to some of the most commonly used menu commands. If you're more comfortable with a mouse than a keyboard, you'll be more comfortable working with toolbars.
Figure 4 - View of toolbars
Toolbar display Word contains many toolbars, which usually combine buttons related to some large topic, for example, Tables and borders (Tables and Borders), Drawing (Drawing), Databases (Database) and Webuzel (Web) .
They can be displayed and removed from it as needed.
1. Right-click on any toolbar or menu bar and select Customize Toolbar. A drop-down list of all panels will appear on the screen.
