Complete system architecture, CSV bulk import guidelines, multi-semester subject retention, teacher permissions, and marks evaluation process under NEP 2020.
Mid-Term Written Test (15 Marks) • Seminar / PPT (5 Marks) • Term Assignment (5 Marks) • Attendance (5 Marks) = Total 30 Marks.
Admin selects Session (e.g. 2024-2028) and Semester (e.g. 1 or 2) and uploads the Excel/CSV file containing 17 columns.
Student personal info goes into master_student. Student's semester subjects (MJC, MIC, MDC, AEC, SEC, VAC) are safely isolated into master_subject.
When Sem 1 student moves to Sem 2, the new Sem 2 subject record is inserted into master_subject, keeping Sem 1 subjects intact without overwrite!
Admin grants ciamark = 1 in teacher profile. Teacher's department or assigned subjects (teacher_subject) determine which student list they can evaluate.
Faculty enters Theory (max 30) & Practical (max 30) marks. Totals are automatically computed in real-time. Faculty can edit college roll numbers directly.
When marks entry is finalized, faculty locks the subject. The teacher ID is permanently recorded in mjc_lock, freezing marks from tampering.
Pehle jab sabhi subjects ek hi master_student table me save hote the, tab student ke Semester 1 se Semester 2 me jane par purane subjects overwrite ho jate the. Ab architecture ko teen alag-alag specialized tables me divide kiya gaya hai:
Permanent Student Identity & Profile:
loginid (Unique Primary Key)name, father, mobexam_roll, college_roll, reg_nosessionz, course, disciplineSemester-Wise Subject History:
loginid + sem (Semester Identifier)mjc (Major Discipline Course)mic (Minor Course)mdc, aec, sec, vacSemester-Wise Marks & Locks:
loginid + sem (Evaluated Semester)mjc_mark, mjc_prac, mjc_lockmic_mark, mdc_mark, aec_mark, etc.
Niche di gayi table me 17 Columns ka complete structure aur 6 alag-alag streams (Science, Arts) ke students ke subjects ka udaharan dikhaya gaya hai. Note: collegeName column ab required nahi hai kyunki sabhi students Bihar National College ke hain.
| Sn | Student Name | Exam Roll | Univ Reg No | Course | Discipline | MJC | MIC | MDC | AEC | SEC | VAC |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Rahul Kumar | 42604320001 | 231066580001 | B.A. Hons | Geography | Geography | History | Economics | English | Digital Marketing | Yoga |
| 2 | Priya Sharma | 42604320002 | 231066580002 | B.Sc. Bio Group | Zoology | Zoology | Botany | Chemistry | Env Science | Basic IT Tools | Sports & Fitness |
| 3 | Amit Patel | 42604320003 | 231066580003 | B.Sc. Math Group | Physics | Physics | Mathematics | Chemistry | Hindi | Creative Writing | Swachh Bharat |
| 4 | Sneha Kumari | 42604320004 | 231066580004 | B.A. Hons | Political Science | Political Science | Sociology | Philosophy | English | Disaster Risk Mgmt | Art of Being Happy |
| 5 | Vikram Singh | 42604320005 | 231066580005 | B.Sc. Math Group | Mathematics | Mathematics | Statistics | Physics | Hindi | Stat Software Pkg | Ethics & Culture |
| 6 | Ananya Gupta | 42604320006 | 231066580006 | B.A. Hons | History | History | Political Science | Sociology | Sanskrit | Rangmanch | Ayurveda & Nutrition |
Bilkul nahi! System reg_no se check karta hai. Student ki basic jankari (exam roll, session, etc.) master_student me update hogi, aur naye Semester 2 ke subjects master_subject me nayi row ke roop me save honge. Previous Semester 1 ka record safe rehta hai.
Admin panel se Teacher Edit page par jayein aur "CIA Marks Update Permission" checkbox ko Yes (ciamark = 1) karke save karein. Permission activate hote hi teacher ke sidebar aur dashboard par Assessment menu dikhai dene lagega.
Lock karne se evaluate karne wale teacher ki ID permanently stamp ho jati hai. Isse audit trail maintain rehta hai ki kis teacher ne kis subject ke marks update kiye the, aur marks me koi accidental badlav nahi kiya ja sakta.