CS 105

MP7: The Final Excel MP!

Released: Later Today
Due: Next Tuesday, April 14 (8:00pm)
On the course website

Part 1: Computational Thinking
(Scratch, JavaScript)

Part 2: Computational Excel
(Excel, Excel, and more Excel)

Part 3: Data Visualization
(JavaScript, HTML, d3.js)

Create your own data visualization using your own data that you gather!

The last three lab sections of the semester will be entirely focused on the project.

Before lab, your team will find or gather a data set consisting of at least 300 rows of data, where each row contains at least 5 unique columns.
In general, the more rows/columns your data has the easier the later parts of this project become. These are minimums.
The data set must be unique to your team; every team needs their own data set. The data set must also not be one used in CS 105.
Due: Beginning of your of lab sections.

Before lab, your team will create a hand-drawn data visualization of your data. (We will be talking about data visualization in lecture before this is due.)
The visualization must be something that is not practically possible to do in Excel (No bar charts, no pie charts, etc).
The visualization must visualize at least 15 data points from your data. It will be a small-scale version of what you will have the computer do for you!
Due: Beginning of your of lab sections.

Using d3.js, your team will create a data visualization of your data you gathered. You and your team will give a short presentation about this to your lab section.

The last major component of Excel we will look at are pivot tables.

Pivot tables provide easy summarization and aggregation of data.

Pivot tables allow for four dimensions to be chosen: