Page 143 - Computer Genius Class 07
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  ormatting on the  asis o   ar s.
                       Sort the data o  ‘class’ in ascending order.
                        reate a  orm to enter a ne  record.



                   MakeCode Arcade                                                         Critical Thinking
                                                                                           Technology Literacy
                 B.  Eat and level up
                      reate a game  ith t o sprites  one  ill  e a  layer sprite  second  ill  e  herry sprite.
                     Objective of the game:

                          o e your sprite around the screen and eat as much cherry as you can  e ore the time runs out
                          ery time you eat the cherry  points are added  and the timer is restored.
                          ou  ill  e gi en time o  1  seconds  and you ha e to eat all the cherry  i  you  ail to do so
                        your game  ill  e o er.

                     Code:















                                                                                       Practical Assessment   141
   138   139   140   141   142   143   144   145   146   147   148