Thursday, October 18, 2012

Friday, Oct 19- Vocabulary Test

On page 92 of your TYPING BOOK, type line 10 and 15 and 20
To hear bellringer message

If you have not finished your project, go to your lunch number and
open your value of exports project and work on it



What we are learning today?
Vocabulary test 
4.3 Know Spreadsheet operations

PROJECT and TEST SCHEDULE
Friday- Vocabulary test (hangman game) ALL PAST DUE WORK TURNED IN

Independent Exercise:
1. Take Multiple Choice Test if absent on Thursday
2. Take Vocabulary Test Vocabulary review link
3. Finish Spreadsheet Unit Project
4.  Finish any outstanding work
5. Take October Olympic typing contest choose EXERCISE 8 at http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
6. Write down the questions and answers missed on the Multiple Choice test

Wednesday, October 17, 2012

Thursday, Oct 18- Multiple Choice Test

On page 91 of your TYPING BOOK, type line 5
On page 92 of your TYPING BOOK, type lines 12 and 18
To hear bellringer message

If you have not finished your project, go to your lunch number and
open your value of exports project and work on it



What we are learning today? 
Multiple Choice test on the 25 study guide questions
from the Presentation and Spreadsheet lessons.

4.3 Know Spreadsheet operations

PROJECT and TEST SCHEDULE
Thursday- 26 Question multiple choice PowerPoint and Spreadsheet Content test
Friday- Vocabulary test (hangman game)
ALL PAST DUE WORK TURNED IN

Don't forget to take home your vocabulary definitions to study.

Independent Exercise:
1. Take Test
2. Finish Spreadsheet Unit Project
3. Finish any outstanding work
4. Vocabulary review link
5. Take October Olympic typing contest choose EXERCISE 8 at http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
6. 2nd and 7th periods- If time- Work 3 of the Fun with Formulas exercises ON YOUR OWN

Tuesday, October 16, 2012

Wed, October 17- Multiple Choice Test Review

You may sit anywhere you like on the rows 
with construction paper.   :)  :)
The rows are teams
for the Review Game.
On page 87 of your TYPING BOOK, type line 5
On page 88 of your TYPING BOOK, type lines 12 and 18
To hear bellringer message

If you have not finished your project, go to your lunch number and
open your value of exports project and work on it

What we are learning today?
Review for Multiple Choice test on the 25 study guide questions
from the Presentation and Spreadsheet lessons.
 

4.3 Know Spreadsheet operations

PROJECT and TEST SCHEDULE
Wednesday- Jeopardy 26 Question PowerPoint and Spreadsheet game
Thursday- 26 Question multiple choice PowerPoint and Spreadsheet Content test
Friday- Vocabulary test (hangman game)
ALL PAST DUE WORK TURNED IN

Don't forget to take home your study guide questions and vocabulary definitions to study.

Independent Exercise:
Finish Unit Project
Finish any outstanding work
Vocabulary review link







Monday, October 15, 2012

Tuesday, Oct 16 Excel Project


Bellringer:

On page 83 of your TYPING BOOK, type line 5

On page 84 of your TYPING BOOK, type lines 12 and 18

To hear bellringer message

Everyone go to your lunch number and open your value of exports project


2nd period

Go to Student Docs- Witkowski- Spreadsheets- SSflash cards- Skill 19- hide worksheets

What are we learning today?
Project that uses all skills such as formatting data, creating charts and analyzing data
4.3 Know Spreadsheet operations

PROJECT and TEST SCHEDULE
Tuesday- finish project and vocabulary review
Wednesday- Jeopardy 26 Question PowerPoint and Spreadsheet game
Thursday- 26 Question multiple choice PowerPoint and Spreadsheet Content test
Friday- Vocabulary test (hangman game)
ALL PAST DUE WORK TURNED IN

Don't forget to take home your study guide questions and vocabulary definitions to study.

Guided Lesson:
The Unit Project's directions will be explained

2nd period ONLY Daily spreadsheet skill exercises-
Skill 19- hide worksheets (right click bottom worksheet tabs)
Skill 10- freeze panes (view tab)

Independent Exercise:
Finish Unit Project
Finish any outstanding work
Vocabulary review link

Sunday, October 14, 2012

Monday, Oct 15- Relative Cell Referencing





Bellringer:

On page 79 of your TYPING BOOK, type line 5
On page 80 of your TYPING BOOK, type lines 12 and 18

To hear bellringer message

Go to Student Docs- Witkowski- Spreadsheets- vocabulary test word list file
AND go to Student Docs- Witkowski- Spreadsheets- Spreadsheet Vocabulary PowerPoint
AND go to Student Docs- Witkowski- Spreadsheets- value of exports project

If you didn't finish on FRIDAY
Write out questions 20 through 23 and answer with an a, b, c or d


What are we learning today?
Relative versus Absolute cell referencing and reviewing Vocabulary
Start Unit Project
4.3 Know Spreadsheet operations

PROJECT and TEST SCHEDULE
Monday- start project
Tuesday- finish project and vocabulary review
Wednesday- Jeopardy 26 Question PowerPoint and Spreadsheet game
Thursday-  26 Question multiple choice PowerPoint and Spreadsheet Content test
Friday-     Vocabulary test (hangman game)
ALL PAST DUE WORK TURNED IN

Guided Lesson:
The Unit Project's directions will be explained

2nd period ONLY Daily spreadsheet skill exercises-
Skill 06- alignment of data (home tab- top of alignment group)
Skill 19- hide worksheets (right click bottom worksheet tabs)
Skill 10- freeze panes (view tab)

Independent Exercise:

****STUDY GUIDE QUESTIONS****
In the Spreadsheet Vocabulary PowerPoint-
copy questions 24, and 25 and write an a, b, c or d answer.

Start unit project.

Vocabulary review link

Thursday, October 11, 2012

Friday, Oct 12 Spreadsheets Study Guide Questions

Bellringer:
On page 75 of your TYPING BOOK, type line 5

On page 76 of your TYPING BOOK, type lines 12 and 18

To hear bellringer message

Go to Student Docs- Witkowski- Spreadsheets- fun with basic formulas and functions file
AND go to Student Docs- Witkowski- Spreadsheets- Spreadsheet Vocabulary PowerPoint

Write out questions 20 through 23 and answer with an a, b, c or d

What are we learning today?
Typing and Inserting formulas and functions and reviewing Vocabulary
4.3 Know Spreadsheet operations

Guided Lesson:

2nd period ONLY Daily spreadsheet skill exercises-
Skill 06- alignment of data (home tab- top of alignment group)
Skill 19- hide worksheets (right click bottom worksheet tabs)
Skill 10- freeze panes (view tab)

Independent Exercise:

****USING FUNCTIONS****
1. You need 2 different color markers, crayons, etc.
2. Write your name on small worksheet.
3. You are going to highlight all of the mathematical operation words (add, divide, subtract, multiply) in one color and you are going to highlight all of the range cell references (A1:B10) (A10 through C10) ETC. in another color.
4. You will have the following instructions:
  • type- means you need to type out the formula the function button will not work because they are not adjacent numbers.
  • extra c- means extra credit. if you TYPE the problems correctly you have a chance to win candy
                  you may SKIP extra credit problems if you like
  • function button- means you may use the function button to answer the questions
5. Go to the fun with basic formulas and functions file
6. You will need to READ and TYPE formulas or use functions for the 10 problems.

You MUST get the RIGHT FORMULA!!!!


****STUDY GUIDE QUESTIONS****
In the Spreadsheet Vocabulary PowerPoint-
copy questions 20, 21, 22 and 23 and write an a, b, c or d answer.




Wednesday, October 10, 2012

Thursday, Oct 11- Multiple Math Operations in formulas and functions


Bellringer-

On page 71 of your TYPING BOOK, type line 5

On page 72 of your TYPING BOOK, type lines 12 and 18

To hear bellringer message

Go to Student Docs- Witkowski- Spreadsheets- SS flash cards- exercise 6 alignment of data

What are we learning today?
Typing and Inserting formulas and functions and Vocabulary review
4.3 Know Spreadsheet operations

Guided Lesson:
Daily spreadsheet skill exercises-
Skill 06- alignment of data (home tab- top of alignment group)
Skill 19- hide worksheets (right click bottom worksheet tabs)
Skill 10- freeze panes (view tab)

Independent Activity- SmartBoard formative testing of vocabulary
How much do you remember about Spreadsheets?
By yourself or with a partner take turns and play.
Today it is not a test, but it will be a test at the end of the Spreadsheet unit.
Make sure you click on VIEW RESULTS and stay on that page until Miss W checks it.
Miss W will draw names to see which students will play it on the Smartboard.
http://www.quia.com/hm/174125.html?AP_rand=933500499&playHTML=1

For 2nd period ONLY

Rules for Thursday's candy challenge.
1. All class work must be completed.
2. You work alone and quietly.
3. You do not get upset if you do not win.
4. Miss W is the final judge.

For all Classes:
Depending on time we will either begin the "Fun with basic formulas and functions" worksheet
  or
write and answer the next study guide questions 20 through 23.