CBSE Class 12 Informatics Practices Board and Sample Prelim Question papers

CBSE Class 12 Informatics Practices Board, Preboard and Sample Question Papers

Distribution of Marks: Total 100 Marks

• Date Handling-2: 30 Marks
• Basic Software Engineering: 15 Marks
• Data Management-2: 15 Marks
• Society, Law and Ethics-2: 10 Marks
• Practicals: 30 Marks

CBSE Class 12 Syllabus for Informatics Practices (2019-2020):

THEORY

First Unit: Data Handling -2

Python Pandas:

• Advanced operations on Data Frames which include pivoting, sorting, and aggregation
• Descriptive statistics: max, min, mean, mode, median, sum, count, quartile, var
• Create a histogram, and quantiles
• Function application such as pipe, apply, aggregation (group by), transform, and apply map
• Re-indexing, and altering labels

Numpy:

• 1D array, 2D array
• Arrays: slices, joins, and subsets
• Arithmetic operations on 2D arrays
• Covariance, correlation and linear regression

Plotting with Pyplot

• Plot bar graphs, histograms, frequency polygons, scatter plots, and box plots

Second Unit: Basic Software Engineering

• Software Engineering introduction
• Software Processes: evolutionary model, waterfall model, and component based model
• Delivery models: incremental delivery and spiral delivery
• Process activities which include specification, design/implementation, validation, evolution
• Agile methods such as pair programming, and Scrum
• Business use-case diagrams
• Practical aspects which include Version control system (GIT), and perform case studies of software systems and build use-case diagrams

Third Unit: Data management -2

• Minimal Django based web application to be written that parses a GET and POST request, and writes the fields to a file – flat file and CSV file.
• Interface Python along with an SQL database
• SQL commands: aggregation functions, having, order by, group by.

Fourth Unit: Society, Law and Ethics-2

• Intellectual property rights, digital rights management, plagiarism, and licensing (Creative Commons, GPL and Apache), open data, open source, privacy.
• Privacy laws, fraud; cybercrime- illegal downloads, phishing, child pornography, scams; cyber forensics, IT Act, 2000.
• Technology and society which includes understanding societal issues and cultural changes induced by technology.
• E-waste management which includes proper disposal of used electronic gadgets.
• Identity theft, biometrics, and unique ids.
• Gender and disability issues while teaching and using computers.
• Role of new media in society which includes online campaigns, crowdsourcing, smart mobs
• Issues with the internet: internet addiction, internet as an echo chamber, net neutrality,
• Case studies - Arab Spring, Bit coin, WikiLeaks

PRACTICALS:

Fifth Unit First part: Data management: SQL+Web Server

• Find the max, min, sum, and average of the marks in a student marks table.
• Using group by find the total number of customers from each country in the table (customer ID, customer Name, and country).
• 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.

Fifth Unit Second part: Data handling using Python libraries

• Convert using map functions all negative numbers in a Data Frame to the mean of all the numbers.
• Consider a Data Frame, where each row should contain the item category, item name, and expenditure.
• Group the rows by the category, and then print the total expenditure per category.
• Print all the elements that are above 75th percentile of a given Series,.
• Aggregate and Print the highest, lowest, and closing prices of each stock given a day’s worth of stock market data.
• Plot a linear regression line of given sample data,.
• Take data from government web sites, aggregate and summarize it and then plot it using different plotting functions of the PyPlot library.
• Fifth Unit Second part: Basic Software Engineering
• Business use-case diagrams for an airline ticket booking system, train reservation system, and stock exchange
• Write a program collaboratively and manage the code with a version control system (GIT)

PROJECT

CBSE Board advises to have groups of 2-3 students. Students should go out and meet real businesses. A real life problem should be taken and then the programming should be done to solve the problem. Students can be highly creative in their approach. It might require some additional learning and CBSE board encourages the student to do the same. Plagiarism should be avoided and open source software’s should be used for the same. Disciplinary action is suggested against students who indulge in plagiarism or piracy.

Solving question papers is one of the ways to make sure that you are prepared for the exams. The question papers are as per the curriculum and syllabus of NCERT and CBSE Board. Testpaperz provides you enough practice material to ensure that you gain confidence and do well in your exams. They also give a feedback on your strengths and weakness which helps you prioritise your focus areas and strengthen them. Download free CBSE Class 12 Informatics Practices by clicking below:

Previous Year CBSE Class 12 Informatics Practices Board Exam Question Paper

CBSE Class 12 Informatics Practices Preboard Question paper

CBSE Class 12 Informatics Practices Sample Question paper

Download Previous Year Board, Preboard and Sample Question papers of other subjects by clicking below:

Previous Year CBSE Class 12 Question papers for all subjects