Business&ITCenter21: Microsoft Excel Business Project (2013)

This module provides students the opportunity take on the role of an intern at a movie theater and update a Microsoft Excel 2013 spreadsheet to present financial income data for a meeting.

 

Unit: Module Resources


Description
The Lesson Plan and assessment rubric for the module.

 

Unit: Income Statement Project (Part 1)


Description
In this unit, students will learn about: entering financial equations in an Excel spreadsheet, formatting the data and graphing the net income results. 

Lessons
  1. Your Internship 
  2. Your Task 
  3. Implementation Overview 
  4. Implement - Enter Calculations 
  5. Implement - Format Spreadsheet 
  6. Implement - Create a Graph 
  7. Quiz

 

Unit: Income Statement Project (Part 2)


Description
In this unit, students will learn about: analyzing options in Excel to determine which has the best result on gross profit, using this analysis to select the best option, and showing how it affects next year's net income for the movie theater. 

Lessons
  1. Your Task 
  2. Implementation Overview 
  3. Implement - Option 1, Increase Ticket Prices 
  4. Implement - Option 2, Second Run Movies 
  5. Implement - Calculate Net Income 
  6. Implement - Review and Revise 
  7. Quiz

module-back-button.png