1 / 56

Activity 1a

Activity 1a. Activity 1 – Part 1. Facts from Scenario – Learn them all! There are six stages in the race A stage must start and finish in one of the nine towns A stage must go through all nine towns A stage must be at least 150km but must not exceed 200km

vadin
Download Presentation

Activity 1a

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. Activity 1a

  2. Activity 1 – Part 1 Facts from Scenario – Learn them all! • There are six stages in the race • A stage must start and finish in one of the nine towns • A stage must go through all nine towns • A stage must be at least 150km but must not exceed 200km • A check point is where two or more roads cross • Overall Champion • All riders start together, each rider given an individual time for each stage • If a rider fails to complete a stage they are out of the competition • Rider with the lowest aggregate time wins • Team Race • Each team has 5 riders, fastest 3 of those are recorded for each stage • Town with overall shortest team time over the 6 stages wins • King of the Mountains • 2 stages must be climb stages • Can only have 2 category 1 climbs or 1 category 1 and 1 category 2 climb • Category 1 climb should average greater than or equal to 9% • Category 2 climb should average in excess of 7% but less than 9% • Sprint Cup • One stage must be a sprint stage • No climbs greater than 5% • Spotters at 6 of the checkpoints

  3. Activity 1b

  4. Activity 1 – Part 2 Decisions – Learn them ALL • Routes for each stage, making sure 1 stage is a sprint and 2 other stages are climb stages • Which stage will be a sprint stage, with no climbs greater than 5% • Which stages will be climb stages – either 2 cat 1 or 1 cat 1 and 1 cat 2 • Average Heights of climbs • Length of stages (more than 150km but less than 200km) Assumptions – Learn them ALL • That the pedometer has given accurate distances between checkpoints • Height measurements are accurate for each checkpoint. • Aggregated climb % are accurate based on the watch measurements. Remember – Activity, Name, Candidate No, Centre No in the Header or Footer

  5. Activity 2

  6. Activity 2 – Learn All Points • Why Height & Distance Data is inaccurate • Low quality Pedometer used gives inaccurate data • Pedometer Data rounded to the nearest KM so not exact • Altimeter measure atmospheric pressure but needs to be properly set up • Best results with Google Earth or other satellite technology Other ways to get Height & Distance Data • Sat Navigation Technology • Google Earth • Tape measure, Ordinance survey maps Remember – Activity, Name, Candidate No, Centre No in the Header or Footer

  7. Activity 3a

  8. Activity 3a – Step 1 Click on the blank worksheet Rename the worksheet Tdistance & Height Click on cell A1 in the Tdistance & Height Worksheet

  9. Activity 3a – Step 2 Click on Data and then From Text Find the TDistanceand click on Import

  10. Activity 3a – Step 3 Click Next

  11. Activity 3a – Step 4 Click Comma and Next

  12. Activity 3a – Step 5 Click Finish Click OK

  13. Activity 3a – Step 6 Click G1 Click Data and From Text

  14. Activity 3a – Step 7 FindTHeightsand click Import

  15. Activity 3a – Step 8 Click Next

  16. Activity 3a – Step 9 Click Comma and then Next

  17. Activity 3a – Step 10 Click Finish Click OK

  18. Activity 3a – Step 11 Finished Worksheet should look like this

  19. Activity 3b

  20. Activity 3b – Step 1 Click on M4 in the Height worksheet Type in the following formulae Or type in = and click on cell G1 in the TDistance & Height worksheet

  21. Activity 3b – Step 2 Click on M4 and replicate the formulae down to N36

  22. Activity 3c

  23. Activity 3c – Step 1 Click on A3 in the Distances worksheet Type in the following formulae Or type in = and click on cell A1 in the TDistance & Height worksheet

  24. Activity 3C – Step 2 Click on A3 and replicate the formulae down to E35

  25. Activity 3d

  26. Activity 3d – Step 1 Click on I7 Stage Builder worksheet Type in the formula =IF('Climb Calculation'!J52>0,"YES","NO“)

  27. Activity 3d – Step 2 Drag to copy the formulae across to N7 Drag the formulae down to N9

  28. Activity 3d – Step 3 Click on I10 Stage Builder worksheet Type in the formula =IF('Stage Builder'!B30>150,"Yes","NO") Drag the formula across to N10

  29. Activity 3d – Step 4 Click on I11 Stage Builder worksheet Type in the formula =IF('Stage Builder'!B30<200,"Yes","NO") Drag the formula across to N11

  30. Activity 3e

  31. Activity 3e – Step 1 Click on U28 Stage Builder worksheet Type in the formula =SUM(U6:U27)

  32. Activity 3e – Step 2 Drag the formula from U28 to AC28

  33. Activity 3f

  34. Activity 3f – Step 1 Click on I15 Stage Builder worksheet Type in the formula =COUNTIF(U28:AC28,0)

  35. Activity 3f – Step 2 Click on I16 Stage Builder worksheet Type in the formula =IF(MIN(U28:AC28)=1,"YES","NO")

  36. Activity 3f – Step 3 Click on I17 Stage Builder worksheet Type in the formula =SUM('Climb Calculation'!J53:O53)

  37. Activity 3f – Step 4 Click on I18 Stage Builder worksheet Type in the formula =COUNTIF('Climb Calculation'!J53:O53,"2")

  38. Activity 3f – Step 4 Click on I19 Stage Builder worksheet Type in the formula =COUNTIF('Climb Calculation'!J51:O51, "<=5%")

  39. Activity 3f – Step 5 Click on I20 Stage Builder worksheet Type in the formula =IF(I19=1,"YES","NO")

  40. Activity 3g

  41. Activity 3g – Step 1 Use the drop down list to select these towns for Stage 1, 2 & 3

  42. Activity 3g – Step 2 Use the drop down list to select these towns for Stage 4, 5 & 6

  43. Activity 3h

  44. Activity 3h – Step 1 Click on I12 Select Climb (because 2 Yes’ in 17 & I8) Click on J12, K12 & L12 Select Normal (because 2 No’s)

  45. Activity 3h – Step 2 Click on M12 Select Climb (because 2 Yes in M7 & M8) Click on N12 Select Normal (because 2 No’s)

  46. Activity 3i

  47. Activity 3i – Step 1 • You must print out each worksheet as per the exam instructions (i.e formula view etc) • Highlight the area you want to print • Click on Page Layout • Click on Print Area • Click on Set Print Area

  48. Activity 3i – Step 2 • Click on Formulas • Click Show Formulas to show the formula • Click Show Formulas again to hide formulas • Adjust columns to show all of the formulas

  49. Activity 3i – Step 3 • You must print out each worksheet as per the exam instructions (i.e formula view etc) • Click on Page Layout • Click on the little arrow at the bottom of the Page Setup box

  50. Activity 3i – Step 4 • On the Page Tab • Click on Landscape • Click on Fit to – 1

More Related