Answers to the questions..
WORKSHEET–1 — ANSWERS
A. Select the correct option
An if statement within another if statement is called
(d) Nested if
The Excel feature that recognises a data pattern and fills other cells with the same pattern is
(a) Flash Fill
The number 12 in the hexadecimal number system is denoted by
(b) C
Operators that combine two expressions involving relational operators are
(a) Logical
The area bounded by the two axes in a chart is called
(c) Plot Area
B. Fill in the blanks
The Format Painter lets you copy formatting from one cell to another cell.
The values on which operators perform tasks are called Operands.
A compact chart that visualises a row or column of data and fits inside a single cell is called a Sparkline.
The starting of text at a position away from the margin in Python is called Indentation.
A digital computer represents data and information using the Binary number system.
C. Write T for True and F for False
A Radar chart represents data in the form of a circle divided into various sectors.
F — This description is of a Pie chart.
The Logical operator OR returns False if any one of the expressions evaluates to False.
F — OR returns False only when all expressions are False.
The base of a number system is also called its Radix.
T
Every if statement must have a corresponding else statement.
F — An else statement is optional.
Conditional formatting makes it easy to highlight certain values.
T
D. Perform the following operations
1. Convert decimal 73 into binary
73 = 64 + 8 + 1
Therefore:
73₁₀ = 1001001₂
2. Convert binary 10101110 into decimal
= 128 + 32 + 8 + 4 + 2
= 174
10101110₂ = 174₁₀
3. Add 101101 and 111001
101101
+ 111001
--------
1100110
Answer: 1100110₂
4. Divide 101010 by 111
101010₂ = 42₁₀
111₂ = 7₁₀
42 ÷ 7 = 6
6₁₀ = 110₂
Answer: 110₂
5. Subtract 11001 from 111010
111010₂ = 58₁₀
11001₂ = 25₁₀
58 − 25 = 33
33₁₀ = 100001₂
Answer: 100001₂
E. Write the output of the expressions/code in Python
1. String multiplication
The expression involving:
"Ha!" * 4
produces:
Ha!Ha!Ha!Ha!
2. Logical expression
(True and False) or (True and not(False))
Step-by-step:
True and False → False
not(False) → True
True and True → True
False or True → True
Output: True
3. Arithmetic expression
For the expression shown in the image:
11 - (50 - 2) + 40 % 8
50 − 2 = 48
40 % 8 = 0
11 − 48 + 0 = −37
Output: -37
4. If–else program
The program checks whether x > 30. For the value shown (x = 30), the condition is false.
Output:
You have a small number
F. Identify the errors and write the correct code
Correct program
# Program to accept two numbers and display the smaller number
Num1 = int(input("Enter first number: "))
Num2 = int(input("Enter second number: "))
if Num1 > Num2:
print("Second number is smaller")
else:
print("First number is smaller")
Main errors in the given program
Num2 = print(...) should be Num2 = input(...).
The inputs should be converted to integers using int().
num2 and Num2 are different variable names in Python.
or: should be else:.
The statements inside if and else need proper indentation.
G. Answer the following questions in brief
1. Explain the working of the if...else statement in Python with an example.
The if...else statement is used to make a decision.
If the condition is True, the if block executes.
If the condition is False, the else block executes.
Example:
age = 18
if age >= 18:
print("Eligible")
else:
print("Not eligible")
Output:
Eligible
2. Difference between face value and place value
Face value: The actual value of a digit, regardless of its position.
Place value: The value of a digit according to its position in a number.
Example: In 5,432
Face value of 5 = 5
Place value of 5 = 5,000
3. Difference between division and modulus operators in Python
Operator
Name
Purpose
Example
/
Division
Gives quotient, usually as a decimal
10 / 3 = 3.333...
%
Modulus
Gives remainder
10 % 3 = 1
4. Name any five types of charts available in Excel 2019.
Any five:
Column Chart
Bar Chart
Line Chart
Pie Chart
Scatter Chart
Other examples include Area, Radar, Doughnut and Stock charts.
H. Answer the following questions
1. What are Conditional Statements? Write the syntax of any two Conditional Statements in Python.
Conditional statements are statements used to make decisions in a program based on whether a condition is True or False.
(a) if statement
Syntax:
if condition:
statement
Example:
marks = 80
if marks >= 40:
print("Pass")
(b) if...else statement
Syntax:
if condition:
statement1
else:
statement2
Example:
marks = 35
if marks >= 40:
print("Pass")
else:
print("Fail")
2. What is a data type? Explain common data types available in Python with examples.
A data type specifies the kind of value that a variable stores.
Common Python data types are:
Data Type
Meaning
Example
int
Integer/whole number
age = 15
float
Decimal number
price = 25.50
str
Text/string
name = "Rahul"
bool
True or False
passed = True
list
Collection of values
marks = [80, 75, 90]
For example:
age = 15
height = 5.6
name = "Aman"
passed = True
marks = [80, 75, 90]
3. Write a short note on the Binary Number System.
The binary number system is a number system with base 2. It uses only two digits:
0 and 1
Computers use the binary number system because electronic circuits can conveniently represent two states, such as ON/OFF.
The positions in a binary number have powers of 2.
For example:
1011₂
means:
= 8 + 0 + 2 + 1
= 11₁₀
Thus, 1011₂ = 11₁₀.
4. What do you mean by sorting data? Write the steps to sort data on multiple columns in a worksheet.
Sorting data means arranging data in a particular order, such as:
Ascending order
Descending order
Alphabetical order
Numerical order
Steps to sort data on multiple columns in Excel
Select the entire data range.
Go to the Data tab.
Click Sort.
Select the first column in Sort by.
Select the required order, such as A to Z or Smallest to Largest.
Click Add Level.
Select the second column.
Select its required sorting order.
Add more levels if required.
Click OK.
Excel will arrange the data according to the first column and then use the second/third columns to further arrange records.
Quick Answer Key
A: 1-d, 2-a, 3-b, 4-a, 5-c
B: Format Painter, Operands, Sparkline, Indentation, Binary
C: F, F, T, F, T
D: 1001001, 174, 1100110, 110, 100001
E: Ha!Ha!Ha!Ha!, True, -37, You have a small number
Would you like the answers formatted as a clean school answer sheet or a teacher marking key?
A. Tick (✓) the correct option
b. To maintain
b. Natural Language Processing
c. Learning the algorithm
c. Zero hunger
b. It is expensive and time-consuming to collect.
d. MATLAB (Note: Standard curriculum lists Excel, Power BI, and Tableau Public as primary visualization tools).
a. Supervised learning
b. Reinforced learning
B. State whether these statements are true or false
True — Evaluation tests the trained model against test/new data to check accuracy.
False — Systems thinking considers the entire system and interconnections, not just isolated parts.
False — Sustainability is about using resources responsibly without depleting them for future generations.
True — Pollution harms marine life and coral ecosystems.
False — Testing happens during the Evaluation stage; Data Acquisition focuses on gathering data.
True — Secondary data is second-hand data collected by someone else.
True — Different AI problems require distinct data types (text, audio, image, tabular).
True — Exploring and understanding data quality is essential before training.
C. Fill in the blanks
arrows
6
Data (Note: Standard AI domains are Data, Computer Vision, and Natural Language Processing; Machine Learning is an AI subfield/approach).
United Nations
Audio
Modelling
Primary
Textual (or Text)
D. Answer the following questions
1. What does a system map represent?
A system map visually represents components within a system, showing their relationships, interconnections, and how they influence each other using directed arrows.
2. What is meant by model training in AI project cycle?
Model training is the stage where an AI algorithm processes training dataset to learn patterns, correlations, and rules so it can make accurate predictions on new data.
3. How does society contribute to sustainability?
Society contributes by adopting eco-friendly practices such as reducing waste, conserving energy and water, using renewable resources, and supporting sustainable products and policies.
4. Why is evaluation important in the AI project cycle?
Evaluation measures the accuracy and reliability of the model on unseen data, ensuring it meets performance standards before deployment and prevents errors or bias.
5. What is the role of Data Acquisition in an AI project?
Data Acquisition involves collecting relevant, reliable, and high-quality data from various primary or secondary sources to serve as the input for training and testing the AI model.
6. What are rule-based AI and learning-based AI?
Rule-based AI: Operates on explicitly coded logic and developer-defined rules ("If-Then" statements) without learning independently.
Learning-based AI: Uses algorithms that analyze data patterns to learn, adapt, and make decisions dynamically without explicit programming for every scenario.
7. What happens during the evaluation stage of an AI project?
The trained model is tested using a separate evaluation/test dataset to calculate metrics like accuracy, precision, and recall, identifying model weaknesses or errors.
8. Explain the term Modelling.
Modelling is the process of selecting and implementing suitable machine learning or deep learning algorithms to construct a mathematical representation capable of solving the defined AI problem.
WORKSHEET–1 — ANSWERS
A. Select the correct option
The <dl> and </dl> tags are used to create a(n) Description list.
Answer: (c) Description list
The data type that increments automatically when a new record is added to the table is AutoNumber.
Answer: (d) AutoNumber
The Subtotal command is available in the Outline group on the Data tab.
Answer: (b) Outline
A network that covers a region of an entire city is MAN.
Answer: (c) MAN
You can create a form for a table with pre-designed layouts by using the Form Wizard.
Answer: (a) Form Wizard
B. Fill in the blanks
A key symbol in the Row selector of a table design indicates that the field is the table's Primary Key.
Data Validation in Excel restricts the type of values that can be entered in a cell.
The data retrieved by a Query is displayed in the Datasheet view in Access.
The list-style-type property specifies the type of bullet for the list item marker in an unordered list.
In Mesh topology, each node is connected to every other node in the network.
C. Write T for True and F for False
Split form creates a new form that shows both the form and the Datasheet view.
T
An unordered list uses numbers or alphabet to mark each item in the list.
F — An unordered list normally uses bullets.
Cable television network is an example of a LAN.
F — A cable television network is not classified as a LAN.
You can create only one scenario for data in a worksheet.
F — Multiple scenarios can be created using Scenario Manager.
A Relational database stores data in the forms of tables.
T
D. Answer in one word
A computer network limited to use by an individual.
PAN
A database object that is used to extract information from a database table.
Query
A device or software that provides services to other devices or software applications on a network.
Server
A list that contains another list within it.
Nested list
A unique address assigned to every device connected to a network.
IP address
E. Write the function of each network device
1. Hub
A hub connects multiple devices in a network and broadcasts the received data to all connected devices.
2. Switch
A switch connects devices in a network and forwards data only to the intended device.
3. Router
A router connects different networks and directs data packets between them.
4. Modem
A modem converts digital signals into signals suitable for transmission and converts incoming signals back into digital form.
5. NIC
A Network Interface Card (NIC) enables a computer or device to connect to a network.
F. Give two examples
1. Network devices
Switch
Router
2. Types of Lists in HTML5
Ordered list (<ol>)
Unordered list (<ul>)
3. Wired transmission media
Twisted-pair cable
Coaxial cable
4. Network protocols
TCP/IP
FTP
5. Wireless transmission media
Wi-Fi
Bluetooth
G. Identify errors and write the correct HTML5 code
Correct code:
<!DOCTYPE html>
<html>
<head>
<title>Machine Learning</title>
</head>
<body>
<h2>Types of Machine Learning</h2>
<p>Machine Learning approaches can be classified as follows:</p>
<ul>
<li>Supervised Learning</li>
<li>Unsupervised Learning</li>
<li>Semi-supervised Learning</li>
<li>Reinforcement Learning</li>
</ul>
</body>
</html>
HTML
Main errors in the given code
<!DOCTYPE CSS> should be <!DOCTYPE html>.
The <title> tag is incorrectly written.
<ul> is missing before the list items.
<td> before Unsupervised Learning is incorrect; it should be <li>.
The list should be properly closed with </ul>.
The <body> tag should be properly closed with </body>.
H. Answer briefly
1. What is a description list? Write the tags used to create a description list.
A description list is a list used to display terms and their descriptions.
The tags used are:
<dl> — Description List
<dt> — Description Term
<dd> — Description Details
Example:
HTML
<dl>
<dt>HTML</dt>
<dd>HyperText Markup Language</dd>
</dl>
2. What is a Pivot Table?
A Pivot Table is an Excel tool used to summarize, analyze and present large amounts of data in a meaningful way.
3. State three limitations of computer networks.
Security risks — Data may be accessed by unauthorized users.
Network failure — If the network fails, communication and resource sharing may stop.
High setup and maintenance cost — Networks require hardware, software and maintenance.
4. Differentiate between an ordered list and an unordered list.
Ordered List
Unordered List
Items are displayed in a specific sequence.
Items do not have a specific sequence.
Uses numbers or letters as markers.
Uses bullets as markers.
Created using <ol>.
Created using <ul>.
5. Name the various database objects available in Access 2019.
The main database objects in Access 2019 are:
Tables
Queries
Forms
Reports
Macros
Modules
I. Answer the following questions
1. What is a Scenario in Excel? What is the function of Scenario Manager?
A Scenario is a set of values used in a worksheet to analyze different possible outcomes.
Scenario Manager is a What-If Analysis tool in Excel that allows us to create, save, compare and switch between different sets of input values.
For example, we can create scenarios such as Best Case, Normal Case and Worst Case.
2. What is a topology? Explain any three topologies in computer networks.
A network topology is the physical or logical arrangement of computers and other devices in a network.
a. Bus Topology
All devices are connected to a single main cable, called the backbone.
b. Star Topology
All devices are connected to a central device, such as a switch or hub.
c. Mesh Topology
In a mesh topology, devices are connected to multiple or all other devices. In a full mesh, every node is directly connected to every other node.
3. Describe the various tags used to create a table in an HTML document.
The main HTML tags used to create a table are:
<table> — Creates the table.
<tr> — Creates a table row.
<th> — Creates a table heading/cell.
<td> — Creates a table data cell.
<caption> — Adds a caption/title to the table.
Example:
HTML
<table>
<caption>Student Details</caption>
<tr>
<th>Name</th>
<th>Class</th>
</tr>
<tr>
<td>Ali</td>
<td>VII</td>
</tr>
</table>
4. What is a Query? Write the steps to create a query using Query Design.
A Query is a database object used to retrieve specific information from one or more tables according to given conditions.
Steps to create a query using Query Design:
Open the database in MS Access.
Click the Create tab.
Click Query Design.
Select the required table or tables.
Click Add and then close the Show Table window.
Select the required fields.
Enter conditions in the Criteria row if required.
Click Run (!) to execute the query.
Save the query with an appropriate name.
5. Describe any five field properties associated with different data types in Access 2019.
1. Field Size
Specifies the maximum size or range of data that can be stored in a field.
2. Format
Specifies how the data is displayed.
3. Input Mask
Defines a pattern that controls how data is entered into a field.
4. Default Value
Specifies a value that is automatically entered when a new record is created.
5. Validation Rule
Specifies a condition that the entered data must satisfy.
Example:
For an Age field, the validation rule can be:
>=18
This allows only values of 18 or above.
A number system is a way of writing and representing numbers using symbols or digits.
For example, the decimal number system is the one we use in everyday life. It uses 10 digits: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9.
In computers, common number systems are:
| Number system | Base | Digits used | Example |
|---|---|---|---|
| Binary | 2 | 0, 1 | 1010 |
| Octal | 8 | 0–7 | 157 |
| Decimal | 10 | 0–9 | 245 |
| Hexadecimal | 16 | 0–9, A–F | 2AF |
Simple definition: A number system is a method used to represent numbers using a set of digits according to certain rules.
We normally use the decimal number system, which has base 10.
The digits are:
0, 1, 2, 3, 4, 5, 6, 7, 8, 9
Consider 345:
So, 10 is the radix/base.
Base = number of symbols available in the number system.