Workshop on information technology in professional activities. Elena Mikheeva - workshop on information technology in professional activities

SECONDARY VOCATIONAL EDUCATION

E. V. MIKHEEVA

WORKSHOP ON INFORMATION

TECHNOLOGIES IN THE PROFESSIONAL

ACTIVITIES

Approved by the Ministry of Education and Science of the Russian Federation

as a teaching aid for students of institutions of secondary vocational education

12th edition stereotypical

Ð å ö å í ç å í ò û:

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 of the Gosstroy of Russia, Ph.D. tech. Sciences A. E. Timashova;

head Department of "Informatization of Banking" of the Moscow Banking Institute, Ph.D. tech. Sciences A. N. Gerasimov

Mikheeva E. V.

M695 Workshop on information technology in professional activities: textbook. allowance for students. medium institutions. prof. education / E.V. Mikheev. - 12th ed., Sr. - M.: Publishing Center "Academy", 2013. - 256 p.

ISON 978-5-7695-9006-1

The textbook is intended for acquiring practical skills in working with the most commonly used application programs in professional activities. Contains assignments for the main sections of the textbook "Information Technologies in Professional Activities" 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.

The textbook can be used to study general professional disciplines of technical specialties in accordance with the Federal State Educational Standard for secondary vocational education.

For students of institutions of secondary vocational education.

ÓÄÊ 303.6(075.32) ÁÁÊ 32.81ÿ723

The original layout of this publication is the property of the Academy Publishing Center, and its reproduction in any way without the consent of the copyright holder is prohibited.

ISBN 978 -5 - 7695 - 9006 - 1 © Design. Publishing Center "Academy", 2004

FOREWORD

The interests of companies and firms with the expansion and deepening of the range of tasks they solve require the appropriate use of information technology. Life itself exposes the framework for the use of application packages to ensure maximum efficiency of the organization.

The workshop is a continuation of the textbook by the same author "Information Technologies in Professional Activities", published by the Publishing Center "Academy". It is aimed at mastering the skills of practical application of information technologies in the professional activities of students studying in the specialties of the "Economics and Management" group.

The workshop contains practical (training and monitoring) tasks on the use of Microsoft Office applications, such as MS Word, MS Excel, MS Access, e-mail and Internet programs, MS Outlook Express, MS Internet Explorer, as well as decision support systems - reference - legal system "Consultant Plus" and professional accounting program "1C: Accounting".

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

S ect 1

MS WORD-2000 TEXT EDITOR

Practical work 1

Topic: CREATING BUSINESS DOCUMENTS IN MS WORD EDITOR

The purpose of the lesson. The study of information technology for creating, saving and preparing for printing MS Word documents.

Task 1.1. Prepare an invitation template.

Operating procedure

1. Open Microsoft Word text editor.

2. Set the desired screen layout, for example - Page Layout (View/Page Layout).

3. Set the page settings (paper size - A4; orientation - portrait; margins: left - 3 cm, right - 1.5 cm, top - 3 cm, bottom - 1.5 cm) using the File / Page Setup command (Margins and Paper size) (Fig. 1.1).

4. Set line spacing - one and a half, alignment - centered using the Format / Paragraph command (tab

Indents and spacing) (Fig. 1.2).

Rice. 1.1. Setting page options

Rice. 1.2. Setting Paragraph Options

5. Type the text below (the text can be changed and supplemented). In the process of typing, change the style, font size (for the title - 14 pt; for the body text - 12 pt, paragraph alignment types - center, width, right) using the buttons on the toolbars.

Job Sample

INVITATION

Dear

Mr. Yakov Mikhailovich Orlov!

We invite you to the scientific conference "Informatization of modern society".

The conference will take place on November 20, 2003 at 12.00 in the conference hall of the College of Technology.

Scientific Secretary

S.D. Petrova

6. Enclose the text of the invitation in a frame and make a color fill.

Rice. 1.3. Framing the invitation

For this:

select the entire text of the invitation;

run the Format/Borders and Shading command;

on the Border tab, set the border parameters:

type - frame; line width - 3 pt.; apply - to a paragraph; line color - at your discretion (Fig. 1.3);

on the Fill tab, select the fill color (Fig. 1.4);

specify the condition for applying the fill - apply to the paragraph;

click OK.

7. Insert a picture into the invitation text (Insert/Picture/Pictures); set the position of the text relative to the picture - "Around the frame" (Format / Picture / Position / Around the frame).

8. Copy the standard invitation twice onto the sheet (Edit /

Copy, Edit/Paste).

9. Edit the sheet with the two invitations received

è prepare for printing (File/Preview).

10. Print the invitations (if you have a printer) by executing the File/Print command and setting the desired print options (number of copies - 1; pages - current).

11. Save the file in your group folder by doing the following:

Rice. 1.4. Invitation color fill

Task 1.2. Prepare a report according to the template.

B r a t c a t c a y i n a r a c a . Make out the upper part of the memorandum in the form of a table (2 columns and 1 line; line type - no borders). This design technique will allow you to perform different alignment in the cells of the table: in the left cell - to the left, in the right - to the center.

Job Sample

MEMORANDUM

The sector is unable to complete the examination of the Astra-N marketing research project in due time due to the lack of complete information about the financial condition of the company.

I ask you to instruct the sector of technical documentation to provide complete information on this company.

Attachment: Protocol on the incompleteness of the technical documentation of the Astra-N company.

Task 1.4. Submit an application according to the template.

B r a t c a t c a y i n a r a c a . Form the upper part of the application in the form of a table (2 columns and 1 line, line type - no borders) or in the form of an inscription using the tools of the Drawing panel. Align the cells to the left and center.

Job Sample

STATEMENT

to CEO

OJSC "GIKOR"

I.S. Stepanov

from Kovrov Olga Ivanovna,

residing at:

456789, Saratov,

st. Komsomolskaya, d. 6, apt. 57

I ask you to accept me for the position of chief specialist.

(signature) O.I. Kovrova

Task 1.5. Create a personal statement.

Job Sample

JSC "Vestor" REFERENCE 08.11.2003 No. 45 Moscow

Vasilyeva Olga Ivanovna works as a leading specialist of JSC Vestor.

Official salary - 4750 rubles.

The certificate is issued for submission at the place of demand.

Task 1.6. Create a short protocol.

Job Sample

JSC "Vestor" MINUTES 08.11.2004 No. 27

meetings of the Board of Directors

Chairman - A.S. Serov Secretary - N.S. Ivanchuk

In attendance: 7 people (list attached) Invitees: Deputy Director of the Book Chamber

n. Sh. Strelkov.

ISSUES CONSIDERED:

1. Organizational matters.

2. About the project of an illustrated publication on the activities of the firm

DECISIONS MADE:

1. A.A. Sidorov to prepare a draft staffing table for 2004.

2. To instruct the member of the Scientific and Information Commission K.S. Petrov to coordinate the draft of the publication with the Book Chamber.

Elena Viktorovna Mikheeva

Workshop on information technology in professional activities

FOREWORD

A personal computer in the digital age is for many professionals a tool for working with information. This means that the qualifications of a modern specialist and the effectiveness of his work are largely determined by the ability to use information technology in professional activities.

The workshop is aimed at mastering the skills of practical application of information technologies in professional activities in the preparation of students studying in the specialties of group 0600 "Economics and Management". It is a continuation of the textbook by the same author "Information Technology in Professional Activities".

The workshop contains training and control practical tasks on the use of Microsoft Office 2003 applications (Microsoft Word, Microsoft Excel, Microsoft Access), e-mail and Internet programs (Microsoft Outlook Express, Microsoft Internet Explorer), decision support programs (reference and legal system "ConsultantPlus" and the professional accounting program "1C: Accounting").

The workshop can be used both for conducting basic and optional practical classes, and for individual improvement of existing skills in working with computer software products.

CREATING TEXT DOCUMENTS IN MICROSOFT WORD-2003

Practical work 1

Topic: CREATING BUSINESS TEXT DOCUMENTS

Purpose of the lesson. The study of information technology for creating, saving and preparing for printing Microsoft Word documents.

Task 1.1. Create an invitation template

Operating procedure

1. Open Microsoft Word text editor.

2. Set the desired screen view, for example Page layout (View/Page layout).

3. Set the page parameters (paper size - A4, orientation - portrait, margins: top - 2 cm, left - 2.5 cm, bottom - 1.5 cm, right - 1 cm) using the command File/Page Setup(tabs fields and paper size)(Fig. 1.1).

Rice. 1.1. Setting page options

4. Set the alignment - to the center, the first line - indent, line spacing - one and a half, using the command Format/Paragraph(tab indents and spacing)(Fig. 1.2).

Rice. 1.2. Setting Paragraph Options

5. Type the text below (the text can be changed and supplemented). In the process of typing, change the style, font size (for the heading - 16 pt, all caps; for the body text - 14 pt), paragraph alignment types (center, width, left) using the buttons on the toolbars.

Job Sample

6. Enclose the text of the invitation in a frame and make a color fill.

For this:

- select the entire text of the invitation with the mouse;

- run the command Format/Borders and fill;

- on the tab The border set border parameters: type – frame; line width - 2.25 pt; apply - to a paragraph; line color - at your discretion (Fig. 1.3);

- on the tab fill select a fill color;

– specify the condition for applying the fill – apply to the paragraph;

– press the button OK.

Rice. 1.3. Framing the invitation

7. Insert a picture in the text of the invitation (Insert Picture/Pictures); set the position of the text relative to the picture - in front of the text (Format/Picture/Position tab/Before Text)(Fig. 1.4).

8. Copy the template prompt onto the sheet twice (highlight the prompt, Edit/Copy, set the cursor to a new line, Edit/Paste).

9. Edit the sheet with the two invitations received and prepare for printing (File/Preview).

10. Print the prompts (if you have a printer) by running the command File/Print and setting the desired print settings (number of copies - 1, pages - current).

Rice. 1.4. Set the position of text relative to a picture

11. Save the file to your group folder by doing the following:

Task 1.2. Fill out a sample application

Brief reference. Make the upper part of the application in the form of a table (2 columns and 1 line, line type - no borders) or in the form of an inscription using the panel tools Drawing. Align the cells to the left and center.

Job Sample

Additional tasks

Brief reference. Make out the upper part of the advertising letter in the form of a table (3 columns and 2 rows, line type - no borders, except for the dividing line between the lines). Align the table cells: the first row is centered, the second row is left-aligned.

Job Sample

FOR MANAGERS

firms, enterprises, banks and insurance companies

The International Institute "Work and Management" offers to your attention and to the attention of your employees the program "Company Image and Management Personnel".

The purpose of the program: formation of a positive image of the company, the acquisition of communication and etiquette skills by the company's employees.

The duration of the course is 20 hours.

The contents of the book "Workshop on information technology in professional activities":

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

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.

The workshop as part of the teaching materials with the textbook "Informatics" can be used in the study of the discipline of the mathematical and general natural science cycle "Informatics" in accordance with the Federal State Educational Standards for all specialties.

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.

Recommended by FGU "FIRO" as a teaching aid for use in the educational process of educational institutions implementing programs of secondary vocational education in the specialty "Informatics and Computer Engineering"

Publisher: Academy, 10th edition, 2012

ISBN 978-5-7695-8733-7

Number of pages: 192.

The contents of the book "Workshop in Informatics":

3 Foreword
SECTION 1: WINDOWS BASICS
- 4 Practical work 1. Topic: Organization of work on a PC. Working with a PC keyboard
- 12 Practical work 2. Topic: Organization of work in the Windows environment. Creating and deleting shortcuts
- 19 Practical work 3. Topic: Customizing the Windows user interface. My Computer window
- 26 Practical work 4. Topic: Working with files and directories in the Explorer program
- 31 Practical work 5. Topic: Placement, search and preservation of information. Antivirus protection
SECTION 2. STANDARD WINDOWS PROGRAMS
- 37 Practical work 6. Topic: Fundamentals of graphic image processing
- 44 Practical work 7. Topic: Multiprogram mode of operation in the Windows environment
- 46 Practical work 8. Topic: Integrated work with information in the Windows environment
SECTION 3. CREATING TEXT DOCUMENTS IN MS WORD 2000
- 48 Practical work 9. Topic: Creating documents in MS Word. Font Formatting
- 55 Practical work 10. Topic: Making paragraphs of documents. Headers and footers
- 62 Practical work 11. Topic: Creating and formatting tables in MS Word
- 68 Practical work 12. Topic: Creating lists in text documents
- 73 Practical work 13. Topic: Speakers. Initial letter. Register Formatting
- 77 Practical work 14. Topic: Inserting objects into a document. Preparing for printing
- 83 Practical work 15. Topic: Integrated use of MS Word capabilities to create text documents
SECTION 4. CALCULATIONS IN ELECTRONIC TABLES MS EXCEL 2000
- 88 Practical work 16. Topic: Organization of calculations in spreadsheet MS Excel
- 95 Practical work 17. Topic: Building and formatting charts in MS Excel
- 104 Practical work 18. Topic: Using functions in MS Excel calculations
- 111 Practical work 19. Topic: Relative and absolute addressing MS Excel
- 114 Practical work 20. Topic: Data filtering and conditional formatting in MS Excel
- 118 Practical work 21. Topic: Integrated use of MS Excel capabilities to create documents
SECTION 5. INTRODUCTION TO MS ACCESS 2000
- 122 Practical work 22. Topic: Database design in MS Access DBMS
- 132 Practical work 23. Topic: Creating tables and user forms for data entry in MS Access DBMS
- 139 Practical work 24. Topic: Modifying tables and working with data using queries in the MS Access DBMS
- 145 Practical work 25. Topic: Working with data and creating reports in MS Access DBMS
- 150 Practical work 26. Topic: Integrated work with MS Access DBMS objects
SECTION 6. CREATING A PRESENTATION IN MS POWER POINT 2000
- 152 Practical work 27. Topic: Development of a presentation in MS Power Point
- 161 Practical work 28. Topic: Setting effects and demonstrating a presentation in MS Power Point
SECTION 7. BASIC ORGANIZATION OF WORK ON THE INTERNET 2000
- 166 Practical work 29. Topic: Searching for information on the global Internet
- 173 Practical work 30. Topic: E-mail (E-Mail)
184 Bibliography

Workshop on information technology in professional activities. 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 Standard for secondary vocational education. The textbook is intended for acquiring practical skills in working with the most commonly used application programs in professional activities. Contains assignments for the main sections of the textbook "Information Technologies in Professional Activities" 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
Topic: Comprehensive use of MS Word capabilities to create documents
Section 2 MS EXCEL-2000 SPEECH PROCESSOR
Practical work 8 43
Topic: Organization of calculations in spreadsheet MS Excel
Practical work 9 52
Subject: Creating an 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. MS Outlook Express mail program
Practical work 37 237
Topic: Configuring MS Internet Explorer
Practical work 38 245
Topic: Searching for information on the global network
References 251