Thursday, March 20, 2014

Friday, March 21st- 7th Grade- Spreadsheets- formatting a table

Bellringer:
1.
 Open your Typing file and on page 46 type lines 4, 5 and 6.            
    Use your right INDEX finger  for the Y  key 

2. If you do not have the Career worksheet or PowerPoint finished
Click on http://www.careeroutlook.us/table.php?state=NC&cluster=sci&interest=all
3. Students will go to http://www.carmax.com 
to finish their worksheet and spreadsheet.    

What are we learning?
4.1 Know the components of Spreadsheets
Bring back signed Interim Reports today for 85. No Reward time until returned.


Guided Lesson- : 

@ Open up the Spreadsheet Vocabulary PowerPoint file.
     Slides 21-23 (Range, Cell Reference, Sorting)


@ Ascending and Descending Sorting Activity
 
@ Cell Reference and Range Activity
 Follow instructions to make a picture.

Make cell C5 to C8 yellow


Make D5 to D8 yellow

 Make cell F5 to F8 yellow

 Make cell G5 to G8 yellow

 Now click on C6 make it black

 Then F6 and make it black

 Cell E11 green

 Cell B12 B13 red

 Cell I11 I12 red

 Cell C14 red

 Cell D15 red

 Cell E16 red

 Cell F15 red

 Cell G14 red

 Cell H13 red
 
SS Flash cards file
Open 7 Format Table    (format as table button)
 
SS Flash cards file  (conditional formatting button)
Open 13 Data Bars
 


SS Flash cards file   (border button and percent button)
Open 31 Formatting Cells


@ Open up the Spreadsheet Vocabulary PowerPoint file.
     Slides 24-25 (identifying parts of spreadsheet formula)


Slides 26 (order of operations in a spreadsheet formula)

@ Students will recreate the formula.
http://edu.glogster.com/ 
Do NOT create a new id if you can not log in! We have a list with ids on it.  
Independent Activity:
1. Complete unfinished work.
2. Complete Exit activity.  
Exit Activity:
Exit Activity:http://www.quia.com/rr/363962.html
We have not covered one question yet.
Built in calculations are called functions.
Horizontal is like laying down flat on the ground.
Vertical is up and down
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars.

 

No comments:

Post a Comment