Grade 5- Comparing 3,4,5 Mile Run Times Table (Microsoft ...



Grade 5- Comparing 3,4,5 Mile Run Times Table (Microsoft Excel)

Materials needed:

Average Time per grade level, supplied by PE Teacher

Introduction:

Why should be look at this data?

Have students make predictions on which grade level’s time is the longerst/ shortest and why.

Procedure:

1. Open Excel

2. Click “Magic Box” and change font size to 14

3. Type Name is cell A1

4. Click in cell B3, Click Underling button and type 3, 4,5 Mile Run

5. Highlight cells A50B8. Click on Border Button and choose All Borders to place border around cells.

6. Click in cell A5, type Grade Level, widen Column A

7. Click in cell B5, type Average Time, widen column

8. Click on the B on column B and click on center button

9. Click in cell A6, type Three

10. Click in cell A7, type Four

11. Click in cell A8, type Five

12. Click in cell B6, B7, B8, type in data

13. Highlight cells A5-B8, click on Chart Wizard button on Toolbar

14. Use the Chart Wizard to create a Column Graph

15. Title- Average Mile Run Times

16. X Axis- Grade Levels

17. Y Axis- Times

18. Click on the Legend tab and uncheck the Legend box

19. Save the graph as an object in Sheet 1.

20. Move graph under chart and resize.

21. To see page division lines, click in empty cell, click on print preview button and click close. You will now see a dotted line that will help you place graph on the page.

22. Save and print.

Discussion:

Draw conclusions from data collected.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download