Scratch and Spreadsheet Basics | Quizalize

My Classes
Find resources
My Library
Create

Loading...

Scratch and Spreadsheet Basics | Quizalize

Loading...

Loading...

Loading...

Loading...

placeholder image to represent content

Scratch and Spreadsheet Basics

Quiz by Paul

Customize this quiz to suit your class

Instantly translate to 100+ languages

Measure skills

from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

Give this quiz to my class

as a classroom game

as homework

as an exam

as a printed PDF

Q 1/14
Score 0
In Scratch, what is a variable used for?
30
To create an object
To store and change data
To draw shapes
To make sounds
Q 2/14
Score 0
What does a sequence of commands in Scratch do?
30
It changes the background color
It creates a new sprite
It determines the order in which actions are performed
It adds sound effects

14 questions

Q.

In Scratch, what is a variable used for?

1

30 sec

Q.

What does a sequence of commands in Scratch do?

2

30 sec

Q.

In Scratch, how do you create a new variable?

3

30 sec

Q.

What is the purpose of the 'when green flag clicked' block in Scratch?

4

30 sec

Q.

How can you change the value of a variable during a Scratch project?

5

30 sec

Q.

What happens when you use the 'broadcast' block in Scratch?

6

30 sec

Q.

What is a loop in Scratch used for?

7

30 sec

Q.

Which block would you use to change a sprite's position in Scratch?

8

30 sec

Q.

How can you see the value of a variable while your Scratch project is running?

9

30 sec

Q.

Which formula correctly multiplies the values in cells C1 and C2?

10

30 sec

Q.

What formula would you use to subtract the value in cell D1 from the value in cell D2?

11

30 sec

Q.

Which formula will display the maximum value from the range E1 to E10?

12

30 sec

Q.

What formula would you use to calculate the total of cells A1, A2, and A3 in a spreadsheet?

13

30 sec

Q.

If you want to find the average of numbers in cells B1 to B5, which formula should you use?

14

30 sec

Related quizzes

Revision session on spreadsheet functions and scratch programming
Spreadsheets and Scratch 6
Spreadsheets and Scratch 2
Spreadsheets and Scratch 4
Spreadsheets and Scratch 3
Spreadsheets and Scratch 5
The following days are a jumble of gunfire, digging, gobbled food, soldiers running in and out of the forest in small groups, distant explosions, stray shells, bandaged heads and unexpected lulls. On the very first day, before dawn, I am ordered into one of the newly dug trenches. I huddle there, squeezing my magic buttons and singing songs to the dog. When the fighting stops, the dog disappears, but a new companion takes his place. A strange little soldier crawls along the trench toward me. ‘Private Sasha!’ he cries. ‘I’ve been looking for you all day long!’ He’s old, like a grandfather, a dedushka. He has a black patch over one eye, a tape measure around his neck and a row of pins threaded into his sleeve. Hanging from his belt is the most enormous pair of scissors I have ever seen and I wonder if he uses them as a weapon. He doesn’t tell me his name, so in my head he becomes Dedushka. Dedushka squats, cups his hand to his ear, peers over the top of the trench and smiles. ‘It’s safe to be upright . . . for now.’ He helps me to my feet, dusts me off and commands me to stand as tall and straight as I can. Then he measures me. Everything from head to toe – even my toes! He writes numbers in a little notebook, strings his tape measure back around his neck, salutes and hurries away. It’s all very strange, and I wonder if Dedushka has been bumped on the head during the battle and is now a little bit muddled. I should have given him a hug before he left. I chase after him but stop when I’m hit by a shovelful of flying dirt. Sleepy Bear is digging a cave! ‘Are you going to hibernate?’ I ask. Sleepy Bear chuckles. ‘No, although that would be wonderful! I could do with a lo-o-o-ong sleep.’ He sighs and closes his eyes. He doesn’t open them again and I realise that he has gone to sleep. Standing up! I shake his arm, and he opens his eyes and keeps talking. ‘No, I’m not hibernating. I’m digging a little nook where I can sleep and eat. I’ll hang up my raincape as a door that can open and close so it feels just like a real home . . . except for the lice . . . and the bad smells . . . and the bombs that make the walls shake and crumble.’ He points further along the trench to where other soldiers are digging. ‘We’re all making little houses in the ground.’ ‘Like rabbits and moles,’ I say. Sleepy Bear chuckles. ‘Yes! And soldiers who need to hide from German bullets and bombs.’ He stops digging to roll a cigarette. ‘Should I be making a house?’ I ask. ‘I want to hide from German bullets and bombs, too.’ Sleepy Bear flops to the ground, lights his cigarette, closes his eyes and takes a deep puff. I wait for him to answer, but, instead, he begins to snore! I poke him in the side. He snorts and he murmurs, ‘I think someone has already built you a house, Sasha. Keep going along this beautiful village street and you are sure to find it.’ He falls asleep once more. I kiss his dusty cheek and whisper, ‘Thank you, Sleepy Bear.’ A little way along, I see Cook in a cloud of smoke. He has lit a fire, right here in the middle of the trench, and is stirring a cauldron full of kasha. He squats as he stirs. ‘What are you doing?’ I ask. ‘Cooking supper, of course!’ he cries. ‘But why are you doing it here?’ Cook points his spoon at the ground above the trenches. ‘Because if I do it up there, my pot will be filled with holes from German bullets and all of the kasha will leak out onto the ground. It’s bad enough that our supplies can’t get through German lines and there’s nothing to cook but buckwheat for kasha. But if we lost the kasha, too . . .’ ‘Hungry soldiers,’ I say. Cook nods. ‘And grumpy!’ ‘Like Boris!’ I gasp. ‘Even worse,’ warns Cook. I picture the kasha pot full of bullet holes. And then I realise that if the kasha pot were full of holes, then Cook would be, too. I wrap my arms around Cook’s neck and say, ‘I think this is a very good place for cooking our supper.’ I kiss his smoky cheek and run along. At the end of the trench, I find the biggest hole of all. It’s wide and deep and as busy as a beehive in a blossom tree. Above, a group of soldiers is rolling logs into place for a roof, while below, typewriters rattle and pencils scratch and papers flutter and voices crackle out of five different radios. Their words tangle together to tell a strange wartime fairy tale about German guns and a loving father called Stalin and a Red Army regiment that is lost in the deep, dark forest and a wicked beast called Hitler and a delivery of vegetables that was hit by a bomb and blown into a million tiny pieces too small even to make soup. In the middle of it all, wrestling with a rumpled map, his rifle still slung over his shoulder, is Major Scruff. ‘Major Scruff!’ I run and jump into his arms. ‘Is this our new home?’ ‘Yes, Sasha. I suppose it is.’ ‘Is it safe from German bullets and bombs?’ I ask. He stares at me. ‘Were you scared in the trenches today, Sasha?’ ‘No,’ I reply. ‘I had magic buttons and a dog and some songs to sing. Were you scared in the forest, Major Scruff?’ ‘Yes,’ he says. ‘Poor Major Scruff!’ I press my hand against his cheek. The dark, rough stubble is grubby with grit and his eyelids are taking a long time to open after every blink. ‘You need a shave and a nap!’ I scold. He chuckles. ‘I am too tired to shave and too busy to nap.’ I scrunch my nose while I consider his problem. ‘I know!’ I cry. ‘You nap and I will shave your whiskers. That will be two jobs tumbled into one!’ And so that’s what we do. Major Scruff slumps into a chair and snoozes while I lather his face with soapy water and shave his whiskers. The soap suds travel from his face, up into his hair and down the front of his uniform, and I have to shave his jaw and chin three times because I keep missing bits, but I finally get it all done. I am just wiping his cheeks dry when the dog appears. He licks my hand, then stretches up and licks soap suds from Major Scruff’s ear. Major Scruff wakes with a start. He feels his newly shaved face and cries, ‘Wonderful, Sasha! I feel smooth, clean, rested and ready for action.’ He ruffles my hair. ‘We must do this again tomorrow. Although next time, you might wake me with a gentle shake of the shoulder instead of licking my ear.’
Scratch loops and variables