Campus Visitor Pass with Data Science: A 2027 Project Guide

Use a familiar campus workflow to practise Data Science: campus visitor pass. The user is a campus reception volunteer, and the first question is: How many visitors have approved passes by purpose? The deliverable is an exploratory modelling study with a visible rule and repeatable evidence behind its output.

This is a 2027 study-edition project brief. All example records and operational situations are fictional. Start with basic Data Science knowledge, the ability to inspect structured data and a local practice environment. The complete first version should answer the stated question before adding accounts, real integrations or additional screens.

Define the project rule

Approved visitor counts describe permission in a fictional system, not physical attendance. Revoked passes must leave the approved total while retaining the decision history. For this exercise, one row represents one pass_request. The stable key is record_id; visit_purpose is the grouping or filtering label. The numeric visitor_count field uses visitors. Accepted states are requested, approved, revoked.

The summary selects status approved and applies sum to the selected numeric values. Keep this definition visible in the interface, response or report so another learner can reproduce it. Use positive finite values in the starter fixture and define any future zero or missing-value policy explicitly.

Choose the Data Science approach

Separate descriptive analysis from a predictive experiment. Start by defining what could be known at decision time, then investigate whether a target is meaningful. Use a simple baseline and keep evaluation records separate from training. A three-row fixture can test processing logic, but it cannot support a credible model-performance claim.

The three design decisions to explain in your project notes are:

• Question and target definition. Apply this choice to pass_request records and explain its effect on visitor_count.
• Leakage-aware data separation. Apply this choice to pass_request records and explain its effect on visitor_count.
• Comparison with a simple baseline. Apply this choice to pass_request records and explain its effect on visitor_count.

Work through a small sample

A separate predictive extension needs an adequately sized labelled synthetic dataset, a declared target and held-out evaluation. The example below only checks the processing contract.

[
  {
    "record_id": "visitor-passes-01",
    "visit_purpose": "Project Demo",
    "visitor_count": 2,
    "status": "approved",
    "recorded_on": "2027-01-04"
  },
  {
    "record_id": "visitor-passes-02",
    "visit_purpose": "Open Lab",
    "visitor_count": 1,
    "status": "requested",
    "recorded_on": "2027-01-05"
  },
  {
    "record_id": "visitor-passes-03",
    "visit_purpose": "Workshop Visit",
    "visitor_count": 3,
    "status": "approved",
    "recorded_on": "2027-01-06"
  }
]

Only the first and third records match approved. Their visitor_count values are 2 and 3; the full-fixture result is 5 visitors, with 2 matching records. Selecting visit_purpose = Project Demo leaves the first record, so the result becomes 2 visitors, with 1 match. This provides two independent checks for the filter and aggregation.

The full-fixture output contract is:

{
  "matching_count": 2,
  "operation": "sum",
  "value": 5,
  "unit": "visitors"
}

Check the result by visit_purpose

The overall figure answers the all-records version of the question. Grouping by visit_purpose produces the following separate expectations, using the same approved rule. The middle group has a record in the source fixture but no qualifying observation.

Use this breakdown when answering the group-level question. Compare like-for-like units and keep the matching count visible, especially for averages. A different filter changes which records enter the calculation; it does not change the meaning of the metric.

The code blocks describe sample data and an expected result. Implement the surrounding feature using the installed version of your chosen tools, then save the actual run evidence separately from these expectations.

Build the feature in three passes

1. Establish a non-predictive baseline

First answer the descriptive question using the sum of visitor_count for approved records. This creates a verified baseline and exposes schema problems. Three sample pass_request records support processing tests, not a meaningful training experiment.

2. Define a defensible extension

Propose a synthetic target such as whether a future visitor_count exceeds a threshold chosen before training. State when the prediction would be made and which visit_purpose and status information would be available then. Obtain enough labelled synthetic examples to study the question.

3. Evaluate without leaking the answer

Separate training and evaluation data before fitting preprocessing. Compare the model with a simple reference and inspect errors by visit_purpose. Report the data construction and limitations. Keep measured evaluation results out of the article until the experiment has actually run.

Find the mistake before polishing the result

A useful defect to introduce deliberately is: Revoked passes still appear as approved visitors. First reproduce it against the fixture, then identify the smallest rule or state transition that explains the mismatch. Fix that boundary and rerun the full-fixture and selected-label examples. This creates a stronger explanation than changing several unrelated parts until the screen looks right.

The scenario-specific acceptance check is: Revoke a pass and verify the approved count changes without erasing the request. Preserve before-and-after evidence. Add a missing visit_purpose, a negative visitor_count, an unrecognised status and a duplicate record_id as separate invalid cases. Define the rejection or duplicate-handling policy before testing, and verify that invalid input does not silently change valid existing records.

Check the Data Science concerns as well:

• Future information must not enter features.
• The baseline must use the same evaluation records.
• Tiny synthetic examples must not become accuracy claims.

For an empty filter match, the expected sum value is 0. Keep matching_count at zero. This distinction prevents an empty dataset from being interpreted as a measured observation.

Explain the finished work in a portfolio

Show the campus reception volunteer question, the record definition and the expected calculation first. Then demonstrate a visit_purpose filter and the acceptance check. Include the fixture, setup instructions, chosen tool versions, actual test output and one remaining limitation in the repository. If you show a screenshot, pair it with the input that produced it. Another learner should be able to repeat the same result from a clean checkout.

For a focused extension, add a second visit_purpose selection and compare the two groups using the same rule. Specify how missing groups appear and keep the original fixture as a regression case. Expand scope only after the current calculation, state handling and recovery path remain understandable.

Questions learners often ask

Which pass_request records belong in the result?

Select records whose status is exactly approved and that satisfy the chosen visit_purpose filter. Other states remain in the source data and can have separate summaries. Follow the domain rule above when a record changes state.

What should happen when no records match?

Return a zero total with a matching count of zero and a clear empty-result message. Keep the applied filter visible so the user can change it. Avoid using a loading indicator for a completed request that simply has no matching data.

How can I prove the visitor_count result is correct?

Reconcile the first and third sample records, then repeat the calculation for Project Demo alone. Save both expected and actual outputs, and rerun the scenario-specific acceptance check after making a change.

Continue learning with Groot Academy

Use this exercise as a concrete discussion point when choosing a learning path. Explore the related Groot Academy course and ask about the current syllabus, learning mode and project practice. Course availability and batch details should be confirmed directly with the academy.

For implementation details, consult the official Data Science documentation matching the tools you install. This project defines an original practice brief; it does not depend on a forecast about 2027 software releases.

Continue with Community Book Exchange using Data Science, or compare Campus Visitor Pass using Machine Learning. These companion practice guides are part of the 2027 learning collection.