Detailed Syllabus Page 230 of 241 effectively. They will also learn to incorporate add-ins for extended functionalities and manage printing options for the professional presentation of data.
* - Remember (R), Understand (U), Apply (Ap), Analyse (An), Evaluate (E), Create (C) # - Factual Knowledge(F) Conceptual Knowledge (C) Procedural Knowledge (P) Metacognitive Knowledge (M) Module Unit Content Hrs (30+30) Marks I Introduction to Spreadsheet 7 10 1 Overview of spreadsheet software (e.g., Microsoft Excel, Google Sheets), Basic spreadsheet navigation and interface 1 2 Entering and formatting data, Data types and cell formatting, Sorting and filtering data 2 3 Arithmetic operations and basic formulas, Common functions (SUM, AVERAGE, MIN, MAX, COUNT) 2 4 Text functions (CONCATENATE, LEFT, RIGHT, MID, TEXT), Date and time functions 2 II Data Cleaning and Visualization 8 15 5 Logical functions (IF, AND, OR, NOT, IFERROR, IFS, SWITCH), Lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH) 2 6 Financial functions (NPV, IRR, PMT), Array formulas (SUMPRODUCT, SUMIF, AVERAGE, TRANSPOSE, Array Multiplication, FILTER, IMPORTRANGE) 2 7 Handling missing values and duplicates, Data transformation techniques (text to columns, merging cells) 2 8 Using advanced text functions for data cleaning, Data validation rules and error-checking 1 9 Creating and customizing charts (bar, line, pie, scatter, Histogram), Conditional formatting for data visualization 1 III Pivot Tables and Pivot Charts 8 10 10 Sparklines and data bars, Advanced chart techniques (combination charts, dual-axis charts) 2 11 Creating and configuring pivot tables, Grouping and summarizing data in pivot tables 2