Tuesday, April 19, 2011

Computer Tips From A Computer Guy

Computer Tips From A Computer Guy


Generate Statistical Data About Your Facebook Friends

Posted: 19 Apr 2011 04:36 AM PDT

Have you ever wondered which of your Facebook friends posts the most photos or the most status updates? Do you know how many of your Facebook friends went to college?

Most of what we see about our Facebook friends comes from our news feeds and the occasional glance at their profiles—which reveals very little other than their relationship statuses and what they had for dinner on any given day.

Facebook Spectrum generates statistical data that helps us visualize information about the people in our friends list.

logo

Click the blue Login button on the top right corner of the Facebook Spectrum home page.

login

Click Allow when prompted to allow the service access to your Facebook account.

allow

The service will then start aggregating data about your friends. This process may take a long time, depending on the number of Facebook friends you have. You can close this window and come back later.

wait

Once loaded, the data Facebook Spectrum shows is very interesting. You can view a timeline of status updates for yourself, and any one of your friends. The little blue marks represent status update posts by month, day and year.

status

You can also view all of your friends' birthdays on a single calendar.

birthday

A map of the world reveals where all of your Facebook friends live.

map

You can also see how many of your friends are male versus female.

gender

If you are interested in determining what percentage of your friends have a college or graduate school education, you can see this information on a pie graph. We were amazed by how many of our friends did not go to college.

college

Or, view a pie chart showing which of your friends post the most pictures.

photos

Facebook Spectrum offers a unique way to think about our Facebook friends. We found the map of where our friends live in relation to each other the most interesting—it is amazing to see how far apart our friends live!

The only complaint we have with the service is the amount of time it takes to aggregate the data for the first time. We waited more than an hour, and when no results displayed, we thought the service did not work—only to retry it the next day and see the data appear instantly.


Copyright © 2007
Online Tech Tips.
Aseem Kishore (digitalfingerprint: a59a56dce36427d83e23b501579944fcakmk1980 (74.125.94.84) )

Post from:

Generate Statistical Data About Your Facebook Friends


How to Create Form Letters in Word 2010

Posted: 18 Apr 2011 05:31 AM PDT

Sometimes you may want to create a letter that you will be sending to a lot of different people, but you'd like certain parts of it to be individualized to the addressee; parts such as the greeting, name, address, etc.; which means, you want to create a form letter, which is great, because Microsoft over the past several versions of Word has been making it easier to do so.

To begin, create a document that has the standard stuff in it, here's an example Christmas letter:

Bare Letter

Notice how it has no salutation, address,etc., this is because those will all be added as fields later.

The first thing you need to do is click on Select Recipients, on the Mailings ribbon:

Select Recipients

This is where you add the people that will be receiving the letter.

Recipient Dropdown

Click Type New List… to start adding people, then add several names:

Address List

Note: When you go to save your recipient list, Word will prompt you for a location on your hard drive to save the data file that will be created.

Once you save your recipients list, you should notice that a lot of the icons that are on the Mailings ribbon are highlighted now. To start adding fields to your from letter, click a spot in your document to indicate where you want the field to be placed, then click on Address Block:

Address Block

Here's what it looks like:

Address Block Format

Click OK to go with the default format, you should get something that looks like this:

Address Block Inserted

Next, add an Enter after the Address Block to move your text down a line, then click on the Greeting Line icon:

Greeting Line Icon

You should get something like this:

Greeting Line Format

Once again, let's go with the default format and just click the OK button.

Next, highlight where it says <Address Block> click your right mouse button, chose Paragraph, then check the box next to where it says Don't add space between paragraphs of the same style, then click the OK button. This will make the address block hang together correctly instead of having a blank line between each part of it.

Then, click on the Preview Results icon, your document should now look something like this:

First Preview

When you're done previewing, click the Preview Results icon to turn off previewing.

Next, to see how to add other fields, click just past the <Address Block> in your document to make that your current position, then click on the Insert Merge Field icon.

Instant Merge Field Icon

You should get something like this:

Instant Field

Choose Country or Region, then click on the Insert button, you should get something like this:

Merge Field Inserted

Try clicking the Preview Results icon again to see how it looks, it should look something like this:

Country Added Previews

Now that you have your form letter looking as you want it, you might decide that you want to add some particular text for some of your recipients, but some other text to others; to do that, click where it says Rules

Rules

…you should get a screen like this dropdown:

Rules Dropdown

Choose If…Then…Else, to get this screen:

IF Then Else

Change the Field name: to Country_or_ Region, and type USA into the Compare to: field, and then add some text to the boxes where it says Insert this text, and Otherwise insert this text. In this example if the recipient lives in the USA, they will get the text, Merry Christmas inserted into their letter, while everyone else will get the message, Seasons Greetings.

Here's what it will look like once you click the OK button and then the Preview Results button.

Add Merry Christmass message

Next, note the Preview Results section:

Preview Results Section

Here you can click on the arrow buttons (when Preview Results is turned on) to the left and right of the number to scroll though all of the letters that will be sent out. This way you can make sure that all of your letters will look right before sending them out.

Note: The match fields menu choice under Rules is for matching field names in a database with header names in your recipients list.

Also to make it easier to see where you've inserted fields into your document, use the Highlight Merge Fields button:

Highlight Fields

It's a toggle you can turn on and off at your discretion.

And finally, when you're happy with your letter, click the Finish & Merge icon:

Finish & Merge

You should get this dropdown menu:

Finish & Merge Dropdown

Choose Edit Individual Documents to get Word to merge all your letters together into your current document; that way you can look it over before printing or sending as an email.

As you can see, creating form letters with Word is no longer the chore it once was, you can create documents quickly and and send them out without much trouble; now that you've learned how.


Copyright © 2007
Online Tech Tips.
Aseem Kishore (digitalfingerprint: a59a56dce36427d83e23b501579944fcakmk1980 (74.125.94.84) )

Post from:

How to Create Form Letters in Word 2010


0 comments:

Post a Comment

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Justin Bieber, Gold Price in India