yearly revenue sheet

HS115 | Software Applications for Health Care Professionals

1

Assignment Instructions

Unit 5 Assignment, Part 2 of 2: Yearly Revenue Sheet

Unit outcome(s) addressed in this Assignment:

• Explain and illustrate the benefits of using charts and graphs. • Demonstrate the ability to plan, create, and format a variety of layouts. • Assess cause and consequence of a variety of presentation formats. • Demonstrate the ability to assess value and make appropriate choices in electronic

spreadsheet file creation through progressive skill level assessments.

Course outcome(s) addressed in this Assignment:

HS115-2: Create spreadsheets, graphs, and charts using spreadsheet applications.

HS115-4: Manage data and documents by integrating appropriate programs.

HS115-5: Demonstrate how these programs are used by healthcare professionals and in a healthcare environment.

Instructions:

You are an office manager at Diagnostics Laboratory. At the end of each year, you are tasked with creating a yearly revenue worksheet listing money earned from each of the company’s four labs. This year, you have decided to add charts to help explain the revenue in a visual way.

Enter the text listed in this image. Insert formulas for the Total column (G4:G7) and the Total Row (B8:E8).

Create two charts using this data. The charts should be formatted like the following, including the same labels and legends:

Chart 1

Chart 2

HS115 | Software Applications for Health Care Professionals

2

When complete, please submit your work file(s) to the Dropbox. Be sure to Upload ALL of your Assignment files.

Use the proper naming convention: username Chap7Ex1-StudentLate Name.xlsx

To view your graded work, come back to the Dropbox or go to the Gradebook after your instructor has evaluated it.

Make sure that you save a copy of your submitted project.

Your work is due by the end of Unit 5.

Unit 5 Assignment, Part 2 of 2 Grading Rubric = 25 points

Unit 5 Assignment 1 of 2 Requirements Points possible

Points earned by student

Enter data into spreadsheet 5

Create formulas for Total column (column G) 5

Enter formulas for Total row (row 8) 5

Create two charts shown 10

Total (Sum of all points) 25

Points deducted for spelling, grammar, and/or APA errors. (See Writing Deductions Rubric in Doc Sharing)

Adjusted total points

Instructor Feedback: