Page 7 - 2422_C1_Flipbook
P. 7

Assessment Resources





                                                                        TesT Your skills
                                                           1.  Tick ( ) the correct answer
                           Sheet Tab
                                                              a.  An active cell has a ____________ border around it.  Test Your Skills contains
                                                            (i) Green      (ii) Blue
                                                                             (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?
                         tabs show the number of worksheets in a workbook and the Active Sheet (currently open
                                                            (i) A:3:F9
                         plus sign on the right of the sheet tab.     (ii) C20:E28       variety of exercises to
                         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
                                                            (i) Esc key      (ii) Enter key
                          Row and Columns                     d.  The keyboard shortcut to copy and paste cell contents is:     (iii) F2 key   reinforce the concepts.
                                                            (i) Ctrl + Z & Ctrl + V      (ii) Ctrl + C & Shift + V

                                                              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
                                                             b.  You cannot select a range using a mouse.
                        its thick green border. You can type data into an active cell only.
                         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 U P                   e.  Moving the cells data means deleting it from original position.
                                                          4.  Answer the following questions:
                        Match the following.
                                                             a.  What is the use of Redo command?
                        1.  Row Header
                              a.  Address of the active cell
                        2. Column Header                    ___________________________________________________________________________
                              b.  Displays content of active cell                        Tech Practice is a lab
                        3. Sheet Tab                        ___________________________________________________________________________
                              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.
                         Let's Catch Up           Tech Zone contains                      (Subject Enrichment)
                        recalls a part of           sections such as                                         Century  21 st  Skills  #Creativity
                                                                                             Tech PracTice
                         lesson quickly.           Let's Explore, Let's                     Draw a poster of 'Save the Environment' using Paint application in your computer.
                                                                                            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              SDG Activity shows                                  For The Teacher
                                               how students use digital                         Explain the concept of information processing to students.
                                                                                                 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
                     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  the SDGs.
                     1.   Prepare a presentation on the following topics:
                         a.  Life cycle of butterfly  Skills
                         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   assessment to develop
                                                          (i) Calculator      (ii) Abacus
                                                         2.  Mark-I was built in ____________.
                         Four Periodic                       3.  Which of these is not an option in the suggestion box?     (iii) 1940   practical proficiency.
                                                                  (ii) 1948

                                                          (i) 1944
                                                                  (ii) Ignore All

                 Assessments for evaluation.               4.  Which of these is not a page orientation in Word?       (iii) Add all
                                                          (i) Change
                                                                        (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.  B.  Fill in the blanks.
                     1.   Charles Babbage
                                                          1.  Transistors and magnetic tapes were used in ____________ generation.  B.  Create the following in Excel.  Century  21 st
                     2.  John Mauchly       _____________________________                                      Skills  #Creativity
                                                          2.  The invention of integrated circuits occurred in ____________ generation.
                     3.  Blaise Pascal      _____________________________
                                                          3.  Paper size is the actual length and width of the paper in ____________.
                     4.  Herman Hollerith      _____________________________
                                                                           Test Sheet 1
                                _____________________________              Test Sheet 1  75 75
                     5.  Gottfried Wilhelm Leibniz   _____________________________
                    C. Write 'T' for true and 'F' for false.
                     1.   Paragraph spacing cannot be changed in a document.
                                                  Two Test Sheets                            C.   Create similar PowerPoint presentation on Global   21 st
                     2.  Line spacing can be changed in a document.
                     3.  The header is placed at the bottom of a page.
                                                                                              Warming.
                                                                                                            Century
                                                                                                            Skills  #Leadership & Responsibility
                                                  have questions to                        https://www            https://www
                     4.  Abacus is used to calculate numbers at low speed.
                     5.  Herman Hollerith developed the Tabulating Machine in 1890.
                                                   assess students.
                    D.  Competency-based/Application-based question.
                      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