Grade 11 · Term 2
Spreadsheets: IF Logic and Databases
Grade 11 Computer Applications Technology
Cover nested IF, AND/OR operators, COUNTIF, SUMIF, VLOOKUP, data validation, conditional formatting, and database queries with criteria and wildcard characters.
Where this fits in CAPS
Spreadsheets: IF Logic and Databases is part of Grade 11 Computer Applications Technology, Term 2, in the CAPS (Curriculum and Assessment Policy Statement) practice on PrepPals. Each practice session gives you questions on the topic with instant feedback, and you keep a streak as you go. It is free.