🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Agriculture, Environment & Public Service › Aquaculture & Marine Science Tech › Fish and Shellfish Culture › Lesson 11
AGR-AQUA50-02 · Lesson 11 · 18 clock hours · practice

Production Record-Keeping and Data Analysis

Objective. Students will maintain a complete 10-day production log using both paper and digital formats, then use the data to identify a trend and write a concise management memo.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a licensed professional in the field or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

Why Production Records Matter

In commercial aquaculture, decisions about feeding rates, stocking density, and harvest timing are only as good as the data behind them. A facility that relies on memory or informal notes will miss early warning signs — a gradual rise in daily mortality, a feed conversion ratio (FCR) creeping upward, or a dissolved oxygen level that dips on the same day each week. Systematic record-keeping transforms daily observations into a body of evidence that managers can act on. It also satisfies regulatory requirements, supports biosecurity audits, and provides the paper trail that fish health professionals need if a disease event occurs.

As an aquaculture technician, maintaining accurate logs is a core professional responsibility, not a clerical task.

The Standard Production Log

A production log captures the state of each tank or pond unit on a given day. At minimum, each daily entry should include:

Leave no field blank. If a reading was not taken, write the reason (e.g., "probe malfunction — replacement ordered"). An unexplained blank is indistinguishable from data that was simply forgotten.

Paper Log and Digital Spreadsheet — Using Both

Most production facilities use a dual system. The paper log is filled out at the tank side, where spills, wet hands, and time pressure make simplicity essential. The digital spreadsheet is updated at the end of each shift from the paper log. The spreadsheet enables sorting, graphing, and formula-based calculations that paper cannot.

When entering data into the spreadsheet, transfer every value exactly as written on the paper log. If you notice a discrepancy while entering data — for example, a DO reading that is implausibly low — flag it with a note in the spreadsheet and initial the paper log. Do not silently correct data; always document the reason for any change.

Keep paper logs in a dedicated binder organized by date. Back up digital files at least daily, either to a shared network drive or a cloud service.

Feed Conversion Ratio (FCR)

FCR is the most widely used efficiency metric in fish culture. It tells you how many kilograms of feed were required to produce one kilogram of fish biomass.

FCR = Total feed fed (kg) ÷ Biomass gained (kg)

A lower FCR is better. A species-typical FCR for Atlantic salmon in intensive recirculating systems is roughly 1.1–1.3; for tilapia it is often 1.5–2.0. These benchmarks vary by species, life stage, feed quality, and management. Tracking FCR over time lets you detect feeding inefficiency before it becomes costly.

Mortality Rate

Daily mortality rate expresses the number of deaths as a percentage of the population at risk.

Daily mortality rate (%) = (Mortalities that day ÷ Estimated population) × 100

A sudden spike or a slow upward trend both warrant investigation. When graphed over ten days, even a modest trend is visible in a way it is not when reading raw numbers day by day.

Creating and Interpreting a Trend Graph

Select a single variable — FCR or daily mortality rate — and plot it on the y-axis against day number on the x-axis. Label both axes with units. Give the graph a descriptive title (e.g., "Tank 4 — Daily Mortality Rate, Days 1–10"). Add a simple trend line if your spreadsheet software supports it.

When interpreting the graph, address three things: (1) What is the overall direction of the trend? (2) Are there any obvious outliers or step changes, and what might explain them? (3) What does the trend suggest about current management?

Writing the Management Memo

A management memo is a brief, professional document that moves from observation to recommendation. Use this structure:

1. To / From / Date / Subject header

2. Background — one or two sentences on the data set (tank ID, dates, species)

3. Findings — describe the trend you observed and cite at least one specific data point

4. Recommendation — one clear, actionable change (e.g., reduce feeding rate by 10%, increase water-exchange frequency) with a data-based reason

5. Follow-up — how and when the effect of the change will be measured

Keep the memo to one page. Avoid vague language such as "fish seem stressed." Write instead: "Daily mortality rate rose from 0.1% on Day 1 to 0.6% on Day 9, suggesting a deteriorating condition that warrants investigation."

Safety Notes

Wet floors around tanks are a persistent slip hazard; wear non-slip boots whenever you are on the production floor. When handling dead animals for mortality counts, wear waterproof gloves and dispose of mortalities according to your facility's biosecurity protocol. If you handle water-quality reagents or probes that require calibration chemicals, consult the Safety Data Sheet (SDS) for each chemical and wear appropriate PPE — at minimum, chemical-splash goggles and nitrile gloves. Never lean over a tank unassisted when recording readings from probes at depth.

Key terms8

Feed Conversion Ratio (FCR)The weight of feed consumed divided by the weight of biomass gained over the same period; a lower value indicates more efficient feed use.
Daily mortality rateThe number of animals that died on a given day expressed as a percentage of the estimated population in that unit.
Production logA standardized record capturing daily data for each tank or pond unit, including feeding, mortality, water quality, and observations.
Biosecurity protocolA set of procedures designed to prevent the introduction and spread of pathogens within an aquaculture facility, including rules for handling and disposing of mortalities.
Trend lineA line added to a graph that summarizes the overall direction of a data set over time, making gradual changes easier to detect.
Management memoA short professional document that presents a data-based finding and recommends a specific operational change to a supervisor or facility manager.
Dissolved oxygen (DO)The concentration of oxygen gas dissolved in water, typically measured in mg/L or percent saturation; a critical water-quality parameter for aquatic animal health.
Total ammonia nitrogen (TAN)The combined concentration of ionized and un-ionized ammonia in water; a key indicator of nitrogen loading and water quality in recirculating systems.

Worked examples4

1. Tank 7 held an estimated 2,000 tilapia. Over 10 days, a total of 48 kg of feed was delivered. A sample weight at the start of the period gave a mean fish weight of 85 g; at the end of the period the mean weight was 102 g. Calculate the FCR for the 10-day period.
  1. Step 1 — Calculate starting biomass: 2,000 fish × 0.085 kg/fish = 170 kg.
  2. Step 2 — Calculate ending biomass: 2,000 fish × 0.102 kg/fish = 204 kg. (For simplicity, assume mortality was negligible and population count stayed at 2,000.)
  3. Step 3 — Calculate biomass gained: 204 kg − 170 kg = 34 kg.
  4. Step 4 — Apply the FCR formula: FCR = 48 kg feed ÷ 34 kg gained = 1.41 (rounded to two decimal places).
Answer: FCR = 1.41, meaning 1.41 kg of feed was used for every 1 kg of growth over the 10-day period.
2. On Day 6, Tank 3 had an estimated population of 1,500 shrimp and 9 mortalities were counted at the morning check. What was the daily mortality rate for Day 6?
  1. Step 1 — Identify values: mortalities = 9; estimated population = 1,500.
  2. Step 2 — Apply the formula: Daily mortality rate = (9 ÷ 1,500) × 100.
  3. Step 3 — Calculate: 9 ÷ 1,500 = 0.006; 0.006 × 100 = 0.6%.
Answer: The daily mortality rate on Day 6 was 0.6%.
3. A student's spreadsheet shows the following daily mortality rates for Tank 5 over five days: Day 1 = 0.1%, Day 2 = 0.2%, Day 3 = 0.2%, Day 4 = 0.4%, Day 5 = 0.5%. What is the average daily mortality rate over the five days, and what trend should the student report in the management memo?
  1. Step 1 — Sum the daily rates: 0.1 + 0.2 + 0.2 + 0.4 + 0.5 = 1.4%.
  2. Step 2 — Divide by the number of days: 1.4% ÷ 5 = 0.28% per day on average.
  3. Step 3 — Describe the trend: the rate started at 0.1% and increased to 0.5% by Day 5, representing a five-fold increase over five days, indicating a worsening condition that requires investigation.
Answer: Average daily mortality rate = 0.28%. The trend is a consistent upward increase that the memo should describe as a potential health or water-quality concern requiring prompt review.
4. A technician fed Tank 2 the following amounts over three days: Day 1 = 1.2 kg, Day 2 = 1.2 kg, Day 3 = 1.4 kg. Total biomass gained over the three days was 2.5 kg. What is the three-day FCR?
  1. Step 1 — Sum total feed: 1.2 + 1.2 + 1.4 = 3.8 kg.
  2. Step 2 — Apply the FCR formula: FCR = 3.8 kg ÷ 2.5 kg.
  3. Step 3 — Calculate: 3.8 ÷ 2.5 = 1.52.
Answer: Three-day FCR = 1.52.

The math in this lesson2

Learners compute start and end biomass and FCR as feed ÷ biomass gained over 10 days.
A-SSE.1S-ID.2
Brush up in the math halls at newSchoolWorks.com:
In class: Instructor demonstrates the facility's paper log format (date, tank ID, feeding amount, mortality count, water-quality readings, observations) and the corresponding digital spreadsheet; students enter three days of provided historical data as a formatting exercise. · Over the following lab sessions, students record their own tank group's daily production data (feeding, mortality, growth checks) in both paper log and spreadsheet for 10 cumulative days, with instructor spot-checks. · Data-analysis exercise: students use their completed spreadsheet to create one graph (FCR trend or mortality rate trend over time), interpret the graph in two to three sentences, and write a one-page management memo recommending a feeding or stocking adjustment with data-based justification.
Materials: Paper log templates, spreadsheet template (Excel or Google Sheets), laptop or tablet, calculator, printer for memo submission.
Check: Lab log (paper and digital) reviewed for completeness and accuracy on all 10 days; graph is correctly labeled and interpreted; memo recommendation is data-justified; pass = log 90% complete with no unexplained blank days, graph correctly labeled, memo contains at least one specific data reference.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

Aquaculture production management
1. Which formula correctly calculates feed conversion ratio (FCR)?
Record-keeping and data integrity
2. A technician notices several blank fields in the previous shift's paper log with no explanation. What is the correct action?
Aquaculture production monitoring
3. A tank holds 800 fish. On a given day, 4 mortalities are counted. What is the daily mortality rate?
Data analysis and graphing
4. When graphing a mortality-rate trend over 10 days, what should appear on the x-axis?
Feed management calculations
5. Over 10 days, a tank received 22 kg of feed and fish in the tank gained 14 kg of biomass. What is the FCR for this period?
Record-keeping systems
6. What is the primary reason a facility uses both a paper log and a digital spreadsheet rather than one or the other alone?
Professional communication and data-based decision making
7. A student's management memo states: 'Feed efficiency seems to be getting worse.' Which revision best meets professional memo standards?
Workplace health and safety
8. Which personal protective equipment (PPE) is most important when handling dead fish during a mortality count in a recirculating aquaculture system?
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.