Monday, October 21, 2013

Tuesday, Oct 22- 7th Grade- Default Alignment, AutoSum and AutoFill

Bellringer:
1. Open your typing book to page 365    
    and type the two SENTENCES
    in the 
paragraph with the title
    "Edit and Format Data"

2. Make up any number pad exercises 1-8 you are missing  
http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html


What are we learning?
4.0 Spreadsheet Basics and Formulas
4.1 Know the components of Spreadsheets
4.2 Creation and Formatting of Spreadsheets
4.3 Know spreadsheet operations


Guided Lesson: 

Excel 2010 Autosum  http://www.youtube.com/watch?v=1wnP9CVCEDk
Spreadsheet flashcard 32 calculates averages

Spreadsheet flashcard 6 alignment of data
Notice that the words(labels) are aligned to the left
and the numbers (values) are aligned to the right.
Default alignment is how the items will be if you do not format them
.


Excel 2010 Autofill http://www.youtube.com/watch?v=l24ZjX1m3Y8

Independent Activity:
Students will work individually to complete the Spreadsheet Ribbon worksheet

Exit Activity:
Work in groups of 2 or 3
http://www.quia.com/hm/174125.html
there are a few words we have not covered yet

No comments:

Post a Comment