Tutorial. - 14th ed., erased. — M.: Academy, 2014. — 256 p. - ISBN 978-5-4468-0800-7. The textbook can be used to study general professional disciplines technical specialties in accordance with GEF SPO for secondary vocational education.
The textbook is intended for acquiring practical skills in working with the most commonly used in professional activity application programs. 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. Gives maximum effect parallel use tutorial and workshop.
For students of institutions of secondary vocational education. Foreword.
Practical work
Text editor MS Word-2000
Creation business documents in MS Word editor.
Formatting text documents containing tables.
Creation of text documents based on templates. Creation of templates and forms.
Creation of complex documents in a text editor.
Formulation of formulas by the MS Equation editor.
Organizational charts in MS Word document.
Comprehensive use of the capabilities of MS Word to create documents.
Spreadsheet MS Excel-2000
Organization of settlements in spreadsheet processor MS Excel.
Creation e-book. Relative and absolute addressing in MS Excel.
Related tables. Calculation of subtotals in MS Excel tables.
Parameter selection. Organization of the reverse calculation.
Optimization problems (search for solutions).
Links between files and data consolidation in MS Excel.
Economic calculations in MS Excel.
Integrated use of Microsoft Office applications to create documents.
Database management system MS Access-2000
Creating database tables using the designer and the table wizard in MS Access DBMS.
Editing and modification of database tables in MS Access DBMS.
Creation of user forms for data entry in MS Access DBMS.
Consolidation of acquired skills in creating tables and forms in MS Access DBMS.
Working with data using queries in MS Access DBMS.
Creation of reports in MS Access DBMS.
Creation of subforms in MS Acces DBMS.
Creating a database and working with data in MS Access DBMS.
Reference and legal system "Consultant plus"
Search organization normative documents according to the details of the document in the ATP "Consultant Plus".
Organization of full-text search. Working with a list in the ATP "Consultant Plus".
Working with the list and text of found documents. reference Information. Working with folders in ATP "Consultant Plus".
Working with forms. Organization of search in several information bases.
Search for documents, work with the list and text of found documents in the ATP "Consultant Plus".
Accounting program "1C: Accounting" (Version 7.5/7.7)
Organization of initial work in the accounting program "1C: Accounting".
Formation of analytical accounting and filling in directories in the accounting program "1C: Accounting".
Input initial balances on accounts in the accounting program "1C: Accounting".
Reflection of business transactions in the accounting program "1C: Accounting".
Calculation wages and deductions for UST in the accounting program "1C: Accounting".
Cash and banking operations in the accounting program "1C: Accounting".
Formation of financial results, reports and receipt of the final balance in the accounting program "1C: Accounting".
Organization of work in global network Internet
Email. MS Outlook Express mail program.
MS Browser Setting Internet Explorer.
Search for information in the global network.
Bibliography

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.

CREATING TEXT DOCUMENTS BASED ON TEMPLATES. CREATION OF TEMPLATES AND FORMS.
The purpose of the lesson. Studying the information technology of creating MS Word documents using Templates, creating Templates and Forms.

Task 3.1. Create a calendar for the current month using a Template.
Operating procedure
1. Launch Microsoft Word text editor.
2. Create a calendar for the current month using the Template. To do this, in the document creation window (File/Create), on the Other Documents tab, select Calendar Creation Wizards (Fig. 3.1).
Selecting the style, sheet orientation, and month/year in sequence, create a calendar for the current month.
3. Save the document in your folder.

TABLE OF CONTENTS
Foreword
Section 1 MS WORD-2000 TEXT EDITOR
Practical work 1
Topic: Creating business documents in MS Word
Practical work 2
Topic: Formatting text documents containing tables
Practical work 3
Topic: Creation of text documents based on templates. Create templates and forms
Practical work 4
Topic: Creating complex documents in a text editor
Practical work 5
Topic: Formatting formulas in MS Equation editor
Practical work 6
Topic: Organizational charts in MS Word document
Practical work 7
Topic: Comprehensive use of MS Word capabilities to create documents
Section 2 MS EXCEL-2000 SPEECH PROCESSOR
Practical work 8
Topic: Organization of calculations in spreadsheet MS Excel
Practical work 9
Subject: Creating an e-book. Relative and absolute addressing in MS Excel
Practical work 10
Subject: Linked tables. Calculation of subtotals in MS Excel tables
Practical work 11
Subject: Parameter selection. Backcounting organization
Practical work 12
Topic: Optimization problems (search for a solution)
Practical work 13
Topic: Links between files and data consolidation in MS Excel
Practical work 14
Topic: Economic calculations in MS Excel Practical work 15
Topic: Comprehensive use of Microsoft Office applications to create documents
Section 3 DATABASE MANAGEMENT SYSTEM MS ACCESS-2000
Practical work 16
Topic: Creating database tables using the designer and the table wizard in MS Access DBMS
Practical work 17
Topic: Editing and modifying database tables in MS Access DBMS
Practical work 18
Topic: Creating custom forms for data entry in MS Access DBMS
Practical work 19
Topic: Consolidation of acquired skills in creating tables and forms in MS Access DBMS
Practical work 20
Topic: Working with data using queries in MS Access DBMS
Practical work 21
Topic: Creating reports in MS Access DBMS
Practical work 22
Topic: Creating subforms in MS Acces DBMS
Practical work 23
Topic: Creating a database and working with data in MS Access DBMS
Section 4 REFERENCE AND LEGAL SYSTEM "CONSULTANT PLUS"
Practical work 24
Topic: Organization of the search for regulatory documents by the details of the document in the SPS "Consultant Plus"
Practical work 25
Topic: Organization of full-text search. Working with a list in the ATP "Consultant Plus"
Practical work 26
Topic: Working with the list and text of found documents. Reference Information. Working with folders in ATP "Consultant Plus"
Practical work 27
Topic: Working with forms. Organization of search in several infobases
Practical work 28
Topic: Searching for documents, working with the list and text of found documents in Consultant Plus SPS
Section 5 ACCOUNTING SOFTWARE "1C: ACCOUNTING" (VERSIONS 7.5/7.7)
Practical work 29
Topic: Organization of initial work in the accounting program "1C: Accounting"
Practical work 30
Topic: Formation of analytical accounting and filling in directories in the accounting program "1C: Accounting"
Practical work 31
Topic: Entering initial account balances in the accounting program "1C: Accounting"
Practical work 32
Topic: Reflection of business transactions in the accounting program "1C: Accounting"
Practical work 33
Topic: Calculation of wages and deductions for UST in the accounting program "1C: Accounting"
Practical work 34
Topic: Cash and banking operations in the accounting program "1C: Accounting"
Practical work 35
Topic: 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
Practical work 36
Subject: Email. MS Outlook Express mail program
Practical work 37
Topic: Configuring MS Internet Explorer
Practical work 38
Topic: Searching for information on the global network
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.

Workshop in composition of the CMD 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 educational process 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: Processing basics graphic images
  • 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

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 qualification modern specialist and its effectiveness in to a large extent determined by the ability to use information technology in professional activities.

The workshop is aimed at mastering the skills practical application 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), programs for working with email and the Internet ( Microsoft Outlook express, Microsoft Internet Explorer), decision support programs (reference legal system "ConsultantPlus" and professional accounting program "1C: Accounting").

The workshop can be used for both basic and optional practical exercises, 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 of creation, preservation and preparation for printing Microsoft documents word.

Task 1.1. Create an invitation template

Operating procedure

1. Open Microsoft Word text editor.

2. Install desired view screen, 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. top make statements 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.

Suggested topic:

1. Psychology of business communication.

2. Business etiquette.

3. Culture appearance firm personnel.

involved in the implementation of the project experienced psychologists, culturologists, doctors, make-up artists, fashion designers.

Upon completion of the course, students will receive a certificate International Institute"Work and Management" under the advanced training program.

We look forward to fruitful cooperation, realizing the exceptional importance and relevance of the topics we propose.

Task 1.4. Prepare a report template

Brief reference. 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 - left, in the right - centered.

Job Sample

MEMORANDUM

Sector in deadlines unable to complete project review marketing research firm "Eureka" due to the lack of complete information about financial condition firms.

Please give guidance to the sector technical documentation provide complete information about this company.

Attachment: Protocol on the incompleteness of the technical documentation of the Evrika company.

Note. When finished, close all open files, close the Microsoft Word text editor window, and then shut down the computer (Start/Turn off the computer).

Task 1.5. Create a property write-off act

Job Sample

About write-off of property

Reason: command CEO LLC "Vlados" dated 10.10.2007 No. 1 "On inventory".

Compiled by a committee composed of:

chairman: commercial director S. L. Roshchina;

Commission members: 1. Chief Accountant D. S. Kondrashova;

2. Head of the administrative and economic department S. R. Semenov;

were present: the storekeeper O. G. Nozhkina.

In the period from 10/11/2007 to 10/15/2007, the commission carried out work to establish the unsuitability for further use of the property.

The commission established: according to the list attached to the act, the property is subject to write-off due to unsuitability for use.

The act is drawn up in triplicate:

1st copy - to the accounting department;

2nd copy - to the administrative department;

3rd copy - in case No. 1-03.

Application: for 3 liters. in 1 copy.

Chairman of the Commission (signature) S. L. Roshchina

Members of the commission (signature) D. S. Kondrashova

(signature) S. R. Semenov

Acquainted with the act: (signature) O. G. Nozhkina