If anyone is working on projects this weekend, remember, you can submit them by going under the links page at the top of this post.  Enjoy your few days with friends and family!

Before beginning this project Mr. Sillman will go over the basic functions and vocabulary of Microsoft Excel.  Please refer to the Excel reference post for help or review.

TP – Students will collect, manipulate , and calculate data using Microsoft Excel

Please go to this link for the Excel project on Fast Food Fun:

http://www.wmburgweb.com/Resources/Lesson/spreadsheet.htm

This project will use both Excel and Word to gather, manipulate, and process data about fast food.

1. Pick a fast food restaurant chain.

2. Choose four items from the menu – It must include an entree (burger, salad, chicken), a side (fries, mashed potatoes, chili), a drink (soda, milk, juice), and a desert (ice cream, pie, cookie).

3. Find the Calories and the Calories from Fat for each item.

These sites might help:

http://menustat.org/advanced-search/

http://www.fastfoodnutrition.org/

http://nutrition.mcdonalds.com/getnutrition/nutritionfacts.pdf

 

4. To help you set up the spreadsheet click the link above. Click on the SAMPLE SPREADSHEET link under the word food.

5. Enter that data into the spreadsheet you have created.

6. Create math formulas to find the rest of data (I will help).

7. At the bottom of the SAMPLE SPREADSHEET page click the link for Charts.

8. Follow the directions on the charts to create a bar graph and a pie chart.

9.  You will then have a writing piece which will make you think about the following questions:

After looking at these numbers, do you think this is a healthy meal?  How could you make it better for you?

Here is the rubric to help you out:

Fast Food Rubric

TP – Students will learn to hyperlink by creating a historical timeline.

Do you think you have completed your timeline and are ready to move on?  Look over these questions before you do:

1.  Is the file named properly so I know who worked on it and from what class it is from?

2.  Do you have at least 4 links to slides and 2 to websites?

3.  Did you include a resource page (where you got your information and pictures)?

4.  Did you look over your spelling, grammar, and sentence structure?

5.  Is your information accurate and from reliable sources?

6.  Can you get back to the initial timeline from your other slides?

Check out the rubric and self reflect t to make sure you are satisfied with your project:

timelinerubric

If you think you are done, please fill out Mr. Sillman’s exit slip.  The link is on this site.

TP – Students will learn about balancing a checkbook (decimals & money) by using an Excel template

First, the class will have a discussion on banks, checks, and money balances.

Next the students will download the template for the checkbook:

Checkbook Template

Students will follow the teacher’s instructions and the checkbook lesson guide, which can be found at:

Guide

 

Before beginning this project Mr. Sillman will go over the basic functions and vocabulary of Microsoft Excel.  Please refer to the Excel reference post for help or review.

TP – Students will learn to create mathematical formulas and analyze data by using functions in Microsoft Excel

First, look over the tutorials and helpful links under the previous post.

Next, download the word file located below:

VampiresWS

Then, open Microsoft Excel.

Once you have the spreadsheet and worksheet open, follow the directions on the worksheet along with answering the questions on it.

You will be completing the worksheet in Word and the spreadsheet in Excel.  Both will be handed in to be graded.

Pay careful attention to the directions and questions.  One simple mistake can throw off all your numbers.

TP – Students will refresh their knowledge of Excel basics by reviewing websites and tutorials

http://sunburst.usd.edu/~bwjames/tut/excel/1.html   (starts simple, but becomes informative)

http://www.gcflearnfree.org/excel2007

http://spreadsheets.about.com/od/excelformulas/ss/2010-12-25-excel-2010-basic-tutorial-pt1.htm

http://www.fgcu.edu/support/office2007/Excel/

http://www.bgsu.edu/downloads/cio/file15626.pdf   (very informative booklet)

If your feeling like you want extra credit…http://pjnicholson.com/excel_game/jigsawgame.html

 

TP – Students will create a Jeopardy game by researching and using a template

As you begin to finish your project, please ask yourself the following questions before submitting:

1.  Does it function?

2.  Do the answers match with the questions?

3.  Do the links work?  Do I go back to the playing board after the questions?

4.  Have I named all the categories on the playing board?

5.  Are my facts correct?

6.  Did I look over my spelling and grammar?

If you are able to answer all of these questions with YES, then you may submit the file.

Take a look at the rubric for assistance if needed:

Jeopardy Rubric

Go to the new links section of this page.  Fill out the online Exit Slip for Mr. Sillman.

If you finish early, I would like you to get yourself used to Microsoft Excel for our next lesson by looking at the new post.

 

TP – Students will create a database of observations to identify minerals

1.  First, students will create an outline of their database.  This will include a category for Color, Streak, Luster, Hardness, and any other identifiable feature.

2.  Next, students will observe the minerals and record the observable features into the database.

3.  Then, students will perform the routines needed for determining the hardness and streak.

• For hardness, you will begin by scratching the mineral with your nail.  If it does not scratch, you will try a penny.  If that does not work, you will try a steel nail.  The higher the level of scratch needed = higher hardness of the mineral.
• For streak, you will put the mineral against the streak plate and scratch across.  The color left behind is the streak.  If you do not see a color, it is the color of the tile or clear.

4.  After the database is filled with all the observations, you will compare your chart to the one I have posted here:

mineral-identification-chart

You will try to identify the name of the mineral and record it on your chart.