B061- Manipulating Data

Question 1

What is data capture?

Answer 1

Data capture is the processing of collecting data for use in a computer system.

Question 2

How can data be captured automatically?

Answer 2

A scanner, optical character recognition, optical mark readers, radio frequency identification scanners, voice recognition, sensors.

Question 3

Give two non-automatic ways that you can capture data.

Answer 3

Tally sheets and questionnaires.

Question 4

Describe text data.

Answer 4

Text data can have any character including letters, numbers, punctuation, space and other characters. Data stored as text can not be used in calculations.

Question 5

Describe numeric data.

Answer 5

Numeric data can only be numbers with or without decimal places.

Question 6

Describe boolean or logical data.

Answer 6

Boolean or logical data can only have two values- TRUE or FALSE.

Question 7

Give two non-automatic ways that you can capture data.

Answer 7

Tally sheets and questionnaires.

Question 8

Describe date/time data.

Answer 8

Date/time data is either in days, months and years or a time only.

Question 9

Describe image data.

Answer 9

Image data is used to store graphics and photographs.

Question 10

What errors may occur when entering data from a data-capture sheet?

Answer 10

The data may not be read properly from the data capture sheet or typing errors may occur.

Question 11

Why is verification used?

Answer 11

Verification is used to ensure that the data that appears in a document or database is the same as the original source data

Question 12

Fill in the blanks. …………… use a grid of cells arranged in ……… and ………. Cells can be ………. in to ranges.

Answer 12

Spreadsheets, rows, columns, grouped.

Question 13

Which type of cell referencing allows cell references to change automatically when copying or replicating cells?

Answer 13

Relative cell referencing.

Question 14

Which type of cell referencing prevents cell references from changing automatically when copying or replicating cells?

Answer 14

Absolute cell referencing

Question 15

What are formulas used to do?

Answer 15

Formulas are used to carry out calculations using references to the contents of other cells.

Question 16

What does formatting do?

Answer 16

Formatting cells change how the contents of cells look.

Question 17

What are databases?

Answer 17

Databases are files of data that are manipulated by database management software.

Question 18

What does querying mean?

Answer 18

It means asking the database to find chosen specific data.

Question 19

What do relational databases do?

Answer 19

Relational databases keep data in tables that are related to each other.

Question 20

True or False. A primary key is the field in a record that holds unique data and allows that record to be identified among all the other records

Answer 20

True.

Question 21

Give two examples of where spreadsheets can be used for manipulating data.

Answer 21

1) Spreadsheets can be used by teachers for keeping records of exam and test marks, class attendance or the finances of a school trip.
2) people can use spreadsheets at home for keeping track of their finances

Question 22

Fill in the blanks. Computer models use ……………. and …………. to perform …………… on variables to allow a user to see the outcome of ………….. without creating the real thing.

Answer 22

Computer models use formulas and functions to perform calculations on variables to allow a user to see the outcome of changes without creating the real thing.

Question 23

Give three examples of people that use databases

Answer 23

Companies, small businesses and individuals.