Management Computing Course

Lesson 1 • What Is Management Computing

Defines management computing and distinguishes it from general IT. Anchors the chapter by framing how technology supports managerial decision-making.

Lesson 2 • Data, Information, and Knowledge

Distinguishes raw data from actionable information and organizational knowledge. Builds the conceptual basis for later database and analytics chapters.

Lesson 3 • Ethics and Governance Fundamentals

Introduces data privacy, acceptable use, and governance responsibilities. Sets the ethical baseline applied throughout the entire course.

Lesson 4 • Core Computing Concepts for Managers

Introduces hardware, software, networks, and storage fundamentals. Provides the technical literacy managers need to communicate with IT teams.

Lesson 1 • PivotTables and Dynamic Analysis

Uses PivotTables and PivotCharts to summarize large datasets interactively. Connects raw data organization to executive-level reporting.

Lesson 2 • Automation with Macros

Records and edits macros to automate repetitive reporting tasks. Reduces manual effort and introduces the logic behind scripted automation.

Lesson 3 • Essential Functions and Formulas

Teaches logical, lookup, statistical, and text functions used in management reporting. Directly enables the financial modeling covered later in this chapter.

Lesson 4 • Financial Modeling and Scenario Analysis

Constructs budget models, forecasts, and what-if scenarios using spreadsheet tools. Delivers the applied financial output managers need for planning decisions.

Lesson 5 • Spreadsheet Interface and Navigation

Covers workbook structure, cell referencing, and keyboard efficiency. Establishes the operational fluency required for all subsequent spreadsheet work.

Lesson 1 • Joining and Combining Data

Covers INNER, LEFT, and RIGHT joins to merge data across multiple tables. Builds the multi-table query skills essential for real-world reporting.

Lesson 2 • Structured Query Language Basics

Introduces SELECT, WHERE, ORDER BY, and aggregate functions for data retrieval. Enables managers to extract specific datasets without IT assistance.

Lesson 3 • Data Manipulation and Maintenance

Teaches INSERT, UPDATE, DELETE, and transaction control for data upkeep. Ensures managers understand how data changes affect reporting accuracy.

Lesson 4 • Database Design for Business Applications

Applies normalization and ER modeling to design a functional business database. Integrates all prior database concepts into a complete design project.

Lesson 1 • Regression and Correlation Analysis

Applies simple and multiple regression to model relationships between business variables. Directly supports the forecasting and predictive modeling covered next.

Lesson 2 • Probability and Inferential Reasoning

Introduces probability concepts, sampling distributions, and hypothesis testing logic. Enables managers to evaluate statistical claims and research findings critically.

Lesson 3 • Forecasting Techniques

Covers moving averages, exponential smoothing, and trend projection for demand and revenue forecasting. Connects statistical methods to operational planning decisions.

Lesson 4 • Descriptive Statistics for Business

Covers measures of central tendency, dispersion, and distribution shape for business datasets. Builds the statistical vocabulary used throughout all analytical work.

Lesson 1 • Connecting and Transforming Data

Demonstrates importing, cleaning, and shaping data from multiple sources in a BI tool. Prepares clean datasets required for accurate dashboard creation.

Lesson 2 • Sharing and Governing BI Reports

Covers publishing, scheduling, and access control for distributed BI content. Connects technical output to organizational governance requirements.

Lesson 3 • Building Interactive Dashboards

Constructs multi-page dashboards with filters, drill-throughs, and KPI cards. Delivers the interactive reporting product managers present to stakeholders.

Lesson 4 • Designing Effective Visualizations

Applies chart selection principles and visual design rules to business data. Ensures reports communicate insights clearly to non-technical audiences.

Lesson 1 • System Integration and APIs

Introduces API concepts, middleware, and integration patterns between enterprise systems. Enables managers to oversee integration projects and vendor discussions.

Lesson 2 • Supply Chain and Operations Platforms

Examines SCM modules for procurement, inventory, and logistics management. Links operational data to the financial and BI reporting covered earlier.

Lesson 3 • Enterprise Resource Planning Overview

Explains ERP modules, master data, and cross-functional integration logic. Establishes the enterprise system context for all platform-level work.

Lesson 4 • Evaluating and Selecting Enterprise Software

Provides a structured framework for vendor evaluation, total cost of ownership, and fit analysis. Prepares managers to lead or participate in software selection decisions.

Lesson 1 • Digital Project Planning Tools

Applies Gantt charts, task dependencies, and resource allocation in project management software. Translates planning concepts into executable digital project plans.

Lesson 2 • Project Management Fundamentals

Defines project lifecycle, scope, constraints, and stakeholder roles in a digital context. Establishes the management framework before tool-specific instruction.

Lesson 3 • Business Process Modeling

Introduces process mapping notation and workflow diagramming for operational improvement. Provides the process documentation skills needed for automation and ERP work.

Lesson 4 • Monitoring, Reporting, and Closing Projects

Covers earned value metrics, status reporting, and formal project closure procedures. Completes the project management lifecycle with performance measurement skills.

Lesson 1 • Technology Roadmap Development

Guides construction of a multi-year technology roadmap with prioritized initiatives and milestones. Delivers the primary strategic planning artifact of this chapter.

Lesson 2 • IT Governance and Risk Management

Covers governance frameworks, risk registers, and control objectives for technology assets. Connects strategic planning to accountability and compliance requirements.

Lesson 3 • Budgeting and ROI for Technology

Applies capital and operational budgeting methods to technology investment decisions. Enables managers to justify and evaluate technology spending quantitatively.

Lesson 4 • Leading Digital Transformation

Addresses change management, culture, and leadership practices for technology-driven transformation. Closes the course by connecting technical skills to executive leadership responsibilities.