Syllabus of

Modern Computer Application

Class – XII

Syllabus of modern computer application class xii

Chapter -1 (Logic Gate & Combinational Circuit)

1. Basic gate using a universal gate.
2. Two-level Circuit
3. Combinational Circuit –
4. Half Adder & Full Adder( Definition & representation)
5. Full Adder using Half adder only.
6. Half Subtractor, Full Subtractor( Definition & representation)
7. 4-bit Adder and Subtractor Circuit.
8. Multiplexer(4×1) and De-Multiplexer(1×4)
9. Decoder (Minimum 3bits) and Encoder (Decimal to Binary & Octal to Binary)

Chapter -2 ( Networking )

Introduction to Networking(Definition, Advantage, Disadvantage, Application)

• Analog and Digital Communication
• Modes of Communication – Simplex, Half Duplex and Full Duplex Communication
• Types of Networking- LAN, MAN, WAN
• Network Architecture – Client Server & Peer to Peer Networks.
• Serial & Parallel Communication.
• Bandwidth, Channel Capacity, Baud.
• Synchronous and Asynchronous Transmission mode
• Baseband and Broadband Networks.

Components of Network

• Servers (File server, Communication Server, Print Server) and Workstation
•  NIC
•  Guided Media: UTP,STP, Co-axial, Fiber Optic
•  Unguided Media: Infrared, Radio & Microwave communication, Satellite.
•  Network Operating System characteristics.

LAN Protocols

• Ethernet (CSMA/CD) and Token Ring Protocol

Switching Technique

• Circuit, Message, & Packet Switching

Use of Modem

TCP/IP Protocols

• TCP, IP, UDP, FTP, TELNET

IP Addressing

• Class A, Class B & Class C IP Addressing

Domain Name System

• URL

Introduction to Internet

• Basic requirement for connecting to the internet. ISP
• Services provided by Internet: WWW, Browser, E-Mail, Search Engine, Social Networking.
• Networking Security: Computer Virus, Concept of Firewall, Password.

HTML

• Basic Page Designs, Using Ordered & Unordered lists, Using Image Hyperlinking, using Table

 Chapter -3 ( Database Management System )

Introduction of Database

• Definition of Database
• Advantage and Disadvantage of DBMS
• Database Language(DDL, DML, DCL)
• Data Dictionary, Metadata.
• Database Schema and Instance.
• DBMS and its components,
• Various Data Model: ER Model, Hierarchical Model, Network Model, Relational Model(Only concepts)
• Different Database User
• Functions of DBA.

Relational Model

• Topple, Attribute, Concept of Relation, Domain, Degree, Cardinality.
• Concept of Key: Super Key, Candidate Key, Primary Key, Alternate Key.
• Concept of Relation : 1:1, 1:N, N:M relationships.
• Database Constraints: Equity Integrity Constraints, Domain Constraints, Referential Integrity Constraints, and  Concept of Foreign Key.

Relational Algebra

• Selection Operation
• Projection Operation
• Set Operation
• Cartesian Product
• Natural Join Operation.

SQL

• Simple Select Query (SELECT, FORM, WHERE, DISTINCT, AND,OR, IN, NOT IN, BETWEEN, LIKE, ORDER BY)

Chapter – 4 (Introduction to Spreadsheet)

• Introduction to Excel.
• Concept of Workbook, Worksheet, Row Column, Cell.
• Creating, Opening, Editing, Saving a Workbook.
• Changing Row and Column Width.
• Formatting Cells.
• Different data types in Excel.
• Entering labels and values.
• Use of following inbuilt functions only: SUM, PRODUCT, AVERAGE, MAX, MIN, ROUND, COUNT, COUNTIF, IF, AND, OR, NOT, DATE, TIME, NOW, CONCATENATE, UPPER & LOWER.
• Copying Cells: Relative, Absolute, and Mixed Reference.
•  Making Calculations and re-calculation.
• Autofill, Fill with series.
•  Conditional Formatting.
•  Sorting and Filtering Data(Use Auto Filter).
• Goal Seek.
•  Hiding Rows and Columns.
•  Use of Macro.
•  Creating Line Diagrams, Pie Charts, Bar Graphs.

Chapter – 5 (Using M S Access)

• Introduction to Access.
• Table creating using Design View & Wizard/Template.
• Different data types in Access.
• Manipulation of data using Access: Inserting, Updating, Deleting Data.
• Creating Relationship between Tables.
• Form creating using wizard and auto form.
• Report generating using wizard and auto report.

Syllabus of modern computer application class xii