Page 8 - 2611_SmartGPT Pro V(5.0) C-5
P. 8
CONTENTS
Digital World
1 Photo Editor & Video Editor 7
Photos App OpenShot Video Editor
2 Excel 2021 21
Excel 2021 Uses of Excel 2021 Starting Excel 2021 Components of Excel 2021 Window
Creating a New Workbook Entering Data in the Worksheet Working with Worksheet Opening a Workbook
Saving a Workbook Closing a Workbook Exiting Excel 2021 Selecting a Range of Cells
Editing Cell Contents Undo and Redo Commands Deleting Cell Contents Deleting Cells, Rows Or Columns
Inserting Cells, Rows Or Columns Copying the Data Moving the Data Autofill
Changing the Column Width and Row Height
Periodic Assessment 1 44
3 Charts, Formulas & Functions in Excel 45
Understanding Cell Range Using Charts Types of Data in Excel Using Formulas to Perform Calculation
Order of Operation Cell Referencing in Formulas and Its Types References to Other Worksheets Functions
4 E-mail and Malware Safety 63
What is E-mail? E-mail Address Creating an E-mail Account Components of an E-mail Window
Using an E-mail Account Malware How can we Protect Our Computers? Antivirus Software
Periodic Assessment 2 79
Test Sheet 1 80
Computational Thinking & Coding World
5 Algorithm, Flowchart and Mind Maps 82
Algorithm Writing an Algorithm Flowchart Drawing a Flowchart Brainstorming Mind Maps
Computer Languages Language Translator
6 More on Scratch 96
Variables in Scratch Controlling the Movement of a Sprite Project: Chase the Starfish Game Creation
Adding a Backdrop to the Game Adding Text to the Game Create a Sprite for the Game
Adding One More Sprite Code the Wheel Sprite Code the Arrow1 Sprite Creating a Variable for the Game
Running the Game
Periodic Assessment 3 114
7 Creating Apps with MIT App Inventor 115
What are Apps? Features of Mobile Apps Types of Mobile Apps Categories of Apps App Inventor
Starting MIT App Inventor Types of UI Components Blocks Editor and Its Interface Creating an App
Testing Your App
Artificial Intelligence & Robotics
8 Evolution of Artificial Intelligence 134
Artificial Intelligence How Artificial Intelligence Evolved? From 2010 to Present
Periodic Assessment 4 143
Test Sheet 2 144
Project Work 146
(vi)
