Computer Science Grade XII - Final Practical / Project Work Questions

Computer Lab Practical / Presentation Work

1. Database Management Projects

1. Create a database to store student information and maintain records (MS-Access: table, form, query, report).
2. Design a database for Quiz Management System in MS Access.
3. Design database and tables with SQL statements.

• Work with DDL and DML (CREATE, DROP, ALTER, SELECT, INSERT, UPDATE, DELETE).

2. Networking Projects

1. Construct twisted pair cable and create a LAN / Router configuration.
2. Install Packet Tracer or AnyDesk software to control another PC (share files, folders, printer).

3. Web Development Projects

1. Create a static school website overview with student registration form and client-side validation (HTML, CSS, JS).
2. Design a login form with Create/Read/Update/Delete functionality using PHP.

4. Programming Projects

1. Menu-based Library Management System in C:

• Insert Records
• Display Records
• Delete Records
• Update Records
• Exit

5. Research and Analysis Projects

1. Visit an IT company and survey programming languages used. Write details.
2. Create DFD, ER diagram, and Use Case diagram for Bookstore Management System.
3. Make a presentation about SDLC and its models.
4. Case study: How e-governance helps communities. Write a report based on government body visits.

Final Project Report

Summary

Project Categories:
Database Management: 3 Projects
Networking: 2 Projects
Web Development: 2 Projects
Programming: 1 Project
Research & Analysis: 4 Projects

Programming Requirements:
JavaScript Programs: 11
PHP Programs: 10
C Programs: 21

Total Assessment Components:
Practical/Presentation Work: 12 Projects
Theory Questions: 7 Units
Programming Assignments: 42 Programs

Note: This comprehensive practical examination covers all major aspects of Computer Science Grade XII curriculum with hands-on experience in database management, networking, web technologies, and programming languages.