Wed., Oct 10- Inserting Functions

Bellringer- We are learning the number keypad.
http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
Choose exercise 2 and then click on the word “start.”
To hear bellringer message

Go to Student Docs- Witkowski- Spreadsheets- SS flash cards- exercise 32 calculates average

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

Guided Lesson:

Daily spreadsheet skill exercises-

Skill 32- calculates averages,
Skill 08- removes duplicates  (on data tab and then sort),
Skill 14- merge cells

Open your hurricane file.

Instead of typing formulas we are going to use FUNCTIONS, which are shortcuts that are quicker than typing formulas in by hand.

We are going to practice inserting the following FUNCTIONS or shortcuts:
Sum- adds all of the numbers in a range
Max- finds the largest number in a range
Min- finds the lowest number in a range
Average- calculates the average of a range of numbers
Count- counts the numbers of entries in a range

Excel Home Ribbon Exercise  DO NOT PRINT UNTIL MISS W SAYS OK

Exit 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

Rules for Wednesday'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.

 

Tuesday, October 9- Using Functions in Spreadsheets

Bellringer- We are learning the number keypad.
http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
Choose exercise 1 and then click on the word “start.” R
ecord your typing speed and accuracyTo hear bellringer message

Go to Student Docs- Witkowski- Spreadsheets- SS flash cards- exercise 11 high low lines

What are we learning today? 
"Home" ribbon review, Vocabulary review
4.3 Know Spreadsheet operations

Guided Lesson:

Daily spreadsheet skill exercises-

Skill 11- high low lines (layout tab then lines), Skill 16- hide and show rows (right click),
Skill 20- color scales (under conditional formatting)

Rules for Wednesday'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.
 

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

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.
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.
Today it is not a test but a review, but it will be a test at the end of the Spreadsheet unit.  http://www.quia.com/hm/174125.html?AP_rand=933500499&playHTML=1

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

Friday, Oct 5 Spreadsheets- Charts

Bellringer- We are learning the number keypad.
http://www.typeonline.co.uk/number_pad_big_plus_lesson3.html
Choose exercise 1 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

Open Car lot file and open your green file

What are we learning today?
What if statements. How to create and format charts .

Guided Lesson:
Pull out your study guide questions
Write the correct answers for all of the questions 

Open your to Green file.
What If analysis
What if you change the value in B7 to 10
What if you change the value in C7 to 100
The spreadsheet automatically recalculates new totals for you.
You do not have to retype formulas.

Open your Car lot file.
Sorting
Make sure you have chosen a "Format as Table" style.
Click on the sort arrow by the price.
We are going to sort the most expensive car.
We are going to sort for the least expensive car.
Click on the sort arrow by the miles.
We are going to sort the car with the most miles.
We are going to sort the car with the least miles.

Adding data bars
Click on the price data.
On the Home tab then go to the Conditional Formatting button then choose data bars then choose a color

Chart creation and formatting

• highlight your car lot data
• Insert a column chart
• click on the chart and the Chart Tools Tab will appear
• insert the chart title "My Car Lot". It will explain the chart's purpose.
• insert axis titles "miles" and "price"
• right click on the legend and choose "select data"
• highlight series 1 then click on edit and change to miles
• highlight series 2 then click on edit and change to price
• click on data labels and click on show
• change chart wall
• change chart floor
• make sure you have gridlines they will make the plot area easier to read.

Independent exercise:
Write down study guide questions 18 and 19 and write down a, b, c or d for the answers.
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.

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

Thursday, Oct 4 Spreadsheets- Entering formulas

Bellringer- We are learning the number keypad. http://www.typeonline.co.uk/number_pad_lesson2.html
Choose 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

What are we learning today?
How to enter formulas that calculate the values in spreadsheets.

Guided Lesson:
 “Spreadsheet PowerPoint Presentation” parts of spreadsheet vocabulary describing- cell, column, row, cell range, cell address, and active cell, label, value and formulas

Slides 25 and 27

Note: Just because you are learning about many different ways to format data doesn't mean you want to use all of the methods at once.

Daily spreadsheet skill exercises
Open Exercise Skill 1 ascending order (Home tab)then Skill 13- data bars (Conditional Formatting button)Skill 21- hide gridlines (Page layout tab)

Independent exercise:
Green formula sheet exercise AND
Write down study guide questions 14, 15, 16 and 17 and write down a, b, c or d for the answers.

Guided Lesson:
Correct study guide questions
Write corrected and complete answers for study guide questions 14, 15, 16 and 17

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.

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

Wednesday, Oct 3- Spreadsheets- Formulas

Bellringer- We are learning the number keypad. http://www.typeonline.co.uk/number_pad_lesson2.html
Choose exercise 1 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 accuracy

To hear bellringer message

What are we learning today?
How formulas calculate the values in spreadsheets.

Guided Lesson:
Slides 18 and 19
Open Exercise 31    Skill- Changing data to currency         Skill- using the fill color

Independent Exercise:
On your car lot spreadsheet complete the following formatting:
1. choose a "format as table" style,
2. change the color of the 3 tabs,
3. create a "thick box" border (any color) around your favorite car,
4. fill in that cell with any color
5. and change the data format in the price column to currency.  

6. Write down study guide question 13 and write down a, b, c or d for the answer.  

Guided Lesson:

“Spreadsheet PowerPoint Presentation” parts of spreadsheet vocabulary describing- cell, column, row, cell range, cell address, and active cell, label, value and formulas (slides 20-30)

Independent exercise:

Green formula sheet exercise
Write down study guide question 14, 15 and 16 and write down a, b, c or d for the answers. 

Guided Lesson:
Correct study guide questions
Group slide 27 exercise- more complicated formulas
Write corrected and complete answers for study guide questions 14, 15 and 16

Daily spreadsheet skill exercises-

Skill 15- replace formulas with calculated value, skill 1 ascending order, Skill 13- data bars,

 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

Tuesday, Oct 2- Spreadsheet Vocabulary

Bellringer- We are learning the number keypad. http://www.typeonline.co.uk/number_pad_lesson1.html
Choose 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 accuracy

To hear bellringer message

What are we learning today?

The different parts of a spreadsheet.

Guided lesson:

“Spreadsheet PowerPoint Presentation” definition of spreadsheet, what if analysis, parts of spreadsheet vocabulary describing- cell, column, row, cell range, cell address, and active cell, label, value (slides 9-21)

Independent exercise:

Car lot exercise-   We will review the following daily spreadsheet skill exercises using your car lot spreadsheet:

Skill 7- format table, Skill 13- data bars,
Skill 23- change color of tabs, Skill 31 formatting cells

Students will write out study guide questions 11-13.

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

2nd period only

Charades- each group of three will have 3 minutes to come up with a way to act out one of the people below using spreadsheets. They can say anything but the name of the person.
For example: They can not say "Look at me, I'm an accountant."

Accountants, Teachers,
Engineers, Sales people,
Scientists, Supermarkets,

Market Researchers.

3rd period CONNECTIONs class ONLY

Bullying survey- Go to http://pollev.com

To see results

http://www.polleverywhere.com/multiple_choice_polls/LTE5Nzc0MjUzOA 

http://www.polleverywhere.com/multiple_choice_polls/NzE3MDYwNDA4

http://www.polleverywhere.com/multiple_choice_polls/MTYzODI2MzcyOQ