Saturday, September 12, 2026

VIII IT Worksheet1 Solutions

 

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.

No comments:

Post a Comment