Topic 4  Processing Data

Knowledge, Information, and Data

A piece of data is a simple raw fact that reflects a particular event, e.g.,

A single data item on its own is meaningless.  Consider the number 256.  256 what?  Cars on the A19?  Pink elephants?  Let’s put it with some other numbers:

            256, 294, 330, 349, 392, 440, 494, 512.

Even if you knew that these data items were related, they would still be meaningless.  They would be more meaningful if you put them into the context of frequencies in Hertz.  But not many people would understand the significance.  If you were to represent them as:

Musicians would immediately recognise this as the scale of C major, and would put a name to each note, i.e. C, D, E, F, G, A, B, C.

Information is the collection of a series of related pieces of data processed into a coherent and understandable form:

 Question 1

Write down what processing can be done to turn the following data items into information.  One has been done as an example.                                    

Data Item

Information

 

Stock items

Number multiplied by price of each gives total value

 

Temperature readings

 

Customer’s transactions

 

 

Time off work

 

 ANSWER

Knowledge is really the way that we respond to information.  The facts and figures help us to function, but it’s not the whole answer.  We have knowledge that stems from rules, the likely effects of certain courses of action:

In ICT we refer to knowledge as how information given out by computers is used to make decisions.

Knowledge from the information gained from processed data can help us to:

Question 2 Write down two ways in which information from an ICT system can be used as knowledge from which a decision can be made.  ANSWER

Professional people are those whose specialist knowledge gives them the expertise to provide services and make decisions on a wealth of formal and informal facts and rules gained through years of training and experience.

Wisdom can be thought of as the constructive use of one’s knowledge and experience to the benefit of others, possibly to the disadvantage to oneself.  Remember also:

  A little bit of knowledge is a very dangerous thing.

Computers can help us immensely by processing data very rapidly to give us information.  We then have to use our knowledge to help us to process the information.  Computers have no knowledge at all.  They are adding machines that can tell the difference between ON and OFF.  True, they can do amazing things.  For about £50 you can buy a flight simulator that you can use to fly from any airport in the world to any other, and you can see the scenery in between.  Indeed some flying organisations use it for their basic pilot training.  If you crash a plane, it doesn’t matter!  However, computers do not think, nor do they know anything.  They are electronic filing cabinets and adding machines.  Even the CRAY Supercomputer is an adding machine that can add up like greased lightning.

Question 3 Explain why a simulator can help a new pilot to train.  ANSWER

 

Collection of Data

We can collect data directly:

This is often called data capture.

Data can be collected indirectly.  It is used for a purpose other than the original purpose.  For example, the transaction data for a credit card holder can be used to build up a profile of the customer.  The bank sells details of the customer to companies that market products and services that the customer is most likely to use.

It is obviously important that the data is accurate, up-to-date, and complete, but we can think of occasions when it has not been.  This might lead to

Question 4.  What do you understand by poor quality data?  Give examples to illustrate your answer.  ANSWER

Keeping data so that it is high quality is important to a business.  Mistakes can be expensive; an annoyed customer will take her trade elsewhere.  However the maintenance of data is an ongoing and expensive activity:

  An insurance broker would be keen to give the best rates possible for his clients.  He will have a database with all the insurers he uses.  However they are changing rates and products all the time, so to keep abreast, he will have to have someone constantly updating the database.

A current radio advert starts:

"I am Michelle.  I am Michelle. I am 37. I am 44.  I am happily married.  I have recently divorced.  I am a home maker.  I work for an industrial die manufacturer in Reading..."

The company whose radio advert this is makes its living by making sure that the databases of large organisations are kept up to date.  While addressing a letter to Michelle and her ex might not be the biggest disaster in the world, it would probably cause Michelle no end of annoyance.  Annoyed customers will take their trade elsewhere.

Question 5  Explain why the maintenance of company databases is expensive.  ANSWER

Any subjective description of something is based on a value judgement.  Some people might describe another person as “rude and bad-mannered”, whereas others might describe the same person as “good laugh”.  One person might gain a lot from a particular computing lesson; for another it could be a complete turn off. Questionnaires try to code value judgements.  You tick boxes marked from Excellent to Very Poor.  This can be difficult, especially when you are asked to tick one box only, but your judgement lies between two boxes!

This is an example:

Information as a Commodity

Poor information can lead to loss in sales or failure to satisfy demand.  Accurate sales predictions can lead to good profits; accurate prediction depends on accurate information.  Stores can analyse the buying patterns of certain groups of customers by monitoring loyalty cards.  For example, it has been found that on a Friday evening, men between 20 and 40 were buying disposable nappies.  Cans of beer were located near to the nappies and sales of beer rocketed!

Analysis of purchasing patterns of customers can allow companies to target information about appropriate products that might be of interest to a particular individual:

Question 6.  Explain how a supermarket chain might use ICT to target products to different kinds of customer.  ANSWER

If a company gets it wrong, at best they will look stupid.  Products addressed to dead people are especially distressing.  Getting it right is particularly important to companies that sell products by direct mail.  They regularly update their information or purchase updated information.

Many companies and charities sell their information, e.g. mailing lists, on to other companies to make use of it, and this is a regular source of income.  This is how companies get your address to bombard you with junk mail.  Some people love junk mail; most of us loathe it!

Question 7. Give two ways in which bad information can damage a company’s image.  ANSWER

 

Control of Information

Personal data on individuals can be held by many organisations:

A very detailed profile of an individual can be accessed from anywhere in the world and can be used (or misused).  It does not take a genius to see that the storage of such data can result in an invasion of our privacy, which is a fundamental right, which we take for granted.  Furthermore, incorrect data has resulted for some individuals in considerable distress or inconvenience.

The use of data is governed by the Data Protection Act 1984.  Further legislation grants you the opportunity to prevent your details being passed on.  On registration and similar forms used to provide information, there is a tick box to this effect.

It is clear that you don’t want any old Tom, Dick, or Harry getting access to your personal files.  There are lots of ways to protect the integrity and security of data.  We need to protect against:

Standard clerical procedures will help to maintain the quality of data by prevention of:

This is achieved by:

  Security of data is ensured by:

Program errors can corrupt files.  These might be already in the program and not surface for some time.  Or they could be introduced during maintenance.

Question 8  Describe three things that can happen to data that can make it wrong and suggest ways in which each of the faults can be corrected.  ANSWER

By law you are entitled to see certain kinds of data that is held on you, for example credit ratings.  You are asked to pay a small fee (£1) for access.  You may also view your medical records, although often the local health trust does not exactly go out of its way to help you.  Some data is kept confidential within an organisation, and gaining access to it can be difficult.  Some data will never be revealed, including:

Data is a valuable commodity and is bought by many commercial organisations to target potential customers.

 

Computer Coded Information ASCII – Number storage

Computers cannot do anything other than adding two binary numbers.  They cannot:

The arithmetical processes of subtraction, multiplication, and division are done by complimentary addition, repeated addition, and a combination of repeated complimentary addition respectively.  We will not discuss the process here, although you may wish to find out more as an extension.

Computers recognise alphanumeric (letters, numbers and punctuation) characters by the ASCII (pronounced “as-key”) codes.  ASCII stands for American Standard Codes for Information Interchange.  You will find a table of these in Heathcote.  You are expected to know of their existence, but not what they are.  Here are a few selected at random:

Code

Decimal

Character

0100001

33

!

1000100

68

D

1100100

100

d

1111110

254

~ (a tilde)

All PCs use ASCII.  Some old mainframes (huge and antique computers that are still used by some large companies) use another code called EBCDIC (Extended Binary Coded Decimal Interchange Code).  The two are different and there needs to be interpretation between the two codes.  It’s a bit like the character codes we use to read and write.  We use Roman Script; in Greek letters it looks like Roman Script.

The standard ASCII codes are those that are offered on an ordinary typewriter.  There are others such as the copyright symbol, ©, that form part of the extended ASCII code.

Question 9  A password is case sensitive.  Describe how the computer might recognise the difference between two passwords, "LetMeIn" and "letmein"  ANSWER

Sound and Graphics

Computer programmers have enabled adding machines to do some pretty amazing things:

The sounds and sights that we see are analogue signals, which can have any value you like.  Computers work on digital signals, ON and OFF.  Therefore signals have to be converted from analogue to digital and vice versa.  This is done with analogue to digital converters and digital to analogue converters.  A university level electronics course is the place to discuss how they work.

All these functions need separate processors, computers in their own right.  We buy these as:

All the data is processed as binary numbers.  A colour can be represented as a binary number.  The simplest is 2-bit (bit is a binary digit) which gives black and white.  Then there is 4-bit, which gives 16 colours.  This was used by the early PC’s.  Eight bits gives 256 colours, quite a reasonable palette.

Most modern video cards are 64-bit, which means that each colour is coded by a 64 digit binary number.  This means that there is a very large number (264) of combinations available.  There are some that are 128-bit, enabling virtually any colour you like.

When you are word-processing, the video card converts the codes into letters, but the operating system produces the font.  The word processor “calls on” the font.

Question 10 Describe how the computer processes colours and sounds.  ANSWER

Now try the Topic Quiz

Home                ICT AS                  Module 1 Topics