1
Project phase 1
Plan the work
State the goal, audience or user, and the evidence a strong result needs. Explain how Record and field changes your plan.
Offline-ready notes · progress saves on this device
Lesson 1 of 2
The Data Professional’s Office Toolkit
Read the overview in
English overview
Use Excel’s row-column grid as a bridge to database thinking, then turn raw information into a clear written report and an audience-ready presentation.
Four clear stages
Learn → Project → Check → Finish
- 1LearnRead the lesson and examplesUnderstand the examples before beginning the project.Do this now
- 2ProjectCreate a data-to-decision mini reportPlan it, create it, then prove it meets the definition of done.Next
- 3CheckAnswer all 30 questionsCorrect weak spots using the explanation after each answer.Next
- 4FinishMark the lesson completeThen move to Layout, Grids & Visual Hierarchy.Next
Course outlineDatabase Management & Graphic Design
Detailed lesson
Learn the ideas, then use them.
Read the classroom walkthrough below. The project that follows turns the lesson into a concrete result.
Lesson project · Data report
Create a data-to-decision mini report
A clean table, one supported finding, a short written explanation, and a one-slide presentation.
0%0 of 3 checks
2
Project phase 2
Create the deliverable
Enter a small classroom dataset in Excel with one record per row and one field per column. Summarize one finding in Word and present it on a single PowerPoint slide.
3
Project phase 3
Prove and improve
Use Structured data and Data communication to check the result. Record one piece of evidence, one correction, and one improvement you would make next.
Complete walkthroughDetailed notes, examples, and guided practice
Why this lesson matters
Use Excel’s row-column grid as a bridge to database thinking, then turn raw information into a clear written report and an audience-ready presentation.
The goal is not to memorize vocabulary. By the end of the lesson, you should be able to use the ideas in a realistic situation, explain the reason for your choices, and check whether the result actually works for the intended person or task.
Learning objectives
- Explain Record and field in your own words.
- Apply Structured data to a realistic classroom or community example.
- Connect Record and field with Data communication when making a decision.
- Complete the practice task and reflect on one improvement.
Core ideas
1. Record and field
A row usually represents one record or entity, while each column represents a consistently defined field or attribute.
In practice: Look for this idea while you complete the lesson task. Pause before each major step and explain how Record and field changes what you choose, create, or check.
2. Structured data
Information organized with consistent fields and types so it can be sorted, filtered, validated, queried, and analyzed reliably.
In practice: Look for this idea while you complete the lesson task. Pause before each major step and explain how Structured data changes what you choose, create, or check.
3. Data communication
Turning analysis into a clear explanation and visual that helps a specific audience understand and act on the finding.
In practice: Look for this idea while you complete the lesson task. Pause before each major step and explain how Data communication changes what you choose, create, or check.
How the ideas connect
Start with Record and field to understand the foundation of the lesson. Use Structured data to turn that understanding into an action. Then apply Data communication to check the quality, safety, or usefulness of the result. The three ideas are strongest when you can explain their relationship rather than treating them as separate definitions.
Guided walkthrough
- Name the goal. In one sentence, write what you are trying to understand, create, or improve.
- Make a prediction. Before touching a device, use Record and field and Structured data to predict what a strong result should look like.
- Complete the task. Enter a small classroom dataset in Excel with one record per row and one field per column. Summarize one finding in Word and present it on a single PowerPoint slide.
- Check the outcome. Use Data communication to inspect the result. Ask what worked, what did not, and what evidence supports your judgment.
- Explain and revise. Tell a partner what you changed and why. Make one small improvement, then compare the new result with the first one.
Worked classroom scenario
Imagine two learners sharing one device. The first learner is the driver and performs the steps; the second is the navigator and reads the goal, predicts the next step, and checks the result. Halfway through the task, switch roles. Both learners should be able to explain how Record and field, Structured data, and Data communication appeared in the work.
If no device is available, complete the same reasoning on paper: sketch the screen or result, label each decision, and describe what you would test when a device becomes available.
Common mistakes and fixes
- Rushing into the tool: Write the goal and prediction first so every click or step has a reason.
- Copying without understanding: After each major step, explain it in your own words to a partner.
- Accepting the first result: Compare the outcome with the goal and make at least one deliberate improvement.
- Letting one person control a shared device: Rotate driver and navigator roles so both learners think and practice.
Independent practice
Enter a small classroom dataset in Excel with one record per row and one field per column. Summarize one finding in Word and present it on a single PowerPoint slide.
For an extra challenge, adapt the task for a different audience or community need. Write two sentences explaining what changed and which lesson idea guided your decision.
Check your understanding
- How would you explain Record and field to someone new to the topic?
- What is one realistic example of Structured data outside this classroom?
- When might Data communication prevent a weak, unsafe, or confusing result?
- How are Record and field and Structured data connected?
- What evidence would convince you that your practice result works?
- If you repeated the activity tomorrow, what would you improve first and why?
Key takeaway
Use Excel’s row-column grid as a bridge to database thinking, then turn raw information into a clear written report and an audience-ready presentation.
You are ready to move on when you can explain the three core ideas, complete the practice without copying, and describe one improvement using evidence from your result.