IS 44: Microsoft Office Tools for Business Analysis (Fall 25)
Instructor: Dr. Md Alimoor Reza
Assistant Professor of Computer Science
Department of Mathematics and Computer Science
Drake University

Classroom: Boyi#508@Qingdao University
Meeting Time: Monday: 10:10 am - 12:00pm
Office Hours: Tuesday: 08:00 am-9:50 am and and Thursday: 2:00 pm - 3:50 pm or by appointment


Content Portal: MindTap Cengage Learning
MOOC Portal: Chaoxing Fanya (Xue Xi Tong)
Reference eBook: Microsoft 365 & Office Collection

Schedule
A tentative schedule is provided below (content may be adjusted as we progress).


  Mindtap training & Project#12 (due on 12/15)
Date Topic Reading Items due
week 1 (Mon: Sep 08)

  Course Introduction, Required Materials, and File Management
  Lecture 1 slide

 
  No Project
week 2 (Mon: Sep 15)

  Excel Module 1 - Getting Started with Excel
  Lecture 2 slide
  Mindtap training & Project#1 (released)
 
  Reading: Module 1
 
week 3 (Mon: Sep 22)

  Excel Module 2 - Formatting Workbooks, Text, & Data
  Lecture 3 slide
  Mindtap training & Project#2 (released)
 
  Reading: Module # 2
  Mindtap training & Project#1 (due on 09/21)
week 4 (Mon: Sep 29)

  Excel Module 3 - Calculations with Formulas & Functions
  Lecture 4 slide
  Mindtap training & Project#3 (released)

 
 
  Reading: Module # 3
 
  Mindtap training & Project#2 (due on 09/28)
week 5 (Mon: Oct 06)

  Mid-Autumn Festival/National Holiday break: October 1–8, 2025  

 

 
 

week 6 (Mon: Oct 13)

  Excel Module 4 - Charts & Graphs
  Lecture 5 slide
  Mindtap training & Project#4 (released)

 
  Reading: Module # 4
 
  Mindtap training & Project#3 (due on 10/12)
week 7 (Mon: Oct 20)

  Excel Module 5 - Working with Multiple Worksheets & Workbooks
  Lecture 6 slide
  Mindtap training & Project#5 (released)


  Reading: Module # 5
  Mindtap training & Project#4 (due on 10/19)
week 8 (Mon: Oct 27)

  Excel Module 6 - Managing Data with Tables & Tools
  Lecture 7 slide
  Mindtap training & Project#6 (released)


  Reading: Module # 6
    Mindtap training & Project#5 (due on 10/26)
week 9 (Mon: Nov 03)

  Excel Module 7 - Summarizing Data with PivotTables
  Lecture 8 slide
  Mindtap training & Project#7 (released)


  Reading: Module # 7
    Mindtap training & Project#6 (due on 11/02)
week 10 (Mon: Nov 10)

  Excel Module 8 - Performing What-If Analyses
  Lecture 8 slide
  Mindtap training & Project#8 (released)




  Reading: Module # 8
  Mindtap training & Project#7 (due on 11/09)
week 11 (Mon: Nov 17)

  Excel Module 9 - Financial Functions
  Lecture 9 slide
  Mindtap training & Project#9 (released)


  Reading: Module # 9

    Mindtap training & Project#8 (due on 11/16)
week 12 (Mon: Nov 24)

  Excel Module 10 - Analyzing Data with Business Intelligence Tools
  Lecture 10 slide
  Mindtap training & Project#10 (released)


 
  Reading: Module # 10
    Mindtap training & Project#9 (due on 11/23)
week 13 (Mon: Dec 01)

  Excel Module 11 - Exploring PivotTable Desgin
  Lecture 11 slide
  Mindtap training & Project#11 (released)



 
  Reading: Module # 11
    Mindtap training & Project#10 (due on 11/30)
week 14 (Mon: Dec 08)

  Excel Module 12 - Developing an Excel Application
  Lecture 11 slide
  Mindtap training & Project#12 (released)

 
  Reading: Module # 12
 
    Mindtap training & Project#11 (due on 12/08)
week 15 (Mon: Dec 15)

  Exam review
  Practice Exam
  Course Evaluation
  Lecture 12 slides
 

    Final Exam (due by 12/23)