Make your own free website on

Shawnee State University




Course:  BUOA1150-02   Spreadsheet Applications

                  Room:  Kricker 152                Time:  TR

                                                                   12:30 – 1:45 pm


Term:     Spring Semester, 2010


Professor:  Mr. Jean P Houser


Office Hours:  Room:  Kricker 227

                             Office phone 351-3670

                             Campus e-mail:


Prerequisites:  BUAI101


Required Materials: New Perspectives on Microsoft Excel 2007 - Comprehensive


SAM 2003 Software from Course Technology


USB Drive as needed to store assignments.


Note: Bring your textbook to each class.  You will also be required to register for SAM because we will be using this software for training and testing.  If you lack the funds to purchase the textbook and additional materials required for class, either borrow the cash or drop the course and enroll in a subsequent semester after you have saved sufficient money for the materials, or transfer to another section that may not require these materials.


Course Description: 

This course provides instruction on the use of Excel 2007 software using a business case based approach.


Course Outline: 

Upon completion of this course, you must demonstrate that you:



  1. can create, spell check, preview, save, and print worksheets and charts.
  2. can format data using comma, currency, percent styles, borders, and AutoFormat.
  3. can enter formulas and supply functions such as SUM, AVERAGE, MAX, MIN, IF, PV, FV, and VLOOKUP.
  4. can create, sort, and query a list.
  5. can create formulas that use a 3-D cell reference and link and embed worksheets.
  6. can templates and work with multiple worksheets and workbooks.
  7. can create, execute, and edit a macro.
  8. can track, highlight, and review changes to a workbook.
  9. can merge and mail workbooks.
  10. can create and use names.
  11. import data from sources such as text files, Access databases, web pages, and XML maps and export data from a workbook in standard formats.
  12. can analyze worksheet data using PivotTables and Pivot Charts.
  13. can add hyperlinks and comments to worksheet elements.


Course Policies:


Missed Classes: You are responsible for the activities of each class period. Assignments are due as stated on the attached weekly schedule. Late assignments will receive half credit.


Class attendance is mandatory for all tests on the day scheduled. Legitimate absences do not excuse the student from class responsibilities.


Academic Integrity
You are required to do your own work on all tests and assignments. Any form of cheating may result in a grade penalty or being withdrawn from the course as well as dismissal from the University. See page 37 of the
Shawnee State University catalog.


ADA Statement
Section 504 of the Rehabilitation Act of 1973 and the Americans with Disabilities Act of 1990 require
Shawnee State University to provide reasonable academic adjustments or accommodations for students with documented disabilities which would not compromise the integrity of the academic program.  Examples of documented disabilities include physical, psychiatric, and/or learning impairments that substantially limit one or more major life activities of the student.  Students seeking academic adjustments or accommodations must self-identify with the Coordinator of Disability Services, Student Success Center, Massie Hall, 740-351-3276.   After meeting with the Coordinator, students are encouraged to meet with their instructors to discuss their needs, and if applicable, any lab safety concerns related to their disabilities.


Course Structure and Schedule:


Lectures/Demonstrations: The first part of each class will be used to highlight the important material within each tutorial using interactive discussions, group work, handouts, and computer demos.


Labs: The remainder of the class will be hands-on learning, facilitated by the instructor.  You will work at your own pace during this portion of the class to learn the tutorial material and/or complete projects and cases.


Projects: You will complete the unit tutorial exercises, the review assignment at the end of each tutorial, and selected case problems at the end of the unit.  Additional projects not listed on the weekly schedule will be provided for some tutorials.


Tests: SAM 2003 Assessment & Training is available for additional learning and reinforcement.


Deadlines will be set as you progress through the quarter.



60% of the final grade – Tests using the features of Excel

30% of the final grade – Tutorials, projects, and cases

10% of the final grade – SAM Training Assignments


Final Exam – This exam will be comprehensive and it will replace your lowest test score.  If you have missed a test during the course of the semester, then the final exam will replace that score.  All students are expected to take the final exam.



Grading Scale:         90 – 100   A

                               80 – 89     B

                               70 – 79     C

                               60 – 69     D

                               Below 60  F



Make-Up Tests: The Final Exam will count 100 points and will also makeup any points missed on tests because of absences.  Therefore, if a student misses a test, the final exam will count 200 points for that student.


Record Retention:

The instructor will retain all student work submitted for grading for two weeks after the end of the quarter, at which time they will put the material through the paper shredder.




Location of data files:

All data files are located on the X drive under BUAI 215.  Copy the Tutorial files onto your 3 ฝ” diskette or USB drive before starting the assignments.


Excel 2003 is loaded in the Success Center as well as SAM.  Use Lab 1490 for SAM.  You may also use the labs in Kricker Hall when they are open.


 BUAI 215 Spreadsheet Applications

Tentative Weekly Schedule



Reading Assignment

Laboratory Assignment



Tutorial 1

Using Excel to Manage Data (Creating a Sales Order Report)

T1.1 and 1.2

Review Assignment

Case I

SAM Training


Tutorial 2

Working with Formulas and Functions (Developing a Family Budget)

T2.1 and 2.2

Review Assignment

Case 1

SAM Training








Tutorial 3

Developing a Professional-Looking Worksheet (Formatting a Sales Report)   


T3.1 and 3.2

Review Assignment

Cases 1 and 2

SAM Training


Tutorial 4

Working with Charts and Graphics

(Charting Sales Data)


Test 1 – Tutorials 1-3

T4.1 and 4.2

Review Assignment

Cases 1 and 2

SAM Training



Tutorial 5

Working with Excel Tables, PivotTables, and PivotCharts

(Tracking Museum Art Objects)


T5.1, 5.2 and 5.3

Review Assignment

Case 1

SAM Training


Tutorial 6

Working with Multiple Worksheets and Workbooks

(Tracking Cash Flow)


T6.1, 6.2, and 6.3.

Review Assignment

Case 1

SAM Training



Continue Tutorial 6

Test 2 – Tutorials 4 and 5



Tutorial 11

Importing Data into Excel

(Working with a Stock Portfolio)



T11.1, 11.2, 11.3

Review Assignment

Case 1

SAM Training


Tutorial 7

Working with Excel’s Editing and Web Tools

(Comments, Hyperlinks)


Case 1

SAM Training


Tutorial 8

Developing an Excel Application



Review Assignment

SAM Training

Test 3 – Tutorials 6 - 11

Exam Week

Final Exam