Computer Science Overview Guide
Computer Science Overview Guide
Prepared by: Jhonny E. Solano N. – Eng. Dairo Rodríguez Blanco Module: Office Automation
Reserved Copyright Rights ® Page No.1
CLASSIFICATION OF COMPUTERS
Computers, according to their origin or manufacturing, are classified as:
Branded computers: they are those in which all their components, internal and external, are from
the same manufacturer. These devices operate with the so-called 'closed technology,' currently
many brand equipment manufacturers have revalued this concept with the intention of achieving a
increase in their sales and to provide their customers with one more advantage by being able to repair their equipment with
parts from other manufacturers.
Clone computers: they are those machines that have components that are not all from the same manufacturer.
manufacturer, but that are compatible with the IBM factory PC platform. These machines
they manage the so-called 'open technology'.
According to their size and processing capacity, computers are classified into:
Microcomputers: Commonly known as PCs (personal computers) and are the type of
most widespread computers. There are 'Desktop' types and those called 'Laptops'.
Minicomputers: They can have multiple processors. They are used in network administration.
computers. They use multi-user operating systems with many variants and manufacturers.
Mainframes: They use large databases in large corporate networks. They have large
storage devices such as hard drives of over 1 Terabyte and security tapes.
Supercomputers: They are very powerful machines that allow simultaneous multi-user usage and have
hundreds or thousands of terminals. They have information storage capabilities on the hard drive
of 15, 20, or 30 Exabytes (thousand gigabytes) and handle millions of simultaneous access orders
informative. They have up to thousands of processors working in parallel to increase their
efficiency.
Illustrated quick work guide Topic: Introduction to Computer Science
Prepared by: Jhonny E. Solano N. – Eng. Dairo Rodríguez Blanco Module: Office Automation
Copyright Reserved ® Page No.2
The software: is the logical part of the machine, the one that is not
cannot be touched or physically felt. It is formed by all the
programs and the information that is managed and stored in the
machine; such as Windows, Word, Excel, etc.
The Firmware: It is the mixture between hardware and software, that is, the software controls the
Hardware.
b) The Mouse: it is a device used to select objects that already appear in the
screen. Objects are selected using a small arrow called pointer.
that moves when the mouse is moved across a flat surface.
h) The Optical Pencil: It is an instrument in the shape of a pencil that, through an optical system, is located
at one end, it allows data entry directly to the screen. To create drawings, it is moved
the pencil in front of the screen and a line will appear on it that describes the same movement. Also
fulfills mouse functions
The Magnetic Card Reader: it is an element that serves to read the data contained in
the magnetic stripe of a special card. They are used by banking entities especially
for the transactions at the ATMs.
a) The Monitor or Screen: It is the most common output medium for information, its
the appearance is very similar to a conventional television. Currently, work is being done
with LCD monitors (Liquid Crystal Display) which provide a good
definition, although its cost is a bit higher than conventional ones, it is justified in
regarding the advantages of space and the emission of non-harmful rays for the eyes.
c) The Monitor: it is also considered as an input and output device since today
There are monitors with Touch Screen technology that allow the selection of options in the
same screen.
a) The Main Board: also called the Motherboard, is the board where all the components are located.
electronic circuits, the microprocessor, the memories, the control chips, and the slots where
the other interface cards are inserted.
b) The Microprocessor: it is the electronic brain of the PC. It is responsible for performing all operations
mathematics and logic and controlling the entire functioning of the machine. It is he who receives and processes
the information and executes the orders given by the programs. All signals for handling and
information processing goes through the microprocessor.
The processor is internally divided into:
Arithmetic and logic unit: it is responsible for mathematical and logical processes and for sending the
results to the control unit.
Control unit: it is responsible for reading and writing information in memory, for carrying and bringing.
information and to execute the orders received by the computer.
c) The Memories: they are the first place where information is stored. All computers
They have various types of memory, but the two most used and known classes are:
Illustrated Quick Work Guide Theme: Introduction to Computer Science
Prepared by: Jhonny E. Solano N. – Eng. Dairo Rodríguez Blanco Module: Office Automation
Copyright Reserved ® Page No.5
RAM Memory: it is the working memory, in which the data that is temporarily stored is kept.
they are processing, the operating system and the program that is running. It is reading and
writing that indicates its content can be modified. It is erased when the machine is turned off or when exiting.
from an application or program without saving the data.
ROM memory: it is a read-only memory, its content is permanent or fixed and cannot be changed.
delete. It stores a series of routines or programs that the computer needs in order to
carry out the boot or initialization process. This is for the exclusive use of PC manufacturers and
we users do not have access to it.
Other types of memory are: Cache memory and video memory.
d) Interface Cards: they are cards with electronic circuits designed to be inserted into
the slots or expansion slots of the computer's mainboard. With these cards, it is possible
establish communication between the main card and its components with the peripheral devices
external ones that are used to perform various tasks. Among these cards are the video card,
sound, the network, the modem, etc.
e) The Hard Drive: it is the main means of permanent information storage that
runs in the RAM. It is a small metal box that is fixed inside the CPU that has great
storage capacity but are very fast for work. The system is installed on it
operational and all application programs are also stored with the already processed information.
f) The System Buses: A 'bus' is a network of fine metal lines that transport data to
through the motherboard of the computer and to the different components. They pass from the memory,
the processor, the motherboard, the hard drive, the slots, the interface cards and the peripherals. The
computers have three types of buses, they are:
The Data Bus: works in two directions or senses and allows the exchange of data between the
processor and the input and output units. In other words, it transports the information.
The Address Bus: works in one direction, from the microprocessor to the peripherals.
With it, one selects or directs which element the information is sent to or from which it is received.
The Control Bus: it works in a combined manner, it has lines of one-way and two-way.
With this, some procedures such as reading and writing are carried out.
g) The Power Source: it is responsible for receiving the direct current that comes from the regulator or from the
power outlet and transform it into the appropriate voltage required by the machine to then distribute it through
the other components of the PC. It is located at the rear back of the CPU case and of
She unplugs the cable that is connected to the outlet.
h) Communication Ports: they are the different connectors that are generally found,
on the back of the CPU where the different peripheral devices are connected
(keyboard, screen, mouse, printer, etc.). Each connector is called a port, and these in turn
They are installed on the main board or on the interface cards. There are serial and parallel ports.
my USB.
Fig. 12 Main Card Fig. 13 Microprocessor Fig. 14Memoria RAM Fig. 15Tarjeta de
Interface
Date: Student:______________________________________
Degree:
After reading and analyzing the concepts contained in the support material developed to date, we will
to exercise your mind a little by developing the following questionnaire in class.
Answer each of the following questions according to the specified modality in each case:
1. Responda (F) Falso o (V) Verdadero en cada uno de los siguientes enunciados:
The word Ofimática comes from the union of the words: office plus technique. )
Firmware is the mix between software and programs. )
Currently, all computing devices possess "Open Technology". )
The most widely used office suite is Office from the company Microsoft. )
The most widespread computers in the world are Mainframes.................. ............................ ( )
The storage measure used by supercomputers is terabyte ... )
The interface cards communicate the main card with some peripherals…………. ............ ( )
The RAM memory temporarily stores programs and work data. )
The acronym USB stands for Universal Serial Basic. )
A scanner is responsible for digitizing images to input them into the computer... )
[Link] the following sentences with the correct word from each line:
The capacity of supercomputer hard drives is measured in
The computers used by the tellers of a bank branch would be
The scanner can be called and the speakers can be called
LCD screens mean
A DVD-ROM drive is only capable of: more not of
The main characteristics of the PC are:
Another name by which a terminal or client is known is
The it is a voltage transformer inside the PC
The microprocessor is internally divided into
The It is the place where information can be stored permanently.
[Link] the relationship between the left column and the right column according to the concepts and
putting the corresponding letter:
( Plotter A) Uninterrupted power system
( ROM memory B) Motherboard or base plate
( UPS C) Versatile disk reading unit
( Blu Ray D) Read-only memory
( RAM Memory E) CD reader and rewritable unit
( Inkjet or bubble printer F) Output device for blueprint printing
( Mother Board It is known as a blue laser beam reader device.
( Hard drive H) Random Access Memory
( DVD-ROM I) Mass storage device
( CD-RW J) Output device that operates with toner
But the programs are designed for different tasks, and from there a classification arises.
according to their functions that we will analyze later.
1. BASIC STRUCTURE OF INFORMATION
DATA: A Data is an isolated idea that does not allow for a decision to be made as it is not
sufficient to establish a logical idea. It is said that there are two types of data, they are:
Discrete Data: These are the results of sporadic counting, they do not maintain a sequence or
continuity. For example, a person who goes out to walk or jog one morning but does not do it again.
diary, but every time he feels the need and suddenly takes the time it took and the distance
that traveled but только out of curiosity.
Continuous Data: They are the result of a continuous measurement process, obtained
through constant monitoring, evaluating and comparing the obtained data, generally
for making certain decisions. An example is that of a high-performance athlete who
trains every day and gets up to run a certain distance, timing himself and comparing it
with previous records to determine future training. Another example is that of a
doctor who evaluates an admitted patient by recording the obtained data in their medical history
in such a way that the treatment to be followed can be determined.
FIELDS: A field is a memory location that can store a single type of data.
Data, for example, a name is a field, as is age, a date, or an address.
There are several types of fields, they are:
Alphabetic or Alphanumeric Fields: They accept or receive letters, numbers, and symbols, but that
they are characterized by the fact that they cannot be used in mathematical operations or calculations.
Examples: Martha 3551246
- – Calle 41 # 39-67
Numeric Fields: They are those that only accept or allow numbers and whose main characteristic
they are usually employed in mathematical operations, for example, salaries, sales,
ages, etc.
Logical Fields: They are those that hold a single answer of two possible alternatives.
where they generally correspond to values of False or True.
Date Fields: Composed precisely of numerical data representing the values
the day number, the month number, and the year of any event or occurrence. For example, the date of
birth of a person, the hiring date of an employee, etc.
THE RECORDS: A record is the union of several data fields in the same row and that
they refer to the same person, the same element or the same entity. In turn, the union of
Several records make up a file, let's look at the following example:
Field names Records
Name Last name Address Salary Fec_Nacim Are you studying?
Carlos Road Cra 62 # 74-41 600000 03/25/80 S
Mary Sierra Cle 80 # 42-15 750000 06/12/77 N
Jorge Pérez Cle 45 # 57-28 550000 10/21/85 S
Teresa Diaz Cra 39 # 53-69 1200000 04/15/72 N
3.2. APPLICATION PROGRAMS: They are different types of utility programs, each one
they are very useful and generally have a lot of use at the business and personal level, among them are
the following stand out:
WORD PROCESSORS: Especially used for the
creation and modification of text-type documents such as written works, letters, reports,
memos, theses, projects, etc. Examples: Word – WordPerfect
SPREADSHEETS OR ELECTRONIC SHEETS: They are especially used for handling
files with accounting, financial or statistical information that involve the execution of
mathematical operations and handling of numerical data. Examples: Excel - Lotus
GRAPHING PROGRAMS: These programs are generally used for the
creation, modification, and manipulation of images and other graphic objects, especially with
advertising fines. Some may incorporate movements or animations, accompanied by
sounds and other special effects. Examples: Flash – Corell Draw – Power Point – Paint
DATABASE MANAGERS: They store large amounts of information under the
structure of fields and records which can be classified according to certain conveniences
or needs and offer them under certain criteria of consultations or searches requested by the
users. Examples: Access – Oracle – Informix – Paradox – FoxPro
INTEGRATED PROGRAMS: They are packages that group several applications or programs of
general purpose in one. Examples: Microsoft Office - Lotus Smart Suite
PUBLISHING PROGRAMS: Used for the preparation and editing of books, magazines, newspapers,
etc., in which large amounts of texts are handled at a professional level. Examples:
PageMaker, Publisher
{"text":"EDUCATIONAL PROGRAMS: They are made especially for teaching in different"}
levels, such as reference encyclopedias, tutors, simulators, etc.
SPECIALIZED PROGRAMS: These are specific programs designed to provide solutions to problems of
administrative, accounting or other types. They are business or commercial applications.
SPECIFIC PURPOSE PROGRAMS: These are programs that have been designed to
to fulfill a special or specific task that generally cannot be employed for another
purpose such as Antivirus, music and video players, browsers, etc.
Illustrated Quick Work Guide Theme: Introduction to Computer Science
Prepared by: Jhonny E. Solano N. – Eng. Dairo Rodríguez Blanco Module: Office Automation
Copyright Reserved ® Page No.
COMPUTER VIRUSES: They are executable programs that have been designed to
cause damage to files, programs, and even physical components of a computer
in which they are installed or spread. It is also possible that they are only used for
create confusion among users through the appearance of sounds and messages
unexpected. They can cause loss of information, slow execution of
procesos y muchas otras situaciones que vayan en contra de las actividades normales
of the users.
There are also antivirus programs or vaccines whose purpose is to detect, locate
to locate and remove viruses from a PC. Currently, there is a wide variety of
diversity of computer viruses and antivirus programs but some things must be taken into account
important recommendations:
An antivirus can help eliminate many viruses, but it may not be able to eliminate all of them.
The ideal is to keep the antivirus updated (recent version) with a renewed 'catalog' of viruses.
Review all the information that will be entered into the PC as a preventive measure.
Illustrated quick work guide Topic: Introduction to Computer Science
Prepared by: Jhonny E. Solano N. – Eng. Dairo Rodríguez Blanco Module: Office Automation
All Rights Reserved ® Page No.