Class 12 Modern Computer Application WBCHSE Syllabus

 Class  ১২ Modern Computer Application  Syllabus  টি West  Bengal Council  এর Syllabus অনুযায়ি তৈরি করা হয়ে হয়েছে। প্রত্যেকটি section এর শেষে একটি করে link  দেওয়া আছে যেখান থাকে তোমরা chapter অনুসারে নোটস ,Question paper ,Chapter wise  Video ,Suggestion  দেখে নিতে পারবে  । আশাকরি এই ব্লগটি তোমাদের খুব কাজে লাগবে । এই পেজটি তোমাদের বন্ধুদের কাছে  whatsapp এবং Facebook এ share করতে পারো।

A . Logic Gate and Combinational Circuits (15 Marks ):

• Logic  Gates - OR,AND,NOT,XOR,X-NOR Gates.
• Universal Gates- NAND and NOR Gate.
• Basic gate using Universal Gates.
• Combinational circuits :
•  Half Adder & Full Adder(Definition and representation)
• Full Adder using Half Adder only.
• Half Sub tractor & Full Sub tractor
• 4 bit Adder and Sub tractor circuit.
• Multiplexer (4╳1)and DE-multiplexer(1╳4) circuit.
• Decoder (Maximums 3 bits), and Encoder(decimal to Binary,Octal to Binary)

➤ Click Here to see the video for Logic gate part 1:

➤ Click Here to see the video for Logic gate part 2:

➤ Click Here to see the video for Logic gate part 3:

➤Click here to Download the notes

B. Networking ( 20 MARKS)

• Introduction to Networking (Definition, Advantage, Disadvantage, Application)
• Analogue and digital communication.
• Modes of Communication:Simplex,Half Duplex, and Full duplex.
• Types of Network: LAN,MAN,WAN
• Network Architecture: Client-Server & Peer-to-Peer Networks.
• Serial and Parallel Communication.
• Bandwidth, Channel Capacity, Baud.
• Synchronous and Asynchronous Transmission Mode.
• Base band and Broadband Network.
• Components of Networks
• Servers(File server,Communication Server,Print server) and workstation.
• Guided Media.
• Cables:-UTP, STP,Co-axial,Fiber Optic.
• Unguided Media
• Infrared,Radio & Microwave Communication,Satellite.
• Network Operating System- Characteristic.
• Network Topologies
• BUS
• Ring
• Star
• Network Connecting Devices:
• Hub
• Repeater
• Bridge
• Switch
• Router
• Gateways
• LAN Protocols
• Ethernet(CSMA/CD) and Token Ring Protocol.
• Switching Technique
• Circuit,Message and Packet Switching.
• Use of MODEM
• TCP/IP Protocols
• TCP
• IP
• UDP
• FTP
• HTTP
• ISP
• IP Addressing
• class A
• Class B
• Class C
• 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.
• Computer Virus,  Concept of Firewall, Password.
• HTML 
• Basic Page design, using Ordered and Unordered Lists, Using Image,Hyperlinking,Using tables.

➤ Click Here to see the video for Networking part 1:

➤ Click Here to see the video for Networking part 2:

➤ Click Here to see the video for Networking part 3:

➤ Click Here to see the video for HTML part 1:

➤ Click Here to see the video for HTML part 2:

➤ Click Here to see the video for HTML part 3:

➤ Click here to Download the tutorial

C. Database Management system (15 Marks)

• Introduction to Database:
• Definition of Database.
• Advantage and Disadvantage of DBMS.
• Database Languages (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 Users.
• Functions of DBA.
• Relational Model
• Concepts of Relation,Tuple,Attribute,Domain,Degree,Cardinality.
• Concepts of key - Key,Super key,Candidate key,Primary Key, Alternate Key.
• Concepts of Relations - 1:1,1:N,N:M relationships.
• Database Constrains - Equity Integrity Constrain,Domain Constraint,Referential integrity Constraint and concept of Foreign Key.
• Relational Algebra:
• Selection Operation
• Projection Operation
• Set operation
• Cartesian product
• Natural Join Operation
• SQL
• Simple SELECT Quires(SELECT,FROM,WHERE,DISTINCT,AND,OR,IN,NOT IN,BETWEEN,LIKE,ORDERED BY.

➤ Click Here to see the video for DBMS part 1:

➤ Click Here to see the video for DBMS part 2:

➤ Click Here to see the video for DBMS part 3:

➤ Click Here to see the video for DBMS part 4:

➤ Click Here to see the video for DBMS part 5:

➤ Click Here to see the video for DBMS part 6:

D. Introduction to Spread Sheet (MS Office-2007 or Compatible)(10 Marks)

• Introduction to Excel.
• Concepts of Workbook,Worksheet,Row,Column,cell
• Creating Opening,Editing,Saving a Workbook
• Changing Row and Column Widths.
• Formatting Cells.
• Different Type 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 Referencing.
• Making calculations and re-calculations.
• Auto fill,Fill with series
• Conditional formatting.
• Sorting and Filtering  data (use of Auto Filter)
• Goal Seek.
• Hiding Rows and Columns.
• Use of Macros.
• Creating Line Diagrams,Pie Charts, Bar Graphs.

➤ Click Here to see the video for MS Excel 2007 part 1:

➤ Click Here to see the video for MS Excel 2007 part 2:

E. Using MS Access (MS Office 2007 or Compatible)

• Introduction to Access
• Tables creating using Design View and Wizard
• Different data types in Access
• Manipulation of data using Access Facilities-Inserting, Updating, Deleting Data.
• Creating Relationship between Tables
• Form creation using Wizard , Auto Form
• Query Generation using Design view.
• Report Generation using Wizard, Auto Report.

Click Here to see the video for MS Access 2007 part 1:

F. Practical

• Using MS Excess and MS Excel.
• Web page Design using HTML.
• Project Work(two Projects)
• Suggestive topics
• Application of Excel
• Using Excel creation of Mark Sheet, Balance Sheet, Monthly/Yearly.
• Expenditures,Reports.
• Web page designing using HTML(minimum 5 linked pages)
• Travel tourism.
• Festivals.
• Book catalog.
• Pollution and pollution Control
• Viva voce.