MER (Monitoring, Evaluation, and Reporting) Mechanism Project: "Orphan Scholarship Program"

MER (Monitoring, Evaluation, and Reporting) Mechanism

Project: "Orphan Scholarship Program"

A. Excel-Based Dashboard (For Analysis & Storage)

File Name: OSP_MER_Monthly_Report_[MM-YYYY].xlsx

Sheet 1: EXECUTIVE DASHBOARD (Summary View)

Metric	Monthly Target	Actual Achievement	% Achievement	Cumulative (FY)	Trend (↑→↓)
SCHOLARSHIP MANAGEMENT
Total Active Scholars
New Scholars Enrolled
Scholars Graduated/Promoted
Scholars Dropped/Exited
FINANCIAL DISBURSEMENT
Total Disbursement Amount ($)
Average Disbursement per Scholar
Disbursement Timeliness (% on schedule)
EDUCATIONAL PERFORMANCE
% Scholars with ≥75% Attendance
% Scholars Passing Grade/Exams
Scholars in Extracurricular Activities
SUPPORT SERVICES
Mentoring Sessions Conducted
Well-being Checks Completed
Guardian Engagement Rate

Sheet 2: SCHOLAR MASTER DATABASE

Scholar ID	Full Name	Guardian Name	Contact	Age	Gender	Grade/Class	School Name	Enrollment Date	Scholarship Tier	Monthly Amount	Bank/Account	Last Disbursement	Status (Active/Hold/Graduated)	Notes

Sheet 3: DISBURSEMENT LOG

Disbursement ID	Date	Scholar ID	Scholar Name	Amount	Method (Bank/Cash)	Transaction ID	Verified By	Receipt Obtained (Y/N)	Purpose Cycle (e.g., Jan-Mar Tuition)	Notes

Sheet 4: ACADEMIC TRACKING

Scholar ID	Month	Attendance (%)	Subjects	Recent Scores/Grades	Teacher Comments	Areas Needing Support	Promoted (Y/N)	Extracurricular Participation	Submitted By (Teacher/Mentor)

Sheet 5: MENTORING & SUPPORT LOG

Session ID	Date	Scholar ID	Mentor Name	Session Type (Academic/Emotional/Career)	Duration	Key Issues Discussed	Action Items	Follow-up Required (Y/N)	Next Session Date	Satisfaction Rating (1-5)

Sheet 6: ISSUES & RESOLUTIONS REGISTER

Case ID	Date Reported	Scholar/Guardian Name	Issue Category (Academic/Financial/Health/Bullying/etc.)	Description	Priority (High/Medium/Low)	Assigned To	Resolution	Date Closed	Status

B. Airtable Base (For Collaborative Data Collection & Reporting)

Base Name: Orphan Scholarship Program MER

Table 1: Scholars (Core Database)

Fields:

Scholar ID (Auto-Number, e.g., OSP-SCH-001)
Full Name (Text)
Date of Birth (Date)
Gender (Single Select)
Guardian Name (Text)
Relationship to Guardian (Single Select)
Contact Information (Phone, Email, Address)
School Information (Linked Record to Schools Table)
Current Grade/Class (Text)
Enrollment Date (Date)
Scholarship Tier (Single Select: Full/Partial/Books & Supplies)
Monthly/Annual Amount (Currency)
Bank Details (Text - encrypted field)
Status (Single Select: Active/Hold/Graduated/Exited)
Exit Reason (Text, if applicable)
Profile Photo (Attachment, with consent)
Special Notes (Long Text)

Table 2: Disbursements (Linked to Scholars)

Fields:

Disbursement ID (Auto-Number)
Scholar (Link to Scholars Table)
Disbursement Date (Date)
Amount (Currency)
Purpose (Single Select: Tuition/Fees/Books/Uniforms/Allowance)
Cycle (Single Select: Monthly/Quarterly/Semester/Annual)
Method (Single Select: Bank Transfer/Cash/Voucher)
Transaction Reference (Text)
Verified By (Collaborator)
Receipt/Proof (Attachment)
Status (Single Select: Scheduled/Processed/Completed/Issue)

Table 3: Academic Progress (Linked to Scholars)

Fields:

Progress ID (Auto-Number)
Scholar (Link to Scholars Table)
Reporting Period (Date, e.g., End of Term)
School Report Card (Attachment)
Overall Grade/Percentage (Number)
Attendance Percentage (Number)
Teacher Comments (Long Text)
Strengths (Multiple Select)
Areas for Improvement (Multiple Select)
Extracurricular Activities (Multiple Select)
Promoted to Next Grade (Checkbox)
Submitted By (Teacher/School Coordinator Name)

Table 4: Mentoring Sessions (Linked to Scholars)

Fields:

Session ID (Auto-Number)
Scholar (Link to Scholars Table)
Mentor (Link to Staff/Volunteers Table)
Date & Time (Date & Time)
Format (Single Select: In-person/Phone/Online)
Session Focus (Multiple Select)
Discussion Summary (Long Text)
Scholar's Emotional State (Single Select: scale 1-5)
Action Items (Long Text)
Follow-up Date (Date)
Confidential (Checkbox)

Table 5: Schools & Institutions

Fields:

School ID (Auto-Number)
School Name (Text)
Type (Single Select: Public/Private/Religious)
Contact Person (Text)
Fee Structure (Attachment)
Performance Rating (Single Select)
Number of Our Scholars (Roll-up)
Agreement Status (Single Select)

Views & Dashboards:

Active Scholars View: Filter by status, school, grade
Disbursement Calendar: Monthly schedule
Academic Alerts: Scholars below performance threshold
Case Management: Open issues needing attention
Graduation Tracker: Scholars approaching completion

2. SUPPORTING DETAILS & FORMATS

A. Data Collection Process

Daily/Weekly: Field officers update scholar status, issues
Monthly: Academic reports collected from schools; disbursements processed
Quarterly: Comprehensive review meetings with guardians
Annually: Complete reassessment of scholar eligibility and progress

B. Monthly Narrative Report Template

ORPHAN SCHOLARSHIP PROGRAM
Monthly Progress Report: [Month, Year]

1. EXECUTIVE SUMMARY
   - Key metrics vs. targets
   - Success stories
   - Major challenges

2. SCHOLARSHIP MANAGEMENT
   - 2.1 Enrollment Status (New, Active, Exited)
   - 2.2 Demographic Analysis
   - 2.3 School Distribution

3. FINANCIAL OVERVIEW
   - Disbursement summary
   - Budget utilization
   - Timeliness analysis

4. EDUCATIONAL OUTCOMES
   - Academic performance trends
   - Attendance analysis
   - Extracurricular engagement

5. PSYCHOSOCIAL SUPPORT
   - Mentoring activities
   - Well-being indicators
   - Guardian engagement

6. CASE MANAGEMENT
   - Issues resolved and pending
   - Success interventions

7. RISKS AND MITIGATION
   - Current risks to program
   - Action plans

8. RECOMMENDATIONS FOR NEXT MONTH

9. ANNEXES
   - Annex A: Detailed scholar list
   - Annex B: Financial details
   - Annex C: Success stories with photos

C. Quality Assurance Checklists

Scholar Enrollment Checklist:

Eligibility verified (orphan status documents)
School admission confirmed
Guardian agreement signed
Bank account established
Baseline assessment completed
Photograph and consent obtained

Monthly Disbursement Checklist:

Attendance verified (>75%)
Academic performance checked
Previous disbursement accounted for
Bank details confirmed
Approval from program manager
Receipt collected post-disbursement

Quarterly Review Checklist:

School report cards collected
Guardian meeting conducted
Mentor feedback reviewed
Academic support needs assessed
Well-being evaluation completed
Continuation decision documented

3. SCHOLAR APPLICATION & ASSESSMENT TEMPLATE

A. Scholar Application/Assessment Form

============================================================================
         ORPHAN SCHOLARSHIP PROGRAM - SCHOLAR APPLICATION & ASSESSMENT
============================================================================
Application ID: OSP-APP-___     Assessment Date: __/__/____

SECTION 1: PERSONAL INFORMATION
Scholar Name: _________________________________ DOB: __/__/____
Gender: Male/Female/Other        Age: ___     Nationality: _____________

Orphan Status: □ Single Parent □ Double Orphan □ Abandoned □ Other
Supporting Documents: □ Death Certificate □ Court Papers □ Other: _________

SECTION 2: GUARDIAN INFORMATION
Guardian Name: ____________________________ Relationship: _______________
Contact: Phone: _______________ Email: ________________ Address: _________
Occupation: ___________________ Monthly Income: $_______ Household Size: ___

SECTION 3: EDUCATIONAL BACKGROUND
Current Grade: _______ Last School Attended: _____________________________
Last Grade Completed: _______ Average Performance: Excellent/Good/Fair/Poor
Reason for Discontinuation (if any): ____________________________________

SECTION 4: FINANCIAL NEED ASSESSMENT
Monthly School Fees: $_______    Books & Uniforms: $_______    Transport: $_______
Other Educational Expenses: $_______    Total Need: $_______
Family Contribution Possible: $_______    Scholarship Requested: $_______

SECTION 5: PSYCHOSOCIAL ASSESSMENT
Scholar's Aspirations: ____________________________________________________
Notable Strengths: _______________________________________________________
Support Needs Identified: Academic □ Emotional □ Social □ Career □ Other
Current Emotional State: Stable □ Anxious □ Depressed □ Thriving □

SECTION 6: RECOMMENDATION
Eligibility Score (1-10): ___    Recommended Scholarship Tier: _____________
Justification: ___________________________________________________________
_________________________________________________________________________

Assessed By: ________________________    Reviewed By: ____________________
Signature: __________________________    Signature: ______________________
Date: ______________________________    Date: ___________________________

[ ] APPROVED    [ ] PENDING    [ ] REJECTED    Reason: ___________________

B. Digital Equivalent (Airtable Form)

Form Name: "New Scholar Application"

Fields mirror physical form with additional:
- Document uploads (Death certificates, previous reports)
- Calculation field for financial gap
- Automated eligibility scoring based on criteria
- Workflow status (Submitted/Under Review/Approved/Rejected)
- Assignment to case officer

IMPLEMENTATION PHASES

Phase 1 (Month 1): Database setup, form design, staff training
Phase 2 (Month 2-3): Pilot with 20 scholars, system refinement
Phase 3 (Month 4-6): Full implementation, guardian orientation
Phase 4 (Month 7+): Evaluation framework activation, impact assessment

KEY PERFORMANCE INDICATORS (KPIs)

Access: Number of orphans accessing quality education
Retention: Scholar retention rate (≥90% target)
Performance: Academic improvement rate
Completion: Grade promotion rate (≥85% target)
Well-being: Psychosocial improvement scores
Efficiency: Cost per scholar per academic year
Satisfaction: Guardian and scholar satisfaction (≥80% target)

This MER mechanism ensures accountable fund utilization, measurable educational impact, and holistic support tracking for vulnerable scholars while maintaining strict data privacy and ethical standards.

HADI Asia

Search This Blog