Excel Worksheet

Excel Worksheet.

A Skills Approach: Excel 2016 Chapter 3: Using Formulas and Functions

1 | Page Skill Review 3.2 Last Updated 3/19/18

Skill Review 3.2 In this project you will edit a worksheet to compute student grades and grade statistics. Be sure to save your work often!

Skills needed to complete this project: • Using Date and Time Functions

• Using CONCAT to Combine Text

• Formatting Text Using Functions

• Creating Formulas Using Counting Functions

• Using Formula AutoComplete to Enter Functions

• Displaying and Printing Formulas

• Naming Ranges of Cells

• Using the Logical Function IF

• Using the Function Arguments Dialog to Enter Functions

• Working with Named Ranges

• Finding Minimum and Maximum Values

• Calculating Averages

• Finding Data Using the VLOOKUP Function

• Checking Formulas for Errors

1. Open the start file EX2016-SkillReview-3-2. The file will be renamed automatically to include your

name. Change the project file name if directed to do so by your instructor, and save it. Click the Enable

Editing button in the Message Bar at the top of the workbook so you can modify it.

2. Take a look at the two sheets. The first sheet contains the students’ names and their scores. The second

sheet will be used to look up the letter grade for each student.

3. On the Scores worksheet, enter a function in cell B3 to display the current date and time.

a. If necessary, click the Scores worksheet tab. Click cell B3.

b. On the Formulas tab, in the Function Library group, click the Date &Time button.

c. Click NOW.

d. Click OK.

4. The first column should display the full student name. Use CONCAT to combine the values from the

First Name and Last Name columns.

a. Click cell A10.

b. On the Formulas tab, in the Function Library group, click the Text button, and select CONCAT.

IMPORTANT: If you do not see CONCAT in the list, use CONCATENATE function instead.

c. Click cell C10 to enter the cell reference in the Text1 argument box.

d. Press TAB to move to the Text2 argument box.

e. Type ” ” to place a space between the first and last names.

f. Press TAB to move to the Text3 argument box.

Step 1 Download start file

 

 

A Skills Approach: Excel 2016 Chapter 3: Using Formulas and Functions

2 | Page Skill Review 3.2 Last Updated 3/19/18

g. Click cell B10 to enter the text reference in the Text3 argument box.

h. Click OK. The completed formula should look like this: =CONCAT(C10,” “,B10)

5. Add the PROPER function to the formula so student names do not appear in all uppercase.

a. Double-click cell A10 to edit the formula.

b. Create a nested formula by typing PROPER( between the = symbol and CONCAT.

c. Type another ) at the end of the formula.

d. Press ENTER. The completed formula should look like this:

=PROPER(CONCAT(C10,” “,B10))

e. Copy the formula from cell A10 to A11:A26 to fill the list of student names. Use any method you

want.

6. Count the number of students to calculate the class size.

a. Click cell B2.

b. Type =COU

c. Double-click COUNTA in the Formula AutoComplete list.

d. Click cell A10 and drag to cell A26.

e. Press ENTER. The completed formula should look like this: =COUNTA(A10:A26)

7. Display your formulas to check for accuracy.

a. On the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

b. When you are ready to continue, hide the formulas and display formula values by clicking the Show

Formulas button again.

8. Define a named range for the total possible points up to the class drop cut-off point.

a. Select cells D7:R7.

b. In the Name box, type: PossiblePtsMid

c. Press ENTER.

9. Find out which students have a grade below C at the cut-off point for dropping the class. Enter an IF

function in cell S10 to check if the student’s total points divided by the total possible points through the

midterm is less than 70% (the lowest percentage for a C grade). Use SUM functions within the IF

function. Be sure to use the range name you just defined for possible points. If the student is below a C

grade, display Warning! in the cell; otherwise leave the cell blank.

a. Click cell S10.

b. On the Formulas tab, in the Function Library group, click Logical.

c. Click IF.

d. If necessary, move the Function Arguments dialog so you can see the worksheet data.

e. In the Logical_test argument box, type: SUM(D10:R10)/SUM(PossiblePtsMid)<70%

f. In the Value_if_true argument box, type: Warning!

g. In the Value_if_false argument box, type: “”

 

 

A Skills Approach: Excel 2016 Chapter 3: Using Formulas and Functions

3 | Page Skill Review 3.2 Last Updated 3/19/18

h. Click OK. The completed formula should look like this:

=IF(SUM(D10:R10)/SUM(PossiblePtsMid)<70%,”Warning!”,” “)

i. Fill the IF function in cell S10 down for all students. Use any method you want. There should be

three students with Warning! in the Class Drop Cut-Off Point column.

10. Find the highest score for each assignment.

a. Click cell D4.

b. Type =MAX( and then click cell D10 and drag to cell D26.

c. Press ENTER. The completed formula should look like this: =MAX(D10:D26)

d. Copy the formula across the row to cell AB4. Use any method you want. Be sure to leave cell S4

blank.

11. Find the lowest score for each assignment.

a. Click cell D5.

b. Type =MIN( and then click cell D10 and drag to cell D26.

c. Press ENTER. The completed formula should look like this: =MIN(D10:D26)

d. Copy the formula across the row to cell AB5. Use any method you want. Be sure to leave cell S5

blank.

12. Calculate the average score for each assignment.

a. Click cell D6.

b. Type =AV and then double-click AVERAGE in the Formula AutoComplete list.

c. Click cell D10 and drag to cell D26.

d. Press ENTER. The completed formula should look like this: =AVERAGE(D10:D26)

e. Copy the formula across the row to cell AB6. Use any method you want. Be sure to leave cell S6

blank.

13. Compute the students’ total points. Enter a SUM function in cell AC10 to add all the points across for

the first student.

a. Click cell AC10.

b. Type =SU and then double-click SUM in the Formula AutoComplete list.

c. Click cell D10 and drag to cell AB10.

d. Press ENTER. The completed formula should look like this: =SUM(D10:AB10)

e. Copy the formula from AC10 through cell AC26. Use any method you want.

14. Enter a formula to compute the percentage for the first student. Divide the student’s total points by the

total possible points. You will be copying this formula, so make sure the reference to the total possible

points uses an absolute reference.

a. In cell AD10, enter the following formula to calculate the percentage: =AC10/$AC$7

b. Copy the formula from AD10 through AD26. Use any method you want.

 

 

A Skills Approach: Excel 2016 Chapter 3: Using Formulas and Functions

4 | Page Skill Review 3.2 Last Updated 3/19/18

15. The grade scale is stored in the Grades worksheet. Before calculating students’ final grades, create a named

range to use in the formula.

a. Click the Grades sheet tab.

b. Select cells B4:C8.

c. Type GradeScale in the Name box.

d. Press ENTER.

16. Now you are ready to create a lookup formula to display each student’s final letter grade.

a. Return to the Scores sheet, and click cell AE10.

b. On the Formulas tab, in the Function Library group, click the Lookup & Reference button, and select

VLOOKUP.

c. Click cell AD10 to enter it in the Lookup_value argument box.

d. Type GradeScale in the Table_array argument box.

e. The rates are located in the second column of the lookup table. Type 2 in the Col_index_num

argument box.

f. In this case, you do not want to specify an exact match, as the percentage grades do not match the

grade scale percentages exactly. An approximate match will return the correct letter grade.

g. Click OK. The completed formula should look like this: =VLOOKUP(AD10,GradeScale,2)

h. Fill down for all students. Use any method you want.

17. Before closing the project, check your workbook for errors.

a. On the Formulas tab, in the Formula Auditing group, click the Error Checking button.

b. If errors are found, use the error checking skills learned in this chapter to find and fix the errors.

18. When Excel displays a message that the error check is complete, click OK.

19. Save and close the workbook.

20. Upload and save your project file.

21. Submit project for grading.

Step 2

Upload & Save

Step 3 Grade my Project

Excel Worksheet

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Case Studies in Neurology

Case Studies in Neurology.

ignment Details

Focus on Case Studies in Neurology

For this assignment you will respond to three case studies.

What is a Case Study?

ā€œA case study is a narrative used to help you practice real-life analysis and communication skills. It is a learning tool that provides readers with ā€œenough detail…to understand the nature and scope of the problem, and…serve as a springboard for discussion and learningā€ (O’Rourke, 2007, p. 391).

Use your textbook and academic resources from the Library to support your responses.

Access the Library directly from Course Resources for this class, or through the student portal. Be sure to cite and reference all your sources. The Library has a feature that allows you to automatically create an APA formatted reference.

Your completed case studies should be between 750–1000 words, and all sources must be properly cited using APA format.

CASE STUDY #1

  1. Amy is cooking dinner for her family. She moves to pull a pot off the stove and accidently touches the burner. She reflexively pulls her finger away from the stove and immediately feels the pain.
    1. Which receptor neuron is responsible for sending information from her finger to her peripheral nervous system?
    2. Is this receptor neuron, an afferent or efferent neuron?
    3. Explain where the information from the receptor neuron is sent and how does it result in Amy moving her finger away from the stove.
    4. Describe the three classes of neurons involved in this response.
    5. Evolutionarily, why do you think the human body has this system in place?
    6. What might happen if we did not have this response?

CASE STUDY #2

  1. Glen, who is 45 years old, begins to notice that his hands shake (tremors) when he is performing everyday tasks such as signing his signature. His family members have noticed that he also has muffled speech and tends to shuffle when he walks. He is diagnosed with Early Onset Parkinson’s disease.
    1. What is Early Onset Parkinson’s disease?
    2. What specific cell type is affected in Parkinson’s disease?
    3. What is dopamine? What effects does dopamine have on the body?
    4. Explain the structure of a synapse and why Glen’s neurologist would prescribe him a dopamine agonist?
    5. Glen has genetic testing performed and it is determined that he does carry an autosomal dominant mutation in the SNCA gene associated with Early Onset Parkinson’s disease. Glen has three children. Would you advise his children to have genetic testing performed to determine if they also carry the disease mutation? Why or why not?

CASE STUDY #3

3. Patricia, who is 37 years old, discusses with her physician recent symptoms that she has experienced including blurred vision, numbness in her fingers and face, dizziness, fatigue and weakness. The physician performs multiple neurological tests and she is diagnosed with multiple sclerosis (MS).

  1. What is MS?
  2. Is MS a disease of the central or peripheral nervous system?
  3. What is the main cell structure affected in MS?
  4. How is the action potential of a neuron affected in MS?
  5. The origins of MS are not clear. What do scientists hypothesize to be the causes of MS?

Your assignment should be written in an essay format. The assignment requires you to include details from research including the course materials and sources you locate on your own. Remember to use APA format to cite your sources of information, both within parenthetical citations and also within a reference page at the end of the project.

Basic Writing Requirements:

  • Between 750–1000 words not counting the title or reference pages.
  • Include a title page, double space, font size 10 or 12.
  • Include a well-developed introduction and conclusion
  • Provide exceptional content.
  • Demonstrate superior organization: use logic.
  • Free of grammar and spelling errors.
  • No evidence of plagiarism.
  • Use APA style for all citations and references.

Case Studies in Neurology

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Skeletal System

Skeletal System.

  Experiment 11: Skeletal System of the Fetal Pig

In this exercise you will become familiar with the skeletal system of the fetal pig. Because the fetal pig had not reached its full gestation, many of the bones have not fully developed, but are instead still cartilaginous. Still, we can look at this structures to gain a better understanding of the axial and appendicular skeletons, along with the joints.

 
  Materials

Fetal Pig Dissection Tray

Dissection Tools Kit String (should still be tied onto pig’s hooves)  
       

Procedure

1. To begin, lay your underpad down and place your dissecting tray on top of it. Lay out your dissecting tools. Be sure you have all of your safety equipment on before beginning the experiment.

2. Once prepared, gently open the bag your pig is in. Note:Ā DO NOTĀ destroy this bag or empty out the preserving solution within the bag, you will need it for the whole semester.

3. Lay your pig into the dissecting tray, dorsal side facing up. Slide the strings over the dissection tray to hold the pig in place.

4. Look at Figure 21 displaying the skeletal system of a grown pig. Notice the similarities and differences between that of your human skeleton and that of the pig.

5.
Figure 21:Ā Ā The pig skeleton

6. Due to the rigidity of your pig, it typically will not stay in this position on its own so you will need to hold it while you examine the skeletal system.

7. Begin by examining, through the skin, the axial skeleton as shown in Figure 21. Feel the bones of the skull, then continue down the vertebral column feeling the vertebrae along the way. Notice that the tail of the pig is composed of caudal vertebrae. Note your observations in Table 34.

8. Slide the strings off of the dissection tray and gently turn your pig ventral side up. Slide the strings back under the dissection tray after the pig is correctly positioned.

9. Feel the thoracic cage of the pig. Though you will not cut into the pig today, feel the similarities that occur between the fetal pig and the human skeleton model. Note your observations in Table 34.

10. Turn your attention to the appendicular skeleton. The pig’s four appendages correlate to the human arms and legs. Use Figure 21 as a guide to try and feel the different bones of the arms and legs (humerus, femur, tibia, etc.). Note your observations in Table 34.

11. In Figure 21, look at the pelvic girdle of the pig. This structure appears noticeably different than that of a human. However, the innominate bones of the pig are created by the ilium, ischium and pubis.

12. Focus your attention on the joints of the pig. The pig should be fairly rigid due to the preservation fluids. However, you should still attempt to produce the movements created by synovial joints on the pig (e.g., flexion, rotation, etc.). Notice the joints at which these movements are possible. Do they correlate to human movement? Note your observations in Table 34.

13. Take a photograph of your pig in the dissection tray for the upload document. Make sure that your name is written on a piece of paper that is clearly visible in the background of the photograph.

14. You are now finished with the external observations of the skeletal system. Remember that as you dissect into your pig, you will be able to touch and feel the bones of the skeletal system. As the dissection progresses, always take note of the bones present within the fetal pig.

15. To finish, locate the bag the pig came in. Gently place the pig back into the bag and tightly secure the bag with a rubber band, or place in the zip-seal bag provided in the dissection box.

16. Place the pig back into the cool environment you had previously stored it in. Remember, the best place to keep the pig is in a cool, dark place.

17. After your pig has been put away, clean off your dissecting tray and dissection tools with soap and water. There should not be any biological scraps because you did not cut into the pig. However, biological scraps should not be thrown into the garbage.

18. Clean the area in which you worked with soap and water as well. As long as the underpad has not been damaged, keep it for future experiments.

 
Figure 22:Ā Ā Palpate the skeleton of the fetal pig using gloved hands.

 

Table 34:Ā Skeletal Region Observations
Skeletal Region Observations
Axial Skeleton  
Appendicular Skeleton  
Joints  

 

 

 

 

 

 

   

 

  Ā© 2013 eScience Labs, LLC. All Rights Reserved      

Skeletal System

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Animal Physiology Questions

Animal Physiology Questions.

 

COMPARATIVE PHYSIOLOGY-Ā Animal Physiology

 

course introduction, composition of air, water vapor in air, solubility of gases, respiration in water, gills, countercurrent exchange, boundary layers, respiration in air, mammalian lungs

 

 

air-breathing fish, bird respiration, insect respiration, cyclic respiration, oxygen transport in blood, respiratory pigments, oxygen dissociation curves, facilitated diffusion

 

 

carbon dioxide transport, pumps and channels, water compartments, circulation patterns, cardiac output, blood vessels, physics of pipe flow, blood pressure, capillaries, exercise, invertebrate circulation, clotting

 

 

feeding, food types and mechanisms, hydrothermal springs, digestion, enzymes, wood and cellulose digestion, ruminants, nutrition, vitamins, minerals, trace elements, chemical defense, metabolic rate, energy storage, oxygen

 

 

diving mammals and birds, metabolic rate and body size, size and scaling, energy cost of locomotion, running, swimming and flying, physiological time

Biology 451 – Comparative Physiology – Exam 1

Pledge: In recognition of and in the spirit of the honor code, I certify that I have neither given nor received aid on

this examination.

 

(Signature) _________________________________

 

(Full Name, printed) ________________________________Student I.D. Number ____________________

 

Water vapor over a free water surface: 46.9 mmHg @ 37ļ‚°C; 31.7 mmHg @ 30 ļ‚°C; 17.5 mmHg @ 20 ļ‚°C;

12.8 mmHg @ 15 ļ‚°C; 9.2 mmHg @ 10°C

Solubility Coefficients @ 20ļ‚°C:  = 31 ml O2/l H2O;  = 878 ml CO2/l H2O;  = 15 ml N2/l H2O

Solubility Coefficients @ 15ļ‚°C:  = 34.1 ml O2/l H2O;  = 1019.0 ml CO2/l H2O;  = 16.9 ml N2/l H2O

MW of O2 = 32, MW of CO2= 44, MW of N2 = 28

 

For complete credit please show all calculations and units for problems 1-4 below. Write the correct answer

in the blank on the left side of the page for questions 5-7 (2 points per question)

 

Following the disastrous earthquake in Haiti, you are part of a team that has been contracted to conduct a survey of

the fauna and to document its recovery.

 

1) You land in Port-de-Paix on the northern coast of the island to begin your survey. You find an interesting group

of anolid lizards living in the vegetation adjacent to the beach. The temperature is 30 ļ‚°C, the relative humidity is

73%, and the locality is at sea level (barometric pressure = 760 mmHg). What is the partial pressure of carbon

dioxide in the air?

 

 

 

 

 

2) You begin trekking inland and discover a small freshwater lake that is inhabited by a diverse assemblage of

aquatic crustaceans. The elevation is 1815m (barometric pressure = 610 mmHg), the relative humidity is 62% and

the temperature is 20 ļ‚°C. What is the tension of nitrogen of the water in the lake?

 

 

 

 

 

3) You continue travelling inland and ascend the highest mountain, Morne de la Selle (2715 meters, barometric

pressure = 545 mmHg). At the top you discover a small pond that is inhabited by an unusual small fish species.

The temperature is 15 ļ‚°C and the relative humidity is 85%. What is the oxygen content (ml O2/liter water) of the

water in the pond?

 

 

 

 

 

4) Before departing Haiti you receive an invitation from a colleague to join her in the Aquarius underwater habitat

that is currently situated at 10 meters depth on the seafloor near the Ile de la Tortue, north of Port-de-Paix. She is

conducting experiments on corals in the surrounding patch reef area. The Aquarius habitat has open ports in the

bottom through which divers can enter the water, so the internal pressure in the habitat is the same as the ambient

pressure at that depth (1520 mmHg, relative humidity =100%, temperature = 20 ļ‚°C) and normal atmospheric air is

pumped down to the habitat from the surface. What is the partial pressure of nitrogen in the habitat?

 

 

 

 

Name _________________________________________ 2

The Aquarius habitat includes a small laboratory in which your colleague has installed aquaria to maintain the coral

specimens. The aquaria, which are filled with seawater, are equilibrated with the ambient air. Freshwater for

drinking and washing is kept in a large tank in the habitat and is also equilibrated with the ambient air in the

chamber.

 

5)_____ The tension of oxygen in the seawater in the aquaria would be (a. greater than; b. less than; c. equal to)

the freshwater in the tank.

 

6)_____ The oxygen content of the seawater in the aquaria would be (a. greater than; b. less than; c. equal to) the

freshwater in the storage tank.

 

7)_____ The tension of oxygen in the seawater in the aquaria would be (a. greater than; b. less than; c. equal to)

the tension of oxygen in the seawater surrounding the habitat at that depth.

 

 

Write the letter of the correct answer in the blank on the left side of the page (2 points each).

 

8)_____ In a mammalian circulatory system, the lowest pressure would be found in the (a. aorta; b. capillaries; c.

veins; d. vena cava.)

 

9)_____ The rate of diffusion of oxygen in air is (a. greater than; b. less than; c. equal to) the rate of diffusion of

oxygen in water.

 

10)____If the colloidal osmotic pressure is 30 mmHg and the hydrostatic pressure at a particular point in the

capillary is 22 mmHg, one would expect (a. reabsorption; b. no fluid movement; c. bulk filtration) to

occur at that point.

 

11)_____ During the ā€œclosedā€ phase of the cyclical respiration in insects, the partial pressure of oxygen in the

tracheal system (a. increases; b. decreases; c. remains relatively constant).

 

12)_____ Suppose that you perform an experiment on a mammal in which you decrease the oxygen content in the

inhaled air by 2.5%. You would predict that respiration by the animal would (a. increase; b. decrease; c.

remain unchanged).

 

13)_____ During exhalation, most of the air leaving the anterior air sacs of a bird (a. exits the mouth; b. enters the

posterior air sacs; c. flows into the lungs).

 

14)_____ The apparent viscosity of blood (a. increases; b. decreases; c. does not change) as the blood flows from

the arterioles to the capillaries.

 

15)_____ During inhalation, air flows from the (a. lungs; b. posterior air sacs; c. mouth) of a bird into the anterior

air sacs.

 

16)_____ If you monitored the pressure in the tracheal system of an insect, you would observe the lowest pressure,

relative to ambient, during the (a. fluttering phase; b. closed phase; c. open phase)

 

17)_____ Respiratory pigment molecules that are enclosed in blood cells tend to have a molecular weight that is (a.

greater than; b. less than; c. equal to) the molecular weight of respiratory pigments that are in solution in

the blood.

 

18)_____ At the normal pH of mammalian blood, most of the total carbon dioxide present is in the form of (a.

carbonic acid; b. bicarbonate ion; c. carbonate ion; d. a dissolved gas).

 

19)_____ Nearly 70% of the fat free vertebrate body is water. The smallest percentage of the water is found in the

(a. intracellular; b. interstitial; c. blood) compartment.

 

 

 

 

 

Name _________________________________________ 3

Oxygen-hemoglobin dissociation curves (a, b, & c) are graphed below. Fill in the blank with the letter

indicating the correct curve or with the correct value (2 points per blank)

20) If curve b is for the blood of a fetal

mammal, curve _____ is most likely for

the blood of the mother.

21) If curve b is for the blood of a rhinoceros,

curve _____ is most likely for the

myoglobin of its muscle.

22) If you increased the pH of a sample of

blood, curve b would shift towards

curve _____.

23) If the concentration of ATP in a blood

sample decreases, the oxygen

dissociation curve would be expected to

shift from the position of curve b

towards the position of curve _____.

24) The approximate P50 for curve c is _____

25) Suppose that you measure the oxygen

dissociation curves for a giraffe, a

gerbil and a gopher. Curve ____ is

most likely the curve for the giraffe.

26) If curve b was obtained for a blood sample tested at 30ĀŗC, curve _____ would be obtained when the blood

sample is tested at 15 ĀŗC.

27) If curve b is for blood leaving the muscle of a swimming fish, curve _____ would be the same blood after

leaving the gills.

28) If the blood sample shown by curve b was exposed to air with a high partial pressure of CO2, the curve would

be expected to shift toward the position of curve _____.

29) If curve b is for the blood of a deer, curve _____ is most likely for the blood of a seal of the same body mass.

 

The flow of blood through a portion of an unusual circulatory system is illustrated below. Fill in the blanks with the

number identifying the correct answer from the list below. The fluid has viscosity (i.e., it is not an ideal

fluid). (2 points per blank)

1. greater than 2. less than 3. equal to 30) The velocity at point B is _____ that at point C.

31) The pressure at point A is _____ that at point C.

32) In five minutes, the volume of water flowing past point A is ____ that at point B.

33) The tension in the wall at point B is ______ that at point D.

34) If the blood is stationary for a moment, the pressure at point C is ____ that at point D.

(You are viewing the vessels of the circulatory system from the side so point D is lower than point C.)

 

35) _____ Suppose that there is a mutation in mice that dramatically reduces surfactant secretion in the lungs. One

would predict that the muscular effort required to inflate the lungs during inhalation would (a. increase; b.

decrease; c. be unchanged) compared with a wild type mouse.

 

 

A B

C

D

% Sat

100

40 80

PO2 (mmHg)

a b c

 

 

Name _________________________________________ 4

36) _____ Suppose that you measured the breathing rate of a kangaroo (number of breaths per minute) while

hopping at sea level and while hopping at high altitude. If the stride frequency (number of hops per

minute) is identical at sea level and at altitude, you would predict that the breathing rate at altitude would

be (a. greater than; b. less than; c. equal to) that at sea level.

 

37) _____The lowest blood velocity in a mammalian circulatory system would be found in the (a. aorta; b.

capillaries; c. veins; d. vena cava.)

 

38) _____ The carbon dioxide content of air in the posterior air sacs of a bird is likely to be (a. greater than; b.

less than; c. equal to) that of the anterior air sacs.

 

39) _____ When compared at the same carbon dioxide tension, deoxygenated blood binds (a. more; b. less; c.

the same amount of) carbon dioxide compared with oxygenated blood.

 

40) _____ Suppose that you are a respiratory physiologist interested in the function of fish gills. You are also

unusually skilled in surgical techniques. You perform a series of experiments in which you swap the

arterial blood supply to, and venous return from, each gill arch so that blood flow through the gill lamellae

is reversed compared to the control fish. All other aspects of the experimental and control fish are

identical. You would predict that oxygen extraction in the experimental fish would be (a. greater than; b.

less than; c. equal to) that of the control fish.

 

41) _____ Suppose that you decide to repeat Scholander’s famous experiments on facilitated diffusion. If you

added gelatin to the hemoglobin solution you predict that the facilitation would (a. increase; b. decrease; c.

be unaffected).

 

42) _____ Gas exchange through the skin of most reptiles (a. is much greater than; b. is much less than; c. is

approximately equal to) gas exchange in the lungs.

 

43) _____ During the ā€œflutteringā€ phase of cyclical respiration in insects, the partial pressure of carbon dioxide in

the tracheal system (a. increases; b. decreases; c. remains relatively constant).

 

44) _____ When carbon dioxide dissolves in water, the formation of (a. carbonate ion; b. bicarbonate ion; c.

carbonic acid) is the rate-limiting step. This step is accelerated by the enzyme called

45) ____________________________________________.

 

Fill in the blank with the correct word or words (2 points per blank).

46) If a gill removes oxygen from completely still water, the immediately adjacent

___________________________________ of water will soon be depleted of oxygen. Renewal of this

water is therefore important in supplying oxygen.

47) The tubeworm, Riftia pachyptilia, is an important member of many deep sea rift communities. Although it

lacks a mouth and intestinal tract, it grows remarkably rapidly and to great size. A large organ called the

___________________________________ fills the greater part of the coelom and is packed with bacteria

which provide the tubeworm with energy obtained from the oxidation of hydrogen sulfide.

48) In birds, the finest branches of the respiratory system, known as ________________________________ permit

through passage of air and are the site of exchange of the respiratory gases with the blood.

49) In insects, the openings of the tracheal system to the outside are called

__________________________________ and are highly complex structures that can be opened or closed

to allow a variable amount of gas exchange.

50) The flow of a fluid such as blood, water or air is characterized by two radically different regimes. In

_______________________________ the fluid ā€œparticlesā€ move more or less parallel to one another in

paths that are smooth and regular. The large and small scale movements of the fluid in this regime are the

same.

 

Please print your name in the upper right corner of the back of this page.

Animal Physiology Questions

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"