Spreadsheet Learning & Team Training
Track Server-Verified Academy Lesson Progress vs AI Hint Practice
Audit team spreadsheet training by separating local draft attempts and AI hint sessions from server-verified Academy lesson completions in Excel and Arte Sheets.
Never confuse local draft attempts or AI hint sessions with verified completion
When a finance or operations team trains on spreadsheet formulas, learners often practise with hints before completing graded exercises. In Arte Sheets, the in-app Pro assistant uses metered monthly Pro credits when you send a prompt, while the Arte Sheets ChatGPT connector 0.1.0 (currently In review / Not published) provides read-only Academy tools (list_lessons, get_lesson for free lessons or Pro-unlocked paid lessons, and get_learning_progress under academy:read) without consuming Arte AI credits — and neither AI hints nor the connector can submit exercises, mark lessons complete, or issue certificates.
Build a 4-module team training tracker in A2:D5: Foundations (4 lessons, 4 local drafts, 4 server-verified), Lookups (4 lessons, 4 drafts, 3 verified), Dates & Cleaning (3 lessons, 3 drafts, 2 verified), and Reporting (4 lessons, 2 drafts, 0 verified). Counting local drafts (13 / 15 = 86.67%) overstates readiness by +26.67 percentage points compared with true server-verified progress (9 / 15 = 60.00%)!
| Learning Activity | Entitlement & Credit Rule | Counts Toward Verified Completion? |
|---|---|---|
| Free Lesson Read & Self-Check | Available without Pro in web app & get_lesson | Only after in-app exercise verification passes |
| In-App Pro Assistant Socratic Hint | Requires active Pro; deducts metered Pro AI credits per request | No — coaching aid only; learner must verify sheet |
| ChatGPT Connector 0.1.0 (In review) | academy:read OAuth; paid lessons require Pro; 0 Arte AI credits | Read-only progress/prompts; cannot submit or certify |
| Server-Verified Exercise Pass | Verified inside Arte Sheets Academy (verifiedLessons) | Yes — sole source for completion & certification |
Verified Mastery Rate vs Draft Inflation Gap Formula
Divide SUM(D2:D5) (server-verified lessons) by SUM(B2:B5) (total curriculum lessons), clamping any bad manual entry where verified exceeds module size via MIN.
=IF(SUM(B2:B5) <= 0, "Invalid Curriculum Total", ROUND(SUM(D2:D5) / SUM(B2:B5), 4))Module Completion & Certification Readiness Gate Formula
Require 100% server-verified lessons across every module (SUM(D2:D5) = SUM(B2:B5) and zero unverified gap) before marking a cohort module complete. Test updating D3 = 4, D4 = 3, and D5 = 4 after the learner verifies the remaining 6 exercises in Arte Sheets: verified completion rises from 0.6000 to 1.0000 and flips the status to "All Lessons Server-Verified".
=LET(tot_l, SUM(B2:B5), ver_l, SUM(D2:D5), drf_l, SUM(C2:C5), IF(tot_l <= 0, "Invalid Curriculum Total", IF(ver_l > tot_l, "Count Exceeds Curriculum", IF(ver_l = tot_l, "All Lessons Server-Verified", "In Progress: " & (tot_l - ver_l) & " Unverified"))))Try the example
Use the original values or change them to test your understanding.