Objective. Students will use spreadsheet software to organize equipment data and perform calculations, and describe the purpose and basic workflow of a computerized work-order and maintenance-management system as used in nuclear plant operations.
This lesson, its worked examples and its practice questions has not yet been verified by a licensed professional engineer or master 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.
Nuclear power plants are complex industrial facilities that depend on accurate recordkeeping, careful data management, and clearly documented work processes. Whether you are tracking instrument readings, requesting a maintenance job, or reporting an equipment deficiency, you will almost certainly use a computer to do it. Two categories of software stand out in everyday plant work: spreadsheet programs and computerized maintenance management systems (CMMS). Learning the basics of both now gives you a practical head start before you ever step through a plant security checkpoint.
The nuclear industry operates under strict regulatory oversight by the U.S. Nuclear Regulatory Commission (NRC). Accurate, traceable records are not optional — they are a regulatory requirement. A handwritten log transferred to no other system can be lost, misread, or altered without a clear audit trail. Electronic records, when properly controlled, create a time-stamped, searchable history that supports both safety decisions and NRC inspections. Errors in data entry can cascade into incorrect trend analyses, missed equipment problems, or faulty work authorizations. Precision in data entry is a safety behavior, not just good housekeeping.
A spreadsheet organizes information in a grid of cells, each identified by a column letter and row number (for example, cell B3 is column B, row 3). You will use spreadsheets to enter instrument readings, calculate statistical values, and display trends visually.
Data entry is straightforward: click a cell, type your value, and press Enter. Use consistent units throughout a column. Never mix degrees Fahrenheit and degrees Celsius in the same column without a clear label, because a formula will treat all numbers as equal.
Formulas begin with an equals sign. The formula `=AVERAGE(B2:B8)` calculates the average of all values in cells B2 through B8. The formula `=MAX(B2:B8)` returns the highest value. Use these to summarize a shift's worth of readings quickly.
Cell referencing allows one formula to refer to values in other cells. A relative reference (like B2) adjusts automatically when you copy the formula to another row. An absolute reference (like $B$2) stays locked regardless of where you copy it. Understanding this distinction prevents formula errors when building a log-sheet template.
Charts turn columns of numbers into visual trends. A bar chart (also called a column chart) is well suited to comparing daily values side by side. Select your data range, insert a chart, choose the bar/column type, and label your axes with the measured quantity and its units. A chart without labeled axes is not acceptable in plant documentation.
Spreadsheet safety habits: save your file frequently and under a clearly dated file name. Never overwrite a completed, verified log with new data — start a new file or a new sheet tab. If your plant uses a controlled electronic document system, follow its check-in and version-control procedures exactly.
A CMMS is specialized software that tracks every piece of plant equipment and all the work performed on it. In a nuclear plant, the CMMS is central to maintaining equipment reliability and proving to the NRC that required maintenance has been completed on schedule.
The five major functional sections you will encounter are:
1. Work-Order Creation – Technicians and operators enter a description of the work needed, the affected component, and the priority level. The work order becomes the official authorization document for the job.
2. Equipment History – Every completed work order, inspection result, and component replacement is stored here. Before starting a job, technicians review the equipment history to understand past failures and any recurring problems.
3. Parts Lookup – Identifies the correct spare parts, their stock numbers, and their availability in the plant warehouse. Using a wrong or unapproved part on a safety-related system can be a serious regulatory violation.
4. Approval Workflow – In a nuclear plant, work on certain systems requires review and sign-off by supervisors, engineers, or the operations department before work begins. The CMMS routes the work order through these approval steps automatically, creating an electronic paper trail.
5. Condition Reporting / Corrective Action – When a deficiency is identified (such as a gauge reading outside its expected band), a condition report (CR) is initiated in the system. The CR triggers the plant's corrective-action program (CAP), which is required under NRC regulations.
The corrective-action program is one of the most important quality systems in a nuclear plant. Any employee who notices a problem — even a minor one — is expected to write a condition report. Failing to report a known deficiency is a serious breach of nuclear safety culture.
A well-written condition report uses neutral, precise language. Describe what you observed, when, and where. Do not speculate about cause in the initial report; state only the facts. For example: "At 0730 on [date], pressure gauge PI-204 on the auxiliary feedwater header indicated 47 psig. The expected band per procedure is 55–65 psig." That statement is factual and verifiable. A vague entry such as "gauge looks low" is not acceptable.
Required fields in most CR templates include: date and time of observation, location and equipment identifier, description of the condition, name of the person reporting, and immediate actions taken (if any). Missing a required field can delay corrective action and may constitute a procedural violation.
The NRC, NUCP, and NRRPT all expect technicians and operators to maintain accurate records and follow documented procedures. Competence with plant digital tools directly supports your readiness for those credentials and for day-one work in the plant.
Answer each question, then check it. Nothing is recorded; this is your own practice.
A free tech program — complimentary, as our commitment to get America working. Help us build VoTechWorks. Tell us what works, what doesn’t, and what you want to learn.