Start Date

16-8-2018 12:00 AM

Description

This case presents games for developing what-if skills in Excel. They can be added to existing curriculum in classes covering data analysis. The games require students to create decision-making models, and then use those models in interactive class auctions. The auctions generate significant classroom energy and unpredictability. Since each auction proceeds differently, students cannot rely on peers to give them the "right" answer. This helps reduce plagiarism, and the rules of each game can be tweaked to provide a unique competition for each section. Professors can grade each team on their earned profit, as well as an optional written analysis or presentation. The games help students understand the value of Excel in quickly generating and choosing between multiple options. The public competition engages students, and supplements more traditional instructional material. \

Share

COinS
 
Aug 16th, 12:00 AM

What-if Model Games in Excel

This case presents games for developing what-if skills in Excel. They can be added to existing curriculum in classes covering data analysis. The games require students to create decision-making models, and then use those models in interactive class auctions. The auctions generate significant classroom energy and unpredictability. Since each auction proceeds differently, students cannot rely on peers to give them the "right" answer. This helps reduce plagiarism, and the rules of each game can be tweaked to provide a unique competition for each section. Professors can grade each team on their earned profit, as well as an optional written analysis or presentation. The games help students understand the value of Excel in quickly generating and choosing between multiple options. The public competition engages students, and supplements more traditional instructional material. \