MIME-Version: 1.0 Content-Location: file:///C:/AACBA310/FishFarmWriteup.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Create Figures for the Fish Farm Report Using Excel

I.  Running Your Fish Farm Experiments= . 

 

A.  Practice With<= /span> Catfish: Your goal is to make to $250,000 per run. 

 

1.  Left = Click on the Fish Farm “FISH.EXE” file.=   Press the space bar.  A= djust the speed to slow by holding down the “S” key.  Once the speed is adjusted, press escape. 

2.  At th= e fish selection screen, press the space bar for Catfish.  Follow the instructions on the scr= een to accept the catfish.

3.  Select “Use outdoor ponds?” at the experiment selection screen by pres= sing the “2” key. 

4.  At th= e pond menu you will need to select the culturing conditions for your fish.  Type the following letters, then follow the screen instructions to set your culture conditions. 

 

   &nbs= p;            a.  Stocking density: Set the number of fish per hectare to between 1,000 and 500,000.  More fish       could mean higher profits, but too many fish might use up all available resources, pollute the   pond, spread disease, or cause fighting. 

   &nbs= p;            b.  Feeding instructions:  Set the percent= age of protein between 10 and 80.  Se= t the feed rate at      =     varying rate.  Some fish need high pro= tein levels to grow and be healthy.  The higher the              =           percentage protein the more expensive the feed will be.  If the protein level is too high, ammonium      &nbs= p;          waste can accumulate in the pond.  

   &nbs= p;            c.  Add a= ntibiotics:  You can skip this step if you don’t want to add antibiotics.  This can stop    &nbs= p;     bacterial disease, but makes feed much more expensive. 

   &nbs= p;            d.  Add groundwater:  You can skip thi= s step if you don’t want to add ground water.  You can add   between 0% and 190% ground water.  Ground water is added to decrease = the pond water      &n= bsp;   temperature.  Water from underground wells will = be much colder than pond water in the  &n= bsp;        summertime. 

   &nbs= p;            e.  Emergency aeration:  Set this dissolved = oxygen to 8 mg/l or lower.  You will = want to aerate the      water by turning on paddle wheels to splash the water when the oxygen level gets = too low.  If you    set it too high you spend too much money, too low and all your fish could die. 

f.  Time of harvest:  Leave this set at “end of season”.   After th= ey reach marketable weight, some fish continue to grow at a fast rate but othe= rs do not. 

 

5.  Once = you have set all of your culturing conditions, press the “escape” key immediately followed by the “P” key. 

6.  View = your data and record your profits.  Discard your data.   Return to the main menu and do another po= nd experiment.  Change some of the culture conditions and run another experiment.  Continue running experiments in an attempt to achieve profits of $250,000 or more for a run.  You will be given about five to 10 minutes. 

 

B.  Recording Data for the Fish Farm Report. 

 

Next, your instructor will give you a fish with which = you will do five experiments.  For= each of these experiments you will record raw data.  The data sheets should contain all= of the information that you need to exactly repeat the experiment and all the = data you need to create a figure or a data table.  At the top of each data sheet you = should clearly write what the experiment is about (Example Data Table).  Each data sheet must describe all controlled variables (like the fish used, percentage of protein in the feed, emergency aeration level, stocking density, etc.). 

 

C.  The Tank Experiments.

 

  Prior to setting up large experiments outside in ponds, some preliminary experiments need to be done to determine basic culture requirements for your fish.  These experiments will be done ind= oors in aquarium tanks each containing 10 fish.=   When doing these experiments make sure you select independent variab= le treatment levels at even numerical increments for ease of graphing.  You will only be doing one replica= tion of each of the tank experiments. &nbs= p;

 

1.  The Temperature Experiment.  The g= oal of the experiment is to determine whether your fish can survive temperature between 25o and 30oC.  If your fish can tolerate these hi= gh temperatures you will not need to add groundwater.  Groundwater is expensive to add an= d you will only use it if necessary.  You will want to collect cost and weight data (Table 1) so you can make a figure (Figure 1).  

 

a.  You start the program as described above, but when you get to the fish selection screen you should p= ress the letter key that corresponds to the fish your professor has assigned to you. 

b.  Select “Tank experiments?” at the experiment selection screen by pressing the “1” key.   Pr= ess the A key to select the temperature experiment. 

c.  Set the oxygen at 10 mg/l a= nd the food to 50% protein with a 10 % constant rate of biomass per day. 

d.  Select a temperature and pr= ess the “escape” key to run the experiment.  You will want to repeat this proce= dure several times with different temperatures, so you can get the answer to the experimental goal, and get enough data points to make an interesting figure (Figure 1). 

 

2.  The O= xygen Experiment.  The goal of the experiment is to determine the lowest dissolved oxygen level at which your = fish can survive.  You will need to aerate the ponds to prevent the dissolved oxygen from getting so low that y= our fish start to die.  It is expe= nsive to aerate the ponds so you should only turn them on when it is necessary.  You will collect cost and weight d= ata (Table 1), so you can make a figure (Figure 1).  

 

a.  You start the program as de= scribe above, selecting the fish your professor has assigned to you, and selecting another tank experiment. 

b.  Set the temperature to the = one that your fish did best at in the previous experiment or just set it at 20<= sup>o C.   Set the food to 50% protein with a 10 % constant rate of biomass per day. 

c.  Set the dissolved oxygen to= 10 mg/l and press the “escape key” to run the experiment.  You will want to repeat this proce= dure several times, each time lowering the dissolved oxygen level.  Make sure your data can answer to = the experimental goal and can be used to make an interesting figure (Figure 1). 

 

3.  The F= eed Experiment.  The goal of the experiment is to determine the percentage of protein in the feed that produ= ces good profit at the lowest cost.  Protein is one of the most expensive components in a feed mix.  You must make sure that increasing percent protein is accompanied by increase profits for your fish.  You will collect cost and weight d= ata (Table 1), so you can make a figure (Figure 1).  

 

a.  You start the program as de= scribe above, selecting the fish your professor has assigned to you, and selecting another tank experiment. 

b.  Set the temperature to the = one that your fish did best at in the previous experiment or just set it at 20<= sup>o C.   Set the oxygen at 10 mg/l.  

c.  Select protein percentages = in a range from five to 80 percent.  Make sure your data can answer to the experimental goal.  To meet your goal, a plot of your = cost data should curve up at both ends and a plot of your weight gain data should curve down on both ends (Figure 1). 

 

D.  The pond experiments.  &n= bsp;       

 

1.  The S= tocking Density Experiment: 

 

   &nbs= p;            a.  Select the fish your professor assigned  = to you and start an outdoor pond experiment.  The      &n= bsp;   culturing conditions you select will depend on the results from the three tank experi= ment you did       = ;      with your fish

         &= nbsp;      b.  Feeding instructions:  Determine the p= ercent protein from your tank feeding experiment that             = ;            = produced good weight gain at the lowest cost, and use this percent protein a variable rate for your      = ;     pond experiments. 

   &nbs= p;            c.  Add antibiotics:  Skip antibiotics= for now.  You may want to try them latter in your production    = ; runs if disease seems to be a problem. 

   &nbs= p;            d. Add groundwater:  If your fish= were dieing at 25o to 30o C in the temperature tank experiments,      you will need to add 190% ground water.  If your fish were able to survive these temperatures, you         &= nbsp;       should not add ground water. 

   &nbs= p;            e. Emergency aeration:  Set this dissolved oxygen lowest level that did not kill fish during your         oxygen tank experiment    &nbs= p;

   &nbs= p;            f. Time of harvest:  Leave this <= span class=3DGramE>set  at &= #8220;end of season” to start with.  Once you find a good stocking density to test, you should run a experiment and plot th= e data as the program is running by   &n= bsp;   pressing “escape” immediately followed by “P”.  If profits continue to increase af= ter the end of the     &nbs= p;         season, you should harvest at the end of the season.  If profits drop off at the end, ha= rvest at       &nbs= p;         marketable weight.  

   &nbs= p;            g. You need to test a number of stocking densities between 1,000 and 500,000 f= ish per hectare.          Once you determine the range of stocking densities that your fish will make a profit, you should     =         determine what stocking densities you are going test.  You need to select nine or 10 diff= erent   stocking densities that are set at = equal numerical increments from each other.  These selected    &nb= sp;      stocking densities need to cover a range of densities above and below the stocking density which   make maximum pr= ofits for your fish.  Run the experi= ment ten times at each stocking density so  = ;        your experiment is replicated ten times.   

 

2.  The Production Runs. 

 

Select your stocking densit= y which produced the best average profits and perform five more runs with all the s= ame constant variables.  You want = to record all of the data that the program gives you for the production runs so that it can all be used to make Table 1 in your paper.  If during the course of your exper= iments you noticed deaths due to disease, fighting, or ammonia poisoning, you may = want to change one of your constant variables in one or two of your production runs.  Addition of antibiotics, ground water, or reduction of stocking density may be tried here.  

 

II.  Create Figures for the Fish= Farm Report Using Excel

 

A.  Figures one, two, and three

 

1.  Make = a data table in Excel with the first column containing the independent variable (t= emperature for Figure 1) and the second and third columns contain the dependent variab= les (weight in grams and cost in $). 

2.  Highl= ight the dependent variables with their headings, then le= ft click on the chart wizard icon.  Select the line chart and left click “next”. 

3.  Left = click on the “series button” and the click on the  “category (X) axis icon”.   Know you s= hould high light the independent variable column numbers from you data table and press the enter key. 

4.  Click= on the next button and type your title (Figure 1. Growth and …) and the label the X axis (Temperature o<= /sup>C).  Click next and finish. 

5.  Right= click on title, axis descriptions and legends.&n= bsp; Each time you do this, left click on the font button and change the = font to 8.  

6.  To ma= ke an “o” a superscript highlight the “o”, select format chart, and click the superscript square.   You can use the same procedu= re to subscript the “2” in O2 .=

 

B. Figure 4. 

 

1.  Set u= p a data table where the first column contains the stocking density, the second colu= mn contains the lowest profit for one replication at that stocking density, the third column contains the difference between the average of 10 replications= and the lowest profits at that stocking density, and the last column contains t= he difference between the highest and average profits at that stocking density.  Use headings lowest, average, and highest at the top of the second, third, and fourth columns respectively. 

2.  Left = click on the Chart Wizard Button.  Sele= ct a stacked column chart and click next.  Do not select the 100% stacked column chart. 

3.  Selec= t series in columns and click “next”.&n= bsp; Type in the appropriate title and X-axis descrip= tion.  Left click on “next” a= nd “finish”. 

4.  Chang= e the text sizes as described above. 

5.  Left = click on “Tools” at the top of the screen.  Click on customize and left click = in the box  indic= ating the drawing  option, leaving a= check in this box.    This= will bring up the “Draw ” option bar.  Left click on the text box, then c= lick and drag the cursor in your chart to create a text box of the appropriate s= ize to indicate your data represents averages of 10 replications.  

 

III.  Writing the Fish Farm Repor= t

 

Your Fish Farm Report should start with a grading shee= t and then a cover sheet.  Next you = should include the raw data from all of you experiments.  Then you should include a figure or table for each of the five experiments you conducted.  Finally you will include the six paragraphs that explain your experiments.&= nbsp;

 

You will write a paragraph for each of the three tank experiments and the stocking density experiment.  Each of these paragraphs should in= clude a sentence that addresses each of the following: 

   &nbs= p;            1. Explain what information you expect to get from this experiment and why thi= s is important. 

   &nbs= p;            2.  Describe how you did the experimen= t.

   &nbs= p;            3.  Summarize the results of the experiment. 

   &nbs= p;            4.  Explain how you are going to use t= he results of this experiment.  &nb= sp;

   &nbs= p;            5.  Compare or contrast your results t= o the description of your fish. 

 

You will write a paragraph describing the results of t= he production runs.  This paragra= ph can describe profits, percent death, food conversion ratio, and weight of fish = sent to market.  Finally you will w= rite a conclusion paragraph.  This paragraph should summarize the conclusions from your tank experiments and t= he stocking density experiment, and explain what profits you can expect using the cultu= re conditions you determined were optimum for your fish.  If there are any weaknesses in your experiments you may want to explain them here and suggest additional experimentation prior to using this fish commercially. 

 

Example Paragraphs:&n= bsp;

 

Dissolved Oxygen Experiment 

 

Proper dissolved oxygen levels in pond water are essen= tial for the fish survival.  Howeve= r, aeration of pond water can be very expensive and should only be used when oxygen levels reach critically low levels.=   Catfish were cultured 10 fish per tank, at 25 <= sup>oC, with 50% percent protein feed, and at one mg/l intervals of dissolved oxygen ranging from one mg/l to 7 mg/l (Figure 2).  Fish gained weight at low cost fro= m four to five mg/l of dissolved oxygen, but fish deaths were recorded at dissolved oxygen levels of 3 mg/l and lower.  Emergency aeration of pond water should occur when dissolved oxygen levels reach 4 mg/l. 

 

Stocking Density Experiment

 

To optimize fish farming profits it is essential to determine the maximum number of fish that can be raised per hectare to marketable weight while keeping disease, fighting, and nitrogen wastes in p= ond to low levels.  Stocking densi= ties from 1,000 to 11,000 fish per hectare were tested in static pond with 30% protein feed, on ground water, and emergency aeration at 4 mg/l O2.  All stocking densities tested prod= uced profits, but the highest average profits were recorded for using 7,000 and 8,000 fish per hectare.   Eight thousand fish per hectare produce more consistent results than 7,000, so 8,= 000 fish per hectare was chosen the production runs.  

 

 

 

 

 

 

 

 

Fish Farm Grading Sheet   &nb= sp;            =             &nb= sp;      Group Members

 

   <= span style=3D'mso-tab-count:5'>        &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;                    =             &nb= sp;            =                  &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;          &= nbsp;            

        =         

   &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;                   =             &nb= sp;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;          

       =

   &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;                   =             &nb= sp;            &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;          

        =         

Cover Page = (2 points)                   &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;             =          =             =

        &= nbsp;           &nbs= p;            &= nbsp;            =     

Raw Data

 <= /o:p>

        &= nbsp; Completeness (18 points)            =             &nb= sp;            =                    =          =             =

   &nbs= p;             All data presented in the figures, = tables and paper are found in the raw data pages.

        &= nbsp; Clear Association of Data with the Methods (10 points)        =              =             =

   &nbs= p;            All experimental variables (dependent, independent, and controlled)

   &nbs= p;             are clea= rly noted. 

        &= nbsp; Bonus (5 points)     &n= bsp;       =             &nb= sp;            =             &nb= sp;                  =          =             =

   &nbs= p;            Data pages contain appropriate questions, observations,

   &nbs= p;            conclusions, and background information. 

 

Results Section 

 

        &= nbsp; Three tank Experiment Figures (15 points)               &= nbsp;                =          =             =

 

        &= nbsp; The Stocking Density Experiment Figure (10 points)                 =          =             =

 

        &= nbsp; The Production Run Table&n= bsp; (5 points)   =         =             &nb= sp;              =          =             =

 

Discussio= n and Conclusions

 

   &nbs= p;            Content (25 points)                =             &nb= sp;            =                =           =          =            &= nbsp;         A paragraph should be written that explains each experiment. 

   &nbs= p;            Three tank experiments, the stocking density experiment, and the production runs. 

        &= nbsp; Presentation (10 points)               =             &nb= sp;            =                    =          =             =

   &nbs= p;            The paper should be neatly typed, should not exceed the two page limit, should =

        =        be written clearly and concisely, and is = free form spelling and grammar errors. 

        &= nbsp; Conclusions (5 points)               =             &nb= sp;            =             <= span style=3D'mso-spacerun:yes'>        =          =             =

 

        &= nbsp; Bonus  (5 points)           &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;                =          =             =

   &nbs= p;            Relevant literature is properly cited in the text and referenced properly in a refer= ence

        =       section at the end of the paper. 

 

Total     &nb= sp;            =             &nb= sp;            =             &nb= sp;            =             &nb= sp;                        =            &= nbsp;