Tuesday, March 5- Spreadsheet Vocabulary Review

What are we learning today? Reviewing spreadsheet vocabulary & voting on Project PowerPointsBellringer-
1.On Page 52 type lines 5,6, and 7
and save your work. 


2. How much do you remember? Go to Spreadsheet vocabulary game.
By yourself or with a partner take turns and playhttp://www.quia.com/hm/174125.html?AP_rand=933500499&playHTML=1
You need to complete the questions until it says 100%
raise your hand for the teacher to see 100% completed and
 write down the score, you will not be graded.(It can’t be saved)
There is a pink vocabulary guide between every desk!

3.Pull up Edmodo

For each category pick the best PowerPoint
AND answer the Voting questions on the worksheet:
Why do you like the project you voted for?
What is the design evidence? (liked animation, font, colors, easy to understand, etc.)What one thing will you change on your PowerPoint and why?

Monday, Mar 4- Spreadsheet formatting

Bellringer-
On Page 52 type lines 1,2, and 3
Pull up Edmodo
What are we learning today?
How to format a spreadsheet

Guided lesson:

Review Sub plan for Tues.Take practice poll.Explain voting polls.

Review Voting questions:
Why do you like the project you voted for?
What is the design evidence? (liked animation, font, colors, easy to understand, etc.)
See practice poll for ideas.

What one thing will you change on your PowerPoint and why?

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
You need to complete the questions until it says 100% and note score but you will not be graded.(It can’t be saved)

Independent exercise:

Math Operations Worksheet (1st four problems)
Formatting Practices (need for Project)

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

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

Friday, Mar 1- Spreadsheet Formulas

Bellringer:
On Page 49 type lines 4, 5, and 6.
Finish questions 11, 12, and 13
Finish adding 10 cars to your car lot exercise at http://www.carmax.com

Guided lesson:
Remember you will get a grade for bringing the report back signed.
You get a 100 if it is back by today.
You will get a 95 if it is back by Monday.

Open “Spreadsheet Vocabulary" PowerPoint-  math operations and formulas (slides 21 - 35)

Independent exercise:
Open a NEW spreadsheet file.
We will practice typing in formulas as a group and then individually.
We will review the following daily spreadsheet skill exercises using your car lot spreadsheet.
Write the questions and answer questions 14-19.

If there is time we will format our car lot spreadsheet.
Skill 7- format table, Skill 13- data bars,
Skill 23- change color of tabs, Skill 31 formatting cells

Thursday, Feb 28- Spreadsheets- Parts

Bellringer:
On Page 46 type lines 5 and 6.

Guided lesson:
6th and 7th period will get back their project grades.
All remaining interim reports will be passed out.
Remember you will get a grade for bringing the report back signed.
You get a 100 if it is back by Friday.
You will get a 95 if it is back by Monday.

“Spreadsheet PowerPoint Presentation” parts of spreadsheet vocabulary describing- cell, column, row, cell range, cell address, and active cell, label, value (slides 9-22)
Independent exercise:
Students will write out study guide questions 11-13.

Open your Car lot exercise file-
Add 10 cars and their information to your car lot exercise spreadsheet.
Only use http://www.carmax.com/ to look for cars.
Remember to get the year, make, model, miles and price.

We will review the new vocabulary terms using our car lot spreadsheet.

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

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, Feb 27 - Spreadsheets and Careers

Bellringer:
On page 44, type lines 9 and 10 and 14

Guided lesson:

“Spreadsheet PowerPoint Presentation”
describing uses of spreadsheets (slides 11-15)
(what if analysis, charts and graphs)

Who uses spreadsheets? People, who use 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.

Write and answer questions 11 and 12 from the Spreadsheet Vocabulary PowerPoint.

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

Tuesday, Feb 26- Finish Internet Safety, Start Spreadsheet Unit

Bellringer- 
On Page 43 type lines 4, 5 and 6

What are we learning today?
We are finishing Internet Safety.
Add video to Edmodo. (NOT Design section)
Review original Internet Safety questions and revise as needed.

The uses of spreadsheets and how having this skill can help you get a job.

61,000 jobs require knowing how to use spreadsheets.
1. Go to http://www.simplyhired.com/a/jobs/list/q-spreadsheet and look at your monitor number.
2. Go to that number's page and find one job that needs spreadsheets.
3. 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? People, who use 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 Internet safety?
Do NOT print certificate. Once you have 100% show Miss W.http://www.att.com/Common/images/safety/game.html

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

Monday, Feb 25 - Internet Safety Part 2 Privacy

Bellringer:
1. Change your Project PowerPoint to Video
if your computer didn't get it finished Friday.
Try a different computer.
2. Sign into Edmodo
3. On page 37 type lines 4, 5 and 6.
4. If you were absent on Friday
Edmodo Codes:
1st period dnbfza
2nd period wf6o1l
6th period jl6fe0
7th period 9khspf
5. If you have a Project video completed
reply and attach the video to the CORRECT
section on the Edmodo Design Project Page.

What are we learning today?
We are learning how to protect ourselves from cyberbullies and internet predators.

Guided Practice:
@Students will watch and discuss the Cyberbully videos.
@Your grade will be a participation grade.
@ AFTER the lesson, you will review and answers and make changes.
@ In groups of 2 to 3 answer the following questions on Edmodo.

1. What would you do if someone sent you a mean text?
2. What would you do if someone online said they were going to hurt you?
3. What would you do if someone you do not know asks to be your friend on Facebook or MySpace?
4. What would you do if someone wanted to borrow your password?
5. What things should you not share on Facebook or MySpace?
6. What would you do if someone keeps bothering you online?
7. Would you ever want to post something online that you wouldn’t want your family to see, or your teachers to see, or the college you want to go to?