Case 5: Megan Davis Convention Center
Research-Discuss-Plan-Create
Book Case 7
- Description
“This is a big one,” your boss says. “Megan Davis Convention Center has been a major customer with use for several years. I am going to assign you to be the on-going consultant for this account. You will needs to be in contact regularly with them and come up to speed on the different projects we are working on with them. Currently there are 4 projects that need on-going support and two in development. Your contact with the company is Vasundhara Sawhney. The previous consultant is Sarah Lambert. Talk with her to get up to speed.” She also gives you access to a sample MS Access database to work with. - 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 Megan Davis Convention Center is currently operating.
- A completed assesment case
- Resources
-
- Case
- Further background on the case: Text pages 42 – 43.
- The design for the solution: Text page 44.
- The information Needed: Text pages 44 – 45: Information Specifications
- The implementation concerns: Text page 45 paragraphs 1 and 2. Do not use Microsoft Query
-
- 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.
