Chatbots answer. Atelo teaches.
The same request went to the top AI models and to Atelo. Their replies, unedited.Read every reply
An Excel user who has never coded
“I am a Excel user and want to be able to program VBA but I have never coded before …”
A top AI model
799 words to read.
atelo.
5 steps to do.
A top AI modelits whole reply, unedited
799 words
Your first VBA sitting: count values above a limit
Today’s task: plan the calculation, predict the result for 5, 15 and 25 above 20, change only the limit in a supplied program, then explain the result.
We’ll use the starter program below. You do not need to write it from scratch or learn every VBA command today.
1. Plan before coding
“Above 20” means strictly greater than 20. In VBA, the symbol for “greater than” is >.
Imagine checking the three values one at a time. Write a short plan in ordinary English:
- What should the count start at?
- What question should you ask about each value?
- When should you increase the count?
No VBA needed yet—this is the thinking that comes before programming.
2. Predict before running
Complete this table without using Excel:
| Value being checked | Is it greater than 20? | Count after checking this value |
|---|---|---|
| 5 | ___ | ___ |
| 15 | ___ | ___ |
| 25 | ___ | ___ |
My predicted final count is: ___
Keep your prediction so you can compare it with the program’s result.
3. Read the supplied program
VBASub CountAboveLimit() Dim limit As Long Dim count As Long Dim number As Variant limit = 10 count = 0 For Each number In Array(5, 15, 25) If number > limit Then count = count + 1 End If Next number MsgBox countEnd Sub
Here are the parts you need to understand today:
| VBA | Plain English |
|---|---|
limit | A named place holding the cutoff value. |
count | A named place holding the running total. |
Dim ... | Declares the variables the program will use. Leave these lines unchanged. |
For Each number In Array(5, 15, 25) | Take each of these three numbers in turn. |
If number > limit Then | Do the following action only if this number is above the limit. |
count = count + 1 | Take the current count, add one, and store the new count. |
Next number | Move on to the next number. |
MsgBox count | Display the final count in a message box. |
Important difference from Excel formulas: in this VBA program, = assigns a value. So count = count + 1 is an instruction to update the count—not a claim that two quantities are equal.
4. Change only the limit, then run
Use desktop Excel; VBA does not run in Excel for the web. This program displays a message and does not alter any worksheet cells.
- Open a blank workbook.
- Open Developer → Visual Basic. If Developer is hidden, enable it in Excel’s ribbon settings.
- In the VBA editor, choose Insert → Module.
- Paste the supplied program into the module.
- Make the program use 20 as its limit. Change only the value assigned on the
limit = 10line. Leave the numbers, comparison symbol and all other lines unchanged. - Click inside the program, then choose Run → Run Sub/UserForm.
If you want to keep the program, save the workbook as an Excel Macro-Enabled Workbook (.xlsm).
Record your results:
- The single line I changed:
___ - The displayed count: ___
- Does it match my prediction? ___
5. Explain—not just report
Write two or three sentences explaining the result. Include:
- Whether each of 5, 15 and 25 passes the test.
- When
count = count + 1runs. - How that produces the final count.
Knowing the displayed number is not enough: the goal is to understand why the program produces it.
Your turn: reply with your plan, completed prediction table, the single line you changed, and your explanation. Try the exercise before checking the answer key.
(After the learner attempts the exercises:)
1. A suitable plan
- Start the count at zero.
- Check each of 5, 15 and 25 to see whether it is greater than 20.
- Add one to the count only when the answer is yes. After all three checks, display the count.
Your wording can differ; those are the essential steps.
2. Prediction
| Value being checked | Is it greater than 20? | Count after checking this value |
|---|---|---|
| 5 | No | 0 |
| 15 | No | 0 |
| 25 | Yes | 1 |
Predicted final count: 1.
3. The only changed line
Pythonlimit = 20
Everything else stays exactly as supplied.
4. Why the answer is one
The count starts at 0. Neither 5 nor 15 is greater than 20, so the program skips count = count + 1 for both values. 25 is greater than 20, so that instruction runs once, changing the count from 0 to 1. The message box therefore displays 1.
The program counts qualifying values; it does not add their values together.
Feedback
- Correct result and explanation: you have used variables, a comparison, a condition, a loop and a counter in one small program.
- If the result is 2: check whether the limit is still
10. With that limit, both 15 and 25 qualify. - If you changed other lines: restore the supplied program and change only the limit. The point of this exercise is to see how one controlled change affects the result.
Atelolesson one, every step
Lesson 1Change the limit and make your first check work
Change it
Change only limit = 10 to limit = 20.
limit
amountsabove 20 count
It works.Real output
Rows above 20: 1
Setting limit, the value each amount is compared with, to 20 changes which amounts count.
Step through
Step through the amounts and watch when the count changes.
After the loop finishes, show the limit and the completed count.
Beat 5 of 5Prints
Rows above 20: 1
Predict
Predict what this prints when one amount equals the limit.
Compare each amount with limit before following the indented update.
What does it print? Rows above 20: ?
Right. The > comparison excludes the amount equal to limit, and each accepted amount adds one to count.
Spot the bug
Find the line that loses the earlier matching row.
Found it. Assigning 1 replaces the previous count at every match, whereas adding one preserves the match already counted. The fix: count = count + 1
Run with the fixReal output
Rows above 20: 2
Before the fix: Rows above 20: 1
Write it
Write the decision and the matching-row update.
- Keep
amounts = [5, 15, 25]andlimit = 20while completing the loop body. - Replace the loop's comment and
passwith your own comparison and count update.
It works.Real output
Rows above 20: 1
Your two indented lines turn each amount's decision into a running count that remembers earlier matches.
Every other way to learn has a catch. Atelo doesn’t.
A chatbot
It answers. It never teaches.
A wall of text. Nothing to try. No idea if you got it.
A video course
One pace for everyone.
The same videos, whatever you already know.
A private tutor
Brilliant. And rationed.
Expensive, an hour a week, and booked up.
atelo.
All of it. Every hour.
- Plans your course with you, from your files
- Runs your code. Knows what you understand.
- A fraction of a tutor’s price
Bring your own. Atelo reads every line.
A repo, a spec, a query. Atelo finds what matters, bugs included, then builds your course on it.
microblog-a975ef6.zipA zipped codebase
config.py
9SECRET_KEY = os.environ.get('SECRET_KEY') or 'you-will-never-guess'Atelo found
Without SECRET_KEY set, password-reset tokens are signed with a key anyone can read.
RFC 7519, JSON Web TokenA spec, by link
section 4.1.4
The "exp" (expiration time) claim identifies the expiration time on or after which the JWT MUST NOT be accepted for processing.
Atelo found
A token is already expired at its exp second, not a moment after.
query.sqlA query, pasted in their post
3FROM SpendsPremissions LEFT JOIN AdditionPermissions ON (SpendsPremissions.ItemName = AdditionPermissions.ItemName) AND (SpendsPremissions.SpendsDate = AdditionPermissions.AdditionDate)Atelo found
The JOIN repeats spend rows whenever two additions match, so the total quantity comes out inflated.
Ada plans it with you.
Ada, your AI tutor, reads your words, your files and your level, then plans a course for you alone.
What you wrote
Ada’s plan
“I am excellent at campaign strategy (key objectives, budgeting, targeting, etc) but suck at data analysis.”
Where it startsStart with a budget decision
“I’d like to learn Data Analysis for Marketing from scratch”
Where it takes youTurn campaign results into better marketing decisions
“I would also like to have a side project where I could practice my theoretical knowledge side by side.”
What you buildCampaign performance report
AdaA campaign performance report is my recommended side project because it connects directly to the strategy and budgeting work you already do.
Your skill checkSix answers were all I needed.
- You summed amounts within each group.
- Not shown yet: counting every order in each pair.
campaigns-april.csvYour file: 12 rows, 7 columns
import pandas as pd campaigns = pd.read_csv('campaigns-april.csv')print(f'{len(campaigns)} rows, {len(campaigns.columns)} headings')print(campaigns.head(4))print('Missing entries:')print(campaigns[['spend', 'signups']].isna().sum())What it printed
12 rows, 7 headings
| date | campaign | channel | ... | impressions | clicks | signups | |
|---|---|---|---|---|---|---|---|
| 0 | 2026-04-01 | Spring Launch | Paid Social | ... | 51230 | 1180 | 64.0 |
| 1 | 2026-04-01 | Brand Search | Search | ... | 18400 | 1460 | 97.0 |
| 2 | 2026-04-02 | Spring Launch | Paid Social | ... | 49870 | 1102 | 58.0 |
| 3 | 2026-04-02 | Newsletter Promo | ... | 12800 | 640 | 41.0 |
[4 rows x 7 columns]
Missing entries:
| spend | 1 |
| signups | 1 |
dtype: int64
See what your code is really doing.
We killed the passive course. No videos, no walls of text.
JavaScriptLine 3
What the program holds
one object
state.rewardClaimed is false, so line 4 runs next.
JavaScriptLine 4
What the program holds
one object
state.score goes from 0 to 10.
JavaScriptLine 5
What the program holds
one object
state.rewardClaimed goes from false to true.
JavaScriptLine 7
What the program holds
one object
claimReward hands back the same object it was given.
JavaScriptLine 26
What the program holds
one object
game.score goes from 0 to 10 and game.rewardClaimed goes from false to true. afterFirst is now { score: 10, rewardClaimed: true }.
The program you just finished, with lines 3 to 5 written three ways. One works. Two are slips a learner could make.
Version 1Works
if (!state.rewardClaimed) { state.score += 10; state.rewardClaimed = true; }After second claim:score10rewardClaimedtrueVersion 2A slip
if (true) { state.score += 10; state.rewardClaimed = true; }After second claim:score20rewardClaimedtrueVersion 3A slip
if (!state.rewardClaimed) { state.score += 10; state.rewardClaimed = false; }After second claim:score20rewardClaimedfalseIn version 2, you are paying again even after the object remembers that this reward was claimed. In version 3, you are paying the reward but leaving the object saying it has not been claimed.
It printed the row with no rating
ratings one column per platform
melt turns each platform’s column into rows
long one row per month and platform
Anything technical. Any size.
One question gets one lesson. A new career gets a whole course.
Real questions, posted online
I wish to learn about Postgres and applying it to Python. … Chatgpt doesn't give the best lessons
Posted on Hacker News, January 2025
Postgres that works with your PythonA course: 6 modules, 21 lessons
Lesson oneReceive notebook stock without losing the existing balance
PostgreSQLReal output
Lines 1 to 4 set up the stock table
It returned
| item | quantity |
|---|---|
| notebook | 3 |
The 10 already in stock is gone. Lesson one has you repair it.
But every time I sit down and try to make something from my own head, I can’t get the code to do what I want it to.
Posted on the freeCodeCamp forum, January 2023
Make JavaScript do what you have in your headA course: 4 modules, 9 lessons
Lesson oneCollect the key you meant to collect
JavaScriptReal output
It printed
First: {"item":null,"bag":["key"],"message":"You take the key."}
Second: {"item":null,"bag":["key"],"message":"There is no key here to collect."}
Original: {"item":"key","bag":["key"],"message":""}The original start now has the key too. Lesson one has you keep it unchanged.
As someone with zero coding background, I never imagined I could build my own personal website
Posted on the Cursor forum, June 2025
Build a personal page with code you can checkA course: 3 modules, 8 lessons
Lesson oneMake your first personal page with words you can change
HTML and CSSLive page
The page it builds
I have been tasked with getting traffic from AWS, to a colo, and out through a private link to a third party. I am a bit out of my depth here.
Posted on Hacker News, June 2021
Get AWS traffic through your colo to the third partyA course: 5 modules
Lesson oneFind the missing reply path
Python, tracing the routesReal output
It printed
10 lines before, the last 4:
REPLY third-party-api 10.80.10.20 -> third-party-edge via gateway 10.80.10.1 third-party-edge: STOP, no route for 10.20.1.10
Runs live in the lesson
- Python
- JavaScript
- TypeScript
- SQL
- PostgreSQL
- Web pages
- Django
- FastAPI
- Go
- Java
- C++
Your course doesn’t exist yet. Ask for it.
A chatbot gave a first-time coder 799 words to read. Atelo gave them a program that works.
Start with 5 free credits. No card needed.
Ada’s plan for SQL for a data analyst job4 modules, 14 lessons
Answer business questions with SQL
- Start with a business question
- Combine tables without misleading totals
- Build readable business reports
- Check and explain your reporting pack
Ada’s plan for Postgres for my Python app6 modules, 21 lessons
Postgres that works with your Python
- Catch and repair a receipt that loses stock
- Make the database enforce your inventory rules
- Build reports you can trust
- Make Python and PostgreSQL talk
- Keep every sale all or nothing
- Finish your program and defend its index
Ada’s plan for Data analysis for marketing4 modules, 16 lessons
Turn campaign results into better marketing decisions
- Start with a budget decision
- Make the results trustworthy
- Find where performance differs
- Turn the report into a recommendation