Page 8 - Computer Genius Class 06
P. 8

CONTENTS                                                                          Scan
                                                                                                      For Animation



                 1   Safeguarding Your Computer                                                                    7
                       Cyber Crimes                    Protecting Your Computer from Illegal Access
                       Protecting Your Computer from a Computer Malware
                 2   Formulas and Functions in Excel                                                              21
                       Different Ways to Enter Formulas     Understanding Cell Range    Cell Referencing in Formulas and Its Types
                       Customise Worksheet Tab         Functions
                 3   Charts in Excel                                                                              38
                       Charts in Excel                 Sorting Data
                     Periodic Assessment 1                                                                        48
                 4   Advanced Features of PowerPoint 2016                                                         49
                       Slide Views                     Slide Transition        Animation
                       Uses of Media Clips and Action Buttons                  Importing Data from other Applications
                 5   Algorithm and Pseudocode                                                                     66
                       How Do Traffic Lights Work?       Coding in Computer Science
                       What is a Programming language?     About Syntax        Algorithm
                       Representation of an Algorithm      Flowchart           Pseudocode
                     Periodic Assessment 2                                                                        73

                     Test Sheet 1                                                                                 74
                 6   Using MakeCode Arcade                                                                        76
                       Starting MakeCode Arcade        Components of Makecode Arcade Window
                       Commonly Used Blocks            Adding a Sprite         Changing the Background
                       Getting started with Block Coding     Logical operators     Relational Operators
                       Nested Conditional Statements     Jump Statements
                 7   More on MakeCode Arcade                                                                      93
                       What are Variables?             Naming Variables        Performing Operations on Variables
                       What is Variable Initialization?      Data types in Programming    What is a Sequence?
                       Loop                            Apply Loops and Conditionals with Sequencing
                       What is a Bug?                  What is an Event?       What are Collections?
                 8   Types of Robots                                                                             109
                       Categories of Robots            Robots Vs Humans—Advantages and Disadvantages
                     Periodic Assessment 3                                                                       121
                 9   Exploring Maths with Coding                                                                 123
                       Multiplication of Two Numbers      Area of the Rectangle     Cost of Fencing for a Rectangular Farm
                 10  Plotting Graphs                                                                             129
                       Blocks to Draw Graphs           Line Graph in AI Connect    Vertical Bar Graph in AI Connect
                       Horizontal Bar Graph in AI Connect
                 11  AI in Real World                                                                            135
                       AI and Facial Detection         Face Mask Detection in AI Connect
                     Periodic Assessment 4                                                                       140

                     Test Sheet 2                                                                                141
                     Practical Assessment                                                                        143
                     Info Hub: Introduction to HTML                                                              146
                     OGO Cyber Sample Questions                                                                  151
   3   4   5   6   7   8   9   10   11   12   13