Theme 2. Software. Windows Ms-office. Information networks

There are tens of thousands of applications of a different nature.

Systems of preparation of texts

Text processors allow you to prepare documents on a PC. An example of word processors is Word, PageMaker, Lexicon, and many others.

Table Processors

Electronic tables (processors) - software systems that are designed to work with tables of numbers, presentation of results in the form of charts, diagrams, etc. 

Electronic tables allow you to store in a tabular form not only a large amount of initial data, the results of calculations but also communications (mathematical relationships) between them, whose values are automatically recalculated according to the formulas when changing the values of the initial data.

An example of spreadsheets is Excel, Quattro Pro, SuperCalc, Lotus, etc. 

Documents created in the Excel environment are called books. Each book consists of sheets of the following types of sheets: work, diagrams, macros, modules in the language Visual Basic.

Database Management Systems (DBMS)

Databases - the only, centralized data warehouse of a certain domain. 

Each program has access to specific database data using special programs called database management systems. DBMS software products are FoxBASE, FoxPro, Access, etc.

Types of data organization and communication between them:

• Hierarchical (in the form of a tree) - there is the ordering of elements in the record, one element is considered the main one, others - subordinates.
• Network - there is an opportunity to install horizontal links in addition to vertical hierarchical connections.
• Relational (from the English relation - relationship) - in the form of rectangular tables.

The main objects of the database are:

• Tables are the basis of the database. In the database information is stored in a separate two-dimensional table. When working with data from multiple tables, links are established between tables.
• Queries - are created to search and select data from a table that satisfies certain conditions.

Powerpoint

PowerPoint is designed to prepare various kinds of presentations. In these presentations, you can use audio and video streams.

Computer graphics systems

There are two types of graphics: raster and vector.

Raster graphics - An image consists of points (pixels) that store information about brightness and color. 

Applied in artistic practice. An example of raster graphics systems is Paint, Photoshop, CorelDraw, and others.

Vector graphics - the image is constructed using a mathematical description of simple objects - line, circle, etc. 

Applied in engineering practice. An example of vector graphics systems is AutoCAD, Illustrator, and many others.

Computer Mathematics Systems

Systems of computer mathematics are intended for the decision of mathematical problems: Mathcad, Maple, Mathematica, Matlab, Derive and others.