Page 6 - Plus_V2.2_C7_Flipbook
P. 6
INSIDE THE SERIES
The key features of the series have been designed to ensure better learning and assessment.
Learning Resources
1 Number System 3 Advanced Features
Let's Surf provides of Excel
Let’s surf
Number System an overview of the
Decimal to Binary Conversion
Binary to Decimal Conversion
Operations on Binary Numbers Let’s surf Filtering Data
chapter contents. Sorting Data
Conditional Formatting
Let’s PLug-in
Solve the following sums. Also note the time you took to solve each of them.
1. 345678 – 789 = _______ (Time taken to solve: _______) Let’s PLug-in
2. 567 x 55 = _______ (Time taken to solve: _______) State whether these statements are True or False. __________
3. 100 x 9 + 890 – 67 = _______ 1. Area chart displays the data trends over a period of time. __________
(Time taken to solve: _______) __________
3. Plot area contains the actual chart and its other components.
4. 22/11 + 20 – 4 x 2 = _______ (Time taken to solve: _______) 2. A chart helps us to represent data pictorially. __________
4. Excel provides eight categories of charts.
Do you know how computer solves these sums and how quickly it does it? Let's find out in this chapter.
In the previous chapter, you have learned about different types of charts in Excel. In this chapter you
A computer takes data from a user and produces result as information. Although the words data
and information are often used interchangeably, but there is an important distinction between the
information. are going to learn how to sort and filter data. You will also learn about conditional formatting.
two words. In the strict sense, data consists of the raw numbers that computers organise to produce
SORTING DATA
From an early age, we are introduced to the concept of numbers and counting. Toddlers learn at an
to organise the data in ascending or descending order. Excel allows you to sort both numeric and
Let's Plug-in links back to Every day, you deal with a lot of data. It is easier to work with sorted data. Sorting of data means
early age that they can carry two cookies, one in each hand. Kindergarteners start counting by twos
textual data. You can sort the data according to a particular column as well as a range of data. To sort
and fives. Invariably, we use the decimal number system. Our number system is based on 10, most
likely because we have 10 fingers. Let us learn more about the number system.
previous knowledge before Step 1: Select a column or range of data to be sorted. In this case, we have selected the range
Tech Fact data, follow these steps:
A3:D8.
numeral system. Step 2: Click on the Sort & Filter command from Editing group under the Home tab. A dropdown
• The numerical digits, we use today, i.e., 1, 2 and 3 are based on the Hindu-Arabic
starting the lesson. list appears.
Step 3: Click on the Sort A to Z (for text) and Sort Smallest to Largest (for numbers) to sort the
• Different names for the number 0 include zero, nought, naught, nil, zilch and zip.
data in ascending order.
Number System 7
Touchpad PLUS (Version 2.1)-VII
26
Number Keys
Number keys are used to type numbers. We also call them numeric keys. There Tech Hint Factopedia adds Factopedia
In Hospitals
are 10 number keys. * ( ) provides a tip excitement to learning Doctors use computers to
! 1 @ 2 # 3 $ 4 % 5 ^ 6 & 7 8 9 0 create and study medical
On a keyboard, there are two sets of number keys. One set is above the alphabet to help the by providing some reports of the patients.
keys. The other set is on the right side of the keyboard. This set is also called
Num
Numeric keypad. The numeric keypad works only when the Num Lock key
Lock
was very big in
is on. Num Lock / * – Tech Hint students in the more interesting The first computer
size, almost the
7 8 Pg Up 9 information. size of a room.
Home + To activate the lab.
4 5 6 numeric keypad: Num Lock In Shops
1 2 Pg Dn 3 Num Lock key Shopkeepers use
End Enter Charles Babbage computers to create bills
0 Ins Del . Tech Fact presents is known as and maintain records of
the father of the items in the shop.
Spacebar Key
Spacebar key is used to give a blank spaces when we type words, letters or a fact about computer.
numbers. It is the longest key on the keyboard.
the topic. Let’s Back-Up
my school Ÿ Things made by man are called man-made
myschool Spacebar key
things.
natural things.
Shakuntala Devi
Ÿ Things that are created naturally are called
was an Indian Ÿ Machines make our work easier.
writer and mental
Ÿ Computer is a very useful machine.
Tech Fact calculator, known Ÿ We can do many things on the computer like
as the "Human
When we type, we see a blinking line on the screen. Computer". letters, etc.
It is called the Cursor.
solve sums, play games, listen to music, type
Cursor
The Keyboard and The Mouse 25
14 Touchpad PLUS (Version 2.1)-I
8
7 Introduction to Artificial Let's Back-Up
Intelligence
Reasoning and Critical
Thinking
Let’s surf provides a summary
Ø Natural and Artificial Things
Ø Natural Intelligence
Ø Artificial Intelligence
Let’s surf of the chapter for
Ø Shapes
Ø Pattern Let’s PLug-in
Ø Word Search quick recapitulation.
Critical Thinking
Circle the things that are made by human beings.
Let’s PLug-in
Experiential Learning Special Chapter on
Colour the shapes as per the given hints to complete the picture.
(Hints)
= Blue
Computational Thinking
= Green
and Artificial Intelligence.
= Yellow When you look around, you may see many things. Some of these are made by human,
while others are found in nature. Let us find out more about them.
= Purple
shape. NATURAL AND ARTIFICIAL THINGS
The given figure is made up of different shapes. Let us learn about each
artificial.
SHAPES
When you look around yourself, you may find two types of objects— natural and
sun, flowers, etc.
Things that are found naturally are known as natural things. For example, trees,
You have often observed various objects and wonder as to what shape they are
made up of. Let us discuss about some of the basic shapes.
Introduction to Artificial Intelligence
69
61
Reasoning and Critical Thinking

