LESSON 1: INTRODUCTION TO INFORMATION

AND COMMUNICATION TECHNOLOGIES - a nonprofit service designed to help people who have
visual/reading and hearing impairments
• Paperless Society (online transaction)
INFORMATION AND COMMUNICATION TECHNOLOGIES
• 3D Technology (3D outputs)
- deals with the use of different communication technologies
such as mobile phones, telephone, Internet, etc. to locate, • Wearable Technology
save, send and edit information
LESSON 2: ONLINE SAFETY, SECURITY, ETHICS
ICT IN THE PHILIPPINES AND NETIQUETTE
- “ICT Hub of Asia”
- 106.8 cellphones per 100 Filipinos in the year 2012 - ICT Industry NETIQUETTE
shares 19.3% of the total employment population in 2010. - network and etiquette
- “The Selfiest Cities around the World” via Time Magazine • - set of rules for behaving properly online
1st: Pasig & Makati , 9th: Cebu City
ONLINE SAFETY
TRENDS IN ICT - knowledge of maximizing the user’s personal safety and
CONVERGENCE security risk to private information, and the self-protection
from computer crime in general
- synergy of technological advancements to work on a similar
goal or task INTERNET SAFETY TIPS
1. Know the scams
SOCIAL MEDIA
2. THINK before you click
- a website, application, or online channels - T-True, H-Helpful, I-Inspiring, N-Necessary, K-Kind
- enable web users to create, co-create, discuss, modify, and 3. Safety Peruse
exchange user-generated content - have an address that’s very similar to legitimate site -
a) Social Networks have misspellings, bad grammar or low-resolution
- connect with other people with the same interests or images
background 4. Shop Safely
(Facebook, Google+) - don’t shop unless it has “https” and padlock icon to
b) Bookmarking Sites the left/right of the URL
- store and manage links to various website and 5. Kick-butt passwords
resources 6. Protect your info. Keep your guard up
(StumbleUpon, Pinterest) - back-up all data
c) Social News 7. Watch your Wi-Fi connectivity
- post own news items or links to other news sources - change router’s settings
(Reddit, Digg) - password-protected connection
d) Media Sharing 8. Install a firewall
- upload or share media content like images, videos 9. Keep up to date
and music 10. Use your noggin (common sense)
(Flickr, YouTube)
e) Microblogging INTERNET THREATS
- focus on short updates from the user MALWARE
(Twitter, Plurk)
f) Blogs and Forums - stands for malicious software
- post own contents • Virus
(WordPress, Tumblr) - designed to replicate itself and transfer from one
computer to another either through the internet
MOBILE TECHNOLOGIES and local network or data storage
- devices’ capabilities to do tasks • Worm
- kinds of operating systems: - transfer from one computer to another by any type of
• iOS – proprietary operating system means

• Android – utilized by various companies - often uses computer network to spread itself. •
Trojan
• Blackberry OS – proprietary operating system •
- disguised as a useful program
Symbian – Microsoft (nokia)
- once downloaded or installed, leaves your PC
• WebOS – smart television unprotected and allows hackers to get your
• Windows Mobile – Microsoft (pocket PCs) information
ASSISTIVE MEDIA
 JN GULLON
• Spyware TIPS IN CONDUCTING ONLINE RESEARCH
- runs in the background without you knowing it
1. Have a question in mind
(thus called “spy”)
- focus on a question you want answered.
- has the ability to monitor what you’re currently
- if it is a series of questions, start with one
doing and typing through keylogging
- never search everything on one go
• Adware 2. Narrow it down
- program designed to send advertisements, mostly as - use several filters to determine the most appropriate
pop-ups. result for you
• Boolean Operators
SPAM
o and – 2 concepts together
- unwanted email mostly from bots or advertisers. - o or – 1 concept or another
can be used to send malware o not – filters out concept you don’t need
• Asterisk / Star Symbol
PHISHING
- find different forms of the same word.
- goal to acquire sensitive personal information like passwords (ex. Teen*, Canad*)
and credit card details • Question Marks
• phishing – email - group words together in your search
• pharming – direct 3. Advanced Search
- filter out information you don’t need
• vishing – call
4. Look for credible source
5. Give Credit
COPYRIGHT INFRINGEMENT - Name of the person or organization (the author of the
- RA 8293 Intellectual Property Code of the Philippines. - the information). Title of the home page in italics. URL. Date
unauthorized use of copyrighted material, such as text, photos, last seen.
videos, music, software, and other original content. - copyright
violations often refer to software and websites in the computer
industry LESSON 3: ADVANCED WORD PROCESSING SKILLS

FAIR USE MAILMERGE

- a legal concept that allows the reproduction of copyrighted - used to create multiple documents at once
material for certain purposes without obtaining permission
- these documents have identical layout, formatting, text, and
and without paying a fee or royalty
graphics
- only specific sections of each document vary and is
SEARCHING THE WEB
personalized
SEARCH ENGINE - 2 components:
- websites used for retrieval of data, files, or documents from • Form Document
data bases - document that contains the main body of the
(ex. google, yahoo, duck duck go, bing) message we want to convey or send

ANATOMY OF A URL

• List or Data File

- where the individual information or data that needs to
be plugged in (merged) to our form document is
placed and maintained

ONLINE RESEARCH
- a research method that involves the collection of information
from the internet
 JN GULLON
HOW TO MAIL MERGE: =COUNTIFS (A2:A17,
1. Create Form Document, then Save "Dyeing", B2:B17, "Cash")

2. Open or create List Data File in Excel then Save =COUNTIFS (A2:A17,
"Meeting hairstyles",
3. Go back to Form Document, click Mailings B2:B17, "Cash")

4. Click Start Mail Merge → Step by step Mail =COUNTIFS (A2:A17,

Merge 5. Select Document Type → Letter → Next "Dyeing", B2:B17,
"Credit Card")
6. Select Starting Document → Use current document →
=COUNTIFS (A2:A17,
Next 7. Use an Existing List → Browse → OK → Next "Meeting hairstyles",
B2:B17, "Credit Card")
8. Write your Letter → More items → Insert

9. Arrange it (ex: «LastName», «FirstName», «MA»)

SUMIF
LESSON 4: ADVANCED SPREADSHEET
SKILLS - returns the sum of cells that meet a single criteria

=SUMIF (range, criteria, sum_range)

FUNCTIONS
- predefined formula that performs calculations using specific =SUMIF(A2:A17,
values in a particular order "Dyeing", C2:C17)
- criteria can be applied to dates, numbers, and text using
=SUMIF(A2:A17,
logical operators and wildcard for partial matching • logical
"Meeting hairstyles",
operations - <, >, <=, >=, ==, <> C2:C17)
• wild card - *
- enclosed in double quotations “”
- the parts are:
SUMIFS
- returns the sum of cells that meet multiple criteria =SUMIFS

(sum_range, range1, criteria1, [range2], [criteria2], …)

COUNTIF
=SUMIFS(C2:C17, A2:A17,
- a function to count cells that meet a single criteria "Dyeing", B2:B17, "Cash")
=COUNTIF (range, criteria)
=SUMIFS(C2:C17, A2:A17,
"Meeting hairstyles",
=COUNTIF (A2:A17, "Dyeing") B2:B17, "Cash")

=COUNTIF (A2:A17,
"Meeting hairstyles")
LESSON 5: ADVANCED PRESENTATION SKILLS

PRINCIPLES IN CREATING AN EFFECTIVE PPT

MINIMIZE
- keep slide counts to a minimum to maintain a clear message

COUNTIFS CLARITY

- A function to count cells that meet a multiple criteria - avoid being fancy by using a font style that is easy to read -
font style and size
=COUNTIFS (range1, criteria1, [range2], [criteria2], …) - consider screen/area
- must be in sans serif
- ✓ Arial, Comic Sans MS, Segoe UI Black
 - ✗ Forte, Jokerman, Edwardian Script
- summarize information using bullets or short sentences -
6x7 rule (7 words 6 lines)
SIMPLICITY

JN GULLON
VISUALS - the elements in it will support and complement each other so
that the focus is obtained according to the desired goal
- use graphics to help in your presentation
- 2-3 pictures

CONSISTENCY

- make your design uniform

- avoid different font styles and backgrounds - HARMONY
max of 2 font styles
- also called alignment is the suitability of one part with
CONTRAST another in a design
- aspects can be in the form of harmony in line and shape or
- contrast the color
- use light font on dark background or vice versa harmony in texture and color

LESSON 6: IMAGING AND DESIGN FOR

ONLINE ENVIRONMENT
EMPHASIS
BASIC PRINCIPLES IN GRAPHIC DESIGN
LAYOUT PROPORTION - design needs to have something that becomes the focus or
gets attention first
- efforts to regulate the size between one part and another

BALANCE LAYOUT

- visual weight of objects, texture, color, and space is evenly - can basically be divided into several parts, it can be 4 parts, 3
distributed parts, and 2 parts depending on the design needs

CONTRAST
- visual elements placed close together noticeably differ from
each other

RHYTHM

- pattern created by elements repeatedly and varied

• Repetition (repeating similar elements)
• Variation (changes in shape, size, element)

UNITY

- used to unify layout elements such as typography, illustrations, colors, etc.