QT2

//Objective: Assessment//
 * Friday January 28, 2011**

MidTerm Exam You **need** to look in Word and Excel and use your binder. You must have the cursor on a chart to see the Chart Tools menu. You must have a picture selected to see the Picture Tools menu. __//**You must do this silently and individually.**//__ Finish AIM.docx
 * Part II: Multiple Choice**

//Objective: Assessment// Include the usual header and footer. Save to the desktop and upload to your Gaggle digital locker. Print!!!
 * ﻿ Thursday - Tuesday January 20-25, 2011**
 * MidTerm Exam **
 * Part I: Word/Excel Project Tables & Graphs Created within a Word Processing Document **
 * Filename: AIM.docx **
 * __//You must do this silently and individually.//__ **
 * Follow the directions in the back of your red binder. **
 * If you would like to make the spreadsheet portion in Excel and copy and paste special into Word you may. **

//Objective: Create a spreadsheet with formulas.//
 * Wednesday January 19, 2011**

__Read__: Read pages 100 to 102 in your **red** notebook. (Highlight as needed.) __Excel Filename__: - **Using Formulas.xlsx**
 * Lesson 7-3 Using Formulas**

1. 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**.

2. Make a copy of the Final Exam Scores on another worksheet tab and change the copy to **show formulas**.

3. On another worksheet tab 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.



4. Make a copy of Vacation Expenses on another worksheet tab and change the copy to **show formulas**. 5. Rename the worksheet tabs appropriately.

6. Change at least one number in each column. Notice the average and totals change.



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

 Save **UsingFormula.xlsx** to your desktop and upload to your digital locker.

//Objective: Use a spreadsheet to create a checkbook.//
 * Thursday & Friday January 13 & 14, 2011 Pd 6, 7**

Discuss this question with another student: What is the difference between a debit and a credit? __Excel Filename__: Checkbook.xlsx

Follow the directions on 4 pages in your binder.



Upload to your gaggle digital locker. //Objective: Use analytical thinking to create a working clock in Scratch.//
 * Friday January 14, 2011 Pd 3**

On Clock Do Now handout, answer these questions also: 1. How many seconds are in a minute? Write as a ratio. 2. How many minutes are in an hour? Write as a ratio. 3. How many seconds are in an hour? Write as a ratio. 4. How many degrees are in a circle? 5. How many numbers appear on the clock? 6. How many degrees must the second hand move in 1 second? Write as a ratio. 7. How many degrees does the minute hand move in 1 hour? Write as a ratio. Reduce the fraction to show how many degrees the minute hand moves in 1 second. 8. How many degrees are there from the number 12 to the number 1, from the number 1 to the number 2, etc? Write as a ratio. 9. How many degrees does the hour hand move in 1 hour? Write as a ratio. Reduce the fraction to determine how many degrees the hour hand moves in 1 second. __Scratch Filename__: **Clock.sb** Use your own ingenuity and the 1 page handout, titled Clock.sb Directions to create a program in Scratch that operates as a clock. . Upload to your gaggle digital locker.

//Objective: Use analytical thinking to create a working clock in Scratch.// //Objective: Use the modulus operator to calculate the remainder.// __Friday__: Search google images for a clock face. Save it to the desktop. __Monday__: Clock Do Now handout. __Tuesday__: On Clock Do Now handout, answer these questions also: 1. How many seconds are in a minute? 2. How many minutes are in an hour? 3. How many seconds are in an hour? 4. How many degrees are in a circle? 5. How many numbers appear on the clock? 6. How many degrees must the second hand move in 1 second? 7. How many degrees does the minute hand move in 1 hour? Reduce the fraction to show how many degrees the minute hand moves in 1 second. 8. How many degrees are there from the number 12 to the number 1, from the number 1 to the number 2, etc? 9. How many degrees does the hour hand move in 1 hour? Reduce the fraction to determine how many degrees the hour hand moves in 1 second.
 * Friday - Monday January 7 - 10, 2011**

__Scratch Filename__: **Clock.sb** Use your own ingenuity and the 1 page handout, titled Clock.sb Directions to create a program in Scratch that operates as a clock. . Upload to your gaggle digital locker. Put your Do Now paper and the directions in your binder. Put your red binder to the back of the room and return to your seat until the bell rings.

//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 - Thursday January 3 - 6, 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.