Darasa Hub - Learning Lions
Dira Portal Safety and Welfare ICT Support
SCS3.4

Sheets as a Back Office

Level 2 · BootCampSCS3 WorkspaceTaught week 5 Thursday morning

Submit Your Work

What You Turn In

  1. Your client's sheet, shared to the owner (sheet link)
    1. Lists, Records, Dashboard; at least twenty real rows; a rejecting rule on every entry column; five formulas; formulas and dashboard protected; the owner an editor of the entry columns fill in on the hub
  2. The .xlsx download and your hand-check log — stay in the evidence folder fill in on the hub
    1. In ~/scs/evidence/scs3.4; every formula checked against a row your partner picked, hand result beside the sheet's, any mismatch caused and fixed
  3. Your build notes (repo link)
    1. The overkill verdict, the rules and the garbage you typed at them, the protection, every AI receipt, break the books — the client named by trade, never by name
  4. The owner's card (client folder) fill in on the hub
    1. One page in the owner's language: where to type, what never to touch, what the five numbers mean, what to do when a number looks wrong; its PDF on the owner's phone
  5. Screenshot: the dashboard beside your hand-check log
    1. The five numbers next to their checks
  6. check-scs3.4 receipt and your method note
    1. Every automatic item PASS or its NOT YET explained; six lines, the sixth from your exit tickets

Stuck, or want to check your thinking? Paste this card into your own AI and ask it to question you, not answer for you.

How

  1. Asha, by Saturday's update.
Done when
  1. The client's sheet, shared to the owner: Three tabs in one shape; at least twenty real rows, ledger rule kept; a rule on every entry column set to reject; five dashboard numbers as formulas over whole columns with the flag; formulas and dashboard protected; shared to the owner's own address as editor
  2. .xlsx download + hand-check log: Every formula checked against a row the partner picked, from the other month where it filters; hand and sheet results side by side; every mismatch chased to its cause and fixed
  3. Build notes: Overkill verdict with its reason, rules and garbage tests, protection and the owner's minute, every AI receipt, break-the-books write-up; the client by trade, nothing private
  4. Owner's card: In the owner's language; where to type, what never to touch, the five numbers in the owner's words, what to do when a number looks wrong, how to open it on the phone; reads like the owner speaking
  5. Dashboard-beside-log screenshot: The five dashboard numbers beside their hand-check rows
  6. check-scs3.4 receipt + method note: Every automatic item PASS or its NOT YET explained; six lines, the sixth a real doubt from the exit tickets

Counts toward: the SCS3.4 badge, 1 to 3 stars · the client folder · attendance for the Taught and SGL blocks · LP (Lion Points) for accepted badge work.

Fill in the worksheet Submit work for SCS3.4