INSTRUCTOR – MICHAEL DAVIS

Prerequisites – None (Advisory: CIS 300, CIS 302, or CIS 310) Acceptable for Credit: CSU

Units – 1

Schedule – Online Course
Section 22960/22962 August 22nd to October 16th, 2009
Section 22964/22966 October 16th, 2009 to December 11th, 2009
 

Note:  It is the students responsibility to drop from this course.  Failure to process a drop with the Admissions office can result in a grade of F for the course.  Incompletes cannot be given for online courses.

Text – New Perspectives on Microsoft Office Access 2007 Comprehensive
Adamski and Finnegan, (ISBN 978-1-4239-0589-9), Course Technology

Materials – Microsoft Access 2007 (previous versions of the program will not work for this class)
                    This program is available in the school's computer lab
                    Any storage device capable of storing 256 MB or more of data files

Catalog Description – This course introduces database management systems. Using Windows application programs, students will design and implement practical database applications. Topics include database and reports design, data views and queries, and data maintenance.

Course Objectives – At the end of this course, students will be able to:

• Develop tables for data by defining their structure, data types and formats.

• Design and test forms using graphical tools or controls to facilitate data input.

• Define queries which result in data extraction from single tables to produce desired results.

• Design and implement reports which display extracted data in an accurate, reliable and readable format.

• Describe the importance of database maintenance regarding timeliness, reliability, accuracy, credibility, repair and backup.

Course Structure – this course is a self paced course requiring reading assignments and completion of hands on exercises to be completed utilizing a personal computer.  This course also includes a final exam (content to be determined).  It is the responsibility of the student to be aware of any written or oral instructions that will cause the class to deviate from the content or objectives defined in the class syllabus.

Homework Assignments - We will be covering Chapters 1 through 4.  The homework assignments for this class are the Case Problems that are found at the end of each chapter of the book (they start right after the Review section at the end of each chapter).  There are 4 problems for each chapter.  Follow the link below for a detailed list of the assignments.

CISA 320 Assignment List

Homework Preparation - There may / will be several printed pages for each homework assignment.  When you turn in each assignment:

• each page must be clearly marked with your name, the chapter number and the step number of the exercise

• pages must be organized and submitted in the order (step order) in which they are completed.

• I do not require that you print in color.

 Failure to follow this format will result in the assignment being returned without a grade

Homework Submission - These assignments can be mailed to me at the school address. They can also be dropped off in the homework bin at the entrance to the library.  You can paste you answers to a Word or Excel document and email them to me.  You can convert them to a pdf file and email them to me.  I will not however, accept the database file, either on a disk or by email.  You must provide me with the prints that are requested in the assignment.

Grading Composition and Scale

Points                      Grade

225 – 250                    A

200 – 224                    B

175 – 199                    C

150 – 174                    D

149 or less                  F

Student Data files - The data files that are needed for this course can be obtained a number of ways.  Log onto a computer in the lab.  Open Windows Explorer and go to the T drive and find the folder named Davis.  There is a folder under Davis called CISA 320 that will contain the data files.  I will also make these files available as a downloadable zip file.

Print Screen - At several points, you will asked to take a screen print.  Once you have the screen positioned the way you want it, click on the Print Screen button on your keyboard (usually on the right end of the function key row).  This will save a copy of the screen to the Windows clipboard.  Open a program that will accept images (such as MS Word or MS Excel).  From the program menu select Edit - Paste or CTRL-V from the keyboard to paste the image in.  Print this out and turn it in as directed.

Blackboard - Blackboard will not be used for this course

Instructor Schedule - There will be someone available to assist you in the lab at all times.
                                    Click here to see my schedule.

Return to Main