Page 143 - Computer_Genius_v2.1_C7_flipbook
P. 143
Practical Assessment
Productivity & Accountability
Excel Initiative
A. Create a worksheet in Excel 2016 and add the following data:
After entering the data, perform the following actions:
Apply conditional formatting on the basis of Marks.
Sort the data of ‘class’ in ascending order.
Create a form to enter a new record.
MakeCode Arcade Critical Thinking
Technology Literacy
B. Eat and level up
Create a game with two sprites, one will be a Player sprite, second will be Cherry sprite.
Objective of the game:
Move your sprite around the screen and eat as much cherry as you can before the time runs out!
Every time you eat the cherry, points are added, and the timer is restored.
You will be given time of 10 seconds, and you have to eat all the cherry, if you fail to do so,
your game will be over.
Code:
Practical Assessment 141

