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