Assignment Files
Submissions
You must submit your completed file(s) through the CS101 Submit Assignments tool.
Due Date
This assignment is due on Thursday, February 13, 2025. For on-campus sections, it is due by the end of class. For online sections, it is due by 11:59:59 PM Eastern Time. Late work will not be accepted.
Grades
This assignment is worth 8 points. A grading rubric is provided at the end of the assignment instructions. Over the entire semester, students must complete at least 20 Participation Projects to earn a maximum of 160 points.
Help & Resources
Video
This video is also available on YouTube [1].
Assignment Notes
Step 3
1. Copy and Paste the formula from the PDF directly into Excel.
2. You will find the Scenario Manager and the Goal Seek on the Data Ribbon under What-If Analysis.
3. You use the Scenario Manager, you'll get a pop up box. The pop up won't have scenarios in it. You'll have to hit the "Add" button to put them in.
Step 5c, Part 2 and 3
Using the Goal Seek requires a formula in your destination cell to work as it uses the numbers that are part of the formula to manipulate and get you the new results. So it's like asking Excel "I want this equation to equal X, what does Y need to be?" The value in the "By Changing Cell" field of the dialog box should be a percentage. You are looking for a percentage to get the value 169,206,836 in cell G16.
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.ED04 | Write formulas using cell references and functions to calculate data. |
| 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. |
References
- B. M. Powell, Excel: What-If Analysis Participation Project. West Virginia University, 2021. Available: https://www.youtube.com/watch?v=OCBM0sjXnaY.