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

