1-1 Discussion: Leveraging Data to Inform Decisions

In this discussion, you will introduce yourself to the class. You will discuss an article that covers how spreadsheets are leveraged in management to inform decisions.
In your initial post, briefly introduce yourself to your peers by describing your academic and professional background. Then, using what you learned from the Using Excel to Make Strategic Managerial Decisions article, think about a past or present situation where data could have helped or can help you make an informed decision. Describe the situation and the kind of data that would have or could still help you.

Using Excel to Make Strategic Managerial Decisions.


Chart Chart Chart Chart

Jacobs, Aimee1, aimee.jacobs@indstate.edu
Robinson, David F.1, david.robinson@indstate.edu
DePaolo, Concetta A.2, cdepaolo@indstate.edu
Journal of Information Systems Education; Spring2016, Vol. 27 Issue 2, p93-98, 6p, 4 Charts
Document Type:
Microsoft Excel (Computer software); Business students; Electronic spreadsheets; Decision making in business; Data entry; Point-of-sale systems
Author Supplied Keywords:
Data cleansing
Descriptive statistics
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. [ABSTRACT FROM AUTHOR]
Copyright of Journal of Information Systems Education is the property of Journal of Information Systems Education and its content may not be copied or emailed to multiple sites or posted to a listserv without the copyright holder’s express written permission. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)
Author Affiliations:
1Management, Information Systems and Business Education Scott College of Business Indiana State University Terre Haute, IN 47809, USA
2Operations & Supply Chain Management Scott College of Business Indiana State University Terre Haute, IN 47809, USA
Accession Number:
Education Full Text (H.W. Wilson)