Term 2 round-up
Answers are for parents and teachers.
1
A 7 MB picture is sent over a 14 Mbps link. How many seconds does it take? Then the link is shared equally by two devices that each download a 7 MB picture. How long does each one take?
7 × 8 = 56 megabits, and 56 ÷ 14 = 4 seconds. Shared by two devices, each gets 7 Mbps, so 56 ÷ 7 = 8 seconds.
2
Take the URL https://games.example.org/chess/rules.html apart (protocol, domain name, TLD, path). Then change one number so that the IP address 198.51.100.300 becomes valid, and say why it was invalid.
protocol https://, domain name games.example.org, TLD org, path /chess/rules.html. 198.51.100.300 was invalid because 300 is bigger than 255. Changing 300 to a number from 0 to 255, such as 30, makes it valid.
3
Encrypt GARDEN with a Caesar shift of 8. Then write the plaintext of WUHH, which was made with a shift of 3.
GARDEN becomes OIZLMV. Moving WUHH back 3 places gives TREE.
4
A garden club sells seed packets. In column D write the formula that works out the income for each packet, copy it down and add the total. What are the values?
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Packet | Price | Sold | Income |
| 2 | Peas | 2 | 15 | ? |
| 3 | Beans | 3 | 12 | ? |
| 4 | Herbs | 4 | 8 | ? |
| 5 | Total | ? |
D2 =B2*C2 shows 30, D3 =B3*C3 shows 36 and D4 =B4*C4 shows 32. The total =SUM(D2:D4) shows 98.
5
A school wants to keep a record of its lost property. Design the table: write five field names, a data type for each and say which field is the primary key. Say why a database suits this job better than a spreadsheet.
A model answer: ItemNo (autonumber, primary key), Item (text), Colour (text), WhereFound (text), DateFound (date), Returned (yes/no). A database can search many records with a query, such as all red scarves not yet returned, and every record has a unique key.