Page 8 - ModularV1.1 _c6_flipbook
P. 8

CONTENTS





                  01   Types of Software                                                                             7
                       q  Software                       q  System Software               q  Application Software

                  02   Advanced Features of Windows 7                                                               14
                       q  Understanding Windows Explorer   q   Different Views of Files and Folders
                       q  Searching of Files or Folders   q  Control Panel
                       Periodic Assessment-1                                                                        22
                   è
                  03   Introduction to MS Excel 2010                                                                23
                       q  Starting MS Excel 2010         q   Components of MS Excel 2010
                       q  Creating a New Workbook        q  Entering Data in a Worksheet
                       q  Types of Data in MS Excel
                  04   Editing in MS Excel                                                                          28

                       q  Selecting Cells in a Worksheet   q   Copying/Moving Data        q  Using Undo and Redo Features

                       q   Column Width and Row Height   q   Inserting Rows/Columns       q   Merging Cells
                       q   Autofill                      q   Customise Worksheet Tab
                  05   Formulas and Functions                                                                       35
                       q   Using Formulas to Perform Calculation                          q   Order of Operation
                       q   Different Ways to Enter Formulas                               q   Understanding Cell Range
                       q   Cell Referencing in Formulas and Its Types                     q   Functions
                       Periodic Assessment-2                                                                        47
                   è
                       Test Sheet-1                                                                                 48
                   è
                  06   Excel as Database                                                                            50
                       q   Form in Excel                 q   Using Form in Excel          q   Sorting Data

                       q   Filtering Data                q   Conditional Formatting       q   Using Data Validation
                       q   Using Subtotal Command        q   Using Pivot Table
                  07   Charts in Excel                                                                              60
                       q   Components of a Chart         q   Types of Charts in MS Excel    q   Creating a Chart

                       q   Formatting a Chart
                       Periodic Assessment-3                                                                        67
                   è
                  08   Conditional and Looping Statements in BASIC-256                                              68

                       q   Conditional Statements        q   Looping                      q   For...Next Statement

                       q   Sample Programs using For...Next Statement                     q   While…END...WHILE Statement
                       q   Sample Programs using While…END...WHILE Statement              q   Infinite Loop
                  09   Services on Internet                                                                         76
                       q   Internet Services             q   Cyber Security               q   Cyber Crime
                       q   Hacking and Cracking
                       Periodic Assessment-4                                                                        85
                   è
                       Test Sheet-2                                                                                 86
                   è
                       Project Work                                                                                 88
                   è
                       Explore More (Excel 2016)                                                                    91
                   è
                       OGO Cyber Sample Questions                                                                   93
                   è
                       Keyboard Shortcuts (MS Excel)                                                                95
                   è
                       Glossary                                                                                     96
                   è

                                                                  (vi)
   3   4   5   6   7   8   9   10   11   12   13