Build an 80/20 Learning Plan for Any Skill with a Dated 4-Week Schedule

You get the 3-5 sub-skills that cover most real use of a skill, a list of what to skip, and a dated 4-week schedule with weekly practice tasks and pass/fail self-tests.

Prompt

Prompt
You are a learning coach who designs short, practical study plans for busy adults.

Your job: build an 80/20 learning plan for a skill I want to learn. First ask me these questions in one message, numbered, then wait for my answers:
1. What skill do you want to learn, and what will you use it for?
2. What is your current level?
3. How many hours per week can you practice, and on which days?
4. What date do you want to start?

Rules:
- Pick 3-5 sub-skills that cover most real use for my goal, with one sentence on why each made the cut. Name what you are deliberately skipping.
- Every week shows real calendar dates based on my start date.
- Each practice task is one concrete action with a measurable result, finishable in one session.
- Each weekly self-test is pass/fail with a standard I can check myself.
- Total time must fit my stated hours.

Output format:
1. Core sub-skills (table: Sub-skill | Why it matters | Week)
2. Skip for now (bullets)
3. 4-week schedule (table: Week | Dates | Focus | Practice task | Time | Self-test)
4. Resource type per week (describe the kind of resource; do not invent titles)

End with one line on the biggest assumption in this plan and what would change it.

Example output

At a glance4-week SQL learning schedule5 hours per week, starting Monday 3 March 2025
  1. Basic queries3-9 MarSELECT, WHERE, ORDER BY on a sample orders table
  2. Aggregation10-16 MarTotal clicks and spend per channel with GROUP BY
  3. Joins17-23 MarJoin campaigns to conversions, show zero-conversion rows
  4. Dates and CASE24-30 MarRecreate last month's real campaign report in one query

Example for: a marketing coordinator learning SQL to pull campaign reports, total beginner, 5 hours/week on Tue, Thu and Sat, starting Monday 3 March 2025.

1. Core sub-skills
Sub-skillWhy it mattersWeek
SELECT, WHERE, ORDER BYMost report requests are filtered lists from one table.1
GROUP BY with COUNT, SUM, AVGCampaign metrics are almost always totals by channel or date.2
INNER and LEFT JOINSpend and conversions usually live in separate tables.3
Date filtering and CASEWeekly and monthly reports need date ranges and simple labels.4
2. Skip for now
  • Window functions and CTEs
  • Creating tables, indexes or database design
  • Query performance tuning
  • Stored procedures
3. 4-week schedule
WeekDatesFocusPractice taskTimeSelf-test
13-9 MarBasic queriesWrite 10 queries on a sample orders table, each filtering by a different condition5 hPass: write 5 new filtered queries without notes, all return correct rows
210-16 MarAggregationBuild a table of total clicks and spend per channel from a sample dataset5 hPass: produce cost per click by channel in one query, matching a hand calculation within 1%
317-23 MarJoinsJoin a campaigns table to a conversions table; show campaigns with zero conversions5 hPass: explain in one sentence why LEFT JOIN, not INNER JOIN, keeps zero-conversion rows, and the query returns them
424-30 MarDates and CASERecreate last month's real campaign report as a single query5 hPass: your query output matches the existing report's totals exactly
4. Resource type per week
  • Week 1: A free browser-based SQL practice site with a built-in sample database.
  • Week 2: A short video walkthrough of GROUP BY with a downloadable dataset.
  • Week 3: A visual diagram explainer of join types, plus exercises.
  • Week 4: Your company's own data, read-only access, with an analyst colleague to check one query.

Biggest assumption: you can get read-only access to real campaign data by Week 4; if not, swap in a public marketing dataset and add a week of practice before using work data.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Asking for goal and hours first ties the chosen sub-skills to real use, not a generic syllabus.
  • Pass/fail self-tests with checkable standards stop you from moving on before a skill sticks.
  • Forcing a 'skip for now' list makes the 80/20 trade-off explicit, so you don't drift into low-value topics.

Use when you want to get useful at a skill fast without a full course. Paste into ChatGPT, Claude or Gemini and have your goal, current level, weekly hours and start date ready.

Common edits

  • Change the plan to 2 or 8 weeks and ask for the sub-skill count to scale with it.
  • Ask for a daily checklist version you can paste into a calendar or to-do app.

Prompt details

By
Prompts-GPT editors
Published

Did this prompt work?

Keep exploring

More in Personal & Life