Page 12 - IT 402 v2.0 class 10
P. 12

Share and review a        • Setting up a spreadsheet for sharing.    • Set up a spreadsheet for sharing.

                 spreadsheet               • Opening and saving a shared spreadsheet.  • Open and save a shared spreadsheet.
                                          Recording changes.                  • Record changes.
                                           • 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.

                 Create and Use Macros in     • Using the macro recorder. Creating a simple  • Demonstrate the use of a macro recorder.
                 spreadsheet              macro. Using a macro as a function.    • Create a simple macro.
                                           • Discuss Passing arguments to a macro.    • Use a macro.
                                           • Discuss Passing the arguments' areas values.    • Using a macro.
                                           • Discuss Macros to work like built-in functions.
                                                                              • Sort the columns using macro.
                                           • Accessing cells directly.
                                           • Sorting the columns using macro.
                 Appreciate the concept     • Concept and examples of data and information,    • Identify the data and information,
                 of Database Management     • Concept of database,            • Identify  the  field   record   table  in the database
                 System                    • Advantages of database,          • Prepare  the  sample  table  with  some  standard
                                           • Features of database,           fields.
                                           • Concept and examples of Relational database,
                                                                              •  ssign the primary key to the field
                                           •  oncept and examples of field  record  table
                                                                              • Identify the primary key, composite primary key,
                                          database,
                                           • Concept  and  examples  of  Primary  key,   foreign key.
                                          composite primary key, foreign key,
                                           • Relational Database management system
                                          (RDBMS) software.
                 Create and edit tables using     • Introduction to a RDBMS    • Start the RDBMS and observe the parts of main window,

                 wizard and SQL commands    • Database objects – tables, queries, forms, and  • Identify the database objects, Create the sample
                                          reports of the database,           table  in  any  category  using  wizard,  Practice  to
                                           •  erms in database   table  field  record   create different tables from the available list and
                                           • Steps to create a table using table wizard*  choosing fields from the available fields.
                                           • Data types in Base,              •  ssign data types of field  Set primary key.

                                           • Option to set primary key Table Data View  •  dit the table in design view   nter the data in the fields.
                                          dialog box
                                                                              • Create and edit table using DDL Commands
             DATABASE MANAGEMENT SYSTEM  Retrieve data using query    • Deleting records from the table,    • Create and edit relationships
                                                                           Demonstrate to:
                                           • Inserting data in the table,
                 Perform operations on table
                                                                              • Insert data in the table, Edit records in the table,
                                           • Editing records in the table,
                                                                             Delete records from table, Sort data in the table,
                                           • Sorting data in the table, Referential integrity,

                                           • Creating and editing relationships – one to  • one to one, one to many, many to many,
                                          one, one to many, many to many,
                                                                              •  nter various field properties.
                                           • Field properties (default, required and format).
                                           • Database query,
                                                                              • Prepare a query for given criteria,
                                                                              • Demonstrate to create query using wizard, and
                                           •  efining  uery
                                                                             using design view,
                                           • Query creation using wizard,
                                           • Creation of query using design view,
                                                                              • Demonstrate to apply various criteria in query –
                                           • Editing a query,
                                                                             single field  multiple fields  using wild card
                                           •  pplying  criteria  in   uery     single  field      • Edit a query,
                                          multiple fields  using wildcard     • Performing calculations using query in Base,
                                           • Performing calculations,         • Demonstrate to group data,
                                           • Grouping of data,                • Use basic SQL commands,
                                           • Structured Query Language (SQL)
                                           • Introduction to DDL (purpose of– Create database,
                                          Create table, Alter table and Drop table)
                 Create Forms and Reports     • Introduction to Forms in DBMS..    • Illustrate the various steps to create Form using
                 using wizard              • 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    • Demonstrate to modify Forms,
                                           • Modifying form,
                                           • Changing label, background,      • Demonstrate to change label, background,
                                           • 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.

                 Working With Accessibility     • Understand various types of impairment that  • Illustrate use of  various options under Computer
                 Options                  impact computer usage              Accessibility like Keyboard, mouse, sound, display
                                           • Computer Accessibility Dialog box and its   setting serial keys, cursor options
                                          tabs                                •  se of toggle keys  filter keys  sticky keys  sound
                                           • Serial Keys                     sentry, show sounds etc.
                                                         (x)
   7   8   9   10   11   12   13   14   15   16   17