Page 52 - IT-802_class_12
P. 52

ICT SKILLS-IV                                             3










                   ICT (or Information and Communications Technology) refers to the use of technology for communication
                   and processing information.

                   Information and communications technology (ICT) skills refer to one’s ability to converse with people
                   through various technologies. Similar to information technology (IT), ICT refers to the technology used
                   for regular, everyday tasks like sending an email, making a video call, searching for information on the
                   internet, using a tablet or mobile phone, and more.
                   In this unit, we will learn how to use a spreadsheet. Spreadsheet skills allow students to organize, calculate,
                   graph, and analyze data. These skills provide a critical foundation in preparation for future studies and the
                   workplace. Today, many careers require knowledge of how to use a spreadsheet program.

                     3.1 INTRODUCTION TO SPREADSHEET

                   A  spreadsheet  is  a  computer  application  for  computation,  organization,  analysis,  and  storage  of  data
                   in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets.
                   The program operates on data entered into cells of a table. Each cell may contain either numeric or text data,
                   or the results of formulas that automatically calculate and display a value based on the contents of other
                   cells. A spreadsheet may also refer to one such electronic spreadsheet. A collection of spreadsheets is known
                   as a workbook. By default, a new workbook contains three worksheets.
                   Some of the most popular spreadsheet software are listed here:










                       Google Sheet                Excel                OpenOffice Calc         LibreOffice Calc

                     3.2 WHAT IS OPENOffICE CAlC?


                   OpenOffice Calc is the spreadsheet component of OpenOffice.org. One can enter data (usually numerical)
                   in a spreadsheet and then manipulate this data to produce certain results.

                   Alternatively, one can enter data and then use Calc in a ‘What If...’ manner by changing some of the data
                   and observing the results without having to retype the entire spreadsheet or sheet.
                   Other features provided by Calc include:
                   Ð ÐFunctions, which can be used to create formulas to perform complex calculations on data

                   Ð ÐDatabase functions to arrange, store, and filter data
                   Ð ÐDynamic charts include two new types of charts—bubble charts and filled net charts
          50       Touchpad Information Technology-XII
   47   48   49   50   51   52   53   54   55   56   57