https://accounts.google.com

Preview:

To use the preview, create yourself an account ( account) Google and log into it: https://accounts.google.com

Preview:

Assignment 6

1. Create a shortcut to launch Notepad on your desktop

Left-click on the "Start" button. In the menu that opens, select the menu item "All Programs" "Standard" "Notepad".

Click on the "Notepad" line with the right mouse button. In the context menu that opens, select the command "Send" "Desktop (create shortcut)" and press the left mouse button.

A shortcut to Notepad is created on your desktop.

Assignment 7

1. Format your USB stick

To format a USB flash drive, open the "Computer" section and select "USB-Flash Drive" from the list of devices.

Then, right-click on the flash drive icon and select the "Format" command in the context menu that appears.

The "Format" dialog box opens, allowing you to select the file system to store the data and assign the cluster size.

To format, you must press the "Start" button and your flash drive will be formatted. By default, FAT32 is selected as the file system.

Theory:

Large files on a USB flash drive?

Almost every owner of a "thick" flash drive encountered a problem when it was necessary to upload a movie to a friend on a flash drive ... Or, in general, write a file over 4GB. A strange problem turned out: the flash drive is mega-capacious, almost empty ... and Windowos gives "Not enough space for recording". All things are in the file systems that we just need to change.

The thing is that the standard FS of a flash drive, FAT32, cannot fit such large files into itself. Though file system is outdated, it is still installed on a USB flash drive. it gives greater data safety if it is incorrectly extracted (i.e. if you just sniff out system unit USB flash drive with NTFS file system - information on it may be lost).

There is also an alternative - ExFAT. It was mainly designed for flash drives. Allows you to write data a little faster, including more than 16GB and does not damage it when you extract it. But it is not supported by all computers - Windows XP requires an update to work with this file system.

Golden mean -NTFS.

1. Be sure to save important information from the flash drive to your computer.
2. Start the formatting process, choose from the list "File system" -\u003e "NTFS", click OK
3. The program will format the USB flash drive into a new FS (all files are deleted!)

Is there a way without deleting files? YES. But it is not recommended ...

1. Run Command Prompt: press Win + R, type "cmd", press Enter

Where G is the letter of the USB stick you want to convert

The flash drive will be formatted in "NTFS" format, and in the window command line additional information about your flash drive will be shown.

Thus, you can quickly format a USB flash drive using both the standard Windows formatting function and using the command line.

	Page

Preview:

Windows7 hands-on exercises

Assignment 8

1. Create a text file in Notepad

Left-click on the "Start" button. In the menu that opens, select the line "All programs" "Standard" "Notepad" and press the left mouse button Enter

The Notepad window opens.

Type on the sheet the phrase:This is my first document.

Save the created document in the "Drafts" folder

Move the mouse pointer over the "File" menu and press the left mouse button.

In the menu that opens, select the "Save" command and press the left mouse button. The "Save As" window will open.

Select the "Drafts" folder so that its name appears in the "Folder:" field. In the "File name:" field, enter a name for the file, for example: "Document 1".

Hover your mouse over the "Save" button and press the left mouse button (or just press the "Enter" key on your keyboard). The document has been saved.

Save the "Document 1" file to a flash drive

Insert into USB connector - USB-Flash Drive (USB-Flash drive).

Open the "Drafts" folder ("My Documents" "Documents" "Ivanov Ivan" "Drafts").

Hover over the Document 1 file icon and right-click.

In the context menu that opens, select the "Send" command "Removable drive G:". Press the left mouse button. The process of saving the file will start.

	Page

Preview:

Windows7 hands-on exercises

Assignment 9

Change your desktop picture

To change the desktop picture, press the right mouse button (the cursor should be on a clean desktop, and not on any tabs, shortcuts), call the context menu.

In the menu that opens, select Personalization.

In the "Personalization" window that opens, click the "Desktop background" tab and left-click on it.

In the "Wallpaper" window, select the required desktop image, click on it with the left mouse button. A sample pattern appears on the window screen.

You can install a picture from your collection by left-clicking on the "Browse" button. In the "Browse" window that opens, select a folder and desired file picture.

If you put a checkmark on several images, then the Change image every field will become active and from the drop-down list you can select the time interval after which the images will replace each other.

But, perhaps you want to make your picture or photo as the background of your desktop. Then click the Browse button A and find a folder with your photos. Just keep in mind that if the photo or picture does not fit the screen, then you need to click the Fill B button and select from the drop-down list what you need to do with the picture: stretch, center, etc.

It is better to make a photo in advance corresponding to the size of the screen of your monitor, otherwise it will be cropped or distorted.

	Page

Preview:

To use the preview, create yourself a Google account (account) and log into it:

The purpose laboratory work is a practical mastering of the Windows 7 operating system - its graphical shell, entry and exit, the structure of the desktop, basic actions and settings when working in the system.

Workshop:

1. Starting the system

Turn on the computer with Windows 7 installed. In less than a minute, the system boots up and is ready to go. The start menu with user names is displayed.

2. Login and user authentication

Select your username and click on the picture next to the name. Typically, the default name User is already entered into the system. If a password has been set for the user, enter it. After logging in, the desktop is rendered on the screen.

3. Desktop structure, my computer, control panel

The desktop consists of application icons (for example, Internet Explorer) and the taskbar - usually gray at the bottom. In the lower left corner there is a Start button, by clicking on which the user can choose an initial action - launching an application, creating a document, etc. The appearance and background of the desktop may differ with different settings. To change the background of the desktop, press the right mouse button on the background image and select Properties / Desktop in the context menu, and then select the desired background image in the drop-down list.

The main items of the start menu, visualized as a result of pressing the Start button:

1. Computer - information about a computer, its resources, devices, the name of the OS installed on it;

2. Documents - a standard folder for created documents (you can place documents in any other folder that is more convenient for you);

3. Control Panel - control panel;

4. Search programs and files - search and launch programs and open files;

5. (bottom) Shut down - exit your user session, shutdown the computer or restart the system.

Take a closer look at the control panel. It allows you to manage your computer's resources. For example, the Programs and Features item allows you to install new programs, uninstall or reinstall ("repair") already installed ones.

Select the Computer item in the start menu. In this case, information about the state of the computer is visualized in a special window.

The Computer window displays information about disks and some of the most important folders and offers a set of possible actions and a set of other information nodes to navigate to them (for example, Network).

To visualize the basic properties of a computer (system information), select in the start menu: Computer / (Right mouse button) / Properties. A window with system information appears.

You can see information about the OS, memory size, processor type and a number of links, for example, Device Manager, by clicking on which you will receive detailed information about the composition of the computer hardware and installed drivers... The interface is designed as a web page.

4. Working with files and folders

Working with files and folders (folders) - stores of links to files and other folders - is carried out using windows programs Explorer. Windows Explorer displays information about disks and main folders on your computer. If you double-click on the C: drive, then the contents of its root folder are displayed, which may contain other folders, etc. Navigation through folders is carried out using the arrows<- и -> .

Selecting a file or folder in a directory is done with one click of the mouse, entering a directory or opening a file - by double-clicking on the name of the directory or file. At the same time, for the file, the action of its opening is performed, depending on its type, - for text files - calling the corresponding editor (notepad, WordPad, MS Word, etc.), for .pdf files - calling Adobe Acrobat, for executable codes or batch files - launching the corresponding program or script, etc. Experiment on your computer with navigating through files and folders and opening document files.

5. Launching programs, managing tasks, programs and processes

There are several ways to run the program:

1. from Windows Explorer - double-click on the name of its file;

2. From the Start menu - select the Search programs and files item. This is one of the most convenient innovations in user interface Windows 7. When searching, as you type a program name, lists of programs and files with that name (name prefix) are displayed, which makes it very comfortable to select a program to run. By choosing a name notepad editor... get a window to launch it by clicking on the program name;

3. Starting the program from the command line (Command Prompt): select Start / Search Programs and Files / cmd. After starting the command processor, its window is rendered. In a command prompt window, type the name of the program (for example, notepad) and press Enter.

To manage your tasks, use the Windows Task Manager program, which you launch by simultaneously pressing the Ctrl / Alt / Del keys. As a result, the system will first ask you what exactly you want to do. Confirm the launch of the task manager. This renders the Windows Task Manager (Performance) window

The Applications tab contains information about the programs you invoked. If, for example, a program hangs, select it and click "End Task", as a result of which the program will be removed from the system. The Processes tab visualizes information about all processes running in the system. The Performance tab visualizes processor and memory usage information that you may find useful in the event of any unexpected delays in your computer. Experiment with the Windows Task Manager tabs.

6. Network settings

To connect a computer to a local TCP / IP network, you need to perform network settings for it - set an IP address and a network mask.

Make a physical connection to the network (check) by connecting a twisted pair network cable to the network connector (RJ45) that connects your computer to a network hub or switch. A physical connection is indicated by a green indicator light (check).

To connect to the network, use network Card (network adapter). Your task is to correctly set the IP address of the computer. To do this, select Start / Control Panel / Network and Sharing Center. Then select Change adapter settings. A window with a list of network connections will appear. In this window, select Local Area Connection. local network, then choose Properties. In the window select TCP / IPv4 and click Properties.

As a rule, "Obtain IP address automatically" is selected by default. Select "Use the following IP address" and type in your computer's IP address and netmask using the sample. Click OK. The system will require you to restart for the changes to take effect. Your computer is now ready to work on the local network.

7. Work on remote computers

When working in a local network, a very useful feature of Windows 7 is a remote login to another computer on your local network. In Windows, this system function is called Remote Desktop Connection (remote desktop). To connect, you need to know the name of the other computer, eg aphrodite.

Select Start / Remote Desktop Connection for remote login. As a result, the remote desktop call window is rendered

A list of computers with which remote communication has already been carried out is displayed. Select the computer name. The login window is visualized (Figure 1.1.7):

Figure 1.1.7. Remote login window to another computer

You have to click Connect, then enter your username (login) and password. After that, your computer screen is used as a terminal to visualize the actions you are performing on the remote computer. Now select Computer, display the computer name, etc. to make sure that you are now working remotely on another computer with the specified name. Select the computer for remote login at the direction of the system administrator of the local network of your classroom.

This feature is very convenient if remote computer has the resources you need (memory, fast processor, programs installed on it, etc.) that are not on your computer.

8. Logout

Select Start / Shut down to exit your user session. The final action selection menu is displayed.

2 academic hours

Windows 7 overview

Desktop structure, my computer, control panel

The appearance and background of the desktop may differ depending on the settings. In fig. 36.2 shows one of the custom desktop backgrounds. To change the background of the desktop, press the right mouse button on the background image and select Properties / Desktop in the context menu, and then select the desired background image in the drop-down list.

The main items of the start menu, visualized as a result of pressing the Start button:

• Computer - information about a computer, its resources, devices, name, OS installed on it
• Documents - a standard folder for created documents (you can place documents in any other folder that is more convenient for you)
• Control Panel - control panel (fig. 36.3)
• Search programs and files - search and launch programs and open files
• (at the bottom) Shut down - exit your user session, computer shutdown or restarting the system.

Take a closer look at the control panel (fig. 36.3). It allows you to manage your computer's resources. For example, the Programs and Features item allows you to install new programs, uninstall or reinstall ("repair") already installed ones.

Select the Computer item in the start menu, In this case, in a special window,

Installing Windows and Linux operating systems

1. Purpose of work

The aim of the work is to study the process of installing operating windows systems 7 and Linux openSUSE 12.2.

2. Objectives of work

- Consolidation, deepening and expansion of students' knowledge during installation operating systems Windows and Linux.

- Acquisition of skills and abilities to work with Windows and Linux installers.

- Developing the ability to think logically, to comprehend the results obtained when installing Windows and Linux.

3. Theoretical part

operating system(OS) is a complex of interconnected system programs, the purpose of which is to organize the user's interaction with the computer and the execution of all other programs.

The operating system acts as a link between the computer hardware, on the one hand, and the programs being executed, as well as the user, on the other hand.

The operating system is usually stored in the external memory of a computer -on disk... When you turn on the computer, it is read from disk memory and placed inRAM... This process is called booting the operating system.

3.1 Operating systemsWindows

Windowsis a family of operating systems manufactured by Microsoft Corporation. Windows OS is installed on the hard disk and other programs are already installed and operated "inside this program".

Windows OS is by far the most common among personal computer (PC) users. There are different versions of Windows that are widely used:

Windows Vista;

Windows 10 TP (Technical Preview).

There are also other windows versionsbut they are considered obsolete and hardly ever used.

Today, the most used OS is Windows 7.
3.1.1 Installing the operating systemWindows 7

To install Windows 7, you must have a disk with installation files (boot disk). After the disc is inserted into the PC drive, you must specify that the boot is performed from the drive, and not from the hard drive.

Once the files are uploaded, the " Installing Windows"(Fig. 2).

Figure: 2. Installing Windows 7

Further, following the instructions on the screen, you must select the language used for the installed OS, and also read the terms of the license agreement and accept them. Then the type of installation is selected: "Update" or " Complete installation". The update is used only if the installer was launched from a previous version of Windows.

After all the steps are completed, you need to configure hDD... In this case, configuration is carried out in the graphical interface after clicking the "Disk configuration" button, as shown in Figure 3.

Figure: 3. Disk setup

In order to create a new partition on the hard disk, you must click the "Create" button and specify the size of this partition (Fig. 4) and then click the "Apply" button.

Figure: 4. Creating a section

If you need to create several sections, then again press the "Create" button and specify the size of the section. The total size of all partitions must not exceed the total size hard disk.

After creating a partition where Windows 7 will be installed, a special system partition will also be created, which is necessary for the OS to work correctly (Fig. 5).

Figure: 5. Created sections

Also, if sections already exist, you can delete them or erase information from them (format) by using the corresponding "Delete" and "Format" buttons.

Figure: 6. Windows installation process

After completing the process of copying files and installing, the PC will reboot automatically and then it is necessary to boot from the hard disk. After booting, the Windows Setup window will appear, as shown in Figure 7.

Figure: 7. Configuring Windows 7

Next, you need to configure basic system parameters, such as username, user password, time zone, Windows activation. And after setup, Windows 7 will start.

Windows 7 requires at least 512MB random access memory and 20 GB hard disk space for installation.

3.2 Operating systemLinux openSUSE

openSUSE is a Linux distribution that is developed by Novell. This distribution is stable, easy to use, and is primarily suitable for novice users (Fig. 8).

Figure: 8. openSUSE icon

3.2.1 Key benefitsopenSUSE

The main advantages of the distributionLinux openSUSE:

- a wide range of applications, both for work and for entertainment;

- intuitive user interface;

- simple configuration of the system using YaST (control center, similar to the "Control Panel" inWindows);

- simple application management system;

- a fairly large set of device drivers;

- stability, security and developer support.

3.2.2 InstallationopenSUSE

To install the openSUSE OS, you must have a disc with the installation files (bootable disc). After the disc is inserted into the PC drive, you must specify that the boot is performed from the drive and not from the hard drive.

After the boot from the disk has been carried out, the openSUSE installer will appear on the screen (Fig. 9), where to install this distribution kit on the hard disk, you must press the "Installation" button and the process of preparing for installation will begin.

First, you need to set the language of the installer and the operating system to Russian, as shown in Figure 10. Then click the "Next" button.

Figure: 10. openSUSE installer

Next, the time zone is set. Then the hard disk is configured (Fig. 11).

Figure: 11. Proposed hard disk layout

Since the used file system has a specific structure, it is recommended to use the suggested hard disk settings. Click the "Next" button.

After selecting the markup, the user is configured, i.e. the username and password are set. In operating rooms linux systems there is a superuser ( system administrator) Is root, so it is recommended to create a new user with a password that matches the superuser password. Click the "Next" button.

All configured parameters of the installed openSUSE operating system appear on the screen. These parameters are checked and if everything is correct, then the "Next" button is pressed. Then a message appears for the user about the correctness of the parameters, and to start the installation process, press the "Install" button (Fig. 12).

Figure: 12. The openSUSE installation process

After the installation is complete, the operating system will reboot and then an automatic login will occur, since the user password was already entered during the installation phase.

OpenSUSE 12.2 requires a minimum of 256MB of RAM and 8GB of hard disk space for installation.

4. Task forlaboratory work

Install Windows 7 and Linux openSUSE 12.2 operating systems and familiarize yourself with the basic capabilities of their installers.

5. Methodologyfulfillment tasks

1. Install Windows 7

2. Start Windows 7

3. Shut down Windows 7

4. Install the OS openSUSE 12.2.

5. Start OS openSUSE 12.2

6. Shut down OS openSUSE 12.2

6. Requirements to the content and design of the report

The laboratory report should contain:

a) title page;

b) a description of the work progress and screenshots;

c) conclusion on the work performed;

d) answers to control questions.

Control questions

1. What is an operating system?

2. What is called loading the operating system?

3. What is the minimum amount of RAM required for windows work 7?

4. What are the benefits of openSUSE?

5. Is there a Russian interface in openSUSE OS?

6. What is the minimum amount of RAM required to run openSUSE?

LABORATORY WORK No. 3

OPERATING SYSTEMWINDOWS

PURPOSE OF THE WORK.

Become familiar with the basic concepts of Windows. Acquire skills in working with folders and files.

1. Study theoretical material.

2. Get familiar with the Desktop.

3. Open folder window My computer.Enlarge, reduce its size. Move the window across the screen.

4. Left-click on the menu item referenceenter the Windows help system. Read the content of the help system. Select (click) an option Getting to know the computer.Then select the option Veils and folders.Read the content of the items Working with filesand Search for files.Close help system. Close a window My computer.

5. Enter the main menu (button Start).Select an option Programs.Then select the option Standard.Enter text word editor Pad. Get familiar with the structure of the window.

6. Sketch a window in a notebook indicating functionality parts of the window. Read the contents of the menu items.

7. Type on the keyboard the phrase: "We are getting acquainted with windows windows". Save file with name Laboratory workin the personal folder of the STUDENT folder created in the previous work. Close the file and exit the editor.

8. In the personal folder, create a folder named Personal 2.Copy file Laboratory workunder a different name to the folder Personal 2.

9. Include in the report a description of the process of creating a file and folder, as well as the procedure for copying and moving folders and files, a variety of menus.

CONTROL QUESTIONS AND ANSWERS:

1. What's on the Desktop?

At the bottom of it is a strip called the Taskbar.

Various icons and shortcuts are placed on the Desktop field, through which communication with files is carried out.

2. What is the structure of the window?

Structure of all windows is the same.

Viewed from top to bottom, the window contains: title bar, menu bar, toolbar, window field, status bar, taskbar. In addition, horizontal and vertical stripes scrolling.

3. What's in the title bar?

In the title barin the left corner is the menu button. This is followed by the name of the window and the application in which this window is open. There are three squares in the right corner. Clicking on the left square will minimize the window to the size of a dash and place it on the taskbar with the appropriate caption. Clicking on the middle square resizes the window. Clicking on the right square will close the window.

4. Why do you need a menu? What types of menus do you know?

Menu- this is a list of commands that can be executed by selecting the appropriate items (options).

Main menurestores up when the button is clicked Start.The choice of a menu item is carried out by pointing with the mouse and then double-clicking. If a menu item ends with an arrow (triangle), then you do not need to click, you just need to indicate, and a submenu appears, in which, in turn, there may be submenus. Such menus are called cascading menus.

The menus located on the menu bar are outliersand can be cascading. The number and list of menus, as well as the composition of menu items, depends on the application in which the user works. Items Fileand referencepresent in any window. Menu items Filerefers to actions on files such as opening and saving a file. Menu items referencecall up help information specific to the running application.

Context menuis the menu that appears when you right-click the mouse. Its items refer to the object pointed to by the mouse cursor.

5. Purpose of the toolbar.

Toolbaris optional for any window. It consists of buttons, clicking on which replaces the call to the corresponding menu items. If you move the mouse cursor to any button and wait 2-3 seconds, an inscription will appear explaining the purpose of the button. The left arrow curved button cancels the last command up to a depth of 20 commands. The curved right arrow button restores the canceled command.

6. What is the taskbar for?

On the taskbarminimized windows (tasks), language indicator, sometimes clock are placed. The need to minimize windows may arise when many windows are open at the same time, some of which are not currently being used. A window placed on the taskbar can be re-expanded by clicking on the window name.

7. Create new folders and move them. Saving, copying and transferring files. Search for files.

To create a new folder, you need to open the window in which the folder is created. Right-clicking on an empty space will bring up a context menu. Is selected Create,then Folder.An image of a folder appears in the window asking for a name. The folder name is typed on the keyboard.

If the file is saved for the first time or when the file name is changed, then the menu item is selected Save as.A dialog box appears. In its upper left part there is a window with the name Folder, which contains the name open folder... If you need to save to another folder, then using the scroll bar you can find and open the required folder. At the bottom of the window there is a window into which a new file name is entered. Saving ends by pressing the key Save.If an existing file is saved, then select in the menu Fileoption Save,or the corresponding Toolbar button is clicked.

Sometimes it becomes necessary to nest one folder in another or move a file to another folder. If the folders are in different windows, you should open them and place them side by side. Then, with the left mouse button, take the object to be moved (folder or file) and put it on the image of the destination folder. If you hold down the CTRL key while transferring a file, the file will be copied.

During this lab, I became familiar with the basic concepts of Windows. I acquired skills in working with folders and files.

(see folder STUDENT - laboratory 3)

LABORATORY WORK No. 4

KNOWING THE APPSWINDOWS:PAINT,WORDPAD, CALCULATOR

PURPOSE OF THE WORK.

Acquire skills in working with Windows applications.

1. Read the theoretical material

2. Open the Paint application. Create a drawing suggested by your instructor. Save the drawing in a private folder.

3. Open Word Pad. Copy the drawing you created to open page... Resize it.

4. On the same page, describe the process of creating, saving and copying a drawing. Place this text in the report. Save the file to a private folder.

5. Open the Calculator app. Check out the help for this app. Perform the calculations suggested by your instructor. In the report, specify the task and the calculation result.

TEST QUESTIONS.

1. How do I draw straight and curved lines? Polygon? Rectangle? Square? How do I change the color of the picture and background? Writing text together with a drawing.

Drawing lines is carried out using the selected tool from the available toolbox.

In the toolbox, select the line type (straight, curve, ellipse, rectangle). Under the toolbox, select the type (thickness) of the line. By placing the pointer in the desired place on the canvas and pressing the left mouse button, we can draw the objects we need.

The color of the image is selected from the palette by clicking on the desired color.

To draw a horizontal or vertical straight line, or a 45-degree slanted line, hold down the SHIFT key while dragging the pointer.

To create a square or circle by selecting an ellipse or rectangle, hold down the SHIFT key and drag the pointer.

You can draw a freeform line by selecting only the tool and not selecting a line view.

To draw curved lines, select a wavy line as a view, draw a straight line, and then, by placing the pointer at the top of the intended arc, curve the straight line to the desired shape. Keep in mind that each curve must consist of one or two arcs.

To create a filled shape, select a fill type below the toolbox. Select the shape color with the left mouse button, and the fill color with the right mouse button. The type of filling depends on the selected type. If you want to fill an already created shape, then you need to select the fill color on the palette, click in the toolbox on the button Fill,and then inside the filled shape. The line color also changes.

When drawing polygons, double-click at the last vertex. To have the polygon only contain angles of 45 and 90 degrees, hold down the SHIFT key while dragging the pointer.

Entering and formatting text.

In the toolbox, select A. Create a frame for the text box by dragging the pointer diagonally to the desired size. On the menu View(or the context menu) open the formatting panel and select the name, size and style of the font. Click inside the text box, enter text.

2. How do I move a drawing from one application to another?

In all wINDOWS applications very widely used clipboard.

Clipboard - this is an area of \u200b\u200bmemory in which some fragment of the file is temporarily stored. The selected file fragment (the selection method depends on the application) is placed on the clipboard via the menu Edit \\ Copy,if you need to get a copy of the fragment, and - To cut,if this fragment does not need to be saved in the same place.

A fragment on the clipboard can be placed in the specified location of the same or another file (even another application) by choosing from the menu Editcommands Paste.

Instead of a menu Editthe context menu or the corresponding toolbar buttons can be used.

A fragment of a file is stored on the clipboard until another fragment is sent to it, so the same fragment can be inserted multiple times.

IN graphic editor PAINT To select an area at the top of the toolbox, select a rectangle or an asterisk, depending on whether the area is to be copied rectangular or otherwise. Select the copied area with the pointer. On the menu Editselect team Copy... The selection can be moved (or copied) via the clipboard. Moving can be done by dragging the inner point of the fragment.

3. In what order were the calculations performed on the calculator? Is this sequence optimal?

application Calculatoris intended for performing arithmetic operations with real numbers.

There are two types of calculators: arithmetic (without using functions) and engineering (using functions). The transition from one view to another is carried out through the menu View.

When making calculations, keep in mind that the priority of multiplication and division is respected in the Engineering Calculator, but not in the Normal Calculator. So, for example, pressing the key sequence 2 + 3 * 4 \u003d in the Engineering Calculator will result in a result of 14, while in the Normal Calculator it will result in a result of 20.

Calculation results can be transferred to another application via the clipboard (menu Edit).

When performing calculations in my expression, the order of operations was as follows:

Result: 3308393

RESULTS OF PERFORMANCE OF THE LABORATORY WORK:

In the course of this lab, I gained skills in working with Windows applications.

(see folder STUDENT-laboratory 4)

LABORATORY WORK No. 5

EDITING AND FORMATTING

OF TEXT DOCUMENTS BY MEANS

PURPOSE OF THE WORK.

Get skills in typing, editing and formatting text using microsoft programs Word.

Create a text document with the following page parameters: paper size: 21x 29.7 cm, sheet orientation - portrait; page margins: top, bottom, left - 2 cm, right - 1 cm.

In the created document, type the proposed text. When typing, use a font of size 12. Highlight the headings in red bold italics of size 14. Words printed in Latin are underlined with a wavy line and highlighted in bold. Format the paragraphs of the typed text according to the sample. Save the created document under the name lab5.doc.

Note.In the proposed text, the end of one paragraph and the beginning of another paragraph are marked with a "¿" symbol.

Using different ways copy and move text fragments, copy and then transfer the first two lines of the first paragraph and place them at the end of the text.

TEST QUESTIONS.

1. What is a paragraph? What paragraph formatting options do you know? How can they be changed?

The main concept when entering text information is a paragraph, that is, a section of text enclosed between paragraph end markers that appear in the text when you press the ENTER key. A paragraph can be empty or contain one or more lines of text. In order to type a paragraph consisting of several lines, it is not at all necessary to press the ENTER key at the end of each line. The program will automatically move the cursor to the beginning of the normal line when it reaches the paragraph boundary. If at the same time a word was typed, then it will be completely shuffled to the next line.

The main paragraph formatting options are:

Paragraph indents (left and right indents are the distances from the corresponding paragraph borders to the left and right borders of the text area, the first line indent is the distance from its beginning to the left main paragraph border);

Line spacing - the distance between adjacent lines of a paragraph;

alignment. Determines the placement of each line of a paragraph between its left and right borders. There are four types of alignment: left-aligned (the text is pressed against the left border of the paragraph), right-aligned (text is pressed against the right border of the paragraph), centered (each line is placed at an equal distance from both borders) and width-wise (unlike others types of alignment allows you to get even both the right and left borders of the paragraph - by automatically inserting the required number of spaces between words). At the same time, the content of the paragraph is aligned in only one of the above ways.

You can set these parameters in the dialog box of the menu command Format| Paragraph. In order to format one paragraph of text, just place the cursor anywhere in it. Multiple paragraphs with the same parameters are formatted with their preliminary selection.

2. How can I change the font size and color in an already typed piece of text?

Word text editor allows you to apply to represent text characters a large number of scalable TrueType fonts. To change the font parameters in an already typed fragment of text, select it and use the command Format \\ Font.In its dialog box, you can change the following parameters:

Font type (e.g. Times New Roman, Arial, Courier, etc.); typeface (normal, italic, bold, bold italic); font size;

underline type;

font color;

apply any effects (strikethrough, top and bottom

indices, etc.).

If at the moment of changing the font parameters there is no selection in the text, they will be applied to the newly entered characters.

3... How do I create superscript or subscript?

Superscript or subscript can be created using the command Format \\ Font. In its dialog box, you can select the checkbox in the required formatting.

4. How are page parameters such as paper size and margins changed?

Page parameters are set in the command dialog File \\ Page Setup.

6. How can you copy or move a piece of text?

Adding text is done by placing the cursor at the beginning and typing the necessary characters from the keyboard. Deletion of unnecessary or erroneously entered characters is performed with the BACKSPACE and DELETE keys. In order to split one paragraph into two, you need to move the cursor to the end of one and the beginning of the other and press the ENTER key. Mergetwo paragraphs into one is done by placing the cursor at the beginning of the lower paragraph and pressing the BACKSPACE key before combining them.

Moving and copying text fragments is performed using the commands of the menu item Edit.In order to perform any actions with a piece of text, you must first select it. The selection can be made either using the mouse (moving the pointer to the desired place, pressing and holding the left button, moving the mouse across the table to spread the selection area), or using the keyboard (pressing and holding the SHIFT key, select the desired fragment with the arrow keys). The selection will end when you release (depending on the method) the button or SHIFT key. The entire document is selected with the command Edit\Select all.To remove the selection, just click the mouse anywhere in the document or press one of the cursor keys.

Moving and copying a selection can be done in two ways.

1) Using the clipboard. Having selected the desired fragment, execute the command Edit \\ Cutto move it or Edit \\ Copyto copy. Then you need to move the text cursor to the future insertion point of the fragment and execute the command Edit \\ Paste.

2) Using the "drag and drop" method. To do this, place the mouse pointer on the selected fragment, press the left button and, without releasing it, drag the text cursor, which will take the form of a dashed line, to the insertion point. After making sure that the cursor is in the place where we want to move the piece of text, release the button. To copy using this method, press and hold the CTRL key before releasing the left button.

To delete a large piece of text, select it and press the DELETE key.

7. How do I undo the last editing or formatting of the text?

Cancellation of any last action to edit or format the document is done by the command Edit Undo.

If the user has decided to cancel the action, then he can use the command Edit Check In.

RESULTS OF PERFORMANCE OF THE LABORATORY WORK:

In the course of the laboratory work, I gained skills in typing, editing and formatting text using Microsoft Word.

(see folder STUDENT-lab 5)

LABORATORY WORK No. 6

CREATING AND EDITING TABLES WITH TOOLSMICROSOFTWORD

PURPOSE OF THE WORK.

Learn to create and edit tables of varying complexity in text microsoft documents Word.

Create a file lab6.doc, in which to place the results of the following tasks.

Using the menu item Tableand toolbar Tables and borderscreate a table with the following content.

List of department staff
		Science degree	Scientific title	Position	Total work experience
			Professor	Head chair
				Deputy head chair
				Senior Lecturer
				Assistant
				Secretary

Insert into the document the original table, consisting of 7 rows and 7 columns, and convert it to the form specified in the variant.

TEST QUESTIONS.

1. In what ways can you create a table in a text document?

You can create a table in a document in two ways.

1) Run command Table \\ Draw Table.In this case, the mouse pointer will take the form of a pencil, with which you need to draw the outline of the future table. After that, the command is executed Table \\ Split Cells,in the dialog box which indicates the number of rows and columns of the drawn table.

2) Having placed the cursor at the beginning of the future table, execute the command Table\ Add table.Then the number of rows and columns is specified in its dialog box.

2. How to select one or several cells, a column, a table as a whole?

You can select cells by dragging and holding the left mouse button.

A column can be selected by clicking the left mouse button over the column when the mouse pointer becomes a down arrow.

A table can be selected by clicking in the upper left corner of the table.

3. How can you combine several cells into one?

Select the cells to be merged. After that, the command is executed Table \\ Combine Cells.

4. How to change the line type of the cell border, its width and color?

You can change the appearance of the borders of selected cells, fill them with any color or pattern using the command Format \\ Borders and Fill.Tab Borderin its dialog box allows you to change the type of lines that form the borders of the cell, their color, thickness and, if necessary, hide them.

5. How is the cell filled with the selected color?

The filling type of the selected cells is set in the tab Fill.It can be either uniform or containing some kind of pattern (for example, hatching).

6. How can I change the direction of text in a cell?

Almost all editing and formatting capabilities applicable to plain text can be applied to text information located in table cells.

The direction of the text in a cell changes when the command is applied Format \\ Direction of the text.

RESULTS OF PERFORMANCE OF THE LABORATORY WORK:

In the course of the laboratory work, I will learn how to create and edit tables of varying complexity in Microsoft Word text documents.

(see folder STUDENT-laboratory 6)

LABORATORY WORK No. 7

WORK WITH GRAPHIC OBJECTS IN TEXT DOCUMENTSMICROSOFTWORD

PURPOSE OF THE WORK.

Acquisition of practical skills when creating illustrations in MS Word text documents.

Create a text file named lab7.doc to place the results of the following tasks.

https://pandia.ru/text/79/043/images/image003_7.jpg "align \u003d" left "width \u003d" 59 "height \u003d" 72 "\u003e Transport company" Faster, further, cheaper "
Ensure fast and timely delivery

Your cargoes on our vehicles to anywhere

countries for cash and bank transfer. Our drivers are professionals in their field.

Cooperation with us will be a guarantee of your success!

Using the toolbar Painting,draw your own version of the flowchart.

Using the Microsoft Equation formula editor, insert the formulas according to your option.

TEST QUESTIONS.

1. How to draw a regular square, circle?

To draw squares, circles and lines with inclination angles in multiples of 30, 45 and 60 °, hold down the Shift key.

2. How to move (copy) the selected object?

The most convenient way to move the selected object is to use the mouse. To do this, the pointer is placed on the object and, by pressing the left mouse button, move it to the desired distance, after which the button is released. For more accurate positioning of the object being moved, use the cursor keys while holding down the Ctrl key. If you hold down the Ctrl key while moving the object with the mouse , then it will be copied.In addition, to copy the selected element of the picture, you can use the clipboard.

3. How to select several drawn objects at the same time?

To select multiple objects, you can click each while holding down shift key, or by clicking the arrow button on the toolbar (Object selection),circle them with a rectangular frame.

4. How can you combine several drawn objects into one?

In order to make any transformations with the selected elements, use the button menu Actions.

Group, ungroup, regroup.Several selected objects can be combined into one using the command Group.In further transformations, it is considered as a single object, and not as a collection of its constituent figures. If necessary, it can again be broken down into its constituent elements with the command Ungroup.

5. How can you change the placement level of objects when they overlap?

The button menu is in use Actions.

Ordersets the placement level of an object when it overlaps other shapes or text.

6. What actions must be taken to insert an object into the text WordArt?

To insert curly text into the document, click on the button Add objectWordArton the toolbar Painting.Next, you need to select the type of inscription, type its text, set the font formatting options and, if necessary, apply certain features of the WordArt toolbar.

7. How the formula editor is used Microsoft Equation?

To insert a formula, select the command Insert \\ Object \\MicrosoftEquation,after which the object outline and the Microsoft Equation toolbar will appear on the screen. Next, the type of expression is selected and the corresponding fields in its template are filled. At the same time, using items Formatand Styleformula editor menu, you can set the required parameters for formatting mathematical symbols and select the desired style of their presentation. Using the menu item The sizesets the size of the selected or newly typed formula elements.

8. How can I change the nature of text flow over a graphic object?

Object format.It can be called by right-clicking on the object and selecting the corresponding command from the context menu. Depending on the type of graphic object, the name of this command may change (for example, Autoshape format, Picture format, Inscription format, etc.,). Object Format \\ Position

RESULTS OF PERFORMANCE OF THE LABORATORY WORK:

In the course of the laboratory work, I gained practical skills in creating illustrations in MS Word text documents.

(see folder STUDENT-laboratory 7)

LABORATORY WORK No. 8

CREATING AND EDITING ELECTRONIC

TABLES BY MEANSMICROSOFTEXCEL, PERFORMANCE OF CALCULATIONS USING FORMULAS

PURPOSE OF THE WORK.

Acquisition of practical skills for entering and editing data by means eXCEL programs and performing standard calculations.

Create a file named f8.xls with the following structure: the first sheet contains the original table, the second sheet contains the results of the necessary calculations for the original table.

Source table

list of released goods

	Name		unit of measurement	amount	The cost
	Oil paint
			1 pack. (50 kg)
	Painting brush
	Wallpaper glue
	Insulating tape
	Screwdriver
	Power socket

THE TASK:

Option

Calculate the total cost of goods, taking into account a 10% discount for those goods with more than 100 units.

On the third sheet of the f8.xls file, create a table of arguments and values \u200b\u200bof the specified function.

TEST QUESTIONS.

1. What cells in a spreadsheet are called dependent?

Spreadsheet cells are said to be dependent if they contain an absolute or relative reference.

2. How to calculate a given number of elements of an arithmetic progression with a known step?

1. Enter the first two numbers of the arithmetic progression taking into account the step.

2. Select these cells and drag along the column (row) to the required last element of the progression. - The cells will be filled with progression elements.

3. Select all filled cells and use the button on the toolbar Autosumor by command Insert \\ Function \\ Sum

3. What can be included in the formula? Give an example .

The formula can include all possible functions from the command Insert \\ Function

Arithmetic signs *, /, +, -, ^, (,).

For example: \u003d (Sheet1! $ C $ 13 * Sheet1! $ E $ 13 + 100) * 0.14

4. What formats do you know for representing numbers?

Numeric, monetary, financial, percentage, fractional, exponential.

5. Explain the mechanism of operation of the logical function IF .

Returns one value if the specified condition evaluates to TRUE, and another value if FALSE.

The IF function is used to test conditions for values \u200b\u200band formulas.

IF A(log_expression;value_if_true; value_if_false)

Log_expression is any value or expression that evaluates to TRUE or FALSE. For example, A10 \u003d 100 is boolean expression; if the value in cell A10 is 100, then the expression evaluates to TRUE. Otherwise, FALSE. This argument can be used in any

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

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

Notes

Up to 7 IF functions can be nested as value_if_true and value_if_false arguments to construct more complex checks. See the last of the examples below. When value_if_true and value_if_false are evaluated, the IF function returns the resulting value. If one of the arguments of the IF function is array, when executing the IF function, all elements of the array are calculated. Microsoft Excel offers additional functionsthat can be used to analyze data using conditions. For example, to calculate the number of occurrences of a text string or number in a range of cells, use the COUNTIF function. Use the SUMIF function to calculate the sum of values \u200b\u200bthat fall within an interval specified by a text string or numbers.

RESULTS OF PERFORMANCE OF THE LABORATORY WORK:

In the course of the laboratory work, I gained practical skills for entering and editing data using the EXCEL program and performing standard calculations.

(see folder STUDENT-laboratory 8)

LABORATORY WORK No. 9

PROCESSING AND ANALYSIS OF DATA BY MEANS OF THE PROGRAMMICROSOFTEXCEL

PURPOSE OF THE WORK.

Acquisition of practical skills in building diagrams, performing sorting and filtering using the EXCEL program.

Create a file named f9.xls with the following structure: the first sheet contains the original table (the original table corresponds to the original table of laboratory work No. 8), the second sheet - In the original table, filter the data so that only those rows that contain data about those goods, the quantity of which is not less than 150 units. Sort the list in descending order of the number of products.

On the third sheet of the f9.xls file, build a diagram with the specified parameters, corresponding to the values \u200b\u200bof the function calculated in laboratory work No. 8.

A flat pie chart of the first seven values \u200b\u200bof a function, showing the fraction of each value.

TEST QUESTIONS.

1. How do I sort a single column of text data?

Data \\ Sort ... \\ Sort within the selected range.

2. How to sort by one of the columns taking into account the entire table?

Select a column and run the command Data \\ Sorting ... \\ Automatically expand the selected range.

3. What charting parameters do you know?

Chart type, data labels, legend, title, range, grid, axis labels.

4. How to select data that meets some two conditions using the "AutoFilter" mode?

1. Click on any cell in the data column and execute the command Data \\ Filter \\ AutoFilter

2. Under the appeared sign select the required filtering condition.

5. How to change the type of the constructed diagram?

Right-click on the diagram and select the command Chart type.

6. Give examples of tasks in which sorting data can significantly speed up their processing.

Sort the list of employees of the enterprise by year of life in descending order to determine the number of employees of pre-retirement age.

RESULTS OF PERFORMANCE OF THE LABORATORY WORK:

In the course of the laboratory work, I acquired practical skills in charting, performing sorting and filtering using the EXCEL program.

(see folder STUDENT-laboratory 9)

LABORATORY WORK No. 10

CREATING GRAPHIC OBJECTS WITH THE PACKAGECORELDRAW

PURPOSE OF THE WORK.

Acquisition of practical skills in performing standard operations with objects of vector computer graphics.

Draw a block diagram showing the vertical dimensions of the first three blocks and extension lines of the last three blocks (the content of the inscription is the block type, for example, "Input block", "Logic block").

Select the flowchart of the corresponding laboratory work No. 7 "Working with graphic objects in text documents Microsoft Word".

TEST QUESTIONS.

1. What types of presentation of graphic information do you know?

All computer graphics objects are divided into two classes; point and vector. Bitmap (raster) images consist of an array of pixels of the same size and shape, geometric shapes (usually squares and circles), which have their own color and are set at a certain point on the screen. A mosaic pattern is a prime example of an enlarged bitmap. Vector images consist of a collection of more complex and varied geometric objects described by mathematical formulas, such as, for example, circles, rectangles, ellipses, polygons, line segments, arcs of curves, etc.

2. How to construct a star-shaped heptagon?

The construction of polygons is performed using the tool Polygon (Polygon).The parameters for constructing a polygon (type, number of vertices, sharpness of corners) are set on a special panel, which can be called up by double-clicking on the tool button

Polygon (Polygon).

3. What class of objects does the rhombus belong to?

Class "Rectangles".

4. How do I resize an object?

Before making changes to the dimensions, the object must be selected, for which you need to select the tool Pick (Pointer)and click on the required point of the desired object and hold down the left mouse button to resize.

5. What kinds of lines do you know?

Connecting Lines, Painting, Pen, Polyline, 3 Point Curve, Free Hand, Bezier Tool, ½ to 24 point path.

RESULTS OF PERFORMANCE OF THE LABORATORY WORK:

In the course of my laboratory work, I gained practical skills in performing standard operations with vector computer graphics objects.

(see folder STUDENT-laboratory 10)