Introduction

Unit 1

Unit 2

 

 

 

 

2. Data & Information

Key Concepts Content and Amplification
1. Data Define data.
How data can arise.
Data can be in different forms including text, still and moving images, numbers and sound.
The need to code data on collection to enable effective processing.
The need to encode data on input to an ICT system.
2. Data is processed to produce information Processing is required to enable information to be
produced from data.
3. Information Define information.
Factors that affect the quality of information.


1. Data. Data is raw facts and figures. A birthday date is data, but it doesn't mean very much without having the person's details whose birthday it is. An address can be made up of a number of parts - a house number, a street, a postcode, each part doesn't mean very much without all of the pieces together. Data can take the form of a number, a date, a word, an image, a clip of film, or a piece of sound.

How might Data arise? Data will come from a number of different sources in different forms.

  • a new employees address and bank details have to be typed into the organisation's,
  • a high street survey into what brands of washing powder is used by housewives,
  • a test on the efficiency of a new aeroplane wing design in a wind tunnel,
  • a person withdrawing cash from an Automated Teller Machine (ATM),
  • an image of a suspicious person recorded from a high street camera,
  • a sensor that records the amount of pollutants in the atmosphere every second,
  • a result of a first process that is used for another process.

Encoding data means that it has been put into a specified format relating to the type of the data. This means that it is a much more efficient way for the computer to use it , being processing data, transmitting and receiving data, or storing data. All computers ultimately transfer all data and encoded data into binary code before it can perform any processing. The binary code will be shorter if data has already been encoded thus enabling faster processing and transmission.

Examples of encoding:

  • sound files;
    • AAC: Compressed audio file similar to a .MP3 file, but offers several performance improvements; examples include a higher coding efficiency for both stationary and transient signals, a simpler filterbank, and better handling of frequencies above 16 kHz; maintains quality nearly indistinguishable from the original audio source.
      AIF
      : CD-quality audio file, similar to a .WAV file; developed by Apple Computer.
    • M3U: playlists are typically used for audio playlists, but some may also include references to video files,
    • MIDI: Standard MIDI (Musical Instrument Digital Interface) file; contains music data such as what notes are played, when they are played, how long each note is held, and the loudness (velocity) of each note.
    • MP3: Compressed audio format developed by the Moving Picture Experts Group; uses "Layer 3" audio compression; commonly used to store music files and audiobooks on a hard drive; may provide near-CD quality sound (stereo, 16-bit) in a file roughtly 1/10 the size of a .WAV or .AIF file.
    • MPA: Compressed audio file using MPEG Layer I, II or III compression.
    • WAV: Standard digital audio file format for storing waveform data; allows audio recordings to be saved with different sampling rates and bitrates; often used to save CD-quality audio.
    • WMA: Audio file compressed with Windows Media compression; proprietary format developed by Microsoft, similar to the .MP3 format; can be converted to other more standardized formats; often used for playing music from the Web.
  • image files;
    • BMP: Uncompressed raster image made up of a rectangular grid of pixels; each pixel is a different color (or level of gray for grayscale images), which together form an image; zooming in on a bitmap image will make it appear blocky since the size of each pixel increases.
    • DRW: Generic drawing format used by several different programs; stores image data in a vector format, which uses lines and directions to represent the image instead of dots.
    • GIF: Image file that may contain up to 256 indexed colors; color palette may be a predefined set of colors or may be adapted to the colors in the image; lossless format, meaning the clarity of the image is not compromised with GIF compression.
    • JPG: Compressed graphic format standarized by the JPEG (Joint Photographic Experts Group); supports up to 24-bit color, which makes JPEG a good format for storing digital photos; compressed using lossy compression, which may noticeably reduce the image quality if high amounts of compression are used. JPEG images are commonly used for Web graphics and for storing photos taken with a digital camera.
    • PDF: Cross-platform document created by Adobe Acrobat or a program with the Acrobat plug-in; commonly used for e-mail attachments or for saving publications in a standard format for viewing on mulitple computers; usually created from another document instead of from scratch. May contain text, images, forms, annotations, outlines, and other data; preserves fonts and formatting electronically across multiple platforms; appears on the screen as it will when printed on paper.
    • PNG: Image format that uses indexed colors and lossless compression (like a .GIF file), but without copyright limitations.
    • PSD: Document created by Adobe Photoshop, the most commonly used professional image editing program; can include image layers, adjustment layers, layer masks, annotation notes, file information, keywords, and other Photoshop-specific elements.
    • PSP: Color bitmap image saved in Paint Shop Pro format; may include layers, guides, vector paths, metadata, and other objects within the image file.
    • QXP: QuarkXpress project file created by QuarkXpress version 6 and later; contains page layout information, text, and images; may consist of a single page or multiple pages.
    • TIF: High-quality graphics format often used for storing images with many colors, such as digital photos; includes support for layers and pages.
  • video files;
    • AVI: Video container or wrapper format created by Microsoft; stores video data that may be encoded in a variety of codecs; typically uses less compression than similar formats such as .MPEG and .MOV.
    • MOV: Common multimedia format often used for saving movies and other video files; uses a proprietary compression algorithm developed by Apple Computer; compatible with both Macintosh and Windows platforms.
    • MP4: Movie or video clip that uses MPEG-4 compression, a standard developed by the Moving Picture Experts Group (MPEG); commonly used for sharing video files on the Internet. The MPEG-4 video format uses separate compression for audio and video tracks; video is compressed with MPEG-4 video encoding; audio is compressed using AAC compression, the same type of audio compression used in .AAC files.
    • MPG: Common video format standardized by the Moving Picture Experts Group (MPEG); typically incorporates MPEG-1 or MPEG-2 audio and video compression; often used for creating downloadable movies.
    • RM: Media file format used by RealPlayer; may contain audio or video data or both; can be a downloaded file or a streaming media file, which is played back as it is downloaded.
    • SWF: Animation created by Adobe Flash (formerly Macromedia Flash); can include text as well as both vector and raster graphics; plays in Web browsers that have the Flash plug-in installed; most Web browsers come with a recent version of the Flash plug-in.
    • WMV: Video or audio file based on the Microsoft Advanced Systems Format (ASF) container format and compressed with Windows Media compression; basically an .ASF file that is encoded using the Windows Media Video (WMV) codec.
  • text files;
    • ASCII: Stands for "American Standard Code for Information Interchange." ASCII is the universal standard for the numerical codes computers use to represent all upper and lower-case letters, numbers, and puctuation. Without ASCII, each type of computer would use a different way of representing letters and numbers, causing major chaos for computer programmers. Data from the keyboard is coded in Binary, but using a special code of 8 Bits, known as a Byte (Bit is a binary 0 or 1; a Byte is a collection of 8 Bits). For example capital A is represented as 0100 0001.
    • DOC: Word processing document created by Microsoft Word, the most popular word processing program; included with all versions of Microsoft Office; may contain formatted text, images, tables, graphs, charts, page formatting, and print settings.
    • DOCX: Word processing format introduced with Microsoft Word 2007 (part of Office 12); based on Open XML and uses ZIP compression for smaller file sizes.
    • RTF: Common text file format that supports "rich text;" may include several types of text formatting, such as bold type, italics, different fonts and font sizes, custom tab settings, etc; may also support images saved within the text file.
    • SMS: A group of SMS text messages exported from a Sony Ericsson cell phone; saved in a text format that can be viewed with cell phone software or a basic text editor.
    • TXT: Standard text document that contains unformatted text; recognized by any text editing or word processing program; can also be processed by most other software programs.
    • WPS: Text document created with Microsoft Works Word Processor; similar to Microsoft Word (.DOC) document, but does not include advanced formatting options and macros that a Word document may contain.
  • data files;
    • DLL: Text document created with Microsoft Works Word Processor; similar to Microsoft Word (.DOC) document, but does not include advanced formatting options and macros that a Word document may contain.
    • MDB: Database file created by Microsoft Access, one of the most widely-used database programs; contains database content as well as tables, forms, queries, etc.
    • PPT: Editable slide show created with Microsoft PowerPoint; often used for creating presentations; may include formatted text, bullet points, images, movies, sound effects, and other audio files; often built from one of many templates included with the PowerPoint software.
    • SQL: Database file written in SQL (Structured Query Language); can be read by any SQL-compatible database program, such as FileMaker, MS Access, or MySQL.
    • XMS: Spreadsheet file created by Microsoft Excel, the most widely-used spreadsheet program; stores data in a table with rows and columns; table cells can contain manually entered data or the results computed from the data of other cells; can also be used to create charts and graphs.
  • web files;
    • HTM: HTML Web page that contains code which displays and formats text and images in a Web browser; ".htm" is the extension typically used by Microsoft FrontPage or newer Microsoft Web development programs such as SharePoint Designer and Expression Web.
    • HTML: Web page coded in HTML that can be displayed in a Web browser; formats text, tables, images, and other content that is displayed on the page; HTML source code is parsed by the Web browser and typically not seen by the user.The raw HTML source code can be viewed by choosing "View Source" from the Web browser's view menu or by opening the HTML file in a text editor.
    • JS: Text file containing JavaScript code; used to execute JavaScript instructions in Web pages; may include functions that open and close windows, validate form fields, enable rollover images, or create drop-down menus.
  • system files;
    • DRV: Allows certain hardware devices (both internal and external) to be recognized and used by the computer; contains commands that enable communication between the computer and hardware devices.
    • KEY: Contains registration information or a security code for a software program; often created when the program is registered; typically stored in the program's application folder or the system preferences folder.
    • SYS: Stores system settings and variables used by the DOS and Windows operating systems; also contains functions that are used to run the operating system; SYS files typically should not be edited.

There is another way of encoding data before being input into an ICT system, there are a number of reasons for this:

  • data that is entered by keyboard into a database could be shortened to save time and reduce errors; customers of a local company who wishes to enter their details onto their mailing list might encode some of data being entered such as E for Eltham and the post code automatically starting with SE9, they may enter F for femail and M for male.
  • this will also take up less space on the data entry screen making it easier for proof reading.
  • programable checking of the entries (Validation) is made simpler due to encoding.

Check the Data slides!

2. Data is processed to produce information. (Much more about processing data is in Topic 7). The type of processing that takes place are: calculating; sorting; grouping; filtering; structuring; making decisions - (Boolean meaning AND OR NOT).

3. Information. Is the result of the processing, and is used by people. People will also use their knowledge of the results to give it meaning as so base decisions on that information.

Check the Data & Information slides!

Useful information has meaning to the user of that information, if the information is:

  • not relevant, (the information on sales has been produced for the personnel department),
  • not reliable, (the source has had problems in the past),
  • not accurate, (your bank account number has been entered 50982365 instead of 50983265),
  • not in date, (your travel brochure shows hotels and resort details for 2007),
  • not complete, (your address has the post code missing),
  • not understandable, (the information has been presented in a way that is unclear and ambiguous),
  • not given at the right time, (the information was needed last week, it cannot be used this week),

it will not be useful to the user.

Data collected and held by organisations quickly becomes out of data. Organisations spend a lot of money collecting data for their own requirements, and for that data to be useful they also need to keep it up to date.

Organisations will have to be informed of the changes,

  • either by individuals whose data is kept,
  • or by the other organisations that they have dealings with,
  • or by government legislation changes,
  • or by specialist organisations that collect data just for other organisations to use.

For example: when a person moves house, what organisations need to know this?

 

Homework: 

Read text book: p 130-133.

Question 1 & 2: p134

Activity 1 & 2: p134

Activities:

Use the Learning Gateway for the self marking test!

Slides: Data

Slides: Data & Information

 

ICT-Teacher.com