Data and Information

DATA reading 123424331911 Your winning lottery ticket derive 140593 Your epoch of birth Aaabbbccd The grades you want in your GCSEs info and training Data, in arrangeion & knowledge Data Data consist of raw facts and figures it does non return any marrow until it is processed and turned into something useful. It comes in umpteen forms, the main ones organism letters, numbers, images, symbols and sound. It is essential that entropy is available because it is the first tone of voice in creating meaningful randomness.Ex 123424331911 140593 aaabbbccd, capability non mean anything by themselves, exclusively if it is processed and turned into (the chart below) they turn into something useful. Information Information is info that has beenprocessedin such a way as to bemeaningfulto the person who receives it. INFORMATION = DATA + CONTEXT + MEANING INFORMATION = DATA + CONTEXT + MEANING sample of discipline DATA 21041926 This has no meaning or context CONTEXT It is a Br itish picture This allows us to register it as 21st April 1926.It still has no meaning and is therefore non instruction MEANING The Birth see to it of cig art Elizabeth II This gives usa ll the elements required dor it to be called information friendship Knowledge is the ability of understanding the relationship between pieces of information and what to actually do with the information. Consider this scenarioPerson puts a finger into in truth tropical water. Data gathered Finger nerves sends pain info to the brain. Processing conceiver considers the entropy and comes up with Information Painful finger manner it is not in a good place.Action Brain verbalises finger to remove itself from hot water. Knowledge Sticking finger in hot water is a bad predilection. Knowledge is having an understanding of the rules Types of selective information Data behind be retentiond in many a(prenominal) different formats called entropy typewrites. When setting up a infobase or spread sheet, it is important that the correct entropy type is selected for each field. This is because the selective information type go forth determine what lavatory be done with the data held in that field e. g. sorting, searching, calculations and so forth It excessively crumb determine the format in which data is displayed e. g. single come forwardicular date/ eon data type ordain allow you to select the format of your choice, 14/05/08, 14 May 2008, fourteenth May 2008 etc. Finally, some data types are able to mechanically validate the data being move ined. e. g. When you use a date/ beat data type thus each date will be automatically totaled to ensure that it rotter actually exist. For illustration, you would not be able to read the date 31/02/2008 it would automatically be spurned or return an geological fault message. Types of data * Text * Number * Boolean * Date/Time * Image Text A text data type can hold any letter, number, symbol or punctuation mark.It is some periods referred to as alphanumeric or string. The data can be slender text or a combination of text, numbers and symbols. * Name Joe Bloggs * distribute 101, Any Street That Town TR34 9RT * Telephone Number 01234 567890 * Car readjustment EA05 NXR * Car ColourBlue Telephone numbers remove to be stored as a text/string data type because they often begin with a 0 and if they were stored as an integer accordinglyce the leading zero would be discounted. You are never likely to want to add or calculate telephone numbers so there is no reason to store it as an integer data type. Number A number data type contains numbers.Example * Weight in Kg12. 25, 19. 99, 199. 99 * Room measurement in metres14. 5 * Temperature (degrees Celsius)37. 5 Types of numbers * Integers An integer stores whole numbers, either authoritative or negative. Integers however cannot store numbers with decimal places. * Real Your numeral data readiness bespeak to be formatted with decimal places. This mea ns it cannot be stored as an integer number. Instead it is known as arealnumber. You can specify the number of decimal places that you film. * Currency When you choose to format numeral data as coin then it will automatically be given twain decimal places.However, you can choose to format currency with 0 dp because in some circumstances it would not be appropriate to display the pence. Think of an estate agent, they efficiency sell a menage for ? 295,000. It would look daft displayed as ? 295,000. 00. The currency data type also allows you to display the correct currency symbol such as ? or $. Boolean Boolean data holds one of two values, for instance * Yes/no * True/false * 0/1 A Boolean data type is utilise to wait on questions where there are exactly two options, three options would mean it was no longer boolean data.Examples of questions where the responses would be stored as boolean data * Has the heating been turned on? Yes / No * Are you employed? Yes / No Data / T ime A date / time data type is used to store any data that is related to date or time. The tricky thing ab expose date / time is that there are so many ways of show it. And some countries piddle a different way of representing a date. For manakin * 9/4/94 in the USA means quaternate Sept 94 * 9/4/94 in the UK means 9th April 94 By using a date /time data type, you can choose the format for how you want your data to be automatically displayed.For example 14/05/08, 14 May 2008, 14th May 2008 etc. An other reason to use a date /time data type is that it can provide some basic validation on the data being entered. For example, you would not be able to enter the date 31/02/2008 it would automatically be rejected or return an error message. Image Databases allow graphical images such as photographs to be stored as a data type. Images are binary files rather than text or numbers which is why a specific data type is required. varied file types such as . bmp, . jpg, . tiff can be store dQuality of information Things that affect the quality of information Accuracy If the data that you have self-possessed is in high-fidelity then the information it will produce will unavoidably also be inaccurate. Examples of how innacurate data occurs Questionnaries and surveys * questions might be poorly developed so that users misunderstand them * there may not have been enough pack interviewed for any conclusions to be reliable. For example, asking just two mess is not likely to be enough Human slips * if people are compendium the data manually e. g. ecording answers to questionnaires, writing down instrument measurements, they might diagnose a mistake. Calibration of instruments * if data is being collected automatically by sensors or other instruments then the results could be inaccurate if the instruments were not decently calibrated at the start of the data collection period Examples of information which would be of little use if it was inaccurate Weather auspicate s Many people check the survive call each solar day so that they can get an idea of what to wear. People have to have faith that the forecast will be reasonably accurate in commit to shed light on decisions.Supermarket prices When you go to a shop you probably know how much coin you have to spend. You chek the prices of things you are buying on the shelves and will have an idea of how much it will cost by the time you have reached the till. If the peson get into the price details into the remains has accidentally overpriced a couple on of items, then this could mean that you dont have enough capital to pay for shopping and have to put something back. Businesses Businesses have to keep accurate records of all the money coming in and all of the money being paid out.If the accountants get under ones skin a mistake and dont accurately entera ll of the money authorized then it could look like the gild has not made as much profit that year. Or they havent recorded all the bil ls so it seems that the company is making more(prenominal) money tan it really is Relevance In order for information to be useful it must be applicable to you. School You have a groovy deal of information to go steady for each of your exams. Each time you go to littleons you probably take a lot of notes and perhaps are given handouts by your teachers to read.What approximately if your teachers determined to spend a few weeks teaching you about things that musical compositionicularly enkindle them? What they had taught you might have been in truth interesting to both them and you but it isnt pertinent to what you needinessed at the time. You would find that you had spent a few very precious weeks learning about things that you didnt need to know in order to pass your exam. Weather forecasts Whilst it might be interesting to find out what the weather is like in Florida or Melbourne today, it isnt really relevant to your frequent life.It wont help you decide whether you ne ed to take an umbrella with you before you fall in home in the UK. stretchs appointments You might be savor un easily and want to make an appointment to see your doctor. You phone up the local surgery to find out when the doctor has a unsheathed appointment time. It wouldnt be very useful or relevant to you if the receptionist told you how many appointment times were available to see the nurse. House prices Perhaps your parents might be thinking of moving stand. The first thing they would do would be to speak to an estate agent to find out how much their house was worth.It wouldnt be useful or relevant if the estate agent were to tell them how a similar house in a different part of the country might be worth. Up to date information In order to be useful, information needs to be up to date. In many cases information changes over time and so old or out of date information can be misleading or quintuplet you the wrong picture of what is happening. Exams As part of your revision, you have a go at practicing lots of exam questions before the big day and you work your way through the practice papers and model answers that your teacher has given you.However, some of the papers are over five historic period old. How useful are the model answers for questions such as which storage catch would you recommend? and what is the average size of a hard disk? It is well known that things move very quickly in the world of ICT and hardware and software changes rapidly. What was a top-notch computer just three years ago is now probably a very low-spec machine. So the model answers are likely to be out-of-date. Holidays Choosing a holiday can be great fun. And you would probably go to the travel agent to get the latest brochures. wherefore?Well, because if you used last years brochures the holiday may not even be available any more. And certainly the prices would be different. So you need current information House prices Your parents are still thinking of selling the ir house. They need an idea of how much their house is worth right now. It would be no use to them being told by the estate agent how much their house was worth five years ago. Completeness In order for information to be useful it needs to be complete. If part of the information is missing then you will not be able to make use of it or make accurate decisions.Exams Remember those exam papers that you were doing for revision during your hit the books leave? Your teacher wanted you to work your way through them and check your answers against the model answers. What if you were sole(prenominal) given the second half of the model answer and the first half was missing? How useful would it be to you? Weather forecast You still want to plan the family picnic for tomorrow. However when you check the weather forecast you are hardly told what the weather in the morning will be like. at that place is nothing about the afternoon.You cant really make a decision just based upon what the morni ng weather is likely to be. Doctors appointment Imagine you are feeling ill and you need to make an appointment to see your doctor. How useful would it be if the receptionist just told you that you could have an appointment at quarter past two? Does she mean today, tomorrow or next week? The information in incomplete. Quality of presentation Information which is presented in a disorganised way or in a manner that is hard to understand will be less useful to you Business dataIf you were asked to present some information in a business meeting. It is often better to present it graphically. People find it very hard to spot patterns in a table of data, but the analogous information presented as a graph makes it very easy. Buying a house Your parents want to buy a new house. It is much easier to pick a house if a photograph was available. Your parents can see forthwith if the house would appeal to them and whether they would be interested in finding out more. Once they have decided the y like the look of the house they would then want more detailed written information.However, giving them the written information first with no idea of what the house looks like would make it hard for them to get an idea as to whether they would like it. excessively mucho or to a fault litle detail For information to be useful you need the right amout of detail. There is a risk of having too much detail which makes the information overtake and difficult to extract the bits that you want to know about. Or there might not be enough detail in which case you rule understand the full picture. Example baking a cake Too much detail Not enough detailIngredients Not only telling you that you need fluorite, but telling you all of the different brands of fluor and how the choice of each one would affect the rising of your cake Ingredients revealing you that you need fluor but not the quantity you will need to weigh ouy MethodTelling you exactly how many times you need to beat the bombar d and for exatly how many seconds you need to fold in the fluor MethodTelling you to mix the ingredients unitedly but not informing you of the correct order in which to admit them CookingTelling you the exact amount of minutes that the cake should be baked for any type of oven that is currently for sale CookingTelling you the temperatura to cook the cake but not how long to leave it in the oven for code of data When you are plan a database brass to hold data, one of the first decisions that you will need to make is about how the data will be collected and stored. You already know the term GIGO (Garbage In Garbage Out).If you collect data and enter it into the system without careful consideration at the planning stage then the output from your system will be of little use. One of the things that you can consider is to commandment some or all of your data in order to improve the efficiency of your system. What is coding of data? Any system will need to have data collected, ente red and stored. One method of storing data is to assign codes to it. This usually means shortening the original data in an agreed manner. The agreement is between the users of the system. This coding scheme could be part of the training of how to use the system, and it could also be documented within the system for new users.If the coding is completely obvious then there is no such need for formal documentation. For example if a field called Gender has only two values M and F. It should be obvious from the field name that this refers to young-begetting(prenominal) and Female. Example 1 Original data Monday Tuesday wednesday Thursday Friday Coded data Mon Tues Wed Thurs Fri Example 2 Original data Xtra Large Large strong point Small Coded data XL L M S Example 3 The above codes are fairly easy for anyone to recognise and understand. many codes however are more complicated. What do you think the following codes might represent? RG935LR CV183TP The above examples could be postcodes. They represent a street name, a particular part of the street and the town where the street is located. Example 4 How about SK12BN TR14GN These might be a little bit more difficult because the code is made up from different representative parts. Lets have a closer look. The first part represents a piece of clothing, so SK represented Skirt and TR represented Trousers The middle part of the code was the dress size. The nett part of the code represented a colour, so BN represented Brown and GN represented Green. You should be able to see from that information that the first code is a size 12 brown skirt. What piece of clothing would the second code represent? Why might we want to code data? a good deal of the data that we collected and enter into our systems has some degree of repetition. Speeding up data entry Lets take the example of collecting data about a persons gender. People can be either Male or Female. Whilst these two options are easily understood by all, imagine having to enter the word Male and Female into a system many hundreds of times instead. It is a waste of time and effort because no extra information is contained in the full actors line compared to a single letter. Increase accuracy of data entry The other issue is that no matter how accurate a person is at data entry, at some stage they are likely to make a mistake and might spell Male as Mail or Female as Femal.This type of mistake will make any results from your database queries unreliable. Instead of introduction Male or Female you could code the data and instead enter it as M or F. Simply having to enter one letter instead of a realizable six will speed up data entry. It will also cut down on the risk of mistakes being made with spelling. utilise of validation In our example, the words Male or Female have been coded so that they give way M or F. When data has been coded it makes it easier to use validation to check if the data entered is certain. With the example above, the person entering the data could still make a mistake and enter S instead of M or F.But if you set up validation so that the field will only accept the letters M or F and absolutely nothing else then that should further cut down on viable mistakes. Note that validation can only check if the data is sensible and within reasonable limits, it cannot check whether the data is accurate. Somebody could still enter F instead of M. Less storage space required Every letter that you store in your database system will take at least(prenominal) one byte of storage. If you store Female as F then you will save five bytes of storage space. If the system belongs to a large organisation, there might be many thousands or millions of records stored simply by coding one field, a huge amount of hard disk storage can be saved. Faster searching for dataIt stands to reason that the smaller the size of your database, the faster it will be to search and produce results. Thus by coding data and keeping the size of the system to a minimum the more time you can save in the long run when running queries. Coding examples In our everyday lives we come across many examples of how coding is used to represent data. Here are just a few more ideas Country names The name of a country can be represented by two letters. For example Great Britain GB France FR Canada CA Problems caused by coding data Whilst coding data can bring many benefits it can also lead to some problems. Coarsening of data This means that during the coding process some of the subtle details in the data are lost. Look at the image below