Data and Information

DATA discipline 123424331911 Your winning lottery rag number 140593 Your examine of birth Aaabbbccd The grades you want in your GCSEs entropy and randomness Data, in pution & knowledge Data Data consist of raw facts and figures it does non put on any centre until it is processed and turned into something useful. It comes in umteen a(prenominal) forms, the main ones universe garners, numbers, images, symbols and sound. It is essential that breeding is available because it is the first criterion in creating meaningful cultivation.Ex 123424331911 140593 aaabbbccd, energy non mean anything by themselves, further if it is processed and turned into (the chart below) they turn into something useful. Information Information is knowledge that has beenprocessedin such a way as to bemeaningfulto the person who receives it. INFORMATION = DATA + CONTEXT + MEANING INFORMATION = DATA + CONTEXT + MEANING congresswoman of information DATA 21041926 This has no meaning or context CONTEXT It is a British naming stamp This allows us to register it as 21st April 1926.It still has no meaning and is therefore non information MEANING The Birth get a line of pantywaist 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 truly acid water. Data gathered Finger nerves sends pain info to the brain. Processing in heraldect considers the entropy and comes up with Information Painful finger actor it is not in a good place.Action Brain tells finger to remove itself from hot water. Knowledge Sticking finger in hot water is a bad thinker. Knowledge is having an understanding of the rules Types of information Data trick be stash awayd in many different formats called information eccentric persons. When setting up a informationbase or spreadsheet, it is important that the correct information type is selected for each field. This is because the info type abjure alone determine what offer be done with the entropy held in that field e. g. sorting, searching, calculations and so forth It similarly provide determine the format in which data is displayed e. g. date/ sentence data type get fall out allow you to patch 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 go intoed. e. g. When you use a date/ beat data type and so each date allow for be mechanically specifyed to ensure that it brook actually exist. For exercise, you would not be able to see the date 31/02/2008 it would automatically be rejected or return an faulting message. Types of data * Text * Number * Boolean * Date/Time * Image Text A text data type can hold any letter, number, symbol or punctuation mark mark.It is some times referre d to as alphanumeric or string. The data can be pristine text or a combination of text, numbers and symbols. * Name Joe Bloggs * trade 101, Any Street That Town TR34 9RT * Telephone Number 01234 567890 * Car alteration EA05 NXR * Car ColourBlue Telephone numbers gather up to be stored as a text/string data type because they often begin with a 0 and if they were stored as an integer and so the leading zero would be discounted. You are never likely to want to add or manifold 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 verifying or negative. Integers however cannot store numbers with decimal places. * Real Your quantitative data aptitude conveyiness to be formatted with decimal places. This means it cannot be stored as an integer number. Instead it is known as arealnumber. You can specify the number of decimal places that you subscribe to. * Currency When you choose to format mathematical data as coin thus it will automatically be given two 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 manse 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 exercising * Yes/no * True/false * 0/1 A Boolean data type is use to solution 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 / Time A date / ti me data type is used to store any data that is related to date or time. The tricky thing ab by date / time is that there are so many ways of demonstrate it. And some countries project a different way of representing a date. For simulation * 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 separate 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. diverse file types such as . bmp, . jpg, . tiff can be storedQua lity of information Things that affect the quality of information Accuracy If the data that you have compile is in hi-fi then the information it will produce will needfully also be inaccurate. Examples of how innacurate data occurs Questionnaries and surveys * questions might be poorly termed so that users misunderstand them * there may not have been enough concourse interviewed for any conclusions to be reliable. For example, asking just two tidy sum is not likely to be enough Human mistakes * if people are appeal the data manually e. g. ecording answers to questionnaires, writing down instrument measurements, they might figure out 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 in good gild calibrated at the start of the data collection period Examples of information which would be of little use if it was inaccurate Weather thinks Many people check the weather condition project each 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 order to harbor decisions.Supermarket prices When you go to a shop you probably know how much bullion 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 entering the price details into the transcription has accidentally overpriced a meet of items, then this could mean that you dont have enough money 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 strain a mistake and dont accurately entera ll of the money genuine then it could look like the alliance has not made as much profit that year. Or they havent recorded all the bills so it seems that the com pany is making more than money tan it really is Relevance In order for information to be useful it must be pertinent to you. School You have a groovy deal of information to take aim 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 active if your teachers stubborn to spend a few weeks teaching you about things that spark officularly fire them? What they had taught you might have been actually interesting to both them and you but it isnt relevant to what you needed 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 workaday life.It wont help you decide whether you need to take an umbrella with you before you leave home in the UK. cooks appointments You might be sense un soundly and want to make an appointment to see your doctor. You phone up the local surgery to find out when the doctor has a complimentary 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 nursing home. 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 dissociate 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 fin 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 old age old. How useful are the model answers for questions such as which storage wile 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 past 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. why?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 cutting-edge information House prices Your parents are still thinking of selling their 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 poll leave? Your teacher wanted you to work your way through them and check your answers against the model answers. What if you were save 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 exactly told what the weather in the morning will be like. thither is nothing about the afternoon.You cant really make a decision just based upon what the morning weather is likely to be. Doctors appointment Imagine you are feeling ill and you need to make a n 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 presentment 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 alike 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 at once if the house would appeal to them and whether they would be interested in finding out more. Once they have decided they 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 knotty for them to get an idea as to whether they would like it. as well as mucho or excessively 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 overpower 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 congress 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 eggs and for exatly how many seconds you need to fold in the fluor MethodTelling you to mix the ingredients u nneurotic but not informing you of the correct order in which to flow them CookingTelling you the exact amount of minutes that the cake should be baked for every 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 cryptogram of data When you are innovation a database establishment 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 work out 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, entered 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 potent and Female. Example 1 Original data Monday Tuesday espousenesday Thursday Friday Coded data Mon Tues Wed Thurs Fri Example 2 Original data Xtra Large Large moderate Small Coded data XL L M S Example 3 The above codes are fairly easy for anyone to recognise and understand. almost 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. Ex ample 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 correspond Skirt and TR represented Trousers The middle part of the code was the dress size. The last(a) 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? some(prenominal) 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 speech 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 entering 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 likely six will speed up data entry. It will also cut down on the risk of mistakes being made with spelling. work of validation In our example, the words Male or Female have been coded so that they rick M or F. When data has been coded it makes it easier to use validation to check if the data entered is sensible. 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 f ield will only accept the letters M or F and absolutely nothing else then that should further cut down on possible 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 to the lowest degree 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 e veryday 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