Projectscompetency-analytics-assistant
Education Analytics / Desktop App

Assistant d'Analyse des Compétences

A local-first analytics assistant for teachers to import Excel competency reports, analyze class and student performance, identify strongest and weakest competencies, and generate printable reports with French/Arabic support.

ReactTypeScriptViteElectronRechartsExcel importi18nlocalStorageGitHub Actions
View GitHubLive Demo: Coming soonDesktop Release: Coming soon
Assistant d'Analyse des Competences analytics dashboard screenshot with Excel import and class competency reporting

GitHub

Repository available

Source code and project documentation

Live Demo

Coming soon

Desktop Release

Coming soon

CI / build

GitHub Actions CI configured

Problem

What needed to be solved

Teachers often receive competency results in Excel reports, but manually checking scores, calculating averages, comparing students, and finding competencies that need intervention can be slow and error-prone.

Solution

How the project approaches it

I rebuilt the project as a local-first desktop analytics assistant with Excel competency report import, score validation, class and student statistics, competency-level analysis, strongest and weakest competency detection, support priority indicators, Recharts dashboards, French/Arabic internationalization, printable report views, localStorage persistence, Electron packaging, and GitHub Actions CI.

Key features

What the project includes

Excel competency report import
Student, class, and competency statistics
Strongest and weakest competency detection
Support priority and intervention indicators
Recharts-based dashboards
Printable reports
French/Arabic internationalization
Local-first student data storage
Electron desktop packaging
GitHub Actions CI

Architecture / Technical decisions

Implementation choices worth reviewing

Kept student data local by using an Electron desktop workflow and localStorage persistence instead of a remote backend.
Built the analytics flow around Excel import validation, class/student/competency statistics, and Recharts visualizations.
Added French/Arabic i18n and printable reports so the tool fits teacher review and reporting workflows.

Validation / Quality

How I made the work reviewable

Excel import validation and score checks
Local-first data handling for student records
Printable reports for manual review
GitHub Actions CI listed in the project scope

What I learned

Technical takeaway

I learned to turn spreadsheet-based classroom data into reliable local analytics, with validation, clear indicators, bilingual UI support, and printable outputs that help teachers act on results without exposing student data to a remote service.