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)
   7   8   9   10   11   12   13   14   15   16   17