Computer Science Syllabus: Exception Handling, Database Concepts, and Computer Networks, Schemes and Mind Maps of Biology

Download Computer Science Syllabus: Exception Handling, Database Concepts, and Computer Networks and more Schemes and Mind Maps Biology in PDF only on Docsity!

Computer Science/

Informatics Practices - 308

Syllabus for Class 12

Computer Science/Informatics Practices

- 308

Section A

Exception and File Handling in Python

Exception Handling: syntax errors, exceptions, need of exception handling, user-defined

exceptions, raising exceptions, handling exceptions, catching exceptions, Try - except - else clause,

Try - finally clause, recovering and continuing with finally, built-in exception classes.

File Handling: text file and binary file, file types, open and close files, reading and writing text files,

reading and writing binary files using pickle module, file access modes.

Database Concepts

Introduction to database concepts, difference between database and file system, relational data model: concept of domain, tuple, relation, keys - candidate key, primary key, alternate key, foreign key; Relational algebra: selection, projection, union, set difference and cartesian product;

Structured Query Language

Advantages of using Structured Query Language, Data Definition Language, Data Query Language and Data Manipulation Language, Introduction to MySQL, Creating a database using MySQL, Data Types

Data Definition: CREATE TABLE, DROP TABLE, ALTER TABLE,

Data Query: SELECT, FROM, WHERE

Data Manipulation: INSERT, UPDATE, DELETE

Math functions: POWER (), ROUND (), MOD ().

Note: There will be one Question Paper which will contain Two Sections i.e. Section A and Section B [B and B2]. Section A will have 15 questions covering both i.e. Computer Science/Informatics Practices which will be compulsory for all candidates Section B1 will have 35 questions from Computer Science out of which 25 questions need to be attempted. Section B2 will have 35 questions purely from Informatics Practices out of which 25 question will be attempted.

Queue (List Implementation): Introduction to Queue (FIFO), Operations on Queue (INSERT and DELETE) and its implementation in Python. Introduction to DQueue and its implementation in Python.

Searching: Sequential search, Binary search, Analysis of Sequential and Binary Search. Dry run to

identify best, worst and average cases. Implementation of searching techniques in Python.

Overview of sorting techniques, Bubble Sort, Selection Sort and Insertion Sort. Dry run to identify

best, worst and average cases. Implementation of sorting techniques in Python.

Hashing: Hash Functions, Collision Resolution, Implementing the Map Abstract Data Type.

Data and its purpose, collection and organization; understanding data using statistical methods: mean, median, standard deviation, variance; data interpretation; visualization of data.

Introduction to database concepts, difference between database and file system, relational data model: concept of domain, tuple, relation, keys - candidate key, primary key, alternate key, foreign key; Relational algebra: selection, projection, union, set difference and cartesian product;

Advantages of using Structured Query Language, Data Definition Language, Data Query Language and Data Manipulation Language, Introduction to MySQL, Creating a database using MySQL, Data Types

Data Definition: CREATE TABLE, DROP TABLE, ALTER TABLE,

Data Query: SELECT, FROM, WHERE

Data Manipulation: INSERT, UPDATE, DELETE

Math functions: POWER (), ROUND (), MOD ().

Chapter 7: Database Concepts

Chapter 3: Queue

Chapter 4: Searching

Chapter 5: Sorting

Chapter 6: Understanding Data

Chapter 8: Structured Query Language

Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM (). Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME (). Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*). Querying and manipulating data using Group by, Having, Order by. Operations on Relations - Union, Intersection, Minus, Cartesian Product, JOIN

Introduction to computer networks, Evolution of networking, Network types: LAN, WAN, MAN Network devices: Modem, Ethernet Card, Repeater, Hub, Switch, Router, Gateway. Network Topologies: Mesh, Ring, Bus, Star, and Tree topologies

Basic concept of MAC and IP Address

Difference between Internet and web

Section B2: Informatics Practices

Math functions: POWER (), ROUND (), MOD (). Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM (). Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME (). Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*). Querying and manipulating data using Group by, Having, Order by. Operations on Relations - Union, Intersection, Minus, Cartesian Product, JOIN

Introduction to Python libraries- Pandas, NumPy,

Chapter 1: Database Query using SQL

Chapter 2: Data Handling using Pandas – I

Chapter 9: Computer Networks

phishing, cyberbullying, Overview of Indian IT Act, preventing cybercrime.

E-waste its a hazard and management

Awareness about health concerns related to the usage of technology like effect on eyesight, physiological issues, and ergonomic aspects.

Concept of communication, Types of Data Communication, switching techniques

Communication Media : Wired Technologies – Twisted pair cable, Co-axial cable, Ethernet Cable, Optical Fibre;

Introduction to mobile telecommunication technologies

Wireless Technologies – Bluetooth, WLAN, Infrared,

Microwave

Network Protocol: Need for Protocol, Categorization and Examples of protocol, HTTP, FTP, IP, PPP; electronic mail protocol

Concept of Channel, Bandwidth (Hz, KHz, MHz) and Data Transfer rate (bps, Kbps, Mbps, Gbps, Tbps)

Threats and prevention: Viruses, Worms, Trojan horse, Spam, Cookies, Adware, Firewall, http vs https

Network Security Concepts: Firewall, Cookies, Hackers and Crackers

Antivirus and their workings

Network security threats: Denial of service, Intrusion problems, Snooping, Eavesdropping

Chapter 10: Data Communication

Chapter 11: Security Aspects