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

Monday- Oct 1, Spreadsheets- Uses

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

Congratulations to our September Typing Olympics Winners!
Please see the wall in front of the room. September's Winners have been posted.

What are we learning today?
The uses of spreadsheets and how having this skill can help you get a job.

61,000 jobs require knowing how to use spreadsheets. Go to  http://www.simplyhired.com/a/jobs/list/q-spreadsheet and look at your monitor number.
Go to that number's page and find one job that needs spreadsheets.
You will need to give the name of the job and a sentence that DESCRIBES the job.

For example: If you are sitting at monitor 20, go to page 20 and pick one job from that page.

Guided lesson:

“Spreadsheet PowerPoint Presentation” describing uses of spreadsheets (slides 1-8)

Who uses spreadsheets? Uses of spreadsheets http://www.teach-ict.com/gcse_new/spreadsheets/spreadsheets/miniweb/pg9.htm

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.

Car lot exercise-  
1*Students will create a spreadsheet of dream cars that they would have in their own car lot business.
2*Open the "car lot" file found in student docs, Witkowski folder, Spreadsheet folder and save to your lunch number.  3*Students will go to http://www.carmax.com and find 3 cars and type the information (year, make(brand), model(name), miles, and price) into their spreadsheets.

If there is time, we will review the following daily spreadsheet skill exercises:

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

Skill 24- transpose data, 18- themes, and 16 hide and show rows

Exit Activity   
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