🚧 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 › Manufacturing & Marine › Fiberglass / Composites (boatbuilding) › Universal Core: Safety, Math, Communication & Career — Fiberglass & Composites Boatbuilding › Lesson 6
MFG-COMP18-01 · Lesson 6 · 14 clock hours · practice

Digital Tools for the Composites Shop and Job Search

Objective. Students will use spreadsheet software to build a resin mix-ratio tracking log and use professional digital communication and job-search platforms to locate and respond to a real entry-level marine composites job posting.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a licensed engineer or certified journey-level tradesperson 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 Digital Tools Matter in the Composites Shop

Modern boatbuilding is not just resin and fiberglass — it is also data. Shops track every batch of resin mixed, every material order placed, and every quality check performed. Employers hiring composites technicians increasingly expect workers who can maintain digital records, communicate professionally by email, and use online platforms to grow their careers. The ABYC Composite Boat Builder credential and the ACMA Certified Composites Technician (CCT) both reflect an industry that values accuracy and professionalism, and digital literacy supports both.

Spreadsheet Basics for Resin Tracking

A resin-tracking log is one of the most practical spreadsheets you will build in this trade. Every time you mix a batch, small errors in catalyst ratio can cause incomplete cure, soft spots, or exothermic runaway — all safety hazards. A well-designed spreadsheet catches those errors before the resin goes into the part.

Key columns your log must include:

Calculating target catalyst weight: Multiply the target resin weight by the catalyst percentage expressed as a decimal. For example, if target resin weight is 500 g and the catalyst percentage is 1.5%, the target catalyst weight is 500 × 0.015 = 7.5 g.

Calculating percent error: Percent error tells you how far off your actual measurement is from your target.

> Percent error = ((Actual − Target) / Target) × 100

A typical shop tolerance for catalyst addition is ±5% (always confirm with your resin manufacturer's TDS). In your spreadsheet, use conditional formatting to highlight any cell where the absolute value of percent error exceeds the tolerance — for example, turn the cell red. This gives a technician or inspector an instant visual flag without having to read every number.

Spreadsheet safety tip: Never guess at a catalyst ratio from memory. Always reference the TDS for each specific resin system. Incorrect catalyst ratios are a recognized fire, heat, and health hazard — styrene-based resins can release toxic vapors during an exothermic event. Maintain proper ventilation and PPE (nitrile gloves, safety glasses, and appropriate respirator) whenever mixing, but a correctly tracked batch is your first line of defense.

Professional Email Communication

Email is the primary written communication tool in most marine manufacturing workplaces. A poorly written email reflects on your professionalism, even if your shop work is excellent. Every professional email has three parts:

1. Greeting: Address the recipient by name and correct title. "Dear Ms. Rivera," or "Good morning, Mr. Chen," are appropriate. "Hey" or no greeting at all are not.

2. Body: State your purpose in the first sentence. Keep paragraphs short. Include all necessary details — quantities, part numbers, dates — so the reader does not have to follow up with questions. End with a clear request or next step.

3. Sign-off and signature: Use a professional closing such as "Thank you," "Best regards," or "Sincerely," followed by your full name. Add your phone number and program or job title in a signature block.

When responding to an interview invitation, confirm the date, time, and location, express genuine interest in the position, and thank the employer for the opportunity. Proofread every email before sending — spell-check does not catch the wrong word used correctly ("their" vs. "there").

Using Job Boards and Industry Career Resources

Finding entry-level work in marine composites requires knowing where to look. General job boards such as Indeed, LinkedIn, and Glassdoor list boatbuilding and composites fabrication roles. Industry-specific resources include:

When you find a job posting, read the requirements carefully. Note which credentials are listed as required versus preferred. Map each posting to the credential most relevant to its duties. A marine-focused role may list ABYC certification; a broader composites fabrication role may reference ACMA CCT. Some postings reference neither by name but describe tasks — lamination, vacuum bagging, surface finishing — that both credentials cover. That analysis is the skill employers want: the ability to read a specification and match it to your qualifications.

Connecting Digital Skills to Your Career

Every spreadsheet you build, every email you send, and every job posting you analyze is a professional artifact. Organized resin logs demonstrate quality consciousness to inspectors and employers. Professional emails build your reputation before you walk in the door. A completed job-comparison table shows you understand the marketplace. These habits, practiced now, become second nature on the shop floor and in every interview you sit.

Key terms9

Catalyst percentageThe ratio of catalyst (hardener or MEKP) to resin, expressed as a percentage by weight, specified by the resin manufacturer's technical data sheet; incorrect ratios are a safety and quality hazard.
Percent errorA calculation showing how far an actual measured value deviates from the target value, expressed as a percentage: ((Actual − Target) / Target) × 100.
Conditional formattingA spreadsheet feature that automatically changes cell color, font, or style when a value meets a defined condition, such as turning a cell red when percent error exceeds the allowable tolerance.
Technical data sheet (TDS)A manufacturer-issued document specifying the correct mixing ratios, pot life, cure schedule, and handling requirements for a specific resin system; the authoritative source for mix ratios.
ToleranceThe acceptable range of variation from a target value; in resin mixing, tolerance defines how much error in catalyst addition is acceptable before the batch is considered out of specification.
Exothermic reactionA chemical reaction that releases heat; in resin systems, excessive catalyst or large batch volume can cause runaway exothermic reactions, creating fire risk and releasing toxic vapors.
ABYC Composite Boat BuilderA portable industry credential issued by the American Boat & Yacht Council recognizing competence in composite boatbuilding to ABYC standards; recognized by marine employers nationwide.
ACMA CCTCertified Composites Technician credential issued by the American Composites Manufacturers Association; recognized across marine, aerospace, automotive, and wind energy industries.
Professional signature blockThe standardized closing section of a professional email that includes the sender's full name, title or program, and contact information so the recipient can easily follow up.

Worked examples4

1. A technician targets 400 g of polyester resin with a catalyst percentage of 1.25%. What is the target catalyst weight? The technician actually scales out 4.8 g of catalyst. What is the percent error, and does it fall within a ±5% tolerance?
  1. Step 1 — Calculate target catalyst weight: Target catalyst = Target resin weight × (Catalyst % ÷ 100) = 400 g × 0.0125 = 5.0 g
  2. Step 2 — Calculate percent error: Percent error = ((Actual − Target) / Target) × 100 = ((4.8 − 5.0) / 5.0) × 100 = (−0.2 / 5.0) × 100 = −4.0%
  3. Step 3 — Compare to tolerance: The absolute value of −4.0% is 4.0%, which is less than the 5.0% tolerance limit, so this batch is within tolerance.
Answer: Target catalyst weight = 5.0 g; percent error = −4.0%; the batch passes the ±5% tolerance check.
2. A technician targets 250 g of vinyl ester resin with a 1.5% catalyst percentage. The actual catalyst weighed out is 4.1 g. Calculate percent error and determine whether the spreadsheet should flag this batch.
  1. Step 1 — Calculate target catalyst weight: 250 g × 0.015 = 3.75 g
  2. Step 2 — Calculate percent error: ((4.1 − 3.75) / 3.75) × 100 = (0.35 / 3.75) × 100 = 9.33%
  3. Step 3 — Compare to ±5% tolerance: 9.33% exceeds 5.0%, so the batch is out of tolerance.
  4. Step 4 — Spreadsheet action: Conditional formatting should flag this cell (e.g., turn it red) because the absolute percent error value is greater than 5.
Answer: Target catalyst = 3.75 g; percent error = +9.33%; this batch is out of tolerance and should be flagged by conditional formatting.
3. Write the correct spreadsheet formula for a percent error cell in Google Sheets or Excel, where cell D2 contains actual catalyst weight and cell C2 contains target catalyst weight. The result should appear as a percentage.
  1. Step 1 — Identify the percent error formula: Percent error = ((Actual − Target) / Target) × 100. In spreadsheet terms: ((D2 − C2) / C2) × 100.
  2. Step 2 — Write the formula: =((D2-C2)/C2)*100
  3. Step 3 — Format the cell: You can format the result cell as a number with two decimal places, or multiply by 100 and label the column '% Error'. Alternatively, use =((D2-C2)/C2) and format the cell as Percentage in the cell format menu.
  4. Step 4 — Write the conditional formatting rule: Apply a red fill when the formula =ABS(E2)>5 is TRUE, where E2 is the percent error cell.
Answer: Formula: =((D2-C2)/C2)*100 — Conditional formatting rule triggers red fill when ABS(percent error cell) > 5.
4. A job posting lists the following requirements: laminating experience, knowledge of wet layup and vacuum infusion, and states 'ABYC certification preferred.' A second posting lists: composite fabrication in wind or marine, and 'ACMA CCT or equivalent preferred.' A student holds both the ABYC Composite Boat Builder and the ACMA CCT credentials. For each posting, which credential is the primary match?
  1. Step 1 — Read posting 1: It mentions ABYC certification specifically in a marine context. The ABYC Composite Boat Builder credential directly matches ABYC marine standards.
  2. Step 2 — Read posting 2: It mentions ACMA CCT explicitly and spans wind and marine industries. The ACMA CCT is the direct match.
  3. Step 3 — Note dual advantage: A candidate holding both credentials is competitive for both postings and should highlight the relevant credential first in each application.
Answer: Posting 1 primary match: ABYC Composite Boat Builder. Posting 2 primary match: ACMA CCT. Holding both credentials strengthens candidacy for either role.

The math in this lesson2

Learners compute target catalyst weight at 1.25 and 1.5 percent and percent error of weighed amounts.
7.RP.3A-SSE.1
Brush up in the math halls at newSchoolWorks.com:
In class: Spreadsheet lab: students build a resin-tracking spreadsheet from scratch that accepts batch number, resin type, target weight, catalyst percentage, and actual weights, then auto-calculates percent error and flags out-of-tolerance batches with conditional formatting — instructor evaluates the file against a specification checklist. · Email drafting exercise: students compose a professional email to a fictional shop supervisor requesting a material order, then a follow-up email responding to a fictional employer's interview invitation — both reviewed against a professional-communication rubric emphasizing correct greeting, clear body, and appropriate sign-off. · Job-search activity: students use publicly available job boards and the ABYC and ACMA career resource pages to find three real or realistic entry-level composites or boatbuilding job postings, copy the key requirements into a comparison table, and identify which credential (ABYC Composite Boat Builder or ACMA CCT) is referenced or relevant to each posting — results shared in class discussion.
Materials: Computers or tablets with spreadsheet software (Google Sheets or Microsoft Excel); internet access; email accounts; job-board websites; ABYC and ACMA website access; email rubric; spreadsheet specification checklist.
Check: Spreadsheet file meets all checklist items (correct formulas, conditional formatting triggers accurately) — pass = all required functions present and operating; email drafts score ≥ 80% on rubric; job-search table submitted with three postings and credential mapping completed.

Practice check8

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

Composites process quality and measurement
1. A technician targets 600 g of resin with a 2.0% catalyst ratio. What is the target catalyst weight?
Composites process quality and measurement
2. The actual catalyst weight in a batch is 6.8 g; the target was 7.5 g. What is the percent error, rounded to one decimal place?
Composites process quality and measurement
3. Using a ±5% catalyst tolerance, which batch should be flagged as out of specification?
Digital tools and workplace documentation
4. In a spreadsheet, which conditional formatting rule correctly flags a percent error cell (E2) as out of tolerance when the allowable limit is ±5%?
Safety and hazardous materials
5. Why is it critical to reference the resin manufacturer's technical data sheet (TDS) rather than relying on memory when entering a catalyst percentage into a tracking log?
Workplace communication and professionalism
6. Which element is required in every professional workplace email?
Career readiness and credential recognition
7. A job posting specifies 'ABYC certification preferred' for a marine laminator role. Which credential most directly matches this requirement?
Career readiness and credential recognition
8. A student finds a composites fabrication posting that mentions vacuum infusion and out-of-autoclave processing for wind and marine applications, and lists 'ACMA CCT or equivalent.' The student holds both the ABYC Composite Boat Builder and ACMA CCT credentials. What is the best strategy for this application?
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.
← Previous lessonProgram planNext lesson →