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

A1 · Multiple choice5

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

Q1 · Processing techniques5

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
Q2 · Operating systems4

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

Q3 · Networks5

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
Q4 · Mobile & location3

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

Q5 · Data loss & backups5

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

Q6 · Database concepts4

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

Q7 · IoT & Big Data4

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

P1 · 1D array4

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 · Text files4

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)
P3 · Filtering & sorting records4

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

Q8 · Network layout4

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)
Q9 · Cabling3

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

Q10 · Connection management4

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

Q11 · 4IR & blockchain4

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
Q12 · Digital footprint3

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

Q13 · Validation & verification4

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 · Searching & methods4

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
P5 · Reading CSV data3

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
P6 · Looping through records3

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 First to Eof, advancing with Next
  • Only count/sum records where Grade = 11
  • Divide total by count for the average, guarding against division by zero

Section B — Mixed Exam Questions

Q14 · Motherboard & memory4

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
Q15 · Software & virtualisation4

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
Q16 · Databases4

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
Q17 · Social implications3

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
P7 · Parallel-array sort4

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 arrMark at i and j using a temp
  • Swap arrName at the same index so the name stays with its mark
  • Correct nested-loop structure
Tip

Learn the definitions word-for-word from the IT Glossary, then practise applying them in these questions.