Information Practices (065)
- Course Outline
- 8 Months
- 4 Sessions/Month
Introduction to Computer Systems
Evolution of computing devices, components of a computer system, input/output devices, memory types, data security, and types of software (system and application).
Python Programming Fundamentals
Basics of Python: syntax, operators, data types, expressions, control statements, loops, lists, and dictionaries.
Introduction to NumPy and creating arrays from lists.
Database Concepts & SQL (Class XI)
Introduction to databases and RDBMS, data models, and SQL operations: CREATE, SELECT, INSERT, UPDATE, DELETE, and filtering with WHERE, BETWEEN, and logical operators.
Emerging Technologies
Overview of AI, Machine Learning, NLP, AR/VR, Robotics, Big Data, IoT, Cloud and Grid Computing, and Blockchain technology.
Data Handling with Pandas (Class XII)
Working with Pandas Series and DataFrames: creation, indexing, slicing, and performing operations using Python.
Importing/exporting data between CSV files and DataFrames.
Data Visualization
Using Matplotlib for creating line, bar, and histogram plots; customizing charts with labels, titles, and legends for data interpretation.
Advanced SQL Operations
Use of mathematical, text, and date functions; aggregate functions; Group By, Having, and Join operations for relational data management.
Computer Networks & Internet Concepts
Basics of PAN, LAN, MAN, WAN; network devices and topologies; internet concepts like URL, WWW, web pages, and browser configuration.
Societal and Ethical Impacts of IT
Cyber safety, digital footprints, net etiquettes, data protection, intellectual property rights, plagiarism, e-waste management, and awareness about tech-related health issues.
Practical and Project Work
Hands-on Python and SQL exercises, Pandas and Matplotlib applications, and a project integrating Class XIβXII concepts.
Introduction to Computer Systems
Evolution of computing devices, components of a computer system, input/output devices, memory types, data security, and types of software (system and application).
Python Programming Fundamentals
Basics of Python: syntax, operators, data types, expressions, control statements, loops, lists, and dictionaries.
Introduction to NumPy and creating arrays from lists.
Database Concepts & SQL (Class XI)
Introduction to databases and RDBMS, data models, and SQL operations: CREATE, SELECT, INSERT, UPDATE, DELETE, and filtering with WHERE, BETWEEN, and logical operators.
Emerging Technologies
Overview of AI, Machine Learning, NLP, AR/VR, Robotics, Big Data, IoT, Cloud and Grid Computing, and Blockchain technology.
Data Handling with Pandas (Class XII)
Working with Pandas Series and DataFrames: creation, indexing, slicing, and performing operations using Python.
Importing/exporting data between CSV files and DataFrames.
Data Visualization
Using Matplotlib for creating line, bar, and histogram plots; customizing charts with labels, titles, and legends for data interpretation.
Advanced SQL Operations
Use of mathematical, text, and date functions; aggregate functions; Group By, Having, and Join operations for relational data management.
Computer Networks & Internet Concepts
Basics of PAN, LAN, MAN, WAN; network devices and topologies; internet concepts like URL, WWW, web pages, and browser configuration.
Societal and Ethical Impacts of IT
Cyber safety, digital footprints, net etiquettes, data protection, intellectual property rights, plagiarism, e-waste management, and awareness about tech-related health issues.
Practical and Project Work
Hands-on Python and SQL exercises, Pandas and Matplotlib applications, and a project integrating Class XIβXII concepts.
One-Time:
INR 10800
Monthly: INR 1500