Myresource.phoenix.edu
BSHS/375 Excel Assignment Instructions
Week 2
Utilize the raw data provided to do the following:
Resource: Database Template, Excel Guide
You will build on this assignment during the next 4 weeks of the course, with the final product submitted in Week 5. The Database Template has two worksheets you can access using the tabs at the bottom of the template. You will also add two tabs during Week 4 and Week 5. Each week's portion should be contained in one worksheet.
Using the Demographic worksheet the in the Database Template, create an automatic sort by applying a filter to each column so your data can be viewed in different ways.
Format the Demographic worksheet so it can be printed in landscape format, on a single page with a header in the header field that says “Database”. Add boxes around each cell.
Click the Assignment Files tab to submit your assignment.
Week 3
Resource: Database Template, Excel Guide
Complete the Encounters worksheet in the Database Template you started in Week 2. Using the first one as an example, complete the five encounters for three of the clients in the Demographics worksheet in Week 2 by adding formulas to columns G, H and I as follows:
• The formula in column G should reflect the number of hours of service times the fee per hour.
• The number in column H is up to you. Add a dollar amount that the client paid.
• The formula in column I should reflect the amount due minus the amount paid.
Once you have correctly entered the formulas for columns G, H and I in line 2, copy and paste the formulas down the entire column so that all row in these 3 columns contain the formulas.
Save your work.
Click the Assignment Files tab to submit your assignment.
Week 4
Resource: Database Template, Excel Guide: How to Create a Pivot Chart
Open the Database Template and click on the “Demographics” tab. Create a pivot table and bar chart reflecting the number of clients taking each type of medication.
Follow the instructions in the Excel Guide to create the pivot table and the bar chart, and change the tab label.
Save your work.
Click the Assignment Files tab to submit your assignment.
Week 5
Resource: Database Template, Excel Guide: How to Create a Pie Chart
Open the Database Template and click on the “Encounters” tab. Create a pivot table and a pie chart reflecting the dollar amount due to each of the three care providers.
Follow the instructions in the Excel Guide to create the pivot table and the pie chart, and change the tab label.
Save your work.
Click the Assignment Files tab to submit your assignment.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.