Page 7 - Trackpad_ipro 4.1_Class8
P. 7

Assessment Resources






                              Section A (Objective)                      2.  You went to your father’s office with him. While there, you saw a scanner.
                                                                           What do you think the scanner is used for in the office?
                  One Touch  Learn
                   1.   Anshu wants to display the steps of a sweet dish recipe on a web page. Which type of list
                  One
                  A.  Tick ( ) the correct option.                       Crack The  Code  #Coding & Computational Thinking
                     will you suggest him to do so?       c. Unordered List   Fill in the crossword with the help of pictures given as hints.
                           d. None of these
                     a. Ordered List
                   b. Description
                           c. <LI>
                     2.  Which of the following tags is used to define an item in a list?  C  M

                             d. <UL>                                               I  R
                   a. <IL>
                     3.   Amita wants to display the items of the list with upper Roman numerals. Which option   K  M
                      b. <OL>                                               P
                      should she use to achieve this?     c. TYPE="IV"
                    a. TYPE="a"        d. TYPE="*"      4.  ................................ is used to sort the data either in ascending or descending order.  S  P
                                                 5.  ................................ buttons are used to navigate through the records.  M  R  S
                    b. TYPE="I"
                      4.  Which of the following tag defines the description term?  C.  Write ‘T’ for true and ‘F’ for false.  ................................  S  A
                            c. <DT>

                             d. <LI>           1.  Flat file database and relational database are the two types of databases.   ................................  D
                      a. <DD>                    2.  Navigation Pane is present on the right side of the Access window.   ................................  E
                    b. <DL>
                      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.   ................................     Worksheet 1
                            c. <TH>

                                                                                                       1.  Disk Drive
                                                                                                            (Based on chapters 1 to 6)
                            d. <TD>              4.  Field names can begin with an underscore ( _ ).   A.  Give two examples of each of the following:
                      a. <TR>      ................................                                        2.  Port  -   ................................
                     b. <CAPTION>
                    B.  Write ‘T’ for true and ‘F’ for false.  ................................  Let's Do  It  Section B (Subjective)  SDG Activity     3.  Number System   -  -   ................................   ................................

                    1.  An ordered list is also called the numbered list.
                                 ................................
                                                                                                      4.  Computer Viruses
                                                                          Planting seeds is the “input” stage where you put effort into the
                       2.  <OL TYPE ="1" START=”25”> will start the list from 24.   ................................  A.  Write a short note on the following:  4.  Form   Your school took you to a community garden to plant seeds.        5.  Unethical Practices    -   ................................   ................................
                       3.  Rectangle is one of the values of the TYPE attribute in unordered list.    ................................     1.  Primary Key   2.  Report    3.  Query   soil. As the plants grow and produce vegetables or fruits, this   6.  Components of MS Excel   -   ................................   ................................
                       4.  Tables represent the data in the form of rows.   B.  Short answer type questions:  is the “output.” Explain how your small effort in planting helps      B.  Define the following terms:  -   ................................   ................................
                    C.  Fill in the blanks using the words given below:   .  C.  Long answer type questions:  33    C.  Guess! Who am I?  2.  Radix   ................................
                       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?  everyone have more food and supports those in need.     1.  Hardware   ................................   ................................
                                               2.  Write the names of any four data types in Access.


                                                                                                      4.  Cyber Crime
                         disc, TYPE, <TH>, border-style, Table Data , START
                        Hints
                                               1.  What are the advantages of the Database Management System?
                                                                                                            5.  Cell Range
                                                                                                                  3.  Antivirus
                     1.  The <OL> tag has two attributes named    in HTML.   and        2.  Explain the types of views in a database.  Input and Output Devices     1.  I am the brain of a computer that does all the calculations and runs  6.  AutoFill
                                                                                                      all the programs.
                                               3.  What are the naming conventions for writing a field name in a database?
                          2.  The default bullet style is     D.  Application-based questions.           3.  I am a digital video camera connected to a computer.   ................................
                                                                                                      power supply.
                                                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.  ................................
                                                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

                     116
                                                that can help him do this.
                                                                                                     4.  I am a group of 8 digits, either 0 or 1.
                                                                                                      (Based on chapters 1 to 6)
                                                                                                                  ................................
                                                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
                                                                                                                  ................................
                                                is Sarah most likely to use track her monthly expenses, and can you name an
                      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   ................................
                                                                                                     other unwanted actions on a computer system.
                                                                                                     5.  I am a type of malicious program designed to damage or carry out
                                                                                                            Section A
                                                example of this type of database?
                                                                                                     leave when they use the internet.
                                                                                                                  ................................
                                                                                                     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
                                                                                                     that displays the current workbook's name.
                                                                                                     c. Printer
                       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   ................................

                                                                                                     7.  I am a long horizontal bar located at the top of the Excel window
                                                                                                     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.  ................................
                                                                                                     a. 1 and 2
                                                                                                             d. None of these
                                                                                                    c. 0 and 1


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

                                                                                                    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
                                                                                                    4.  What will be the result after subtracting the binary number (1101) 2  from (100110) 2 ?
                                                                                                            b. 11001

                                                                                                                Worksheet 1
                                                                                                            d. 11111
                                                                                                     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                                          8.  What are the horizontal divisions in a worksheet called?
                                                                                                   a. Digital Diary
                                                                                                   Worksheets & 2

                                                                                                   c. Digital Dossier
                                                                                                           b. Database

                                                                                                   a. Rows
                                                                                                           d. None of these
                                                 subjective type                                 78  c. Grid          b. Columns
                                                                                                   Test Sheets are
                                                                                                          d. None of these
                                                                                                   iPro (Ver. 4.1)-VII
                                                    questions.                                  included to evaluate
                                                                                                 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
                                                                                                   Crack The  Code  #Problem Solving & Logical Reasoning
                   different web pages. Write the HTML code to create this.
                  Higher Order Thinking Skills (HOTS)
                   how lists, radio buttons, and checkboxes are displayed and used on these two
                                                                                                            #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  J  C  O  R
                                             A.   Create a worksheet in Excel as shown below.  #Problem Solving & Logical Reasoning  J  B  O  R  D  E  R  H O  R  F
                                                       #Creativity & Innovativeness
                                                                                                       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?
                    2.   Arnav created a page webpage using HTML. He added an image in it. Some portions of the
                 <HTML>                                                                             SDG Activity
                                                                       20  iPro (Ver. 4.1)-VII
                                              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
                   <HEAD> <TITLE> Inserting Image </TITLE>
                 </HEAD>                      2.    Find the number of matches lost by each team by using the subtraction formula.  education for all students. You have been asked to research and
                   <BODY>                                                                          identify  various methods  to achieve this  goal and  present  your
                                              3.    Compare the performance of India and Pakistan by checking if India won more matches than
                                                                                                   findings in a list format on an HTML web page.
                                              Pakistan.
                                                4.    Calculate the win percentage of each team.  Fun in Lab: This
                 <B> Inserting image on the web page </B>
                144                                    #Coding & Computational Thinking                     #Digital Literacy
                                                       #Problem Solving & Logical Reasoning
                                             B.
                                              Enter the following data in Excel:
                 iPro (Ver. 4.1)-VII
                                                                      is a lab activity to           Create this table in HTML.
                                                                                                          Marks in
                                                                                                   No.  Name of Student  Total
                                                                                                        English  Maths  Science
                                                                                                   1  Suman  84  96  81  271
                                                                                                   2  Aryan  68  94  89
                                                                      develop practical            3  Naveen  71  83  73  251 227
               HOTS: This section
                                                                                                   4  Vinod
                                             Perform the following tasks:                               55  65  86  206
                                                1.  C2   =(A2*B2)                                  5  Sonia  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