Assignment 10 – Glogster Poster

Glogster – Poster Yourself


Objectives: Students will be able to create a Glog/online poster incorporating graphics, photos, videos, music and text to embed in a blog post or on a wiki page.

Directions: Create a glog about you; your interest, favorites, etc. When you are done with your Glog poster add it to a blog post titled Assignment 11.

Glog samples:


Create a login/account.

How to use Glogster

Assignment 9 – Create a Google presentation

You will be able to:

    • Create a google presentation about your favorite Disney Movie
    • Research your topic and create a Google presentation
    • Post it in your blog

My Favorite Disney Movie

Pick your favorite Disney movie to create a PowerPoint presentation.

 Include at least the following:
                      The year the movie was released

                       The cast of characters

                       Who were the voices for the characters?

                       What Music and/or song titles were included?

                       A summary of the plot or storyline of the movie

                       A collection of several images from the movie

    You can include more information if you would like.

Steps to Post on Blog

  1. Create a new post on Edublogs labeled – Assignment 9 – Google Presentation
  2. Write a paragraph about what you did in this assignment.
  3. Embed your presentation into your post:
  4. On Google Docs with your presentation open select > Share > Publish/Embed
  5. Select Publish Document
  6. Player Size = Small
  7. Copy the code in the box (<iframe src=”http://docs.googl….)
  8. Switch back to edublogs assignment 9 post
  9. Click on the HTML editor and not the Visual editor.
  10. Paste this code into the HTML of your blog
  11. Switch back to the “Visual” editor
  12. Go back to Google publish screen and
  13. Copy and paste the link to your published presentation below the embedded video. (My presentation is viewable at:

Assignment 8 – Calculation Consumption

In this lesson you will be able to:

  • Access Google Spreadsheet.
  • Name & save your file.
  • Freeze rows & columns.
  • Enter collected data.
  • Add formulas for Sum and Average calculations.
  • Create a graphs representing the data
  • Enter data as a collaborator.
  • View revisions to a shared document.
  • Export spreadsheet data and add to your blog


  1. Log into your Google Docs account and create a new spreadsheet file. Save your file as Your Name – CC.
  2. Set up the sheet as follows (Use 5 Classmates and take a survey):


Beverages (8oz.)

Notebook Paper

Text Messages

(# of items)

(# of glasses)

(# of sheets)

(# of sent)


3. Create a formula for Total number of items in each category

4. Create a formula for Average number of items in each category

5. Rename your sheet to Consumption Worksheet


6. Create a column chart on a new sheet to show the usage by student of each item. (select: A1 to E7)

7. Create a pie chart to show the  total usage per category. In Google Docs you can not select one row and then hold down the Ctrl key down while selecting a row that is not near that row instead you have to do the following: Select, copy & paste the heading row 1 with the labels to row 15. Then select, copy & paste the Total row (A9-E9)  to row 16. Now select row 15 and 16 and create a pie chart the is on a new sheet called Total Consumption Chart.

8. Create another pie chart showing the totals of what you consumed. The select will have to be done the same way you did step 7 above.


9. When you are done your Google Spreadsheet log into edublogs and create a new post titled Assignment #8 – Calculating Consumption. Write a brief paragraph explaining what you did in this assignment and add the following to your post:

  • A link to your spread sheet as an html file.
  • Insert one of your graphs in the post. Save the chart as an image and then upload and insert it into your post.

10. Share your spreadsheet file with me with access to edit.

Assignment 7 – Dream Room Spreadsheet

Student Objectives:
Students will be able to:

  • Gather information on the Internet (mock shopping spree – price, item)
  • Enter this information into Google Spreadsheet
  • Enter formulas to calculate totals, balance, least most and average price
  • Link your spreadsheet to a blog post.

Student Directions:
You just won $5,000 to decorate your dream room. This could be a game room, bedroom, home office, TV room, etc. You are looking for furnishing and decor for your room.

Shop at IKEA or Target

But wait! There’s a catch! The total cost of all the items you select must not exceed (go over) $5000.00, tax included. Also, the total cost of all the items (tax included) must fall between $4995.00 and $5000.00 or you lose everything. “Not a problem!” you exclaim. “I have a secret weapon called Google spreadsheet! I can make it do the math for me – right down to the very last penny! Show me the money!”

1. Log on to your Google Docs account and set up your file as follows:


2. Format B3-B18 (blue cells) as currency with 2 decimal places and show the dollar sign.
3. Format D3-D27 (blue cells) as currency with 2 decimal places and show the dollar sign.

4. Go to View > Freeze Rows > Freeze 2 Rows (this will freeze the top two rows)
5. Save your file as YourName_ShoppingSpree.
6. Go to IKEA or Target and shop for items to decorate your room:

7. Enter items and quantity.
8. Create the following formulas:

  • In D3 – formula to multiply cost of the item by the quantity, then use the fill handle to fill to D18
  • In D19 – formula to add prices of all the items (D3 to D26)
  • In D20 – formula to calculate tax, sub-total by 5%
  • In D 21 – formula to add the subtotal and tax
  • In D22 – formula to subtract Grand Total from $5,000
  • In D25 formula to calculate the most expensive item (use cost of item column)
  • In D26 formula to calculate the least expensive item (use cost of item column)
  • In D27 formula to calculate the average priced item (use cost of item column)

9. Insert 2-3 pictures and format font (size & color) so that your spreadsheet is easy to read.

10. Rename your sheet to MyRoomExpenses

11. Share this file with me so I can correct your work. []

12. File > Download as PDF with the following settings:

  • Current Sheet
  • Actual Size
  • Landscape

13. Add this file to your blog.

Create a new post titled: Assignment 7 – Dream Room Spreadsheet and file it under the assignments category. Write a short intro paragraph about this assignment. What did you do? How did you like this lesson? etc. At the end of the paragraph create a link to your spreadsheet. “Check out my dream room expenses.”

Assignment 6 – Creating a newsletter in Google Docs

Google Docs Newsletter – Assignment #6

Objectives: Working in a shared environment you will collaborate to create a newsletter about current events using Google Docs.
[Note: you will be working with an assigned partner from another class on this project.]
Partner 1 (person who starts first) will create a new document from a template. File > New > From Template. Search for a newsletter template (Modele, BrandCo Theme will work well)
Save file as: news-name 1 and name 2
[Note: file name should have both partner names and grades]
Share this file with me and your partner  > Share > Invite People
[see email list for your partner’s email address]


Go to the following Web sites and read articles in the news:
  1. Summarize the articles to add to you newsletter.
  2. Include 5-6 different categories.
    One should be a featured article and one should be from the National News category. You should have a total of 6-7 articles in your newsletter.
  3. Create another document to make notes on and share this with your partner, you can name it news-notes. In this file you should put rough drafts of your articles and categories before you enter the final article in your newsletter. Write notes to your partner about how you will get this assignment done.
  4. Create your own newsletter logo at This logo can go at the top of your newsletter.
  5. When you are finished you will add the newsletter to your blog as a PDF file and an html link.

    • In Google Docs – With your newsletter open select File > Download as > Select > PDF —– Select >  Save File > Click Okay > Save in your grade folder on the Public Server in the Newsletter folder.
    • In Google Docs – With your newsletter open select Share > Publish as Web Page > Check the box “” > Select > Publish Document. Your document is publicly viewable at: (this is the link you will add to your blog).
    • Log on to edublogs
    • Create a new post titled Assignment #6 – Newsletter (file in the assignments category).
    • Write a brief paragraph such as:

Janie and I work on this newsletter using Google Docs. It was quite easy and fun to learn this new online word processor. You can see our newsletter online at or download our newsletter as a PDF file [newsletter].

  • The online link is the link that you copy and paste after you Publish as a Web Page.
  • newsletter as a PDF file [newsletter] … you will need to upload your media > Add media > select the add media button > browser to your saved file on the server > Select Upload
  • On your post select the “newsletter” and link that word to your PDF link file (target –  open in a new window).


Using Google Docs

Using Google Docs in the classroom: Simple as ABC

Google Docs is a free, Web-based word processing, presentations and spreadsheets program.

Unlike desktop software, Google Docs lets people create web-based documents, presentations and spreadsheets that anyone in the group can update from his/her own computer, even at the same time.

Instead of emailing around files and having to deal with the confusion and extra work involved in managing different file versions and manually aggregating input from others, anyone in the group can edit the document online from anywhere — all you need is a Web browser.

And, since your docs are all stored safely in Google’s servers, you don’t have to worry about losing data from a hard drive crash or nasty virus.

Take a Tour

Assignment 5 – The Link

Objective: You will add links to your favorite classmates blogs and also your favorite (educational) Web sites on your widget (side panel).


To do this follow these steps:

  1. Go to  links > Link Categories > Change “Blogroll” to “Links” or “Favorite Web Sites”
  2. Add a New Link Category  >  “Favorite Blogs”
  3. You now have two categories to file your links in
  4. Add a link: Go links > Add New
  5. Fill in the Name, Web Address, and select the category the link will go in. Also use http:// in front of the URL. When this form is complete select  > Add Link
  • Add 5-6 links for educational Web sites that you like to use for your learning. (When you have projects to create for Science, History,ELA, etc. where do you go to on the Internet for information.)
  • Add 5-6 (or more) of your favorite classmates blogs.

Assignment 4 – The Debate

Objective: You will be able to create a blog post to discuss the pros and cons of one of the following topics and post a comment on other student’s post.

TOPIC 1 – Cell Phone & Mobile Device Use in School

In your blog (titled: Assignment #4 – Cell Phone Use) please discuss this issue and voice your opinion on “cell phone use in school”. Your post should be 3 paragraphs long and include both sides of the issue (pros, cons & your opinion). You should also post a comment on 2 other student’s blogs (copy and paste links to where you posted in your post). One student should have a different opinion than you. Include links to where you found your information (ex: the article I read on Education Week states that….. and link the words “Education Week” to the article.) Also create proper citations for the Web sites where you found your information, use or

  • What are the pros and cons of cell phone/mobile devoce use in schools?
  • How will cell phone/mobile device use affect discipline, safety, community, attitude and education?
  • What types of policies do schools have on cell phone and mobile devise use?

Please visit the following Web sites to see what others are saying:



TOPIC 2 – Spirit Wear aka School Uniforms

Henry Lord Middle School has adopted spirit wear (uniforms) since 09/10 school year.

The public school uniform debate has been an issue for educators, parents, and students for years. Though public school uniform use is not widespread, it is growing and might soon be adopted in many other schools.

What are the pros and cons of public school uniforms?

How will school uniforms affect discipline, safety, community, attitude and education?

What other schools have such policies?

In your blog (titled: Assignment #4 – Spirit Wear) please discuss this issue and voice your opinion on “spirit wear”. Your post should be 3 paragraphs long and include both sides of the issue (pros, cons & your opinion). You should also post a comment on 2 other student’s blogs (copy and paste links to where you posted in your post). One student should have a different opinion than you. Include links to where you found your information (ex: the article I read on Education Week states that….. and link the words “Education Week” to the article.)

Please visit the following Web sites to see what others are saying:

  1. (also see link for statistics)

Assignment 3 – Digital Footprint

You will be able to create a presentation on the concept of digital footprint and comment on 2 other classmate’s post with links added on your comments page.

It’s great to share things online with your friends. Part of the fun of sharing videos, images and other content, is that lots of people can view and respond. Remember that what you share with your friends may also be viewed by others who you don’t know. They may also be able to look at it for years to come. Everything you post adds up to make your digital footprint and, once it’s online, it could be there forever. So think before you post.

VIDEO : Protecting reputations on-line in plain English

You can also think about a digital footprint as a digital legacy. What type of trail are you leaving behind? Would you want your coach, future employer, college admissions officer or grandmother to see that message, picture or video you posted? Is it a good trail or ugly? Check out the different types of legacies these people are leaving behind:

The Good
The Bad
The Ugly
The Most Ugly – videos posted online that will hurt the person’s reputation

links from:

Extra-Normal Example 1

Extra-Normal Example 2


Gather information about digital footprints. Create a presentation to embed in your blog to help students learn about keeping their reputation online positive.

Digital Footprint Web sites

Footprints in the Digital Age

Student Video

Presentation Tools

You may use any of the following on-line tools to create your presentation:

Toondoo – Make a cartoon
Animoto – make a movie (see me for the code)
VoiceThread – multimedia slide show that holds images, documents, and videos
Go Animate presentation
xtranormal – text to movie
Glogster – online poster to embed in your post (see me for an account)
Stupeflix Studio
Photo Peach

This poster example is on Digital Citizenship yours will be on using the Internet in a positive way to leave a good digital footprint.


Assignment 2 – blogging Safety

You will be able to:

  • create a post on safe blogging and comment on 2 other classmate’s post
  • add an “About Me” page using the guidelines listed below and comment on 2 other classmate’s post

1. Safe Blogging Post and comment on 2 classmate’s post

Visit the following sites and create your second post with tips on safe blogging. I am looking for a paragraph and 6-8 points (in a list) on safe blogging.
(example post:

  1. Student Tips for New Bloggers
  2. Seven tips for middle school students who will be reading and commenting on blogs.
  3. Bud’s Blogging Rules
  4. Magnet Blogging Policy
  5. The 10 Commandments of Spelling, Grammar and Punctuation for Blogging!

Student Blogging Guidelines

ISB has published the following blogging guidelines below. Use the questions in italics to help you decide what is appropriate to post on your blog.

1. Only post things that you would want everyone (in school, at home, in other countries) to know.
Ask yourself: Is this something I want everyone to see?

2. Do not share personal information.
Ask yourself: Could someone find me (in real life) based on this information?

3. Think before you post.
Ask yourself: What could be the consequences of this post?

4. Know who you’re communicating with.
Ask yourself: Who is going to look at this, and how are they going to interpret my words?

5. Consider your audience and that you’re representing ISB.
Ask yourself: Do I have a good reason/purpose to do this?

6. Know how to give constructive feedback.
Ask yourself: What will I cause by writing this post?

7. Treat other people the way you want to be treated.
Ask yourself: Would I want someone to say this to me?

8. Use appropriate language and proper grammar and spelling.
Ask yourself: Would I want this post to be graded for proper grammar and spelling?

9. Only post information that you can verify is true (no gossiping).
Ask yourself: Is this inappropriate, immature or bullying?

10. Anytime you use media from another source, be sure to properly cite the creator of the original work.
Ask yourself: Who is the original creator of this work?

Commenting Guidelines “this is important”

As a blogger, you will be commenting on other people’s work regularly. Good comments:

  • are constructive, but not hurtful;
  • consider the author and the purpose of the post;
  • are always related to the content of the post;
  • include personal connections to what the author wrote;
  • answer a question, or add meaningful information to the content topic;
  • follow the writing process. Comments are a published piece of writing.


When you are commenting on other student’s blogs be sure to keep the conversation going and add constructive comments.

Take a look at the following blog comments:

Brad and  Abby

Notice that they are actually having a conversation and not just saying “I love your blog!”.

2. Create an About Me page and comment on 2 classmate’s post

Your page should include:

  • a paragraph about you
  • a picture, flickr letters or wordle to enhance your page

Here is what Sue Waters posted on her blog on the Edublogger

Tips For Writing Your ‘About page’:

Student blog

Your ‘About page” is like meeting someone for the first time in a new class.  Tell them a bit about who you are and your interests.  You might even want to share reasons why you blog.

Remember you need to be Internet savvy — follow all your teacher’s guidelines!

  • Only ever use your first name or a nickname
  • Never use any other student’s last name
  • Never post personal information such as your home phone number, home address, e-mail address, IM
  • Remember online is forever – Don’t write anything you wouldn’t say to your grandmother
  • Don’t write anything that could hurt anyone else
  • Don’t post photos or videos of yourself unless your teacher and parents have given you permission

Examples of student blogs:

  1. Lauren’s About page
  2. Abbey’s About pag