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.
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.
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 PlatformDescription
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
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.
डेटा संरचना और कार्य-योजना
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 CampDescription
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
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
बुक डोनेशन कैंप के लिए डेटा संरचना और कार्य-योजना
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
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
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?
Are these NCERT Solutions for Project Based Learning free?
How should I revise Project Based Learning for the CBSE Class 12 board exam?
Sources & Official References
- NCERT Official — ncert.nic.in
- CBSE Academic — cbseacademic.nic.in
- CBSE Official — cbse.gov.in
- National Education Policy 2020 — education.gov.in
Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.
More resources for Project Based Learning
Practice Quiz
Test yourself with a quick quiz
Important Questions
Exam-style questions with answers
Revision Notes
Key points for last-minute revision
Chapter Summary
Understand the chapter at a glance
Concept Maps
See how topics connect
Study Plan
Step-by-step plan for this chapter
Flashcards
Quick-fire cards for active recall
Syllabus
What topics to cover
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.