College of Computer Science Dmmmsu - Sluc
College of Computer Science Dmmmsu - Sluc
College of Computer Science Dmmmsu - Sluc
Anthony T. Imatong
1st Semester 2021
COURSE
DESCRIPTION
This course provides an overview of the Computing Industry and Computing profession
including Research and Applications in different fields: 1) an Appreciation of Computing in
different fields such as Biology, Sociology, Environment and Gaming; 2) an Understanding of
ACM Requirements; and 3) an Appreciation of history of computing and Knowledge on the Key
Components of Computer Systems (Organization and Architecture), Malware, Computer
Security, Internet and Internet Protocols, HTML 4/5 and CSS (CMO No. 25, Series of 2015).
OBJECTIVES
✔ COURSE
REQUIREMENTS
Class Standing
MIDTERM 60%
Learning Activities
GRADE Summative Test
40% MIDTERM EXAM
Class Standing
60%
FINAL GRADE 40% Learning Activities
20% Summative Test
40% FINAL EXAM
GRADING SYSTEM
Module I Introduction
Books:
Hunt, M.S. et al. (2016). Illustrated Microsoft Office 365 & Office 2016:
Fundamentals. Cengage Learning.
Online Resources:
https://sites.google.com/view/ccselibrary
Module 1 7
Module 1: Introduction
INTRODUCTION
OBJECTIVES
DIRECTIONS/MODULE
ORGANIZER
There are four lessons in the module. Read each lesson carefully then answer the
exercises/learning activities to find out how much you have benefited from it.
Work on these exercises carefully and submit your output to your instructor.
Lesson 1
Field in CS/IT/IS
Objectives:
IT professionals possess the right This offers a foundation that It is concerned with the
combination of knowledge and permits graduates to adapt to new information that computer
practical, hands-on expertise to technologies and new ideas. systems can provide to aid a
take care of both an organization’s company, non-profit or
information technology that uses governmental organization in
it. The work of computer scientists defining and achieving its goals.
falls into three categories:
They assume responsibility for
selecting hardware and software a) Designing and building
products appropriate for an software;
organization.
b) Developing effective ways to
solve computing problems
TECHNOLOGY CAREERS
With billions of dollars in annual revenue, the technology industry is a major source of career
opportunities worldwide. This industry has created thousands of high tech career
opportunities, even in organizations whose primary business is not technology related. As
technology changes so do the available careers and requirements. New careers are available
in social media and mobile technologies that did not exist a few years ago. For this reason,
you should stay up to date with technology developments.
Most medium and large businesses and government organizations have an IT Department.
They are responsible for ensuring that all computer operations, mobile devices, and networks
run smoothly. They also determine when and if the organization requires new hardware,
mobile devices or software. Usually, these jobs are divided into the following area:
FIELDS IN TECHNOLOGY
4. Technology Sales field, people with this job must possess a general understanding
of technology and a specific knowledge of the product they are selling. Strong
people skills are important, including a keen listening ability and superior verbal
communications. They generally determine buyers’ needs and direct buyers toward
devices, computers and apps that meet their needs. The technology salesperson in
a retail store often is a suitable entry level job for students working towards a
certificate or degree in computer relates fields.
and apps, design and develop systems, write programs, integrate and sync data
from apps used on multiple devices, and perform other technology-related
activities.
3. Web Marketing and Social media. Careers in web marketing and social media
require you to be knowledgeable about web-based development platforms, social
media apps, and marketing strategies.
4. Data Storage, Retrieval and Analysis. Careers in data storage and analysis require
you to be knowledgeable about collecting, analyzing, and reporting data from
databases or the web.
Learning Activity
REVIEW QUESTIONS
What is the difference of IT/CS/ IS profession?
List and describe the areas found in an IT Department.
Describe the technology/ equipment field. And list possible jobs in
this area.
Explain different types of companies in the software and apps field.
Explain security issues that arise when using unlicensed software.
List criteria needed to be a technology salesperson. Describe various
careers in this field.
Describe the role of a corporate trainer.
Explain the responsibilities and educational requirements of a
helpdesk specialist.
Define the roles an IT consultant might fulfill.
List requirements and available careers for the following area:
system development; technology operations; web marketing and social
media; data storage, retrieval and analysis, information and systems
security, and app development and mobile technologies.
Lesson 2
Information Technology,
the Internet, and You
Objectives:
Information System
Module 1 18
We deal with information systems in our daily life. Think of all things you can do
online like registering for classes, paying bills, searching for jobs, or making travel
reservations. Those examples show that IS are integral to our daily lives. Thanks to IS
we may have a simpler life.
Before stating the importance of Information Systems, you should get a little picture
of the difference between Information Systems (IS) and Information Technology (IT).
IS is an umbrella term for the systems, people and processes. The field of information
systems bridges business and computer science. Meanwhile IT falls under the IS
umbrella but deals with the technology involved in the systems themselves. IT can be
defined as the study, design, implementation, support or management of computer-
based information systems. Many people assume that Information Technology (IT) and
Information Systems (IS) are the same, because people assume they are all computer-
based.
IS improves our quality of life. IS provides flexibility of time and location. A student
can do their homework at home; check assignments from their teachers even no face
to face meeting done that day. Indirectly, it affects our quality of life.
To understand more about Information system, the diagram below and components
are presented in detailed.
People
Connectivity Procedures
Information
System
Data Software
Hardware
Module 1 19
Mobile apps or mobile applications are small programs designed for mobile
devices such as smart phones, tablet computers, and other mobile devices.
There are over half a million apps. The most popular mobile apps are for text
messaging, Internet browsing, and connecting to social networks.
Four Types of Computers
● Supercomputers are the most powerful type of computer. These machines are
special high-capacity computers used by very large organizations. IBM's Blue
Gene supercomputer is one of the fastest computers in the world.
● Mainframe computers occupy specially wired, air-conditioned rooms. Although
not nearly as powerful as supercomputers, mainframe computers are capable
of great processing speeds and data storage. For example, insurance companies
use mainframes to process information about millions of policyholders.
● Midrange computers, also referred to as servers, are computers with
processing capabilities less powerful than a mainframe computer yet more
powerful than a microcomputer. Originally used by medium-size companies or
departments of large companies to support their processing needs, today
midrange computers are most widely used to support or serve end users for
such specific needs as retrieving data from a database or supplying access to
application software.
Module 1 21
● Microcomputers are the least powerful, yet the most widely used and fastest-
growing type of computer.
2. Input/output. Input devices translate data and programs that humans can
understand into a form that the computer can process. The most common
input devices are the keyboard and the mouse.
o Output devices translate the processed information from the computer
into a form that humans can understand. The most common output
devices are monitors and printers.
3. Secondary storage. Unlike memory, secondary storage holds data and
programs even after electric power to the computer system has been turned
off.
o Kinds of secondary media
▪ Hard disks are typically used to store programs and very large
data files. Using rigid metallic platters and read/write heads that
move across the platters, data and information are stored using
magnetic charges on the disk's surface.
Module 1 22
Data
Data is raw, unprocessed facts, including text, numbers, images, and sounds. As
we mentioned earlier, processed data becomes information. When stored
electronically in files, data can be used directly as input for the system unit.
Four common types of files
1. Document files - created by word processors to save documents such as
memos, term papers, and letters.
2. Worksheet files - created by electronic spreadsheets to analyze things like
budgets and to predict sales.
3. Database Files – typically created by database management programs to
contain highly structured and organized data. For example, an employee
database file might contain all the workers' names, Social Security numbers,
job titles, and other related pieces of information.
4. Presentation files - created by presentation graphics programs to save
presentation materials. For example, a file might contain audience handouts,
speaker notes, and electronic slides.
Connectivity
Module 1 23
Learning Activity
REVIEW QUESTIONS
Which part of an information system is the most important?
Describe the two major kinds of software.
Describe three types of system software programs.
Define and compare general-purpose, specialized, and mobile applications.
What are the four types of computers?
Describe the four types of microcomputers.
Describe the four basic categories of microcomputer hardware.
Module 1 24
Lesson 3
The Internet, Web and
Electronic Commerce
Objectives:
Internet
– It is the actual network that is made up of wires, cables, satellites, and rules
for exchanging information between computers connected to the network
(being online).
– Connects millions of computers throughout the world.
Web
– A multimedia interface to the resources available on the internet.
Communicating
• You can exchange e-mail, photos, and videos with your family and
friend from almost anywhere in the world.
Shopping
• You can window shop, look for the latest fashions, search for
bargains, and make purchases.
Searching
• You can access some of the world’s largest libraries directly from
your home computer.
• You can find the latest local, national, and international news.
Education or e-learning
• You can take classes on almost any subject.
Entertainment
• You can find music, movies, magazines, and computer games.
B. Browsers
● Browsers are programs that provide access to web resources.
● It allows you to explore or to surf the web by easily moving from one
website to another.
● Some of the well-known browsers are Google Chrome, Mozilla Firefox, MS
Internet Explorer and Apple Safari.
• Protocol
– Used to connect to the resource.
– HTTP is used for web traffic and is the most widely used internet
protocol.
• Domain Name
– It indicates the specific address where the resource is located.
– The last part of the domain name following the dot is the top-level
domain (TLD). Also known as web suffix.
Cloud Computing
hardly bothers you where they go. When your stop comes you get off the bus
thanking the driver. Cloud computing is just like that bus, carrying data and
information for different users and allows to use its service with minimal cost.
Types of Clouds
There are four different cloud models that you can subscribe according to
business needs:
Challenges of IoT
● Insufficient testing and updating
● Concern regarding data security and privacy
● Software complexity
● Data volumes and interpretation
● Integration with AI and automation
● Devices require a constant power supply which is difficult
● Interaction and short-range communication
Disadvantages IOT
● Security: IoT technology creates an ecosystem of connected devices. However,
during this process, the system may offer little authentication control despite
sufficient security measures.
● Privacy: The use of IOT, exposes a substantial amount of personal data, in
extreme detail, without the user's active participation. This creates lots of
privacy issues.
● Flexibility: There is a huge concern regarding the flexibility of an IoT system.
It is mainly regarding integrating with another system as there are many
diverse systems involved in the process.
● Complexity: The design of the IOT system is also quite complicated. Moreover,
it's deployment and maintenance also not very easy.
● Compliance: IOT has its own set of rules and regulations. However, because of
its complexity, the task of compliance is quite challenging.
Learning Activity
REVIEW QUESTIONS
Make a list of the latest technological devices you are familiar with or
have used. Identify at least 3 technology trends and write down their
pros and cons. You can provide pictures if you want.
Module 1 31
Lesson 4
Computer Software
Objectives:
Application Software
As we discussed on previous lesson, there are two kinds of software. System software
works with end users, application software, and computer hardware to handle the
majority of technical details. Application software can be described as end-user
software and is used to accomplish a variety of tasks.
Three categories of Application software
● General purpose applications, includes word processing programs,
spreadsheets, database management systems, and presentation graphics.
● Specialized applications, includes thousands of other programs that tend to be
more narrowly focused and used in specific disciplines and occupations.
● Mobile applications are add-on features or programs designed for a variety of
mobile devices including smart phones and tablets.
USER INTERFACE
A user interface is the portion of the application that allows you to control and
to interact with the program.
Almost all applications use a graphical user interface (GUI) that displays
graphical elements called icons to represent familiar objects and a mouse.
A window is simply a rectangular area that can contain a document, program,
or message. More than one window can be opened and displayed on the computer
screen at one time.
Software programs uses system menus, toolbars, and dialog boxes. These are the
following:
● Menus present commands that are typically displayed in a menu bar at the top
of the screen.
● Toolbars typically appear below the menu bar and include small graphic
elements called buttons that provide shortcuts for quick access to commonly
used commands.
● Dialog boxes provide
additional
information and
request user input.
Module 1 33
Common Features
Most applications provide a variety of features to make entering/presenting, editing,
and formatting documents easy. Some of the most common features include:
● Spell checkers—look for misspelled words
● Alignment—either centers, right-aligns, or left-aligns numbers and characters
● Font and font sizes (perhaps use character effects)—specifies the size and
style of entered numbers and text
● Tables—presents numbers and text in table format
● Reports—provides a variety of different types and styles to report information
General-Purpose Applications
1. Word processors create text-based documents and are one of the most
flexible and widely used software tools.
Microsoft Word is the most widely used word processor. Examples of MS Word
are Corel WordPerfect, Apple Pages, OpenOffice Writer, and Google Docs.
2. Spreadsheets organize, analyze, and graph numeric data such as budgets
and financial reports. Microsoft Excel is the most widely used spreadsheet
program. Other spreadsheet applications include Apple Numbers and
OpenOffice Calc.
3. Database Management Systems. A database is a collection of related data.
It is the electronic equivalent of a file cabinet. Database management system
(DBMS) or database manager is a program that sets up, or structures, a
database. It also provides tools to enter, edit, and retrieve data from the
database.
● All kinds of individuals use databases, from hospital administrators
recording patient information to police officers checking criminal
histories.
Module 1 34
Presentation Graphics
Presentation graphics are programs that combine a variety of visual objects to create
attractive, visually interesting presentations. They are excellent tools to
communicate a message and to persuade people.
Example of presentation graphics
1. Microsoft PowerPoint
2. OpenOffice Impress
3. Apple Keynote
4.
Specialized Applications
⮚ Graphics programs
⮚ Web authoring programs.
Graphics
Graphics are widely used by professionals in the graphic arts profession. They use
desktop publishing programs, image editing programs, illustration programs, and
image galleries.
● Desktop publishing programs, or page layout programs, allow you to mix text
and graphics to create publications of professional quality.
Example of desktop publishing programs
1. Adobe Publisher
2. QuarkXPress
● Image editors, also known as photo editors, are specialized graphics programs
for editing or modifying digital photographs.
Module 1 35
Apps
● The breadth and scope of available mobile applications for smartphones and
other mobile devices are ever expanding.
● There are over 500,000 apps just for Apple's iPhone alone.
o most widely used Apps are social networking, messaging, web browsing,
e-mail, photo sharing, and games.
● One of the fastest-growing apps is QR code readers.
o These readers allow mobile devices to use their digital cameras to scan
QR codes. QR codes, also known as quick response codes, are graphics
that typically appear as black and white boxes that automatically link
mobile devices to a variety of different content including games, text,
videos, and websites.
App Stores
App store is typically a website that provides access to
specific mobile apps that can be downloaded either for a
nominal fee or free of charge.
● Three of the best-known stores are
o Apple's App Store
o Google Play
o Windows Phone Marketplace.
Module 1 37
System Software
System software works with end users, application software, and computer hardware
to handle the majority of technical details.
End users use application software to accomplish specific tasks. For example, we use
word processing programs to create letters, documents, and reports.
System software is not a single program. Rather it is a collection or a system of
programs that handle hundreds of technical details with little or no user intervention.
Four types of programs of System software:
1. Operating systems coordinate computer resources, provide an interface between
users and the computer, and run applications.
2. Utilities perform specific tasks related to managing computer resources.
3. Device drivers are specialized programs that allow particular input or output
devices to communicate with the rest of the computer system.
4. Language translators convert the programming instructions written by
programmers into a language that computers understand and process.
Operating System
An operating system is a collection of programs that handle many of the technical
details related to using a computer. In many ways, an operating system is the most
important type of computer program. Without a functioning operating system, your
computer would be useless.
Module 1 38
Functions
Every computer has an operating system and every operating system performs a
variety of functions. These functions can he classified into three groups:
● Managing resources: Operating systems coordinate all the computer's
resources including memory, processing, storage, and devices such as printers
and monitors. They also monitor system performance, schedule tasks, provide
security, and start up the computer.
● Providing user interface: Operating systems allow users to interact with
application programs and computer hardware through a user interface. Many
older operating systems used a character-based interface in which users
communicated with the operating system through written commands such as
"Copy A: assign.doc C:". Almost all newer operating systems use a graphical
user interface (GUI).
● Running applications: Operating systems load and run applications such most
operating systems support multitasking, or the ability to switch between
different applications stored in memory. With multitasking, you could have
Word and Excel running at the same time and switch easily between the two
applications. The program that you are currently working on is described as
running in the foreground. The other program or programs are running in the
background.
Features
Starting or restarting a computer is called booting the system. There are two ways to
boot a computer: a warm boot and a cold boot. A warm boot occurs when the
computer is already on and you restart it without turning off the power. A warm boot
can be accomplished in several ways. For many computer systems, they can be
restarted by simply pressing a sequence of keys. Starting a computer that has been
turned off is called a cold boot.
You typically interact with the operating system through the graphical user
interface. Most provide a place, called the desktop that provides access to computer
resources. Operating systems have several features in common with application
programs, including
● Icons—graphic representations for a program, type of file, or function.
● Pointer—controlled by a mouse, trackpad, or touch screen, the pointer changes
shape depending on its current function. For example, when shaped like an
arrow, the pointer can be used to select items such as an icon.
Module 1 39
Most operating systems store data and programs in a system of files and
folders. Files are used to store data and programs. Related files are stored
within a folder, and, for organizational purposes, a folder can contain other
folders. For example, you might organize your electronic files in the Documents
folder on your hard disk. This folder could contain other folders, each named to
indicate its contents. One might be "Computer Class" and could contain all the
files you have created (or will create) for this course.
Module 1 40
Categories
While there are hundreds of different operating systems, there are only three basic
categories: embedded, network, or stand-alone.
● Embedded operating systems are used for handheld devices such as
smartphones, cable and satellite television tuner boxes, video game systems,
and other small electronics. The entire operating system is stored within
Handheld devices have embedded operating systems or embedded in the
device.
● Network operating systems (NOS) are used to control and coordinate
computers that are networked or linked together. Many networks are small and
connect only a limited number of microcomputers. Other networks, like those
at colleges and universities, are very large and complex. These networks may
include other smaller networks and typically connect a variety of different
types of computers. Network operating systems are typically located on one of
the connected computers' hard disks. Called the network server, this computer
coordinates all communication between the other computers. Popular network
operating systems include Linux, Windows Server, and UNIX.
● Stand-alone operating systems also called desktop operating systems, control
a single desktop or notebook computer. These operating systems are located on
the computer's hard disk. Often desktop computers and notebooks are part of a
network. In these cases, the desktop operating system works with the network's
NOS to share and coordinate resources. In these situations, the desktop
operating system is referred to as the client operating system.
The operating system is often referred to as the software environment or software
platform. Almost all application programs are designed to run with a specific
platform. For example, Apple's iMovie software is designed to run with the Mac OS
environment. Many applications, however, have different versions; each designed to
operate with a particular platform. For example, one version of Microsoft Office is
designed to operate with Windows. Another version is designed to operate with Mac
OS.
Mobile Operating Systems
Mobile operating systems, also known as mobile OS, are a type of embedded
operating system. Just like other computer systems, mobile computers including
smartphones and tablets require an operating system. These mobile operating systems
are less complicated and more specialized for wireless communication. While there
are numerous mobile operating systems, some of the best known are Android,
BlackBerry OS, iOS, WebOS, and Windows Phone.
● Android was introduced in 2007. It was originally developed by Android Inc.
and later purchased by Google. Android is widely used in many of today's 1
smartphones.
Module 1 41
BlackBerry OS, also known as RIM OS, was first introduced in 1999 by a small
Canadian firm called Research in Motion.Originally designed as the platform
for the 131ackBerry handheld computer, it has evolved into a powerful mobile
operating system. iOS, formerly known as iPhone OS, was originally developed
in 2007 by Apple. It is based on Mac OS and is used as the platform for Apple's
iPhone, iPod Touch, and iPad.
● WebOS was originally developed in 2009 by Palm, Inc. and later purchased by
the Hewlett-Packard Company. Originally developed for Palm's handheld
computers, it has evolved to support HewlettPackard's smartphones and tablet
computers.
Windows Phone 8 was introduced in 2012 by Microsoft to support a variety of
mobile devices, including smartphones. It has the ability to run many powerful
programs designed for desktop and laptop computers.
Mac OS
Apple has been the leader in the development of powerful and easy-to-use
microcomputer operating systems since its introduction of the Macintosh
microcomputer in 1984. Designed to run only with Apple computers, Mac OS is not as
widely used as the Windows operating system. As a result, fewer application programs
have been written for it. With dramatically increasing sales of Apple computers,
however, the use of Mac OS has been rapidly increasing and is widely recognized as
one of the most innovative operating systems.
● Mac OSX is the most widely used Mac OS. Its two most recent versions are:
o OS X Lion was released in 2011 and introduced several powerful
features, including Launchpad to display and provide direct access to
applications, Mission Control to display all running applications, and
gestures.
o OS X Mountain Lion was released in 2012 and designed for desktops and
laptops. Its user interface is very similar to the interface used with its
tablets and smartphones. The functionality of Mountain Lion is similar to
Windows 8 although it is generally regarded as easier to use.
Linux. This operating system is designed for netbook computers and other mobile
devices. Chrome OS focuses on Internet connectivity and cloud computing.
Virtualization
When a single physical computer runs a special program known as virtualization
software, it operates as though it were two or more separate and independent
computers, known as virtual machines. Each virtual machine appears to the user as a
separate independent computer with its own operating system.
The operating system of the physical machine is known as the host operating
system.
Learning Activity
REVIEW QUESTIONS
Discuss desktop publishing programs, image editors, and illustration
programs.
What are image galleries? Stock photos? Clip art?
What are blogs? What is web authoring? What are animations?
What are mobile apps?
What are some of the most common applications? What are QR
codes and QR code readers?
What are app stores?
What is a mobile operating system?
List the five most widely used mobile operating systems.
Which mobile operating system works with the 'Phone?
Which mobile operating system was developed by Microsoft?
Module 1 44
SUMMARY
Lesson IV, you have learned about application software and system software wherein both
reiterates different types of software.
Congratulations! You have just studied Module II. Now you are ready to evaluate
how much you have benefited from your reading by answering the summative test.
Good Luck!!!
Module 1 45
Summative Test
I. Directions: Read each question carefully and choose the best answer from the
given choices. Write the letter of your answer on the space provided.
The keyboard, mouse, monitor, and system unit are:
a. hardware c. storage devices
b. output devices d. software
2. Programs that coordinate computer resources, provide an interface, and run
applications are known as:
a. application programs c. storage systems
b. operating systems d. utility programs
3. A browser is an example of a:
a. general-purpose application c. system application
b. specialized program d. utility program
4. Although not as powerful as a supercomputer, this type of computer is capable
of great processing speeds and data storage.
a. mainframe c. notebook
b. midrange d. tablet
5. The smallest type of microcomputer:
a. handheld c. midrange
b. notebook d. tablet
6. RAM is a type of:
a. computer c. network
b. memory d. secondary storage
7. Unlike memory, this type of storage holds data and programs even after electric
power to the computer system has been turned off.
a. primary c. ROM
b. RAM d. secondary
8. The type of file created by word processors to save, for example, memos, term
papers, and letters.
a. database c. presentation
b. document d. worksheet
9. Uses the Internet and the web to shift many computer activities from a user's
computer to computers on the Internet.
a. cloud computing c. network
b. high definition d. USB
10. The largest network in the world is Ethel:
a. Facebook c. web
b. Internet d. USB
Module 1 46