Page 14 - Trackpad 402_Class-X_Final
P. 14

Unit  2  Electronic Spreadsheet (Advanced)                                                            191
          Data Consolidation                              Creating Subtotals
          Using WHAT-IF Scenarios                         Goal Seek Analysis
          Using Solver                                    Linking Data and Worksheets
          Cell Reference                                  Working with Hyperlinks in a Sheet
          Sharing Worksheet Data                          Record Changes in a spreadsheet
          Adding Comments to Changes                      Merging Worksheets
          Comparing Documents                             What are Macros?


        Unit  3  Database Management System                                                                   263
          Database                                        Elements of a Database
          Relational Database Management System (RDBMS)    Steps to Create a Table
          Data Types in Database                          Database Objects
          Inserting a New Record in a Table               Referential Integrity
          What are Relationships?                         What is a query?
          Steps for Creating Queries                      Structured Query Language(SQL)
          What is a form?                                 What is a Report?


        Unit  4  Web Applications and Security                                                                337
          Types of Impairment                             Computer Accessibility
          Accessibility Options in an Operating System    Networking Fundamentals
          Internet                                        Getting Access to Internet Through Internet Service Providers
          Data Transfer on the Internet                   Steps to Check for Active Internet Connection
          Concept of Instant Messaging (IM)               Etiquettes to be Followed While Chatting
          Chatting Using Yahoo Messenger                  Creating and Publishing Web Pages (Blog)
          Using an Offline Blog Editor                    What is Online Transaction?
          What is Internet Security?                      Antivirus
          General Guidelines for Managing Strong Passwords    What is a Firewall?
          Clearing Data Stored in Browsers                Maintain Workplace Safety
          What is First Aid?                              Prevent Accidents and Emergencies
          Emergency                                       Protecting Health and Safety At Work
          Case Studies of Hazards/Accident due to Situations Avoidable    How to Keep Your Workspace Safe

                                                  Part C: Practical Work
        Practical Work                                                                                        395
        Viva Voce Questions                                                                                   400
        Projects (Hints for Part D)                                                                           402
        Glossary                                                                                              406
        Sample Question Paper                                                                                 408
        CBSE Sample Question Paper                                                                            412






















                                                            (xiv)
   9   10   11   12   13   14   15   16   17   18   19