So What Else Can You Do With a Spreadsheet?

We have looked at spreadsheets as a way to create a database, and explored how to use the function key and its many formulas to help us save time with calculations such as adding (sum) and finding percents. But what else can you do with a spreadsheet? This week you will check out Pamela Fox’s blog post, “Creating a Wordsearch Using Google Spreadsheet.” First you will need to brainstorm 15 words about a particular subject. It can be anything appropriate for school, but does not have to be school related. Once you have created your list of words, you will follow the instructions at the link above. Read carefully and think before asking questions. If you are using your effective effort strategies, you should be able to do this on your own. I will give you a couple of hints below:

Hint #1: Be sure to name your spreadsheet when you create it.
Hint #2: What is a URL and where do you find it?
**You actually can skip this step; as there is a gadget for wordsearches now.**
Hint #3: You may need to enlarge or expand your wordsearch by
grabbing a corner and dragging so you can see it all.

While you are working on your wordsearch I will be asking you collaborate on a class survey. When asked, you will stop working on your wordsearch, go to the shared form, and create a question for the survey. We will determine the topic of the survey at the beginning of class and have a quick demonstration of how to create questions using our Google forms. You will be completing another ILT classes’ survey in the next couple of weeks. We will then take a look at transforming the responses in to a chart or graph which could be imported in to a presentation. There are so many possibilities with our Google Docs!!!!

Spreadsheets

This week we will start off finishing up our paraphrasing and sharing the doc with me.  Once we have completed that lesson, we will start exploring spreadsheets.  You will be taking the, “School Spreadsheet Safari” using this link.  You will need to explore the definition, vocabulary, basics, and puzzle

tabs of this site.  Once you have gone through those four areas, you will take the quiz.  You will end class by completing a diagram of a spreadsheet using your Google doc (spreadsheets) as a resource.  Spreadsheets are used in many different occupations.  This will be a good introduction to the world of spreadsheets.