Build a Technology Data Report

You will turn a small synthetic dataset into a report that someone else can audit. The assignment is successful only if the formulas, chart, observation, and limitation agree with the same evidence.

Synthetic device dataset

Create or copy this classroom-safe data into Sheets:

These records are fictional. Do not replace them with real student device histories.

Step 1 — document the model

Create a small data dictionary for the five fields. Include type and unit. This forces you to define what a value means before you calculate with it.

Step 2 — calculate transparent summaries

At minimum calculate:

• average battery percentage;
• minimum and maximum screen time;
• average storage used;
• count of numeric battery observations.

Label each result with a unit or clear description. Keep the formulas visible for review.

Step 3 — filter one question

Choose a bounded condition, for example:

• battery below 60%;
• screen time above 200 minutes;
• storage used above 50 GB.

State the condition before interpreting the filtered results.

Step 4 — build one useful chart

Choose a chart that answers a specific question. Write the question as the chart title or nearby description.

A bar chart might compare battery percentage by device. A scatter plot could explore whether screen time and battery percentage move together in this tiny sample. If you choose the scatter plot, remember that association does not prove causation.

Step 5 — write a claim and a limitation

Your observation must be specific to the supplied data.

Weak:

More screen time destroys batteries.

Defensible:

In this eight-device fictional sample, the devices with the two longest screen-time values also have battery readings below 62%. This single snapshot does not establish that screen time caused the lower battery values.

Submit — Student Technology Data Report

Your report contains:

1. cleaned/organized dataset;
2. mini data dictionary;
3. at least four labeled calculations;
4. one documented filter;
5. one chart;
6. one evidence-bounded observation;
7. one limitation;
8. one screenshot or formula record that allows the calculation path to be inspected.

Defense

Be ready to explain why the chart type fits the question, what records were included, and which claim would become invalid if the sample changed.

A spreadsheet becomes evidence when another person can follow data → operation → result → claim without guessing.