APAI Praveen
← All projects
IS & DIGITAL BUSINESSBUILDER~3 hrsFREE SAMPLE

Prioritise the backlog of a tuition-class booking app with a scoring grid

A small tuition booking app has far more feature ideas than time, and the loudest voice usually wins unless the team scores them.

WHAT YOU HAND IN

A scored backlog of twelve feature ideas with reach, impact and effort ratings, a final ranking and a one-paragraph reason for the top three and for the one you would cut.

YOUR AI BUILD GUIDE

This is a spreadsheet analysis project. Put real data in a table, work it out, and say what the numbers show.

The approach: Decide what one row means → Clean the data before analysing it → Calculate in the sheet, not in the chat → Write the finding in a sentence a manager can act on.

Think first

A small team cannot build twelve features at once. The scoring grid replaces 'who argued loudest' with a fair, repeatable judgement, so the real work is fixing the scale before you score and then testing it against someone else's view.

ANSWER THESE BEFORE YOU OPEN ANY AI TOOL
  • Who uses the app: students, parents, tutors, the class owner? Whose problem matters most right now?
  • What does a high score mean on reach, on impact and on effort, in one sentence each?
  • How will you combine the three scores into one ranking, and why that way?
  • Which feature are you secretly fond of, and how will you stop that bending the scores?
WHAT GOOD LOOKS LIKE

A sheet with twelve features, a written scale for reach, impact and effort, a formula that ranks them, a comparison with a friend's scores on three features, and one paragraph defending the top three and the one you would cut.

THE COMMON WRONG TURN

Scoring first and writing the scale afterwards. The scale then quietly fits whatever you already wanted to build.

Gather

COLLECT
  • Twelve feature ideas you write yourself, such as reminders, reschedule, parent view and fee receipts
  • A short talk with a tutor or a parent about what annoys them about booking classes today, with their consent
  • A friend willing to score three features on your scale without seeing your scores
WHAT AI MUST NOT MAKE UP

The features and scores are yours and should be labelled as a practice exercise. AI must not claim how many users would use a feature or quote usage data for any real app.

Build with AI

  1. 3.1 Write the scoring scaleCLAUDE CHAT

    Why this tool: Claude can spot vague scale wording before you start, while changing it is still cheap.

    Write a one-line meaning for each score on reach, impact and effort. Ask Claude where two people could read a line differently, and tighten it.

    Prompt to copy · fill in the [brackets]
    Here is my scoring scale for features in a tuition booking app:
    [paste your scale]
    For each line, tell me how two different people might score the same feature differently because the wording is unclear. Suggest one question I could add to make it sharper. Do not score any features.
  2. 3.2 Score every feature the same way with a SkillCLAUDE SKILLS

    Why this tool: A saved Skill applies your exact scale to each feature in turn, which exposes features you scored generously by hand.

    Save your scale as a Skill that asks for a score and a one-line reason per criterion. Run it on all twelve features, then compare with your own scores and decide each difference yourself.

    Prompt to copy · fill in the [brackets]
    Score this feature for a tuition booking app using only the scale below. For reach, impact and effort, give a score and one line of reason. If the scale does not decide it, say 'unclear' instead of guessing.
    Scale: [paste your scale]
    Feature: [one feature from your list]

    Before you let it act: Read the saved instructions before running: they must contain your scale word for word and must ask for reasons. The Skill suggests scores; you decide the final ones in your sheet.

  3. 3.3 Rank in the sheetGOOGLE SHEETS

    Why this tool: A formula keeps the ranking honest: change a score and the order updates.

    Put each score in its own column, add a combined score with a simple formula, and sort. Add your friend's three scores in a separate column.

  4. 3.4 Ask what you missedCLAUDE CHAT

    Why this tool: Claude can suggest features and risks you did not list, which you then judge against what a tutor or parent would want.

    Paste your twelve features and ranking. Keep only suggestions your tutor or parent conversation supports.

Check the AI's work

  • Your scale was written before any feature was scored
  • Recompute two combined scores by hand and confirm the sheet agrees
  • Where your friend scored differently, you wrote down why
  • The feature you cut is cut for a reason on your scale, not a feeling
  • Recompute two numbers by hand
  • Check the row count before and after cleaning
WHAT AI USUALLY GETS WRONG HERE

AI tends to rate every feature as high impact because each one sounds useful. If most features score near the top, your scale is too soft, not your backlog too good.

Finish and show

DONE WHEN
  • Twelve features with three scores each
  • Written scale and ranking formula
  • Friend comparison on three features
  • One paragraph on the top three and the cut
HOW TO PRESENT IT

Show the ranked table first, then the scale in a small box, then your paragraph. Highlight where your friend disagreed.

FOR YOUR PORTFOLIO

Explain one feature that moved a lot once you fixed the scale, and what that taught you about prioritising.

Which tool fits

  • Claude chat: Claude can spot vague scale wording before you start, while changing it is still cheap.
    Free plan works; Pro gives longer conversations.
  • Claude Skills: A saved Skill applies your exact scale to each feature in turn, which exposes features you scored generously by hand.
    Pro or above, with code execution switched on.
  • Google Sheets (free alternative): A formula keeps the ranking honest: change a score and the order updates.
    Free with a Google account.
  • Claude for Excel: building and explaining formulas inside your workbook
    Paid plans; needs Excel.
LEVEL UP

Reuse the Skill on a second backlog, such as a college fest app, and see whether your scale still works for a different product.

AI helps you think, check and polish. The work, and the judgement, stay yours.

Like this one? There are many more.

This is a free sample. Full Access opens every project in full and lets you submit your finished work.

See Full Access →
More builder projects in IS & digital business
IS & DIGITAL BUSINESSBUILDER
Mock up a weekly sales dashboard for a small bakery in a spreadsheet

A bakery sells dozens of items but its owner cannot tell which ones make money or which get thrown away.

~3 hrs🔒 Details
IS & DIGITAL BUSINESSBUILDER
Decide between a chatbot and a better FAQ page for an online course seller

A small online course seller is tempted by a chatbot, yet most questions might be solved by a clear page.

~3 hrs🔒 Details
IS & DIGITAL BUSINESSBUILDER
Write an incident one-pager for a clinic that loses a laptop with patient files

A small clinic's laptop is stolen from a car and the staff do not know whom to tell or what to do first.

~3 hrs🔒 Details