Assignment Files
Submissions
You must submit your completed file(s) through the CS101 Submit Assignments tool.
Due Date
This assignment is due on Thursday, January 23, 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
Tables are very useful - especially for sorting and filtering. They’re something I use nearly every day, and if your job will require any use of data, I think you’ll find them as useful as I do.
A few notes about the assignment-
- Numbers are rows
- Letters are columns
- In step 3b, you’re asked to insert new columns in the table. Right click IN the table and choose to insert a column to the right. You’ll rename the columns later.
- Step 4a asks you to format in a table style of your choice - highlight the table (the range specified) and under the home tab, look for the Format as Table button. Pick a style, any style.
- Step 6a asks you to turn on total row. Click in the table. Go to the Ribbon, click on the contextual “Table” ribbon that shows up. Click on total row. It will appear at the ed of the table.
- Answering the analysis questions are optional.
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.ED05 | Use tables and PivotTables to organize data. |
| C05.ED01 | Locate and access data and resources necessary to solve problems. |
| C05.ED08 | Interpret and analyze spreadsheet data. |
References
- B. M. Powell, Excel: Tables Participation Project. West Virginia University, 2021. Available: https://www.youtube.com/watch?v=-ztW0nhTv7Q.