Computer Science > TEST BANK > INSTRUCTORS MANUAL FOR USING MIS 11TH EDITION DAVID KROENKE, RANDALL BOYLE (All)
Chapter 1 Application Exercises AE1-1 The spreadsheet in Microsoft Excel file Ch01Ex01_U11e.xlsx contains records of employee activity on special projects. Open this workbook and examin... e the data that you find in the three spreadsheets it contains. Assess the accuracy, relevancy, and sufficiency of this data to the following people and problems. a. You manage the Denver plant, and you want to know how much time your employees are spending on special projects. The answer to this question is given directly on the Denver worksheet, so this data is accurate, relevant, and sufficient for the purposes of the Denver plant manager. (LO: 6, Learning Outcome: Explain how information systems can be used to assist in decision making, AACSB: Information Technology) b. You manage the Reno plant, and you want to know how much time your employees are spending on special projects. The answer to this question is given directly on the Reno worksheet, so this data is accurate, relevant, and sufficient for the purposes of the Reno plant manager. (L O: 6, Learning Outcome: Explain how information systems can be used to assist in decision making, AACSB: Information Technology) c. You manage the Quota Computation project in Chicago, and you want to know how much time your employees have spent on that project. The project manager will have to manipulate the data on the Chicago worksheet to produce the answer of interest. The worksheet rows could be sorted by project, and then a sum computed of the hours worked for the Quota Computation rows. The data is sufficient, but must be manipulated to produce the relevant result, and because of that manipulation, the accuracy of the result might be questionable. (L O: 6, Learning Outcome: Explain how information systems can be used to assist in decision making, AACSB: Information Technology) d. You manage the Quota Computation project for all three plants, and you want to know the total time employees have spent on your project. [Show More]
Last updated: 1 month ago
Preview 1 out of 223 pages
Instant download
Buy this document to get the full access instantly
Instant Download Access after purchase
Add to cartInstant download
Connected school, study & course
About the document
Uploaded On
May 06, 2024
Number of pages
223
Written in
This document has been written for:
Uploaded
May 06, 2024
Downloads
0
Views
11
In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.
We're available through e-mail, Twitter, Facebook, and live chat.
FAQ
Questions? Leave a message!
Copyright © Browsegrades · High quality services·