Information Practises

Information Practises syllabus for Grade 12

Information Practice Syllabus for Grade 12:

• Unit 1: Data Handling using Pandas and Data

• Visualization 

• Unit 2: Database Query using SQL

• Unit 3: Introduction to Computer Networks

• Unit 4:Societal Impacts

Unit 1: Data Handling using Pandas and Data Visualization

• What is Python programming and what is the concept of Libraries

• Explains the more popular data handling Libraries like Pandas and Matplotlib.

• They are able to install the libraries in their system with the proper system path

• The Series and DataFrame are created using a list, dictionaries and other datatypes

• Know the use of different types of Maths functions in the questions

• The Series and DataFrame is created using lists, dictionaries and other datatypes

• Know the use of Different types of Maths functions in the questions

• Create Series and data frames and apply various operations.

• Design SQL queries using aggregate functions

• Import/Export data between SQL database and Pandas.

• Students will get the concept of Graphs to represent data in pictures

• Visualize data using relevant graphs

• Using properties of Graphs to display the graph in a proper way.

Unit 2: Database Query using SQL

• Database and its use

• How database works

• Design SQL queries using aggregate functions.

• Different functions in the Database to extract filtered data from the huge database

• Use of Set and Relational Concepts of Maths to get complex data in simple form

• Database queries to search using a set and a subset of data

• SQL queries 

Unit 3:Introduction to Computer Networks

• Learn terminology related to networking and the internet.

• Identify internet security issues and configure browser settings.

Unit 4:Societal Impacts

• Understand the impact of technology on society including gender and disability issues

Enhance Technology Skills

Essential Resources

• https://drive.google.com/file/d/1uuaPoM9DJIXUcP6G6Vb_yAsCGKL5OqHM/view?usp=sharing