Fill marks in ERP, not by hand.
The NUB ERP Marks Entry page wants Class Attendance, Continuous Assessment, Mid Term and Final typed one box at a time. This extension reads your Google Sheet or Excel file, matches every Student ID, and fills it all in — with validation built in.
What it does
Two input sources
Pick an already-open Google Sheet tab, or upload an Excel (.xlsx/.xls) file directly.
Mark validation
Flags anything over the maximum — Attendance 10, Continuous Assessment 20, Mid Term 30, Final 40.
ID mismatch detection
Catches Student IDs in ERP but missing from your sheet, and vice versa — before anything is filled.
Wrong file / section guard
If 50%+ of IDs don't match, it stops and tells you to double-check the file or the selected Course & Section.
Special codes
Understands -7 / A (Absent), -5 (Reported), and blank cells — and reports them clearly.
Categorized PDF report
Failed students, absences in Mid/Final, missing IDs, and near-boundary marks — each in its own table, downloadable as a PDF.
Required column format
Both the Google Sheet and the Excel file must follow this column order. Row 1 can be any header — data is read starting from Row 2. Column position matters, not the header text.
| Column | Field | Notes |
|---|---|---|
| A | Student ID | Required — must match the ID shown in ERP |
| B | Student Name | Optional, not used for filling |
| C | Class Attendance | Max 10 |
| D | Continuous Assessment | Max 20 |
| E | Mid Term | Max 30 |
| F | Final | Max 40 |
How to use it
1. Have your marks ready
Open the Google Sheet containing the marks in this same browser — the tab must be open here for the extension to read it — or have your Excel file ready to upload.
2. Open the ERP Marks Entry page
Select Semester and Course & Section, then click Populate Students so the table loads.
3. Click the extension icon
Choose Option 1 — Google Sheet and pick the open tab and sheet, or Option 2 — Upload Excel File and select your file.
4. Click Fill Marks Now
Every matched Student ID gets filled automatically. Review the report, then click Save Marks or Save & Submit Marks on the ERP page yourself — the extension never submits on your behalf.
Good to know
- It only fills form fields — you always click Save or Submit yourself.
- Everything is read and validated in your browser. Nothing is uploaded to any server.
- The report groups issues into six categories: Failed, Absent in Mid/Final, Missing from Sheet, Missing from ERP, Near Boundary, and Others.
Questions or something not working? Get in touch.
Privacy policy
Last updated July 2026 · applies to all versions
What this extension does
NUB Automated Marks Entry helps NUB faculty auto-fill the NUB ERP "Marks Entry" form using data from a Google Sheet the user has open, or an Excel file the user uploads. It also validates the marks and shows an on-page report.
Data this extension accesses
- Google Sheet cell values (Student ID, marks) — read from an open Google Sheets tab the user selects, used only to fill the ERP form. This stays local: read in the browser and written directly into the ERP form fields. Never sent to any third-party server.
- Excel file contents — from a file the user manually uploads via the file picker. Parsed entirely in the browser. Never uploaded anywhere.
- NUB ERP page content (Student IDs, form fields) — read from the active NUB ERP tab, only when the user opens the extension popup on that page, to match Student IDs and fill marks.
What this extension does NOT do
- It does not collect, store, transmit, or sell any personal data.
- It does not use any external server, API, or analytics service.
- It does not require a login or account.
- It does not use cookies, tracking pixels, or third-party scripts.
- All processing — reading the Google Sheet CSV export, parsing Excel files, validating marks, generating the report — happens entirely inside your own browser.
Google Sheets access
To read your Google Sheet, the extension fetches the sheet's CSV export URL (docs.google.com/spreadsheets/.../export?format=csv) using your existing logged-in Google session in Chrome. This request goes directly from your browser to Google's servers — it never passes through any server we operate, because we don't operate one.
Permissions used and why
- activeTab — to read and fill the NUB ERP marks form on the tab you're viewing when you open the extension.
- scripting — to inject the fill logic and the report popup into the ERP page, and to read sheet tab names from Google Sheets.
- tabs — to find open Google Sheets tabs so you can pick one.
- Host permission: docs.google.com — to fetch your sheet's data as CSV using your logged-in session.
Data retention
This extension does not retain any data between sessions. Nothing is written to persistent storage. Once you close the popup or the tab, no marks or sheet data remain anywhere except on the ERP page itself, which you control.
Remote code
The extension does not use remote code. All of its JavaScript is included in the package you install. Nothing is downloaded or executed from an external source.
Children
The extension is a workplace tool for university faculty and is not directed at children.
Changes to this policy
If this policy changes, the update will be reflected here with a new "Last updated" date.
Contact
Questions about privacy? Please see the contact page.