Campus Print Queue with Microsoft Excel: A 2027 Project Guide

The starting point for this Microsoft Excel exercise is a student print-desk volunteer working with print_job records. Their question is specific: How many pages were printed for each document type? Building an auditable spreadsheet report around that question gives the project a manageable scope and makes the result possible to verify.

This is a 2027 study-edition project brief. All example records and operational situations are fictional. Start with basic Microsoft Excel 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

Printed page count records completed output. Cancelled or merely queued jobs must not contribute, and duplex printing needs a separate sheet-count definition if added later. For this exercise, one row represents one print_job. The stable key is record_id; document_type is the grouping or filtering label. The numeric page_count field uses pages. Accepted states are queued, printed, cancelled.

The summary selects status printed 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 Microsoft Excel approach

Convert the fixture into a named table and keep input, calculation and presentation areas separate. Verify that numeric-looking cells are actually numbers before building a summary. Make filters and exclusions visible. Protect the meaning of blank cells rather than replacing every missing value with zero, and reconcile a small manual example before sharing the workbook.

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

• Structured tables. Apply this choice to print_job records and explain its effect on page_count.
• Explicit filter criteria. Apply this choice to print_job records and explain its effect on page_count.
• Formula and total reconciliation. Apply this choice to print_job records and explain its effect on page_count.

Work through a small sample

The three records below are deliberately small enough to inspect by hand. They are a compact specification for the data shape and expected result, and can later be expanded into a larger synthetic fixture.

[
  {
    "record_id": "print-queue-01",
    "document_type": "Workshop Handout",
    "page_count": 25,
    "status": "printed",
    "recorded_on": "2027-01-04"
  },
  {
    "record_id": "print-queue-02",
    "document_type": "Project Report",
    "page_count": 40,
    "status": "queued",
    "recorded_on": "2027-01-05"
  },
  {
    "record_id": "print-queue-03",
    "document_type": "Practice Worksheet",
    "page_count": 15,
    "status": "printed",
    "recorded_on": "2027-01-06"
  }
]

Only the first and third records match printed. Their page_count values are 25 and 15; the full-fixture result is 40 pages, with 2 matching records. Selecting document_type = Workshop Handout leaves the first record, so the result becomes 25 pages, 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": 40,
  "unit": "pages"
}

Check the result by document_type

The overall figure answers the all-records version of the question. Grouping by document_type produces the following separate expectations, using the same printed 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. Inspect the data before charting

Check record_id uniqueness, document_type labels, page_count types and status values. Keep the supplied data as a raw input and create a separate cleaned representation. Record exclusions so the student print-desk volunteer can understand what entered the report.

2. Calculate a transparent metric

Restrict the analysis to printed entries and calculate the sum of page_count. Show both the result in pages and the matching-record count. Reconcile the small fixture by hand before applying a chart, pivot or dashboard measure.

3. Present a reproducible answer

Use a document_type filter and label every unit. Show the empty-selection behaviour and explain the difference between this metric and a wider operational claim. Include the input version and transformation notes so another learner can rebuild the result.

Find the mistake before polishing the result

A useful defect to introduce deliberately is: Page count is labelled sheet count without considering duplex output. 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: Keep page and sheet measures distinct and label the displayed unit. Preserve before-and-after evidence. Add a missing document_type, a negative page_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 Microsoft Excel concerns as well:

• A newly added row must enter the intended range.
• A filtered subtotal must have a clear denominator.
• Text-formatted numbers must not disappear silently.

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 student print-desk volunteer question, the record definition and the expected calculation first. Then demonstrate a document_type 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 document_type 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 print_job records belong in the result?

Select records whose status is exactly printed and that satisfy the chosen document_type 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 page_count result is correct?

Reconcile the first and third sample records, then repeat the calculation for Workshop Handout 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. Browse the current Groot Academy course directory 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 Microsoft Excel 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 Campus Parcel Desk using Microsoft Excel, or compare Campus Print Queue using Power BI. These companion practice guides are part of the 2027 learning collection.