Click here to access the cardiac output spreadsheet activity. Complete the activity and you will learn some complex definitions to do with the function of the heart....AND....how to write simple formulae in Excel.
Hints: to write the formula for cell C14 (second half of question 2):
Click on cell C14,
In the formula bar near the top of the spreadsheet (just above column C on the spreadsheet) type =, (so Excel knows you want to write a formula)
then click on cell C12 (the value for body surface area),
then hold down shift and hit the number 8 (which is the mutiply sign),
then type 2.75 (cardiac index for 11-14 year olds given on the instructions page)
finally hit the 'enter' key.
There should now be a number in cell C14 and if you click on cell C14 the formula bar should read...=C14*2.75
To calculate the value for cell C18 you need to divide your cardiac output by your pulse rate (number of beats per minute). Use the same method as above but the divide sign is / (forward slash) which can be typed by hitting the question mark key. Remeber you don't need to type any of the numbers you need in your formulae, you just need to click on the cell those numbers are in.
No comments:
Post a Comment