Quality & maintenance records
Run SPC on inspection data and manage CMMS work orders.
20 project-authored proposals · taxonomy v1.1 · 0 new benchmark runs. Verifiers and partial-credit rules below are designs, not executed results.
- Typical applications
- Minitab · CMMS · Excel
- Class GUI-need label
HY· Hybrid
Task proposals · 20
Expand to inspect the complete original wording and proposed checks. Original proposal text remains English in both interfaces.
R07.07.02.04-T01 Build an Xbar-R chart and list Western Electric rule violations
Original instruction
In Minitab 22 open input/shaft_od.xlsx (25 subgroups of 5 diameters, mm). Create an Xbar-R chart with tests 1, 2, 5 and 6 enabled (Western Electric rules 1-4 equivalents), save the chart to out/xbar_r.png, and list each violating subgroup with the rule number in out/violations.csv.
- Platforms
win· Windowsmac· macOS- Applications
- Minitab
- Interfaces
desk· Desktop GUI- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
CL· CLI-sufficient- Interaction primitives
click· Point & clicktype· Text & formsvis· Visual judgment- Work product
WP12· Answer/decision- Conditions
licensed· Licensed pro app- Proposed difficulty
- 3 / 5
Proposed verifier
violations.csv equals grader computation (subgroup, rule) exactly; control limits read from Minitab session output within 0.001 mm; chart file exists; Minitab project (.mpx) saved with the chart command in history.
Proposed partial credit
25% limits correct; 60% violations list (F1); 15% outputs saved
R07.07.02.04-T02 Compute Cpk for three CMM features and flag those below 1.33
Original instruction
input/cmm_lot_4417.csv has 60 measurements for bore Ø, flatness and position with specs in docs/drawing_specs.pdf. Compute Cp, Cpk (within, unbiased) for each feature, and write out/capability.xlsx with the values and a FLAG column for Cpk <1.33.
- Platforms
win· Windowsmac· macOS- Applications
- Minitab · Excel
- Interfaces
desk· Desktop GUI- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
CL· CLI-sufficient- Interaction primitives
click· Point & clicktype· Text & forms- Work product
WP02· Records/table- Conditions
- None declared
- Proposed difficulty
- 2 / 5
Proposed verifier
Cp/Cpk within 0.01 of reference; one-sided specs handled for flatness/position (Cpk = CPU); flags correct.
Proposed partial credit
30% spec limits read correctly; 50% indices; 20% flags
R07.07.02.04-T03 Build a live SPC chart in Excel with phase-I limits and rule highlighting
Original instruction
In Excel create out/fill_weight_spc.xlsx from input/fill_weights.csv: compute I-MR limits from the first 30 points (phase I), plot individual values with CL/UCL/LCL lines for all 120 points, and use conditional formatting to highlight points beyond limits or 8 in a row on one side. The chart must update if a new row is appended.
- Platforms
win· Windowsmac· macOS- Applications
- Excel
- Interfaces
desk· Desktop GUI- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
CL· CLI-sufficient- Interaction primitives
type· Text & formsclick· Point & clickvis· Visual judgment- Work product
WP02· Records/table- Conditions
- None declared
- Proposed difficulty
- 3 / 5
Proposed verifier
openpyxl: limit cells are formulas over rows 2-31 and values match reference; chart series ranges reference a Table/dynamic range (append test via LibreOffice recalc); highlighted rows equal rule set.
Proposed partial credit
30% limits; 25% chart series; 30% rule highlighting; 15% dynamic range
R07.07.02.04-T04 Run a crossed Gage R&R study and judge measurement system adequacy
Original instruction
In Minitab analyze input/grr_caliper.xlsx (10 parts × 3 operators × 3 trials) with Gage R&R Study (Crossed), ANOVA method, process tolerance 0.40 mm. Report %StudyVar, %Tolerance, number of distinct categories and an accept/conditional/reject verdict per AIAG MSA in out/grr.json.
- Platforms
win· Windowsmac· macOS- Applications
- Minitab
- Interfaces
desk· Desktop GUI- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
CL· CLI-sufficient- Interaction primitives
click· Point & clicktype· Text & forms- Work product
WP12· Answer/decision- Conditions
licensed· Licensed pro app- Proposed difficulty
- 3 / 5
Proposed verifier
grr.json values within 0.5 points of reference; ndc integer exact; verdict per thresholds (<10% accept, 10-30% conditional).
Proposed partial credit
40% %StudyVar/%Tol; 20% ndc; 25% verdict; 15% interaction term handled
R07.07.02.04-T05 Set up preventive maintenance schedules for twelve assets in Odoo
Original instruction
In the sandbox Odoo 17 Maintenance app create equipment records for the 12 assets in input/pm_plan.xlsx (category, serial, location, team) and preventive maintenance requests with the stated intervals (days) and durations, assigned to the 'Mechanical' team, first due dates as listed.
- Platforms
web· Any OS (web)- Applications
- CMMS · Odoo
- Interfaces
brow· Browser- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
type· Text & formsclick· Point & clickmulti· Cross-app- Work product
WP08· App/system state- Conditions
multiapp· Multi-app- Proposed difficulty
- 3 / 5
Proposed verifier
Grader XML-RPC: 12 equipment with fields exact; preventive requests with period, duration, team, schedule date per plan; no duplicates. Agent has UI login only.
Proposed partial credit
40% equipment records; 45% PM schedules; 15% no duplicates
R07.07.02.04-T06 Close completed work orders with labour and parts in a CMMS
Original instruction
In the sandbox MaintainX organization, close the 8 work orders listed in input/tech_sheets.pdf (scanned technician sheets): enter labour hours per technician, parts used (decrementing inventory), failure code and completion notes, and set status Done with the actual completion date.
- Platforms
web· Any OS (web)- Applications
- CMMS · MaintainX
- Interfaces
brow· Browser- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
type· Text & formsclick· Point & clickvis· Visual judgment- Work product
WP08· App/system state- Conditions
- None declared
- Proposed difficulty
- 2 / 5
Proposed verifier
Grader API: 8 WOs Done with dates; labour entries per tech ±0.1 h; parts quantities and inventory levels decremented correctly; failure codes exact.
Proposed partial credit
25% status/dates; 25% labour; 30% parts & inventory; 20% failure codes
R07.07.02.04-T07 Create and release a corrective maintenance order from a notification in SAP PM
Original instruction
In the SAP S/4HANA training client via SAP GUI, open notification 10004711 (M2, pump P-301 seal leak), create a PM01 order from it (IW34) with two operations (isolate & replace seal 3 h; test 1 h) on work center MECH-01, reserve material 100-3355 (1 EA) from plant 1000, schedule and release the order. Record the order number in out/order.txt.
- Platforms
win· Windows- Applications
- SAP GUI · CMMS
- Interfaces
desk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
G3· GUI-only- Interaction primitives
type· Text & formsclick· Point & clicknav· Pan/zoom/scroll- Work product
WP08· App/system state- Conditions
licensed· Licensed pro app- Proposed difficulty
- 4 / 5
Proposed verifier
Grader reads order via RFC: type PM01 linked to notification; 2 operations with times/work center; reservation for 100-3355 qty 1; status REL; order.txt matches. SAP GUI scripting disabled and no RFC/BAPI user issued to the agent; the order's change documents must show the agent's dialog user.
Proposed partial credit
20% order from notification; 30% operations; 25% component reservation; 25% released
R07.07.02.04-T08 Run a non-normal capability analysis with distribution identification
Original instruction
input/runout.xlsx (n=150, one-sided USL 0.05 mm) is skewed. In Minitab use Individual Distribution Identification to choose between Weibull, lognormal and Box-Cox, then run the matching non-normal capability analysis and report Ppk, expected PPM > USL and the chosen model with its AD p-value in out/capability.json.
- Platforms
win· Windowsmac· macOS- Applications
- Minitab
- Interfaces
desk· Desktop GUI- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
CL· CLI-sufficient- Interaction primitives
click· Point & clicktype· Text & formsvis· Visual judgment- Work product
WP12· Answer/decision- Conditions
licensed· Licensed pro app- Proposed difficulty
- 4 / 5
Proposed verifier
Chosen model equals best-fitting by AD among valid candidates (reference); Ppk within 0.02; PPM within 5%; p-value within 0.01.
Proposed partial credit
35% model choice; 35% Ppk; 20% PPM; 10% p-value
R07.07.02.04-T09 Update a process FMEA with new detection ratings and reprioritize actions
Original instruction
In input/pfmea_line4.xlsx update the Detection ratings for the 9 failure modes covered by the new vision inspection (docs/vision_capability.pdf maps to the AIAG-VDA scale), recompute Action Priority (AP) per the AIAG-VDA table on the 'AP_table' sheet, and sort the open actions by AP then severity. Save out/pfmea_line4_rev2.xlsx.
- Platforms
win· Windowsmac· macOS- Applications
- Excel
- Interfaces
desk· Desktop GUI- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
CL· CLI-sufficient- Interaction primitives
type· Text & formsclick· Point & click- Work product
WP02· Records/table- Conditions
- None declared
- Proposed difficulty
- 3 / 5
Proposed verifier
Detection values equal key for 9 rows; AP column computed by formula (lookup) and values equal reference; open actions sorted; other cells unchanged.
Proposed partial credit
35% detection ratings; 40% AP values via formula; 15% sorting; 10% no collateral
R07.07.02.04-T10 Analyze a 2^4 factorial with center points and find the optimal settings
Original instruction
input/coating_doe.mtw holds a 2^4 full factorial with 4 center points for coating thickness (target 25 µm, minimize variation). In Minitab analyze the factorial, reduce the model to significant terms (α=0.05, keep hierarchy), check curvature, and use Response Optimizer to hit 25 µm. Save out/doe.json with significant terms, curvature p-value and optimal settings.
- Platforms
win· Windowsmac· macOS- Applications
- Minitab
- Interfaces
desk· Desktop GUI- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
CL· CLI-sufficient- Interaction primitives
click· Point & clicktype· Text & formsvis· Visual judgment- Work product
WP12· Answer/decision- Conditions
licensed· Licensed pro app- Proposed difficulty
- 4 / 5
Proposed verifier
Significant term set equals reference; curvature p within 0.01; optimal settings predict 25±0.2 µm under the reduced model.
Proposed partial credit
40% term selection; 20% curvature; 40% optimizer settings
R07.07.02.04-T11 Compute MTBF and MTTR from work-order history and a downtime Pareto
Original instruction
Export the last 12 months of corrective work orders from the sandbox CMMS (Odoo Maintenance, 'Line 2' equipment) and compute per-asset MTBF and MTTR (hours), plus a Pareto chart of downtime by failure cause. Save out/reliability.xlsx with the table and chart.
- Platforms
web· Any OS (web)win· Windowsmac· macOS- Applications
- CMMS · Odoo · Excel
- Interfaces
brow· Browserdesk· Desktop GUI- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
HY· Hybrid- Interaction primitives
click· Point & clickmulti· Cross-apptype· Text & forms- Work product
WP02· Records/table- Conditions
multiapp· Multi-app- Proposed difficulty
- 3 / 5
Proposed verifier
Table MTBF/MTTR within 1% of grader computation from DB; Pareto categories sorted descending with cumulative %; only corrective WOs in window used.
Proposed partial credit
20% correct export filter; 50% MTBF/MTTR; 30% Pareto
R07.07.02.04-T12 Define quality control points in Odoo and route a failed check to a quality alert
Original instruction
In the sandbox Odoo 17 (Manufacturing + Quality), create quality control points on operation 'Assembly' of product 'Pump PX-20': a measure check (torque 22±2 N·m) and a pass/fail visual check. Process manufacturing order MO/00042, record a torque of 25.1 N·m, and create the quality alert from the failed check assigned to team 'Line QA'.
- Platforms
web· Any OS (web)- Applications
- CMMS · Odoo
- Interfaces
brow· Browser- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
type· Text & formsclick· Point & click- Work product
WP08· App/system state- Conditions
- None declared
- Proposed difficulty
- 4 / 5
Proposed verifier
Grader XML-RPC: 2 control points with type, tolerances, operation; check on MO/00042 with value 25.1 and state fail; alert linked to check and team.
Proposed partial credit
35% control points; 30% check recorded; 35% alert routed
R07.07.02.04-T13 Run an attribute agreement analysis for visual inspectors
Original instruction
input/aaa_visual.xlsx has 3 inspectors rating 30 parts twice (pass/fail) with a known standard. In Minitab run Attribute Agreement Analysis and report within-appraiser, each-vs-standard and all-vs-standard % agreement and Fleiss' kappa in out/aaa.json, naming any inspector below 90% vs standard.
- Platforms
win· Windowsmac· macOS- Applications
- Minitab
- Interfaces
desk· Desktop GUI- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
CL· CLI-sufficient- Interaction primitives
click· Point & clicktype· Text & forms- Work product
WP12· Answer/decision- Conditions
licensed· Licensed pro app- Proposed difficulty
- 3 / 5
Proposed verifier
Percentages within 0.5 points and kappa within 0.01 of reference; flagged inspector set exact.
Proposed partial credit
50% agreement stats; 25% kappa; 25% flagged inspectors
R07.07.02.04-T14 Fit a Weibull to bearing failures and set a PM interval from B10 life
Original instruction
input/bearing_failures.xlsx lists hours-to-failure for 23 bearings plus 11 suspended (still running) units. Fit a 2-parameter Weibull with suspensions (MLE), compute β, η and B10 life, and propose a PM replacement interval at 80% of B10. Put results and a probability plot in out/weibull.xlsx.
- Platforms
win· Windowsmac· macOS- Applications
- Excel · Minitab
- Interfaces
desk· Desktop GUI- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
CL· CLI-sufficient- Interaction primitives
click· Point & clicktype· Text & formsvis· Visual judgment- Work product
WP02· Records/table- Conditions
licensed· Licensed pro app- Proposed difficulty
- 4 / 5
Proposed verifier
β and η within 2% of reference MLE with right-censoring; B10 within 3%; interval = 0.8×B10; plot present. Ignoring suspensions yields outside tolerance.
Proposed partial credit
40% β/η with censoring; 30% B10; 15% interval; 15% plot
R07.07.02.04-T15 Record inspection results and a usage decision for an SAP QM lot
Original instruction
In the SAP S/4HANA training client via SAP GUI, record results (QE51N) for inspection lot 040000001234 from input/inspection_sheet.pdf (5 quantitative characteristics, sample size 5), let the system valuate, record a defect for the out-of-spec characteristic, and make the usage decision (QA11) 'R - Reject' with stock posting to blocked stock.
- Platforms
win· Windows- Applications
- SAP GUI
- Interfaces
desk· Desktop GUI- GUI need · task setting
G3· GUI-only- GUI need · ordinary access
G3· GUI-only- Interaction primitives
type· Text & formsclick· Point & clicknav· Pan/zoom/scroll- Work product
WP08· App/system state- Conditions
licensed· Licensed pro apprisk· Irreversible/risky- Proposed difficulty
- 4 / 5
Proposed verifier
Grader RFC read: 25 results equal sheet; valuations; defect record for the failing characteristic; UD code R and stock posted to blocked; lot status UD. SAP GUI scripting disabled and no RFC/BAPI user issued to the agent; the inspection lot's change documents must show the agent's dialog user.
Proposed partial credit
40% results entered; 15% valuation; 15% defect; 30% UD & stock posting
R07.07.02.04-T16 Build a P chart with varying subgroup sizes and flag out-of-control days
Original instruction
input/daily_defectives.xlsx has 40 days of inspected counts (varying 180-420) and defectives. In Minitab create a P chart with varying limits (and check overdispersion with the P chart diagnostic; use Laney P' if indicated), and list out-of-control days in out/p_chart.csv with the chart type used.
- Platforms
win· Windowsmac· macOS- Applications
- Minitab
- Interfaces
desk· Desktop GUI- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
CL· CLI-sufficient- Interaction primitives
click· Point & clicktype· Text & formsvis· Visual judgment- Work product
WP12· Answer/decision- Conditions
licensed· Licensed pro app- Proposed difficulty
- 3 / 5
Proposed verifier
Chart type equals diagnostic outcome (reference); flagged days exact for that chart; limits per day within 0.001.
Proposed partial credit
30% diagnostic & chart choice; 50% flagged days; 20% limits
R07.07.02.04-T17 Import a 200-asset hierarchy into a CMMS with parent-child links
Original instruction
Import input/assets_plant2.csv (200 assets with IDs, parent IDs, location, criticality) into the sandbox MaintainX organization using its CSV import, fix the 6 rows whose parent IDs reference a misspelled area, and verify the hierarchy shows Plant 2 → 5 areas → lines → assets.
- Platforms
web· Any OS (web)- Applications
- CMMS · MaintainX
- Interfaces
brow· Browser- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
click· Point & clicktype· Text & forms- Work product
WP08· App/system state- Conditions
- None declared
- Proposed difficulty
- 2 / 5
Proposed verifier
Grader API: 200 assets; parent links equal corrected key; no orphans; criticality and location fields exact.
Proposed partial credit
40% assets imported; 40% hierarchy correct; 20% fields
R07.07.02.04-T18 Turn an SPC out-of-control signal into a linked corrective work order
Original instruction
Minitab project fixtures/press_force.mpx shows an I-MR chart for press P-12 force. Identify the first out-of-control point (test 1) and its timestamp, then in the sandbox Odoo Maintenance create a corrective request for equipment P-12 with priority High, the timestamp and value in the description, and attach the exported chart PNG. Do not change other requests.
- Platforms
win· Windowsmac· macOSweb· Any OS (web)- Applications
- Minitab · CMMS · Odoo
- Interfaces
desk· Desktop GUIbrow· Browser- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
vis· Visual judgmentmulti· Cross-apptype· Text & forms- Work product
WP08· App/system state- Conditions
licensed· Licensed pro appmultiapp· Multi-app- Proposed difficulty
- 5 / 5
Proposed verifier
Request on P-12 with type corrective, priority High, description includes correct timestamp/value, attachment PNG of chart (image hash shows I-MR); no other requests modified.
Proposed partial credit
30% correct signal found; 40% request fields; 20% attachment; 10% no collateral
R07.07.02.04-T19 Track gauge calibration due dates and flag overdue instruments in Excel
Original instruction
input/gauge_register.xlsx lists 85 gauges with last calibration date and interval (months). Add Next Due (EDATE), Days Remaining relative to 2026-10-14, a Status column (Overdue/Due ≤30 d/OK), conditional formatting, and a pivot of Status by department. Save out/gauge_register_2026-10.xlsx.
- Platforms
win· Windowsmac· macOS- Applications
- Excel
- Interfaces
desk· Desktop GUI- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
G2· GUI-essential- Interaction primitives
type· Text & formsclick· Point & click- Work product
WP02· Records/table- Conditions
- None declared
- Proposed difficulty
- 3 / 5
Proposed verifier
Formulas (EDATE) present; computed values equal reference; status counts per department in pivot cache match; conditional formatting rules exist for Overdue and Due.
Proposed partial credit
30% next due; 25% status; 25% pivot; 20% formatting
R07.07.02.04-T20 Monitor four correlated characteristics with a T² chart and find the driver
Original instruction
input/extrusion_mv.xlsx has 100 subgroups (n=4) of 4 correlated dimensions. In Minitab build a Tsquared-Generalized Variance chart using the first 40 subgroups as historical (phase I), identify out-of-control subgroups in phase II, and for each give the variable contributing most (decomposition). Save out/t2.csv.
- Platforms
win· Windowsmac· macOS- Applications
- Minitab
- Interfaces
desk· Desktop GUI- GUI need · task setting
HY· Hybrid- GUI need · ordinary access
CL· CLI-sufficient- Interaction primitives
click· Point & clicktype· Text & formsvis· Visual judgment- Work product
WP12· Answer/decision- Conditions
licensed· Licensed pro app- Proposed difficulty
- 5 / 5
Proposed verifier
Flagged subgroups exact vs reference using phase-I parameters; top contributor per signal equals decomposition key for ≥90%.
Proposed partial credit
25% phase-I setup; 45% flagged subgroups; 30% contributors
Mapped research references
No benchmark reference is assigned to this class in the current mapping.