Informatics Practices (New)
CLASS XI (Code No. 065)
2019-20
CLASS XI (Code No. 065)
2019-20
THEORY 70Marks:
Unit 1: Introduction of Computer System 5 Marks
Basic computer organisation: Computer system – I/O Devices, CPU, memory, hard disk, battery, power, transition from a calculator to a computer and further to smart devices.Trouble shooting with parts of computer and basic operations of operating system. Basic concept of Data representation: Binary, ASCII, Unicode.
Familiarization with the basic of Python programming: a simple "hello world" program, process of writing a program, running it, and print statements; simple data-types: integer, float, string. Introduce the notion of variable, and methods to manipulate it (concept of L-value and R-value even if not taught explicitly). Tokens - keywords, identifiers, Literals, Delimiters. Knowledge of data type and operators: accepting input from the console, assignment statement, expressions, operators (assignment, arithmetic, relational and logical) and their precedence.
Conditional statements: if, if-else, if-elif-else; simple programs: e.g.: absolute value, sort 3 numbers, divisibility.
Notion of iterative computation and control flow: for ( range() , len()), while, flowcharts.
Suggested programs: finding average and grade for given marks, amount calculation for given cost-qty-discount, perimeter-wise/ area-wise cost calculation, interest calculation, profit-loss, EMI, tax calculation (example from GST/Income Tax).
List and dictionary: finding the maximum, minimum, mean; linear search on a list of numbers, and counting the frequency of elements in a list using a dictionary.
Text handling: compare, concat, and substring operations (without using string module).
Introduction to Python modules: importing math (sqrt, ceil, floor, pow, fabs), random (random, randint, randrange), statistics (mean, median) modules.
Numpy 1D array, 2D array Arrays: slices, joins, and subsets. Arithmetic operations on 2D arrays.
Relational databases: Concept of a database, relations, attributes and tuples, keys - candidate key, primary key, alternate key, foreign key; Degree and Cardinality of a table.
Use SQL - DDL/DML commands to CREATE TABLE, INSERT INTO, UPDATE TABLE, DELETE FROM, ALTER TABLE, MODIFY TABLE, DROP TABLE, keys, and foreign keys; to view content of a table: SELECT-FROM-WHERE-ORDER BY alongwith BETWEEN, IN, LIKE. (Queries only on single table)
Aggregate Functions : MIN , MAX, AVG, COUNT, SUM
Cyber safety: safely browsing the web, identity protection, confidentiality, social networks, netiquettes, digital footprint, cyber trolls and bullying. Appropriate usage of social networks: spread of rumours, and common social networking sites (Twitter, LinkedIn, and Facebook) and specific usage rules.
Safely accessing web sites: adware, malware, viruses, Trojans.Safely communicating
data: secure connections, eavesdropping, and phishing and identity verification.
Reference:-
1. http://cbseacademic.nic.in/curriculum.html