4.

2 Grade 11
Term 1
Overview and introduction (±½ week / 2 hours) Spreadsheet (±3 weeks / 12 hours)
x Information processing cycle including communication x Reinforce content, concepts and skills from Grade 10
x Advantages and disadvantages of using computers x Absolute cell referencing
x Types of computers and typical features x Autofill options
- Dedicated devices such as ATMs and electronic x Using spreadsheet functions such as round, small, large,
appliances countif, counta, countblank, sumif, power, rand
- Mobile computers and devices such as PDAs x Rounding off numbers and the difference between
- Client / server rounding and formatting
x Categorise computers x Conditional formatting
- Portable (mobile) / non-portable x Interpreting error indicators such as: circular reference
- Processing power
- Usage
x The role of ICTs in contexts such as home, communication,
business, education, banking, travel
x Particular technologies being used for specific purposes
Hardware (±1 week / 8 hours) Word Processing (±3½ weeks / 14 hours)
Input x Reinforce content, concepts and skills from Grade 10
x Scanners and digital cameras x File management
x Input via PDAs, smart phones, tablet PCs, data collection - Print (including options such as range of pages, odd or
devices even, number of copies, print quality), send to (e-mail,
x Terminals (POS), ATMs internet fax), convert, properties
x Alternative input devices such as virtual keyboards, optical x Input data from different file formats, e.g. text files, tables
keyboards - Editing: Paste special, find, replace (more options)
x Input devices for physically challenged users - Page layout: Themes and background
x Wireless technology x Document layout
x Advantages / disadvantages / limitations of input devices - Section breaks and sections
x How to use - Headers and footers (including date, path and
x When to use filename)
x What software / other equipment are required, e.g. device - Page numbers, different first page, odd, even
drivers, OCR? x Paragraph
Output - Customise bullets and numbering
x Display devices - Customise spacing
- What determines the quality of monitors and printers? x Autocorrect
- Current trends and new technology: plasma, HD- x Customise templates
technology x Import / export data
x Software and input and output devices for physically x Online and offline help
challenged users
x Wireless technology
x List advantages / disadvantages / limitations of output devices
x How to use, when to use
x What software / other equipment are required, e.g. device
drivers?
Application Software (±½ week / 2 hours) Presentations (±1 week / 4 hours)
x Understand the role of application software x Reinforce content, concepts and skills from Grade 10
x Function / purpose / role of different types x Slide transitions
x Compatibility x Animations, sound, video
x When / where to use x Design themes and tools
x Web tools such as blogs, wikis x Print and view options such as handouts, slide master
x Help files x Set up and customising slide show
x Problem solving using presentations
x Troubleshooting presentations
Social Implications (±½ week / 2 hours)
x Social issues applicable to the above content
x Unauthorised access, ethical use of computers, networks and recourses, safe Internet use, green computing issues
Assessment (PoA): 1 Practical Test + 1 Theory Test
Reporting: Add raw marks and totals and convert to % for term mark.

21|P a g e 
Term 2
Hardware (±1 week / 4 hours) Database (±2 weeks / 8 hours)
Storage x What it is it used for?
x Online storage x First looks:
x HD and Blu-ray technology - Objects: Table, form, query, report
x New technology x Tables: Records and fields, field names
x Interpret adverts - Basic field properties: size / length, default value,
x Basic troubleshooting decimal places, required
x How to write CDs, DVDs x Data types
x Primary storage (memory) vs. secondary storage - Text, Number, Date and Time, Currency, Autonumber,
x List advantages / disadvantages / limitations of storage Yes/No, Memo
devices x Database structure
x How to use, when to use x Primary key
x Concepts of new trends such as cloud computing x Create tables and forms
Processing x Enter data (records)
Understand the role of basic components of the system unit x Add and delete records, fields
- Motherboard – houses components x Formatting and editing
- CPU – processing x Sort
- RAM – holds data and instructions during processing / x Page headers, footers (design view)
execution x Report headers, footers
- ROM – stores start-up instructions x Basic data validation techniques
x Start-up process x Use filters
x Work with different views, e.g. design view, table view
Networks (±1 week / 4 hours) Spreadsheets (±1½ week / 6 hours)
x Local area networks (LAN and WLAN) x Simple IF function
- What is it? x Use of relational operators (> < <= >= <>) in simple IF
- Where is it used? functions
- Definition, purpose, role, uses x Create, format and edit charts using including meaningful
- Examples titles and labels, gridlines, legends and options appropriate
- Function to the graph type chosen
x Basic components of a network– concepts only x Integration techniques
- Workstations and servers Word Processing (±1 week / 4 hours)
- NIC x Styles
- Switch
- Communication medium
- Communication software
x Connection
- Wired vs. wireless
- Data transmission speed
x Log in / log off
x Intranet – What is it? Uses
x Basic network security such as passwords, usernames and
access rights
Information Management (±1 week / 4 hours)
x Reinforce content, concepts and skills from Grade 10
x Task definition, data and information gathering
x Evaluate sources: Purpose, author, objectivity, coverage, currency, recognition
x Evaluate websites: Navigation and usability, authority, content validity
Social Implications (±½ week / 2 hours)
x Social issues applicable to the above content
x Unauthorised access, ethical use of networks, network safety and security issues, privacy issues – spyware, adware, spam,
respect privacy and products of others
Assessment (PoA): 1 Assignment + 1 Examination – 1 Practical Paper + 1 Theory Paper
Reporting: Add raw marks and totals and convert to % for term mark.

Note:
It is important to note that application packages share common features (formatting, editing, page layout, illustrations, etc.)
that are reinforced when dealing with the different packages and as these features may take up more with the first
application taught, they take up less time when teaching subsequent packages.

22|P a g e 
Term 3
Database (±3 weeks / 12 hours) Spreadsheets (±1 week / 4 hours)
x Design basic queries using and, or, not and sorting x Import / export data
options x Help files
x Selecting which fields to display in a query x Work with sheets: move, copy, headings, protect, gridlines,
x Design basic reports using a wizard freeze panes, etc.
x Choosing appropriate data types x Use different print options such as print area
- Text, Number, Date and Time, Currency, x Integration techniques within package, e.g. linking cells and
Autonumber, Yes/No, Memo, OLE object, Hyperlink, formulas between sheets
Lookup Word Processing (±1 week / 4 hours)
x Field properties
x Mailings
- size / length, default value, decimal places, required, - Mail merge
input mask, validation rule, validation text, alignment
x Reference
x Basic calculations at end of report such as: sum, avg, - Table of contents
count, min, max - Captions
x Import / export data - Citations and bibliography
System Software and Computer Management (±1½ weeks / 6 hours)
x Types of system software
x Where does the operating system reside? Do theoretically and reinforce practically where appropriate
- Different types of computers, e.g. PC, PDA
x Management of desktop
x Management of files: File types, properties, file attributes such as read-only and hidden, import, export, search
x Add devices: Role of drivers, plug and play
x Operating system utilities such as:
- Install / uninstall, disk scanner / defragmenter, backup / restore, archive, search utility
- Compress / decompress files and folders, security features such as control of spyware, adware, firewall
x Determine and set basic system properties such as the resolution and refresh rate, volume setting, etc.
x Function / purpose / role; How / where / when to use
x Basic troubleshooting using utility software
Communications (±1 week / 4 hours)
x What is a communication network?
x Communication system
- Two or more computers, communication devices, communication channel
x Types of digital communications such as e-mail, instant messaging, text messaging, picture / video messaging, smart phones,
VoIP (Skype), etc.
- Advantages and disadvantages, Good practices
x Common examples of Web browsers
x Uses of computer communications
x Communication devices: Wireless modem / router
x New trends and technologies
Information Management (±2 weeks / 8 hours)
x Role of spreadsheet and database to process and manipulate data to provide information
x Reinforce content, concepts and skills through application packages and PAT
Social Implications (±½ week / 2 hours)
x Social issues applicable to the above content:
x Computer and human error and the effects thereof such as accuracy and validity – data input, data types used, e.g. database,
Verification and validation of data, software bugs, hardware failure, how ICTs affect communication, decision-making, e.g. data
analysis
Assessment: 1 Practical Test + 1 Theory Test
Reporting: Add raw marks and totals and convert to % for term mark.

23|P a g e 
Term 4
Hardware and software (±½ week / 2 hours) Spreadsheets (±½ week / 2 hours)
x Categorise hardware and software x Consolidate and reinforce content, concepts and
x Web-based software – what is it? skills to this point
x Basic system requirements, e.g. hard disk space, CPU, RAM – what x Plan and design own documents for specific
does it mean? How does it link with software? scenarios and inquiries
x Software and input and output devices for physically challenged users x Integration with other packages
x Problem solving using spreadsheets
x Troubleshooting spreadsheets
Documents (Word processor, spreadsheet, presentations, database) x Database (±1 week / 4 hours)
(±1½ week / 6 hours) x Formatting techniques to fields, records, tables,
x Use integrated software effectively and efficiently to reproduce and forms, queries, reports
create documents that incorporate text, graphics and data x Integration with other packages
x Manipulate graphics and text within documents. x Problem solving using database
x Use integrated software to create and design documents for specific x Troubleshooting database
purposes
x Apply general principles of layout and design to a document process
x Emphasise information using techniques such as placement, colour
Word Processing (±½ week / 2 hours)
x Create documents by customising templates
x Mail Merge
x Use media, visual literacy and technology skills to create products that - Envelopes and labels
express understanding
x Integration with other packages
Communications (±½ week / 2 hours) Communications (Practical) (±½ week / 2 hours)
x Evaluate websites – basic areas x Managing e-mail:
- Navigation and usability - Organise using e-mail folders
- What does the URL tell you? - Sort by, flag, prioritise
x New trends and technologies - Distribution lists, message rules
x Planning and designing communication solutions for specific scenarios. x Register a Web-based e-mail address
Content using case studies (±1 week / 2 hours)
Consolidate content, concepts and skills using case studies to:
x identify general hardware configuration of a computer in terms of the processor, memory and hard drive size
x understand computers and their uses
x understand how technology helps one to operate more efficiently, effectively and more accurately
x know how to use computers as tools to access information and to communicate with others around the world
x make better buying decisions – interpret advertisements and make judgements about quality and usefulness when buying
equipment, software
x know how to fix ordinary computer problems and deal with challenges that arise with utilising computers
x know how to use the Internet and e-mail
x make informed decisions and choices in selecting communication devices and modes of communications for a given scenario
x know what kind of computer uses can benefit them and advance them in whatever work they do / career path they will follow
x know how to protect themselves against online villains and threats.
x know how to apply digital tools to communicate, gather, analyse, use information and solve problems
x understand technology concepts, systems and operations
x recommend specific hardware / software for a specific scenario
Information Management (±1½ weeks / 6 hours)
x Reinforce content, concepts and skills in finalising PAT
Social Implications (±½ week / 2 hours)
Social issues applicable to the above content
x Social engineering tricks such as phishing
x Information accuracy, data protection, threats, computer misuse
x Acceptable use policies of schools, Internet and networked services
x Document sources obtained electronically, e.g. website addresses, plagiarism
x Protecting oneself when online – online harassment, stalking and bullying, malware and security software, e-commerce and e-
banking (HTTPS, etc.), social network sites, chat rooms, etc.
x Why anti-virus and anti-spyware programs need to be updated and how they function
x Different software settings in terms of how it effects the ease of use of the interface, e.g. for physically challenged, elderly users
x New physical environments with respect to ergonomics
x Usability – definition and usability features in operating system
Assessment (PoA): Practical Assessment Task + 1 Examination – 1 Practical Paper + 1 Theory Paper 1
Promotion Mark: Convert term marks to 25%, Convert PAT mark to 25%, Convert Paper 1 to 25%, Convert Paper 2 to 25%

24|P a g e