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
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.