Page 7 - TP_iPlus_V2.1_Class7
P. 7

Assessment Resources



                              #Digital Literacy                                                               #Problem Solving & Logical Reasoning
                                             Exercise contains    To Sum Up                                   #Digital Literacy
                Let’s CatCh Up                                                                    Crack The Code
               Match the following:  a. Address of the active cell  variety of exercises     Computer system is made up of two types of components: hardware and software.  Identify five terms related to computer safety and viruses.
                                                                                                            X  H  E   S
                                                                     All the physical components of a computer system are called hardware.
               1. Row header   b. Displays contents of active cell    A computer accepts data and instructions from you through input devices.  V  Q  A  U  Y  S
                2. Column header   c. Row numbers                   The CPU is the brain of the computer.    J  U  V  F  U  W  C  G  T   P
                                                                                                            B  F  R   Y
                3. Sheet tab   d. Column letters  to reinforce the     Output is the information obtained after processing of data which the user receives   P  R  G  E  K  E  R  U  S  O  W
                                                                   through output devices.
                4. Name Box   e. Displays number sheets in worksheet                                   A  E   Z  V  I   A  G   J   A
                                                                                                         D  S  U  S
                5. Formula bar                   concepts.          Storage devices are used to store data for future use.  O  D  E  O  F  A  M  K  A   R
                                                                                                       W  S
                While working in Excel, the following types of data can be entered:  capability to log in to devices like smartphones or laptops.  R  F   F  X  T  I   B  B  N   E  #Experiential Learning
                i +  TYPES OF DATA
                                                                    The 3D camera is a real-sense device which is able to recognise faces and use that
                                                                                                             O  N   S   S
                                                                                                        M  H  N  O  R  T
                Numbers include the digits (0–9) and their various combinations. All types of calculations can be   Exercise  #Communication
                Numbers
                done on numbers.By default, Excel aligns numbers to the right.
                                                                                                    Browse the internet and make a list of ten popular antivirus programs.
                calculation can be performed on text. By default, Excel aligns text to the left.
                Text Text includes the collection of letters, numbers, and special characters.  No mathematical   A.  Tick (3) the correct option.  Section A (Objective)  Let’s Explore  #Ethical & Moral Reasoning

                Date type is used to enter the date in different formats. The default format of date in Excel is          2.  Which output device helps in printing flex, graphs, tables, charts, etc.   Life Skills and Values

                                                                  1.  What is a set of instructions called that makes the computer perform a specific task.
                                                                  a. Hardware
                 mm/dd/yy. Time type is used to enter time in either hh:mm or hh:mm:ss format. By default,

                Date and Time
                                                                            b. Software
                                                                  c. Memory

                                                                            d. CPU
                                          Let’s Catch Up
                 Excel aligns dates and times to the right.
                 i +  CREATING A NEW WORKBOOK
                                                                  a. Laser printer

                                                                            b. Plotter
                 To create a new workbook in Excel 2016, follow the given steps:  recalls a part of          3.  Which of the following is not an internal hardware component?  Never download files from unknown websites.  #Digital Literacy
                                                                  c. Ink jet printer

                                                                            d. Dot matrix printer
                      2  Click on the New option.
                                                                                                     Practical Time
                                                                  a. SMPS

                                                                                                    •   Create a presentation on "Computer Virus." The presentation should include the following topics,
                                           topic quickly.            4.  Which port is found in computer projectors?  b. Ports   Visit your computer lab and perform the following tasks:
                                                                  c. Mother board

                                                                           d. Printer
                                                                                                    •  Open Microsoft PowerPoint.
                  1  Click on the File tab.  Blank workbook.       a. Parallel      b. Serial       with each topic covered on a separate slide:
                                   3  Click on the
                                                                                                      o  What Happens If a Virus Infects Your Computer?

                                                                  c. USB
                                                                            d. VGA                    o  What is a Computer Virus?
                                                                   5.  Which keyboard  is  operated  by typing on a touch-sensitive surface rather  than pressing     o  Common Types of Computer Viruses
                                                                 physical keys?                       o  What is Antivirus Software?
                                                                   a. Virtual                         o  How Does Antivirus Software Work?

                                                                           b. Wireless

                  A new workbook will be created.  61            c. Wired      d. Real               Teacher’s Corner
                                Spreadsheets—An Introduction    18                                  1.  Discuss about the latest computer virus and malware threats.  39
                                                                                                    2.  Demonstrate the installation of antivirus software.
                                    Two Worksheets               iPlus (Ver. 2.1)-VII                               Computer Virus
                                     and Test Sheets
                                    have questions to                                     Crack the Code is a puzzle or fun
                                     assess students.         Test Sheet 1                based activity to help understand
                                                                                                 the concepts better.
                                                              (Based on chapters 1 to 6)
                                                                Section A
                                                      A.  Tick (3) the correct option.
                               (Based on chapters 1 to 6)       1.  What projects the output from the computer screen to a larger screen?
                                                        a. Projector
                  Worksheet 1                            c. Printer      b. Speakers
                                                                   d. Monitor

                 A.  Rewrite the incorrect statements.     2.  Of which digits is Octal Number System made up?
                                                        a. 0 to 7
                  ..............................................................................................................................................................................................

                                                                  b. 0 to 9
                    1.  The total number of digits used in a number system is called its LSD.      c. 0 and 1      d. Both a and b   Let’s Explore
                  2.  Hexadecimal number system consists of 16 digits from 0–15.      3.  What is another name for a program file virus?  #Experiential Learning
                    ..............................................................................................................................................................................................     a. File-infecting virus      b. File injector virus   Be Creative
                  3.  Numbers or text values that do not change are called references.     c. Both a and b      engines which are not taught in this chapter.
                                                                                                           Open any web browser and find out information about different types of search
                                                                  d. None of these
                    ..............................................................................................................................................................................................     4.  When someone sends e-mails that appear genuine from a trusted e-mail ID but in reality they're
                 B.  Define the following terms:  .......................................................................................................................     not to be trusted, then it is called .................................  includes activities   Be Creative
                                                       a. Spamming
                    1.  Macro Virus:    .......................................................................................................................     c. Phishing       b. E-mail spoofing   #Creativity & Innovativeness
                    2.  Pop-ups:     .......................................................................................................................        d. None of these     based on Art   notebook.
                     3.  Rootkit:     .......................................................................................................................  5.  Which of the following is a long horizontal bar at the top of the window that shows the name of
                                                                                                       Draw the logo of any two Internet service providers on a chart paper and paste it in your
                                                       the current workbook?
                     4.  Forum:     .......................................................................................................................     a. Title bar      b. Formula bar
                   5.  Patent:     .......................................................................................................................     c. Menu bar   Integration.
                                                                  d. None of these                     Life Skills and Values  #Ethical & Moral Reasoning
                   6.  Job Frauds:

                  C.  How are the following selected in a worksheet?     6.  Whose collection is known as a workbook?  rules of data sharing.
                         ................................................................................................................................
                                                       a. Cells
                                                                                                       Do not copy and paste data without the permission of your classmate and follow the
                     1.  Single Cell:   ................................................................................................................................     c. Columns        b. Rows
                                                                 d. Worksheets
                   2.  Group of Cells or Range:         7.  What does Excel consider it if we add an equal to sign at the beginning of the data?  SDG Activity
                          ................................................................................................................................     a. Text      b. Formula
                     3.  Entire Row/Column:   ................................................................................................................................       c. Number      d. Invalid value   Your school is organising a “Green Energy Fair,” and you’ve been chosen
                   4.  Entire Worksheet:              8.  Which option in the Alignment group is used to combine two or more selected cells into a cell?  to  showcase how  to power  up  your  school using renewable  energy
                                                        a. Merge & Center                             environment.
                                                                                                      sources. Explore different mediums through the Internet to create the
                  D.  Guess! Who am I?  ..........................     c. Combine cells      b. Wrap Text   Practical Time
                                                                                                      most effective renewable energy model and explain how it helps the
                   2.  I am an additional feature in ‘Excel’ that helps you enter a certain kind of
                      1.  I am used to display multiple lines of text inside a cell.   d. None of these
                      predefined series of data such as name of months of a year, serial numbers,    ..........................
                    etc. once the user feeds the initial data.
                                    ..........................
                    3.  I am a cell or a range of cells that you want to use in your calculation.   Test Sheet 1  83  is a lab activity to   Practical Time  #Experiential Learning
                                                                                                                    #Digital Literacy
                                               Project is an                    develop practical    common websites for online learning with the help of your teacher.

                                                                                                       Open Microsoft Edge and identify different components of it. Try to open some of the
                                              assessment to
                   82                                                                 skills.        Teacher’s Corner
                    iPlus (Ver. 2.1)-VII                                                            1.  Demonstrate the process of searching about a topic on the Internet and the process of downloading & uploading.
                                             develop practical                                      2.   Discuss the importance of Internet in our lives with the students.
              Focusses on fostering            proficiency.                                                       The Internet—Web Browser  61
                  Higher Order                                         PROJECT
                Thinking Skills in                                A.     Create a document in Word and write few lines on the "Say NO to Junk Foods".
                                                                              #Creativity & Innovativeness
                                                                              #Digital Literacy
                     students.                                  Make use of various features of Word.
                ...................................................................................................................................................................................
                3.  Write the steps to create a new document.                                    CYBER         Sample Questions
                  ...................................................................................................................................................................................
               C.  Competency-based/Application-based questions:  B.       Type the following text in Word. Apply various formatting features of Word such as   flowers are red”?  Section-A (Logical Reasoning)
                1.   Saransh is writing a letter to his mother and he added some text by mistake. He
                 doesn’t know how can he should undo the text. Tell him which key he should
                                                               text effects and numbering to make your text eye-catching.
                                                                                                   [Each question has four choices (a), (b), (c) and (d), out of which only ONE is correct.]
                                                                             #Creativity & Innovativeness
                2.   Arjun wants to find a synonym for the word “beautiful” in his poem. Which feature in Word   1.      #Ethics & Moral Reasoning         1.    Which of the following conclusions can be drawn from the statement: “All roses are flowers, and some

                                                                                                   (a) All roses are red.
                 use to do so.
                                                                                                           (b) All flowers are roses.
                                                                                                   (c) Some roses are red.
                               #Experiential Learning
                  2016 should he use to find a word with a similar meaning?  #Interdisciplinary    2.  Which arrow comes next?  (d) Some flowers are not roses.
                1.   Rajesh wrote a story in Word. He observed that below some words, red wavy lines appeared.
                Higher Order Thinking Skills (HOTS)                                                  (a)          (b)
                                                                                                           (c)
                 What does these lines mean?
                                                                                                   (a) 4276
                   2.   Saif wrote his introduction at the end of a Word document. When his teacher saw it, he       3.  If the code of 24673 is 35784, what will be the code of 3185?      (d)
                                                                                                      (b) 4296
                   asked him to move it to the beginning of the document. How can he do so?          4.  The Odometer is to mileage as the compass is to:  (c) 4297     (d) 4295
                               #Coding & Computational Thinking
                                                                                                   (a) Hiking
                                                                                                      (b) Direction
                                                                                                           (c) Needle
                                                                                                                  (d) Wind
                                                                                                 is the girl related to the lady?
                                                                                                     5.    Pointing towards a lady in a photograph, a girl said, “She is the sister of my mother’s husband”. How
                  Crack The Code
                                                                                                   (a) Daughter
                                                                                                      (b) Niece
                 Complete the steps to use Thesaurus tool in the following text:                  6.    ________  is  the  primary  computer  that  holds  the  files  that  can  be  transferred  to  other  computers
                                                                                                           (c) Sister
                                                                                                                  (d) Cousin
                                                                                                       Section-B (Subject Specific)
                                                                                                 connected to a network.
                                                                                                  [Each question has four choices (a), (b), (c), and (d), out of which only ONE is correct.]
                 Step 1:  ................................ the word.                                 (a) Clip art   (b) Motherboard
                 Step 2:  Click on the ................................ tab.                      7.    Which  component  of  a  computer  system  stores  data  permanently  even  when  the  power  is  turned
                 Step 4:    Click on the drop-down arrow and select ................................ or .................................
                                                                                                 off?
                                                                                                           (c) Peripheral
                 Step 3:  Click on the ................................ tool.                          8.  What is the 8-bit binary representation of the decimal number 156?     (d) Keyboard
                                                                                                                 (d) File server
                                                                                                  (a) RAM
                                                                                                     (b) CPU
                                                                                                          (c) Hard disk drive
                                #Experiential Learning
                                                                                                  (a) (10011011)2
                                                             96
                                                                                                     (b) (10100111)2
                                                                                                          (c) (10110111)2
                                                                                                  (a) Decimal
                                                              iPlus (Ver. 2.1)-IV                  9.  Which of the following number systems uses the digits 0-9 and the letters A-F? (d) (10011100)2
                                                                                                     (b) Binary
                                                                                                          (c) Octal
                  Let’s Explore                                                                    10.  Which option allows you to rehearse timings for a PowerPoint presentation?   (d) Hexadecimal
                                                                                                  (a) Animation Pane
                   Find out names of other word processing software.                            11.  Identify this icon. It is used to insert ________.  (c) Slide Show view     (d) Presenter view
                                                                                                     (b) Slide Sorter view
                                            This activity shows                                     12.  Which function key is commonly used to calculate formulas in Excel?    (d) Animation
                                                                                                  (a) Date & Time
                                                                                                     (b) Word Art
                                                                                                          (c) Slide Number
                                                                                                  (a) F1
                                                                                                     (b) F2
                    SDG Activity                                                                  13.  Which of the following file extension typically represents a document created in Microsoft Word?
                                                                                                          (c) F9
                                                                                                                 (d) F12
                                                                                                  (a) .docx
                  “Good health helps us enjoy life and feel great.” Make a few flash cards   how students use   OGO Section has   166  iPlus (Ver. 2.1)-VII  (c) .pptx     (d) .pdf
                                                                                                     (b) .xlsx
                  with different healthy activity quotes such as “Eat a fruit,” “Play outside,”
                   “Drink water,” “Get a good night’s sleep,” and “Wash your hands” in a
                   Word document.            digital literacy to
                                      35                            Cyber Olympiad sample
                                  Editing in Word 2016
                                             understand the                questions.
                                                  SDGs.
   2   3   4   5   6   7   8   9   10   11   12