Skip to main content

Participation Project #8: PivotTables

WV Mining Problem Problem

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 8, 2024. 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].

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.ED05 Use tables and PivotTables to organize data.
C01.ED06 Use charts, PivotCharts, and sparklines to present data in a graphical format.
C05.ED01 Locate and access data and resources necessary to solve problems.
C05.ED08 Interpret and analyze spreadsheet data

References

  1. B. M. Powell, Excel: PivotTables Participation Project. West Virginia University, 2021. Available: https://www.youtube.com/watch?v=OpQSEThrt5Y.