The workshop is designed to acquire practical skills in working on personal computer in the Windows environment and the main 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 study guide 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: 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: Complex use features of MS Word for creating 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: Email(Email)
• 184 Bibliography

Tutorial. - 14th ed., erased. — M.: Academy, 2014. — 256 p. – ISBN 978-5-4468-0800-7
The textbook is intended for acquiring practical skills in working with the most commonly used in professional activity application programs. 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. Maximum effect gives parallel use of the manual and workshop.
For students of institutions of secondary vocational education. Foreword.
Practical work
Text editor MS Word-2000
Creation of 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 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 calculations in spreadsheet 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".
Entering initial account balances 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 Bank operations in the accounting program "1C: Accounting".
Formation financial results, reports and obtaining the final balance in the accounting program "1C: Accounting".
Organization of work in the global Internet
Email. mail program MS Outlook Express.
Configuring the MS Internet Explorer browser.
Search for information in the global network.
Bibliography

Elena Viktorovna Mikheeva

Workshop on information technology in professional activity

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 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), e-mail and Internet programs (Microsoft Outlook Express, Microsoft Internet Explorer), decision support programs (ConsultantPlus legal reference system 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 (16 pt for the title, all caps; 14 pt for the body text), paragraph alignment types (center, justify, 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 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 Painting. 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 "Image of the company and management personnel".

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

The duration of the course is 20 hours.

Suggested topic:

1. Psychology of business communication.

2. Business etiquette.

3. Culture appearance firm personnel.

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

Upon completion of training, students are issued a certificate of the 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 cannot complete the examination of the project of marketing research of the company "Evrika" due to the lack of complete information about the financial condition of the company.

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. Close everything when finished 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;

committee 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, 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

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.

Approved by the Ministry of Education Russian Federation as a teaching aid

For students of institutions of secondary vocational education.

Publisher: Academy, 11th edition, 2012

ISBN 978-5-7695-8744-3

Number of pages: 256.

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

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