Thursday, June 19, 2014

Final Exam

Below is the final exam for Spring 2014 Web Applications.  The exam must be completed in class before the end of the assigned period.  All work must be your own.  However, you are free to search the internet or look at any previous work.

Blog Post (50pts):
What is the effect of violent video games on behavior?  Create a blog post that answers this question.  Your blog post should include all elements of modern web writing.  You must post your response to the Google+ community.

HTML (50pts):
You will create a two-page website.

  • Create a folder.  Name it (firstinital, lastname, project----bschneiderfinal)
  • All work will be in this folder.
  • I choose a topic many of you nothing
    • Your home page will be a picture of a flower.  
      • Name this file home.html
      • Heading = FLOWERS
      • Background color = YELLOW
      • Place an image in the center of the page.  
      • Below the image write "For more information click here".  Click here will link to page2
    • Your second page will include information.
      • Name this file page2.html
      • Link back to home page
      • Heading = Flower Images
      • Background color = YELLOW
      • Create a table with a border.  4 rows, 2 columns.

      Flower Image
      Daisy put daisy image here
      Rose put rose image here
      Tulip put tulip image here

    Save folder to UDrive-WebApps folder when done.
Your exam is done when you post your blog to Google+ and save your website to your folder on the UDrive.  Please remain quiet until the bell rings or until all students are done with their exam.

Sunday, June 15, 2014


Last chance to submit missing work.  If you have missing work that you turn in be sure that you tell me so I mark it in the gradebook.  Grades will close when the bell rings.

Your exam will include:

  • Writing of a blog post that includes links, images, and video.
  • Coding of an HTML website that has at least two pages.
  • Saving of HTML website in appropriate spot on UDrive.
  • Completing all work in allotted time.  The exam is designed to take 60-75 minutes.  Those of you who require extra time have the entire 2 hour block.  If you finish early you must stay in room.  

Wednesday, June 11, 2014

Thursday Work

1. Read the NYTimes article "Do our kids get off to easy?"  Write a blog article.  Do you agree with the author?  Post to Google+ community.

2. Complete a Google A Day.

3. How many red dots do you have?  Remember, if you get a red dot from ten different countries you do not have to take the final exam.

4. Complete the Intro in Scratch.  If you did this before it will take you 2 minutes.  Show teacher when done.

5. Make five substantive comments on classmates blogs.

6. Watch this short film from a few years back.  Youtube has exploded the popularity of short films.

Monday, June 09, 2014


Your final exam will occur next Thursday in this room (104).

Your exam will require you to code and create a working website.  You will have to save the website to the UDrive.  We will practice this today.



1. Create a folder on your desktop.

  • Name it using the following protocol; first name, last name, project (brandtschneiderfinal).
  • Save your BEST webpage to this folder.  Copy any needed images into folder.
  • Copy folder to UDrive-WebApps.
2.  Complete 700pts in Code Avengers.

3. Complete any missing work.

4. Using Hopscotch code a task that is "Etch-a-Sketch".  Have you seen the task that draws the shells of the Sydney Opera House?  Can you recreate that?  Or maybe try the Eiffel Tower, or Seymour High School, or Yankee Stadium?  Make it fun.  Share with teacher when done.

Friday, June 06, 2014

TED Video

I would like you to watch at least three videos today from start to finish. Everyone must watch the Bobby McFerrin video. I give you some prompts to start a discussion on your blog. Some of these videos are about 10-20 minutes long. All are from a few years ago.

Please write a substantial blog post that reviews the videos.  Be sure to embed or link to videos and any additional information.

Hans Rosling: How data is cool. Think of your little Excel charts. Will you be ready to use data like this? This guy is fun to listen to.
Jeff Han: How displays will change. This would profoundly change how we use computers.  This is from six years ago.  How fast technology evolves (Hello iPod!).

John Maeda: A smart, funny guy talks about simplicity. Think about how simplicity is the driving force in design (hint: iPads).

Rives: This guy can talk.  Power of the spoken word.  I laughed out loud (also notice his use of powerpoint).  Check this poem about the internet by Rives.  Fascinating (and why you should work on your poetry).

Bobby McFerrin: How does that work without rehearsal?  Is music hard-wired to our brains?  Bobby's genius is awe inspiring.
John Bohannon: Why you should dance and not use powerpoint.  This is super-awesome. Can dance make you understand science?  Do that google search he speaks about. Any dancers here?  That would be an AWESOME project.
David Blaine: Not for the faint of heart.  Is he crazy, or focussed?
William Kamkwamba: Inspiring.  Many of you are 14.  What is on your resume?  Think about all that you have to work with here.
I will grade the work from Wednesday today.  Be sure it is submitted.

Tuesday, June 03, 2014

Wednesday Work

1. Complete the following HTML code:

  • First 8 tags
  • Title = Your Name
  • Heading = Thanksgiving
  • Create a simple website that explains Thanksgiving to a non-American who is visiting this country.
  • The background color must not be white.  
  • The webpage must include links to information.
  • The webpage must include an image.
Test your website.  Print out code and hand to teacher.  Be sure your name is in the Title.

2. Print out your code avengers page.  700 points.  Make sure your name is on paper.  Hand to teacher.

Sunday, June 01, 2014

Return home

1. Over the weekend we heard the news that Sgt. Bowe Bergdahl was released as prisoner of war by the Taliban.  He went missing in June of 2009.  After five years the world has changed a lot.  If you were briefing the Sgt. about technology changes what five things would you focus on?  Please write a blog post that highlights the technology shifts of the last five years since June 2009.  Your blog post should include images and links and have distinct paragraphs, including a clear introduction.

This should take you awhile.  Test grade.  I am looking for an expertly crafted article.

2. Continue codeavengers work.  700 pointts is new goal.

3. Play with Scratch.

Wednesday, May 28, 2014


1. Today students will explore Scratch, the programming language from the people at M.I.T. This program is designed to teach some basic programming functions. With this program you can do some basic behavior and game functions and produce some cool things. It looks a lot like the Hopscotch game we have been playing.

Click "Try it" to play.

Explore the website.

Can you make your own game?

Show me something that you create.

2. Please ensure you are caught up on your blogs and coding (600pts).

3. What do you think about Google's Car?  Please write a descriptive blog post about the new car.  Be sure to include an image or video.

4. Did you create a resume?  Post it to your blog if you did (not required).

Monday, May 26, 2014

Tuesday Work

1. HTML review.  We will do this together.  This will be turned in today for a grade.
2.  Play around with,  and . I give you the option to create an account and explore this software.  There is a free account option that asks for your email address.  This is an optional assignment.  I've done this with previous classes and they have loved using it.
  • Rate the usability of one of the geneology sites.
3. Check your comments and red dots on your blog.  Any progress?
  • What if you got 1 point for each red dot and needed to get to 100pts to pass.  How would your blog strategy change? 
4. Create an online resume using Vizualize.MeGoogle SitesRe.Vu or Weebly.  Which site works best for your needs? Check out some of these resumes:
  • Should you have a traditional resume and an infographic website?  
5. Coding is getting a lot of press lately.  You have spent a good part of this class learning some basic coding.  We know most of the innovation that is happening the world requires coding knowledge.  
  • Should coding be a required course?  Should it be a math credit or science credit?
Answer one of the above blog reflective questions based on what you do today.

Tuesday, May 20, 2014

Red Dots


1. If you get red dots from ten different countries you will not have to take your final exam.  How can you improve the reach of your blog?

2. Utilize an online/free animator like PowToon to add a video to any of your websites.  If PowToon doesn't work search for another option.

3. Play with  This is a bit easy, but it will help with coding logic.  Can you solve all the problems?

4. Take the typing test .

  • Put your score in your blog (be honest!) and see if it improves later.
  • Don't say "I took a typing test". Say "I took a typing test". Demonstrate that you know how to code a link.
  • Compare to scores from previous tests.
5. Can you create a musical instrument using the Makey Makey?

6. Can you code Hopscotch on the iPad so the character draws a circle?  A stick figure?

In addition:
1. Ensure all tests are completed.
2. 600pts in Code Avengers.

Monday, May 19, 2014

Tuesday Work

Hacking basically means to create something new.  Often it takes a negative connotation--"He hacked into the computer files"--but it in schools we are seeing more and more students hack solutions.  The Makey Makey is a product of hacking.

I enjoy following Music Hack Day.

Today we will practice our HTML skills while we look at Johnny Lee.

Johnny Lee wowed the TED crowd when he showed how he can use a Wii Remote to make a cheap interactive Whiteboard. Please create a website that does the following:
  • Embed the TED video (How do you embed a video?) 
  • Create a table that lists the parts needed and their approximate cost. (Can we format the table so TH and TD are used effectively?  Should there be a border?)
  • Links to more information. Use google to search effectively. (How will you display this information? A list?  A paragraph?)
  • A basic description of how it is done.  (Be sure your website explains the process.  Can you write an effective description?)
Show me when done.

Thursday, May 15, 2014

Friday Activities

1. I will distribute grade sheets.

2. Students who are done with all work will do the following.  I am encouraging you to use Google to search for ideas.  If you figure something out use your blog to document so other people can use YOU as a resource.  First bullet point is easiest, progressing to harder:

  • Use the Hopscotch App on iPad to:
    • Can you have character draw a square?
    • Can you have character draw a loop/circle?
    • How about your signature?  Or a stick figure person?  These are a series of loops and lines.  Can you program it?
  • Use the Makey Makey to:

Tuesday, May 13, 2014

Wednesday Work

Both tests should be completed at this point.

Today you should practice making effective blog posts by reading and writing about the two articles.  Please format the blog posts using modern tools and design.

In addition I would like you to work on your coding.


1. You must do todays Google A Day and record your answer.

2. Please complete 600 pts on Code Avengers.

3. Please read the debate on the NYTimes about coding.  Each entry is only a few paragraphs.  Please write a blog post that answers the following:

--Should coding be taught in schools?  
--At what age?

Provide evidence and links from the article.  Be sure to post to the Google+ class community.

4. Can you answer the question "Should a Robot Sacrifice Your Life to Save Two?".  Please debate this in a blog post and post to Google+.  You must comment on at least five classmates blogs with comments that extend the conversation.

Saturday, May 10, 2014


There are two test grades out there right now:

1. Snow Fall.  Some of you completed this, but I asked you to resubmit it.  Please make any needed corrections.  I am testing your reading of content and your ability to create a modern blog post.

2. Favorites.  Some of you clearly needed more time on this.  Some of you, however, did not work on it at all.  Please be sure to complete today.

Both assignments must be submitted, and correct, by the end of class.

In addition:

1. You must do todays Google A Day and record your answer.

2. Please complete 600 pts on Code Avengers.

Wednesday, May 07, 2014

HTML Tables

Spend some time reading and practicing creating tables in HTML.  Its not that hard, but it requires a precise order of codes.  Pay attention.

Know the difference between TD, TR, TH.


Create an HTML website that will demonstrate some HTML skills.

1. This assignment is called "Favorites". Create a folder in your HTML folder.

2. Create a four page HTML website. Save the four pages as home, foods, music, school. (Do you know how to create pages in notepad and save them in a folder?  Be sure to create them with the first 8 tags that are in every HTML page)

3. On the home page include an MSPaint image of you that you create and include links to the other pages. This is your landing page. (Can you save the picture in the right spot so it can be embedded in your webpage?)

4. Foods (Can you find a CC image and search for effective information?):

  • List your three favorite foods using an An ordered list.
  • Include an image from a creative commons search on flickr. Notice the difference when you click "interesting" vs. "relevant"
  • Include a link to a recipe of your favorite food.

5. Music (Can you make this page visually interesting and consistent with the other three pages?):

6. Schedule (Can you code a table?  Can you code it so the display makes sense?):
  • Include your schedule using a table.
  • Use an underline code somewhere.
  • Make the table border blue.

7. Layout/Other (Does your site look modern and effective?)
  • Be sure to link all pages together.
  • Include links where there should be links.
  • All pages should look uniform and connected.
  • White background color.

Monday, May 05, 2014

Snow Fall

Today we will read the Snow Fall.  Everyone is talking about this piece in the NY Times.  It won a Pulitzer Prize which is a top award for newspapers.  It is an amazing blend of video, text, graphics, and audio.  You should read it with your headphones on.

That's right, a newspaper piece you read with your headphones on.

This is a "long read".  Take the time.  It is worth it.  I realize that some of you are slower readers and this might end up being homework. 

Your test grade is a blog entry.  We have not had a test yet this marking period.  Your question: "How will writing change in the digital age?".  Be sure to reference this Snow Fall text.

We have talked a lot about this and there are other sources that you could cite.

Please think about your answer.  Plan it out.  Include links.  Use paragraphs.

Thursday, May 01, 2014

Friday Work

Before we start:

You will complete the typing test. We did this before.  

  • Put your score in your blog (be honest!) and see if it improves later. 
  • Don't say "I took a typing test". Say "I took a typing test". Compare your score to January.
  • Demonstrate that you know how to code a link.
The rest of the period will be a catch up period for many of you.  I will pass out grade sheets.  Please complete all work and show me so I can adjust grades.

I encourage those who are done to review the links provided in the last few classes.

Edline codes:

AB: Absent 
IN: Incomplete
NA: Not attempted or submitted
CT: Cut class
**: Not graded yet

Tuesday, April 29, 2014

More HTML Coding

We will make our first webSITE today. Until now we have made webPAGES. Today please do the following:
  • Create a folder in your WDrive-HTML. Label it correctly "Flag".
  • Download a clip-art or Creative Commons image of an American Flag (do not steal one from Google images). Save in flag folder
  • Create a two-page website.
  • Title Page 1: "American Flag". Add heading, background color, and flag image.
  • Center image.  Include Alt text in image code.
  • Title Page 2: "American Flag History". Add heading. Add short description of Flag history with two links to further information.
  • Link pages together: Make image on Page 1 the link to Page 2. On Page 2 include a "home" link back to page 1.
  • Does your font choice matter?  Read this.
  • Save both pages. Test links.
  • Show teacher when done.  Be sure the links work.
When done:

Sunday, April 27, 2014


Start today with a Google A Day.

Then Draw a Stickman.  Wouldn't you like to learn how to do that?

You will create a one page website about your current class schedule. This website should include:
  • A title in the header code.
  • A clear heading on the page.
  • A list of classes (yes, there is a code for list)
  • A brief paragraph describing yourself (junior at Seymour High School, etc...)
  • Background color other than white.  Keep the color light (no bright red, black, etc...if you disagree go back and look at the bad websites)
If you do the above correctly the maximum you can score is 3/4.  You must do at least one of the extras to be able to score 4/4.
1. Can you include an image that you created?  Remember that the image must be in the same folder as the webpage.
2. Can you place the schedule in a table?

Be sure you code the first 8 code tags correctly.  Be sure you open and close your tags in the correct order. 
Save the file to your WDrive-HTML folder when done.

Wednesday, April 23, 2014


Today we will have a coding test.  If you have spent time in code avengers this should be no problem.

Please do the following first:  Create a folder in your W Drive.  Name it "HTML Files".  All your work will be in this folder.

For each web page you will do the following:
  • Open up a new page in the program Notepad
  • Create the HTML code.
  • Save the file using the .html extension
Using HTML tutorials or any other resource please complete the following tasks. 

1. Create a webpage titled "Web Apps". Add a heading and two paragraphs describing assignments you have already done (coding, blogging, etc.. ). Save as "webapps.html"

2. Create a biography webpage. Save as "biography.html". Include link to your blog. 

3. Show teacher when done.

Monday, April 21, 2014

Tuesday Work

1. Watch this video.  Put in your headphones.

  • After watching, embed video on your blog.
  • Include short reflection and explanation for your readers.
2. Get to 500 pts on Code Avengers.

3. Complete a Google a Day and add to your spreadsheet.

4. Let me know when you are done.

Thursday, April 10, 2014

Growing your Blog Audience

Each of you should have a blog post measuring the reach of your blog and the red clustrmap dots.  We did this on Monday. Some of you began your campaign to grow your audience by commenting on blogs.  We will continue this today.

We have discussed the difference between spam comments and valuable comments.  Remember that a valuable comment builds on the conversation.  Your goal for this assignment is to create comments that make people interested to read more about your thoughts.

Building an audience is one of the most important skills we will work on.  Nearly every product, service, and idea is sold via the web now.  You MUST know how to get your work out there to survive and eat.  This blog is practice for that.

I'm also hoping to raise the level of work on your google profile.  For many of you your twitter feed is your #1 result on google.  For many of you this is NOT good.  Seriously.  And remember, swearing is bad.

Today you will do three things:
1. Write blog posts to increase the quality of your blog (see topics below).  You need posts that people will link to, email their friends, post on twitter.  We want people to be saying "Read this!".
2. Comment, comment, comment.  Using google you will find blogs to comment on.  You will leave comments everywhere.  You will make the comments interesting and they will extend the conversation. Be sure to leave your blog address in the comment info!!!
3. If you find an interesting blog post you will write about and link back to the original blog.  This is "polite blogging".  This is how traffic gets generated.  "I read this great blog article about...".

Suggested blog posts (remember to include links, a cool title, embed video/images if needed).  Choose one or all:
1. If you are a football fan: Explain when you would punt the ball and when you "go for it" so anyone can understand it.
2. If you are a cheerleader: Is cheerleading becoming more dangerous?  Describe how cheerleading has changed over time.  Where is the line between OK and too dangerous?
3. If you are a musician:  How have headphones and iPods changed music?
4. If you are an artist/photographer: How has the internet changed how we view art?  Does the internet help or hurt art?
5. If you eat: What should we eat?  Should we be allowed to eat whatever we want?  What if we know what we eat is slowly killing us?
6. If you breath: Whats in the air that you breath?  Is it safe to breath?

Tuesday, April 08, 2014

Blogging: Wednesday Work

Choose three of the following to write a blog post.

1. Can you spot the liar?

2. What is your favorite infographic on this list?  Infographics are changing how we tell our stories.

3. Should the child have been at sea?  Take a position and defend it.

4. If you look up what you want to order for dinner will you be hacked?  How can you protect your system?

5. What is the top news story of the hour?  Right NOW.

6. Should students be allowed to wear Google Glasses?

7. Imagine you were studying the Civil War and found out that for entertainment kids of that time period spent hours a day playing games where they simulated killing people.  Now think about games that you play on the computer.  Will future society look kindly at us for spending hundreds of billions of dollars and games that simulate shooting people?

Each blog post must:

  • Be long enough to explain the topic.
  • Include your opinion and evidence.
  • Include a link.
  • One of the posts must include an embedded video.


1. Everyone prints out your summary screen from Code Avengers.   Must have 400pts.
2. Complete a Google a Day.  Add to spreadsheet.

Sunday, April 06, 2014


Challenge #1:  Create a one page resume and put in your google folder and print for teacher.  This is a TRADITIONAL resume.  Here are some tips.  Here is an example.  I will spend a lot of time on this assignment.  We will make infographic resumes shortly.

Some things to think about:
  • Use google doc to make notes and brainstorm about the resume.
  • List EVERYTHING you could possibly include.  Only include stuff you did in middle school if it is truly amazing (like winning a National Science Fair or something).
  • Follow the format, follow the format, follow the format.
  • Use active verbs.  Quantify everything:
    • Created and published movie review podcast that reached 75 listeners per day
    • Directed Hope Club recruitment plan that increased membership by 75%
    • Implemented lunch recycling plan that resulted in 35% reduction in cafeteria waste
Challenge #2:  Create an account in Meograph.  Create a meograph around one of the following:
  • Your family vacations.
  • Your favorite professional teams best season (Road to Victory...)
  • Battles of the Revolutionary War
  • Upcoming tour of your favorite singer/band
Challenge #3:  Using the app Hopscotch on the iPad code the app so:
  • Level 1: The monkey will travel in the correct direction when you tilt the ipad (up-down-left-right).
  • Level 2: The monkey will follow a maze that you design.
  • Level 3: The monkey needs to follow the maze you design or it will grow so big it explodes...
Challenge #4: Class work.
  • Complete the Google A Day.  You should have at least ten scores in your google a day spreadsheet.
  • All students should have scored at least 400pts on Code Avengers

Thursday, April 03, 2014

Blog Writing

1. Update your blog with any missing assignments.  Post any entries to Google+.

2. Analyze the red dots on your clustrmap on your blog.  

  • Please write a short blog entry about your audience.  
  • You can also go to blogger and look at your stats to see which blog posts got read, and by whom. 

3. Play with Google Story Builder.  

  • Figure out how to construct a story and use the tool.
  • Embed your story on your blog.
  • Post to Google+
4. Evaluate the Build with Chrome website.  Obviously you need to be on Chrome for your browser.
  • Is this just a game, or does virtual reality act as a teaching tool?
  • Notice you can search for an address.  Can you build your house, or Seymour HS, or Yankee Stadium?  Thats just an example.  
  • Post a blog entry, be sure to include link.
  • Post to Google+
Please remember, I give you these examples so you can practice writing online.  Please continue to improve your blog entries.

Does your blog post:
  • Include links for anything that should be linked?
  • Writing that is clear, free of errors, and inviting to the reader?
  • Include videos and images where appropriate?
Everyone should have three blog entries posted today.

Tuesday, April 01, 2014

A/B Day Madness

We have 30 minutes.  Lets watch some videos.  Put on your headphones.

 I love this Arnold video. His movies were really big when I was in high school so that voice is iconic. He really, really believes what he is saying.  That last line is classic.

If you watch this TED talk watch it from the beginning and do not skim forward! Its freaky amazing. 

I've watched this 100 times. Still funny. 

Funny Ellen moments.

Additional work:

  • Do some wikipedia edits.  Check out the SHS page.  Perhaps there is too much information there does not quite fit wikipedia's guidelines.  We can also organize it better.
  • Google a Day.  Keep practicing.
  • Read this story about caffeine drinks.  Also, I'm pretty sure any type of soda or fruit drink may shorten your life.
  • This review in the NYTimes of Guy Fierri's new restaurant .  It is very, very harsh.
  • If you did all that check out some of my favorite videos.  Be sure to have headphones on.

Sunday, March 30, 2014


Please work on your coding today.

1. Work in code avengers.

2. Check out

3. Watch the video

Tuesday, March 25, 2014

Computer Lab Redesign Test

Imagine you cleared this room out.  No chairs, no computers, no nothing.

Imagine I gave you $40,000 to outfit a new computer lab.  What would you design?  I want you to prepare a proposal.
Your lab might look like a Starbucks with a juice machine, couches and a few tables.  It might have a bunch of round tables for people to collaborate.  Your lab might have PCs, iMacs, Laptops, or iPads.  Will it have a TV or a Smartboard?  Should there be a rug?  Posters?  Ergonomic furniture?
What are some of my parameters for the computer lab?
  • There should be seating for 25.  This does not necessarily mean 25 computers.
  • You must budget for everything.  This includes chairs, wifi hubs, printers, etc... You must budget for software.
  • This is a "general purpose" lab for a high school.
What must you prepare?
  • A spreadsheet outlining how you will spend the money.  Including formulas and charts.
  • One page memo.  Memo must start with the words "I recommend that...."  Follow the format for the memo!!
  • A slideshow presentation to the class.  
  • Drawings or video of proposed lab.
  • You must turn in a paper copy of your proposal as well as post all work on your blog and Google+.
What will I look for?
  • That you contribute to discussions and documents.
  • Thoughtful design and research.  Will the lab be effective? You should show evidence of research ("I emailed Microsoft", "I surveyed the English department")
  • Accuracy and proper use of tools (google docs, spreadsheet formulas, etc...).  
  • Presentation is consistently designed.  For example, your fonts on the spreadsheet match the fonts on your memo.
This will be due at end of class on Friday.
I will nitpick this project like crazy.  Be ready.  This is the first assignment I will really check for accuracy.

One Page memo directions: link blocked

September 05, 2006

Friday, March 21, 2014


If you have not completed your test in blogger please do that first.  Please post to Google+.

If you have not posted your spreadsheet and schedule to Google+ do that next.

Challenge #1:
Complete a Google a Day.  Make sure you enter data correctly to your spreadsheet.  Have you figured out how to compute average time?

Challenge #2:
How responsible do adults and teens need to be about technology use with children?  Watch this video.  Is technology use helpful or harmful?  What rules should be set up in a household?  Please write a blog entry that:

  • Includes links to relevant research, videos, or images.
  • Is clearly written, has a main point, topic sentences, etc...
  • Encourages conversation and comments.
  • Is shared in the Google+ community.
Challenge #3: 
Analyze the red dots on your clustrmap on your blog.  Please write a short blog entry about your audience.  You can also go to blogger and look at your stats to see which blog posts got read, and by whom.  

Challenge #4:
Please get to 400 pts in Code Avenger.

Wednesday, March 19, 2014


All students must get a check from me that their SchneiderCorp spreadsheet is done.  

Please ensure that a CORRECT version of the spreadsheet and presentation is on Google+.

Challenge #5:
Can you attach a chart to the Challenge SchneiderCorp spreadsheet that shows me how much farm equipment stuff we sold? Please attach chart to separate sheet.

Challenge #6:
Clean up your google a day spreadsheet.  What is the average time it took you to solve the puzzle?  Yes there is a formula for time.  Thats todays puzzle, I suppose.  Can you find and apply this formula to get an average?  I don't have an answer yet, but I'm sure its really simple.

Challenge #7 (extra-when done):
Design a task with the Makey-Makey or review an App on the iPad.  Blog about the activity and post to Google+.

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.