Find a course you'll use.

Here is a made-up sales table. The total is 125, and Tea accounts for 100. If your report gives another answer, fix that before choosing a chart.

With headers in row 1, put this in an empty Excel cell:

=SUMIF(A2:A4,"Tea",B2:B4)

In SQL, group the rows by product:

SELECT product, SUM(sales) AS total
FROM sales
GROUP BY product;

COUNT(*) would count sales rows instead of adding their values. Change the last 60 to 70. Tea should become 110 and the whole table 135.

Save these four lines as sales.csv. Put the Python script beside that file and run it with Python 3.

Product,Sales
Tea,40
Coffee,25
Tea,60

It should print 100. Change the final Tea sale from 60 to 70, save the CSV, then run it again. You should get 110.

If the answer stays the same, check which file you saved. A blank or non-number in Sales will cause an error here. Do not replace an unknown amount with zero just to make an error disappear.

import csv

with open("sales.csv", newline="", encoding="utf-8") as source:
    rows = list(csv.DictReader(source))

tea_total = sum(
    int(row["Sales"]) for row in rows
    if row["Product"] == "Tea"
)
print(tea_total)

Try these made-up notes in an assistant you already use:

Sam will send the draft on Thursday. The budget is still waiting for approval. We need someone to check the figures.

Ask it to list each action, its owner and its due date, using only the notes. Tell it to write not stated for missing information.

What the answer should preserve

Sam owns the draft, due Thursday. There is no named owner or deadline for checking the figures. Budget approval is still pending.

If the answer assigns Sam the figures or invents an approval date, correct it against the notes. Rewriting the request is useful only if you also check the next result.

Keep customer and employee details out of a tool unless your organisation has approved it. There is no need for private data in this exercise.

Use this made-up event: film night, community room, 7 pm, free entry. Put the event name first, then the details someone needs to turn up.

Use one font to start. Make the title larger, keep the details together and give the text some space. Add a photo only if it helps the event make sense.

Export it, open it on your phone and view it without zooming. Can you find the place and time? If you have to hunt for either, change the size or position before adding decoration.