Please Enter Your Detail

Note:- For Address please update in your profile and email to

Crash Course IP Class XII

Crash Course IP Class XII

By :Online IT Teaching

This online crash course include all important concepts related to the subject Informatics Practices. You can take class using internet & laptop or mobile. Course will be conducted on weekends and weekdays. 8 hrs on weekend or 8 hrs on weekdays.

0 Reviews

  • 3499
  • 15000
Buy Course

100 % Genius Product.

Secure Ordering.

This online course is on Informatics Practices subject, which is part of the CBSE (India) curriculum.

The aim of the subject is to make a student:

  • Understand the application development process.
  • Gain programming skills in front-end application development
  • Gain skills in Database Creation and querying using ANSI SQL.
  • Design, program and develop database driven web applications using GUI Programming Tool and RDBMS.
  • Understand and appreciate open source and open standard concepts.

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.

4.1.2. Numpy
- 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

About the Instructor

Online IT Teaching

I have 21 years of IT industry experience, now planning to teach the students online. Last 14+ years as Enterprise Architect, e-Commerce Global Practice Head in e-commerce/digital transformation / CMS , Program/Project Manager,Consulting Sales, Pre-sales, Delivery – on Mobile App, Sterling OMS, ATG Commerce, SAP Hybris, IBM WCS , Magento, AEM,IoT across B2C, B2B platforms, Cloud platforms technically managing with multiple tracks with a team of 300+.

Oracle Java, TOGAF Architect, IBM IT Specialist, Web Master , IBM DB2 Certified Professional.

Act as the design authority, creating architecture blueprint and leading the large scale digital transformation projects. Consult, Implement and support multi-million dollar projects with 360 Degree Customer View using Agile,DevOps, Automation, best practices etc

Read More

Subscribe all Tests & Courses by Online IT Teaching for Rs.25000 for full one year.

Buy Subscription

Have you studied the courses of Online IT Teaching? Write a Review

Write Review About Courses

Posting review here

Could you please tell us more about your experience with Crash Course IP Class XII and overall service?*