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

Term 2 round-up

Week 21 · Review: Term 2 · 3 lessons
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?
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.
3
Encrypt GARDEN with a Caesar shift of 8. Then write the plaintext of WUHH, which was made with a shift of 3.
plainsecretABCDEFGHIJKLMplainsecretNOPQRSTUVWXYZ
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?
ABCD
1PacketPriceSoldIncome
2Peas215?
3Beans312?
4Herbs48?
5Total?
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.