CIT 281
Adv. Bus. Sys.

Spring 2007

Instructor:

Gary Bricher


Home

Syllabus

Schedule

Assignments

Announce

Links

Notes


 

General Info

  • CIT 281 Advanced Business Systems, Spring 2007
      TueThu 8:30am-9:50am, 216 ALL
      Prerequisites: CIS 111
      Credits: 4
      CRN: 31294
  • Instructor: Gary Bricher
      Office: 162 Deschutes
      Tue & Thu 10:00am-11:00am, or by appointment
      Phone: 541-346-0488
      bricherg@cs.uoregon.edu
  • GTF: Jonathan Lidbeck
      Office: 254 Deschutes
      Tue & Wed 2:00pm-3:00pm, or by appointment
      Phone: 541-346-4436
      jlidbeck@cs.uoregon.edu

Description

This is the third course in the CIT minor program, and builds upon the concepts and applications presented in CIS 110 Information Processing and CIS 111 Computers and Computation.  In CIT 281, students learn to develop integrated office applications using Visual Basic for Applications (VBA) and Microsoft Access, Excel, and Word.  Requires computer-laboratory work in addition to regularly scheduled hours.  Students must take this course for a grade rather than pass/no pass.

Textbook

Visual Basic for Applications, by Diane Zak, Thomson Course Technology, 2006, ISBN 1-423-93443-1.

Online Materials

Class home page: http://www.cs.uoregon.edu/classes/07S/cit281

Topics

  • Creating, using, and managing databases including input forms, query options, and printed reports using non-procedural approaches.
  • Writing and using visual basic for applications (VBA) code to develop and enhance MS Office applictions.

Tools

  • MS Office Professional running under MS Windows.
  • These are installed on the lab machines.
  • Students may use their own computers if they have the software.
  • You will need the student data files since they are referenced in some of the assignments.  The self-extracting zip files may be downloaded from the publisher’s Web site:  Student data files

Lab Rooms

  • Students are registered for one lab section per week.  These meet in 026B Klamath.
  • Students may use the Klamath or McKenzie labs to do their assignments.

Grading Policy

Grading will be based on assignments, a midterm exam, and a final exam.  The final grade will be computed using the following weighting scheme.  Plus and minus grades will be used.

Assignments:

60%

Midterm:

20%

Final:

20%

To continue on in the CIT minor program, students must complete the course with a B- or better.

The assignments are designed to help the student learn the core material of the course as presented in the lectures and text.  Each student must turn in their own solutions. 

No late assignments will be accepted.  Turn in partial work if you are not finished.  Exceptions include illness or major family problems, in which case contact the instructor as soon as possible.

The midterm will cover the first part of the course, and the final will cover the last part of the course. 

No makeup exams will be given unless arrangements are made with the instructor in advance.

Assignment Drop Boxes

Written assignments and printouts should be turned into the instructor in class or in the CIT281 drop box in Deschutes near the CIS main office.

Electronic homework submissions should be uploaded to the DropAssignmentsHere folder on the Andromeda2 server (see below).  

Andromeda2 Server

The Andromeda2 file server is available for student use.  It may be accessed from the PCs in the lab rooms or remotely using a Web browser.  The server is located at: http://andromeda2.uoregon.edu/   The instructor will provide you with the appropriate login name and password for Andromeda2. 

Electronic homework submissions should be uploaded to the DropAssignmentsHere folder under CIT281 on the Courses volume.  Names for uploaded files should begin with your last name then your first initial followed by the assignment number then the rest of the filename, for example, Bricherg_1_Payments.mdb.  Once a file is uploaded, you may not delete or change it. 

You have read only access to the Resources folder on Andromeda2.  The student data files in self-extracting zip format are located here (as well as on the publisher’s Web site, see above).  The instructor may provide other files here for you to use.

Collaboration & Self Reliance

For this course, students are encouraged to collaborate in order to effectively learn the material.  However, each student should do their own work on assignments.  It is ok to discuss course material with other students, but the hands-on work required in the assignments is critical for student learning.  Therefore, each assignment should be done by the student him/herself.  You are responsible for knowing the university’s policy on academic dishonesty.