Grade 11 — Questions & Memos Grade 11
Questions covering the Grade 11 syllabus. Answer first, then click Show memo and mark each ✓.
Section A — Short Questions
1.1 High-speed memory on/near the CPU that stores frequently used data is … A) virtual memory B) cache C) ROM D) a register
1.2 Splitting one program into parts that run concurrently is … A) multitasking B) multiprocessing C) multithreading D) virtualisation
1.3 The amount of data that can be sent over a network per second is … A) latency B) bandwidth C) a data cap D) throughput cap
1.4 A field used to uniquely identify each record in a table is the … A) foreign key B) index C) primary key D) attribute
1.5 Hardware that can be removed while the computer is on is … A) plug-and-play B) hot swappable C) modular D) embedded
Show memo
- 1.1 B) cache ✓
- 1.2 C) multithreading ✓
- 1.3 B) bandwidth ✓
- 1.4 C) primary key ✓
- 1.5 B) hot swappable ✓
Systems Technologies
1.1 Distinguish between multitasking and multiprocessing. (2)
1.2 What is virtual memory? (2)
1.3 What happens during thrashing? (1)
Show memo
- 1.1 Multitasking switches rapidly between programs on one CPU (taking turns) ✓; multiprocessing uses multiple CPU cores to do work truly in parallel ✓
- 1.2 Space on the hard drive used by the OS as if it were extra RAM ✓ when physical RAM is full ✓
- 1.3 The computer spends more time swapping data between RAM and virtual memory than doing useful work, so it slows to a crawl ✓
2.1 Compare an embedded OS and a desktop (stand-alone) OS in terms of size and the hardware they need. (4)
Show memo
- Embedded: very small ✓; runs on minimal hardware — a small chip with little memory, built into one device ✓
- Desktop: large ✓; needs a full PC/laptop with a multi-core CPU and several GB of RAM ✓
Networks & Mobile
3.1 Define the term bandwidth. (2)
3.2 Distinguish between a LAN and a WAN. (2)
3.3 What is the purpose of a network protocol? (1)
Show memo
- 3.1 The amount of data that can be sent over a network ✓ in a specific amount of time ✓
- 3.2 A LAN covers a small area such as one building ✓; a WAN covers a large geographic area (e.g. the internet) ✓
- 3.3 A set of rules that controls how data is exchanged between devices on a network ✓
4.1 Give ONE advantage and ONE disadvantage of mobile technology. (2)
4.2 Name ONE privacy risk of location-based services. (1)
Show memo
- 4.1 Advantage: work/bank/learn from anywhere, always with you ✓; disadvantage: small screen, limited battery, data costs or privacy/distraction ✓
- 4.2 Organisations can track your movements / stalking risk / targeted ads without consent ✓
Computer Management
5.1 Give TWO reasons data may be lost. (2)
5.2 Distinguish between a full and an incremental backup. (2)
5.3 State the 3-2-1 backup rule in ONE line. (1)
Show memo
- 5.1 Any two: human error, hardware failure, power surge/outage, malware, theft, natural disaster ✓✓
- 5.2 Full = copies all files every time ✓; incremental = copies only files changed since the last backup ✓
- 5.3 Keep 3 copies, on 2 different media, with 1 off-site/in the cloud ✓
Databases
6.1 What is a primary key? (1)
6.2 What is a DBMS? (1)
6.3 Give ONE advantage of storing data in a database rather than separate files. (2)
Show memo
- 6.1 A field (or fields) that uniquely identifies each record in a table ✓
- 6.2 Database Management System — software used to create, manage and query a database ✓
- 6.3 Less duplication / data shared by many users / easier to keep consistent and secure ✓✓
Social Implications
7.1 What is the Internet of Things (IoT)? (2)
7.2 Name the THREE characteristics ("V"s) of Big Data. (2)
Show memo
- 7.1 A network of physical devices with sensors and internet connectivity ✓ that collect and exchange data automatically ✓
- 7.2 Volume, Velocity and Variety ✓✓
Practical — Delphi & Databases
An array arrAge : array[1..N] of Integer holds N ages. Write code to find and display the largest age.
Show memo
iMax := arrAge[1];
for i := 2 to N do
if arrAge[i] > iMax then
iMax := arrAge[i];
ShowMessage(IntToStr(iMax));
- Initialise iMax to the first element ✓
- Loop through the rest of the array ✓
- Compare and update iMax when a larger value is found ✓
- Display the result ✓
P2.1 Which command opens an existing text file for reading? (1)
P2.2 Which function tells you the end of the file has been reached? (1)
P2.3 Why must you always call CloseFile? (1)
P2.4 Name ONE way to check that a file exists before opening it. (1)
Show memo
- P2.1
Reset(F)✓ - P2.2
EOF(F)✓ - P2.3 So the file is saved and unlocked and no data is lost ✓
- P2.4
FileExists('file.txt')(or wrap Reset in try..except) ✓
Table tblBook(BookID, Title, Author, Price, Year) is connected via a TADOTable named dmBooks.tblBook.
P3.1 Write the Delphi code to filter tblBook so only books published after 2015 are shown. (2)
P3.2 Write the Delphi code to sort tblBook by price from cheapest to most expensive. (2)
Show memo
dmBooks.tblBook.Filter := 'Year > 2015'; dmBooks.tblBook.Filtered := True; dmBooks.tblBook.Sort := 'Price ASC';
- P3.1
Filter := 'Year > 2015'✓;Filtered := True✓ - P3.2
Sort := 'Price ASC'✓; ASC = ascending, cheapest first ✓
Topologies & Media
8.1 What is a network topology? Name ONE example. (2)
8.2 Distinguish between guided (wired) and unguided (wireless) media, with ONE example each. (2)
Show memo
- 8.1 The layout/arrangement of devices and connections on a network ✓; e.g. star (or bus, ring, mesh) ✓
- 8.2 Guided: the signal travels along a physical cable (UTP, fibre) ✓; unguided: the signal travels through the air (Wi-Fi, Bluetooth, radio) ✓
9.1 Give TWO advantages of fibre-optic cable over UTP (copper). (2)
9.2 Give ONE advantage UTP still has. (1)
Show memo
- 9.1 Any two: much faster/higher bandwidth, immune to electrical interference, more secure (hard to tap), longer distances ✓✓
- 9.2 Cheaper / easier to install and work with ✓
Internet & Multimedia
10.1 Distinguish between shaping and throttling. (2)
10.2 Distinguish between a capped and an uncapped account. (1)
10.3 Why are multimedia files often compressed before being sent online? (1)
Show memo
- 10.1 Shaping = the ISP prioritises certain traffic over others ✓; throttling = the ISP deliberately slows the connection ✓
- 10.2 Capped = a limited amount of data per month; uncapped = no data limit ✓
- 10.3 To reduce file size → faster download/streaming and less bandwidth/storage used ✓
Emerging Technologies
11.1 What does the 4IR refer to? (1)
11.2 What is blockchain? (2)
11.3 What is crowdsourcing? (1)
Show memo
- 11.1 The Fourth Industrial Revolution — the fusion of digital, physical and biological technologies (AI, IoT, robotics) ✓
- 11.2 A decentralised digital ledger ✓ where data is stored in linked, tamper-resistant blocks ✓
- 11.3 Getting ideas, content, services or funding from a large group of people online ✓
12.1 What is a digital footprint? (1)
12.2 Distinguish between an active and a passive digital footprint. (2)
Show memo
- 12.1 The trail of data you leave behind online ✓
- 12.2 Active = data you intentionally share (posts, forms) ✓; passive = data collected without your knowledge (cookies, browsing history) ✓
Data Validation
13.1 What is data validation? Give ONE example of a validation check. (2)
13.2 Distinguish between validation and verification. (2)
Show memo
- 13.1 Checking that entered data is reasonable and in the correct format ✓; e.g. a range check, type check, or required-field check ✓
- 13.2 Validation checks whether data is sensible/allowed ✓; verification checks whether data was entered/copied correctly (e.g. double-entry or proofreading) ✓
More Delphi & Databases
P4.1 Distinguish between a linear search and a binary search. (2)
P4.2 What must be true of an array before a binary search will work? (1)
P4.3 Distinguish between a procedure and a function. (1)
Show memo
- P4.1 Linear search checks each element one by one ✓; binary search repeatedly halves the search range ✓
- P4.2 The array must be sorted first ✓
- P4.3 A function returns a value; a procedure performs a task but returns no value ✓
A line read from a text file has the form Name,Mark (e.g. Thabo,72) stored in sLine. Write code to split it into sName (string) and iMark (integer).
Show memo
iPos := Pos(',', sLine);
sName := Copy(sLine, 1, iPos - 1);
iMark := StrToInt(Copy(sLine, iPos + 1, Length(sLine)));
- Find the comma with
Pos✓ - Copy the part before the comma into sName ✓
- Copy the part after the comma and convert to integer ✓
Table tblLearner(LearnerID, Name, Grade, Average) is connected via dm.tblLearner. Write Delphi code that loops through every record and works out the number of Grade 11 learners and their average mark.
Show memo
iCount := 0;
rTotal := 0;
dm.tblLearner.First;
while not dm.tblLearner.Eof do
begin
if dm.tblLearner['Grade'] = 11 then
begin
iCount := iCount + 1;
rTotal := rTotal + dm.tblLearner['Average'];
end;
dm.tblLearner.Next;
end;
if iCount > 0 then
ShowMessage('Grade 11 learners: ' + IntToStr(iCount) +
', Average: ' + FloatToStrF(rTotal / iCount, ffFixed, 6, 1));
- Loop from
FirsttoEof, advancing withNext✓ - Only count/sum records where Grade = 11 ✓
- Divide total by count for the average, guarding against division by zero ✓
Section B — Mixed Exam Questions
8.1 What is the purpose of the motherboard? (1)
8.2 Distinguish between RAM and ROM. (2)
8.3 Where is cache memory located and why does that help? (1)
Show memo
- 8.1 It connects and provides power to all the components; the central hub through which data flows ✓
- 8.2 RAM is volatile, temporary working memory; ROM is non-volatile and holds permanent start-up instructions ✓✓
- 8.3 On or very close to the CPU, so frequently used data is fetched quickly without waiting for slower RAM ✓
9.1 Distinguish between a compiler and an interpreter. (2)
9.2 What is virtualisation, and give ONE benefit. (2)
Show memo
- 9.1 A compiler translates the whole program to machine code at once (before running); an interpreter translates and runs it one line at a time ✓✓
- 9.2 Using software to run one or more "virtual" computers on one physical machine ✓; benefit: saves cost/space/electricity, or lets you test risky software safely ✓
10.1 What does DBMS stand for and do? (2)
10.2 Distinguish between a desktop/personal database and a server/centralised database. (2)
Show memo
- 10.1 Database Management System ✓ — software used to create, manage and query a database ✓
- 10.2 A personal database is on one computer for a single user; a centralised database is stored on a server and shared by many users over a network ✓✓
11.1 What is crowdsourcing? Give ONE example. (2)
11.2 What is the digital divide? (1)
Show memo
- 11.1 Getting ideas, content, services or funding from a large group of people online ✓; e.g. Wikipedia, crowdfunding (BackaBuddy), map/review contributions ✓
- 11.2 The gap between people who have access to digital technology and those who do not ✓
arrName and arrMark are parallel arrays of N learners. Explain — and show with a swap — how to sort them from highest mark to lowest while keeping each name with its mark.
Show memo
for i := 1 to N - 1 do
for j := i + 1 to N do
if arrMark[j] > arrMark[i] then
begin
// swap BOTH arrays at the same index
iTemp := arrMark[i]; arrMark[i] := arrMark[j]; arrMark[j] := iTemp;
sTemp := arrName[i]; arrName[i] := arrName[j]; arrName[j] := sTemp;
end;
- Compare marks with
>for descending order ✓ - Swap
arrMarkat i and j using a temp ✓ - Swap
arrNameat the same index so the name stays with its mark ✓ - Correct nested-loop structure ✓
Learn the definitions word-for-word from the IT Glossary, then practise applying them in these questions.