I asked ChatGPT who my weakest student is. It did not guess.

Confession: my relationship with spreadsheets is like my relationship with the gym. I know it is good for me. I open it in January. Then I stop.

So when the team switched on the Mocxam AI connector, I did what any responsible growth person would do. I skipped the documentation, opened ChatGPT, and started asking our demo coaching centre rude questions about its students. The demo centre is full of pretend students, which is the only reason I am allowed to write this.

Here are five questions, what actually happened, and the bits that surprised me.

Question 1: "Which centre am I connected to?"

Boring, I know. But this is the question you should always ask first, because it calls get_my_centre and tells you the centre, the plan and who you are signed in as. If you have two logins at two institutes, this is how you find out you are about to analyse the wrong one. Ask me how I know. Actually, do not.

Question 2: "List my batches"

This calls list_batches and returns each batch with how many students it has and how many took a test in the last 30 days. It is the AI equivalent of walking into the staff room and asking "who is actually showing up?" Except nobody gets defensive.

Question 3: "Who are my best students this month?"

My first surprise. It did not just hand me a list. It told me some students had been left out because they took fewer than three tests in the window. That is the default rule, and it is a good one: otherwise the student who took one easy test and vanished would be crowned topper. We have all met that student. Some of us were that student.

Question 4: "Who is my weakest student in English?"

The headline question. I expected ChatGPT to confidently invent someone. Instead it called students_needing_attention with the section set to English, and Mocxam came back with students flagged for specific reasons: accuracy well below the centre average, scores falling, skipping questions they could have attempted, or simply not taking tests. Then ChatGPT explained each reason in normal human words.

The AI did not guess. Mocxam did the maths; ChatGPT did the talking.

This is the bit that actually matters. ChatGPT is a brilliant writer and a nervous accountant. With the connector, it never has to add anything up. The numbers come from our server; the AI just makes them readable.

Question 5: "Write 10 English questions for SSC CGL Tier 1 on error spotting"

The flex. The AI checked the exam blueprint with get_exam_blueprint, looked at what was already in the bank, wrote ten questions with four options, one answer and an explanation each, and saved them with create_questions. They show up in the question bank under the right section. Students do not see them until a teacher puts them in a mock, which is good, because I would like a teacher to check my AI's grammar questions before 200 students do.

Pro tip: add "solve each question again before saving and tell me if any answer changes". It catches the occasional overconfident answer key.

Things it will not do (and I tried)

• It will not show another institute's data. The institute comes from your login, and no amount of "pretty please" in the prompt changes that.
• It will not delete anything. You can add questions; you cannot nuke the bank at 2 a.m.
• It will not change your logo or domain. Branding colours and text, yes, with a preview first. Identity stuff stays in the console.
• It will not tell you why Rahul stopped coming to class. That is still your job. Sorry.

The small print, without the small font

Free ChatGPT accounts cannot add custom connectors yet, so if you are on free ChatGPT, use Claude, whose free plan allows one custom connector. Paid ChatGPT works through Developer Mode. The connector is on Academy Pro and above. Setup guides are here for Claude and ChatGPT, and if you want more questions to steal, the prompt library has about twenty.

Anyway. I still do not like spreadsheets. I just do not need to open them any more.