| Exercise Activity using the Excel Programme |
| For use outside BUPS/BIS |
| This is an activity to illustrate the effect of exercise on breathing and heart beat. The first part is a student practical controlled by the teacher, where the students collect the data. This data can then be taken to the computer lab, and using the excel programme below, a set of graphs are automatically generated. These should illustrate the effect well, and the experiment can be written up. The follwing instructions should be comprehensive. If you have any questions please feel free to contact me at [email protected]. |
| 1. Students download the Excel file by clicking on the link below. |
| 2. Students enter data into ALL the yellow boxes, - for example; |
| a) Enter your class in the first box |
| b) Enter the names of the students in each group in the next three boxes (if there are two of them, leave the last box empty). |
| c) Enter all the numbers you have collected for pulse & breathing, at rest and during exercise. |
| * DO NOT LEAVE ANY BOXES EMPTY or the programme will not work! |
| * If you only have two numbers, enter one of them twice. |
| * If any numbers are very strange and different from the others (very big or very small) then DO NOT use these numbers - alter any anomalies by substituting them with suitable figures |
| If you have filled in all boxes correctly, then all graphs should automatically be correct. |
| 3. Please check the graphs before you print them. |
| 4. Once you have all the graphs, DO NOT SAVE. Just close the Excel programme and the internet connection. |
 |
| Created by K.Machin, BUPS/BIS, Turkey - [email protected] - January 2007 |
| The Practical |
| 1. Arrange students into groups of three, and name each student A, B and C. 2. Teach students how to feel their pulses - using 3rd and 4th fingers and not thumbs. 3. The teacher counts for 30 seconds while students count their pulse. 4. Students record the figures. 5. This is repeated three times to get an average. 6. Tell the students to sit, relax and not to think about their breathing. 7. The students record each others breathing (e.g. A watches B, B watches C, and C watches A) 8. This is repeated three times. 9. Then all student A's moves to the front of the classroom and exercise for 5 minutes (this gets loud!). 10. B records A's pulse, whilst C records A's breathing rate, whilst the teacher times the activity. * immediately after exercise, B and C record for 30 seconds only (i.e. T=0s to T=30s) * everyone waits for 30 seconds (i.e. T=30-60s) * after 1 minute, B and C record again for 30 seconds only (T=60s-90s) * after 2 minutes, B & C record again for 30 seconds (T=120-150s) * after 3 minutes, B & C record again for 30 seconds (T=180-210s) 11. Repeat this with B running, C recording B's pulse and A recording B's breathing. 12. Repeat with C running, A recording pulse, B recording breathing. 13. Now take figures to the computer room. |
| The Analysis |
| 5. Back in the classroom, the increases in rates can be compared from student to student. As can the recovery times, and maybe a link to fitness can be established. This can be written up as an experiment with aim, method, results, analysis, evaluation etc... |