Page 7 - TP_Pluse_V2.2_Class_6
P. 7

Assessment Resources




                                                                        TesT Your skills
                                                           1.  Tick ( ) the correct answer
                           Sheet Tab
                                                              a.  An active cell has a ____________ border around it.
                                                            (i) Green      (ii) Blue   Test Your Skills contains
                                                                             (iii) Black
                         It is present at the bottom left side of the Excel window just above the Status bar. Sheets
                                                            b.  Which of these is not a range?
                                                            (i) A:3:F9
                         tabs show the number of worksheets in a workbook and the Active Sheet (currently open
                         plus sign on the right of the sheet tab.     (ii) C20:E28
                         worksheet). The name of default worksheet is Sheet 1. To add a new worksheet, click on the
                                                              c.  What is the shortcut key to edit a cell?  (iii) B6:D16   variety of exercises to
                                                            (i) Esc key      (ii) Enter key
                          Row and Columns                     d.  The keyboard shortcut to copy and paste cell contents is:     (iii) F2 key
                                                            (i) Ctrl + Z & Ctrl + V      (ii) Ctrl + C & Shift + V   reinforce the concepts.

                                                              e.  Which of these cannot be filled using Auto Fill feature in Excel? (iii) Ctrl + C & Ctrl + V
                        Columns are the vertical sections of the worksheet whereas Rows are the horizontal sections
                        of the worksheet. An Excel worksheet has 1,048,576 rows and 16,384 columns.
                          Cells                             (i) Numbers      (ii) Days
                                                                            (iii) Colours
                                                           2.  Fill in the blanks using the words given below:
                        hold numbers, text or formula.
                        Cells are the intersection of rows and columns. It is the smallest unit in a worksheet and can
                                                                 Editing, Cells, Delete, Column, Number
                          Worksheet                           a.  To edit any content, you have to select the ____________.
                                                              b.  To select a column, place the mouse pointer on the ____________ header.
                                                              c.   Time and date can be entered in a cell from ____________ group under Home tab.
                        The worksheet is divided into Rows and Columns. The rows are numbered as 1, 2, 3, 4…. as

                        indicated by the Row Headers on the left side of the workspace. The columns are labelled
                        of the workspace.                  d.  To delete the contents of cells, select the cells and press the ____________ key.
                                                              e.  The Fill button is in the ____________ group under Home tab.
                        alphabetically as A, B, C, D…Z, AA….AZ,…..XFD as indicated by the Column Headers at the top
                          Active Cell
                                                           3.  Write 'T' for true and 'F' for false.
                                                             a.  You cannot enter a series of number using Auto Fill feature.
                        As the name suggests, it is the cell that is currently active or selected. It can be recognised by
                        its thick green border. You can type data into an active cell only.
                                                             b.  You cannot select a range using a mouse.
                         Formula Bar
                                                             c.  The date and time formats are given in the category box.
                       formula bar.                          d.  You can change the contents of the cell by clicking in the formula bar.
                       It displays the contents of the active cell. You can also type or edit data and formulas in the

                         Let’s CatCh Up                    e.  Moving the cells data means deleting it from original position.
                                         21 st            4.  Answer the following questions:
                        Match the following.  Century   #Critical Thinking
                                         Skills              a.  What is the use of Redo command?
                        1.  Row Header
                              a.  Address of the active cell
                        2. Column Header                    ___________________________________________________________________________
                        3. Sheet Tab   b.  Displays content of active cell  ___________________________________________________________________________  Tech Practice is a lab
                              c.  Row numbers
                       4. Name Box
                              d.  Column labels                         Editing Cell Contents in Excel 2016
                       5. Formula Bar   e.  Displays number of sheets in worksheet  71     activity to develop
                       52  Plus (Ver. 2.2)-V
                                                                                             practical skills.
                                                                                          (Subject Enrichment)
                                                  Tech Zone contains
                         Let's Catch Up
                                                    sections such as                                         21 st
                        recalls a part of                                                    Tech PracTice   Century  Skills  #Creativity
                                                   Let's Explore, Let's                     Draw a poster of 'Save the Environment' using Paint application in your computer.
                         lesson quickly.                                                    Make use of the following symbols to create the poster.
                                                   Get Better & Let's
                                                         Solve.
                                     Tech Zone
                       LeT's soLve
                      Guess who am I?   21 st
                                        Century   #Critical Thinking
                                        Skills
                      a.  I change the layout of the presentation.

                                        ____________
                      b.  I provide the themes for presentation.
                        c.  I add pattern in the background.            ____________
                        d.  I provide option to change the font color and size.               ____________
                                      ____________
                       LeT's exPLore
                                         21 st
                                        Century   #Creativity
                      themes in a slide.  Skills
                     1   Follow the steps of applying a theme in presentation and try to apply three different
                                                 SDG Activity shows
                       SDG Activity
                                                                                                     For The Teacher
                                                                                                 Demonstrate an example other than one in the book to explain the concept of secret message to students.
                     You see some trash on the ground in a park where animals live. What can
                                               how students use digital                         Explain the concept of information processing to students.
                     you do to help in keeping the animals safe and the park clean? Present
                     your thoughts in the form of an essay in a Word document.
                                                 literacy to understand
                     Tech PracTice
                                       21 st                                                                   Data Processing  95
                                       Century   #Creativity
                     1.   Prepare a presentation on the following topics:
                         a.  Life cycle of butterfly  Skills  the SDGs.
                         b.  Environment
                     2.  Add different headings using various WordArt.
                     3.  Add pictures related to topic.
                                                        T est Sheet  1  (Based on chapters 1 to 5)
                                    Formatting a Presentation     Section A          Project Work is an
                                         47
                                                        A. Tick ( ) the correct option.
                                                           1.  Which of these was used by the early man for counting?     (iii) Bones
                                                          (i) Calculator      (ii) Abacus   assessment to develop
                                                           2.  Mark-I was built in ____________. (ii) 1948      (iii) 1940

                                                          (i) 1944
                         Four Periodic                     3.  Which of these is not an option in the suggestion box?  practical proficiency.
                                                          (i) Change      (ii) Ignore All      (iii) Add all
                 Assessments for evaluation.               4.  Which of these is not a page orientation in Word?     (iii) Portrait
                                                                  (ii) Scenery

                                                          (i) Landscape
                                                            5.  Which of these is a default paper size in Word?      (iii) Letter   https://www
                                                                  (ii) A3
                                                          (i) A4
                                                         6.  Which of these is not available in the Variants group?
                                                                                                      PROJECT
                                                                           (iii) Effects              PROJECT WORK
                                                          (i) Colors      (ii) Designs
                                                         7.  Which of these is not an option in background fill effect?
                                                                                            https://www
                         Periodic Assessment                        (ii) Solid      (iii) Gradient   A.   Create the following document in Word and share   21 st
                                     1                    (i) Liquid                           it with your friends using the Mail Merge feature:  Century  Skills  #Leadership & Responsibility  https://www
                                                                    (ii) Design tab      (iii) Animation tab
                             (Based on chapters 1 & 2)    8.  Where is the Animation pane option located?
                                                          (i) Insert tab
                     A. Write the names of the following.
                                                            9.  Which key combination will move the active cell one row up?    (iii) Shift + Ctrl   https://www
                                                          (i) Shift + Enter      (ii) Shift + Tab
                                                            10.  Which of these is not a range?     (iii) B6:D16   https://www
                      1. _____________                    (i) A:3:F9      (ii) C20:E28
                           2. _____________               11. What is the shortcut key to edit a cell?
                                 3. _____________
                                      4. _____________            (ii) Enter key      (iii) F2 key
                                                           (i) Esc key
                        B.  Name the machines associated with the following scientists in the field of computers.
                     1.   Charles Babbage                B.  Fill in the blanks.
                                                          1.  Transistors and magnetic tapes were used in ____________ generation.  B.  Create the following in Excel.  21 st
                     2.  John Mauchly       _____________________________                                     Century   #Creativity
                                                          2.  The invention of integrated circuits occurred in ____________ generation.  Skills
                     3.  Blaise Pascal      _____________________________
                       4.  Herman Hollerith      _____________________________      3.  Paper size is the actual length and width of the paper in ____________.
                                                                           Test Sheet 1
                      C. Write 'T' for true and 'F' for false.    _____________________________   Test Sheet 1  75 75
                     5.  Gottfried Wilhelm Leibniz
                              _____________________________
                     1.   Paragraph spacing cannot be changed in a document.
                     2.  Line spacing can be changed in a document.
                                                  Two Test Sheets                            C.   Create similar PowerPoint presentation on Global
                     3.  The header is placed at the bottom of a page.
                                                                                              Warming.
                                                                                                            Century  21 st   #Leadership & Responsibility
                                                                                                            Skills
                     4.  Abacus is used to calculate numbers at low speed.
                                                  have questions to                       https://www
                    5.  Herman Hollerith developed the Tabulating Machine in 1890.
                    D.  Application based question.                                                                https://www
                                                   assess students.
                      Rahul wrote an essay on ‘MY COUNTRY—INDIA’ and saved it. Now he wants to break the
                    essay in three paragraphs. Which tab and group will help in doing so?
                    ________ _ _______________________________________________________________________
                                                                                            120  Plus (Ver. 2.2)-V
                    ________ _ _______________________________________________________________________
                                                                                              https://www
                   34
                    Plus (Ver. 2.2)-V
   2   3   4   5   6   7   8   9   10   11   12