How to Detect AI Cheating in a Business Analyst SQL/Excel Test
Business analyst skills tests typically cover SQL joins, pivot-table construction, and requirements-mapping short answers. AI cheating shows up as instantly-perfect queries or formulas pasted from Copilot/ChatGPT rather than built step by step. Neuroxa's Browser Proctoring logs paste events and tab switches during the timed test.
| Threat Model | Observable Tell | Confidence |
|---|---|---|
| Query/formula pasted whole from an AI assistant | Paste event with no incremental keystroke history | High |
| Tab switch to ChatGPT or a SQL-help site mid-test | Tab-focus-loss logged with no declared reference material | High |
| Excel Copilot auto-completing pivot-table formulas | Formula syntax inconsistent with the candidate's earlier manual entries | Medium |
| Webcam shows repeated glances to a second device | Gaze/attention flag at consistent intervals correlating with answer jumps | Medium-High |
Interviewer script (test instructions): "This test is browser-locked — please stay on this tab with no AI tools or external help. Use the built-in hint if you're stuck on syntax." Review the paste and tab-switch timeline against the candidate's final answers before scoring.
Evidence to capture:
- Keystroke and paste-event log per question
- Tab/window-focus change timestamps
- Webcam snapshot at flagged events
- Time-per-question vs. cohort baseline
- Query/formula pattern comparison against known AI-generated solutions
Neuroxa product: Browser Proctoring — tab-lock, paste-event logging, and webcam capture for SQL/Excel skills assessments.
FAQs
Isn't pasting normal if a candidate wrote the query elsewhere first? Neuroxa flags paste-without-keystroke-history as a signal for review, not an automatic fail — reviewers see the full context before deciding.
What if Excel's own AI features trigger a false flag? Disable Copilot/Ideas in the test environment ahead of time and disclose that policy to candidates.
What if the candidate has two monitors for legitimate reasons? Browser Proctoring flags focus loss regardless of monitor count — a declared reference doc is fine; an undeclared AI chat window is not.
Should we combine this with a live interview round? Yes — a short live walkthrough of the candidate's query logic is the fastest way to confirm genuine understanding.
Related: Business Analyst Async Video Interview · Business Analyst Take-Home Assignment · Data Analyst SQL/Excel Test · Data Engineer SQL/Excel Test
Lock down skills tests with Neuroxa.ai Browser Proctoring.