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)

