Computer Application Form Two - 100 Homework Questions & 25-Question Model Exam

This master workbook delivers an authoritative, hands-on pedagogical capstone tailored specifically for Form Two Ordinary Secondary Education across Tanzania. Fully synchronized with the Tanzania Institute of Education (TIE) Information and Computer Studies (ICS) Form 2 Syllabus, Dadisi ICT Grade 2 notes, and VETA Vocational Computer Application standards, this workbook masters the triad of core office application software across four structured thematic modules:
• Module 1: Spreadsheets Fundamentals, Formulas & Cell Referencing (Q001 – Q025): Concepts of electronic spreadsheets vs. manual ledgers, automatic recalculation, workbook vs. worksheet, grid architecture (rows, columns, cell addresses, Name Box, Formula Bar); data types (labels, values, dates, formulas); cell formatting (currency TZS, percentages, decimals, text wrapping, Merge & Center); worksheet editing, row/column adjustments, handling ##### width warnings; AutoFill and Fill Handle series; data sorting (ascending, descending) and filtering (AutoFilter vs. Advanced Filter); formula construction, operator precedence (PEMDAS/BODMAS); and relative, absolute ($A$1), mixed ($A1, A$1), and 3D cross-sheet cell referencing.
• Module 2: Advanced Spreadsheet Functions, Data Validation & Charts (Q026 – Q050): Built-in statistical and counting functions (SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTBLANK, COUNTIF, SUMIF); logical evaluations (IF function, nested IF grading algorithms, AND, OR); lookup tables with VLOOKUP and HLOOKUP; decimal rounding (ROUND, ROUNDUP, ROUNDDOWN); data validation rules (whole numbers, decimal limits, dropdown selection lists, and Stop vs. Warning error alerts); conditional formatting (highlight rules, data bars, color scale heatmaps, icon sets); data visualization (column, bar, line, pie charts, legends, data labels); page setup (print area, print titles, repeating header rows, scaling to fit); and exporting to secure PDF and CSV data interchange formats.
• Module 3: Relational Database Fundamentals, Table Architecture & Queries (Q051 – Q075): Limitations of flat-file spreadsheets (redundancy, inconsistency); RDBMS core concepts; database objects (tables, queries, forms, reports); table structure (fields, records, primary keys, candidate keys, composite keys, foreign keys, and referential integrity); table relationships (1:1, 1:N, N:M); Microsoft Access data types (Short Text, Long Text, Number, Date/Time, Currency, AutoNumber, Yes/No); field properties (Field Size, Caption, Default Value, Validation Rule & Validation Text, Required, Indexed); Table Design View vs. Datasheet View; and Query Design Grid (QBE), criteria syntax, wildcards (* and ?), date delimiters (#), AND vs. OR logic, calculated fields, parameter queries, aggregate totals (Σ), and Action Queries (Append, Update, Delete, Make-Table).
• Module 4: Database Forms, Reports & Electronic Presentations Mastery (Q076 – Q100): Database forms (bound, unbound, calculated controls, combo boxes vs. list boxes, form sections, subforms); database reports (report hierarchy: Report Header, Page Header, Group Header, Detail, Group Footer, Page Footer, Report Footer, summary formulas =Sum(), =Count()); and electronic presentation software (PowerPoint / Impress interface, slide vs. slide deck, slide layouts, text boxes, SmartArt graphics, image compression, charts & tables, Slide Master branding, slide transitions, custom animations in 4 categories: Entrance, Emphasis, Exit, Motion Paths, Animation Pane triggers: On Click, With Previous, After Previous, Presenter View speaker dashboard, 6×6 design rule, rehearse timings, remote meeting presentation techniques, and multi-application integration).