Understanding of basic spreadsheet functions and familiarity with data entry, basic formulas, and common features in spread sheet software. Basic knowledge of business concept is recommended but not mandatory.

Course Details

Course Code: COM5FS112 (1)

Course Title: Advanced Spreadsheet Applications in Business

Type of Course: SEC

Semester: V

Credits: 3

Lecture Hours per Week: 3

Total Hours: 45

Pre-requisites

Students should have:

Basic knowledge of spreadsheet software.

Familiarity with data entry.

Understanding of basic formulas and spreadsheet features.

Basic business knowledge is recommended but not compulsory.

Course Summary

The course focuses on:

Spreadsheet functions and formulas

Pivot Tables and Pivot Charts

Macros and Automation

Data Visualization Techniques

Efficient Data Entry Techniques

Course Outcomes (CO)

CO 1

Gain insight into the characteristics of data analysis and management features.

Cognitive Level: Understand (U)

Knowledge Category: Conceptual (C)

Evaluation: Instructor-created exams and practical assignments

CO 2

Apply statistical and financial analysis tools in spreadsheets to make informed business decisions.

Cognitive Level: Apply (Ap)

Knowledge Category: Procedural (P)

Evaluation: Examinations and Assignments

CO 3

Create and implement advanced formulas, lookup functions, and macros for streamlined data manipulation and task automation.

Cognitive Level: Apply (Ap)

Knowledge Category: Procedural (P)

Evaluation: Practical Assignments and Observation of Practical Skills

CO 4

Apply acquired spreadsheet skills in diverse business contexts, ensuring relevance and effectiveness in various industries and scenarios.

Cognitive Level: Apply (Ap)

Knowledge Category: Procedural (P)

Evaluation: Projects