Course Description

In response to the changing business environment in the era of digital transformation and generative AI, this course develops AI utilization capabilities and data-driven decision-making skills. Students will apply generative AI such as ChatGPT to business problem-solving, and learn data analysis and visualization techniques using Microsoft Excel and PowerPoint.

Learning Objectives

  • Understand the operating principles and limitations of generative AI and use it ethically in business contexts
  • Optimize AI system performance through strategic prompt engineering
  • Improve coding productivity by applying AI copilot concepts
  • Build data analysis pipelines and develop business intelligence capabilities
  • Acquire data-driven storytelling and effective presentation skills

Evaluation

Midterm
35%
Final
35%
Assignment
15%
Quiz
5%
Project
10%
Attendance
10%

Weekly Schedule

Week Topic Details
1 Orientation Course overview, importance of AI and data utilization
2 Getting Started with ChatGPT ChatGPT overview, understanding features, basic prompt writing
3 Information Utilization with ChatGPT Effective questioning methods, business use cases
4 Prompt Engineering Basics Prompt structure, strategies for improving response quality
5 ChatGPT Writing Assistant Business emails, report writing, document proofreading
6 Practical Applications with ChatGPT Business idea development, market research, organizational culture establishment
7 Comprehensive ChatGPT Application Synthesizing learning content, case study analysis, midterm preparation
8 Midterm Exam
9 Excel Overview and Basic Functions Excel interface, data entry and management
10 Excel Basic Functions Math/conditional/date/text functions, ChatGPT integration
11 Excel Data Visualization Chart types, visualization principles, effective design
12 PowerPoint Basics Basic settings and features
13 PowerPoint Applications Font rules, visualization methods, napkin.ai utilization
14 MS Copilot Practice and Integrated Project Workshop Copilot utilization, integrated tool usage
15 Team Project Presentation and Final Exam Final project presentations and evaluation

Textbook

Self-developed PPT materials