Multi-Week Project: Nov. 11-13 / Nov. 18-20 / Dec. 2-4 (in lab sections)
One of the most fun, rewarding, and creative aspects of computation is the ability to take your own ideas and make them a reality – you get to make something that never existed before!
The final project for CS 105 will span the last three lab sections and you will work on your project with a team of peers from your lab section along with your TA.
In lab, you will pick your own teams of 2-3 students (no groups of 1; no groups of 4+) to work in to complete the Excel lab (Lab #11). As part of the lab, you will submit a sheet of paper to your TA that indicates your team.
Before your lab section, 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 and more columns your data has will make the later parts of the project more interesting.
In addition to the data, you must create an Overview sheet as part of your Excel workbook where you have at least one interesting fact per group member that you found about your data using Excel formulas. This interesting fact must require more analysis than a simple arithmetic expression (eg: more than just an AVERAGE or SUM).
You will be required to show your data and interesting facts to your TA and submit your Excel sheet.
Before your final lab section, your team must create a Simulation sheet as part of your Excel workbook. This sheet must contain two major components:
RAND()
(or RANDBETWEEN()
) function in
Excel. This simulation must produce different, random results every time F9
is
pressed.
Finally, you must add to your Overview sheet at least one interesting observation per group member about the results of your simulation. These observations do not need to contain formulas, but most often do.
You will be required to show your data and interesting facts to your TA and submit your Excel sheet.
The final project is worth a total of 90 points, where the points are divided in the following way: