In the last two videos, you made a list of online actions that leave behind informationabout you.
In this video, you will indicate which actions you take online. You will add your owncolumn to the spreadsheet and an x for every action you take online. Then, you’lladd 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 ormight 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 certainconditions, 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 cellif 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 youselected. 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 andpaint a picture of your digital footprint.