Grade 11

THEORY LESSONS AND WORKSHEETS

Covid 19 Summary of All Theory Content to assist with accelerated Teaching

System Technologies:


Term 1: General Concepts

INFORMATION PROCESSING CYCLE, TYPES OF COMPUTERS, ROLE OF ICTs IN THE WORKPLACE, VALUE OF CAT


Term 1: Hardware

INPUT, OUTPUT, DRIVERS, P&P, OTHER EQUIPMENT, OCR


Term 2: Hardware

STORAGE, PROCESSING (MB, CPU, RAM, ROM), ADVERTS, TROUBLESHOOTING


Term 3: Software

APPLICATION SOFTWARE, FUNCTION, COMPATIBILITY, VERSIONS (PATCHES + SERVICE PACKS), UPDATING, DISABILITIES, CLOUD STORAGE, CLOUD BASED APPS


Term 3: Hardware, Software and Computer Management

BASIC SYSTEM REQUIREMENTS, SOFTWARE INSTALL AND UNINSTALL, BACKUPS, DISK CLEAN AND DEFRAG, MANAGEMENT OF FILES (TYPES, PROPERTIES, ATTRIBUTES, SEARCH)


Social Implications:


Term 1

IO DEVICES FOR DISABLED, ACCESSIBILITY, HARDWARE THEFT, POWER SETTINGS, HEALTH, CAREER OPTIONS


Term 2

SOCIAL ISSUES, UNAUTHORIZED ACCESS, ETHICAL USE, AUP, NW SECURITY, SPYWARE, ADWARE, BOYD, PRIVACY, BIG DATA, CRYPTO CURRENCY


Term 3

GIGO, DATA VERIFICATION, BUGS, HARDWARE FAILURE, ICTs IMPACT ON THE WORKPLACE, MOBILE OFFICES


Term 4

SOCIAL ENGINEERING, ACCURACY, DATA PROTECTION, COMPUTER MISUSE, PROTECTING ONESELF ONLINE, HOW ANTIVIRUS WORKS, COMMERCE AND BANKING


Network Technologies:

Term 2: Networks

LAN, WAN, P2P, NIC, CONNECTION DEVICES, COMMUNICATION MEDIUM, NETWORK SOFTWARE, WIRED AND WIRELESS CONNECTIONS, SPEED, ADVERTS, INTERNET VS INTRANET, NETWORK SECURITY

Internet Technologies:


Term 3: Internet, WWW and Communications

VoiP, VIDEO CONFERENCING, TYPES OF DIGITAL COMMUNICATION, ONLINE SERVICES, IoT, 4IR, SOCIAL NETWORK SITES, WiFi, WiMAX, Bluetooth, NFC, LTE, PORTABLE vs MOBILE, CELL PHONE AS MODEM, BROWSERS AND EMAIL SOFTWARE


Term 3: Internet and the WWW

USABILITY OF WEB PAGES, EVALUATE SITES, IoT TECHNOLOGIES AND IMPACT ON SOCIETY


Term 4: Communications

MANAGING E-MAIL


PRACTICAL RESOURCES: DBE-Textbook

Additional Resources on all Applications


Revision:


WORD PROCESSING


Chapter 1 - File Management in Word Processing

PRINTING, PRINT TO FILE/PDF, SEND, SHARE, IMPORT EXPORT DATA


Chapter 2 - Templates and Input data in Word Processing

SAVE AS TEMPLATE, INPUT FROM DIFFERENT FORMATS, IMPORT, EXPORT


Chapter 3 - Editing in Word Processing

PASTE SPECIAL, FIND AND REPLACE:


Chapter 4 - Page and Document Layout in Word Processing

THEMES, COVER PAGES, SECTION BREAKS, HEADERS AND FOOTERS, PAGE NUMBERS, COLUMNS, PARAGRAPHS: BULLETS AND NUMBERING, SPACING, DROP CAP


Chapter 5 - Electronic Forms and Online/Offline Help

LEGACY TOOLS, ONLINE/OFFLINE HELP


Chapter 6 - Styles

HEADINGS AND PARAGRAPHS: CHANGE, EDIT, CREATE


Chapter 7 - Mailings & References

MAIL MERGE: SOURCES, LETTERS, LABELS,REFERENCES: TOC, TABLE OF FIGURES, FOOT AND ENDNOTE, CAPTIONS, CITATIONS, BIBLIOGRAPHY, INDEX


SPREADSHEETS


Additional Resources on Spreadsheets:


Chapter 8 - Spreadsheet Formatting

CONDITIONAL FORMATTING, ABSOLUTE CELL REFERENCING, ROUND, SMALL, LARGE, COUNTA, COUNTBLANK, COUNTIF, POWER, ROUNDING OFF, ERRORS (CIRCULAR REFERENCE & #NULL)


Chapter 9 - If functions and Charts

OPERATORS, IF FUNCTION, COUNTIF, SUMIF, CHARTS (CREATE, FORMAT, EDIT, LABEL, GRIDLINES, LEGENDS, TYPE), INTEGRATION


Chapter 10 - Working with Spreadsheets

IMPORT/EXPORT DATA, HELP FILES, SHEETS (MOVE, COPY, DELETE INSERT, HEADINGS, PROTECT, GRIDLINES, FREEZ PANES), PRINTING (PAGE BREAKS, TITLES, SCALE TO FIT, GRIDLINES, AREA), INTEGRATION


Chapter 11 - Templates & Integration

SCENARIO BASED DOCUMENT DESIGN, INTEGRATION, PROBLEM SOLVING, TROUBLESHOOTING


DATABASE


Chapter 12 - Introduction to Databases

USE OF DATABASE, FIRST LOOK, TABLES (FIELD PROPERTIES: DEFAULT, DECIMAL, REQUIRED), DATA TYPES, STRUCTURE, PRIMARY KEY, CREATE TABLES (SORT, DELETE, VALIDATE, FILTER), CREATE FORMS (ADDING FIELDS, BUTTONS, IMAGES, TITLE, DATE, ORDER, SOURCE, VIEWS)


Chapter 13 - Tables and Queries

DESIGN A TABLE, CHOOSING APPROPRIATE DATA TYPES, FIELD PROPERTIES (INPUT MARK, FORMAT, VALIDATION RULE AND TEXT, ALIGNMENT), QUERIES (AND, OR, NOT, SORT, SELECT FIELDS)


Chapter 14 - Reports

REPORTS (DESIGN, CALCULATIONS, HEADER AND FOOTER, IMPORT AND EXPORT, SOURCE), TERM 4 (INTEGRATION, SCENARIO, PROBLEM SOLVE, TROUBLESHOOT)

ACCESS COURSE MATERIAL

Additional videos by Mr Long: "Series on Microsoft Access Databases that particularly covers the content in Grade 11 and 12 CAT (Computer Applications Technology) and IT (Information Technology)."


WEB DESIGN


Chapter 15 - Introduction to HTML

CONCEPTS OF THE WEB, HTML (EDITOR, SYNTAX, TAGS, COMMENTS, ELEMENTS, FORMATTING, ATTRIBUTES, STRUCTURE)


Chapter 16 - Principles of Web Design

GOOD DESIGN, COLOUR, LISTS, IMAGES, LINKS