Calicut University • B.Com • Semester 3
Business Analytics Tools (COM3MN209) — Syllabus & Course Structure
Lecture Notes • Complete Study Material & Course Outline
Course Details & Structure
| Credit | Lecture per week | Tutorial per week | Practical per week | Total Hours |
|---|---|---|---|---|
| 4 | 3 | - | 2 | 75 |
Course Code: COM3MN209 | Type of Course: Minor | Academic Level: 100-199
Pre-requisites: Basic skills in computer applications
Course Summary: This course provides students with the knowledge and skills needed to operate software tools for data analysis, and decision-making in a business context.
Course Outcomes (CO)
| CO | Course Outcome Statement | Cognitive Level* | Knowledge Category# | Evaluation Tools Used |
|---|---|---|---|---|
| CO1 | Students should gain proficiency in using basic analytical software tools such as Microsoft Excel | U | C | Examinations, Quizzes, Assignment |
| CO2 | Understand fundamental data structures such as tables, rows, columns, and cells | U | C | Examinations, Assignment, Practicum |
| CO3 | Apply basic analytical tools to perform descriptive analytics | Ap | P | Project |
* Cognitive Levels: Remember (R), Understand (U), Apply (Ap), Analyse (An), Evaluate (E), Create (C)
# Knowledge Categories: Factual Knowledge (F), Conceptual Knowledge (C), Procedural Knowledge (P), Metacognitive Knowledge (M)
Detailed Syllabus
| Module | Unit | Content | Hrs |
|---|---|---|---|
| Module I | Monetizing Data to Drive Business Decisions | 12 | |
| 1 | Need for data driven decision making — Solving the business problem using Analytics | 4 | |
| 2 | Overview of Analytical cycle and Hierarchy of information user | 4 | |
| 3 | The Complete BA professional — Understand BA roles and Responsibilities — Identify the Popular BA Tools | 4 | |
| Module II | Organizing Data with Excel | 08 | |
| 4 | Formatting cells — Using the Ribbon to Format Numbers — Using the Format Cells Dialog Box — Add a Border, background Color — Change the Font, Font Size, Font Color | 1 | |
| 5 | Formatting input data — Understanding Dates and Times — Format Percentages, Fractions, In Scientific Notations | 1 | |
| 6 | Formatting worksheet — Align Data, Rotate Data, Wrap Text, Merge and Center — Apply a Style, Using Format Painter, Clear Formats — Structuring the workbook — Cut, Copy, and Paste Cells | 2 | |
| 7 | Using Live Preview with Paste, Paste from the Office Clipboard, Insert or Delete — Find and Replace Information | 1 | |
| 8 | Change the Name of a Worksheet, Change Column Widths or Row Heights, Hide Columns or Rows, Hide a Worksheet | 1 | |
| 9 | Move or Copy a Worksheet — Freeze Worksheet Titles — Hide Gridlines, Headings, or the Formula Bar | 2 | |
| Module III | Searching and Combining Data with Power Query | 12 | |
| 10 & 11 | Getting started with Power Query — Know the Environment tabs and toolbars | 3 | |
| 12 | Access new or existing reports — Importing and combining data from databases, web, files — Splitting and aggregating data | 3 | |
| 13 | Query data from SQL — Working in the Select Part of an SQL Query | 3 | |
| 14 | Managing SQL commands — Managing Tables | 3 | |
| Module IV | Performing Computations and Aggregations Using Excel | 13 | |
| 15 | Understanding formulas — Calculate with an Operator — Calculate Using a Function and Cell Addresses | 1 | |
| 16 | Create an Array Formula using the Sum, Average, Count, Min, and Max Functions Managing formulas in Excel | 1 | |
| 17 | Create a Formula that Refers to Another Worksheet — Understanding Relative and Absolute Cell Addresses — Edit Formulas, Name Cells and Ranges | 1 | |
| 18 | Define and Display Constants — Create Formulas That Include Names — Check Formulas for Errors, Trace Precedents and Dependents | 2 | |
| 19 | Introduction to functions in Excel — Understanding the Function Wizard — Create a Conditional Formula — Calculate a Conditional Sum — Calculate a Conditional Count | 2 | |
| 20 | Find the Square Root — Using VLOOKUP and index — Retrieve Column or Row Numbers — Using VLOOKUP — Using Index: Match, Search and Text-based functions in Excel — Determine the Location of a Value Using INDEX | 3 | |
| 21 | Calculate Future Value, Present Value — Exploring inbuilt statistical functions and tools — Calculate an Average — Calculate a Conditional Average — Calculate the Median or the Mode — Calculate Rank | 3 | |
| Module V | Open Ended Module (Practical Exercises):
| 30 | |
Recommended Reference Books
- Greg Harvey — Excel 2016 for Dummies; ISBN: 9788126558964
- Michael Alexander — Microsoft Excel Power Pivot & Power Query for Dummies; ISBN: 9788126562305
- Ken Bluttman — Microsoft Excel Formulas & Functions for Dummies, 4ed; ISBN: 9788126559466
COM3MN209Business Analytics Tools
Download Official Syllabus Notes (PDF)
Calicut University • FYUGP 2024 Syllabus
Ready to start learning?
Proceed to Module 1 notes or view all syllabus topics.