AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Year plan · Computing

Models and decisions

Week 20 · Unit 7.4: The power of data · 3 lessons
1

Sheet or database?

Computing 7: Unit 7.4, pp. 112–149
GoalCompare spreadsheets and databases and choose the better tool for a real situation, giving reasons.
New words
data model · a spreadsheet or database that copies a real situation, so that you can study it and test changesspreadsheet · a grid of cells that is best for numbers and calculationsdatabase · a set of tables with fields and records that is best for storing and searching lots of factsscenario · a description of a real situation that is to be modelled
Explanation

Spreadsheets and databases both help people make decisions with data. A spreadsheet stores data in cells and uses formulas to calculate and to show how numbers are linked. A database stores records under field headings, uses primary keys to identify records and uses queries to search. Both can use conditional formatting to highlight important data. To choose, ask: do I need many calculations, and is the data mainly numbers? If so, a spreadsheet is probably better. If the main job is to store and search many records, choose a database. Some jobs need both.

SpreadsheetDatabase
data in cellsdata in fields and records
labelsfield headings
formulas for calculationsqueries to search
data formatsdata types
conditional formattingconditional formatting
no key neededprimary key for each record
Worked examples
B5fx=SUM(B2:B4)
AB
1ItemCost
2Fuel40
3Food55
4Tickets30
5Total125
A family plans a day trip and wants to know the total cost. This is a calculation job on numbers, so a spreadsheet is best. The formula in B5 is =SUM(B2:B4). Change the cost of one item and the total updates by itself.
Part of the planBike repair stall
FieldsJobNo (key), OwnerName, BikeType, Fault, Ready
Data typesAutonumber, Text, Text, Text, Yes/No
QueryBikeType, Ready where Ready = Yes
Tooldatabase
A bike repair stall records each bike that is brought in. The stall will have hundreds of records and wants to ask questions such as ‘which bikes are ready to collect?’. This is a storing and searching job, so a database is best. Each bike gets a primary key, and a query uses the criteria Ready = Yes.
QuestionIf the answer is yes
Many calculations?spreadsheet
Mainly numbers?spreadsheet
Many records to store and search?database
Each record needs a unique identity?database with a primary key
Some situations need both tools. A school fair stores the names of stall holders in a database and uses a spreadsheet to add up the money. A good planner writes down the data, the calculations and the searches first, and then chooses.
Class activity

Tool chooser cards (no computer). Write ten situations on cards, such as ‘the monthly savings of a family’, ‘a list of all the plants in a school garden with their needs’, ‘points in a quiz competition’ and ‘who has borrowed which book’. Make two piles labelled spreadsheet and database. Sort the cards, and for each one say the reason in one sentence, using the words calculation, record or search. Discuss any card that could go in either pile or in both. Then pick one card and list the field headings or columns you would use.

Practice
1
A class records the weight in kilograms of vegetables picked each day for a month, and wants totals and the average per day. Which tool is better, and why? Name two things you would put in it.
2
Pet sitters keep records of their name, the pets they can look after and their free days. Families want to find a sitter who is free on Saturday. Which tool is better? Give the field headings and one criteria.
3
Complete the table: choose spreadsheet or database and give a reason.
SituationSpreadsheet or database?Reason
Profit of a lemonade stall??
Register of borrowed sports kit??
Total quiz points of four teams??
4
In the trip sheet, the cost of food changes from 55 to 65. What is the new total? Which cell changes, and why?
AB
1ItemCost
2Fuel40
3Food65
4Tickets30
5Total?