Western Cape Education Department

Directorate: Curriculum FET

COMPUTER APPLICATIONS TECHNOLOGY REVISION

BOOKLET 2024

YEAREND

Grade 12

MEMORANDUM & MARKING GUIDE

TABLE OF CONTENTS
TABLE OF CONTENTS .............................................................................................................................. 3
THEORY SECTION ................................................................................................................................... 2
SECTION A .......................................................................................................................................................2
QUESTION 1: PASITEMS
..............................................................................................................................2
QUESTION 2 MEERVOUDIGEKEUSE VRAE
..................................................................................................2
QUESTION 3: WAAR/ ONWAAR ITEMS
.......................................................................................................2
SECTION B .......................................................................................................................................................3
QUESTION 4: SYSTEM TECHNOLOGIES
.......................................................................................................3
QUESTION 5: NETWORK AND INTERNET TECHNOLOGIES
..........................................................................5
QUESTION 6: INFORMATION MANAGEMENT ............................................................................................6
QUESTION 7: SOCIAL IMPLICATIONS
..........................................................................................................6
QUESTION 8: SOLUTION DEVELOPMENT ...................................................................................................7
SECTION C .......................................................................................................................................................9
QUESTION 9: INTEGRATED SCENARIO
........................................................................................................9
QUESTION 10: INTEGRATED SCENARIO ...................................................................................................
11
PRACTICAL SECTION ............................................................................................................................. 14
QUESTION 1: WOORDVERWERKING ....................................................................................................... 14
QUESTION 2: WORDPROCESSING............................................................................................................ 15
QUESTION 3: SPREADSHEET ....................................................................................................................
16
QUESTION 4: SPREADSHEET ....................................................................................................................
18
QUESTION 5: DATBASE ............................................................................................................................
19
QUESTION 6 (HTML) ................................................................................................................................
21
 QUESTION 7 .............................................................................................................................................
22

THEORY SECTION

SECTION A
QUESTION 2 MEERVOUDIGEKEUSE VRAE QUESTION 1: PASITEMS 2.1 B

1.1 D Kaart leser/ Card reader 2.2 C 1.2 G HDMI

2.3 B
1.3 B NFC
2.4 A
1.4 N Bit.ly
2.5 D
1.5 J IvD/ IoT
2.6 D
1.6 C Drabare/ Wearables
1.7 E RAM 2.7 B
1.8 F Klikkaping/ Click jacking 2.8 B
1.9 H Losprys sagteware/ Ransomware 2.9 C
1.10 I Verifikasie/ Authentication 2.10 A
[10] [10]

QUESTION 3: WAAR/ ONWAAR ITEMS

3.1 ONWAAR: verslag/

FALSE: report (1)
3.2 ONWAAR: Drywer/
FALSE: Driver (1)
3.3 WAAR/ TRUE (1)
3.4 WAAR/ TRUE (1)
3.5 ONWAAR: skyfskoonmaak/
FALSE: disk cleanup (1)
[5]
SECTION B
QUESTION 4: SYSTEM TECHNOLOGIES
4.1 • GOBS ('FOSS') has a less formal support structure
• GOBS source code is available/GOBS can be modified
• GOBS is generally free (2)
• Operating systemshas a different approach to the UI
(Any two)
4.2 • Comes standard on most portable devices, can share chargers/connectors✔ •
Tak (2)
• es up less space/Device can be made smaller/thinner✔
4.3 • Faulty power
• Faulty cable
• Cable not connected/Screen not turned on
• Faulty graphics card/motherboard/port/computer (2)
• Driver problems
• Problemscaused by using more than one display device
✔✔(Any two)
4.4. • On-screen keyboard blocks the text
• Font size is too big/Screen size is too small
• More than one app is open taking up screen space (2)
• Text is scrolled out of view / Auto-rotation not on
✔✔ (Any two)
4.5 1024x768 is the resolution and not the physical screen / Screen size is given in inches✔ (1)
4.6 Fewer appliances means less materials are used/going to landfills ✔
(2)
Fewer devices means less power consumption✔
4.7.1 • Wide variety of devices can be connected via USB
• Compatibility with older devices
• Power source for appliances
• Implement plug and play technologies/devices
• Support data transfer (1)
• USB devices can be swapped while the computer is switched on/Hot swapping ('hot
swopping') can be done
• Smaller size is more suitable for device mobility
✔ (Any one)
4.7.2 • Optical drive is older technology and currently less used for data storage (Backup)
• Music, videos and software can be downloaded from the internet or distributed through
social media/flash drives
• Computer can be made smaller/Not enough space to include the optical drive
(1)
• To keep the price down – one less device
• Can reduce the weight of the computer/Can be made lighter
• Battery can last longer because there is one less device/Reduces power requirements
✔ (Any one)
4.7.3 Temporary memory/RAM✔ (1)
4.7.4 128 GB (must mention size and unit for point)✔ (1)

4.8 • Access from anywhere with internet/Open 24/7

• Save travel costs/transaction costs
• No queues/Save time
• Not exposed to physical crime
(2)
• Most banking activities can be done without visiting a bank
• Banking can be done in the privacy of your own environment
• No personal interaction required/Complies with COVID-19 requirements
✔✔ (Any two)
4.9 • Reboot (restart) the printer
• Check that the correct printer is selected
• Switch from offline to online mode
• Remove print jams in the print queue
• Clear printer memory
• Load paper in the printer/Correct the selected paper size (2)
• Clear paper jams
• Add ink/powder ink ('toner')/Check print heads
• Check for possible faulty printer cable/wireless connection (10) Reinstall the printer
driver
✔✔ (Any two)
4.10 • Getting messages that) there is no space left/Can't save anything
• Thrashing/System is slow
• System sometimes freezes/crashes (2)
• Programs do not open
✔✔ (Any two)
4.11 • Provide facility to download files/content
• Manage plugins/extensions
• Save the link/URL of recently visited web pages
• Can save favourites/bookmarks/history
• Provide a pop-up blocker
• Allow caching
• Has a feature to block websites (2)
• Manage data usage
• Manage proxy settings
• Acts as a file explorer / Open different files / document
• Allow video streaming
• Allow SaaS ('software as a service').
✔✔ (Any two)

4 | Page
4.12 Reason:
The action will only create a shortcut and not save the file to the desktop✔

Solution:
(2)
• Copy and paste on the desktop
• Open the document and save it to the desktop ('File Save As')
• Click and drag to the desktop if it is already saved elsewhere
✔ (Any one)
[25]
QUESTION 5: NETWORK AND INTERNET TECHNOLOGIES
5.1 • Adding infrastructure is difficult/Specialist knowledge may be required
• Available space/specific location may make it difficult/inappropriate to lay
cables/Possible cable clutter ('clutter')
(2)
• Reduced portability/mobility of devices
• Not generally suitable for connecting IoT devices
✔✔ (Any two)
5.2 • Important/High priority internet services e.g. Email is always preferred✔
(1)
(Note to marker: Accept any valid example and explanation.)
5.3.1 Port A/Ethernet port ✔ (1)
5.3.2 Wireless dongle ✔in Gate B✔
(2)
(Note to marker: Do not accept only Port B.)
5.4 • There is not enough bandwidth
• IDV ('ISP') throttled connection
(1)
• Problems with the streaming server
✔ (Any one)
5.5 Encryption✔ (1)
5.6 Provide access to the Internet✔ (1)
5.7 • Connect a computer to the Internet/Connect two networks together (Accept references
to data)
• Create a network/Has the functionality of a switching device ('switch')
(2)
• Offer some connectivity services of a server/Act as a server
• Provide security to the network, e.g. a firewall
✔✔ (Any two)
5.8.1 Wi-Fi /Access Point ('Hotspot')✔ (1)
5.8.2 • If many people are connected, it can slow down the line speed
• Time/Data may be limited
(1)
• Possible restrictions on websites/services available
✔ (Any one
5.9 • Include at least one special character (Accepts an instance of a special character)
• Include at least one capital letter
(2)
• Change the repeating characters
✔✔ (Any two)
[15]

5 | Page
7.1 • Report the offender

• Block the offender from contacting them

• Do not respond to taunts/messages from the bully

6 | Page
 • Avoid Be selective in using social media/Don't initiate a discussion that could lead to (2)
bullying of anyone
• Don't post controversial statements that could open you up to harassment
✔✔ (Any two)
QUESTION 6: INFORMATION MANAGEMENT
6.1 • Search for specific sentences from the report on the Internet to check the original
source/Check Internet search history
• Investigate if no references are given
• Look for words or phrases that are beyond the learner's ability/American
expressions/Some sentences don't seem to fit the writing style
(2)
• Compare work of different learners for similarities
• Check the learner's previous files/folder activity to verify authentic work
• Use online plagiarism software (Accept valid plagiarism detection services, eg Turnitin,
SafeAssign, etc.)
✔✔ (Any two)
6.2 • To offer the respondent a limited choice of answers
• To prevent typing/input errors
• Consistent data for processing/export (2)
• Usually, entering with a drop-down field is faster than typing
✔✔ (Any two)
6.3 • Explain the problem/purpose of research
• Give guidelines for the research
• What information is required
• To determine the scope of the project
(2)
• How to go about collecting information
• How the different applications are used in the research
• Describe the target audience to whom the information will be presented
✔✔ (Any two)
6.4 • Easier to process answers/responses in a spreadsheet/database
• Can read all responses/Poor handwriting is not an issue
• Easy to share data with others/publish dataset (2)
• Data validation of responses can be done
✔✔ (Any two)
6.5.1 A brief summary of the report✔ (1)
6.5.2 • To describe in broad strokes/overview what the report aims to achieve
• To give background information on the topic
• To briefly give an idea of what the researcher did/ research process was to solve the (1)
problem
✔ (Any one)
[10]

7 | Page
QUESTION 7: SOCIAL IMPLICATIONS
7.2 • Less time for work purposes/Waste of time/Lower productivity
• Possible loss of income/profit for the employer
• Risk of malicious software infecting computers
• Employer can be held responsible for crimes committed from the workplace
(2)
• Data costs for the employer may increase
• Company information can be cracked
• Risk to the reputation of the company
✔✔ (Any two)
7.3 • Program errors ('bugs')/corrupt programs can cause the car to not function safely✔
• Cars can be hacked and remote controlled✔
• Weather conditions can hinder the operation of the sensors
• No internet/GPS connection can contribute to inaccurate routes, poor traffic management,
etc. (2)
✔✔ (Any two)
(Notes to marker:
• Accept any valid answer regarding problems associated with driverless/self-driving cars.
Do not accept any answer referring to mechanical problems/breakdown.)
7.4 • Take regular breaks
• Use 'Speech to Text'/Use predictive text options
• Do suitable exercises to relieve tension
• Use ergonomically designed keyboards/devices (2)
• Joint support equipment
• Practice good typing/posture habits that don't overtax your joints
✔✔ (Any two)
7.5 • Withdraws/Dislikes social activities
• Obsessive about their internet activities
• Mental Health Issues/Depression
(2)
• Repetitive stress injuries
• Exhaustion
✔✔ (Any two)
[10]
QUESTION 8: SOLUTION DEVELOPMENT
8.1 ● The 'SHOW FORMULAS' option is enabled/CTRL + ~(tilde)
● The cell is formatted as text
(1)
● Truncation (')/Space inserted before the function
✔ (Any one)

8 | Page
8.2.1 ● The font closing tag </font> must be moved before the body closing tag </body> ●
'Font style' should be 'font face'
✔ (Any one)
(Note to marker:
(1)
● Accept answers that refer to other errors, e.g.
o Extra space before the 'font style' should be removed o
Remove extra closing tag after 'Crowd Funding'
● Acceptif HTML code is rewritten correctly)
8.2.2 Insert a closing tag to close the heading </h1>✔ before the <p> tag (1)
(Note to markup: Accept if HTML code is correctly rewritten)

8.2.3 On the browser tab✔ (1)

8.3.1 Dominant String or 'Wildcard'✔ (1)
8.3.2 To find every record starting with 'Smi…' / When searching for records but only part of the
(1)
search text is known✔
8.4 • 'All files' option is not selected from the list of extensions 'Open dialogue'
• The file has a hidden attribute set
(1)
• Wrong package was used when trying to open the file
✔ (Any one)
8.5 Use the '(Paste) link'✔option when pasting the chart/It has a connection/link to the original
(1)
data/Use the second option in the 'Paste Special' options
8.6 • Change the font/Change symbols to text font
• Use the 'Format Painter' to copy the font over from where it was correct (1)
✔ (Any one)
8.7 Use the 'Manage Sources' option to insert the reference source / Insert a reference source via
(1)
the 'Insert Citation' option✔
8.8 Square brackets refer to a field✔or a table (1)
8.9 Format to Number or General✔ (1)
8.10 • Easy to create table of contents/Allows the use of automatic table of contents
• Consistent formatting of headings/Professional layout of document
• Easy to customize many headers at once (1)
✔(Any one)
(Note to marker: Accept time savings only when motivated)
8.11 Drag the (blue) page break✔with the mouse to manipulate the printable area (2)
[15]
TOTAL SECTION B [72]

9 | Page
SECTION C
QUESTION 9: INTEGRATED SCENARIO
9.1.1 • Tablet is smaller, which makes it more portable and easier to handle when moving
around
• Tablets usually have a longer battery life
• Input can be faster with a touch screen
(2)
• Graphic input, e.g. barcodes, QR codes
• Tablets are easier to sanitize
• Basic ('low-end') tablets are generally cheaper than tablets, in this context
✔✔ (Any two)
9.1.2 • Wi-Fi/Cellular/Bluetooth connectivity
• Front and rear facing cameras
• Expandable storage/Size of internal storage
• Battery life
• (Screen) size (2)
• RAM
• CPU
• Version of Software/Current Operating System
✔✔ (Any two)
9.1.3 • Use an SD card
• Use an (OTG) flash drive/external hard drive
(2)
• Use a cloud storage service
✔✔ (Any two)
9.2 • Can access data from any device with internet access anywhere in the world
• Backup is in a remote location (Accept any reference to the reasons for backing up in a
remote location eg theft, fire, virus etc.
(2)
• More secure than removable drives/No physical damage
(DO NOT accept: Make more space available on the hard drive
✔ ✔ (Any two)
9.3 • Reports can be automatically customized for many individuals
• You don't have to retype every report for every recipient/Save time
• Edit the recipient list ('recipient list')
• No need to type in the addresses of individuals as they are automatically extracted (2)
from a spreadsheet/database
• Formatting/Designing the merged document can be done at once
✔✔ (Any two)
9.4.1 • Experts are misquoted or referred to
• Pretend to be from a reputable author
• Information is presented in a professional/technical format, which appears to be
reliable (1)
• Sometimes shared on social media by people you usually trust
• 'Made up' statistics are made to look believable
✔ (Any one)

10 | Page
9.4.2 • Check the accuracy of the information against other sources
• Check the credibility of the author
• Watch out for bias
(2)
• Use checking services like Snopes
• Check the spelling and grammar
✔✔ (Any two
9.5.1 • Lumens/Brightness
• Lamp type
• Lamp life
• Image quality e.g. contrast ratio ('Contrast ratio')/Color depth, etc.
• Aspect ratio ('Aspect ratio')
• Remote control
• Connectivity options/Compatibility with existing devices
• Image capture ('invert')/rotation/'keystone'
(2)
• Refresh options/Response time
• Zoom options/Lens adjustment
• Short and long-distance display
• Portability/Physical Size
• Built-in speakers/microphone, etc.
✔✔ (Any two)
Displaying movies is not graphics intensive /Built-in graphics specifications are sufficient to
play video
9.5.2 Displaying movies is not graphics intensive /Built-in graphics specifications are sufficient to
(1)
play video✔
9.5.3 INTERNET RISK PREVENTION
(1) Malicious software (1) Install antivirus software, keep antivirus
(Malware) software up to date
(2) Unauthorized access/ (2) Use a firewall/Enable the firewall/Use a
Hacking strong password
(3) (Cyberattacks)/Vulnerabilities (3) Verify sender, check security of websites,
change passwords regularly, keep system up
to date
(4) Phishing ('Phishing') /Social (4) Do not give out personal details, do not click (2)
manipulation on suspicious links

✔(Any one internet risk) ✔(Any one way to prevent attacks) (Notes
to marker:

▪ Accept only one example of each risk.

▪ Preventive measure must relate to the risk
▪ Accept any valid preventative measure that is well explained

11 | Page
9.6.1 • Turn off computers/devices when not in use • Select power
saving options on the devices
(2)
• Buy energy efficientcomputers/components
✔✔ (Any two)
9.6.2 To temporarily supply power to a computer✔to shut down in case of a power
failure/Protect the computer from power fluctuation (1)
9.6.3 Power is used to charge batteries✔ (1)
9.7.1 Fix a program error in software✔ (1)
9.7.2 • Disk Defragmenter/Defragmentation
• Disk Cleanup
• System Restore
• Resource monitor
• Manage startup ('startup') programs through task manager ('task manager') • (1)
ScanDisk
✔ (Any one)
(Note to marker: Accept any valid third-party software, eg System mechanic, CCleaner, etc.).

9.8 • Missing separators/comma/comma/border symbol

• COUNTIF cannot check if all three ratings in each row are greater than 7/Wrong
function/COUNTIFS not used
• The condition must be greater than 7 only
• Series/s must always be in a single row
✔✔ (Any two (2)
[26]
QUESTION 10: INTEGRATED SCENARIO
10.1.1 • Online lessons/virtual meetings/streaming of lessons/webinars etc.
• (Educational videos/pictures
• E-books/electronic notes etc.
• Online quizzes and tests
• Simulation applications (2)
• Pot throws/audio files/pre-recorded lessons
• Teaching ('tutorial') applications
Note to marker: DO NOT accept any examples such as Zoom, Google Classroom, etc.)
✔✔ (Any two)
10.1.2 • Comments ('Comments')
• Track changes
• Clarification/Different font colors to indicate issues (2)
• Hyperlinks/Embedded links
✔✔ (Any two)

12 | Page
10.2.1 • Easy capture through forms
• Inquiries based on criteria
• Easy to do reports
(1)
• Use of functions/calculations in summary/report
• Data does not require extensive number-crunching/operations
✔ (Any one)
10.2.2 Import the data from the database/ Export the data to the spreadsheet/Copy and paste
(1)
the data into a spreadsheet✔
10.2.3 Right click on the chart and select 'Save as picture'✔ (1)

10.3.1 • No clutter of cables/Easier to manage

• You don't have to be very close to the computer
• Less time consuming as several guests will be able to transfer data at the same time (in (2)
real time).
✔✔ (Any two)
10.3.2 • Reduce the resolution of the photos
• Crop the photos
(1)
• Change the images' format/Compress image together ('Compress')
✔ (Any one)
10.3.3 Flash drive /CD or DVD/External hard drive/SD card/Notes ('Handout') ✔ (1)
10.4 • Resolution/DPI
• Print speed
• Linking options, e.g. network enabled
• Printer Capacity (Industrial Level)
(2)
• Multi-function capability, e.g. copier, scanner, etc.
• Paper size
• User interface options
✔✔ (Any two)
10.5 • Recycle the components
• Reuse working components
(2)
• Use an e-junk disposal service provider
✔✔ (Any two)
10.6.1 • Additional layer of access control for employees
• To prevent theft
(2)
• To prevent physical damage/vandalism
✔✔ (Any two)
10.6.2 • Data theft
• Flash drives often have viruses
• Prevent employees from connecting other devices
(2)
• Prevent employees from bringing in games and personal documents that can waste
work time
✔✔ (Any two)

13 | Page
10.6.3 • Automatic updates can use a lot of bandwidth/storage space
• Updates can slow down the network
• Update may cause computers/network to become unstable/Possible introduction of
(2)
program errors
• Some features of the BS are not required by the users
✔✔ (Any two)
10.7 • Backup only when the computers are not in use
• Do not store backup copies in the same location
(2)
• Choose a reliable storage medium
✔✔ (Any two)
10.8 • Video chat ('chat')

• To take selfies (1)

• Security/Biometric security
✔ (Anyone)
[24]

14 | Page
PRACTICAL SECTION
Marking: Use Reveal Formatting (Shift + F1), Alt + F9 to mark fields, switch Show
Hide on.
QUESTION 1: WORD PROCESSING - 1Oversharing

Maximum Learner
No Criteria
Mark Mark

1.1.1 Heading: Social media oversharing ...

1
Text changed to Small Caps ✓ 2
Font size changed to 16pt ✓ 1

1.1.2 Heading is centered ✓ (centre aligned)

1 1

1.2 Footnote:
1
Footnote inserted ✓ (no space between footnote and text)
custom mark: symbol  ✓ 1 3
Footnote text: ‘cybersecurity expert. ✓ (Hover mouse over
1
footnote to see text)

1.3 Picture
1
Text wrapped to Tight / Square / Through ✓
Picture position to right of first two paragraphs ✓ 1 3
Bottom left of picture next to “concensus”. ✓ (accuracy)
1

1.4 Style: Sharing

(mark in Styles, Modify)
Paragraph spacing changed to 10 pt before ✓
Style Automatically updated. ✓ 1
2
1

1.5 Paragraph : There is a growing ...obtain elsewhere”

1
alignment justified ✓
1 3
paragraph spacing after at 6 pt. ✓
line spacing to multiple at 1.3. ✓ 1

1.6 Hyperlink points only to https://www.verizon.com/. ✓ 1 1

15 | Page
 (hover mouse over red hyperlink, ignore full stop if it was
added, no marks awarded if link was recreated)

1.7 Citation p2:

Author changed to Brian Pinnock ✓ 1
Year is suppressed ✓ 2
1
(Displays only Pinnock in citation, looses first mark if citation
was recreated)

16 | Page
1.8 Bulleted List
Webding symbol 230 was used ✓ 1
Bullet indent at 1cm and text 0.8 cm from bullet ✓
1 3
Keep with next ✓
1
(If numbered list was not changed, but second and third
marks as above are correct, award 2 marks)
1.9 Hyperlink
(to mark: click right on arrow, Edit Hyperlink) 1
2
On orange arrow ✓
1
Links to top of document ✓

1.10 Bibliography:
1 1
Bibliography inserted ✓
TOTAL 23

17 | Page
QUESTION 2 WORD PROCESSING: Q2PewDP

Learn
No Criteria Maximum Mark er
Mark
2.1 Alternative text: 1
Author details (Werner Geyser) appear in the author
1
section ✓
(hover mouse over file in folder or open properties)

2.2 Footnote: 1
Footnote converted to endnote ✓ 1
(note appears on last page only – no longer on page 1)

2.3 Picture: 1
1
Flipped to display and read correctly ✓

2.4 Capital A: 1
1
Changed to Dropped cap ✓ (not in margin anymore)

2.5 Synonym for ‘troubled’: 1

Any one of the following synonyms use from the
thesaurus list:

2.6 Table 1
From “Net Worth…” to “…2023” converted to a table ✓
1
Fixed width ✓of 8 cm ✓
1 3

(If only one column width 8 cm loose second mark)

2.7 Track Changes

Deleted text rejected  (Markup Paragraphs remain) 1
2
tracking stopped  (markups indications have been
removed) 1

18 | Page
(Reject all changes and stop tracking)

19 | Page
2.8.1 Table
1
Repeat header rows activated ✓
For both heading rows ✓ 1
2

(1st two rows shows on second page of table, ignore if

text is white)
2.8.2 Formula at end of Views column:
1
(Alt + F9 - {=Max(Above)}
2
=Max ✓ (Above) ✓ 1
(Mark function, not answer)

2.9.1 Table 1
Split table✓ (2 separate tables)

2.9.2 Video with the highest number of views (Saying 1

Goodbye is Hard) added to dropdown ✓

2.9.3 Last cell: Text field replaced with Calculation field ✓ 1

(accept number field)

2.10 Automatic page numbering 1

In footer ✓ 2
1
Format X of Y ✓

Total for QUESTION 2 [19]

20 | Page
QUESTION 3 SPREADSHEET - 3UsersGebruikers
NOTE:

• Use formulae and/or functions for ALL calculations in the spreadsheet.

• Use absolute cell references ONLY where necessary to ensure that formulae are.
correct when you copy them to other cells in the same column (copy down).
• Insert formulae and/or functions in such a manner that the correct results will still be obtained even if the
existing data changes.
• Should you need to use building blocks, use the allocated space in the spreadsheet.

NO. Criteria Maximum Mark Learne

r Mark

UserDetails sheet:

3.1 Row 2 formatting: 1

1
• Formatting the same as row 1 (blue pattern fill) ✓

3.2 Row 3 height: 1

1
• Row height changed to 15 pt ✓

3.3 Row 7 Alignment: 1

All headings in row 7 horizontally and vertically centred. ✓

3.4 Conditional formatting column E:

= D8 ✓or $D8 or D8:D107 1

(if absolute cell reference at both column and row loose first mark)
1
> 1000✓
cells in E8:E107 ✓ 1
filled with any background color ✓ 4
Check Building blocks. 1

(No marks if cells are filled by hand.)

3.5 Cell C4: 1

=MAX(G8:G107) OR =LARGE(G8:G107,1) ✓ 1

21 | Page
3.6 Cell C5: 1
=ROUNDDOWN(AVERAGE(D8:D107),0) 1
• AVERAGE(D8:D107) ✓
1 3
• ROUNDDOWN function ✓ (not formatted)
• ,0) ✓
(R1487,33 becomes R1487,00 – question asks to ROUND DOWN)

3.7 Cell I8: 1

=DATE(YEAR(H8), MONTH(H8) +G8, DAY(H8)) 1

• +G8 ✓ added to the month

3.8 Cell J8: 1

=VLOOKUP(A8,Applications!$A$1:$B$11,2,FALSE)
1
• A8 ✓
• Applications!$A$1:$B$11✓ or Applications!$A$2:$B$11 1

1
or named range created ✓ (absolute optional)
• 2 4
• FALSE✓

Lose 2nd mark if copied to same sheet

OR (in Office2021 or 365)

3.9 Graph sheet: 1

• Stacked 3facebook image in the Facebook column. ✓ 1

• Filter option used to remove the Twitter column. ✓
1
(Data not removed from the original sheet) 5
• Both axis titles added ✓ 1
• Data labels outside end✓ 1
• X-Axis: Custom angle: -45°✓ (mark by inspection)

22 | Page
 •
Total for QUESTION 3 [21]

23 | Page
QUESTION 4 SREADSHEET – 4GameSpeel
NO. Criteria Maximum Mark Learne
r Mark

Scores_Punte sheet:
1
4.1 Column I: Data validation:
“Black” removed from all cells (check first and last cell) ✓ 1

(Note: award mark only if removed from all cells)

5
4.2 Cell H191: =SUMIFS(M3:M189,H3:H189,"F",F3:F189,"WC") 1
=SUMIFS(M3:M189, ✓
1
H3:H189, ✓
"F” ✓ (Criteria and ranges could be swopped, but must correspond) 1

F3:F189, ✓ 1
"WC") ✓
1
(If cell references were used for criteria, deduct mark for first criteria, but
award for second).
4
4.3 Cell G7: Code
1
Take note that first part of function was given. Only calculations/
functions in bold below are to be assessed.
=CONCATENATE(LEFT(B7,1),LEFT(C7,1),F7,LOWER(H7),LEFT(I7,1),YEAR(D7) 1
=CONCATENATE(LEFT(B7,1),
LEFT(C7,1),
1
F7, ✓
LOWER✓ (H7), ✓ (brackets around H7)
LEFT(I7,1), 1

YEAR(D7) ✓
(If original functions have been changed or deleted, loose first mark)
6
4.4 Column N: Nested IF
Take note that first part of function was given.
1
=IF(E3>50,$N$1*0.9,IF(E3<25,"",$N$1*0.95))
Or
=IF(E3>50,$N$1-$N$1*10%,IF(E3<25,"",$N$1-$N$1*5%)) 1

Check building blocks if cell references differ.

=IF(E3>50,$N$1 - only greater than 50 ✓ 1

*0.9, ✓
IF(E3<25, ✓ 1

"", ✓

24 | Page
 $N$1 ✓
1
*0.95)) ✓
If learner understood that only the discount must be displayed, accept the
1
following:
=IF(E3>50,$N$1*10%,IF(E3<25,"",$N$1*5%)) or correct variations.
4.5 1 4
Cell O3: Bonuspoints: =MAX(J3:L3)/RANDBETWEEN(5,10)
=MAX(J3:L3) ✓ 1
/ ✓ RANDBETWEEN ✓ 1
(5,10) ✓
1

Total for QUESTION 4 [20]

25 | Page
Question 5: Database 5SocialMedia

Learne
Item / Criteria Max Mark
r Mark

No Table: tbl5_1

5.1.1 Surname field size: any value smaller than 50✓ 1 1

5.1.2 Participant_Code: Input mask: 00 ✓ 1

“&” ✓ or /& 1
4
> ✓ 1
LL ✓ or ?? 1

5.1.3 WIFI field Datatype: Yes/NO✓ 1 1

5.1.4 Favourite_Social_Media (mark in Lookup tab)

Combo box ✓ 1
Select from [Social Media] ✓ 1
Order by Social Media ✓ 1
Limit to list: Yes ✓ 1
4

26 | Page
Question 5: Database 5SocialMedia

Learne
Item / Criteria Max Mark
r Mark

5.1.5 Hours_per_day: Validation rule

>= 0 ✓
And <12 ✓

OR
Between 0 ✓
1
and 11 ✓ 2

27 | Page
5.2 Form: frm5_2
Picture fit in frame ✓ or border adjusted to display picture correctly.

MoneySpent = Currency ✓
Command Button✓ 1

Caption: Print Form✓

1

Arrangement of fields ✓

28 | Page
Question 5: Database 5SocialMedia

Learne
Item / Criteria Max Mark
r Mark

Query: qry5_3
Gender Female ✓
SocialMedia_1 Facebook ✓ 1
Untick Gender and SocialMedia_1 Show boxes ✓
5.3 (Expect 14 records) 1 3

Query: qry5_4
Query qry5_4 named correctly ✓
SocialMedia_1: Group by✓ 1
SocialMedia_1: Count✓
1

5.4 3
1

Query: qry5_5 1
Sorted descending according to Hours. ✓
1
Field: MoneySpent criteria >=150 ✓
1
Calculated field:
New field: Price2023 ✓: 1

5.5 Calculation: [MoneySpent] ✓ * 1.12 ✓ 6

1
Formatted to Currency ✓
1

OR

29 | Page
Question 5: Database 5SocialMedia

Learne
Item / Criteria Max Mark
r Mark

5.6 Report: rpt5_6

1
Gender label and field removed ✓
1
Grouped on SocialMedia_1 field ✓
Function in group footer or header: ✓ 1
=avg ([MoneySpent]) ✓ 6
1
Formatted to two decimals✓
Suitable label✓ 1

(If not in group header or footer, do not award 3rd mark, but award 1
remaining marks that are correct. )

TOTAL 35

30 | Page
 CANDI
QUESTION 6: WEB DESIGN (HTML)
MAXIMUM MARK DATE
MARK

6Media.html web page ✓

6.1.1 Title Tag: <title>Social Media</title>

1 1
• text " Social Media " in title tags.✓

6.1.2 Heading 1 style

<h1>Importance of Social Media in today's world</h1> 1 1
• Heading 1 style applied to correct text ✓

6.1.3

• font face=Comic Sans MS✓

(Deduct mark at bottom of marking guideline if closing font tag 1
was inserted at incorrect position)
1
• font color=red✓ 4
1
• <i>Entertainment</i>✓
1
• <u>Social media platforms</u>✓

6.1.4

• ordered list <ol></ol>✓ 1

2
• type =”a”✓
1

31 | Page
6_2Table.html web page

6.2 Cellspacing = 10 (inside table tag) ✓

1
<td >…..</td> inserted ✓ (accept <th> …</th>)
1
rowspan = 4 ✓ (inside above <td>)
1
Picture moved to correct position ✓ 6

(do not award mark if there are two pictures) 1

<img src=”6Social media.jpg”✓ (correct name of picture) 1

alt = “Social media and users”> ✓

1

Correct use of nesting, closing tags and triangular brackets. ✓ 1 1

[15]

32 | Page
QUESTION 7: GENERAL

7StatsReport LEARNE
MAXIMUM MARK
R MARK
✓
7.1.1 7GlobalStats picture inserted at correct position ✓ 1
Size adjusted to 6 cm high exactly ✓
1 3
10 cm wide exactly ✓
(aspect ratio tick removed) 1

7.1.2 Linked graph:

If document opens with message about link that must be
updated, award both marks. ✓✓
1
Choose No to continue.
2
1

If graph was pasted without link or as icon = 1 mark. ✓

7.1.3 7Info spreadsheet, on Name sheet:

Mark in Name Manager in Formulas:

2
1

Named range A2:F10 ✓

Called CI ✓

7Influencers database

7.2.1 Type table appended (one table only) ✓

99 records in total if done correctly ✓ (original table contained
1
14 records)
2
(If a second table was created containing 85 records named 1
Add award second mark
Open table to make sure it is not empty

33 | Page
frmType
7.2.2 StartDateBeginDatum field: >=#2018/01/01#
>= ✓
#2018/01/01# ✓ (do not accept 2018 only)

1
2
1

OR
>#2017/12/31#
AmountBedrag field:
Conditional formatting: 1
Compare to other records ✓
1 3
Green bar ✓
1
Show Bar Only unticked ✓

Function:
In footer ✓ 1
SUM function and appropriate label ✓
Correct field and brackets ✓ 1 3
(If done correctly somewhere else do not award first mark)
1

34 | Page
[17]

TOTAL: 150

35 | Page