Skip to content

🔎 Student Search

Search and view individual student records across all processed semesters.

Overview

The Student Search feature allows you to quickly find and view a student's complete academic record across all processed semesters. This provides a comprehensive view of a student's progress throughout their course.

When to Use This Feature

Use this feature when you need to:

  • Look up a specific student's results
  • Review academic history for advising
  • Verify student records for administrative purposes
  • Track student progress across semesters

Accessing the Feature

There are two ways to access Student Search:

  1. Tab Bar: Click the Student Search tab at the top of the main window
  2. Menu: Tools → Student Search...

How to Use

Enter Search Query

Type a search query in the search box:

Search By Example Notes
Registration Number E022-01-1234/2024 Partial matches work
Registration Number (partial) E022-01-1234 Finds all years
Student Name John Doe Case-insensitive
Name (partial) John Finds all matching names

View Results

Matching students appear in a list showing:

  • Registration number
  • Student name
  • Number of semester records found

Select a Student

Click on a student to view their complete record:

  • Student Information: Registration number, name
  • Semester Results: All processed semesters with marks
  • Unit Details: Individual unit grades and marks
  • Academic Summary: Overall progress and status

Student Record View

When you select a student, the record displays in three sections:

Basic Information

  • Registration Number
  • Student Name
  • Course Code
  • Current Year of Study
  • Academic Status

Results by Semester

Semester Units Passed Failed Average Status
YR3 SEM1 6 5 1 58.3 SUPP
YR3 SEM2 6 6 0 62.1 PASS
YR3 ANNUAL 12 11 1 60.2 PASS

Click on a semester row to see detailed unit results.

Individual Unit Marks

Unit CAT Exam Total Grade
EMT3101 25 48 73 A
EMT3102 18 35 53 C
EMT3103 22 15 37 E

Includes:

  • CAT marks
  • Exam marks
  • Lab marks (if applicable)
  • Total marks
  • Grade
  • Special indicators (IGS, SUPP, etc.)

Search Tips

  • Use Partial Numbers

    Search E022-01-12 to find all registration numbers starting with that pattern.

  • Case Doesn't Matter

    Searching john doe, John Doe, or JOHN DOE all return the same results.

  • Year Variations

    Search without the year suffix (E022-01-1234) to find all records for that student across years.

  • Name Parts

    Search just a first or last name to find all students with that name.

How It Works

Data Architecture

Student Search uses a local SQLite database as a search cache:

┌─────────────────────┐      Sync      ┌──────────────────┐
│   XLSX Files        │  ──────────▶   │  SQLite Cache    │
│  (Source of Truth)  │                │  (Search Index)  │
└─────────────────────┘                └──────────────────┘
         │                                      │
         │                                      │
    You edit here                         Fast searches
Component Purpose
XLSX Files Master data - all your exam results live here
SQLite Database Search index - enables fast lookups across all semesters

How Syncing Works

  • When you click Sync Database, DEEPS reads all consolidated XLSX files and indexes them
  • If you edit an XLSX file (correct a mark, add a student), click Sync to update the search index
  • The database is just a cache - XLSX files remain the source of truth
  • If you delete the database, just sync again to rebuild it from your XLSX files

When to Sync

Click Sync Database after:

  • Processing new scoresheets
  • Editing a consolidated file
  • Renaming or moving files

Data Sources

Student Search queries data from all processed consolidated files in:

outputs/verified_results/{academic_year}/YR{n}/SEM{n}/
└── 2024_2025_YR3_SEM1_consolidated_verified.xlsx

Data Availability

Only semesters that have been processed through DEEPS will appear in search results. If a semester hasn't been processed yet, its data won't be searchable.

Exporting Records

To export a student's record:

  1. Select the student from search results
  2. Click Export Record
  3. Choose export format:
  4. Excel (.xlsx) - Full data with formatting
  5. PDF - Print-ready document
  6. Select save location
  7. Click Export

Troubleshooting

Student not found

Problem: Search returns no results for a known student.

Solutions:

  1. Check spelling of name or registration number
  2. Try searching with partial information
  3. Verify the student's semester has been processed
  4. Check for registration number variations (see below)
Registration number variations

Problem: Student has multiple registration number formats.

Common variations normalized automatically:

Entered Normalized
E022 01-1234/2024 E022-01-1234/2024
E022-1-1234/2024 E022-01-1234/2024
E022-01-1234\2024 E022-01-1234/2024

The search automatically handles these variations.

Incomplete records

Problem: Student record is missing some semesters.

Solutions:

  1. Process the missing semester(s) through Step 1
  2. Check that the student's data exists in the original scoresheets
  3. Verify the consolidated file for that semester contains the student
Data out of sync

Problem: Search results don't reflect recent edits to XLSX files.

Solutions:

  1. Click Sync Database to update the search index
  2. If files were renamed, sync will automatically clean up old references
  3. Wait for sync to complete before searching again
File not found in Data Sources

Problem: Data Sources tab shows "File not found" for some entries.

Cause: Files were renamed or moved since last sync.

Solution: Click Sync Database - it will clean up orphaned entries and index the current files.