KS3 ICT | Data use - store and shop loyalty cards

Back to ICT

ICT Quiz - Data Use 01 (Questions)

Discover how data is used to answer questions. Learn about databases, records and fields, and how sorting, filtering and searching help organisations make decisions.

Explore the Topic →

(quiz starts below)

Fascinating Fact:

Databases are used when you need to store lots of records, search quickly, and avoid repeated information.

In KS3 ICT, using data means collecting it, storing it sensibly, and turning it into useful information. You will practise organising data in tables, checking it is sensible, and using tools like searches, filters, and reports to spot patterns and answer real questions.

Key Terms

Database: An organised collection of data that can be stored, searched, and updated efficiently.
Record: A complete set of information about one item, such as one student or one library book.
Query: A question you ask a database to find specific records that match rules, such as “all items borrowed this month”.

Frequently Asked Questions (Click to see answers)

What does data use mean in KS3 ICT?

In KS3 ICT, data use means handling data responsibly so it becomes useful information. This includes collecting it, storing it, checking it for errors, and analysing it to make decisions.

What is the difference between a record and a field?

A record is one full entry in a database table, like one customer. A field is one piece of information in that record, like the customer’s name or postcode.

How do sorting and filtering help you find data?

Sorting puts data in an order, such as highest to lowest, which makes patterns easier to spot. Filtering hides records that do not match your rule, so you only see the results you need.

Try These Related Quizzes

Loyalty cards are used by some shops. To get a card .......

[ ]	a customer must supply their name and address details
[ ]	the customer buys a card from the shop
[ ]	the customer just picks one up in the shop
[ ]	the customer only need give their name

When an application for a loyalty card is received .......

[ ]	the shop adds name and address details onto a database
[ ]	the shop loses it
[ ]	the shop performs an identity check on the customer
[ ]	the shop simply sends out the card

When buying something in the shop, the loyalty card is .......

[ ]	given to the shelf filler
[ ]	ignored
[ ]	looked at by the checkout staff
[ ]	usually asked for and read at the checkout

A loyalty card sends details of a purchase and .......

[ ]	the customer credit card number to the shop database
[ ]	the customer ID to the shop database
[ ]	the customer mobile phone number to the shop database
[ ]	the shop ID to the shop database

Which is not an advantage of a loyalty card scheme to a consumer?

[ ]	Stores may give a voucher to give the customer some money off their next bill
[ ]	Shops can build a profile of a customer
[ ]	Stores can offer customers personalised offers
[ ]	The customer may be rewarded with discounts on specific items

Bar codes .......

[ ]	are easily read by the checkout person
[ ]	contain product ID and can be read quickly by a scanner
[ ]	contain product stock level and price information
[ ]	contain product ID and stock levels

EPOS stands for .......

[ ]	Electronic Point Of Sale
[ ]	Electronic Position Of Sale
[ ]	Electronic Position Of Store
[ ]	Electronic Program Operating System

EPOS systems scan a bar code at the checkout; then .......

[ ]	the product ID is checked on the shop database
[ ]	an itemised bill is printed at the checkout
[ ]	the item price is returned from the database
[ ]	All of these events

Which of these is not an advantage to the shop?

[ ]	EPOS can help to reduce fraud
[ ]	EPOS results in better stock control, so less shortages
[ ]	EPOS systems usually mean quicker service
[ ]	In EPOS systems, more information is printed on the bill

10.

What does EFTPOS stand for?

[ ]	Easy Finance Trap at Point Of Sale
[ ]	Electronic Finance Transfer at Point Of Sale
[ ]	Electronic Finance Trick at Point Of Sale
[ ]	Electronic Funds Transfer at Point Of Sale

ICT Quiz - Data Use 01 (Answers)

Loyalty cards are used by some shops. To get a card .......

[x]	a customer must supply their name and address details
[ ]	the customer buys a card from the shop
[ ]	the customer just picks one up in the shop
[ ]	the customer only need give their name

The shop can track what customers buy and use that to send out special offers related to the items they buy the most

When an application for a loyalty card is received .......

[x]	the shop adds name and address details onto a database
[ ]	the shop loses it
[ ]	the shop performs an identity check on the customer
[ ]	the shop simply sends out the card

This will be a relational database as the store will record all of the items that each customer with a loyalty card buys

When buying something in the shop, the loyalty card is .......

[ ]	given to the shelf filler
[ ]	ignored
[ ]	looked at by the checkout staff
[x]	usually asked for and read at the checkout

They are usually read using the barcode reader that is used on the items bought

A loyalty card sends details of a purchase and .......

[ ]	the customer credit card number to the shop database
[x]	the customer ID to the shop database
[ ]	the customer mobile phone number to the shop database
[ ]	the shop ID to the shop database

It uses an automatic input system

Which is not an advantage of a loyalty card scheme to a consumer?

[ ]	Stores may give a voucher to give the customer some money off their next bill
[x]	Shops can build a profile of a customer
[ ]	Stores can offer customers personalised offers
[ ]	The customer may be rewarded with discounts on specific items

Building a customer profile could be a privacy violation

Bar codes .......

[ ]	are easily read by the checkout person
[x]	contain product ID and can be read quickly by a scanner
[ ]	contain product stock level and price information
[ ]	contain product ID and stock levels

Price and stock levels are stored on a database linked to the product ID and are not part of the bar code

EPOS stands for .......

[x]	Electronic Point Of Sale
[ ]	Electronic Position Of Sale
[ ]	Electronic Position Of Store
[ ]	Electronic Program Operating System

Another example for you of an automatic input

EPOS systems scan a bar code at the checkout; then .......

[ ]	the product ID is checked on the shop database
[ ]	an itemised bill is printed at the checkout
[ ]	the item price is returned from the database
[x]	All of these events

Stock levels are also automatically adjusted