Page 12 - Trackpad IT-402_Class-IX
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  the 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,
                                      •  Formatting a range of cells with decimal
                                                                              format values,
                                                                            •  Demonstrate to format range of cells with
                                        places,
                                                                              decimal places,
                                      •  Formatting a range of cells to be seen as
                                        labels,
                                                                            •  Demonstrate to format a range of cells to
                                                                              labels,
                                      •  Formatting of a cell range as scientific,
                                      •  Formatting a range of cells to display times,
                                      •  Formatting alignment of a cell range,
                                                                              scientific,
                                                                            •  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