Class 5 MOY Assessment CCS
Name: .............................................. Date: .......................... Max. Marks: 40 Time: 60 min.
Instructions :
Write your name and date on the question paper.
Read the questions carefully and attempt all questions.
Write the answers in the space provided in the question paper.
Choose the correct option.
1) What is sorting in a spreadsheet? (1 mark)
(i) Arranging data in a specific order (ii) Highlighting cells with different colours
(iii) Creating graphs and charts (iv) Deleting unnecessary rows
2) Which initial action should be taken when editing a recorded video using Windows (1 mark)
Movie Maker?
(i) Trim (ii) Export Files (iii) Add videos and photos (iv) Create New Project
3) Which of the following options refers to different types of spreadsheet software? (1 mark)
(i) Microsoft Word and Google Docs (ii) Adobe Photoshop and Illustrator
(iii) Microsoft Excel and LibreOffice Calc (iv) Windows Media Player and VLC Player
4) What is the initial step to create a Gmail account? (1 mark)
(i) Compose an email (ii) Log in to Gmail
(iii) Create a YouTube account (iv) Open the Gmail website in the browser
Answer the following.
5) Fill in the blanks using the words from the help box.
appearance Forever Ctrl + Space Events
a) The _______________________________ blocks represent the action after which the script (1 mark)
starts working.
b) The _______________________________ block repeats the loop until the Stop button is (1 mark)
clicked.
c) In Scratch, the Looks blocks represent the _______________________________ of a sprite (1 mark)
and a backdrop.
d) The shortcut key to select a column using a keyboard is (1 mark)
_______________________________.
Page 1 of 6
Answer the following.
6) Match the following. (4 marks)
Column A Column B
(i) Sends a message to all the scripts
(a) Pivot Table
of the project
(b) LibreOffice Impress (ii) stores a value
(c) Broadcast Block (iii) creates a presentation
(d) Variable (iv) Analyses data
Answer the following.
7) Write the category of each of the following blocks. (4 marks)
Page 2 of 6
Answer the following.
8) Observe the given code and answer the following question. (1 mark)
What will happen if ‘Marks’ is 79?
9) What is the use of Operators blocks in Scratch ? (1 mark)
Answer the following.
10) a) What will happen if the user presses the space bar key? (1 mark)
b) Identify the error in the function given below and rewrite it to find the average of (1 mark)
the numbers in cells A1, A2, and A3.
=Sum(A1+A3)
Page 3 of 6
c) Identify the variable in the code block given below. (1 mark)
d) Which Screen recording option is used to start the recording in ShareX ? (1 mark)
Answer the following.
11) The given script must display a message only when the user collects 60 coins. Identify (2 marks)
the errors in the script and provide solutions.
12) The following script is written to find the addition of 6 and 3 when the space bar key is (2 marks)
pressed. Identify the errors in the following code snippet and provide solutions.
Page 4 of 6
Answer the following.
13) What are the basic requirements to create a game in Scratch ? (3 marks)
14) Write an algorithm to get two numbers as input from the user and find their (3 marks)
multiplication.
Answer the following.
15) Represent the following data in tabular form: (4 marks)
Student J participates in 3 extracurricular activities and has an attendance of 92%.
Student K participates in 2 extracurricular activities and has an attendance of 85%.
Student L participates in 1 extracurricular activity and has an attendance of 78%.
Attendance sheet
Student Extracurricular Activities Attendance
Page 5 of 6
16) Number the given blocks from 1 to 4 to arrange them in the correct sequence to find (4 marks)
the difference between two numbers.
Page 6 of 6
