Informatics Practices XI Class

Introduction of Computer System

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

Introduction Python Programming:

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


Introduction to Python modules: importing math (sqrt, ceil, floor, pow, fabs), random (random, randint, randrange), statistics (mean, median) modules.

Unit 3: Data Handling:

Numpy 1D array, 2D array Arrays: slices, joins, and subsets. Arithmetic operations on

2D arrays.

Data Management:

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 along with BETWEEN, IN, LIKE. (Queries only on single table)

Aggregate Functions: MIN, MAX, AVG, COUNT, SUM

Society, Law and Ethics:

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.