B061- Manipulating Data Flashcards
What is data capture?
Data capture is the processing of collecting data for use in a computer system.
How can data be captured automatically?
A scanner, optical character recognition, optical mark readers, radio frequency identification scanners, voice recognition, sensors.
Give two non-automatic ways that you can capture data.
Tally sheets and questionnaires.
Describe text data.
Text data can have any character including letters, numbers, punctuation, space and other characters. Data stored as text can not be used in calculations.
Describe numeric data.
Numeric data can only be numbers with or without decimal places.
Describe boolean or logical data.
Boolean or logical data can only have two values- TRUE or FALSE.
Give two non-automatic ways that you can capture data.
Tally sheets and questionnaires.
Describe date/time data.
Date/time data is either in days, months and years or a time only.
Describe image data.
Image data is used to store graphics and photographs.
What errors may occur when entering data from a data-capture sheet?
The data may not be read properly from the data capture sheet or typing errors may occur.
Why is verification used?
Verification is used to ensure that the data that appears in a document or database is the same as the original source data
Fill in the blanks. …………… use a grid of cells arranged in ……… and ………. Cells can be ………. in to ranges.
Spreadsheets, rows, columns, grouped.
Which type of cell referencing allows cell references to change automatically when copying or replicating cells?
Relative cell referencing.
Which type of cell referencing prevents cell references from changing automatically when copying or replicating cells?
Absolute cell referencing
What are formulas used to do?
Formulas are used to carry out calculations using references to the contents of other cells.
What does formatting do?
Formatting cells change how the contents of cells look.
What are databases?
Databases are files of data that are manipulated by database management software.
What does querying mean?
It means asking the database to find chosen specific data.
What do relational databases do?
Relational databases keep data in tables that are related to each other.
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
True.
Give two examples of where spreadsheets can be used for manipulating data.
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
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.
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.
Give three examples of people that use databases
Companies, small businesses and individuals.
