(Optional for the 2018-19 school year and mandatory for the 2019-20 school year and beyond)
1. Prerequisites: No basic prerequisites are required for this course other than basic math skills. However, it will be helpful if the student has a basic knowledge of computer applications.
2. Learning outcomes:
- Develop basic computational thinking. Learn how to reason with variables, state transitions, conditions, and iterations.
- Understand the concept of data types and higher-order data structures such as lists, tuples, and dictionaries.
- Assess the concept algorithm and understand its structure, including how the algorithms handle corner cases.
- Develop basic knowledge of computer systems — architecture, OS, mobile and cloud computing.
- Learn the basics of SQL programming.
- Learn all about cybersecurity.
3. Distribution of signs
Unit No. Unit Name Marks 1. Programming and Computational Thinking - 1 35 2. Computer Systems and Organization 10 3. Data Management - 1 15 4. Society, Law and Ethics - 1 10 5. Practical 30 Total 100
4.1 Unit 1: Programming and Computational Thinking (PCT-1) (80 Theory + 70 Practical)
An introduction to the basics of Python programming: a simple hello world program , L-values and Rvalue, even if not explicitly taught), if, if-else, if-elif-else ; simple programs: for example: decision trees and pseudocode; write many programs: factorials .
Debugging idea: lists , tuples and accessing items in a collection using numbers and names.
Sorting algorithm: Strings in Python : comparison, concat , Basic Computer Organization : Description of the computer system and mobile system, processor, memory, hard disk, I / O, battery, power.
Software types: bit, byte, MB, GB, TB, and PB .
Boolean logic: De Morgan’s laws Number representation: base numbers 2, 8, 16, unsigned integers, binary addition
Strings: ASCII, UTF8, UTF32, ISCII (Indian script code )
Program execution: main compilation thread — interpreters (process one line at a time) , difference between compiler and interpreter , operating system as resource manager .
Cloud computing: relationship , keys, primary key, foreign key ; delete table .
SQL Commands: design and combine ; indexes and lots of practice in the classroom.
NoSQL Database Basics : adware, viruses, trojans
Secure data transfer: secure connections, eavesdropping, phishing and identity verification.
|S.No.||Unit Name||Marks (Total = 30)|
|1.||Lab Test (12 marks)|
|td >|| Python program (60% logic + 20% documentation + 20% code |
|SQL program (at least 4 queries)||4|
|2.||Report File + viva ( 10 marks)|
|Report file: Minimum 20 Python programs and 8 SQL commands||7|
|Viva voce (based on the report file)||3|
|3.|| Project (that uses most of the concepts that have been learned) |
(See CS-XII for the rules regarding the projects ).
5.1. Python Programming: By at least the following Python concepts should be covered in a
lab sessions: expressions, conditionals, loops, list, dictionary, and strings. Below are some typical lab assignments.
- Find the third largest listed number .
- Find if a string is palindrome or not .
- Given two integers x and n, calculate x n. is the number equal to the sum of the cubes of its digits . Find the smallest and largest such numbers.
5.2. Data management: SQL commands. During the lab, at least the following SQL commands should be considered: delete , select and