System Description

AMTOS

Aviation Maintenance Training & Operations System

A product by Aggregator Solutions

ASP.NET MVC · DevExpress · Entity Framework · SQL Server · Cloud Hosted

Presentation Overview

What We'll Cover

Short Stop — Slides 1–16
01TitleAMTOS System Description
03System Architecture3-tier: Browser→IIS→SQL
04Role-Based AccessConcentric permission model
05Personnel & Access MgmtStep 01
06Training TracksStep 02 · tree diagram
07Course CatalogueStep 03 · grading parts
08Student RegistrationStep 04 · profile anatomy
09EnrolmentStep 05 · funnel flow
10Class SchedulingStep 06 · Gantt + holidays
11Exams & Question BankStep 07 · lifecycle flow
12Attendance RecordingStep 08 · pivot heatmap
13Results PublishingStep 09 · review workflow
14Practical AssessmentStep 10 · P1–P9 matrix
15Dashboards & BIStep 11 · KPI gauges
16Reports & EASA Form 148Step 12 · CoR wireframe
Short stop here✋ Slide 16
Full Stop — Slides 17–27
17Exam Deep DiveMCQ vs Essay, randomisation
183-Level Q TaxonomyModule→Sub→Sub-sub
19Item AnalysisDiscrimination index, distractors
20Data Security & AccessASP.NET Identity, OWIN
21Import / ExportExcel, ICS, CSV, PDF
22Report Designer stored procs
23Theming & Dark ModeUser-level preferences
24Full Tech StackAll 11 badges detailed
25Deployment & HostingIIS, SQL Server, cloud
26Integration PointsICS, Excel import, PDF
27Contact / Next Steps✋ Full stop

System Architecture

Three-Tier Web Application

ASP.NET MVC server-side rendering via Razor, DevExpress component suite for grids, schedulers and PDF reports, Entity Framework Code-First ORM, SQL Server persistence. Hosted on Windows IIS.

BrowserChrome · Edge · Safari
IIS / ASP.NET MVCRazor · DevExpress · Identity
Entity FrameworkCode-First ORM
SQL Serveramtos.aggregatorsolutions.com
ASP.NET MVC 5DevExpress v25.1 Entity Framework 6SQL Server ASP.NET IdentityOWIN / OAuth

Foundation — Access Control

Role-Based Access Model

Four roles sharing one database. Each role holds a concentric subset of the previous role's permissions — no parallel data stores, no duplication, no conflicting records.

🛡️
Admin
Full system access. Personnel, tracks, scheduling, BI, reports, settings.
📋
Staff
Operational access. Student records, enrolment, attendance, exam oversight, certificates.
📚
Instructor
Class-scoped. Own classes, attendance, exam review, practical assessment.
🤝
Student
Personal portal. Own calendar, exams, results, certificate download.
AMTOS Core DB Admin Staff Instructor Student Each outer role ⊂ inner role permissions
1

Step 01 — Foundation

Personnel & Access Management

Single Personnel record per individual — staff, instructor or student. Each record optionally links to a system login. Role assignment controls every menu, grid and action visible to that user.

Profile & Photo
Full name, nationality, DOB, contact details and profile photo stored per person.
Document Vault
Passport, national ID, medical and custom document types — uploaded and version-tracked.
User Account Creation
Generate a login directly from the personnel record, or link to an existing account.
Role Assignment
Admin / Staff / Instructor / Student roles — control every menu, grid and action.
Account Lock / Unlock
Instantly suspend or re-enable any user's access without deleting their record.
Excel Import
Bulk-import student records from a spreadsheet with optional automatic track assignment.
2

Step 02 — Structure

Training Tracks

A Track is the top-level certification pathway — Cat A, Cat B1.1, Cat B2. Each track bundles courses, carries a total credit value, and when a student is assigned they automatically inherit the full curriculum.

Track Definition
Named pathway with description and credit hours. Full CRUD with audit trail.
Course Assignment
Batch checkbox interface. One course can belong to multiple tracks.
Drill-down View
Popup panel shows every course in a track with module numbers and credit info.
Export
Full tracks list to PDF or Excel WYSIWYG A4 landscape with one click.
Cat B1.1 Track Module 1 Module 2 Module 7 Classes → Classes → Classes →
3

Step 03 — Curriculum

Course Catalogue

Courses are the atomic unit of the curriculum. Each maps to a Part-66 module number, carries its own document library, and may have prerequisites. Grading components are configured independently per course.

Course Library
Title, module number, credit hours, description. Full CRUD with inline grid editing.
Track Membership
Assign to one or many tracks via checkbox panel — reflected immediately system-wide.
Instructor Assignment
Designate qualified instructors per course for scheduler dropdown population.
Document Vault
Syllabus, manuals and references uploaded against a course with title, version and date.
Grading Parts
Weighted components (e.g. Theory Exam 70%, Practical 30%) specific to each course.
Prerequisites
Flag prerequisite courses to guide enrolment decisions and enforce learning sequence.
4

Step 04 — Learners

Student Registration

Students are a specialised type of Personnel record with nationality, regulatory ID data, photo and a personal document vault. Large cohorts load in minutes via Excel bulk import with automatic track assignment.

Rich Profile
Name, DOB, nationality, contact info, status, photo and join date.
ID Documents
Passport, national ID or custom types — tracked with number and expiry.
Excel Bulk Import
Download template, populate, re-upload. Optional track override assigns all students instantly.
Track Assignment
Assign to one or more tracks; mass-enrol into all active track classes in one action.
🤝 NATIONALITY STATUS DOCUMENTS TRACKS ENROLLED Portal Access →
5

Step 05 — Registration

Enrolment

Enrolment bridges students and scheduled classes. Both individual and bulk enrolment are supported. An enrolment-locking mechanism freezes class rosters ahead of an exam period.

Track Enrolment
Assign to a track; mass-enrol into all active classes in one action.
Class Enrolment
Per-class roster management — individual add/remove with bulk select.
Bulk Enrolment
Select multiple students and enrol them all in a class simultaneously.
Enrolment Lock
Lock a class roster — no further changes once exam attempt window opens.
All-Enrolments View
Cross-class overview filterable by course, instructor and date range.
Status Tracking
Enrolment status (active, withdrawn) tracked per student per class — full history.
6

Step 06 — Timetabling

Class Scheduling & Calendar

Visual drag-and-drop scheduler for planning the entire training calendar. Classes carry start/end dates, facility, instructor and enrolled roster. Country-specific holiday calendars prevent accidental scheduling on rest days.

Visual Scheduler
Drag-and-drop. Day, week and month views. Filter by instructor or class group.
Holiday Calendars & Overrides
Country-specific public holiday lists. Individual classes can override default holiday rules for make-up sessions.
Facility Booking & Capacity Check
Assign classes to rooms and facilities; manage name, type and capacity. System warns when enrolled student count exceeds the facility limit at planning time.
⚡ Auto-Schedule Wizard
3-step wizard calculates class end date from course contact hours, session times, and holidays. Validates hours and highlights reshuffles.
Exam Scheduler
Dedicated exam scheduling view separate from regular class timetable.
ICS Import
Import external calendar events (ICS) from Outlook or Google Calendar.
CLASS SCHEDULE Module 1 Module 2 Module 7B P-Workshop Holiday Today Jan Feb Mar Apr May Classes visualised on timeline with holiday and today markers
7

Step 07 — Assessment

Exams & Question Bank

Full question-bank authoring with two-stage approval workflow. MCQ exams delivered online and auto-graded instantly. Essay exams accept PDF upload within a defined submission window. Questions support images on both the question and individual answer options.

Question Bank
Author MCQ with up to four illustrated answers. Module-tagged for accurate exam assignment.
Approval Workflow
Draft → Approved two-stage workflow. Only approved questions appear in live exams.
Random or Fixed Sets
Same questions for all students, or random selection per student to prevent sharing.
Essay Exams
Configurable open/close windows. Students upload PDF; admin reviews and grades.
3-Level Taxonomy
Module → Submodule → Sub-submodule, mirroring the EASA Part-66 syllabus.
Pass Threshold
≥ 75% pass. Results held until instructor explicitly releases to students.
Q Bank Draft Q Approved ✓ Exam Created Student Takes Exam Auto-Graded ≥ 75% Verified Instructor Review Results Released
8

Step 08 — Presence

Attendance Recording

Attendance recorded at class-session level for every enrolled student. Presented as a pivot table — students on one axis, dates on the other — so absence patterns are immediately visible. Data feeds directly into CoR certificate hours.

Session-Level Recording
Mark present or absent per session. One click toggles; saves instantly.
Pivot Heatmap
Green/red colour-coded grid — scan the whole class at a glance.
Instructor View
Scoped to own classes only. Toggle attendance inline without admin involvement.
CoR Hours Feed
Attendance data feeds directly into the Certificate of Recognition hours section.
Period Filtering
Filter by week, month or custom date range. Switch class via dropdown.
KPI Gauge
Attendance rate % surfaces as a live KPI gauge on the admin homepage.

Attendance Pivot — Students × Sessions

Present Absent
9

Step 09 — Verification

Exam Review & Results Publishing

Before results reach students, an instructor or administrator reviews each attempt question by question. Individual questions can be excluded/awarded for one student or system-wide. A release-summary screen confirms pass/fail counts before results are published.

Attempt Review
Full walkthrough: each question with student's answer versus correct answer.
Question Exclusion/Awarding
Exclude/Award for one student or all students adjusting overall scores.
Pass / Fail Summary
Pre-release summary shows pass count, fail count and overall class performance.
Results Release
One-click release makes results visible in student portal. Can be reverted if needed.
Essay Grading
Open submitted PDFs, score them and release marks — same workflow as MCQ.
Item Analysis
Per-question stats: correct-answer rate, most-selected distractor, discrimination index.
Admin & Staff Results Viewer
Dedicated cross-class exam results viewer for Admin and Staff roles — browse any student's attempt, cancel questions, and monitor pass/fail outcomes across all classes, unrestricted by instructor scope.
Flagged Exam Questions
Automatically flags underperforming questions (< 50% correct) for Admin review. Instructors cannot publish results until all pending flags are resolved via the Admin Dashboard.
10

Step 10 — Hands-On

Practical Assessment

Workshop practical skills (P1–P9) assessed against defined criteria per module. Instructor creates a Practical Exam linked to a class, then opens individual student attempts and scores each criterion live. Held in draft until deliberately released.

Module Definitions
Configure P1–P9 — title, description, category (Cat A / Cat B).
Assessment Criteria
Detailed pass/fail or scored criteria per module; reusable across instances.
Live Scoring
Score each criterion per student in real-time with notes and observations.
Controlled Release
Results held privately until explicitly released. Same workflow as theory exams.

Assessment Matrix — Modules × Criteria

C1 C2 C3 C4 C5 P1 P2 P3 P4 P5 Pass Fail Pending
11

Step 11 — Insight

Dashboards & Business Intelligence

Every role has a personalised dashboard. The admin homepage surfaces live KPI gauges drawn from the database in real time. A full BI Dashboard Designer lets administrators build and publish rich interactive dashboards without code.

Live KPI Gauges
Total Students, Portal Access count, Enrolments, Attendance %, Pass Rate % — all live.
BI Dashboard Designer
Drag-and-drop: charts, pivots, cards, filters. Connect to any AMTOS data source.
Instructor Calendar
Upcoming classes, exam reviews and practical assessments in a personal calendar view.
Student Portal
Personal class timetable, upcoming and past exams, released practical results — scoped to own enrolments.
Theming & Dark Mode
User-level font, colour intensity, brightness, background and full dark mode.
Report Designer
Report Designer backed by stored procedures with dynamic columns.

Admin KPI Dashboard

87% ATTENDANCE 72% PASS RATE 248 STUDENTS
✋ Short version stop · slides 1–15
12

Step 12 — Certification

Reports, CoR Checklist & EASA Form 148

Two regulatory PDFs generated at any point. The CoR Checklist covers passport check, hours attended, theory M1–M17, workshop P1–P10, aircraft practical and signatures. The Certificate of Recognition (EASA Form 148) lists all passed module numbers, pass dates and track.

EASA Form 148
A4 portrait PDF — passed modules, pass dates, track, signatory block.
CoR Checklist
Full regulatory checklist — ID, hours, theory M1–M17, P1–P10, aircraft, signatures.
Live Data
Both query the live database — every pass and assessment reflected at print time.
Preview & Download
In-browser PDF preview viewer; one-click download.

CoR Checklist — Layout Wireframe

Instructor
Manager

Deep Dive — Assessment

Exam Delivery Modes in Detail

MCQ — Multiple Choice

Question Sets
Fixed set (same for all) or randomised per student from the approved pool.
Illustrated Options
Both question stem and each answer option support image uploads — essential for diagram questions.
Instant Auto-Grade
Score calculated on submission. Pass at ≥ 75%. Held until instructor releases.
Question Exclusion/Awarding
Exclusion/Awarding per-student or system-wide — adjust score. Revert if needed.

Essay — PDF Submission

Submission Window
Configurable open/close datetime. Students cannot submit outside the window.
PDF Upload
Students upload their essay as a PDF from the student portal during the open window.
Manual Grading
Instructor opens the PDF, reviews and enters a score. Same release workflow as MCQ.
Results Portal
Released marks visible in student portal alongside MCQ results — unified view.

Deep Dive — Question Bank

3-Level Question Taxonomy

Questions are tagged to a three-level hierarchy mirroring the EASA Part-66 syllabus. Filters let examiners draw questions from any level — entire module, specific submodule, or granular sub-submodule.

Level 1
Module
e.g. Module 7
Maintenance Practices
Level 2
Submodule
e.g. 7.1
Safety Precautions
Level 3
Sub-submodule
e.g. 7.1.1
Fire Hazards

Exam creators filter the question pool at any level when building an exam session.

Deep Dive — Exam Quality

Item Analysis

Per-question statistics computed across all student attempts on a given exam. Flags questions that should be reviewed, revised or retired to maintain question-bank quality and exam fairness.

📊
Correct-Answer Rate
Percentage of students who answered the question correctly. Low rates flag ambiguous or poorly worded questions.
🎯
Most-Selected Distractor
Which incorrect answer option attracted the most selections — reveals misleading distractors.
📐
Discrimination Index
How well the question distinguishes high-performing from low-performing students. Negative index = problem question.
🔍
Question Review Flag
Questions below threshold on any metric are automatically flagged for examiner review before the next exam cycle.
🗑️
Retire Workflow
Flag poor-performing questions for retirement — they remain in history but are excluded from future exam generation.
📈
Trend Across Cohorts
Compare item statistics across multiple exam sittings to identify drift in question difficulty over time.

Deep Dive — Security

Security & Access Control

AMTOS uses ASP.NET Identity for user management and OWIN/OAuth for authentication middleware. Every controller action is decorated with role-based authorization attributes — no route is accessible without the correct role claim.

🔑
ASP.NET Identity
Industry-standard membership system. Password hashing, lockout policy, claims-based identity.
🔒
OWIN / OAuth
Authentication middleware pipeline. Cookie-based session with configurable expiry.
🛡️
Role Authorization
Every controller decorated with [Authorize(Roles="...")] — unauthorised requests return 403.
🚫
Account Lock
Admins can instantly suspend any user account without deleting their record or data.
🔐
Password Management
Admin-forced reset, user self-reset. Passwords never stored in plain text.
📝
Audit Trail
Record creation timestamps and user IDs stored on key entities — full creation audit.

Deep Dive — Data Exchange

Import & Export Capabilities

AMTOS supports multiple data exchange formats for importing external data and exporting records in standard formats. No proprietary lock-in.

Import

Excel / CSV (Students)
ExcelDataReader library. Bulk student records from .xlsx template with optional track override.
ICS / iCalendar
Import external calendar events from Outlook or Google Calendar into the AMTOS event calendar.
TXT / CSV (Misc)
Additional flat-file import support for supplementary data sets where applicable.

Export

PDF — Certificates
EASA Form 148 and CoR Checklist via PDF engine. In-browser preview + download.
Excel / PDF — Grids
Any data grid (Tracks, Courses, Enrolments) to WYSIWYG A4 PDF or Excel with branded headers.
Custom Reports
Report Designer outputs to PDF, Excel or preview — backed by stored procedures.

Deep Dive — Reporting

Report Designer

Admin-accessible Report Designer for building custom printable reports. Reports are backed by stored procedures and support dynamic columns — no code deployment required to add a new report.

🎨
Visual Designer
Drag-and-drop bands, fields and controls. WYSIWYG preview in the browser.
💾
Stored Procedures
Reports connect to SQL Server stored procedures — full flexibility in data shaping without ORM constraints.
📊
Dynamic Columns
Pivot-style reports where columns are data-driven — no hard-coded field count.
🖨️
Output Formats
PDF, Excel, HTML preview. No server-side print queue — all rendered client-side via viewer.
🔐
Access Control
Report Designer access restricted to Admin role. Published reports visible to roles as configured.
♻️
Reusable Templates
Save report templates and reuse across different date ranges, classes or cohorts.

Deep Dive — User Experience

Theming & Dark Mode

AMTOS supports user-level visual preferences — each user can tune the interface independently without affecting others.

🔤
Font Family
User selects preferred font from supported options — applied system-wide for that account.
🎨
Colour Intensity
Adjust the intensity of UI accent colours — from subtle to vivid.
☀️
Brightness
Per-user brightness control for the interface — useful in varied lighting environments.
🖼️
Background Intensity
Tune the contrast between content areas and page background.
🌙
Full Dark Mode
Complete dark theme toggle — persistent per user account across sessions.
💾
Preference Persistence
All settings stored server-side — preferences follow the user across devices and sessions.

Technology Stack

Complete Technology Inventory

ASP.NET MVC 5
Server-side MVC framework. Razor view engine. Controller-based routing.
DevExpress v25.1
Grids, schedulers, BI Dashboard Designer, Report Designer, PDF document viewer.
Entity Framework 6
Code-First ORM. Migrations for schema evolution. LINQ-based query layer.
SQL Server
Relational database. Stored procedures for report queries. Hosted on cloud IIS server or local instance.
ASP.NET Identity + OWIN
User management, password hashing, role claims, cookie authentication middleware.
ExcelDataReader
Server-side Excel parsing for bulk student import from .xlsx files.
ICS / iCalendar
Standard calendar format import — Outlook and Google Calendar compatible.
PDF Generation
PDF engine for certificates, checklists and custom reports. No third-party queue.

Infrastructure

Deployment & Hosting

AMTOS is deployed as a standard ASP.NET web application on Windows Server with IIS. The database server runs SQL Server. Both tiers are cloud-hosted for availability and managed maintenance.

☁️
Cloud Hosted
Both application and database tiers hosted on cloud infrastructure — no on-premise hardware required.
🖥️
Windows IIS
Internet Information Services web server. Application pool isolation. Standard .NET deployment.
🗄️
SQL Server
Dedicated SQL Server instance. Connection string configurable per deployment environment.
🔄
EF Migrations
Schema changes applied via Entity Framework Code-First Migrations — no manual SQL scripts.
🌐
Browser Compatibility
Chrome, Edge and Safari. Responsive layout for tablet use. No client-side install required.
🔒
HTTPS
SSL/TLS termination at IIS. All traffic encrypted in transit. Standard certificate management.

Integration

Integration Points

AMTOS integrates with standard external systems and formats. All integrations use widely supported open standards — no proprietary connectors required.

📅
Calendar Systems
ICS / iCalendar import from Microsoft Outlook, Google Calendar or any standards-compliant calendar app.
📊
Spreadsheet Tools
Excel .xlsx import for bulk student data via ExcelDataReader. Export to Excel from any data grid.
📄
PDF Ecosystem
PDF generation for all regulatory documents. Students upload PDF essay submissions. All standard-compliant.
🖨️
Print Workflow
Document viewer provides in-browser preview and browser-native print — no print server needed.
🔑
Identity Providers
ASP.NET Identity with OWIN OAuth middleware. Extensible to external IdP integration if required.
💾
Database Tools
SQL Server compatible with SSMS, Azure Data Studio and standard backup/restore tooling.
Full technical deck · 26 slides

Next Steps

Request Access or a Technical Demo

Arrange a technical walkthrough, request a sandbox environment, or discuss deployment requirements with the Aggregator Solutions team.

Riyadh, Saudi Arabia · aggregatorsolutions.com