Page 10 - Informatics_Practices_Fliipbook_Class12
P. 10

INFORMATICS PRACTICES                                                          CLASS-XII



                                   [CODE-065]




            1.  Prerequisites
                Informatics Practices – Class XI
            2.  Learning Outcomes
                At the end of this course, students will be able to:
                a.  Create Series, Data frames and apply various operations.
                b.  Visualize data using relevant graphs.
                c.  Design SQL queries using aggregate functions.
                d.  Import/Export data between SQL database and Pandas.
                e.  Learn terminology related to networking and internet.
                f.  Identify internet security issues and configure browser settings.
                g.  Understand the impact of technology on society including gender and disability issues.
            3.  Distribution of Marks and Periods:

                  Unit                  Unit Name                   Marks       Periods     Periods      Total
                  No.                                                           Theory      Practical   Periods
                   1.   Data Handling using Pandas and Data Visualization  25     25          25          50
                   2.   Database Query using SQL                      25          20          17          37
                   3.   Introduction to Computer Networks             10          12           -          12
                   4.   Societal Impacts                              10          14           -          14
                        Project                                       -            -          7           7
                        Practical                                     30           -           -          -
                        Total                                        100          71          49         120
            4.  Unit Wise Syllabus
                Unit 1: Data Handling using Pandas-I
                   Introduction to Python libraries- Pandas, Matplotlib.
                   Data structures in Pandas - Series and Data Frames.
                   Series: Creation of Series from – ndarray, dictionary, scalar value; mathematical operations; Head and Tail functions; Selection,
                   Indexing and Slicing.
                   Data Frames: creation - from dictionary of Series, list of dictionaries, Text/CSV files; display; iteration; Operations on rows and
                   columns: add, select, delete, rename; Head and Tail functions; Indexing using Labels, Boolean Indexing;
                   Importing/Exporting Data between CSV files and Data Frames.
                Data Visualization

                   Purpose of plotting; drawing and saving following types of plots using Matplotlib – line plot, bar graph, histogram
                  Customizing plots: adding label, title, and legend in plots.
                Unit 2: Database Query using SQL
                   Revision of database concepts and SQL commands covered in class XI
                   Math functions: POWER (), ROUND (), MOD ().
                   Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM
                   (), RTRIM (), TRIM ().
                   Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME ().
                   Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*).
                   Querying and manipulating data using Group by, Having, Order by.
                   Working with two tables using equi-join

                                                            (viii)
   5   6   7   8   9   10   11   12   13   14   15