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
   138   139   140   141   142   143   144   145   146   147   148