Week 3 explainer and transcript
Build a clear resource handout, a small workbook, and a short presentation.
Choose a chapter or replay a skill
Create for a person and a purpose
Think about a notice, set of directions, or supply list that was easy to use. What helped you find the next step? We will apply those same practical standards to a small resource pack: a handout, a supply workbook, and three slides. Choose a fictional community activity such as a library computer-help session or a neighborhood meeting. Decide who will use the material and what they need to do after reading it. A beautiful page that leaves the reader unsure is unfinished. Keep that reader's task in view as we make choices about words, structure, calculations, pictures, and the final file format.
Give the document a readable structure
Start the handout with the service and the next action. Use a real heading style for the title and section headings, followed by short paragraphs or a numbered list when order matters. Selecting bold text changes appearance, but does not necessarily identify a heading to assistive technology or a navigation pane. A numbered sequence might say choose a task, visit the learning desk, and ask how to repeat the skill at home. Use link text that names the destination instead of click here. Read the document in order without relying on color or position alone. Does it still make sense? That is a useful first accessibility check.
Screen demonstration steps
This is an original screen simulation with fictional practice data. Menus vary by application. Pause or replay each action before trying it yourself.
- Start with meaningful document structure
- Select the title text
- Open Styles → choose Heading 1
- The title now appears in Navigation
- Name the destination in the link text
Edit without losing useful work
Select a short piece of text before changing it, and check what the selection includes. Common shortcuts such as copy, paste, save, and undo can reduce repeated mouse work; your instructor can show the keys for your computer. Practice on a copy so a mistake is easy to reverse. When reviewing someone else's document, a comment asks a question or suggests an improvement. Tracked changes record proposed edits for review, where the application supports them. They are not the same as silently replacing the text. Pause and propose one specific improvement to the handout. Explain the reader's problem it solves, then let the author decide whether to accept it.
Read a worksheet like a labeled table
A workbook can contain several worksheets. Within a sheet, columns usually have letters, rows have numbers, and a cell address combines both. B2 means column B, row two. Our fictional supply list puts item names in column A and dollar amounts in column B: paper at twelve, folders at eight, and pens at five. Include a heading that explains the units, so twelve is clearly dollars rather than boxes. Enter the values in separate cells instead of putting the whole list into one cell. Before calculating anything, check that each amount sits beside the intended item. A correct formula cannot rescue numbers assigned to the wrong rows.
Build a formula and challenge it
Select a total cell outside the three input cells and enter equals SUM, followed by the range B2 through B4 in parentheses. The colon means include the cells from the first address through the last. The expected total is twenty-five dollars. Now change paper from twelve to fifteen. The total should become twenty-eight because the formula refers to the cells, not to a permanently typed answer. If it stays at twenty-five, inspect the formula and range. Did you type the total manually? Did the range omit a cell? Pause and predict the result before changing a value. Then compare the observed total with your prediction and correct any mismatch.
Screen demonstration steps
This is an original screen simulation with fictional practice data. Menus vary by application. Pause or replay each action before trying it yourself.
- Select B5 • keep the total outside the input range
- Enter =SUM(B2:B4)
- Check the expected total: $25
- Predict the new total before the change
- Change B2 from 12 to 15
- The formula recalculates: $28
- Check =SUM(B2:B4) if the result is wrong
Choose a chart that answers a question
A chart should help someone see a relationship in the checked data. To compare the three supply costs, select the item labels and their values, then choose a simple bar or column chart. Give it a meaningful title and make the dollar units clear. Check that the labels still match their bars. A large bar should represent the larger value, not merely a brighter color. After changing the paper cost, confirm that the chart follows the updated cells. If a chart looks surprising, return to the table before decorating it. Keep the table available so a reader can inspect exact amounts and understand the information without relying only on the graphic.
Make slides and images serve the message
For a three-slide presentation, use the first slide to name the useful task, the second to demonstrate the key steps, and the third to show the next action. Prefer a relevant picture or diagram to a paragraph copied from the handout. Keep text large and explain unfamiliar terms aloud. Cropping removes outer parts of an image from the view; resizing changes its displayed dimensions. Those actions solve different problems. Preserve the original file before experimenting, and check that a crop has not removed information the viewer needs. If an image carries meaning, provide an equivalent explanation or alternative text in the format you are using.
Edit a short clip for understanding
A useful instructional clip has a clear beginning, an understandable action, and a visible result. Trimming removes unwanted material at the start or end. Splitting allows you to work with sections inside a clip, such as removing a long unrelated interruption. Watch both sides of an edit: did it cut off the first syllable or remove the step that explains the result? Keep speech intelligible and check captions against the final audio after editing. Captions from an earlier version may drift. You do not need elaborate effects. The goal is for another person to follow the action, pause when needed, and understand what changed.
Choose a format and inspect what survives
Decide what the next person needs to do. An editable document supports revision. A PDF often preserves a finished layout for viewing or printing. A CSV carries plain table data, but does not preserve a workbook's full formatting and formula behavior. Keep the editable original as well as the export. Reopen the exported file and inspect the page breaks, labels, links, and important values. If you reused someone else's image or wording, check the permission or license and provide the required credit. Finding an image in a search result does not automatically give you permission to reuse it. Use original or appropriately licensed material for the practice pack.
Test the pack with another person
Pause and ask a partner to use your resource pack without your explanation first. Can they identify the next action on the handout? Can they find the total and explain what changed when one cost changed? Can they tell what each slide contributes? Record one point of confusion and revise it. Then reopen the export and repeat the affected check. This is useful evidence of learning: the document has structure, the calculation responds correctly, and another reader can act on the result. Carry the same routine into a household budget, a community notice, or another task you choose. Create for a reader, test the result, and keep a recoverable original.