MARIST COMPREHENSIVE COLLEGE EZZAGU

PRACITIC TEST DATA PROCESSING

1. (a) Define information transmission.
(b) D ifferentiate between:
(i) . Internet and intranet;
(ii). LAN and WAN.
(c) List four devices used in a LAN environment.
2. A medium scale enterprise intends to create a database to manage its staff records
with the following fields: staff ID, Name, Address, Photograph and Department.
A). (i) What is a Database?
(ii) List three DBMS the firm can use to achieve the stated objectives.
B). (i) Mention two tasks that can be performed on staff photographs using graphic
packages.
(ii) Give three examples of graphic packages that can be used for the tasks in 2 (b)(i)
3.(a)(i)What is a presentation package?
(ii) Give two examples of presentation package.
(iii) State three features of a presentation package.
(b) Highlight the steps followed to find and replace data in MS Excel.
4. A professional photographer uses analogue cameras and a computer system for his
business. The computer is used to prepare documents and keep records of clients’
accounts. Copies of these documents are stored in CD-ROMs and Floppy disks. The
photographer now plans to innovate by using digital cameras and the computer for
taking, editing and printing photographs.
i). State two hardware changes required on the photographer’s computer to achieve
the planned innovation.
ii). Give one reason:
iii). for each of the changes in 4(a).
iv). why the photographer should use external hard disk instead of floppy disk to store
data.
(c) State two advantages of switching from analogue to digital camera.
5. A class captain was asked to create a database in MS Access for all the student in
the class without using any template and name it Student_Record. The table created is
to be named Students and should have five columns/fields with the following names:
ID_Number, FullName, Date of Birth, Age Home_Address
i). Highlight the procedures the captain will follow to create the database.
ii). List the step the captain would take to create the table in Design View.
iii). Give the data type suitable for each column/field provided.
iv). Which field can be used as the primary key?
v). Mention one importance of primary keys.
vi). List three SQL command statements the class captain can perform on the
database. 7
vii). Give the SQL query the captain will use to display all the columns in table
Students.
6. (a) Outline the steps taken in MS word to:
(i) create a table with 4 columns and 6 rows;
(ii) insert a hyperlink on a text. Figure 1 is a portion of Microsoft Word interface. Use
the figure to answer question 6(b).
 1. Information Transmission

(a) Define Information Transmission

Information transmission refers to the process of conveying data or information

from one point to another through various means or channels. This can involve the
transfer of digital data over networks, communication systems, or physical media,
ensuring that the intended message reaches its destination accurately and efficiently.

(b) Differentiation

(i) Internet vs. Intranet

 Internet: A global network of interconnected computers that communicate using

standardized protocols. It allows users to access a vast array of information and
services, including websites, email, and online applications.
 Intranet: A private network that operates within an organization, using internet
protocols to share information and resources among its members. It is not accessible
to the general public and is designed for internal communication and collaboration.

(ii) LAN vs. WAN

 LAN (Local Area Network): A network that connects computers and devices within
a limited geographical area, such as a home, school, or office building. LANs are
typically characterized by high data transfer rates and low latency.
 WAN (Wide Area Network): A network that covers a broad geographical area,
connecting multiple LANs and other networks. WANs often use leased
telecommunication lines and can span cities, countries, or even continents, typically
having lower data transfer rates compared to LANs.

(c) Four Devices Used in a LAN Environment

1. Router: Connects different networks and directs data packets between them.
2. Switch: Connects devices within a LAN and forwards data to the appropriate device
based on MAC addresses.
3. Access Point: Allows wireless devices to connect to the wired network, extending the
network's reach.
4. Network Interface Card (NIC): A hardware component in computers and devices
that enables them to connect to a network.

A. Database Management

A(i) What is a Database?

A database is an organized collection of structured information or data, typically

stored electronically in a computer system. It allows for efficient data management,
retrieval, and manipulation. Databases are managed by a Database Management
System (DBMS), which provides the tools for creating, updating, and querying the
data.

A(ii) Three DBMS Options

The firm can use the following three Database Management Systems (DBMS) to
manage its staff records:

1. MySQL: An open-source relational database management system known for its

reliability and ease of use.
2. PostgreSQL: An advanced open-source relational database that supports both SQL
and JSON querying, offering strong performance and extensibility.
3. Microsoft SQL Server: A comprehensive enterprise-level DBMS that provides
robust data management and analytics capabilities.

B. Graphic Packages

B(i) Two Tasks for Staff Photographs

Using graphic packages, the following tasks can be performed on staff photographs:

1. Image Editing: Adjusting brightness, contrast, cropping, and applying filters to

enhance the quality of photographs.
2. Image Compression: Reducing the file size of photographs for efficient storage and
faster loading times without significantly compromising quality.

B(ii) Three Examples of Graphic Packages

Here are three graphic packages that can be used for the tasks mentioned:

1. Adobe Photoshop: A powerful image editing software widely used for professional
photo editing and graphic design.
2. GIMP (GNU Image Manipulation Program): A free and open-source image editor
that provides advanced editing capabilities similar to Photoshop.
3. CorelDRAW: A vector graphic design software that also includes features for photo
editing and manipulation.
 (a) Presentation Package

(i) What is a Presentation Package?

A presentation package is a software application designed to create visual

presentations. It allows users to combine text, images, graphics, and multimedia
elements to convey information effectively. Presentation packages typically offer
tools for designing slides, adding animations, and organizing content in a way that
enhances audience engagement.

(ii) Two Examples of Presentation Packages

1. Microsoft PowerPoint: A widely used presentation software that offers a range of

features for creating and delivering presentations.
2. Google Slides: A web-based presentation tool that allows users to create, edit, and
collaborate on presentations online.

(iii) Three Features of a Presentation Package

1. Slide Templates: Pre-designed layouts that help users create visually appealing
presentations quickly.
2. Animation and Transition Effects: Tools to add movement and effects between
slides or to individual elements, enhancing the presentation's visual impact.
3. Multimedia Integration: The ability to incorporate images, videos, audio clips, and
charts to support and enrich the content of the presentation.

(b) Steps to Find and Replace Data in MS Excel

1.

Open the Excel Workbook: Launch Microsoft Excel and open the workbook
containing the data you want to modify.
2.
3.

Access the Find and Replace Feature:

4.
 Press Ctrl + H on your keyboard to open the Find and Replace dialog box directly.
 Alternatively, go to the Home tab, click on Find & Select, and choose Replace from
the dropdown menu.
5.

Enter Search Criteria:

6.
 In the Find what field, enter the data you want to find.
 In the Replace with field, enter the new data you want to replace it with.
7.
 Choose Options (if necessary):
8.
 Click on Options >> to expand the dialog box and specify additional criteria (e.g.,
match case, match entire cell contents).
9.

Execute the Replacement:

10.
 Click on Replace All to replace all instances of the found data in the workbook
or Replace to replace them one at a time.
 A dialog box will appear showing how many replacements were made.
11.

Review Changes: Check the worksheet to ensure the replacements were made
correctly.
12.
13.

Close the Dialog Box: Click OK and then close the Find and Replace dialog box
when you are finished.

(a) Hardware Changes Required

i) Two Hardware Changes Required

1. Digital Camera: The photographer needs to acquire a digital camera that can capture
high-quality images.
2. Higher Storage Capacity: An upgrade to a larger hard drive or the addition of an
external hard drive to accommodate the larger file sizes of digital images.

ii) Reasons for Each Change

1. Digital Camera:
 A digital camera allows for immediate image review, editing capabilities, and the
ability to store numerous photos on memory cards, enhancing workflow and
efficiency.
2. Higher Storage Capacity:
 Digital images, especially in high resolutions, require significantly more storage space
than analogue photographs. A larger storage capacity ensures that all images, along
with editing software and documents, can be stored without running out of space.

iii) Reason for Using External Hard Disk Instead of Floppy Disk

 Storage Capacity: An external hard disk offers vastly greater storage capacity
compared to floppy disks, which can only hold a small amount of data (typically 1.44
MB). This is essential for storing large digital image files and backups, making it a
more practical solution for a professional photographer.
 (c) Advantages of Switching from Analogue to Digital Camera

1.

Immediate Feedback: Digital cameras allow photographers to review images

instantly on the camera's display, enabling them to make adjustments on the spot if
necessary.
2.

Editing Flexibility: Digital images can be easily edited using software, allowing for
enhancements, corrections, and creative effects that are not possible with analogue
photography. This flexibility improves the overall quality and presentation of the final
photographs.

(a) Hardware Changes Required

i) Two Hardware Changes Required

1. Digital Camera: The photographer needs to acquire a digital camera that can capture
high-quality images.
2. Higher Storage Capacity: An upgrade to a larger hard drive or the addition of an
external hard drive to accommodate the larger file sizes of digital images.
ii) Reasons for Each Change

1. Digital Camera:
 A digital camera allows for immediate image review, editing capabilities, and the
ability to store numerous photos on memory cards, enhancing workflow and
efficiency.
2. Higher Storage Capacity:
 Digital images, especially in high resolutions, require significantly more storage space
than analogue photographs. A larger storage capacity ensures that all images, along
with editing software and documents, can be stored without running out of space.
iii) Reason for Using External Hard Disk Instead of Floppy Disk

 Storage Capacity: An external hard disk offers vastly greater storage capacity
compared to floppy disks, which can only hold a small amount of data (typically 1.44
MB). This is essential for storing large digital image files and backups, making it a
more practical solution for a professional photographer.

(c) Advantages of Switching from Analogue to Digital Camera

1.

Immediate Feedback: Digital cameras allow photographers to review images

instantly on the camera's display, enabling them to make adjustments on the spot if
necessary.
2.
3.
 Editing Flexibility: Digital images can be easily edited using software, allowing for
enhancements, corrections, and creative effects that are not possible with analogue
photography. This flexibility improves the overall quality and presentation of the final
photographs.
4.
A class captain was asked to create a database in MS Access for all the student in the
class without using any template and name it Student_Record. The table created is to
be named Students and should have five columns/fields with the following names:
ID_Number, FullName, Date of Birth, Age Home_Address i). Highlight the
procedures the captain will follow to create the database. ii). List the step the captain
would take to create the table in Design View. iii). Give the data type suitable for each
column/field provided. iv). Which field can be used as the primary key? v). Mention
one importance of primary keys. vi). List three SQL command statements the class
captain can perform on the database. 7 vii). Give the SQL query the captain will use
to display all the columns in table Students.

Monica
Searching memo: MS Access create database SQL commands primary keys data
types
i) Procedures to Create the Database in MS Access

1. Open MS Access: Launch the Microsoft Access application on your computer.

2. Create a New Database:
 Select Blank Database from the available options.
 In the dialog box, enter the database name as Student_Record.
 Choose a location to save the database and click Create.
3. Save the Database: The new database will open, and you can begin creating tables.

ii) Steps to Create the Table in Design View

1. Open the Database: Ensure that the Student_Record database is open.

2. Create a New Table:
 Click on the Table Design option from the Create tab.
3. Define Fields:
 In the design view, enter the field names in the first column.
 Set the data types in the second column for each field.
4. Save the Table:
 Click Save on the Quick Access Toolbar (or press Ctrl + S), and name the
table Students.
5. Close the Design View: After saving, you can close the design view.

iii) Suitable Data Types for Each Column/Field

 Field Name Data Type
ID_Number Short Text
FullName Short Text
Date of Birth Date/Time
Age Number
Home_Address Short Text

iv) Primary Key Field

 ID_Number can be used as the primary key. It uniquely identifies each student in the
database.

v) Importance of Primary Keys

 Uniqueness: Primary keys ensure that each record in a table is unique, preventing
duplicate entries and maintaining data integrity.

vi) Three SQL Command Statements

1. SELECT: To retrieve data from the Students table.

2.
sql
3.
4.
Copy
5.
6.
SELECT * FROM Students;
7.
8.
9. INSERT: To add a new record to the Students table.
10.
sql
11.
12.
Copy
13.
14.
INSERT INTO Students (ID_Number, FullName, Date_of_Birth, Age,
Home_Address) VALUES ('12345', 'John Doe', '2000-01-01', 24, '123 Main St');
15.
16.
17. UPDATE: To modify an existing record in the Students table.
18.
sql
19.
20.
Copy
21.
22.
UPDATE Students SET Age = 25 WHERE ID_Number = '12345';
23.
24.

vii) SQL Query to Display All Columns in Table Students

sql
Copy
SELECT * FROM Students;
This query retrieves all records and columns from the Students table.
(a) Steps to Create a Table and Insert a Hyperlink in MS Word

(i) Create a Table with 4 Columns and 6 Rows

1. Open MS Word: Launch Microsoft Word on your computer.

2. Insert Table:
 Go to the Insert tab on the Ribbon.
 Click on Table.
 Hover over the grid to select 4 columns and 6 rows.
 Click to insert the table.
3. Adjust Table Properties (if needed):
 Click on the table to select it.
 Use the Table Design and Layout tabs to format the table (e.g., adjust column width,
row height, borders).

(ii) Insert a Hyperlink on a Text

1. Select the Text: Highlight the text you want to turn into a hyperlink.
2. Insert Hyperlink:
 Right-click on the highlighted text.
 Select Link or Hyperlink from the context menu.
 In the dialog box, enter the URL in the Address field.
 Click OK to create the hyperlink.

(b) Answering Question 6(b) Using Figure 1

Since I cannot see the figure, I can't provide specific details based on it. However, if
you describe the content or context of Figure 1, I can help you analyze or answer
questions related to it!