Mpvm.edu.in



MAHARSHI PATANJALI VIDYA MANDIR, PRAYAGRAJSYLLABUS BREAKUP: 2020 - 2021SUBJECT: INFORMATICS PRACTICESCLASS - XI MONTHCHAPTERTOPICSMayGetting started with PythonAssignment statement, expressions, operators and their precedence. Familiarization with the basics of Python programming: a simple “hello world" program, process of writing a program, running it, and print statements;JulyData typesIntroduction, integer, float, string Introduce the notion of a variable, and methods to manipulate it (concept of L-value and Rvalue even if not taught explicitly) Knowledge of data types and operators: accepting input from the console,Mutable and Immutable types.AUGUSTConditional statements and flow of controlif, if-else, if-elif-else; simple programs: e.g.: absolute value, sort 3 numbers, divisibility. Notion of iterative computation and control flow: for, while, flowcharts, decision trees and pseudo code; write a lot of programs: interest calculation, EMI, tax calculation (examples from GST), standard deviation, correlation Lists and dictionary: finding the maximum, minimum, mean; linear search on a list of numbers, and counting the frequency of elements in a list using a dictionary. SEPTEMBERString Manipulation Substring operations, string slicing Introduction to Python modules: creating and importing modules.OCTOBERData Handling List manipulation, creating/accessing a list, list operations.Dictionaries, key-value pairs, accessing key-values, Dictionaries functions. NOVEMBERIntroduction to numpy library, ways to create numpy arrays, One dimensional and two dimensional arrays. Calculation of sum, mean median, mode standard deviations, variance on numpy arrays.DECEMBERData ManagementRelational databases: idea of a database and the need for it, relations, keys, primary key, foreign key; Use SQL DDL , DML commands to create, alter, drop a table, primary key and foreign key; insert/delete/update an entry in a table. JANUARY Basic SQL: select, project, and join( equi, non-equi, natural joins) to viewing data from multiple tables and a lot of in-class practice.FEBRUARYProject Work.TEST -IGetting Started with Python, Data TypesHALF YEARLY EXAMINATIONGetting Started with Python, Conditional statement and flow of control, String ManipulationTEST-IIData Handing & Basics of Data Management ANNUAL EXAMINATIONGetting started with Python, Data types, Conditional statements and flow of control, String Manipulation, data handling, Data management. MAHARSHI PATANJALI VIDYA MANDIR, PRAYAGRAJSYLLABUS BREAKUP: 2020 - 2021SUBJECT: INFORMATICS PRACTICES NEW (PRACTICAL)CLASS - XI MONTHCHAPTERMAY, JULY - SEPTEMBERGetting started with PythonData typesConditional statements and flow of controlText HandlingOCTOBER- FEBRUARYData HandlingData ManagementMAHARSHI PATANJALI VIDYA MANDIR, PRAYAGRAJSYLLABUS BREAKUP: 2020 - 2021SUBJECT: INFORMATICS PRACTICES NEW (PRACTICAL)CLASS - XI MONTHTOPICS PRACTICAL JULYProgramming in Python:Find the largest and smallest numbers in a list.Find the third largest number in a list. Find the sum of squares of the first 100 natural numbers. Find whether a string is a palindrome or not. Given two integers x and n, compute x n .Compute the greatest common divisor and the least common multiple of two integers. Test if a number is equal to the sum of the cubes of its digits. Find the smallest and largest such numbers in the range of 100 to 1000.AUGUSTSEPTEMBEROCTOBERData Management: SQL Commands Create a student table with the student id, name, and marks as attributes where the student id is the primary key. Insert the details of a new student in the above table. Delete the details of a particular student in the above table. Use the select command to get the details of the students with marks more than 80.Create a new table (name, date of birth) by joining two tables (student id, name) and (student id, date of birth). Create a new table (order ID, customer Name, and order Date) by joining two tables (order ID, customer ID, and order Date) and (customer ID, customer Name, contact Name, country).NOVEMBERDECEMBERJANUARYData Handling:To Create array of containing numeric values 0 to 9. To Create array a numpy array with all values as 0.To perform basic arithmetic operations on 1D and 2D arrays. To crate 1D array having 12 elements using arrange function, now convert this array into a 2D array with size 4X3.FEBRUARYProject Work. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download