Hello {{ $exam->tester->name }},
The exam {{ $exam->title }} has been completed.
Please find the full results report attached to this email as an Excel file.
Exam Title
{{ $exam->title }}
Total Candidates
{{ $exam->attempts()->where('status','graded')->count() }}
Passed
{{ $exam->attempts()->where('passed',true)->count() }}
Average Score
{{ round($exam->attempts()->where('status','graded')->avg('percentage'), 1) }}%
Pass Rate
@php
$total = $exam->attempts()->where('status','graded')->count();
$passed = $exam->attempts()->where('passed',true)->count();
$rate = $total > 0 ? round(($passed/$total)*100,1) : 0;
@endphp
{{ $rate }}%
Report Generated
{{ now()->format('D, M j Y H:i') }}
📎
Excel Report Attached
The attached .xlsx file contains individual candidate scores, grades, time taken, and pass/fail status.