CAPS Computer Applications Technology 11 – Leaddership

Free

CAPS Computer Applications Technology 11

Alabi Arnold

CONTENT AND SCOPE PER TOPIC

Solution Development

Word Processing

File management
Advanced document layout
Customising
Reviewing tools and proofing functions
Electronic forms
Mail merge
Styles
Sections
Reference functions
Integration techniques
Troubleshooting

Spreadsheets

Advanced formatting
Advanced formulas and functions
Error indicators
Graphs/charts
Manipulate worksheets
Import/export data
Integration techniques
Troubleshooting

Databases (N/A)

Basic skills and basic knowledge in working with

Tables: Records, fields and data types
Record manipulation
Basic field properties
Formatting and editing
Forms
Basic data validation
Basic queries
Simple reports
Calculations
Integration techniques

Fourth Applications

Html / Web design
What is HTML?
HTML syntax
Basic HTML tags
Basic text and text formatting
Structure of a simple HTML page
HTML links
HTML images
HTML lists

Systems Technologies

Introduction to Concepts of Computing

Information processing cycle
Role of ICTs
Types of computers
Computer categories

Hardware (systems unit)

Input, output, storage and processing
Mobile technology
Portable devices
Devices for physically challenged users
Alternative I/O and storage devices

Software

Software updates, versions and compatibility
Application software
System software
Web applications
Software for physically challenged users
System requirements
Help files

Computer Management

Software installation
File management
System properties
Basic trouble-shooting

Network Technologies

Networks

Types of network: LAN and WLAN
Basic components of network
Connection
Intranet
Introduction to network security concepts

Internet Technologies

Internet and WWW

Overview of online services
Features of browsers
Web page and websites
Website usability issues
Limitations of fixed Internet access
Portable and mobile Internet access

Electronic Communication

Types of digital communications
Uses of computer communications
Managing e-mail

Information Management

Find and access data and information

Task definition in different contexts – understanding the problem/task
Questions and questioning
– Utilising main question
– Formulating other questions
– Quality control of questions
Indentifying appropriate sources
Information and data gathering
– Add questions to questionnaire
– Using one other source
Quality control of information

Process data and information

Extracting appropriate information
Utilising appropriate tools and techniques to process data/ organise and manipulate information
Processing dataAdding data questions
Data handling – the role of the spreadsheet and the database
Analysis of data and information – Trends and patterns

Present solution

Utilising appropriate software tools to communicate findings
Report
Interpreted knowledge and understanding
Cohesive and logical organisation and flow of content and recommendations/conclusions
Communication using supporting texts and graphics
Copyright and plagiarism issues
Appropriate referencing

Social Implications

Impact on society

Enhancing accessibility
Computer and human error
Impact of ICTs in the workplace and employment practices
Social engineering tricks
Online safety and protection issues

Legal and ethical and security issues

Hardware theft and vandalism
Ethical use of networks
Unauthorised access
Network safety and security
Privacy issues
Information accuracy
Data protection
Computer misuse
Currency of protective software

Health and ergonomic issues

Factors that influence health
Health risks

Environmental issues

Power settings and savings