ERIC Number: EJ1125996
Record Type: Journal
Publication Date: 2016
Abstractor: As Provided
Teaching Case: Using Excel to Make Strategic Managerial Decisions
Jacobs, Aimee; Robinson, David F.; DePaolo, Concetta A.
Journal of Information Systems Education, v27 n2 p93-98 Spr 2016
This case involves actual data from a student managed café that serves as a learning laboratory for a college of business. The student team that manages the café has never had access to precise data from a point of sale system until this semester. However, once they downloaded the raw data from the cash register they were unable to make sense of the data. This was in part due to the data entry errors in recording transactions as well as operational issues such as multiple managers entering new items into the register when there is already an existing code for the item in the Point of Sale (POS) database. To clean up the data and develop actionable spreadsheet based results, the managers decide to call in a team of information systems consultants to help them clean the dataset while not losing important data. To address the operating concerns of the managers, the consultants analyze the sales data for a number of questions whose answers can be used to improve how the café operates. By using Excel to analyze the data, consultants will be able to address the managerial decisions faced by the café team.
Descriptors: Business Administration Education, Spreadsheets, Technology Uses in Education, Educational Technology, Data Analysis, Data Collection, Experiential Learning, Dining Facilities, College Students, Information Management
Journal of Information Systems Education. e-mail: firstname.lastname@example.org; Web site: http://www.jise.org
Publication Type: Journal Articles; Reports - Descriptive
Education Level: Higher Education; Postsecondary Education
Authoring Institution: N/A
Grant or Contract Numbers: N/A