EMTECH 7.

Click the Customize Columns button on the

dialog box for the New Address List.
LESSSON 3 8. Select a field that you do not need then click
the Delete button.
 MAIL MERGE- Allows you to create 9. Click Yes in the confirmation dialog box.
documents and combine or merge them 10. Repeat steps 8 and 9 for the fields you do
with another document or data file. not need.
11. To add a field you need, click the Add
MAIL MERGE REQUIRES 2 button.
COMPONENTS: 12. Type the field name inside the Add field
 Document that contains the message. dialog box and click the OK button.
 Document or file that generally contains the 13. Repeat steps 11 and 12 for each field.
list of names and address. 14. Click OK on the Customize Address list box
to confirm changes.
15. The New Address List box will appear again
 FORM DOCUMENT
ready for you to type in your data.
The document that contains the main
16. Type the data from your list (Title,
body of the message we want to send.
Name(bold),etc.)
It remains the same no matter whom you
17. Press the Tab key each time to enter next
send it to from among your list.
field.
18. To add a new record, press the Tab key
 PLACE HOLDERS
after inputting the last field.
( data field or merge field )- marks the
19. Repeat steps 16-18 until you enter all the
position on the document where information
records you want. Once done, click OK on
will be inserted.
Add New List to save your data.
20. Type a name for the address list. Name it
TWO COMPONENTS OF MAIL MERGE:
Client list.
 LIST OR DATA FILE- where the individual 21. Click the save button. Go back to Main
information or data that needs to be merged Document.
to form document is placed. 22. Select a field placeholder (ALL CAPS) in the
(Mail merge feature) allows data file to main document.
be created from within the MS Word 23. Click Insert Merge Field.
application or gets data from a file created 24. Choose the proper field to insert into your
in Microsoft Excel or other data formats. text.
25. Continue adding fields until the document is
 LABEL GENERATION- Print individual complete. Repeat steps 22-24 to stick all
addresses to a standard form that it has fields into your document.
already pre-formatted. 26. Save the main document.
-Creates a blank form document that 27. Choose Finish & Merge to edit, print or send
stimulates either a blank label or envelope your merged documents through email.
of pre-define size and will use the data file. 28. Or you may want to choose Preview Results
to check your work before sending it.
STEPS IN CREATING A SIMPLE MAIL MERGE: 29. Save and close your document.
1. Open MS Word and start a new blank
document. INTEGRATING IMAGES AND EXTERNAL
2. On the Mailing Tab, from the Start Mail MATERIALS
Merge group, choose Start Mail Merge →  PICTURES
Letters. a. JPEG (Joint Photographic Experts Group)-
3. Write your letter in MS Word, save it and supports 16.7 colors, suitable with full color
name it “Sample Letter”. photographic images.
4. Insert the fields you need in the letter b. GIF (Graphics Interchange Format)-
(CAPITAL LETTER). capable of displaying transparencies, and
5. Save the main document once more. simple animation.
(Ctrl+S) c. PNG (Portable Network Graphic)- transports
6. On the Mailings Tab in the Start Mail Merge images on the internet at faster rates, good
group, choose Select Recipients → Type a with transparencies, can display 16 million
New list.
 colors, allows control of transparency level LESSON 4
or opacity of images.
 CLIP ART
- Line art drawings or images used as
generic representation for ideas and
objects.

 SHAPES
- Printable objects that you can integrate
in your document to enhance its
appearance.

 SMART ART
- Predefined sets of different shapes
grouped together to form ideas that are
organizational or structural in nature.

 CHART
- Graphical presentation of data.
- Allows to present data characteristics
and trends.

 SCREENSHOT
- Integration of a more realistic image of
what the report is.

IMAGE PLACEMENT
MS – EXCELL PARTS AND FUNCTONS
 TEXT WRAPPING- allows you to place
images where you want in the document. Buttons
used to
 IN LINE WITH TEXT- image is placed change
totally aligned with the text line. how the
 SQUARE- allows the inserted image to be worksheet
place anywhere in the document with text content is
going around the image in a square pattern. dospalyed
 TIGHT- text hugs or conform to the general –normal,
shape of the image. page
 THROUGH- text flows even tighter, taking layout, or
the contour and shape of the image. page
 TOP AND BOTTOM- pushes the text away break preview view.
vertically to the top and/or bottom of the
image. Buttons to
 BEHIND TEXT- allows image to be dragged scroll the
anywhere but with all texts floating in front list of
of it. sheet
 IN FRONT OF TEXT- text is placed on top tabs in
of the image. the work
book.
 MS – EXCEL CREATING FORMULA

A sign that
tells Excel
that the
succeeding
characters
constitute a
formula.

 FUNCTIONS- are predefined formulas and

are already available in Excel.
 FORMULA BAR- the bar that displays the
contents of a cell.

FUNCTIONS TERMS TO REMEMBER:

BASIC MATH OPERATIONS  ACCOUNTING NUMBER FORMAT- a
 =SUM(x,y) or =SUM(range)- returns the number format used for accounting.
sum of x and y or (all the numbers within the  ORIENTATION- the angle to which text
range). displayed Ctrl+1 – shortcut key for
 =PRODUCT(x,y)- returns the product of x Format Cells Dialog Box.
and y.  COUNT- a function used to count the
 =QUOTIENT(x,y)- returns the quotient of x cells with content in a range.
divided by y.  SUM- a function used to compute for the
 =x-y- returns the difference of x substracted summation of the number of a range.
by y.  AVERAGE- used to compute for the
 =x+y- returns the sum of x and y. average of the number of a range.
 =x*y- returns the product of x and y.  COUNTIF- used to count the cells with a
 =x/y- returns the quotient of x divided by y. specified content within a range.
  SUMIF- used to compute for the 4. VISUALS- use graphics to help in your
summation of a range if the condition is presentation but not too many to distract the
met. audience.
 AVERAGE- used to compute for the 5. CONSISTENCY- make your designs
average of a range if a certain condition uniform.
is met. 6. CONTRAST- use light font on background
 RANGE- the range of cells where you or vice versa.
want to look for criteria.
 CRITERIA- a value or label that USING HYPERLINKS
determines if a cell is part of the range WAYS TO INSERT HYPERLINKS:
to be averaged. 1. Select an object or highlight a text.
 AVERAGE RANGE- the actual range of 2. Go to insert > hyperlinks or use the insert
cells that will be averaged, if omitted, the hyperlink dialog box.
range will be used instead.
 LINK TO OPTIONS:
ESTIMATING THE PRODUCT COST USING MS- A. EXISTING FILE OR WEB PAGE- saved in
EXCEL hard drive.
FOLLOW THE STEPS BELOW: B. PLACE IN THIS DOCUMENT- specific slide
1. Open Microsoft Excel. in presentation.
2. Type the name of your product and on each
space downward, write the ingredients’  WAYS TO INSERT HYPERLINKS:
name and their price on the opposite C. CREATS A NEW DOCUMENT- once
column. clicked, creates new document on your
3. Values with PHP of Philippine peso sign use specified location.
the Accounting Number Format. Its default D. E-MAIL ADDRESS- opens MS Outlook.
uses $ symbol. To change this into peso,
click the drop-down arrow at the currency 3. When done, click OK to apply your
button then select More Accounting hyperlink.
Formats, then change the symbol to PHP or
peso sign. EMBEDDING OBJECTS IB MS POWERPOINT
4. Use the SUM formula to get the summation EMBEDDING AN EXCEL FILE:
of the values from the 1st to the last 1. Go to insert Tab.
ingredient (Write the letter and no of the 2. On the TEXT group, click on OBJECT.
column only (=SUMC4:C70). Type this on 3. The insert OBJECT dialog box would
the column next to the last ingredient and appear:
name it as TOTAL.  OPTIONS:
5. Check is estimated price will own profit. a. Creates New
Type ESTIMATED PRICE(BELOW TOTAL). b. Create from file
Then below the estimated price, write Profit c. Once done click OK
and type (=C9-C8).
6. If you are not satisfied with the resulted LESSON 5
profit. You can make an adjustment. After a
space after the profit, write adjusted sale WHAT IS AN IMAGE?
price, below this type profit then on the A representation of the external form of a person
opposite type =C12-C8 or adjusted sale or thing in art.
price minus total.
Images may be 2-dimensional, such as a
TIPS IN CREATING EFFECTIVE PRESENTATION photograph or screen display, or 3-dimensional,
1. MINIMIZE- it is just a visual, most such as a statue or hologram. They may be
information should still come from the captured by optical devices – such as cameras,
reporter. mirrors, lenses, telescopes, microscopes, etc. and
2. CLARITY- consider how big the screen is natural objects and phenomena, such as the
during your report. human eye or water.
3. SIMPLICITY- use bullets or short
sentences, limit the context to six lines and
seven words per line.
GRAPHICS  PIXLR- also a multiplatform image editing
Are visual images or designs on some surface, program, almost similar to photoshop.
such as a wall, canvas, screen, paper, or stone to
inform, illustrate, or entertain. INFOGRAPHICS (Information Graphics)
Used to represent information, statistical data or
LAYOUT knowledge in a graphical manner usually done in a
Is part of graphic design that deals in the creative way to attract the viewer’s attention.
arrangement of visual elements on a page.
STEPS IN MAKING INFOGRAPHICS
BASIC PRINCIPLES OF GRAPHICS & LAYOUT 1. Create a piktochart account by going to
 BALANCE- visual weight of objects texture, www.piktochart.com.
color, and space are evenly distributed on 2. Click sign up and fill in the needed
the screen. information.
 EMPHASIS- An area in the design that may 3. After creating an account and logged in,
appear different in size, texture, shape or select a template under Free Themes on
color to attract the viewer’s attention. the Presenta Board, then select create.
 MOVEMENT- Visual elements guide the 4. Select the block on the Presenta Board
viewer’s eyes around the screen. Theme and input the information.
 PATTERN, REPETITION & RHYTHM- The TOOLS ON THE LEFT SIDE TO CHOOSE
repeating visual element on an image or a FROM:
layout to create unity in the layout or image. A. GRAPHICS- lines, shapes, icons,
 PROPORTION- Visual elements create a photos.
sense of unity where they relate well with B. UPLOADS- images
one another. C. BACKGROUND
 VARIETY- Uses several design elements to D. TEXT
draw viewer’s attention. E. STYLES- modify colors
F. TOOLS- create charts
BASIC EDITING TECHNQUES 5. Save your work and click on save, to save
1. CROPPING- Process of removing in your computer, click Download.
unwanted parts of the image focusing only
on one subject. ONLINE IMAGE FILE FORMAT
2. COLOR BALANCE- Allows you to make 1. JPEG Use: Real – life photographs, high
changes in the mixture of colors in an compression, does not support
image. transparency and animation.
3. BRIGHTNESS AND CONTRAST 2. GIF Use: Computer – generated graphics,
ADJUSTMENT- Adjusting the image tone supports transparency and animation.
(highlights). 3. PNG Uses: Screenshots, high compatibility,
4. COMPRESSION AND RESIZING supports transparency but not animation.
 FOR WEB UPLOADING- 72 dpi (dots per
inch) as standard resolution to maintain its TIPS TO EDIT IMAGES FOR YOUR WEBSITE:
image file size of 30-50 KB. 1. Choose the right file format.
 FOR PRINTING- 300 dpi and set the 2. Choose the right image size.
printing size in inches. 3. Caption it.
5. COLOR BLENDING- Use the different
special effects button and combine colors CREATING AND MANIPULATING IMAGES
and command to give you a more dynamic USING PHOTOSCAPE:
image result.  PHOTOSCAPE- A free image manipulation
6. COMBINING MULTIPLE IMAGES- Plan tool that has batch edit, viewer and paper
and conceptualize first to render the best features.
image and message possible.  EDITOR EDIT- Manipulating an image with
tools like Home Tab, Objects Tab, Crop,
ONLINE GRAPHICS SOFTWARE Tools.
 PICASA- a Google’s free desktop image  BATCH EDITB- Manipulate all images at
editing. the same time, useful when making
 FOTOR- a multiplatform photo editing galleries.
website.
BATCH EDIT-STEPS: 6. Click Customize Your Site.
1. Select the folder where the photos are 7. Once done, click Save.
located, drag the photos on the work area
(preview window). POSTING ON YOUR WORDPRESS BLOG
2. Use the tools on the right to edit your photo. 1. Go to Posts > Add New
(Filters Tab replaced Crop and Tools Tab). 2. Type a title, customize the URL (optional),
3. Resize the pictures. (don’t exceed to 800 the post in the editor.
pixels in width). 3. Compose a welcome message for your
4. Click on convert all. readers.
5. Click Save. 4. Set the Format
5. Add a category or tag for easily searching.
INSERTING, UPLOADING & SHARING PHOTOS 6. Preview your post, then click Publish.
OVER THE INTERNET
SAVING PHOTOS WITH PHOTOBUCKET CLOUD COMPUTING- Applications that do not
1. Sign up for a photobucket account. need any installation and are readily available in
2. Log in and click Start Uploading button. the internet.
3. Drag and drop photos to upload.
4. View uploads. ADVANTAGES DISADVANTAGES
5. Choose where to share your photo. No need to install No internet, no cloud
computing
LESSON 7 Easy access to your Require compatible
files software or browser
1. SOCIAL MEDIA PLATFORM- Allows you to Saves money Not own the software,
create not only personal accounts but also only renting it
pages and groups where you can share No need to update Security risk
content. Back up and data More prone to hacking
 “one-size-fits-all design (facebook)
 Linkedle- an example of LESSON 8
2. BLOGGING PLATFORMS- Focus on
content and design, looks like a newsletter HTML (Hypertext Markup Language)- contains
where you are given an option at change codes to create pages.
the design to your liking.
 Customization in blogs depends on CSS (Cascading Style Sheets)- contains codes to
content. design the page.
 Downside- the amount of
customization in blogs depends on WYSIWYG (What You See Is What You Get)- an
the CMS implemented by the editor that allows you to create and design web
provider. pages without any coding knowledge.
CONTENT MANAGEMENT SYSTEM (CMS)- a WEB DESIGN PRINCIPLES
computer application that allows the user to “Web design is a concept of planning, creating,
publish, edit and manipulate, organize and delete and maintaining websites.”
web content. Web design=communication
CREATING YOUR BLOG THROUGH 1. VISUAL HIERARCHY- Elements should be
WORDPRESS ranked according to its importance and
1. Visit www.wordpress.com and sign up. objectives.
2. If it’s your time, create your first blog, 2. PROPORTION- Make use of “golden ratio”
otherwise; click register another blog in My (1.618) Width-960px/1.618=593px Height-
Blogs. 760px, split into 470px & 290px
3. Pick a blog address, name it then click (760/1.618=470).
Create Blog. 3. HICK’S LAW- “With every additional choice,
4. Click on Change Your Blog Description or the time required to make a decision
Permissions. increases.”
5. Choose Appearance > Themes, select Free,
select any then click Activate.
 4. FITT’S LAW- The time needed to move to a WEB PAGE DESIGN: ADVANTAGES USING
target is dependent upon the size of the TEMPLATES
target as well as the distance to one target. 1. You know how your finished site looks.
5. ACCESSIBILITY 2. Faster turn around. You need not a lot of
- Typefaces must be readable to all. time on getting the colors and layout right.
- Make your own color palette and choose 3. Templates are much cheaper than hiring a
contrasting colors for the background web developer.
and written content. 4. Templates look much better then sites
- Make sure images are high quality and developed in traditional HTML
are suitable to your purpose. programming.
6. VISIBLE LANGUAGE- Should 5. Templates can be customized by anyone
communicate with the users clearly in an with basic HTML knowledge.
engaging manner: Organize. Economize,
Communicate. CREATING WEBSITE USING MS WORD
7. WHITE SPACE & SIMPLE DESIGN 1. Open MS WORD
- White space helps divide the web page 2. Type anything on the page
into several distinct parts or areas which 3. Click on File>Save As>Browse
makes it simpler for users to process 4. Create a folder and rename it
information. 5. On Save As, type select “Web Page”
OTHER THING TO REMEMBER: 6. Click the Change Title button, input the title
- Grid-based layout- columns, boxes, then click OK the Save.
sections
- F-pattern design- natural reading ONLINE TECHNOLOGIES
pattern like ”F”  PREZI (2009)- a presentation resources
- Conventional (conservative) that features a zoomable canvas.
8. REGULAR TESTING  EMAZE- features a propriety state-of-the-art
- TETO (Test Early and Test Often) HTML5 presentation maker that enables to
- Conducting usability test create slide shows, video and 3D
- Upgrades and updates presentations.

WED DESIGN ELEMENTS FILE MANAGEMENT & MAPPING

1. Links  MIND MAP- uses diagrams to represent
2. Forms tasks, words, concepts, or items linked to
3. Form Validation and arranged around a central concept or
4. Status Messages: Errors, Warnings, subject.
Confirmation  FILE MANAGEMENT SYSTEM- a type of
5. Animation: Pop-ups, Tooltips, Transitions software that manages data files in a
computer system.
WEB PAGE DESIGN: USING ELEMENTS AND  ONLINE MANAGEMENT SYSTEM-
ONLINE WYSIWYG PLATFORMS designed to manage individual or group files
(cloud based).
 WYSIWYG (“wiz-ee-wig”)- an editor or  MINDMEISTER
program that allows a developer to see - An online mind mapping tool that allows
what the end result will look like while users to create, develop and share
the interface or document is being ideas visually.
created. - A mind map editor for brainstorming,
EX. Adobe Dreamweaver, Rapidweaver, note taking, project planning, etc.
Microsoft SharePoint Designer  SIBELIUS
 WEB TEMPLATE- a ready-made design - An online platform used for writing
for website; images, navigation, sample music.
pages, flash animation. - A notation software that features a
 WIX, WEEBLY- examples of website magnetic layout and other tools good for
builder. music compositions.
 GOOGLE FORMS- a part of G drive that is
used for creating surveys.
 FACEBOOK GROUPS- allows you to create a
LESSON 9 group page that will allow people in your group to
communicate your ideas.
TERMS USED IN COLLABORATIVE ICT
DEVELOPMENT WORDPRESS- allows you to have multiple
 ONLINE COLLABORATION- Simply put, contributors for a single blog.
online collaboration let a group of people
work together in real-time over the internet. G SUITE- is a brand of cloud computing,
 WEB CONFERENCE- provides live productivity and collaboration tools, software and
audio/video communication between two or products developed by Google. It comprises Gmail,
more locations to conduct meetings, Hangouts, Calendar, and Google+ for
training, or presentation via the internet. communication.

DIFFERENCE ONLINE COLAB & WEB CONF GOOGLE DOCS, SHEETS, AND SLIDES- are a
The difference between Online Collaboration word processor, a spreadsheet and a presentation
and Web Conference is that Online collaboration is program respectively, all part of a free, web-based
sharing information to each other to come with a software office suite offered by Google within its
way to achieve the groups goal. While in Web Google Drive Service.
Conference is more like a meeting to discuss about
a certain topic. MICROSOFT OFFICE ONLINE- allows multiple
people to work on different office files.
SECURITY IS ESSENTIAL IN ONLINE
COLLABORATION MICROSOFT’S YAMMER- offers companies to
 ENCRYPTON- additional layer of security have their own social network that allows sharing
that makes content unreadable for people and managing content.
with malicious intent.
 SSL (Secure Socket Layer)- is the TRELLO- offer an online to-do checklist for your
standard security technology for entire team.
establishing an encrypted link between a
web server and a browser.

A GOOD COLLABORATIVE TOOL:

 Is easy to use;
 Has features that will fit your purpose;
 Are user-friendly and focused on real-time
updates; and
 Gives importance to security.

5 ESSENTIAL FEATURESMOF AN ONLINE

COLLABORATIVE TOOLS
 Easy and Clean Interface
 Permission Control
 File storage with document versioning
 Whiteboard
 Document locking

WEB PORTAL- is a website that contains

information from different sources and places them
in one location in a uniform way.

ONLINE COLLABORATIVE TOOLS- are tools that

can help your group “go the distance” and work as
if you already have your own office. Working
together does not necessarily mean you have to be
physically together.