ETECH 2

2 components of mail merge

- Form Document

- List or Data file

Form Document

- First component

- It is generally the document that contains the main body of the message we want to convey or send. The main body of the message is the part of the form document that remains the same no matter to whom you will send the message from among your contact list.

Data fields or Merge fields

This marks the position on your form document where individual data or information will be inserted. From our sample document, the placeholders are denoted or marked by the text with double-headed arrows (<< >> on each side and with a gray background.

List or Data file

- 2nd component

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

Hyperlinks

- uses to link to resources that are not online.

- A quick way to refer to another slide in your presentation

Microsoft excel

- a spreadsheet application that can help you calculate and analyze numerical information for budgets, company finances, inventory, and more.

Cell references

Relative and Absolute

Relative references

- can save your time when you're repeating the same type of calculation across multiple rows or columns.

Functions

a ready-made formula in Microsoft Excel which performs a series of operations.

SUM

Adds all cells in the arguments

AVERAGE

Calculates the average or mean in a range of cells

MIN

Compute the minimum value in a range of cells

MAX

Compute the maximum value in a range of cells

COUNT

Counts the number of cells in a range of cells

Infographic

- Information Graphics

- refers to an image that combines information, storytelling, and perceptions that help the cause of an individual or an institution to communicate a message to viewers.

- ways of presenting data information using visual tools.

Basic principles of graphics and layout

- lines

- color

- shapes

Lines

- the most basic of all the elements

- can define the characteristics of an infographic

- can form shapes that can catch the attention of a viewer. They can be sharp, be made up of broken lines and fine or thick lines, and can create different impressions to viewers.

Color

- one of the powerful and influential elements in an infographic.

- Using the right combination of colors can catch the attention of a passerby or even glancing viewers.

Shapes

- These are defined by the enclosure created by a combination of multiple lines.

- are universal symbols that do not require language

Online image file formats

- JPEG

- PNG

- TIFF

- GIF

.jpeg

- Joint Photographic Experts Group

- 24-bit color with up to 16 million colors great for photographs that need fine attention to color detail. Most accepted file format.

- Cannot be animated. Does not support transparency.

.tiff

- Tagged image file format

- Supports several types of compression like JPEG, LZW, ZIP or no compression at all. High quality image format.

- Very large file size— long transfer time, huge disk space consumption, and slow loading time

.gif

- Graphic interchange file

- Can support transparency. Can do small animation effects. Great for images with limited colors, or with flat regions of color

- Only supports 256 colors

.png

- Portable network graphics

- Does not lose quality and detail after image compression creates smaller file sizes than GIF.

- Generates a very large file, creating larger files than JPEG. Cannot be animated. Not supported by all web browsers.