Monday, March 17, 2014


Challenge #1: 

Complete Google a Day.  Put results in spreadsheet.

Challenge #2: 

Some of you have experience with spreadsheets, some of you don't.  This next challenge will be a good way to get us started.  Create a new spreadsheet in your google Web Apps folder and name it "Challenge 2: Spreadsheet".

Design a spreadsheet that includes the following information:
  • Monthly sales figures need to be collected.
  • Mr. Jones, Ms. Smith, Mr. Williams, and Miss Stanley are the sales people who work for "Schneider Corp".
  • Schneider Corp sells farm equipment.  Tractors cost $10000, Mowers cost $5000, and Plows cost $15,000.
  • Mr. Jones sold 3 tractors, 2 mowers, and zero plows this month.
  • Ms. Smith sold 1 tractor, 1 mower, 1 plow.
  • Mr. Williams sold 5 plows.
  • Miss Stanley sold 2 tractors, 2 mowers, 1 plow.
The spreadsheet should show me total $$ each sales person sold, total # of each item sold, total $ of each item sold.  Finally what was our total $$ sales for the month?
I will walk around and help you.  Also use google and the help menu to figure out your formulas.  It may help some of you to draw it out on paper first.

Challenge #3:
Create a Google Presentation of your class schedule.  A few rules:

1. You can only have 10 slides.  Not 9, not 11, but 10.
2. You must spend some time reading about Presentation Zen.  Really check out some of the tips.  I will not accept poorly designed slides.  If you took my freshman seminar class you are very familiar with these rules.
3. You can only use YOUR photos or drawings OR photos you find using a CC search.  Plagiarism applies to photos as well as text.  If you search within Google Docs (click insert image) those images will be CC images.

Name the presentation "Schedule" and save in your folder.

Challenge #4:
If blogger is back up, please ensure you have completed your tests and posted to Google+

Donate some rice to support world hunger.

No comments: