Powerpoint project on Tips to create an effective powerpoint presentation.

Create a 5 slide PowerPoint Presentation on

"Ten Tips for Creating an Effective PowerPoint Presentation"

Your presentation should include the following items:

1.  5 slides
2.  Add 1 picture to each slide
3.  Animate some of your pictures and text
4.  Add transitions between your slides
5.  Include 10 tips

Intro to Powerpoint

Today you will learn about the basic of powerpoint through video and then apply what you learned there in a basic powerpoint.


1.  Complete this form-KWL chart/questions. Click on the link
https://docs.google.com/forms/d/1xRYTQp2UaeNj0nCOpyWF0YExi-y7pyR0eqq2o2zK0cE/viewform

2. Watch the PowerPoint_Basics_Video Series:
http://office.microsoft.com/en-us/mac-powerpoint-help/training-powerpoint-for-mac-2011-basics-RZ103796258.aspx?CTT=5&origin=HA103528343

3.  Then complete the Power point tutorial by clicking on this link:
http://office.microsoft.com/en-us/mac-powerpoint-help/powerpoint-for-mac-2011-basics-RZ103895020.aspx?CTT=5&origin=HA103528343

Web 2.0 project

Please choose a creative Web 2.0 application/tool to work in.  It could be one you reviewed yesterday or a new one.  You must produce a creative product (comic strip, story, graphic organizer, etc.) and share it with me.

Web 2.0 applications/tools

We have talked about Web 2.0 applications and tools.  Now I would like you to explore some and think about them critically.  

I would like you to take a look at 5 creative Web 2.0 sites and look at them critically. 
You may click this link, http://edjudo.com/web-2-0-teaching-tools-links to get to a long list of web 2.0 online tools by category or you can simply google web 2.0 online tools.   
After viewing and using them write a review for your favorite and your least favorite web 2.0 application/tool as a user on this blog.  I think it will be interesting to see what people think of the sites and their functionality, since each of you will have your own individual needs, likes and dislikes. You may stay in one category or try a variety of them. 

Each review should include:

·                Name of program/site 

·                URL 

·                Purpose of the site (example:  a place for me to edit my photos, a site where I could create a story, share it and publish it if I want)

·                Things that you like about the site (example:  I loved the features it offered, it was super user-friendly and created a great product)

·                Drawbacks to the site (example:  it was very difficult to navigate, or it was not user-friendly)

·                Would you recommend this tool to a friend? Why or why not?

Digital Footprint

Digital Footprints

Please answer the first two questions in a comment or post.

1.  What is a digital footprint?
2.  Can things you post on the Internet affect your future opportunities? Why or Why not?

Then watch a video and read an article that relate to digital footprints.  The links are below.

 Video: Abba's Story-Pride in Your Digital Footprint  https://www.commonsensemedia.org/video/modal/2531716



Article: "Digital dirt" can haunt your job search.
link http://www.cnn.com/2009/LIVING/worklife/10/12/cb.digital.trail.job.search/

"A Picture is Worth a Thousand Words"

Unintended consequences of sharing.  

"A Picture is Worth a Thousand Words"What do you think this saying means?

Look at the picture below and write what you think is going on in the picture just based on the picture.  Post your thoughts in a comment to this blog.  

After completing this, go to your email, read the article then complete the two assignments, forms, sent via google drive.  

Excel figure out a payment

Excel-figure out a payment

Hi everyone,

Today you will do some research on cars to figure out how much your car payments will be with different APR's.

1. Open up file car payment.  (should be on your desktop)

2.  Save file as carpayment_yourname

3.  Research cars and choose a car for under $10,000, one between $25-35,000, and one over $50,000

4.    Enter the year and type of car in column A accordingly.

5.  Enter the prices in column B accordingly.

6.  In cell C5, you will create a formula using the PMT function.  Here is the information you need to know in order to use it.

7.  Please search for an auto loan calculator on line to check to see if your payments calculated properly.

8. Figure out how much you pay in interest over the term of your loan for each payment.
You can accomplish this by taking the monthly payment multiplying it by the number of payments that must be made and subtracting that from the original price of the loan.

Nutritional Facts Assignment

Nutritional Facts Assignment 

What to do:

 Data collection

1. Drag the chart from our class folder to obtain nutritional facts file to work on the next activity. 
2. Gather research on 3 fast food restaurants of like foods.  Complete the nutritional facts on a typical meal you might purchase from one of the fast food restaurants.

Example
McDonalds Big Mac, Large Fries, Milkshake
Burger King Whopper, Large fries, milkshake
Wendy's double cheeseburger, large fries, milkshake

You can go to each restaurant's site individually or you can try www.nutritiondata.com .


3.  Save your file as nutritionfacts_yourname.

After data collection

After you have collected the data:

1. Use your knowledge of formulas to figure out the totals at the bottom of the spreadsheet.

2.  Create a graph or chart comparing the totals of the 3 restaurants.

3.    Visit the US dept of Agriculture to find out more healthy eating guidelines:
http://www.health.gov/dietaryguidelines/dga2010/DietaryGuidelines2010.pdf
Especially the executive summary viii-xi and page 14 of the document. Feel free to check out some of the tools to use to track calories and nutrition.

4.  Using Microsoft word, type a three paragraph report about your findings.

  a.  Paragraph 1- Introduction including which restaurants you chose and the items on your menu.

  b.  Paragraph 2- Summarize your findings about your meal including number of calories, percentage of fat, etc.  Add your chart to further demonstrate your findings.

  c.  Paragraph 3- Use the information from the Dept of Agriculture to evaluate your meal.  How does your percentage of fat compare to the percentage recommended? What about other guidelines like eating fruits and vegetables.  Have your planned a healthy meal? WHat changes might you make in your meal to make it healthier?

  d.  Paragraph 4- Using all the information provided, please inform us what meal you would choose and why.

Getting started with formulas and functions

Getting Started with Formulas and Functions 

What you'll learn:

• Create simple formulas for basic mathematical calculations 
• update formula results automatically 
• use a function to simplify formulas 
• copy and edit formulas 

Agenda:

• Actively listen and watch lecture on formulas and functions and ask questions. 
• Complete formula and function tutorial, independently, asking questions as you go along. 
• Start researching and working on the Nutrition Activity (see next post).

Excel intro lessons

Objectives:  

Students will be able to
open excel
be able to label and explain the major parts of the excel interface
create a basic excel document
enter, select and format data
insert and resize rows and columns
sort information in a list
sort by several columns at once
filter a list by custom criteria and reset filters

Today's Agenda 

A.  Answer the following questions, on the blog.

1.  What is Excel?
2.  What do you think you, as a student, can use Excel for?
3.  Have you used Excel before?
4.  If yes, how have you used it.

B.  Label and discuss the Excel interface, shared with you electronically but also have hard copies for anyone interested)

C.  Complete some guided practice and tutorials in Excel, creating a new document, formatting, and sorting and filtering.

Try a mail merge with a letter

Click on the link below to gain access to today's assignment.  You will need to download the excel and the word document for the assignment.

http://office.microsoft.com/en-us/mac-word-help/use-mail-merge-to-create-a-form-letter-RZ103895371.aspx

Mail Merge

Mail Merge 

Today's assignment is dealing with Mail Merge. You will be using Excel and Word to create this.
Please see below for your mail merge assignment.

What is a mail merge?

Facility provided by most word processing program whereby a form-letter can be sent to many recipients, each letterpersonalized for each recipient. The program takes each recipients name and address (from a mailing list) and enters it in its usual place on the letter, and also prints out mailing labels. 
(taken from http://www.businessdictionary.com/definition/mailmerge.html )

Mail Merge Assignment-Envelopes

1.  Open up a New Excel File,  Save it as yourname_addressbook
2.  Enter the information as follows in Row 1 
Last name   First Name    Street Address   City/Town   State    Zip code 

3.  Complete it with 10 of your family or friends information, making sure to format your zip code column

4.  Save

5.  Open up Word

6. Click on "tools" on the menu bar

7.  choose Mail merge Manager, a toolbox/window will appear with steps on it

7.  Click on create new> choose envelope

8.  Add your your own address in the bottom envelope of the box, where it says return address.

9.  Click ok

10.  Click on "get list" > Open data source >choose file > open

you should see this screen, click ok

11.  You should now see items in your placeholders appear.  These should be the categories you listed in row 1.

 12.  Now you will drag the placeholders into your envelope as follows:
         First Name Last name
         Street Address
          City, State  zip code
Your document should look like this

 13.  You are going to skip 4 and 5 on your box and move right to 6.  Complete Merge.  Click on the second button from the left "Merge to new Document"

   

14.  After clicking, this a new document should appear with your envelopes addressed.

15.  Save this file as completed merge_yourname

16.  Add your file to the class folder on your dock.

Using Templates-Creating a Newsletter

USING TEMPLATES

CREATING YOUR OWN NEWSLETTER

1.   Before starting your newsletter watch this video on managing layers which will help you in the template.
http://office.microsoft.com/en-us/mac-word-help/video-manage-layers-easily-VA103935555.aspx?CTT=5&origin=HA103528093


2.  You are going to create a 2-page newsletter about yourself.  Directions are listed below to create a successful newsletter.

1.     Open Word.  Word Documents Gallery will appear and choose “Newsletters” under Publishing Layout View.

2.     Choose a layout or design you like. 

3.     When you open it up you may find that there are more than 2 pages in your newsletter.  That is ok.  You will learn how to remove the extra pages.

4.     To Remove pages from your newsletter complete the following :

a.     Click on the document pane map: it looks like the show or hide sidebar.
  

b.     The side panel will appear to the left of your document.  Click on the Layout tab. You will see on the ribbon the options for layout.  The first set is pages.  Here you will see an Add button and a remove button.  Before hitting the remove button make sure you have the correct page in your side bar selected that you would like to remove. 

5.     Please save your document as yourname_newsletter.

6.     The main title on your newsletter should be your name. 

7.     You may want to change the color scheme of your newsletter.  To achieve this make sure you are on your Home tab.  You will see at the end of the ribbon a themes button select one that you might like to use. 

8.     Fill in the text boxes with information about you and your friends.  What you like to do, what you did this summer, things you like (food, music, etc).  Remember to be school appropriate!

9.     Change the pictures on your newsletter.  One of them should be of just yourself.  You can take it using photobooth.  The other photos should be of the things you talk about in your newsletter. If you are taking pictures from the internet you must copy the URL of where you are taking it from so you may cite it properly on your page.
     
      Change the text in the text boxes to reflect things about you.

Styles, Themes and templates

 Differences between styles, themes and templates.

Important Notes:

1.  What are word styles? 

 An effective tool to apply or format styles to different sections of your text in your document.  By applying styles to your paper you can easily create a table of contents with a click of a button or 2. 

2.  What is a theme? 

A way to coordinate colors and fonts.  This can help give your document a designer-quality look. 

3.  What is a template? 

Files that help you design professional looking documents.  These files are completely formatted and all you have to do is personalize it with your information.

Your Task: 

Styles

1.  Watch the video on styles

http://office.microsoft.com/en-us/videos/video-reveal-the-power-of-styles-VA102755322.aspx?CTT=5&origin=HA103528093

2.  Complete the tutorial on styles, by clicking on this link: 

            file:///Users/melissa/Downloads/Word%20tutorial%20-%20Format%20text%20with%20styles.pdf

You will need to download the practice file to complete the activity.  It is located on the first page of the tutorial-heading Practice file, file name is Styles.docx, click on the practice file name and it will appear. 

Please save it as styles_yourname. 

Reminder:  make sure that you pay attention to where you save it. 

Word Pre-Assessments

Today and tomorrow, I am going to ask you to partake in a questionnaire and two pre-assessments, knowledge and skill based,  using Microsoft Word.  

This allows me to see what areas students need the most instruction in.  They will be scored, however they will not count as a grade in the grade book,.  They will be used to show learning growth over the course. Therefore everyone should work independently.  

The questionnaire and the assessments have been emailed to you.  Please check your email and complete all three assignments.  

Intro to Word

There are a lot of bells and whistles in Microsoft Word, but it all starts with the ribbon.
Today we are going to tackle a few of them.

1.  Please watch this 2 minute video for a great overview of the ribbon. Click on the link below to watch.

http://office.microsoft.com/en-us/mac-word-help/video-up-to-speed-with-the-office-for-mac-ribbon-VA102748545.aspx?CTT=5&origin=HA103528093

2.  Click the link questionnaire to check for understanding.
https://docs.google.com/forms/d/1lUWR8KUooX2IpgM0NFbIklwXn6vMSWjMVMvYraZvtzw/viewform


3.  Go to your email and get the Basic Word Tutorial.
http://office.microsoft.com/en-us/mac-word-help/word-for-mac-2011-basics-RZ103895284.aspx

Make sure you click download and then save to your desktop folder.

Google Breach of Security and Reliable Sources

Some  of you may have heard that Google has had a security breach, so today I want you to do some research on it.
I am going to take this current event and turn into a real life learning activity.


1.  I would like you to find 3 articles online about Google's security breach.  Open up each one in its own window, read them, and then copy and paste their information into the form I have attached here.

https://docs.google.com/forms/d/1prUzKEIaOqwtYtGfy9HNeNSakvMGlmy5VkKVdr09qwU/viewform
2.  Answer all the questions on the form.

Evaluating Websites

Try these steps on one of the websites you used yesterday to see if it were a good source of information. 

The following was taken from:

http://www.lib.berkeley.edu/TeachingLib/Guides/Internet/Evaluate.html

Techniques for Web Evaluation :

1. Find out what other web pages link to this page.

a. Use alexa.com:

Type or paste the URL into alexa.com's search box.

Click on the "Get details" button.

You will see, depending on the volume of traffic to the page:

·       Traffic details.

·       Contact/ownership info for the domain name.

·       "Related links" to other sites visited by people who visited the page.

·       Sites linking in to the page.

b. Do a link: search in Google, Yahoo!, or another search engine where this can be done:

1. Copy the URL of the page you are investigating (Ctrl+C in Windows).

2. Go to the search engine site, and type link: in the search box.

3. Paste the URL into the search box immediately following link: (no space after the colon).

The pages listed all contain one or more links to the page you are looking for.

If you find no links, try a shorter portion of the URL, stopping after each /.
Note: Different search engines give very different results for "link:" searches. We suggest trying more than one.

2. Look up the title or publisher of the page in a reputable directory that evaluates its contents (ipl2, Infomine, About.com, or a specialized directory you trust). 

3. Look up the author's name in Google or Yahoo!

For the most complete results in Google, search the name three ways:

a. without quotes:  Firstname Lastname

b. enclosed in quotes as a phrase:  "Firstname Lastname"

c. enclosed in quotes with * between the first and last name:  "Firstname * Lastname" (The * can stand for any middle initial or name in Google only).