L03-Data And Data Types Flashcards
pages 23-24
What is data?
Data is raw facts and figures before they have been processed
What can data be made up of?
Letters, numbers, symbols, graphics and sound
What are the main points about data?
Data has no meaning
Data is raw facts and figures before they have been processed
Examples of Data type’s
Text, Alphanumeric, Date/time, Integer number, Real number, Currency, Percentage, Fraction, Decimal, Object, Logical/Boolean and Limited Choice
What is text type?
Any character
Text type Examples
Name and address
What is Alphanumeric type?
A combination of letters, numbers, spaces or numbers
Example of a alphanumeric type
Postcode
What is Date/time types?
A date and time type is used to store any data related to date or time
Examples of date and time type
Birthdays and Time of birth
What is a integer number type?
Whole numbers
Examples of integer number type
Number of tickets sold
What is a Real number type?
Any number, with or without decimal points
Examples of Real number type
Height or weight
What is a currency type?
Shows data in a format of money, currency signs £$
Example of currency type
Prices
What is a percentage type?
A number format that include a % sign
Example of percentage type
25% of price
What is a fraction type?
A number format that enables actual fractions to be inputted
Example of fraction type
Result of a calculation
What is a decimal type?
A number that uses a decimal point
Examples of a decimal type
Result of calculation expressed as a decimal
What is a limited choice type?
Restricts a user’s choice
Example of limited choice type
Select a day of the week
What is a object type?
An additional component
Example of object type
Graph added in a worksheet
What is a logical/Boolean type?
There are only two choices
Example of logical/Boolean type
True or false