Page 6 - CA 165 ver 1.0 Class 9
P. 6
INSIDE THE SERIES
INSIDE THE SERIES
The key features of the series have been designed to ensure better learning, assessment and evaluation.
Learning Resources
Wi-Fi is used to establish network in offices or within the small campus of an organization. It establishes
a good network connectivity generally for locations within a distance of 100 mts. It reduces the usage of
WiMAX stands for Worldwide Interoperability for Microwave Access. It is a type of telecommunication
spaces & cables. facility that enables wireless transmission of data. It is specially used in places where
internet connectivity is poor. A Local base station is created at such places where
Notes
WiMAX device is installed so that it catches signal, amplifies it and passes on to a local
network. Its range of operation is within 50 Km radius from base station.
It is a networking media in which computing devices are connected via short-range wireless signals Notes
through infrared adapters. Infrared connections are commonly used in remote controls to operate TV, AC,
Infrared
etc. that can connect by signal transmission in a short range distance.
Cloud computing refers to the usage of IT applications that are available on Cyber network but stored in This section contains additional Do you know?
a remote server. Rather than keeping files on a hard drive or local storage device, cloud-based storage
makes it possible to save program or data on a remote storage media and can be accessed anywhere
CLOUD COMPUTING
information to enrich the subject.
It makes it easier for organisations to use the same software at different locations or branches as
the application package can be used by numerous users thereby saving cost of multiple numbers of
using internet connections.
Computers connected to cloud computing technology are known as Cloud Computers. Cloud services
enable the users to use applications or remote servers. Thus it saves cost of purchasing additional software
licence. It also reduces data duplication of redundancy & removes data inconsistency or contradictions.
Hard Disk is also known as Winchester Disk.
installations. l from the flat surface of the optical disc.
Optical Disc
Cloud Computing is also very helpful in transferring the large files, eg: E-mails have the limitation of
sending files upto 25MB size only but larger files can be sent through cloud storage options such as
Public Cloud: It is available through Internet to anyone who is willing to pay for the services of
Optical disc is commonly used as an external storage device in which the laser beam helps to read data
Private Cloud: It is generally an application that is developed & run by a particular organisation for
CD: CD or Compact Disc is a common optical disc. It is made up of light weight
its own use at different branches or location. Some examples of cloud computing are Google drive,
plastic material with a chemical coating on one side where the data is stored.
l Google Drive. Some of the types of clouds are: as well. The capacity of 120 mm standard CD is 700 MB.
application.
It is inserted into a CD/DVD drive or CD/DVD writer of a CPU. CD ROM (Compact
Disc Read Only Memory) reads the data whereas in CD writer, data can be written
l l DVD: DVD or Digital Versatile/Video Disc is an optical disc which looks like a CD
Protocol refers to a set of common notions, norms or rules that coordinate or govern the functioning l to a DVD, one has to use a DVD writer).
One drive, IDrive, etc.
PROTOCOLS
between two or more sets of computers or networks.
but has a capacity to store data up to 17.1 GB. DVD is the merging of video and
audio in a common format. To read information stored in a DVD, it has to be
Basics of Information Technology 43 a Blue violet laser is used.
inserted into a DVD ROM or DVD Writer or DVD player (to copy information on
by the Blu-ray Disc Association (BDA).
Blu-ray Disc: Blu-ray disc can store data upto 128 GB. It has been developed
Do you know?
It is more advanced than CDs or DVDs. To read or write data on a Blu-ray disc,
data upto 1.5 GB.
player.
Do you Know? Flash Memory
v Diameter of a CD, DVD or Blu-ray disc is 120 mm. DVD can also be of 80 mm diameter that can hold
v CDs can be used or played in a DVD-ROM or a DVD player but DVD cannot be operated in a CD
v A combo drive is a device which contains all the features of a CD-Writer and a DVD ROM.
This section contains a l transfer data to computer.
fact about the topic. USB (Universal Serial Bus) port.
Flash Memory is a small sized external storage device that is commonly used in digital cameras, mobile
phones, MP3 players, etc. It can be plugged through USB or Fire wire port of a computer to fetch or
Pen/Flash Drive: It is small in size, handy and is a detachable device from
which data can be read, copied or transferred from one system to another. It is
re-writable and weighs less than 25 g. Nowadays, pen drives are the most
commonly used external storage and data transferring devices. It has an
attachment slot which can be easily inserted or attached into the computer’s
Basics of Information Technology
27
Subject Enrichment
Glossary
1. Animation: It is the display of sequence of images in order to create extraordinary illusions. Glossary
2. Antivirus: It is utility software that helps the computer to be free from virus and it notifies when any
3. Application Software: Application Software refers to programs which are designed to accomplish
program gets infected and contaminate other files.
4. Autofill: It is a feature in spreadsheet package in which a certain kind of predefined series of data This section contains
particular type of tasks to meet a user’s specific needs.
such as name of months of a year, serial numbers, etc. are automatically generated once the user
definition of common terms.
5. AutoSpellcheck: It is a facility in ‘Writer’ that enables to automatically check each word as it is typed Complete the following activities and tick on the circle. Subject Enrichment
feeds the initial data.
6. Callout: It is a text box, to which a line or arrow is connected for the purpose of pointing to a part of
and displays a red wavy line under the misspelt words.
Lab Assignment ‘n Activity
the document, so that additional information, related to that specific part can be presented.
7. Cell: It is a rectangular box formed by the intersection of a row and a column. ª Make all the contents of the cell as ‘Bold’ and set the size of the text as ‘18’. Designation
headings:
8. Charts: It is a visual graphical representation of data from a worksheet which is very useful for instant
ª Open ‘Calc’ on the computer and make Sheet2 as an active sheet.
DOJ
ª Rename the sheet as ‘Attendance’ and prepare a list of employee with the following
9. Communication Channel: It is the media through which data is transferred, (i.e., air, wires, waves,
Name of the Employee
analysis of data and decision making.
satellite connections, etc.) from sender to receiver and vice versa.
10. Communication: Communication refers to transfer of ideas or information from one place to another
ª Enter details of at-least 10 employees and set the font size as ‘Arial’.
DOJ
ª Insert a column after designation and give the name as ‘Salary’.
11. Confidentiality: It refers to keep the data or information secret and allowing only authorized people ª Enter the salary of each employee. Designation Salary
Name of the Employee
between different individuals.
ª Set the type face of ‘Salary’ as Bold and Italic.
12. Editing: It refers to the process of making changes in the existing text. ª Copy the content to the newly inserted worksheet.
13. Format Paintbrush: It is a tool which is used to apply the same type of formatting which is on a
to access the information.
ª Insert a column before DOJ and name it as S.No.
14. Formatting: It refers to the process of changing the appearance of text or document to make it more ª Insert a new worksheet and name it as ‘Attendance’.
ª Insert a new worksheet after the worksheet ‘Attendance’.
ª Fill the serial number starting from ‘1’ in the ‘S.No.’ column using AutoFill feature.
particular content; to some other content.
ª Delete the worksheet ‘Attendance’.
prominent and attractive as per user’s requirement.
ª Rename the newly inserted worksheet and name it as ‘Employee’.
227
Glossary
Recap Zone
Worksheet is the working area or page on the screen.
A workbook is like a book and the worksheet is like a page of a book.
different cells of the worksheet.
Recap Zone hide/unhide the sheets.
Data can be classified into numeric, alpha-numeric or text, date/time and formula.
Commands or data have to be entered with the help of input devices like mouse and keyboard in
If a workbook is saved for the first time, it must be assigned with a new file name.
This section contains summary recent actions.
navigation feature.
Workbook opens with three sheets by default. But the user can add, delete, rename, move and
of the chapter. ‘Calc’ also provides a feature to create a custom list where some series of names or text that can
We can move in OpenOffice from a cell to another cell or from one sheet to the other using the
Editing could be modifying, deleting, copying, moving, inserting, cancelling or repeating the
Formatting a cell includes changing the contents of cell with respect to appearance.
be predefined and then it can be displayed when the initial data is entered and AutoFill is applied.
Working with Spreadsheet
191

