Special software arm. Workstation software

Benefit number 3

Discipline of AWP and NPP

Laboratory and coursework

Topic No. 3: "Workstation software"

Select:

1. General software for a given AWP;

2. Functional software for a given AWP.

Develop:

3. A program (in Excel, Access, MathCAD, etc.) for solving the problem in the framework of an individual assignment.

MM. Bolotin. Automated workstations and expert systems for car repair production. Study guide (in two books). MIIT. 1996 .-- 109 p.
MM. Bolotin. Methodical instructions for laboratory work on the discipline "Automated workstations and expert systems of car repair production". MIIT. 1997 .-- 38 p.
MM. Bolotin. Methodical instructions for course work in the discipline

"Automated workstations and expert systems for car repair production." MIIT. 1998.- 16 p.

Joyce Nielsen. Microsoft Excel 97: Reference. -SPb: Peter Kom, 1999.-320 p.
Leontiev Yu. Microsoft Office 2000: a short course. - SPb: Peter, 2001 .-- 288 p.
Walkenbach, John. A detailed guide to creating formulas in Excel 2002 .: Per. from English. - M .: Publishing house "Williams", 2002.-624 p.
Gunther Steiner. Visual Basic 6.0 for Applications - M .: Laboratory of Basic Knowledge, 2000 .-- 832 p. (Directory).
MM. Bolotin. Application of Excel and MathCAD programs in engineering calculations of car repair production. Methodical instructions for the implementation of laboratory and coursework on the discipline "Automated workstations and expert systems of car repair production." MIIT. 2005.
MM. Bolotin. Automation systems for the production and repair of cars. Methodical instructions for laboratory work in the EXCEL spreadsheet environment. M .: MIIT. 2001 .-- 60 p.

Workstation software is a set of programs and software tools that implement the solution of problems, ensure the rational functioning of a complex of technical means and an information base, as well as carry out rational human interaction with hardware.

The AWS software is formed in accordance with the structural diagram of the AWP, its purpose and operating mode. The content of documents on the AWP software must comply with GOST 24.207-80 System of technical documentation. Requirements for the content of software documents.

Software documentation is intended to describe design solutions for software, to establish requirements for a complex of programs, to describe solutions that provide maintenance, production and operation of software complexes, to check the performance of programs based on a test case.

General software workstation

General software is a part of the software of an automated system, which is a collection of programs designed for a wide range of users and intended for organizing the computing process and solving frequently encountered information processing problems.

Common software includes:

· OS;

· System programs;

· programming languages;

· Tools for creating programs.

Operating systems (it is necessary to indicate the operating system recommended for use in a given workstation).

The most widespread in Russia are the dialog operating systems Windows (95; 98; 2000, etc.), Windows NT, Windows ME, Windows XP, etc.

Windows 2000, Windows ME, Windows XP are the most simple operating systems that allow a person to interact with a computer in a convenient manner.

Windows NT is most often used in workplaces in large corporations. It places high demands on computer resources and has built-in capabilities to restrict access to data.

System programs.

System programs include:

· Driver programs that expand the OS's capabilities to control input-output devices and multimedia (keyboard, hard drive, mouse, sound card, speakers, CD-ROM, etc.);

· Shell programs that provide a more convenient and visual way to communicate with a computer compared to the OS (Norton Commander, Disco Commander);

· Operating shells, which provide the user with visual aids for performing the most frequently used actions, graphical tools, menu building tools, etc. (Windows 3.1 for MS DOS);

Auxiliary programs (utilities): programs for copying, backing up, antivirus programs (Norton Antivirus 2002), programs for restricting access, archiving programs (WinRAR), etc.

Programming languages.

Programming languages determine the principles of creating programs and are most often used to write narrowly focused programs on the order of specialists. The most commonly used are BASIC, Pascal, Fortran, C ++, Prolog, Lisp, etc. Narrow-oriented programs can be effectively created using Excel and MathCAD tools.

Tools for creating programs.

Programming tools are, as a rule, program editors for the corresponding programming languages, which provide a means of highlighting subroutines or functions and greatly facilitate the debugging of programs. These tools include: Visual Basic, Turbo Pascal, Turbo C, etc.

Functional software

Functional or application software AWP is a set of interconnected programs designed to implement functions or a group of functions of an automated system and are customizable for a specific application.

Functional software includes:

Multifunctional packages:

Text editor for publishers;

Graphic editor AutoCAD;

Database management systems;

Computer games;

Electronic directories;

Training programs;

Computer-aided design systems, etc.

· Integrated packages (combine some of the most frequently used programs under a common ideology).

In integrated packages, all the necessary tools are combined into one package, which ensures the compatibility of data recording, the ability to switch to other programs, the continuity of various types of commands and methods of working with the menu. The most popular integrated packages: Microsoft Office, Lotus - 1-2-3, Frameworks, MS Works, etc.

The integrated Microsoft Office suite includes:

Microsoft Word is a text editor that is effective for typing and editing text, creating formulas (Microsoft Equation 3.0), a set of tables, building charts and trend lines, building elementary diagrams;

Microsoft Excel - spreadsheets that are effective for making calculations in the form of tables, creating formulas for making calculations using mathematical and statistical functions, including sections of probability theory, mathematical statistics, linear programming, differential equations and creating databases;

3.1 General software workstation

Common software includes:

· OS;

· System programs;

· programming languages;

· Tools for creating programs.

Operating systems (it is necessary to indicate the operating system recommended for use in a given workstation).

The most widespread in Russia are the dialog operating systems Windows (95; 98; 2000; 2007, etc.), Windows NT, Windows ME, Windows XP, Windows Vista, etc.

Windows 2000, Windows ME, Windows XP are the most simple operating systems that allow a person to interact with a computer in a convenient manner.

Windows NT is most often used in workplaces in large corporations. It places high demands on computer resources and has built-in capabilities to restrict access to data.

The Windows Vista operating system is distinguished by increased security and reliability of protection against viruses, design, convenience of the system of searching and organizing information, the ability to work with sound, photo and video files. But it places higher demands on the PC.

System programs.

System programs include:

· Driver programs that expand the OS's capabilities to control input-output devices and multimedia;

Auxiliary programs (utilities): programs for copying, backing up, antivirus programs, programs for limiting access, programs for archiving (WinRAR), etc.

Programming languages.

Narrow-oriented programs can be efficiently created using Excel and MathCAD tools.

Tools for creating programs.

3.2. Functional software

Functional software includes:

· Multifunctional packages:

Text editor for publishers;

Graphic editor AutoCAD;

Database management systems;

Computer games;

Electronic directories;

Training programs;

Computer-aided design systems, etc.

· Integrated packages(combine some of the most frequently used programs under a common ideology).

In integrated packages, all the necessary tools are combined within one package, which ensures the compatibility of data recording, the ability to switch to other programs, the continuity of various types of commands and methods of working with the menu. The most popular integrated packages: Microsoft Office, Lotus - 1-2-3, etc.

The integrated Microsoft Office suite includes:

Microsoft Power Point - used to prepare reports in the form of slides;

Microsoft Access - a database management system (used to store information in the form of tables, perform data analysis);

· Problem-oriented packages.

Problem-oriented packages cover a specific area of knowledge (mathematics, physics, economics, mechanics, etc.). A striking representative of problem-oriented packages is the universal mathematical package MathCAD designed to solve engineering and scientific problems in the amount of higher mathematics.

· Narrow-specific programs are created at the request of specialists by professionals in the subject area of knowledge (dynamics, strength, organization of production, etc.), fluent in programming languages.

Narrowly-oriented programs developed by order of AWP users in traditional programming languages or in the Excel and MathCAD environment must be accompanied in accordance with GOST 24.207-80 by the following documents: "program description", "programmer's manual", "operator's manual", "text programs".

As part of the course work, narrowly focused programs are developed for the following tasks:

Calculation of the technical and economic criterion of competitiveness;
Selection of optimal strategies;
Building statistical models;
Building models of linear mathematical programming;
Examination of production
Development of calculation algorithms and narrowly oriented programs within the framework of an individual assignment.

3.3. List of selected standard software and narrowly oriented programs

Table 3.3. XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

3.4. Methodology for determining the technical and economic criterion of competitiveness of AWP

The numerical values of the technical and economic criterion can be determined by the formula:

where - an integral indicator of competitiveness in terms of technical parameters;

The number of investigated technical parameters;

weight coefficient of the first technical parameter:

the absolute weight of the first technical parameter;

Empirical coefficient ( .

As technical parameters, you can, for example, take the following characteristics of the system unit and monitor:

clock frequency ();

the amount of RAM ();

mean time to failure ();

the amount of hard disk memory ();

video card memory size ();

fan noise ();

response time (), etc. ( the set of parameters is chosen by the AWP developer);

or - the relative indicator of competitiveness, compared parameters of the system unit or monitor ( the first ratio is used for indicators with an upward trend, and the second - for a decrease: the first five indicators have an upward trend, and the last two - a downward trend). An increase in the relative indicator should correspond to an improvement in product quality (AWP);

The absolute value of the first technical parameter for the design option;

As part of the AWP software, two main types of software can be distinguished, differing in functions: general (system) and special (applied). The general software includes a set of programs that automates the development of programs and the organization of the economic, computing process on a PC, regardless of the tasks being solved. Special (application) software is a collection of programs for solving specific user problems.

Taking into account the modern functional structure of territorial government bodies, the set of software and hardware should form at least a three-level global data processing system with a developed set of peripheral facilities at each level.

The first level is the central computing system of a territorial or corporate body, which includes one or more powerful computers, or mainframes. Its main function is general, economic and financial control, information services for management employees.

The second level - the computing systems of enterprises (associations), organizations and firms, which include mainframes, powerful PCs, provide data processing and management within the structural unit.

The third level is locally distributed computer networks based on PCs serving the production areas of the lower level. Each site is equipped with its own PC, which provides a set of works on primary accounting, accounting for needs and resource allocation. In principle, it can be an automated workstation (AWS) that performs functional computational procedures within a certain subject area.

Problem-oriented PPPs are the most functionally developed and numerous PPPs. They include the following software products: word processors, publishing systems, graphic editors, demo graphics, multimedia systems, CAD software, work organizers. And also, spreadsheets (spreadsheet processors), database management systems, character recognition programs, financial and analytical and statistical programs.

Spreadsheets (tabular processors) are software packages for processing tabularly organized data. The user can use the tools of the package to carry out various calculations, build graphs, control the format of data input-output, compose data, conduct analytical studies, etc.

Work organizers are software packages designed to automate the planning procedures for the use of various resources (time, money, materials) both for an individual and for the entire company or its structural units.

Word processors are programs for working with documents (texts) that allow you to compose, format, edit texts when a user creates a document.

Desktop publishing systems (NIS) are programs for professional publishing activities that allow electronic layout of the main types of documents, for example, a newsletter, a short color brochure and a voluminous catalog or trade application, a reference book.

Graphic editors - packages for processing graphic information; are divided into RFP processing of raster graphics and images and vector graphics. SPP of the first type are designed to work with photographs. The packages provide the ability to convert photos to images with a different degree of resolution or other data formats. Packages with vector graphics are intended for professional work related to artistic and technical illustration, followed by color printing. They have a wide range of functionalities for complex and accurate processing of graphic images.

Integrated software packages - in terms of the number of product names, they are not numerous, but computationally powerful and actively developing part of the software. Traditional, or fully connected, integrated software systems are a multifunctional stand-alone package in which the functions and capabilities of various specialized (problem-oriented) packages, related in the sense of data processing technology at a separate workplace, are combined into one whole.

Country support:
Operating system: Windows
Family: Universal Accounting System
Purpose: Business automation

AWP program

The main features of the program:

The program can be translated into any language convenient for you. In addition, you can work with several languages at once.

You can keep an electronic medical history in the program

The program includes academic knowledge with a categorized list of ICD diagnoses

For various diagnoses according to ICD, a plan for the required examination and treatment has already been drawn up

All test results can also be stored in the program

Setting up the filling of templates for research will help optimize the work of all your specialists and get rid of paper documentation

You can attach pictures and any files to the patient's history

Any letterhead in MS Word format can be set as a template for filling

To prevent patients from waiting in line for an appointment, you can use an appointment

It is possible to use discount cards

Supports automatic and manual write-off of medicines and materials for research. Pharmacy sales

For all services, you can set up a calculation, and then consumables will be written off automatically

A modern system for working with patients will help employees complete all important tasks on time

You will be able to observe how your client base is growing rapidly and attract new patients using the modern capabilities of the program

You will find out on which days of the week or day of the month you have the most patients, this will make it easy to manage the workload of each department

The system will show which of the patients brought you the most profit, and you can easily reward such clients with a personal price list or bonuses

The report will show which of the patients did not fully pay for their purchases or which of the suppliers you have not yet fully settled with

Each of your marketing decisions will be taken into account and analyzed according to the number of new patients and payments

Managers will be able to easily find out which of your clients has not appeared for a long time and immediately contact them

Reason for leaving statistics can help you avoid patient outflow

Your specialists can be easily compared according to various criteria: number of patients, services provided, profit and productivity

You will find out which doctors often come back to patients, and who can lose your clients

Piecework wages of specialists are easily calculated automatically, taking into account personal rates

For each doctor or department, you can find out the dynamics of the growth of visits and services for any period

A special report will show the most profitable or popular services

You can find out all statistics on patients, services and specialists for any convenient period of time and evaluate the dynamics using visual reports

You will receive full statistics on the goods sold or spent on services

For each medication or product, the program will tell you how long its stock will last, which will optimize procurement and storage

The purchasing power report will show the financial capabilities of your customers depending on each branch

All financial movements will be under your complete control. You can easily track what you spend the most money on for any period

Analysis of payments by the values you need will help you make a decision to increase or decrease prices for services and goods

Integration with the latest technologies will allow you to shock your customers and deservedly gain the reputation of the most modern company

Payment
terminals

Reserve
copying

Application
for staff

Application
for clients

You can quickly enter the initial data required for the program to work. For this, a convenient manual input or import of data is used.

The interface of the program is so easy that even a child can quickly figure it out

Language of the basic version of the program: РУССКИЙ

You can also order the international version of the program, in which you can enter information in ANY LANGUAGE of the world. You can even easily translate the interface yourself, since all the names will be placed in a separate text file.

The AWP program is an information and technical complex that collects, stores and processes data and automates the management and control of various business processes. The automated workstation of a workstation specialist reduces the possibility of errors or deliberate falsification of data. The program provides management with proper control over the actions of personnel.

The administrator's workstation program visually displays records to specialists, foremen or to certain offices, provides management of the client base and control over the accounting of debts and prepayments. The use of the doctor's workstation software provides automation of the appointment of an examination and treatment plan according to a diagnosis selected from the base, provides the formation of all the necessary forms and protocols according to specified templates. The workstation program of the polyclinic stores information on anamnesis and treatment protocols, there are built-in reference books with academic data. The AWP polyclinic program and the AWP inpatient program guarantee the registration of test results, the inclusion and binding of X-ray images, dental records and other electronic documents and scans to patients.

In the AWP program, clients and all contact information on them will never be lost due to a single database of counterparties. On it, you can perform contextual search with management of various filters and control of grouping and sorting according to certain criteria. The entire history of transactions and relationships will be stored in one place in the program. You can link documents or any electronic files to the records in the administrator's workstation. Work planning is also carried out on the counterparty. Thanks to the program, managers will receive a prompt reminder of the need to make an important call, send a letter or prepare documentation, or hold a meeting. There is automation of mass and individual mailing.

AWP personnel program allows you to assign an individual work schedule for each employee, provides automation of the calculation of fixed and piecework wages, allows you to keep track of the employee's performance. The AWP store program will lead to the automation of the activities of the cashier, storekeeper: it maintains and keeps records of all types of payments, inventory, accounting of balances in warehouses, the formation of invoices, checks and orders.

You will not need instructions on how to install the AWP program: our specialists work with all near and far abroad for remote installation. The AWP software works over a local network and the Internet. There is remote access control and blocking control in case the user leaves the workplace.

In the AWP program, users are protected by a password, in addition, each account can be delegated their own access rights. Ordinary employees receive management of only information necessary for their work, for example, accounting. The management is provided with all the necessary control of any edits and changes, all reporting and its visualization for analyzing the management of a company or enterprise.

On the website of the Universal Accounting System company you will find many ready-made types of AWP programs and you can practically familiarize yourself with their capabilities by downloading the demo versions of the program. After the decision, our specialists will delve into all the subtleties of doing your business and will offer the most complete complex for automating management and control. We are waiting for your calls!

The program can be used by:

Anatoly Wasserman presents a new version 5.0 of the USU program

In addition to the opinions about the USU program of ordinary users, the opinions of experts are now presented to your attention. Anatoly Wasserman was born on December 9, 1952. Graduated from the Odessa Technological Institute of the Refrigeration Industry, specializing in engineer. After graduation he worked as a programmer. Then he became a system programmer. For the first time appeared on the screen in 1989 in the club “What? Where? When? ”, Then - at the“ Brain-ring ”. He won fifteen consecutive victories in 2001-2002 in the television "Svoi Game" and became the best player of the decade in 2004. Five-time champion of Ukraine in the sports version of "My Game". Four-time Moscow champion in the sports version of Svoy Igry, bronze medalist of the same competition, silver in 2017. Silver medalist of the "Experts" - World Games of Experts - 2010 in "Your own game".

Executive Management Supplement - The Modern Executive's Bible

Supplement to the program for professional managers: to develop business and increase income. A unique product developed at the intersection of two sciences: economics and information technology. No analogues

USU mobile application

With the advancement of technology, life is accelerating. Everywhere you need to be in time - because the faster you do things, the more you earn. For this reason, it is very important to have a feature-rich mobile app at your fingertips.

Alexander Druz about the Universal Accounting System

In addition to the opinions about the USU program of ordinary users, the opinions of experts are now presented to your attention. Alexander Druz is the first master of the intellectual game "ChGK". He was awarded the "Crystal Owl" prize for the best player of the club six times. Winner of the "Diamond Owl" prize for the best player. Champion of the television version of the "Brain-ring". In the television program "Own Game" he won "Linear Games", "Super Cup", won the "III Challenge Cup" with the team, set an absolute record for performance in one game. Author and presenter of intellectual games and educational programs on various TV channels.

Maxim Potashev on the effectiveness of the USU program

In addition to the opinions about the USU program of ordinary users, the opinions of experts are now presented to your attention. Maxim Potashev - master of the game “What? Where? When? ”, Four-time winner of the“ Crystal Owl ”prize, twice world champion, three times champion of Russia, six-time champion of Moscow, three-time winner of the Moscow Open Championship in the game“ ChGK ”. According to the results of a general audience vote in 2000, he was recognized as the best player in all 25 years of the elite club's existence. 50 thousand viewers of the program voted for the candidacy of Maxim Potashev. Received the "Big Crystal Owl" and the main prize of the jubilee games - the "Diamond Star" of the master of the game. Member of the Board and since 2001 - Vice President of the International Association of Clubs. By profession - mathematician, marketer, business coach. Graduated from the Faculty of Management and Applied Mathematics, taught at the Department of General and Applied Economics at MIPT. In August 2010 he was elected President of the All-Russian public organization "Federation of Sports Bridge of Russia". Leads a consulting company that helps various organizations solve problems related to sales, marketing, customer service and business process optimization.

The software tools used in the process of building and operating the AWS are subdivided into general and functional software.

General software (OBO) ensures the functioning of computers, the development and connection of new programs. It includes system software and programming systems. ...

Functional software support (FPO) determines the professional orientation of the AWP. It is here that the focus on a specific specialist is realized, the solution of problems of certain subject areas is ensured.

The specialization of a particular workstation depends on the composition of the functional software. Since the FPO ultimately determines the scope of the AWP and the composition of the tasks to be solved by the user, it should be developed on the basis of the software of dialogue systems designed to perform functions with similar information processing procedures.

Dialogue systems are software tools in which the user interacts with a computer by transmitting and receiving information through appropriate devices in real time. In this case, the user issues commands to the program, in response to which it provides him with the necessary data or performs certain actions.

Dialogue systems must satisfy the following set of requirements:

- fast and relatively easy user adaptation to work with the system;

- availability of uniform and user-friendly computational and logical procedures, as well as terminology;

- the use of short forms of dialogue, simple, easy to remember user commands;

- supplying the user with the necessary reference information and instructions for working with the system.

Let's consider the main groups of software tools used to automate the most common functions performed by employees. Such software tools include the following:

- systems for preparing text documents (text editors and desktop publishing systems);

- systems for processing financial and economic information (tabular editors and other similar programs);

- database management systems;

- presentation preparation systems;

- project management systems;

- personal information systems (organizers);

- Web browsers;

- programs for working with e-mail;

- expert systems;

- systems for intelligent design and improvement of control systems;

- document image processing systems;

- optical character recognition systems;

- document management systems and electronic document management.

Systems for preparing text documents

Systems for preparing text documents are divided into word processors and desktop publishing systems, which differ in the number and scope of functions performed. All types of systems for preparing text documents allow you to quickly enter information, edit it, search for errors themselves, help prepare text for printing, and also perform a number of other functions.

Publishing systems are used in the creation of printed products: for the design of magazines and "books, colorful advertising booklets and for other tasks that are impossible or difficult to solve using conventional text editors. Publishing systems allow you to prepare for printing and print on high-quality laser printers, as well as output complex documents that require high print quality to photosetters (Aldus PageMaker, Ventura Publisher)

Financial and economic information processing systems

Financial and economic information processing systems are used when working with numerical data (characteristics of economic and financial processes) to compile analytical reviews and other documents on their basis. Such software tools include spreadsheet processors, specialized accounting and banking programs (for intrabank and interbank settlements), specialized programs for financial and economic analysis and planning.

Database management systems

Specialists often have to work with large amounts of data in order to find various information necessary for preparing documents. To facilitate this kind of work, database management systems (DBMS) have been created.

Database (DB) is a collection of specially organized and logically ordered data.

The development of information technologies and their application in various fields of activity has led to the creation of various databases of varying complexity. The complexity of the database depends on the volume and structure of the information stored in the database, the variety of forms of its presentation, links between files, performance and reliability requirements.

Database organization requires the preliminary construction of a logical data model. Its main purpose is to systematize information by content, structure, volume, interrelationships, as well as to reflect the properties of information, taking into account the needs of end users.

The convenience of working with the database, obtaining the necessary information from the data arrays stored in the database, etc., is ensured by the presence of a well-thought-out and correctly implemented database management system.

A database management system (DBMS) is a set of tools and methods for collecting, registering, storing, ordering, searching, selecting and presenting information in a database.

DBMSs allow you to store large amounts of information and quickly find the data you need. (Microsoft Access)

Web browsers and e-mail programs

Currently, the main information resource for obtaining data is the Internet. To work with it, special software tools are used - Web browsers, which allow you to receive a wide variety of information around the world.

In modern management processes, one of the central places belongs to the operational exchange of information. According to some estimates, the exchange of data takes up to 95% of a manager's time and up to 53% of the time of ordinary specialists. In this regard, e-mail software is now widely used in the work of all types of organizations. E-mail allows you to exchange emails, as well as send documents within the organization, send, receive and process messages from various workplaces, and even hold meetings of specialists located at a considerable distance from each other.

Expert systems

The purpose of expert systems is to help employees perform high-quality analysis of source data in a specific area and make informed and informed decisions.

Expert systems are a special class of automated information systems that analyze, classify, diagnose and provide advice. When analyzing, they reproduce the scheme of reasoning of a human expert - reasoning based on informal rules used to improve the efficiency of solving a specific problem.

Expert systems not only perform the necessary functions, but at every step can explain to the user the reason for a particular recommendation and the sequence of analysis.

Document Management and Electronic Document Management Systems

Document management systems are used to automate the search, management and storage of electronic documents of various formats. Modern software products of this type allow you to perform a wide variety of operations on documents.

With today's high level of development of computer technology, it has become a common phenomenon when using a computer, payment orders, receipts and expenditures cash orders, invoices and other primary economic documents are formed.

When choosing a document management system, it is necessary to take into account the following parameters: ease of development and ease of use, the ability to integrate with other automated systems and work in computer networks, system reliability, availability of information security tools.

One of the common software products of this type is "1C: Electronic Document Management".