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.eduOffice 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:
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 |
||