Covid 19 Summary of All Theory Content to assist with accelerated Teaching
Term 1: General Concepts
INFORMATION PROCESSING CYCLE, TYPES OF COMPUTERS, ROLE OF ICTs IN THE WORKPLACE, VALUE OF CATTerm 1: Hardware
INPUT, OUTPUT, DRIVERS, P&P, OTHER EQUIPMENT, OCRMindset Video - Choosing Hardware and Software
Term 2: Hardware
STORAGE, PROCESSING (MB, CPU, RAM, ROM), ADVERTS, TROUBLESHOOTINGTerm 3: Software
APPLICATION SOFTWARE, FUNCTION, COMPATIBILITY, VERSIONS (PATCHES + SERVICE PACKS), UPDATING, DISABILITIES, CLOUD STORAGE, CLOUD BASED APPSTerm 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)Term 1
IO DEVICES FOR DISABLED, ACCESSIBILITY, HARDWARE THEFT, POWER SETTINGS, HEALTH, CAREER OPTIONSTerm 2
SOCIAL ISSUES, UNAUTHORIZED ACCESS, ETHICAL USE, AUP, NW SECURITY, SPYWARE, ADWARE, BOYD, PRIVACY, BIG DATA, CRYPTO CURRENCYTerm 3
GIGO, DATA VERIFICATION, BUGS, HARDWARE FAILURE, ICTs IMPACT ON THE WORKPLACE, MOBILE OFFICESTerm 4
SOCIAL ENGINEERING, ACCURACY, DATA PROTECTION, COMPUTER MISUSE, PROTECTING ONESELF ONLINE, HOW ANTIVIRUS WORKS, COMMERCE AND BANKINGTerm 2: Networks
LAN, WAN, P2P, NIC, CONNECTION DEVICES, COMMUNICATION MEDIUM, NETWORK SOFTWARE, WIRED AND WIRELESS CONNECTIONS, SPEED, ADVERTS, INTERNET VS INTRANET, NETWORK SECURITYTerm 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 SOFTWARETerm 3: Internet and the WWW
USABILITY OF WEB PAGES, EVALUATE SITES, IoT TECHNOLOGIES AND IMPACT ON SOCIETYTerm 4: Communications
MANAGING E-MAILAdditional Resources on all Applications
Revision:
Chapter 1 - File Management in Word Processing
PRINTING, PRINT TO FILE/PDF, SEND, SHARE, IMPORT EXPORT DATAChapter 2 - Templates and Input data in Word Processing
SAVE AS TEMPLATE, INPUT FROM DIFFERENT FORMATS, IMPORT, EXPORTChapter 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(Term 1) Data Files
Chapter 5 - Electronic Forms and Online/Offline Help
LEGACY TOOLS, ONLINE/OFFLINE HELPChapter 6 - Styles
HEADINGS AND PARAGRAPHS: CHANGE, EDIT, CREATE(Term 2) Data Files
Chapter 7 - Mailings & References
MAIL MERGE: SOURCES, LETTERS, LABELS,REFERENCES: TOC, TABLE OF FIGURES, FOOT AND ENDNOTE, CAPTIONS, CITATIONS, BIBLIOGRAPHY, INDEX(Term 3) Data Files
Additional Resources on Spreadsheets:
Date Functions by Mr Long
Nested If Statements by Mr Long
AND, OR and NOT operators by Mr Long
Lookup Functions by Mr Long
Evaluate Formulas by Mr Long
Chapter 8 - Spreadsheet Formatting
CONDITIONAL FORMATTING, ABSOLUTE CELL REFERENCING, ROUND, SMALL, LARGE, COUNTA, COUNTBLANK, COUNTIF, POWER, ROUNDING OFF, ERRORS (CIRCULAR REFERENCE & #NULL)(Term 1) Data Files
Chapter 9 - If functions and Charts
OPERATORS, IF FUNCTION, COUNTIF, SUMIF, CHARTS (CREATE, FORMAT, EDIT, LABEL, GRIDLINES, LEGENDS, TYPE), INTEGRATION(Term 2) Data Files
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(Term 3) Data Files
Chapter 11 - Templates & Integration
SCENARIO BASED DOCUMENT DESIGN, INTEGRATION, PROBLEM SOLVING, TROUBLESHOOTINGChapter 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)(Term 1) Data Files
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)(Term 3) Data Files
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)."
Chapter 15 - Introduction to HTML
CONCEPTS OF THE WEB, HTML (EDITOR, SYNTAX, TAGS, COMMENTS, ELEMENTS, FORMATTING, ATTRIBUTES, STRUCTURE)(Term 2 and 3) Data Files-not available
Chapter 16 - Principles of Web Design
GOOD DESIGN, COLOUR, LISTS, IMAGES, LINKS(Term 2 and 3) Data Files