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.

