Exercise 1

Valacich, J. S., & Schneider, C. (2022). Information systems today: Managing in the digital world (8th ed.). Pearson.

Week 1 Application Project

Complete ONE of the following application exercises to complete from the text Information Systems Today: Managing the Digital World:

Option 1: Spreadsheet Project

10-45 Spreadsheet Application: Analyzing Ethical Concerns at Campus Travel (page 441)

Follow the directions in the text to complete the project

Use the starting data file EthicsSurveyv attached below

A valid Microsoft Excel workbook file (.xlsx) must be submitted as the final deliverable

Spreadsheet Application: Analyzing Ethical Concerns at Campus Travel

1. 10-45. Because of the employees’ increased use of IS resources for private purposes at Campus Travel, you have announced that a new acceptable use policy will be implemented. You have set up a website for the employees to provide feedback to the proposed changes; the results of this survey are stored in the file EthicsSurvey.csv. Your boss wants to use the survey results to find out what the greatest concerns in terms of ethical implications are for the employees, so you are asked to do the following:

1. ■ Complete the spreadsheet to include descriptive statistics (mean, standard deviation, mode, minimum, maximum, and range) for each survey item. Use formulas to calculate all statistics for the responses to the individual questions. 

2. (Hint: In Microsoft Excel, you can look up the necessary formulas in the category “Statistical”; you will have to calculate the ranges yourself.) 

3. ■ Format the means using color scales to highlight the items needing attention. 

4. ■ Make sure to professionally format the pages before submitting them to your instructor.