CS 105 Week 10, Part 2 MP7 Out: Later Today Due: Next Tuesday by - - PowerPoint PPT Presentation

cs 105
SMART_READER_LITE
LIVE PREVIEW

CS 105 Week 10, Part 2 MP7 Out: Later Today Due: Next Tuesday by - - PowerPoint PPT Presentation

CS 105 Week 10, Part 2 MP7 Out: Later Today Due: Next Tuesday by 6pm Grade Refresh Regrades MP4-6 Labs and Activites Midterm 2 Exam Tuesday, Nov. 18, 2014 8:00pm 9:30pm (Conflict signups online) Final Project Final Project The


slide-1
SLIDE 1

CS 105

Week 10, Part 2

slide-2
SLIDE 2

MP7 Out: Later Today Due: Next Tuesday by 6pm

slide-3
SLIDE 3

Grade Refresh Regrades MP4-6 Labs and Activites

slide-4
SLIDE 4

Midterm 2 Exam Tuesday, Nov. 18, 2014 8:00pm – 9:30pm (Conflict signups online)

slide-5
SLIDE 5

Final Project

slide-6
SLIDE 6

Final Project

  • The pinnacle of CS 105 is the final

project!

slide-7
SLIDE 7

Final Project

  • The pinnacle of CS 105 is the final

project!

–Group project: 2-3 people

slide-8
SLIDE 8

Final Project

  • The pinnacle of CS 105 is the final

project!

–Group project: 2-3 people –Must be from your lab section

slide-9
SLIDE 9

Final Project

  • The pinnacle of CS 105 is the final

project!

–Group project: 2-3 people –Must be from your lab section –Your TA will be assisting you and grading you on the project

slide-10
SLIDE 10

Final Project

  • Topic:

–Largely up to you! The best project is a project that uses computing to solve a problem that exists for you already!

slide-11
SLIDE 11

Final Project

  • Languages:

–JavaScript

  • Console-based
  • HTML based

–Excel

slide-12
SLIDE 12

Final Project

  • Languages:

–JavaScript

  • Should be a decent code base, ~50 lines
  • f JavaScript. Ideally, includes an

HTML/CSS web page that is well designed as a front-end to the JavaScript.

–Excel

slide-13
SLIDE 13

Final Project

  • Languages:

–JavaScript –Excel

  • Must be an original data set of

substantial data or extremely deep analysis of existing data. Must be significantly larger than MP4-7.

slide-14
SLIDE 14

Final Project Ideas

slide-15
SLIDE 15

Final Project Ideas Idea #1: Genetic Diversity

slide-16
SLIDE 16

Idea #1: Genetic Diversity

  • We all know about blood

phenotypes: A, B, AB, and O.

slide-17
SLIDE 17

Idea #1: Genetic Diversity

  • We all know about blood

phenotypes: A, B, AB, and O.

  • With O being recessive, how is it that

O is the most common blood type?

–Population dynamics!

slide-18
SLIDE 18

Idea #1: Genetic Diversity

  • Simulation:

–Create an artificial world in JavaScript of 1000 simulated “people”:

  • Start 90% of the people as OO,
  • 5% of the people with AA, and
  • 5% of the people with BB.
slide-19
SLIDE 19

Idea #1: Genetic Diversity

  • Simulation:

–Create an artificial world in JavaScript of 1000 simulated “people”:

  • Start 90% of the people as OO,
  • 5% of the people with AA, and
  • 5% of the people with BB.

–Randomly pair all of the people, have them produce two offspring. What happens?

slide-20
SLIDE 20

Final Project Ideas Idea #2: Stock Market

slide-21
SLIDE 21

Idea #2: Stock Market

  • Create a portfolio for each member

in your team, where each member gets a random stock that fits some category (JavaScript).

slide-22
SLIDE 22

Idea #2: Stock Market

  • Create a portfolio for each member

in your team, where each member gets a random stock that fits some category (JavaScript).

–How did it do in 2013? –Continue to refine the category basis

  • n how the stock is picked.
slide-23
SLIDE 23

Final Project Ideas Idea #3: Data APIs

slide-24
SLIDE 24

Idea #3: Data APIs

  • Create an interesting data set on a

topic you are interested in:

–Volleyball? Softball? Football? Soccer? Band? Chess? Bridge? LOL? DOTA2? Facebook? …

slide-25
SLIDE 25

Idea #3: Data APIs

  • Create an interesting data set on a

topic you are interested in:

–Volleyball? Softball? Football? Soccer? Band? Chess? Bridge? LOL? DOTA2? Facebook? … –Create the dataset in Excel, export it into a CSV format, and then use a JavaScript API to visualize it

slide-26
SLIDE 26

Final Project Ideas Your Idea

slide-27
SLIDE 27

Final Project Timeline

  • This Week: Form your groups in lab,

work with your groups on an idea.

slide-28
SLIDE 28

Final Project Timeline

  • Next Week: Submit a project

proposal to your TA in lab. S/he will approve it or request you refine it and resubmit it. [20 points]

slide-29
SLIDE 29

Final Project Timeline

  • Week 3: Present a milestone update
  • f your project, showing that you

have made progress toward completing it. [30 points]

slide-30
SLIDE 30

Final Project Timeline

  • Week 4: Present your final project to

your TA, turning in your code and a write-up about your project. [50 points]

slide-31
SLIDE 31

Final Project Timeline

  • We’ll show of some of the top

projects in lecture!

slide-32
SLIDE 32

Pivot Tables

slide-33
SLIDE 33

A pivot table is a data summarization tool

slide-34
SLIDE 34

Pivot Table

  • Summarize: A pivot-table can

automatically sort, count, total, or give the average of the data stored in

  • ne table or spreadsheet.
slide-35
SLIDE 35

Pivot Table

  • Summarize: A pivot-table can

automatically sort, count, total, or give the average of the data stored in

  • ne table or spreadsheet.
  • Display: It displays the results in a

second table (called a "pivot table") showing the summarized data.

slide-36
SLIDE 36

Pivot Table

  • Each column fill one of four roles:

–Row Label –Column Label –Filter –Summarization Value

slide-37
SLIDE 37