QT1

=Computer Applications II - Daily Assignments First Marking Period=


 * 1) Voki & Do Now: How does your Voki represent you?
 * 2) Do Now: Define Kinesthetic
 * 3) Do Now: Define Aural
 * 4) 9/17 What does your chart say about you?
 * 5) 9/18 Do Now: What are 3 techniques from the reading that can help?
 * 6) 9/25 Learning Styles Essay and Chart
 * 7) 9/28 Do Now: What do you already know about spreadsheets. Put on the form.
 * 8) 9/29 ShoeSize.xls
 * 9) 10/1 Exploring Spreadsheets.doc
 * 10) 10/2 P. 95 Demonstrate Your Knowledge (Paper and pencil)
 * 11) 10/7 BasicEditing.xls / Practice.xls
 * 12) 10/7 BasicEditing.doc
 * 13) 10/9 Demonstrate Your Knowledge P. 99 (paper and pencil)
 * 14) 10/13 SleepTime.doc
 * 15) 10/16 UsingFormulas.xls
 * 16) 10/19 UsingFormulas.doc with Questions and Final Exam Scores and Vacation Expenses
 * 17) 10/20 Do Now: Form on Order of Operations
 * 18) 10/22 Activity2.xls
 * 19) 10/22 UsingFormulasDYK.doc
 * 20) 10/23 Do Now: Spreadsheets online quiz
 * 21) 10/29 Page105.xls
 * 22) 10/29 Page105.doc

Page105 Extend Your Knowledge
 * Thursday October 29, 2009**


 * Monday - Wednesday October 26, 27, 28 2009**

__**Do Now:**__ Save the Page105.doc Word document to the desktop. Put your name in the header. Make sure it shows just the correct period for your class.

__**Assignment:**__ Go to page 105 in your ** red notebook **, to the Chapter Review and Assessment on Spreadsheet Basics. The page has two sections, Think Critically and Extend Your Knowledge For the Think Critically section follow these steps for problems 1 to 5:

For the Extend Your Knowledge section, follow these steps for problem A. Do Extend Your Knowledge problem B. Proofread. Make it look nice.
 * Type the question.
 * Do what it is referring to in a spreadsheet that you save with the filename, Page105.xls
 * Copy and paste the example cells into your Word document.
 * Answer the question in sentences.
 * Make the worksheet described on sheet 2 of your Page105.xls spreadsheet.
 * Create the chart.
 * Do a Copy and Paste Special of the table to the Page105.doc Word document.
 * Do a Copy and Paste Special of the chart to the Page105.doc Word document.



Do Now:
 * Friday October 23, 2009**

Make sure you type your name in the correct spot and then click on Start Quiz. media type="custom" key="4633952"  **__Assignment:__** Study spreadsheet vocabulary by using these techniques at @http://quizlet.com/_s8o2

Finish back work.

Go over UsingFormulasDYK.doc Finish back work.
 * Thursday October 22, 2009 **

**Only if you are finished with all previous work!!!!!** When you finish UsingFormulasDYK.doc and Activity2.xls create Word Art of vocabulary words. Make the document landscape and put 1 word on a page. Show it to Miss Hangen. Vocabulary Words:

__**Do Now:**__ Please excuse my dear Aunt Sally. media type="custom" key="4607800"
 * Tuesday and Wednesday 10/20, 21/09**


 * __ Assignment: __**

Save to this file to the desktop. Put your name in the header. Do the **Demonstrate Your Knowledge** problems in the document. Before answering the question for Activity #2, make an Excel spreadsheet with the filename **Activity2.xls**. Save it to the desk top. Follow the directions in the red notebook or these here.


 * Type January in cell A1 and use AutoFill to enter the remaining months of the year through June in A6.
 * Enter the following values in B1 through B6: 10, 12, 14, 15, 9, 12
 * In cell C3, write a formula using cell references for finding the average of the values from B1 to B3.
 * In cell C6, write a formula for finding the average of the values from B4 to B6.
 * Copy the area of the spreadsheet used to another area of the spreadsheet.
 * In the first copy, change the following values:
 * Change B3 next to March from 14 to 20. What do you think will happen to the average?
 * Change B4 next to April from 15 to 9. What do you think will happen to the average?
 * Compare the numbers in C3 and C6 to the answers in the other copy where you didn't change values.
 * Select the area of the spreadsheet used to copy it.
 * Get into your **UsingFormulasDYK.doc** document and do a **Paste Special (Excel worksheet object)** at the bottom left of page 2 to the left of the answer box for Activity # 2. Make the answer textbox small so you can see the spreadsheet object.
 * In the answer textbox, explain why the results change automatically when you change the data.

__**Ticket out the Door:**__ Save to the desktop. Upload **UsingFormulasDYK.doc** to your Gaggle digital locker. Upload **Activity2.xls** to your digital locker.

__**Do Now:**__ Get into your Gaggle digital locker. Save **UsingFormulas.xls** to the desktop. Make graphs of both of your tables in **UsingFormulas.xls** If you already made **UsingFormulas.doc** in Word, save that from your Gaggle locker to your desktop.
 * Friday and Monday 10/16, 19/09**

Create a Word document with the filename, **UsingFormulas.doc** Use the same type header and footer we used for SleepTime.doc Directions for creating a header and footer. Copy and **Paste Special as Excel Objects,** your tables and graphs from **UsingFormulas.xls** spreadsheet. -- Final Exam Scores table -- Final Exam Scores graph -- Vacation Expenses table -- Vacation Expenses graph Open this file. Select everything and do a right click to copy and paste its contents into your **UsingFormulas.doc** Word document below your tables and graphs. Put the answers to the questions in the textboxes.
 * __ Assignment: __**

__**Ticket out the Door:**__ Save to the desktop and upload to your Gaggle digital locker.

**__Do Now:__** Read pages 100 to 102 in your **red** notebook. (Highlight as needed.) Lesson 7-3 Using Formulas
 * Thursday 10/15/09**

Spreadsheet: Filename - **Using Formulas.xls**
 * __Assignment:__**

On **sheet 1** create the **Final Exam Scores** table that appears at the bottom of page 100. Make sure to use a **formula** for the **average**.



On **sheet 2** create the **Vacation Expenses** table at the bottom of page 203. Use **formulas** as indicated. Remember that you can format the cells rather than typing the $ and .00 everytime.



Change at least one number in each column. Notice the average and totals change.
 * __Ticket out the Door:__ **



If they do not change, go back and put in formulas using fx.

 Save both **UsingFormula.xls** to your desktop and upload to your digital locker.

__ **Do Now:** __ Get into your Gaggle digital locker. Save **SleepTime.xls** to the **desktop**. Verify that you have a formula in the cell next to the word Average.
 * Monday and Tuesday 10/12, 13/09**

Create a Word document with the filename **SleepTime.doc** Use the **standard header and footer** demonstrated by Miss Hangen On the spreadsheet copy the table from sheet1 to sheet 2. //**Watch the average change.**// Make a column graph of you data. Copy the table and paste it into your Word document. Copy the graph and paste it into your Word document. Now copy, but this time use Paste Special and choose the Excel Spreadsheet choice.
 * __Assignment:__ **
 * Change the table to reflect your hours of sleep.**
 * What changes and doesn't change when you edit the table in Word?**
 * How is this version different?**

Save both **SleepTime.xls** and **SleepTime.doc** to your desktop and upload to your digital locker.  __ **Do Now:** __ Read page 97 in your red notebook. Highlight what is new to you.
 * __Ticket out the Door:__ **
 * Friday 10/9/09**

__**Assignment:**__ After you read the directions for Activity 2, look at the back of the paper for more details. Open Excel and save the spreadsheet to the **desktop** with the filename **SleepTime.xls** Have the header include your name, CS200, and your period. Also include your name in a cell on the form.
 * Do page 99, Demonstrate Your Knowledge**

Email SleepTime.xls to jchangen@lancaster.gaggle.net as an attachment Add SleepTime.xls to your digital locker. Turn in the Demonstrate Your Knowledge paper.
 * __Ticket out the Door:__ **

__ **Do Now:** __ Get into your Gaggle digital locker. Choose Practice.xls When the gray box appears, choose **SAVE**. Save the file to your **desktop.** Once downloaded, open it. Also from your digital locker, choose **BasicEditing.doc** and **SAVE** to the **Desktop** when the gray box appears. When the gray box says **Download Complete**, open it.
 * Tuesday, Wednesday, Thursday 10/6, 7, 8/09**

__**Assignment:**__ We will continue working through pages 96-98, by reading and trying the techniques on the Practice.xls spreadsheet. As we do this, we will answer the questions on the BasicEditing.doc document.

**__Ticket out the Door:__** Upload the documents that have been saved to your desktop, to your digital locker.



__**Assignment:**__ Basic Editing Functions Read pages 96-98 in the red notebook. Save this file to your desktop, and fill in the answers.
 * Monday 10/5/09**

**__Ticket out the Door:__** Upload the document to your digital locker. 

__ **Do Now:** __ Handout: **Demonstrate Your Knowledge P. 95** Critical Thinking 1 - 3 Activity 1 Extra Credit: Activity 2
 * Friday 10/2/09**
 * // 10 minutes //**

__**Class Lesson:**__ Read Lesson 7-2: Basic Editing Functions Follow along with the demonstrations of techniques.
 * Formatting Dates
 * AutoFill Dates
 * Edit - Fill - Series

Try some of this yourself and save the file as **BasicEditing.xls**

**__Ticket out the Door:__** Upload the spreadsheet that was made during the class lesson to your digital locker.

Finish Exploring Spreadsheets from yesterday.
 * Thursday 10/1/09**

__ **Do Now:** __ Do you understand a little bit more about spreadsheets, now that you made one yourself? Discuss this with a student near you.
 * Wednesday 9/30/09**


 * __Assignment:__ **
 * 1) Open the red notebook to Lesson 7-1 **Exploring Spreadsheets**.
 * 2) Read page 92, silently as I read it aloud.
 * 3) Highlight a sentence or concept in each paragraph.
 * 4) Each person in your row, now takes a turn reading one thing that you highlighted to the rest of your row members.
 * 5) Read page 93, silently as I read it aloud, and watch as I point things out on the screen.
 * 6) Highlight some things on page 93 that are new to you.
 * 7) Each person in your row, now takes a turn reading one thing that you highlighted to the rest of your row.
 * 8) Follow the same process for page 94.

**__Ticket out the Door:__**


 * Select this document [[file:ExploringSpreadsheets.doc]] and **save** it to the **desktop** with the filename, **ExploringSpreadsheets.doc**.
 * Change your name in the header to your actual name and delete the period number that is not yours.
 * Begin answering the questions by double clicking in the cell where the answer should be typed.
 * Save the document and upload it to your Gaggle digital locker.

__Assignment:__ ** Ask the students in your row what shoe size each wears. Create a spreadsheet that displays the names and their shoe sizes. Make the spreadsheet calculate the average show size for your row. Use appropriate labels and make it look nice. Save it to the desktop with the filename, **ShoeSize.xls** Upload to your digital locker.
 * Tuesday 9/29/09

Do Now: media type="custom" key="4746457" Class Activity:** Introduction to Spreadsheets
 * Monday 9/28/09

Finish Learning Styles essay. Open chart page of your learning styles inventory. Get final approval from Miss Hangen to print your documents for grading.
 * Friday 9/25/09**

__Assignment:__ ** Follow the directions below for writing your 6 paragraph essay on your learning styles. Read each sentence out loud with a quiet voice to help catch errors, then fix them. Have another student proofread yours while you proofread his/hers. Include a header and footer that looks like these.
 * Tuesday, Wednesday, Thursday 9/22, 23, 24/09



Directions for making a header and footer.

__ **Do Now:** __ On paper explain what aural means or give some synonyms?  **__Assignment:__** 
 * Monday 9/21/09**
 * Use your notes from researching your learning styles to write a 6 paragraph essay.**
 * Use Word and the filename, LearningStyles.doc** @http://www.learning-styles-online.com/


 * First paragraph:** Name the learning styles on which you scored 10 or higher. These are your main learning styles. Give the styles and scores and some introductory information.
 * Second paragraph:** In your results, which is higher, solitary or social?
 * Describe the characteristics of this learning style.
 * How does this student learn best?
 * What are common pursuits (careers)?
 * How does this learning style information apply to the way you learn/study and acta as a student?
 * Third through fifth paragraphs:** Answer the following questions about the 3 learning styles on which you scored the highest. Each style must have its own paragraph.
 * Describe the characteristics of this learning style.
 * How does this student learn best?
 * What are common pursuits (careers)?
 * How does this learning style information apply to the way you learn/study and acta as a student?
 * Last paragraph:** Summarize what you learned from this test and how it might help you in your role as a student.

**__Ticket out the Door:__** Save your documents to the desktop. Upload all documents you worked on today, to your gaggle locker. Log out of Gaggle. Delete your document files from the desktop. Empty the recycling bin. Close all programs that are open or minimized so you get back to the plain desktop. Clean your area, putting trash in the trash can. Stay in your seat until the bell rings.  __ **Do Now:** __ Read the LearningStyles page of this wiki. What are 3 of these techniques that you think would help you as a student? Explain why. Type this in your Voki.doc or DoNow.doc that is in your gaggle digital locker. Save and upload the new version. Send me an email with the document attached or the text from the document pasted into the body of the email. My email address is jchangen@lancaster.gaggle.net
 * Friday 9/18/09**

**__Assignment:__** 
 * Use your notes from researching your learning styles to write a 6 paragraph essay.**
 * Use Word and the filename, LearningStyles.doc** @http://www.learning-styles-online.com/


 * First paragraph:** Name the learning styles on which you scored 10 or higher. These are your main learning styles. Give the styles and scores and some introductory information.
 * Second paragraph:** In your results, which is higher, solitary or social?
 * Describe the characteristics of this learning style.
 * How does this student learn best?
 * What are common pursuits (careers)?
 * How does this learning style information apply to the way you learn/study and acta as a student?
 * Third through fifth paragraphs:** Answer the following questions about the 3 learning styles on which you scored the highest. Each style must have its own paragraph.
 * Describe the characteristics of this learning style.
 * How does this student learn best?
 * What are common pursuits (careers)?
 * How does this learning style information apply to the way you learn/study and acta as a student?
 * Last paragraph:** Summarize what you learned from this test and how it might help you in your role as a student.

**__Ticket out the Door:__** Save your documents to the desktop. Upload all documents you worked on today, to your gaggle locker. Log out of Gaggle. Delete your document files from the desktop. Empty the recycling bin. Close all programs that are open or minimized so you get back to the plain desktop. Clean your area, putting trash in the trash can. Stay in your seat until the bell rings.

**__ Do Now: __** Get into your gaggle digital locker. Double click on **Memletics-Learning-Styles-Inventory.xls**. If you are not finished marking the 0, 1, 2, save it to the desktop and complete it and put your name in the header. If you are finished, open it and study the chart and graph. In gaggle, find your Do Now document and save it to the desktop. **Open it add to it an explanation of what you think that the results of this learning styles inventory means about you.** Save it and upload the new version to your gaggle locker, at which time you can delete the old one.
 * Thursday 9/17/09**

**__Assignment:__** Fill out the notes paper by starting with a list of the styles with your scores ranked from highest to lowest. Research the learning styles for which you have the highest scores first, followed by the rest of them, and put notes on the paper. Use the links at @http://www.learning-styles-online.com/ gather information for your notes sheet. These notes will eventually be used to create an essay. Also research at other websites. See the LearningStyles page of this wiki.

**__Ticket out the Door:__** Save your documents to the desktop. Upload all documents you worked on today, to your gaggle locker. Log out of Gaggle. Delete your document files from the desktop. Empty the recycling bin. Close all programs that are open or minimized so you get back to the plain desktop. Clean your area, putting trash in the trash can. Stay in your seat until the bell rings.