Library — DistroSource

Everything digital. One source.

5 resources

Project · Beginner · 5h
Project: An inventory workbook with reorder alerts
Build an inventory workbook with a products table, stock movements, reorder points, a dashboard and checks.
- Build a workbook with a products table (SKU, name, cost, reorder point, lead time), a movements table (date, SKU, quantity in or out), a stock-on-hand summary with SUMIFS, reorder alerts with conditional formatting, a pivot dashboard by category, validation on all inputs and a checks block.
- Milestone 1: Structure
- Milestone 2: Calculations
Project · Beginner · 6h
Project: An accessible, responsive landing page
Build a landing page with semantic structure, keyboard-accessible interaction, a fluid layout and measured performance.
- Build a landing page for a product with a header, hero, feature grid, pricing cards, FAQ disclosures and a signup form. It must pass an accessibility audit, work by keyboard, adapt from 320px to 1600px with at most two media queries, and load with good paint metrics.
- Milestone 1: Structure
- Milestone 2: Layout
Project · Beginner · 6h
Project: Automate one process end to end
Take one manual process from map to live automation with error handling, a manual fallback and a measured saving.
- Choose a recurring process. Map it from three real examples, build the automation one block at a time, add error routing and idempotency, test three samples and one deliberate failure, and run it live for two weeks with a log of runs, failures and time saved.
- Milestone 1: Map and build
- Milestone 2: Harden
ZapierMake
Project · Beginner · 4h
Project: A personal operating setup for ChatGPT
Configure instructions, three projects and a saved-prompt file for your real work, then measure the time saved over a week.
- Write custom instructions, create three projects for your three most recurring areas of work with files and instructions, and keep a file of five saved prompts with variables. Use the setup for a week and log time saved per task and edits made.
- Milestone 1: Configure
- Milestone 2: Use
ChatGPT
Project · Beginner · 4h
Project: An honest guide to assistants for your team
Write a two-page guide for your team on what your chosen assistant does well, where it fails, and the rules for using it, with every claim tested by you.
- Produce a two-page internal guide for a real team: what the assistant is, three tasks it does well with evidence from your own tests, three ways it fails with examples you produced, and five rules for use. The guide must not contain a claim you did not test yourself.
- Milestone 1: Test the strengths
- Milestone 2: Reproduce the failures
Any assistant

Search

Project: An inventory workbook with reorder alerts

Project: An accessible, responsive landing page

Project: Automate one process end to end

Project: A personal operating setup for ChatGPT

Project: An honest guide to assistants for your team