All materials

Starter files

Files to practise with

Real-looking data you can open, change and ask AI about, without sharing anything of your own. The numbers are made up.

Kit

Open the sales log in a spreadsheet first. Then try the notebook: it reads the same file and draws two charts.

The files

  • Small-shop sales log

    sales-log.csv · 145 rows

    One month of sales from an invented drinks and snacks shop: date, product, group, quantity, unit price, total and how the customer paid.

    Columns: date, weekday, product, category, quantity, unit_price_vnd, total_vnd, payment

    How to open it: Excel: File, Open. Google Sheets: File, Import, Upload. Numbers are in Vietnamese dong.

    Try with AI: Paste the rows into a chatbot and ask: "Which three products earned the most this month, and on which weekday do I sell the most?" Then check one answer yourself with a filter or SUM.

  • Monthly family budget

    monthly-budget.csv · 11 rows

    Spending groups with a planned and an actual amount. The last column works out the difference for you when you open it in a spreadsheet.

    Columns: category, planned_vnd, actual_vnd, difference_vnd

    How to open it: Excel or Google Sheets. Change the amounts to yours; the difference column updates itself.

    Try with AI: Ask a chatbot: "Here is my budget. Where did I spend more than planned, and suggest two small changes for next month." Keep account numbers out of it.

  • Sales charts notebook (Python)

    sales-charts.ipynb

    A Jupyter notebook with short explanations between the steps: it loads the sales log, adds up sales by day and by product, and draws a line chart and a bar chart.

    How to open it: Upload it to Google Colab (colab.research.google.com, File, Upload notebook) or open it in Jupyter. Then upload the sales CSV too, or let the notebook download it.

    Try with AI: Stuck on a line of code? Paste that one cell into a chatbot and ask it to explain it in plain words, line by line.

These files hold made-up data, so they are safe to paste into a chatbot. With your own shop's or family's numbers, remove names, phone numbers and account numbers first.