Docstoc

Excel

Document Sample
Excel Powered By Docstoc
					                                                                     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
                            6     Add headers to worksheets                   EX 13
                            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)
Project: "Estrada
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
                               Fill adjacent cells with formulas
                         10    Enter formula arguments by
                               clicking
                               Fill adjacent cells with formulas
                         11    Enter formula arguments by
                               clicking
                               Fill adjacent cells with formulas
                         12    Enter formula arguments by
                               clicking
                               Fill adjacent cells with formulas
                         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
                                Fill adjacent cells with formulas
                          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
                                Fill adjacent cells with formulas
                          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
                                Add borders
                          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
                                 Adjust table style options
                           8     Set cell color
                           9     Apply a Quick Style to an
                                 existing table
                                 Adjust table style options
                                 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
                           13    Add headers to worksheets                 EX 13
Shelly Cashman Excel      Step            Covered Skills             Textbook Page
Chapter 2: Lab 1                                                      Remediation
Project: "Façade
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
                                 Fill adjacent cells with formulas
                           7     Create a formula using the            EX 56; EX 69
                                 Insert Function button
                                 Fill adjacent cells with formulas
                                                                       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
                                   Fill adjacent cells with formulas
                             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
                                   Add borders
                             11    Center cell content                    EX 40 ; EX 7
                                   Apply styles
                                   Apply bold and italics
                             12    Apply styles                        EX 40 - EX 41; EX 7
                                   Add borders
                                   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
                                Fill adjacent cells with formulas
                          3     Use absolute references             EX 70; EX 56; EX 69
                                Create a formula using the
                                Insert Function button
                                Fill adjacent cells with formulas
                          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
                          12    Add borders                               EX 41
                          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
     Add borders
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
     Fill adjacent cells with formulas
11   Enter formula arguments by                  EX 69
     clicking
     Fill adjacent cells with formulas
12   Enter formula arguments by                  EX 69
     clicking
     Fill adjacent cells with formulas
13   Enter formula arguments by                  EX 69
     clicking
     Fill adjacent cells with formulas
14   Edit numbers in cells
15   Edit numbers in cells
16   Enter formula arguments by                  EX 69
     clicking
     Fill adjacent cells with formulas
17   Enter formula arguments by                  EX 69
     clicking
     Fill adjacent cells with formulas
                                                                    SAM Projects

                          18    Enter formula arguments by                EX 69
                                clicking
                                Fill adjacent cells with formulas
                          19    Create formulas using the SUM             EX 69
                                function
                                Fill adjacent cells with formulas
                          20    Enter formula arguments by                EX 69
                                clicking
                                Fill adjacent cells with formulas
                          21    Create formulas using the IF          EX 244; EX 69
                                function
                                Fill adjacent cells with formulas
                          22    Enter formula arguments by                EX 69
                                clicking
                                Fill adjacent cells with formulas
                          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"

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:12/10/2013
language:Unknown
pages:12
Abbydoc Abbydoc
About Abbydoc@163.com