Skip to content

4. Add Color to Your Digital Footprint

Playback Speed:
Transcript

In the last two videos, you made a list of online actions that leave behind information about you.

In this video, you will indicate which actions you take online. You will add your own column to the spreadsheet and an x for every action you take online. Then, you’ll add conditional formatting to visually show your digital footprint.

To begin, at your own computer, add your name to a column in the spreadsheet. Bold the text.

Next, read through your list of online actions. If the action is something you have done or might do online, place an X in that row.

Once you have marked all of the things that you do online, add conditional formatting so you can clearly see your online activities.

Conditional formatting changes the color of spreadsheet cells if they meet certain conditions, such as containing a particular word or number.

To add a conditional formatting rule, select your own column in the sheet.

Then, in conditional formatting, add a rule that tells Google Sheets to format the cell if the text contains an X.

Choose a color that reflects your personality and is different from your group members.

Great job! Now the actions you take online appear in your spreadsheet in the color you selected. You have a picture of your digital footprint!

Now, it’s your turn: Create a column with your name as the header, Indicate your online actions, and Use conditional formatting to add color and paint a picture of your digital footprint.

Next
Instructions
  1. Create a column with your name as the header.
  2. Indicate you online actions.
  3. Use conditional formatting to add color and paint a picture of your digital footprint.