Excel by lonyoo

VIEWS: 1,633 PAGES: 13

									SAM Projects Succeeding in Business with Microsoft Office Excel 2007 (978-1-4239-0605-6) SAM Projects Mapping Grid
Illustrated Excel Unit A: Independent Challenge 1 Project: "Real Estate Listing" Illustrated Excel Unit A: Independent Challenge 1 (Scenario 2) Project: "Hampton Neighborhood Association" Step Covered Skills Textbook Page Remediation

1

Save a workbook with a new name in a different location

2

3 4 5 6 7

Switch to new worksheet Edit text in cells Edit numbers in cells Edit text in cells Edit numbers in cells Edit text in cells Edit numbers in cells Edit text in cells Edit numbers in cells Add headers to worksheets Enter formula arguments by clicking

EX 13

New Perspectives Excel Tutorial 1: Case Problem 1 Project: "Altac Bicycles" New Perspectives Excel Tutorial 1: Case Problem 1 (Scenario 2) Project: "Estrada Eyewear"

Step

Covered Skills

Textbook Page Remediation

1

Save a workbook with a new name in a different location

2 3 4 5 6 7 8

Switch to new worksheet Edit text in cells Edit numbers in cells Edit numbers in cells Edit numbers in cells Enter formula arguments by clicking Create formulas using the SUM function EX 55

SAM Projects
9 Enter formula arguments by clicking Fill adjacent cells with formulas Enter formula arguments by clicking Fill adjacent cells with formulas Enter formula arguments by clicking Fill adjacent cells with formulas Enter formula arguments by clicking Fill adjacent cells with formulas Check spelling in a worksheet Edit text in cells Modify column width Modify row height Insert columns and rows Modify worksheet names Reposition worksheets in a workbook Delete a worksheet from a workbook EX 38 EX 43 EX 6 EX 7

10

11

12

13 14 15 16 17

Shelly Cashman Excel Chapter 1: Lab 1 Project: "Kona's Expresso Coffee Annual Cost of Goods" Shelly Cashman Excel Chapter 1: Lab 1 (Scenario 2) Project: "Maui Sun Spex - Annual Cost of Goods"

Step

Covered Skills

Textbook Page Remediation

1

Save a workbook with a new name in a different location

2 3 4

Switch to new worksheet Edit text in cells Edit text in cells Edit numbers in cells Edit text in cells Create formulas using the SUM function Apply styles Merge cells and center their content EX 55

5

EX 40 - EX 41

SAM Projects
6 Change font face Change font size Apply bold and italics Change the font color Merge cells and center their content Apply styles Apply accounting and percent number formats Apply date and comma number formats Modify column width Create charts using column chart types Apply a Quick Style to a chart Resize a chart Position a chart Edit text in cells Covered Skills EX 7; EX41

7 8

EX 40 EX 39 - EX 40

9 10

EX 38 EX 15

11 Illustrated Excel Unit B: Independent Challenge 1 Project: "Estimated Dinner Expenses" Illustrated Excel Unit B: Independent Challenge 1 (Scenario 2) Project: "The Graphics Studio" Step

Textbook Page Remediation

1

Save a workbook with a new name in a different location

2 3 4 5 6 7 8

Edit text in cells Edit numbers in cells Enter formula arguments by clicking Fill adjacent cells with formulas Move cell contents Create formulas using the SUM function Create a formula using the Insert Function button Create a formula using the Insert Function button Fill adjacent cells with formulas Copy cell contents EX 55 EX 56 EX 56; EX 69 EX 69

9

EX 7

SAM Projects
10 11 Edit text in cells Edit numbers in cells Create a formula using the Insert Function button Use absolute references Create a formula using the Insert Function button Fill adjacent cells with formulas Create formulas using the SUM function Edit numbers in cells Create a formula using the Insert Function button Covered Skills

EX 56; EX 70

12

EX 56; EX 69

13 14

EX 55 EX 56

New Perspectives Excel Tutorial 2: Case Problem 1 Project: "FrostiWear" New Perspectives Excel Tutorial 2: Case Problem 1 (Scenario 2) Project: "Richmond Office Furniture"

Step

Textbook Page Remediation

1

Save a workbook with a new name in a different location

2 3

4

Set cell color Add borders Apply styles Change font size Change the font color Apply bold and italics Merge cells and center their content Apply styles Change font size Merge cells and center their content Right align cells Rotate text Apply styles Change font size Apply bold and italics Use Format Painter Right align cells Apply data and comma number formats Use Format Painter

EX 41 EX 40; EX 7

EX 40 - EX 41

5

EX 40 - EX 42; EX 7

6

EX 40; EX 42

SAM Projects
7 Apply a Quick Style to an existing table Adjust table style options Set cell color Apply a Quick Style to an existing table Adjust table style options Set cell color Modify column width Format cells with data bars Modify worksheet orientation Control page breaks Modify print settings to repeat the first two rows of the worksheet on every printed page Add headers to worksheets Covered Skills EX 38 EX 232 EX 7

8 9

10 11 12

13 Shelly Cashman Excel Chapter 2: Lab 1 Project: "Façade Importers - Sales Analysis Worksheet" Shelly Cashman Excel Chapter 2: Lab 1 (Scenario 2) Project: "Café Cabinetry - Sales Analysis Worksheet" Step

EX 13 Textbook Page Remediation

1

Save a workbook with a new name in a different location

2 3 4 5 6

Apply a theme to a worksheet Modify column width Edit text in cells Edit numbers in cells Enter formula arguments by clicking Fill adjacent cells with formulas Create a formula using the Insert Function button Fill adjacent cells with formulas EX 69 EX 38

7

EX 56; EX 69

SAM Projects
8 Create formulas using the SUM function Create formulas using the AVERAGE function Create formulas using the MAX function Create formulas using the MIN function Fill adjacent cells with formulas Enter formula arguments by clicking Center cell content Merge cells and center their content Set cell color Apply styles Change the font color Change font size Add borders Center cell content Apply styles Apply bold and italics Apply styles Add borders Set cell color Change the font color Modify row height Apply accounting and percent number formats Format cells before entering data Apply date and comma number formats Modify worksheet names Covered Skills EX 55; EX 58; EX 69

9 10

EX 40 - EX 41; EX 7

11

EX 40 ; EX 7

12

EX 40 - EX 41; EX 7

13 14 15 16 17 Illustrated Excel Unit C: Independent Challenge 1 Project: "Lovely Locks Inventory" Illustrated Excel Unit C: Independent Challenge 1 (Scenario 2) Project: "Shaw TV & Appliance" Step

EX 38 EX 39

EX 40 EX 6 Textbook Page Remediation

1

Save a workbook with a new name in a different location

SAM Projects
2 Create a formula using the Insert Function button Apply date and comma number formats Fill adjacent cells with formulas Use absolute references Create a formula using the Insert Function button Fill adjacent cells with formulas Apply bold and italics Modify column width Apply accounting and percent number formats Apply date and comma number formats Insert columns and rows Edit text in cells Edit numbers in cells Create a formula using the Insert Function button Check spelling in a worksheet Apply conditional formatting Format cells with an icon set Add borders Delete rows and columns Covered Skills EX 56; EX 40; EX 69

3

EX 70; EX 56; EX 69

4 5 6 7 8

EX 7 EX 38 EX 39 EX 40 EX 43; EX 56

9 10 11 12 13 New Perspectives Excel Tutorial 3: Case Problem 1 Project: "Chemistry 303" New Perspectives Excel Tutorial 3: Case Problem 1 (Scenario 2) Project: "French 212" Step

EX 7 EX 231 EX 232 EX 41 EX 7 Textbook Page Remediation

1

Save a workbook with a new name in a different location

2

3 4 5

Create a formula using the Insert Function button Create formulas using the AVERAGE function Use absolute references Fill adjacent cells with formulas Use the COUNT function Use the MEDIAN function

EX 56; EX 58; EX 70

EX 69

SAM Projects
6 7 8 Create formulas using the MAX function Create formulas using the MIN function Enter formula arguments by clicking Use the MEDIAN function Create formulas using the MAX function Create formulas using the MIN function Enter formula arguments by clicking EX 58 EX 58 EX 58

10 11

Apply conditional formatting Control page breaks Modify print settings to repeat the first two rows of the worksheet on every printed page Modify worksheet orientation

EX 231 EX 7

Shelly Cashman Excel Chapter 3: Lab 1 Project: "Salioto Auto Parts - Eight Year Financial Projection" Shelly Cashman Excel Chapter 3: Lab 1 (Scenario 2) Project: "Motorino Scooters - Eight Year Financial Projection"

Step

Covered Skills

Textbook Page Remediation

1

Save a workbook with a new name in a different location

2

3

4

Apply a theme to a worksheet Select and format all cells in a worksheet Apply bold and italics Edit text in cells Change font face Change font size Create formulas using the NOW function Apply date and comma number formats Modify column width Modify row height

EX 7

EX 7; EX 40

EX 38

SAM Projects
5 Fill a range of cells with a series Change font size Apply bold and italics Center cell content Rotate text Use Format Painter Edit text in cells Change font face Change font size Add borders Edit text in cells Edit numbers in cells Enter numbers with format symbols Change font face Change font size Apply underline Apply date and comma number formats Enter formula arguments by clicking Enter formula arguments by clicking Fill adjacent cells with formulas Enter formula arguments by clicking Fill adjacent cells with formulas Enter formula arguments by clicking Fill adjacent cells with formulas Enter formula arguments by clicking Fill adjacent cells with formulas Edit numbers in cells Edit numbers in cells Enter formula arguments by clicking Fill adjacent cells with formulas Enter formula arguments by clicking Fill adjacent cells with formulas Enter formula arguments by clicking Fill adjacent cells with formulas EX 69 EX 7

6

EX 7; EX 41

7

EX 7

8 9 10

EX 40

EX 69

11

EX 69

12

EX 69

13

EX 69

14 15 16

17

EX 69

18

EX 69

SAM Projects
19 Create formulas using the SUM function Fill adjacent cells with formulas Enter formula arguments by clicking Fill adjacent cells with formulas Create formulas using the IF function Fill adjacent cells with formulas Enter formula arguments by clicking Fill adjacent cells with formulas Set cell color Select non-adjacent cells Create charts using column chart types Move chart to a new worksheet Edit a chart Format charts Modify worksheet names Reposition worksheets in a workbook Format worksheet tabs Use Goal Seek Covered Skills EX 55 EX 15 EX 69

20

EX 69

21

EX 244; EX 69

22

EX 69

23 24

25 26 27

28 Illustrated Excel Unit D: Independent Challenge 1 Project: "Springfield Theater Group" Illustrated Excel Unit D: Independent Challenge 1 (Scenario 2) Project: "Mason Auto Body" Step

EX 139 Textbook Page Remediation

1

Save a workbook with a new name in a different location

2

Create charts using column chart types Position a chart Apply a Quick Style to a chart Edit a chart Create charts using area chart types Move chart to a new worksheet

EX 15

4 5

SAM Projects
6 Create charts using line chart types Move chart to a new worksheet

New Perspectives Excel Tutorial 4: Case Problem 1 Project: "Kenai Fjords National Park" New Perspectives Excel Tutorial 4: Case Problem 1 (Scenario 2) Project: "Serenity Fitness Center"

Step

Covered Skills

Textbook Page Remediation

1

Save a workbook with a new name in a different location

2 3 4 5 6

Create charts using column chart types Move chart to a new worksheet Modify worksheet names Apply a Quick Style to a chart Edit a chart Change font size Edit a chart Rotate text Change font size Rotate and tilt a 3-D Pie chart Create a data table Customize a data series Select non-adjacent cells Create charts using the pie chart types Move chart to a new worksheet Modify worksheet names Reposition worksheets in a workbook Edit a chart Change font size Customize a data series Format chart data labels

EX 15 EX 6

7 8 9 10

EX 15; EX 6

11 12 13 14

EX 175

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

see all of the above

SAM Projects


								
To top