Thursday, March 14- Creating a chart

Bellringer
We are learning the number keypad. Click on http://www.typeonline.co.uk/number_pad_lesson1.html
Choose exercise 3 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 on a piece of paper.

What are we learning today? 4.2 Creation and formatting of Spreadsheets

Guided Practice: Learn the following flashcard skills:

20 Icon sets- Home tab, Conditional Formatting button, then Icon sets

22 Pie chart- Insert tab, Pie chart, 3D, Chart layout number 2

09 Chart types and styles-
Select chart, On Design tab click Change Chart Type, Select column chart.

Open the Car lot exercise  for absent students file
and save to your lunch number ADD your name to the file name.

Follow the Practice for Spreadsheet Project Chart worksheet with your teacher.

Independent Activity:
1. Open your hurricane file.
2.  Column B should be hidden!  Highlight Columns A and C.
3.  Click on the insert tab and click on the Column chart button, choose a 3D Column design.
4. The Design tab lets you change the color of the bars.
5. Click on the LAYOUT tab.
6. Click on the chart.

7. Make sure you are on the Layout tab.
    Add the title "Hurricanes and Millibars"

8. Choose Axis Titles.
9. Choose the 2^nd choice “Primary Vertical Axis Title”
10. Choose the 2^nd choice “Rotated title”
11. Spelling Counts! Type “Millibars” (millibars are a measure of atmospheric pressure)

12. Choose Data Labels and then click on Show.

 13. Click on Chart Wall. Click on More Wall Options. Click on Solid Fill. Choose any color.

We will edit the legend together.

Wednesday, March 13- PowerPoint Skills

Bellringer
We are learning the number keypad. Click on 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 on a piece of paper.

What are we learning today? 4.2 Creation and formatting of Spreadsheets

Guided Practice: Learn the following flashcard skills:
 
02 Color Scales- Home tab,  click Conditional Formatting, click color scales

04 Sparklines-
Insert tab, click Column Sparklines, highlight where you want sparklines, click Marker color, Negative points red

Insert tab, click Line Sparklines, highlight where you want sparklines, click Show Marker

06 Alignment of data - Home tab- top of the alignment group

14 Merge Cells- Home tab, Merge and center button

16 Hide and Show Rows- right click on row 12 and choose hide, highlight column labels E and G and right click and choose unhide.

19 Hide worksheet- right click on tab and choose hide

Independent Exercise:

Open your Hurricanes file:

1. Finish finding the sum, max, min and averages of columns D, E and F.

2. Use any color scale on column E.

3. Merge cells H4 and I4.

4. Hide column B.

5. Insert column sparklines at the bottom of Column D in cell D14.

6. Align the hurricane names in Column A counter clockwise.

Tuesday, March 11- Functions are Formula Shortcuts

Bellringer
We are learning the number keypad. Click on 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 on a piece of paper.

What are we learning today?
How to use functions 4.3 Know Spreadsheet operations

EQ: How are functions different than formulas?
Functions are shortcuts for typing formulas.
You do not need to type as many items in functions compared to formulas.
For example:  =F2+F3+F4+F5  is the same as =Sum(F2:F5)

Guided Exercises:

Open Flashcard 19- hide worksheet

Open Flashcard 32 calculates average.

Open a new Excel spreadsheet

Open the Understanding Functions Word document

It is important to understand the parts of a function (equals sign, function name, parentheses, beginning of the range, colon, ending of the range and parenthese).

We will type out a formula =F2+F3+F4+F5 and then we type out function to see how functions are shortcuts. =Sum(F2:F5) 

Open up the "Functions goes with youtube" file.
http://www.youtube.com/watch?v=b3q1ch-Cgto

Open up the Hurricane file.
Class practice of Hurricane sheet using  functions

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

Independent Activity:
Open up your car lot file. Insert the functions sum, max, min and average.

Monday, March 11- Formatting Spreadsheet Data

Bellringer
1. Typing Contest

http://www.typingweb.com/tutor/lesson/index/id/31/  

2. Open “Practice Formatting” file.

What Are We Learning Today? There is a Spreadsheet project coming up.
You will be practicing the skills
you need two to three times before the project.
Some of the skills are the flashcard skills and some of the skills are
understanding formulas and functions, which we will be starting this week.  
You will be receiving a classwork grade on your car lot file.

Winners of the PowerPoint Project Vote will be announced!

Guided Lesson: Review flashcards with “practice formatting” file.

New Skills:
Skill 1: Sort ascending
            (Home tab- sort and filter button)
Skill 08- removes duplicates
           (Data tab click on remove duplicates and then sort),  

Previous Skills:
Skill 7- format table any color, (Home tab- format as table arrow)

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.
Skill 13- data bars on price column any color,    
        (Home tab- Conditional Formatting button)
Skill 23- change color of tabs,
        (Right click on tab, click on change color, choose color)
Skill 31 formatting cells- change price column to currency            
        (highlight prices, then click on number format arrow)

Independent Activity:

Open car lot file and add the following items to your file.
Make sure you save. Look above for directions.
Skill 7- format table any color,
Skill 13- data bars on price column any color,
Skill 23- change color of tabs,
Skill 31 formatting cells- change price column to currency

Exit activity:Complete any missing work.

Friday, March 8- Catch Up Day!

Bellringer:
Pull out your green sheet question ANSWERS from your folder. 
1. On page 53 type pages 14, 15 and 16
2. Complete green sheet questions 1 to 10
look at the article "Importance of PowerPoint Skills" (click on link)
3. Complete any missing work- see white sheet

What are we learning today?
We are going to catch up on any late assignments.
With the new English Common Core standards,
students are required to read non-fiction documents
in ALL of their classes and understand them.
We are going to discuss some steps
on how to make a non-fiction document easier to understand.

1. Always "preview" a document by looking at the Titles and pictures.
Let's look at the article "Importance of PowerPoint Skills" (click on link)
What is the main title?
What are the 3 subtitles?
What do you think the article is going to be about?
Ask yourself what do you ready know about the topic, PowerPoint?
Name 5 things you know about PowerPoint.

2. You need to get use to reading a non-fiction text at least 2 times!
The first time is a quick read to get a "big" picture about what the article is about.
The second time is a slower read to understand what the article is about.

Get into groups of 2 or 3 students.
Each group will be assigned a paragraph to read to get the "big" picture.
As close as possible to 10 words explain what your paragraph is about on the yellow sheet of paper on the walls. Do NOT copy from your paragraph.
It needs to be in your own words.

3. Look up any words you do not know. When you go to http://www.google.com type the word
DEFINITION and the word you want to look up.

For example question number one says to look at
the word “synonymous” on Google and write the definition.
You would type “definition synonymous”.

Do NOTuse the word synonymous in your definition.

Some words have more than one definition
so you need to check that it makes sense in the article’s sentence.

4. On a new piece of paper answer the 21 questions on the Green sheet.
Notice that the questions give you the paragraph, where you can find the answers.

Exit Activities:
1. If you were absent on Tuesday, 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!

2. Many of you did not get finished watching and voting on the PowerPoint Projects, that you liked, or completing your review worksheet.

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?

Thursday, Mar 7- Non-fiction reading assignment- Before you read...

Bellringer:
On page 53 type pages 11, 12 and 13

What are we learning today?
With the new English Common Core standards,
students are required to read non-fiction documents
in ALL of their classes and understand them.
We are going to discuss some steps
on how to make a non-fiction document easier to understand.

1. Always "preview" a document by looking at the Titles and pictures.
Let's look at the article "Importance of PowerPoint Skills" (click on link)
What is the main title?
What are the 3 subtitles?
What do you think the article is going to be about?
Ask yourself what do you ready know about the topic, PowerPoint?
Name 5 things you know about PowerPoint.

2. You need to get use to reading a non-fiction text at least 2 times!
The first time is a quick read to get a "big" picture about what the article is about.
The second time is a slower read to understand what the article is about.

Get into groups of 2 or 3 students.
Each group will be assigned a paragraph to read to get the "big" picture.
As close as possible to 10 words explain what your paragraph is about on the yellow sheet of paper on the walls. Do NOT copy from your paragraph.
It needs to be in your own words.

http://linoit.com/users/guest/canvases/cf42fb5ee7045fde206b9ffb94546924?dispLang=en_US

3. Look up any words you do not know. When you go to http://www.google.com type the word
DEFINITION and the word you want to look up.

For example question number one says to look at
the word “synonymous” on Google and write the definition.
You would type “definition synonymous”.

Do NOT use the word synonymous in your definition.  

Some words have more than one definition
so you need to check that it makes sense in the article’s sentence.

4. On a new piece of paper answer the 21 questions on the Green sheet.
Notice that the questions give you the paragraph, where you can find the answers.

Exit Activities:
1. If you were absent on Tuesday, 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!

2. Many of you did not get finished watching and voting on the PowerPoint Projects, that you liked, or completing your review worksheet.

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?

Wed, March 6- Importance of PowerPoint Skills

Bellringer:
1. On page 53 type pages 8, 9, and 10
Miss W. will also be checking yesterday's typing
on page 52, you should have typed lines 5, 6, and 7
2. Pull up Edmodo

What are we learning today?
With the new English Common Core standards,
students are required to read non-fiction documents
in ALL of their classes and understand them.
We are going to discuss some steps
on how to make a non-fiction document easier to understand.

1. Always "preview" a document by looking at the Titles and pictures.
Let's look at the article "Importance of PowerPoint Skills" (click on link)
What is the main title?

What are the 3 subtitles?

 


What do you think the article is going to be about?

Ask yourself what do you ready know about the topic, PowerPoint?Sign in to Edmodo and respond to "Name 5 things you know about PowerPoint."

2. You need to get use to reading a non-fiction text at least 2 times!
The first time is a quick read to get a "big" picture about what the article is about.
The second time is a slower read to understand what the article is about.

Get into groups of 2 or 3 students.
Each group will be assigned a paragraph to read to get the "big" picture.
As close as possible to 10 words explain what your paragraph is about on the link below.
Do NOT copy from your paragraph. It needs to be in your own words.

http://linoit.com/users/guest/canvases/cf42fb5ee7045fde206b9ffb94546924?dispLang=en_US

Exit Activities:
1. If you were absent on Tuesday, 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!

2. Many of you did not get finished watching and voting on the PowerPoint Projects, that you liked, or completing your review worksheet.

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?