Page 12 - IT_V1.0_Class10
P. 12

UNIT-2 ELECTRONIC SPREADSHEET (ADVANCED) USING LIBREOFFICE CALC                                  143–203
              Chapter 4: Analyse Data Using Scenarios and Goal Seek                                                 143
                 Consolidating Data                                 Group and Outline
                 Subtotals                                          What-If Scenarios
                 What-If Analysis                                   Goal Seek
                 Solver                                             Difference Between Goal Seek and Solver
              Chapter 5: Using Macros in Spreadsheet                                                                159
                 Macro                                              Sorting Columns Using Macro

              Chapter 6: Linking Spreadsheet Data                                                                   175
                 Link Data and Spreadsheets                         Cell Reference              Hyperlink
              Chapter 7: Share and Review a Spreadsheet                                                             191
                 Sharing a Spreadsheet                              Recording Changes
                 Add, Edit and Format Comment                       Reviewing Changes
                 Comparing Versions of a Document                   Merging Versions
              UNIT-3 DATABASE MANAGEMENT SYSTEM USING LIBREOFFICE BASE                                         204–276
              Chapter 8: Introduction to Database Management System                                                 204
                 Database                                           Database Management System (DBMS)
                 Data Model                                         Elements of Database
                 Relational Database Management System (RDBMS)      Key Field
                 Database Objects
              Chapter 9: Starting with LibreOffice Base                                                             216
                 Data Type                                          Starting LibreOffice Base
                 Closing the Database and Quitting From LibreOffice     Open an Existing Database
                 Creating a Table                                   Inserting Data in a Table
                 Editing Data in a Table
              Chapter 10: Working with Multiple Tables                                                              232
                 Editing and Deleting Tables                        Relationship
              Chapter 11: Queries in Base                                                                           243
                 Query
              Chapter 12: Forms and Reports                                                                         254
                 Forms                                              Report
              UNIT-4 MAINTAIN HEALTHY, SAFE AND SECURE WORKING ENVIRONMENT                                     277–310
              Chapter 13: Health, Safety and Security at Workplace                                                  277
                 Introduction to Health, Safety, and Security at Workplace     Policies and Procedures for Health, Safety, and Security
                 Workplace Safety Hazards                           Case Studies of Hazards/Accident Due to Avoidable Situations
              Chapter 14: Workplace Quality Measures                                                                286
                 Air and Water Quality Monitoring Process           Office Ergonomics
                 Occupational Overuse Syndrome                      Health and Safety Requirements for Computer Workplace
                 Cautions While Working on the Computer
              Chapter 15: Prevent Accidents and Emergencies                                                         297
                 Accidents and Emergencies                          Fire Hazard in the Workplace
                 Electrical Shocks and its Effects                  Healthy Living

                   C
               Part  Practical Work & Part  D  Project Work
              Practical Work                                                                                    311–315
              Viva Voce Questions                                                                               316–317
              Project Work                                                                                      318–319
              CBSE Sample Question Paper                                                                       320–323
              Glossary                                                                                             324

                                                                 (x)
   7   8   9   10   11   12   13   14   15   16   17