06 How to document Deliverables
Operator Tutorial§
How we’ll use Google Sheets and Google Docs side-by-side during the Learning Boot-Camp
1 · Why we split the tools§
| Purpose | Tool | Why this is the best fit |
|---|---|---|
| Time-tracking evidence (every study minute) | Google Sheet | Fast, row-based logging; totals & charts update automatically. |
| All learning artefacts (answers, screenshots, voice-note links, reflections) | Google Docs with Tabs | Rich media + inline comments; easy for managers to review by tab. |
Bottom line: one Sheet, one Docs folder with 8 tabbed files – nothing slips through the cracks.
2 · Google Sheet — “Boot-Camp Time-Ledger”§
2-A. Make your personal ledger§
- Open the master template: Drive ▸ 04-OPERATORS-INDEX ▸ Templates ▸ Time-Ledger_Template.
- File ▸ Make a copy → rename to
TL-<YourName>-BootCamp. - Move the copy into your OP-
_Drive ▸ Learning-Log folder.
2-B. Ledger layout§
| Column | What you type | Example |
|---|---|---|
| Date | Auto-filled by NOW formula; don’t touch. | 2025-05-16 |
| Start HH:MM | Exact start time of that timer | 09:03 |
| End HH:MM | When you stopped that timer | 09:47 |
| Min | Sheet auto-calculates (=(End-Start)*1440). |
44 |
| Subsystem | Copy from timer description (Learn:Work-Intake:Orient). |
Work-Intake |
| Step/Tab | Orient / Read / … | WGLL |
| Clockify Link | Right-click the entry in Clockify > copy link; paste. | https://clockify.me/tracker/... |
| Brief Note | Optional – 5-word context or “see Docs tab”. | “Deep-Dive Q done” |
Rule: every timer has one row in the Sheet before you start the next timer.
2-C. Auto-totals & visuals§
“Summary” tab shows per-day totals and a pie chart of minutes per subsystem – no editing needed. Managers glance at this during Daily Hygiene.
2-D. Weekly hand-off§
At Friday 16:45 you’ll File ▸ Download ▸ CSV and drop it into the normal Evidence-Export flow (TT-SOP-2).
3 · Google Docs — “Learning Log” files with Tabs§
(recap in brief; full guide is pinned inside every Doc)
- Copy
Tabs_Template.docxfor each subsystem (01-08). -
Each tab matches one step of the 9-phase loop – fill in as you complete the step.
-
Paste answers (Orient 4-pack, ASCII, etc.).
- Insert images/audio ▸ Drive for screenshots or voice-notes.
- Tick the Done? tab only when all prior tabs have content.
- Use Insert ▸ Comment to ask for clarifications; managers reply inline.
- The file turns Green (Drive colour script) when all tabs are ticked.
4 · How the two tools connect§
| Action | Sheet | Doc |
|---|---|---|
| Start timer | Row appears immediately (Date, Start, Subsystem, Step). | — |
| Produce work (e.g., quiz) | — | Paste score in Quiz tab. |
| Stop timer | Fill End time → minutes auto-calc. Insert Clockify link. | — |
| Manager review | Checks Summary tab totals & random Clockify links. | Jumps to specific Doc tab, leaves comments. |
| Daily Hygiene export | “Today” CSV downloaded from Sheet. | Docs untouched. |
5 · Quick reference commands§
| Need | Shortcut |
|---|---|
| Add new row fast | Press Ctrl + ↓ in Sheet to jump to empty row. |
| Copy Clockify link | Click duration ▸ “Copy link”. |
| Embed voice note | In Doc: Insert ▸ Drive ▸ recent MP3. |
| Convert headings to tabs | Insert ▸ Building blocks ▸ Tabs (if enabled). |
| Ask bot for help | In chat: /tip time-tracking or /checklist focus-env. |
Done!§
Keep the Time-Ledger Sheet and your 8 Learning-Log Docs open in pinned Chrome tabs; switch Clockify descriptions & Sheet rows as you move through the scaffold. This pairing gives us airtight evidence and a rich learning portfolio.
Below is everything your operators (or you) need to clone, drop-in, and start using immediately.
1 · Google Sheet Template – “TL--BootCamp” §
How to create it
- Go to Drive ▸ 04-OPERATORS-INDEX ▸ Templates
- New ▸ Google Sheet → Rename to
TL-<YourName>-BootCamp- Paste the exact structure below (copy/paste rows 1-3, formulas auto-fill)
| A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|
| Date | Start HH:MM | End HH:MM | Min | Subsystem | Step/Tab | Clockify Link | Brief Note |
| =TODAY() | 09:00 | 09:44 | =(C2-B2)*1440 |
Work-Intake | Orient | (paste link) | “4-pack done” |
| (keep adding rows…) |
Sheet Tabs
| Tab name | Contents / Formulae |
|---|---|
| Ledger (default) | Data-entry grid above (freeze row 1). |
| Summary | =QUERY(Ledger!A:H,"select A,sum(D) where A is not null group by A order by A",1) + Pie-chart of minutes by Subsystem. |
| Data Valid | Two named ranges used for drop-down validation: Subsystems = { "Work-Intake"; … "IT-Security" } Steps = { "Orient"; "Read"; … "Reflection" } |
| Hide Me | (Optional) Helper columns for other formulas—leave blank for operators. |
Conditional formatting: – If Min = “” → red background (prevents blank rows). – If Clockify Link cell is blank & End time is filled → amber background.
2 · Google Docs Template – “Learning Log - .doc” §
How to create it
- Inside OP-Drive ▸ Learning-Log, make 8 copies of the template—one per subsystem.
- Rename each file:
LL-01-Work-Intake,LL-02-Time-Tracking, …LL-08-IT-Security.
A. Enable Tabs (Google Docs)§
- In each file click Insert ▸ Building Blocks ▸ Tabbed Page.
- Rename the eight tabs exactly as shown:
Orient • Read • WGLL • Deep-Dive • TL;DR • Quiz • Teach-Back • Reflection • Done?
(Google rolls out Tabs gradually. If Tabs aren’t enabled, just use Heading 1 sections with the same names; managers can click the outline on the left.)
B. What goes inside each tab§
| Tab (Heading 1) | Operator pastes or writes… |
|---|---|
| Orient | The 4 answers from Orientation 1-A/B/C/D. |
| Read | Nothing to paste—check-box only: “✅ README + key SOPs finished”. |
| WGLL | One screenshot or short bullet list of key quality cues they noticed. |
| Deep-Dive | Q\&A transcript with Coach plus any “Gap?” lines they raised. |
| TL;DR | 140-character paraphrase. |
| Quiz | Score + date (Score = 92 % (on 2nd attempt)). |
| Teach-Back | Link to voice-note in Drive + GPT rating comment. |
| Reflection | Three bullets: What clicked · Still fuzzy · One micro-experiment I’ll try. |
| Done? | Tick-box → Insert ▸ Special characters ▸ ☑ when every prior tab populated. |
Drive colour script (optional): When the Done? box becomes ☑ the file colour auto-changes to green (easy visual scan).
C. Permissions & comments§
- Operators are Editors on their own Learning-Log files.
- Managers: Commenter.
- Systems-Ops Lead: Editor (to fix template drift).
- Comments for clarification stay inside the relevant tab; resolved when the operator updates content.
3 · Linking Sheet ↔ Docs§
-
In the Brief Note column of the Sheet row for each phase, paste the Docs tab URL (right-click heading ▸
Copy link). Example:https://docs.google.com/document/d/<ID>/edit#heading=h.9jh2... -
If a timer covers multiple micro-actions (e.g., reading plus WGLL glance in one 45-min block) you may list both steps in Step/Tab (
Read+WGLL) and paste two links in Brief Note, separated by newline.
4 · First-day sanity check list§
- Sheet contains at least one row with a valid Clockify link and minutes value.
- LL-01-Work-Intake file exists with the Orient tab filled.
- Manager opens Summary tab – sees a non-zero minute total for today.
- Manager clicks Orient tab link – contents match Orientation 4-pack answers.
When those four bullets are green, the foundational evidence chain is working—and the operator is free to motor through the scaffold with zero hand-holding.