Serf Exported Syllabus Title: CISC-275-w1&2-fall99 Syllabus Columns: 11 EventID: 10296 SyllabusID: 241 Position: 1 Type: 7 Heading: CISC 275: Spreadsheet Applications - General Information Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 10298 SyllabusID: 241 Position: 2 Type: 1 Heading: Course Introduction Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

Welcome to Spreadsheet Applications
via the Internet

This is an advanced course providing experience using electronic spreasheet software as a data analysis and management tool.

The course manual provides realistic, business world cases in the context of solving a problem. Throughout the manual, attention is paid to the multi-cultural, international and ethical issues of business today.

The course begins with two brief overviews - one that compares the Windows 95 and 98 user interfaces and one that provides a quick review of Excel fundamentals.   Regardless of your background, you should go through both overviews.

You will be using the following resources for this course.

Course Manual"New Perspectives Microsoft Excel 97 - Comprehensive", a step-by-step instruction manual (with data files) for using Microsoft Excel 97.
Serf ForumYou will be using online Forums to discuss topics with your instructor and other students.

NOTE! While it is NOT part of this NCC course, by successfully completing the tutorials, case problems and appendices in the text, you will be prepared to take the Expert level MSOUS Exam for Microsoft Excel 97. This is the official Microsoft certification exam for Excel proficiency. Visit the MSOUS Web site at http://www.microsoft.com/office/train_cert/ for details. EventID: 10408 SyllabusID: 241 Position: 3 Type: 1 Heading: Course Objectives Overview Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

Course Objectives Overview

1. Spreadsheet Fundamentals: Through self-paced tutorials, exercises, case problems and comprehensive projects, the student will demonstrate the ability to utilize the fundamental aspects of spreadsheet design, formula construction, chart construction and relative vs. absolute referencing.

2. Construction of Simple Macros: Through self-paced tutorials, exercises, case problems and comprehensive projects, the student will demonstrate the ability to build simple macros using the "macro record" feature of the software.

3. What-if Analysis: Through self-paced tutorials, exercises, case problems and comprehensive projects, the student will demonstrate the ability to perform what-if analysis using goal seeking, one and two input data tables and Excel's scenario manager and solver.

4. Preparing Forecasts: Through self-paced tutorials, exercises, case problems and comprehensive projects, the student will demonstrate the ability to utilize basic statistical and financial functions in analyzing data and preparing forecasts.

5. Consolidating Workbooks: Through self-paced tutorials, exercises, case problems and comprehensive projects, the student will demonstrate the ability to consolidate multiple workbooks.

6. Excel Lists: Through self-paced tutorials, exercises, case problems and comprehensive projects, the student will demonstrate the ability to build and manipulate the database aspect of Excel called lists.

7. Integration with Other Applications: Through self-paced tutorials, exercises, case problems and comprehensive projects, the student will demonstrate how to integrate Excel with other Windows application programs. EventID: 10409 SyllabusID: 241 Position: 4 Type: 1 Heading: Required Hardware & Software Configuration Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

Required Hardware & Software Configuration

At this time, the current hardware and software used for CISC 275, Spreadsheet Applications is as follows.

  • Hardware: an IBM compatible PC (386,486, Pentium or clone)
  • Software: Windows 95 or 98, Microsoft Office 97. NOTE 1: The course manual uses sample screens and instructions for these sofware packages.   If you attempt to use software different from what is required, the lab manual will not be of any use.

    NOTE 2: All lab assignments will be evaluated using the required hardware and software configuration listed here. EventID: 10411 SyllabusID: 241 Position: 5 Type: 1 Heading: Student Skill Assessment (grading) Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

    Student Skill Assessment (grading)

    Read this section carefully. These are the official grading guidelines and policies.
    Assessment of your skills will take 3 forms.
    1. The assignment at the end of each tutorial
    2. Selected case projects
    3. On-campus tests

    Grades are assigned as follows:

    • Tutorial Assignments: 50% of final grade
    • Case Projects: 30% of final grade
    • On-campus tests: 20% of final grade
    All assigned tutorials and case projects are expected to be submitted on time.
    Given the generous amount of time alloted for covering course material, there are serious penalties for late work.

    NOTE! The quality of your work is a component of your grade. Your work must be done neatly and professionally.

    All of your work will be submitted online via SERF. Normally, you will not be required to send diskettes or printouts to your instructor. That policy may change at the discretion of your instructor. If it does, note the following requirements for printouts and diskettes.

    • Printouts
      • Printouts must be as legible as any official business letter, resumé etc.
      • If the printer you're using is starting to print faded characters, change the ink cartridge or ribbon. Do not submit faded, smeared, torn, whiteout-corrected, taped printouts. They will not be accepted for grading.
    • Floppy Disks
      • Floppy disks must be labeled with: your name course name and section number (see your registration papers). Any floppy disk must be sent with a paper detailing its contents. Disks not accompanied by such a list will be returned ungraded.
      • Disk files must be named properly and readable by the configuration listed in the "Hardware and Software Configuration" prior to this section.

    TESTS
    Location:

    • If you registered through Monroe Campus, you must take the test at the Monroe Campus library.
    • If you registered through the Bethlehem Main Campus, you must take the test at the Bethlehem Main Campus library.
    If you need to make special arrangements for taking on-campus tests, contact your instructor.   See "Contacting Your Instructor" under general information.

    Instructions for taking tests:

    • You will need to show some type of official photo ID to the librarian who will then give you the test.
    • Follow the instructions on the cover sheet of the test.
    • When finished, leave all materials with the librarian.
    Your grade will be mailed to you within two weeks. EventID: 15877 SyllabusID: 241 Position: 6 Type: 1 Heading: Contacting Your Instructor Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

    Contacting Your Instructor

    phone: 610-861-4540 ext 1209 (NCC voice mail number)

    e-mail: jpc@mail.nrhm.cc.pa.us (NCC e-mail address)
    (if clicking the above e-mail link does not work, use your own e-mail package and type in the e-mail address manually.)   NOTE:This e-mail address is going to change sometime in Fall '99. You will be notified.

    NOTE! You must register your email address! Click on "Register" in the E-Mail column of the SERF navigation panel. (You get to the navigation panel by scrolling to the bottom of the screen. See page 5 of your SERF Student Jumpstart manual.)

    You are responsible for ensuring all e-mail and any attachments are properly formatted for transfer by e-mail. The instructor is NOT responsible for e-mail material sent but not received.

    Postal Mail:
    Jeff Cassano
    Northampton Community College - CC386
    3835 Green Pond Rd
    Bethlehem, PA 18020-7599

    NOTE! Please make sure you use the correct amount of postage for items sent via U.S. mail. The instructor will NOT pay any postage due charges. Such mail will be returned ungraded to the sender. EventID: 15923 SyllabusID: 241 Position: 7 Type: 1 Heading: Getting Started Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

    Getting Started

    Start this course by doing the following:
    • Carefully review the entire information package you received in the mail.
    • If you are using AOL as you internet service provider, make sure you are using a browser other than AOL's. See the AOL Users section of the your information package.
    • After you log into SERF, register your email. Use the "Register E-mail" selection in the SERF control panel at screen bottom.   This is required so that your instructor can contact send you information, grades etc..
    • Set up a schedule and stick to it. The work load will become intense and challenging. You will fall hopelessly behind if you can't stick to a schedule.
    EventID: 15961 SyllabusID: 241 Position: 8 Type: 1 Heading: Submitting Work for a Grade Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

    Submitting Work for a Grade

    The normal mechanism for submitting work to your instructor will be SERF's "Submit File Assignment". Follow the instructions below.
    • Put into the first worksheet of your workbook the Tutorial # (whether for an assignment or case study) the number of the case study and the page# of the case study.
    • When you have finished an assignment or case project on your own computer, you will log onto SERF to submit the file(s).
    • Go to the appropriate week in the course syllabus.
    • Click on the Submit button for the appropriate assignment (Note: Each assignment will have its own Submit button).
    • Browse your computer to locate the file.
    • Click Submit.
    At this point, SERF copies your file from your PC to our PC and you're done.

    EventID: 15844 SyllabusID: 241 Position: 9 Type: 4 Heading: Condensed Course Schedule Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 15845 SyllabusID: 241 Position: 10 Type: 1 Heading: Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

    Condensed Course Schedule

    This condensed schedule gives you a quick overview of when and where topics fall during the course. A detailed schedule of work, assignments and assessments follows this outline.

    NOTE: The time allotments for the course sections are designed so that you can procede at a relaxed pace. Do not rush with this course.   It starts with a deceptively easy work load, but soon develops to a level that demands very careful thinking and preparation on your part.

    Pace yourself! While you do not have to stick exactly to this schedule, it is strongly advised that you stay as close as possible.

    WEEK 1MS Windows 95 Brief Tuorials MS Windows 98 SupplementExploring Basics, Working with Files, Differences between Windows 95 and 98
    MS Excel 97 - Level I Tutorials
    WEEK 2Tutorial 1Using Worksheets to Make Business Decisions
    Tutorial 2Creating a Worksheet
    WEEK 3Tutorial 3Developing a Professional Looking Worksheet
    Tutorial 4Creating Charts
    WEEK 4ASSESSMENT #1Case Project Assignment
    MS Excel 97 - Level II Tutorials
    WEEK 5Tutorial 5Working with Excel Lists
    WEEK 6Tutorial 6Integrating Excel with Other Windows Programs and the World Wide Web
    WEEK 7Tutorial 7Developing an Excel Application
    WEEK 8ASSESSMENT #2Case Project Assignment
    WEEK 9On-Campus Mid Term Exam
    MS Excel 97 - Level III Tutorials
    WEEK 10Tutorial 8Working with Multiple Worksheets and Workbooks
    WEEK 11continue with tutorial 8
    WEEK 12Tutorial 9Data Tables and Scenario Management
    WEEK 13continue with tutorial 9
    WEEK 14Tutorial 10Using Solver for Complex Problems
    WEEK 15continue with tutorial 10
    Week 16Tutorial 11Importing Data into Excel
    ASSESSMENT #3Case Project Assignment
    MS Excel - Supplemental
    WEEK 17Appendix 1Using Data Maps
    Appendix 2Auditing, Custom Formatting and Sharing Workbooks
    WEEK 18On-Campus Final Exam
    EventID: 15875 SyllabusID: 241 Position: 11 Type: 2 Heading: WEEK 1:
    - Review of Windows 95 Basics
    - Comparing Windows 95 and 98 Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 15876 SyllabusID: 241 Position: 12 Type: 1 Heading: Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:
    Do the following two things for week one.
    1. Review Pages WIN 95.1 through WIN 95.29 in the course manual. No matter what your background with Windows, use this week to make sure you are capable of doing the following in the Windows 95 environment.

      • running multiple programs simultaneously
      • formatting disks
      • setting up directories (folders)
      • copying, moving,renaming and backing up files and directories.
      • using WordPad and Paint

      Go over the section reviewing the Windows 98 Interface that immediately follows the Windows 95 review. NOTE: If you are using Windows 98 Interface, don't worry. It does not affect you for this course. The differences between Windows 95 and 98 are transparent to most users, and irrelevant to Excel 97 (as far as we are concerned).

    2. Download the data files needed for your manual.

      • Create a folder to hold the data files you will download.
      • Use your browser to go to the Web site for you manual.
        http://www.course.com
      • Click on data disk files (Under the Student Learning Heading)
      • Click on Spreadsheets (to right of the "Software" caption)
      • Click on Microsoft Excel 97
      • Scroll down until you see the title of your text "New Perspectives on Microsoft Excel 97 Comprehensive Enhanced" by June Parsons, Dan Oja and Roy Ageloff.
      • Make sure you are in the folder you created and click from backup site for the first group of files. STOP! Before you click save, make sure the "Save in" box has your folder in it. If so, click save. NOTE: You are downloading self-extracting files. When you click on the files, they will uncompress themselves.
      • Repeat the process for the remaining four file groups.

    If you encounter difficulties downloading the data files, contact your instructor. Click "Contacting Your Instructor" in the Detailed Index for details.

    NOTE: There is nothing this week that needs to be submitted to your instructor.

    EventID: 15878 SyllabusID: 241 Position: 13 Type: 2 Heading: WEEK 2: Tutorials 1 and 2
    - Using Worksheets to Make Business Decisions
    - Creating a Worksheet Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 15924 SyllabusID: 241 Position: 14 Type: 1 Heading: Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

    Objectives: Tutorials 1 & 2 Using Worksheets to Make Business Decisions and Creating a Worksheet
    Tutorial 1:Tutorial 2:
    • Start & Exit Excel
    • Discover how Excel is used in business
    • Indentify the major components of the Excel Window
    • Navigate an Excel workbook and worksheet
    • Open, save, print, and close a worksheet
    • Enter text, numbers, formulas, and functions
    • Correct mistakes
    • Perform what-if-analysis
    • Clear contents of cells
    • Use the Excel Help system
    • Plan, build, test, document, preview, and print a worksheet
    • Enter labels, values and formulas
    • Calculate a total using the AutoSum button
    • Copy formulas using the fill handle and Clipboard
    • Learn about relative, absolute, and mixed references
    • Use the AVERAGE, MAX, and MIN functions to calculate values in the worksheet
    • Spell check the worksheet
    • Insert a row
    • Reverse an action using the Undo button
    • Move a range of cells
    • Format the worksheet using AutoFormat
    • Center printouts on a page
    • Customize worksheet headers
    Take careful note of how "planning analysis sheets" and "worksheet sketches" are used in Tutorial 2. All spreadsheets submitted for grading MUST be accompanied by these two items in a separate worksheet of the workbook.

    The time Frame for completing Tutorials 1 & 2 is one week. EventID: 15963 SyllabusID: 241 Position: 15 Type: 1 Heading: What to do for Tutorials 1 & 2 Tracking: 1 Weight: 0 Deadline: 0 Columns: 1 Formatting: 3 Text:

    • Start by reading the objectives list to get an overview of what the tutorial will cover. If you don't know what the objectives terms mean, look them up online in Excel's Help System.
    • Carefully read the description of the case used for the tutorial.   If you don't do this, you won't understand why things are being done in the tutorial.
    • After completing the tutorial, do the assignment immediately following the tutorial and submit it via SERF using the submit file process. See "Submitting Your Work for a Grade" in the detailed index.

    For Tutorial 1, Submit the assignment on page E 1.32.

    For Tutorial 2: Submit the assignment on page E 2.38.

    EventID: 15964 SyllabusID: 241 Position: 16 Type: 22 Heading: Tracking: 0 Weight: 5 Deadline: 7 Columns: 1 Formatting: 3 Text: Submit the tutorial assignment for Tutorial 1 (page E 1.32) here. EventID: 15965 SyllabusID: 241 Position: 17 Type: 22 Heading: Tracking: 0 Weight: 5 Deadline: 7 Columns: 1 Formatting: 3 Text: Submit the tutorial assignment for Tutorial 2 (page E 2.38) here. EventID: 15879 SyllabusID: 241 Position: 18 Type: 2 Heading: WEEK 3: Tutorials 3 and 4
    - Developing a Professional Looking Worksheet
    - Creating Charts Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16002 SyllabusID: 241 Position: 19 Type: 1 Heading: Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

    Objectives: Tutorials 3 & 4 Developing Professional Looking Worksheets and Creating Charts
    Tutorial 3:Tutorial 4:
    • Format data using the Number, Currency, and Percentage formats
    • Align cell contents
    • Center text across columns
    • Change fonts, font style, and font size
    • Use borders and color for emphasis
    • Add comments and grahics to a worksheet using the Drawing toolbar
    • Remove gridlines from the worksheet
    • Print in landscape mode
    • Identiy the elements of an Excel chart
    • Learn which type of chart will represent your data most effectively
    • Create an embedded chart
    • Move and resize a chart
    • Edit a chart
    • Change the appearance of a chart
    • Place a chart in a chart sheet
    • Select nonadjacent ranges
    • Work with 3-D chart types
    • Add a picture to a chart

    The time frame for completing Tutorials 3 & 4 is one week. EventID: 16061 SyllabusID: 241 Position: 20 Type: 1 Heading: What to do for Tutorials 3 & 4 Tracking: 1 Weight: 0 Deadline: 0 Columns: 1 Formatting: 3 Text:

    • Start by reading the objectives list to get an overview of what the tutorial will cover. If you don't know what the objectives terms mean, look them up online in Excel's Help System.
    • Carefully read the description of the case used for the tutorial. If you don't do this, you won't understand why things are being done in the tutorial.
    • After completing the tutorial, do the assignment immediately following the tutorial and submit it via SERF using the submit file process. See "Submitting Your Work for a Grade" in the detailed index.

    For Tutorial 1, Submit the assignment on page E 3.36.

    For Tutorial 2: Submit the assignment on page E 4.34.

    EventID: 16068 SyllabusID: 241 Position: 21 Type: 22 Heading: Tracking: 0 Weight: 5 Deadline: 7 Columns: 1 Formatting: 3 Text: Submit tutorial assignment for Tutorial 3 (Page E 3.36) here. EventID: 16069 SyllabusID: 241 Position: 22 Type: 22 Heading: Tracking: 0 Weight: 5 Deadline: 7 Columns: 1 Formatting: 3 Text: Submit tutorial assignment for Tutorial 4 (page E 4.34) here. EventID: 15880 SyllabusID: 241 Position: 23 Type: 2 Heading: WEEK 4: ASSESSMENT #1 Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 15962 SyllabusID: 241 Position: 24 Type: 22 Heading: Tracking: 0 Weight: 3 Deadline: 7 Columns: 2 Formatting: 3 Text: You must complete the following assessment item during this fourth week of the course.

    A case project that exercises the concepts in tutorials 1, 2, 3, and 4

    Case projects are made available only during the week indicated in the course schedule. Contact your instructor when you are ready. Remember that case projects must be done using a platform described in the Required Hardware & Sofware Configuration section of the general information section of this online program.

    When you have completed the case project, submit it using the SERF Submit File Assignment process. The entry box immediately follows this section.

    EventID: 15881 SyllabusID: 241 Position: 25 Type: 2 Heading: WEEK 5: Tutorial 5
    - Working with Excel Lists Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16058 SyllabusID: 241 Position: 26 Type: 1 Heading: Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

    Objectives: Tutorial 5Working with Excel Lists
    • Identify the elements of an Excel list
    • Freeze rows and columns
    • Sort data in a list
    • Use a data form to enter, search for, edit, and delete records
    • Filter data in a list using AutoFilters
    • Apply conditional formatting to a range
    • Create natural language formulas
    • Insert subtotals into a list
    • Use the subtotals outline view
    • Insert page breaks using Page Break Preview
    • Summarize a list using pivot tables

    The time frame for completing Tutorial 5 is one week. EventID: 16060 SyllabusID: 241 Position: 27 Type: 1 Heading: What to do for Tutorial 5 Tracking: 1 Weight: 0 Deadline: 0 Columns: 1 Formatting: 3 Text:

    • Start by reading the objectives list to get an overview of what the tutorial will cover. If you don't know what the objectives terms mean, look them up online in Excel's Help System.
    • Carefully read the description of the case used for the tutorial. If you don't do this, you won't understand why things are being done in the tutorial.
    • After completing the tutorial, do the assignment immediately following the tutorial and submit it via SERF using the submit file process. See "Submitting Your Work for a Grade" in the detailed index.

    For Tutorial 5, Submit the assignment on page E 5.42.

    EventID: 16070 SyllabusID: 241 Position: 28 Type: 22 Heading: Tracking: 0 Weight: 5 Deadline: 7 Columns: 1 Formatting: 3 Text: Submit the tutorial assignment for Tutorial 5 (page E 5.42) here. EventID: 15882 SyllabusID: 241 Position: 29 Type: 2 Heading: WEEK 6: Tutorial 6
    - Integrating Excel with Other Windows Programs and the World Wide Web Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16064 SyllabusID: 241 Position: 30 Type: 1 Heading: Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

    Objectives: Tutorial 6       Integrating Excel with Other Windows Programs and the World Wide Web
    • Learn about Object Linking and Embedding (OLE)
    • Pate a graphic object into an Excel worksheet
    • Embed a WordArt object in Excel
    • Link an Excel worksheet to a Word document
    • Update linked documents
    • Embed an Excel chart in a Word document
    • Complete a mail merge using an Excel list and a Word document
    • View documents from a mail merge
    • Preview and print a mail-merged document
    • Create hyperlinks to connect files
    • Convert worksheet data to HTML format

    The time frame for completing Tutorial 6 is one week. EventID: 16065 SyllabusID: 241 Position: 31 Type: 1 Heading: What to do for Tutorial 6 Tracking: 1 Weight: 0 Deadline: 0 Columns: 1 Formatting: 3 Text:

    • Start by reading the objectives list to get an overview of what the tutorial will cover. If you don't know what the objectives terms mean, look them up online in Excel's Help System.
    • Carefully read the description of the case used for the tutorial. If you don't do this, you won't understand why things are being done in the tutorial.
    • After completing the tutorial, do the assignment immediately following the tutorial and submit it via SERF using the submit file process. See "Submitting Your Work for a Grade" in the detailed index.

    For Tutorial 6, Submit the assignment on page E 6.43.

    EventID: 16066 SyllabusID: 241 Position: 32 Type: 22 Heading: Tracking: 0 Weight: 5 Deadline: 7 Columns: 1 Formatting: 3 Text: Submit the tutorial assignment for Tutorial 6 (page E 6.43) here. EventID: 15883 SyllabusID: 241 Position: 33 Type: 2 Heading: WEEK 7: Tutorial 7
    - Developing an Excel Application Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16071 SyllabusID: 241 Position: 34 Type: 1 Heading: Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

    Objectives: Tutorial 7 Developing an Excel Application
    • Arrange a worksheet in sections
    • Assign data validation rules to a cell
    • Assign and use range names
    • Use IF and FV functions in formulas
    • Create a series using AutoFill
    • Protect worksheets
    • Delete unnecessary sheets from a workbook
    • Plan and record Excel macros
    • Run a macro using menu commands
    • Run a macro using a shortcut key
    • View Visual Basic for Applications code

      The time frame for completing Tutorial 7 is one week EventID: 16072 SyllabusID: 241 Position: 35 Type: 1 Heading: What to do for Tutorial 7 Tracking: 1 Weight: 0 Deadline: 0 Columns: 1 Formatting: 3 Text:

      • Start by reading the objectives list to get an overview of what the tutorial will cover. If you don't know what the objectives terms mean, look them up online in Excel's Help System.
      • Carefully read the description of the case used for the tutorial. If you don't do this, you won't understand why things are being done in the tutorial.
      • After completing the tutorial, do the assignment immediately following the tutorial and submit it via SERF using the submit file process. See "Submitting Your Work for a Grade" in the detailed index.

      For Tutorial 7, submit the assignment on page E 7.41

      EventID: 16222 SyllabusID: 241 Position: 36 Type: 22 Heading: Tracking: 0 Weight: 5 Deadline: 7 Columns: 0 Formatting: 3 Text: Submit the tutorial assignment for Tutorial 7 (page 7.41) here. EventID: 15884 SyllabusID: 241 Position: 37 Type: 2 Heading: WEEK 8: ASSESSMENT #2 Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16223 SyllabusID: 241 Position: 38 Type: 22 Heading: Tracking: 0 Weight: 3 Deadline: 7 Columns: 2 Formatting: 3 Text: You must complete the following assessment item during this eigth week of the course.

      A case project that exercises the concepts in tutorials 5, 6, and 7.

      Case projects are made available only during the week indicated in the course schedule. Contact your instructor when you are ready.   Remember that case projects must be done using a platform described in the Required Hardware & Sofware Configuration section of the general information section of this online program.

      When you have completed the case project, submit it using the SERF Submit File Assignment process. The entry box immediately follows this section. EventID: 15885 SyllabusID: 241 Position: 39 Type: 2 Heading: WEEK 9: MID TERM EXAM Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16224 SyllabusID: 241 Position: 40 Type: 1 Heading: Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text: You must complete the following assessment item during this ninth week of the course.

      An on-campus test covering all material in Tutorials 1 through 7.

      Most of the test covers concepts, with a minimal number of questions covering specific technique. The test is multiple choice format. See Student Skills Assessment in the Detailed Index for instructions. EventID: 15886 SyllabusID: 241 Position: 41 Type: 2 Heading: WEEK 10: Tutorial 8
      - Working with Multiple Worksheets and Workbooks Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16076 SyllabusID: 241 Position: 42 Type: 1 Heading: Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

      Objectives: Tutorial 8 Working with Multiple Worksheets and Workbooks
      • Insert, name, and move worksheets
      • Create worksheet groups
      • Edit multiple worksheets at the same time
      • Consolidate informations from multiple worksheets and workbooks
      • Create a workbook template
      • Learn how to store templates
      • Create a lookup table and use Excel's lookup function

      The time frame for completing Tutorial 8 is two weeks. EventID: 16079 SyllabusID: 241 Position: 43 Type: 1 Heading: What to do for Tutorial 8 Tracking: 0 Weight: 0 Deadline: 0 Columns: 1 Formatting: 3 Text: NOTE: You have two weeks, not one, to do this tutorial. You don't have to submit the tutorial assignment until after week 11. Remember, take your time.

      • Start by reading the objectives list to get an overview of what the tutorial will cover. If you don't know what the objectives terms mean, look them up online in Excel's Help System.
      • Carefully read the description of the case used for the tutorial. If you don't do this, you won't understand why things are being done in the tutorial.
      • After completing the tutorial, do the assignment immediately following the tutorial and submit it via SERF using the submit file process. See "Submitting Your Work for a Grade" in the detailed index.

      EventID: 15887 SyllabusID: 241 Position: 44 Type: 2 Heading: WEEK 11: continue with tutorial 8 Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16082 SyllabusID: 241 Position: 45 Type: 1 Heading: Continuation of Tutorial 8 Tracking: 1 Weight: 0 Deadline: 0 Columns: 1 Formatting: 3 Text: You should be finishing Tutorial 8 this week. When you do, submit the tutorial assignment (page E 8.45) via the normal SERF Submit File Assignment process. EventID: 16083 SyllabusID: 241 Position: 46 Type: 22 Heading: Tracking: 0 Weight: 5 Deadline: 7 Columns: 1 Formatting: 3 Text: Submit the tutorial assignment for Tutorial 8 (page E 8.45) here. EventID: 15888 SyllabusID: 241 Position: 47 Type: 2 Heading: WEEK 12: Tutorial 9
      - Data Tables and Scenario Manager Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16084 SyllabusID: 241 Position: 48 Type: 1 Heading: Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

      Objectives: Tutorial 9 Data Tables and Scenario Manager
      • Examine cost-volume-profit relationships
      • Learn the principles of multiple what-if analyses
      • Use one-variable data tables to perform a what-if analysis
      • Use two-variable data tables to perform a what-if analysis
      • Create scenarios to perform what-if analyses
      • Create a scenario summary report to save your conclusions
      The time frame for completing Tutorial 9 is two weeks. EventID: 16085 SyllabusID: 241 Position: 49 Type: 1 Heading: What to do for Tutorial 9 Tracking: 0 Weight: 0 Deadline: 0 Columns: 1 Formatting: 3 Text: NOTE! Data tables are tricky at first, so please remember to TAKE YOUR TIME!!!
      • Start by reading the objectives list to get an overview of what the tutorial will cover. If you don't know what the objectives terms mean, look them up online in Excel's Help System.
      • Carefully read the description of the case used for the tutorial. If you don't do this, you won't understand why things are being done in the tutorial.
      • After completing the tutorial, do the assignment immediately following the tutorial and submit it via SERF using the submit file process. See "Submitting Your Work for a Grade" in the detailed index.

      EventID: 15889 SyllabusID: 241 Position: 50 Type: 2 Heading: WEEK 13: continue with tutorial 9 Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16086 SyllabusID: 241 Position: 51 Type: 1 Heading: Continuation of Tutorial 9 Tracking: 1 Weight: 0 Deadline: 0 Columns: 1 Formatting: 3 Text: You should be finishing Tutorial 9 this week. When you do, submit the tutorial assignment (page E 9.35) via the normal SERF Submit File Assignment process. EventID: 16088 SyllabusID: 241 Position: 52 Type: 22 Heading: Tracking: 0 Weight: 5 Deadline: 7 Columns: 1 Formatting: 3 Text: Submit the tutorial assignment for Tutorial 9 (page E 9.35) here. EventID: 15890 SyllabusID: 241 Position: 53 Type: 2 Heading: WEEK 14: Tutorial 10
      - Using Solver for Complex Problems Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16087 SyllabusID: 241 Position: 54 Type: 1 Heading: Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

      Objectives: Tutorial 10 Using Solver for Complex Problems
      • Formulate a problem
      • Perform what-if analysis (a new way)
      • Try to solve a problem using trial and error
      • Use Goal Seek to automate the trial-and-error process
      • Use Solver to find the best solution
      • Create an answer report
      The time frame for completing Tutorial 10 is two weeks. EventID: 16089 SyllabusID: 241 Position: 55 Type: 1 Heading: What to do for Tutorial 10 Tracking: 0 Weight: 0 Deadline: 0 Columns: 1 Formatting: 3 Text: NOTE: With this topic you have two weeks instead of one to do the work.

      • Start by reading the objectives list to get an overview of what the tutorial will cover. If you don't know what the objectives terms mean, look them up online in Excel's Help System.
      • Carefully read the description of the case used for the tutorial. If you don't do this, you won't understand why things are being done in the tutorial.
      • After completing the tutorial, do the assignment immediately following the tutorial and submit it via SERF using the submit file process. See "Submitting Your Work for a Grade" in the detailed index.

      EventID: 15891 SyllabusID: 241 Position: 56 Type: 2 Heading: WEEK 15: continue with tutorial 10 Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16090 SyllabusID: 241 Position: 57 Type: 1 Heading: Continuation of Tutorial 10 Tracking: 1 Weight: 0 Deadline: 0 Columns: 1 Formatting: 3 Text: You should be finishing Tutorial 10 this week. When you do, submit the tutorial assignment (page E 10.29) via SERF's Submit File Assignment process EventID: 16091 SyllabusID: 241 Position: 58 Type: 22 Heading: Tracking: 0 Weight: 5 Deadline: 7 Columns: 1 Formatting: 3 Text: Submit the tutorial assignment for Tutorial 10 (page 10.29) here. EventID: 15892 SyllabusID: 241 Position: 59 Type: 2 Heading: WEEK 16: - Tutorial 11
      - Importing Data into Excel
      - ASSESSMENT #3 Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16092 SyllabusID: 241 Position: 60 Type: 1 Heading: Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

      Objectives: Tutorial 11 Importing Data into Excel
      • Import data from a text file into an Excel workbook
      • Retrieve data from a database using the Query Wizard
      • Retrieve data from multiple database tables
      • Retrieve data from a database into a pivot table
      • Retrieve stock market data from the World Wide Web
      • Use hyperlinks to view infofmation on the World Wide Web

      The time frame for doing Tutorial 11 is one week. EventID: 16093 SyllabusID: 241 Position: 61 Type: 1 Heading: What to do for Tutorial 11 Tracking: 1 Weight: 0 Deadline: 0 Columns: 1 Formatting: 3 Text:

      • Start by reading the objectives list to get an overview of what the tutorial will cover. If you don't know what the objectives terms mean, look them up online in Excel's Help System.
      • Carefully read the description of the case used for the tutorial. If you don't do this, you won't understand why things are being done in the tutorial.
      • After completing the tutorial, do the assignment immediately following the tutorial and submit it via SERF using the submit file process. See "Submitting Your Work for a Grade" in the detailed index.

      Submit the Tutorial assignment on page 11.41 via SERF's Submit File Assignment process. EventID: 16094 SyllabusID: 241 Position: 62 Type: 22 Heading: Tracking: 0 Weight: 5 Deadline: 7 Columns: 1 Formatting: 3 Text: Submit the tutorial assignment for Tutorial 11 (page E 11.41) here. EventID: 16095 SyllabusID: 241 Position: 63 Type: 22 Heading: Tracking: 0 Weight: 3 Deadline: 7 Columns: 2 Formatting: 3 Text:

      ASSESSMENT #3

      You must complete the following assessment item during this sixteenth week of the course.

      A case project that exercises the concepts the the tutorials 8, 9, 10, and 11

      Case projects are made available only during the week indicated in the course schedule. Contact your instructor when you are ready. Remember that case projects must be done using a platform described in the Required Hardware & Sofware Configuration section of the general information section of this online program. When you have completed the case project, submit it using the SERF Submit File Assignment process. The entry box immediately follows this section.

      EventID: 15893 SyllabusID: 241 Position: 64 Type: 2 Heading: WEEK 17: Appendices 1 and 2
      - Using Data Maps
      - Auditing, Custom Formatting and Sharing Workbooks Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16096 SyllabusID: 241 Position: 65 Type: 1 Heading: Tracking: 0 Weight: 0 Deadline: 0 Columns: 2 Formatting: 3 Text:

      Objectives: Appendix 1 & 2 Using Data Maps and Auditing, Custom Formatting, and Sharing Workbooks
      Appendix 1:Appendix 2:
      • Create a data map
      • Modify titles and legends on a data map
      • Resize a data map
      • Change the format of a data map
      • Display multiple sets of data in different formats on a single map
      • Magnify an area of a data map
      • Display labels on a data map
      • Create a custom pin map
      • Remove map features from a data map
      • Trace dependent and precedent cells in a workbook
      • Uncover and correct worksheet errors
      • Create and applay a style
      • Create and apply a style
      • Create and apply custom formats for numbers adn dates
      • Save and edit a worksheet template
      • Share workbooks

      NOTE: The time frame for completing BOTH appendices is one week EventID: 16097 SyllabusID: 241 Position: 66 Type: 1 Heading: What to do for Appendices 1 & 2 Tracking: 1 Weight: 0 Deadline: 0 Columns: 1 Formatting: 3 Text:

      • Start by reading the objectives list to get an overview of what the appendix tutorial will cover. If you don't know what the objectives terms mean, look them up online in Excel's Help System.
      • Carefully read the description of the case used for the appendix tutorial. If you don't do this, you won't understand why things are being done in the appendix tutorial.
      • After completing the appendix tutorial, do the assignment immediately following the tutorial and submit it via SERF using the submit file process. See "Submitting Your Work for a Grade" in the detailed index.

      For Appendix 1, submit the tutorial assignment on page A 1.22.

      For Appendix 2, submit the tutorial assignment on page A 2.25. EventID: 16098 SyllabusID: 241 Position: 67 Type: 22 Heading: Tracking: 0 Weight: 5 Deadline: 7 Columns: 1 Formatting: 3 Text: Submit the tutorial for Appendix 1 (page A 1.22) here. EventID: 16099 SyllabusID: 241 Position: 68 Type: 22 Heading: Tracking: 0 Weight: 5 Deadline: 7 Columns: 1 Formatting: 3 Text: Submit the tutorial assignment for Appendix 2 (page A 2.25) here. EventID: 15894 SyllabusID: 241 Position: 69 Type: 2 Heading: WEEK 18: FINAL EXAM Tracking: 0 Weight: 0 Deadline: 0 Columns: 0 Formatting: 3 Text: EventID: 16101 SyllabusID: 241 Position: 70 Type: 22 Heading: Tracking: 0 Weight: 3 Deadline: 7 Columns: 2 Formatting: 3 Text: You must complete the following assessment item during this eighteenth week of the course.

      An on-campus Final Exam covering all material from Tutorial 8 through the two Appendices.

      Most of the test covers concepts, with a minimal number of questions covering specific technique. The test is multiple choice format. See Student Skills Assessment in the Detailed Index for instructions.