Computer Studies Notes Form 3

Computer Studies Notes Form 3

Computer Studies Notes Form 3


Computer Studies Notes Form 3

1. Definition of Terms and Stages of Data Collection

Definition of terms and Stages of data collection

________________________________________

1. a) Data

Data is defined as a collection of raw facts (figures, letters, special symbols or a combination of both) that convey little meaning by themselves. example: in a statement like James, John and Caro

• what about them?

• why

• how

We actually don’t know anything about these three people thus it does not have much meaning to us until its fully processed for us to understand

b) Information

Information is defined as data has undergone processing and is meaningful to the user when they needs it.

The statement simply indicates that information is not just a by-product of data processing, but it must have certain qualities for it to qualify to be a resource to the organization.

Thus the qualities of timeliness, correctness and relevancy must be observed for it to be good information. example:James, John and Caro were awarded certificates for being the cleanest students in our school.

this statement now satisfies our curiosity because it has been attached much more meaning useful to us but we need also to when.

This statement can therefore be regarded as information

c) Data Processing

Data processing can be regarded as the act of collecting data, manipulating it to get information through (input, Processing and output) and finally distributing it to the relevant organs for use.

 

Data Processing Cycle

Data Processing Platform

Data processing cycle are the stages (phases) through which data moves before it becomes information.

These stages include:

1. Data collection

2. Data input

3. Processing

4. Output

 

Stages of data processing cycle

i) Data Collection

Data collection is the act of collecting data from its point of origin to the computer in a form suitable for processing

Stages of Data Collection

Data collection is procedural, thus it attracts the following stages

A) Data Creation

Data creation is the process of capturing data from the source location using data capturing methods like:(scanning, digital camera, touch screen, voice input etc).

B) Data Transmission

This is a term used to refer to the transfer of data from the point of collection (source) to the point where processing is to be done (data processing department) this is possible through computer-to-computer communication, physically by post office or via courier services if the source is away from the data processing department.

C) Data Preparation

Data preparation is the term used to describe the process by which data is prepared and made ready for entry in the computer for processing.

ii) Data input

This is the process where the collected data is converted from human readable form into machine readable form (binary form)

To ensure quick and error free data the following features should be considered:

• Validation – this is the counter checking whether what is on the input document is exactly what is entered into the computer

• Media Conversion – this is the act of converting data from different storage medium e.g from a flash disk to a hard disk

• Sorting – Data should be arranged in a predefined order before being processed

iii) Processing

This is the manipulation of input data into a more meaningful output that can be regarded as being meaningful to the user.

Processing involves arithmetic, sorting and logical operations

iv) Output

This is the final activity in data processing cycle where the expected output (information) is displayed.

This information is then distributed to places (information dissemination) where its needed to influence decision making process.

Information dissemination may include: electronic presentations over radio or television, distribution of hard copies, broadcasting messages over the internet or mobile phones.

________________________________________

Questions 1. Define the following terms

a) Data Processing

b) Data processing cycle.

c) Data

d) Information

2. using an illustration, describe the four primary stages of the data processing cycle

3. Outline the stages of data collection

4. List the three feature involved during data input stage to minimize errors

5. What is the essence of output stage?

2. Description of errors in data processing

Description of errors in data processing

1. Introduction:

Computers make errors because people program them to make those errors.

Thus the acronym GIGO – Garbage in Garbage out- errors can be described as:

1) Transcription errors

2) Computation errors and

3) Algorithm errors

1) Transcription errors

Transcription errors occur during data entry. These errors include:

i) Misreading errors

ii) Transposition errors

i) Misreading errors

These errors are caused by incorrect reading of the source document by the user and hence entering wrong values e.g. a user may enter 5 instead of S or 0 instead of o and so forth.

ii) Transposition errors

These are errors that occur due to incorrect arrangement of characters. like putting characters in the wrong order. e.g. the user may enter 369 instead of 396.

However these errors can be avoided by using modern data capture devices like the bar code reader, optical character reader, digital cameras, scanners, configuring the right data-types in the database e.t.c.

2) Computation errors

These are errors that occur when an arithmetic operation does not produce the expected results

. They include:

overflow, underflow, truncation and rounding errors

a> Overflow

These are errors that occur from a calculation which appear too large to be stored in the allocated memory space. e.g. if a byte is represented by 8 bits, an overflow will occur if the result of a calculation gives a 9-bit number.

b> Underflow

Underflow (or “floating point underflow”, or just “underflow”) is a condition in a computer program where the result of a calculation is a smaller number than the computer can actually store in memory.

Arithmetic underflow can occur when the true result of a floating point operation is smaller in magnitude (that is, closer to zero) than the smallest value representable as a normal floating point number in the target datatype.

Underflow can in part be regarded as negative overflow of the exponent of the floating point value.

For example, if the exponent part can represent values from −127 to 127, then a result with absolute value less than 2−127 may cause underflow.

c> Truncation

Truncation errors result from having real numbers that have a long fractional part which cannot fit in the allocated memory space.

The computer would truncate or cut off the extra characters from the fractional part For example, a number like 0.784969 can be truncated to four digits to become 0.784.

The resulting number is not rounded off.

d> Rounding

Rounding errors results from raising or lowering a digit in a real number to the required rounded number.

For example, to round off 30.666 to one decimal place, we raise the first digit after the decimal point if its successor is more than 5.

In this case, the successor is 6 therefore 30.666 rounded up to one decimal place is 30.7. If the successor is below 5, e.g. 30.635, we round down the number to 30.6.

3) Algorithm errors

An algorithm is a set of procedural steps followed to solve a given problem. Algorithms are used as design tools when writing programs.

Wrongly designed programs would result in a program that runs but gives erroneous output.

Such errors that result from wrong algorithm design are referred to as algorithm or logical errors.

Data Integrity

Data integrity refers to the correctness and completeness of data entered in a computer or received from the information system.

Integrity is measured in accuracy, timeliness and relevancy of data

A> Accuracy

This is how close an approximation is to an actual value. example: in a number like 34.247545, 34.2475 is more accurate than than 34.2 this is because the deviation on the former is much lesser than the latter.

B> Timeliness

This is the relative accuracy of data in respect to the current state of affairs for which it is needed. Information should be available on time for decision making.

For example: In a data base to prepare worker’s salaries, information on the presence of workers over the month should be processed on time before salary arrears are released every month.

C> Relevancy

Data entered into the computer must be relevant in order to get the expected output.

it must meet pertinent needs at hand and must meet the requirements of the processing cycle.

Way to minimize data integrity threats

1. Backup data on secondary storage devices or on online storage stores like Dropbox and Google Drive

2. Control access to data by enforcing security measures

3. Design user interfaces that minimize chances of invalid data entry

4. Using error detection and correction software when transmitting data

5. Using devices that directly capture data from the source such as bar code readers, digital cameras, optical character reader e.t.c.

Quiz

1. Define the following terms a) data processing b) data processing cycle

2. Using an illustration, describe the four primary stages of the data processing cycle

3. outline the stages of data collection

4. you may have come across the term garbage in garbage out (GIGO). what is its relevance to errors in data processing.

5. explain the two types of transcription errors

6. state three types of computational errors

7. a) define the term data integrity

b) give three factors that determine the integrity of data

C) state at least five ways of minimizing threats to data integrity.

3. Data Processing Methods

posted Jun 26, 2014, 7:08 AM by Maurice Nyamoti [ updated Feb 8, 2016, 4:52 PM ]

Data Processing Methods

Introduction:

There are three types of data processing methods namely:

1. Manual data processing

2. Mechanical data processing

3. Electronic Data Processing

Manual data processing

A paper and pen are used to process in manual data processing example:

Most schools in Kenya process their data manually especially while admitting form 1s.

As the students report, they are given a form to fill, these forms are filed by the school secretary and stored in the file cabinet- that is, if the school has 450 students, the school secretary will have those 450 files to handle thus retrieve, store, manipulate and update information which is a tedious job.

therefore manual data processing can also be defined as the physical entering and organization of data

Mechanical data processing

In mechanical data processing, data is processed with different mechanical devices.

This can include typewriters and calculators

Electronic Data Processing

Electronic Data Processing (EDP) can refer to the use of automated methods to process commercial data.

This means that, data processing, retrieval, storage, manipulation, sorting and part of analysis is done through automated methods using devices like computers.

Computer Files

A file can be defined as a collection of related records that give a complete set of information about a certain item or entity.

A computer file is a resource for storing information, which is available to a computer program and is usually based on some kind of durable storage.

Advantages of computerized/electronic filing system

1. Ease of access.

2. Speed of access.

3. Increased search facilities.

4. Capability to store huge amounts of information in a small space.

5. Portability – a pen drive or disc enables you to transport enormous amounts of data easily and discreetly.

6. Access to data can be monitored and/or restricted. thus enhancing data security

7. Its easier to update and modify information

8. Enhances data integrity and reduces duplication

Disadvantages of computerized/electronic filing system

1. Electrical/Electronic failure can cause temporary suspension of business or permanent loss of data.

2. Portability – copied information can be easily hidden on a disc or pen drive.

3. Data is not always secured by correct monitoring of access.

4. Information can be permanently deleted in error.

5. Hacking can release information that is data protected.

6. Cost of installing system.

Elements of a Computer File

A computer file is made up of three elements namely:

1. Characters

2. Fields

3. Records

Characters

A character refers to a letter, number or symbol that can be entered, stored and output by a computer.

This is the smallest element in a computer file.

Fields

A field is a single character or a collection of characters that represent a single entity Example:

Records

A record is a collection of related fields that represent a single entity.

Classification of Computer files

Computer files are classified as:

1. Logical files

2. Physical files

Logical Files

This is computer file viewed in terms of what data items it contains and details of what processing operations may be performed on the data items.

It does not have implementation specific information like field and data types, size and file types.

Physical Files

This is a computer file viewed in terms of how data is stored on a storage media and how the processing operations are made possible.

They have specific details such as characters per field and data type for each field.

Questions

1. State the three types of data processing methods

2. Define a computer file and state three advantages and three disadvantages of computer files

3. Define: (i) Character (ii) field (iii) record

4. Explain the two classifications of computer files

5. Distinguish between a manual file and a computer file

6. List at least three equipments used during mechanical data processing methods for processing

7. Why is a computer file described as ‘durable’?

3. Types of Computer Processing Files

Types of Computer Processing Files

There are various types of files used for storing data needed for processing, reference or backup. However the main common files include:

Master files, Transaction, Reference, Backup, Report and sort file.

Master File

A master file refers to a collection of records pertaining to one of the main subjects of an information system, such as customers, employees, products and vendors.

Transaction (movement) file

This is a collection of transaction records.

The data in transaction files is used to update the master files, which contain the data about the subjects of the organization (customers, employees, vendors, etc.).

Reference File

This file is normally used for reference or look-up purposes. Look up information is that information which is stored in a separate file but is required during processing.

Backup File

A backup file is used to hold copies (backups) of data or information from the computers fixed storage (hard disk)

Report File

A report file is used to store relatively permanent records extracted from the master file or generated after processing.

Sort File

A sort file stores data which is arranged in a particular order


2024 FORM 1 2 3 4 REVISION RESOURCES

  1. FORM 1 2 3 4 TERM 1 2 3 OPENER , MID AND END TERM EXAMS
  2. 1995-2024 KCSE KNEC PAPERS QUESTIONS,ANSWERS AND REPORT
  3. 2008-2024 KCSE FORM 4 COUNTY MOCKS
  4. FORM 1 2 3 4 SCHEMES OF WORK
  5. FORM 1 2 3 4 LESSON PLANS
  6. FORM 1 2 3 4 CLASS REVISION NOTES
  7. FORM 1 2 3 4 TERM 1 2 3 HOLIDAY ASSISNMENTS
  8. FORM 3 4 SETBOOKS STUDY GUIDES
  9. FORM 1 2 3 4 TOPICAL TESTS
  10. FORM 1 2 3 4 REVISION BOOKLETS
  11. LIFE SKILLS NOTES
  12. FORM 1 2 3 4 SYLLABUS
  13. KENYA SCHOOL CODES
  14. HOW TO REVISE AND PASS EXAMS
  15. GUIDANCE AND CONSELLING NOTES