Case 3: Klein Technology Seminars
Research-Discuss-Plan-Create
Book Case 4
- Description
After another success you have been assigned to work with a company that teaches seminar type classes to local businesses.
Dr. Klein has collected surveys from attendees at each of the seminars that have been taught but has never systematically evaluated the surveys to determine if there are trends that may show useful information. In order to provide a higher quality service Dr. Klein would like to know the actual results of the surveys rather than just what he thinks they say. To enable you to do this he has sent you the compiled survey results.Your boss gives you additional verbal instructions.“Dr. Klein is very smart. Don’t think you will be able to do something slipshod. Make this the best work you have ever done. This could be a big new account for us. I’m relying on you to help the company grow.”
- Deliverables
- Discussion with your cohort about the Excel resources
- Discussion with your cohort about the case issues, concepts, and possible solutions
- Discussion with the class about your cohort’s possible solutions to the case and any unresolved issues
- Personal questions you have about the case and Excel
- A professionally designed and accurate Spreadsheet created by your cohort that indicates how Dr. Klein can improve his business
- A completed assesment case
- Resources
-
- Case
- Further background on the case: Text pages 19 – 21.
- The design for the solution: Text page 22 – 24.
- The information Dr. Klein needs: Text page 25: Information Specifications
-
- Vocabulary
- Median: The middle value of a set of values sorted from highest to lowest.
- Mode: The most common value in a set of values.
- Pivot Table: A way of manipulating large amounts of data by groupings to see hidden patterns.
- Pivot Chart: A visual representation of a pivot table’s information.
