Page 8 - modular4.0
P. 8
Contents
Digital & Cyber World
01 Types of Software 7
Software System Software Application Software
02 Advanced Features of Windows 10 15
Understanding File Explorer Different Views of Files and Folders Searching of Files or Folders
Control Panel
Worksheet 1 25
03 Introduction to Excel 2019 26
Starting Excel 2019 Components of Excel 2019 Creating a New Workbook
Entering Data in a Worksheet Saving a Workbook Data Types in Excel 2019
04 Editing in Excel 2019 33
Selecting Cells in a Worksheet Copying/Moving Data Using Undo and Redo Features
Column Width and Row Height Inserting Rows/Columns Merging Cells
AutoFill Customise Worksheet Tab
05 Formulas and Functions 42
Using Formulas to Perform Calculation Order of Operation Different Ways to Enter Formulas
Understanding Cell Range Cell Referencing in Formulas and its Types
Functions
Worksheet 2 55
Test Sheet 1 56
06 Excel as Database 58
Form in Excel Using Form in Excel Sorting Data
Filtering Data Conditional Formatting Using Data Validation
Using Subtotal Command Using Pivot Table
07 Charts in Excel 72
Creating a Chart Components of a Chart Types of Charts in Excel 2019
Formatting a Chart
Worksheet 3 80
08 Services on Internet 81
Internet Services Cyber Security Cyber Crime
Coding World
09 Conditional Statements in Python 94
Decision Making Statements The if Statement The if…else Statement
Nested if Statement The if…elif…else Ladder
Worksheet 4 106
Test Sheet 2 107
Artificial Intelligence
The AI Corner! (AI-Enabled Devices) 109
Project Work 113
Explore More (Excel 2021) 116
OGO Cyber Sample Questions 118
Keyboard Shortcuts (Excel 2019) 119
Glossary 120
(vi)

