Securing Information Systems

Database Application: Tracking Software Licenses at Campus Travel

Recently, you have taken on the position of IS manager at Campus Travel. In your second week at work, you realize that many of the software licenses are about to expire or have already expired. As you know about the legal and ethical implications of unlicensed software, you have decided to set up a software asset management system that lets you keep track of the software licenses. You have already set up a database and stored some of the information, but you want to make the system more user friendly. Using the SWLicenses.mdb database, design a form to input the following information for new software products:

- Software title

- Installation location (office)

- License number

- Expiration date

Furthermore, design a report displaying all software licenses and expiration dates (sorted by expiration dates). (Hint: In Microsoft Access, use the form and report wizards to create the forms and reports; you will find the wizards under the Create tab.)

- Open the report in the design view.

- Add a label control to the Page Footer section.

- Place CIS 3130 and your name in the label control.

- Print the report as a PDF file

Submit a PDF file of the report.

Spreadsheet Application: Analyzing Ethical Concerns at Campus Travel

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:

- 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. (Hint: In Microsoft Excel, you can look up the necessary formulas in the category Statistical; you will have to calculate the ranges yourself.)

- Format the means that fall below 6.5 using color scales to highlight the items needing attention.

- Set the print areas to only the calculated items. Format the printout in landscape orientation.

- Place CIS 3130, your name, and the current date in the header.

- Print the spreadsheet as a PDF file.

Submit a PDF file of the XLS spreadsheet with the formulas showing and without the formula showing.