MP7: The Final Excel MP!
Released: Later Today
Due: Next Tuesday, April 14 (8:00pm)
On the course website
CS 105: Big Picture
Part 1: Computational Thinking
(Scratch, JavaScript)
Part 2: Computational Excel
(Excel, Excel, and more Excel)
Part 3: Data Visualization
(JavaScript, HTML, d3.js)
CS 105 Final Project
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.
Final Project: Week #1
- This week will be your last "normal" lab section.
- However, as part of this week's lab, you will choose your own team!
- Teams must be 2-3 people; no teams of 1, no teams of 4+
- Complete Lab #10 with your team and that will be your final project team.
Final Project: Week #2
-
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.
Final Project: Week #3
-
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.
Final Project: Week #4
-
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.
Pivot Tables
The last major component of Excel we will look at are pivot tables.
Pivot tables provide easy summarization and aggregation of data.
Pivot Tables
Pivot tables allow for four dimensions to be chosen:
- Column Data
- Row Data
- Values
- Filters