IS-171C Final Project Instructions

Home Typical course schedule Final project details

Create a PowerPoint presentation and an Excel workbook that solves a business problem or relates to an area of your life such as your job, current housing situation, favorite athletic team or hobby.

A.     The PowerPoint presentation should cover the following 4 topic areas (each topic area is worth 3 points):

    ____    First, introduce yourself and your family. For example, the first slide might include your name, age, home city/state (or country), hobbies, year and major at Calvin and career goals.  A second slide might include a family photo along with names and occupations of parents, names and ages of siblings, etc.

    ____    Second, include 1-2 slides that introduce your Excel Workbook.  For example, why did you choose this particular project and how do you plan to use it to solve a business problem.  Now review your Excel workbook.

    ____    Third, after reviewing your Excel workbook, return to your PowerPoint presentation and show 1-2 slides that answer the following question "Name 3-6 new Excel features and/or classroom lecture topics that you learned and expect to use in your future and explain why you chose each new Excel feature or classroom lecture topic."

    ____    Fourth, on a scale of 1-10 (see next page for guidelines), rate your current (end-of-course) Excel skill level and estimate how many hours you spent creating this final project (including the PowerPoint presentation).

B.     The Excel Workbook must include 28 or more of the following 34 Excel features (each feature is worth 3 points):

____ 01.  Absolute or Mixed Cell Address      (use F4 key)    (p. 131)        

____ 02.  Attractive Formatting            (fill/font colors, etc.)    (p. 104)        

____ 03.  Cell Comment                                       (Review tab)    (p. 542)        

____ 04.  Cell Name   (used in a formula)          (Formulas tab)    (p. 161)        

____ 05.  Cell Style     (e.g., Title, Total, etc.)          (Home tab)    (p. 585)        

____ 06.  Chart                                                          (Insert tab)    (p. 178)        

____ 07.  Clip Art or Picture                                   (Insert tab)    (p. 049)        

____ 08.  Conditional Formatting                        (Home tab)    (p. 265)        

____ 09.  Data Passed Between Worksheets                     (p. 458)        

____ 10.  Data Ž Get External Data                      (Data tab)    (p. 488)        

____ 11.  Data Validation                                        (Data tab)    (p. 469)        

____ 12.  Filter   (demo)                                              (Data tab)    (p. 251)        

____ 13.  Formula - Date Arithmetic           (e.g., your age)     p. 144)        

____ 14.  Function - Basic                    (e.g., SUM, AVERAGE)    (p. 141)        

____ 15.  Function - Complex                  (e.g., IF, VLOOKUP)    (p. 150)        

____ 16.  Function/Formula Evaluate         (Formulas tab)    (p. 467)        

____ 17.  Freeze Panes                                           (View tab)    (p. 231)        

____ 18.  Goal Seek   (demo)                                    (Data tab)    (p. 352)

____ 19.  Heading - Multi-line                 ([Alt]+[Enter] keys)    (p. 072)

____ 20.  Heading - Rotated                             (Home tab) (p. 103)

____ 21.  Hidden Column or Row                        (Home tab)    (p. 092)

____ 22.  Hyperlink                                                  (Insert tab)    (p. 450)

____ 23.  Macro with Button                         (Developer tab)    (p. 603)

____ 24.  OLE in PowerPoint Slide or Word Document

____ 25.  Page Setup Standards               (Page Layout tab)    (p. 110)

____ 26.  PivotTable/PivotChart                         (Insert tab)    (p. 297)

____ 27.  Protected Worksheet                        (Review tab)    (p. 593)

____ 28.  Scenarios                                                   (Data tab)    (p. 353)

____ 29.  Scenario Summary                                 (Data tab)    (p. 355)

____ 30.  Sort   (demo)                                                (Data tab)    (p. 249)

____ 31.  Sparklines                                                (Insert tab)    (p. 200)

____ 32.  Subtotals                                                    (Data tab)    (p. 289)

____ 33.  Table                                                          (Insert tab)    (p. 241)

____ 33.  Table                                                          (Insert tab)    (p. 241)

____ 34.  Workbook – password required to re-open *



Final Project Tips and Techniques



1.     Please don't bore me with black on white PowerPoint slides. Use color and a PowerPoint theme or style.

2.     Use the Appear custom animation to reveal your PowerPoint bullets one at a time.

3.     Dim previous bullets on slides in order to focus your audience on the current bullet you are revealing and discussing.

4.     Use simple slide-to-slide transition.  Fancy and/or multiple slide transitions detract from a professional presentation.

5.     Incorporate at least 30 Excel features so you have 1-2 extra features in case you misinterpret or can’t find a feature.

6.     If you incorporate sorting and/or filtering, create a separate copy of these worksheets to quickly show these features.

7.     You must use one of the following 2 techniques to show/demonstrate your Excel features:

a.   Include hyperlinks on a Features worksheet which point to features on other worksheets.  You might also want to include a “Return” hyperlink on the other worksheets that will return to cell A1 of the Features worksheet.

b.   Include macro buttons on a Features worksheet to display features on other worksheets.  You might also want to include a “Return” macro button on the other worksheets that will return to cell A1 of the Features worksheet.

8.     Rehearse your presentation with a friend who will give you constructive criticism and make sure it does not exceed 15 mins.

9.     Please use the following guidelines to estimate your current (end of course) Excel skill level on a scale of 1-10:

  1 = Your only Excel 2010 knowledge is what you learned in 1-2 weeks of the FIT or IDIS course as a Freshman.

  2 = Understand all of the formatting options and know how to create multi-line column headings in a single cell.

  3 = Understand and know how to use relative, mixed and absolute cell references in a formula or function.

  4 = Know how to create charts, use chart shapes and sparklines, and know how to OLE charts into Word documents.

  5 = Know how to pass data between worksheets in a workbook and how to enter formulas with 3D cell references.

  6 = Know how to use Conditional Formatting, data validation, cell names in formulas, and hidden rows or columns.

  7 = Know how to create, sort and filter Tables, and how to use PivotTables, PivotCharts and Scenarios.

  8 = Know how to use advanced functions such as IF, VLOOKUP, PMT, FV, IFERROR, COUNTIFS, and AVERAGEIFS.

  9 = Know how to record and edit macros, and associate them with buttons on worksheets.

10 = Know how to get External Data from other sources and could pass the test to become Microsoft Excel certified.