Y5 Spreadsheets: Pixel art 2 – conditional formatting

Apr 262023
 
  1. Go to Google Drive
  2. Open the spreadsheet from last week
  3. Scroll down to a clear area
  4. Highlight a whole rectangle for your picture
    • Put a border around it
  5. Whith the area still selected:
    • Click on “Format” – “Conditional formatting”
    • Select the range
    • “Text contains”
    • Type in “r” (for red)
    • Change the fill colour to red
  6. Repeat for “b” (for blue)
  7. Make a Union Jack flag by typing “r” and “b” in the cells

Y5 LF: Edit a spreadsheet in Google Sheets

May 182022
 
  • Go to https://www.ilearn2.co.uk/signin-html/
  • Enter the code on the whiteboard
  • Watch the videos (for Chromebooks/Googe Sheets)
  • Follow the instructions
    • Activity 1 Pixelart
    • Activity 2 Tour de France project
  • At the end of the lesson: Fill out the “How did that go?” form