Skip to main content
Chapter 7 of 7
NCERT Solutions

Project Based Learning — NCERT Solutions

CBSE · Class 12 · Informatics Practices

NCERT question answers for Project Based Learning, CBSE Class 12 Informatics Practices: 4 textbook questions solved step by step.

74 questions88 flashcards5 concepts

Interactive on Super Tutor

Studying Project Based Learning? Get the full interactive chapter.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for NCERT solutions and more.

Free trial, no card needed.

4 Questions Solved · 1 Section

The first 2 solutions are open to read. The other 2 are free with a Super Tutor account. Unlock all 4 free in Super Tutor

7.4 Project Descriptions

7.4.1Project I : Online Shopping Platform

Description

Murugan plans to launch an online shopping platform—‘APPAREL EASY’. He plans to have two broad categories of merchandise—Men, Women. Under both the categories—Clothing, Footwear and Accessories will be the sub-categories. Also, on his shopping platform, he is planning to launch two mega events—Festive Sale (a month before Diwali to Christmas), End of Season Sale (February and August). Murugan also wants to keep a record of his monthly revenue generation sales and category wise sales, with special focus on mega events. A record should also be kept on discounts being offered by the manufacturers, payment sites or any discount offered as a promotional campaign by the APPAREL EASY portal.

Specification

The details of the Men and Women apparels should be stored in a data file with fields as Apparel Code, Name, Category, Size, Price, Customer Name, Payment Mode, Discount Code, etc.

If the Category is Men, then apparels can be Men’s Trousers, Men’s Shirt, Men’s Jeans, Men’s T-shirt. If the Category is Women, then the apparels can be Skirts, Top, Pants, Jeans, Kurta, etc.

If the Payment Mode is Credit or Debit Card, then the Credit card number, name, CVV and validity should be entered.

If the Payment Mode is Cash on Delivery(COD), then no details to be asked.

Randomly select the merchandise to be put on sale. The selected merchandise should not be more than 70 per cent of the total merchandise.

The discount code can be either FEST (for Festive) or EOS (for End of Season). The discounts for FEST will be 10 per cent and for EOS will be 15 per cent.

You need to visualise the data structure, keeping all the requirements of Murugan in mind, and then implement it using Python Pandas. Thereafter, you need to design a software to store details of the merchandise to put them online for sale. At the same time, records of customers visiting the e-commerce site and the number of customers placing the order also have to be maintained. The data collected should be plotted appropriately to help Murugan make decisions for future marketing and promotion strategies.

Show solution

डेटा संरचना और कार्य-योजना

Murugan की APPAREL EASY परियोजना के लिए डेटा को इस तरह व्यवस्थित किया जा सकता है कि हर रिकॉर्ड में आवश्यक जानकारी रहे और Pandas की मदद से उसे आसानी से संसाधित किया जा सके।

1) मुख्य डेटा फ़ाइल की संरचना

एक CSV/डेटा फ़ाइल में ये फ़ील्ड रखे जा सकते हैं:

  • Apparel Code
  • Name
  • Category
  • Size
  • Price
  • Customer Name
  • Payment Mode
  • Discount Code

यदि आवश्यक हो तो और फ़ील्ड भी जोड़े जा सकते हैं, जैसे:

  • Credit Card No.
  • Card Holder Name
  • CVV
  • Validity
  • Sale Type
  • Quantity
  • Revenue

2) श्रेणियाँ और उप-श्रेणियाँ

  • Broad Categories: Men, Women
  • Sub-categories: Clothing, Footwear, Accessories

उदाहरण के लिए:

  • Men: Men’s Trousers, Men’s Shirt, Men’s Jeans, Men’s T-shirt
  • Women: Skirts, Top, Pants, Jeans, Kurta, etc.

3) भुगतान के नियम

  • यदि Payment Mode = Credit/Debit Card है, तो:
  • Credit card number
  • Card holder name
  • CVV
  • Validity

दर्ज करनी होगी।

  • यदि Payment Mode = COD है, तो कोई card details नहीं पूछी जाएँगी।

4) छूट (Discount) का नियम

  • FEST = 10% discount
  • EOS = 15% discount

5) Sale के लिए merchandise चयन

प्रश्न के अनुसार sale के लिए merchandise को randomly चुनना है, लेकिन चुना गया merchandise कुल merchandise का 70% से अधिक नहीं होना चाहिए।

6) Pandas से कार्यान्वयन का तरीका

Pandas में एक DataFrame बनाकर:

  • data को store किया जा सकता है,
  • filter किया जा सकता है,
  • discount लागू किया जा सकता है,
  • monthly revenue निकाला जा सकता है,
  • category-wise sales की गणना की जा सकती है,
  • visitors और orders का record रखा जा सकता है।

7) विश्लेषण और plotting

Murugan के निर्णय लेने के लिए उपयुक्त charts बनाए जा सकते हैं, जैसे:

  • bar chart — category-wise sales के लिए
  • line chart — monthly revenue trends के लिए
  • pie chart — sale items या discount distribution के लिए

निष्कर्ष

इस परियोजना में एक ऐसा software बनाया जाएगा जो apparel data को संग्रहित करे, payment और discount rules लागू करे, 70% तक merchandise को sale के लिए चुन सके, और Pandas तथा charts की मदद से बिक्री व ग्राहकों से जुड़ी जानकारी का विश्लेषण कर सके।

Not sure why a step works? check your working in Super Tutor

7.4.2Project II: Automating a Books Donation Camp

Description

Realising the importance of Reduce, Reuse and Recycle, the Bookworm club every year organises a Book Donation Camp. The Book Donation camp collects books and notebooks. The volunteers assess the condition of the books and categorise them as Fit, Needs mending, or Unfit. The unfit books' pages are used to create paper bags and envelopes. The other categories of books are resold at half the price. They accept notebooks that have pages left in them. The pages are torn from the notebooks, and are attractively bound to create a new notebook and sold. They create a variety of recycled objects and sell them. They want to create a software for this purpose and store details about the camp. To be able to efficiently store, retrieve and visualise data, they need to implement the following using Pandas.

Specification

The details of collections are stored in a CSV file with column headings as Item category, Item ID, Item name, Item type, Condition.

If the Item Category is Book, then the Item Type can be either Academic or Non Academic, and Item Id shall be prefixed with a 'B'. In case of Academic, class shall be entered.

If the Item Category is Notebook then the Item can be Single line, Four Line, Five Line, and Item Id shall be prefixed with an 'N'.

Condition can only be Fit, Needs Mending or Unfit. After the items are refurbished, the data are stored

Show solution

बुक डोनेशन कैंप के लिए डेटा संरचना और कार्य-योजना

Bookworm club के लिए एक software तैयार किया जा सकता है जो donated books और notebooks का रिकॉर्ड रखे, उन्हें वर्गीकृत करे, refurbished items का हिसाब रखे, और बिक्री/स्टॉक का विश्लेषण करे।

1) संग्रहित डेटा की CSV संरचना

प्रारम्भिक संग्रहण के लिए कॉलम headings:

  • Item category
  • Item ID
  • Item name
  • Item type
  • Condition

2) Item category के नियम

यदि Item Category = Book

  • Item Type: Academic या Non Academic
  • Item ID का prefix: 'B'
  • यदि Academic है, तो class भी दर्ज की जाएगी

यदि Item Category = Notebook

  • Item Type: Single line, Four Line, Five Line
  • Item ID का prefix: 'N'

3) Condition के नियम

Condition केवल इनमें से एक हो सकती है:

  • Fit
  • Needs Mending
  • Unfit

4) Refurbished items का डेटा

Refurbishing के बाद डेटा दूसरी CSV में रखा जाएगा, जिसके कॉलम होंगे:

  • Item id
  • Item name
  • Item Category
  • Quantity
  • Price

इस फ़ाइल में:

  • Books के लिए class भी जोड़ी जा सकती है
  • Item Category हो सकती है:
  • Paper bags
  • Notebook
  • Books

5) Order data

Orders के लिए एक और CSV फ़ाइल बनाई जाएगी, जिसमें होंगे:

  • Item Category
  • Item name
  • Quantity
  • Price

Order होने पर refurbished CSV की quantity update होनी चाहिए।

6) विश्लेषण और plotting

डेटा को efficiently store, retrieve और visualise करने के लिए Pandas उपयोगी है। उपयुक्त charts बनाए जा सकते हैं ताकि:

  • sales दिखे,
  • items refurbished दिखें,
  • items collected दिखें।

निष्कर्ष

इस परियोजना में book और notebook donations को व्यवस्थित करने, उन्हें condition के अनुसार वर्गीकृत करने, refurbished products को store करने, और orders/stock को update करने वाला Pandas-based software बनाया जा सकता है।

Not sure why a step works? check your working in Super Tutor

7.4.3Project III: A survey of the effect of social networking sites on behaviour of teenagers

Description

With the Internet revolution everyone today is now connected. Teenagers spend a good amount of time on social networking sites, and it plays a vital role in their behaviour. It is considered that excessive use of social networking sites has sometimes a serious impact on the mental health of individuals. A well-crafted survey questionnaire can help in exploring and finding many facts.

Specifications

Free with a Super Tutor account

7.4.4Project IV: Utilising an open data source to use a national, state or district level Dataset

Description

Open Government Data (OGD) Platform India www.data.gov.in is a platform for supporting open data initiative of Government of India. From this platform, let us consider the dataset “Special Tabulation on Adolescent and youth population classified by various

NOTES

parameters for India, States and Union Territories, 2011'. The dataset was contributed by the Ministry of Home Affairs, Government of India, and released under National Data Sharing and Accessibility Policy (NDSAP). The dataset was published on portal on 07/09/2015.

Statistics of the Data Set:

Number of rows: 12168

Number of columns: 123

Descriptions of some of the columns are given below:

State: Serial numbers given to states

Area Name: Name of the states and union territories

Total/Rural/Urban: Data about the total, rural or urban areas of a state or UT.

Adolescent and youth: Data for different age groups

Total Male: Total number of males

Total Female: Total number of females

SC-M: Total number of males of Scheduled Castes(SC)

SC-F: Total number of females of Scheduled Castes(SC)

ST-M: Total number of males of Scheduled Tribes(ST)

ST-F: total number of females of Scheduled Tribes(ST)

Literates-M: total number of literate males

Literates-F: total number of literate females

LiteratesSC-M: total number of literate males of Scheduled Castes(SC)

LiteratesSC-F: total number of literate females of Scheduled Castes(SC)

LiteratesST-M: total number of literate males of Scheduled Tribes(ST)

LiteratesST-F: total number of literate females of Scheduled Tribes(ST)

Illiterates-M: total number of illiterate males

Illiterates-F: total number of illiterate females

IlliteratesSC-M: total number of illiterate males of Scheduled Castes(SC)

IlliteratesSC-F: total number of illiterate females of Scheduled Castes(SC)

IlliteratesST-M: total number of illiterate males of Scheduled Tribes(ST)

IlliteratesST-F: total number of illiterate females of Scheduled Tribes(ST)

MainWorker-M: total number of main worker males

MainWorker-F: total number of main worker females

MainWorkerSC-M: total number of main worker males of Scheduled Castes(SC)

MainWorkerSC-F: total number of main worker females of Scheduled Castes(SC)

Reprint 2026-27


PROJECT BASED LEARNING

203

MainWorkerST-M: total number of main worker males of Scheduled Tribes(ST)

MainWorkerST-F: total number of main worker females of Scheduled Tribes(ST)

MarginalWorker-M: total number of marginal worker males

MarginalWorker-F: total number of marginal worker females

MarginalWorkerSC-M: total number of marginal worker males of Scheduled Castes(SC)

MarginalWorkerSC-F: total number of marginal worker females of Scheduled Castes(SC)

MarginalWorkerST-M: total number of marginal worker males of Scheduled Tribes(ST)

MarginalWorkerST-F: total number of marginal worker females of Scheduled Tribes(ST)

Specifications

Free with a Super Tutor account

2 more solved questions in Project Based Learning

They are free with a Super Tutor account, along with practice quizzes and flashcards for this chapter. Free to start, no card needed.

Frequently Asked Questions

What are the important topics in Project Based Learning for CBSE Class 12 Informatics Practices?
Key topics in Project Based Learning include Introduction to Project Based Learning, Approaches for Solving Projects, Steps Involved in Project Based Learning, Teamwork. Study these first, then practise questions on each for the CBSE Class 12 board exam.
Are these NCERT Solutions for Project Based Learning free?
The first 2 of the 4 solutions on this page are open to read. The other 2 are free with a Super Tutor account — signing up is free and needs no card.
How should I revise Project Based Learning for the CBSE Class 12 board exam?
Learn the core ideas first, then work through the 74 practice questions on Project Based Learning. Revise definitions regularly and use flashcards for quick recall before the exam.

Sources & Official References

Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.

For serious students

Get the full Project Based Learning chapter — start free.

Quizzes, flashcards, an AI doubt solver and a study plan for CBSE Class 12 Informatics Practices. Free to start, no card needed.