
Week 3 · Worksheet
Follow along with the slides: each step there is a step here. Check the box when you see what You should see describes. Nothing tonight needs an account, a payment or your own personal details.
Tonight’s goals
Check each one at the end of class if you can do it.
Open this worksheet on your computer
It has every step from tonight, a box to check for each one, and the practice photo for Part 4. If you have a printed copy, open it on screen too.
- 1Open the course website. Click Microsoft Edge on the taskbar at the bottom. Click the address bar at the top. Type vublessons.com, press Enter.the VUB Learning page with course cards.
- 2Open your Week 3 worksheet. On the Digital Literacy — Level 2 card, click Open course. Scroll down to Week 3. Click Worksheet.a page titled Week 3 · Worksheet. Leave it open for Part 4.
IF YOU GET STUCK
No Edge on the taskbar? Press the Windows key, type Edge and press Enter.
Cannot find Week 3? Roll the mouse wheel toward you to scroll down. The weeks are in order.
Make a handout with real headings
- 1Open Word. Press the Windows key on your keyboard. (Or click Start at the bottom left.) Type Word and press Enter.the Word start screen, with a Blank document tile.
- 2Start a blank document. Click Blank document.a white page with a blinking line at the top. The blinking line is the cursor: where your typing goes.
- 3Type the handout. Type the seven lines below. Press Enter at the end of each line.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.seven lines, all the same size and color. - 4Make the title a Heading 1. Click anywhere in the first line, Computer help at the library. On the Home tab, in the Styles box, click Heading 1.the line gets bigger and turns dark blue.
- 5Make two section headings. Click in the line Who it helps. Click Heading 2. Click in the line Steps. Click Heading 2.both lines turn dark blue. They are a little smaller than the title.
- 6Select the three steps. Point just before the C in Choose one task. Hold the left mouse button down. Drag to the end of home. Let go.the three step lines shaded gray: selected.
- 7Number the steps. On the Home tab, click Numbering: the button with 1, 2, 3 on it.1., 2. and 3. in front of the three steps.
- 8Check your headings. Click the View tab. Click the box next to Navigation Pane so it has a check mark.a panel on the left that lists Computer help at the library, Who it helps and Steps.
- 9Save: open the Save As box. Click File at the top left. Click Save As, then click Browse.a box titled Save As.
- 10Make your Resource pack folder. On the left side of the box, click Documents. Click New folder near the top. Type Resource pack and press Enter.a new folder named Resource pack.
- 11Open the folder. Double-click Resource pack.the top of the box ends in Resource pack. The folder is empty.
- 12Name it and save. Click in the File name box. Press Ctrl and A together to highlight the old name. Type Computer help handout. Click Save.Computer help handout at the very top of the window.
IF YOU GET STUCK
A box asks you to sign in? Close it with the X. You do not need an account tonight.
Made a typing mistake? Press Backspace to erase the letter before the blinking line.
A heading is missing from the Navigation Pane? Click in that line, then click Heading 1 or Heading 2 on the Home tab.
CHECK YOURSELF
Bold text looks like a heading. What proves it is a real heading?
A. It is bigger than the other lines · B. It is blue · C. It shows in the Navigation Pane
My answer:
Save your handout as a PDF
- 1Open the Save As box again. Click File at the top left. Click Save As, then click Browse.the Save As box. It opens in your Resource pack folder.
- 2Choose PDF. Click the Save as type box, just under File name. In the list, click PDF (*.pdf).Save as type now says PDF (*.pdf).
- 3Save the PDF. Check that Open file after publishing has a check mark. If not, click its box. Click Save.your handout opens as a PDF in Microsoft Edge.
- 4Check your PDF. Look at the PDF. Find the three blue headings and the numbers 1, 2 and 3.the same headings and numbers you made in Word.
IF YOU GET STUCK
The Save As box is not in Resource pack? Click Documents on the left, then double-click Resource pack.
Cannot find PDF in the list? Click the Save as type box. PDF is about halfway down the list.
CHECK YOURSELF
You email your handout as a PDF. What will your neighbor see?
A. A blank page without Word · B. Your same headings and layout · C. Plain text, no headings
My answer:
Add costs with a total that updates
- 1Open Excel. Press the Windows key on your keyboard. (Or click Start at the bottom left.) Type Excel and press Enter.the Excel start screen, with a Blank workbook tile.
- 2Start a blank workbook. Click Blank workbook.a grid of empty boxes called cells. The cell A1 has a green border.
- 3Type the labels. Click cell A1. Type Item and press Tab. Type Cost in dollars and press Enter.Item in A1 and Cost in dollars in B1.
- 4Type the supplies. In A2 type Paper, press Tab, type 12, press Enter. Do the same for Folders and 8, then Pens and 5.Paper 12, Folders 8 and Pens 5 in rows 2, 3 and 4.
- 5Add the total. Click A5. Type Total and press Tab. In B5, type =SUM(B2:B4) and press Enter.B5 shows 25.
- 6Look at the formula. Click cell B5. Look at the long box above the column letters: the formula bar.the cell shows 25. The formula bar shows =SUM(B2:B4).
- 7Predict. 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.your guess, ready to check.
- 8Change one cost. Click cell B2. Type 15 and press Enter.B5 changes to 28 by itself. Was your guess right?
- 9Save: open the Save As box. Click File at the top left. Click Save As, then click Browse.a box titled Save As.
- 10Open your Resource pack folder. On the left side of the box, click Documents. Double-click Resource pack.the top of the box ends in Resource pack.
- 11Name it and save. Click in the File name box. Press Ctrl and A together to highlight the old name. Type Supply list. Click Save.Supply list at the very top of the window.
IF YOU GET STUCK
B5 shows the letters you typed? It must start with =. Click B5 and type =SUM(B2:B4) again.
Typed in the wrong cell? Click that cell and press Delete, then type in the right cell.
CHECK YOURSELF
B5 has =SUM(B2:B4) and shows 28. You change Pens from 5 to 7. What will B5 show?
A. 28, because the total stays the same · B. 30 · C. 35
My answer:
Use a photo the right way
Download the practice photo Its permission: you may use and crop it if you give this credit: Photo: VUB practice photo, used with permission.
- 1Download the practice photo. Click Microsoft Edge on the taskbar. Click the Week 3 · Worksheet tab. Scroll to Part 4. Click Download the practice photo.practice-photo.jpg at the top right.
- 2Open PowerPoint. Press the Windows key on your keyboard. (Or click Start at the bottom left.) Type PowerPoint and press Enter.the PowerPoint start screen, with a Blank Presentation tile.
- 3Start a blank presentation. Click Blank Presentation.one white slide with two boxes: Click to add title and Click to add subtitle.
- 4Pick a theme. Click the Design tab. Click any theme you like in the Themes row.your slide changes color and style.
- 5Type the title. Click Click to add title. Type Need computer help?your title on the slide.
- 6Type the photo credit. Click Click to add subtitle. Type Photo: VUB practice photo, used with permission.the credit line under the title.
- 7Insert the photo. Click the Insert tab. Click Pictures, then click This Device.a box titled Insert Picture.
- 8Choose the photo. On the left side of the box, click Downloads. Click practice-photo, then click Insert.the photo on your slide. If a Designer panel opens on the right, click the X at the top of that panel.
- 9Crop the photo. Click the photo. Click the Picture Format tab, then Crop. Drag a black mark on one side inward. Press Esc.that edge trimmed away.
- 10Make it fit. Drag a corner circle of the photo inward to shrink it. Drag the middle of the photo off your words.the title, the credit line and the photo, all in view.
- 11Save: open the Save As box. Click File at the top left. Click Save As, then click Browse.a box titled Save As.
- 12Open your Resource pack folder. On the left side of the box, click Documents. Double-click Resource pack.the top of the box ends in Resource pack.
- 13Name it and save. Click in the File name box. Press Ctrl and A together to highlight the old name. Type Flyer. Click Save.Flyer at the very top of the window.
IF YOU GET STUCK
A Designer panel opened on the right? Click the X at the top of that panel to close it.
No Picture Format tab? Click once on the photo. The tab appears only while the photo is selected.
No practice-photo in Downloads? In Edge, click Download the practice photo again.
CHECK YOURSELF
Why does the flyer have a photo credit line?
A. To fill empty space · B. PowerPoint needs a caption · C. The photo's permission asks for it
My answer:
Check your work
- 1Check your Resource pack. Click File Explorer (the yellow folder) on the taskbar. Click Documents, then double-click Resource pack.four files: the handout (Word and PDF), Supply list and Flyer.
Show your instructor:
- the Navigation Pane in Word listing your three headings
- your PDF
- B5 showing 28 and the formula bar showing =SUM(B2:B4)
- your flyer with the credit line