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)

