This online course is on Informatics Practices subject, which is part of the CBSE (India) curriculum.
We Cover the following Important Topics of syllabus: CBSE Class 12 exam for Informatics Practices
4.1. Unit 1: Data Handling (DH-2) (80 Theory)
4.1.1. Python Pandas
- Advanced operations on Data Frames: pivoting, sorting, and aggregation
- Descriptive statistics: min, max, mode, mean, count, sum, median, quartile, var
- Create a histogram, and quantiles.
- Function application: pipe, apply, aggregation (group by), transform, and apply map.
- Reindexing, and altering labels.
- 1D array, 2D array
- Arrays: slices, joins, and subsets
- Arithmetic operations on 2D arrays
- Covariance, correlation and linear regression
4.1.3. Plotting with Pyplot
- Plot bar graphs, histograms, frequency polygons, box plots, and scatter plots.
4.2 Unit 2: Basic Software Engineering (BSE) (25 Theory + 10 Practical)
- Introduction to software engineering
- Software Processes: waterfall model, evolutionary model, and component based model
- Delivery models: incremental delivery, spiral delivery
- Process activities: specification, design/implementation, validation, evolution
- Agile methods: pair programming, and Scrum
- Business use-case diagrams
- Practical aspects: Version control system (GIT), and do case studies of software systems and build use-case diagrams
4.3. Unit 3: Data Management (DM-2) (20 Theory + 20 Practical)
- Write a minimal Django based web application that parses a GET and POST request, and writes the fields to a file – flat file and CSV file.
- Interface Python with an SQL database
- SQL commands: aggregation functions, having, group by, order by.
4.4. Unit 4: Society, Law and Ethics (SLE-2) (15 Theory)
- Intellectual property rights, plagiarism, digital rights management, and licensing (Creative Commons, GPL and Apache), open source, open data, privacy.
- Privacy laws, fraud; cybercrime- phishing, illegal downloads, child pornography, scams; cyber forensics, IT Act, 2000.
- Technology and society: understanding of societal issues and cultural changes induced by technology.
- E-waste management: proper disposal of used electronic gadgets.
- Identity theft, unique ids, and biometrics.
- Gender and disability issues while teaching and using computers.
- Role of new media in society: online campaigns, crowdsourcing, smart mobs
- Issues with the internet: internet as an echo chamber, net neutrality, internet addiction
- Case studies - Arab Spring, WikiLeaks, Bit coin
5.1. Data Management: SQL+web-server
- Find the min, max, sum, and average of the marks in a student marks table.
- Find the total number of customers from each country in the table (customer ID, customer Name, country) using group by.
- Write a SQL query to order the (student ID, marks) table in descending order of the marks.
- Integrate SQL with Python by importing MYSQL dB
- Write a Django based web server to parse a user request (POST), and write it to a CSV file.
5.2. Data handling using Python libraries
- Use map functions to convert all negative numbers in a Data Frame to the mean of all the numbers.
- Consider a Data Frame, where each row contains the item category, item name, and expenditure.
- Group the rows by the category, and print the total expenditure per category.
- Given a Series, print all the elements that are above the 75th percentile.
- Given a day’s worth of stock market data, aggregate it. Print the highest, lowest, and closing prices of each stock.
- Given sample data, plot a linear regression line.
- Take data from government web sites, aggregate and summarize it. Then plot it using different plotting functions of the PyPlot library.
5.3. Basic Software Engineering
- Business use-case diagrams for an airline ticket booking system, train reservation system, stock exchange
- Collaboratively write a program and manage the code with a version control system (GIT