Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 6 - 2626_South Point_C-7
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

| 1 2 3 4 5 6 7 8 9 10 11 |