Skip to main content

Homework Project #2 (Excel)

Excel - Healthcare Expenditures

Assignment Files


You must submit your completed file(s) through the CS101 Submit Assignments tool.

Due Date

This assignment is due on Friday, September 15, 2017 at 11:59:59 PM Eastern Time. Late work will be accepted for reduced credit until Tuesday, September 19, 2017 at 11:59:59 PM Eastern Time.


This assignment is worth 50 points. A grading rubric is provided at the end of the assignment instructions.

Help & Resources

Assignment Notes

Need help with homework 2?

We have videos! The Homework Help Projects are available under Help on the website.  Here's a link to the first one

The homework help project is not the same as your homework assignment.  It covers all the same topics, but is not identical.  The video is provided to give you an example of how to do something (for example, import an XML file).

If you have questions, please let me know!

Associated Learning Objectives

This assignment covers the following course and unit learning objectives:

Number Learning Objective
C01 Build spreadsheets to perform calculations, display data, conduct analysis, and explore what-if scenarios.
C05 Identify, access, and evaluate information to solve real world problems.
C01.ED02 Create and manage workbooks, worksheets, and their data.
C01.ED03 Format worksheets and cells to create professional reports.
C01.ED04 Write formulas using cell references and functions to calculate data.
C01.ED05 Use tables and PivotTables to organize data.
C01.ED06 Use charts, PivotCharts, and sparklines to present data in a graphical format.
C01.ED07 Use what-if analysis tools to project future values and prepare different scenarios.
C05.ED01 Locate and access data and resources necessary to solve problems.
C05.ED08 Interpret and analyze spreadsheet data