1 / 16

Thinking out loud

Practice setting up intersection traffic rules using IF-THEN statements. Explore nested conditions and model different scenarios. Learn to flowchart and implement in Excel.

kforrest
Download Presentation

Thinking out loud

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Thinking out loud

  2. 1B 2A 2B 1A Traffic Scenario

  3. How would you set up the intersection? An exercise in Monday morning quarterbacking

  4. Basic Model

  5. IF loving you is wrongTHEN I don’t 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 > 65 Yes No Issue Ticket No Ticket

  9. Sample Problem 1

  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 < 40 Yes No Issue Ticket Speed > 65 Yes No Issue Ticket No Ticket

  13. Nested IF-THEN Statements

  14. Basic Model

  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.

More Related