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?

Friday, Feb 22- Internet Safety- Part 1 Being Safe

Bellringer: Change PowerPoint to Video if your
computer didn't get it finished yesterday.
1. On page 34 type lines 4, 5 and 6.
2.   Sign into Edmodo
      and join the correct period class.
                    Codes:
            1st period   dnbfza
            2nd period  wf6o1l
            6th period   jl6fe0
            7th period   9khspf

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.
@ 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?

Thursday, Feb 21 Slide Show Tab- Choose method of delivery

Bell Ringer:
1. Open up your Typing Word document
2. On page 33 type lines lines 21, 22, 23 and 24

What are we learning today?
Slide Show Tab- Choose method of delivery- Skill number 33 on pink sheet

Guided Practice:
@ Miss W will model how to add narration to your PowerPoint and how to save as a video.
@Students will help each other during the project.

If you were absent on Tuesday sign in to Edmodo.com
Join Group DCLY4o
Make sure your name is on one of the white papers on the board

Today's activity:

1.  Revise your PowerPoint by correcting the mistakes Miss W wrote down.
2.  We will  record  audio on our PowerPoints. See PowerPoinft 6 for instructions.  Slide Show Tab then Record Slide Show then Start Recording

• You may "clear" if you don't like recording

REMEMBER:

• Slowly click the enter button.
• You need to give people time to read your slides.
• Copy your game link ahead of time to the Internet.
• Play the game and discuss it in your narration. 
• More than one person can narrate a PowerPoint.
• No inappropriate language.

3. We will save as a video.
File then Save and Send then create a video

4. Play your video to make sure it sounds good.  
5. Add your attachment to the correct place on Edmodo.
Remember to type your name and topic in the reply box. 
6. Help other students.
 

Wednesday, Feb 20- Part 10 Revise, Add Audio, & Convert to Video

Bell Ringer:
1. Open up your Typing Word document
2. On page 33 type lines lines 18 and 19

What are we learning today?
10 Step Procedure for developing a PowerPoint presentation
3.1 Know the Design Principles
3.2 Know your Target Audience

Guided Practice:
@ Miss W will model the 10 steps to use to develop a PowerPoint presentation.
@Students will help each other during the project.

For students working on the Health project:
How to say "No" to Drugs http://lbhughes.schoolloop.com/RRW

Last week’s work click here for details

You should be FINISHED with:
1. Content on 9 to 10 slides with citations if needed (Worth 50%)
2. Pictures or clip art on all slides with citations if needed
3. Transitions and animations on each slide
4. All of the pink skills from #4 until #32 are on your PowerPoint
Check each note pane for numbers 4 to 32 and circle on your PINK sheet
5. Green design sheet- review all design choices (font size, colors, picture size, etc.)
6. Green design sheet- review all spelling and grammar of EACH SLIDE
7. Sign in to Edmodo.com join Group       DCLY4o
8. Finish all of the work above.
9. Write your name on the board under "Helpers"
10. We will do skill 33 together.

Today's activity:
1. Everyone open a NEW PowerPoint. Insert 3 slides. Add a clip art image to each slide.
2. We will all learn how to record video together.

• Slide Show Tab then Record Slide Show then Start Recording
• You may "clear" if you don't like recording

3. We will all learn how to save as a video together.

• File then Save and Send then create a video

4. We will all delete the "practice" video.
5. If you have completed your EDITS, then you will record audio and save as a video.
6. Add your attachment to the correct place on Edmodo.
    Remember to type your name and topic in the reply box.
 

Tuesday, Feb 19- Step 10 Revise- Finishing Project

Bell Ringer:
1. Open up your Typing Word document
2. On page 32 type lines lines 13 and 14

What are we learning today?
10 Step Procedure for developing a PowerPoint presentation
3.1 Know the Design Principles
3.2 Know your Target Audience

Guided Practice:
@ Miss W will model the 10 steps to use to develop a PowerPoint presentation.
@Students will help each other during the project.

For students working on the Health project:
How to say "No" to Drugs http://lbhughes.schoolloop.com/RRW

Last week’s work click here for details

You should be FINISHED with:
1. Content on 9 to 10 slides with citations if needed (Worth 50%)
2. Pictures or clip art on all slides with citations if needed
3. Transitions and animations on each slide
4. All of the pink skills from #4 until #32 are on your PowerPoint
    Check each note pane for numbers 4 to 32 and circle on your PINK sheet 

Friday's Skills

21	Insert hyperlink so when you click on clipart it goes to link
31	Review Tab- spell check
32	Review Tab- create a comment on the slide you are most proud of creating

5. Green design sheet- review all design choices (font size, colors, picture size, etc.)
6. Green design sheet- review all spelling and grammar of EACH SLIDE
YES, I really mean check for mistakes, :) Part of the scoring rubrics is on the number of mistakes. In high school, college and the working world if you make mistakes in\t can affect your grade and your job. I'm going to be giving you class time to review. EVERYONE should review.

Today's Work
7. Sign in to Edmodo.com join Group dcly4o       DCLY4o
8 . Finish all of the work above.
9. Write your name on the board under "Helpers"
10. We will do skill 33 together at the end of class.

Friday- Feb 15 Step 9 Practice

Bell Ringer:
1. Open up your Typing Word document
2. On page 31 type lines lines 5 and 6

What are we learning today?
10 Step Procedure for developing a PowerPoint presentation
3.1 Know the Design Principles
3.2 Know your Target Audience

Guided Practice:
@ Miss W will model the 10 steps to use to develop a PowerPoint presentation.
@Students will help each other during the project.

For students working on the Health project:
How to say "No" to Drugs http://lbhughes.schoolloop.com/RRW

Yesterday’s work
Step 6 Enter content
· Make sure you have at least 9 slides
· Font should be no smaller than size 24
· Font may need to be bigger than 24 depending on the font you use
· Research your content (IN YOUR OWN WORDS for 6 slides)
· You are allowed 2 quotes with proper citations
· Type your content and research your topic

Step 7 Add and format graphics (pictures), audio and video
· Each page needs at least one clip art or image.
· If you get the image from Google you will need to put a citation under it
· Don’t forget google.com is NOT a citation.
· Click on “see full size image” to get citation information
· Pink skills sheet items (PUT NUMBER IN NOTES PANE)
o 16- have a picture border
o 17- use a picture artistic effect
o 18- change picture color or use an artistic effect or remove background

Step 8 Add animations and transitions
· You need an animation or a transition for each slide
· Pink skills sheet items (PUT NUMBER IN NOTES PANE only ONCE)
o 27- make one transition have a longer or shorter duration
o 28- you may skip
o 29- Go back to your title slide and animate your name
o 30 Change the effect on any of your animations

Understand the Skills Rubric (pink grading sheet)
and the Design and Content Rubric (green grading sheet)
You are creating one PowerPoint but will receive 2 grades.
One grade will be for the technical skills you have learned.
One grade will be for the design skills you learned and the accuracy of your content.

Pink skills sheet items (PUT NUMBER IN NOTES PANE only ONCE)

Step 9- Practice

9	Home Tab- change font color
10	Home Tab- center text
11	Home Tab- use text direction
12	Home Tab- shape fill
13	Home Tab- shape outline and shape weight
14	Home Tab- shape effects
20		Insert Tab- insert shape
21		Insert Tab- insert hyperlink
22		Insert Tab- insert text box (will let you position pictures on slide)
23		Insert Tab- insert WordArt
24		Insert Tab- insert date and time
25		Home Tab- click on slide 5 and add a section, choose a new template

If you don’t want to change your design at slide 5, add a “the end” slide and add a section there

Today's Work
Step 9- Practice & REVIEW MOST COMMON MISTAKES

21	Insert hyperlink so when you click on clipart it goes to link
31	Review Tab- spell check
32	Review Tab- create a comment on the slide you are most proud of creating

Review Pink Skills SheetReview your notes panes to make sure you have all numbers listed
Go to each slide and look in the notes section. Circle the numbers you see on your pink sheet.
If you left out a number go back and add it to the CORRECT notes section

Review Green Design and Content sheet
·         Check spelling

·         Check grammar (Sentences begin with Capital letter and end with periods.)

·         Your content makes sense.

·         Your content is yours.

·         For your 2 quotes, you have the proper citations.

Thurs, Feb 14- Grading Rubrics

Bell Ringer:

1. Open up your Typing Word document
2. On page 32 type lines lines 9 and 10

What are we learning today?
10 Step Procedure for developing a PowerPoint presentation
3.1 Know the Design Principles
3.2 Know your Target Audience

Guided Practice:
@ Miss W will model the 10 steps to use to develop a PowerPoint presentation.
@Students will help each other during the project.

For students working on the Health project:
How to say "No" to Drugs http://lbhughes.schoolloop.com/RRW

Yesterday’s work
Step 6 Enter content
· Make sure you have at least 9 slides
· Font should be no smaller than size 24
· Font may need to be bigger than 24 depending on the font you use
· Research your content (IN YOUR OWN WORDS for 6 slides)
· You are allowed 2 quotes with proper citations
· Type your content and research your topic

Step 7 Add and format graphics (pictures), audio and video
· Each page needs at least one clip art or image.
· If you get the image from Google you will need to put a citation under it
· Don’t forget google.com is NOT a citation.
· Click on “see full size image” to get citation information
· Pink skills sheet items (PUT NUMBER IN NOTES PANE)
o 16- have a picture border
o 17- use a picture artistic effect
o 18- change picture color or use an artistic effect or remove background

Step 8 Add animations and transitions
· You need an animation or a transition for each slide
· Pink skills sheet items (PUT NUMBER IN NOTES PANE only ONCE)

o 27- make one transition have a longer or shorter duration

o 28- you may skip

o 29- Go back to your title slide and animate your name

o 30 Change the effect on any of your animations

Today's Work:

Understand the Skills Rubric (pink grading sheet)
and the Design and Content Rubric (green grading sheet)

You are creating one PowerPoint but will receive 2 grades.
One grade will be for the technical skills you have learned.
One grade will be for the design skills you learned and the accuracy of your content.

Pink skills sheet items (PUT NUMBER IN NOTES PANE only ONCE)

Step 9- Practice

9	Home Tab- change font color
10	Home Tab- center text
11	Home Tab-  use text direction
12	Home Tab- shape fill
13	Home Tab- shape outline and shape weight
14	Home Tab- shape effects
20		Insert Tab- insert shape
21		Insert Tab- insert hyperlink
22		Insert Tab- insert text box (will let you position pictures on slide)
23		Insert Tab- insert WordArt
24		Insert Tab- insert date and time
25		Home Tab- click on slide 5 and add a section, choose a new template

If you don’t want to change your design at slide 5, add a “the end” slide and add a section there