Page 12 - open office
P. 12
6. Understand • Introduction to mail merge • Demonstrate to print the letters using mail
and apply mail • Concept of data source for mail merge. merge,
merge • Do the following to achieve
• Create a main document,
• Create the data source,
• Enter data in the fields,
• Merge the data source with main document,
• Edit individual document,
• Print the merged letter,
• Save the merged letter.
1. Create a • Introduction to spreadsheet application • Start the spreadsheet,
Spreadsheet • Starting a spreadsheet • Identify the parts of Calc,
• Parts of a spreadsheet • Identify the rows number, column number,
• Worksheet – Rows and Columns, Cell and cell address,
Cell Address, • Define the range of cell,
• Range of cells – column range, row range, • Identify row range, column range, row &
row and column range. column range
2. Apply formula • Different types of data, • Demonstrate to enter the text, numeric data
and functions in • Entering data – Label, Values, Formula in a cell,
spreadsheet • Formula, how to enter formula, • Identify the label, values and formula in the
• Mathematical operators used in formulae, cell,
• Simple calculations using values and • Demonstrate to enter formula in a cell,
operators, • Construct the formula using mathematical
• Formulae with cell addresses and operators, operators,
• Commonly used basic functions in a • Identify formulae with cell addresses and
spreadsheet – SUM, AVERAGE, MAX, MIN, operators,
Count • Identify the correct syntax of formula,
• Use of functions to do calculations. • Use the basic functions to perform
calculations on data.
ELECTRONIC SPREADSHEET • Use of dialog boxes to format values, • Demonstrate to use of dialog boxes to
3. Format data in
• Identify the formatting tool,
• Formatting tool,
the spreadsheet
format values,
• Formatting a range of cells with decimal
• Demonstrate to format range of cells with
places,
• Formatting a range of cells to be seen as
decimal places,
labels,
• Demonstrate to format a range of cells to
• Formatting of a cell range as scientific,
labels,
• Formatting a range of cells to display times,
scientific,
• Formatting alignment of a cell range,
• Demonstrate to format a range of cells to
• Speeding up data entry using the fill handle, • Demonstrate to format of a cell range as
• Uses of fill handle to copy formulae. display time,
• Demonstrate to align cell data range,
• Demonstrate to create
• number series using fill handle,
• Copy formula by dragging the formula using
fill handle.
4. Understand Concept of referencing, • Demonstrate to use Relative referencing in
and apply • Relative referencing, spreadsheet,
Referencing • Mixed referencing, • Demonstrate to use Mixed referencing in
• Absolute referencing. spreadsheet,
• Demonstrate to use Absolute referencing in
spreadsheet.
5. Create and • Importance of chart in spreadsheet • Create different types of charts supported
insert different • Types of chart by a spreadsheet,
types of • Illustrate the example of chart in a
charts in a spreadsheet.
spreadsheet
(xii)

