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

