Page 8 - TP_Modular_V2.1_Class7
P. 8
Contents
Digital & Cyber World
01 Types of Software 7
Software System Software Application Software
Difference between System Software and Application Software
02 Advanced Features of Windows 10 16
Understanding File Explorer Different Views of Files and Folders Searching of Files or Folders
Control Panel
Worksheet 1 25
03 Introduction to Excel 2016 26
Starting Excel 2016 Components of Excel 2016 Window Creating a New Workbook
Entering Data in a Worksheet Saving a Workbook Data Types in Excel 2016
04 Editing in Excel 2016 32
Selecting Cells in a Worksheet Copying/Moving Data Using Undo and Redo Features
Column Width and Row Height Inserting Rows/Columns Merging Cells
Auto Fill Customise Worksheet Tab
05 Formulas and Functions 41
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 53
Test Sheet 1 54
06 Excel as Database 56
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 67
Components of a Chart Types of Charts in Excel 2016 Creating a Chart
Formatting a Chart
Worksheet 3 76
08 Services on Internet 77
Internet Services Cyber Security Cyber Crime
Coding World
09 Conditional Statements in Python 89
Decision Making Statements The if Statement The if…else Statement
Nested if Statement The if…elif…else Ladder
Artificial Intelligence
The AI Corner! (AI-Enabled Devices) 102
Worksheet 4 106
Test Sheet 2 107
Project Work 109
Explore More (Excel 2019) 112
OGO Cyber Sample Questions 114
Keyboard Shortcuts (Excel 2016) 115
Glossary 116
(vi)

