Module
in
GEE5
LIVING IN THE IT ERA
2nd Semester 2021-2022
Bangquillo John Loyd A.
BSCE-2A
3
Title of the Chapter:
Computer Applications
Pre-test
Multiple Choice: Circle the letter that corresponds to the correct answer.
1. These are commonly used for measuring the data transfer rate of
computer communications devices such as modems.
a. Gigabytes c. Bytes
b. Kilobytes d. Bits
2. It describes any system based on discontinuous data or events; in the
case of computers
a. Wired communication c. Analog
b. Wireless Communication d. Digital
3. It is the logical layout, or shape, of a network.
a. Wireless Communication c. Topology
b. Wired communication d. Bus network
4. It is a private network that use a public network (usually the internet)
to connect remote sites
a. Intranets c. LAN
b. WAN d. VPN
5. It is a fixed-length block of data for transmission
a. Protocol c. Hub
b. Packet d.
Switch
6. It is short for "modulate/demodulate.
a. Module c. Modem
b. MDL d. Mode
7. It is a continuously changing/ fluctuating/ evolving in strength and/or
quality.
a. Analog c. internet
b. Digital d.
extranet
8. It is a special computer that directs communicating messages when
several networks are connected together
a. bridge c.
switch
b. gateway d. router
9. It is an entirely wireless, very power-efficient technology that can
send data at 128 kilobytes per second at a range of about 250 feet.
a. Bluetooth c. Insteon
b. Z-wave d. Zigbee
10. It is known as a first-generation cellular service
a. Wireless Digital Services c. Wimax.
b. Digital wireless services d. Analog
cellphones
Lesson 8. Computers in our Daily Life
Activities
1. Cite at least 2 advantages and 2 disadvantages of computers and
explain how they could affect human activities. Rubrics: 10 points
(Organization-5; Content-5)
Advantages of Computers
Computer helps the user to finish their designated tasks easily
in few seconds.
It helps the user in better understanding and communication
with other devices.
Disadvantages of Computers
Computers can be a distraction because of its high
entertainment value.
Use of computers nowadays increases the numbers of
cybercrimes.
How they could affect human activities
Computer can make human activities easier and faster, it could
help to lessen our everyday work. On the other hand, it could
also be a threat to us. Improper use of it may lead us to danger.
2. Use an image that shows improper posture in using a computer
and suggest how to correct it. Rubrics: 10 points (Creativity-5;
Accuracy/Content-5)
Improper posture in using a computer
Some ways to correct posture in using computer is to:
Sit with a back straight (no hunching), your shoulders pulled back and
buttock touching the end of the seat.
Keep your neck and head in an upright angle with your ears aligned
with your shoulders. According to studies, tilting the head forward
just 15 degrees (so called “text neck”) doubles the amount of pressure
on your neck as the weight of your head doubles.
Avoid leaning on any side. Keep hips even to distribute weight of
body.
Bend your knees at a 90 degree angle, and keep your knees even with
or slightly lower than hips.
Leave a 2-3 inch small gap between the bottom of your thighs and the
edge of the seat. This helps reduce pressure build up in the underside
of your thighs.
Keep both feet flat on the floor, or rest them on a footrest if you can’t
reach it.
Don’t sit with your legs crossed, which restricts blood flow.
Avoid sitting for longer than 30 minutes at a time.
3. Explain the usage of a binary system? Rubrics: 10 points
(Organization-5; Content-5)
Computers use the binary number system to manipulate and store all
of their data including numbers, words, videos, graphics, and music.
Binary is most well known for being used in computers. Each bit (a
storage module) has two values, it can represent 1 or 0. Binary is used
in computers because it’s the most simple way to store and use data
that we know
4. Differentiate bit and byte. Rubrics: 10 points (Organization-5;
Content-5)
The main difference between bit and byte is the size of the file or the
amount of information it contains. A bit is the smallest unit of
computer memory, and it has the capacity to store a maximum of two
different values. While a byte, which is composed of eight bits, has the
potential to store a maximum of 256 distinct values.
D-Evaluation/Post-test
Identification. Write your answer on the space provided before the item (1
Ergonomics
point each).
1. _____________. It is a science-based discipline that brings together
knowledge from other subjects such as anatomy and physiology,
psychology, engineering, and statistics to ensure that designs
complement the strengths and abilities of people and minimize the
effects of their limitations and instructions to the computer. Examples
are mouse,
Ergonomics printer, speakers, etc.
of using computer
2. _____________.It is the field of study that is concerned with the fit
between people, their equipment, and their work.
Memory
3. ______________.It refers to the capacity of the computer to process and
retrieve information.
4. Random Access Memory
______________. Spell-out the acronym RAM.
5. ______________. It refers to a feeling of anxiety and incapacity
Information Overload
experienced when people are presented with more information than
they can Userhandle.
6. ______________. It refers to the computer operator (people).
7. ______________.
Software It is a set of instructions that makes the computer
perform tasks. In other words, the software tells the computer what to
do. Hardware
8. ______________. It is the mechanical devices that make up the computer
are called hardware. Hardware is any part of the computer you can
[Link]
9. ______________. It refers to the function of the computer on how fast it
could produce information.
Computers
10. ______________. It helps us to collect, organize, evaluate, and
communicate information.
Lesson 9. Networks & Wired & Wireless Data
E-Activities:
Rubrics: 10 points each (Organization-5; Content-5)
1. What is the difference between analog and digital technology?
The difference between analog and digital technology is that in analog
technology, information is translated into electric pulses of varying
amplitude. In digital technology, the information is converted into a
number (digits) and displays and stores it.
2. What do you think are the advantages and disadvantages of wired and
wireless communication media?
Using wired networks generally transfer data faster compared to
wireless networks. It is much less likely to suffer from interference
than wireless network. It is also much difficult for an unauthorized
user to intercept data. However, wired networks are expensive to
install or configure. The user also can’t instantly move a device from
one location to another as there may not be a network connection
available.
Using wireless networks allows the user to move around freely and
still stay connected. New nodes can easily be added without the
interruption to the network. However, wireless network only has a
limited range. Each wireless access point only has so much bandwidth
to share among connected nodes. The greater the number of nodes
that are connected, the less bandwidth each receives and the slower
communication becomes.
D-Evaluation/Post-test
Test 1- Identification. Write your answer on the space provided
before the number (1 point each).
1. Hybrid
___________.
Computer A type of computer that can accept continuous, discrete
or both type of input.
2. ___________.
Modem It is a short for “modulate/demodulate.
3. ___________.
Analog It is a continuously changing/ fluctuating/ evolving in
strength and/or quality.
4. Digital Technology
___________. A kind of technology that converts the information into a
number (digits) and displays and stores it.
5. Digital Computer
__________. It represents and processes data in discrete/numerical
form, using binary system.
6. Analog Computer
__________. It measures and operates on data that are represented in
the form of continuous variables.
7. Hybrid
__________.
Computer This type of computer is commonly found in highly
scientific environments.
VPN
8. __________. It is a private network that uses a public network to
connect remote sites or users.
9. __________.
Topology It is the physical way in which computers are
interconnected. It is the logical layout, or shape, of a network.
10. __________. All microcomputers on the network communicate directly
PEER-TO-PEER NETWORK
with one another without relying on a server.
11. __________.
Protocol It is a set of conventions governing the exchange of data
between hardware and/or software components in a communications
network.
Switch
12. ________. It is a device that connects computers to a network. It sends
messages only to a computer that is the intended recipient.
Router It is a special computer that directs communicating
13. ________.
messages when several networks are connected.
Wireless Application Protocol
14. ____________.
(WAP) It is designed to link nearly all mobile devices to your
telecommunications carrier’s wireless network and content providers.
Analog Cellphones
15. ________________. A first generation cellular service that is designed
primarily for communicating by voice through a system of ground-
area cells.
Bluetooth
16. ________________. It is a short-range wireless digital standard aimed at
linking cellphones, PDAs, computers, and peripherals up to distances
of about 30 feet.
Bridge
17. ________________. It is an interface used to connect the same types of
networks.
18. ________________.
Backbones It consists of the main highway—including gateways,
routers, and other communications equipment—that connects all
computer networks in an organization.
Cellular RadioIt is widely used for cellphones and wireless modems,
19. _____________.
using high-frequency radio waves to transmit voice and digital
messages.
FIBER-OPTIC CABLE
20. _____________. It consists of dozens or hundreds of thin strands of glass
or plastic that transmit pulsating beams of light rather than
electricity.
Lesson 10. Application Software: Getting Started
D-Activities
Number 2, 3 & 4 will serve as your Midterm Examination.
1. Determine what kind of files are the following (1 point each):
Extension Types of Document
1 .bmp Bitmap image
2 .docx Word-processing document
3 .mdb Database
4 . hmtl Web page
5 .zip Compressed file
6 .slr Spreadsheet
7 .rtf Text
8 .ppt PowerPoint Presentation
9 .pdf Portable Document Format
10 .wpd Word-processing document
Midterm Examination
2. Using Microsoft Word, create a letter with the following components: Rubrics: 40
points (Accuracy-20; Format-20)
2.1 Put a letterhead of your own resort or hotel (create your own name and logo) at
the upper center of an A4 size document
2.2 Left margin: 1.5 inch and Right Margin: 1 inch
2.3 Top Margin: 1 inch ; Bottom Margin: 1 inch
2.4 Date: January 2, 2021
2.5 Font Size: 12
2.6 Font Style: Georgia
2.7 Font Color: Blue
2.8 First line indention: .5”
2.9 Single-space
2.10 Double-space after to separate each paragraph and line such as Date,
Salutation, Greetings, Complimentary Closing, and Signature (your name only).
2.11 In the body, write a letter to your closest client about your Christmas and
New Year experiences (at least one paragraph each) and invite him/her to stay at
your resort/hotel.
2.12 Submit to me the document file (not the screenshot nor the pdf format).
2.13 Filename: Your Surname
3. Create a Powerpoint presentation of your experiences during the Christmas and
New Year Celebration. Upload pictures, describe them, and apply animation and
effect in presenting it. Rubrics: 40 points (Accuracy-20; Format-20)
3.1 Font Size: Between 24 and 30 points.
3.2 Font Style: Freestyle (as long as visible and readable).
3.3 Font Color: Freestyle
3.4 Submit the ppt file (not the screenshot nor the pdf format).
3.5 Filename: Your Surname
4. Create a Spreadsheet file (i.e. Excel) and prepare an income statement. Let us
assume that you have Php 50,000.00, total sale from your Keso de Bola Business.
Follow the format below:
Rubrics: 20 points (Accuracy-15; Format-5)
Sample Income Statement
For the period ending 12/31/2020
Income 50,000.00
Expenses
Ingredients 15,000.00
Transportation 2,000.00
Water and Electricity 1,000.00
Rent 1,000.00 19,000.00
4.1 Net Income 31,000.00
Change the Word “Sample” into your Surname. i.e Cruz Income Statement
4.2 Use the Formula Function to Add and Subtract the values.
4.3 Submit the Excel file (not the screenshot nor the pdf format).
4.4 Filename: Your Surname
E-Evaluation
Multiple Choice: Circle the letter that corresponds to the correct answer (1
point each).
1. It is an umbrella term for software that is designed for a specific
application or niche
a. Software c. Application Software
b. Hardware d. Specialty Software
2. A type of database wherein data is represented using a parent-child
relationship.
a. Network database c. Hierarchical database
b. Relational database d. Object-oriented database
3. It is a collection of interrelated files in a computer system
a. Data c. System
b. Application Software d. Database
4. These are the settings automatically used by a program unless the
user specifies otherwise, thereby overriding them.
a. Automatic commands c. Default Settings
b. Edited settings d. None of the choices
5. It is a process of getting data from another source and then
converting it into a format compatible with the program in which you
are currently working.
a. Copy c. Importing
b. Converting d. Exportin
6. Word processing, Spreadsheets, Database Managers, Personal
Information Managers, Web Browser, and Email are examples of what
software
a. Specialty software c. Productivity
software
b. Entertainment software d. Education
software
7. It is online software that users lease for a fee and download whenever
they want it.
a. Pirated software c. Rentalware
b. Shareware d. Freeware
8. It is created by software engineers and programmers for the special
needs of the company.
a. Pirated software c. Custom software
b. Entertainment software d. Rentalware
9. It is the exclusive legal right that prohibits the copying of intellectual
property without the permission of the copyright holder.
a. Site License c. Copyright
b. Release d. Software License
10. It is not protected by copyright and thus may be duplicated by anyone
at will.
a. Shareware c. Custom software
b. Copyright d. Public-domain software