ICT 4TH QUARTER (2026)

Unorganized data / raw data

Data

Meaningful and useful output

Information

Organized data

Database

Combination of letters and numbers

Alphanumeric

Requires character length / number of characters

Character

Whole number / no decimal value

Integer

Number w/ decimal point

Numeric

Money values

currency

Yes / No

Boolean

Heading / title

Field

Horizontal entry

Record

Single table

Flatfile database

Connected by multiple tables

Relational database

Ensure proper data entry

data type

Search tool

Query

You have a list of student test scores that are raw numbers. What term describes these raw facts before they are organized

Data

After organizing the students scores into a report that shows averages and rankings, what is this meaningful output called?

Information

You decide to store student data in rows and clumps so that it can be easily accessed and managed. What is this organized collection called

Database

In your students data table, each column has a title like ‘name’ or ‘score’. WHat is the name of these titles?

Field

Each student’s complete information is stored in one horizontal line across the table. What do you call this horizontal grouping?

record

You want to make sure that the ‘date of birth’ column only accepts date values. What is the name of these titles?

Field

Each student’s complete information is stored in one horizontal line across the table. What do you call this horizontal grouping?

Record

You want to find all students who scored above 90. What kind of database action will you perform to filter this data?

query

You want to make sure that the ‘date of birth’ column only accepts date values. What defines this restriction?

Data type

For the ‘student name’ column, what type of database action allows letter and symbols to be entered freely?

alphanumeric

When storing a student’s middle initial, what kind of database action allows unit are you saving?

Character

When tracking tuition fees paid by students, which data type should be used to handle the money values?

Currency

If you calculate the percentage of correct answers on tests, what data type is this considered?

integer

The ‘has paid fees’ field only allows ‘yes’ or ‘no’ answers. What kind of database action type is this?

Boolean

If you store all students information in just one big table without splitting it, what tipe of data base structure is this?

Relational Database

analysing data in rows and columns

spreadsheet

horizontal arrangement of cells

row

vertical arrangement of cells

column

Intersection of row and columns

cells

mathematical expression used in spreadsheet

formula

Built in spreadsheet feature to perform calculations

function

Highest value

= max

Calculate the average (mean)

= AVERAGE

Count only cells

= COUNT

rounds a number

=ROUND

searches for a value in the first column

=VLOOKUP

Searches for a value and returns corresponding values from another location

=LOOKUP

calculates the total

=SUM

Evaluates condition (TRUE / FALSE)

=IF

removes the decimal point

=INT