Page 7 - Trackpad_ipro 4.1_Class6
P. 7

Assessment Resources






                                                                                   #Coding & Computational Thinking
                              Section A (Objective)                     1.    Samira needs to transfer photos from her camera to a computer. Which hardware device is best
                                                                        Higher Order Thinking Skills (HOTS)
                   1.   Anshu wants to display the steps of a sweet dish recipe on a web page. Which type of list
                  One Touch  Learn                                      2.    Vaidik wants to give a presentation in his school on “Environment Literacy”. How should he
                                                                         suited for her?
                  One
                  A.  Tick ( ) the correct option.                       present it in front of audience, so that everyone is able to see and hear properly?
                     will you suggest him to do so?       c. Unordered List   Crack The  Code  #Experiential Learning
                           d. None of these
                     a. Ordered List                                     Find six terms related to internal hardware components of a computer in the grid.
                   b. Description
                                                                                    S
                           c. <LI>
                     2.  Which of the following tags is used to define an item in a list?  P  A  P  E  A  U  B  V  S O  M N  P D  O

                           d. <UL>                                           R  M O  D  E  M  E  I  R  F  A  U

                   a. <IL>
                     3.   Amita wants to display the items of the list with upper Roman numerals. Which option   I  M  R  O  Z  N R  A L  D E  Q  L  T  N
                      b. <OL>                                                M  T  T T  U H  V E  R  B  O  A  R  D  D C
                      should she use to achieve this?     c. TYPE="IV"   4.  ................................ is used to sort the data either in ascending or descending order.  M O R  Z  Y  U  M  P  T  C  F B  Q Q  B A  A
                      a. TYPE="a"        d. TYPE="*"      5.  ................................ buttons are used to navigate through the records.  A  L  M U  S V  I O  E R  O B  A R  Z  R  S  R D
                    b. TYPE="I"
                            c. <DT>
                      4.  Which of the following tag defines the description term?     K E  S L  L  O  C  T  L  D  A  F  E
                                               1.  Flat file database and relational database are the two types of databases.

                            d. <LI>           C.  Write ‘T’ for true and ‘F’ for false.  ................................  #Communication
                      a. <DD>                      2.  Navigation Pane is present on the right side of the Access window.   ................................  Hands On  #Art Integration
                                                            ................................
                    b. <DL>
                            c. <TH>
                      5.  Which of the following tags is used to give the title of the table?     3.  The maximum size of the Number data type is 32 bytes.   ................................  Take chart paper and make a hierarchy chart to display the hardware components of the computer      Worksheet 1

                                                                          come under these categories. After completing the chart, display and explain it in front of your
                              d. <TD>            4.  Field names can begin with an underscore ( _ ).   system with their categories, such as internal and external. Paste some pictures of devices which      A.  Give two examples of each of the following:
                                                                                                            (Based on chapters 1 to 6)
                                                                                                       1.  Disk Drive
                      a. <TR>    ................................                                        2.  Port  -
                    B.  Write ‘T’ for true and ‘F’ for false.  ................................  Let's Do  It     4.  Computer Viruses   -   ................................   ................................
                       b. <CAPTION>   ................................  Section B (Subjective)  class.  #Digital Literacy  3.  Number System   -   ................................
                    1.  An ordered list is also called the numbered list.
                       2.  <OL TYPE ="1" START=”25”> will start the list from 24.   ................................  A.  Write a short note on the following:  3.  Query   4.  Form   Visit your school laboratory and list the types of devices connected to the computers and        5.  Unethical Practices    -   ................................   ................................
                                                                                                             ................................
                       3.  Rectangle is one of the values of the TYPE attribute in unordered list.    ................................     1.  Primary Key   2.  Report    6.  Components of MS Excel   -   ................................
                       4.  Tables represent the data in the form of rows.   B.  Short answer type questions:  paste their pictures in your notebook.   B.  Define the following terms:  -   ................................   ................................
                       5.  The border-color property allows you to apply a colour to the border.      1.  What is the process of adding and deleting the records from the database?       1.  Hardware   ................................   ................................
                    C.  Fill in the blanks using the words given below:   .  C.  Long answer type questions:  1.  Do a walk-through of all the topics covered in this chapter.    C.  Guess! Who am I?  2.  Radix   ................................
                                               2.  Write the names of any four data types in Access.
                                                                          Teacher's Corner


                                                                                                      4.  Cyber Crime
                         disc, TYPE, <TH>, border-style, Table Data , START
                                                                          2.  Discuss with the students about all the hardware components of the computer system.
                                                                          3.  Show the components of an old CPU box and their placement on the motherboard to the students.
                        Hints
                                               1.  What are the advantages of the Database Management System?
                                                                                                            5.  Cell Range
                                                                                                                  3.  Antivirus
                                               3.  What are the naming conventions for writing a field name in a database?
                                                                                                      all the programs.
                     1.  The <OL> tag has two attributes named    in HTML.   and          2.  Explain the types of views in a database.  20  iPro (Ver. 4.1)-VII     1.  I am the brain of a computer that does all the calculations and runs  6.  AutoFill
                                                                                                      power supply.
                          2.  The default bullet style is   D.  Application-based questions.             3.  I am a digital video camera connected to a computer.   ................................
                                                1.   Ranjeet  is  working  on  a  database  of  a  school.  He  wants  to  view  all  the  records  in  a
                    One Touch Learn:              2.   Jennifer is a student who wants to keep track of her monthly expenses. She   Crack the Code: This     A.  Tick (3) the correct option.  Section A  ................................
                                                sequential manner either in ascending or descending order. Suggest a feature of Access
                                                                                                      Test Sheet 1
                                                                                                     2.  I am a hardware component of the computer used to control the


                      iPro (Ver. 4.1)-VII

                                                that can help him do this.
                     116
                                                                                                      (Based on chapters 1 to 6)
                                                                                                     4.  I am a group of 8 digits, either 0 or 1.
                                                                                                                  ................................
                                                decides to use a computer program that allows her to create a database with
                                                                                                                  ................................
                                                columns like 'Date', 'Item', 'Amount', and 'Category'. Which type of database
                      This section has         Higher Order Thinking Skills (HOTS)  #Interdisciplinary  section has a puzzle                8.  I am a symbol or sign used to start formula in Excel.  b. Speakers   ................................
                                                is Sarah most likely to use track her monthly expenses, and can you name an
                                                                                                     5.  I am a type of malicious program designed to damage or carry out
                                                                                                     other unwanted actions on a computer system.
                                                                                                     leave when they use the internet.
                                                example of this type of database?
                                                                                                                  ................................
                                                                                                     6.  I am used for describing the mark, traces or "footprints" that people
                                                                                                     a. Projector
                                                1.   To  determine  which  students  scored  above  90%  on  their  last  computer  test,  which
                                                                                                     c. Printer

                                                                                                     that displays the current workbook's name.
                                                                                                     7.  I am a long horizontal bar located at the top of the Excel window
                       objective based            2.   When entering details about new students into an Access 2019 table, where within the   or fun based activity          D.  Write the names of the following devices:         b. Wrap Text   ................................
                                                                                                     1.  What projects the output from the computer screen to a larger screen?

                                                database object should be used to retrieve this information?

                                                                                                             d. Monitor
                                                                                                     a. AutoFill
                                                Access window should the student information be typed?
                                                                                                                 ................................

                                                                                                     c. Cell Fill
                                                                                                     2.  Which feature automatically fills a series of data in your worksheet?
                       quick questions.                  Database and DBMS—An Introduction  91  to help understand               1.  ................................      2.  ................................  d. 5 and 6   3.  ................................
                                                                                                             d. None of these
                                                                                                     a. 1 and 2


                                                                                                    c. 0 and 1
                                                                                                            b. 8 and 9
                                                                                                    3.  Which of the following are the two symbols present in the binary number system?

                                                                                                    a. 10000
                                                                          the concepts better.          5.  Which of the following is a type of computer virus that is transmitted from one computer  77

                                                                                                    c. 11100
                                                                                                            b. 11001

                                                                                                    4.  What will be the result after subtracting the binary number (1101) 2  from (100110) 2 ?
                                                                                                            d. 11111
                                                                                                                Worksheet 1
                                                                                                     Worksheet &
                                                                                                    a. E-mail
                                                                                                    to another through e-mail messages?
                                                                                                       c. File-infecting
                                                                                                             b. Boot sector
                                                                                                     6.  Which of the following is not a malware?  d. Norton
                                                   Let’s Do It:                                          7.  Which of the following is also known as a "digital footprint"?
                                                                                                   a. Rootkit
                                                                                                    Test Sheet: 2

                                                                                                   c. Ransomware
                                                                                                           b. Worm

                                                                                                           d. Freeware
                                                 This section has                                         a. Digital Diary         b. Database
                                                                                                   Worksheets & 2
                                                                                                   c. Digital Dossier
                                                                                                   a. Rows
                                                                                                           d. None of these
                                                                                                    8.  What are the horizontal divisions in a worksheet called?
                                                                                                   c. Grid

                                                 subjective type                                included to evaluate
                                                                                                   Test Sheets are
                                                                                                          b. Columns

                                                                                                 78
                                                                                                          d. None of these
                                                                                                   iPro (Ver. 4.1)-VII
                                                    questions.                                   the knowledge of
                                                                                                   the students.
                                                                        Hands On
                                                                                  #Communication
                                                                                  #Art Integration
                                                                        Take chart paper and make a hierarchy chart to display the hardware components of the computer
                                                                        class. system with their categories, such as internal and external. Paste some pictures of devices which
                                                                        come under these categories. After completing the chart, display and explain it in front of your
                     B.  Long answer type questions.
                    element.                                                      #Digital Literacy
                      1.   Explain the purpose and functionality of the controls attribute when used in the <video>

                      3.  Why do we use frames in HTML?                 Visit your school laboratory and list the types of devices connected to the computers and
                                                                        paste their pictures in your notebook.
                    2.  How can you open a link in a new browser window/tab using HTML?
                      C.  Application-based questions.
                                                                        Teacher's Corner
                   4.  Explain in simple steps how different values can be added to a CHECK BOX.
                    materials.                                          1.  Do a walk-through of all the topics covered in this chapter.
                     2.   You want to view two web pages on a single screen in a web browser. Show   2.  Discuss with the students about all the hardware components of the computer system.
                   1.   You are developing an online learning platform where students can access courses,
                                                                        3.  Show the components of an old CPU box and their placement on the motherboard to the students.
                    resources and discussions. Consider incorporating internal links within courses, external
                    links to additional resources and internal links for easy navigation within lengthy course
                   different web pages. Write the HTML code to create this.
                                                                                                   Crack The  Code  #Problem Solving & Logical Reasoning
                   how lists, radio buttons, and checkboxes are displayed and used on these two
                  Higher Order Thinking Skills (HOTS)
                                                                                                            #Experiential Learning
                             #Coding & Computational Thinking
                                                                                                   Find nine HTML attributes used while creating lists and tables from this grid.
                                                                                                       D  I  Y  B  E  S  B  S  R  E  J
                  create this webpage.
                  1.   Suppose, you are a web developer. You got a project to design a webpage as shown in the
                                                  PROJECT WORK                                         R F  S D  T Y  A C  Q R  A T  O R  O Y  E F  D H  B C
                   given image. In it you have to move both the bullet points to move from left to right direction
                  on the screen. You decided to create this webpage using HTML code. Write the code to
                                                                                                       G O  P
                                                                                                         K W R  D  K  D  I  D
                                                                                                       H N  E  G  R  E  E
                                                       #Problem Solving & Logical Reasoning                J  C  O  R
                                             A.
                                                       #Creativity & Innovativeness                    J  B  O  R  D  E  R  H O  R  F
                                              Create a worksheet in Excel as shown below.
                                                                                                       I
                                                                                                       O O O  B  G  C  O  L  O  R
                                                                                                       R  T  N U  F  T  O  G  S  W G
                                                                                                       U W E  N  S  U  L  D  P  S  I
                                                                                                       D W  I  D  T  H O  Z  A  P M
                                                                                                       O  A  F  U  Z  E  R  C  N  A  J
                                                                                                       P  N G  I  R  I  F  B  E  N G
                                                                                                       Q  T  T  H H  G  A  H  R  F  X
                 work properly?
                    <HTML>                                                                          SDG Activity
                                                                       20  iPro (Ver. 4.1)-VII
                 2.   Arnav created a page webpage using HTML. He added an image in it. Some portions of the
                                              1.    Find the name of the team which has played the most matches by using the MAX() function.
                                                                                                   Your school has been assigned the task of enhancing the quality of
                 coding are not working. Can you help him to rectify the error in the code to make the code

                                                                                                   education for all students. You have been asked to research and
                 </HEAD>
                                              2.    Find the number of matches lost by each team by using the subtraction formula.
                                                                                                   identify  various methods  to achieve this  goal and  present  your
                 <HEAD> <TITLE> Inserting Image </TITLE>
                 <BODY>                       3.    Compare the performance of India and Pakistan by checking if India won more matches than
                                              Pakistan.                                            findings in a list format on an HTML web page.

                                                4.    Calculate the win percentage of each team.  Fun in Lab: This
                 <B> Inserting image on the web page </B>
                                                       #Coding & Computational Thinking
                144                                    #Problem Solving & Logical Reasoning                 #Digital Literacy
                 iPro (Ver. 4.1)-VII         B.   Enter the following data in Excel:
                                                                      is a lab activity to           Create this table in HTML.
                                                                                                   No.  Name of Student  Marks in
                                                                                                        English  Maths  Total
                                                                                                   1  Suman  84  96  Science 81  271
                                                                      develop practical            2 3  Aryan  68 71  94 83  89 73  251
                                                                                                    Naveen
               HOTS: This section
                                             Perform the following tasks:                          4  Vinod  55  65  86  227 206
                                                                                                   5  Sonia
                                                1.  C2   =(A2*B2)                                       61  92  75  228
                                                2.   C3   =(A5=B3)
                                                3.  E5   =COUNT(A2:B5)      skills.                          Lists and Tables in HTML  119
             focusses on fostering
                                             142  iPro (Ver. 4.1)-VIII
                 Higher Order
                                                                                                 SDG Activity: This
               Thinking Skills in
                                          Project Work: This
                                                                                                 activity shows how
                  students.
                                            is an assessment
                                                                                                students use digital
                                            to challenge the
                                                                                               literacy to understand
                                           students to apply
                                                                                                     the SDGs.
                                          the concepts learnt.
   2   3   4   5   6   7   8   9   10   11   12