1.

Python Fundamentals and Conditional/Looping

Constructs
1.1 Basic Arithmetic Programs

1. Write a program that takes two integers from the user and performs all arithmetic
operations (+, -, *, /, %, **, //) on them.

1.2 Conditional Statements

2. Write a Python program to find if a number is positive, negative, or zero using if-elif-
else.

3. Write a program to find the largest among three numbers entered by the user.

1.3 Loop-based Programs

4. Write a program that takes a number as input and prints its multiplication table up
to 10 using a for loop.

5. Write a program to find the sum of all even numbers from 1 to 50 using a loop.

6. Write a program to generate the Fibonacci series up to a given number of terms.

7. Write a program to find the factorial of a number entered by the user.

8. Write a program to check if a number is prime or not.

1.4 String Handling(Extra)

9. Write a program that takes a sentence from the user and counts the number of
vowels and consonants.

10. Write a program to accept a string and create a new string with all vowels removed.

Aryan Public School : Class XI 1

 11. Write a program to find if a given string is a palindrome.

1.5 Dictionary-based Programs(Extra)

12. Write a program to create a dictionary to store student names and their marks in
five subjects. Print the dictionary and the total marks for each student.

13. Write a program to find the average and grade of a student based on their marks in
five subjects. Use conditional logic for grading.

14. Create a dictionary that stores the names of states and their capitals. Ask the user to
enter a state name and display its capital.

1.6 List Handling(Extra)

15. Write a program that inputs a list of numbers and displays all the even numbers
from the list.

16. Write a program to find the largest and smallest numbers in a list entered by the
user.

17. Write a program to remove a specific element from a list entered by the user.

18. Write a program that takes two lists of the same size and adds their corresponding
elements into a new list.

19. Write a program that takes a list of strings and prints only those strings that are
more than 5 characters long.

1.7 Patterns(Extra)

20. Write a program that uses nested loops to print a right-angled triangle pattern of
asterisks based on user input for the number of rows.

Aryan Public School : Class XI 2

 2. Data Handling using NumPy
2.1 NumPy Array Basics

1. Create a NumPy array from a list of 10 integers. Perform basic arithmetic operations
(+, -, *, /) with a scalar value (e.g., 5).

2. Create a 2D NumPy array (3x4) with random integers and display its shape, size,
and dimensions.

3. Write a program to perform slicing on a 1D NumPy array to extract the middle 5

elements.

4. Given a 2D NumPy array, write a program to swap its first and last columns.

5. Create a NumPy array of 12 elements and reshape it into a 3x4 2D array.

6. Write a program to create a 2D array of shape 5x3 with all elements initialized to 1.

7. Create two 2D NumPy arrays of the same shape and perform element-wise
multiplication on them.

8. Write a program to calculate the mean, median, and standard deviation of a 1D

NumPy array.

9. Create a NumPy program to perform element-wise true division of two given arrays.

10. Create a NumPy program to sort an array of random integers in ascending order.

3. Database Concepts and SQL (MySQL)

Aryan Public School : Class XI 3

 3.1 Database Creation

1. Create a database named LIBRARY in MySQL.

2. Create a table named BOOKS with columns Book_ID, Title, Author, Price,
Publication_Year.

3. Insert at least 5 records into the BOOKS table.

3.2 Basic SQL Queries

4. Write an SQL query to retrieve all records from the BOOKS table.

5. Write an SQL query to update the price of a book using its Book_ID.

6. Write an SQL query to delete a record where Publication_Year < 2000.

7. Write an SQL query to retrieve all book titles and authors, ordered by author.

8. Write an SQL query to find the average price of all books.

9. Write an SQL query to display the number of books published by each author.

10. Write an SQL query to display all books whose title starts with 'T'.

11. Write an SQL query to retrieve all books with price between 500 and 1000.

3.3 Advanced SQL Queries

12. Create another table named MEMBERS with Member_ID, Name, and Address.

13. Add a foreign key Issued_To_Member_ID in BOOKS referencing MEMBERS.

Aryan Public School : Class XI 4

 14. Write an SQL query to list all books not issued to a member.

15. Write an SQL query to display the total number of books in BOOKS.

16. Write an SQL query to display max and min price of books.

17. Write an SQL query to find all books published in a specific year.

18. Write an SQL query to display books having 'Python' in their title.

19. Write an SQL query to increase all book prices by 10%.

20. Use GROUP BY and HAVING to find authors who published more than one book.

Aryan Public School : Class XI 5

4. Advanced Questions
Advanced Python Programming
1. Write a Python program to implement a binary search algorithm for a sorted list.

2. Write a Python function to check if two strings are anagrams.

3. Implement a class Student with attributes roll number, name, and marks. Include
methods to display details and calculate grade.

4. Write a program to read a text file and count the frequency of each word using a
dictionary.

5. Write a Python program to implement a stack using a list with push, pop, and display
operations.

6. Implement a queue using [Link] in Python and perform enqueue and dequeue
operations.

7. Write a program to merge two dictionaries and sort them by keys.

8. Write a Python program to find the longest word in a given sentence.

9. Write a program to generate a list of prime numbers using the Sieve of Eratosthenes.

10. Write a recursive Python function to solve the Tower of Hanoi problem for ‘n’ disks.

Advanced NumPy
1. Write a NumPy program to perform matrix multiplication of two 3x3 arrays.

2. Create a 5x5 identity matrix using NumPy.

3. Generate a 4x4 random array and normalize its values between 0 and 1.

4. Write a NumPy program to compute eigenvalues and eigenvectors of a matrix.

5. Write a program to calculate the correlation coefficient between two NumPy arrays.

6. Use NumPy to generate 1000 random numbers and plot a histogram using matplotlib.

7. Implement broadcasting in NumPy to add a 1D array to each row of a 2D array.

8. Write a program to create a block matrix using NumPy hstack and vstack.

9. Perform polynomial fitting using NumPy polyfit() on a given dataset.

10. Solve a system of linear equations using NumPy [Link]().

Aryan Public School : Class XI 6

Advanced SQL Queries
1. Write an SQL query to find the second highest price of books in the BOOKS table.

2. Write an SQL query to find authors who have written more than 3 books.

3. Write an SQL query to display members who have not borrowed any books.

4. Write an SQL query to calculate the total price of all books issued to a specific member.

5. Write an SQL query to display all books along with member names who issued them
using JOIN.

6. Write an SQL query to rank books based on their price using RANK().

7. Write an SQL query to display books grouped by publication year with the total number
of books per year.

8. Write an SQL query to display authors whose books have an average price greater than
800.

9. Write an SQL query to find duplicate book titles in the BOOKS table.

10. Write an SQL query to display the oldest and newest book in the library.

Project-Based Questions
1. Create a Python project for a simple Student Management System using lists/dictionaries
to store details.

2. Design a Library Management mini-project in Python with options to add books, issue
books, and return books.

3. Build a small Calculator project in Python using functions.

4. Write a NumPy-based program to analyze marks of 50 students stored in an array (mean,

median, top 5 scores).

5. Create an SQL database for an Online Shopping System with tables for Customers, Orders,
and Products. Write queries for order summaries.

6. Develop a Python program to visualize COVID-19 cases data using matplotlib and NumPy.

7. Build a program to simulate Toss of a Coin 1000 times and show probabilities using
NumPy.

8. Write a program in Python to generate a bar chart of sales data from a dictionary using
matplotlib.

9. Develop a Python program for Railway Reservation System (simplified) using file
handling.
Aryan Public School : Class XI 7
10. Create a mini-project in Python that uses OOP concepts to simulate a Banking System
(deposit, withdraw, balance check).

Aryan Public School : Class XI 8