Com.428 • Class 12science Stream7 Lessons

Credit Hours: 5

Computer Science

कम्प्युटर विज्ञान (कक्षा १२)

Database Management Systems (DBMS & Normalization), Data Communication & Networking (OSI, TCP/IP, IP addressing), Web Technology II (JavaScript, PHP, MySQL), Advanced C Programming (Structures, Pointers, File Handling), OOP Concepts, Software Process Models (SDLC, Agile), and Contemporary Trends (AI, Cloud, IoT).

Solved Q&A (1)

Prescribed Chapters

Showing 7 Lessons

Unit 1

Database Management System (DBMS & Normalization)

1 Lesson

1Lesson 1Syllabus Mapped 📋1 Solved Q&A

Database Management System (DBMS & Normalization)

DBMS architecture, data models, ER diagrams, keys, normalization (1NF, 2NF, 3NF, BCNF), and SQL queries (DDL, DML, DCL).

Database Architecture (Three-Schema Architecture)Entity-Relationship (ER) Modeling: Entities, Attributes, RelationshipsCandidate Keys, Primary Keys, Foreign Keys, Alternate KeysData Redundancy, Update Anomalies (Insertion, Deletion, Modification)

~65 mins study8 Marks in Grid

Open Lesson

Unit 2

Data Communication and Networking

1 Lesson

2Lesson 2Syllabus Mapped 📋

Data Communication and Networking

OSI 7-layer reference model, TCP/IP protocol suite, transmission media (guided vs unguided), network topologies, IP addressing (IPv4 vs IPv6), subnetting, network devices (router, switch, gateway).

OSI 7-Layer Architecture and Functions of Each LayerTCP/IP Architecture and Protocol Suite ComparisonTransmission Media: Twisted Pair, Coaxial, Fiber Optic, WirelessNetwork Topologies: Star, Ring, Bus, Mesh, Tree, Hybrid

~65 mins study8 Marks in Grid

Open Lesson

Unit 3

Web Technology II (JavaScript, PHP & MySQL)

1 Lesson

3Lesson 3Syllabus Mapped 📋

Web Technology II (JavaScript, PHP & MySQL)

Client-side scripting with JavaScript, DOM manipulation, form validation, server-side scripting with PHP, connecting PHP with MySQL database for CRUD operations.

Client-Side vs Server-Side Scripting ArchitectureJavaScript DOM Manipulation, Events, and Form ValidationPHP Syntax, Variables, Superglobals ($_POST, $_GET, $_SESSION)PHP Database Connectivity: mysqli_connect() and PDO

~65 mins study8 Marks in Grid

Open Lesson

Unit 4

Advanced Programming in C (Pointers, Structures, Files)

1 Lesson

4Lesson 4Syllabus Mapped 📋

Advanced Programming in C (Pointers, Structures, Files)

Pointers arithmetic, call by value vs reference, dynamic memory allocation (malloc, calloc, realloc, free), structures and unions, data file handling (fopen, fclose, fprintf, fscanf, fread, fwrite).

Pointer Variables, Pointer to Pointer, Pointer ArithmeticPass by Value vs Pass by Reference using PointersDynamic Memory Allocation: malloc(), calloc(), realloc(), free()Structures: Declaration, Arrays of Structures, Nested Structures, Structure Pointers

~70 mins study8 Marks in Grid

Open Lesson

Unit 5

Object-Oriented Programming (OOP) Concepts

1 Lesson

5Lesson 5Syllabus Mapped 📋

Object-Oriented Programming (OOP) Concepts

Procedural vs Object-Oriented paradigm, classes and objects, encapsulation, abstraction, inheritance (single, multiple, multilevel), polymorphism (function overloading, operator overloading, virtual functions).

Limitations of Procedural Programming and Advantages of OOPCore OOP Pillars: Encapsulation, Data Abstraction, Inheritance, PolymorphismClasses and Objects, Access Specifiers (Private, Public, Protected)Constructors and Destructors (Default, Parameterized, Copy)

~60 mins study6 Marks in Grid

Open Lesson

Unit 6

Software Process Model (SDLC & Methodologies)

1 Lesson

6Lesson 6Syllabus Mapped 📋

Software Process Model (SDLC & Methodologies)

Software development life cycle (SDLC) phases, Waterfall model, Prototype model, Spiral model, Agile development methodology, software testing types (white box vs black box, unit, integration, system).

SDLC Phases: Feasibility, Requirement Analysis, Design, Coding, Testing, MaintenanceClassical Waterfall Model: Strengths and WeaknessesPrototyping Model and Spiral Risk-Driven ModelAgile Methodology: Scrum Framework, Sprints, User Stories

~50 mins study6 Marks in Grid

Open Lesson

Unit 7

Recent Trends in Technology

1 Lesson

7Lesson 7Syllabus Mapped 📋

Recent Trends in Technology

Artificial Intelligence and Machine Learning, Cloud Computing (IaaS, PaaS, SaaS), Big Data Analytics, Internet of Things (IoT), Cybersecurity and Ethical Hacking, E-Governance in Nepal.

Artificial Intelligence (AI), Machine Learning (ML), and Deep Learning OverviewCloud Computing Service Models: IaaS, PaaS, SaaS and Deployment TypesBig Data Characteristics: Volume, Velocity, Variety, Veracity, ValueInternet of Things (IoT): Sensors, Actuators, Architecture, Smart Cities

~50 mins study6 Marks in Grid

Open Lesson