|
|
|
|
|
COMPUTER-K12-CLASS-11 |
|
1 Programming and Computational Thinking (PCT-1)
Getting started with PYTHON Python Fundamentals Data Handling Conditional and Iterative statements 2 2 2 Debugging Programs
List Manipulations --- 3 3 Tuples --- Dictionaries --- Sorting Algorithms (Bubble and Insertion Sort) --- String Manipulations
2 Computer Systems and
Organisation (CSO) 3 15 4 10 4 10 Computer System Overview
Data Representations 4 Boolean Logic 5 5 Insight into Program Execuation 5
3 Data Management (DM-1) 6 13 6 15 6 15
Relational Database Table creation and Data Manipulation Table Joins and Indexes in SQL --- Basics of NoSQL, DatabaseMongoDB ---
4 Society, Law and Ethics (SLE-1) 7 12 7 10 7 10 Cyber Safety Online Access and Computer Security
UNIT 1: Programming and Computational Thinking (PCT-1)
Familiarization with the basics of Python programming: a simple “hello world" program, process of writing a program, running it, and print statements; simple datatypes: integer, float, string Introduce the notion of a variable, and methods to manipulate it (concept of L-value and R-value even if not taught explicitly) Knowledge of data types and operators: accepting input from the console, assignment statement, expressions, operators and their precedence. Conditional statements: if, if-else, if-elif-else; simple programs: e.g.: absolute value, sort 3 numbers, and divisibility. Notion of iterative computation and control flow: for, while, flowcharts, decision trees and pseudo code; write a lot of programs: interest calculation, primarily testing, and factorials. Idea of debugging: errors and exceptions; debugging:pdb, break points. Lists, tuples and dictionary: finding the maximum, minimum, mean; linear search on list/tuple of numbers, and counting the frequency of elements in a list using a dictionary. Introduce the notion of accessing elements in a collection using numbers and names. Sorting algorithm: bubble and insertion sort; count the number of operations while sorting. Strings: compare, concat, substring; notion of states and transitions using state transition diagrams.
UNIT 2 :Computer Systems and Organisation (CSO) Basic computer organisation: description of a computer system and mobile system, CPU, memory, hard disk, I/O, battery, power. Types of software: application, OS, utility, libraries. Language of Bits: bit, byte, MB, GB, TB, and PB. Boolean logic: OR, AND, NAND, NOR, XOR, NOT, truth tables, De Morgan’s laws Information representation: numbers in base 2, 8, 16, unsigned integers, binary addition Strings: ASCII, UTF8, UTF32, ISCII (Indian script code) Execution of a program: basic flow of compilation – program ŕ binary ŕ execution Interpreters (process one line at a time), difference between a compiler and an interpreter Running a program: Notion of an operating system, how an operating system runs a program, idea of loading, operating system as a resource manager. Concept of cloud computers, cloud storage (public/private), and brief introduction to parallel computing.
UNIT 3 :Data Management (DM-1) Relational databases: idea of a database and the need for it, relations, keys, primary key, foreign key; use SQL commands to create a table, keys, foreign keys; insert/delete an entry, delete a table. SQL commands: select, project, and join; indexes, and a lot of in-class practice. Basics of NoSQL databases - Mongo DB
UNIT 4 :Society, Law and Ethics (SLE-1) Cyber safety: safely browsing the web, identity protection, confidentiality, social networks, 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, phishing and identity verification.
PRACTICAL (PT-2) Duration : 3 hours Total Marks : 30 1. a. Programming [8+8+4] Two Python programs allotted on the following basis Logic : 4 Marks Indentation : 2 Marks Output : 2Makrs b. SQL ( at least 4 Queries ) : 4 Marks 2. Practical File [6] Record must have 10Python programs along with 5Sql Commands from the topic covered during half yearly syllabus. 3. Viva voce [4] Record must have minimum 10 programs along with configuration of the system from the topic covered during Half Yearly syllabus.
PRACTICAL (ANNUAL) Duration : 3 hours Total Marks : 30 1. a. Programming [8+4] A Python program allotted on the following basis Logic : 4 Marks Indentation : 2 Marks Output : 2Makrs
b. SQL ( at least 4 Queries ) : 4 Marks
2. a. Practical File [7] Record must have 10Python programs along with 5Sql Commands from the topic covered during half yearly syllabus. b. Viva voce (Based on Practical File) [3] Record must have minimum 10 programs along with configuration of the system from the topic covered during Half Yearly syllabus. 3. Project ( That uses most of the concepts that have been learnt) [8]
GUIDELINES FOR PROJECTS Preamble 1.1 The academic course in Computer Science includes on Project in each year. The Purpose behind this is to consolidate the concepts and practices imparted during the course and to serve as a record of competence.
1.2 A group of 2-3 students as team may be allowed to work on one project.
2. Project content 2.1 Project for class XI can be selected from the topics mentioned in the syllabus or domains on the similar lines
2.2 Project for class XII should ensure menu driven programs using: a. Conditional Statements b. Iteration c. List, Tuple, Dictionary d. String Theme of the project can be Any Billing Software
Quizzes / Games;
It is suggested to prepare a bilingual (English and other Indian language) user manual part of project file
The aim of the project is to highlight the abilities of algorithmic formulation, modular programming, optimized code preparation, systematic documentation and other associated aspects of Software Development. |