UGV Academic Import

An extension for updating academic data on UGV portal

# UGV Academic Import **Import student marks and attendance directly from Excel into the University of Global Village Academic Portal.** UGV Academic Import is a productivity extension designed for faculty members of the **University of Global Village (UGV)**. It simplifies academic data entry by allowing instructors to import student results and attendance records directly from Excel workbooks into the UGV Teaching Dashboard. The extension eliminates repetitive manual entry, reduces mistakes, automatically matches students using Student IDs, and provides detailed reports for verification and record keeping. Whether managing theory courses, laboratory courses, or semester attendance records, UGV Academic Import provides a faster and more reliable workflow. --- ## Key Features ### 📊 Excel Workbook Support * Import academic data from **.xlsx**, **.xls**, and **.csv** files. * Drag-and-drop workbook upload. * Supports workbooks containing multiple worksheets. * Select the required sheet before importing. --- ### 🤖 Automatic Detection & Mapping * Automatically detects common Excel headers. * Matches portal fields with workbook columns. * Allows manual column mapping when required. * Saves mapping preferences for future imports. --- ### 🎓 Result Import Support Supports result entry for: * Theory courses * Laboratory courses Automatically handles different assessment structures including: * Class tests and quizzes * Assignments * Attendance marks * Mid examinations * Final examinations --- ### 📅 Attendance Import Support Import attendance directly from semester attendance sheets. Supports: * Daily attendance update * Monthly attendance synchronization * Whole-semester attendance worksheets * Automatic date detection * Future class date protection Recognized attendance values: * **P, p, TRUE** → Present * **L, l** → Late * **A, a, FALSE, blank** → Absent Future empty attendance entries are ignored to prevent accidental marking. --- ### ✅ Automatic Student Matching * Matches students using **Student ID**. * Detects students missing from Excel. * Detects students missing from the portal. * Prevents incorrect updates caused by unmatched records. --- ### 🚫 Automatic Absent Handling * Automatically processes absent records based on course requirements. * Supports blank and predefined absent values. * Reduces manual corrections after importing. --- ### 📄 Detailed Import Reports Generate a complete report after every operation, including: * Course information * Selected worksheet * Result import summary * Daily attendance summary * Monthly attendance update summary * Missing Student IDs * Excel and portal mismatch information Reports can be copied or downloaded for documentation and future reference. --- ## Designed for Productivity UGV Academic Import helps instructors: * Save time during result submission and attendance management. * Reduce repetitive manual data entry. * Minimize typing and calculation mistakes. * Quickly verify imported information. * Maintain accurate academic records. --- ## Privacy UGV Academic Import processes all workbook data **locally inside your browser**. The extension: * Does not upload Excel files. * Does not send student information to external servers. * Does not store academic data outside the browser. Your data remains within the UGV portal and your device. --- ## Intended Users This extension is intended for authorized faculty members and academic staff of the **University of Global Village (UGV)** who use the UGV Teaching Dashboard for academic activities. --- **Developed by** **Md. Masudur Rahman** Lecturer Department of Computer Science & Engineering University of Global Village