Student interview questions and answers

My best project is a bus-tracking web app for our college, built with two classmates in our third year. The problem was that students waited up to thirty minutes without knowing where the bus was. I built the backend in Node.js that received GPS updates from a phone kept on each bus, and stored them in MongoDB. My teammates built the map interface. The hardest part was battery drain on the driver’s phone, so I reduced updates from every five seconds to every twenty. About 300 students used it daily for one semester.

In our final-year marketing project on a local dairy brand, there were four of us. I owned the customer survey: I designed a twenty-question form, collected 212 responses from three residential areas over two weekends, and analysed it in Excel with pivot tables. I also wrote the pricing section of the report. My teammates handled competitor research, the distributor interviews and the presentation design. I presented the survey findings to the faculty panel. When I talk about the project, the numbers on customer preferences are mine; the distribution recommendations came from my teammate Priya.

I did an eight-week summer internship with the finance team of a mid-size logistics company in Pune. My main task was reconciling vendor payments for two months, around 1,400 entries, between their accounting software and bank statements. I found 23 mismatches, mostly duplicate entries, worth about 3.2 lakh rupees, which the team then corrected. I also built a simple Excel template with lookup formulas that cut the reconciliation time for the next month. I learned how much of finance is careful checking, and how to ask good questions without disturbing busy people.

I liked Database Management Systems most. One core idea is normalisation, which means organising tables so the same data is not stored in many places. For example, if a student table stores the department name with every student, renaming the department means updating hundreds of rows, and some may be missed. In normalised form, we keep a separate department table and store only the department ID with each student. Then a change happens in one place. I practised this by redesigning our college fest registration sheet into three related tables.

In my fourth semester my SGPA dropped to 6.4. I had taken on the role of technical head for our college fest, and I underestimated how much time it would take. I also had a backlog in Signals and Systems, which I cleared in the next attempt. After that semester I learned to plan my time properly, and my SGPA in the next three semesters was 8.1, 8.4 and 8.3. I still think the fest taught me useful skills, but I would now balance it better by delegating more to my team.

If the problem is “estimate how many cups of tea are sold in our college canteen each day,” I would first clarify whether it is only the main canteen. Then I would break it down: our college has about 3,000 students and 200 staff. On a normal day maybe 70 percent are on campus, so about 2,200 people. If a third of them drink tea once a day and a few drink twice, that is roughly 750 to 900 cups. I would check by asking the canteen staff how many litres of milk they buy each morning.

I chose BCom because I liked accountancy in Class 12 and enjoyed the logic of balancing accounts. During the degree I found I liked analysing numbers more than recording them, especially in cost accounting and financial management. In my second year I learned advanced Excel and some basic SQL from online courses, and used them in a project on working capital of three listed FMCG companies. I want to start as a financial analyst, which is why this role interests me, and in a few years I plan to take the CFA or a similar qualification.

I learned Figma on my own in my second year because our college app looked outdated and I wanted to redesign it. I followed free tutorials for about six weeks, then redesigned three screens of the app and shared them with the student council. They used my design for the fest app that year. I have also completed a short online course in user research and ran five interviews with classmates for my redesign. My portfolio has all three case studies, each explaining the problem, the research and the changes I made.

First I would write down what I did understand and what exactly is unclear, so I do not waste my manager’s time with a vague question. Then I would spend about thirty minutes looking at existing documents, earlier similar work and searching online. If I was still stuck, I would ask my manager or a teammate with my specific questions and what I had already tried. During my college project, this habit helped, because my guide said my questions were easy to answer. I would also confirm the deadline and what “done” looks like.

My final-year mechanical project was designing a low-cost solar dryer for small farmers near our college. We built a prototype using a wooden box, a black-painted aluminium sheet and a small fan run by a 20-watt solar panel. I was responsible for the airflow design and temperature testing. We dried tomatoes and chillies and compared them with open sun drying. The dryer reached up to 60 degrees and cut drying time roughly in half, with less dust contamination. Our guide submitted it to the state innovation challenge, where it reached the final round.

Yes. In my final year I did a three-month part-time internship with a small bakery chain that had four outlets. They wanted more online orders. I set up their business listings, took proper photos of their twenty best-selling items and ran a simple WhatsApp ordering flow with a fixed menu. I tracked orders in a shared sheet. Online orders went from about five a day to around twenty-five over the three months. I also learned that small businesses need things to be simple, so I wrote a one-page guide the staff still use.

In our semester project, one teammate missed three meetings and had not started his part, the literature review, two weeks before submission. I called him instead of complaining in the group chat. He said he was struggling with a part-time job. We agreed he would take a smaller task that he could do on weekends, making the slides, and I split the literature review with another teammate. We told our guide honestly about the change in roles. We submitted on time, and he did a good job on the presentation.

In my third year, I applied for twenty summer internships and was rejected by all of them, mostly after the first test. I was upset, but I asked a senior who had placed well to look at my approach. He pointed out that I was weak in aptitude speed and my resume listed courses, not projects. For the next three months I practised aptitude daily for forty-five minutes and built two small projects. In the next cycle I cleared four tests and got an internship with a data analytics start-up.

I was the head of logistics for our college’s annual technical fest, leading a team of twelve volunteers. My job was venues, equipment and food for about 1,500 participants over two days. I divided the team into three groups with a lead each and made a shared checklist with deadlines. On day one, a projector in the main hall failed ten minutes before a talk. Because we had kept a spare in the store, we replaced it in five minutes. I learned that most leadership is planning ahead for the things that can go wrong.

During my internship, my manager asked me to build a dashboard in Power BI, which I had never used, for a meeting in five days. On the first day I watched a two-hour beginner course and rebuilt their sample report. On the second day I connected the company’s sales Excel file and made basic charts. I asked a senior analyst for fifteen minutes to review my data model, which saved me from a wrong relationship between tables. I delivered the dashboard a day early, and the team used it for their monthly review.

In my second year, a professor gave my report on renewable energy policy a low grade and wrote that it was “descriptive, not analytical.” At first I thought it was unfair because I had worked hard. I went to her office hours and asked her to show me what analytical meant. She showed me that I had listed policies but never compared their results or argued which worked better. I rewrote one section for practice, and my next report got one of the highest marks in the class. I still use her question: “So what?”

In my final semester, I had my project submission, two internal exams and a placement test in the same week. I listed everything with deadlines and the marks or importance of each. The project was worth the most, so I finished my part three days early by working on it every morning. I did exam revision in the evenings using past papers only, and kept one evening for aptitude practice before the placement test. I also told my project team early that I would be less available that week. I met every deadline and cleared the placement test.

I understand that companies invest in training freshers, so a bond is a way to protect that investment. I plan to stay at least two years in my first job anyway, because I want to learn properly before thinking of a change. Before signing, I would like to understand the exact terms: the duration, the amount if I leave early, and whether it applies from the joining date or after training. If the terms are reasonable and clearly written, I am comfortable signing. I would also discuss it with my parents, since it is a legal commitment.

Yes, I am willing to relocate. I have lived in a hostel for four years, so living away from home is not new for me. I would prefer a city with a technology team because I want to work on development projects, but I understand freshers are posted based on business needs, and I would accept any location for the first posting. I am also comfortable with rotational or night shifts if the project needs it. I would only ask for a little notice before joining, so I can arrange accommodation.

I do want to do an MBA eventually, but not for at least three years. I believe work experience will make the MBA more valuable, and I want to understand how businesses actually run first. At the moment I have one offer from a services company, but your role is my first preference because it is in product analytics, which is exactly what I did in my internship. If I get this offer, I will inform the other company immediately and decline it properly so the seat can go to someone else.