Tuesday, January 31, 2017
Tuesday, January 24, 2017
Photo Editors
Piktochart is a
web-based infographic application which allows users without intensive
experience as graphic designers to easily create professional-grade
infographics using themed templates.
PhotoScape is a graphics editing
program, developed by MOOII Tech, Korea. The basic concept of PhotoScape is 'easy and fun', allowing users to
easily edit photographs taken from their digital cameras or even mobile phones.
Photobucket is an American image hosting and video hosting website, web services suite, and online community dedicated to preserving and sharing the entire photo and video lifecycle.
Photobucket is an American image hosting and video hosting website, web services suite, and online community dedicated to preserving and sharing the entire photo and video lifecycle.
RESOURCES
https://en.wikipedia.org/wiki/Piktochart
https://en.wikipedia.org/wiki/Photobucket
https://en.wikipedia.org/wiki/PhotoScape
Basic Principles of Graphics and Layout
Proximity
Proximity means grouping elements
together so that you guide the viewer/reader to different parts of the message.
Notice below in the template on the left, taken from Apple’s Pages,
related elements are grouped together, as opposed to the linear arrangement of
amateur designs as shown on the right
Alignment
Another important design principle
is aligning elements in a visual and readable arrangement. Most amateur
designers start off by aligning everything in the center of the page, but
that’s not the only way. Again with the “scattered” looking design, we can see
the alignment of elements that helps keep the design balanced. The top group of
text is left-aligned, and three larger text elements are vertically aligned.
Repetition
Like the use of repetitious hooks in
a song, repeating elements in a graphic design can be visually appealing. In
the two examples below, a numbered list is used, but there’s also the
repetition of the blue circles that make a bolder statement.
Contrast
Contrast between design elements can
make a presentation stand out and get noticed. Take for example this original
template from the personal graphic design site, Canva.com. The
elements of the design are grouped together, with strong alignment and
repetition of of the arrows and bullet points. But for some
purposes, the original design could be a little flat.
White Space
Depending on the presentation, the
use of white space can be very powerful in design. It’s useful when you want to
make a direct message, to stand out above the clutter found in many graphic
designs. In this Canva business card template, the empty space helps bring
clarity to the message.
Resources:
Tuesday, January 10, 2017
How to use hyperlinks
In PowerPoint, you can
use hyperlinks to link to resources that are not online. To create a quick way
to refer to another slide in your presentation, you can create a hyperlink to
that slide. If you need to access a file stored on your computer, you can create
a hyperlink to it. Additionally, PowerPoint allows you to format pictures and
shapes as hyperlinks.
To insert a hyperlink
to another slide:
1. Right-click the selected text or image, then
click Hyperlink.
2. The Insert Hyperlink dialog box will appear.
3. On the left side of the dialog box, click Place in this Document.
4. A list of the other slides in your presentation will appear.
Click the name of the slide you want to link to.
5. Click OK. The
text or image will now be a hyperlink to the slide you selected.
Resources: http://www.gcflearnfree.org/powerpoint2013/hyperlinks-and-action-buttons/2/
Thursday, January 5, 2017
Excel Formulas
EXCEL FORMULAS
1. SUM
Formula: =SUM(5, 5) or =SUM(A1, B1) or
=SUM(A1:B5)
2.
COUNT
Formula: =COUNT(A1:A10)
3.
COUNTA
Formula: =COUNTA(A1:A10)
4. LEN
Formula: =LEN(A1)
5.
TRIM
Formula: =TRIM(A1)
6.
RIGHT, LEFT, MID
Formulas: = RIGHT(text, number of characters), =LEFT(text, number of
characters), =MID(text, start
number, number of characters).
(Note: In all of these formulas, wherever it says “text” you can use a
cell reference as well)
7.
VLOOKUP
Formula: =VLOOKUP(lookup_value, table_array, col_index_num,
range_lookup)
8. IF
Statements
Formula: =IF(logical_statement,
return this if logical statement is true, return this if logical statement is false)
9.
SUMIF, COUNTIF, AVERAGEIF
Formulas:
=SUMIF(range, criteria,
sum_range), =COUNTIF(range,
criteria), =AVERAGEIF(range,
criteria, average_range)
10. Manually
enter Excel formulas:
Long Lists: =SUM(B4:B13)
11. Click the Insert Function button
=COUNT(B4:B13) Counts the numbers
in a range (ignores blank/empty cells).
12 Select a function from a group (Formulas tab)
=TODAY() Inserts today’s date.
13. The
Recently Used button
=AVERAGE(B4:B13) adds the list,
divides by the number of values, then provides the average.
14. Auto
functions under the AutoSum button
=MAX(B4:B13) returns the highest value in the list.
=MIN(B4:B13) returns the lowest value in the list.
15. =DAYS
Formula: =DAYS(A30,A29)
16. =NETWORKDAYS
Formula: =NETWORKDAYS(A33,A34)
17. =TRIM
Formula: =TRIM(A39)
18. =CONCATENATE
Formula: For dates enter: =CONCATENATE(E33,” “,F33,”,
“,G33)
Formula: For phone numbers enter:
=CONCATENATE(E37,”-“,F37,”-“,G37)
19. =DATEVALUE
Formula: =DATEVALUE(H33)
Resources:
Tuesday, November 29, 2016
HOW TO MAIL MERGE
Mail Merge is a powerful tool for
writing and sending a personalized letter or e-mail to many different people at
the same time. You can also use it to create envelopes or labels with each
recipient' information. Mail Merge imports data from another source such as
Excel and then uses that data to replace placeholders throughout your message
with the relevant information for each individual you are messaging. You can
use it to quickly create personalized messages for hundreds of people at once.
Mail merge is used to batch-process
many personalized documents in Microsoft Word and other office suites. Both
a template letter and a database or spreadsheet with the required information
is needed. The template letter is then filled with the details found in the
database.
PART I – ADDING RECIPIENTS
1. 1. Understand what the Mail Merge function allows you to
accomplish. Mail Merge is a feature designed for creating mass mailing
and emails, as well as envelopes and labels with different information on each
one. You can load a database of recipients or manually enter them, and then use
placeholders, or "Fields", to automatically fill in each recipient's
information in their own copy. This allows you to create one document that you
can send to hundreds or even thousands of people.
2. 2. Create a recipient spreadsheet (optional). You
can manually enter each recipient during the Mail Merge process, which is fine
if you have just a handful of people you're messaging, but you'll find things a
lot easier if you have a spreadsheet or database of your recipients before you
start.
3. 3. Click the "Mailings" tab to open the Mail Merge
tools. If you are using Word 2003 or older, click the
"Tools" menu and select "Letters and Mailings" → "Show
Mail Merge Toolbar".
4. 4. Click the "Start Mail Merge" button and select your format. You can use Mail Merge
to create emails, letters, envelopes, labels, and directories. You can also
select "Normal Word Document" if you're not sure.
If you select "Envelopes",
the Envelope Options window will appear, allowing you to choose how your
envelopes will be formatted as well as the physical envelope size.
If you select "Labels",
the Label Options will appear, allowing you to choose the type of label paper
as well as the size of each label.
5. 5. Click "Select Recipients" and select how you want to add
recipients to the Mail Merge. Recipients are the most powerful part of Mail Merge,
as they allow you to replace placeholders, or "Fields", in the letter
with each recipient's personal information. You can manually enter your recipients,
load a database or spreadsheet file, or load your Outlook contacts.
If you select "Type a New
List", a new window will open which will allow you to manually enter each
recipient's information. This is useful if you don't have access to a spreadsheet
with your recipients' information in it, but it is also the slowest way to
enter the data. You can click Customize Columns... to create custom
fields for the data you are entering.
If you select "Use an Existing
List", you can browse your computer for a variety of different spreadsheet
and database files, including Excel and Access. You can also click the New
Source... button and connect to an SQL server online.
If you select "Choose from
Outlook Contacts", your Outlook contacts will be loaded, and you can
deselect all of the contacts you don't want to include.
PART II – CREATING THE DOCUMENT
1. Start creating your document as you normally would. Once
you have your recipients entered, you can begin creating your document. You can
make it from scratch or use any template. It's important to enter your
recipients first so that you can use the appropriate fields while creating the
document.
2. Click the "Greeting Line" button to create a custom
greeting. You can use the preview in the window that appears to see how
it will appear on each copy of the Mail Merge.
3. Click the
"Insert Merge Field" button and select the field that you want to
insert in the document. These fields will then be replaced with the data from
the recipient database when the documents are generated.
For example, if you want the document to display the
recipient's first and last name, you would select "First", push Space,
then click the "Insert Merge Field" button again and select
"Last".
For another example, you can use the
"Address Block" button to create envelopes with each recipient's
address printed on it. Type your own address into the return address area of
the envelope template, and then add the "Address Block" to the
recipient area of the template.
You can select any field that
contains recipient data. Make sure that it applies to all ofthe recipients on
the list, as blank fields will be very obvious when reading the document.
4. Click the "Highlight Merge Fields" button to make
the inserted fields stand out.This make
it easier to tell how the fields look while editing.
5. Click the "Preview Results" button to see how the
final product will look. The display will toggle
to show the Mail Merge document filled out with your first recipient's
information.
PART III – COMPLETING THE
MAIL MERGE
1. Check for errors. Click
the "Check for errors" button to have Word scan each document in the
Mail Merge to ensure that all recipients have valid data for each of the
fields. Any invalid results will be reported, allowing you to fix them before
proceeding.
2. Finish the merge
process. Once you have finished checking for errors, you can
finish the merge process and create the individual documents. You have three
options when you click the "Finish & Merge" button:[1]
"Edit Individual
Documents" - You will be able to choose which entries you want to perform
this action on. Once you do, a new document will be created, with each entry as
a new page. You can then go through and make manual edits to each one.
"Print Documents" - You
will be able to choose which entries you want to perform this action on. Once
you do, the documents will be sent to your printer, where each individual one
will print.
"Email Documents" - You will
be able to define the Subject line as well as select the Field that contains
the recipients' email addresses. You will then be able to send the bulk email
message off using Outlook. Note that this will immediately send the message, so
make sure everything looks good!
RESOURCES:
Tuesday, November 22, 2016
PRIVACY POLICY OF YOUTUBE AND TWITTER
YouTube provides you,
the uploader, an opportunity to remove or edit the private information within
your video. We email you about the potential violation and allow you 48 hours
to take action on the complaint. If you remove the alleged violation from the
site within the 48 hours, the complaint filed will then be closed. If the
potential privacy violation remains on the site after 48 hours, the complaint
will be reviewed by the YouTube Team.
If we remove your video for a privacy violation,
please do not upload another version featuring the same people. These
individuals will likely file another privacy complaint or report you for
harassment. We are serious about protecting our users and suspend accounts that
violate people's privacy.
In twitter,
they receive information when you interact with their Services, even if you
have not created an account (“Log Data”). For example, when you visit their websites,
sign into their Services, interact with your email notifications, use your
account to authenticate to a third-party website, application, or service, or
visit a third-party website, application, or service that includes a Twitter
button or widget, they may receive information about you. This Log Data may
include your IP address, browser type, operating system, the referring web
page, pages visited, location, your mobile carrier, device information
(including device and application IDs), search terms, or cookie information. They
also receive Log Data when you click on, view or interact with links on their
Services, including links to third-party applications, such as when you choose
to install another application through Twitter. They use Log Data to make
inferences, like what topics you may be interested in, and to customize the
content they show you, including ads. They keep Log Data as needed for the
purposes described in this Privacy Policy. They will either delete Log Data or
remove any common account identifiers, such as your username, full IP address,
email address, or phone number, after a maximum of 18 months, if not sooner as
provided below for Widget Data.
Resources:
https://twitter.com/privacy?lang=en
https://www.youtube.com/static?template=privacy_guidelines
Subscribe to:
Posts (Atom)