Lecture Map
Source order: CBSE-Paper-Analyzer Export Subtopic List order
Theory: 34 PYQ: 57 Total: 91 Export Excel
Class Lecture Allocation
Edit only Theory and PYQ counts. Lecture names are generated from Primary Sub-subtopic. Use 0.5 + 0.5 to combine Theory and PYQ into one lecture when slots are tight.
Unit Subtopic Primary Sub-subtopic Concept_ID Theory PYQ Total
Unit 1: Computational Thinking and Programming – 2 Revision of Python & Core Concepts Python basics, tokens, identifiers and comments U1_PYTHON_BASICS 0
Unit 1: Computational Thinking and Programming – 2 Revision of Python & Core Concepts Data types, conversion and mutability U1_DATA_TYPES_MUTABILITY 0
Unit 1: Computational Thinking and Programming – 2 Revision of Python & Core Concepts Operators, precedence and expression evaluation U1_OPERATORS_EXPRESSIONS 0
Unit 1: Computational Thinking and Programming – 2 Revision of Python & Core Concepts Errors and syntax correction U1_ERRORS_SYNTAX 0
Unit 1: Computational Thinking and Programming – 2 Revision of Python & Core Concepts Control flow and loops U1_CONTROL_FLOW_LOOPS 0
Unit 1: Computational Thinking and Programming – 2 Revision of Python & Core Concepts String operations U1_STRING_OPS 0
Unit 1: Computational Thinking and Programming – 2 Revision of Python & Core Concepts List and tuple operations U1_LIST_TUPLE_OPS 0
Unit 1: Computational Thinking and Programming – 2 Revision of Python & Core Concepts Dictionary operations U1_DICTIONARY_OPS 0
Unit 1: Computational Thinking and Programming – 2 Functions and Modules Function definition, call and return U1_FUNCTION_DEF_RETURN 0
Unit 1: Computational Thinking and Programming – 2 Functions and Modules Arguments, parameters and scope U1_FUNCTION_ARGS_SCOPE 0
Unit 1: Computational Thinking and Programming – 2 Functions and Modules Function output tracing U1_FUNCTION_OUTPUT_TRACE 0
Unit 1: Computational Thinking and Programming – 2 Functions and Modules Built-in modules and library functions U1_MODULES_LIBRARY 0
Unit 1: Computational Thinking and Programming – 2 Exception Handling Try-except-finally and exception types U1_EXCEPTION_HANDLING 0
Unit 1: Computational Thinking and Programming – 2 File Handling File basics, paths, modes, seek and tell U1_FILE_BASICS_MODES 0
Unit 1: Computational Thinking and Programming – 2 File Handling Text file reading writing searching and counting U1_TEXT_FILE_OPERATIONS 0
Unit 1: Computational Thinking and Programming – 2 File Handling Binary file operations with pickle U1_BINARY_PICKLE_OPS 0
Unit 1: Computational Thinking and Programming – 2 File Handling CSV file read, write and search U1_CSV_OPS 0
Unit 1: Computational Thinking and Programming – 2 Stack Data Structure Stack concept and operations using list U1_STACK_LIST_OPS 0
Unit 2: Computer Networks Network Basics and Communication Network evolution and communication terms U2_NETWORK_EVOLUTION_COMM 0
Unit 2: Computer Networks Network Basics and Communication Transmission media U2_TRANSMISSION_MEDIA 0
Unit 2: Computer Networks Network Devices, Topologies and Case Studies Network devices U2_NETWORK_DEVICES 0
Unit 2: Computer Networks Network Devices, Topologies and Case Studies Network types and topologies U2_TOPOLOGIES_TYPES 0
Unit 2: Computer Networks Network Devices, Topologies and Case Studies Network case study and layout design U2_NETWORK_CASE_LAYOUT 0
Unit 2: Computer Networks Network Protocols and Web Services Network protocols U2_PROTOCOLS 0
Unit 2: Computer Networks Network Protocols and Web Services Web services, HTML/XML, URL and browser U2_WEB_SERVICES 0
Unit 3: Database Management Database Concepts and Relational Model DBMS basics and relational terms U3_DBMS_RELATIONAL_TERMS 0
Unit 3: Database Management Database Concepts and Relational Model Keys and constraints U3_KEYS_CONSTRAINTS 0
Unit 3: Database Management SQL DDL and Table Structure Database/table commands, data types and constraints U3_DDL_TABLE_STRUCTURE 0
Unit 3: Database Management SQL DML, Clauses and Operators SELECT and WHERE filtering U3_SELECT_WHERE 0
Unit 3: Database Management SQL DML, Clauses and Operators INSERT, UPDATE and DELETE U3_INSERT_UPDATE_DELETE 0
Unit 3: Database Management SQL DML, Clauses and Operators SQL operators, IN, BETWEEN and LIKE U3_SQL_OPERATORS_FILTERS 0
Unit 3: Database Management SQL DML, Clauses and Operators NULL, DISTINCT and ORDER BY U3_NULL_DISTINCT_ORDER 0
Unit 3: Database Management SQL Aggregate, Grouping and Joins Aggregate functions U3_AGGREGATE_FUNCTIONS 0
Unit 3: Database Management SQL Aggregate, Grouping and Joins GROUP BY and HAVING U3_GROUP_BY_HAVING 0
Unit 3: Database Management SQL Aggregate, Grouping and Joins Joins U3_JOINS 0
Unit 3: Database Management Python-MySQL Connectivity Connection, cursor, execute, fetch and commit U3_PYMYSQL_METHODS 0
Unit 3: Database Management Python-MySQL Connectivity Python-MySQL query applications U3_PYMYSQL_APPLICATIONS 0
Totals 34 57 91
Heads up: submitting rebuilds this class lecture list and schedule from the configured start/end dates. A planner database backup is created first.