Page 230 - CA_165_V2.0_C9_Flipbook
P. 230

Lab Assignment ‘n Activity                  Century   #Technology Literacy
                                                                                                 21 st
                                                                                                Skills


                     Complete the following activities and tick on the circles:
                     ª  Enter the marks of 5 subjects and draw a Line chart and a Bar Chart for the subjects.
                     ª   The table below shows marks obtained by 50 students in Computer Class Test. Draw a
                        Column Chart (graph) based on the table.

                              Marks            3       4        5       6        7       8        9       10
                         No. of Students       1       3        4       8       12       10       9       3

                     ª  For the following data, draw a Pie Chart.

                             Item           Rent          Food           Cloth       Education        Misc
                         Expenses in%        15%           35%           10%            20%           20%






                      Recap Zone

                        Calculations are performed on cells on the basis of Cell Addresses mentioned, while writing the
                         formula.
                        Formula can be applied in reference to cell names. Name can be used directly in a formula.
                        Functions are in-built formula in OpenOffice Calc, which can be used to perform arithmetical
                         and non-arithmetical tasks.
                        The identification or address of a cell in a formula is known as Cell Reference. There are three
                         types of referencing in OpenOffice Calc are relative, absolute and mixed referencing.
                        An operator is a symbol that performs certain mathematical or logical operations.
                        Functions are entered in a cell to produce the output of data.
                        List of errors which commonly occurs in OpenOffice Calc are ###, #VALUE!, #NAME?, #NUM!,
                         #REF! and #DIV/O!.
                        Sorting refers to the process of arranging data in ascending or descending order based on a
                         certain criteria.

                        Filtering is a quick and easy way to get required information from the subset of data in a range
                         of cells.

                        If the user does not want to show columns or rows that contain some part of data on the
                         screen, it can be hidden with the help of Hide feature.

                        Charts and graphs are visual or graphical representation of data from a worksheet which is
                         very useful for instant analysis and decision making.
                        Based on the same data, a user can easily switch from one type of chart to another.











                   228   Touchpad Computer Applications (Ver. 2.0)-IX
   225   226   227   228   229   230   231   232   233   234   235