Problem 2 (This was given to me by the assessment coordinator and needs to be
collected for AACSB accrediting).
Q1: Pat Jones is the general manager at Denny’s Muffler, which has 3 locations and
27 employees. Currently, the office manager at 3 stores put input their weekly sales
results into a spreadsheet and e-mail that spreadsheet to Pat on Friday by noon.
Each week, Pat handles between 120 to 350 records of sales data, and another 100
to 300 records of customer data. Pat would be like to keep track of weekly sales,
which customers are associated with each sale, the parts used for each sale, what
work was done for each customer at each sale, and which parts were used for each
sale. If Pat wants to improve his efficiency and effectiveness, which of the following
applications would be the best for collecting and storing Pat’s data?
1) Excel
2) SAP
3) Access
4) Minitab
5) Teams
6) MySQL
Q2: Raj Miller runs an 8-person sales team at a small paper company that has 22
employees and $6,500,000 of revenue per year. Raj needs to give a presentation of
second quarter sales results to company management. As part of the presentation,
Raj would like to create some charts and pivot tables to summarize the quarterly
data.
To be successful at this presentation, which of the following technologies would be
the best choice (or choices) for creating charts and making his in-person
presentation to company management? (Indicate all correct answers)
1) SAP
2) Excel
3) Access
4) Powerpoint
5) Oracle
Q3: Jami is an intern on a sales team at a large insurance company. On the first day
of the internship, Jami is asked to download a list of all of her friends and contacts
from Facebook and upload them to the company database. The team lead explains
"This database keeps track of all of our employees, and well as their customers and
prospects. This makes it really easy to avoid redundant customer interactions, and
also keeps us from cannibalizing customers and business from one another."
Jami is wondering if there are ethical issues she should be concerned about. Do you
think there are ethical issues involved with this situation? If yes- what are those
issues, specifically, and how would you advise Jami?