|
Week 1
Unit 6
Spreadsheets
(Overview of Unit)
Lesson 1 (Word)(PDF)
(Lesson
Resources)
· Determine rows and columns
· Save
· Terms: spreadsheet, rows,
columns, cells, cell address i.e. “A3”
Lesson 2 (Word)(PDF)
(Lesson
Resources)
· Enter and edit data
· Terms: worksheets, data,
label, active cell |
Week 2
Spreadsheets
Lesson 3 (Word)(PDF)
(Lesson
Resources)
· Adjust row height by
dragging
· Adjust row height by
menu system
· Adjust row height by
AutoFit cell size
Lesson 4 (Word)(PDF)
(Lesson
Resources)
· Insert/delete row
|
Week 3
Spreadsheets
Lesson 5 (Word)(PDF)
(Lesson
Resources)
· Insert
column
· Delete
column
Lesson 6 (Word)(PDF)
(Lesson
Resources)
·
Format cells - font tab
· Format cells -
alignment tab
|
| Week 4
Spreadsheets
Lesson
7 (Word)(PDF)
(Lesson
Resources)
· Format cells - number
tab
Lesson
8 (Word)(PDF)
(Lesson
Resources)
· Format cells - border
tab
· Format cells - pattern
tab
|
Week 5
Spreadsheets
Lesson 9 (Word)(PDF)
(Lesson
Resources)
· Enter data for new spreadsheet
Lesson
10
(Word)(PDF)
(Lesson
Resources)
· Review
|
Week 6
Spreadsheets
Lesson 11
(Word)(PDF)
(Lesson
Resources)
· Review
Spreadsheet Benchmark
|