Monday, Oct 8 Spreadsheets- functions

Bellringer- We are learning the number keypad.
http://www.typeonline.co.uk/number_pad_big_plus_lesson3.htmlChoose exercise 2 and then click on the word “start.” Time will not start until you put your cursor in the white rectangle and start typing. Record your typing speed and accuracyTo hear bellringer message

Go to Student Docs- Witkowski- Spreadsheets- SS flash cards- exercise 22 Pie Chart

What are we learning today?
Values in formulas, math operations and the "Home" ribbon
4.3 Know Spreadsheet operations

Guided Lesson:

Daily spreadsheet skill exercises-

Skill 22- pie chart (chart tools then design tab),  Skill 4- sparklines(insert),
Skill 20- icon sets (under conditional formatting)

 

Explanation about Ribbon Questions DO NOT PRINT UNTIL MISS W SAYS OK

When you get finished with the hurricane spreadsheet, you will start working on the Ribbon worksheet. You need to decide if you want to type or write your answers. We are going to go over how to save and how to do the exercise.

Spreadsheet Formulas and Functions- hurricane worksheet-
DO NOT WRITE ON WORKSHEET USE YOUR OWN PAPER

·         Students need to find the values and rewrite the formulas with them.

·         1^st do number 7.  =Sum(f8:f10) = f8 + f9 + f10   = 0+075+6   =81

·         SUM means to add all of the numbers in the range (group of cells)

In Column K Students will type in formulas and see if the numbers match up

·         Save  hurricanes files to lunch number

2010 Ribbon- “Home” ribbon exercise sheet

Start on the Excel Home Tab Ribbon Sheet Worksheet
you may write or type the answers but do NOT print until Miss W checks it.
Make sure if you are typing you save to your lunch number.

Exit Activity- SmartBoard formative testing of vocabulary How much do you remember about Spreadsheets? By yourself or with a partner take turns and play http://www.quia.com/hm/174125.html?AP_rand=933500499&playHTML=1