Thinking out loud

1
Thinking out loud
2
Traffic Scenario
3
How would you set up the intersection?

• An exercise in Monday morning quarterbacking

4
Basic Model
Traffic Lane Max Length of Light Minimum Length of Light Time for car to clear intersection Of Cars Time Needed Time Given (s) Of Cars Leftover
Lane 1A
Lane 1B
Lane 2A
Lane 2B
5
IF loving you is wrongTHEN I dont want to be
right
6
IF-THEN Statements

• If, Then, Else (a.k.a. Otherwise)
• What is your procedure?
• In excel this is written as
• IF(Condition, True Value, False Value)

7
Sample Problem 1

• If a driver is going over 65 mph a speeding
  ticket should be issued.

8
Sample Problem 1
Speed gt 65
Yes
No
Issue Ticket
No Ticket
9
Sample Problem 1
Speed Caught Traveling Action To Be Taken
65 Issue Ticket
55 No Ticket
Speed Caught Traveling Action To Be Taken
65 IF(A11lt65,"No Ticket","Issue Ticket")
55 IF(A12lt65,"No Ticket","Issue Ticket")
10
Nested IF-THEN Statements

• What if you have a second condition?
• IF(Cond, True ,IF(Cond, True, False))

11
Sample Problem 2

• If a driver is going over 65 mph or under 45 mph
  a speeding ticket should be issued.

12
Sample Problem 2
Speed lt 40
Yes
No
Issue Ticket
Speed gt 65
Yes
No
Issue Ticket
No Ticket
13
Nested IF-THEN Statements
Speed
65 IF(A11gt64,"Ticket",IF(A11lt40,"Ticket","No Ticket"))
14 IF(A12gt64,"Ticket",IF(A12lt40,"Ticket","No Ticket"))
55 IF(A13gt64,"Ticket",IF(A13lt40,"Ticket","No Ticket"))
Speed
65 Ticket
14 Ticket
55 No Ticket
14
Basic Model
Traffic Lane Max Length of Light Minimum Length of Light Time for car to clear intersection Of Cars Time Needed Time Given (s) Of Cars Leftover
Lane 1A
Lane 1B
Lane 2A
Lane 2B
15
Directions

• Break the problem into steps and verbalize what
  you want to do with your partner.
• Draw a flow chart that outlines your solution
• Add columns to your spread sheet and perform to
  perform the necessary calculations in stages

16
Possible Connections

• Nature of Science
• Scientific Method
• Objective Experimentation and Observation.