Computer Applications and Data Visualization for Managers
Subject Overview
Computer Applications and Data Visualization for Managers develops digital business competence — business computing and MS Office fundamentals, Excel for business analytics and AI-enabled spreadsheet tools, data visualization principles and Tableau/Power BI, and business storytelling with data for managerial decision-making. A 2-credit core theory paper.
Unit-wise Syllabus
4 units — click WhatsApp below to get the full notes for each
Unit 1: Business computing fundamentals
Role of computers in business, digital transformation, hardware and software concepts, operating system functions and cloud-based business applications, MS Office applications for professional documents, reports and presentations
Unit 2: Excel for business analytics
Workbook creation, formatting, sorting, filtering, data validation, financial/logical/statistical/text functions, conditional formatting, pivot tables, charts and dashboard creation, scenario and what-if analysis, AI-assisted spreadsheet tools
Unit 3: Data visualization
Importance of data visualization in managerial decision making, Gestalt principles, cognitive aspects, visual hierarchy and colour theory, Tableau and Power BI data import/preparation/charts/filters, geographical maps, calculated fields, KPI visualization and dynamic dashboards
Unit 4: Business storytelling and ethics
Communicating analytical insights through narrative frameworks, designing impactful presentations, infographic development, data security and ethical use of AI, misleading visualizations and interpretation bias, applications across finance, marketing, HR and operations