Mikheeva E.V. Workshop on information technology in professional activities

Workshop on information technology in professional activity. Mikheeva E.V.

15th ed. - M.: 2015. - 256 p.

The textbook can be used to study general professional disciplines of technical specialties in accordance with the Federal State Educational Standards of secondary vocational education vocational education. The textbook is intended for acquiring practical skills in working with the most commonly used application programs in professional activities. Contains tasks for the main sections study guide"Information technologies in professional activity" by the same author, published by the Publishing Center "Academy". These tasks are provided with detailed instructions for execution and clarifying screen views of the corresponding program for clarity. To consolidate and test the acquired skills, the workshop contains additional tasks. The maximum effect is given by the parallel use of the manual and the workshop. For students of institutions of secondary vocational education.

Format: pdf(2015, 256s.)

The size: 16 MB

Watch, download:drive.google

Format: pdf(2014, 256s.)

The size: 47 MB

Watch, download:drive.google

TABLE OF CONTENTS
Preface 3
Section 1 MS WORD-2000 TEXT EDITOR
Practical work 1 4
Topic: Creating business documents in MS Word
Practical work 2 12
Topic: Formatting text documents containing tables
Practical work 3 15
Topic: Creation of text documents based on templates. Create templates and forms
Practical work 4 18
Topic: Creating complex documents in a text editor
Practical work 5 27
Topic: Formatting formulas in MS Equation Editor
Practical work 6 33
Topic: Organizational charts in MS Word document
Practical work 7 36
Subject: Complex use features of MS Word for creating documents
Section 2 MS EXCEL-2000 SPEECH PROCESSOR
Practical work 8 43
Topic: Organization of calculations in spreadsheet MS Excel
Practical work 9 52
Theme: Creation e-book. Relative and absolute addressing in MS Excel
Practical work 10 57
Subject: Linked tables. Calculation of subtotals in MS Excel tables
Practical work 11, 63
Subject: Parameter selection. Backcounting organization
Practical work 12 69
Topic: Optimization problems (search for a solution)
Practical work 13 77
Topic: Links between files and data consolidation in MS Excel
Practical work 14 83
Topic: Economic calculations in MS Excel
Practical work 15 91
Topic: Comprehensive use of Microsoft Office applications to create documents
Section 3 DATABASE MANAGEMENT SYSTEM MS ACCESS-2000
Practical work 16 98
Topic: Creating database tables using the designer and the table wizard in MS Access DBMS
Practical work 17 104
Topic: Editing and modifying database tables in MS Access DBMS
Practical work 18 113
Topic: Creating custom forms for data entry in MS Access DBMS
Practical work 19 120
Topic: Consolidation of acquired skills in creating tables and forms in MS Access DBMS
Practical work 20 121
Topic: Working with data using queries in MS Access DBMS
Practical work 21 129
Topic: Creating reports in MS Access DBMS
Practical work 22 135
Topic: Creating subforms in MS Acces DBMS
Practical work 23 142
Topic: Creating a database and working with data in MS Access DBMS
Section 4 REFERENCE AND LEGAL SYSTEM "CONSULTANT PLUS"
Practical work 24 145
Topic: Organization of the search for regulatory documents by the details of the document in the SPS "Consultant Plus"
Practical work 25 151
Topic: Organization of full-text search. Working with a list in the ATP "Consultant Plus"
Practical work 26 159
Topic: Working with the list and text of found documents. Reference Information. Working with folders in ATP "Consultant Plus"
Practical work 27 170
Topic: Working with forms. Organization of search in several infobases
Practical work 28 179
Topic: Searching for documents, working with the list and text of found documents in Consultant Plus SPS
Section 5 ACCOUNTING PROGRAM "1C: ACCOUNTING * (VERSION 7.5 / 7.7)
Practical work 29 183
Topic: Organization of initial work in the accounting program "1C: Accounting"
Practical work 30 193
Topic: Formation of analytical accounting and filling in directories in the accounting program "1C: Accounting"
Practical work 31 199
Topic: Entering initial account balances in the accounting program "1C: Accounting"
Practical work 32 205
Topic: Reflection of business transactions in the accounting program "1C: Accounting"
Practical work 33 214
Topic: Calculation of wages and deductions for UST in the accounting program "1C: Accounting"
Practical work 34 220
Topic: Cash and banking operations in the accounting program "1C: Accounting"
Practical work 35 224
Topic: Formation of financial results, reports and obtaining the final balance in the accounting program "1C: Accounting"
Section b ORGANIZATION OF WORK IN THE GLOBAL INTERNET NETWORK
Practical work 36 232
Subject: Email. mail program MS Outlook Express
Practical work 37 237
Topic: Configuring MS Internet Explorer
Practical work 38 245
Topic: Searching for information on the global network
References 251

as a teaching aid for students of institutions

secondary vocational education

UDC 004(075.32)

BBC 32.81ya723

M695
Reviewers:

deputy director of the Moscow College of Urban Planning and Entrepreneurship for informatization of the educational process,

Head of the Regional Computer Center, Member of the Expert Council on Informatization Issues

Gosstroy of Russia, Ph.D. tech. Sciences L. E. Timashova;

head department "Informatization of banking activity"

Moscow Banking Institute, Ph.D. tech. Sciences A. N. Gerasimov
Mikheeva E. V.

M695 Workshop on Informatics: Proc. manual for environments, prof. education / Elena Viktorovna Mikheeva. - M.: Publishing Center "Academy", 2004. - 192 p. ISBN 5-7695-1510-4
The workshop is designed to acquire practical skills in working on a personal computer in a Windows environment and basic office programs MS Office - text editor MS Word; spreadsheet editor MS Excel; MS Access database management systems. Contains tasks provided with detailed instructions for execution and drawings for clarity.

For students of institutions of secondary vocational education. It may be useful to those who wish to learn how to work with applied programs in a qualified manner.
UDC 004(075.32)

BBK32.81ya723

FOREWORD

This book is a collection of training and control practical tasks for working with information on a personal computer (PC) and using Microsoft Office applications such as MS Word, MS Excel, MS Access, MS Power Point, MS Internet Explorer.

The workshop contains practical tasks on the main sections of the discipline "Computer Science". Tasks are provided with detailed instructions for execution and drawings for clarity. To consolidate and test the acquired skills, additional tasks are included in it.

The workshop can be used both for conducting practical classes (basic and optional), and for individual training in the basic methods of working with computer software products.

The author, a professional teacher with extensive practical experience in working with information technology, tried to create a system of practical tasks aimed at acquiring stable initial skills of practical work in a Windows environment with software products, and selected a set of tasks that become more difficult as skills are acquired.

An important feature of the workshop is the presence of additional tasks for independent work at the end of each practice and at the end of each section.

Having studied theoretical material and having completed the practical tasks of the proposed workshop, the user will have stable initial skills in working in the Windows environment.

Section 1 WINDOWS BASICS

Practical work 1

Topic: ORGANIZATION OF WORK ON A PC. WORK WITH PC KEYBOARD

The purpose of the lesson. Learning the techniques of the initial organization of work on a PC, turning on / off the PC, learning how to work with the keyboard PC.

Task 1.1. Turning on the PC. Getting Started on PC.
Operating procedure
1. Turn on the PC in the network, press the power button on the monitor, press the Power button on the system unit.

When turned on, the indicators should light up, the monitor will make the same sound as when you turn on the TV, and the power supply fan in the system unit will make noise.

2. Wait for the operating system to load (approximately 60 seconds).

launch operating system occurs automatically after turning on the PC with the Power button on the system unit. First, the computer checks the functionality of its main devices, then you may need to enter a user password or network password if the PC is connected to a network.

After loading the Windows environment, the so-called Desktop(Desktop), at the bottom of which, when standard installation situated Task bar. There is a button on the left side of the taskbar. Start(Start)

3. Study the composition main menu Windows. Click on the button Start, this will open Main menu Windows. Learn the commands of the mandatory section Main menu windows- Run, Help, Find, Settings, Documents, Favorites, Programs. Please note that shutting down the computer is done with the command Completion of work.

Brief information. into the structure main menu There are two sections: mandatory and optional. The user can set the points of an arbitrary section at will. Sometimes

such items are generated automatically when installing applications (for example, Ms Office).

4. Learn the screen layout and basic icons Working field.

The main part of the screen is Working field. Icons are located on it - My computer, My documents,Internetexplorer, Basket, corresponding folders of the same name. There may also be folder shortcuts. The set of icons and labels is chosen by the user himself, so their number and list may be different.

5. Learn the basics of the job personal computer with a training program like "Instructor" (or any other that you have).
Task 1.2. Entering information using the keyboard.
Operating procedure
1. Carefully examine the keyboard of a personal computer.

2. To display the information entered from the keyboard, open the electronic notepad. To do this, follow these steps: click the button Start, select a command with the mouse Programs, Further standard, then - Notebook(Fig. 1.1).

3. Use the key to turn on the numeric keypad (the Num Lock indicator will light up) and dial the numbers from 1 to 9, after dialing the numbers, press the enter key. Note that the cursor has moved down one line.

4. Find the tab key on your keyboard. Dial a sequence of numbers separated by an interval by pressing the key: 123 456 789.

After typing the numbers, press the enter key.

5. Set the Russian keyboard layout. To do this, on the screen on the right side of the taskbar, find the EN / RU indicator and set the RU position corresponding to the Russian language.

6. Consider a basic text keyboard. Find the keys for the letters fiwa and OLDJ.

7. Take the initial position of the hands on the keyboard, when four fingers of the left hand (except for the thumb) are located on the keys of the fiwa, and four fingers right hand(except for the big one) are located on the OLJ keys. At the same time, round your fingers as if you are holding a large apple in each hand.

Place your thumbs over the intermediate key, which is the largest and is located under the letter keys. The space key makes spaces between words. If the word ends with a letter on the left, then the thumb of the right hand strikes the intermediate key, and vice versa.

Rice. 1.1. Opening notepad
It is necessary to press the keys one by one, the blow must be uniform and the same in strength for each key.

8. Check that the Caps Lock light is off. If necessary, turn it off with the key.

Brief reference. The fixed caps mode is activated by pressing the key, and the Caps Lock indicator lights up. Attention! Do not confuse with the key that turns on the numeric keypad.

9. Type fyva and OLJ, separating the words with a space.

10. At the end of each line of characters you type, press the enter key.

11. Press the key that fixes capital letters. The Caps Lock indicator should light up. Dial fiwa and OLDJ. Please note that the text is typed in capital letters. Remember the purpose of the key. Turn off the Caps Lock indicator.

12. Press in turn all the keys (from left to right) of the top row, on which the numbers from 0 to 9 and some symbols are located. Move to a new line by pressing .

Rice. 1.2. Character set in electronic notepad
13. Find the key on the keyboard that changes the dialing case. Press and, without releasing it, again press in turn all the keys of the top row. Note that other characters are printed than the previous set.

14. Set the keyboard layout to latin. To do this, on the right side of the taskbar, find the EN / RU indicator and set the EN position.

15. Press the key and, without releasing it, again press in turn all the keys of the top row. Please note that some characters are again different from the previous set (Fig. 1.2).

16. Place the cursor on the first line at the very beginning of the character set and press the A key several times (seven to eight times). You will see that the / symbols appear, because we have a Latin keyboard layout and the indicator is off.

17. Remove numbers to the right of typed letters fffff by pressing a key on the keyboard. Please note that the numbers located to the right of the cursor are deleted.

18. Press the key (left arrow above the key) to delete characters to the left of the cursor. Remove all characters fffff to the left of the cursor.

19. Go to the very end of the typed characters by simultaneously pressing the and keys (press the key and, without releasing it, press the key). Return to the beginning of the text by simultaneously pressing the keys and [Note]. Remember these keyboard shortcuts.

20. Find the cursor keys (in the form of arrows) on the keyboard and move the cursor to the right / left along the line and up / down the lines.

Rice. 1.3. warning window
21. Find in the upper right corner of the window Notebook button close(with a cross) and click on it with the mouse. The program will display a warning window (Fig. 1.3) with the text “The text in the Nameless file has been changed. Save changes? Click the button No.

22. Open your keyboard trainer and use it to practice entering information from a PC keyboard.

23. Turn off your computer. Left-click on the taskbar button Start, select from the main menu Completion of work. In the dialog that appears, check the command Turn off computer and click on the button OK.
Additional tasks
Practicing the skills of entering information using the keyboard.

For exercises, open Notebook. Before starting the exercises, study the rules of typing.

Printing rules. When typing on the keyboard, the hands move first of all, and with them the fingers, which should always be next to each other. When typing, the fingers almost do not diverge to the sides at all: the hands move up, down and to the sides, and with them the fingers, while the right finger hits the right key.

The starting position for the hands on the PC keyboard is shown in fig. 1.4:

four fingers of the left hand (except for the thumb) are located on the keys of the fiwa; four fingers of the right hand (except for the thumb) are located on the OLJ keys;

thumbs are located above the intermediate key (space);

all fingers, except for the thumbs, should be slightly rounded (as if you are holding a large apple in each hand);

Without fail, after hitting the keys, the fingers (hands) return to their original position.

Rice. 1.4. Home position for hands on a PC keyboard
Task 1.3. Keep your hands in the starting position of the middle row motionless and print the text of the exercise.

s s s s s s s s s s s s s s s s s s s s s s s s s s fffffffffffffffffffffff oooooooooooooooooooooooooooooo llllllllllllllllllllllllllllddddddddddddddddddddddddddd

zhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzhzh

AVA V AB AB AV A AB AVA V AB AVA ASA AVA ASA AVA AVA A WA ASA AVA AVA A WA f o l l l l l l l l l l l l l l l l l l l l l l l o ld old o ld o ld o ld o ld o ld o ld d alge olj olj olj olj olj olj awyf olj avyf olj avyf olj avyf olj avyf olj fyva avyf fyva avyf fyva avyf fyva avyf
Task 1.4. Type the text of the exercise, returning the hands to the starting position.
wa ol
Aaaoa Aaoao oaao iooa iooa АО АОАААО ООАОААА АО АОА АОАААО ООААО ООАААА АО ОАА АОАО Вовово вовово VOVOV Vova Vova Vova Vova Ovo Vova Vova LlllVV LLVLV VLLVV LVLVL VLVL VLVLV VLLV VLLA AALLL AALAL LAALL ALAL LLAL ALL ALLO LAVAL LVLLV Vova Oolol Lola Oololo Llaolo oval allo lola vova oval lava ox tin vova lola alla oval lavalov tin shaft oval allo wolf lava lola tin vova oval
fy j

yyyddd yydyd dyydd ydydy ddydy hell two water water yddyy dydyd ode ox widow conclusions arguments frets cornstalk fffddd ffdfd dffdd fdfdf ddfdf F daf fdffd fdfdf halyard foul Lafayette coattails zhzhzhddd zhzhdzhd zhzhzhfff zhzhfzhf zhfzhfzh ffzhfzh already bed messy zhfzhzhf fzhfzhf sting crap vozhzhzhv zhyf ski ozhyf fyzh lzhyf yyyzhzhzh yyzhyzh zhyyzhzh yzhyzhy zhzhyzhy lfzha squeezed yzhy yzhzhy zhyzhy lyzhafyffy yffyy Oscilloscopes Oscilloscopes-fyf yyfyf dyf coattails ddzhdzh zhddzhzh zhazhdzha dvvvazhdy dzhdzhd zhzhdzhd I waited Dodge fdfyzh ddy yffzh fzhyyd hell ode two dylyda squeezed arguments foul rein sting waited Dodge thirst F ski squeezed conclusions coattails bed widow waited for lafa twice

mi t

mmmtt mmtmt tmmtt mtmtm ttmtm here is soap for you mttmmt tmtmt armor photo fleet fata scrap tom atom there mat moto miser iiiitt iiitt tiitt ititti ttiti go typhus itiit titit vita wick lift chunks tahiti yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyingyyyyyyyyyyyyyyy umm umm dark umm umm mol movie yimim miimm im mil mim myth imi mmimi past phima press wring tht tm tm mother howl tmt tmt wash only survive grind itimim tmyi titm mtmmmmmmm pour grind prayer survive smoke fuse film darkness break
Task 1.5. Type the text of the exercise, returning the hands to the starting position.
en nr

pprrrr rrrr rrrrr rrrrp floor pop reef snout mug page rrrr rrrp pir steam time port trail truth break rapier eeerrr eeerr reerr errere erree repa vera rerer eeerrr relay drill wind mode shadow pprpr rpren pnper nerpp rnpr enrrp hello change plumage plywood jam rent loss of coins now try on the belt opposite in the brothel
uk gsh
kkgggg kkgkg kggkk kgkgk ggkg kg com whale guide goal kgkkg gkgkg treasure count when skittles claws bitter easy uuugg uugug guugg ugh ugh ug ug ug corner meadow ug ug ug ug coal duck stew n uga circle dgkt beep shshshuuu shshushu ushu ushshuu shushushu ushu shushoo shushush shush shush shush shush shush shush shush shush shush Shortchat Skkshksh Shchshkshkshkshkshkshksh SShchkshkshkshkshkshksh Shchshksh Shchkshksh Skyka Cshkchksh Shchkshksh Ship Shab Squash Crush Gun Skush Kukuk Kukack San Schgshg Shchgshg Gun Shchhgshg Guashk Hu Shishku GCSHSU GUGSHK CHASHUKH WORKS PRESS GROW whispering
chs bye
ssbbb ssbsbs bsssbb sbsbs bbsbs ball is white dunce sbssb bsbsb bass bob baobab bank dollar boxing boss quickly to charges chchchbbb chchbchb bchchbb bchbchb bbchbch forelock barrel chbchchb chbchbchb cup chelobrek to protect the butterfly yuyuyuchchch yuyuchyuch yuchchyuyu chyuchyuch chchyuchyu smell south yuchyuyuch syusyukane chandelier chchschs Sochi chsschch chchssch hour counter bbbyub buyubb bust bureau buubub yuubub love skirt chbbchbb bsyusch yuchyyus busch yuchbs syuchb special fold log house muesli burn brochure load parachute budget lawyer handfuls hit cabin boy in the jaw love jury yule
Task 1.6. Type the text of the exercise, returning the hands to the starting position.
yts schz

tststsschschsch tstsschtsschts schtstsschsch tsschtsschts schschtsschts goal soup tongs tsschtstssch schtsschtssch circus price penny queen face Fritz looking shield pike cheek ivy thicket schupaluv yyyschschsch yyschysch schyyschsch yschyschy schschyschy th pus pike yschyysch schyschysch soup yoga howling barking chew devil generous overall zzzyyy zzyzy yzzyy zyzyz yyzyz heat slaughter zyyzzy yzyzy rear narrow call zaznayka infectious bunny with thorn tstsztsz ztstszz tsztszts zztszts Caesar difference tsztstsz ztsztsz censorship here yytsytsy ytstsyy Choi ytsytsy yytstsy cesium scanty schschzschz zschschzz slot times schzschzsch zzschzsch tooth food yschyschz schyzzy schyschzts schyschzsch schzyyz tsztsysch zyschschsch zyztssch yztstssch cave rubble Marzano scurrying forceps sorrel soup hares replacing fighters at lightning
I ehh

I eh eeehhh eeheh heehh ehehe eehhe eh echo ehma ehheeh heheh Khan temple laughter Shah prude Caliph this eftr this era is the era of hash yayayahhh yayahyah hyayahh yahyahya hhyahya poison ham yayahhyah hyahyah lizard box yacht plaque needles hatya find fault yayaya yaya yayaya yayaya yayaya explain yayaya declare hug sarcastic eee ee ee eee to recording lf went to the Congress yayaeyae eyayaee elegy aloe yaeyaeya eeyaeya emotion hhh hhh hh hh entrance detour entrance yahyaeyaheyahyaheyaehyaya eeyah yahhe ehya yaeeh predatory slaughter sparing hearing good pub Charter subcell boar cartilage anchors the show wants to grasp the immensity flaw dashing mistress
e

eeeee eeee eeee volume rise shooting ehehe hehee ehheh ferret ezese zezze tears dreams still more brush alkali yellow hedgehog green fir-tree stick capacious drawing score four-tiered funny prompter and type all that

Practical work 2

Subject: ORGANIZATION OF WORK IN WINDOWS ENVIRONMENT. CREATING AND DELETING SHORTCUTS

The purpose of the lesson. Studying the technology of organizing work in the Windows environment. Create shortcuts, work with basket.

Task 2.1. Operations with windows in the Windows environment.
Operating procedure

2. If your operating system (OS) is Windows-98, follow these steps to study the OS.

Launch the Windows 98 Program Introduction (Start/Programs/Accessories/Utilities/Welcome toWindows/Introduction toWindows-98) (Fig. 2.1).

Start the section "Basics of computer literacy" by pressing the number 1.

Explore the sections (Fig. 2.2):

Keyboard use;

Working with the mouse;

Studying the desktop;

Using the main menu;

Work with Windows system;

Rice. 2.1. Windows 98 Getting Started Program window

Rice. 2.2. Selecting sections of the program "Introduction to Windows-98"
getting help.

After completing the e-tutorial material, complete the Windows-98 Basics Tutorial.

3. If you have Windows-2000 installed, please refer to the "Getting Started with Windows-2000" program to study the features of the operating system. (Start/Programs/Accessories/Utilities/Getting Started/Getting StartedWindows-2000/ Textbook)(Fig. 2.3).

4. From the desktop, double-click on the shortcut My computer open two windows in sequence: My computer and Drive C:

Notice that there are two buttons on the taskbar corresponding to these windows.

Brief reference. The window the user is working in this moment time is called active. The active window is placed in the foreground on top of other windows. Any command refers to the active window, which is running in the foreground.

5. Examine the main elements of the window. Locate the following window elements on the screen:

Borders - frames that bound the window on four sides. By grabbing and dragging the border with the mouse, you can resize the window;

The title bar below the top border of the window. By grabbing the window title with the mouse, you can move the window;

The button for calling the system menu is located on the left in the title bar (the appearance of the button usually corresponds to the contents of the window). By clicking on it with the mouse, you can open a list of window management commands;

Rice. 2.3. Windows 2000 Getting Started window
window control buttons Minimize, Restore, Close(on the right in the title bar);

The menu bar below the title. The menu provides access to basic set commands;

Toolbar (buttons for basic operations). The toolbar is an optional window element that contains icons and buttons for quick access to the most commonly used commands. You can add a toolbar from the menu View team Toolbar;

Scrollbars that allow vertical and horizontal movement when the window borders do not allow you to see all the contents of the window.

Brief reference. When working with multiple windows, the easiest way to switch to another window is to click on the visible part of the window. If the windows are maximized to full screen, then the transition is carried out in one of the following ways: by clicking on the button with the name of the window in the taskbar or by pressing the and keys (a window with icons of running programs will open in the middle of the screen; without releasing the key, press the key).

6. Make a window My computer active and learn the process of minimizing/maximizing windows. Expand the window to full screen with the button Expand- the window will increase in size and occupy the entire desktop. At the same time, the button Expand turn into a button Reestablish with two overlapping squares. By clicking on the button Reestablish, we return the window to its previous form.

Brief reference. How to resize a window?

To change the window width, move the mouse pointer to the vertical side of the window. The pointer changes to a horizontal double-edged arrow. Drag the edge of the window sideways horizontally and the window shrinks.

To change the height of a window, move the mouse pointer over the top or bottom sides of the window, and the cursor will change into a vertical double-edged arrow. Drag the edge of the window and the window will resize in height.

To simultaneously change the height and width of the window, move the cursor to the corner of the window - the mouse pointer will turn into a diagonal double-edged arrow. By dragging the window frame diagonally, you will reduce the size of the window.

7. By moving the windows (behind the window title) and changing the linear dimensions of the windows (vertical and horizontal), arrange the windows sequentially in five variants according to the model (Fig. 2.4).

Rice. 2.4. Options for arranging windows on the monitor screen
8. Arrange the windows on the screen. To organize, right-click on a free part of the taskbar and select the command from the context menu cascading windows, so that only the window titles are visible. To view the contents of all open windows select a command at the same time Windows from top to bottom or Windows from left to right.

9. Minimize all active windows with the command Minimize all windows context menu Taskbars.

10. Close the windows My computer and Drive C:(menu File, team close by simultaneously pressing the keys - or by the window button close).
Task 2.2. Create shortcuts.
Operating procedure
1. Create a desktop shortcut for the text Microsoft editor word. To create a shortcut, place the cursor on empty place desktop and press the right mouse button (right click). In the context menu that appears, select the command Create/Shortcut(Fig. 2.5).

2. In command line window Create a shortcut enter the file path to the launch file of the Microsoft Word program - winword.exe. You can use the button Review. Press the button to continue working. Further.

Brief reference. With a standard installation, the full file path to the MS Word startup file looks like: C:/Program Files/Ofiice/winword.exe.

3. The next window prompts you to select the name of the program as the name of the shortcut or replace it with another one. Leave the suggested name. Click the button Ready. A shortcut to MS Word appeared on the desktop.

Rice. 2.5. Create a shortcut
4. Change the appearance of the created label. By right-clicking on the label (cryptogram) of the Word program, open the window Label properties(Fig. 2.6).

Rice. 2.6. Window Label property
Change the cryptogram, to do this, go to the tab Label, click on the button Change icon. Choose the look of the shortcut icon you like and confirm your choice.

5. Remove the shortcut you created in basket, why drag the shortcut to the icon with the mouse Baskets.
Task 2.3. Technology of working with the "Basket" window.
Brief reference. Basket located on the desktop and intended for temporary storage deleted files. It allows you to recover files deleted by mistake. Files removed from diskettes shopping cart are not placed. After cleaning Baskets files are deleted, and before disk defragmentation, file recovery is performed only by special programs.
Operating procedure
1. Open the window Basket and see its contents. To do this, double-click on the icon baskets, located on the desktop. On the menu View issue a command Table(Fig. 2.7). Examine the properties of the remote label - type, size, date of deletion.

2. Restore the deleted desktop shortcut. To restore, select the name of the object to restore, select from the menu File command Reestablish.

Brief reference. If you need to restore several objects, then select their names by holding down the key.

3. Produce complete cleaning Baskets. Call Properties Baskets by right-clicking on its icon, and in the context menu that opens, select (left-click) the command Empty trash.

Removal from Baskets of all objects is produced by the command File/Empty Trash.

Rice. 2.7. Window Basket

Rice. 2.8. Capacity change Baskets
4. Resize Baskets. After right clicking on the icon Baskets select a team Properties. In the window that opens, set the slider to the appropriate division - 10% of the disk capacity (Fig. 2.8).
Additional task
Task 2.4. Create desktop shortcut for office softwareMS excel (C:/ program Files/ office/ excel. exe).

Check if the program you have chosen has a different cryptogram icon. Change the look of the label. Delete the label in shopping cart. Clear shopping cart in any way.

Practical work 3

Subject: WINDOWS USER INTERFACE SETUP. MY COMPUTER WINDOW

The purpose of the lesson. Formation of skills for setting up the operating system, user interface, operating parameters. Learning the technology of working with files and folders using a window My computer.
Task 3.1. Using the Windows Control Panel for settings.
Operating procedure
1. Turn on your computer. Wait for the Windows operating system to finish loading.

Brief reference. Opening methods Control panels:

Open the "My Computer" folder and double-click on the icon Control Panel;

Click the button Start and select commands from the main menu Settings/Control Panel.

2. Open Control Panel in any way (Fig. 3.1).

3. To display in the window Control Panel a brief description of the icons select from the menu View command Table. Examine the screen.

4. Arrange icons with captions in alphabetical order (View/Arrange icons by name).

Brief reference. Double click on the icon Date Time control panel opens a window for setting date and time parameters. The same can be achieved by double-clicking the time indicator icon on the taskbar.

Rice. 3.1. Control Panel
5. Set the current date and time of the computer's system clock at the time of the exercise, as well as your time zone (Fig. 3.2).

Brief reference. The date and time set on the computer's system clock is fixed when you finish working with a document and helps you find the latest version of the file.

6. In the "Keyboard" folder window (double-click on the icon Keyboard control panel) on the tab Speed set the repeat and blink speed of the cursor, as well as the interval before the start of the repeat and character (Fig. 3.3).

7. In the window Mouse(tab mouse buttons) set the configuration “for right-handed” (or “for left-handed” if you are left-handed) and set the optimal speed for double-clicking the mouse buttons (you can check it by clicking in the test area) (Fig. 3.4).

On the tab moving set the trail behind the mouse pointer. Notice how the trail trails behind the mouse pointer.

8. Customize the screen. Open a dialog box Properties: Screen double click on the icon Screen in the control panel or by right-clicking the mouse after placing the pointer on a free surface of the desktop. The display properties window contains several tabs: Background, Screensaver, Appearance, Options.

9. Background allows you to decorate the part of the desktop that is free from windows and icons with a background pattern or pictures (wallpaper)

Rice. 3.2. Setting the date, time and time zone

Rice. 3.3. Setting the repeat speed and cursor blinking

Rice. 3.4. Setting computer mouse properties

Rice. 3.5. Selecting a screen design
from the existing set. Switch Post pregnant In the center places the picture in the center of the screen, in position propagate repeats the pattern many times over the entire working field. Set the background you like.

10. Screen saver(screen saver) is selected from the screen saver list. The amount of time the computer is idle before the screen saver appears is set in minutes in the list Interval. Set the screen saver you like and set the interval to 5 minutes.

11. Tab Registration choose the type of design you like from the list standard schemes, created by designers (Fig. 3.5).
Task 3.2. Sets the style for viewing the contents of a folder.
Operating procedure

1. Open the window My computer. Set View Style Large Icons (View/Large Icons). Using the menu View, set view styles one by one: Small icons, List, Table. Pay attention to the difference between the styles of viewing the contents of a folder.

2. Sort the contents of the My Computer folder. To sort in a tabular view, click on the headings: Name, Size, Type, Changed. Please note that clicking the header again will sort the parameter in reverse order.

3. To sort in other styles (not tabular), run the command Arrange icons from the menu View and set the sort key (by name, file type, size, or date).
Task 3.3. Copying, moving and deleting files (folders) in the "My Computer" window.

Instead of the C: drive, it is advisable to use the D: logical drive for performing practical tasks (if it is available in the PC), therefore it is advisable to partition the hard drive into logical drives, followed by prohibition of access to the C: drive.

Brief reference. My computer provides universal program providing quick access to resources local computer, to a network drive, to various devices(printer, disks) and their settings. Icon activation My computer causes the opening of a window with icons corresponding to the local or network resources of the computer.
Operating procedure
1. Create a new folder on the C: drive. To do this, in the window My computer Select the C: folder icon and double-click to activate it. Choose a team File/New/Folder, name the folder (use your last name as the folder name) and press the key.

Note. If you want to create a new folder inside another folder, you must first select the folder with the mouse, and only then create a new one.

2. On drive C: find the largest file in size. To do this, in the C drive window: set the tabular view style (View/Table) and sort the files by size.

3. Copy the found largest file to your folder using the commands Edit/Copy and Edit/ Paste.

Brief reference. To copy a file, select it and in the menu Edit select a team Copy. To paste the copied file, place the cursor at the paste location (highlight your folder) and in the menu Edit select a team Insert.

4. Search drive C: for all files with the .exe extension. Open the search box to search (File/Find), set the search mask *.exe and the search area - drive C: (Fig. 3.6), then click the button To find.

Note. If you enter a keyword in the title of a document, then all documents that have this word in the title will be found.

5. Search drive C: for all files with the .doc extension. Open the search box to search (File/Find), set the search mask *.doc and search area - C: drive. Copy four of the found files to your folder.

Rice. 3.6. Search for *.exe files on drive C:
6. Create a shortcut to your folder on drive C:. To do this, place the cursor on the folder and use the command File/Create Shortcut.

7. Copy the shortcut of your folder to the desktop by dragging it from the C: drive window while holding down the key.

8. After checking the work done by the teacher, delete your folder and its shortcut. To delete a folder, file, shortcut, select the icon with the mouse and use the command File/Delete.

Brief reference. To delete a folder, you can use the right mouse button click on the system menu button of this folder.
Additional tasks
Task 3.4.

Open the Trash folder, find the deleted shortcut and folder and restore them.

Task 3.5.

On the tab moving window Mouse remove the cable behind the mouse pointer.

Task 3.6.

Restore standard settings screen.

Practical work 4

Topic: WORKING WITH FILES AND CATALOGS IN THE PROGRAM "EXPLORER"

The purpose of the lesson. Learning the technology of working with files and directories (folders) in the Explorer program.

Task 4.1. Basics of working in the program "Explorer". Operating procedure

1. Turn on your computer. Wait for the Windows operating system to finish loading.

2. To learn how to use the Explorer program in Windows-98, do the following: start the help system (Start/Help/tab Pointer/Enter search term "Explorer"). Explore sections: Browse, Copy, Rename, Move, Drag and drop a file or folder.

3. Search background information about the program "Explorer" in Windows-2000 is similar (Start/Help). The corresponding help window is shown in fig. 4.1.

4. Launch File Explorer:

in Windows-98 - Start/Programs/Explorer;

in Windows-2000 - Start/Programs/Accessories/Explorer.

Rice. 4.1. Help about File Explorer in Windows-98
Brief reference. You can launch the Explorer program by right-clicking on the button Start and selecting the command from the context menu Conductor.

5. Examine the appearance of the screen and the program menu (Fig. 4.2).

Window working field Conductor divided into vertical regions. The left side of the window displays the folder hierarchy of the computer (directory tree) - a complete "tree" of everything that is on the computer. You can view the entire "tree" from the roots to the top using the scroll bar (bar) located on the right side of the window.

Folders are attached to the central trunk in the form of "branches". If the folder has subfolders, then the node to which the "branch" is attached has a "+" sign. If you click on it with the mouse, the folder will expand into a new branch, and the “+” sign will change to a “-” sign. If you now click on "-", then the branch will collapse back into a folder.

When a folder is open in the left pane and a folder is always open, its contents will be shown in the right pane.

So, the left part of the window is designed for quick browsing of folders. If the folder is closed, and other folders are nested in it, there is a “+” sign next to it; if it is opened and the elements included in it are indicated, then there is a “-” sign next to it.

6. Expand all "branches" of the folder tree on the left side Explorer(by clicking on the "+"). Collapse all the "branches" of the tree (by clicking on the "-").

Rice. 4.2. Explorer window
7. Make the C: drive active by clicking on it with the mouse. In this case, the name of the drive C: will be marked, and its contents will appear in the right area.

8. Change the screen layout to include the status bar and toolbar (View/Status Bar, View/Table).

9. Click the "+" sign to the left of the Windows folder on the C: drive. The list item will open (expand) on the left side of the window conductor, the contents of the right part of the window will not change.

10. Open the Windows folder on the C: drive. To open a folder, click on its name in the left part of the window Conductor, the folder will be marked and its contents will appear in the right pane.

Brief reference. Double click on the folder name on the left side Explorer will make this folder current, and its contents will appear on the right side. At the same time, the level of detail of the folder structure will change on the left side.

11. Sort files by name, size and file type by clicking the appropriate buttons (Name, Size, Type, Changed) on the right side of the File Explorer window.
Task 4.2. Building a tree of directories (folders) in the program "Explorer".
Operating procedure
1. Create on drive C: a folder named "1-Test" and a folder tree in it as in fig. 4.3. Folder creation order:

Open the folder inside which you want to create a new folder;

Execute the command File/New/Folder;

Type in a name for the new folder.

Brief reference. When creating a folder using the Explorer program, you need to remember that:

Opening a folder in the directory tree (left side of the screen conductor) possible by simply clicking the left mouse button on the folder icon;

Opening a folder on the right side of the screen Explorer performed by double-clicking the mouse;

The folder name can be entered in any language (English, Russian), limited to 256 characters (excluding special characters).

Rice. 4.4. Job to create directory tree
2. Using the mouse (while holding down the key) copy the folders "Informatics" and "Law" to the folder "Abstracts".

Copy the "Philosophy" and "Economics" folders to the "Practical Studies" folder.

3. Build on drive C: in the folder "My Documents" a folder tree according to the task (Fig. 4.4).
Task 4.3. Copying, transferring and deleting files (folders) in the Explorer program.
Operating procedure
1. Copy files of a certain configuration with the extension specified in the task from the My Documents folder to the appropriate folder (for the task, see Fig. 4.4).

To copy a file or a group of files to the created folders, do the following:

On the left side Explorer open the My Documents folder from which files will be copied, while the contents of the My Documents folder will be displayed on the right side Explorer;

On the left side Explorer make the “Destination” folder visible for copying (expand the directory tree, move the folder tree with the scroll bar);

On the right side Explorer select files for copying;

When copying to the "Destination" folder, the icons of the copied files are dragged to the icon of the selected "Destination" folder while pressing the key. At the same time, a “+” icon will appear next to the copied file or folder;

Copying, deleting, pasting and moving are also possible using the buttons Copy and Insert control panel or menu commands Edit/Copy, Edit/Paste.

Brief reference. To select a group of consecutive files/folders, click on the first and then on the last files of the group, while holding down the key. A similar selection of a group of files can be made with the mouse using the “lasso” technique, covering the files with the mouse while holding down the left mouse button.

To select a group of separately located files/folders, click on the files while holding down the key.

2. Move the "Pictures" folder to the "Documents" folder.

3. Delete the Files folder using the right-click context menu.
Task 4.4. Rename files and folders in File Explorer.
Operating procedure
1. Rename any three files in the folder of the third level (full name), giving them names (NAME1, NAME2, NAME; using the right mouse button, call the file properties, select the command Rename, enter a new file name without changing the extension).

2. Rename the "Documents" folder, giving it the name "Texts and Pictures".

Additional task
Task 4.5. Build a tree of directories (folders) in the Explorer program.

The task is shown in fig. 4.5. Copy files of the specified type from the My Documents folder.

Rice. 4.5. Folder tree for task 4.5

Practical work 5

Topic: PLACING, SEARCHING AND SAVING INFORMATION. ANTI-VIRUS PROTECTION

The purpose of the lesson. Studying the technology of organizing work with information in the Windows environment. Search, saving information, checking for viral purity.

Task 5.1. Placement, search and copying of files/folders.
Operating procedure
1. Turn on your computer. Wait for the Windows operating system to finish loading.

2. Create on drive C: in the folder "My Documents" a folder of your group, in it - your folder (select your last name as a name).

3. In your folder, create three folders: Copy, Save, Virus Check.

4. Find on drive C: the boot file calc.exe corresponding to the Calculator program. Open a window to search To find from the Windows main menu (Start / Find / Files and folders), tab Name and location in the "Name" line, enter the file name - calc.exe and select the search zone - drive C:, including subfolders. button To find start a search.

5. Create a desktop shortcut for the Calculator program. To do this, after the file "calc.exe" is found, drag its icon from the window with the mouse To find on the working field while pressing the key.

6. Copy the calc.exe file to the "Copy" folder. To copy, place the cursor on the file and use the command Edit/Copy. Open the window My computer, then - drive C: "My Documents", the group folder and your folder, the "Copy" folder. Next, use the command Edit/Paste. The calc.exe file will be copied to the Copy folder.

7. Search on all local hard drives files starting with exp (Start / Find / Files and folders). On the tab Name and location in the "Name" line, enter exp * (Fig. 5.1). Select an area to search - local hard disks, including subfolders.

Brief reference. The asterisk (*) character in file and folder names replaces a group of arbitrary characters.

8. Sort files by name and select a group of files called explorer. To sort files and folders set the tabular view of the window Find (View/Table).

Rice. 5.1. Search for files starting with exp
9. Open File Explorer and copy the selected files to the Copy folder.

10. Find all files created in the last month (Start/Find/Files and Folders/Date tab)(Fig. 5.2). Record the number of files found in your workbook.

11. Find all files opened in the last five days (Start / Find / Files and folders / Date tab). Record the number of files found.

Rice. 5.2. Search for files and folders created in the last month
Task 5.2. Preparation of diskettes for work.
Operating procedure
To prepare a 3.5-inch (1.44 MB) diskette for use, you must format the diskette.

1. Insert a floppy disk into drive A:. Before formatting a floppy, make sure the floppy's write-protect window is closed.

2. Open the window My computer.

3. Right click on the icon Disc 3.5 (A:) and select command Format(Fig. 5.3).

Rice. 5.3. Specifying the Format Floppy Command

Rice. 5.4. Format diskette window
Note. Be very careful when specifying the formatting object, because the formatting process marks the disk and completely deletes information from it.

4. Set the floppy disk formatting parameters as in fig. 5.4 and click on the button To begin. After the formatting is completed, a report on the formatting results will be displayed on the screen. If defective areas are found on the diskette, i.e. If the total capacity of the disk does not match the available memory, it is best not to use a floppy disk.
Task 5.3. Saving files/folders. Operating procedure

1. Open an electronic notepad (Start / "Programs /" Accessories/Notebook).

2. Type in the notepad the text according to the model.
Sample text
The Explorer program is designed to manage the Windows file system. "Explorer" displays the contents of folders, allows you to open, move, copy, delete, rename folders and files, run programs, display a tree of directories (folders); the right side of the "Explorer" is an analogue of the "My Computer" folder window.

3. Save the typed text in the "Save" folder with the name "Sample Text" with the command File/Save(Fig. 5.5). In the "Folder" line, specify the "Save" folder, in the "File name" line, type the name "Sample Text", then click on the button Save. The file will be saved on drive C: in the "Save" folder.

Rice. 5.5. File save window
4. Once again save the text on the floppy disk with the command file/save as. In the "Folder" line, specify "Disk 3.5 (A:)", in the "File name" line, type the name "Sample Text", then click on the button Save. The file will be saved to diskette A:.
Task 5.4. Anti-virus check of information on a diskette.
Operating procedure
1. Insert the floppy disk with job file 5.3 into drive A:.

2. Run your existing anti-virus program, such as Kaspersky's AVP (AntiViral Toolkit Pro).

Brief reference. In Russia, anti-virus problems have been professionally dealt with for many years by two serious companies: Dialogue Science (programs: Aidstest, Doctor WEB, ADinf, Sheriff complex) and Kaspersky Lab (Kami, AVP series programs).

3. Set the scan area - floppy disks, scan mode - disinfection of infected files and click the button Start(Fig. 5.6).

4. Pay attention to the scanning progress indicator. If the anti-virus program found viruses and disinfected the files (which can be seen in the scan report), run the floppy scan process again and make sure that all viruses are removed.

Rice. 5.6. Checking a floppy disk with an antivirus program
Additional tasks
Task 5.5. Anti-virus check of information on the hard drive.

Run your anti-virus program and check for viruses on the local C: drive.
Task 5.6.

Find on drive C: files with any extension starting with the letter w (search mask - w*). Copy the smallest file found to a floppy disk (sort by size). Check the diskette containing the recorded file for viruses.

Brief reference. To copy a file to a floppy disk, you can use the command File/Send/Disk 3.5 (A:).

admitted

Ministry of Education of the Russian Federation

as a teaching aid for students of institutions

secondary vocational education

UDC 004(075.32)

BBC 32.81ya723

Reviewers:

deputy director of the Moscow College of Urban Planning and Entrepreneurship for informatization of the educational process,

Head of the Regional Computer Center, Member of the Expert Council on Informatization Issues

Gosstroy of Russia, Ph.D. tech. Sciences L. E. Timashova;

head department "Informatization of banking activity"

Moscow Banking Institute, Ph.D. tech. Sciences A. N. Gerasimov

Mikheeva E. V.

M695 Workshop on Informatics: Proc. manual for environments, prof. education / Elena Viktorovna Mikheeva. - M.: Publishing Center "Academy", 2004. - 192 p. ISBN 5-7695-1510-4

The workshop is designed to acquire practical skills in working on a personal computer in a Windows environment and basic office programs MS Office - text editor MS Word; spreadsheet editor MS Excel; MS Access database management systems. Contains tasks provided with detailed instructions for execution and drawings for clarity.

For students of institutions of secondary vocational education. It may be useful to those who wish to learn how to work with applied programs in a qualified manner.

UDC 004(075.32)

BBK32.81ya723

Foreword

The workshop can be used both for conducting practical classes (basic and optional), and for individual training in the basic methods of working with computer software products.

An important feature of the workshop is the presence of additional tasks for independent work at the end of each practical work and at the end of each section.

Having studied the theoretical material and completed the practical tasks of the proposed workshop, the user will have stable initial skills in working in the Windows environment.

Section 1 of the basics of working in the windows environment Practical work 1 Topic: organization of work on a PC. Working with a PC keyboard

The purpose of the lesson. Learning the techniques of the initial organization of work on a PC, turning on / off the PC, learning how to work with the keyboard PC.

Task 1.1. Turning on the PC. Getting Started on PC.

Operating procedure

1. Turn on the PC in the network, press the power button on the monitor, press the Power button on the system unit.

When turned on, the indicators should light up, the monitor will make the same sound as when you turn on the TV, and the power supply fan in the system unit will make noise.

2. Wait for the operating system to load (approximately 60 seconds).

The operating system starts automatically after turning on the PC with the Power button on the system unit. First, the computer checks the functionality of its main devices, then you may need to enter a user password or network password if the PC is connected to a network.

After loading the Windows environment, the so-called Desktop(Desktop), at the bottom of which, during a standard installation, is located Task bar. There is a button on the left side of the taskbar. Start(Start)

Brief reference. into the structure main menu There are two sections: mandatory and optional. The user can set the points of an arbitrary section at will. Sometimes

such items are generated automatically when installing applications (for example, Ms Office).

4. Learn the screen layout and basic icons Working field.

The main part of the screen is Working field. Icons are located on it - My computer, My documents,Internet explorer, Basket, corresponding folders of the same name. There may also be folder shortcuts. The set of icons and labels is chosen by the user himself, so their number and list may be different.

5. Learn the basics of a personal computer with a tutorial like "Instructor" (or whatever you have).

Task 1.2. Entering information using the keyboard.

- (Greek academia, from own name). 1) a garden near Athens, given to Plato by the Athenian citizen Akademos, for his conversations with his students. 2) educational institution the highest level with any special teaching. 3) a society of scientists or artists with ... ... Dictionary of foreign words of the Russian language

Painting and stink. Jarg. stud. Shuttle. Academy of Painting and Sculpture. BSRZh, 32. Academy of winged. Pub. Obsolete Pathet. Higher educational institution that trains pilots. Novikov, 18. Academy of squalor. Jarg. stud. Shuttle. iron. Academy of Arts in ... ... Big dictionary of Russian sayings

The Platonic School of Plato, founded c. 387 BC A. from the name of the public gymnasium, which probably existed since the time of Solon (beginning of the 6th century BC) in the north. app. suburb of Athens on the site of a sanctuary in honor of the local hero Academ. Near… … Philosophical Encyclopedia

academy- and well. academy f. 1508. Lexis. 1. 1691. Lexis. School for teaching horseback riding, dancing, fencing, etc. Sl. 18. Academy, there is also a place where the nobility learns horseback riding, and other bodily exercises. FRL 1 1 10. From the opening of the case ... ... Historical Dictionary of Gallicisms of the Russian Language

The original name of the Academy was the philosophical school organized by Plato in 388 BC. in Athens. Its members paid monthly membership dues. Training sessions and debates were held according to a strict schedule. For almost... ... Historical dictionary

ACADEMY, academies, women (Greek akademia, originally the school of Plato in gardens dedicated to the memory of the hero Academ). 1. Higher scientific institution. Academy of Sciences. Communist Academy. 2. The name of some higher education institutions, eg. Military ... ... Dictionary Ushakov

Arts. Schools for the training of artists, like all schools, may first of all be founded by private individuals, and as individual, non-extensive schools or workshops, are of the highest importance and must count on the assistance of communities and government ... Encyclopedia of Brockhaus and Efron

ACADEMY, the name of some educational, scientific and other creative institutions (from the Platonic Academy). Academies were called circles of scientists that gathered under the rulers of some medieval states of the East and Western Europe, societies ... ... Modern Encyclopedia

Female, Greek in general, the highest scientific or educational fraternity and the institution itself; a society of scientists or artists united under this name for the benefit of science; the same educational institution, for education-prepared young people. In university… … Dahl's Explanatory Dictionary

academy- Academy ♦ Academie A proper name originally referring to the school of Plato (he taught in the gardens located in the northwest of Athens called Akademos). Contrary to the direction of its founder, the Academy subsequently became a hotbed ... ... Philosophical Dictionary of Sponville

According to the definition of the Federal Law on Higher and Postgraduate Professional Education of July 19, 1996, a higher educational institution that: implements educational programs higher and postgraduate professional education; prepares... ... Law Dictionary