ManageBac Analytics Toolkit

Unlock your
ManageBac data
in minutes

MB Data Explorer turns raw ManageBac records into actionable insights — smart natural-language queries, weighted GPA calculations, and one-click data sync. No terminal needed.

Student Grade Explorer
AL
Alex Liu
A GPA 3.9
SR
Sara Rahman
A GPA 3.8
JK
James Kim
B+ GPA 3.6
MW
Mia Wang
A− GPA 3.7
NLSQL
Natural Language Queries
3×
GPA Weight Layers
1-click
ManageBac Data Sync
0 CLI
No Terminal Required

Core Features

Everything your school data team needs

From raw API data to insight-ready dashboards — MB Data Explorer handles the complexity so you don't have to.

Smart Natural Language Queries

Ask questions like "Grade 11 students with GPA above 3.5 this semester" and get instant results — no SQL required. Powered by DeepSeek / OpenAI.

Weighted GPA Calculation Engine

Three-layer weighting: base GPA mapping, course level bonus (HL/SL), and subject-specific multipliers. Fully configurable, no code changes needed.

Student Grade Profiles

Drill into any student's semester grades, subject breakdown, and raw ManageBac data. Two-year trend overview with year-over-year GPA delta.

One-Click ManageBac Sync

Connect your API token and subdomain, then pull students, teachers, classes, grades, and terms in one click. Incremental sync keeps data fresh.

Visual Configuration

Manage GPA mapping tables, weight rules, LLM provider, and ManageBac credentials entirely from the browser — zero code, zero restarts.

Full Calculation Transparency

A dedicated debug view breaks down every GPA calculation step by step — source score, mapped value, weight applied, and final result.

How It Works

Up and running in 3 steps

From zero to insight in under 10 minutes, no prior data engineering experience needed.

1
Connect ManageBac

Open /config.html, enter your ManageBac subdomain and API token. Credentials are stored securely in a local SQLite database — never sent to third parties.

/config.html → ManageBac Data
2
Sync & Configure GPA

Click "Download All Data" to pull records from ManageBac. Then customise your GPA mapping table and subject weights in the visual config panel.

One-click sync + auto GPA snapshot
3
Query & Explore

Use the natural language search bar on the home page — type a question in plain English, get instant results. Click any student to see full grade history.

"Show me Grade 12 with GPA ≥ 3.7"

GPA Formula

Weighted GPA Engine

GPA =
  Σ(baseGPA  × levelWeight  × subjectWeight)
  ─────────────────────────
  Σ(levelWeight  × subjectWeight)

GPA Engine

Three layers of precision

Every school weighs grades differently. MB Data Explorer's GPA engine gives you full control through a configurable, transparent formula.

Base GPA Mapping

Map letter grades (A, B+, C…) or numerical scores to GPA point values. Supports both grading systems simultaneously.

Course Level Bonus

Apply multipliers based on course level — HL courses can carry a higher weight than SL, Standard, or Core courses.

Subject-Specific Weights

Override weights for individual subjects — Math, English, or any core subject can carry independent multipliers separate from the level bonus.

Full Audit Trail

The debug view shows every input value, applied weight, and intermediate result for complete transparency and easy troubleshooting.

Technology

Built on proven, lightweight tech

No heavy infrastructure. Runs locally on any machine — just npm install and you're ready.

Node.js + Express SQLite 3 Vanilla JavaScript DeepSeek / OpenAI ManageBac REST API HTML5 + CSS3
Terminal
# Clone and install
$ git clone https://github.com/faria-edu/mb-data-explorer
$ cd mb-data-explorer && npm install
# Start the app
$ npm start
✓ Server running on http://localhost:3000

Ready to explore your school data?

Set up takes less than 10 minutes. Your data stays local, always.