Advertisement Remove all ads

Informatics Practices Class 12 CBSE (Commerce) CBSE Topics and Syllabus

Advertisement Remove all ads
Academic year:


100 Networking and Open Standards
101 Computer Networking
  • Networking: a brief overview,
  • Communication Media: Wired Technologies - Co-Axial,Ethernet Cable, Optical Fiber; Wireless Technologies - Blue Tooth, Infrared, Microwave, Radio Link, Satellite Link;
  • Network Devices: MODEM, Hub, Switch, Repeater, Gateway - and their functions
  • Types of network: LAN, MAN, WAN, PAN;
  • Network Topologies: Star, Bus, Tree
  • Network Protocols: HTTP, TCP/IP, PPP, Remote access software such as Team Viewer;
  • Identifying computers and users over a network:Basic concept of domain name, MAC (Media Access Control), and IP Address, domain name resolution
  • Network Security Concepts: Cyber Law, Firewall, Cookies, Hackers and Crackers
  • Network security threats: denial of service, intrusion problems, snooping, eavesdropping
  • Internet Applications: SMS, Voice Mail, Electronic Mail, Chat, Video Conferencing
  • Wireless/ Mobile Communication: GSM, CDMA, WLL, 3G, 4G
102 Open Source Concepts
  • Open Source Software (OSS), common FOSS/FLOSS examples (GNU/Linux, Firefox, OpenOffice, Java, Netbeans, MySQL), common open standards (HTML, XML, ODF, TCP/IP)
  • Indian Language Computing: character encoding, UNICODE, different types of fonts (open type vs true type, static vs dynamic), entering Indian Language Text - phonetic and key map based, lnscript.
200 Programming
  • Basic concept of class, object, inheritance and polymorphism.
  • Commonly used libraries:
  1. String class and methods: toString(), concat(), length(), toLowerCase(), toUpperCase(), trim(), substring()
  2. Math class methods: pow(), round()
  • Accessing MySQL database using JDBC to connect with database.
  • Web application development: URL, Web server, Communicating with the web server, concept of Client and Server Side
  • HTML based web pages covering basic tags - HTML, TITLE, BODY, H1..H6, B, I, U, CENTER, COMMENT, IMG, ANCHOR(A), Paragraph (P), Line Break (BR), Section Separator (HR), FONT, TABLE, LIST (UL, OL), FORM
  • Creating and accessing static pages us ng HTML and introduction to XML
300 Relational Database Management System
  • Concept of Database transaction, Committing and revoking a transaction using COMMIT, ROLLBACK and Savepoint.
  • Grouping Records: GROUP BY, Group functions - MAX(), MIN(), AVG(), SUM(), COUNT(); using COUNT(*), DISTINCT clause with COUNT; Group Functions and Null Values.
  • Creating a Table with PRIMARY KEY, FOREIGN KEY and NOT NULL constraints,Viewing Constraints, Viewingthe ColumnsAssociatedwith Constraints using DESC command.
  • Displaying Data From Multiple Tables: Cartesian product, Union, Intersection and Equi-Join
  1. deleting column(s), modifying data type(s) of column(s),
  2. adding a constraint, enabling constraints, dropping constraints.
  • DROP Table for deleting a table
400 IT Applications
  • Front-end Interface: Introduction; content and features; identifying and using appropriate component (Text Box, Radio Button, CheckBox, List etc. aslearnt in Unit 2 (Programming)) for data entry, validation and display.
  • Back-end Database: Introduction and its purpose, exploring the requirement of tables and its essential attributes.
  • Front-End and Database Connectivity: Introduct on, requirement and benefits
  • Demonstration and development of appropriate Front-endinterface and Back-end Database for e-Governance,e-Business and e-Learning applications
  • Impact of /CT on society: Social, environmental and Economic benefits.
Advertisement Remove all ads

BooksVIEW ALL [1]

Advertisement Remove all ads

View all notifications

      Forgot password?
View in app×