BIS 155 You are current student

$5.50

BIS 155 You are current student 
(TCO 9) You are a current student with DeVry University and have a work study job…

Description

BIS 155 You are current student

BIS 155 You are current student

A+ Final Exam

(TCO 9) You are a current student with DeVry University and have a work study job in the College of Business & Management. The Dean understands that you have completed BIS155 and has a data set saved to a .csv file format that needs to be analyzed. There are a total of ten employees with 216 record entries for the 2014 year including individual hours worked in the range of 15 to 79 hours per week. The data set includes the following fields: Employee Name, Week Ending Date, Hours Worked, Hourly Wage, Gross Pay, and Net Pay. The Dean has asked you to use your skills learned from BIS155 to create the following reports with the support of Microsoft Excel integrated into Microsoft Word:

Report 1: Total Net Pay by Employee to Date

Report 2: Total Hours Work to Date

Report 3: Comparison of Total Net and Gross Pay to Date

Report 4: Employees that have worked Over 40 hours for any given week

In scholarly and descriptive details, share with the dean a complete step by step process in how you plan to create these four reports presented in Microsoft Word. Also take into account that the Dean may also like illustrative options with charts.

(Points : 40)

To create report 1, The user will select the name of each employee from the employee ….

To create report 2, The user will select the name of each…

To create report 3, The user will select the name of each employee from the employee name column and copy in a new …To create report 3, The user will select the name of each employee from the employee name …