; Excel
Documents
User Generated
Resources
Learning Center
Your Federal Quarterly Tax Payments are due April 15th

# Excel

VIEWS: 0 PAGES: 12

• pg 1
```									                                                                     SAM Projects

Succeeding in Business with Microsoft Office Excel 2007 (978-1-4239-0605-6)
SAM Projects Mapping Grid

Illustrated Excel Unit     Step            Covered Skills             Textbook Page
A: Independent                                                         Remediation
Challenge 1 Project:
"Real Estate Listing"
Illustrated Excel Unit      1     Save a workbook with a new
A: Independent                    name in a different location
Challenge 1 (Scenario
2) Project: "Hampton
Neighborhood
Association"
2     Switch to new worksheet
Edit text in cells
Edit numbers in cells
3     Edit text in cells
Edit numbers in cells
4     Edit text in cells
Edit numbers in cells
5     Edit text in cells
Edit numbers in cells
7     Enter formula arguments by
clicking

New Perspectives Excel     Step            Covered Skills             Textbook Page
Tutorial 1: Case                                                       Remediation
Problem 1 Project:
"Altac Bicycles"
New Perspectives Excel      1     Save a workbook with a new
Tutorial 1: Case                  name in a different location
Problem 1 (Scenario 2)
Eyewear"
2     Switch to new worksheet
3     Edit text in cells
4     Edit numbers in cells
5     Edit numbers in cells
6     Edit numbers in cells
7     Enter formula arguments by
clicking
SAM Projects

8     Create formulas using the SUM             EX 55
function
9     Enter formula arguments by
clicking
10    Enter formula arguments by
clicking
11    Enter formula arguments by
clicking
12    Enter formula arguments by
clicking
13    Check spelling in a worksheet              EX 7
14    Edit text in cells
15    Modify column width                       EX 38
Modify row height
16    Insert columns and rows                   EX 43
17    Modify worksheet names                     EX 6
Reposition worksheets in a
workbook
Delete a worksheet from a
workbook

Shelly Cashman Excel    Step            Covered Skills             Textbook Page
Chapter 1: Lab 1                                                    Remediation
Project: "Kona's
Expresso Coffee -
Annual Cost of Goods"
Shelly Cashman Excel     1     Save a workbook with a new
Chapter 1: Lab 1               name in a different location
(Scenario 2) Project:
"Maui Sun Spex -
Annual Cost of Goods"
2     Switch to new worksheet
Edit text in cells
3     Edit text in cells
4     Edit numbers in cells                     EX 55
Edit text in cells
Create formulas using the SUM
function
SAM Projects

5     Apply styles                          EX 40 - EX 41
Merge cells and center their
content
6     Change font face                       EX 7; EX41
Change font size
Apply bold and italics
Change the font color
Merge cells and center their
content
7     Apply styles                              EX 40
8     Apply accounting and percent          EX 39 - EX 40
number formats
Apply date and comma number
formats
9     Modify column width                       EX 38
10    Create charts using column                EX 15
chart types
Apply a Quick Style to a chart
Resize a chart
Position a chart
11    Edit text in cells

Illustrated Excel Unit B:   Step            Covered Skills             Textbook Page
Independent Challenge                                                   Remediation
1 Project: "Estimated
Dinner Expenses"

Illustrated Excel Unit B:    1     Save a workbook with a new
Independent Challenge              name in a different location
1 (Scenario 2) Project:
"The Graphics Studio"

2     Edit text in cells
Edit numbers in cells
3     Enter formula arguments by
clicking
4     Fill adjacent cells with formulas         EX 69
5     Move cell contents
6     Create formulas using the SUM             EX 55
function
7     Create a formula using the                EX 56
Insert Function button
SAM Projects

8     Create a formula using the             EX 56; EX 69
Insert Function button
9     Copy cell contents                         EX 7
10    Edit text in cells
Edit numbers in cells
11    Create a formula using the             EX 56; EX 70
Insert Function button
Use absolute references
12    Create a formula using the             EX 56; EX 69
Insert Function button
13    Create formulas using the SUM             EX 55
function
14    Edit numbers in cells                     EX 56
Create a formula using the
Insert Function button

New Perspectives Excel   Step           Covered Skills               Textbook Page
Tutorial 2: Case                                                      Remediation
Problem 1 Project:
"FrostiWear"
New Perspectives Excel    1     Save a workbook with a new
Tutorial 2: Case                name in a different location
Problem 1 (Scenario 2)
Project: "Richmond
Office Furniture"
2     Set cell color                            EX 41
3     Apply styles                           EX 40; EX 7
Change font size
Change the font color
Apply bold and italics
4     Merge cells and center their          EX 40 - EX 41
content
Apply styles
Change font size
5     Merge cells and center their        EX 40 - EX 42; EX 7
content
Right align cells
Rotate text
Apply styles
Change font size
Apply bold and italics
Use Format Painter
SAM Projects

6     Right align cells                     EX 40; EX 42
Apply data and comma number
formats
Use Format Painter
7     Apply a Quick Style to an
existing table
8     Set cell color
9     Apply a Quick Style to an
existing table
Set cell color
10    Modify column width                       EX 38
11    Format cells with data bars              EX 232
12    Modify worksheet orientation               EX 7
Control page breaks
Modify print settings to repeat
the first two rows of the
worksheet on every printed
page
Shelly Cashman Excel      Step            Covered Skills             Textbook Page
Chapter 2: Lab 1                                                      Remediation
Importers - Sales
Analysis Worksheet"
Shelly Cashman Excel       1     Save a workbook with a new
Chapter 2: Lab 1                 name in a different location
(Scenario 2) Project:
"Café Cabinetry - Sales
Analysis Worksheet"

2     Apply a theme to a worksheet
3     Modify column width                       EX 38
4     Edit text in cells
5     Edit numbers in cells
6     Enter formula arguments by                EX 69
clicking
7     Create a formula using the            EX 56; EX 69
Insert Function button
SAM Projects

8     Create formulas using the SUM       EX 55; EX 58; EX 69
function
Create formulas using the
AVERAGE function
Create formulas using the MAX
function
Create formulas using the MIN
function
9     Enter formula arguments by
clicking
10    Center cell content                 EX 40 - EX 41; EX 7
Merge cells and center their
content
Set cell color
Apply styles
Change the font color
Change font size
11    Center cell content                    EX 40 ; EX 7
Apply styles
Apply bold and italics
12    Apply styles                        EX 40 - EX 41; EX 7
Set cell color
Change the font color
13    Modify row height                         EX 38
14    Apply accounting and percent              EX 39
number formats
15    Format cells before entering
data
16    Apply date and comma number               EX 40
formats
17    Modify worksheet names                     EX 6
Illustrated Excel Unit C:   Step           Covered Skills               Textbook Page
Independent Challenge                                                    Remediation
1 Project: "Lovely
Locks Inventory"

Illustrated Excel Unit C:    1     Save a workbook with a new
Independent Challenge              name in a different location
1 (Scenario 2) Project:
"Shaw TV & Appliance"
SAM Projects

2     Create a formula using the          EX 56; EX 40; EX 69
Insert Function button
Apply date and comma number
formats
3     Use absolute references             EX 70; EX 56; EX 69
Create a formula using the
Insert Function button
4     Apply bold and italics                     EX 7
5     Modify column width                       EX 38
6     Apply accounting and percent              EX 39
number formats
7     Apply date and comma number               EX 40
formats
8     Insert columns and rows                EX 43; EX 56
Edit text in cells
Edit numbers in cells
Create a formula using the
Insert Function button
9     Check spelling in a worksheet              EX 7
10    Apply conditional formatting              EX 231
11    Format cells with an icon set             EX 232
13    Delete rows and columns                    EX 7

New Perspectives Excel   Step           Covered Skills               Textbook Page
Tutorial 3: Case                                                      Remediation
Problem 1 Project:
"Chemistry 303"
New Perspectives Excel    1     Save a workbook with a new
Tutorial 3: Case                name in a different location
Problem 1 (Scenario 2)
Project: "French 212"

2     Create a formula using the          EX 56; EX 58; EX 70
Insert Function button
Create formulas using the
AVERAGE function
Use absolute references
3     Fill adjacent cells with formulas         EX 69
4     Use the COUNT function
SAM Projects

5     Use the MEDIAN function
6     Create formulas using the MAX            EX 58
function
7     Create formulas using the MIN            EX 58
function
8     Enter formula arguments by               EX 58
clicking
Use the MEDIAN function
Create formulas using the MAX
function
Create formulas using the MIN
function
Enter formula arguments by
clicking
10    Apply conditional formatting            EX 231
11    Control page breaks                       EX 7
Modify print settings to repeat
the first two rows of the
worksheet on every printed
page
Modify worksheet orientation

Shelly Cashman Excel     Step           Covered Skills             Textbook Page
Chapter 3: Lab 1                                                    Remediation
Project: "Salioto Auto
Parts - Eight Year
Financial Projection"
Shelly Cashman Excel      1     Save a workbook with a new
Chapter 3: Lab 1                name in a different location
(Scenario 2) Project:
"Motorino Scooters -
Eight Year Financial
Projection"
2     Apply a theme to a worksheet              EX 7
Select and format all cells in a
worksheet
Apply bold and italics
3     Edit text in cells                    EX 7; EX 40
Change font face
Change font size
Create formulas using the NOW
function
Apply date and comma number
formats
SAM Projects

4    Modify column width                         EX 38
Modify row height
5    Fill a range of cells with a series          EX 7
Change font size
Apply bold and italics
Center cell content
Rotate text
Use Format Painter
6    Edit text in cells                       EX 7; EX 41
Change font face
Change font size
7    Edit text in cells                           EX 7
Edit numbers in cells
Enter numbers with format
symbols
Change font face
Change font size
Apply underline
8    Apply date and comma number                 EX 40
formats
9    Enter formula arguments by
clicking
10   Enter formula arguments by                  EX 69
clicking
11   Enter formula arguments by                  EX 69
clicking
12   Enter formula arguments by                  EX 69
clicking
13   Enter formula arguments by                  EX 69
clicking
14   Edit numbers in cells
15   Edit numbers in cells
16   Enter formula arguments by                  EX 69
clicking
17   Enter formula arguments by                  EX 69
clicking
SAM Projects

18    Enter formula arguments by                EX 69
clicking
19    Create formulas using the SUM             EX 69
function
20    Enter formula arguments by                EX 69
clicking
21    Create formulas using the IF          EX 244; EX 69
function
22    Enter formula arguments by                EX 69
clicking
23    Set cell color
24    Select non-adjacent cells                 EX 15
Create charts using column
chart types
Move chart to a new worksheet
25    Edit a chart
26    Format charts
27    Modify worksheet names                    EX 55
Reposition worksheets in a
workbook
Format worksheet tabs
28    Use Goal Seek                            EX 139

Illustrated Excel Unit   Step           Covered Skills              Textbook Page
D: Independent                                                       Remediation
Challenge 1 Project:
"Springfield Theater
Group"
Illustrated Excel Unit    1     Save a workbook with a new
D: Independent                  name in a different location
Challenge 1 (Scenario
2) Project: "Mason
Auto Body"
2     Create charts using column                EX 15
chart types
Position a chart
Apply a Quick Style to a chart
4     Edit a chart
SAM Projects

5     Create charts using area chart
types
Move chart to a new worksheet
6     Create charts using line chart
types
Move chart to a new worksheet

New Perspectives Excel   Step           Covered Skills            Textbook Page
Tutorial 4: Case                                                   Remediation
Problem 1 Project:
"Kenai Fjords National
Park"
New Perspectives Excel    1     Save a workbook with a new
Tutorial 4: Case                name in a different location
Problem 1 (Scenario 2)
Project: "Serenity
Fitness Center"
2     Create charts using column              EX 15
chart types
3     Move chart to a new worksheet            EX 6
Modify worksheet names
4     Apply a Quick Style to a chart
5     Edit a chart
Change font size
6     Edit a chart
Rotate text
Change font size
7     Rotate and tilt a 3-D Pie chart
8     Create a data table
9     Customize a data series
10    Select non-adjacent cells            EX 15; EX 6
Create charts using the pie
chart types
Move chart to a new worksheet
Modify worksheet names
Reposition worksheets in a
workbook
11    Edit a chart
12    Change font size
13    Customize a data series
14    Format chart data labels               EX 175
SAM Projects

Illustrated/New       see all of the above
Perspectives/Shelly
Cashman Excel
Capstone Project:
"Small World
Microloans"
Illustrated/New       see all of the above
Perspectives/Shelly
Cashman Excel
Capstone Project
(Scenario 2):
"BizMarket"

```
To top