ARMY PUBLIC SCHOOL, KANDRORI 
                          SPLIT-UP SYLLABUS (Subject – INFORMATICS PRACTICES) 
                                                SESSION: 2022-23 
                                                    CLASS- XII                                     
      Month      Expected     Chapter / UNIT   Detailed Split Up Syllabus     Periods for class   Practical 
                 No. of                                                       room Teaching 
                 Working 
                 Days 
      April      23           UNIT – 1         Introduction to Python                18                05 
                              Data Handling    libraries: 
                              using Pandas -I  Pandas 
                                                
                                               Data structures in 
                                               Pandas: 
                                                Series and Data Frames. 
                                                
                                               Series:  
                                               Creation of Series from: 
                                               ndarray, dictionary, scalar 
                                               value;  
                                               List, 
                                               mathematical operations on 
                                               Series using operators  and 
                                               functions;  
                                               Head and Tail functions; 
                                               Selection,  
                                               Indexing and  
                                               Slicing ,  
                                               Series attributes. 
      May        15                            Data Frames:                          11                04 
                                               creation –  
                                               from dictionary of Series, 
                                                list of dictionaries, NESTED 
                                               list , 
                                                array. 
                                                
                              Data handling    Operations on rows and 
                              using Pandas –   columns:  
                              II               Operations on rows and 
                                               columns: add ( insert 
                                               /append) , select, delete 
                                               (drop column and row), 
                                               rename. 
      June       10           Vacation         Head  and  Tail  functions,            4              - 
                                               indexing     using    labels, 
                                               Boolean Indexing: 
       July          23                                 Text/CSV files; display;                      19                   04 
                                                        iteration. 
                                                        Importing/Exporting          Data 
                                                        between  CSV  files  and  Data 
                                                        Frames. 
                                                         
                                   Data                 Data  Visualization  Purpose  of 
                                   Visualization        plotting;  drawing  and  saving 
                                   & Revision for       following types of plots using  
                                   UT 1                 Matplotlib – line plot, bar graph 
                                                        . 
                                   UT – 1 Exam 
       Aug           23            Data                 histogram  Customizing  plots:                20                   03 
                                   Visualization        adding label, title, and legend in 
                                                        plots 
                                   UNIT 2:              Customizing plots: 
                                   Database              color, style : Line style using 
                                   Query using          (dashed,      dotted),     width, 
                                   SQL                  adding label, title, and legend 
                                                        in plots. 
                                                        Math functions:  
                                                        POWER (), ROUND (), MOD () 
                                                        ,  ABS()  ,  SQRT(),  FLOOR()  , 
                                                        CEIL(). 
                                                         
                                                         
                                                        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 (*). 
       Sep           25                                 Querying  and  manipulating                   20                   05 
                                                        data using Group by, Having, 
                                                        Order 
                                   UNIT  3:             Introduction  to  networks, 
                                   Introduction to      Types of network: LAN, MAN, 
                                   Computer             WAN. 
                                   Networks             Network  Devices:  modem, 
                                                        hub, switch, repeater, router, 
                                   Revision for         gateway 
                                   Half Yearly           
                                   Exam                 Network  Topologies:  Star, 
                                                    Bus, Tree, Mesh. 
                                Half Yearly         Introduction to Internet, URL, 
                                exam                WWW and  its  applications- 
                                                    Web, email, Chat, VoIP. 
                                                    Web Browsers: Introduction, 
                                                    commonly  used  browsers, 
                                                    browser  settings,  add-ons 
                                                    and plug-ins, cookies. 
      Oct          15           UNIT  4:            Digital  footprint,  net  and             13                 02 
                                Societal            communication      etiquettes, 
                                Impacts             data  protection,  intellectual 
                                                    property rights (IPR), 
                                                    plagiarism,   licensing    and 
                                                    copyright,  free  and  open 
                                                    source    software     (FOSS), 
                                                    cybercrime and cyber laws, 
                                                    hacking,    phishing,    cyber 
                                                    bullying,  overview  of  Indian 
                                                    IT Act. 
                                                    E-waste:      hazards      and 
                                                    management. 
                                                    Awareness     about     health 
                                                    concerns related to the usage 
                                                    of technology. 
      Nov          23           Practical File ,                   -                          10                 13 
                                Project Work 
                                and Revision 
                                for UT 2 
                                 
                                UT 2 Exam 
      Dec          25           Finalizing                         -                          13                 12 
                                Project and                         
                                Practical File                      
                                work.                               
                                                                    
                                Preboard 1                          
                                                                    
      Jan          13           Project work ,                     -                          15                 03 
                                Practical 
                                checking  & 
                                Revision 
                                 
                                Preboard 2 
      Feb          22             Revision for                     -                          22                  - 
                                   Final Exam 
      Mar                         Revision for                     -                          25                  - 
                                   Final Exam  
                                 & Commencing 
                                     of Final 
                                 Practical as per 
                                      CBSE 
                                   Guidelines