# Assignment coverage — 2026-09-19

“Observed” means the prior run's records include a direct grade check. “Reported” means the user told us the score; it was not independently read in that run. Test results apply only to the reviewed layouts. All submissions and grade checks remain outside the installed companion.

| Assignment | Recipe coverage | Human actions | Evidence / remaining limits |
|---|---|---|---|
| 1.3 Cells and Worksheets | Insert column, Fill IDs, hide column; guided state checks | Four answers, Cut/Paste, width 20, delete required sheet | Workbook tasks observed 60/60; one recorded run was 90% because Q1 was unanswered. User later confirmed 1.3 is good. Answer persistence is still manual; no claim the software fixed it. |
| 1.5 Formatting Cells and Sheets | Formatting with guided native steps | Short Date, Thick Bottom Border, two Format Painter operations | Observed 100/100 pilot. Exact native methods matter. |
| 1.7 Sorting and Filtering | Single multi-level sort and two filter criteria | Instruction match, visual review | Reported 100/100; live readback and saved-workbook validation. |
| 1.8 Excel Basics | 21 requirements across three sheets, 12 guarded groups | Three exact native widths and Thick Bottom Border | User reported all requirements validated and 100/100. Sorting moves fitted row heights with records; shared border edges are accounted for. Final validation/grade were user-reported. |
| 2.2 References and Calculations | Four requirements in six formula/copy steps | Instruction match, visual review | Observed 100/100 pilot. |
| 2.4 Summary Statistics | Seven formula steps plus two guided AutoSum actions | Native AutoSum Average and Sum | Reported 100/100; live validation. |
| 2.6 Financial Functions | Six tasks using starter's signed cash flows | Instruction match, visual review | Reported 100/100; live formula/result validation. |
| 2.8 Formula Auditing | Three repairs, reference/result checks | Show Formulas review and four MyEducator answers | Reported 100/100; live workbook validation. Companion cannot persist answers in MyEducator. |
| 2.9 Formulas and Functions | Exact sales-tax/MLB/student-loan template; 25 requirements, 32 guarded operations | Compare all requirements; run reviewed plan | Prior supervised execution observed 100/100 and 409 formula/results checked. User later reported 100 after supported-mode validation. Template matching is strict, not a general formula solver. |

No extra worksheet is added for logging. Each recipe checks the existing sheet layout and stops on unsupported data/structure. Read each recipe's documentation for its inspection ranges. Formatting checks are strongest in 1.5 and 1.8; do not infer full style/object validation from a formula-check count. Exact width units and some method-specific operations rely on operator confirmation.

Before sharing course-owned instructions, starter data or material embedded in recipes, confirm you have permission to distribute those materials. Use only where assignment automation is permitted. No user workbooks, course URLs, launch codes or progress exports belong in a distributed package.