AGR-AQUA50-07 · Lesson 3 · 60 clock hours · practice
Data Analysis, Report Writing, and Portfolio Assembly
Objective. Students analyze their collected data using appropriate descriptive statistics and graphing, write a complete technical report following the program style guide, and assemble a final project portfolio containing all documentation produced from proposal through fieldwork.
⚠ 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 This Lesson Matters
You have spent weeks designing your project, collecting field data, and maintaining your logbook. This final phase turns raw numbers into professional knowledge that employers, agencies, and dive contractors can actually use. A strong technical report and a complete portfolio are also the evidence that proves your competency for both PADI and ADCI credential evaluations. Accuracy, completeness, and professional presentation are not optional—they are the product.
Step 1: Entering and Checking Your Data
Before you calculate anything, transfer all raw field data from your signed data sheets into a spreadsheet exactly as recorded. Do not round at this stage. Create one row per observation and label every column with the variable name and unit (for example, "DO mg/L" or "Temp °C"). Save the original import as a protected sheet so you always have an untouched record.
Once data are entered, visually scan for outliers or obvious entry errors—a dissolved-oxygen reading of 450 mg/L, for instance, is a transcription mistake, not a discovery. Compare questionable values against your calibration logs and logbook notes before deciding whether to flag or exclude them. Any exclusion must be documented and explained in your methods section.
Step 2: Descriptive Statistics
For most aquaculture and marine science field projects, three statistics carry the analysis:
- Mean (average): Sum all values in a data set and divide by the count. The mean tells you the central tendency of a measurement over time or across sites.
- Range: Subtract the minimum value from the maximum value. Range reveals how much a parameter varied, which is often critical for water-quality compliance assessment.
- Percent change: ((Final value − Initial value) / Initial value) × 100. Use this when your objective involves tracking improvement or degradation over time, such as growth rate in a hatchery cohort or change in reef fish density.
Simple trend analysis—drawing a best-fit line on a scatter plot or noting whether values went up, down, or stayed stable across sampling dates—is appropriate when you have at least four or five time points. You are not expected to perform inferential statistics unless your instructor specifically requires it.
Step 3: Producing Publication-Quality Figures
Every figure must earn its place by directly answering one of your project objectives. Two figures are the minimum; more are acceptable if they add meaning. Requirements for every figure:
1. Both axes labeled with the variable name and unit in parentheses.
2. A figure number and a complete caption below the figure that explains what is shown and the key take-away.
3. Consistent font size, clean gridlines, and no unnecessary decorative elements (no 3-D bar charts, no background color fills).
4. Source data identified (your data, your dates, your site).
Submit your draft figure set to your instructor for review before you begin writing. Feedback at this stage prevents you from building your written results section around a figure that misrepresents your data.
Step 4: Writing the Technical Report—Section by Section
Follow the program style guide and work through sections in this order, submitting each as a draft and incorporating instructor comments before moving on:
- Abstract: Written last in practice but placed first. One paragraph (150–200 words) summarizing objective, methods, key results, and main conclusion.
- Introduction: Background context, why the project matters, and a clearly stated objective or research question.
- Methods: Enough detail that another technician could repeat your work. Include site description, equipment used with calibration references, sampling frequency, and any safety protocols observed (PPE worn, dive procedures followed, hazard controls in place).
- Results: Present your data objectively using your figures and statistics. No interpretation here—save that for Discussion.
- Discussion: Interpret your results in light of your objectives. Compare to published water-quality standards or reef health benchmarks from your course references. Acknowledge limitations honestly.
- Conclusions: Brief, direct statements of what you found and what you recommend.
- References: Cite every source used, formatted per the APA or industry citation guide specified by your program.
Step 5: Assembling the Portfolio
Your portfolio is a professional record of the entire project lifecycle. Organize items in this order with a table of contents:
1. Approved project proposal
2. All signed field data sheets
3. Calibration logs for every instrument used
4. Logbook (photocopied or printed pages covering all project dates)
5. Draft figures (both early and final versions)
6. PPE and safety documentation
7. Any dive records (ADCI-format dive logs, if applicable)
8. Final technical report
9. Self-audit checklist, signed and dated
10. Any supplementary material (permits, correspondence, photos)
Conduct your self-audit against the portfolio checklist before submission. Missing even one of the ten required document categories results in a portfolio that does not pass—just as a commercial dive operation cannot legally proceed with incomplete safety records.
Safety Documentation Note
Safety records are not bureaucratic paperwork—they are evidence that hazards were controlled. Your portfolio must include completed PPE sign-off sheets for any confined-space, boat-based, or in-water work. Dive records must show depth, bottom time, gas supply, and the name of your dive supervisor. If lockout/tagout procedures were applied during equipment maintenance at a facility, the completed LOTO log belongs here too. Incomplete safety documentation is a professional and legal liability, and it will prevent portfolio approval.
Scoring and Revision
Your technical report is graded on a 100-point rubric. A score of 75 or higher is required to pass. If you score below 75, you have one week to revise and resubmit. The portfolio is pass/fail: all ten document categories must be present. Build the portfolio incrementally throughout the project so nothing is missing at the end.
Key terms9
Descriptive statisticsNumerical summaries—such as mean, range, and percent change—that describe the basic features of a data set without making inferences about a broader population.
MeanThe arithmetic average of a data set, calculated by summing all values and dividing by the number of observations.
RangeThe difference between the maximum and minimum values in a data set, used to express how much a measured parameter varied.
Percent changeA calculation showing how much a value increased or decreased relative to its starting point: ((final − initial) / initial) × 100.
Figure captionA brief description placed below a graph or image that identifies what is shown, the data source, and the key finding; required on every publication-quality figure.
Calibration logA written record documenting when field instruments were calibrated, what standards were used, and the results, providing traceability and data integrity.
Technical reportA structured professional document presenting the objective, methods, results, and conclusions of a scientific or engineering project in a standardized format.
Portfolio self-auditA systematic review conducted by the student against a published checklist to verify that all required documents are present and complete before final submission.
Trend analysisAn examination of data collected over time to determine whether a measured variable is increasing, decreasing, or remaining stable across sampling periods.
Worked examples4
1. You measured dissolved oxygen (DO) at your study site on five sampling dates: 7.2, 6.8, 7.5, 6.5, and 7.0 mg/L. Calculate the mean and range.
- Sum all values: 7.2 + 6.8 + 7.5 + 6.5 + 7.0 = 35.0 mg/L
- Count the observations: n = 5
- Calculate the mean: 35.0 ÷ 5 = 7.0 mg/L
- Identify the maximum value: 7.5 mg/L
- Identify the minimum value: 6.5 mg/L
- Calculate the range: 7.5 − 6.5 = 1.0 mg/L
Answer: Mean DO = 7.0 mg/L; Range = 1.0 mg/L
2. At the start of your hatchery grow-out trial, average juvenile tilapia weight was 4.2 g. At the end of the 6-week trial, average weight was 18.9 g. Calculate the percent change in body weight.
- Identify initial value: 4.2 g
- Identify final value: 18.9 g
- Calculate the difference (final − initial): 18.9 − 4.2 = 14.7 g
- Divide the difference by the initial value: 14.7 ÷ 4.2 = 3.5
- Multiply by 100 to express as a percentage: 3.5 × 100 = 350%
Answer: Percent change in body weight = 350% (an increase of 350% from initial weight)
3. Your reef transect data show fish counts of 12, 15, 11, 18, and 14 individuals per 50 m² plot across five plots. Calculate the mean count and range, then state what you would report in the Results section.
- Sum all counts: 12 + 15 + 11 + 18 + 14 = 70 individuals
- Count the plots: n = 5
- Calculate the mean: 70 ÷ 5 = 14.0 individuals per 50 m²
- Identify maximum: 18; identify minimum: 11
- Calculate range: 18 − 11 = 7 individuals per 50 m²
- Draft Results statement: 'Mean fish density across the five transect plots was 14.0 individuals per 50 m² (range: 11–18 individuals per 50 m²).'
Answer: Mean = 14.0 individuals/50 m²; Range = 7 individuals/50 m². The Results section reports these values in a complete sentence without interpretation.
4. Your water temperature data over four weeks are: Week 1 = 22°C, Week 2 = 23°C, Week 3 = 24°C, Week 4 = 25°C. Calculate percent change from Week 1 to Week 4 and describe the trend.
- Identify initial value (Week 1): 22°C
- Identify final value (Week 4): 25°C
- Calculate difference: 25 − 22 = 3°C
- Divide by initial value: 3 ÷ 22 = 0.1364
- Multiply by 100: 0.1364 × 100 ≈ 13.6%
- Describe trend: Temperature increased by 1°C each week—a consistent upward linear trend over the four-week monitoring period.
Answer: Percent change = approximately 13.6% increase. Trend: steady linear increase of 1°C per week from Week 1 to Week 4.
The math in this lesson1
Learners compute mean and range of five DO readings and percent change in growth for the report.
S-ID.2
In class: Students enter all raw field data into a spreadsheet (Microsoft Excel or Google Sheets), calculate descriptive statistics (mean, range, and where appropriate, percent change or simple trend analysis), and produce at least two publication-quality figures (labeled axes, units, captions) that directly answer their project objectives; the instructor reviews a draft figure set before students proceed to writing. · Students write each section of the technical report in sequence—abstract, introduction, methods, results, discussion, conclusions, references—using the program style guide and an industry report checklist; each section is submitted as a draft, returned with instructor comments within 48 hours, and revised before the next section is begun, ensuring iterative improvement rather than a single last-minute submission. · Students organize their complete project portfolio in a professional binder or digital folder with a table of contents, including: approved proposal, all signed field data sheets, calibration logs, logbook (photocopied or printed), figure drafts, PPE and safety documentation, any dive records, and the final technical report; they conduct a self-audit against the portfolio checklist and certify completeness before submission.
Materials: Laptop with spreadsheet software and word processor, program style guide, industry technical report checklist, portfolio assembly checklist, graph paper as backup, scientific calculator, reference materials from courses 2–6 (water quality standards, hatchery SOP references, reef transect protocol guides), APA or industry citation guide as specified by program
Check: Technical report is scored on a 100-point rubric: completeness of all required sections (30 pts), accuracy and clarity of data presentation (25 pts), logical discussion tied to results (20 pts), correct citations and professional formatting (15 pts), grammar and clarity (10 pts). Passing score is 75/100. Portfolio completeness is assessed as pass/fail against the checklist—all 10 required document categories must be present to pass. Students below 75 on the report have one opportunity to revise within one week.
Practice check8
Answer each question, then check it. Nothing is recorded; this is your own practice.
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.