Homework #1

Assignment Files

Instructions Data Files Sample Solution

Submissions

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

Due Date

This assignment is due on Friday, February 14, 2025 at 11:59:59 PM Eastern Time. Late work will be accepted for reduced credit until Tuesday, February 18, 2025 at 11:59:59 PM Eastern Time.

Grades

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

Help & Resources

Homework #1 Help Video & Projects CS101 Learning Center

Assignment Notes

A sample solution is provided for Homework #1. This is not available for any other Homework assignments. Work must be done on an individual basis, per direction given in the academic integrity policy.

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.