1. Learning Outcomes
2. Distribution of Marks and Periods
|Unit No.||Unit Name||Marks||Periods|
|1||Introduction to Computer System||5||3||2|
|2||Introductory Python Programming||30||45||35|
|5||Society, Law and Ethics||10||10||0|
2.1 Unit 1: 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
2.2 Unit 2: 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 module).
Introduction to Python modules: importing math (sqrt, ceil, floor, pow, fabs), random (random, randint, randrange), statistics (mean, median) modules.
2.3 Unit 3: Data Handling
Numpy 1D array, 2D array Arrays: slices, joins, and subsets. Arithmetic operations on 2D arrays.
2.4 Unit 4: 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 alongwith BETWEEN, IN, LIKE. (Queries only on single table) Aggregate Functions : MIN , MAX, AVG, COUNT, SUM
Unit 5: 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.
3. Class XI Practical
|Sr. No.||Unit Name||Marks|
|1||Problem solving using arithmetic operations, conditional statements and iterations with the help of a Python program 60% logic + 20% documentation + 20% code quality (To be tested on the day of the final exam)||6|
|2||Problem solving using numPy |
(To be tested on the day of the final exam)
|3||SQL - 5 Queries based on single table |
(To be tested on the day of the final exam)
|4||Report File |
1. Minimum 20 Python Programs
2. Minimum 20 SQL Queries
|6||Project using the concepts learnt in the course||5|
4. Programming in Python
(Sample problems to be solved using expressions, conditions, loops, list, dictionary, and strings.)
5. Data Handling
The following are some representative lab assignments.
6. Data Management using SQL Commands
At least the following SQL commands should be covered during the labs: create, insert, delete, select.
The following are some representative assignments.
A complete solution of a problem stating the problem, objective, source code, output Students in group of 2-3 are required to work collaboratively to develop a project using Programming Skills learnt during the course.
(Sample Examples can be a combination of few problems illustrated above)
Classes Everyday starting 4:30 PM in center
Course Fees Starts From– $499.00
THERE ARE LIMITED SEATS. SO BOOK YOUR SPOT TODAY!