WEEK OF CODE

GOAL: You will remix JavaScript code to change the words on a website, learn about composing for the web, coding JavaScript values, and remixing Web content.

OBJECTIVES:

  • Distinguish between original content and a remix
  • Recognize the relationship between HTML and JavaScript elements.
  • Edit JavaScript to change the words on a webpage.

GET STARTED:

  1. Go to https://teach.mozilla.org/ and CREATE an account
  2. In coding/techy vocab, what does REMIX mean and is it legal?
  3. Get a notecard and pen or pencil.
  4. Write down the best homework excuse ever.
  5. Give your notecard to a classmate.
  6. Read the card given to you out loud.
  7. Here is the webpage for today’s activity.
  8. Explore the projectExplore the Homework Excuse Generator by clicking on its button several times.This was made in Mozilla’s Thimble Web editor. This means that you can hit the green “Remix” button in the upper right hand corner of the screen to change all sorts of things on the page, including its title, text, and images.After you hit the Remix button, Thimble will show them the code for the wbepage, as well as the JavaScript code that makes the button work with the webpage. HTML, the language of the Web, shapes the page while JavaScript, a coding language for webpages, makes its interactive parts work.
    • The title of the page on the index.html page.
    • Several values in the arrays, or sets of words’ in the excuses.js file.
    • The credits at the bottom of the index.html page.
       Remix the project

      Look around the Thimble interface. Notice the sidebar to the left that has the main page called index.html, as well as the other files used in the web page, including the JavaScript file called excuses.js.

      Notice that you can hit the ‘Tutorial’ tab on the right side of the screen to switch your view from the webpage to a self-guided tutorial that takes you through the remix activity.

      Do the tutorial at your own pace.

      In the end you should have remixed and changed

  9.  Share your project

    Publish your remix. Hit the ‘Publish’ button in the upper right-hand corner of your mix when you are finished. Thimble will give you a URL, or Web address, to visit and share. Share it with your teacher.Take it a step further.Transform the Homework Excuse Generator into something else entirely, like a gross food generator. Check out the style.css file in the left sidebar and to see what happens when you change values there.

  10. Reflect and review

    Visit your classmate’s machines to see what they came up with in their remixes.

    In your Google Doc for this class, respond to the following:

    • What seemed easiest or most difficult about remixing the page today?
    • How does beginning with a remix help you learn to build something new? Or is beginning with a remix less helpful than beginning with a blank page? Why do you think so?
    • How would you explain the connection between the HTML – or webpage – in this activity and the JavaScript file?

Make Your First Webpage | Build a Blank Page & Beyond

Learning Objectives

  • Understand and explain how to build a basic, blank webpage using high-level HTML tags.
  • Identify and explain the basic parts of a webpage including the head and body.
  • Code and compose basic meta information about a webpage using appropriate tags and attributes including author, title, and character set.
  1. Today we’ll be building a webpage. The webpage we’ll build is going to be blank. That way, we can see if we made any mistakes if something shows up on the screen. We’ll learn about the basic parts of a webpage – the tags that act like the roof and foundation of the page and surround everything else.
  2. We’ll build a blank page together before reflecting on what we’ve learned so far about structuring pages with HTML. The great thing about a blank webpage is that it’s easy to test: when you’re finished, if something shows up, you’ve got a bug to fix. If the page is blank, you did it right. Follow along as I work through the tags to structure the page.
  3. Let’s go remix this blank webpage project in Thimble. Here is the URL.
  4. Sign in to Thimble.
  5. First, let’s add <!doctype html>. This is the document type declaration. It tells a browser that our file is a webpage. This tag is a stand-alone tag. We won’t need to close it.
  6. After that, let’s open an <html> tag. This tells the browser that everything inside the tag is marked-up with HTML, the language of the web. The browser knows how to display all the HTML we’ll include between these tags. We’ll close this tag at the end of the page.
  7. Now, let’s open the <head> tag. The head is where secret information about the page goes. Anything we put in the head should be invisible to readers, but the web browser will use the information to make our page more discoverable and easy to reach online.
  8. Let’s add a <title> tag and call this page. “My Blank Webpage.” Close the </title> tag after you type the title itself. This tag is what makes your browser window or tab show the name of your page up top.
  9. Meta tags come next. Meta tags give information about the page. They don’t need to be closed. We’ll use three of them, like this:
    1. We can use something like this to tell a browser and search engine the name of our page:
      1. <meta name=”title” content=”My Blank Webpage”>
    2. We can use a meta tag like this to name ourselves as authors:
      1. <meta name=”author" content=”My Name”>
    3. We can use the meta tag called “charset” to tell the browser which character set, or alphabet, to use on the page whenever someone loads it, even if they’re in another country with a different alphabet. Our alphabet is the Western Latin alphabet, and it’s charset code is utf-8. Try it like this:
      1. <meta charset=”utf-8”>
  10. Notice how these tags have a few parts each. The meta part is the tag, the parts like name and content are attributes, or characteristics the tags can have, and the parts in quotes are the values or definitions of the attributes.
  11. You should always use meta tags to help people find your page online and give yourself credit for authoring it.
  12. Close the </head> like so and move on to the <body>.
  13. The head and body are the two main parts of any webpage. The head holds invisible information and the body holds everything you want to display on the screen. However, since we’re testing a blank webpage today, we’re going to leave the body blank for now. Let’s just open and close it with <body> and </body>.
  14. Finally, we have to close our </html> tag to tell the browser we’re done writing the page.
  15. Publish your project, give it a short description, and then visit the URL, or web address, Thimble gives you for this project. Is the page blank?
  16. Now, add text or other tags you can find to the body of the page and to see what happens.
  17. You can publish this page using the Publish button in the upper right-hand corner of the screen and use it as a template for webpages you make later on.
  18. Once you have created a blank page, take what you learned about page structure to read and revise this “Keep Calm” project on Thimble.
  19. Right click anywhere on the RED in the picture and choose VIEW PAGE SOURCE.
  20. Select the code inside the body tags and copy it.
  21. Get into Thimble and paste the code inside the body tags.
  22. In your Google Doc for this class, respond to the following:
    1. In your own words, how do tags give structure to a webpage?
    2. In your own words, how do parent and child tags work together on a webpage?
    3. What other tags do you think exist? Based on apps and webpages you’ve seen, what tags do you think people might use a lot on webpages?
    4. What do you think might happen if you forget to close a tag that needs to be closed?
    5. What questions do you have about the way webpages work? What questions do you have about the way browsers work with them?

WEEK OF CODE

WEBINAR: Hour of Code: Oh The Things You Can Makey With A Makey Makey

Description

Come chat with the folks who created the Makey Makey invention kit.  Hear about what ideas lead to its creation and what people have built with it since then.  Find out what’s next for Makey Makey and ask fun questions!

Key Questions

Whatever you ask!

And:

  • What’s a Makey Makey
  • Where did it come from
  • Why does it exist
  • What are some cool things people have created
  • And much, much more.

Expected Outcomes

A little bit about how JoyLabz operates, how we try to foster the Maker Mindset, how they can duct tape their classroom to their computer, how a banana isn’t just a banana.  And more! – See more at: https://nepris.com/sessions/session/detail/48305#sthash.H5HjTiKf.dpuf

 

WEEK OF CODE

Make Your First Webpage | #commontags

Learning Objectives

  1. Evaluate which common tag to use when according to the structure of a webpage and nature of its content.
  2. Use tags to structure and organize content on a webpage.
  3. Understand and explain HTML as a markup language for structuring a webpage.
  4. Understand and apply common tags such as <h1>, <p>, <img>, <em>, <strong>, <u>, <ol> and <ul>, and <li>.
  5. Understand and explain the importance of organization and structure to communication and media.
  6. This may be helpful:
  7. Let’s work through the page together using some common HTML tags to give it better structure and organization for a viewer. We can use the tutorial tab to help us improve the page. Click on the tab and then follow the steps.
  8. What do you think is wrong with this webpage? How do you think we might fix it? Which parts seem like they should be block elements to you? Which parts seem like they could stay inline?
  9. Once you’re on the remix screen, sign in to Thimble.
  10. You can see that the page needs some work. It’s a mess. Let’s fix it. Hit Remix to go into Thimble.
  11. First, let’s visit today’s project in Thimble. Here is the URL: http://bit.ly/2bEBmUg.
  12. We’ll also look at inline tags which are tags that work inside block elements. For example, you might have a large block element, like a paragraph, with italic words inside it. The italic passage is inline because it doesn’t start a new line. Bold and underline text, and links, work in the same way.
  13. Today we’re going to work with common HTML tags. These are the tags that people use to structure and organize information on a webpage. For example, people use <head> and <body> tags to set up the two main sections of a webpage and tags like <p> for paragraph to separate each block of text. Some of the tags we’ll use are block elements – parts of the page that get their own line or block of space like an image or paragraph.
    1. <h1> – stands for heading, level 1; used for a big heading like a title; this is a block element
    2. <p> – stands for paragraph; begins and ends blocks of text; this is a block element
    3. <img>– stands for image; calls an image into your webpage from wherever it lives as a file; this is a block element
    4. <ol> – stands for ordered list; creates a numbered list; this is a block element
    5. <ul> – stands for unordered list; creates a bulleted list; this is a block element
    6. <li> – stands for list item; creates a new child item inside a parent list; this is a block element
    7. <a> – this is the tag for a link; creates a link to another page or file; this is an inline element
    8. <strong> – this is the tag for bold text; this is an inline element
    9. <em> – stands for emphasis; this is the tag for italic text; this is an inline element
    10. <u> – stands for underline; this is the tag for underlined text; this is an inline element
  14. You can also reference this cheatsheet.
  15. Once you’ve completed the tutorial, if you have time left, keep messing with the page to see what you can discover.
  16. At the end of class, respond to the following in your Google Doc for this class:
    1. Why do people structure and organize media? Why don’t we treat all information the same way all the time?
    2. How do block elements provide structure on a webpage?
    3. How do inline elements help order or emphasize content on a webpage?
    4. What other elements do you think you might use on your own webpage? Would you predict that they are block or inline? Why?
    5. Where else in the world or in media can you see structure and organization at work? Can you explain and example for the group?
    6. What did you notice about the page before and after its revision? How did applying block and inline elements improve is structure, organization, and readability?
GOAL: Before you leave today you will know how to:

  1. Open a saved version of a project
  2. Add multiple objects to a scene
  3. Describe the difference between precise positioning and drag-and-drop (or imprecise) positioning
  4. Use a one-shot procedure to precisely position an object
    in a scene
  5. Edit properties of an object in the Scene editor
  6. Describe three-dimensional positioning axes
  7. Position the sub-parts of an object in the Scene editor

RIGHT NOW:

  1. READ these slides for understanding and refer back to it when you are doing your assignment: 
  2. DO: 
    1. You can use this file if you didn’t finish the one from last class: Finished White Rabbit Lesson 1
    2. Compare your’s with your neighbor’s when you are done with #6
    3. Compare your’s with your neighbor’s when you’re done with ALL 3 optional activities as you finish them.
    4. Here is what the finished Finished White Rabbit Lesson 2 file looks like.
  3. DO THIS!!! TELL ME HOW IT WENT TODAY!! WHAT DO YOU GET FINISHED?? HOW FAR DID YOU GET???? Send me a note stating what you learned today. 3-5 sentences.

PYTHON: Displaying Output & Variables

PYTHON: Inputs & Data Types

PYTHON: Math Operators & Logic Operators

PYTHON: Libraries & Turtle

PYTHON: Branching & While Loops

GOAL: By the end of class today you will know what programming is and how to learn programming using Khan Academy.

Log in to Google Drive ON YOUR MACHINE:

      1. Click the WINDOWS button in the lower right corner of your screen
      2. Begin to type DRIVE
      3. Click on Google Drive when it pops up
      4. Log in using your SCHOOL email

Khan Academy–sign in/create an account–CHECK YOUR SCHOOL EMAIL FOR AN INVITE FROM ME!!!

      1. What is Programming?
      2. Learning Programming on Khan Academy.
      3. What is Pair Programming?

        Download (PPTX, 1.34MB)

      4. Save these 2 files to your Google Drive for future reference:

CheatSheet
 HandoutGraphPaper

GOAL: By the end of class today you will know the basics of programming and how to draw shapes.

      1. Khan Academy: Intro to JS: Drawing & Animation: Drawing Basics

GOAL: By the end of class today you will know how to color and outline your shapes!

      1. Khan Academy: Intro to JS: Drawing & Animation: Coloring

GOAL: By the end of class today you will know how to use variables to hold values, animate your drawings, and more.

      1. Khan Academy: Intro to JS: Drawing & Animation: Variables

GOAL: By the end of class today you will know how to animate your drawings.

      1. Khan Academy: Intro to JS: Drawing & Animation: Animation Basics

GOAL: By the end of class today you will know how to make programs that draw shapes based on the mouse location, like painting apps.

      1. Khan Academy: Intro to JS: Drawing & Animation: Interactive Programs

GOAL: By the end of class today you will know how to display text on the canvas, resize it, color it, and animate it.

      1. Khan Academy: Intro to JS: Drawing & Animation: Text and Strings

GOAL: By the end of class today you will make your code more re-usable by grouping it into functions, and then make those functions accept parameters and return values.

      1. Khan Academy: Intro to JS: Drawing & Animation: Functions

GOAL: By the end of class today you will teach your program to make decisions!

      1. Khan Academy: Intro to JS: Drawing & Animation: Logic & If Statements

GOAL: Repeating something over-and-over? Loops are here to help!

      1. Khan Academy: Intro to JS: Drawing & Animation: Looping

GOAL: By the end of class today you will learn how to write JavaScript code that is easy to read and understand, with good use of indentation, spacing, naming, and comments.

      1. Khan Academy: Intro to JS: Drawing & Animation: Writing Clean Code

GOAL: By the end of class today you will learn how to store multiple values in your variables with arrays!

      1. Khan Academy: Intro to JS: Drawing & Animation: Arrays

GOAL: By the end of class today you will learn how to store complex data in objects.

      1. Khan Academy: Intro to JS: Drawing & Animation: Objects

GOAL: By the end of class today you will learn how to use object-oriented concepts in JavaScript to make more re-usable code.

      1. Khan Academy: Intro to JS: Drawing & Animation: Object-Oriented Design

GOAL: Now that you understand the basics of programming, learn techniques that will help you be more productive and write more beautiful code.

    1. Khan Academy: Intro to JS: Drawing & Animation: Becoming A Better Programmer

PixiclipSketchtoy–Drawing

TuzzitCanva & Checkthis & Picktochart–Infographics

ALICE

GOAL: Before you leave today you will know about programming, computer science, and how to think!!! You will also download and install Alice.

  1. READ THIS AND WATCH THE VIDEO: DON’T PANIC!
  2. CODEAVENGERS: What do you think of this? Do the intro lessons for the following:
    1. HTML/CSS

GOAL: Before you leave today you will know about programming, computer science, and how to think!!!

  1. CODEAVENGERS: What do you think of this? Do the intro lessons for the following:
    1. Python

GOAL: Before you leave today you will know about programming, computer science, and how to think!!!

  1. CODEAVENGERS: What do you think of this? Do the intro lessons for the following:
    1. Javascript
  2. At the end of class, email me to let me know how far you got and what you learned. Also, let me know what you would like to do next……..
    1. Start Alice & making games?
    2. Work more in CodeAvengers? If so, which language? Python? HTML? JavaScript?
    3. Other? Explain……..

Go to CODEAVENGERS & finish one programming language. You choose.

 

7/30/2015–www.microsoft.com/itacademy Web Apps & Coding 2015-2016 Group/Learning Plan Enrollment Code: 9C5QK6TME2RH7P for the online course

98-374: Gaming Development Fundamentals–retired? HTML5 App Dev Fundamentals & exam 98-375–Microsoft Certification test

Test Prep: http://www.microsoftvirtualacademy.com/training-courses/preparing-for-exam-mta-98-375-html5-app-development-fundamentals &  ftp://ftp.certiport.com/Marketing/MTA/docs/98-375-HTML5-SSG-Withoutcrop.pdf

Learn to code COURSE MATERIALS: https://www.microsoft.com/en-us/itacademy/members/LearnToCode.aspx

HTML5 application development fundamentals COURSE MATERIALS: https://www.microsoft.com/en-us/itacademy/members/html5-development-fundamentals.aspx

Gaming development fundamentals COURSE MATERIALS: https://www.microsoft.com/en-us/itacademy/members/gaming-development-fundamentals.aspx

 

TEST–ONE DAY ONLY

CREATE INSTRUCTIONAL SCREENCASTS FOR ALICE–PUT THEM ON YOUR YOUTUBE CHANNEL–SHARE YOUR CHANNEL WITH ME–Be sure to include the following:

  1. State the GOAL of the screencast at the beginning–tell them WHAT they will learn AND WHY!!!
  2. Show them step by step what to do
  3. Summarize–re-state what they learned and WHY!!
  4. Keep the video to 3 minutes or less

Work on your game in Alice

Finish your Alice game

Present your Alice game

GOAL: Before you leave class today you will be learn beginning JavaScript for App code writing.

  1. Join my TouchDevelop group for app code writing by Microsoft–Sign in using your Google account
  2. Click Choose to Code Tutorials–Choose EXPERT LEVEL–this IS Javascript!!
  3. Do the following tutorials today:
    1. First Step with Turtle
    2. Turtle Shapes

GOAL: Before you leave class today you will be learn beginning JavaScript for App code writing.

  1. Go to TouchDevelop
  2. Do the following tutorials today:
    1. Coding Jetpack Jumper
    2. Jumping Bird
    3. Monster Slicer
    4. Falling Rocks

GOAL: Before you leave class today you will be learn beginning JavaScript for App code writing.

  1. Go to TouchDevelop
  2. Do the following tutorials today:
    1. Don’t Tap the Tile
    2. Quadratic Equation Solver
    3. Pixel Art
    4. Bear Quest

GOAL: Before you leave class today you will have the opportunity to create your own game! You have today to finish it.

  1. Go to TouchDevelop
  2. Click CREATE SCRIPT
  3. Choose BLANK GAME
  4. Create your game.

GOAL: Before you leave class today you will be learn beginning JavaScript for App code writing.

  1. Go to TouchDevelop
  2. Do the following tutorials today:
    1. Word Hunt
    2. Love Me Not
    3. Soundboard

CAN YOU MAKE THE GAME PORTABLE?

GOAL: Before you leave class today you will be learn beginning JavaScript for App code writing.

  1. Go to TouchDevelop
  2. Click on Create Your Own Apps Tutorials
  3. Click More Game Tutorials
    1. Bubble Popper
    2. Bouncing Bubbles
    3. Tap a Mole StepByStep
    4. Tin Can Tap

APP CODE WRITING EXAM:

Create a computer game that includes the following features/capabilities:

  1. has at least 3 levels
  2. keeps score
  3. must run on a PC using Windows 7 or newer
  4. must be a standalone executable program
  5. virus and malware free
  6. must have some type of celebratory conclusion if the game is conquered. Must have some type of encouragement for those who cannot conquer the game. Can replay.
  7. at least 2 lives or chances
  8. game features should be compatible with a maximum ESRB rating of E10+

Here is how you will be scored:

Create a mobile app that does the following:

  1. The following platforms may be used to develop the project: Google’s Android, Apple iOS, or Microsoft Windows Phone.
  2. Project submissions must include the source code and screen shots of the GUI in PDF format.
  3. The solution must run standalone with no programming errors.
  4. Applications may deploy from a smartphone, tablet, or both, but must be smartphone deployable.
  5. Applications do not need to be available for download from a digital-distribution multimedia-content service.
  6. The app should be shown to the judges

Here is the scenario:

  1. An apps is the be created that allows FBLA members to interact and share their opinions on style, fashion, and attire.
  2. Users can snap a picture with their phone. They can share what they want to know–things like (a) Is this outfit stylish? (b) Is this outfit professional (c) Is this outfit within the FBLA-PBL dress code? (d) What should I change to make this outfit better? and other important details.
  3. It should allow users to post outfits and interact with anyone else who has posted outfits.

LUKE: FINAL PROJECT

GOAL: Before you leave class today you will have the opportunity to create your own game! You have today and next class to finish it.

  1. Go to TouchDevelop
  2. Click CREATE SCRIPT
  3. Choose BLANK GAME
  4. Create your game.

 

GOAL: Before you leave class today you will have the opportunity to play some games created by other students in order to get a good idea on the type of game you would like to create.

  1. Go to TouchDevelop
  2. Go to the Showcase
  3. Play games! Get ideas for your own game! You will begin to create your own game next class!

LUKE–FINISH PROJECT–Show Mrs. Weber

GOAL: Before you leave class today you will have the opportunity to create your own game! You have today to finish it. Arcade Day next class!!

  1. Go to TouchDevelop
  2. Click CREATE SCRIPT
  3. Choose BLANK GAME
  4. Create your game.

EVERYONE: REMEMBER TO PUBLISH YOUR GAME TODAY!!!

LUKE: FILL OUT THE EVALUATION FORM PLEASE:

Create your own user feedback survey

ARCADE DAY:

  1. Play each other’s game & rate them using the grading rubric. Each of you should have SIX scores for each of the 5 parts of the grading rubric.
  2. In a Google Doc, tell me which game was the best, why it was the best, and what you plan to do for your next game.
  3. Begin creating your final game.

FINAL PROJECT

GOAL: Before you leave class today you will have the opportunity to create your own game! You have today and the next 3 classes to finish it.

  1. Go to TouchDevelop
  2. Click CREATE SCRIPT
  3. Choose BLANK GAME
  4. Create your game.

FINAL PROJECT

GOAL: Before you leave class today you will have the opportunity to create your own game! You have today and the next 2 classes to finish it.

  1. Go to TouchDevelop
  2. Click CREATE SCRIPT
  3. Choose BLANK GAME
  4. Create your game.

FINAL PROJECT

GOAL: Before you leave class today you will have the opportunity to create your own game! You have today and next class to finish it.

  1. Go to TouchDevelop
  2. Click CREATE SCRIPT
  3. Choose BLANK GAME
  4. Create your game.

FINAL PROJECT

GOAL: Before you leave class today you will have the opportunity to create your own game! You have today to finish it. Arcade Day next class!!

  1. Go to TouchDevelop
  2. Click CREATE SCRIPT
  3. Choose BLANK GAME
  4. Create your game.

CREATE INSTRUCTIONAL SCREENCASTS FOR ALICE–PUT THEM ON YOUR YOUTUBE CHANNEL–SHARE YOUR CHANNEL WITH ME–Be sure to include the following:

  1. State the GOAL of the screencast at the beginning–tell them WHAT they will learn AND WHY!!!
  2. Show them step by step what to do
  3. Summarize–re-state what they learned and WHY!!
  4. Keep the video to 3 minutes or less

Work on your game in Alice

Finish your Alice game

Present your Alice game

GOAL: Before you leave class today you will be learn beginning JavaScript for App code writing.

  1. Join my TouchDevelop group for app code writing by Microsoft–Sign in using your Google account
  2. Click Choose to Code Tutorials–Choose EXPERT LEVEL–this IS Javascript!!
  3. Do the following tutorials today:
    1. First Step with Turtle
    2. Turtle Shapes

GOAL: Before you leave class today you will be learn beginning JavaScript for App code writing.

  1. Go to TouchDevelop
  2. Do the following tutorials today:
    1. Coding Jetpack Jumper
    2. Jumping Bird
    3. Monster Slicer
    4. Falling Rocks

GOAL: Before you leave class today you will be learn beginning JavaScript for App code writing.

  1. Go to TouchDevelop
  2. Do the following tutorials today:
    1. Don’t Tap the Tile
    2. Quadratic Equation Solver
    3. Pixel Art
    4. Bear Quest

GOAL: Before you leave class today you will have the opportunity to create your own game! You have today to finish it.

  1. Go to TouchDevelop
  2. Click CREATE SCRIPT
  3. Choose BLANK GAME
  4. Create your game.

GOAL: Before you leave class today you will be learn beginning JavaScript for App code writing.

  1. Go to TouchDevelop
  2. Do the following tutorials today:
    1. Word Hunt
    2. Love Me Not
    3. Soundboard

CAN YOU MAKE THE GAME PORTABLE?

GOAL: Before you leave class today you will be learn beginning JavaScript for App code writing.

  1. Go to TouchDevelop
  2. Click on Create Your Own Apps Tutorials
  3. Click More Game Tutorials
    1. Bubble Popper
    2. Bouncing Bubbles
    3. Tap a Mole StepByStep
    4. Tin Can Tap

APP CODE WRITING EXAM:

Create a computer game that includes the following features/capabilities:

  1. has at least 3 levels
  2. keeps score
  3. must run on a PC using Windows 7 or newer
  4. must be a standalone executable program
  5. virus and malware free
  6. must have some type of celebratory conclusion if the game is conquered. Must have some type of encouragement for those who cannot conquer the game. Can replay.
  7. at least 2 lives or chances
  8. game features should be compatible with a maximum ESRB rating of E10+

Here is how you will be scored:

Create a mobile app that does the following:

  1. The following platforms may be used to develop the project: Google’s Android, Apple iOS, or Microsoft Windows Phone.
  2. Project submissions must include the source code and screen shots of the GUI in PDF format.
  3. The solution must run standalone with no programming errors.
  4. Applications may deploy from a smartphone, tablet, or both, but must be smartphone deployable.
  5. Applications do not need to be available for download from a digital-distribution multimedia-content service.
  6. The app should be shown to the judges

Here is the scenario:

  1. An apps is the be created that allows FBLA members to interact and share their opinions on style, fashion, and attire.
  2. Users can snap a picture with their phone. They can share what they want to know–things like (a) Is this outfit stylish? (b) Is this outfit professional (c) Is this outfit within the FBLA-PBL dress code? (d) What should I change to make this outfit better? and other important details.
  3. It should allow users to post outfits and interact with anyone else who has posted outfits.

LUKE: FINAL PROJECT

GOAL: Before you leave class today you will have the opportunity to create your own game! You have today and next class to finish it.

  1. Go to TouchDevelop
  2. Click CREATE SCRIPT
  3. Choose BLANK GAME
  4. Create your game.

 

GOAL: Before you leave class today you will have the opportunity to play some games created by other students in order to get a good idea on the type of game you would like to create.

  1. Go to TouchDevelop
  2. Go to the Showcase
  3. Play games! Get ideas for your own game! You will begin to create your own game next class!

LUKE–FINISH PROJECT–Show Mrs. Weber

GOAL: Before you leave class today you will have the opportunity to create your own game! You have today to finish it. Arcade Day next class!!

  1. Go to TouchDevelop
  2. Click CREATE SCRIPT
  3. Choose BLANK GAME
  4. Create your game.

EVERYONE: REMEMBER TO PUBLISH YOUR GAME TODAY!!!

LUKE: FILL OUT THE EVALUATION FORM PLEASE:

Create your own user feedback survey

ARCADE DAY:

  1. Play each other’s game & rate them using the grading rubric. Each of you should have SIX scores for each of the 5 parts of the grading rubric.
  2. In a Google Doc, tell me which game was the best, why it was the best, and what you plan to do for your next game.
  3. Begin creating your final game.

FINAL PROJECT

GOAL: Before you leave class today you will have the opportunity to create your own game! You have today and the next 3 classes to finish it.

  1. Go to TouchDevelop
  2. Click CREATE SCRIPT
  3. Choose BLANK GAME
  4. Create your game.

FINAL PROJECT

GOAL: Before you leave class today you will have the opportunity to create your own game! You have today and the next 2 classes to finish it.

  1. Go to TouchDevelop
  2. Click CREATE SCRIPT
  3. Choose BLANK GAME
  4. Create your game.

FINAL PROJECT

GOAL: Before you leave class today you will have the opportunity to create your own game! You have today and next class to finish it.

  1. Go to TouchDevelop
  2. Click CREATE SCRIPT
  3. Choose BLANK GAME
  4. Create your game.

FINAL PROJECT

GOAL: Before you leave class today you will have the opportunity to create your own game! You have today to finish it. Arcade Day next class!!

  1. Go to TouchDevelop
  2. Click CREATE SCRIPT
  3. Choose BLANK GAME
  4. Create your game.

GOAL:During class today you will have the opportunity to research a topic of your choice, take a stand, and back up your position through a blog post.

  1. READ THIS FIRST TODAY
  2. THIS MIGHT BE HELPFUL TAKE A LOOK–SCROLL DOWN TO THE CREATING CONTENT SECTION & TAKE A LOOK
  3. BLOG DAY–Blog about a topic of your choice–share it with me.
    1. Go to Google
    2. Click More
    3. Choose Blogger
    4. CREATE A NEW POST: Blog about a topic of your choice. Take a stand and then back up your claim with 3-4 reasons for your stance on your topic. EDUCATE YOUR AUDIENCE ON A TOPIC OF YOUR CHOICE!! Use the Internet. Provide web links, YouTube clips, and pictures to support your claim.
    5. SHARE the blog post with me and your classmates.
    6. Change the Layout of your blog:
      1. Click the Down arrow on the button (Go to post list) beside the pencil on the page that lists your blogs.
      2. Choose Layout
      3. EXPERIMENT!! Customize your blog!!
  4. Check JMC for make up work
  5. Timings

READ REFLECT & WRITE–Consider reading this:

  1. Go to Power My Learning
  2. Sign up
  3. Our class code is: 612423
  4. Work on the Internet/Coding Basics–What do you think?

 

 

Google Forms

Before you leave today you will know how to create a Form using Google Docs. You will know how to embed your form into your blog and how to add it as a hyperlink. You will invite your classmates to complete your form. Invite ME to complete your form (tracyweber@bellevue.k12.ia.us). You will also complete forms for your classmates and then review your classmates responses to your form.

  1. What Is A Google Form?–WATCH THIS
  2. How to Create A Google Form–WATCH THIS
  3. How to Create A Google Form–READ THIS
  4. Let’s create a Google Form to collect data about the followers of your blog.
    1. Online, go to your Google Drive
    2. In the upper left corner, click CREATE
    3. Choose Form
    4. At the top click THEME and choose a Theme
    5. Click APPLY
    6. Give the Form a title “About You: My Followers” (or something like that)
    7. Below the title provide instructions for filling out the form for your followers. For example: “Below are a series of questions designed to help me learn more about my blog followers so that I can tailor my blogs to better address the interests of my followers.”
    8. Point at Sample Question 1, notice the four-headed arrow, this means you can drag and drop all parts of your form to move things around.
    9. Point at Sample Question 1 again and click the PENCIL on the right side, this will allow you to edit the question.
    10. Question Title: This is the question. For example, question 1 might be: “What is your age?”
    11. Help Text: This provides added instruction, if needed. For example: “Please select the age range you currently fall under.”
    12. Question Type: When conducting a survey, it is better to require your audience to pick from a list of choices. This will allow you to better evaluate the data. For this first question, choose MULTIPLE CHOICE.
    13. Option 1: 0-10 years
    14. Option 2: 11-20 y2ears
    15. Option 3: 21-30 years
    16. Option 4: 31years and over
    17. Make this question required meaning they will NOT be able to submit the form without answering this question.
    18. Click DONE–you are done with your first question.
    19. Now, make up a question for sample question 2–this time make this question a CHECKBOX type question–this is where the person responding to your survey can have more than 1 answer. For example: “What are some of your interests?” and the Help Text: “Check all that apply to you.” Here are some options you may give them to check: reading, fitness, academics, arts, music.
    20. Do NOT make this question required.
    21. CLICK DONE
    22. Now, add a question: Click ADD ITEM in the upper left corner.
    23. Under questions, click CHOOSE FROM A LIST
    24. Edit the question to be the following:
      1. Which town do you live in?
      2. Please select the town in which you currently reside.
      3. Here are the options:
        1. Springbrook
        2. LaMotte
        3. Bellevue
        4. St. Donatus
        5. Bernard
        6. Dubuque
        7. Otter Creek
        8. Other
      4. Make this question REQUIRED
      5. Click DONE
    25. Add another question. Make this question be a SCALE question. Here is waht to include for this question:
      1. In comparision to other schools in Jackson county, how do you think Bellevue rates?
      2. Help Text: This is based on what you hear other people say about other schools and our school.
      3. Label 1: The worst school in Jackson county
      4. Label 2: The best school in Jackson county
    26. Add another question. Make this question be a GRID question. Here is what to include for this question:s
      1. On a scale of 1 to 5, what are your feelings on the items listed below.
      2. Help Text: 1 being “I am totally not interested” and 5 being “I would definitely join!”
      3. Make this 5 columns–Provide descriptions for each column
      4. Leave the column labels as indicated
      5. Row 1 label: Future Business Leaders of America
      6. Row 2 label: Bowling
      7. Row 3 label: Science Club
      8. Row 4 label: Computer Club
      9. Row 5 label: Drama Club
      10. click DONE
    27. Add another question. Make this question a TEXT question. You want to limit these because anyone can put anything which makes it hard for you to analyze your collected data. Use text when what the person is suppling is unique to them–it cannot be picked from a list.
      1. Question Title: What is your first name?
      2. Help Text: Please provide only your first name for security purposes.
      3. click DONE
    28. Add another question.Make this question a PARAGRAPH TEXT question. You want to limit these because anyone can put anything which makes it hard for you to analyze your collected data. Use when you are letting your audience supply their thoughts/suggestions.
      1. Question Text: Other
      2. Help Text: Please provide any other information that you think is important.
      3. click DONE
    29. Add a SECTION HEADER named “School Evaluation” and move it so that it is immediately before the GRID question about the different clubs.
    30. Add a PAGE BREAK and title the page “Submit”
  5. That is how you create a FORM using Google Docs. Now you will learn how to send the form to people.
    1. Click SAVE in the upper right corner
    2. Click EMAIL THIS FORM
    3. Type in all the email addresses on the white board
  6. View your form to see what it looks like to people who will receive it:
    1. At the bottom of your screen click the long link. This opens a new window so you can see what it looks like.
    2. Fill out the form.
  7. Go check your email. Fill out the forms that your classmates sent you.
  8. work on your blog or work on FBLA stuff

Google Forms

GOAL: Before you leave today you will know how to view and analyze your form responses and you will have the opportunity to create a form of your own. You will also know how to embed your form in your blog!

  1. Finish the form from last class and share it with me and all your other classmates.
  2. Go check your email. Fill out the forms that your classmates sent you.
  3. WATCH THIS VIDEO CLIP TO SEE HOW TO VIEW AND ANALYZE YOUR FORM RESPONSES
  4. Go to the form you created for this class and review the results of your survey!
  5. In your Google Doc for this class write about what you learned about your classmates from analyzing the forms they filled out.
  6. IF YOU DIDN’T FIGURE OUT YOUR BLOG TOPIC LAST CLASS DO THIS:
    1. Create YOUR OWN blog: FIND A BLOG TOPIC for your BLOG
      1. watch this to help you create your own blog. Here are some questions you must be able to answer about your blog topic:
        1. What interests you?
        2. What do you want to learn more about?
        3. What do you want others to learn about because you think it is cool?
        4. How can you use it to benefit you in the future?
      2. In the upper right corner of your screen, click CREATE BLOG
      3. Use your SCHOOL Google account for the email address
      4. Name YOUR BLOG–My Blog name is Web Apps & Coding–This should be a GENERIC name that is the overall description of all your posts, so if you are interested in sports and ALL your blog POSTS will be sports related then maybe name your blog YOUR NAME’S SPORTS BLOG
      5. Create your first Blog POST! It can be anything that is school appropriate as long as it fits under the name/subject of your BLOG
      6. FOR A GRADE: Include 1 picture and 1 link in your first post.
    2. Share your BLOG with me: tracyweber@bellevue.k12.ia.us
  7. Watch this video about how to embed your Google Form into your Blog
  8. Blog About You & Create your own blog
    1. Work on your YOUR OWN blog:
      1. Log in to your Google Account online
      2. Click on the APPS button
      3. Choose More (you may have to choose Even More)
      4. Click Blogger
      5. Create a new POST to EMBED YOUR FORM
      6. Create another NEW POST to share with me on a topic that interests you–current event, hobby, etc. You may add anything to your blog–pictures, etc. to decorate it. Share your Post with me. This is your writing for today.
  9. Check your email and finish filling out your classmates forms.

Before you leave class today you will create your own unique form using Google Docs. Your form must meet the following criteria:

  1. WATCH THIS BEFORE CREATING YOUR OWN FORM
  2. Include all 7 different question types
  3. Include a title
  4. Include additional instructions to help the people completing your form understand why they are completing your form
  5. Include at least 2 section headings
  6. Include at least 1 page break
  7. Embed or include the link for your form in your Blog
  8. Invite at least 10 people to complete your suvey–including Mrs. Weber!

Here are some suggestions for topics for your form:

  1. Survey to collect primary data when conducting research
    1. Automobile accidents–are teens more likely to have an accident than an adult?
    2. Healthy eating habits–are boys or girls more likely to make healthy decisions?
    3. Technology uses–what types of technology are employed by people of various ages on a daily basis?
  2. Collect personal information
    1. Find more information about your friends and family
    2. Find information about people in your class
    3. Find information about your teachers
  3. Gather feedback from a customer

IMPORTANT: EVERYDAY SHARE A GOOGLE DOC WITH ME AT THE END OF CLASS TELLING ME HOW FAR YOU GOT AND WHAT YOU LEARNED!! THIS WILL BE GRADED!! YOU ARE EXPECTED TO REMEMBER TO DO THIS EVERYDAY–WHETHER YOU ARE REMINDED OR NOT!!!

  1. Create a new Google Doc, explain why learning to use Google Forms is important. Explain how you can use this now and in your future. Be specific and use good writing skills. Share this with Mrs. Weber (tracyweber@bellevue.k12.ia.us)
  2. If you didn’t do it last class, finish your form and send your form to your classmates–send it to 5-10 of your classmates including me.
  3. Check your email and fill out forms

In Google Docs, open your form from last class. Analyze your results. Did people respond the way you anticipated? Could you have reworded the questions to get better responses? Did enough people respond to make it a fair survey? Respond to these questions in a note to me in Edmodo.

  1. EVERYONE: Proofread & finish your survey & send it. Make sure there are no typos!!
  2. View your results graphically
    1. Click the FORM menu and choose SHOW SUMMARY OF RESPONSES.
    2. Do you see how using questions that require a numeric response is easier to analyze?
  3. Set notifications
    1. TOOLS menu, choose NOTIFICATION RULES
    2. Place check marks in the following locations:
      1. Any changes are made (this is to the form itself and the back side of the form)
      2. Anything on this sheet is changed (this is to this spreadsheet–the back side of your form)
      3. Collaborators are added or removed (this is if you or someone else includes another person to edit the FORM itself)
      4. A user submits a form (if anyone fills out a form, you will receive email notification which will remind you to check the form!)
      5. Email – daily digest (this will show you results daily of your form)
      6. Email – right away (it will not wait to email…..)
      7. Click SAVE
      8. Click DONE
  4. Sort to better analyze your results
    1. Point at a column letter and notice the down pointing arrow–click it
    2. You can choose to sort here–to see the most recent results choose to sort on the Timestamp from Z-A
    3. Try sorting on other columns. Notice how the rows of information stay together.
  5. Perform calculations using the results–calculate the average for one of your questions that resulted in a numeric answer.
    1. Calculate the AVERAGE of a column by placing your active cell below a column containing numbers.
    2. Click the FUNCTIONS button in your toolbar (it looks like an E)
    3. Click AVERAGE
    4. Click and drag over the cells you want to calculate the average of
    5. Hit ENTER

IMPORTANT: EVERYDAY SHARE A GOOGLE DOC WITH ME AT THE END OF CLASS TELLING ME HOW FAR YOU GOT AND WHAT YOU LEARNED!! THIS WILL BE GRADED!! YOU ARE EXPECTED TO REMEMBER TO DO THIS EVERYDAY–WHETHER YOU ARE REMINDED OR NOT!!!

GOAL: Before you leave today you will have the opportunity to customize your blog and create another blog post.

  1. BLOG DAY
    1. Go to Google
    2. Click More (if necessary)
    3. Choose Blogger
    4. Create a new POST. (click the ORANGE PENCIL BUTTON)
    5. Blog about a topic of your choice–share it with me. Use good writing skills. TEACH US SOMETHING ABOUT WHAT YOU KNOW THAT WE MAY NOT KNOW!!
    6. After you Publish your new Post, click BLOGGER in the upper left corner of your screen.
    7. Next to the ORANGE PENCIL button is a button with a down arrow. Click the Down Arrow
    8. Scroll down and choose SETTINGS
    9. Click MOBILE AND EMAIL
    10. Next to EMAIL POST TO click ADD. Include my email address (tracyweber@bellevue.k12.ia.us) and your classmates email addresses. Try clicking CHOOSE FROM CONTACTS……
    11. Click SAVE SETTINGS at the top of your screen.
    12. Change the Layout of your blog by clicking LAYOUT on the left side of your screen
      1. EXPERIMENT!! Customize your blog!!
      2. Change the FAVICON to a different picture
      3. Edit the Navbar
      4. Edit the title
      5. Add a Gadget
      6. Edit Attribution (at the bottom)
    13. Send your Post from today to me by clicking POSTS on the left side of your screen
    14. Point at today’s post and click SHARE below it (tracyweber@bellevue.k12.ia.us)

GOAL: Before you leave today you will demonstrate your knowledge of Google Forms. THIS IS FOR A TEST GRADE. DUE TODAY!!

Create another form for a different purpose. Choose a topic that is more significant locally–either here at the school, in the school district, in the City of Bellevue, or in Jackson county.

  1. Include all 7 different question types
  2. Include a title
  3. Include additional instructions to help the people completing your form understand why they are completing your form
  4. Include at least 2 section headings
  5. Include at least 1 page break
  6. Embed or include the link for your form in your Blog
  7. Invite at least 10 people to complete your suvey–including Mrs. Weber!
  8. Be sure your questions are understandable to ALL of your audience (for example, 13-18 year olds and 40-50 year olds)
  9. Be sure you distribute your survey to all different kinds of people–not just high school students!!
  10. Analyze the results & in a Google Doc share with me your stance on your survey and support it with statistics and averages based on the responses you get from your form.

Here are some suggestions for topics for your form:

  1. Building a New Elementary Near the Middle/High School & Converting the Old Elementary into a Community Recreation Center (like a YMCA)
  2. Open Campus
  3. Open Lunch
  4. Railroad Crossings
  5. New City Pool
  6. Alternative Forms of Energy for Bellevue
  7. Bringing New Residents to Bellevue
  8. Alcohol Consumption in Jackson County
  9. Preventing Poaching in Jackson County

 

 

 

 

 

 

GOAL: Before you leave class today you will have the opportunity to collaborate as a team to think of a form to collect USABLE data about a worthwhile topic.

  1. Here is your writing for today. Please be thoughtful about this!! You will have to scroll………

  1. Get into groups of 3
  2. Have 1 group member create a Google Doc and share it to everyone else in the group (including me)–Name it BRAINSTORMING FOR A FORM IDEA
  3. For 5 minutes create a list of topics that could be used to gather usable information in a Google Form. You may use the Internet.
  4. Pick 1 idea–BOLD IT
  5. Create a goal for your form……..Answer this question: “The main purpose of collecting responses for this form is to determine…………”
  6. Below your list brainstorm all possible questions that could be asked on the form. (15-20)
  7. Decide what type of question in a Google Form each of the questions you thought of should be.
  8. Below your list of questions create an outline–which will be a rough draft of your form. Here are some things to think about:
    1. Use multiple section headings
    2. Use multiple page breaks
  9. Begin to create the form on 1 person’s computer. Share it with the other group members.

 

GOAL: Before you leave today your group will finish creating your form and you will distribute it.

As a group do the following:

  1. Create/Complete the form–Pick ONE person in your group to create the form and have that person SHARE the editing capabilities with everyone else in the group. Word on ONE computer.
  2. Decide how many people should complete the survey in order to make the results be accurate.
  3. Decide who you will send it to.
  4. Send it.

Writing for today: Send me a note in Edmodo predicting the results of your form.

Analyze the results of your survey–As a group look at the results. Did you get the results you were expecting? Explain. What would you have done differently if you were to do it again? Explain.

Check JMC: Make up work

COMPLETE THE FOLLOWING FROM LAST CLASS:

Analyze the results of your survey–As a group look at the results. Did you get the results you were expecting? Explain. What would you have done differently if you were to do it again? Explain.

Check JMC: Make up work

Do timings

GOAL: Before you leave today you will demonstrate your knowledge of Google Forms. THIS IS FOR A TEST GRADE. DUE TODAY!!

Create another form for a different purpose. Choose a topic that is more significant locally–either here at the school, in the school district, in the City of Bellevue, or in Jackson county.

    1. Include all 7 different question types
    2. Include a title
    3. Include additional instructions to help the people completing your form understand why they are completing your form
    4. Include at least 2 section headings
    5. Include at least 1 page break
    6. Embed or include the link for your form in your Blog
    7. Invite at least 10 people to complete your suvey–including Mrs. Weber!
    8. Be sure your questions are understandable to ALL of your audience (for example, 13-18 year olds and 40-50 year olds)
    9. Be sure you distribute your survey to all different kinds of people–not just high school students!!
    10. Analyze the results & in a Google Doc share with me your stance on your survey and support it with statistics and averages based on the responses you get from your form.
  1. TuzzitCanva & Checkthis & Picktochart–Infographics

Before you leave today you will know how to use Google Drawing and how to link or embed a drawing to your blog. Do the following in order:

  1. Watch this video clip
  2. Go to your Google Drive online
  3. Create a Drawing. Play around with it. Experiment with everything to see what you can do. Become familiar with Google Drawing.
  4. Create a banner for your blog. Share this drawing with me.
  5. See if you can embed or link it to your blog. Send a message to me when you have.

GOOGLE DRAW–EDIT PICTURE & SAVE AS JPG

OPTIONAL: Google Drawing–Create a link in your blog for a logo. Create a logo for a business you would like to own in the future. Be sure to include the name of your business and a slogan. For instance, Subway’s name is in its logo and its slogan is “Eat Fresh”.

OPTIONAL (if you did the form last class): Analyze your survey results

Goal: Before you leave class today you will know how to use Google Presentation.

  1. HOW TO CREATE A PRESENTATION
  2. WATCH THIS INTRO VIDEO
  3. ADVANCED GOOGLE PRESENTATION FEATURES
  4. Google Presentation–Experiment!
  5. Look at all menus and try everything in every menu, especially the following:
    1. Type speaker notes below each slide–this is what you would SAY when you are presenting.
    2. File–Print–What are your options?
    3. View–Present, Animations, Show Speaker Notes
    4. Insert–Textbox, Image, Link, Video, Wordart, Line, Shape, Table, Animate
    5. Slide–Background, Change Layout, Change Theme, Change Transition
    6. Format–TRY EVERYTHING
    7. Table–TRY EVERYTHING
    8. Click PRESENT to view the presentation
  6. Create a presentation about you using everything above.

GOAL: Before you leave class today you will apply what you have learned about Google Presentation by creating a presentation on a topic of your choice that will educate your audience.

  1. WATCH THIS–Remember the following:
    1. In life, when you get a job, most likely you will not get to pick your coworkers. Be flexible & FIND A WAY!!
    2. Negotiate. This is another employability skill. Find common ground!! Compromise!!
    3. Work together equally–the person who does ALL the work will receive a low grade as well as the person who does NONE of the work. Neither will go over very well in the real world. TEAMWORK is key!! Include everyone. Work together!!
  2. Get with a partner.
  3. Google Presentation
    1. Create a presentation on a topic of your choice. The topic must meet the following guidelines:
      1. It must require Internet research.
      2. It is a QUESTION, but it may or may not have a right or wrong answer.
      3. It affects you locally.
      4. It educates your audience. Tell us something we don’t already know. Catch our attention in the beginning, hold our attention throughout the presentation, and tell us what to do in the end.
  1. You will show the class your presentation online by SHARING it.
  2. Your presentation must include the following:
    1. Print speaker notes–give them to me
      1. Bring up your presentation in Google
      2. File menu
        1. Download As
          1. PowerPoint
      3. Get into PowerPoint
      4. Open the presentation you just downloaded
      5. File
        1. Print
          1. Notes Pages
    2. Include a YouTube video
    3. Include a Table
    4. Include an inserted image
    5. Include a drawing
      1. Bring up the Google Drawing
      2. File
        1. Download As
          1. JPEG
      3. Bring up your Google Presentation
      4. Insert
        1. Image
          1. Upload
    6. Include a theme
    7. Include transitions–to draw attention, not distract your audience
    8. Include animations–to draw attention, not distract your audience
    9. Share with all your classmates

GOAL: Before you leave class today you will apply what you have learned about Google Presentation by creating a presentation on a topic of your choice that will educate your audience.

  1. Remember the following:
    1. In life, when you get a job, most likely you will not get to pick your coworkers. Be flexible & FIND A WAY!!
    2. Negotiate. This is another employability skill. Find common ground!! Compromise!!
    3. Work together equally–the person who does ALL the work will receive a low grade as well as the person who does NONE of the work. Neither will go over very well in the real world. TEAMWORK is key!! Include everyone. Work together!!
  2. Remember:
    1. Conduct primary & secondary research.
    2. Address the QUESTION, but it may or may not have a right or wrong answer.
    3. How does it affect you & your audience?
    4. It educates your audience. Tell us something we don’t already know. Catch our attention in the beginning, hold our attention throughout the presentation, and tell us what to do in the end.

TODAY:

  1. Open the Google Doc for this project–work with the outline for your designated parts.
  2. Conduct interviews (you can use my cameras or you can face-time & record it), get quotes from people through emails & surveys (use a Google form)
  3. You will begin working on the PRESENTATION next class.

IN THE END:

  1. Here is how you will be graded
  2. You will show the class your presentation online by SHARING it.
  3. Your presentation must include the following:
    1. Print speaker notes–give them to me
      1. Bring up your presentation in Google
      2. File menu
        1. Download As
          1. PowerPoint
      3. Get into PowerPoint
      4. Open the presentation you just downloaded
      5. File
        1. Print
          1. Notes Pages
    2. Include a YouTube video
    3. Include a Table
    4. Include an inserted image
    5. Include a drawing
      1. Bring up the Google Drawing
      2. File
        1. Download As
          1. JPEG
      3. Bring up your Google Presentation
      4. Insert
        1. Image
          1. Upload
    6. Include a theme
    7. Include transitions–to draw attention, not distract your audience
    8. Include animations–to draw attention, not distract your audience
    9. Share with all your classmates

GOAL: Before you leave class today you will apply what you have learned about Google Presentation by creating a presentation on a topic of your choice that will educate your audience.

  1. Remember the following:
    1. In life, when you get a job, most likely you will not get to pick your coworkers. Be flexible & FIND A WAY!!
    2. Negotiate. This is another employability skill. Find common ground!! Compromise!!
    3. Work together equally–the person who does ALL the work will receive a low grade as well as the person who does NONE of the work. Neither will go over very well in the real world. TEAMWORK is key!! Include everyone. Work together!!
  2. Remember:
    1. Conduct primary & secondary research.
    2. Address the QUESTION, but it may or may not have a right or wrong answer.
    3. How does it affect you & your audience?
    4. It educates your audience. Tell us something we don’t already know. Catch our attention in the beginning, hold our attention throughout the presentation, and tell us what to do in the end.

TODAY:

  1. Create a Google PRESENTATION share it with your partner & your teacher
  2. Open the Google Doc for this project–use to to create your slides & speaker notes for this PRESENTATION.
    1. Write what you will SAY to your audience when you are presenting in the SPEAKER NOTES
    2. Abbreviate what you will say into words & phrases (no complete sentences) on the actual SLIDE
  3. You will finish the PRESENTATION next class.

IN THE END:

  1. Here is how you will be graded
  2. You will show the class your presentation online by SHARING it.
  3. Your presentation must include the following:
    1. Print speaker notes–give them to me
      1. Bring up your presentation in Google
      2. File menu
        1. Download As
          1. PowerPoint
      3. Get into PowerPoint
      4. Open the presentation you just downloaded
      5. File
        1. Print
          1. Notes Pages
    2. Include a YouTube video
    3. Include a Table
    4. Include an inserted image
    5. Include a drawing
      1. Bring up the Google Drawing
      2. File
        1. Download As
          1. JPEG
      3. Bring up your Google Presentation
      4. Insert
        1. Image
          1. Upload
    6. Include a theme
    7. Include transitions–to draw attention, not distract your audience
    8. Include animations–to draw attention, not distract your audience
    9. Share with all your classmates

GOAL: Before you leave class today you will apply what you have learned about Google Presentation by creating a presentation on a topic of your choice that will educate your audience.

  1. Remember the following:
    1. In life, when you get a job, most likely you will not get to pick your coworkers. Be flexible & FIND A WAY!!
    2. Negotiate. This is another employability skill. Find common ground!! Compromise!!
    3. Work together equally–the person who does ALL the work will receive a low grade as well as the person who does NONE of the work. Neither will go over very well in the real world. TEAMWORK is key!! Include everyone. Work together!!
  2. Remember:
    1. Conduct primary & secondary research.
    2. Address the QUESTION, but it may or may not have a right or wrong answer.
    3. How does it affect you & your audience?
    4. It educates your audience. Tell us something we don’t already know. Catch our attention in the beginning, hold our attention throughout the presentation, and tell us what to do in the end.

TODAY:

  1. Finish your  PRESENTATION.
    1. Write what you will SAY to your audience when you are presenting in the SPEAKER NOTES
    2. Abbreviate what you will say into words & phrases (no complete sentences) on the actual SLIDE
  2. You will present next class online.

IN THE END:

  1. Here is how you will be graded
  2. You will show the class your presentation online by SHARING it.
  3. Your presentation must include the following:
    1. Print speaker notes–give them to me
      1. Bring up your presentation in Google
      2. File menu
        1. Download As
          1. PowerPoint
      3. Get into PowerPoint
      4. Open the presentation you just downloaded
      5. File
        1. Print
          1. Notes Pages
    2. Include a YouTube video
    3. Include a Table
    4. Include an inserted image
    5. Include a drawing
      1. Bring up the Google Drawing
      2. File
        1. Download As
          1. JPEG
      3. Bring up your Google Presentation
      4. Insert
        1. Image
          1. Upload
    6. Include a theme
    7. Include transitions–to draw attention, not distract your audience
    8. Include animations–to draw attention, not distract your audience
    9. Share with all your classmates

GOAL: Before you leave class today you will apply what you have learned about Google Presentation by creating a presentation on a topic of your choice that will educate your audience.

TODAY:

  1. Present
  2. Here is how you will be graded
  3. Share your Presentation with your classmates
  4. Print speaker notes–give them to me
    1. Bring up your presentation in Google
    2. File menu
      1. Download As
        1. PowerPoint
    3. Get into PowerPoint
    4. Open the presentation you just downloaded
    5. File
      1. Print
        1. Notes Pages
  5. View the presentations sent by your classmates. Provide positive feedback for them on the Wall below. You may want to respond to the following questions:
      1. What did you like about how they set it up?
      2. What did you learn about their topic?
      3. What suggestions do you have for them?

  6. Make Up Work–Check JMC. Turn in all ZEROS.

GOAL: Before you leave class today you will apply what you have learned about Google Presentation by creating a presentation on a topic of your choice that will educate your audience.

TODAY:

  1. Present
  2. Here is how you will be graded
  3. Share your Presentation with your classmates
  4. Print speaker notes–give them to me
    1. Bring up your presentation in Google
    2. File menu
      1. Download As
        1. PowerPoint
    3. Get into PowerPoint
    4. Open the presentation you just downloaded
    5. File
      1. Print
        1. Notes Pages
  5. View the presentations sent by your classmates. Provide positive feedback for them on the Wall below. You may want to respond to the following questions:
      1. What did you like about how they set it up?
      2. What did you learn about their topic?
      3. What suggestions do you have for them?

  6. Make Up Work–Check JMC. Turn in all ZEROS.

GOAL: Before you leave today you will know how to use Google Spreadsheet.

  1. Google Spreadsheets–WATCH THIS
    1. From your online Google Drive, click CREATE and choose SPREADSHEET
    2. Google Spreadsheets–Create the following spreadsheet:
      1. Grades Spreadsheet–Get this file on 1/2 of your screen and a Google spreadsheet file on the other 1/2 of your screen.
    3. Use the MERGE button to merge the title across A1 to E1
    4. Use the CENTER button to center the title
    5. Use the BOLD button to bold the title
    6. Use the CENTER button to center the column headings
    7. Use the UNDERLINE command from the FORMAT menu to UNDERLINE the column headings
    8. Center the contains of A3 to A10
    9. Use the PERCENT button to put in the percent sign (you will probably have to re-type the numbers!)
    10. Use the SUM function to find the TOTAL number of students in all classes (put this in cell C11)
    11. Use the MAX function to find the LARGEST class (put this in cell C12)
    12. Use the MIN function to find the SMALLEST class (put this in cell C13)
    13. Use the AVERAGE function to find your grade average (put this in cell D11)
    14. Enter a FORMULA in cell E3 to calculate what percentage your grade will be if you increase it by 10%–THINK!! YOU can do this!!
    15. Use formatting features to highlight data, draw attention to important information, and to make your spreadsheet more visually attractive:
      1. Borders
      2. Bold, italic, underline
      3. Font, font color, font size
      4. Fill color
    16. Copy the spreadshet & paste it into another sheet in the same workbook–you will have 2 sheet tabs at the bottom of your screen. Change it to match your courses for this year (estimate number of students and grades).
    17. Name sheet1 and sheet2 appropriate names.
    18. Name all sheets
    19. Create a bar chart using at least 3 sets of data in one of the spreadsheets
      1. Title and name the chart
      2. Include vertical and horizontal axis labels
      3. Change the color of all the bars
    20. Create a pie chart
      1. Title and name it
    21. Share this spreadsheet with me–tracyweber@bellevue.k12.ia.us

FINISH THE SPREADSHEET FROM LAST CLASS

Create another new spreadsheet. Be sure to do the following:

  1. Merge & center & bold the title above all columns for information in the spreadsheet
  2. Underline all column headings
  3. Include the SUM, MAX, MIN, AVERAGE functions
  4. Include 1 formula
  5. Include 1 chart

Here are some suggestions for a spreadsheet

  1. Do an expense sheet where the columns are months and the rows are types of expenses like gas, food, spending money, etc.
  2. Do an income sheet where the columns are months and the row are types of income like Benders, babysitting, lawn work, etc.
  3. Do a golf score sheet where the columns are round 1, round, 2, etc and the rows are the name of the golfer (make them up)
  4. Do a basketball stats sheet where the columns are basketball stats like rebounds, fouls, shots made, shots attempted, etc. and the rows are the names of the basketball players.

FINISH THE SPREADSHEET FROM 2 CLASSES AGO–Jacob & Allison–Show me

Create another new spreadsheet. Be sure to do the following:

  1. Merge & center & bold the title above all columns for information in the spreadsheet
  2. Underline all column headings
  3. Include the SUM, MAX, MIN, AVERAGE functions
  4. Include 1 formula
  5. Include 1 chart

Here are some suggestions for a spreadsheet

  1. Do an expense sheet where the columns are months and the rows are types of expenses like gas, food, spending money, etc.
  2. Do an income sheet where the columns are months and the row are types of income like Benders, babysitting, lawn work, etc.
  3. Do a golf score sheet where the columns are round 1, round, 2, etc and the rows are the name of the golfer (make them up)
  4. Do a basketball stats sheet where the columns are basketball stats like rebounds, fouls, shots made, shots attempted, etc. and the rows are the names of the basketball players.

FINISH THE OTHER new spreadsheet. Be sure to do the following:

  1. Merge & center & bold the title above all columns for information in the spreadsheet
  2. Underline all column headings
  3. Include the SUM, MAX, MIN, AVERAGE functions
  4. Include 1 formula
  5. Include 1 chart

Here are some suggestions for a spreadsheet

  1. Do an expense sheet where the columns are months and the rows are types of expenses like gas, food, spending money, etc.
  2. Do an income sheet where the columns are months and the row are types of income like Benders, babysitting, lawn work, etc.
  3. Do a golf score sheet where the columns are round 1, round, 2, etc and the rows are the name of the golfer (make them up)
  4. Do a basketball stats sheet where the columns are basketball stats like rebounds, fouls, shots made, shots attempted, etc. and the rows are the names of the basketball players.

YOU HAVE TODAY AND THE NEXT TWO CLASSES TO COMPLETE THIS PROJECT

HERE IS HOW YOU WILL BE GRADED

GOOGLE PROJECT: Find an app, use the suite to instruct others about why it is useful and how to use it. Here is what you need to do:

  1. Go to the Google Chrome Store and search for apps that you think would be useful. Try out a bunch of different apps! Explore! Have fun!!
  2. Pick 1 Google App that you think is useful.
  3. Use the following in some way to help educate people about this app–why it is useful and how to use it:
    1. Google Form
    2. Google Draw
    3. Google Presentation
    4. Google Spreadsheet
  4. Options:
    1. This can be designed as an online workshop
    2. This can be designed as a face-to-face workshop where you are the instructor

OR:

THIS IS YOUR FINAL CULMINATING PROJECT FOR THE GOOGLE UNIT–YOU NEED TO DEMONSTRATE WHAT YOU HAVE LEARNED FROM THE GOOGLE UNIT BY INSTRUCTING OTHERS ABOUT THE GOOGLE SUITE.

GOAL: Before you leave today you will have the opportunity to plan a workshop to be offered to one of the following groups of people (PICK ONE): our community members/students at BHS/students at BMS/Teachers in the school district/teachers at the elementary/teachers in the middle/high school about Google Doc.. You will have today and the NEXT 2 CLASSES TO PLAN THIS WORKSHOP.

  1. PROBLEM: It is your job to conduct a workshop to teach others about how to use the Google suite (Documents, Forms, Spreadsheets, Presentation, Drawing). You will plan this workshop over the next 3 classes and then conduct the workshop.  Before you leave today, you need to formulate a plan and organize the next 3 classes–create your lesson plan and share it with me. Here are some things to consider:
    1. Who will you conduct this workshop for? Who needs to learn how to use the Google suite?
    2. When will this workshop be conducted  and where?
    3. What specific skills should be taught during the workshop?
    4. Who, in your group, is responsible for what?
    5. What will be the main goal of the workshop?
    6. How will you promote it?
    7. Who will promote it?
  2. At the end of class share a Google Doc with me detailing your plans for the next 3 classes. BE SPECIFIC!!!

OR:

GOAL: Before you leave class today you will have picked your group of 2 or 3 and you will have DECIDED on a topic, and you will have a plan in place for how this project will proceed.

  1. GROUP PROJECT: Pick a research topic. The topic must meet the following requirements:
    1. Fairly local concern
    2. Heavy use of data in the form of numbers
    3. Use Google Forms to gather primary data on your research topic
    4. Use the Internet to gather information
    5. Create a Google Spreadsheet to illustrate your findings
    6. You will present this information to the class using Google Presentation–import your Google Spreadsheet into your Google Presentation
    7. Use Google Drawing to create a logo on your topic–include it in your presentation
  2. Develop a plan. Use a new Document in Google. Share it with everyone in your group & me (tweber@bellevue.k12.ia.us). Things to think about:
    1. Create an outline of your project
    2. Assign everyone in your group at least 2 parts to the outline–these should include Internet research
    3. Who is in charge of creating the Form?
    4. Who is in charge of creating the Spreadsheet?
    5. Who is in charge of creating the Presentation?
    6. Who is in charge of creating the Drawing?
  3. Send a note to me in Edmodo addressing the following:
    1. Who is in your group?
    2. What is your topic?
    3. Why did you choose this topic?
    4. Who is your audience?
    5. What is your plan?
    6. How did it go today?
    7. What needs to happen in order for your group to work well together to create a worthwhile and educational project?

YOU HAVE TODAY AND THE NEXT CLASS TO COMPLETE THIS PROJECT

HERE IS HOW YOU WILL BE GRADED

GOOGLE PROJECT: Find an app, use the suite to instruct others about why it is useful and how to use it. Here is what you need to do:

  1. Go to the Google Chrome Store and search for apps that you think would be useful. Try out a bunch of different apps! Explore! Have fun!!
  2. Pick 1 Google App that you think is useful.
  3. Use the following in some way to help educate people about this app–why it is useful and how to use it:
    1. Google Form
    2. Google Draw
    3. Google Presentation
    4. Google Spreadsheet
  4. Options:
    1. This can be designed as an online workshop
    2. This can be designed as a face-to-face workshop where you are the instructor

OR:

THIS IS YOUR FINAL CULMINATING PROJECT FOR THE GOOGLE UNIT–YOU NEED TO DEMONSTRATE WHAT YOU HAVE LEARNED FROM THE GOOGLE UNIT BY INSTRUCTING OTHERS ABOUT THE GOOGLE SUITE.

GOAL: Before you leave today you will have the opportunity to plan a workshop to be offered to one of the following groups of people (PICK ONE): our community members/students at BHS/students at BMS/Teachers in the school district/teachers at the elementary/teachers in the middle/high school about Google Doc.. You will have today and the NEXT 2 CLASSES TO PLAN THIS WORKSHOP.

  1. PROBLEM: It is your job to conduct a workshop to teach others about how to use the Google suite (Documents, Forms, Spreadsheets, Presentation, Drawing). You will plan this workshop over the next 3 classes and then conduct the workshop.  Before you leave today, you need to formulate a plan and organize the next 3 classes–create your lesson plan and share it with me. Here are some things to consider:
    1. Who will you conduct this workshop for? Who needs to learn how to use the Google suite?
    2. When will this workshop be conducted  and where?
    3. What specific skills should be taught during the workshop?
    4. Who, in your group, is responsible for what?
    5. What will be the main goal of the workshop?
    6. How will you promote it?
    7. Who will promote it?
  2. At the end of class share a Google Doc with me detailing your plans for the next 3 classes. BE SPECIFIC!!!

OR:

GOAL: Before you leave class today you will have picked your group of 2 or 3 and you will have DECIDED on a topic, and you will have a plan in place for how this project will proceed.

  1. GROUP PROJECT: Pick a research topic. The topic must meet the following requirements:
    1. Fairly local concern
    2. Heavy use of data in the form of numbers
    3. Use Google Forms to gather primary data on your research topic
    4. Use the Internet to gather information
    5. Create a Google Spreadsheet to illustrate your findings
    6. You will present this information to the class using Google Presentation–import your Google Spreadsheet into your Google Presentation
    7. Use Google Drawing to create a logo on your topic–include it in your presentation
  2. Develop a plan. Use a new Document in Google. Share it with everyone in your group & me (tweber@bellevue.k12.ia.us). Things to think about:
    1. Create an outline of your project
    2. Assign everyone in your group at least 2 parts to the outline–these should include Internet research
    3. Who is in charge of creating the Form?
    4. Who is in charge of creating the Spreadsheet?
    5. Who is in charge of creating the Presentation?
    6. Who is in charge of creating the Drawing?
  3. Send a note to me in Edmodo addressing the following:
    1. Who is in your group?
    2. What is your topic?
    3. Why did you choose this topic?
    4. Who is your audience?
    5. What is your plan?
    6. How did it go today?
    7. What needs to happen in order for your group to work well together to create a worthwhile and educational project?

TODAY IS THE LAST CLASS TO COMPLETE THIS PROJECT–YOU WILL VIEW/EVALUATE YOUR CLASSMATES PROJECTS NEXT CLASS.

HERE IS HOW YOU WILL BE GRADED

GOOGLE PROJECT: Find an app, use the suite to instruct others about why it is useful and how to use it. Here is what you need to do:

  1. Go to the Google Chrome Store and search for apps that you think would be useful. Try out a bunch of different apps! Explore! Have fun!!
  2. Pick 1 Google App that you think is useful.
  3. Use the following in some way to help educate people about this app–why it is useful and how to use it:
    1. Google Form
    2. Google Draw
    3. Google Presentation
    4. Google Spreadsheet
  4. Options:
    1. This can be designed as an online workshop
    2. This can be designed as a face-to-face workshop where you are the instructor

OR:

THIS IS YOUR FINAL CULMINATING PROJECT FOR THE GOOGLE UNIT–YOU NEED TO DEMONSTRATE WHAT YOU HAVE LEARNED FROM THE GOOGLE UNIT BY INSTRUCTING OTHERS ABOUT THE GOOGLE SUITE.

GOAL: Before you leave today you will have the opportunity to plan a workshop to be offered to one of the following groups of people (PICK ONE): our community members/students at BHS/students at BMS/Teachers in the school district/teachers at the elementary/teachers in the middle/high school about Google Doc.. You will have today and the NEXT 2 CLASSES TO PLAN THIS WORKSHOP.

  1. PROBLEM: It is your job to conduct a workshop to teach others about how to use the Google suite (Documents, Forms, Spreadsheets, Presentation, Drawing). You will plan this workshop over the next 3 classes and then conduct the workshop.  Before you leave today, you need to formulate a plan and organize the next 3 classes–create your lesson plan and share it with me. Here are some things to consider:
    1. Who will you conduct this workshop for? Who needs to learn how to use the Google suite?
    2. When will this workshop be conducted  and where?
    3. What specific skills should be taught during the workshop?
    4. Who, in your group, is responsible for what?
    5. What will be the main goal of the workshop?
    6. How will you promote it?
    7. Who will promote it?
  2. At the end of class share a Google Doc with me detailing your plans for the next 3 classes. BE SPECIFIC!!!

OR:

GOAL: Before you leave class today you will have picked your group of 2 or 3 and you will have DECIDED on a topic, and you will have a plan in place for how this project will proceed.

  1. GROUP PROJECT: Pick a research topic. The topic must meet the following requirements:
    1. Fairly local concern
    2. Heavy use of data in the form of numbers
    3. Use Google Forms to gather primary data on your research topic
    4. Use the Internet to gather information
    5. Create a Google Spreadsheet to illustrate your findings
    6. You will present this information to the class using Google Presentation–import your Google Spreadsheet into your Google Presentation
    7. Use Google Drawing to create a logo on your topic–include it in your presentation
  2. Develop a plan. Use a new Document in Google. Share it with everyone in your group & me (tweber@bellevue.k12.ia.us). Things to think about:
    1. Create an outline of your project
    2. Assign everyone in your group at least 2 parts to the outline–these should include Internet research
    3. Who is in charge of creating the Form?
    4. Who is in charge of creating the Spreadsheet?
    5. Who is in charge of creating the Presentation?
    6. Who is in charge of creating the Drawing?
  3. Send a note to me in Edmodo addressing the following:
    1. Who is in your group?
    2. What is your topic?
    3. Why did you choose this topic?
    4. Who is your audience?
    5. What is your plan?
    6. How did it go today?
    7. What needs to happen in order for your group to work well together to create a worthwhile and educational project?

EVALUATE YOUR CLASSMATES PROJECTS

THIS IS YOUR FINAL CULMINATING PROJECT FOR THE GOOGLE UNIT–YOU NEED TO DEMONSTRATE WHAT YOU KNOW ABOUT THE GOOGLE SUITE BY TEACHING IT TO OTHERS.

HERE IS HOW YOU WILL BE GRADED

THIS IS YOUR FINAL CULMINATING PROJECT FOR THE GOOGLE UNIT

DUE TODAY!!! HERE IS HOW YOU WILL BE GRADED

SHARE IT WITH ME & EVERYONE IN THIS CLASS

View your classmates workshops & provide compliments/constructive criticism. Do this in a Google Doc shared with me.

PROBLEM: There are many careers available for you to pursue beyond high school. Think about your interests and what you want to do for the rest of your life when you are done with school. Research a career in that area. Does the career require education beyond high school? If so, how much? Where can you go to get that education? How much time and money will it cost you? How will you pay for it? What jobs can you get in that career field? (For example, in the education career field you could get a job as a teacher, counselor, paraprofessional, administrator, psychologist, etc.) What is the average pay for someone with that job? Where are the jobs? Will you need to relocate? What are the benefits to working in that career area? What are the detriments to working in that career area? Why did you choose this career area? How could this career/job utilize Google Drive?

  1. BLOG DAY–Blog about your chosen career/job–share it with me (tracyweber@bellevue.k12.ia.us).
    1. Go to Google
    2. Click More
    3. Choose Blogger
    4. CREATE A NEW POST: Blog about a career/job of your choice. EDUCATE YOUR AUDIENCE ABOUT THIS CAREER CHOICE!! Use the Internet. Provide web links, YouTube clips, and pictures to support your claim.
      1. YOU SHOULD RESEARCH FOR AT LEAST 30 MINUTES!!!
    5. BE SURE TO ADDRESS THE FOLLOWING QUESTIONS:
      1. Does the career require education beyond high school?
        1. If so, how much?
        2. Where can you go to get that education?
        3. How much time and money will it cost you?
        4. How will you pay for it?
      2. What jobs can you get in that career field? (For example, in the education career field you could get a job as a teacher, counselor, paraprofessional, administrator, psychologist, etc.)
      3. What is the average pay for someone with that job?
      4. Where are the jobs? Will you need to relocate?
      5. What are the benefits to working in that career area?
      6. What are the detriments to working in that career area?
      7. Why did you choose this career area?
      8. How could this career/job utilize Google Drive?
    6. SHARE the blog post with me and your classmates by posting it on your class’ Edmodo page.
    7. Change the Layout of your blog:
      1. Click the Down arrow on the button (Go to post list) beside the pencil on the page that lists your blogs.
      2. Choose Layout
      3. EXPERIMENT!! Customize your blog!!
  2. Check JMC for make up work

INFOGRAPHIC

  1. Look at some examples of infographics
  2. Read this article about 5 different infographic sites you can use to create free infographics
  3. Experiment with at least 2:
    1. http://www.visme.co/
    2. https://www.canva.com/create/infographics/
    3. http://www.easel.ly/
    4. http://piktochart.com/
    5. https://infogr.am/
    6. http://vizualize.me/
    7. https://venngage.com/
  4. Here is your job: Bellevue Community School District has hired you to spice up their “signage”. Below is a sign they would like “spiced up”. You have decided to create an infographic to help you do the job. You have also decided that you will create at least TWO different infographics so that your customers will have a choice.
    1. student-success
  5. Here is an example:
    1. Student Success in School & Life Infographic

INFOGRAPHIC

GOAL: Share & print your 2 infographics as a PDF before you leave today.

  1. Here is your job: Bellevue Community School District has hired you to spice up their “signage”. Below is a sign they would like “spiced up”. You have decided to create an infographic to help you do the job. You have also decided that you will create at least TWO different infographics so that your customers will have a choice.
    1. student-success
  2. Here is an example:
    1. Student Success in School & Life Infographic

INFOGRAPHIC

GOAL: Share & print your 2 infographics as a PDF before you leave today.

  1. Here is your job: Bellevue Community School District has hired you to spice up their “signage”. Below is a sign they would like “spiced up”. You have decided to create an infographic to help you do the job. You have also decided that you will create at least TWO different infographics so that your customers will have a choice.
    1. student-success
  2. Here is an example:
    1. Student Success in School & Life Infographic

Everfi-Radius Curriculum: Class code: 31246587

Mission 1: Introduction to Binary Numbers − Overview: o Students will be welcomed to the world of RADIUS & will design their secret agent avatar for use during course − Learning Objectives: o Compare and contrast place value systems of numeration. o Use point and click selection functions. o Identify basic STEM vocabulary in selected domains. − Performance-Based Activities and Assessments: o Design a custom secret agent avatar. o There are five practice questions (recognition) and five summative multiple choice assessment questions with feedback after each answer. The first answer selected for each assessment question counts toward students’ scores. o Each mission poses two optional open response questions.

Mission 2: Working with Binary Numbers − Overview: o Students convert numbers between base 10 and base 2 and perform binary addition and multiplication. − Learning Objectives: o Understand binary numbers and how to manipulate them and apply them to real-world scenarios o Compare and contrast place value systems of numeration o Write code to automate conversion of decimal and binary numbers − Performance-Based Activities and Assessments: o Apply knowledge of binary numbers to plan a truck convoy and determine the minimum number of trucks required to carry different cargo weights. o Generate code to automate conversion of decimal and binary numbers. o There are five practice questions (recognition) and five summative multiple choice assessment questions with feedback after each answer. The first answer selected for each assessment question counts toward students’ scores. o Each mission poses two optional open response questions.

Mission 3: Rational and Irrational Numbers & Estimation

Overview: You will distinguish rational numbers from irrational numbers and practice estimation and determining measurement error.

Learning Objectives:

  1. Identify rational and irrational numbers and estimate rational approximations of irrational numbers.
  2. Define and identify errors in measurement including absolute error, relative error and percentage error.
  3. Create code to automate finding the value of an irrational number to a specified accuracy.

Activities and Assessments:

  1. Calculate irrational number approximations to determine the length of the new steel beams needed to fix a broken bridge.
  2. Generate code to approximate irrational numbers.
  3. Questions

Mission 4: Linear Equations, Functions & Graphs

Overview: Students learn about linear equations and apply linear equations to solve real world problems.

Learning Objectives:

  1. Analyze and solve linear equations with one variable and multiple variables.
  2. Graph linear equations on a coordinate plane.
  3. Interpret slope-intercept form of a linear equation.

Activities and Assessments:

  1. Solve linear equations to determine how many feet of surfacing is needed to patch up the gap in the broken bridge.
  2. Generate code to automate and solve linear equations in form y = mx +b.
  3. Questions

Mission 5: HTML Part 1 − Overview: o Students learn key terms related to computer networks and are introduced to HTML tags, which they must apply for the first time in their online Agent Report. − Learning Objectives: o Recall and apply HTML tag conventions and best design practices for web-page display. o Construct interface design for basic readability (color/font/size) and avoiding cognitive overload. o Compare and contrast HTML and programming language. o Populate Agent Report journal using HTML code. − Performance-Based Activities and Assessments: o Produce HTML to design the first phase of the Agent Report. o There are five practice questions (recognition) with feedback after each answer. o Each mission poses two optional open response questions.

Mission 6: Ratios, Rational Numbers, Rates & Unit Conversion − Overview: o Students learn about different types of unit measurements and how to perform conversions. − Learning Objectives: o Discover the relationships between ratios, rational numbers and unit rates. o Evaluate functions that involve rational numbers, ratios, proportions and unit rates. o Perform unit conversion and dimensional analysis (going from one set of units to another) using code. − Performance-Based Activities and Assessments: o Match answers with different units of measurement to the appropriate problems. o Generate code to automate conversions between different units of measurement. o There are five practice questions (recognition) and five summative multiple choice assessment questions with feedback after each answer. The first answer selected for each assessment question counts toward students’ scores. o Each mission poses two optional open response questions.

Mission 7: Circuits and Paths − Overview: o Students are introduced to basic network models, circuits and paths and discover how they relate to STEM in the real-world. − Learning Objectives: o Apply graph theory to determine network flow. o Identify and manipulate Euler and Hamilton paths and circuits. o Determine an optimal route through a network by assessing paths, circuits, edges, nodes and points of failure. − Performance-Based Activities and Assessments: o Analyze three network graphs to determine how to map the shortest route possible while still reaching all of the necessary nodes. o There are five practice questions (recognition) and five summative multiple choice assessment questions with feedback after each answer. The first answer selected for each assessment question counts toward students’ scores. o Each mission poses two optional open response questions.

Mission 8: Cryptography − Overview: o Students are given a history of cryptography and learn how to use binary numbers to solve basic encryption and decryption problems. − Learning Objectives: o Understand why encryption and decryption of information is important, both historically and in modern day. o Synthesize binary coding scheme to encode and decode messages. o Modify code for specific encryption and decryption algorithms using a template. − Performance-Based Activities and Assessments: o Decode secret messages by applying basic decryption methods and knowledge of binary numbers. o Modify code for a specific encryption/decryption algorithm. o There are five practice questions (recognition) and five summative multiple choice assessment questions with feedback after each answer. The first answer selected for each assessment question counts toward students’ scores. o Each mission poses two optional open response questions.

Mission 9: Logical Operators & True or False Statements − Overview: o Students learn about logical operators, Boolean logic, truth tables and logical program design. − Learning Objectives: o Evaluate true/false statements with logical connectors and, or, and not and recall the order of logical operations. o Translate truth tables into binary code. o Understand the steps of logical program design and how you can use the true/false value of logical statements to control the flow of a program. − Performance-Based Activities and Assessments: o Sort the steps of programming a solution into the correct sequencing. o Generate code to automate truth tables. o There are five practice questions (recognition) and five summative multiple choice assessment questions with feedback after each answer. The first answer selected for each assessment question counts toward students’ scores. o Each mission poses two optional open response questions.

Mission 10: HTML Part 2 − Overview: o Students discover more common HTML tags as a continuation of Mission 5 and become versed in best practices when creating webpage visuals. − Learning Objectives: o Construct Online Learning Journal using HTML o Identify HTML tags as the source of controlling web-page display details o Design for basic perceptual readability (color/font/size) and avoiding cognitive overload o Compare and contrast HTML and programming language − Performance-Based Activities and Assessments: o Produce HTML code to continue to enhance the Agent Report. o There are five practice questions (recognition) and five summative multiple choice assessment questions with feedback after each answer. The first answer selected for each assessment question counts toward students’ scores. o Each mission poses two optional open response questions.

Mission 11: Pythagorean Theorem & Distance Formula − Overview: o Students are introduced to the Pythagorean Theorem and learn how to find the distance between two points on a coordinate plane using the Pythagorean Theorem and the Distance Formula. − Learning Objectives: o Apply the Pythagorean Theorem to solve for one side of a right triangle o Apply the Pythagorean Theorem and Distance Formula to find the distance between two points on a coordinate plane. − Performance-Based Activities and Assessments o Match mathematical expressions with the corresponding images. o Generate code to automate a function template that uses Pythagorean Theorem to find the length between two coordinate points. o There are five practice questions (recognition) and five summative multiple choice assessment questions with feedback after each answer. The first answer selected for each assessment question counts toward students’ scores. o Each mission poses two optional open response questions.

Mission 12: Visual Displays, Trends & Scientific Notation − Overview: o Students learn about scientific notation and different types of visual data displays and how to analyze them. − Learning Objectives: o List numbers in scientific notation in order from least to greatest. o Identify different types of visual displays (lists, tables, bar graphs, pie charts, time series graphs, scatterplots) and how to read them. o Analyze visual displays to find trends and determine if the display might be misleading and why. − Performance-Based Activities and Assessments: o Match visual displays with the appropriate trend (increasing, decreasing or unchanging). o Generate code to create a template that can be used to plot data. o There are five practice questions (recognition) and five summative multiple choice assessment questions with feedback after each answer. The first answer selected for each assessment question counts toward students’ scores. o Each mission poses two optional open response questions.

Mission 13: Probability − Overview: o Students learn about probability and determining probability with diagrams and algebraic statements. − Learning Objectives: o Solve the probability of an event and compound events by applying the rules of probability, including P(E) = number of times the event occurs ÷ total number of outcomes. o Calculate the complement of P(E). o Evaluate and make decisions under uncertainty. − Performance-Based Activities and Assessments: o Analyze Venn diagrams and algebraic statements to calculate simple and compound probabilities for possible outcomes. o Modify code to create a custom tool that calculates expected value given a probability distribution. o There are five practice questions (recognition) and five summative multiple choice assessment questions with feedback after each answer. The first answer selected for each assessment question counts toward students’ scores. o Each mission poses two optional open response questions.

Mission 14: PERT, Project Planning & Critical Paths − Overview: o Students learn how to execute PERT planning techniques and critical path analysis. − Learning Objectives: o Create a project task table. o Draw a network diagram from a task table. o Identify the critical path from a network diagram. − Performance-Based Activities and Assessments: o Coordinate task management and planning activities. o There are five practice questions (recognition) and five summative multiple choice assessment questions with feedback after each answer. The first answer selected for each assessment question counts toward students’ scores. o Each mission poses two optional open response questions.

Mission 15: Trees- Rooted, Binary, Expression − Overview: o Students learn how to create and interpret network trees that represent algorithms. − Learning Objectives: o Read and identify rooted trees, binary trees and expression trees and understand how they relate to sorting. o Find the value of expression trees. o Build expression trees from binary trees. − Performance-Based Activities and Assessments: o Match complex arithmetic expressions with their equivalent tree diagrams. o There are five practice questions (recognition) and five summative multiple choice assessment questions with feedback after each answer. The first answer selected for each assessment question counts toward students’ scores. o Each mission poses two optional open response questions.

 

Mission 16: HTML Part 3 − Overview: o This final mission reinforces students’ understanding of HTML tags and best design practices for webpages as they finalize their Agent Report. − Learning Objectives: o Recall basic HTML tags with solid understanding of how tags function to control webpage display details. o Develop strong sense of user interface best practices for basic readability (color/font/size) and avoiding cognitive overload. − Performance-Based Activities and Assessments: o Match types of components with examples in a webpage image. o Finalize Agent Report using HTML to format answers and design the report. o There are five practice questions (recognition) and five summative multiple choice assessment questions with feedback after each answer. The first answer selected for each assessment question counts toward students’ scores. o Each mission poses two optional open response questions.

YOU WILL PRESENT YOUR PORTFOLIO TO YOUR CLASSMATES. YOU CLASSMATES WILL BE YOUR POTENTIAL EMPLOYER. YOU NEED TO CONVINCE US THAT YOU ARE RIGHT FOR THE JOB!! GET YOUR EVALUATION FORM FOR YOUR PORTFOLIO FROM YOUR TEACHER. DRESS PROFESSIONALLY WHEN PRESENTING.

  1. Electronic Career Portfolio–YOU WILL HAVE TODAY AND THE NEXT CLASS TO FINISH THIS.
  2. Get a grading rubric from your teacher, if you don’t have one.
    1. Add Table & Memo to your RESOURCES page
      1. Find a Table and a Memo that you created in this class and upload it to your RESOURCES page. You will need to know how to do each one for the final.
    2. Finish the lesson plan from yesterday
    3. HOW TO ADD MULTIMEDIA OBJECTS TO YOUR GOOGLE SITES WEB PAGE
    4. Add multimeda objects to all your pages:
      1. Animated clipart
      2. Photos of your work
      3. iMovies
      4. etc.

YOU WILL PRESENT YOUR PORTFOLIO TO YOUR CLASSMATES. YOU CLASSMATES WILL BE YOUR POTENTIAL EMPLOYER. YOU NEED TO CONVINCE US THAT YOU ARE RIGHT FOR THE JOB!! GET YOUR EVALUATION FORM FOR YOUR PORTFOLIO FROM YOUR TEACHER. DRESS PROFESSIONALLY WHEN PRESENTING.

  1. Electronic Career Portfolio–FINISH TODAY–PRESENT NEXT CLASS
  2. Get a grading rubric from your teacher, if you don’t have one.
    1. Add work from other classes
    2. Check JMC–add anything you haven’t added to your site (resume, letter of application, table, memo, MLA style report with table of contents, title page, and work cited page)
    3. SEND ME THE LINK TO YOUR SITE SO I CAN GRADE THE ABOVE DOCUMENTS
    4. Remember: this is a PROFESSIONAL site!!
    5. EXTRA CREDIT–look at the FBLA grading rubric–include the career information
  3. YOU WILL PRESENT YOUR PORTFOLIO TO YOUR CLASSMATES. YOU CLASSMATES WILL BE YOUR POTENTIAL EMPLOYER. YOU NEED TO CONVINCE US THAT YOU ARE RIGHT FOR THE JOB!! GET YOUR EVALUATION FORM FOR YOUR PORTFOLIO FROM YOUR TEACHER. DRESS PROFESSIONALLY WHEN PRESENTING.

FINISH & PRESENT CAREER PORFOLIO

  1. Get a grading rubric from your teacher, if you don’t have one.

CHECK JMC & GET ALL ZEROS TURNED IN!!!!

REVIEW FOR FINAL–YOU MAY USE YOUR NOTES!!! GET ORGANIZED!!

Review for final exam. Here is what will be on your final:

  1. Spreadsheet & chart in Google Docs
    1. Create a spreadsheet and be sure you can do the following:
      1. Create a vertical bar chart.
      2. Title the chart
      3. Title the x-axis
      4. Title the y-axis
      5. Find the total using a function.
      6. Find the average using a function.
      7. Share the spreadsheet and chart with me: tracyweber@bellevue.k12.ia.us
  2. Access database: be sure you can do the following:
    1. create a table
    2. use input mask
    3. use lookup wizard
    4. create a query

 

GET THE HANDOUT FROM YOUR TEACHER FOR THE REMAINDER OF YOUR TEST:

FINISH: PARTS I & II–Spreadsheet & Database–SHOW ME EACH PART WHEN YOU ARE DONE

BEGIN: PART III–MLA Style Report–SHOW ME WHEN YOU ARE DONE

Access 2010–create a new document in Google and name it Access 2010 learnfree.org

  1. Under Access Basics start with Introduction to Databases
    1. Watch the video
    2. What is a database and how is it used?
    3. The tables in Access are similar to what other Office program?
    4. Click NEXT
    5. Why would you use Access instead of using Excel?
    6. What is a relational database?
    7. Read the page and click NEXT.
    8. Read the page and click NEXT.
  2. Introduction to Objects
    1. What are the four objects in Access?
    2. Click NEXT
    3. Watch the video
    4. All information in an Access database are stored in what?
    5. What is the difference between a field and a record?
    6. Click NEXT
    7. What is the difference between a form and a table in Access?
    8. What does a query do in Access?
    9. What is the purpose of creating a report in Access?
    10. Click NEXT
    11. Read the page and click NEXT
  3. Getting Started in Access
    1. Watch the video
    2. What are the similarities and differences between navigating in Access and Excel?
    3. Click NEXT
    4. What is a contectual tab?
    5. How can the ribbon be minimized or maximized?
    6. Does the Save command save al open objects?
    7. Does the Undo command undo all actions?
    8. Click NEXT
    9. What does the Save command allow you to save in Backstage view?
    10. Look at all the options available in the Backstage View.
    11. Click NEXT
    12. What does the Navigation Pan contain?
    13. What can you do using the Navigation Pane?
    14. How can you minimize and maximize the Navigation Pane?
    15. Read the rest of the page and click NEXT
    16. We will not use navigation forms in this class. Click NEXT
    17. Click on the our example link and save the database to your DOWNLOADS folder–you will not be able to open it immediately
    18. Once it is saved to the Downloads folder, click your Windows button in the lower left corner of your screen, click All Programs, scroll to find the Microsoft Office folder, and click Access.
    19. Once you are in Access, click OPEN from the Backstage View
    20. Go to your Downloads folder and open the file you just downloaded.
    21. Click Enable Content
    22. Try minimizing and maximizing the Ribbon
    23. Click through all the Tabs and notice how the Ribbon changes
    24. Resize the Navigation Pane
    25. Re-sort the objects in the Navigation Pane
    26. Back to the tutorial, click NEXT
  4. Managing Databases and Objects
    1. Watch the video
    2. Read the page and click NEXT
    3. Can you have more than 1 object open at one time?
    4. How do you close an object?
    5. How do you rename an object?
    6. Click NEXT
    7. You do NOT need to download the sample again–you already did! Get into Access and open the sample database that you saved to your downloads folder and do numbers 2-5 in the Challenge page of the tutorial.
    8. Click NEXT
  5. Working with Tables
    1. Watch the video
    2. Rows are called what?
    3. Columns are called what?
    4. Read the rest of the page and click NEXT
    5. What are the 3 ways to enter a new record? Which do you think is the easiest?
    6. Click NEXT
    7. How do you delete a record?
    8. When you delete a record, can you undo it and get the record back?
    9. What happens to ID numbers when a record is deleted?
    10. Click NEXT
    11. Watch the video
    12. How can you resize a field and a row?
    13. Click NEXT
    14. Read the page and click NEXT
    15. Do the Challenge using the previously downloaded database.
    16. Click NEXT
  6. Working with Forms
    1. What is the advantage to using forms in Access?
    2. Click NEXT
    3. Watch the video
    4. Read the page and click NEXT
    5. Read the page and click NEXT
    6. Do the Challenge and show me when you are done!!
    7. Click NEXT

BE SURE TO SHARE YOUR GOOGLE DOC WITH ME: tracyweber@bellevue.k12.ia.us

PICK UP WHERE YOU LEFT OFF LAST CLASS:

Access 2010–create a new document in Google and name it Access 2010 learnfree.org

  1. Under Access Basics start with Introduction to Databases
    1. Watch the video
    2. What is a database and how is it used?
    3. The tables in Access are similar to what other Office program?
    4. Click NEXT
    5. Why would you use Access instead of using Excel?
    6. What is a relational database?
    7. Read the page and click NEXT.
    8. Read the page and click NEXT.
  2. Introduction to Objects
    1. What are the four objects in Access?
    2. Click NEXT
    3. Watch the video
    4. All information in an Access database are stored in what?
    5. What is the difference between a field and a record?
    6. Click NEXT
    7. What is the difference between a form and a table in Access?
    8. What does a query do in Access?
    9. What is the purpose of creating a report in Access?
    10. Click NEXT
    11. Read the page and click NEXT
  3. Getting Started in Access
    1. Watch the video
    2. What are the similarities and differences between navigating in Access and Excel?
    3. Click NEXT
    4. What is a contectual tab?
    5. How can the ribbon be minimized or maximized?
    6. Does the Save command save al open objects?
    7. Does the Undo command undo all actions?
    8. Click NEXT
    9. What does the Save command allow you to save in Backstage view?
    10. Look at all the options available in the Backstage View.
    11. Click NEXT
    12. What does the Navigation Pan contain?
    13. What can you do using the Navigation Pane?
    14. How can you minimize and maximize the Navigation Pane?
    15. Read the rest of the page and click NEXT
    16. We will not use navigation forms in this class. Click NEXT
    17. Click on the our example link and save the database to your DOWNLOADS folder–you will not be able to open it immediately
    18. Once it is saved to the Downloads folder, click your Windows button in the lower left corner of your screen, click All Programs, scroll to find the Microsoft Office folder, and click Access.
    19. Once you are in Access, click OPEN from the Backstage View
    20. Go to your Downloads folder and open the file you just downloaded.
    21. Click Enable Content
    22. Try minimizing and maximizing the Ribbon
    23. Click through all the Tabs and notice how the Ribbon changes
    24. Resize the Navigation Pane
    25. Re-sort the objects in the Navigation Pane
    26. Back to the tutorial, click NEXT
  4. Managing Databases and Objects
    1. Watch the video
    2. Read the page and click NEXT
    3. Can you have more than 1 object open at one time?
    4. How do you close an object?
    5. How do you rename an object?
    6. Click NEXT
    7. You do NOT need to download the sample again–you already did! Get into Access and open the sample database that you saved to your downloads folder and do numbers 2-5 in the Challenge page of the tutorial.
    8. Click NEXT
  5. Working with Tables
    1. Watch the video
    2. Rows are called what?
    3. Columns are called what?
    4. Read the rest of the page and click NEXT
    5. What are the 3 ways to enter a new record? Which do you think is the easiest?
    6. Click NEXT
    7. How do you delete a record?
    8. When you delete a record, can you undo it and get the record back?
    9. What happens to ID numbers when a record is deleted?
    10. Click NEXT
    11. Watch the video
    12. How can you resize a field and a row?
    13. Click NEXT
    14. Read the page and click NEXT
    15. Do the Challenge using the previously downloaded database.
    16. Click NEXT
  6. Working with Forms
    1. What is the advantage to using forms in Access?
    2. Click NEXT
    3. Watch the video
    4. Read the page and click NEXT
    5. Read the page and click NEXT
    6. Do the Challenge and show me when you are done!!
    7. Click NEXT
  7. Check JMC & do make up work
  8. Take timings: send your screenshots to me in a note in Edmodo or in an email message.

YELLOW TEXTBOOK–Before you leave today you will know how to:

  1. Navigate in Access
  2. Enter records
  3. Sort records
  1. Read pages 342-349 in the YELLOW book–This will give you an overview of the Access unit.
  2. Activity 1.1
    1. Read and do pages 350-353
    2. Read the NOTE that is in bold and italics on page 350 and make sure you do it!!!
    3. Be sure you can answer the following questions?
      1. What is a field?
      2. What is a record?
      3. What is Datasheet View?
      4. What is a table?
      5. What is a database?
      6. What is a primary key?
    4. Tables 1.1 and 1.2 are EXTREMELY important!!!!
  3. Activity 1.2
    1. Read and do pages 354-357
    2. What are the Objects in Access?
    3. What is a Query?
    4. How can you move from record to record in a database?
    5. What is a Report?
    6. What is Design or Layout View?
    7. Can more than 1 database be open at a time?
    8. Do you have to save the Access database or is it done automatically?
  4. Activity 1.3
    1. Read and do pages 358-359
    2. What does Best Fit do?
    3. How can you move to the last record in a table?
    4. How can you move to the first record in a table?
    5. What do the folllowing commands allow you to do in a table:
      1. ctrl-home
      2. ctrl-end
      3. shift-tab
      4. home
      5. end
    6. What needs to be saved manually?
  5. Activity 1.4
    1. Read and do pages 360-361
    2. What can you do if you cannot see something when you are finding something in a database because the Find and Replace dialog box is in the way?
    3. What does the pencil icon represent?
  6. Activity 1.5
    1. Read and do pages 362-363
    2. What is primary key?
  7. Create a new Google Doc, share it with me. Using 5-8 sentences, tell me what you learned today and how you can use it in your life now or in the future.

GOAL: Before you leave today you will know what a form is, what happens when you delete a record in Access, how to sort on multiple fields, how to print a table in Access, and how to use a filter.

For review, in a Google Doc, share the following sentences with me:

  1. In a Google Doc shared with me do the following:
    1. Use Record as the 3rd word in a sentence.
    2. Use Field as the last word in a sentence.
    3. Use Database as the first word in a sentence.
  2. Finish Activities 1.1 to 1.5 from last class.
  3. In the same Google Doc (SHARE THE GOOGLE DOC FROM LAST CLASS WITH ME SO I CAN SEE HOW MUCH YOU GET ACCOMPLISHED TODAY!), copy and paste and do the following:
  4. Activity 1.6
    1. Read and do pages 364-365
    2. What is a Form?
    3. Take the Activities 1.1 to 1.6 Quiz in Edmodo
  5. Activity 1.7
    1. Read and do pages 366-367
    2. If you delete a record by mistake can you get it back, undo?
  6. Activity 1.8
    1. Read and do pages 368-369
    2. How can you select more than 1 column at a time?
    3. Can you sort on multiple fields at the same time? If so, how?
  7. Activity 1.9
    1. Read and do pages 370-371
    2. What is a filter?
    3. Does it matter what column you have your cursor in when you click the Filter button?
    4. How can you turn off a Filter?
    5. Can you filter on several conditions or only 1? Explain.
  8. Activity 1.10
    1. Read pages 372-373
    2. If a table doesn’t fit on 1 page, what are some measures you can take to try to get it to fit to one page?
    3. What if you still cannot get it to fit to one page?
    4. Do not print
    5. How can you preview multiple pages?
  9. Activity 1.11
    1. Read pages 374-375
    2. What is the keyboard shortcut for selecting all records?
    3. Do not print
  10. SHARE THIS GOOGLE DOC WITH ME SO I CAN SEE HOW MUCH YOU ACCOMPLISHED TODAY
  1. Review the Activities 1.1 to 1.11 questions in the last 2 class lesson plans.
  2. Take the Access Section 1 Quiz in Edmodo
  3. Begin working on the assignments for Section 1.

Be sure to do the following to every assignment:

  1. Get all information to fit on 1 page
  1. Skills Review 1–Print Preview before closing. Try to get it to 1 page, if possible, using the techniques learned in this section. Show me.
  2. Skills Review 2–Print Preview before closing. Try to get it to 1 page, if possible, using the techniques learned in this section. Show me.

CHECK JMC & FINISH ACCESS SECTION 1

GET ALL ZEROS TURNED IN TODAY!!!

Before you leave today you will know how to create a table in an Access Database. You will also know how to use different field types such as text, currency, numeric, date, input mask, and lookup wizard.

  1. CLICK ON THIS LINK TO SHOW YOU HOW TO DO THE STEPS BELOW:
    1. Right now, create a NEW database and name it Bellevue High School
    2. Create a NEW TABLE and name it STUDENTS.
    3. Click DESIGN view and assign the following fields:
      1. First Name, text, size 15
      2. Last Name, text, size 20
      3. Birthday, date/time, long date format with a short date input mask
      4. Phone Number, text, input mask
      5. City, lookup wizard, enter the following cities (be sure to NOT limit to list):
        1. Bellevue
        2. LaMotte
        3. Springbrook
        4. St. Donatus
      6. Credits, number
      7. Fees, currency
      8. Graduated, yes/no
    4. Click DATASHEET view (name the table STUDENTS)
    5. Enter data for 5 students

On your own, practice what you learned:

    1. Activity 4, page 524 in the purple book
      1. Create a new database and name it ACTIVITIES
      2. Create a new table in the activities database and name the table DT3
      3. All field types are TEXT except for Date, make it SHORT DATE FORMAT–AND make it have an INPUT MASK for the short date format.
      4. Show me when you are done.
    2. Activity 7, page 528 in the purple book
      1. Open the ACTIVITIES database and the DT3 table, if necessary, and make the indicated changes
    3. Activity 9
      1. Open the ACTIVITIES database, if necessary
      2. Create a new table in Design View and in addition to the instructions in your book, be sure to do the following:
        1. Create a lookup wizard for the Binding field. The options to pick from should be: hardcover, papercover
      3. Name the table DT5
      4. Show me
    4. Activity 10
      1. Open the ACTIVITIES database, if necessary
      2. Open the DT5 table, if necessary
      3. In addition to the instructions in your book, be sure to do the following:
        1. Use an input mask for the date
      4. Show your teacher
    5. Activity 11
      1. Open the ACTIVITIES database, if necessary
      2. Open the DT3 table, if necessary
      3. Follow the instructions in your book
      4. PROOFREAD VERY WELL!!! You should go back to previous activities to ensure accuracy!!

FINISH:

    1. Activity 4, page 524 in the purple book
      1. Create a new database and name itACTIVITIES
      2. Create a new table in the activities database and name the table DT3
      3. All field types are TEXT except for Date, make it SHORT DATE FORMAT–AND make it have an INPUT MASK for the short date format.
      4. Show me when you are done.
    2. Activity 7, page 528 in the purple book
      1. Open the ACTIVITIES database and the DT3 table, if necessary, and make the indicated changes
    3. Activity 9
      1. Open the ACTIVITIES database, if necessary
      2. Create a new table in Design View and in addition to the instructions in your book, be sure to do the following:
        1. Create a lookup wizard for the Binding field. The options to pick from should be: hardcover, papercover
      3. Name the table DT5
      4. Show me
    4. Activity 10
      1. Open the ACTIVITIES database, if necessary
      2. Open the DT5 table, if necessary
      3. In addition to the instructions in your book, be sure to do the following:
        1. Use an input mask for the date
      4. Show your teacher
    5. Activity 11
      1. Open the ACTIVITIES database, if necessary
      2. Open the DT3 table, if necessary
      3. Follow the instructions in your book
      4. PROOFREAD VERY WELL!!! You should go back to previous activities to ensure accuracy!!

GOAL: Before you leave today you will know how to perform simple sorts, advanced sorts, and how to create simple and complex queries. COMPLETE:

    1. Activity 11
      1. Open the ACTIVITIES database, if necessary
      2. Open the DT3 table, if necessary
      3. Follow the instructions in your book
      4. PROOFREAD VERY WELL!!! You should go back to previous activities to ensure accuracy!!

Free Courses: Read, listen, watch, & do the following free free courses:

  1. Sorting & Filtering Records
    1. Sorting and Filtering Records
      1. Watch the video
      2. What is ascending order for numbers and words?
      3. What is descending order for numbers and words?
      4. How do you sort?
      5. How do you remove a sort?
      6. Click NEXT
      7. What do Filters do?
      8. How do you create a simple filter?
      9. What does the Toggle Filter do?
      10. How do you do a filter based on a selection?
      11. Click NEXT
      12. Clicn NEXT again
      13. Do the Challenge–if you need help–ASK!!!
      14. Click NEXT
  2. Designing A Query
  3. More Query Design Options
  4. WRITING FOR TODAY: What did you learn today? What is the difference between a query and sort/filter?

CHECK JMC & DO MAKE UP WORK, IF TIME PERMITS

GOAL: Before you leave today you will know how to perform simple sorts, advanced sorts, and how to create simple and complex queries. COMPLETE:

WATCH THESE 2 VIDEOS BEFORE CONTINUING:

  1. How to do a simple sort, advanced sort, and simple query.
  2. How to do more complex queries.
    1. Activities 12-14
      1. Do not print, instead compare your results to your neighbors to see if you did it correctly.
    2. Activity 15–Show me for a grade
    3. Activity 16–Just do it
    4. Activity 17
      1. Remember to click QUERY WIZARD from the CREATE tab
      2. Only the State & Date of Statehood fields should appear for the query.
      3. Show me
    5. Acitivty 18–Show me no grade
    6. Activity 19–Just do it.
    7. Activity 20–Show me for a grade
    8. Activity 21–Just do it.
    9. Activity 22:
      1. HINT: You will need all State Capitols with names greater than or equal to C and less than something. See if you can figure it out. 🙂 WATCH THE COMPLEX QUERIES video clip
      2. Show me for a grade
    10. Activity 23 & 24–Just do them
    11. Activity 25 & 26–Show me for a grade

FINISH FROM LAST CLASS:

  1. Acitvity 18–Show me no grade
  2. Activity 19–Just do it.
  3. Activity 20–Show me for a grade
  4. Activity 21–Just do it.
  5. Activity 22:
    1. HINT: You will need all State Capitols with names greater than or equal to C and less than something. See if you can figure it out. 🙂 WATCH THE COMPLEX QUERIES video clip
    2. Show me for a grade
  6. Activity 23 & 24–Just do them
  7. Activity 25 & 26–Show me for a grade

CHECK JMC & DO MAKE UP WORK!!!

GOAL: Before you leave class today you will know how to create a report in Access and you will know how to add formulas to a report in Access.

Free Courses: Read, listen, watch, & do the following free free courses:

  1. Creating Reports Free Course
  2. Advanced Report Options

CHECK JMC AND DO MAKE UP WORK, IF TIME PERMITS.

GOAL: Before you leave class today you will know how to create a report in Access and you will know how to add formulas to a report in Access.

WATCH THESE VIDEOS ABOUT CREATING REPORTS IN ACCESS AND HOW TO USE FORMULAS IN THE REPORT.

  1. HOW TO CREATE A REPORT IN ACCESS
  2. HOW TO ADD FORMULAS TO A REPORT IN ACCESS

Before you leave today you will know how to create Reports in Access and how to use formulas in database reports.

  1. Create a report for DT5. Include the following:
    1. Group the report by the Binding Field
    2. Sort the report within each Binding field by Author
    3. Title the report Authors
    4. Average the Retail Price field
    5. Total the Inventory field
    6. Put your name in the title.
    7. Make sure the report fits on 1 page (by width) by doing a print preview. You may need to adjust the margins, adjust field width in the report in design view, or change the orientation to landscape. Once it is on 1 page, show me.
  2. Create a report for DT3. Include the following:
    1. Group the report by the State Bird Field
    2. Sort the report within each State Bird field by Date of Statehood
    3. Title the report States
    4. Average the Highest Point field
    5. Total the Highest Point field (HINT: you will have to do this in DESIGN view after you create the report using the Report Wizard. You will need to copy & paste. See if you can figure it out!! :-))
    6. Put your name in the title.
    7. Make sure the report fits on 1 page (by width) by doing a print preview. You may need to adjust the margins, adjust field width in the report in design view, or change the orientation to landscape. Once it is on 1 page, show me.
  3. Create another report include everything above but group, sort, title, and total on fields of your choice.
    1. Make sure the report fits on 1 page (by width) by doing a print preview. You may need to adjust the margins, adjust field width in the report in design view, or change the orientation to landscape. Once it is on 1 page, do the following:
      1. Print Preview (again, if necessary)
      2. Alt-Prt Scrn
      3. Create a new email message to me (tracyweber@bellevue.k12.ia.us)
      4. In the message area:
        1. CTRL-V
        2. Explain how you (this is your writing for today):
          1. Grouped
          2. Sorted
          3. Totaled
          4. Averaged
  4. CHECK JMC & DO MAKE UP WORK–TAKE TIMINGS!!!

We are nearing the end of the Access unit. The written test will be multiple choice and the hands on exam will be similar to the exercises you have been working on.

  1. Access Automobile Project–Partner up

WRITING FOR TODAY: Midterm Evaluation: Give me advice about the business classes offered at Bellevue. What should be added? What should be eliminated? 3-5 sentences using good writing skills in a shared Google Doc.

We are nearing the end of the Access unit. The written test will be multiple choice and the hands on exam will be similar to the exercises you have been working on.

    1. Access Automobile Project
      1. When the Access Unit Project is complete, send it to me as an attachment in a note in Edmodo.
    2. GOAL FOR TODAY: Finish finding ALL 20 vehicles and begin setting up the table in Access. HINT: Copy your Word table and paste it into an Excel file. Save the Excel file. In Access, click the External Data tab. In the Import section, click Excel.
    1. Access Automobile Project
      1. When the Access Unit Project is complete, send it to me as an attachment in a note in Edmodo.
    2. GOAL FOR TODAY: Finish the table in Access and begin the Queries section.
  1. Access Automobile Project
    1. When the Access Unit Project is complete, send it to me as an attachment in a note in Edmodo.
    2. Print as indicated–be sure your name and your partner’s name appears on the printout. Print to: HP Officejet Pro 8600 (Network)
  2. GOAL FOR TODAY: FINISH
  3. Take Timings & Do Make Up Work–share with me through email, a Google Doc, or Edmodo–GET ALL ZEROS TURNED IN!!!
  1. Teacher Evaluation–I value your opinion!! This is the only way I can improve my courses to better meet the needs of my students. Please provide your HONEST opinion! Be descriptive & detailed–this is your writing for today.
  2. Written Exam–Edmodo–Copy #1 of Apps II Access Post Test
  3. Make up work/Timings–turn in all zeros!!
  1. Access Unit Hands On Exam–CERTIPORT EXAM!!!!

Access Hands On Test–Get handout from your teacher

Access Unit Exam

PERIOD 3:

FINISH THE ACCESS UNIT

Take timings

Do make up work

Blog

PERIOD 7:

TAKE THE ACCESS CERTIFICATION TEST

PERIOD 7:

FINISH THE ACCESS UNIT

Take timings

Do make up work

Blog

PERIOD 3:

TAKE THE ACCESS CERTIFICATION TEST

YOU WILL PRESENT YOUR PORTFOLIO TO YOUR CLASSMATES. YOUR CLASSMATES WILL BE YOUR POTENTIAL EMPLOYER. YOU NEED TO CONVINCE US THAT YOU ARE RIGHT FOR THE JOB!!  DRESS PROFESSIONALLY WHEN PRESENTING.

DO THIS TODAY:

    1. Before you leave today you will know what an Electronic Career Portfolio is.
      1. Google “Electronic Career Portfolio” and look at examples. Be thinking of how you could use this for yourself.
      2. Bookmark at least one example that you can use throughout this project.
      3. Get grading rubric from your teacher
  1. Create a Google Site:
    1. How to Create an E-Portfolio using Google Site–Add Pages, Edit Pages, Insert Photo
      1. Name it “YOUR NAME Electronic Career Portfolio”
      2. Choose an appropriate template
      3. Edit a page
      4. Add a page
  2. Make your home page “your” home page–edit the sidebar, place content on the page, include a logo in the header (comet, a picture of you, etc)
  3. Add pages and include content on each page (text, pictures, videos, etc):
    1. Activities
      1. Include a page for each activity?
    2. Work Experience
      1. Include a page for each job
    3. References
    4. Education
      1. Include a picture of the school
      2. Include a page for each class
      3. OR include a page for Projects, and a page for Essays, etc.
  4. Other suggestions:
    1. Limit scrolling on all pages
    2. Use bulleted/numbered lists as much as possible–avoid long paragraphs
    3. Use animated clipart
    4. Include your iMovies–try uploading an iMovie to Google Docs and then inserting it on a page in your site
    5. Take pictures of food you make in foods class, art projects, small engine you rebuilt, etc. and explain what you did to create it………

YOU WILL PRESENT YOUR PORTFOLIO TO YOUR CLASSMATES. YOU CLASSMATES WILL BE YOUR POTENTIAL EMPLOYER. YOU NEED TO CONVINCE US THAT YOU ARE RIGHT FOR THE JOB!! GET YOUR EVALUATION FORM FOR YOUR PORTFOLIO FROM YOUR TEACHER. DRESS PROFESSIONALLY WHEN PRESENTING.

  1. HOW TO UPLOAD A FILE TO A GOOGLE SITES WEB PAGE
  2. HOW TO SAVE A WORD FILE AS A PDF & UPLOAD IT TO A GOOGLE SITE PAGE & WHY
  3. Get a grading rubric from your teacher, if you don’t have one.
  4. Electronic Career Portfolio–YOU WILL HAVE TODAY AND THE NEXT TWO CLASSES TO WORK ON THIS.
  5. DO THE FOLLOWING TODAY!!
    1. Create a RESOURCES page for your electronic career portfolio. Include the following:
      1. Research Report Instructions
      2. Sample MLA Style Research Report
      3. Sample Table of Contents
      4. Sample Title Page
      5. Academic Report Guide–MLA Format
      6. How To Do A Letter of Application
      7. Resume Template Instructions
      8. Sample Resume
    2. IF YOU DO NOT HAVE YOUR RESUME:
      1. Upload the Resume Worksheet & Resume Template Instructions. Work on your resume at home. This is due next class. The more you have done, the easier your assignment will be!! Take a look at the Sample Resume. This is what your’s will eventually look like.
    3. IF YOU DO HAVE YOUR RESUME:
      1. Save it as a PDF and upload the PDF version. (This way only you will be able to EDIT it and EVERYONE will be able to open it regardless of the software they have on their computers.
    4. Do How To Do A Letter of Application–create a generic letter that you can change to fit jobs you will apply for in the future. Upload it to your site.
    5. Add Research Report with Works Cited page–find the one that you created in Apps I on a topic of your choice–add this to either the Introduction to Business Computer Applications I or II class page or to your Sample Work page (or whatever you named it…….)
      1. BE SURE TO SAVE IT AS A PDF FIRST AND THEN UPLOAD THE PDF VERSION.

YOU WILL PRESENT YOUR PORTFOLIO TO YOUR CLASSMATES. YOU CLASSMATES WILL BE YOUR POTENTIAL EMPLOYER. YOU NEED TO CONVINCE US THAT YOU ARE RIGHT FOR THE JOB!! GET YOUR EVALUATION FORM FOR YOUR PORTFOLIO FROM YOUR TEACHER. DRESS PROFESSIONALLY WHEN PRESENTING.

  1. Electronic Career Portfolio–YOU WILL HAVE TODAY AND THE NEXT CLASS TO FINISH THIS.
  2. Get a grading rubric from your teacher, if you don’t have one.
    1. Add Table & Memo to your RESOURCES page
      1. Find a Table and a Memo that you created in this class and upload it to your RESOURCES page. You will need to know how to do each one for the final.
    2. Finish the lesson plan from yesterday
    3. HOW TO ADD MULTIMEDIA OBJECTS TO YOUR GOOGLE SITES WEB PAGE
    4. Add multimeda objects to all your pages:
      1. Animated clipart
      2. Photos of your work
      3. iMovies
      4. etc.

YOU WILL PRESENT YOUR PORTFOLIO TO YOUR CLASSMATES. YOU CLASSMATES WILL BE YOUR POTENTIAL EMPLOYER. YOU NEED TO CONVINCE US THAT YOU ARE RIGHT FOR THE JOB!! GET YOUR EVALUATION FORM FOR YOUR PORTFOLIO FROM YOUR TEACHER. DRESS PROFESSIONALLY WHEN PRESENTING.

  1. Electronic Career Portfolio–FINISH TODAY–PRESENT NEXT CLASS
  2. Get a grading rubric from your teacher, if you don’t have one.
    1. Add work from other classes
    2. Check JMC–add anything you haven’t added to your site (resume, letter of application, table, memo, MLA style report with table of contents, title page, and work cited page)
    3. SEND ME THE LINK TO YOUR SITE SO I CAN GRADE THE ABOVE DOCUMENTS
    4. Remember: this is a PROFESSIONAL site!!
    5. EXTRA CREDIT–look at the FBLA grading rubric–include the career information
  3. YOU WILL PRESENT YOUR PORTFOLIO TO YOUR CLASSMATES. YOU CLASSMATES WILL BE YOUR POTENTIAL EMPLOYER. YOU NEED TO CONVINCE US THAT YOU ARE RIGHT FOR THE JOB!! GET YOUR EVALUATION FORM FOR YOUR PORTFOLIO FROM YOUR TEACHER. DRESS PROFESSIONALLY WHEN PRESENTING.

FINISH & PRESENT CAREER PORFOLIO

  1. Get a grading rubric from your teacher, if you don’t have one.

CHECK JMC & GET ALL ZEROS TURNED IN!!!!

REVIEW FOR FINAL–YOU MAY USE YOUR NOTES!!! GET ORGANIZED!!

Review for final exam. Here is what will be on your final:

  1. Spreadsheet & chart in Google Docs
    1. Create a spreadsheet and be sure you can do the following:
      1. Create a vertical bar chart.
      2. Title the chart
      3. Title the x-axis
      4. Title the y-axis
      5. Find the total using a function.
      6. Find the average using a function.
      7. Share the spreadsheet and chart with me: tracyweber@bellevue.k12.ia.us
  2. Access database: be sure you can do the following:
    1. create a table
    2. use input mask
    3. use lookup wizard
    4. create a query

WHEN YOU ARE COMPLETELY DONE WITH ALL 4 PARTS TODAY (AFTER I CHECK THEM), SAVE THEM AS PDF FILES AND UPLOAD THEM TO YOUR RESOURCES PAGE OF YOUR e-PORTFOLIO!!

  1. MLA style report with Works Cited page and title page.
    1. Report 22 on page 274 in your textbook.
    2. You may use your notes (on the Resources page of your e-Portfolio) and anything else to help you–they are your manuals/references.
    3. This is MLA style–use proper format!!!
      1. All margins = 1 inch
      2. Double space
      3. Remove spacing before & after paragraphs
      4. Times New Roman, 12 font
      5. First 4 lines of the report on page 1:
        1. Your Name
        2. Teacher Name
        3. Class
        4. Date in MILITARY style
      6. Center & use INITIAL caps for the title
      7. Put your last name and the page number in the top right corner of every page
      8. Side Headings (MAJOR SECTIONS OF A REPORT)–ALL CAPS, BOLD, NOT INDENTED
      9. Paragraph Headings (SUB SECTIONS OF THE MAJOR SECTIONS IN A REPORT)–Initial Caps, BOLD, Indented, Period at the end
    4. Format all the references using MANAGE SOURCES & then INSERT CITATION in the RESOURCES tab in WORD– (there are only 2)
    5. Make the last paragraph a bulleted list by having each sentence have a bullet.
  2. Create a NEW FILE for the  title page using the Insert Cover Page in Word 2010
    1. FYI: The title page and table of contents page should be saved as different FILES, but the Works Cited page should be included as a new PAGE in the REPORT file (R22 file).
  3. Create a NEW FILE for the Table of Contents page:
    1. Use References Tab
    2. Table of Contents
    3. Manual Table of Contents
    4. The Table of Contents page should use the SIDE & PARAGRAPH headings and the pages numbers from the report. Format the table of contents page to match the report (margins, font size, style, & color), be sure everything lines up–you may have to adjust indent markers.
      1. FYI: The title page and table of contents page should be saved as different files, but the Works Cited page should be included as a new PAGE in the REPORT file (R22 file).
  4. Works Cited Page:
    1. Go to the end of the REPORT file (report 22)
    2. insert a page break
    3. go to the References tab
    4. click Bibliography and choose Works Cited
    5. Format the works cited page so it matches the report: font size, style, color, etc.

Show me all FOUR parts when you are completely finished.

  1. Table & Memo
    1. Create a NEW file.
    2. Choose a MEMO TEMPLATE to use.
    3. Compose a memo to Mrs. Weber and tell her about what you learned this semester that was most valuable to you.
    4. Include a table in the memo. Be sure to do the following to the table:
      1. Horizontally center it.
      2. Include a title that is merged & centered
      3. Include column headings
      4. Include a column of numbers
      5. Include a formula to calculate the total.
  2. Letter in block style with envelope
    1. Complose a bock style letter to Mrs. Weber and tell her about what you learned this semester that was most valuable to you.
    1. Create a NEW file
    2. VERTICALLY center
    3. Line spacing–single
    4. Remove spacing before & after paragraphs
    5. INSERT the date
    6. Hit enter 4 times
    7. Type the name & address of the person RECEIVING the letter (Mrs. Weber, 1601 State Street, Bellevue, IA 52031)
    8. Hit enter 2 times
    9. Type the SALUTATION (Dear Mrs. Weber:)
    10. Hit enter 2 times
    11. Type at least 2 paragraphs–hit enter 2 times after each paragraph
    12. After the last paragraph, type the COMPLIMENTARY CLOSING (Sincerely,)
    13. Hit enter 4 times
    14. Type your name & address
    15. CTRL-HOME to go to the beginning of the file
    16. Click the Mailings tab
    17. Click ENVELOPES
    18. Be sure to include the proper information in the proper places.
    19. ADD TO DOCUMENT

BEGIN FINAL EXAM:

In Word, compose a letter that you would like to send to a teacher of your choice thanking them for something they did for you. Be sure to include the following:

  1. 3 paragraphs with 3-5 sentences in each paragraph
  2. The letter should be block style
  3. The letter is from you.
  4. The high school address is: 1601 State Street, Bellevue, IA 52031
  5. Be sure to include a properly addressed envelope.
  6. SHOW ME WHEN YOU ARE DONE

GET THE HANDOUT FROM YOUR TEACHER FOR THE REMAINDER OF YOUR TEST:

BEGIN: PARTS I & II–Spreadsheet & Database–SHOW ME EACH PART WHEN YOU ARE DONE

  1. FOLLOW THE STEPS BELOW FOR SCREENR CREATE A SCREENCAST
  2. Create a Youtube channel for yourself to upload your video clips to. Create it using your Google Account.
  3. Get into Internet Explorer
  4. Go to www.screenr.com
  5. Click to register/login with your Google Account
  6. Use your Google Account name as your login name.
  7. Click to get Java, if you are asked.
  8. Before you begin, click HELP at the bottom of your screen and READ.
  9. Scenario: You have been hired as an expert in Google Docs to create an instructional video that will show teachers how to create, share, and edit shared docs using Google. This video will be distributed to all teachers in the Bellevue Community School District as a resource for them to use. Here are the goals of this project:
    1. All teachers will understand how to access their Google Account
    2. All teachers will understand how Google Docs saves their files.
    3. All teachers will understand how to create a Google Doc.
    4. All teachers will understand how to share a Google Doc.
    5. All teachers will understand how to access and edit a Google Doc that someone else shared with them.
  10. A clip is only 5 minutes in length. Here are some suggestions:
    1. Create an outline first
    2. You will need to record and record several times…….be patient and persistent!!!
    3. Create written instructions BEFORE recording and refer to them as you record.

 

Use Jing to create an instructional video clip for teachers on how to create a Google Doc and share it and then how to open a Google Doc that was shared with them. CREATE A SCREENCAST

  1. FOLLOW THE STEPS BELOW TO GET JING ON YOUR MACHINE:
    1. www.techsmith.com/jing.html
    2. Click FREE DOWNLOAD
    3. click START WINDOWS DOWNLOAD
    4. SAVE or RUN
    5. click the download file, if necessary, in the lower left corner of your Internet window.
    6. RUN
    7. click NEXT as many times as needed.
    8. FINISH
    9. click GET STARTED
    10. create a new account
  2. LEARN JING
    1. www.techsmith.com/tutorial-jing.html
    2. Click to watch: TAKE YOUR FIRST CAPTURE
    3. Do practice video clip of your own to see how it works
    4. Upload it to screencast.com
    5. Click to view it on screencast.com
  3. Scenario: You have been hired as an expert in Google Docs to create an instructional video that will show teachers how to create, share, and edit shared docs using Google. This video will be distributed to all teachers in the Bellevue Community School District as a resource for them to use. The clip can only be 5 minutes in length. An instructional handout needs to accompany the video clip. Here are the goals of this project:
    1. All teachers will understand how to access their Google Account
    2. All teachers will understand how Google Docs saves their files.
    3. All teachers will understand how to create a Google Doc.
    4. All teachers will understand how to share a Google Doc.
    5. All teachers will understand how to access and edit a Google Doc that someone else shared with them.
  4. A clip is only 5 minutes in length. Here are some suggestions:
    1. Create written instructions BEFORE recording and refer to them as you record.
    1. You will need to record and record several times…….be patient and persistent!!!
  5. GOAL FOR TODAY: Create the step by step instruction sheet. Here are some things to consider:
    1. Use numbered lists
    2. Divide the handout into sections:
      1. How to Access Your Google Account
      2. How to Create a Google Doc
      3. How to Share a Google Doc
      4. How to Access and Edit a Shared Google Doc
    3. Keep it simple.
    4. Include EVERYTHING
    5. It should only be 1 side of 1 page.
    6. This will be distributed to all teachers: make sure it is ERROR-FREE!!!
    7. Put your name at the end.
  1. SkyDrive and Office Web Apps
  2. Google Applications for Business
  3. Google Apps and Their Use in Business
  4. Google Docs to Improve Productivity
  5. Evernote
  6. ePortfolio

 

Lesson 142 Assignment:
(You will create ONE DATABASE, but each activity will have you creating TABLES for this ONE DATABASE)

  1. Activity 1–Show me
  2. Activity 2–Formatting grade
  1. Activity 8
    1. Create a lookup wizard for the Minimum Credentials field. The options to pick from should be: Bachelor’s Degree, Associate’s Degree, Master’s Degree
    2. Show your teacher
  2. Complete the following:
    1. Activity 6
    2. Activity 7–Upload to Edmodo.
    3. Activity 8
      1. Create a lookup wizard for the Minimum Credentials field. The options to pick from should be: Bachelor’s Degree, Associate’s Degree, Master’s Degree
      2. Show your teacher
    4. Activity 9
      1. Create a lookup wizard for the Binding field. The options to pick from should be: hardcover, papercover
      2. Upload to Edmodo
    5. Activity 10
      1. Use an input mask for the date
      2. Show your teacher
  3. Complete Lesson 142 Assignment:
    1. Activity 1–Show me
    2. Activity 2–Formatting grade
    3. Activity 3
      1. Be sure to open the ACTIVITIES database
      2. Best fit all columns
      3. Print Preview so you know everyting fits on 1 page for the table
      4. Print the table and WRITE “Activity 3” on your printout
      5. Put it on black cart
    4. Activity 5

Finish Activities 3-5

  1. Activity 6

 

Be sure to the following to every assignment:

  1. Put your name in the header
  2. Put the filename in the header
  3. Put the exercise name in the header
  4. Get all information to fit on 1 page
  1. Skills Assessment 1–Just do it.
  2. Skills Assessment 2–Print Preview.Show me.
  3. Skills Assessment 3–Print as instructed. Label it with your name and exercise name.
  4. Skills Assessment 4–turn in the memo through Edmodo–you will USE this for one of the challenges, so help yourself out and be thorough when doing this.
  5. Skills Assessment 5–Print as instructed. Label it with your name and exercise name.
  6. Challenge 1–Print after #5. Label it with your name and exercise name.
  1. Complete Section 1 Today!
  2. Hands On Test: Challenge 2 on page 420

Yes, you are creating a WORD file! Use tables.

Read all the directions thoroughly and make sure you are meeting the requirements for every piece of instruction on page 420.

You are in the DESIGN phase of creating a database. It is important when you are creating a database from scratch that the layout of the database is well thought out before you actually get into Access and begin creating tables and adding fields. Deciding on fieldnames that make sense is a critical part of desiging a database. BE SURE TO READ THE BULLETED ITEMS IN #2!

#1–1st bullet–instead of using spaces use an underscore. For example: the name for your first table will probably be customer_information.

#2–2nd bullet means to put a person’s first name in a field by itself as well as their last name in a separate field as opposed to putting their first and last names in one field.

The contract_seamstress table will be similar to the customer_information table.

Here are some helpful hints for the order_information table:

customer for whom costume is being made–REMEMBER TO USE UNIQUE FIELD NAMES! You will use similar field names here as you did in the customer_information field. For example: customer_first_name

Seamstress–refer to the item above. Use a uniquie field name!! For example: seamstress_first_name.

Estimated hours for all 3 centers. For example: est_hrs_research. Also be sure to read the additional notes at the bottom of page 420. For example: actual_hrs_research.

Read the first additional note at the bottom of page 420. This will most likely be a checkbox field indicating they signed the contract. You just need to come up with a name for the field for now.

ship_to_information table:

Be sure to use the same field names you used in the other tables as much as possible

You will create FOUR tables. PRINT the WORD file when you are done. It should fit on 1 page. Here is an example on how I would create table 1:

Table: Customer_information

Customer_first_name
Customer_last_name
Customer_street_address
Customer_city
Customer_state
Customer_zip
Customer_home_phone
Customer_work_phone
Customer_cell_phone
  • Hands On Test: Challenge 2 on page 420Yes, you are creating a WORD file! Use tables.Read all the directions thoroughly and make sure you are meeting the requirements for every piece of instruction on page 420.You are in the DESIGN phase of creating a database. It is important when you are creating a database from scratch that the layout of the database is well thought out before you actually get into Access and begin creating tables and adding fields. Deciding on fieldnames that make sense is a critical part of desiging a database. BE SURE TO READ THE BULLETED ITEMS IN #2!#1–1st bullet–instead of using spaces use an underscore. For example: the name for your first table will probably be customer_information.#2–2nd bullet means to put a person’s first name in a field by itself as well as their last name in a separate field as opposed to putting their first and last names in one field.The contract_seamstress table will be similar to the customer_information table.Here are some helpful hints for the order_information table:customer for whom costume is being made–REMEMBER TO USE UNIQUE FIELD NAMES! You will use similar field names here as you did in the customer_information field. For example: customer_first_nameSeamstress–refer to the item above. Use a uniquie field name!! For example: seamstress_first_name.Estimated hours for all 3 centers. For example: est_hrs_research. Also be sure to read the additional notes at the bottom of page 420. For example: actual_hrs_research.Read the first additional note at the bottom of page 420. This will most likely be a checkbox field indicating they signed the contract. You just need to come up with a name for the field for now.ship_to_information table:Be sure to use the same field names you used in the other tables as much as possibleYou will create FOUR tables. PRINT the WORD file when you are done. It should fit on 1 page. Here is an example on how I would create table 1:Table: Customer_information
Customer_first_name
Customer_last_name
Customer_street_address
Customer_city
Customer_state
Customer_zip
Customer_home_phone
Customer_work_phone
Customer_cell_phone

Access Section 2

    • Read and look at the examples on pages 383-387
    • Activity 2.1
      1. Read and do pages 388-389
      2. Be sure to read the blue text at the bottom of page 388–VERY IMPORTANT!!
      3. What are primary keys and why are they important?
      4. Show me your document in #7 on page 389
      5. Can you use a space in a field name?
    • Activity 2.2
      1. Read and do pages 390-393
      2. Is it important how you enter a date?
      3. What is the difference between Design View and Datasheet View?
      4. Do not print
    • Activity 2.3
      1. Read and do page 394-395
      2. Why should you use a description?
      3. Be sure to read the In Addition at the bottom of page 395–helpful!
    • Activity 2.4
      1. Read and do pages 396-397
      2. In the field properties, what is caption?
      3. What is default value?
      4. What happens if a person tries to enter data into a field and the data is too long? Field size is 4 and you enter 6 items?
    • Activity 2.5
      1. Read and do pages 398-399
      2. What is a validation rule?
      3. Is it important about entering Validation Text?
      4. Read the In Addition at the bottom of page 399–VERY HELPFUL!!!
    • Activity 2.6
      1. Read and do pages 400-401
      2. What is an input mask?
      3. In which fields can you use the Input Mask Wizard?
    • Activity 2.7
      1. Read and do pages 402-403
      2. What is a lookup wizard and why would you use one?
      3. Useful Information–In Addition on page 403
    • Activity 2.8
      1. Read and do pages 404-405
      2. How do you move, insert and delete fields?
      3. How to you insert a total?
      4. What can you do when you are working with wide datasheets?
    • Activity 2.9–DO THIS SECTON SLOWLY!!!!! UNDERSTAND IT!! ASK QUESTIONS!!!!
      1. Read and do pages 406-407
      2. What is a relational database?
      3. What must you always be sure of when you want to join 2 tables?
    • Activity 2.10
      1. Read and do pages 408-409
      2. Which table should always be the primary table–the one with only 1 record per person or with possibly more than 1 record per person?
      3. How is a relationship created?
      4. How is a one-to-many relationship formed?
      5. What is referential integrity and how does it relate to orphan records?
    • Activity 2.11
      1. Read and do pages 410-411
      2. How is a one-to-one relationship formed?
    • Actvitiy 2.12
      1. Read and do pages 412-413
      2. Why would you print a relationships report?
      3. What is a subdatasheet?
    • Access Section 2 Assignments:
      1. Knowledge Check–Share with me in a Google Doc
      2. Skills Review 1–Do not print–SHOW ME
      3. Skills Review 2–Do not print–SHOW ME
      4. Skills Assessment 1–Show me
      5. Skills Assessment 2–Show me
      6. Skills Assessment 3–Show me
      7. Skills Assessment 4–Print as instructed
      8. Skills Assessment 5
        1. Include as many different field types as possible.
        2. Use Input Mask
        3. Use Lookup Wizard
      9. Challenge 1–Show me
  1. Work on Access Section 2 assignments
  1. Knowledge Check–Share with me in a Google Doc
  2. Skills Review 1–Do not print–SHOW ME
  3. Skills Review 2–Do not print–SHOW ME
  4. Skills Assessment 1–Show me
  5. Skills Assessment 2–Show me
  6. Skills Assessment 3–Show me
  7. Skills Assessment 4–Print as instructed
  8. Skills Assessment 5
    1. Include as many different field types as possible.
    2. Use Input Mask
    3. Use Lookup Wizard
  9. Challenge 1–Show me
  1. Work on Access Section 2 assignments
  1. Knowledge Check–Share with me in a Google Doc
  2. Skills Review 1–Do not print–SHOW ME
  3. Skills Review 2–Do not print–SHOW ME
  4. Skills Assessment 1–Show me
  5. Skills Assessment 2–Show me
  6. Skills Assessment 3–Show me
  7. Skills Assessment 4–Print as instructed
  8. Skills Assessment 5
    1. Include as many different field types as possible.
    2. Use Input Mask
    3. Use Lookup Wizard
  9. Challenge 1–Show me
    1. Complete Access Section 2–Text next class

Access Section 2 Test

Access Section 2 Hands On Test

Finish Access Section 2 Hands On Test–Challenge

  1. Finish C2 for Access Section 2
  2. You are an employee of Microsoft. It is your job to get businesses to use Access databases. Compose a persuasive letter to an area business explain at least 3 different reasons as to why they should use an Access database. Create the letter in Word and share it with me through Edmodo (create a NOTE and attach the file to the Note).
  3. Article Summary

GO BACK TO THE WORD 2010 TUTORIAL AT LEARNFREE.ORG and do RUNNING QUERIES AND REPORTS AND DATABASE DESIGN TIPS

  1. Access Section 3 Activities 3.1 to 3.6
    1. Read and look at pages 423-429
      1. What is the difference between a form, report, and query?
    2. Activity 3.1
      1. Read and do pages 430-431
      2. What is a query?
      3. What does a query do?
      4. Can you save a query?
    3. Activity 3.2
      1. Read and do pages 432-433
      2. What command executes a saved query?
      3. What is the difference between a Simple Query Wizard and creating a query in design view?
    4. Activity 3.3
      1. Read and do pages 434-435
    5. Activity 3.4
      1. Read and do pages 436-437
      2. What does a criterion statement do in the query design grid?
      3. How do you hide columns in a query?
      4. What does Access automatically insert for text fields?
      5. What does Access automatically insert for date fields?
      6. Be sure to read the In Addition at the bottom of page 437.
    6. Activity 3.5
      1. Read and do pages 438-439
      2. Read and understand the In Addition at the bottom of page 439
    7. Activity 3.6
      1. Read and do pages 440-441
      2. What is the difference between using AND and OR?
      3. Read the In Addition at the bottom of page 441.
  1. Access Section 3 Activities 3.7 to 3.12
  2. Activity 3.7
    1. Read and do pages 442-443
    2. When entering a formula for a query, what type of syntax needs to be used?
    3. Can you format answers given due to including a formula in a query?
  3. Activity 3.8
    1. Read and do pages 444-445
    2. What is a form?
    3. What is the purpose to using a form?
    4. Forms consist of a series objects called……
    5. How do you create a form?
  4. Activity 3.9
    1. Read and do pages 446-447
    2. Why would you add a field from another table to a form and how?
  5. Activity 3.10
    1. Read and do pages 448-449
    2. How do you shorten controls?
    3. Why do you shorten controls?
    4. What is a label control object?
  6. Activity 3.11
    1. Read and do pages 450-451
    2. What is a report in Access?
    3. Why do you use a report in Access?
  7. Activity 3.12
    1. Read and do pages 452-453
    2. In what view can a form be modified?
    3. What is printed on all reports?
    4. What are the 5 sections of a report?
  8. What would motivate you (or another classmate) to de better, either in this class or school, in general, or both? Share with me in a Google Doc.
  9. Access Section 3 Knowledge Check

Access Section 3 Skills Review 1-3

  1. Access Section 3 Skills Assessment 1-5

Access Section 3 Challenge 1-2

Complete Access Section 3

Work on completing Access Section 3

Field Trip

Complete Access Section 3

Work on completing Access Section 3

Test next class

Access Section 3 Test

Access Section 3 Test

Access Hands On Test

Access Hands On Activity

Finish Access Hands On Activity

You must begin PowerPoint section 1 today!

  1. PowerPoint Section 1–Read pages 467-475 for an overview of the unit
  2. Activity 1.1–Read and do pages 476-479
    1. You may print the outline. You will never print slides on a page by themselves.
  3. Activity 1.2–Read and do pages 480-483
    1. What is a live preview?
    2. Try all the Insertion Point Movement Commands in Table 1.2
    3. What does TAB and SHIFT-TAB do?
  4. Activity 1.3–Read and do pages 484-485
    1. Be sure to read the In Addition at the bottom of page 485–EVERYONE NEEDS TO KNOW THIS!!
  5. Activity 1.4–Read and do pages 486-487
    1. What is Reading View and when should it be used?
  6. Activity 1.5–Read and do pages 488-489
    1. Be sure to read the In Addition at the bottom of page 489
  7. Activity 1.6–Read and do pages 490-491
  8. Activity 1.7–Read and do pages 492-495
  9. Activity 1.8–Read and do pages 496-499
    1. Does the mouse pointer have to be visible when presenting? Explain.
  10. Activity 1.9–Read and do pages 500-501
    1. Read and try the In Addition at the bottom of page 501
  11. Activity 1.10–Read and do pages 502-503
    1. Print every time you are instructed so you can see what happens.

PowerPoint Section 1 Assignments:

  1. Knowledge Check–submit in a Google Doc
  2. Review 1–Print as instructed. Include your name and Review 1 in the header
  3. Assessment 1–Show me for a grade
  4. Assessment 2–Print according to directions in #4
  5. Assessment 3–Show me.
  6. Assessment 4–Show the class. Pretend like we are your clients and you want us to book a vacation to Cancun from you. This is suppose to be a PROFESSIONAL presentation.
  7. Challenge 1–Print according to the directions with your name and challenge 1 in the header
  8. Challenge 2–Print according to the directions with your name and challenge 2 in the header
  9. Complete PowerPoint Section 1 Assignments:
    1. Knowledge Check–submit in a Google Doc
    2. Review 1–Print as instructed. Include your name and Review 1 in the header
    3. Assessment 1–Show me for a grade
    4. Assessment 2–Print according to directions in #4
    5. Assessment 3–Show me.
    6. Assessment 4–Show the class. Pretend like we are your clients and you want us to book a vacation to Cancun from you. This is suppose to be a PROFESSIONAL presentation.
    7. Challenge 1–Print according to the directions with your name and challenge 1 in the header
    8. Challenge 2–Print according to the directions with your name and challenge 2 in the header

Finish PowerPoint Section 1 Assignments:

  1. Knowledge Check–submit in a Google Doc
  2. Review 1–Print as instructed. Include your name and Review 1 in the header
  3. Assessment 1–Show me for a grade
  4. Assessment 2–Print according to directions in #4
  5. Assessment 3–Show me.
  6. Assessment 4–Show the class. Pretend like we are your clients and you want us to book a vacation to Cancun from you. This is suppose to be a PROFESSIONAL presentation.
  7. Challenge 1–Print according to the directions with your name and challenge 1 in the header
  8. Challenge 2–Print according to the directions with your name and challenge 2 in the header

TEST NEXT CLASS!

.

.

POWERPOINT SECTION 1 TEST

PowerPoint Section 2:

Complete Activities 2.1 to 2.11

Show your PowerPoint section 1 A4 to the class. Present it like a professional travel agent.

PowerPoint Section 2 Assignments:

  1. Knowledge Check–Turn in through a Google Doc
  2. Skills Review 1–Show me–no grade
  3. Skills Review 2–Show me–no grade
  4. Assessment 1–Print according to directions with your name in the header
  5. Assessment 2–Print according to directions with your name in the header
  6. Assessment 3–SPrint according to directions with your name in the header
  7. Assessment 4–Show it to the class.
  8. Challenge 1–Print as instructed with your name in the header.
  9. Challenge 2–Print as instructed with your name in the header.

PowerPoint Section 2 Assignments:

  1. Knowledge Check–Turn in through a Google Doc
  2. Skills Review 1–Show me–no grade
  3. Skills Review 2–Show me–no grade
  4. Assessment 1–Print according to directions with your name in the header
  5. Assessment 2–Print according to directions with your name in the header
  6. Assessment 3–SPrint according to directions with your name in the header
  7. Assessment 4–Show it to the class.
  8. Challenge 1–Print as instructed with your name in the header.
  9. Challenge 2–Print as instructed with your name in the header.

PowerPoint Section 2 Assignments:

  1. Knowledge Check–Turn in through a Google Doc
  2. Skills Review 1–Show me–no grade
  3. Skills Review 2–Show me–no grade
  4. Assessment 1–Print according to directions with your name in the header
  5. Assessment 2–Print according to directions with your name in the header
  6. Assessment 3–SPrint according to directions with your name in the header
  7. Assessment 4–Show it to the class.
  8. Challenge 1–Print as instructed with your name in the header.
  9. Challenge 2–Print as instructed with your name in the header.
  10. PowerPoint Section 2 Assignments:
    1. PowerPoint Section 2 Assignments:
      1. Knowledge Check–Turn in through a Google Doc
      2. Skills Review 1–Show me–no grade
      3. Skills Review 2–Show me–no grade
      4. Assessment 1–Print according to directions with your name in the header
      5. Assessment 2–Print according to directions with your name in the header
      6. Assessment 3–SPrint according to directions with your name in the header
      7. Assessment 4–Show it to the class.
      8. Challenge 1–Print as instructed with your name in the header.
      9. Challenge 2–Print as instructed with your name in the header.

.

TEST NEXT CLASS

Complete PowerPoint Section 2 Assignments

PowerPoint Section 2 Test

Present A4 to the class

Word, Excel, Access, and PowerPoint Integrated

Look at the examples on pages 553-563

Read and do pages 564-585

Word, Excel, Access, and PowerPoint Integrated

Assignments (show me all of them):

Review 1

Review 2

Review 3

Review 4

Review 5

Review 6

Review 7

Review 8

Word, Excel, Access, and PowerPoint Integrated

Assignments (show me all of them):

Review 1

Review 2

Review 3

Review 4

Review 5

Review 6

Review 7

Review 8

LETS TALK ABOUT THE BAKE SALE

Look at the examples on pages 553-563

Read and do pages 564-585

Assignments:

Review 1

Review 2

Review 3

Review 4

Review 5

Review 6

Review 7

Review 8

Integrating Project

Invitations & List of names & addresses

Integrating Project

Complete List of names & addresses

Expense Spreadsheet & Chart

Integrated Project

Expense Spreadsheet & Chart

Integrated Project: Presentation

Review: Word

Integration: Mail Merge using Word & Access

Business Letter Activity

Integration: Mail Merge using Word & Access

Graduation Party Activity

Review:

Access & PowerPoint

Word & Excel

  • Access
  • PowerPoint
  • Integrated Portion of Final:
    • In a meaningful way, integrate:
      • Word & Excel
      • Word & Access
      • Access & Excel
      • PowerPoint & Word
    • Send the integrated file to me in a note in Edmodo. Explain in the note what you did to integrate the files.

http://www.brainshark.com/mybrainshark–use with Advanced

Computer Applications for PowerPoint

Review:

Finish Word & Excel

  1. Memorial Day Assignment
  2. Information:
    1. Picture–Be sure to crop it.
    2. Memorial Tableau
    3. Monday, May 31
    4. 10:15 A.M.
    5. 2010
    6. Additional Program:
      1. The High School Band
      2. ‘Roll Call of the Dead’
      3. Wreath on the River
      4. Names added this year
      5. TAPS
      6. Address
      7. Comments
      8. Colors Retired
      9. ‘National Anthem’
    7. Inclement Weather: The Elementary Gym
    8. Presented by Bellevue American Legion Post 273
  3. Complete the following (CHECK JMC TO SEE IF YOU NEED TO TURN THESE ASSIGNMENTS IN–THEY ARE DUE TODAY!!!):
      1. Do Report 36–Use the example on the wall. Just type it and check it. Remember your errors so you can correct them when you do Report 37.
      2. Do Report 37–Remember to select OPEN R36 to CREATE R37!!! Make any corrections from Report 36
      3. Do Report 38–Remember to select OPEN R37 to CREATE R38!!! Make any corrections from Report 37–Use the example–Send it to me as an email attachment. Send it to: tweber@bellevue.k12.ia.us for a Proofreading Grade–10 points
      4. Do Report 39—-Remember to select OPEN R33 to CREATE R39!!! Put your name in the header–use the example–send it to me as an email attachment to tweber@bellevue.k12.ia.us for a grade.
    1. Lesson 104 in the Keyboarding textbooks & KCA
      1. Read and do pages 113-115 in the Student Manual. Here are some helpful hints:
        1. For #4 on page 115 put your cursor in the blank line below the city, state and zip line in the second address and use the Format menu to set the tab. Be sure it is a right tab.
        2. For #7 use the Shapes button in your Insert ribbon, choose Lines and then either Curve or Scribble. Draw the circle (see the example). When you complete the circle it appears that the text is gone, it is not. Right click on the shape you drew and choose Order and then Send Behind Text. You will need to do this in your assignment as well.
      2. Report 40, Lesson 104–Here are some helpful hints:
        1. REMEMBER TO CLICK ON OPEN R33 TO CREATE R40!!
        2. The document is vertically centered. If you leave the vertical centering on, you will have a difficult time completing the assignment. Change the vertical alignment to top, complete all the instrucitons, then change the vertical alignment back to center.
        3. #4 When you draw the shape, it may cover up the text. You can right click on the shape, choose Order, and then Send to Back or Send Backward OR you can change the fill for the shape to NO FILL (use the paint can)
      3. Report 41, Lesson 104–More helpful hints:
        1. REMEMBER TO CLICK ON OPEN R38 TO CREATE R41!!!
        2. #3–Use your ruler on the right side of your screen–if you can’t see your ruler, go to the View ribbon
        3. Experiment and help each other out with #6. YOU CAN FIGURE IT OUT!!! HINT: Go to the Bullets button and click the down pointing arrow–that will get you started
        4. Use the example
        5. PRINT with your name and REPORT 41 in the header
      4. Report 42, Lesson 104–REMEMBER TO OPEN R40 TO CREATE R42
        1. Set a left indent at 1.5–use the indent markers in your ruler
        2. Remember to turn off the vertical centering and then turn it back on!
        3. #4–Use your ruler to help you–the one at the top of your screen–where the blue meets the white is where the margins are set.
        4. Print with your name and REPORT 42 in the header
      5. TIMINGS! Leave a note on my desk if you get any good ones.

    Today you will have the opportunity to work with Word as a desktop publishing tool. Before you leave class today be sure you know how to do the following:

    • Create a shape according to certain size requirements by using your rulers in Word
    • Create a perfect circle/square
    • Group objects
    • Place an object in front or behind another object

    1. Do Lesson 105 in your textbook & KCA

    1. Read and do student manual pages 116-119
      1. Make sure you choose Software Features from Lesson 105 in KCA to get there.
      2. Use the examples to help you.
      3. #4–To type inside the shape, see the top of page 119 (#3)
      4. #6–Use the Tooltip to see the actual names of each shape by just pointing at it.
    2. Do Report 43
      1. To make a perfect circle or square, hold down the SHIFT key when drawing the circle.
      2. Use your vertical and horizontal RULERS on your screen to help estimate the sizes.
      3. Use the example.
      4. After you have created your snowman, group all of the objects to make your snowman ONE piece, so that when you try to move him, you don’t have to move all the parts, you just have to move one. Here is how you do it:
        1. In the Drawing toolbar, click on the BIG WHITE ARROW next to the Draw button. When you click and drag with this arrow, it will select everything you drag over. Click way up in the upper left corner of your file and drag all the way down to the lower right corner of your file. Let go of the mouse button. Everything in your picture should be selected. If it is not, retry it.
        2. When everything is selected, click on the DRAW button in your drawing toolbar. Select GROUP. You may have to click on the arrows at the bottom so you can see all the options in the menu.
        3. Now move your snowman. He should be all one piece!
    3. Heritage Days Button
    1. Use your creative talents and your Word Desktop Publishing skills! Create your entry for the 2010 Bellevue Heritage Days button!
      1. Draw 2 circles–one circle should be 2.75″ and the other should be 2.25″
      2. Make your design inside the SMALLER circle
      3. Use a picture of Bellevue
      4. Use the words: Bellevue Heritage Days July 3-4, 2010
      5. Put your name in the footer or header and print it BEFORE YOU LEAVE TODAY!

    Heritage Days Button

    1. Use your creative talents and your Word Desktop Publishing skills! Create your entry for the 2010 Bellevue Heritage Days button!
      1. Draw 2 circles–one circle should be 2.75″ and the other should be 2.25″
      2. Make your design inside the SMALLER circle
      3. Use a picture of Bellevue
      4. Use the words: Bellevue Heritage Days July 3-4, 2010
      5. Put your name in the footer or header and print it BEFORE YOU LEAVE TODAY!

    Today you will be using Word as a desktop publishing tool. Make sure you know how to do the following before you leave today:

      • How to add text to a shape
      • How using textboxes in a desktop publishing file is better that not using one

    1. Begin Lesson 106 in your textbook & KCA

    1. Lesson 106 in your student manual–Here are some instructions for the file practice106
      1.  Instructions in box #1
      2. If you hold down the SHIFT key you will make a perfect square.
      3. Use the ruler to help you make a 2 inch square.
    2. Instructions in box #2
      1. Look at your Drawing toolbar and find the textbox button.
      2. To create a default textbox–click on the textbox button in your drawing toolbar and then click one time in your file.
    3. Instructions at the bottom of the file
      1. You will almost NEVER, in the real world, place a picture inside a textbox because when you place a picture inside a textbox you cannot change the black handles to white and freely move the picture. The ONLY TIME you would ever want to place a picture inside a textbox is when you want to include a caption below the picture like they do in magazines.
      2. Follow the instructions under GRAPHIC OR FIGURE BOXES on pages 122-123 in your student manual on how to place a picture in a textbox.
      3. Once the picture is in the textbox, click on it and resize it so it is small enough to fit the box.
      4. Next, type the caption. Here is how you do it (this can be a little tricky):
        1. Try clicking INSIDE the box, just to the right of the picture–between the textbox border and the picture.
        2. Once your cursor is flashing INSIDE the box, hit enter and type something.
        3. You can center the text and the picture inside the textbox to make it look nice.
    4. Reports 45 & 46–Print Report 46–10 points
      1. ADDITIONAL INSTRUCTIONS FOR #3 IN REPORT 46: Place a caption of some kind below the picture.

    1. Lesson 107 in your KCA textbook

    Report 47–Follow the instruction in your textbook. Use the example. Correct any errors you may have after you check it. Do not print or send to me by email. Just do it.

    Report 48–You DO NOT have to put the picture in a textbox. Just insert a piece of clipart. Remember to change the WRAPPING OF THE PICTURE! Do not print or send to me by email. Just do it.

    Report 49–Follow all the instructions in your book. Raise your hand so I can grade it off your screen–10 points.

    1. Bleacher Blowout Program
    2. Keyboarding Textbook–Lesson 108
      1. Read page 393 D. Wrapping Text at the top of the page
      2. Report 50–Print with name in header
        1. The paragraph you need to type is at the top of page 394 in your text.
        2. The smiley used in this report is a SYMBOL. Remember how to insert a symbol? If not, go back in your student manual until you figure it out!
        3. Remember, we did not put a picture in a textbox, so you will have to delete the clipart & insert a new textbox as shown.
        4. Print with your name in the header
      3. Report 51–Print with name in header
        1. #1–Make sure the fill covers the entire inside of the textbox!
        2. Use the example.
        3. Print with your name in the header

    Bleacher Blowout Program

      • Keyboardinng Textbook Lessons 112-114
        1. Report 58–Follow the directions as shown. Print with your name in the header. USE TEXTBOXES!!!!!! Make it look professional! This should be something that you would be proud to have several copies made in order to be used by a real business. It should be ERROR-FREE!!!!
        2. Report 59–Use the directions as a guide, but make it look like the example. Additional instructions:
          1. Put ALL TEXT in a TEXTBOX. Some of the textbox do not have lines showing, you must make sure your same textboxes do not have lines showing (HSK’s Job Forum Linking Marketing, Professionals With Retail Careers textboxes)
        3. Report 60–Follow the instructions & print with your name in the header. Again, this should be PROFESSIONAL!!!!! It should look identical to the picture in your book. ERROR-FREE!!!!
        4. Report 61–Use the directions as a guide, but make it look like the example. Additional instructions:
          1. Put ALL TEXT in a TEXTBOX. Some of the textboxes do not have lines showing, you must make sure your same textboxes do not have lines showing.
          2. Print with your name in the header
          3. MAKE THIS PROFESSIONAL LOOKING. BE SURE TO MAKE IT APPEAR BALANCED ON THE PAGE!! EQUAL AMOUNTS OF WHITE SPACE!!!!
        5. Read the Portfolio Activity at the bottom of page 413 and DO IT!!!!! Print a copy with your name on it and hand it in!!!
    1. Moodle on the Advanced Computer Applications forum.
    2. Keyboarding Textbook Lessons 116-119–USE THE STUDENT MANUAL TO HELP YOU!!!!
      1. Report 64
      2. Report 65
      3. Report 66
      4. Report 67
      5. Report 68
      6. Report 69
    3. Timings

    Complete:

    1. Report 64
    2. Report 65
    3. Report 66
    4. Report 67
    5. Report 68
    6. Report 69
    7. PRINT BOTH 68 & 69 WITH YOUR NAME IN THE HEADER & STAPLE TOGETHER & HAND IN!!!!!! Make sure they both fit on 1 page and be sure they look “professionally done” and “pleasing to the eye.”

    3. Take timings

    Complete:

    1. Report 64
    2. Report 65
    3. Report 66
    4. Report 67
    5. Report 68
    6. Report 69
    7. PRINT BOTH 68 & 69 WITH YOUR NAME IN THE HEADER & STAPLE TOGETHER & HAND IN!!!!!! Make sure they both fit on 1 page and be sure they look “professionally done” and “pleasing to the eye.”

    Complete the following:

    Reports 68 & 69–Print both with your name in the footer

    Make up work!

    1. We will begin applying for a job at Ozark Zoological Park!
      1. In the Ozark Zoological Park booklet, we will read pages 1-5. You are going to apply for the position at the bottom of page 5.
      2. Open the following files and save them to your drive. You will need them next class:
        1. How to Type a Letter of Application
        2. How to Create a Resume Using Word’s Resume Templates
    2. Take a five minute timings–Let your teacher know if you have 5 errors or less!
    3. Upload the Resume Worksheet to Google Docs. Work on it at home. This is due next class. The more you have done, the easier your assignment will be!! Take a look at the Sample Resume. This is what your’s will eventually look like.

    Good morning! Today we will continue our quest to obtain the volunteer position with Ozark Zoological Park. Let’s do the following:

    1. Complete the letter of application.
      1. Remember: this is a personal business letter and you are sending your resume with the letter. Use your Reference Manual in the back of your booklet to help you format the letter. Hint: Enclosure
      2. Create an envelope using OCR for the letter of application
      3. Be sure it is error-free and print it. Each error will drop you a letter grade!
      4. Remember: Only feed the printer paper or envelopes when it asks for that particular item. If you feed it paper when it wants an envelope, it will print the envelope on a regular piece of paper–we don’t want to do that!
    2. Create your resume using a Resume Template in Word.
      1. Open the Resume Template Instructions handout that you saved to your drive last class. Follow the instructions on the handout to create your own resume. Suggestion: Also open your resume from Introduction to Computer Applications I to get your information (it might be saved at Report 16 in your KCA folder).
      2. Use the Sample Resume as a guide. Your’s should look very similar to it.
      3. Make sure it is error-free & print it. Each error will drop you a letter grade!
    3. Fold the letter & resume together. Put them in the envelope & hand them in.
    4. UPLOAD YOUR RESUME & LETTER OF APPLICATION TO GOOGLE DOCS and SAVE THEM TO YOUR FLASH DRIVE SO YOU WILL ALWAYS HAVE THEM!
    5. Take 5 minute timings. Let me know if you get any good timings.

    Complete your resume. Remember, if you had Apps I last semester, open your resume & use that information–BUT YOU MUST CREATE A NEW TEMPLATE–Type the information from last quarter. Print it when it is error-free.

    1. Remember to sign your letter of application using blue or black ink. Fold the resume & letter together. Put the letter on top. Place them in the envelope. Do not seal the envelope. Remember this project should be ERROR-FREE! If you notice an error, fix it and reprint it. Only reprint the page that had the error. If you are unsure on how to print just the letter or just the envelope, ask a classmate for help or ask me for help.
    2. Place your stuffed envelope on the black cart. Remember, 1 letter grade will be dropped for every error identified!
    3. UPLOAD YOUR RESUME & LETTER OF APPLICATION TO GOOGLE DOCS and SAVE THEM TO YOUR FLASH DRIVE SO YOU WILL ALWAYS HAVE THEM!
    4. Take TWO 5-minute timings.
    5. Read and do Enrichment Activity B–Interview Preparation–on pages 9-11. So far in the job seeking process you sent your letter of application and resume to Ozark Zoological Park. They, in turn, sent you an application form that you would have completed and mailed back to them. They are now interested in you as a possible future employee with their company and they would like to meet you in person and get to know you better to determine if you would be a good fit with their company. They want to interview you. A good candidate for any job ALWAYS prepares for the interview. When preparing for an interview, it is extremely important to answer any anticipated questions before hand so you have an appropriate response. Enrichment Activity B is designed to help get you thinking of what kinds of questions to anticipate in an interview. Type your answers for Enrichment Activity B in a Word file and upload them to Google Docs. Be sure to put your name in the header.
    6. Extra Credit Opportunities:
      1. The following website has commonly asked questions and some suggested responses. How do you answer “Tell me a little about yourself”? Check out some of the responses to other commonly asked questions. Go to:  http://www.faqfarm.com/Q/FAQ/1869. In Word, type a suggested response to the question above and then type 2-3 other questions you looked at. Do you think this website could come in handy for you in the future? Save the file as Interviews.
      2. Go to this website: http://msn.careerbuilder.com/jobseeker/careerbytes/quiz.aspx?qid=QZ0014. Take the quiz. How did you do and what did you learn? Type your response in Word–in the same file as #1 above. Now, click on the BACK button go to 3 other links that you think sound interesting. In the Word file, type the link you chose, why you chose it, and what you learned or didn’t learn.
      3. Put your name in the header of the Word file and upload it to Google Docs.

    Before you leave class today, you will know how to properly complete an application form and how to prepare for an interview.

    1. Complete the letter of application and resume. Hand them in.
    2. UPLOAD YOUR RESUME & LETTER OF APPLICATION TO GOOGLE DOCS and SAVE THEM TO YOUR FLASH DRIVE SO YOU WILL ALWAYS HAVE THEM!
    3. Read and do Enrichment Activity B–Interview Preparation–on pages 9-11. So far in the job seeking process you sent your letter of application and resume to Ozark Zoological Park. They, in turn, sent you an application form that you completed and mailed back to them. They are now interested in you as a possible future employee with their company and they would like to meet you in person and get to know you better to determine if you would be a good fit with their company. They want to interview you. A good candidate for any job ALWAYS prepares for the interview. When preparing for an interview, it is extremely important to answer any anticipated questions before hand so you have an appropriate response. Enrichment Activity B is designed to help get you thinking of what kinds of questions to anticipate in an interview. Try to put a POSITIVE spin on all your answers. Type your answers for Enrichment Activity B in a Word file and upload them to Google Docs. Be sure to put your name in the header. THIS IS REQUIRED!
    4. TAKE TIMINGS IF TIME PERMITS!

    Congratulations! You got the job at Ozark Zoological Park! Today you will begin your first job!

    Before you leave class today you will know:

    • How to create a memo using Word’s templates
    • How to create a table
    • How to use click and drag
    1. Open your Ozark Zoological Booklet to pages 12-13 and read the instructions.
      1. You are going to create this memo using a Memo Template (From the Office Button in Word choose NEW, in the New Document dialog box, scroll down and click on MEMO, and then double-click the CONTEMPORARY DESIGN Memo.)
      2. Save the file as JOB01MEMO to your drive–look at the instructions on page 12 in your Ozark Booklet.
      3. You will need to insert a table to list the Associations and Countries. Go to the Insert Ribbon, click on Table. Hit TAB to move from cell to cell in a table.
      4. You are expected to put all countries and associations in alphabetical order. ADVICE: Type everything out and then use CLICK and DRAG to put them in alphabetical order. (To use click and drag: select the word or words you are moving, click and drag the select to its new location and release the mouse.)
      5. To decide on what to put at the beginning of your memo, read your instructions on page 12 and use the example that is posted on the wall.
      6. Type the document to the best of your ability. Get up and use the example as much as necessary. Be sure to proofread VERY well!
    2. Upload this file to Google Docs
    3. If you finish early, please work on the Job 1 Enrichment Activity on page 15 in your Ozark Booklet. You may type your answers in a Word file and upload it to Google Docs.

     

    Next you will be expected to complete your 2nd job for Ozark Zoological Park. You will also begin to learn a little bit about desktop publishing using MS-Word. Before you leave class today you will know how to do the following:

    • Create an open table in Word.
    • Use the Indent marker in your ruler to align text.
    1. Open, save, and read the Tables Handout.
    2. Read the instructions for Job 2 on page 17 in the Ozark Booklet. You may need to refer to the Reference Manual in the back of the booklet to help you with the proofreader’s marks. Use the example hanging on the wall as much as you need. You are under a deadline: this must be completed by the end of class today. Show me when you are done.
    3. There are examples for each exercise below hanging on the wall. Use them!
    4. Take TIMINGS!!!
    1. Send Mrs. Weber her MIDTERM!
    2. Moodle on the “COURSE DESCRIPTION” topic
    3. Complete the INFORMATION TECHNOLOGY NEEDS ASSESSMENT survey located at the top of your class’ web page.
    4. Make up work–print all with name and assignment name in header.
    5. Timings

    EVERYONE TAKE A TIMING RIGHT NOW!!!!

    Job 6–Ozark Booklet–Page 46

    Today you will have the opportunity to compose a personal business letter to the World Wildlife Fund.

    • Be sure to include everything suggested on page 46 in the Ozark booklet for Job 6.
    • Use the Personal Business Letter Format found in the Reference section of your Ozark booklet.
    • Create an envelope for the letter also.
    • Show me when you are done

    Before you leave today you will have the opportunity to learn about greetings and business cards when doing business in other countries while editing a memo template. You will also have the opportunity to contemplate how you would use what you are learning in this class in the real world.

    1. Click on the link at the bottom of this page to get you to Moodle. Click on Document Formatting (7 or 8) and type your response to the forum titled “Real Life Application”. After typing your response, please comment on a classmates response.

    2. Complete Job 6 in the Ozark booklet. Remember the following:

    1. Be sure to mention everything on the top of page 46 in your letter
    2. Show me with the envelope creating–NOT FOR A GRADE
    3. Make changes and print ONLY THE LETTER

    Today you will get the opportunity to work more with memo templates in Word. Today you will be working in the Ozark booklet.

    1. Do Job 7 in the Ozark Booklet.

    1. Please go to my web site and open the Job 7 file from the Other Important Class Files/Web Sites linked off the Apps II web page. You will need to copy this information into the body of your memo template that you will need to create for this job.
    2. You will have to make all the necessary and indicated corrections in Job 7 on pages 51-52 in your Ozark Booklet. There may also be some corrections that need to be made that are NOT indicated with proofreader’s marks. PROOFREAD it very carefully!
    3. Be sure to follow the proper format for page 2 of a memo. Use your Reference Manual in the back of the Ozark Booklet.
    4. Show me when you are done.

    1. Job 8 in the Ozark Booklet

    1. Read the instructions on PAGE 61.
    2. For 8-1–Read the definition on page 62, then go to the following link to type your responses: Click Here to take the ethics survey
    3. For 8-2–Read and follow the instructions–send it to me as an email attachment. Be sure to use appropriate sentence structure and correct punctuation. Put some thought into your paragraphs!! Do COMPLETE research. Don’t just go to the first 2 sites listed in your search results! Remember I am your boss–you always want to impress your boss!!! They are the ones who recommend you for promotions!

    2. Timings

    1. Ozark Booklet–Job 9
      1. Open the file from the Apps 2 page of my website
      2. At this point in time, I consider you all to be EXPERT word processors! You should be able to figure out ANYTHING with Word! Make sure this is an error-free file!
      3. Read the directions CAREFULLY!
      4. Use the reference manual as instructed on page 66. Make sure you know what KIND of file this is!!!!
      5. Include your name in the header and print it.
    2. Timings
    1. Ozark Booklet–Job 10
      1. REMEMBER YOU ARE A WORD PROCESSING EXPERT!!!!!
      2. Open the file from the Student Data Files pages linked from the Apps 2 page off my web site. Make all indicated corrections AND look for other errors NOT indicated in the document.
      3. Follow all the directions on page 73 in your Ozark booklet.
      4. Use your Reference Manual to help you.
      5. Send this file to me as an email ATTACHMENT: tweber@bellevue.k12.ia.us
      6. Here are some helpful hints:
        1. bf stands for boldface–bold these items.
        2. The numbers (1, 2, etc.) indicate you need to INSERT a footnote. Here is how you do that in Word:
          1. Be sure your cursor is positioned in the correct place.
          2. From the References tab, click on the Insert Footnote button.
          3. Type the information for the footnote. The information you need to type is written at the bottom of pages 74-75.
          4. When you are done typing the footnote, click back in the document where you left off and continue.
        3. On page 75 start a new paragraph with “Moving east to west…….”
        4. For the table on page 76:
          1. Make sure the lines show up when you do a print preview.
            1. Select the table, from the Table Tool Design tab, click on the Borders button and choose All Borders.
          2. Horizontally center the table.
          3. Best fit the columns
        5. If you are unsure of any proofreader’s marks use your Reference Manual!!!
    2. Timings–if you get a good one, email me the results.
    1. Ozark Job 11–Open the file linked from the Apps 2 page of my website.
      1. Use the reference manual–Some of you ARE NOT DOING THIS!!!! Major points will be taken off!! If you work for a company and they have their own style manual you will be expected to follow their guidelines. The Reference Manual in the back of this book is our company’s manual–follow it!!!!!!! Read all your directions carefully. Proofread carefully!!!!!
      2. Print it with your name in the header on page 1.
    2. Tmings–Email me your results if you have 5 errors or less.
    3. Re-do Jobs 9 & 10–Read all the directions & proofread very carefully!!!!! Paying attention to detail is an extremely important employability skill! Tune that skill in right now!
    1. Ozark Booklet Job 12
      1. Open the file linked from my web site on the Apps 2 page for Job 12.
      2. Use the Reference Manual
      3. READ ALL YOUR DIRECTIONS CAREFULLY!!!!
      4. HINTS:
        1. This is a BUSINESS letter–who is is from and who is it too? Individual or business? What should be at the very top of the letter? What should be at the end of the letter? REVIEW!!!! Ask each other for help, if necessary!
        2. What is modified block? Use the reference manual
        3. Where should the subject line go? Use the reference manual.
        4. Who is the Assistant Manager of Communication? Use the reference manual.
      5. Print it with an envelope. Place the letter (properly folded) into the envelope (don’t seal it)!

     

    Ozark Booklet Job 13

    1. USE YOUR OWN WORDS!!! Write how you talk!!!! Use proper sentence structure, punctuation, capitalization, etc.
    2. A good paragraph in a letter is 2-3 sentences.
    3. HINTS:
      1. Who is the Assistant Manager of Animal Programs?
      2. This is a BUSINESS LETTER. What do you need to do at the very beginning and the very end?
      3. Use the TOTAL feature in the Tables ribbons. SHOW ME ON TUESDAY!!!!
    4. Use the Reference Manual
    5. Print it with an envelope!!!Properly fold the letter & place it in the envelope. Do not seal it.

     

    Ozark Job 14

    1. You are preparing this for all the people who work for Ozark that travel a lot. BE NEAT & ERROR-FREE!!
    2. Get the files from the Apps 2 page of my web site.
    3. Use your Reference Manual!!!! Read the directions!!!
    4. The table should fit on 1 page and the report should fit on 1 page.
    5. PROOFREAD!!
    6. Print it.

     

    Ozark Job 15

    1. Follow the instructions.
    2. Make this easy to read & understand. Use various formatting, but be sure to PROOFREAD!!!!
    3. Print it. BE ERROR-FREE!!

    3. Check JMC. If you see a 0, finish that file & print it. Be sure to label it with the exercise!!!!

    4. Timings–Send me an email or write me a note if you get a good one!

     

    Today we will work on mail merge. Right now create a new file in Word. We will do 1 mail merge together (you may want to jot down some notes) and then you will get the opportunity to do a couple on your own.

    On your own:

    1. If you have questions, Lesson 85 in your student manual has step-by-step instructions on mail merge.
    2. For the following assignments be sure to use proper letter format–be sure to include ALL PARTS!!!!!!
      1. Keyboarding Textbook–Lesson 85–page 310–show me.
      2. Keyboarding Textbook–Lesson 86–page 313–show me.
      3. Keyboarding Textbook–Lesson 87–page 317–show me–for a grade!
      4. Ozark Booklet Job 12-1 on page 91. The file you need with all the names and addresses is on the Apps II web page.

     

    MAKE UP DAY!!!!

    1. Complete the Mail Merge Assignments from last class. Use the Mail Merge Instructions handout to help you. Save it to your drive and open it.
      1. Keyboarding Textbook–Lesson 85–page 310–show me.
      2. Keyboarding Textbook–Lesson 86–page 313–show me.
      3. Keyboarding Textbook–Lesson 87–page 317–show me–for a grade!
      4. Ozark Booklet Job 12-1 on page 91. The file you need with all the names and addresses is on the Apps II web page–show me–for a grade!
    2. Look at your grade in JMC and complete any assignments with a 0 as a score. Be sure to label the assignment!!!!
    3. Take timings. Allow yourself enough time today to take at least 3 timings. I have to have midterms finished by April 29th.
    4. Test next class!!!!

     

    1. Read-A-Thon
    2. Go to my blog and answer the thick question of the week.
    3. Look at your grade in JMC and complete any assignments with a 0 as a score. Be sure to label the assignment!!!!
    4. Take timings. Allow yourself enough time today to take at least 3 timings. I have to have midterms finished by April 29th.
    5. Test next class!!!!

     

     

    Review for the test–get a sample test–try to answer the questions to the best of your ability throughout class today. We will check it at the end. Study!!! You will take a written and hands on test next class. The written test will be similar to the sample test you will take today and the hands on test will be a newsletter, invitation, and a letter.

    1. Look at your grade in JMC and complete any assignments with a 0 as a score. Be sure to label the assignment!!!!
    2. Take timings. Allow yourself enough time today to take at least 3 timings. I have to have midterms finished by April 29th.
    3. Test next class!!!!
    1. Word Processing/DTP Test Day
      1. Written Test & Hands On Test
        1. Written Test on the computer. Log in as CLASS password is xp
      2. Hands On Test: Keyboarding Textbook:
        1. Report 70–Follow the directions & make sure you BALANCE the columns!
          1. Print this when it is completed with your name in the header or footer.
        2. In Word, compose a letter that you would like to send to a teacher of your choice thanking them for something they did for you. Be sure to include the following:
          1. 3 paragraphs with 3-5 sentences in each paragraph
          2. The letter should be modified-block with indented paragraphs
          3. The letter is from you.
          4. The high school address is: 1601 State Street, Bellevue, IA 52031
          5. Be sure to include a properly addressed envelope.
          6. Print the envelope and letter

     

    Complete the Hands On Test. The instructions from last class have changed!!!!!! I will give you as much time as you need!!! Keyboarding Textbook:

    1. Be sure to look at the grading rubric before you raise your hand to show me or print!
    2. Report 22 on page 274 in your textbook.
      1. You may use your notes and both books for this class to help you–they are your manuals/references.
      2. This is a LEFT-BOUND BUSINESS report.
      3. Format all the references as FOOTNOTES (this is different from the directions in your book).
      4. Make the last paragraph a bulleted list by having each sentence have a bullet.
      5. In my opinion, you are an expert at using Word now. So:
        1. Using the format on pages 282-283, create a title page, table of contents page, and bibliograph page for Report 22. READ THE DIRECTIONS!!
        2. FYI: The title page and table of contents page should be saved as different files, but the bibliography should be included as a separate page in the R22 file.
        3. Table of Contents page: To set a DOT leader:
          1. Immediately after you type the title and hit enter 2 times: Go to the Tabs dialog box and set a DOT leader tab at approximately 5 inches. YOU CAN DO IT!! YOU ARE AN EXPERT!!!
        4. Bibliography: Use the little example at the top of page 283 to help you OR use the REFERENCE tab in Word 2007!!!!!!
      6. Show me all FOUR files when you are completely finished. Be sure you have met all the requirements on the grading rubric.
    3. Memo–Create a memo using a template. The memo is from you to Mr. Meyer or Mr. Healy. It can be on a subject of your choice. It should contain 2 paragraphs. Use good writing skills–proper punctuation, grammar, spelling, capitalization, sentence structure, etc. Be sure to use the grading rubric before you raise your hand to show me.
  • Complete the Word Unit Exam. See the lesson plans for last class and your grading rubric for details.
  • Take timings
  • Do make up work
  • Extra credit opportunity!!! See me!!!!

 

  1. Excel Unit
  2. Lesson 131
    1. Exercises A-D
    2. Read E
    3. Do F in the Student Manual
    4. Activity 26–Remember to RETURN TO KCA when you are done!
    5. Activity 27–Remember to RETURN TO KCA when you are done!
    6. Activity 28–Upload to Edmodo–Remember to RETURN TO KCA when you are done! For a grade.
  3. Lesson 132
    1. Exercises A-E
    2. Read F
    3. Do G in Student Manual
    4. Activity 29–upload to Edmodo attached to a Note to me–not for a grade
    5. Activity 30–upload to Edmodo attached to a Note to me–not for a grade
    6. Activity 31–Upload to Edmodo
      for a grade
  4. Lesson 133
    1. Exercises A-C
    2. Read D-E
    3. Do F in Student Manual
    4. Activity 32
    5. Activity33
    6. Activity 34–Upload to Edmodo attached to a Note to me (not for a grade)
    7. Activity 35–Upload to Edmodo for a grade
  5. Lesson 134
    1. Exercises A-B
    2. Read C & D
    3. Do E in Student Manual
    4. Activty 36–Upload to Edmodo attached to a Note to me (not for a grade)
    5. Activity 37
    6. Activty 38–Upload to Edmodo for a grade
  1. Lesson 135
    1. Exercises A-D
    2. Read E & F\
    3. Do G in Student Manual
    4. Activity 39–Upload to a Note in Edmodo as an attachment–not for a grade
    5. Activity 40–Upload to Edmodo for a grade

    Lesson 136

    1. Exercises A-B
    2. Read C
    3. Do D in Student Manual
    4. Activity 41
    5. Activity 42–upload attached to a note in Edmodo–not for a grade
    6. Activity 43–Upload to Edmodo for a grade

     

  1. SENIORS LAST DAY!
  1. Lesson 137
    1. Exercises A-D
    2. Read E
    3. Do F in Student Manual
    4. Activity 44
    5. Activity 45–Upload as an attachment to a note to me in Edmodo–not for a grade

    Lesson 138

    1. Activities A-B
    2. Read C
    3. Do D in Student Manual
    4. Activity 46
    5. Activity 47–Upload as an attachment to a note to me in Edmodo–not for a grade
    6. Activity 48
    7. Activity 49–Upload to Edmodo–for a grade

     

  1. Lesson 139
    1. Exercises A-C
    2. Activity 50–Upload as an attachment to a note to me in Edmodo–not for a grade
    3. Activity 51–Upload to Edmodo for a grade

    Lesson 140

    1. Exercises A-C
    2. Activity 52
    3. Activity 53–Upload as an attachment to a note to me in Edmodo–not for a grade
    4. Activity 54
    5. Activity 55–Upload to Edmodo for a grade
  2. Before you leave today you will have the opportunity to learn how to integrate Access, Word, and Excel
  3. Exercises A-C
  4. Student Manual for Lesson 150 TOGETHER
  5. Activity 31–Upload as an attachment to a note to me in Edmodo–not for a grade
  6. Activity 32–Upload as an attachment to a note to me in Edmodo–not for a grade
  7. Activity 33–Upload to Edmodo for a grade

 

  1. Lesson 139
    1. Exercises A-C
    2. Activity 50–Upload as an attachment to a note to me in Edmodo–not for a grade
    3. Activity 51–Upload to Edmodo for a grade

    Lesson 140

    1. Exercises A-C
    2. Activity 52
    3. Activity 53–Upload as an attachment to a note to me in Edmodo–not for a grade
    4. Activity 54
    5. Activity 55–Upload to Edmodo for a grade
  2. Before you leave today you will have the opportunity to learn how to integrate Access, Word, and Excel
  3. Exercises A-C
  4. Student Manual for Lesson 150 TOGETHER
  5. Activity 31–Upload as an attachment to a note to me in Edmodo–not for a grade
  6. Activity 32–Upload as an attachment to a note to me in Edmodo–not for a grade
  7. Activity 33–Upload to Edmodo for a grade
  1. Lesson 139
    1. Exercises A-C
    2. Activity 50–Upload as an attachment to a note to me in Edmodo–not for a grade
    3. Activity 51–Upload to Edmodo for a grade

    Lesson 140

    1. Exercises A-C
    2. Activity 52
    3. Activity 53–Upload as an attachment to a note to me in Edmodo–not for a grade
    4. Activity 54
    5. Activity 55–Upload to Edmodo for a grade
  2. Before you leave today you will have the opportunity to learn how to integrate Access, Word, and Excel
  3. Exercises A-C
  4. Student Manual for Lesson 150 TOGETHER
  5. Activity 31–Upload as an attachment to a note to me in Edmodo–not for a grade
  6. Activity 32–Upload as an attachment to a note to me in Edmodo–not for a grade
  7. Activity 33–Upload to Edmodo for a grade
  1. Easter Bunny Mail Merge–YOU are the EASTER BUNNY. Compose a creative letter to a preschool student. You may want to include how you live your day-to-day life, what your life is like around Easter time, how your “chocolate bunny factory” works, etc. REMEMBER: These are 3-4 year old children!!
    1. Use proper letter format.
    2. You will earn more points the more creative you are–both in the design and wording of the letter!
    3. Use Bellevue Elementary School’s Address: 300 Third Street, Bellevue, IA 52031
    4. Come up with your own field names. (For example: First Name, Teacher Name, Address, City, State, Zip, Boy/Girl)
    5. Include at least TWO fields in the BODY of the letter.
    6. Include a table–use various borders & shading, merge cells
      1. You might use a table to show your daily schedule, what you make in your factory, etc
    7. Use clipart and a page border.
    8. Here are your assigned students:
      Dimitri Teacher: Ms. Jodi

Michael B.

Connor D.

Maverick D.

Hope G.

Payton G.

Kaden G.NatalieTeacher: Ms. Jodi

Logan K.

Ben R.

Logan S.

Cole V.

Cody C.

Deanna B.DylanTeacher: Ms. Jodi

Deyonna P.

Jack W.

Devon S.

Gavin A.

Aunika H.

Tate G.ColinTeacher: Ms. Jodi

Owen Po.

Myles P.

Arian R.

Kendelle S.

Alexus S.

Seth S.MaddieTeacher: Ms. Jodi

Alyssa W.

Chloee A.

Jeffrey B.

Brooke B.

Alena C.

Joanna C.ShianneTeacher: Ms. Jodi

Robert G.

Presly K.

Alyssa K.

Tait N.

Liberty R.

Olivia R.RileyTeacher: Ms. Jodi

Paige S.

Miranda S.

Kaitlyn T.

Brianna V.

Josh E.

Maxwell F.TessaIzabella M.–Teacher: Ms. Jodi

Anthony (Tony) S.–Teacher: Ms. Jodi

Leo–Teacher: Mrs. Decker                      Gavin–Teacher: Mrs. Decker

Isaac–Teacher: Mrs. Decker

Alex –Teacher: Mrs. DeckerJarrettTeacher: Mrs. Decker

Trent

Jamie

Trevor

Todd

Teagan

NoahMeganTeacher: Mrs. Decker

Alexis

Hunter M.

Ben

Hunter P.

Spencer

TeylorErikaTeacher: Mrs. Decker

Casey

Bill

Aly

Olivia

SamsonDJTeacher: Mrs. Decker

Rayna

Kelsey

Sienna

Owen

Skylar

  • Share with me in Edmodo.
  • Create an envelope using the mail merge fields you used for the letter. Upload to Edmodo.
  • Compose a memo to the preschool teachers describing your letter to the students and what you hope to accomplish by sending the letter. Upload to Edmodo.

 

  1. COMPLETE EASTER BUNNY LETTERSComplete the following:
    1. Easter Bunny Mail Merge–YOU are the EASTER BUNNY. Compose a creative letter to a preschool student. You may want to include how you live your day-to-day life, what your life is like around Easter time, how your “chocolate bunny factory” works, etc. REMEMBER: These are 3-4 year old children!!
      1. Use proper letter format.
      2. You will earn more points the more creative you are–both in the design and wording of the letter!
      3. Use Bellevue Elementary School’s Address: 300 Third Street, Bellevue, IA 52031
      4. Come up with your own field names. (For example: First Name, Teacher Name, Address, City, State, Zip, Boy/Girl)
      5. Include at least TWO fields in the BODY of the letter.
      6. Include a table–use various borders & shading, merge cells
        1. You might use a table to show your daily schedule, what you make in your factory, etc
      7. Use clipart and a page border.
      8. Here are your assigned students:
        Dimitri Teacher: Ms. Jodi

Michael B.

Connor D.

Maverick D.

Hope G.

Payton G.

Kaden G.NatalieTeacher: Ms. Jodi

Logan K.

Ben R.

Logan S.

Cole V.

Cody C.

Deanna B.DylanTeacher: Ms. Jodi

Deyonna P.

Jack W.

Devon S.

Gavin A.

Aunika H.

Tate G.ColinTeacher: Ms. Jodi

Owen Po.

Myles P.

Arian R.

Kendelle S.

Alexus S.

Seth S.MaddieTeacher: Ms. Jodi

Alyssa W.

Chloee A.

Jeffrey B.

Brooke B.

Alena C.

Joanna C.ShianneTeacher: Ms. Jodi

Robert G.

Presly K.

Alyssa K.

Tait N.

Liberty R.

Olivia R.RileyTeacher: Ms. Jodi

Paige S.

Miranda S.

Kaitlyn T.

Brianna V.

Josh E.

Maxwell F.TessaIzabella M.–Teacher: Ms. Jodi

Anthony (Tony) S.–Teacher: Ms. Jodi

Leo–Teacher: Mrs. Decker                      Gavin–Teacher: Mrs. Decker

Isaac–Teacher: Mrs. Decker

Alex –Teacher: Mrs. DeckerJarrettTeacher: Mrs. Decker

Trent

Jamie

Trevor

Todd

Teagan

NoahMeganTeacher: Mrs. Decker

Alexis

Hunter M.

Ben

Hunter P.

Spencer

TeylorErikaTeacher: Mrs. Decker

Casey

Bill

Aly

Olivia

SamsonDJTeacher: Mrs. Decker

Rayna

Kelsey

Sienna

Owen

Skylar

  • Share with me in Edmodo.
  • Create an envelope using the mail merge fields you used for the letter. Upload to Edmodo.
  • Compose a memo to the preschool teachers describing your letter to the students and what you hope to accomplish by sending the letter. Upload to Edmodo.

 

  1. Scenario: You have been hired as an expert in Google Docs to create an instructional video that will show teachers how to create, share, and edit shared docs using Google. This video will be distributed to all teachers in the Bellevue Community School District as a resource for them to use. The clip can only be 5 minutes in length. An instructional handout needs to accompany the video clip. Here are the goals of this project:
    1. All teachers will understand how to access their Google Account
    2. All teachers will understand how Google Docs saves their files.
    3. All teachers will understand how to create a Google Doc.
    4. All teachers will understand how to share a Google Doc.
    5. All teachers will understand how to access and edit a Google Doc that someone else shared with them.
  2. A clip is only 5 minutes in length. Here are some suggestions:
    1. Create written instructions BEFORE recording and refer to them as you record.
    1. You will need to record and record several times…….be patient and persistent!!!
  3. GOAL FOR TODAY: Create the videos clips needed. Here are some things to consider:
    1. www.screencastomatic.com
      1. after you are done recording a clip, save it as a movie file (mp4) to your Google drive located on your machine.
    2. Refer to the handout A LOT!!
    3. Create 1 video clip for each main section in your handout:
      1. How to Access Your Google Account
      2. How to Create a Google Doc
      3. How to Share a Google Doc
      4. How to Access and Edit a Shared Google Doc
    4. All video clips COMBINED should only be 4-5 minutes
    5. BE PERSISENT!!! You may have to record and re-record several times!!!

 

  1. Scenario: You have been hired as an expert in Google Docs to create an instructional video that will show teachers how to create, share, and edit shared docs using Google. This video will be distributed to all teachers in the Bellevue Community School District as a resource for them to use. The clip can only be 5 minutes in length. An instructional handout needs to accompany the video clip. Here are the goals of this project:
    1. All teachers will understand how to access their Google Account
    2. All teachers will understand how Google Docs saves their files.
    3. All teachers will understand how to create a Google Doc.
    4. All teachers will understand how to share a Google Doc.
    5. All teachers will understand how to access and edit a Google Doc that someone else shared with them.
  2. A clip is only 5 minutes in length. Here are some suggestions:
    1. Create written instructions BEFORE recording and refer to them as you record.
    1. You will need to record and record several times…….be patient and persistent!!!
  3. GOAL FOR TODAY: Create the movie that puts everything together. Here are some things to consider:
    1. You may use iMovie or MovieMaker
    2. Insert a text slide to identify each main section:
      1. How to Access Your Google Account
      2. How to Create a Google Doc
      3. How to Share a Google Doc
      4. How to Access and Edit a Shared Google Doc
    3. Refer to the handout A LOT!!
    4. The entire movie should only be 5 minutes or less
    5. At the end be sure to include that this was created by you.
    6. Save the movie as a movie file and upload it to your YouTube account. Send me the link for the YouTube video in a note in Edmodo.

 

EVERYONE NEEDS TO SEND ME THE YOUTUBE VIDEO LINK AND YOUR HANDOUT TOGETHER IN AN EMAIL MESSAGE TO ME!!!!! TODAY!!!!! EVEN IF YOU ALREADY HAVE A GRADE FOR BOTH!!!!

FINISH THE GOOGLE VIDEO AND HANDOUT

  1. Save your project as a movie file
  2. Upload it to YouTude
  3. Send me the link for the YouTube video

TRY THIS!!!

  1. Go to www.pixorial.com
  2. Create a free account using your Google account
  3. Try making a video–this is really cool because it is cross platform!! Everything is done online!! All you have to do is create video clips using www.screencastomatic.com, save the clips to your Google Drive, and then access them at www.pixorial.com!!! You can even link your YouTube account to it for a quick upload!!

 

Create a screen recording of how to do a screen recording. Use your Mac. Suggestion: use QuickTime to provide instruction on how to Jing or vice versa.

 

Create a screen recording of how to do a screen recording. Use your Mac. Suggestion: use QuickTime to provide instruction on how to Jing or vice versa.

Create a screen recording of how to insert a previously recorded clip into an iMovie.

Submit your clips to me as a YouTube link in Edmodo.

 

PROBLEM: How do create a table in Word and when and why would you need to know this?

  1. Take 2 timings–we are starting over for the 4th quarter! Check out the new grading scale on your class’ webpage.
  2. Before you leave today you will know how to:
    1. Create a table in Word
      1. Insert tab
      2. Table
      3. Choose the number of columns & rows
      4. Tab moves you forward from cell to cell
      5. SHIFT-tab moves you backward from cell to cell
    2. Center a table vertically & horizontally
      1. Click anywhere inside the table
      2. Click the box in the upper left corner of the table to select the entire table
      3. CTRL-E to center horizontally (or click the center button in the Home tab)
      4. Page layout tab
      5. Margins button
      6. Custom margins
      7. Layout
      8. Vertical alignment
      9. Center to vertically center the table
    3. Automatically adjust column widths
      1. Be sure NOTHING is selected inside the table
      2. Point at the line between columns and when you have a double headed arrow, double click to best fit the columns
    4. Format column headings
      1. Center (ctrl-E)
      2. Bold (ctrl-B)
      3. Underline (ctrl-U)
      4. Column headings about numbers that could be used in a calculation should be either centered or aligned at the right like the numbers in the columns
    5. Format title
      1. Merge & center the top row
      2. All caps
      3. Bold
  3. Create a table that includes:
    1. the name of your classes
    2. the name of your teacher for each class
    3. approximate number of students in each class
    4. provide a title
    5. provide column headings
    6. use the formatting above
    7. show me
  4. USE THE PURPLE BOOK–
    1. Save each table in its own file–create a new file for each table.
    2. Show me each  table when you are done.

    Tables:

    1. 16 (page 252)
    2. 18 (page 255)
    3. 26 (page 335–HINT: Use the extra two ribbons for tables in Word AND read the directions in your book)–SHOW ME (or SHARE it with me through your Google Drive online)
    4. 31 (page 342–substitute this year’s top 10 fastest growing occupations information–include the URL for the website you find your information below the table)–PRINT IT
    5. 36 (page 349–make this table PRINT no lines)–SHOW ME (or SHARE it with me through your Google Drive online)
    6. 40 (page 352–make this table PRINT no lines–PRINT IT)
    7. Social Studies Connection (page 357–make this table have no line and at least one row have shading). PRINT IT

EVERYONE TAKE 2 FIVE-MINUTE TIMINGS–Show your teacher your scores–BEAT YOUR SCORES THAT ARE IN THE GRADE BOOK NOW TO GET A HIGHER GRADE FOR THE QUARTER!!!!

FINISH:

  1. USE THE PURPLE BOOK–
    1. Save each table in its own file–create a new file for each table.
    2. Show me each  table when you are done.

    Tables:

    1. 16 (page 252)
    2. 18 (page 255)
    3. 26 (page 335–HINT: Use the extra two ribbons for tables in Word AND read the directions in your book)–SHOW ME (or SHARE it with me through your Google Drive online–put a check mark in the box beside the file and click the SHARE button at the top)
    4. 31 (page 342–substitute this year’s top 10 fastest growing occupations information–include the URL for the website you find your information below the table)–PRINT IT–with your name in the header
    5. 36 (page 349–make this table PRINT no lines)–SHOW ME (or SHARE it with me through your Google Drive online)
    6. 40 (page 352–make this table PRINT no lines–PRINT IT–with your name in the header)
    7. Social Studies Connection (page 357–make this table have no line and at least one row have shading). PRINT IT with your name in the header.

CHECK JMC–DO MAKE UP WORK–share it with me–3rd Quarter ends on March 21, 2014

FINISH:

  1. USE THE PURPLE BOOK–
    1. Save each table in its own file–create a new file for each table.
    2. Show me each  table when you are done.

    Tables:

    1. 16 (page 252)
    2. 18 (page 255)
    3. 26 (page 335–HINT: Use the extra two ribbons for tables in Word AND read the directions in your book)–SHOW ME (or SHARE it with me through your Google Drive online–put a check mark in the box beside the file and click the SHARE button at the top)
    4. 31 (page 342–substitute this year’s top 10 fastest growing occupations information–include the URL for the website you find your information below the table)–PRINT IT–with your name in the header
    5. 36 (page 349–make this table PRINT no lines)–SHOW ME (or SHARE it with me through your Google Drive online)
    6. 40 (page 352–make this table PRINT no lines–PRINT IT–with your name in the header)
    7. Social Studies Connection (page 357–make this table have no line and at least one row have shading). PRINT IT with your name in the header.

CHECK JMC–DO MAKE UP WORK–share it with me–3rd Quarter ends on March 21, 2014

Before you leave today you will know how to create a memorandum using a template in Word

  1. How to create a memo using a template:
    1. File menu
    2. New
    3. Click Memos
    4. Choose Contemporary
    5. Click Download
    6. Customize all areas of the memo to fit your needs
    7. Delete anything that isn’t used
  2. Memos 1-2 pages 324
    1. Show me Memo 1–no grade
    2. Just do Memo 2
  3. Write a memo to Mr. Meyer explaining an issue at the high school that you would like to see changed. Print.
  4. Write a memo to Dr. Healy explaining an issue in our school district that you would like to see changed. Show me.
  5. HOMEWORK: Watch the following video clips before next class:
    1. Begin mail merge to customize columns
    2. Customize columns to merging
    3. Finish the merge

GOAL: Before you leave today you will know how to create a mail merge using Word.

  1. Mail Merge Notes–Open, Save, and USE this handout!!
    1. Open the Handout, get it on 1/2 your screen, then watch and do the following video clips:
        1. Begin mail merge to customize columns
        2. Customize columns to merging
        3. Finish the merge
  2. Read the bottom of page 309 in your textbook (THE PURPLE BOOK).
  3. Letters 44-45
    1. Use the instructions sheet
    2. Show me the FORM LETTER and MERGED FILES when you are completely done.
    3. No grade
  4. Show me for a grade: Letters 46-49 page 313
  5. Letters 51-53 page 317–YOU NEED TO COME UP WITH YOUR OWN FIELD NAMES (For example: Title, First Name, Last
  6. Name, Address, City, State, Zip, Physician, Physician State)!!!!!
    1. Show me for a grade when you are done

FINISH:

  1. Mail Merge Notes–Open, Save, and USE this handout!!
    1. Begin mail merge to customize columns
    2. Customize columns to merging
    3. Finish the merge
  • Read the bottom of page 309 in your textbook.
  • Letters 44-45
    1. Use the instructions sheet
    2. Show me the FORM LETTER and MERGED FILES when you are completely done.
    3. No grade
  • Show me for a grade: Letters 46-49 page 313
  • Letters 51-53 page 317–YOU NEED TO COME UP WITH YOUR OWN FIELD NAMES (For example: Title, First Name, Last
  • Name, Address, City, State, Zip, Physician, Physician State)!!!!!
    1. Show me for a grade when you are done

FINISH: Letters 44-45

  1. Use the instructions sheet
  2. Show me the FORM LETTER and MERGED FILES when you are completely done.
  3. No grade
  1. Show me for a grade: Letters 46-49 page 313
  2. Letters 51-53 page 317–YOU NEED TO COME UP WITH YOUR OWN FIELD NAMES (For example: Title, First Name, Last
  3. Name, Address, City, State, Zip, Physician, Physician State)!!!!!
    1. Show me for a grade when you are done

Check JMC.

Take timings–if you get a good one, let me know if you would like it to be for the 3rd or 4th qtr.

Mail Merge Test

  1. Create a mail merge letter to be sent to 3 people on a topic of your choice. This is a writing assignment. Be sure to use good writing skills.
  2. Create labels OR envelopes using the same list you used for the letter.
  3. Share all files with me.

Take timings & do make up work.

Mail Merge Test

  1. Create a mail merge letter to be sent to 3 people on a topic of your choice. This is a writing assignment. Be sure to use good writing skills.
  2. Create labels OR envelopes using the same list you used for the letter.
  3. Raise your hand and show me the following FILES:
    1. Form Letter
    2. Form Envelope/Labels
    3. Merged Letters
    4. Merged Envelopes/Labels

Take timings & do make up work.

 

Leave a Reply

Your email address will not be published. Required fields are marked *