Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

I.T⌨️🖥 > Data & Information > Flashcards

Data & Information Flashcards

1
Q

Data definition

A

Raw facts and figures which are meaningless as they have not been processed e.g. 3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Information definition

A

Data that has been processed and has meaning e.g. My sister is 3 year old

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Why code data?

A

(i) faster to type than full words, taking less time to enter data
(ii) faster for the computer to perform sorts and searches on data
(iii) codes are often designed to be unique

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is a database?

A

A collection of information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Advantages of databases on a computer

A
  • large amounts of data is stored in a small space
  • a computer can search the database quickly for specific information
  • the stored data is less likely to be lost
  • more than one user can see the data at any one time
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Disadvantages of databases on a computer

A
  • the computer equipment you need will be relatively expensive to buy and install
  • initial cost of collecting the data and setting up the database will be high
  • to make the system effective, staff need to be trained
  • if the system fails you cannot access the information
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Data types

A

Text - letters, symbols, numbers (alphanumeric)

Number - number only (can include decimals)

Date/time - dates and times

Currency - for all monetary data (includes currency symbols)

Yes/no - or true/false

Autonumber - a unique value generated by Access for each different record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is a key field/primary key?

A

A field that uniquely identifies one record in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is a datafile?

A

Collection of related records stored in a table with field headings

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is a record?

A

All the data connected with one item organised under field headings

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is a field?

A

The column which holds the data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is an item?

A

One field in one record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is a flat file?

A

A database containing only one table with all records contained in this table under the field headings. Can be described as a file containing text or data separated by commas or tabs such as in a csv file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is a relational database?

A

A database made up of a group of tables which are linked

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What is data redundancy?

A

Data unnecessarily duplicated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is data integrity?

A

Data that is accurate and up-to-date

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is a link field?

A

A field in two tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Examples of forms

A

National lottery ticket selection form

Registering pupils in school

Multiple choice test

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

How does the optical mark reader (OMR) work?

A

It detects the presence of your pencil mark by reflecting light onto it - less light is reflected where a mark has been made.

The OMR then interprets the pattern of marks and sends the results to the computer for storage, analysis and reporting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Advantages of optical mark reader (OMR)

A
  • a fast method of inputting large amounts of data - up to 10 000 forms can be read per hour depending on the quality of the machine used
  • only one computer needed to collect and process the data
  • OMR is much more accurate than data being keyed in by a person
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Disadvantages of optical mark reader (OMR)

A
  • if the marks don’t fill the space completely, or aren’t in a dark enough pencil, they may not be read correctly
  • not suitable for recording one out of a selection of answers, not suitable for text input
  • the OMR needs the answers to be on the prepared forms which will all be identical to one another (you can’t just pick up a blank sheet of paper and mark your answers on it)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

An optical character recognition (OCR) system consists of…

A

A normal scanner and some special software

23
Q

How does an OCR system work?

A

The scanner scans text on a document or piece of paper into the computer

The special software then examines the page and changes the letters into a form that can be edited or processed by a normal word processing package

24
Q

What is OCR used for?

A

For postcodes on letters at sorting offices

In libraries to digitise old books

25
Q

Advantages of OCR

A
  • cheaper than paying someone to manually enter large amounts of text
  • much faster than someone manually entering large amounts of text
  • the latest software can recreate tables and the original layout
26
Q

Disadvantages of OCR

A
  • not 100% accurate, there are likely to be some mistakes made during the process (accuracy depends on how clear the writing is)
  • all documents need to be checked over carefully and then manually corrected
  • if the original document is of poor quality or the handwriting is difficult to read, more mistakes will occur
  • not worth doing for small amounts of text
27
Q

What is a barcode? What does it contain?

A

A series of vertical bars of varying widths that represents numbers which contain:

  • a country code
  • a manufacturer code
  • a product code

Does not contain price as that’s held in the company database

28
Q

What is a barcode reader?

A

An automatic input device which is used to scan or ‘read’ the barcode by using a visible red light - the reflected light is translated into digital data that is interpreted by the computer to identify the product and price from the database

29
Q

Main advantage of the barcode reader

A

Any price change only needs to be made to the database and not every single product package

30
Q

Examples of things that have barcodes

A
  • books (ISBN number)
  • library tickets
  • boarding passes
  • concert tickets
31
Q

What is a transcription error?

A

Any data entry error created when transferring data from one source to another source

32
Q

Types of error

A

Omission errors
Transposition errors
Duplication errors

33
Q

Omission errors explanation and examples

A

Data is left out

32 instead of 321
Joh_ Smith
22 Marc_

34
Q

Transposition errors explanation and examples

A

Characters being typed are swapped by mistake

312 instead of 321
Jonh Smith
22 Marhc

35
Q

Duplication errors explanation and examples

A

Entering a character twice

3221 instead of 321
Johhn Smith
22 Marrch

36
Q

What is data verification?

A

A method of checking data carried out by a person to check data is correct before it is processed

37
Q

What is data validation?

A

A method of checking data carried out by a computer to check data is correct before it is processed

38
Q

Types of data verification

A

(1) double entry - the data is keyed in twice and both versions must be identical
(2) proof reading - after data is keyed in, it is read to check it has been typed accurately

39
Q

Types of data validation

A

(1) range check
(2) presence check
(3) format check
(4) length check
(5) type check
(6) lookup tables
(7) check digit

40
Q

What is a range check?

A

A check carried out on a number or date field to make sure the data falls within a specified range

E.g. Exam %s can have a range check of between 0 and 100

41
Q

What is a presence check?

A

Ensures that important fields are not left blank

In MSAccess set required field to ‘yes’

42
Q

What is a format check?

A

Data must match a preset pattern

E.g. A post code must have a certain combination of letters and digits

(In MSAccess use an input mask)

43
Q

What is a length check?

A

Ensures data is of a specified length

E.g. A credit card number must have 16 digits

(In MSAccess set the length field for text items)

44
Q

What is a type check?

A

A check carried out on a number or date field to make sure the data entered is of the correct type

45
Q

What are lookup tables?

A

Ensure that the data entered is one of an acceptable set of values

Such as Y or N, M or F

46
Q

What is a check digit?

A

An extra digit added to a numeric code to ensure that it is valid. The extra digit is calculated by applying a formula to the sequence of numbers

Used on barcodes on supermarket items and on the ISBN number on the back of books

47
Q

Advantages of databases

A
  • information is usually only stored once
  • files can be linked together so that updates are automatically made to each file that shares information
  • the record structure can be easily altered even though lots of data has already been entered
  • access to information is fast using queries
  • validation checks can be made as data is entered ensuring fewer mistakes are made
48
Q

Disadvantages of databases

A
  • if the computer breaks down you are not able to access information
  • computer files are easily copied - this can be a problem therefore all sensitive information must have protection - usually by password
  • training is needed to use the system which can be expensive and takes valuable time
49
Q

Why is data compression used?

A

To save space or reduce download time

50
Q

Advantage of data compression

A

Easier to send

51
Q

Disadvantage of data compression

A

It must be decompressed before it can be used

52
Q

Graphics can be compressed using

A

JPEG or GIF format

53
Q

Music files can be compressed using

A

MP3 format

54
Q

Video files can be compressed using

A

MPEG format

I.T⌨️🖥 (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions