Before you leave today you will have the opportunity to  present.

REMEMBER: You audience needs to LEARN something from this presentation!! WHAT are you going to teach them, WHY is it important for them to know, WHEN can they use it in their lives?

  1. Typing Club
  2. SHARE your presentation with me:
    1. PowerPoint or Google Presentation–In your  Google Drive ONLINE, check the box beside the file and SHARE it to me: tracyweber@bellevue.k12.ia.us
    2. Prezi–SHARE it to: tracyweber@bellevue.k12.ia.us
  3. PRESENT
  4. Here is how you will be graded:
    1. Presentation Grading Rubric
Critique your classmates:
1. What did you learn?
2. Why is it important?
3. When will you use it?

Lemonade Stand–Play it, get acclimated

  1. Lemonade Stand Financial Statements
    1. File
    2. Make a Copy
    3. Name it your name Lemonade Stand (ex: Tracy Weber’s Lemonade Stand)
  2. Lemonade Stand–play it, but track your sales/costs in the spreadsheet.
  1. Go to your Google Drive ONLINE and open your Lemonade Stand spreadsheet from last class
  2. Complete the Balance Sheet and the Income Statement
  3. Play the game
  1. Go to your Google Drive ONLINE and open your Lemonade Stand #2 spreadsheet from last class
  2. Do the 14 Day game
  3. Complete the Balance Sheet and the Income Statement–SHOW ME
  4. Play the 30 day game
  1. Get into groups of 3
  2. Lemonade Stand Financial Statements
    1. File
    2. Make a Copy
    3. Name it your name Lemonade Stand (ex: Tracy Weber, Sue Smith, Joe Bromann’s Lemonade Stand)
  3. Lemonade Stand–play it, but track your sales/costs in the spreadsheet. WHO CAN BE THE MOST SUCCESSFUL?!
  1. Typing Club
  2. WATCH THIS ABOUT HOW TO CONDUCT GROUP RESEARCH
  3. Get with a partner
  4. ONE person in your group create a new Google Doc–share  it with the other person in your group and me (tracyweber@bellevue.k12.ia.us)
  5. Gather around ONE computer and do the video clip
  6. YOUR WRITING FOR TODAY: You and your partner together create a new Google Doc–share it with me–tell me how you think you should be graded on this project. Assign points to each item you think you should be graded on.
  7. If you finish early: Typing Club or other online typing games.

GOAL: Before you leave today you will have completed your research and you will be prepared to begin writing your MLA report next class.

  1. At your OWN computer, open the Google Doc
  2. Find RELIABLE websites about your topic–read the website–take notes in the Google Doc using YOUR OWN WORDS–copy and paste the website URL into the Google Doc

GOAL: Before you leave today you and your partner will write your report using MLA style.

  1. Attention Grabbers–Use this for your opening paragraphs
  2. Ending Your Paper–Use this for your closing paragraph
  3. Write your group research report using MLA style. Include a Works Cited page, 1 piece of clipart, 1 textbox. Here are some steps to follow:
    1. Both group members–get the Shared Google Doc for this project on 1/2 of your screen.
    2. One person in your group create a Word file (the other 1/2 of your screen) and save it to your Google Drive. Begin writing the MLA report–set it up & write your parts of the project using good writing skills.
    3. SWITCH
    4. At the end of class:
      1. SAVE the Word file
      2. The person who created the Word file: Go to your Google Drive online and SHARE the Word file with your partner and tracyweber@bellevue.k12.ia.us

FINISH TODAY

GOAL: Before you leave today you and your partner will write your report using MLA style.

    1. Attention Grabbers–Use this for your opening paragraphs
    2. Ending Your Paper–Use this for your closing paragraph
    3. Write your group research report using MLA style. Include a Works Cited page, 1 piece of clipart, 1 textbox. Here are some steps to follow:
      1. Both group members–get the Shared Google Doc for this project on 1/2 of your screen.
      2. One person in your group create a Word file (the other 1/2 of your screen) and save it to your Google Drive. Begin writing the MLA report–set it up & write your parts of the project using good writing skills.
      3. SWITCH
      4. At the end of class:
        1. SAVE the Word file
        2. The person who created the Word file: Go to your Google Drive online and SHARE the Word file with your partner and tracyweber@bellevue.k12.ia.us

GOAL: Before you leave today you will demonstrate your knowledge of MLA style report formatting and you will improve your writing skills.

  1. Typing Club
  2. Finish group report
  3. Word Processing Post-Test–Edmodo
  4. Using your reports notes, format a report about A Career of Your Choice.
    1. The report needs to be 3 paragraphs long with at least 3-5 sentences in each paragraph.
    2. Include 1 piece of clipart and 1 textbox.
    3. Use the Internet to find at least 3 sources.
    4. Here are some ideas you may use or you can use your own. Use good writing skills.
      1. What is the career?
      2. What are different types of jobs you can get in that career area? (For instance, if you want to be in Education, some jobs you might get include: paraprofessional, teacher, principal, counselor, professor, etc.)
      3. What education do you need in order to pursue this career?
      4. Where can you get this education?
      5. In what part of the country can you get a job in this career?
    5. PRINT WHEN YOU ARE DONE!! Printer: HP Officejet 8600 (Network)
  5. Go to Web2.0. Check out the different Web 2.0 Tools. If you see a cool tool, create a report USING CORRECT FORMAT describing it and how it could be used in class. Use correct report format. Upload it to the wall for your class in Edmodo for your classmates to read

 

 

  • Typing Club
  • Using your reports notes, format a report about Bellevue Middle School.
    1. The report needs to be 3 paragraphs long with at least 3-5 sentences in each paragraph.
    2. Here are some ideas you may use or you can use your own.
    3. Use good writing skills.
    4. Include 1 piece of clipart and 1 textbox.
    1. What is good about BMS?
    2. What could be improved at BMS?
    3. Why does it need to be improved?
    4. What can you do to help?
    5. What are you looking forward to this at BMS?
  • SHOW ME WHEN YOU ARE DONE!!

GOAL: Before you leave today you will know how to cite sources using Word.

  1. Typing Club
  2. WATCH THIS ABOUT HOW TO CITE A SOURCE
  3. Create an MLA style report about a research topic that interests you. Here are some that interest me that I might consider:
    1. Healthy Eating
    2. Physical Fitness
    3. My Career Choice
    4. Pandas
    5. Abraham Lincoln
    6. Global Warming
  4. Your report should be 2- 3 paragraphs with 3-5 sentences per paragraph
  5. Include a piece of clipart
  6. Include a textbox
  7. Include a Works Cited page–be sure to use at least 2 sources
  8. Print the report
  9. HOMEWORK: Create an MLA style report at home. Show your parents. Write a note explaining what you did and have your parents sign it. Return it next class.

FINISH FROM LAST CLASS

GOAL: Before you leave today you will know how to cite sources in a report.

  1. Typing Club
  2. REVIEW (if necessary): WATCH THIS ABOUT HOW TO CITE A SOURCE
  3. Research for your report:
    1. Find a website on your topic
    2. Read the website
    3. Write about what you read in your report (take notes)
    4. Enter the website as a source
      1. In Word, click the References tab
      2. Click the Manage Sources button
      3. Click the New button
      4. Choose Website as the source type
      5. Type the author–if you cannot find the person’s name, type the company name (corporate author)
      6. Title of the webpage–not www.espn.com, but maybe NFL Football page of the ESPN website
      7. Year, Month, Day–find what you can and use the most recent–if only the year is provided, only include the year then
      8. Year, Month, Day Accessed–that is TODAY
      9. URL–copy and paste it from the web browner (www.espn.com)
  4. DO #3 ABOVE 3-4 TIMES (YOU NEED 3-4 SOURCES FOR THIS REPORT)
  5. Include a piece of clipart
  6. Include a textbox
  7. Include a Works Cited page–be sure to use at least 2 sources
  8. Print the report
  9. HOMEWORK: Create an MLA style report at home. Show your parents. Write a note explaining what you did and have your parents sign it. Return it next class.

FINISH FROM LAST CLASS:

  1. Proofread your report & write it in MLA format. Rmember:
    1. Paragraph #1–Introduction–Tell your readers what they will learn (3-5 sentences)
    2. Paragraphs #2 & #3–Type about your topic–What did you learn that you want to teach your audience? (3-5 sentences)
    3. Paragraph #4–Conclusion–Review what you taught your readers and provide your own thoughts on the topic AND tell your audience what to do next. (3-5 sentences)
  2. Include a piece of clipart
  3. Include a textbox
  4. Create the Works Cited page–review the video clip
  5. SHOW ME

FINISH FROM LAST CLASS:

  1. Proofread your report & write it in MLA format. Rmember:
    1. Paragraph #1–Introduction–Tell your readers what they will learn (3-5 sentences)
    2. Paragraphs #2 & #3–Type about your topic–What did you learn that you want to teach your audience? (3-5 sentences)
    3. Paragraph #4–Conclusion–Review what you taught your readers and provide your own thoughts on the topic AND tell your audience what to do next. (3-5 sentences)
  2. Include a piece of clipart
  3. Include a textbox
  4. Create the Works Cited page–review the video clip
  5. SHOW ME

 

Before you leave today you will have the opportunity to conduct research about your topic, take notes, and keep track of your resources.

REMEMBER: You audience needs to LEARN something from this presentation!! WHAT are you going to teach them, WHY is it important for them to know, WHEN can they use it in their lives?

  1. YOU HAVE TODAY AND NEXT CLASS TO FINISH
  2. Open your shared Google Doc from last class–the outline.
  3. For each part of your topic in which you are responsible, find and read webpages about that topic–use at least 5 different webpages!! DO NOT USE WIKIPEDIA!!
  4. Type about what you read in your Google Doc–under that topic–and copy & paste the URL into your shared Google Doc  (THIS IS YOUR WRITING FOR TODAY)
  5. As you are researching, find clipart & videos–save to your shared Google folder.
  6. Here is how you will be graded:
    1. Presentation Grading Rubric

Before you leave today you will have the opportunity to begin creating your presentation.

REMEMBER: You audience needs to LEARN something from this presentation!! WHAT are you going to teach them, WHY is it important for them to know, WHEN can they use it in their lives?

  1. FINISH TODAY
  2. Be sure to SAVE it to the SHARED folder for this project
  3. Here is how you will be graded:
    1. Presentation Grading Rubric
  4. Print it–grayscale & 9 slides per page
  5. Show me

UNIT 3 PRE ASSESSMENT https://assessments.commonsensemedia.org/6-8/Unit3/loginpage.html USE MY EMAIL: tracyweber@bellevue.k12.ia.us (at the end of the quiz, click VIEW RESULTS, then EMAIL RESULTS

  1. Create a new Google Doc. Share it with me. Respond to the following in the Google Doc: Have you ever sent a message or posted a comment online? created a profile on a social network site? used some sort of photo-sharing app? Googled your own name? Were there any results about you?
  2. Watch this video clip
    1. BEFORE viewing, consider the following: When watching the video, carefully observe the imagery in the video and think about what the images might convey about privacy.
    2. AFTER viewing, in your Google Doc, write about he meaning of the following imagery in the video as it relates to digital footprints and online privacy:
      1. Lighthouse
      2. Copies and Whispering in Ear
      3. Stadium/Jumbotron
      4. Permanent Marker
  3. Choose a Host activity
  4. In your Google Doc answer the following:
    1. Who helped to shape Linda’s and Jason’s digital footprint?
    2. Can you tell what a person is really like offline based on what you fin online?
    3. What are some other types of information that make up your “digital footprint”?

GOAL: Before you leave class today you will know what is meant by Digital Footprint and why it should be important to you.

  1. Create a new Google Doc. Share it with me. Respond to the following in the Google Doc: Have you ever sent a message or posted a comment online? created a profile on a social network site? used some sort of photo-sharing app? Googled your own name? Were there any results about you?
  2. Watch this video clip
    1. BEFORE viewing, consider the following: When watching the video, carefully observe the imagery in the video and think about what the images might convey about privacy.
    2. AFTER viewing, in your Google Doc, write about he meaning of the following imagery in the video as it relates to digital footprints and online privacy:
      1. Lighthouse
      2. Copies and Whispering in Ear
      3. Stadium/Jumbotron
      4. Permanent Marker
  3. Choose a Host activity
  4. WATCH THIS
  5. In your Google Doc answer the following:
    1. Who helped to shape Linda’s and Jason’s digital footprint?
    2. Can you tell what a person is really like offline based on what you fin online?
    3. What are some other types of information that make up your “digital footprint”?

UNIT 3 POST ASSESSMENT https://assessments.commonsensemedia.org/6-8/Unit3/loginpage.html USE MY EMAIL: tracyweber@bellevue.k12.ia.us (at the end of the quiz, click VIEW RESULTS, then EMAIL RESULTS

  1. In your Google Doc answer the following:
    1. Who helped to shape Linda’s and Jason’s digital footprint?
    2. Can you tell what a person is really like offline based on what you fin online?
    3. What are some other types of information that make up your “digital footprint”?
  2. UNIT 3 POST ASSESSMENT https://assessments.commonsensemedia.org/6-8/Unit3/loginpage.html USE MY EMAIL: tracyweber@bellevue.k12.ia.us (at the end of the quiz, click VIEW RESULTS, then EMAIL RESULTS

admongo.gov

  1. Typing Time
  2. Living Life Online
    1. What is the FTC?
    2. What questions should you ask yourself before downloading anything from the Internet?
    3. Once you delete something from the Internet that you posted, it is gone forever, right? Explain.
    4. Your best friend forwards a message from another friend, saying mean things about someone in your class. Do you forward it to someone else? Tell your best friend that it’s not cool to forward mean messages? Do you ignore it? How would it feel if it happened to you?
    5. What are some things you should consider before you type anything electronically?
    6. In your own words, what is cyberbullying?
    7. What should you do if you witness cyberbullying?
    8. What should you do if you are cyberbullied?
    9. How can you protect yourself online?
    10. How can you protect your information online?
    11. How can you protect your computer?
    12. What can happen sometimes when you download “free stuff” from the Internet?
    13. What is bill shock?
    14. How can you avoid bill shock?
    15. When you see a message in any medium – a news article, a commercial, a story online, even your textbooks – what 3 questions should you ask yourself?
    16. Are the ads you see when you are on the Internet the same as the ads your mom and dad will see? Explain.
    17. How do advertisers know what to put in an ad?
    18. What are some techniques advertisers do to get you to buy something?
    19. Can advertisers lie in their ads?
  3. VIDEOS!!!

Typing Time

admongo.gov–Go there!!

Lesson 1

Lesson 1A

  1. Typing Time
  2. admongo.gov and complete:
    1. Intro: Entering Admongo
    2. Level 1: The Atrium
      1. Area 1: Sidewalk Stroll
      2. Area 2: Home Sweet Home
      3. Area 3: Mini Mart
    3. Level 2: Assemblimator
      1. Area 1: AD Studio
      2. Area 2: Deep Freeze

FINISH PRESENTING

Last day of the 4th Quarter–Grade your instructor and the course!

Create a PowerPoint about what you learned in this class. Follow the rules for professional presentations.

 

 

http://www.commonsensemedia.org/sites/default/files/6-8-unit3-trilliondollarfootprint.pdf

UNIT 2 POST ASSESSMENT https://assessments.commonsensemedia.org/6-8/Unit2/loginpage.html

 

http://www.commonsensemedia.org/sites/default/files/6-8-unit3-trilliondollarfootprint.pdf

http://www.commonsensemedia.org/sites/default/files/6-8-unit3-identifyinghighqualitysites.pdf

http://www.commonsensemedia.org/sites/default/files/6-8-unit3-reworkreuseremix.pdf

  1. Typing Club
  2. Please complete the Teacher/Course Evaluation
  3. In the Comments section of the 6th Grade page in my web site (toward the bottom of thepage), write a course description for this course. Be sure to do the following:
    1. Write it so that students will want to take the course.
    2. Be sure to include what you learned this semester and how you can use what you learned in your future..

 

UNIT 3 POST ASSESSMENT https://assessments.commonsensemedia.org/6-8/Unit3/loginpage.html

Essential Question for Today: Why is it important to be alert and check sources while exploring online?

Before you leave today you:

  1. will understand that just because information is online doesn’t mean it’s true.
  2. will learn the guidelines on what information they can and can’t trust.
  3. will evaluate and compare online information sources for accuracy, relevance and bias.
  4. will apply their knowledge of reputable online sources to determine which sites are
  5. credible and which are not.

ORDER OF EVENTS TODAY:

  1.  Typing Club
  2. Go to Edmodo
    1. Take the 6th Grade Becoming and Online Sleuth Pre Quiz
    2. YOU WILL NOT BE GRADED ON THIS!!!!
    3. Leave your results screen up. You will refer to this at the end of class.
  3. Create a new Google Doc online, name is Online Sleuth, and share it with me
  4. Watch this video: http://www.youtube.com/watch?v=fXFbQKz3anw
  5. In your Google Doc, List all the guidelines for evaluating and trusting online resources that are mentioned in the video.
  6. Group Activity:
    1. Your group has been given the task of writing a scientific report about the subject: “Could there be life on other planets?” As part of your research you should compare at least 3 websites. Get the Source Comparison Tool from your teacher. Use these sites to evaluate:
      1. Source List: Is There Life on Other Planets?
        1. http://www.aliensthetruth.com/
        2. http://www.seti.org/2http://astrobiology.nasa.gov/ask-an-astrobiologist/popular/
        3. http://www.icr.org/article/can-life-exist-other-planets/
        4. http://www.kepler.arc.nasa.gov/
        5. http://www.nicap.org/articles/hillzeta.htm
        6. http://www.nasa.gov/vision/earth/technologies/Life_Detector.html
        7. http://hubpages.com/hub/milky-way
        8. http://www.science.nasa.gov/headlines/y2010/04jan_fiveplanets.htm
        9. http://www.chacha.com/question/is-there-life-on-other-planets
        10. http://cosmiclog.msnbc.msn.com/archive/2009/09/16/2072217.aspx
        11. http://www.dvorak.org/blog/2006/08/02/nasa-needs-a-plan-for-telling-the-public-about- life-on-other-planets/
        12. http://www.israel21c.org/social-action/israeli-fibers-help-nasa-locate-livable-planets-in-the-universe
        13. http://www.gravitywarpdrive.com/Reticulan_EBE.htm http://www.ufoevidence.org/
        14. http://earthguide.ucsd.edu/virtualmuseum/litu/litusyllabus.shtml
        15. http://www.ufos-aliens.co.uk/
        16. http://www.alicesastroinfo.com/2009/12/answering-questions-life-on-other-planets/the-universe
        17. http://www.answerbag.com/q_view/376966
  7. Go back to Edmodo and review your answers to your Pre Quiz for today
  8. In your Google Doc that you created today, in 3-5 sentences type about what you learned today and how you can use this in your life.

 

  1. http://www2.futurelab.org.uk/resources/documents/handbooks/digital_literacy.pdf
  2. http://www.nsteens.org/

 

Essential Question for Today: What makes a strong password and why should I keep my passwords private?

GOALS FOR TODAY:

  1. You will learn how to create strong passwords.
  2. You will learn guidelines that keep their passwords safe.

ORDER OF EVENTS:

  1. PRACTICE: Typing Club
  2. REVIEW RELIABLE SITES activity from yesterday.
  3. Create a new Google Doc and share it with me. Name it ONLINE BEHAVIOR and do the following in the Google Doc:
    1. Write one thing that you know already about:
      1. How to keep information private online.
      2. How to behave online and what to do if someone misbehaves.
      3. How to avoid dangers online.
    2. Now, write one question you have about the following:
      1. How to keep personal information private online.
      2. How to behave online and what to do if someone misbehaves.
      3. How to avoid dangers online.
    3. Watch this video: http://www.youtube.com/watch?v=DQ5zJvA0NYY
    4. GROUP ACTIVITY: Passwords. Get the handout from your teacher
    5. Go back to the Google Doc you created at the start of class and do the following:
      1. Write one thing that you learned today about:
        1. How to keep information private online.
        2. How to behave online and what to do if someone misbehaves.
        3. How to avoid dangers online.

 

Essential Question for Today: Why is it important to be a good digital citizen?

GOALS FOR TODAY:

  1. You will learn about rules of Online Citizenship (rules of appropriate behavior online.)
  2. You will learn about YouTube rules.

ORDER OF EVENTS:

  1. PRACTICE: Typing Club
  2. FINISH THE FOLLOWING FROM YESTERDAY:
    1. Watch this video: http://www.youtube.com/watch?v=DQ5zJvA0NYY
    2. GROUP ACTIVITY: Passwords. Get the handout from your teacher
    3. Go back to the ONLINE BEHAVIOR Google Doc you created yesterday and do the following:
      1. Write one thing that you learned today about:
        1. How to keep information private online.
        2. How to behave online and what to do if someone misbehaves.
        3. How to avoid dangers online.
  3. Create a new Google Doc and share it with me. Name it DIGITAL CITIZENSHIP and do the following in the Google Doc:
    1. Write down all of the YouTube guidelines you know of. Keep this Google Doc open so that you can refer to it at the end of class.
  4. Watch this: http://www.youtube.com/watch?v=nI2tmiKdPnU
  5. Community Guidelines for YouTube Handout
  6. GROUP ACTIVITY:
    1. Get the “Community Rules activity sheet” from your teacher
    2. Each group will represent a different online community. This community can be a real one or imaginary, big or small.
    3. Invent a name that represents your community and its purpose (for example: The Online Society for Having Fun, The Dog Owners Association, Online Club for Pizza Lovers, Fans of Jonas Brothers, etc.)
    4. Create 6 rules – 3 Do’s and 3 Don’ts that are most important for that community to function properly.
    5. Next to each rule write the purpose that it serves (what would happen if that rule didn’t exist?).
    6. Choose an ambassador that will share with the class their community rules and their purpose.
  7. As a class, we will discuss each rule and determine whether:
    1. Is it also applicable to other communities?
    2. Is it also applicable to offline societies?
  8. Do you think it’s easier to be mean online than offline? Why? Discusswhether the fact that you can’t see the other person makes it easier to behave ina mean way
  9. When people abuse the rules they are not being respectful towards others.You don’t have to put up with bullies.
  10. What should you do if someone uses demeaning or threatening words,harassing you, and is being a bully?
  11. Look at “Actions to Take with Online Bullies” Handout, In groups discuss eachoption and identify when it is relevant to use. Keep these in mind:
    1. If someone is threatening that they will tell on you if you don’t do something for them, whatshould you do?
    2. If someone is posting a message that uses offensive language, what should you do?
    3. If someone is posting private information about you, what should you do?
    4. If someone keeps harassing you by sending you messages that you don’t want to get, whatshould you do?
  12. Go back to the Google Doc DIGITAL CITIZENSHIP and do the following in the Google Doc:
    1. Add any additional guidelines (that they learned from the lesson) to the list you started at the beginning class.

 

 

Essential Question for Today: How do I protect myself and my digital reputation while exploring online?

GOAL FOR TODAY:

  1. You will learn how interact with people you don’t know online and how to responsibly represent yourself online.

ORDER OF EVENTS:

  1. PRACTICE: Typing Club
  2. GROUP ACTIVITY:
    1. You are now in Cyberspace, as you wander and explore “the streets”, different strangers will approach you and ask to connect. You will have to decide whether you would like to connect with that person and what/how to reply.
    2. Get into different groups of 4-5 students. Going around the room, one person from eachgroup will pick out a strip of paper from a container or jar and read the slip out loud to the group. Then, as a group, decidehow they would respond to this situation.
    3. Each group will pick a scenario out and tell the class how you wouldrespond.
  3. ANOTHER GROUP ACTIVITY:
    1. Get into groups of 4-5 and get the “How much to share” handout from your teacher
    2. As a group, choose 1 famous person you all know. It can be The President, an Athlete, an Author etc. Once you agree on a person everyone knows- take out the “Make Your Own Profile” handout and construct an online profile for them.
    3. After your group has created your profile, we will share each group’s profile anddiscuss what each group chose to put on their profiles versus what they left out.
  4. Create a Google Doc to share with me titled ONLINE REPRESENTATION and address the following;
    1. What did you learn today and how can you apply that to your life right now?

Essential Question for Today: How do I protect myself against online tricks?

GOALS FOR TODAY:

  1. You will understand that not everything you see on the web is true, and how to recognize online scams.
  2. You will review how to protect yourself from scams.
  3. You will know how to take action if you find yourself being scammed.

ORDER OF EVENTS:

  1. PRACTICE: Typing Club
  2. Watch this short video (developed by the team at Google), Steering Clear of Cyber Tricks. This video will explain what cyber tricks are, how to avoid fallingfor online scams, what phishing means online (it’s not what you think…) and what to doif you realize you have been tricked: http://www.youtube.com/watch?v=MrG061_Rm7E
  3. Read this site: http://www.google.com/goodtoknow/online-safety/scams/ and watch the video at the end.
  4. Go to this website and take the quiz: http://www.sonicwall.com/furl/phishing/index.php
    1. How did you do?! Keep the results screen up! We will go over them.
  5. GROUP ACTIVITY:
    1. We are going to play a cyber security game of “Who Wants to be aMillionaire?” to test your knowledge about how to steer clear of cyber tricks.
    2. Get into groups of 4-5 students.
    3. Come up with a group name.
    4. You will be asked a questions and each group will have ten seconds to discuss.
    5. One student from each group will raisetheir hand when your group has the answer.
    6. If your group gets the question right, you will earn the pointsassociated with that question.

GAME DAY:

Cellphone Smart Games: http://www.ikeepsafe.org/youth/cellphone-smart/

Online Safety/Cyberbullying Games: http://www.nsteens.org/Games

Google Doc: What did you learn from playing the games today? What did you learn that you can teach others? USE ANIMOTO

 

VIDEO DAY:

Watch these videos about online safety/cyberbullying: http://www.nsteens.org/Videos

Google Doc: What did you learn from watching these videos today? What did you learn that you can teach others? USE ANIMOTO

FINAL PROJECT FOR DIGITAL CITIZENSHIP UNIT:

GOAL: Before you leave today you will have the opportunity to demonstrate what you have learned about digital citizenship.

PRACTICE: Typing Club–Remember to: sit up straight, feet on floor, lean slightly forward, keep eyes on screen, cover hands.

CREATE: go to www.prezi.com and create an account

WATCH: http://www.youtube.com/watch?v=tolWEl7oBQg (how to make a Prezi)

CREATE: Create a new Prezi. Include the following:

  1. Title: What Digital Citizenship Means to Me
  2. Include YouTube video clips
  3. Include credits (websites you used) at the end

EDMODO: Send me a note about what you learned about Prezi today and what you plan to include in this project.

EXPERIMENT: www.wordle.com

Before you leave today you will understand what is meant by digital citizenship, netiquette, cyberbullying, and digital securtity.

COMPLETE: Get Google Search on 1/2 of your screen and your Google Doc from last. Finish researching your term. Be prepared to share with the class.

WATCH: Digital Citizenship Introduction: https://www.youtube.com/watch?v=RfGkmzhZCIA

POST: Post the main idea of this video clip: http://wiffiti.locamoda.com/boards/13567

Before you leave today you will understand the importance of digital etiquette and you will be aware of appropriate and inappropriate behavior when using digital devices.

QUIZ: Take the Etiquette Quiz to see what you already know about Digital Etiquette. Choose to have it graded and at the end, have it sent to me: tracyweber@bellevue.k12.ia.us

http://www.teachertube.com/viewVideo.php?video_id=186363

 

 http://www.teachertube.com/viewVideo.php?video_id=26038

 http://www.teachertube.com/viewVideo.php?video_id=186363

http://www.teachertube.com

http://www.teachertube.com/viewVideo.php?video_id=92840

 http://www.teachertube.com/viewVideo.php?video_id=26038
http://www.teachertube.com/viewVideo.php?video_id=186363
http://www.teachertube.com/viewVideo.php?video_id=144981

http://www.teachertube.com/viewVideo.php?video_id=26038

 http://www.teachertube.com/viewVideo.php?video_id=199290

http://www.teachertube.com/viewVideo.php?video_id=83000

 http://www.teachertube.com/viewVideo.php?video_id=83795

http://www.teachertube.com/viewVideo.php?video_id=26038

 http://www.teachertube.com/viewVideo.php?video_id=102827

WATCH: Then watch the presentation: https://www.youtube.com/watch?v=bLNZkU1tuU8

WATCH: Watch the cyber-bullying video: https://www.youtube.com/watch?v=gnFkKOZiHZA

WRITE: In a Google Doc shared with me (tracyweber@bellevue.k12.ia.us), reflect on the cyber-bullying video. Using at least 5 complete sentences, describe your feelings and thoughts about the video clip. How can you learn from this?

SHARE: Go to www.todaysmeet.com and share your thoughts about the video clip.

PRACTICE: typingclub and then revisit www.todaysmeet.com to view your classmates responses.

 

Before you leave today you will know what is meant by digital citizenship communication and you will be able to communicate to others important tips to remember when communicating online.

PRACTICE: Typing Club–Remember to: sit up straight, feet on floor, lean slightly forward, keep eyes on screen, cover hands.

WATCH: Watch this video clip about Digital Citizenship Communication: https://www.youtube.com/watch?v=4lZPP8ePJbU

WRITE: Create a Google Doc and share it with me: tracyweber@bellevue.k12.ia.us. In the Google Doc, include the following:

  1. You are the technology coordinator for Bellevue Community School District. You need to make sure all students know and understand digital citizenship communication. Create a NEED TO KNOW handout for students that lists good points to remember when communicating online. Name this Doc. You will need to refer to it in order to complete the final project for this unit.
  2. Go to teachertube.com to find at least 3 other video clips about digital citizenship communication. Copy and paste the URLs in this same Google Doc.

CREATE: Go to www.glogster.com and create a multimedia poster illustrating your list.

  1. Go to: http://www.glogster.com/dashboard/pulse
  2. Create an account using your school email
  3. Check your school email to verify your account
  4. Look at this sample glog: http://www.glogster.com/jordanbuske1/resume-glog-by-jordanbuske1/g-6khthojmicidmjuift750ea?s=imgglog
  5. Click the GLOGSTER pink button in the upper left corner
  6. Click on POSTER GLOG (it will take a little while to load) and create a GLOG with your 10 points about Digital Communication.
  7. Include the following:
    1. YouTube/TeacherTube video–at least 1
    2. At least 1 animated clipart
    3. Wallpaper
  8. Click to SAVE and name it.
  9. You do not need to put any tags in it (continue)
  10. Copy the provide URL and paste it into your Google Doc above with your list.
  11. Share it with me: tracyweber@bellevue.k12.ia.us

Before you leave today you will know what is meant by digital literacy and you will have a better understanding of evaluating what is true and accurate on the internet.

PRACTICE: Typing Club–Remember to: sit up straight, feet on floor, lean slightly forward, keep eyes on screen, cover hands.

WATCH: Digital Literacy is one of the most important elements of Digital Citizenship. Being able to determine the purpose behind different media will help you make decisions for research and tasks in your day to day life. Watch the following video: https://www.youtube.com/watch?v=KsnN3DJQ3Jg

WATCH: After watching, go through the Prezi to learn the top 10 concepts that all students should know and understand. The clips in the Prezi illustrate each concept–Be patient; it may take a few minutes for the clips to load: http://prezi.com/la90gsw0txra/?utm_campaign=share&utm_medium=copy&rc=ex0share TAKE NOTES IN A GOOGLE DOC AS YOU GO!!!

Send me a note in Edmodo addressing the following questions:

  1. What was the main idea of the video clip and the Prezi?
  2. What do you think was important in the video clip and the Prezi? Why?

 

 

GOAL: Before you leave today you will understand how to evaluate whether information on a website is true/accurate.

PRACTICE: Typing Club–Remember to: sit up straight, feet on floor, lean slightly forward, keep eyes on screen, cover hands.

DO: Follow the steps below to help you evaluate a website.

  1. Go to this website: http://www.classzone.com/books/research_guide/page_build.cfm?content=web_eval&state=none
  2. Click on Criteria for Evaluating Web Sites
  3. Read and take notes about the 5 criteria to use when evaluating a website.
  4. Click http://www.classzone.com/books/research_guide/page_build.cfm?content=activity_eval_site&state=none and evaluate a website as instructed. Evaluate these sites also:
    1. The Jackalope Conspiracy
    2. The Tree Octopus
    3. Dihydrogen Monoxide
    4. BSA
  5. Click http://www.classzone.com/books/research_guide/page_build.cfm?content=activity_guess_url&state=none and see if you can guess the url.

WRITE: Create a Google Doc and share it with me: tracyweber@bellevue.k12.ia.us. In the Google Doc, include the following:

  1. Write an email message to friend to let them know the dangers in conducting internet research and what they can do in order to be sure they are reading real and true information on the internet.

GOAL: Before you leave today you will know what is meant by digital security and how you can use this in your life. You will also learn about how your health and wellness can be affected while being a digital citizen.

PRACTICE: Typing Club–Remember to: sit up straight, feet on floor, lean slightly forward, keep eyes on screen, cover hands.

WATCH: Watch the following video and take notes in a Google Doc: https://www.youtube.com/watch?v=bKFL4CdCQ-o

WRITE: Create a Google Doc and share it with me: tracyweber@bellevue.k12.ia.us. In the Google Doc, include the following:

  1. You will need to go home tonight and share with your parents what you learned today about Digital Security. Using at least 5 complete sentences, write what you will tell your parents about Digital Security. (EXTRA CREDIT: Share this with your parents at home tonight, bring in a signed note from your parents stating that you did this, get extra credit)

PLAY & LEARN: http://www.netsmartz.org/Teens

READ & LEARN & SHARE: https://accounts.google.com/PasswordHelp

TAKE THIS QUIZ AT THE END OF THE UNIT QUIZ: Take the Etiquette Quiz to see what you already know about Digital Etiquette. Choose to have it graded and at the end, have it sent to me: tracyweber@bellevue.k12.ia.us

Before you leave today you will know what is meant by Digital Citizenship Access, Law, and Commerce.

PRACTICE: Typing Club–Remember to: sit up straight, feet on floor, lean slightly forward, keep eyes on screen, cover hands.

WATCH: Watch the following video and take notes in a Google Doc:

  1. https://www.youtube.com/watch?v=CYRUUxsH7Qk

WRITE: Create a Google Doc and share it with me: tracyweber@bellevue.k12.ia.us. In the Google Doc, include the following:

  1. Create a narrative for a person to speak as a public service announcement for this topic.
  2. Go to www.voki.com and record your narrative.

PLAY: http://www.cybersmart.gov.au/Kids.aspx

 

Final Project

Assignment: 

You will create a final project, from the options listed below, based on the nine elements of Digital Citizenship. The project must express appropriate knowledge of ALL of the nine elements. It must also show greater concentration on one of the top three elements (Security, Etiquette, and Literacy). The project needs to display an element of creativity.

EXAMPLES:

#1 GLOGSTER

#2

#3 ThingLink

#4 piccollage app on the iPad

Works Cited:

Works_Cited_for_9_Planets

Options: 

· Poster (Glogster.com)

· Skit (Video) (youtube; flipshare) (GoAnimate: example: https://www.youtube.com/watch?v=SGCOjeZcF5w)

· Presentation (Animoto, PowerPoint, Prezi)

Guidelines:

1. All projects are to be done individually. Students who choose to do a skit may work in groups of up to three.

2. Skits must be 4 – 6 minutes long.

3. All nine elements must be represented. There must be a greater concentration on one of the top three elements.

4. Each element must have a definition and at least ONE application to life (an example) must be expressed.

5. The element of greater concentration must have a definition and at least THREE applications to life (an example) must be expressed.

6. A personal goal must be set regarding the element of greater concentration.

· Example: Security – Goal = I will make sure I don’t give out any personal information on the web.

7. All images must be documented correctly on your Works Cited.

8. A level of originality and creativity needs to be displayed throughout the project.

 

Final Project Grading Rubric –

 

6 pts 8 pts 10 pts
1. Nine Elements Five – seven of the elements are present and explained. Includes some definitions & some applications Seven – eight of the elements are present and explained. Includes some definitions and some applications All nine elements are present and explained. Includes all definitions and all applications
2. One Element(Top three) The focus and concentration on one element is not clear. Includes one application The specified element is there but does not clearly stand out. Includes two applications The specified element is there and clearly stands out. Includes all three applications.
3. Goal Personal goal related to one of the top three elements is present.
4. Works Cited All visuals are documented in a Works Cited page
5. Creativity &Neatness X Content is unclear or lost Content is clear and easily apparent

Final Project

Assignment: 

You will create a final project, from the options listed below, based on the nine elements of Digital Citizenship. The project must express appropriate knowledge of ALL of the nine elements. It must also show greater concentration on one of the top three elements (Security, Etiquette, and Literacy). The project needs to display an element of creativity.

EXAMPLES:

#1 GLOGSTER

#2

#3 ThingLink

#4 piccollage app on the iPad

Works Cited:

Works_Cited_for_9_Planets

Options: 

· Poster (Glogster.com)

· Skit (Video) (youtube; flipshare) (GoAnimate: example: https://www.youtube.com/watch?v=SGCOjeZcF5w)

· Presentation (Animoto, PowerPoint, Prezi)

Guidelines:

1. All projects are to be done individually. Students who choose to do a skit may work in groups of up to three.

2. Skits must be 4 – 6 minutes long.

3. All nine elements must be represented. There must be a greater concentration on one of the top three elements.

4. Each element must have a definition and at least ONE application to life (an example) must be expressed.

5. The element of greater concentration must have a definition and at least THREE applications to life (an example) must be expressed.

6. A personal goal must be set regarding the element of greater concentration.

· Example: Security – Goal = I will make sure I don’t give out any personal information on the web.

7. All images must be documented correctly on your Works Cited.

8. A level of originality and creativity needs to be displayed throughout the project.

 

Final Project Grading Rubric –

 

6 pts 8 pts 10 pts
1. Nine Elements Five – seven of the elements are present and explained. Includes some definitions & some applications Seven – eight of the elements are present and explained. Includes some definitions and some applications All nine elements are present and explained. Includes all definitions and all applications
2. One Element(Top three) The focus and concentration on one element is not clear. Includes one application The specified element is there but does not clearly stand out. Includes two applications The specified element is there and clearly stands out. Includes all three applications.
3. Goal Personal goal related to one of the top three elements is present.
4. Works Cited All visuals are documented in a Works Cited page
5. Creativity &Neatness X Content is unclear or lost Content is clear and easily apparent

Final Project

Assignment: 

You will create a final project, from the options listed below, based on the nine elements of Digital Citizenship. The project must express appropriate knowledge of ALL of the nine elements. It must also show greater concentration on one of the top three elements (Security, Etiquette, and Literacy). The project needs to display an element of creativity.

EXAMPLES:

#1 GLOGSTER

#2

#3 ThingLink

#4 piccollage app on the iPad

Works Cited:

Works_Cited_for_9_Planets

Options: 

· Poster (Glogster.com)

· Skit (Video) (youtube; flipshare) (GoAnimate: example: https://www.youtube.com/watch?v=SGCOjeZcF5w)

· Presentation (Animoto, PowerPoint, Prezi)

Guidelines:

1. All projects are to be done individually. Students who choose to do a skit may work in groups of up to three.

2. Skits must be 4 – 6 minutes long.

3. All nine elements must be represented. There must be a greater concentration on one of the top three elements.

4. Each element must have a definition and at least ONE application to life (an example) must be expressed.

5. The element of greater concentration must have a definition and at least THREE applications to life (an example) must be expressed.

6. A personal goal must be set regarding the element of greater concentration.

· Example: Security – Goal = I will make sure I don’t give out any personal information on the web.

7. All images must be documented correctly on your Works Cited.

8. A level of originality and creativity needs to be displayed throughout the project.

 

Final Project Grading Rubric –

 

6 pts 8 pts 10 pts
1. Nine Elements Five – seven of the elements are present and explained. Includes some definitions & some applications Seven – eight of the elements are present and explained. Includes some definitions and some applications All nine elements are present and explained. Includes all definitions and all applications
2. One Element(Top three) The focus and concentration on one element is not clear. Includes one application The specified element is there but does not clearly stand out. Includes two applications The specified element is there and clearly stands out. Includes all three applications.
3. Goal Personal goal related to one of the top three elements is present.
4. Works Cited All visuals are documented in a Works Cited page
5. Creativity &Neatness X Content is unclear or lost Content is clear and easily apparent

 

GOAL: Before you leave today you will have the opportunity to demonstrate what you have learned about digital citizenship. THIS IS DUE TODAY

PRACTICE: Typing Club–Remember to: sit up straight, feet on floor, lean slightly forward, keep eyes on screen, cover hands.

CREATE: go to www.prezi.com and create an account (if you didn’t do it last class)

WATCH: http://www.youtube.com/watch?v=tolWEl7oBQg (how to make a Prezi)

CREATE: Create a new Prezi. Include the following:

  1. Title: What Digital Citizenship Means to Me
  2. Include YouTube video clips
  3. Include at least 5 things you learned from this unit.
  4. Include credits (websites you used) at the end

EDMODO: Send me a note that includes the URL of your Prezi.

  1. Typing Club
  2. Excel PreTest in Edmodo–THIS WILL NOT GO IN MY GRADEBOOK!! Do the best you can!!
  3. EXCEL INTRO–watch this first!
  4. Create the following spreadsheets:
    1. Create a NEW Excel Spreadsheet and save it as BOWLING SCORES to your Google Drive:bowlingscores
    2. Create a NEW Excel spreadsheet and save it as GOLF SCORES to your Google Drive (do only to row 10): golfscores
    3. Create a NEW Excel spreadsheet and save it as  GRADEBOOK to your Google Drive (do only to row 10): gradebook

GOAL: Before you leave today you will know how to properly format an Excel spreadsheet and how to enter functions.

  1. Typing Club
  2. Finish the Bullying report from Day 28
  3. HOW TO FORMAT A SPREADSHEET
  4. Open your Bowling Scores spreadsheet that you created last class and format it so it looks like the following: (You may use this handout for help:  Bowling Scores Spreadsheet Instructions Handout) Be sure to use FUNCTIONS to find the AVERAGE and SUM.bowlingscoresformatted
  5. Open your Golf Scores spreadsheet that you created last class and format it so it looks like the following: (You may use this handout for help:   Golf Scores Spreadsheet Instructions Handout) Be sure to use FUNCTIONS to find the AVERAGE and SUM.

    Golf Scores

    Name

    Round 1

    Round 2

    Round 3

    Average Score

    Terry

    45

    58

    58

    53.67

    John

    40

    45

    35

    40.00

    Sue

    38

    63

    64

    55.00

    Katie

    50

    70

    58

    59.33

    Jack

    53

    48

    35

    45.33

    Kerry

    59

    35

    52

    48.67

    Total Score

    285

    319

    302

  6. Open your GradeBook spreadsheet that you created last class and format it so it looks like the following: (You may use this handout for help:   Fairy Tale Grade Book Instructions Handout. Disregard the Chart. Use functions to find the AVERAGE and SUM. Show me. For a grade.gradebookformatted
  7. Open your Basic Gradebook spreadsheet that you created last class and format it so it looks like the following: (You may use this handout for help:   Your Own Basic Grade Book Instructions Handout.) Use functions to calculate AVERAGE and SUM. Show me.basicgradesformatted
  8. Open your Math Grades spreadsheet that you created last class and format it to look like the following: (You may use this handout for help: Your Math Grades Instructions Handout.) Use functions to calculate AVERAGE and SUM.  Show me. For a grade.mathgrades

 

    1. Create a NEW Excel spreadsheet and save it as BASIC GRADEBOOK to your Google Drive (do only to row 13): basicgrades
    2. Create a NEW Excel spreadsheet and save it as MATH GRADES to your Google Drive: mathgrades
  1. Open your Basic Gradebook spreadsheet that you created last class and format it so it looks like the following: (You may use this handout for help:   Your Own Basic Grade Book Instructions Handout.) Use functions to calculate AVERAGE and SUM. SHOW YOUR TEACHER WHEN YOU ARE DONE.basicgradesformatted
  2. Open your Math Grades spreadsheet that you created last class and format it to look like the following: (You may use this handout for help: Your Math Grades Instructions Handout.) Use functions to calculate AVERAGE and SUM.  Show me. For a grade.mathgrades

 

  1. Excel Terms
  2. Excel Terms Tool
    1. Type Term in the Oval (Right-click in Oval & choose Add Text)
    2. Type the definition of the term in the Definition box
    3. Type an example in the Example box or wait to draw a picture in the box after you print
    4. Optional: Type or draw a non-example
    5. DO NOT DO THE CHARACTERISTICS BOX
  3. Battleship
    1. STOP HERE!!!!
    2. Go to LEARNFREE.ORG
      1. In the Search box, type Excel and click on Excel 2010
      2. Click on the first lesson
      3. Getting to Know Excel 2010
        1. What is a spreadsheet program?
        2. What does the Quick Access Toolbar allow you to do?
        3. What is a ribbon?
        4. What does the name box allow you to do?
        5. What can you do with the formula bar?
        6. What identifies a column?
        7. What identifies a row?
        8. What is the difference between a workbook and a worksheet?
        9. What are the 3 different ways to view a spreadsheet? Which one is the default? What does it mean to be the “default”?
        10. Where is the zoom control?
      4. Working with Your Environment
        1. How is the ribbon divided up?
        2. How can you see more options for a group on the ribbon?
        3. SKIP TO CUSTOMIZE THE RIBBON
        4. Scroll to the bottom and read &try the TO MINIMIZE AND MAXIMIZE THE RIBBON
      5. The Quick Access Toolbar
        1. How can you add commands to the quick access toolbar?
      6. Backstage View
        1. What is backstage view and how do you get there?
        2. What can you do from the backstage view?
      7. Creating and Opening Workbooks
        1. How do you create a blank workbook?
        2. How can you open an existing workbook?
      8. Challenge
        1. DO IT!!! Use the example, if there is one available.
      9. CLICK ON CELL BASICS (#2)
        1. What can cells contain?
        2. What is a cell?
        3. How do you know what the cell address is?
        4. How do you select cells?
        5. In what 2 places can you VIEW and EDIT the contents of a cell?
        6. What is the difference between deleting cells and clearing cell contents?
        7. How do you cut, copy, and paste cells–which tab, ribbon section, and button?
        8. What is a quick way to access formatting options?
        9. How do you move cells? What does your pointer look like?
        10. What does the fill handle do? What does your pointer look like?
        11. Do the challenge. Use the example, if there is one available.
      10. Click on MODIFYING COLUMNS, ROWS, AND CELLS
        1. How do you modify a column width? What does your pointer look like?
        2. How do you modify row height? What does your pointer look like?
        3. How do you insert columns & rows? Which tab, ribbon section, and button?
        4. How do you delete columns & rows? Which tab, ribbon section, and button?
        5. How do you wrap text? How do you think this could be useful?
        6. When using Merge & Center, what do you have to do first?
        7. Do the Challenge–if you don’t know how to do something, ask for help!! Use the example, if there is one available.
      11. Click on FORMATTING CELLS
        1. Which tab allows you to change the font and the font size?
        2. What does the Grow and Shrink button do?
        3. How do you add a border? What does the button look like?
        4. How do you add fill? What does the button look like?
        5. What is the difference between vertical text alignment and horizontal text alignment? In which tab and section of the ribbon will you find the alignment commands?
        6. Which tab and ribbon section contains the commands to format numbers and dates?
        7. Which number format would you select to get your numbers to have 1 decimal and a comma?
        8. Which number format would you select to show your date like this: 12/13/2012?
        9. Do the Challenge–if you don’t know how to do something, ask for help!! Use the example, if there is one available.
      12. Click on SAVING
        1. What is the difference between SAVE and SAVE AS?
        2. How does autosave work? Is this useful?
        3. If you wanted to send a workbook to someone who is using Excel 97, what would you have to do?
        4. When would you want to send a workbook saved as a PDF?
        5. Do the Challenge–if you don’t know how to do something, ask for help!! Use the example, if there is one available.
      13. Click on CREATING SIMPLE FORMULAS
        1. What is a formula?
        2. What symbol would you use to multiply? divide? add? subtract?
        3. When creating a formula, what should be entered in the cell first?
        4. What is cell reference?
        5. Why should you use a cell reference? What is the advantage to entering the cell reference as opposed to just entering the numbers?
        6. Pointing and clicking is the easiest way to enter a formula!! Be sure you know how to do this!!
        7. How do you edit a formula?
        8. Do the Challenge–if you don’t know how to do something, ask for help!! Use the example, if there is one available.
      14. Click on PRINTING (SKIP WORKSHEET BASICS)
        1. What is the name of the printer that you will print to in this room (it is on the printer–go look!!)
        2. How can you tell the computer that you only want to print a certain set of cells and not the entire worksheet?
        3. How can you change the orientation to LANDSCAPE?
        4. What does it mean to SCALE?
        5. How do you set the print area so that only a portion of a spreadsheet prints?
        6. How can you change the margins?
        7. Do the Challenge–if you don’t know how to do something, ask for help!! Use the example, if there is one available.
      15. Click on WORKING WITH BASIC FUNCTIONS
        1. What is a function?
        2. What 3 parts do all functions contain?
        3. How to you use a function to add?
        4. Which function would you use to AVERAGE a group of numbers?
        5. Do the Challenge–if you don’t know how to do something, ask for help!! Use the example, if there is one available.

LAST DAY OF FIRST SEMESTER 2013

  1. Typing Club
  2. GRADE YOUR TEACHER/THE COURSE FOR 1st QUARTER
  1. Typing Club
  2. 6th GRADE EXCEL POST TEST
  3. Create a NEW Excel spreadsheet and save it as BASIC GRADEBOOK to your Google Drive (do only to row 13): basicgrades
  4. Create a NEW Excel spreadsheet and save it as MATH GRADES to your Google Drive: mathgrades
  5. Open your Basic Gradebook spreadsheet that you created last class and format it so it looks like the following: (You may use this handout for help:   Your Own Basic Grade Book Instructions Handout.) Use functions to calculate AVERAGE and SUM. SHOW YOUR TEACHER WHEN YOU ARE DONE.basicgradesformatted
  6. Open your Math Grades spreadsheet that you created last class and format it to look like the following: (You may use this handout for help: Your Math Grades Instructions Handout.) Use functions to calculate AVERAGE and SUM.  Show me. For a grade.mathgrades
  1. How to Show Formulas When Printing a Spreadsheet

 

  1. Lemonade Stand Spreadsheet–Get it from your teacher
  2. My Class Schedule Spreadsheet–Get it from your teacher
  3. Review functions
    1. Add the following functions to Golf Scores: (show me–no grade)
      • MAX
      • MIN
      • COUNT
    2. Add the following functions to Lemonade Stand for Sales: (show me for a grade)
      • MAX
      • MIN
      • COUNT
    3. Add the following functions to Class Schedule for Number of Students per class: (print for a grade)
      • MAX
      • MIN
      • COUNt

Typing Club

    1. Finish Class Schedule & Lemonade Stand
    2. Add the following functions to Class Schedule for Number of Students per class: (print for a grade)
      • MAX
      • MIN
      • COUNT
    3. Print Class Schedule. Use the How to Print an Excel Spreadsheet handout.
    4. Make up work
    1. Typing Web
      1. Excel Grocery Store Project–Go to netgrocer.com to help you.
    2. Excel Grocery Store Project–Discuss
    3. Typing Club
      1. TIMINGS
      2. Instruction on how to calculate grade percentages using Fairy Tale Grade Book
      3. Add the following to Your Own Basic Grade Book Instructions Handout:
        • Create a new column in column C with the column heading “Points Possible” and enter the total points possible for each assignment (you can make them up, but be sure they are larger than the points earned on each assignment!)
          • In column D enter a formula to calculate your percent on each assignment
          • Insert functions anywhere in the spreadsheet that will calculate the following:
            • how many assignments are there?
            • what is your best score?
            • what is your worst score?
          • Put your name in the header.
      4. Add the following to Math Grades:
        1. Create a column for Points Possible and enter the total points possible for each assignment (you can make them up, but be sure they are larger than the points earned on each assignment!)
        2. Enter a formula to calculate your percent on each assignment
        3. Insert formulas that will calculate the following:
          • how many assignments are there?
          • what is your best score?
          • what is your worst score?
        • Put your name in the header.
      1. Generative Sentences: SUM, AVERAGE, MAX, MIN, COUNT, Function, Formula
      2. Add the following to Math Grades, if you didn’t do it last class:
        • Create a column for Points Possible and enter the total points possible for each assignment (you can make them up, but be sure they are larger than the points earned on each assignment!)
        • Enter a formula to calculate your percent on each assignment
        • Insert formulas that will calculate the following:
          • how many assignments are there?
          • what is your best score?
          • what is your worst score?
        • Put your name in the header.
      1. Complete the following:
        1. Add the following to Lemonade Stand:
          • Create a new column in column C with the column heading “Total Cost”. The total cost for all items is $20 (enter 20 in cells c3 to c9)
            • In column D enter a formula to calculate the percent of the total cost for each item.
            • Insert functions anywhere in the spreadsheet that will calculate the following:
              • how many items are there?
              • what is your highest cost item?
              • what is your lowest cost item?
            • Put your name in the header.
            • Print 2 copies (1 showing answers & 1 showing formulas). Be sure they both fit on 1 page. Use the How to Print an Excel Spreadsheet Handout to help you
        2. Add the following to My Class Schedule:
          • Create a column for Total Students. The total students for each class is 128.
          • Enter a formula to calculate the percent of students in each class.
          • Insert formulas that will calculate the following (you may have already done this):
            • how many class are there?
            • what is highest number of students in a class?
            • what is lowest number of students in a class?
          • Put your name in the header.
          • Print 2 copies (1 showing answers & 1 showing formulas). Be sure they both fit on 1 page. Use the How to Print an Excel Spreadsheet Handout to help you.

 

  1. Typing Club

Check JMC and do make up work.

Coffee Shop Game–Hoodamath

  1. Typing Club
    1. Complete the following:
      1. Add the following to Lemonade Stand:
        • Create a new column in column C with the column heading “Total Cost”. The total cost for all items is $20 (enter 20 in cells c3 to c9)
          • In column D enter a formula to calculate the percent of the total cost for each item.
          • Insert functions anywhere in the spreadsheet that will calculate the following:
            • how many items are there?
            • what is your highest cost item?
            • what is your lowest cost item?
          • Put your name in the header.
          • Print 2 copies (1 showing answers & 1 showing formulas). Be sure they both fit on 1 page. Use the How to Print an Excel Spreadsheet Handout to help you
      2. Add the following to My Class Schedule:
        • Create a column for Total Students. The total students for each class is 128.
        • Enter a formula to calculate the percent of students in each class.
        • Insert formulas that will calculate the following (you may have already done this):
          • how many class are there?
          • what is highest number of students in a class?
          • what is lowest number of students in a class?
        • Put your name in the header.
        • Print 2 copies (1 showing answers & 1 showing formulas). Be sure they both fit on 1 page. Use the How to Print an Excel Spreadsheet Handout to help you.
    2. How to Create a Chart in Excel handout. Follow the directions on the handout
    1. M & M Worksheet. Remember to include the following:
      1. MAX
      2. MIN
      3. AVERAGE
      4. COUNT
      5. SUM
      6. a formula of your choice (-,/,*)
  1. Hands On Test next class–bring grocery store project
  2. M & M Worksheet. Remember to include the following:
    1. MAX
    2. MIN
    3. AVERAGE
    4. COUNT
    5. SUM
    6. a formula of your choice (-,/,*)

 

 

 

 

 

 

 

 

 

  1. Experiment with Prezi
  2. Plug in your headphones and unmute your sound
  3. Watch the “What is Prezi” introduction movie.
  4. Click LEARN & SUPPORT at the top of the screen. Watch the video.
  5. Go to the Prezi home page and scroll to the bottom and look at sample Prezis.
  6. Create a new prezi and experiment and become familiar!

 

 

 

Goal: Before you leave today you will have the opportunity to practice basic Prezi skills.

  1. Typing Club
  2. Technique Evaluations–CREATE THIS
  3. Click on GET STARTED WITH PREZI–watch the video.
  4. Read the following sections and bookmark them for future reference:
    1. Get to know Prezi
    2. What do I need to do?
    3. The Transformation Tool
    4. Edit Mode & Present Mode
    5. Setting your prezi’s path
  5. Create your own Prezi on a topic of your choice. This is for practice so be sure to experiement with EVERYTHING in Prezi.

GOAL: Apply your knowledge of Prezi to create a presentation to help educate your classmates on a topic of your choice.

  1. Typing Club

Assignment:

  1. Create a new Prezi from scatch about you
  2. You have today and next class to finish.
  3. Include images and video clips

GOAL: Before you leave class today you will create a Prezi about you.

  1. Typing Club
  2. Work on your Prezi from last class.
  3. Finish it today.
  4. Show me.

GOAL: Before you leave today you will know how to print a presentation.

  1. Typing Club
  2. POWERPOINT DAY 3 VIDEO CLIP
  3. Complete PowerPoint Instructions

 

 

 

 

 

GOAL: Apply your knowledge of Prezi to create a presentation to help educate your classmates on a topic of your choice.

  1. Typing Club

Assignment:

  1. Create a new Prezi from scatch about you
  2. You have today and next class to finish.
  3. Include images and video clips

 

  1. Complete PowerPoint Instructions

Goal: Before you leave today you will have the opportunity to practice basic Prezi skills.

  1. Typing Club
  2. Technique Evaluations–CREATE THIS
  3. Experiment with Prezi
  4. Plug in your headphones and unmute your sound
  5. Watch the “What is Prezi” introduction movie.
  6. Click LEARN & SUPPORT at the top of the screen. Watch the video.
  7. Go to the Prezi home page and scroll to the bottom and look at sample Prezis.
  8. Create a new prezi and experiment and become familiar!
  9. Click on GET STARTED WITH PREZI–watch the video.
  10. Read the following sections and bookmark them for future reference:
    1. Get to know Prezi
    2. What do I need to do?
    3. The Transformation Tool
    4. Edit Mode & Present Mode
    5. Setting your prezi’s path
  11. Create your own Prezi on a topic of your choice. This is for practice so be sure to experiement with EVERYTHING in Prezi.

GOAL: Before you leave class today you will create a Prezi about you.

  1. Typing Club
  2. Work on your Prezi from last class.
  3. Finish it today.
  4. Show me.

GOAL: Before you leave today, you will have the opportunity to apply what you have learned about PowerPoint presentations.

  1. Complete PowerPoint Instructions on your own. Remember to change the font to red when you complete a task.
  2. Work on the assignment in the PowerPoint Instructions Handout
  3. When you are done, show your teacher.
    1. Excel Written Test
    2. Excel Hands On Test–You need your Grocery Store worksheet

 

  1. Typing Club
  2. Excel Written Test
  3. Excel Hands On Test–You need your Grocery Store worksheet

 

  1. Typing Time
  2. admongo.gov and complete:
    1. Level 2: Assemblimator
      1. Area 3: Watery Deep
        1. What are “claims” when it come to advertising?
        2. In Challenge 1: Zaano Game Magazine Ad, is it easy or hard to tell if the:
          1. Graphics are state-of-the-art?
          2. The game breaks all the rules?
          3. There are 10 levels?
        3. Are claims in ads suppose to be true?
        4. Is there a government agency that checks ads before they appear?
      2. Area 4: Call Center
        1. In Challenge 1: Cleanology Magazine Ad, which is NOT a call to action?
        2. Are all calls to action bad in advertising? Give an example.
    2. Level 3: Planadtarium: What does targeting mean?
        1. Area 1: The Admosphere
          1. How do advertisers figure out what their target audience likes and doesn’t like?
        2. Area 2: Transmission Chamber
          1. How are ads sometimes placed in a TV show? What are some examples you can give?
          2. Where do advertisers put billboards?
    3. Student Worksheet 2–Use your own ad or the Ad Library in Admongo.
    4. Bonus Activity 2–Use your own ad or an online ad
  1. Typing Time
  2. Level 4: The Adgitator
    1. Area 1: Brain Lab
    2. Area 2: Transmission Chamber
      1. What is your answer to question 1?
      2. Question 2?
      3. Question 3?
  1. Student Worksheet 3–Do this on your own. Student Worksheet 2 from last class to help you with the difference techniques. Hand this in when you are done.
  2. Finale
  3. Check JMC and submit make up work through Edmodo
  4. Typing Time

Final Written Exam

Begin Final Hands On Exam

Complete Hands On Final Exam–LAST DAY

GOAL: Before you leave today you will create the website you will be helping the 3rd graders to fill in using their researched information. Here is the scenario they were given (this is the information they will be bringing out to you–you just need to get the site set up so they can fill in their information):

Many leagues create websites to organize their schedules, standings, and give information to players and spectators. You need to create a website using www.weebly.com. If you have an idea of how to organize this information, other than using a website, please consult with your Board of Directors for approval before staring.

You website must include the following information:

  • Schedule
  • Team names and logos
  • Standings
  • Statistics of at least 5 players in your organization
  1. Get with a partner!!
  2. WATCH THIS: http://www.powtoon.com/embed/fWJz4BcXvyD/ AND DO IT!! Designate each group member as an administrator–that person needs to make everyone else an editor
  3. WHAT YOU AND YOUR PARTNER NEED TO DO TODAY:
    1. Decide how many pages will be in this site
    2. Decide who is in charge of each page
    3. Be sure to use the information in the scenario above!!
    4. Create all pages

GOAL: Before you leave today you will complete the website you will be helping the 3rd graders to fill in using their researched information. Here is the scenario they were given (this is the information they will be bringing out to you–you just need to get the site set up so they can fill in their information):

Many leagues create websites to organize their schedules, standings, and give information to players and spectators. You need to create a website using www.weebly.com. If you have an idea of how to organize this information, other than using a website, please consult with your Board of Directors for approval before staring.

You website must include the following information:

  • Schedule
  • Team names and logos
  • Standings
  • Statistics of at least 5 players in your organization

WHAT YOU AND YOUR PARTNER NEED TO DO TODAY:

  1. COMPLETE filling in your pages–create placeholders the 3rd graders can type their information into–what do you think you should do to make sure it will work for them????????
  2. Be sure to use the information in the scenario above!!
  3. Plan logistics…….where will the 3rd grader sit? What will you have them do first? What will you have done BEFORE they get here?

THIRD GRADERS

THIRD GRADERS

THIRD GRADERS

            1. Finish your PowerPoint and upload it to Edmodo–send it as a note to the class.
            2. Watch your classmates’ PowerPoint presentations and comment on them in Edmodo.
            3. Learn2Type or Typing Racer
            4. Inserting Scanned and Digital Photos
            5. Scanning Pictures and Using the Digital Camera
            6. Bring in photos from home for next class–save them to a flashdrive or to Drop Box
            7. Bring in a song from home for next class–save it to a flashdrive or use Jamendo or Soundzabound (username: 0585belhs password: mbaea9)
            8. Advanced PowerPoint Instructions
              1. The song you will add is in your class’ 2nd Semester folder
              2. Use the pictures in your folder that we took last class.
              3. Do your best! Today is just for practice! You will get a chance to make another one next class with your own photos and song from home!
        1. Complete working through the Advanced PowerPoint handout you received last class.
        1. Complete working through the Advanced PowerPoint handout you received last class.
        1. Advanced PowerPoint Assignment
            1. Create a Photo Album slide show
            2. Put the photo album slide show to music
            3. Make sure the presentation has the following:
              1. Follow everything on the PowerPoint Rules handout
              2. Make everything animated
              3. Make every slide have a transition
              4. Recolor at least 1 piece of CLIPART
              5. Use wordart on the first slide
              6. Print it as handouts with 9 per page with your name in the header
        1. Work on Advanced PowerPoint Assignment. Remember the following:
          1. Create a Photo Album slide show
          2. Put the photo album slide show to music
          3. Make sure the presentation has the following:
            1. Follow everything on the PowerPoint Rules handout
            2. Make everything animated
            3. Make every slide have a transition
            4. Recolor at least 1 piece of CLIPART
            5. Use wordart on the first slide
            6. Print it as handouts with 9 per page with your name in the header
        1. Show the class your PowerPoint–volunteer
        2. Upload your PowerPoint to Edmodo
            1. Consumer Jungle
            1. Typing Time
            2. 2010-2011 START PERSONAL FINANCE UNIT!!! USE Hands On Banking–the KIDS section!
              1. Watch and listen to the Introduction
              2. Take the Site Tour and answer the questions in Edmodo
            3. Hands On Banking –You and Your Money–Do the Hands on Banking Assignment #1 in Edmodo–respond in a NOTE TO ME!!
            1. Typing Time
            2. Teacher Evaluation
            3. Review for Final Exam
            1. Lesson 2 Hands On Banking–Do the Hands on Banking Assignment #2 in Edmodo–respond in a NOTE TO ME!!
            2. Consumer Jungle
            3. Hands On Banking
            4. Finish Edmodo–#3 Budgeting–Remember to click TURN IN in Edmodo for this assignment and then click FILE and then browse to find your file
            5. Edmodo–#4 Saving and Checking Accounts
            6. Hands On Banking
            7. Edmodo–#5 Credit
            8. Consumer Jungle

 

 

Web Wall on Wikispaces

  1. Typing Time
  2. Timeline Project- Present
  3. Timeline Project- Paper Due at the end of class
  4. Difference Between Internet, Extranet, and Intranet
  5. Typing Time

    • Keyterms Lesson
    • Crossword Internet Terms
    • Website Extensions
    • Typing Time
    • Identify Six Types of Web Pages
    • Email
    • Favorites and Bookmarks
    • Evaluate Web Pages
    • Find Favorite – Critique It
    • Typing Time
    • Search Engines
    • Explore!
    • Elephant Search

Loose Change Assignment

    1. Get loose change from your teacher (you need to give it back :-))
    2. Create a spreadsheet showing the following:
      1. number of coins for each type of currency
      2. amount of money for each currency
      3. TOTAL amount of money
    3. INCLUDE OTHER FORMULAS YOU KNOW besides the SUM function.
    4. Include a chart
    5. Format it to look nice–add a border, clipart, change font color, style, etc. MAKE IT LOOK NICE, BUT NOT BUSY OR CLUTTERED!!!
    6. Print it showing answers & showing formulas.
    7. Make it fit to 1 page
    8. Put your name in the header.
    9. Write on the printout what the chart is showing

Complete M & M Comparisons. Add the following:

  1. At least 2 functions
  2. At least 1 other formula
  3. Print this showing answers & showing formulas with your name in the header

My M & M’s Comparisons–Get the handout from your teacher. Let’s see who can get their’s to look just like the example!

  1. Typing Time Lesson 2
  2. PowerPoint Handout–FINISH IT!
  1. Today we will be starting our Internet Unit
      1. Typing Time
      2. Internet Pre-Test–No talking & no Internet.
      3. Internet Connections–There will be no class discussion. Look each one up on the Internet and write your answer on the handout. (www.dictionary.com may be of use)
                  1. Group Roles
                  2. Groups
                  3. Decide on topic of PowerPoint & slide titles
                  4. Work with your partner on your new PowerPoint assignment.
                        1. Be sure to take out your grading rubric–make sure you are meeting the requirements
                        2. Decide on topics for each slide–type all your work out before you begin to add fancy stuff
                        3. You may only get everything typed today–you will have time tomorrow to add fancy stuff
                        4. CONSTANTLY REVIEW YOUR GRADING RUBRIC FOR THIS ASSIGNMENT TO MAKE SURE YOU ARE MEETING THE REQUIREMENTS!!!
              1. Group Assignment
      1. Finish Moodle about Teamwork
              1. Group PowerPoint Assignment
    1. Group PowerPoint Assignment–Finish
    2. Present PowerPoint Assignment #2
    3. Present PowerPoint Assignment #2–Finish
    4. Moodle about Teamwork

     

     

  2. Evaluate Mrs. Weber–Please be honest!! Mrs. Weber takes this very seriously!
  3. Internet Vocab Handout–Look up the terms online and write the definitions for as many as you can find.
  4. History of Your Birthday Handout
  5. Finish:
    1. Internet Vocab Handout
    2. History of Your Birthday Handout
  6. Moodle: Explain what is meant by fair use and how you can give credit where credit is due when copying & pasting from the Internet.
  7. Timeline Project– Power Point
  8. Timeline Project– Power Point

Complete Timeline Project

Present Timeline Project

Teacher/Course Evaluation

Awards