A black-and-white picture from 0s and 1s in a spreadsheet
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. In a spreadsheet pixel picture, which rule colours the cells?
2. You type 1 0 1 0 1 into five cells in a row. What will the row look like after the rule is applied?
3. What does each cell in the grid stand for?
4. A cell holds the digit 0. What colour does the rule fill it?
5. You want to turn one black pixel white. What is the quickest fix?
B
Match the Pairs
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 11 = black | AAll the digits are crammed into one cell. Each pixel needs its own cell, so only one cell can be coloured. | |
| 20 = white | B0 1 1 1 0 | |
| 3A row of five pixels is typed into five cells as 0s and 1s, ready for the colour rules to turn it into a picture | CThe rule uses the wrong colour. 1 should be black, not white, so the 1s would blend into the white 0s and the picture would not show. | |
| 4Changing one digit in a cell, such as typing 0 over a 1, turns exactly one pixel from black to white | D1 → 0 | |
| 5Rule: cells equal to 1 are filled white | EA rule that fills every cell holding a 1 with black | |
| 6Row typed as: 0,1,1,1,0 in one cell | FA rule that fills every cell holding a 0 with white |
C
Definitions
1 = black, 0 = white
D
Fill in the Blanks
Complete each line of code by filling in the missing parts.
1.
Rule 1: if the cell is _, fill it black
2.
Rule 2: if the cell is 0, fill it _____
3.
Picture: black, black, white
Row 1 code: 1, 1, _
4.
To turn pixel B1 from black to white:
change B1 from 1 to _
5.
Rule: if cell value _ 1, fill black
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
A1: 1
B
B1: 0
C
Rule: if 1, fill white
D
Rule: if 0, fill white
Question 2
A
Row 1: 1 1 1
B
Row 2: 1 0 1
C
Row 3: 1 1 1
D
Rule: if 0, fill black
Question 3
A
Goal: black row, white row
B
Row 1: 1 1 1 1 1
C
Row 2: 0 0 1 0 0
D
Rule: 1 black, 0 white
Question 4
A
Goal: black pixel in centre
B
Row: 0 1 0 0 0
C
Rule: 1 black, 0 white
Question 5
A
Select the grid A1:E5
B
Rule 1: 2 = black
C
Rule 2: 0 = white
Answer Key
A black-and-white picture from 0s and 1s in a spreadsheet
Section A: Quick Questions
Q1
A — 1 = black, 0 = white
Q2
A — black, white, black, white, black
Q3
A — One pixel of the picture
Q4
B — White
Q5
B — Change that cell's 1 to a 0
Section B: Match the Pairs
Q1
1 = black → A rule that fills every cell holding a 1 with black
Q2
0 = white → A rule that fills every cell holding a 0 with white
Q3
A row of five pixels is typed into five cells as 0s and 1s, ready for the colour rules to turn it into a picture → 0 1 1 1 0
Q4
Changing one digit in a cell, such as typing 0 over a 1, turns exactly one pixel from black to white → 1 → 0
Q5
Rule: cells equal to 1 are filled white → The rule uses the wrong colour. 1 should be black, not white, so the 1s would blend into the white 0s and the picture would not show.
Q6
Row typed as: 0,1,1,1,0 in one cell → All the digits are crammed into one cell. Each pixel needs its own cell, so only one cell can be coloured.
Section C: Definitions
Q1
1 = black, 0 = white — A rule for a grid of cells: type 0s and 1s, then fill each 1 black and each 0 white so the code shows as a picture. Change one digit to change one pixel.Section D: Fill in the Blanks
Q1
Rule 1: if the cell is 1, fill it blackQ2
Rule 2: if the cell is 0, fill it whiteQ3
Picture: black, black, white
Row 1 code: 1, 1, 0Q4
To turn pixel B1 from black to white:
change B1 from 1 to 0Q5
Rule: if cell value = 1, fill blackSection E: Spot the Error
Q1
C — In this code 1 means black. The rule should be 'Rule: if 1, fill black'. White is used for 0.
Q2
D — A 0 must be filled white. If 0s were black too, the whole grid would be black and the picture would disappear. It should be 'Rule: if 0, fill white'.
Q3
C — The goal says row 2 is all white, so every digit in it must be 0. The 1 would make a black pixel. It should be 'Row 2: 0 0 0 0 0'.
Q4
B — The black pixel should be in the centre, so the 1 goes in the middle (third) cell. Here it is in the second cell. It should be 'Row: 0 0 1 0 0'.
Q5
B — A black-and-white picture uses only the digits 0 and 1. The black rule should look for 1, not 2. It should be 'Rule 1: 1 = black'.