APAI Praveen
← All projects
FISHERIES & SEAFOODSTARTER~1.5 hrsFREE SAMPLE

Keep a two-week price diary for five fish at one Goan market

Fish prices at Panjim, Margao and village markets change every morning, but most buyers only remember that fish has become costly, not when or why.

WHAT YOU HAND IN

A two-week sheet of daily prices for five fish at one market, a line chart, and a half-page note on which fish moved most and two possible reasons.

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

You are recording what five fish actually cost at one market over two weeks, then explaining the sharpest change. The point is to see how prices really move, not to guess at a trend from one visit or a news story.

ANSWER THESE BEFORE YOU OPEN ANY AI TOOL
  • Which market and which single vendor will you visit, and at what time of the morning?
  • In what unit does the vendor quote each fish, and will that stay the same every day?
  • What else will you write down each visit: weather, sea conditions, festivals, how full the stall looked?
  • How will you tell a real price change from the vendor simply giving you a different size of fish?
WHAT GOOD LOOKS LIKE

A clean table with one row per visit, a column per fish, the unit in each header, a short notes column, a line chart, and a half-page note that names the fish that moved most and two reasons you checked with a person.

THE COMMON WRONG TURN

Visiting different stalls or at different times and treating every gap as a price swing. A late-morning price is often lower because the vendor wants to clear stock, so keep the time and the vendor fixed.

Gather

COLLECT
  • Your own price notes from each visit, written on the spot
  • The vendor's answer to one question each visit: is today's catch more or less than usual?
  • Notes on weather and sea conditions, from what you saw or a public weather forecast
WHAT AI MUST NOT MAKE UP

AI must not fill gaps in your diary or suggest typical prices. If you missed a day, leave the cell blank and say so in the notes.

Build with AI

  1. 3.1 Set up the diary tableGOOGLE SHEETS

    Why this tool: A fixed table makes every visit comparable and makes gaps visible.

    Columns: date, time, weather, one column per fish with the unit in the header, and notes. Freeze the header row and enter prices the same day you visit.

  2. 3.2 Find the widest swingGOOGLE SHEETS

    Why this tool: Working out the change in the sheet keeps the numbers checkable.

    For each fish, add rows for the lowest and highest price you saw and the gap between them. Draw a line chart with one line per fish.

  3. 3.3 List possible reasonsCLAUDE CHAT

    Why this tool: Claude can suggest reasons you had not thought of, which become questions for the vendor.

    Paste the table and your notes. Ask for possible reasons and questions, then take the questions back to the market.

    Prompt to copy · fill in the [brackets]
    Here is my two-week price diary for five fish at one market in [market name]:
    [paste the table with notes]
    The fish whose price moved most was [fish]. Suggest four possible reasons, using my notes on weather and catch where you can. For each reason, give me one simple question I could ask the vendor to check it. Do not state any reason as fact.
  4. 3.4 Draft and tighten the noteCLAUDE CHAT

    Why this tool: A second pass helps you cut your note to what the evidence supports.

    Write the note yourself first, then ask Claude to mark any sentence that claims more than your diary shows.

    Prompt to copy · fill in the [brackets]
    Below is my half-page note on fish prices at [market name] and the diary it is based on. Mark every sentence that claims more than the diary or the vendor's answers support, and suggest a softer wording for each.
    Note: [paste your note]
    Diary: [paste the table]

Check the AI's work

  • Every price in the sheet came from your own visit, with the unit stated
  • The widest swing figure matches a recount of the lowest and highest values
  • Each reason in the note was checked with the vendor or marked as a guess
  • Blank days are shown as blank, not filled with an average
  • Recompute two numbers by hand
  • Check the row count before and after cleaning
WHAT AI USUALLY GETS WRONG HERE

AI tends to blame every price jump on the monsoon or fuel costs. Check whether your swing happened on a calm, ordinary day, in which case the reason is probably local, such as a small catch or a festival.

Finish and show

DONE WHEN
  • A two-week diary table with units and notes
  • A line chart with one line per fish
  • A row showing the lowest, highest and gap for each fish
  • A half-page note with two checked reasons
HOW TO PRESENT IT

Put the chart at the top, the note beneath it, and the full table on a second page. Circle the day of the widest swing on the chart.

FOR YOUR PORTFOLIO

Say which fish surprised you, what the vendor told you about why, and how you would repeat the diary in the monsoon season.

Which tool fits

  • Google Sheets (free alternative): A fixed table makes every visit comparable and makes gaps visible.
    Free with a Google account.
  • Claude chat: Claude can suggest reasons you had not thought of, which become questions for the vendor.
    Free plan works; Pro gives longer conversations.
  • Claude for Excel: building and explaining formulas inside your workbook
    Paid plans; needs Excel.
LEVEL UP

Run the same diary at a second market on the same days and compare whether prices move together, then write what that suggests about where the fish come from.

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 starter projects in Fisheries & seafood
FISHERIES & SEAFOODSTARTER
Survey the dried fish products on local shop shelves

Dried fish, from bombil to prawns, is a staple and a gift item, but small producers sell it in very different packs, sizes and labels.

~1.5 hrs🔒 Details
FISHERIES & SEAFOODSTARTER
Write a question card a restaurant can use with its fish supplier

Restaurants that want to serve responsibly sourced fish often do not know what to ask their supplier about where, how and when the fish was caught.

~60 min🔒 Details
FISHERIES & SEAFOODSTARTER
Build a hygiene observation checklist for a village fish market

Fish markets need clean water, ice, drainage and waste removal, but there is rarely a simple way for a student or a market committee to record how a market is doing.

~75 min🔒 Details