Quick Search: Admission Exam BCA Notice
College with Potential
for Excellence (CPE)

Continuous Internal Assessment (CIA) Workflow Guide

Complete system architecture, CSV bulk import guidelines, multi-semester subject retention, teacher permissions, and marks evaluation process under NEP 2020.

NEP 2020 30% Continuous Internal Assessment (CIA)

Mid-Term Written Test (15 Marks) • Seminar / PPT (5 Marks) • Term Assignment (5 Marks) • Attendance (5 Marks) = Total 30 Marks.

Download Sample CSV Format (17 Columns)

1 CIA Mark Update & Management Process (Step-by-Step Workflow)

Step 01

CSV Bulk Student Import

Admin selects Session (e.g. 2024-2028) and Semester (e.g. 1 or 2) and uploads the Excel/CSV file containing 17 columns.

Step 02

Dual-Table Smart Separation

Student personal info goes into master_student. Student's semester subjects (MJC, MIC, MDC, AEC, SEC, VAC) are safely isolated into master_subject.

Step 03

Multi-Semester History Retained

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!

Step 04

Teacher CIA Permission & Subject

Admin grants ciamark = 1 in teacher profile. Teacher's department or assigned subjects (teacher_subject) determine which student list they can evaluate.

Step 05

Marks Entry (Name & Roll Wise)

Faculty enters Theory (max 30) & Practical (max 30) marks. Totals are automatically computed in real-time. Faculty can edit college roll numbers directly.

Step 06

Evaluation Lock & Audit Trail

When marks entry is finalized, faculty locks the subject. The teacher ID is permanently recorded in mjc_lock, freezing marks from tampering.

2 Database Architecture: Semester-Wise Subject Isolation

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:

1. master_student Table

Permanent Student Identity & Profile:

  • loginid (Unique Primary Key)
  • name, father, mob
  • exam_roll, college_roll, reg_no
  • sessionz, course, discipline

2. master_subject Table

Semester-Wise Subject History:

  • loginid + sem (Semester Identifier)
  • mjc (Major Discipline Course)
  • mic (Minor Course)
  • mdc, aec, sec, vac
  • Har semester ka record alag-alag preserve rehta hai!

3. master_marks Table

Semester-Wise Marks & Locks:

  • loginid + sem (Evaluated Semester)
  • mjc_mark, mjc_prac, mjc_lock
  • mic_mark, mdc_mark, aec_mark, etc.
  • Lock me evaluator teacher ki ID store hoti hai.

3 Sample CSV Import Format & Realistic Examples

Download CSV Template

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

4 Important FAQs & Key Rules

Q1: Agar same student ka Semester 2 me CSV se data upload kiya jaye, to kya Semester 1 ka subject hat jayega?

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.

Q2: Kisi teacher ke faculty panel me Assessment menu na dikhe to kya karein?

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.

Q3: Marks entry ke baad "Lock" button dabane ka kya fayda hai?

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.