Computing and coding
Computing and coding projects for college and diploma: 29 ideas.
Each project below opens to its own page with what it shows, the science behind it, the materials, safety, step-by-step instructions, what you should see and viva questions. Many can be made from things at home; where a kit helps, the page links one.
Other subjects for college and diploma: Physics, Chemistry, Earth and space, Electronics and robotics, Environment.
Python student record manager saved in a JSON file
Records of students are stored as nested data in a JSON file and can be added, searched, updated and deleted. It is a small version of how real databases and apps keep data.
Python attendance checker that flags students below 75 percent
The program reads present and total days from a CSV, works out the percentage and writes a second file listing those below 75 percent. It shows reading, calculating and writing data in one pipeline.
Spreadsheet attendance register using COUNTIF
Present and absent entries are counted with COUNTIF, converted to a percentage, and flagged when below 75 percent. It shows how formulas can replace manual counting.
Spreadsheet electricity bill estimator with unit slabs
A single formula with MIN and MAX charges different rates for each block of units, as slab billing does. It shows how step-rate pricing works and how to check it.
Spreadsheet rank list with RANK and a VLOOKUP report card
RANK orders students by total and VLOOKUP fetches one student’s full record by roll number to fill a report card. It shows how lookup formulas turn a data table into a report.
Spreadsheet comparing simple and compound interest over 20 years
Two formulas grow the same sum at the same rate, one adding the same interest each year and one adding interest on interest. The chart shows compounding pulling ahead with time.
AI literacy: testing a chatbot with twenty checkable questions
Twenty questions with known answers are put to an AI chatbot and the answers are checked against textbooks, giving an accuracy percentage and a list of confident mistakes. It shows that AI can be useful but must be verified.
Digital privacy audit of app permissions with a parent
Apps on a phone are checked for the permissions they hold, such as camera, microphone and location, and compared with what they need. It teaches how to protect privacy by limiting access.
AI literacy: can classmates tell AI-written text from student writing?
Short paragraphs written by students and by an AI tool are mixed and shown to volunteers who guess the author. The results show how hard it is to tell and what clues people use.
Binary search against linear search on a sorted roll-number list
Looking for a roll number in a sorted list is done one by one and then by halving, and the steps are counted. It shows why binary search is so much faster for large lists.
SQL mini-database for a school library with a JOIN
Three linked tables for books, members and loans answer questions such as who has which book, using a JOIN. It shows how real databases avoid repeating data.
SQL stock database for a kirana shop with low-stock alerts
One items table answers questions on stock value by category, items running low and best selling price using WHERE, GROUP BY and ORDER BY. It shows how a shop can manage stock with simple queries.
SQL cricket scorecard database with averages and strike rates
Players and match scores in two tables give totals, averages and strike rates with JOIN, GROUP BY and HAVING. It shows how statistics in sports are calculated by queries.
SQL school bus routes database with fares and empty routes
Routes and riders are stored in two tables, and queries give riders per route, fare income and routes with nobody on them using LEFT JOIN. It teaches the difference between inner and outer joins.
Python bank account class with deposit, withdraw and history
A class bundles data and actions for an account, and the code raises errors for overdrawing. It introduces object oriented programming with a familiar example.
Python and pandas analysis of 30 years of monthly rainfall open data
Farmers and city planners ask whether the monsoon is changing. A student can download a public rainfall data set, clean it with pandas and plot monthly averages, yearly totals and a trend line, which teaches data cleaning, statistics and honest conclusions.
Library management database in SQLite with a Python command-line app
A school or a mohalla library often keeps records in a register, and books get lost. A small relational database with books, members and loans tables lets a student issue, return and search books and see overdue lists, which teaches design with primary and foreign keys.
Linear regression to predict used scooter prices with scikit-learn
People who buy a second-hand vehicle want a fair price. A regression model learns from listed prices, age and kilometres how much a scooter is worth. A student can build it from an open data set or from 100 prices noted from classified advertisements, and check how accurate it is.
Flask online quiz app with SQLite score storage and a leaderboard
Teachers in small schools and coaching classes often mark quizzes by hand. A small web app lets students log in, answer multiple-choice questions in a browser, see their score and appear on a leaderboard. The project teaches routes, templates, forms and a database in one application.
K-nearest neighbours classifier on the iris and wine data with a confusion matrix
A first machine learning project should show how a computer decides from examples. The k-nearest neighbours method classifies a new flower or wine by looking at its closest known examples. A student tests how the choice of k and scaling of the features change accuracy.
Tkinter attendance register app with a monthly summary and CSV export
Many coaching centres and small workshops mark attendance in a notebook and later struggle to total it. A desktop app in Python with Tkinter can store students, mark present or absent each day, and give a percentage report, which teaches file handling and a graphical user interface.
Seasonal rainfall prediction for a district with a random forest model
Farmers decide sowing dates and reservoir managers plan releases using rainfall outlooks. The project builds a machine learning model that predicts the coming month’s rainfall of one district from past rainfall and temperature, tests it honestly against a simple average baseline and reports where it fails.
Clinic OPD appointment and patient queue system with Flask and SQLite
Small clinics and government dispensaries have long queues and paper registers. A web application that books slots, assigns token numbers and shows the doctor the day’s queue reduces waiting and lost files. The project designs the database, roles, screens and tests of such a system using sample data only.
Handwritten digit recognition with a CNN on MNIST and a browser demo
Cheque and form readers recognise handwriting. A small convolutional neural network learns to read digits from the open MNIST data set. The project trains it on a laptop, tests accuracy, studies the errors and builds a web page where a user draws a digit.
SMS spam classifier using Naive Bayes with a web form and error analysis
Fake lottery, loan and KYC messages reach millions of phones. A Naive Bayes classifier learns spam words from labelled messages. The project trains on an open SMS data set, measures precision and recall and builds a small web page that scores a message.
Kirana shop inventory and billing web app that prints GST invoices as PDF
Neighbourhood shops often use handwritten bills and lose track of stock. A web application that records products, stock, purchases and sales, calculates GST on each bill and warns of low stock can fit that need. The project designs, builds and tests such software with invented shop data.
Plant leaf disease classifier using transfer learning on an open image set
Farmers lose crops to diseases that are spotted too late. A neural network trained on leaf photographs can suggest the likely disease. The project fine-tunes a pretrained image model on a subset of an open plant leaf data set, measures accuracy and tests it honestly on photographs taken in the field.
City bus route and fare finder using Dijkstra’s algorithm on a graph
Commuters in a town often do not know which buses to take or where to change. Modelling stops as nodes and bus links as weighted edges lets Dijkstra’s algorithm find the shortest or cheapest route. The project builds the graph from a published route list and shows the route on a map web page.
Student marks analytics dashboard with pandas and Streamlit
Teachers have term marks in spreadsheets but rarely get quick views of weak topics, class comparisons or students at risk. A Streamlit dashboard reads a marks file and shows distributions, correlations and a list of students needing help, which teaches data handling, statistics and responsible use of student data.