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)
   3   4   5   6   7   8   9   10   11   12   13