Digital Literacy Exercises Checklist: Home

Excel Exercise Introduction:

To become familiar with using Microsoft Excel you will have to practice. This tab has several exercises you can complete as many times as you need until you can create a correct example. Repeat these exercises as many times as you need.

___________________________________________________________________

EXERCISE ONE;  The Pet Name Roster

Here is the text you will need:

Pet Name Roster (file name)
Cats: Snowball, Kitty, Tiger
Dogs: Buddy, Rover, Spot
Birds: Tweedy, Nightengale, Birdy

Example: Cell Name and Column header

Example: Cell with text and how the text shows up in the Formula bar.

Instructions:

1) Create a new Excel spreadsheet
2) Create three column headers for Cats, Dogs, and Birds.
3) Input the correct names below the column headers, that is three rows below the headers.
4) Highlight, the header by clicking and dragging across the three cells. then change the fill to a grey or black background.
5) Change the font a white color
6) Save file (CTRL -S)  File name: Speech.xlsx.  XLSX is the file type for Microsoft Excel

On your keyboard!

SKILLS LEARNED:

1. Open New Excel file  (CTRL - N)
2. Input date into cells
3. Highlighting a group of cells
4. Changing cell background color
5. Change font color.                                                                                                                                             

 ______________________________________________________________________      

EXERCISE TWO:: Calculating Numbers in Excel

Here is the text you will need:

x

Instructions:

1) x

SKILLS LEARNED:

1. x                                                                                                                                           

 ______________________________________________________________________      

Text Exercise Introduction:

To become familiar with using Text and MS Word you will have to practice. This tab has several exercises you can complete and or repeat as many times as you need. Repeat these exercises as many times as you need. 

___________________________________________________________________

EXERCISE ONE; The Digital Literacy Quote

Here is the text you will need: 

The greatest trick ever played on higher education was the belief that students did not need technology training. Don Michael Jr., 2019

Instructions:

1) Copy the text quote and paste it in a new Word document (CTLR - C and CTLR - V)
2) Format this line of text so that it breaks up into four lines
3) Use the Georgia font and two text sizes, i.e., 28 points and 14 points
4) Indicate the person who made the quote and the year they quoted it.
5) Select all (CTLR - A) and 'center' all text.            

On your keyboard!

SKILLS LEARNED:

1. Opening a new MS Word document
2. Copy and pasting text into Word file
3. Formatting text on 4-5 lines
4. Centering text block
5. Highlighting or selecting all (CTLR - A) text
6. Changing font to Georgia and the font size to 28 points and the author's name to 12 points       
7.                                                                                                                                

 ______________________________________________________________________       

Picture Exercise Introduction:

To become familiar with using pictures, or images, you will have to practice. This tab has several exercises you can complete and or repeat as many times as you need. Repeat these exercises as many times as you need. 

 ______________________________________________________________________      

EXERCISE ONE: Copying Li'l Bub the Cat

Here is the photograph and text you will need:

Here is a photograph of Li'l Bub the cat (right click over photo and select Copy Image)

Background (copy this text also)
Lil Bub was the runt of her litter born to a feral mother. She was born with several genetic mutations, had to be bottle-fed, and had difficulty being adopted. Lil Bub had an extreme form of feline dwarfism that caused her limbs and lower jaw to be quite small in comparison to the rest of her body. The shortened lower jaw meant that, among other things, she could not retain her tongue within her mouth. She also had extra toes. Her owner, Mike Bridavsky, adopted her when his friends asked him to give her a home. When Bridavsky first picked her up, he said "Hey, Bub!"  (Wikipedia)

Instructions:

1) Select the photograph by right clicking a waiting for a menu to pop up
2) In the menu select 'copy image or copy'
3) Open a new MS Word file
4) Click anywhere in the blank Word document and paste the image there (CTLR - V)
4) Also, copy and paste the 'background' text about Li'l Bub under the photograph  

On your keyboard!

SKILLS LEARNED:

1. Copying and pasting a photograph
2. Copying and pasting text                                                                                                                                  

 ______________________________________________________________________      

PowerPoint Exercise Introduction:

To become familiar with using pictures, or images, you will have to practice. This tab has several exercises you can complete and or repeat as many times as you need. Repeat these exercises as many times as you need. 

 ______________________________________________________________________      

EXERCISE ONE: Copying Presentation on Li'l Bub the Cat

Here is what you will need:

1. A photo of Li'l Bub the cat
2.     
3.  
4. Presentation Outline: (always start a presentation with an outline)
   1. Title Slide One:  Who Is Li'l Bub the Cat?
   2. Slide Two:  About Li'l Bub
      1. Lil Bub was the runt of her litter born to a feral mother.
      2. She was born with several genetic mutations, had to be bottle-fed,
      3. She had difficulty being adopted.
      4. She had an extreme form of feline dwarfism that caused her limbs and lower jaw to be quite small in comparison to the rest of her body. 
   3. Slide Three: More Fun Facts about Li'l Bub
      1. The shortened lower jaw meant that, among other things, she could not retain her tongue within her mouth.
      2. She also had extra toes.
      3. Mike Bridavsky adopted her when his friends asked him to give her a home.
      4. When Bridavsky first picked her up, he said "Hey, Bub!"  (Wikipedia)
   4. Slide Five: Contact
      1. your first and last name
      2. your email address
      3. Source: Wikimedia Foundation. (2025, March 31). Lil Bub. Wikipedia. https://en.wikipedia.org/wiki/Lil_Bubhttps://en.wi

Instructions: Create a four slide presentation

1) Open MS365 and create a new PowerPoint presentation (.PPT)
2) Select two column slide template
3) Create four slides (cover slide, slide 1, slide 2, and Contact).
4) Right click on the photo of Li'l bub and save this file.
5) In PowerPoint click on the image insert button. Insert the photo of Li'l bub.
6) Copy the slide text bullets in this assignment and paste in slide one and two.
7) Highlight the text and make the text size larger.
8) Make sure you name your PowerPoint file and locate it in your OneDrive.

Skills Learned:

1) Highlighting text or select all (CTRL + A)
1) Copying (CTRL + C)
1) Pasting (CTRL + V)
1) Duplicating slide thumbnail (select a thumbnail then CTRL + D)
1) Naming a file (field in upper left corner of window)
1) Start showing a presentation (F5)
1) Closing a presentation (ESC button)

THE STEPS

Step One: Open MS365 then select the 'apps' button to get to MS PowerPoint

Step Two: In the apps window open MS PowerPoint

Step Three: Open MS PowerPoint

Step Four: Locate the new slide button and add four new slides. Then locate the picture button.

Step Five: Name your PowerPoint file (suggestion: Cat Presentation.ppt)

Step Six: Create new slides. Choose the two-column template.                                                                                                                                                                                          

Step Seven: To add content select one of the icons. Select the image icon to add an image.

Step Eight: Here is the image icon.

Step Nine: Now find and select the image you want. Select open to import the image to the slide

Step Ten: The image will appear on the side your selected. Now copy the bullet list and paste that text in the other box.

Step Eleven: To change the text size, highlight all of the text. Now you can select the type size.

Step Twelve: Under the home tab all the type changing controls are there.

Step Thirteen: Each slide has a thumbnail

Step Fourteen: You duplicate any slide. Click on the slide you want to duplicate, and a color boarder will appear. Use CTRL+D to duplicate.

Step Fifteen: Don't forget to name your file in the upper right corner about 'File'. Scroll down to see all slide thumbnails.

Step Sixteen: Open MS PowerPoint

Example: Cell with text and how the text shows up in the Formula bar.

Instructions:

1) Open MS365 and create a new PowerPoint presentation (.PPT)
2) Create three column headers for Cats, Dogs, and Birds.

On your keyboard!

SKILLS LEARNED:

1. Location of PowerPoint in MS365 apps page
2. Creating a new presentation
3. Selecting a Slide Template or a blank presentation
4. Title slide creation with new photograph of Li'l Bub
5. New slide creation
6. Adding a slide 
7. Adding new bulleted text to each slide   
8. Reviewing page thumbnails                                                                                                             

 ______________________________________________________________________      

EXERCISE TWO:: Presenting Your PowerPoint Slides

Here is what you will need:

1. The Li'l Bub PowerPoint

Instructions:

Step One: Open your Li'l Bub PowerPoint Presentation

1) Open the Li'l Bub presentation
2) Select the 'Present' button
3) Use the up and down arrows to advance through your presentation.
4) When you reach the last slide and your are finished press the escape key

Step Two: You can also select the film screen icon at the bottom right of your window.

SKILLS LEARNED:

1. x                                                                                                                                           

 ______________________________________________________________________      

Desktop Exercise Introduction:

To become familiar with using pictures, or images, you will have to practice. This tab has several exercises you can complete and or repeat as many times as you need. Repeat these exercises as many times as you need. 

 ______________________________________________________________________      

EXERCISE ONE: Parts of the Desktop

When you log into MS365 (microsoft365.com) this desktop dashboard pops up. A dashboard has multiple items to select from, including applications and your OneDrive.

When you select the 'apps' button it opens up the Application pages (programs) expanding your range of choices.

Selecting the OneDrive button opens the OneDrive page to all the files you have created. On this page you can find your own files and separate them by the programs that created them. (File types: Word = .docx  Excel= ..xlsx  PowerPoint= .ppt, PDF= portable document file or .pdf)

You can filter or separate your files by the program that made them. In the search box you can search for any file using the file name.

Desktop Navigation

Trash Can               Star                          Two People         Blue Dot

Here is the photograph and text you will need:

On your keyboard!

SKILLS LEARNED:

1. x.                                                                                                                                             

 ______________________________________________________________________      

EXERCISE TWO:: MLA Style Bibliography

Here is the text you will need:

x

Instructions:

1) x

SKILLS LEARNED:

1. x                                                                                                                                           

 ______________________________________________________________________      

File Sharing Exercise Introduction:

To become familiar with using pictures, or images, you will have to practice. This tab has several exercises you can complete and or repeat as many times as you need. Repeat these exercises as many times as you need. 

 ______________________________________________________________________      

EXERCISE ONE: Opening One Drive

Step One and Two (after opening MS365 scroll down and select OneDrive.  In OneDrive select "My Files")

         

Step Three (look at the list of files generated by your search)



Here is the photograph and text you will need:
On your keyboard!

SKILLS LEARNED:

1. Opening MS365 dashboard (https://m365.cloud.microsoft/)
2. Opening Apps link to find OneDrive or scroll down to the bottom to find OneDrive
3. In OneDrive opening MyFiles link                                                                                                                                            

 ______________________________________________________________________      

EXERCISE TWO: Searching for files in MyFiles

Here is the text you will need:

Step One: In MyFiles input the name of the file in the search field, then select the magnifying class button.

Step Two: In MyFiles list of files, scroll up or down to locate your file and then select it open.

Instructions:

1) In the MyFiles window located the search field at the top.
2) In putting the name or names of file you want to open

SKILLS LEARNED:

1. Searching for files using the file search field.
2. Finding you file in the list of search files.

 ______________________________________________________________________