PTES’s
PUNE CAMBRIDGE
INSTITUTE OF MANAGEMENT AND COMPUTER APPLICATION, PUNE
CCE – 01
Type of Course: Mandatory
Course: PPR501MJ: Python Programming
Marks: 25
Type of CCE: Simulation Exercises Date : 03/11/2025
Instructions to Students:
1. Read instructions carefully before solving.
2. Perform following any 2 programs on python compiler.
3. Each program carry 10 marks, additional 5 marks given for Output as Screenshot.
4. Solutions must form of hard copy.
Question Questions Marks COGNITIV Bloom’s
No. E Level
ABILITIES
EVALUATE
D - COs
Q.1 Develop a Python program to simulate an academic [10] APPLYING 3
performance analytics system for multiple departments. Accept – CO1
details of n students including Name, Department, and marks in 5
subjects.
Perform the following:
• Calculate total, average, and grade using nested conditional
statements.
• Use dictionaries and lists to group students department-wise.
• Display department-wise toppers and the overall topper in
tabular format.
• Apply appropriate input validation for numeric marks using
exceptions.
Q.2 Design and implement a Python program to perform text mining [10] APPLYING 3
and sentiment analysis on a large dataset (e.g., [Link]). – CO2
The program should:
• Count total words, lines, and unique words.
• Identify the top 10 most frequent positive and negative words
using predefined lists.
• Replace all occurrences of sensitive words (given by user) with
“***”.
• Save cleaned output into a new file and generate a summary
report (word frequency, polarity score).
Use file handling, string operations, dictionaries, and exception
handling effectively.
Q.3 Develop a multithreaded Python application for bank [10] APPLYING 3
transaction processing using OOP concepts and Regular – CO3
Expressions. The program should:
• Define a BankAccount class with attributes account_no,
holder_name, and balance.
• Use multiple threads to simulate concurrent deposits,
withdrawals, and balance checks by different users.• Implement
thread synchronization (Lock) to avoid race conditions
.• Validate account number format (e.g., ACC-XXXX-YYYY)
and holder name using Regular Expressions
PTES’s
PUNE CAMBRIDGE
INSTITUTE OF MANAGEMENT AND COMPUTER APPLICATION, PUNE
.• Log all transactions (timestamp, thread ID, operation, balance)
to a file.
• Display a final consolidated report after all threads complete
execution.
------------------------------------******-------------------------------------
Prepared by Approved by Checked by Approved by
Prof. Shubham R Jambhale Dr. Umesh Nath Prof. Shubham R Jambhale Dr. Manohar Karade
IQAC Head HOD , MCA Director
PTES’s
PUNE CAMBRIDGE
INSTITUTE OF MANAGEMENT AND COMPUTER APPLICATION, PUNE
CCE – 02
Type of Course: Mandatory
Course: PPR501MJ: Python Programming
Marks: 25
Date of presentation: 4/11/2025
Sr. Activity Details / Instructions
No.
1 Title PPT Presentation on Python Programming (Each student prepares one unique
topic)
2 Total PPTs 11
3 Objective To assess students’ conceptual understanding and communication skills through
presentations on various components and concepts of the Python
Programming.
4 Mode of Submit hard copy of PPT to the subject teacher.
Submission
5 Evaluation 1. Content Relevance and Accuracy
Criteria 2. Presentation Skills
3. Design & Visual Appeal
4. Conceptual Understanding
5. Time Management
6 Marks 10 Marks
7 Instructions for - Each student must prepare only one PPT (11 students → 11 PPT slides s in
Students total).
Slide 1 must include:
→ Student Name
→ Roll Number
→ Topic Title
→ Course Name & Code
- Remaining slides should cover:
→ Introduction to the Topic
→ Explanation of Key Concepts
→ Example / Code Snippet / Application
→ Summary or Conclusion
(prepare content in your own words.- Use simple design, readable fonts, and
relevant visuals.)
- Be ready to explain your topic during viva/presentation session.
8 CO Mapped CO1 to CO5 – Demonstrate understanding and presentation skills of Python
Programming.
9 Bloom’s Level Understanding & Applying (Level 2 & 3)
------------------------------------******-------------------------------------
Prepared by Approved by Checked by Approved by
Prof. Shubham R Jambhale Dr. Umesh Nath Prof. Shubham R Jambhale Dr. Manohar Karade
IQAC Head HOD , MCA Director
PTES’s
PUNE CAMBRIDGE
INSTITUTE OF MANAGEMENT AND COMPUTER APPLICATION, PUNE
CCE – 3
Type of Course: Mandatory
Course: PPR501MJ: Python Programming Marks: 50
Type of CCE : Home Written Assignment Submission Date : 6/11/2025
Question Questions Marks COGNITIVE Bloom’s
No. ABILITIES Level
EVALUATED – COs
Q1 Solve any Two: 10 CO1 – Apply Apply
a) Write a Python program to accept a list of numbers
and display the sum of even and odd numbers
separately.
b) Write a Python program to find the frequency of
each character in a string using a dictionary.
c) Write a Python program to print multiplication
tables from 1 to 5 using nested loops.
d) Write a Python program to accept a sentence and
display words that start with a vowel.
Q2 Solve any Two: 10 CO2 – Apply Apply
a) Write a Python function that accepts a list and
returns a new list containing only unique elements (no
duplicates).
b) Write a program that uses a lambda function to sort
a list of tuples based on the second element of each
tuple.
c) Write a Python program that handles division by
zero using exception handling and displays a custom
error message.
d) Explain the use of any five functions from the math
module with suitable examples.
Q3 Solve any Two: 10 CO3 – Apply Apply
a) Define a class BankAccount with attributes
account_no, name, and balance. Include methods to
deposit, withdraw, and display account details.
b) Write a Python program using regular expressions
to extract all mobile numbers from a given text file.
c) Explain the concepts of inheritance and method
overriding in Python with a suitable example.
d) Write a Python multithreading program where one
thread prints even numbers and another prints odd
numbers up to 20.
Q4 Solve any One: 10 CO4 – Apply Apply
a) Write a Python program to connect to MongoDB
and create a Product collection with fields: ProductID,
Name, Category, Price. Perform the following
operations:
(i) Insert 3 documents
(ii) Display all products having price greater than 500
(iii) Update price of “Mouse” by 15%
(iv) Delete all products under category “OldStock”
(v) Display all products sorted in ascending order by
price.
OR
PTES’s
PUNE CAMBRIDGE
INSTITUTE OF MANAGEMENT AND COMPUTER APPLICATION, PUNE
b) Write a Python program using MongoDB to
manage a Course collection with fields: CourseID,
CourseName, Duration, and Fees. Perform the
following:
(i) Insert 3 documents
(ii) Retrieve courses having duration greater than 6
months (iii) Update the fees of “Python” course
(iv) Delete course with minimum fees
(v) Display all courses in descending order of fees.
Q5 Solve any Two: 10 CO5 – Apply Apply
a) Design a Django webpage to display details of
books stored in a database table.
b) Write a Django view that passes student
information (Name, Roll No, Course) from [Link]
to a template file.
c) Explain the concept and advantages of Django
Models with suitable examples.
d) What is URL routing in Django? Demonstrate with
a simple example how URLs map to views.
------------------------------------******-------------------------------------
Prepared by Approved by Checked by Approved by
Prof. Shubham R Jambhale Dr. Umesh Nath Prof. Shubham R Jambhale Dr. Manohar Karade
IQAC Head HOD , MCA Director
