Assignment 1: W1A1 HealthWays Budget
Throughout this course, you will utilize spreadsheet software (Microsoft Excel) to perform economic and financial calculations. In this activity, you will practice some fundamental mathematical applications of spreadsheet software that enable you to use the spreadsheet as a calculator. You will also learn how to use formulas and functions, and present data in Excel.
To Prepare
• Download and review the document Healthcare Budget Request Guide.
• Download and review the Excel Assignment Workbook. Open the Worksheet tab titled “W1A1 HealthWays Budget”.
The Assignment
Using the Healthcare Budget Request Guide for guidance, complete the worksheet tab titled “W1A1 HealthWays Budget”.
Rubric Detail
Download and review the document Health Budget Request Guide.
90 (90%) – 100 (100%)
All directions are followed properly in completing workbook.
Workbook is properly formatted, with additional formatting beyond what is directed.
All formulas are written accurately, as directed.
All functions are written accurately, as directed.
All values are calculated accurately, as directed.
Graphs and tables are complete, accurate, and professional.
Learning Resources
Required Readings (click to expand/reduce)
Bright, S. and Beyt, G. (n.d.). Lessons in systems thinking: A tale from the land of middle health. Systems Thinker. Retrieved April 23, 2019 from https://thesystemsthinker.com/lessons-in-systems-thinking-a-tale-from-the-land-of-middle-health/
LaMarco, N. (2019). What is the purpose of using a spreadsheet? Retrieved from https://smallbusiness.chron.com/purpose-using-spreadsheet-54262.html
Newman, D. (2016). Three essential Excel skills for healthcare IT. Retrieved May 1, 2019 from https://healthcareitskills.com/excel-skills-for-healthcare-it/
Document: Excel Assignment Workbook (Spreadsheet)
Document: Healthcare Budget Request Guide (Word document)