BUA/CSC 214 - Advanced Business Computing

Fall 2002 - Section 70 - Curtis 208 - Tu 7:00-9:30

Course Description

The application of advanced features of software to solve business problems through computer modeling and other techniques. Emphasis will be on the writing of spreadsheet macros and database application development.

Prerequisites

CSC 100, or equivalent experience.

Course Objectives

Textbook

Shelly, Cashman, & Quasney; Excel 2000, Comprehensive Concepts and Techniques; Course Technology; 2000. ISBN 0-7895-5609-X.

Shelly, Cashman, & Pratt; Access 2000, Comprehensive Concepts and Techniques; Course Technology; 2002. ISBN 0-7895-5610-3.

Course Resources

Resources for this course will be placed in the following location on the campus network: H:\users\nlippinc\bua214

Software

Microsoft Office 2000 is required for both in-class work and outside assignments. In particular, Office components Excel 2000 and Access 2000 will be used.

 

 

Instructor

Norman Lippincott

Asst. Professor, Computer Science

Office: Curtis 105

Phone: 610-437-4471, ext. 6197

e-mail: nlippinc@cedarcrest.edu

Office Hours

Monday: 1:00-3:00, 5:30-6:30

Tuesday: 5:30-6:30

Wednesday: 1:00-3:00

Friday: 1:00-3:00

Assessment Overview

Grades for this course will be based on the following assessment items with weights as shown:

Assignments 45%

Tests 50%

Class Participation 5%

A final score is calculated as a weighted average and rounded to the nearest full percent. Final grade is then awarded according to the following scale:

93-100 A 73-76 C

90-92 A- 70-71 C-

87-89 B+ 67-69 D+

83-86 B 60-66 D

80-82 B- 0-59 F

77-79 C+

Assessment

Assignments

Assignments for the course will require the student to design and implement a solution to one or more problems using Excel or Access.

Through assignments, the student demonstrates ability to apply course concepts to large, complex problems that require thought, planning, design, and implementation.

Tests

Tests will consist of both computer-based and written portions. The computer-based portion will require the use of Excel or Access to solve small, specific problems. The written portion will consist of short-answer and short-essay questions. Use of computer during the tests is strictly limited to use of the application software related to the test. Use of web browsing, e-mail, instant messaging, or other non-test related computer activity during the test will result in a grade of zero for the test.

Through tests the student demonstrates competence in course concepts in specific, limited situations.

Class Participation

Students who are active and attentive members of the class may receive up to 5 points for class participation. Students who engage in side conversations during class time should expect no more than 3 points for class participation. Students who engage in web browsing, e-mail, instant messaging, or other non-class related computer activity during class time should expect no more than 2 points.

Due Dates and Late Work

Assignments are due at the beginning of class on the day they are due. By turning in assignments on time your work will be graded and returned in a timely manner (typically within one week), and with comments as appropriate.

Work turned in late will be subject to any or all of the following:

  1. A penalty of 10% of the total possible score will be assessed; 20% if work is a week late or more.
  2. The assignment may be graded without comment.
  3. The assignment will be graded and returned at the instructor’s convenience, possibly as late as the end of the semester.

Extra Credit

Requests for extra credit will be handled on a case-by-case basis. Typically, requests for extra credit will be granted for the purpose of improving a poor test score or assignment grade. Extra credit assignments will be directly related to the material that was the source of difficulty for the student, and gives the student a chance to show that she has, in fact, overcome that difficulty.

General Policies

Honor Philosophy

The Cedar Crest College Student Handbook, Honor Philosophy part III, Community Standards for Academic Conduct, includes the following:

"As a student at Cedar Crest College, each student shall:

Unless specifically designated by the instructor, assignments for this course are individual assignments, not group projects. It is reasonable and appropriate for students to discuss an assignment outside of class, particularly for programming projects. However, the actual assignment work, whether programming or written, is to be one’s own. It is not appropriate to collaborate on programming assignments, nor is it appropriate to copy another student’s program (or other assignment), alter the program’s (or assignment’s) appearance (e.g. changing formatting, variable names, output text), and present it as your own individual work. Evidence of such behavior will be considered a violation of the Honor Philosophy and will result in a grade of zero for the assignment. A second offense will result in a grade of "F" for the course.

Classroom Protocol

Appropriate classroom behavior is implicit in the Cedar Crest Honor Code. Such behavior is defined and guided by complete protection for the rights of all students and faculty to a courteous, respectful classroom environment. That environment is free from distractions such as late arrivals, early departures, inappropriate conversations, and any other behaviors that might disrupt instruction and/or compromise students’ access to their Cedar Crest College education.

 

Attendance

Regular attendance is an important factor contributing to student’s success in the class. Although much of the material covered in class comes from the textbook, some course content may come from instructor’s notes or other resources, and may be delivered only in lecture form. The student is responsible for all material covered in class, and should arrange to get notes from another student in the event of absence from class. The instructor’s notes are not available for perusal by the students.

Your instructor keeps an attendance record for the class, however this record does not directly affect the student’s grade. If a student has excessive absence and is not showing responsibility for the course material, an academic performance notice will be issued to the Advising Center.

If a student will be absent on the day of a test, arrangements for a makeup must be made in advance of the test. Failure to do so will result in a grade of zero for the test.

Students with Disabilities

Students with documented disabilities who may need academic accommodations should discuss these needs with their professors during the first two weeks of class. Students with disabilities who wish to request accommodations should contact the Advising Center.

Computer Classrooms

When classes are conducted in computer classrooms, the computers are to be used only for activities directly related to the class. Use of class computers for other activities, such as web browsing, e-mail, games, instant messaging, and so on, is not permitted. Be aware that such activity not only distracts you from the class, but distracts other students as well. Students who engage in such activity during class will receive a reduced class participation grade.

Course Schedule

The following is a tentative schedule for the course and may be adjusted as necessary during the semester.

Tue

Topic / Reading

Assignments

8/27

Course Intro

Excel Review – Prj. 1, 2, 3

Assignment 1

Due: 9/10

9/3

Prj. 4 – Financial Functions, Data Tables, Amortization Schedules

9/10

Prj. 5 – Creating, Sorting, and Querying a Worksheet Database

Assignment 2

Due: 9/24

9/17

Prj. 6 – Working with Multiple Worksheets and Workbooks

Test 1

9/24

Prj. 7 – Using Visual Basic for Applications (VBA) with Excel

Assignment 3

Due: 10/8

10/1

Prj. 8 – Auditing, Data Validation, and Solving Complex Problems

10/8

Access Review – Prj. 1, 2, 3

Test 2

Assignment 4

Due: 10/22

10/22

Prj. 4 – Reports, Forms, and Combo Boxes

Assignment 5

Due: 11/5

10/29

Prj. 5 – Enhancing Forms with OLE Fields, Hyperlinks, and Subforms

11/5

Assignment 6

Due: 11/19

11/12

Prj. 6 – Creating an App. System using Macros, Switchboard Manager

Test 3

11/19

Prj. 7 – Creating a Report using Design View

Assignment 7

Due: 12/3

Prj. 8 – Customizing Forms using Visual Basic for Applications (VBA), Charts, and PivotTable Objects

11/26

12/3

Prj. 9 – Administering a Database System

TBA

Test 4