To develop skill on spreadsheet applications.
To develop skill on creating graphs.
To assist in the efficient use of database packages.
To develop skill on computerized database management.
To develop skill on programming with database management.
Spreadsheet Analysis Package: Applications of spreadsheet; Using worksheet; Apply formula and functions in worksheet; Creating & printing graphs; Create simple macros.
Database management package: Creating the database; Editing the database; Searching the records; Customizing the data entry form; Creating the query; Arranging the records; Generating reports.
Database management language: Creating a command file; Writing simple database program using decision-making commands.
SPREAD SHEET ANALYSIS PACKAGE:
1 Apply the basic skills of a spreadsheet software package
1.1 Run a spreadsheet software package.
1.2 Identify and use different areas (working area, border area, control panel, mode indicator, and status indicator) of the worksheet screen.
1.3 Identify the function of different keys (typing key, calculator key, text key, cursor key, etc.)of the keyboard.
1.4 Move around the worksheet using keys and combination of key.
1.5 Identify and use the on-screen help facility.
1.6 Identify and use the types of data, numbers, labels and formula.
1.7 Demonstrate menus, submenus, pop-up menu, etc.
2 Manage workbooks and windows.
2.1 Make and use workbooks.
2.2 Access different types of files.
2.3 Open files as read only.
2.4 Demonstrate the options for saving files.
2.5 Display a workbook in more than one window.
2.6 Work with more one workbook.
2.7 Close a workbook.
3 Create a worksheet and use simple commands.
3.1 Activate entries in a worksheet.
3.2 Use edit key (F2) to correct or to modify entries.
3.3 Activate the command menus and select commands.
3.4 Save the worksheet.
3.5 Exit from spreadsheet .
3.6 Retrieve a previously saved worksheet.
3.7 Modify the worksheet.
3.8 Save a modified worksheet.
4 Apply formula, function and using templates.
4.1 Use simple formulae to solve arithmetical computation.
4.2 Use arithmetical operators in formula.
4.3 Edit formula.
4.4 Use mathematical function to solve simple equations.
4.5 Make and use workbook templates.
4.6 Make changes in existing workbook templates
4.7 Validate numbers, dates, times & text.
4.8 Show custom validation.
5 Solve engineering problems using formula and functions
5.1 Use mathematical functions to compute trigonometric values, absolute values, random number, square root, logarithmic values, etc for solving engineering problems.
5.2 Use logical functions to perform an operation depending on a condition in engineering problem.
5.3 Use statistical function to compute summation, average, minimum value, maximum value, etc in engineering problem.
6 Work with cell pointer to a particular cell.
6.1 Use GOTO key to move the cell pointer to particular cell.
6.2 Use the ABSOLUTE KEY to change cell address from one from to another in formula or in functions.
6.3 Enter range in formulae or in functions by typing directly or by using cell pointer.
6.4 Create a range name.
6.5 Use range name in formula & functions.
6.6 Copy, Move & Erase cell range.
7 Format a worksheet.
7.1 Change the width of a column, a range of column, and change the columns width globally.
7.2 Insert blank columns and blank rows in a worksheet.
7.3 Delete columns and blank rows in a worksheet.
7.4 Format the display of data of a worksheet globally or by referring a range of cells (e.g. currency format, exponential format, comma format, etc.).
7.5 Format the display of data and of a worksheet globally or referring of cells.
7.6 Protect worksheet, function, formula, important text and unprotect a range for entering entries.
7.7 Work with window for viewing worksheet in different ways and freeze rows or columns.
7.8 Create, change and delete a style.
8 Exercise on Sorting, Searching and Worksheet Printing.
8.1 Create a database program
8.2 Sort a database in different ways.
8.3 Search a record from the database using search criteria.
8.4 Extract records from the database that match a given criteria.
8.5 Delete records that a given criteria from the database using available
8.6 Show the Print Preview and adjust Page setup option.
8.7 Create and use page headers of footers.
8.8 Set print area, print titles and different print option
8.9 Print portion of worksheet and multiple worksheets
8.10 Print ranges from different worksheets on the same pages.
9 Create and Print graphs.
9.1 Create bar, line, X-Y and pie graphs.
9.2 Add color, titles, legend, gird and levels to the graph.
9.3 Add visual impact with colors.
9.4 Create linked pictures.
9.5 Save the graph and assign names to different graphs of a single worksheet.
9.6 Print graphs (low or high quality graphs.)
9.7 Plot graphs using a plotter using different colors.
9.8 Change graphs size, print & plot them.
10 Create Macros and using macro commands.
10.1 Create simple macros (e.g. to change the width of a cell, to format a cell
display, to erase a range of cells etc.) using keystroke commands.
10.2 Create a macro to convert values into labels vice versa.
10.3 Create a macro for inserting blank rows between two rows of data in a worksheet.
10.4 Create a macro for deleting the inserted blank rows in a worksheet.
DATABASE MANAGEMENT PACKAGE:
11 Create the new database.
11.1 Identify the practical database in real world.
11.2 Identify the fields and records of a database.
11.3 Identify the different phases of database design.
11.4 Collect the data form a typical field.
11.5 Determine the category of a typical field.
11.6 Design a typical Paper- pencil database form raw data.
11.7 Run a generalized database management package and identify its display
11.8 Identify the different options of the selected packages.
11.9 Use the on-screen help facilities of DBMS package
11.10 Create and save the table structure.
12 Change the table structure and edit database.
12.1 Modify and Edit the table structure.
12.2 Verify the structure (i.e. data of update, number of records. etc)
12.3 Enter or append the new records in the database.
12.4 Use the key combinations for editing.
12.5 Use the available options to edit fields.
12.6 Delete unwanted records and files.
12.7 Save & close database file.
12.8 Use different modes to append and edit records of database.
13 Search, display and arrange the records of database.
13.1 View a database using list and display command
13.2 Retrieve the database records with different conditions.
13.3 Search within a field.
13.4 Keep the track of specific records.
13.5 Keep the database up-to-date.
13.6 Sort a database on single or multiple fields.
13.7 Sort with qualifier (i.e. sort with specific subset of records).
13.8 Index the database on single or multiple fields.
13.9 Use the function to index on different field types.
13.10 Use the commands for selective indexing and to control the order of records.
14 Create the customized data entry form.
14.1 Draw a typical data entry screen with paper-pencil work.
14.2 Design the screen with all fields.
14.3 Move the field to make the entry form logical and easy to use.
14.4 Change the field width.
14.5 Add or delete field (if necessary).
14.6 Change the display characteristics of fields.
14.7 Use picture functions template and range to format the displayed data.
14.8 Use different options and commands in design menu.
14.9 Draw lines and boxes on the form.
15 Create the query.
15.1 Display and identify query design screen.
15.2 Build a simple query
15.3 Save & apply the query.
15.4 Use the query design menu options.
15.5 Use the symbols and operators to build query.
15.6 Search the records with matching on two or more fields.
15.7 Select the records within range using range operators.
15.8 Find the records with inexact and complex matching.
15.9 Sort the records within queries.
16 Generate the custom reports.
16.1 Send the reports to the screen or to a file.
16.2 Use the print menu options and dos-prompt options.
16.3 Produce a quick and selective report.
16.4 Plan the design of the report.
16.5 Design a custom columnar report.
16.6 Find the parts of a report specification.
16.7 Make the changes to the report specification.
16.8 Save & run the report.
17 Work with multiple database and relationship.
17.1 Merge the data form one file to another.
17.2 View the files to relate two or more database files.
17.3 Set up the relationship.
17.4 Modify the relationship.
17.5 Create the report from relational database.
DATABASE MANAGEMENT LANGUAGE:
18 Create a simple command file using expression and function.
18.1 Identify the database editor.
18.2 Use the commands to assign different types of data values to variables.
18.3 Save the memory variable.
18.4 Display the memory variable.
18.5 Release & restore the memory variable.
18.6 Use the mathematical expression.
18.7 Use the mathematical, relational, logical and string operators.
18.8 Use the common function such as EOF, BOF DATE, UPPER & LOWER< CTOD, DTOS, SPACE, TRIM, STR, etc. in command file.
18.9 Use the commonly use commands such as SET TALK, SKIP, RETURN in command file.
18.10 Use the commands to display a string of characters and wait for user response.
18.11 Use commands to display or print text.
19 Design & write simple programs.
19.1 Identify the basic steps to design a program.
19.2 Write the pseudocode for simple program.
19.3 Convert the pseudocode into actual program code.
19.4 Verify & documents the simple program.
19.5 Save the command file and then exit.
19.6 Run the program.
20 Use the decision making commands in Programs.
20.1 Use DO WHILE —- ENDDO, IF —- ENDIF and DO CASE —- ENDCASE to control program flow.
20.2 Use SCAN —- ENDSCAN command instead of DO WHILE —- ENDDO.
20.3 Use IF, ELSE and ENDIF commands to branch to the part the program.
20.4 Use nested IF —- ENDIF statements.
20.5 Write simple program using decision making commands.
20.6 Use immediate IF function.
20.7 Write simple program using immediate IF function.
20.8 Use CASE —- ENDCASE statement instead more than three IF —- ENDIF statements.
20.9 Use the EXIT, CANCEL, WAIT and ZAP command in database program.
20.10 Use macro function within programs.