QT3

=Computer Applications II CS200 QT3 Pd 3, 6, 7=

//Objective: Create a digital picture story about a place, topic, or event that you are interested in.// Get into your Gaggle digital locker. Save the photos that you did not import into your PhotoStory yet, to the desktop. Save your PhotoStory file to your desktop. Save your PhotoData.xlsx to your desktop. __Filename__: **PhotoStoryPdxLastname.wp3** __Add music__: You may use more than one selection of music. Select the photo where you want the specific music to start and follow the prompts, and then select another photo where you want different music to start... __Powerpoint Slides__: Make a title slide and save it as **Title.jpg** Make works cited slides and save them as **Credits1.jpg, Credits2.jpg** etc Import the title and credits files into your PhotoStory. __Finish as necessary__: Import photos into PhotoStory Edit photos Add titles to some photos. Customize Motion Add transitions.
 * Tuesday March 29, 2011**

Save to your desktop and upload to your Gaggle digital locker.

//Objective: Create a digital picture story about a place, topic, or event that you are interested in.// Get into your Gaggle digital locker. Save the photos that you did not import into your PhotoStory yet, to the desktop. Save your PhotoStory file to your desktop. __Filename__: **PhotoStoryPdxLastname.wp3** Import photos into PhotoStory Edit photos Add titles to some photos. Customize Motion Add transitions. Save to your desktop and upload to your Gaggle digital locker.
 * Thursday - Monday March 24-28, 2011**

//Objective: Create a digital picture story about a place, topic, or event that you are interested in.// __Finish__: **PeopleSort.xlsx** from directions in your binder. Print the **FirstName** worksheet.
 * Thursday - Wednesday March 17-23, 2011**
 * PeopleSort.xlsx Directions** (pages 1 - 10)
 * PeopleSort.xlsx Directions Part 2** (pages 1 - 4)
 * PeopleSort.xlsx Directions Final Part** (page 1)

**Decide what you want as the place, topic, or event for a digital picture story that you are going to create with Photostory.** __Planning and Preparation:__ __Excel Filename__: **PhotoData.xlsx** Change the format of the web address column and the notes column to alignment **wrap text**. Change the **Page Layout** to a **landscape** orientation. Save to your desktop and upload all the photo files and PhotoData.xlsx to your Gaggle digital locker.
 * Find photos and save photos to the desktop with meaningful names.
 * Take notes in a spreadsheet, so you have material to help you make captions or do narration.
 * Document the websites used, in the spreadsheet so you have them for the works cited page.
 * Log the file names you used in the spreadsheet.
 * [[image:hangencs200:PhotoData.PNG width="811" height="175"]] ||
 * = **Use these headings for PhotoData.xlsx ** ||
 * 1) Make a spreadsheet file where you will save information about the pictures.
 * 2) Search online for photos from a country or place you would like to visit.
 * 3) Save each of the photos to your desktop with a descriptive name.
 * 4) In the spreadsheet include the web address where you found the photo to use in the works cited.
 * 5) In the spreadsheet include notes to help you produce captions and narration.
 * 6) If you gets notes at a different website than where you found photos also log the website for the notes.
 * 7) In the spreadsheet include the descriptive filename you gave so you can find it easily.
 * 8) Save the Excel file to your desktop.
 * 9) Upload the PhotoData.xlsx and your photos to your Gaggle digital locker.

//Objective: Use the IF function in spreadsheets.// //Objective: Use conditional formatting in spreadsheets.// //Objective: Initiate various sorts in spreadsheets.// Save **PeopleSort.xlsx** to your desktop from your Gaggle digital locker.
 * Wednesday March 16, 2011**

Follow **PeopleSort.xlsx Directions Part 3** in your binder. Save to your desktop and upload to your Gaggle digital locker. Get permission to print.

//Objective: Use the IF function in spreadsheets.// //Objective: Use conditional formatting in spreadsheets.// //Objective: Initiate various sorts in spreadsheets.// Save **PeopleSort.xlsx** to your desktop from your Gaggle digital locker.
 * Tuesday March 15, 2011**

Follow **PeopleSort.xlsx Directions Part 2** in your binder. Save to your desktop and upload to your Gaggle digital locker.

//Objective: Use the IF function in spreadsheets.// //Objective: Use conditional formatting in spreadsheets.// __Paper and Pencil__**:** 1. Write the function that is in cell C5? 2. What is the cell address for the cell that contains this function? 3. Describe what this long nested IF function does? 4. What will happen if the score for Alberto is corrected to 66? (Try it to see what happens.) 5. What will happen if the score for Jennifer is changed to 91? (Try it to see what happens.) Get into your Gaggle digital locker and save your **PeopleSort.xlsx** file to your desktop. -In **F1** put the heading, **Kid/Adult** -In **G1** put the heading **Roman Numeral Age** -In cell **F2**, use the **IF** function to have Excel determine whether the person is a kid or an adult based on the data in the age cell. -Use **autofill** to copy the function to the rest of the cells in **column F**. -In cell **G2**, use the **=ROMAN** function to display the Roman numeral for the age. -Use **autofill** to copy the function to the rest of the cells in **column G**. -Use the **Page Layout** menu to choose **Print Area** - **Set Print Area**. Make sure to choose cells A1 through G51. -Save -Make sure that all the columns fit across one page. The will be 2 pages of rows. -Save to the **desktop** with the filename, **PeopleSort.xlsx**. __Paper and Pencil__**:** 6. What are Roman numerals? Turn in your Do Now and Ticket out the Door.
 * Monday March 14, 2011**

//Objective: Sort data in spreadsheets.// //Objective: Use conditional formatting in spreadsheets.// __Paper and Pencil__**:** Write a couple sentences to tell what to do when you get to a stop sign when you are in a car. 1. Use Word, to create a flowchart of what to do at a traffic light. __Word Filename:__ **IfFunctionFlowchart.docx** 2. Watch Pass Fail video @http://video.about.com/spreadsheets/IF-Function-in-Excel.htm and make a spreadsheet in Excel that does the same thing. __Excel Filename__: **IfFunctionExample.xlsx** 3. Include whatever Miss Hangen demonstrates in your files. 4. Use copy and paste special to put the spreadsheet into your Word document. 5. Save both the Excel and the Word to your desktop and upload to your Gaggle digital locker.
 * Friday March 11, 2011**
 * Part I:**

Go through the following tutorials and example pages to find out how to us the **IF** function in Excel. @http://www.free-training-tutorial.com/animations/if-statement-numbers.html @http://www.free-training-tutorial.com/animations/if-statement-text.html __Paper and Pencil__**:** What do you want to use as the break off age for being a kid or an adult for the PeopleSort.xls assignment? Put your answer on your Do Now paper. Turn in the paper with your Do Now and Ticket out Door
 * Part II:**
 * IF Tutorials:**

//Objective: Sort data in spreadsheets.// //Objective: Use conditional formatting in spreadsheets.// __Excel File__: **Oscars.xlsx** Save your file in Gaggle to the desktop.
 * Friday & Monday March 4 & 7, 2011**

__Excel File__: **Oscars.xlsx** Follow Miss Hangen's directions which will include: - Use in column F. - Use autofill for column F. - Change fill for those you want to see. - Use **conditional formatting** to indicate the top money makers. - Use **conditional formatting** to indicate the shortest films. - Duplicate to sheets 2,3, and 4. - Sort sheet 1 alphabetically. - Sort sheet 2 in descending order by gross income. - Sort sheet 3 in ascending order by playing time in minutes. - Sort sheet 4 by a method of your choice. Save to the desktop and upload to Gaggle.

//Objective: Sort data in spreadsheets.// //Objective: Use conditional formatting in spreadsheets.// __Excel File__: **Oscars.xlsx** Find the file in the March 3, 2011 folder in the Thawspace. Save the file to your desktop. Put your name and period number in the existing header.
 * Thursday March 3, 2011**

__Excel File__: **Oscars.xlsx** Follow Miss Hangen's directions which will include: - Total in appropriate cell - Average in appropriate cell - Use **conditional formatting** to make Y's bold and green - Use conditional formatting to make N's bold and red - Understand that around a number means it is negative. Upload to Gaggle.

//Objective: Sort data in spreadsheets.// //Objective: Use conditional formatting in spreadsheets.// __Excel File__: **PeopleSort.xlsx** Save the file to your desktop. Go through ALL of the directions on the 10 pages in the back of your binder. Some of these things you already did; however, there are directions for new and different things that must be done.
 * Wednesday March 2, 2011**

__Excel File__: **PeopleSort.xlsx** Go through ALL of the directions on the 10 pages in the back of your binder. Some of these things you already did; however, there are directions for new and different things that must be done. Keep the file open and when it is wonderful, have Miss Hangen check it at your seat. __Scratch Program__: **Mod.sb** Picture directions are in your binder. Upload to Gaggle.

//Objective: Sort data in spreadsheets.// //Objective: Use conditional formatting in spreadsheets.// __Excel File__: **PeopleSort.xlsx** Format according to the directions in your binder. Include the header and footer shown on the paper in your binder. If you are finished with **PeopleSort.xlsx** (for now. We will be doing more with it soon.) then do __Scratch Program__: **Mod.sb** Picture directions are in your binder. Upload to Gaggle.
 * Friday - Tuesday February 25 - March 1, 2011**

//Objective: Sort data in spreadsheets.// //Objective: Use conditional formatting in spreadsheets.// Print previous assignments that have not yet been printed. __Excel File__: **PeopleSort.xlsx**
 * Wednesday & Thursday February 23 & 24, 2011**
 * 1) Create a Spreadsheet in Excel and save it to the desktop with the filename, **PeopleSort.xlsx**
 * 2) Make it look like the one provided.
 * 3) Fill in names and data for 50 people.
 * 4) They can be friends, relatives, students in this class, famous people, etc.
 * 5) If you don't know the age, estimate it or in the case of a famous person, look it up online.
 * 6) Save to the desktop and upload to your Gaggle digital locker.

Upload to Gaggle.
 * !!!!!We will be doing more with this spreadsheet.!!!!!**

//Objective: Create professional looking tables in Excel.// //Objective: Format cells professionally.// //Objective: Use formulas and functions to do calculations.// //Objective: Make professional looking graphs in Excel.// Look over your Student Detail Report to see your grades on the assignments in this class during the 3rd marking period. The assignments circled in red have not been turned in. __Finish and Print Missing Assignments:__ All of these were started in Excel and copied and pasted (special as Excel objects) into Word. The directions and a copies of what the final products should look like are in the back of your binders. Upload to Gaggle. When you are finished get permission from Miss Hangen to print.
 * Friday & Tuesday February 18 & 22, 2011**
 * LineGraph.docx**
 * RecreateGraphs.docx**
 * FECtables.docx**

//Objective: Create professional looking tables in Excel.// //Objective: Format cells professionally.// //Objective: Use formulas and functions to do calculations.// Highlight the locations on the paper where you will need to include the **sum** function in the spreadsheet. Here is the first one.
 * Monday - Thursday February 14- 17, 2011**

__Excel File:__ **FECtables.xlsx** Create the tables in Excel. Make them look just like the ones on the paper. Include formulas in the appropriate cells. Format as money where necessary.
 * Suggestion**: Use a different worksheet tab for each table.
 * Reminder**: To have 2 lines of text in one cell use **Home - Format - Format Cells - Alignment - Wrap Text**.

__Word File__: **FECtables.docx** Copy the tables from Excel and **Paste Special as Excel Objects** into a Word document. Include your standard header and footer. Upload to Gaggle. When you are finished get permission from Miss Hangen to print.
 * In your document, explain how the use of lines and the thickness of the lines helps make the tables more meaningful.**

//Objective: Obtain data from a graph.// //Objective: Create a column graph from a table of data.// //Objective: Analyze data and draw conclusions.// __Word File__: **RecreateGraphs.docx** Include our standard header and footer. The title which goes in the header is **Federal Election Commission Data in Column Graphs**.
 * Wednesday February 9, 2011**

__Filename__: **RecreateGraphs.docx** Follow **Recreate Graphs** directions in your binder, and refer to the final product key as well.

Upload to Gaggle.

//Objective: Obtain data from a graph.// //Objective: Create a column graph from a table of data.// //Objective: Analyze data and draw conclusions.// __Paper and Pencil__: Look at the graph to determine the fundraising numbers for the democratic committees and write either of these tables (filled in) on your paper.
 * Tuesday February 8, 2011**

__Excel File__: **RecreateGraphs.xlsx** Type the fundraising data into the spreadsheet.

__Filename__: **RecreateGraphs.xlsx** Follow **Recreate Graphs** directions in your binder to make the graph for the democratic committees.

Upload to Gaggle.

//Objective: Obtain data from a graph.// //Objective: Create a column graph from a table of data.// //Objective: Analyze data and draw conclusions.// __Paper and Pencil__: Look at the graph to determine the fundraising numbers for the republican committees and write either of these tables (filled in) on your paper. __Excel File__: **RecreateGraphs.xlsx** Type the fundraising data into the spreadsheet.
 * Monday February 7, 2011**

__Filename__: **RecreateGraphs.xlsx** Follow **Recreate Graphs** directions in your binder to make the graph for the republican committees.

Upload to Gaggle.

media type="custom" key="8245712"

//Objective: Obtain data from a graph.// //Objective: Create a line graph from a table of data.// //Objective: Analyze data and draw conclusions.// __Paper and Pencil__: Look at the graph to determine the number of dollars contributed to candidates. Write the numbers in the appropriate cells in the table. __Filenames__: LineGraph.xlsx, LineGraph.docx Follow directions on paper, **Table from Line Graph**. Upload to Gaggle. Print.
 * Wednesday & Thursday February 2 & 3, 2011**