Com5fs112 1 — Syllabus

• Pre-requisites: Understanding of basic spreadsheet functions and familiarity with data entry, basic formulas, and common features in spreadsheet software. Basic knowledge of business concepts is recommended but not mandatory.

Course Summary This course explores application of spreadsheet functions, formulas, Pivot Tables and Pivot Charts, Macros and Automation, Data visualization techniques and Efficient data entry techniques.

• Course Outcomes (CO): CO CO Statement Cognitive Level* Knowledge Category# Evaluation Tools used CO1 Gain insight into the characteristics of data analysis and management features.

U C Instructor created exams/practical assignments CO2 Apply statistical and financial analysis tools in spreadsheet to make informed business decisions.

Ap P Examinations Assignment CO3 Create and implement advanced formulas, lookup functions, and macros for streamlined data manipulation and task automation.

Ap P Practical Assignment / Observation of Practical Skills CO4 Apply acquired skills in spreadsheet to diverse business contexts, ensuring relevance and effectiveness in various industries and scenarios.

Ap P Projects

• - Remember (R), Understand (U), Apply (Ap), Analyse (An), Evaluate (E), Create (C) # - Factual Knowledge(F) Conceptual Knowledge (C) Procedural Knowledge (P) Metacognitive Knowledge (M) Detailed Syllabus:

Module Unit Content Hrs I Introduction to Spreadsheet Applications 5 1 Introduction to spreadsheet applications. 1 Module Unit Content Hrs 2 Common Spreadsheet Applications 1 3 Basics of spreadsheet interface and functions. 1 4 Navigating the interface 1 5 Key features and capabilities 1 II Data Entry and Formatting with Spreadsheets 12 6 Efficient data entry techniques 2 7 Formatting cells, rows, and columns 2 8 Introduction to cell referencing and formulas 2 9 Creating and managing tables 2 10 Generating charts and graphs 2 11 Basic formulas and functions for business applications 2 III Advanced Functions and Automation 11 12 Advanced Formulas - Nested functions and complex formulas 1 13 Logical and Lookup functions (VLOOKUP, XLOOKUP, HLOOKUP) 2 14 Understanding IF, AND, OR, TEXT, COUNT, COUNTIF functions 2 15 Pivot Tables and Pivot Charts - Data summarization 1 16 Dynamic reporting with Pivot Charts 1 17 Macros and Automation - Introduction to macros 2 18 Creating simple automation scripts (customers, brands, sales, credit data) 2 IV Advanced Financial with Spreadsheets 8 19 Statistical Analysis - Descriptive statistics: mean, median, mode 2 20 Performing simple inferential statistics: t-tests, correlation 2 21 Data visualization techniques - histograms and box plots 1 22 Application of Financial ratios and key performance indicators 3 V Open Ended Module for Practical

1. Working on group projects to solve specific business problems or optimize business processes using spreadsheet tools..

2. Calculating key financial metrics such as net present value (NPV), internal rate of return (IRR), and return on investment (ROI)..

3. Creating charts and graphs to visualize data trends, such as sales trends over time or market share comparisons.

4. Calculate financial ratios a company and make interpretation 9 References

1. Excel 2019 Bible Paperback– 4 December 2018 by Michael Alexander (Author), Richard Kusleika (Author), John Walkenbach (Author)

1. Excel for: Beginners (Excel Essentials Book 1) Kindle Edition by M.L. Humphrey (Author)