Page 10 - Trackpad 402_Class-X_Final
P. 10

• • Setting up a spreadsheet for sharing.*  • • Set up a spreadsheet for sharing.
                                        • • Opening  and  saving  a  shared  spreadsheet.   • • Open and save a shared spreadsheet.
                  Share and review a     Recording changes.                 • • Record changes.
                  spreadsheet           • • Add, Edit and Format the comments.  • • Add, Edit and Format the comments.
                                        • • Reviewing  changes  –  view,  accept  or  reject   • • Review changes – view, accept or reject changes.
                                         changes. Merging and comparing.    • • Merge and compare sheets.
                                        • • Using  the  macro  recorder.  Creating  a  simple
                                         macro. Using a macro as a function.  • • Demonstrate the use of a macro recorder.
                  Create and Use Macros in   • • Discuss Passing arguments to a macro.  • • Create a simple macro.
                                        • • Discuss Passing the arguments' areas values.
                                                                            • • Use a macro.
                  spreadsheet           • • Discuss Macros to work like built-in functions.  • • Using a macro.
                                        • • Accessing cells directly.       • • Sort the columns using macro.
                                        • • Sorting the columns using macro.
                                        • • Concept and examples of data and information,
                                        • • Concept of database,
                                        • • Advantages of database,         • • Identify the data and information,
                                        • • Features of database,           • • Identify  the  field,  record,  table  in the database,
                  Appreciate the concept   • • Concept and examples of Relational database,  • • Prepare  the  sample  table  with  some  standard
                  of Database Management   • • Concept and examples of field, record, table,   fields.
                  System                 database,                          • • Assign the primary key to the field,
                                        • • Concept  and  examples  of  Primary  key,   • • Identify  the  primary  key,  composite  primary  key,
                                         composite primary key, foreign key,  foreign key.
                                        • • Relational  Database  management  system
                                         (RDBMS) software.

                                        • • Introduction to a RDBMS        • • Start the RDBMS and observe the parts of main window,
                                        • • Database objects – tables, queries, forms, and   • • Identify  the  database  objects,  Create  the  sample
                                         reports of the database,
                  Create and edit tables   • • Terms in database – table, field, record,  table  in  any  category  using  wizard,  Practice  to
                                                                            create different tables from the available list and
                  using wizard and SQL   • • Steps to create a table using table wizard*  choosing fields from the available fields.
                  commands              • • Data types in Base,            • • Assign data types of field, Set primary key.
                                                                           • • Edit the table in design view, Enter the data in the fields.
                                        • • Option  to  set  primary  key  Table  Data  View   Demonstrate to:
                                         dialog box
                                                                           • • Create and edit table using DDL Commands
             DATABASE MANAGEMENT SYSTEM  Perform operations on   • • Deleting records from the table,  • • Insert data in the table, Edit records in the table,
                                        • • Inserting data in the table,
                                        • • Editing records in the table,
                                                                            Delete records from table, Sort data in the table,
                                        • • Sorting data in the table, Referential integrity,
                                                                            • • Create and edit relationships
                  table
                                        • • Creating  and  editing  relationships  –  one  to
                                                                            • • one to one, one to many, many to many,
                                         one, one to many, many to many,
                                                                            • • Enter various field properties.
                                        • • Field properties (default, required and format).
                                        • • Database query,
                                        • • Defining query,
                                        • • Query creation using wizard,*
                                                                            • • Demonstrate  to  create  query  using  wizard,  and
                                        • • Creation of query using design view,*
                                                                            using design view,
                                        • • Editing a query,
                                                                            • • Edit a query,
                                        • • Applying  criteria  in  query  –  single  field,   • • Prepare a query for given criteria,
                  Retrieve data using query                                 • • Demonstrate  to  apply  various  criteria  in  query  –
                                         multiple fields, using wildcard,
                                        • • Performing calculations,        single field, multiple fields, using wild card,
                                        • • Grouping of data,               • • Performing calculations using query in Base,
                                                                            • • Demonstrate to group data,
                                        • • Structured Query Language (SQL)  • • Use basic SQL commands,
                                        • • Introduction to DDL (purpose of– Create database,
                                         Create table, Alter table and Drop table)
                                        • • Introduction to Forms in DBMS..  • • Illustrate  the  various  steps  to  create  Form  using
                                        • • Creating form using wizard,*    Form Wizard,
                                        • • Steps to create form using Form Wizard,*  • • Enter or remove data from Forms,
                                        • • Options to enter or remove data from forms
                                        • • Modifying form,                • • Demonstrate to modify Forms,
                  Create Forms and Reports   • • Changing label, background,  • • Demonstrate to change label, background,
                  using wizard          • • Searching record using Form,   • • Search record using Form,
                                        • • Inserting and deleting record using Form View,  • • Insert and delete record using Form View,
                                        • • Concept of Report in Base,     • • Illustrate the various steps to create Report using
                                        • • Creating Report using wizard,*
                                        • • Steps to create Report using Wizard.*  Report Wizard,
                                        • • Insert date and time,          • • Demonstrate various examples of Report.
                                                                            • • Illustrate use of  various options under Computer
                                        • • Understand various types of impairment that
                  Working With Accessibility   impact computer usage        Accessibility like Keyboard, mouse, sound, display
                                                                            setting serial keys, cursor options
                  Options               • • Computer Accessibility Dialog box and its tabs  • • Use of toggle keys, filter keys, sticky keys, sound
                                        • • Serial Keys
                                                                            sentry, show sounds etc.
                                                           (x)
   5   6   7   8   9   10   11   12   13   14   15