Build an Interview Prep Tracker with Score-Based Learning

Story: why students always feel stuck

Anirudh studies DSA questions every day but never improves because he does not see trends. He remembers “I solved many questions”, but not which topic is weak.

This project creates a topic-wise score card and revision planner.

What to explain in beginner language

• A topic is a folder of related questions.
• A score is evidence, not just attempt count.
• A weak topic is where score is lower, not just where student feels weak.

Step map

Step 1: store questions

For each question:

• topic,
• question,
• difficulty,
• date,
• result score (0–5),
• attempt notes.

Step 2: calculate averages

For each topic: average = total score / attempts.

Step 3: rank priorities

Sort by average ascending. Show bottom two topics first.

Step 4: weekly review output

Print:

• best topic,
• worst topic,
• topic needing immediate revision.

Code starting point

def average(values):
    if not values:
        return 0
    return sum(values) / len(values)

Understanding the central idea

Data work converts raw records into evidence that supports a decision. Loading a file is only the beginning; useful analysis also defines each field, checks quality, transforms values consistently, and explains what the result does and does not prove.

The purpose of this article is to connect that idea to a complete working flow. Individual commands matter, but the lasting skill is understanding why each part exists and how information moves from the user's action to a trustworthy result.

Begin with the nouns and verbs in the problem. The nouns usually become data—such as a user, transaction, note, file, or task—while the verbs become operations such as create, validate, calculate, update, and report. This simple translation gives the project a shape before framework or library choices distract from the core behaviour.

It also helps to separate facts from derived values. Store facts that arrived from a trusted input and calculate summaries from those facts when possible. Duplicating calculated totals in several places creates inconsistencies because one copy can change while another remains stale.

How the pieces work together

A dependable pipeline moves through ingestion, inspection, cleaning, validation, analysis, and presentation. Keeping the raw source unchanged makes the work reproducible, while a documented cleaning step shows exactly how the analytical table was produced.

Build the smallest successful path first. Keep input handling, core logic, storage, and presentation distinct even when they live in one file. This makes the project easier to explain today and easier to split into modules when it grows.

Validation belongs close to the boundary where new data enters. The core logic can then work with values that already satisfy basic rules. Persistence should receive a complete valid change, while presentation should translate the outcome into language the user understands. This order prevents a partially processed request from leaking into saved data.

Naming is part of the design. A function such as calculate_monthly_total communicates more than process, and a value such as normalised_category shows that a transformation has already happened. Clear names reduce the amount of state a beginner must remember while reading the code.

A realistic flow from start to finish

A student-performance table may contain duplicate names, blank scores, and several date formats. The analysis first normalises identifiers and dates, flags rather than guesses missing scores, verifies valid ranges, and only then calculates subject averages and improvement trends.

Follow one record through the whole system and inspect its value after every meaningful transformation. This is more instructive than copying a finished code listing because it reveals where assumptions enter the program and where an incorrect value would first become visible.

For the first implementation, use a tiny dataset that can be checked by hand. Three or four records are usually enough to expose ordering, totals, duplicates, and empty-state behaviour. Once the hand-calculated result agrees with the program, add a larger or messier input and observe which assumptions no longer hold.

Keep the successful flow visible in the interface or console output. The result should confirm what changed and include the identifier or summary needed for the next action. A generic message such as “done” hides useful evidence and makes later debugging unnecessarily difficult.

Reliability and common failure points

Always inspect row counts before and after cleaning. Check missing values, duplicates, data types, impossible ranges, and category spelling. An attractive chart cannot repair an incorrect denominator or an undocumented decision to drop inconvenient records.

Treat error handling as part of the user experience. A useful error message says what failed, what remained safe, and what action can be taken next. During development, keep technical detail in logs while presenting concise recovery guidance to the reader or end user.

Test failures at the same layer that owns the rule. Input-format tests belong near validation, calculation examples belong near the core logic, and save-and-reload checks belong near persistence. This makes a failed test point toward one responsibility instead of forcing the learner to inspect the entire application.

Retries also need care. A retry should not create a duplicate record or repeat a payment-like action. Stable request identifiers, uniqueness rules, or an explicit check before writing make repeated actions safe. Even a beginner project benefits from understanding that users double-click buttons and networks repeat requests.

What a complete result demonstrates

The final report should connect every metric to an action, include enough context to interpret it, and allow another person to reproduce the same result from the same source data.

At that point, improvements such as a richer interface, more automation, or cloud deployment become controlled extensions rather than substitutes for an unfinished core. The result is a project that teaches transferable reasoning as well as syntax.

Document the final flow in a short README with setup steps, one realistic example, expected output, and known limitations. This turns the project into something another person can run and review. It also reveals missing assumptions that were obvious only on the original developer's computer.

The best next improvement is the one supported by evidence from actual use. A confusing message may matter more than a new chart, and protecting saved data may matter more than adding another button. This prioritisation habit is one of the most valuable lessons an end-to-end project can teach.

Worked case study: from problem to evidence

This is an illustrative case study designed to make the engineering decisions concrete. It does not claim results from a named organisation; every conclusion follows from the described inputs and observable behaviour.

Starting situation

Anirudh records only the total number of interview problems solved. The number rises, but repeated failures in arrays and SQL joins remain invisible, so revision follows mood rather than evidence.

Intervention

Each attempt records topic, problem, result, confidence, time, and date. The report combines recent accuracy, repeated failures, and time since last practice to rank topics that need attention.

Evidence collected

A sample of twelve attempts correctly places a repeatedly failed topic above a mastered topic, while one isolated failure does not dominate the entire plan. Editing a mistaken result recalculates the ranking from source attempts.

Practical lesson

A useful learning metric changes the next action. Topic-level evidence is more valuable than a large activity count because it directs limited revision time toward the weakest area.

A useful case study separates observation from opinion. The starting state records the problem, the intervention records what changed, and the evidence shows whether the change produced the intended behaviour. This structure helps readers evaluate an approach instead of accepting a success claim without support.

Test cases and expected behaviour

The following cases act as an executable specification. They are not questions for the reader; they state the conditions, expected outcomes, and reason each check matters.

Run the smallest test first and keep its input stable while repairing a failure. When it passes, add boundary and recovery cases. Changing code and test data simultaneously makes the source of improvement difficult to identify.

For automated tests, use the same arrange-act-assert pattern throughout the project. Arrange creates a known starting state, act performs one behaviour, and assert compares the observable result with the documented expectation. A good assertion checks the outcome that matters to the user, not an internal implementation detail that may change during refactoring.

Interpreting test failures

A failed test is evidence of a mismatch between the implemented behaviour and the written expectation. First confirm that the expectation represents the intended product rule. Next reduce the failure to the smallest input that still reproduces it, inspect the boundary between stages, and change one cause at a time.

Failures often reveal missing product decisions rather than typing mistakes. An empty value, repeated request, unavailable service, or partial save forces the application to choose a behaviour. Recording that decision in both the article and the test suite prevents future changes from silently reintroducing the same uncertainty.

The final test report should state the revision tested, environment, cases executed, results, and any untested limitation. That short record turns “it worked for me” into evidence another learner or reviewer can evaluate.