home

=Computer Applications II CS200 Periods 3, 6, 7=

//Objective: Create a bar graph from a table of your own data.// Make a table of the estimated number of hours you slept each night during the vacation. __Excel Filename__: **MyVacationSleep.xlsx**
 * Monday January 3, 2011**

__Excel Filename__: **MyVacationSleep.xlsx** Use your own data and the appropriate days of the week to make a column graph out of your table. __Word Filename:__ **MyVacationSleep.docx** Create a Word document like the example, but make sure it includes your own actual data for the appropriate days. Use different fonts, colors, etc.. Print when finished. Upload to your gaggle digital locker. Put your red binder to the back of the room and return to your seat until the bell rings.

//Objective: Create a greeting card in Microsoft Publisher.//
 * Thursday December 23, 2010**

__Publisher Filename__: **HolidayCard.pub** Use Microsoft Publisher to create a Christmas card or other greeting card for someone. Get permission from Miss Hangen to print it.

Upload to your gaggle digital locker.

//Objective: Create a bar graph from a table.// Use an Excel file with a table of data or chart to look for the icons. __Paper and Pencil__: Tell which menu the icon is in of the 3 choices of Chart Tools menus: **Design**, **Layout**, or **Format**. 1. Change Chart Type 2. Legend 3. Shape Fill 4. Word Art Styles 5. Axis Titles 6. Select Data 7. Chart Layouts 8. Chart Title 9. Data Labels 10. Axes __Excel Filename__: **SleepTime.xlsx** __Word Filename:__ **SleepTime.docx** Follow the directions. You may format your chart differently, but make sure it has all the elements of the one in the directions. Print when finished. Upload to your gaggle digital locker. Put your red binder to the back of the room and return to your seat until the bell rings.
 * Tuesday & Wednesday December 21 & 22, 2010**

//Objective: Understand editing within a spreadsheet////.// //Objective: Compare and contrast values and labels in a worksheet.// //Objective: Describe ways to enter, edit, and format data in a worksheet.// //Objective: Evaluate the benefit of printing options.// Get your red binder and open to the 3 new pages in the back titled, **Basic Editing Functions in Spreadsheets**. Open your **BasicEditing.docx** document. __Word Filename:__ **BasicEditing.docx** Answer these questions in a Word document. Include your standard header and footer and examples. Finish answering questions 5 through 8 by referring to the pages in your binder and thinking about your experience using Excel. 5. What is a print area and how do you set it? 6. What appears in a cell when it is too narrow for a number? What can be done do see the number? 7. How can a spreadsheet be used at home? 8. How can a spreadsheet be used in school? Upload to your gaggle digital locker. Put your red binder to the back of the room and return to your seat until the bell rings.
 * Monday December 20, 2010**

//Objective: Understand editing within a spreadsheet////.// //Objective: Compare and contrast values and labels in a worksheet.// //Objective: Describe ways to enter, edit, and format data in a worksheet.// //Objective: Evaluate the benefit of printing options.// Get your red binder and open to the 3 new pages in the back titled, **Basic Editing Functions in Spreadsheets**. Open your **BasicEditing.docx** document. Create an Excel spreadsheet with the filename, **BasicEditingCharts.xlsx** that looks like this. __Word Filename:__ **BasicEditing.docx** Answer these questions in a Word document. Include your standard header and footer and examples. __Excel Filename__: **BasicEditingCharts.xlsx** Create a column graph and a pie chart in **BasicEditingCharts.xlsx** and include them with your answer for #4. Upload to your gaggle digital locker. Put your red binder to the back of the room and return to your seat until the bell rings.
 * Thursday & Friday December 16 & 17, 2010**
 * 1) What are the 3 types of data that you can enter in a worksheet?
 * 2) What is AutoFill, and how is it done?
 * 3) What is another name for a chart?
 * 4) What are the purposes of 3 of the types of charts? Include pictures.
 * 5) What is a print area and how do you set it?
 * 6) What appears in a cell when it is too narrow for a number? What can be done do see the number?
 * 7) How can a spreadsheet be used at home?
 * 8) How can a spreadsheet be used in school?

//Objective: Understand editing within a spreadsheet////.// //Objective: Compare and contrast values and labels in a worksheet.// //Objective: Describe ways to enter, edit, and format data in a worksheet.// //Objective: Evaluate the benefit of printing options.// Get your red binder and open to the 3 new pages in the back titled, **Basic Editing Functions in Spreadsheets**. Open your BasicEditing.docx document. __Word Filename:__ **BasicEditing.docx** Answer these questions in a Word document. Include your standard header and footer and examples. Upload to your gaggle digital locker. Put your red binder to the back of the room and return to your seat until the bell rings.
 * Monday-Wednesday December 13-15, 2010**
 * 1) What are the 3 types of data that you can enter in a worksheet?
 * 2) What is AutoFill, and how is it done?
 * 3) What is another name for a chart?
 * 4) What are the purposes of 3 of the types of charts?
 * 5) What is a print area and how do you set it?
 * 6) What appears in a cell when it is too narrow for a number? What can be done do see the number?
 * 7) How can a spreadsheet be used at home?
 * 8) How can a spreadsheet be used in school?

//Objective: Read about news in computing.// //Objective: Summarize nonfiction.// //Objective: Do a random act of kindness.// __Paper and Pencil__: 1. On the lined paper write the 2 computer definitions given for hacker at http://dictionary.com.
 * Friday December 10, 2010**

Random //Hacks// of Kindness is a play on words taken from the concept of //Random Acts of Kindness// which may have come about to bring happy moments to those in a world where there are often //random acts of violence//.

__Read__: Read the packet titled, **Random Hacks of Kindness** __Paper and Pencil__: 2. On the lined paper, write a summary of what you read in sentences. 3. Also write what you might put in a blog entry sharing your thoughts about the event. @http://www.randomactsofkindness.org/

Finish back work.

__Paper and Pencil__: 4. What will you do as a random act of kindess (or a random hack of kindness) over the next few days? Turn in your lined paper with your name on it. Turn in the stapled packet titled. **Random Hacks of Kindness** so it can be used for other classes.

//Objective: Understand editing within a spreadsheet////.// //Objective: Compare and contrast values and labels in a worksheet.// //Objective: Describe ways to enter, edit, and format data in a worksheet.// //Objective: Evaluate the benefit of printing options.// Get your red binder and open to the 3 new pages in the back titled, **Basic Editing Functions in Spreadsheets**. __Word Filename:__ **BasicEditing.docx** Answer these questions in a Word document. Include your standard header and footer and examples. Upload to your gaggle digital locker. Put your red binder to the back of the room and return to your seat until the bell rings.
 * Thursday December 9, 2010**
 * 1) What are the 3 types of data that you can enter in a worksheet?
 * 2) What is AutoFill, and how is it done?
 * 3) What is another name for a chart?
 * 4) What are the purposes of 3 of the types of charts?
 * 5) What is a print area and how do you set it?
 * 6) What appears in a cell when it is too narrow for a number? What can be done do see the number?
 * 7) How can a spreadsheet be used at home?
 * 8) How can a spreadsheet be used in school?

//Objective: Understand editing within a spreadsheet////.// //Objective: Compare and contrast values and labels in a worksheet.// //Objective: Describe ways to enter, edit, and format data in a worksheet.// //Objective: Evaluate the benefit of printing options.// Get your red binder and open to the 3 new pages in the back titled, **Basic Editing Functions in Spreadsheets**. __Read and Mark Up:__ **Basic Editing Functions in Spreadsheets** Keep these questions in mind while reading the 3 page document. Put your red binder to the back of the room and return to your seat until the bell rings.
 * Wednesday December 8, 2010**
 * 1) What are the 3 types of data that you can enter in a worksheet?
 * 2) What is AutoFill, and how is it done?
 * 3) What is another name for a chart?
 * 4) What are the purposes of 3 of the types of charts?
 * 5) What is a print area and how do you set it?
 * 6) What appears in a cell when it is too narrow for a number? What can be done do see the number?
 * 7) How can a spreadsheet be used at home?
 * 8) How can a spreadsheet be used in school?

//Objective: Collaborate to complete a Google spreadsheet.// Go to http://Google.com and use the **more** drop down menu to choose **documents**. Create a Google account with your Gaggle email address. Make sure to **remove the check** by After Miss Hangen unblocks the email that Google sent to your Gaggle email address, verify your account by clicking on the link in your Gaggle email. Login to your Google docs account. Click on **Shared with me** and double click on the Google spreadsheet, **States Period 3**. If you get a blocked message, close the message and click on **Create New** and pick one. Close it and try the shared document, **States Period 3** again. It should open this time. Research the states, their populations, capitol cities, and nickname and fill in the Google spreadsheet. It should go pretty fast because everyone in the class is working on the same spreadsheet.
 * Monday, Tuesday December 6,7, 2010**

Log out of your Google account.

//Objective: Demonstrate 3 ways to include a spreadsheet in a Word document.// Get into your Gaggle digital locker. Save Basics.xlsx to your desktop and open it. __Word Filename:__ **Basics.docx** Read and follow the directions on pages 1 through 3of **Putting a Spreadsheet in a Word Document**. When finished, print. Save to the desktop, upload to Gaggle, delete off the desktop, empty recycle bin.
 * Wednesday - Friday December 1-3, 2010**

//Objective: Create a spreadsheet that demonstrates the use of formulas.// __Paper and Pencil:__ Write formulas for cells A3 and B3. Cell A3 must contain the product of the contents of cells A1 and A2. Cell B3 must contain the quotient of the contents of cells B1 and B2. __Excel Filename:__ **Basics.xlsx** Read and follow the directions on pages 1 through 21 of Excel Basics. It guides you through creating a 1 page Excel file. Save to the desktop, upload to Gaggle, delete off the desktop, empty recycle bin.
 * Monday & Tuesday November 29 & 30, 2010**

//Objective: Use x-y coordinate system and random numbers.// Discuss things you do over Thanksgiving weekend. __Scratch Filename:__ **Thanksgiving.sb** Save to the desktop, upload to Gaggle, delete off the desktop, empty recycle bin.
 * Monday & Tuesday November 22 & 23, 2010**

//Objective: Determine if it is ok to divide.// Finish **ExcelNotes.docx** __Scratch Program:__ **Divide.sb** Save to the desktop, upload to Gaggle, delete off the desktop, empty recycle bin.
 * Thursday & Friday November 18 & 19, 2010**

//Objective: Review spreadsheet tools including the cursor/pointer shapes.// Get into Gaggle. Save your **ExcelNotes.docx** to the desktop.
 * Wednesday November 17, 2010**

Right click to save this picture to the desktop and use it to copy and paste the cursor/pointers into the chart that you will create on page 4 of **ExcelNotes.docx**.



Get permission to print your finished document from Miss Hangen. Save to the desktop, upload to Gaggle, delete off the desktop, empty recycle bin.

//Objective: Review spreadsheet tools including those on the formula menu ribbon, data menu ribbon, review menu ribbon, and view menu ribbon.//
 * Tuesday November 16, 2010**

Get into Gaggle. Save your **ExcelNotes.docx** to the desktop.

Continue working on creating this document. Page 3 shown here. Save to the desktop, upload to Gaggle, delete off the desktop, empty recycle bin.

//Objective: Review spreadsheet tools including those on the home ribbon, insert ribbon, header and footers tools, and pay layout ribbon.//
 * Monday November 15, 2010**

Get into Gaggle. Save your ExcelNotes.docx to the desktop.

Continue working on creating this document.

Save to the desktop, upload to Gaggle, delete off the desktop, empty recycle bin.

//Objective: Review spreadsheet tools.//
 * Friday November 12, 2010**

Display your ComparisonShopping.xlsx file on the screen for Miss Hangen to check.

Word Filename: **ExcelNotes.docx** Include your standard header and footer.

Save to the desktop, upload to Gaggle, delete off the desktop, empty recycle bin.

//Objectives: Use a spreadsheet to comparison shop. Use autofill.//
 * Thursday November 11, 2010**

__Paper and Pencil:__ Explain how you would go about comparing prices for a product that you would buy online. Excel Filename: **ComparisonShopping.xlsx** Layout - Orientation - Landscape Use AutoFill to number from 1 to 5. Use a formula to calculate the total. Copy the formula to the other cells by dragging from the AutoFill square at the lower right hand corner of the cell. Include your standard header and footer.

Save to the desktop, upload to Gaggle, delete off the desktop, empty recycle bin.