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