Skip to lesson
Week 3Mission Control

Make a useful resource pack.

Digital Literacy Level 2 · Week 3

Tonight you make a handout, a PDF, a supply list and a flyer, one step at a time.

Illustrative West Virginia learning scenario
Fictional people and setting
Week 3Mission Control

Start with what you know.

Think of a flyer or handout that was easy to follow. What made it easy?

Share one example. Passing is welcome.

Week 3Mission Control

Tonight's goals

By the end of tonight, you can:

  1. Part 1 · Word: Make headings Word can find.
  2. Part 2 · Word: Save a PDF that looks the same everywhere.
  3. Part 3 · Excel: Add costs with a total that updates.
  4. Part 4 · PowerPoint: Use a photo the right way.

These four skills are on your post-test.

Week 3Mission Control

How tonight works.

  1. 1
    Watch the step on the big screen.
  2. 2
    Do the same step on your computer.
  3. 3
    Check You should see. Not the same? Raise your hand.

The colored box at the top of every slide names the program you are in, like Working in: Microsoft Word.

Week 3Working in: Microsoft EdgeBefore we start · Step 1 of 2

Open the course website

  1. Click Microsoft Edge on the taskbar at the bottom.
  2. Click the address bar at the top. Type vublessons.com, press Enter.

You should see: the VUB Learning page with course cards.

Week 3Working in: Microsoft EdgeBefore we start · Step 2 of 2

Open your Week 3 worksheet

  1. On the Digital Literacy — Level 2 card, click Open course.
  2. Scroll down to Week 3. Click Worksheet.

You should see: a page titled Week 3 · Worksheet. Leave it open for Part 4.

Week 3Working in: Microsoft WordPart 1 of 4

Now working in: Microsoft Word

Word makes documents: letters, flyers and handouts.

You will make: a one-page computer-help handout with real headings and numbered steps.

Goal 1: Make headings Word can find

Week 3Working in: Microsoft WordPart 1 · Why it matters

Bold is not a heading.

  1. 1
    A heading is the title of a section.
  2. 2
    Bold text only looks like a heading. Word cannot find it.
  3. 3
    A heading style, like Heading 1, tells Word: this is a title. Word then lists it in the Navigation Pane.
Week 3Working in: Microsoft WordPart 1 · Watch

Watch: make a real heading

Watch for: the title turning into Heading 1, then showing in the Navigation Pane.

0:29 long. It stops by itself.

Week 3Working in: Microsoft WordPart 1 · Step 1 of 12

Open Word

  1. Press the Windows key on your keyboard. (Or click Start at the bottom left.)
  2. Type Word and press Enter.

You should see: the Word start screen, with a Blank document tile.

Week 3Working in: Microsoft WordPart 1 · Step 2 of 12

Start a blank document

  1. Click Blank document.

You should see: a white page with a blinking line at the top. The blinking line is the cursor: where your typing goes.

Week 3Working in: Microsoft WordPart 1 · Know your screen

Find your way around Word

  1. File: save your work.
  2. Home tab: most buttons.
  3. Numbering: makes 1, 2, 3.
  4. Styles box: Heading 1, Heading 2.
  5. View tab: Navigation Pane.
Week 3Working in: Microsoft WordPart 1 · Step 3 of 12

Type the handout

  1. Type the seven lines below. Press Enter at the end of each line.

You should see: seven lines, all the same size and color.

Type these lines:

Computer help at the library

Who it helps

Anyone who wants to practice one computer task.

Steps

Choose one task.

Visit the learning desk.

Ask how to repeat it at home.

Week 3Working in: Microsoft WordPart 1 · Step 4 of 12

Make the title a Heading 1

  1. Click anywhere in the first line, Computer help at the library.
  2. On the Home tab, in the Styles box, click Heading 1.

You should see: the line gets bigger and turns dark blue.

Week 3Working in: Microsoft WordPart 1 · Step 5 of 12

Make two section headings

  1. Click in the line Who it helps. Click Heading 2.
  2. Click in the line Steps. Click Heading 2.

You should see: both lines turn dark blue. They are a little smaller than the title.

Week 3Working in: Microsoft WordPart 1 · Step 6 of 12

Select the three steps

  1. Point just before the C in Choose one task.
  2. Hold the left mouse button down. Drag to the end of home. Let go.

You should see: the three step lines shaded gray: selected.

Week 3Working in: Microsoft WordPart 1 · Step 7 of 12

Number the steps

  1. On the Home tab, click Numbering: the button with 1, 2, 3 on it.

You should see: 1., 2. and 3. in front of the three steps.

Week 3Working in: Microsoft WordPart 1 · Step 8 of 12

Check your headings

  1. Click the View tab.
  2. Click the box next to Navigation Pane so it has a check mark.

You should see: a panel on the left that lists Computer help at the library, Who it helps and Steps.

Week 3Working in: Microsoft WordPart 1 · Step 9 of 12

Save: open the Save As box

  1. Click File at the top left.
  2. Click Save As, then click Browse.

You should see: a box titled Save As.

Week 3Working in: Microsoft WordPart 1 · Step 10 of 12

Make your Resource pack folder

  1. On the left side of the box, click Documents.
  2. Click New folder near the top. Type Resource pack and press Enter.

You should see: a new folder named Resource pack.

Week 3Working in: Microsoft WordPart 1 · Step 11 of 12

Open the folder

  1. Double-click Resource pack.

You should see: the top of the box ends in Resource pack. The folder is empty.

Week 3Working in: Microsoft WordPart 1 · Step 12 of 12

Name it and save

  1. Click in the File name box. Press Ctrl and A together to highlight the old name.
  2. Type Computer help handout. Click Save.

You should see: Computer help handout at the very top of the window.

Week 3Working in: Microsoft WordPart 1 · Check

Bold text looks like a heading. What proves it is a real heading?

Choose an answer, then explain your reason.

Week 3Working in: Microsoft WordPart 2 of 4

Still working in: Microsoft Word

A PDF is a copy of your document that looks the same on every computer and printer, even one without Word.

You will make: a PDF of your handout, ready to email or print.

Goal 2: Save a PDF that looks the same everywhere

Week 3Working in: Microsoft WordPart 2 · Why it matters

Word document or PDF?

  1. 1
    Word document: for you. Keep changing it.
  2. 2
    PDF: for other people. It looks the same on any computer or printer, even without Word.
  3. 3
    Keep both. Change the Word document, then make a new PDF.
Week 3Working in: Microsoft WordPart 2 · Watch

Watch: why a PDF

Watch for: the PDF keeping the finished look for reading and printing.

0:09 long. It stops by itself.

Week 3Working in: Microsoft WordPart 2 · Step 1 of 4

Open the Save As box again

  1. Click File at the top left.
  2. Click Save As, then click Browse.

You should see: the Save As box. It opens in your Resource pack folder.

Week 3Working in: Microsoft WordPart 2 · Step 2 of 4

Choose PDF

  1. Click the Save as type box, just under File name.
  2. In the list, click PDF (*.pdf).

You should see: Save as type now says PDF (*.pdf).

Week 3Working in: Microsoft WordPart 2 · Step 3 of 4

Save the PDF

  1. Check that Open file after publishing has a check mark. If not, click its box.
  2. Click Save.

You should see: your handout opens as a PDF in Microsoft Edge.

Week 3Working in: Microsoft EdgePart 2 · Step 4 of 4

Check your PDF

  1. Look at the PDF. Find the three blue headings and the numbers 1, 2 and 3.

You should see: the same headings and numbers you made in Word.

Week 3Working in: Microsoft WordPart 2 · Check

You email your handout as a PDF. What will your neighbor see?

Choose an answer, then explain your reason.

Week 3Working in: Microsoft ExcelPart 3 of 4

Now working in: Microsoft Excel

Excel works with numbers in a grid of boxes called cells.

You will make: a supply list with a total that updates by itself.

Goal 3: Add costs with a total that updates

Week 3Working in: Microsoft ExcelPart 3 · Why it matters

Every cell has an address.

  1. 1
    Columns have letters: A, B, C. Rows have numbers: 1, 2, 3.
  2. 2
    B5 means column B, row 5.
  3. 3
    A formula starts with =. Excel works out the answer, and works it out again when a number changes.
Week 3Working in: Microsoft ExcelPart 3 · Watch

Watch: a formula that adds

Watch for: the formula =SUM(B2:B4) adding the three costs.

1:05 long. It stops by itself.

Week 3Working in: Microsoft ExcelPart 3 · Step 1 of 11

Open Excel

  1. Press the Windows key on your keyboard. (Or click Start at the bottom left.)
  2. Type Excel and press Enter.

You should see: the Excel start screen, with a Blank workbook tile.

Week 3Working in: Microsoft ExcelPart 3 · Step 2 of 11

Start a blank workbook

  1. Click Blank workbook.

You should see: a grid of empty boxes called cells. The cell A1 has a green border.

Week 3Working in: Microsoft ExcelPart 3 · Know your screen

Find your way around Excel

  1. The formula bar: shows what is really in a cell.
  2. A cell: the box where a column and a row meet. This one is A1.
  3. File is at the top left, the same as in Word.
Week 3Working in: Microsoft ExcelPart 3 · Step 3 of 11

Type the labels

  1. Click cell A1. Type Item and press Tab.
  2. Type Cost in dollars and press Enter.

You should see: Item in A1 and Cost in dollars in B1.

Week 3Working in: Microsoft ExcelPart 3 · Step 4 of 11

Type the supplies

  1. In A2 type Paper, press Tab, type 12, press Enter.
  2. Do the same for Folders and 8, then Pens and 5.

You should see: Paper 12, Folders 8 and Pens 5 in rows 2, 3 and 4.

Week 3Working in: Microsoft ExcelPart 3 · Step 5 of 11

Add the total

  1. Click A5. Type Total and press Tab.
  2. In B5, type =SUM(B2:B4) and press Enter.

You should see: B5 shows 25.

Week 3Working in: Microsoft ExcelPart 3 · Step 6 of 11

Look at the formula

  1. Click cell B5.
  2. Look at the long box above the column letters: the formula bar.

You should see: the cell shows 25. The formula bar shows =SUM(B2:B4).

Week 3Working in: Microsoft ExcelPart 3 · Step 7 of 11

Predict

  1. Paper is going up from 12 to 15. Before you change anything, guess: what will B5 show? Say it out loud or write it down.

You should see: your guess, ready to check.

Your guess (worksheet, Part 3):

If paper costs 15, B5 will show:

Week 3Working in: Microsoft ExcelPart 3 · Step 8 of 11

Change one cost

  1. Click cell B2. Type 15 and press Enter.

You should see: B5 changes to 28 by itself. Was your guess right?

Week 3Working in: Microsoft ExcelPart 3 · Step 9 of 11

Save: open the Save As box

  1. Click File at the top left.
  2. Click Save As, then click Browse.

You should see: a box titled Save As.

Week 3Working in: Microsoft ExcelPart 3 · Step 10 of 11

Open your Resource pack folder

  1. On the left side of the box, click Documents.
  2. Double-click Resource pack.

You should see: the top of the box ends in Resource pack.

Week 3Working in: Microsoft ExcelPart 3 · Step 11 of 11

Name it and save

  1. Click in the File name box. Press Ctrl and A together to highlight the old name.
  2. Type Supply list. Click Save.

You should see: Supply list at the very top of the window.

Week 3Working in: Microsoft ExcelPart 3 · Check

B5 has =SUM(B2:B4) and shows 28. You change Pens from 5 to 7. What will B5 show?

Choose an answer, then explain your reason.

Week 3Working in: Microsoft PowerPointPart 4 of 4

Now working in: Microsoft PowerPoint

PowerPoint makes slides for talks, and one-page flyers.

You will make: a one-slide flyer with a photo you have permission to use.

Goal 4: Use a photo the right way

Week 3Working in: Microsoft PowerPointPart 4 · Why it matters

Use photos the right way.

  1. 1
    Finding a photo online does not mean you may use it.
  2. 2
    Our practice photo's permission says: you may use it and crop it if you give credit.
  3. 3
    Cropping trims the edges on your slide. The photo file itself does not change.
Week 3Working in: Microsoft PowerPointPart 4 · Watch

Watch: permission and credit

Watch for: why a photo from a search still needs permission and credit.

0:16 long. It stops by itself.

Week 3Working in: Microsoft PowerPointPart 4 · Watch

Watch: crop or resize

Watch for: the difference between cropping and making a picture smaller.

0:26 long. It stops by itself.

Week 3Working in: Microsoft EdgePart 4 · Step 1 of 13

Download the practice photo

  1. Click Microsoft Edge on the taskbar. Click the Week 3 · Worksheet tab.
  2. Scroll to Part 4. Click Download the practice photo.

You should see: practice-photo.jpg at the top right.

Week 3Working in: Microsoft PowerPointPart 4 · Step 2 of 13

Open PowerPoint

  1. Press the Windows key on your keyboard. (Or click Start at the bottom left.)
  2. Type PowerPoint and press Enter.

You should see: the PowerPoint start screen, with a Blank Presentation tile.

Week 3Working in: Microsoft PowerPointPart 4 · Step 3 of 13

Start a blank presentation

  1. Click Blank Presentation.

You should see: one white slide with two boxes: Click to add title and Click to add subtitle.

Week 3Working in: Microsoft PowerPointPart 4 · Know your screen

Find your way around PowerPoint

  1. File: where you save.
  2. Insert tab: add a picture.
  3. Design tab: choose a theme.
Week 3Working in: Microsoft PowerPointPart 4 · Step 4 of 13

Pick a theme

  1. Click the Design tab.
  2. Click any theme you like in the Themes row.

You should see: your slide changes color and style.

Week 3Working in: Microsoft PowerPointPart 4 · Step 5 of 13

Type the title

  1. Click Click to add title.
  2. Type Need computer help?

You should see: your title on the slide.

Week 3Working in: Microsoft PowerPointPart 4 · Step 6 of 13

Type the photo credit

  1. Click Click to add subtitle.
  2. Type Photo: VUB practice photo, used with permission.

You should see: the credit line under the title.

Week 3Working in: Microsoft PowerPointPart 4 · Step 7 of 13

Insert the photo

  1. Click the Insert tab.
  2. Click Pictures, then click This Device.

You should see: a box titled Insert Picture.

Week 3Working in: Microsoft PowerPointPart 4 · Step 8 of 13

Choose the photo

  1. On the left side of the box, click Downloads.
  2. Click practice-photo, then click Insert.

You should see: the photo on your slide. If a Designer panel opens on the right, click the X at the top of that panel.

Week 3Working in: Microsoft PowerPointPart 4 · Step 9 of 13

Crop the photo

  1. Click the photo. Click the Picture Format tab, then Crop.
  2. Drag a black mark on one side inward. Press Esc.

You should see: that edge trimmed away.

Week 3Working in: Microsoft PowerPointPart 4 · Step 10 of 13

Make it fit

  1. Drag a corner circle of the photo inward to shrink it.
  2. Drag the middle of the photo off your words.

You should see: the title, the credit line and the photo, all in view.

Week 3Working in: Microsoft PowerPointPart 4 · Step 11 of 13

Save: open the Save As box

  1. Click File at the top left.
  2. Click Save As, then click Browse.

You should see: a box titled Save As.

Week 3Working in: Microsoft PowerPointPart 4 · Step 12 of 13

Open your Resource pack folder

  1. On the left side of the box, click Documents.
  2. Double-click Resource pack.

You should see: the top of the box ends in Resource pack.

Week 3Working in: Microsoft PowerPointPart 4 · Step 13 of 13

Name it and save

  1. Click in the File name box. Press Ctrl and A together to highlight the old name.
  2. Type Flyer. Click Save.

You should see: Flyer at the very top of the window.

Week 3Working in: Microsoft PowerPointPart 4 · Check

Why does the flyer have a photo credit line?

Choose an answer, then explain your reason.

Week 3Working in: File ExplorerWrap-up

Check your Resource pack

  1. Click File Explorer (the yellow folder) on the taskbar.
  2. Click Documents, then double-click Resource pack.

You should see: four files: the handout (Word and PDF), Supply list and Flyer.

Week 3Mission ControlWrap-up

Show your instructor.

  1. the Navigation Pane in Word listing your three headings
  2. your PDF
  3. B5 showing 28 and the formula bar showing =SUM(B2:B4)
  4. your flyer with the credit line
Week 3Mission ControlWrap-up

I can…

  • Make headings Word can find.
  • Save a PDF that looks the same everywhere.
  • Add costs with a total that updates.
  • Use a photo the right way.

Check each box on your worksheet that you can do now.

Week 3Mission ControlWrap-up

Take it home.

Make one real handout with a heading and numbered steps, or a short list of costs with a SUM total. Bring one thing you noticed to Week 4.

Week 3Mission Control

Mission complete.

You made a handout, a PDF, a supply list and a flyer.