LET'S MEET ONLINE

LET'S MEET ONLINE! Call (512)560-2609 or email helpimnotageek@gmail.com and set up a time for a session. It works really well. We talk on the phone while I see your screen.
Showing posts with label spreadsheet. Show all posts
Showing posts with label spreadsheet. Show all posts

Monday, July 8, 2013

When I try to open a document it keeps opening in the WRONG Program

If you open your documents (word processing, spreadsheet, pictures, quicken, etc...) from the document icon on your computer usually it opens in the program that you created it in. If it opens the wrong program, what do you do?

This is the way that computers work: 
1.  Each file is automatically associated with a program. When you click on it that program opens up. 

2. Now and then, for various reasons (which really don't matter) your file opens up in a different program. Some examples of this are when you happen to have (like me) more than one word processor on your computer. You have created something in Word, but when you click on that document it opens up in Pages (or Open Office, Word Perfect), which you never use OR more commonly you click on a link from a website that you are looking at in Internet Explorer and it opens up a different browser (Safari, Firefox, Chrome, etc...).

3. This means that the file or maybe all files of that type now think that they are associated with the new program. 

If you know the steps it is pretty easy to switch them back the way you want them to be. The instructions below are for MAC and following that are PC.

CHANGING A FILE ASSOCIATION IN A MAC

1. Find the file that you want to change. Hold Control down and click on the icon or name if it is listed in a list of text.

2. A window will open with several choices. Look for the words GET INFO. 

3.  When you click on GET INFO a new window opens giving you lots of information about that file and ways that you can
work with it. Look down the list until you see a small box on the bottom that says OPEN WITH. It has a pull down window. It will show you all of the programs that can open this type of file. 

4. Choose the one you want. If you want ALL of the documents of this type to open in the program you chose CHANGE ALL. If you do not choose this it will just make the change on the one file. 

CHANGING A FILE ASSOCIATION IN A PC

1. Open DOCUMENTS to see your files OR find the document that you need to change in the way you are used to.  

2.  Right Click on the document name or icon. A window will come up. Look for the words OPEN WITH. 

3. A window will come up with the program that this file is associated with and a checkmark in the box next to USE THIS APP FOR ALL .DOCX FILES

4. At the bottom it says MORE OPTIONS. If you click this it will open a list of other programs that can open this document. If you want to change which program it opens with LEFT CLICK on that one. 

5. If you want ALL documents like that to open with the new program make sure there is a checkmark in the top box that says USE THIS APP FOR ALL DOCX FILES.

CHANGING WHAT OPENS WHEN YOU CLICK A LINK IN YOUR BROWSER



This applies to both Macs and PCs. The default browser settings are actually in the browser. They all have settings that say something like "Make this browser my default".  If you click this your links will always open in that browser. You can change it by going to the browser that you want to use and finding the "Make this browser my default" choice and clicking it. It will automatically change the settings so that the other browsers do not automatically open.

In the Mac Open up the Main Menu and choose Preferences. Click on the tab at the top that says General.  

In the PC look for Internet Options under either TOOLS or Settings (the little thing that looks like a gear). Choose the Programs TAB and then look for the words CHOOSE HOW YOU OPEN LINKS. Pull down to change the browser that you want to use.


Wednesday, December 19, 2012

Keeping a Christmas Spreadsheet

I don't know about you, but I can never remember what I gave to someone from year to year. I will go to the store and see something and think, "That would be perfect for Susie", but I am not sure if I get it for them every year, or if it is a new idea.




So I have started to keep a gift spreadsheet. It is very simple. In the first column I type the name of each person I want to give to each year. Then across the top row I type the number of the year. Then every year at Christmas shopping time I get out the list and I can see what I have gotten people for the last several years. I then add a new column for the current year and enter what I am giving this year.

This could also be done for gifts that you receive. Start by typing names of people that you have received gifts from in the first column. In the second column you could type what gift you received. The third column could be for checking off that you have written a thank-you note.













We use Google Spreadsheet in order to share the information for a silent auction for Child Development Center. On this shared spreadsheet we collect lots of information. Some of the columns include the item donated, the value of the item, the value of the minimum bid, how much it sold for, the address of the business, who found the donation and a place to check off that thank you notes were written. This is really handy because we all have access to the spreadsheet and can enter our information as soon as we find a donation. We can also look at the list to see what companies have already been asked, so we are not sending people to ask for donations to the same businesses and irritating them. Each year we start a new sheet of the spreadsheet, so that we can compare how we have done from year to year.



You can create a Google Spreadsheet by going to http://drive.google.com and then signing up for a free account. Once you are into the program you can choose if you want to make a webpage, write a document, create a spreadsheet or create a presentation. All of these programs work similarly to the programs you have used in the past. The main difference is that they save automatically on the cloud (Google's server bank) and you can share them with someone else. You can give the other person the option to edit the document or limit them to just reading it. You can also make the document private so that only you can see it.
Take a look at Google Drive and let me know what you think about it and if you have questions for me to research.

And finally Merry Christmas.

I hope you have a wonderful break

and can spend some time with family

doing things you love.


Monday, September 12, 2011

Google Forms

Google has a whole suite of programs that you can use online called Google Docs. These are very similar to Microsoft Office that most of us are familiar with, but the saved documents are stored on their server (the cloud!) so that you can access them anywhere. They can also be shared so that more than one person can access, read and edit the document depending on how you set it up.

Today I am going to talk about something called Google Forms because it is so cool and easy to use. Google Forms is similar to Survey Monkey or any other type of survey software. You create a form that can be filled out by other people and then the results are collected in one place and you can manipulate them there.

You must have a Google Account to use Google Forms. Once you have one and have logged in you can choose to create a form.

A window will open up where you can design your own form. The form is fairly self explanatory to fill in. You put in each question or statement, directions for those who are filling it out. Choose a question type and put a check to indicate whether it is required.

Google offers 97 different themes so that you can change the way that your form looks.

Once you have designed your form you can choose to email it to the people who you want to fill it out. A window opens up where you can type in email addresses or choose from the contacts that you already have in your Google Docs account. You can also embed the form into your blog or website so that people who go there can fill it out (see the sample at the bottom of the blog and fill it out if you want to!)

When people fill out the form the results are automatically recorded on a Google Spreadsheet that is tied to the form. They see a window allowing them to go back to the form or to create their own form. The spreadsheet looks like this.

You can pull down the Form menu and choose "summary of responses" to see graphs that summarize your responses. You can also easily put formulas into the spreadsheet to average or sum up any numbers in the responses.

I used this for a contest where judges had to score pictures that students drew. Rather than trying to get everyone together at the same time I set up a form and then routed the pictures to each person. They could record their scores on the form and then I could just average the spreadsheet and get the responses right away!

This is an example of an embedded form. Feel free to fill it out. I will receive the feedback!: