Page 142 - Computer - 6

C. Scratch 3

1. Create a project in Scratch 3 using the given blocks. Each block must be used in the project.
You can use a block more than once.

2. Create a game for moving the cat and changing its colour. Use three variables – Xpos, Ypos, and Colour.
Ask the user to enter values for the three variables, using suitable statements. The sprite should glide
to the entered x and y position, and change its colour to the entered value after stopping.
D. Excel 2019
1. Create an order form to place order for books.
A sample has been given for reference.
Format the worksheet as shown in the image.
Calculate the Amount for each book and the
total bill value also.
2. Create the worksheet as shown in the image
to display the Census data of India for the
year 2011.

Perform the following operations on the worksheet data:
(a) Calculate the Population Density for each state.
(Hint: Population Density = Population/Area).
(b) Calculate the average, maximum, and minimum of population, area, sex ratio, literacy rate, and
population density for the states.
E. Python
1. Write a program to accept three numbers from the user and display the sum and product of the
three numbers.
2. Write a program to accept a number and display its first five multiples in five separate lines.

140