Assignments

= = Excel - Creating a Pie Chart

-To Do: You will be researching calorie counts, focusing on carbohydrate, fat, and protein calorie content. Locate one food item for this assignment. You may use your own sites or try the following link: [|Wolfram|Alpha] Example of assignment:

On Sheet 2 (**Rename** Sheet 2 to //**3 Foods**)// collect information on 3 items of food. For each item include the following labels: Calorie, carbohydrate, fat, and protein. Create a **Bar chart** on a separate Sheet. You can create it on your data sheet and then Right click and Move chart to a New Sheet and call the New Sheet **Bar Chart.** Make sure to included a Chart Title and call it **Food Comparisons**.
 * Create** the data and the chart on Sheet 1 - **Rename** Sheet 1 to //**Pie Char**//t.

Save your entire document as **Calories** and link the spreadsheet onto a new page called **Calories** in your wikispace.

=Part 2=

Go to your **Calories** page in your wikispace and write a reflection about the spreadsheet project. Write everything about the project that you learned and what you liked. What did you learn about different foods by graphing them and comparing them. Did you enjoy formatting charts?

Investigate this link: @http://www.plasticforkdiaries.org/4u2do/cat_1_0_play.html

**Excel - Formatting Cells**
-To Do: Crossword Puzzle -You will be creating a crossword puzzle using Excel to learn how to format cells and make changes to the text you have entered. Some of the technology skills utilized in this lesson include the following:
 * adding borders to cells
 * adding color to cells
 * adding text to cells
 * moving between worksheets
 * saving work

Attached is an example of this assignment:
 * 1) Develop 8 terms to be used in the crossword puzzle.
 * 2) Next come up with the clues for each term. Utilize your favorite resources such as Google, Dictionary.com, etc to locate the definitions. Compile these terms on a sheet named //Terms//.
 * 3) Name a new worksheet as //Puzzle//.
 * 4) Name a new worksheet as //Answer Sheet.//
 * 5) Click on the following document to get the directions for creating your crossword puzzle. [[image:http://www.wikispaces.com/i/mime/32/application/x-zip.png width="32" height="32" link="file:bms8tech1/crossword puzzle directions.docx"]] [[file:bms8tech1/crossword puzzle directions.docx|crossword puzzle directions.docx]]

iMovie Information:
To Do:
 * Create a children's story (or remake an existing one) that can be made into a movie
 * Audience: 2nd or 3rd grade students
 * Time of movie: 3-4 minutes
 * Details:
 * Include a title slide in your movie
 * Include a credits slide in your movie
 * How?
 * Work with your group to develop a script
 * Script must be narrated into iMovie
 * Script can be written on illustrated pages and/or typed on iMovie frames
 * Work with your group to illustrate age appropriate scenes
 * Work with your group to scan and import your graphics into iMovie
 * General Expectations:
 * Use class time appropriately
 * Each member contributes to product (e.g. ideas, images, script, computer work, etc.)
 * Each group member is expected to illustrate at least two images (or work collaboratively on images)
 * Problem-solving is a must
 * Work on one machine (e.g. if you will be gone, let your partner know and work around absences)
 * Groups


 * Alexis J. || Colton H. || Summer R. || Logan K. ||
 * Autumn G. || Payton B. || Kylie D. ||  ||
 * Clair B. || Gabe P. || Marina S. ||  ||
 * Danielle L. || Brooklyn U. || Jackson H. ||  ||
 * Jace W. || Kareena M. || Alex D. ||  ||
 * Jordyn F. || Kaden N. || Caleb L. ||  ||
 * Kali D. || Tatum B. || Brooklin N. ||  ||
 * Matt H. || Kennedy G. || Bradley C. ||  ||
 * Sabrina S. || Tony B. || Carson J. ||  ||
 * General Time:
 * Day 1: Select story/create story
 * Day 2: Develop script, start drawing illustrations, color illustrations
 * Day 3: Develop script, draw illustrations, scan images to computer
 * Day 4: Develop script, draw illustrations, scan images to computer
 * Day 5: Import still images to iMovie, narrate script, insert transitions, edit scenes
 * Day 6: Import still images to iMovie, narrate script, insert transitions, edit scenes
 * Day 7: Import still images to iMovie, narrate script, insert transitions, edit scenes
 * Day 8: Import still images to iMovie, narrate script, insert transitions, edit scenes
 * Day 9: Final editing and export movie to Quick Time
 * = **Reflection** =

Complete a reflection of the Imovie project by creating a new page on your wikispace and calling it Imovie Story. Then just type on the page and answer the following questions:

 * 1) How do you think your group worked together overall? Give your project a grade and justify your reasons for that grade.
 * 2) Explain who did what during each step of the process.
 * 3) What would you do differently if you had to do the project again?