CSCI 110-01

Microcomputer Database Application

Prerequisite: CSCI 101. Introduction to the design and use of a commercial microcomputer database software. Students use the microcomputer database package to create files and business reports, including file design and maintenance, information retrieval, report generation, and advanced concepts.

CREDIT HOURS:3
CONTACT HOURS:
LECTURE HOURS:2 LABORATORY HOURS:2

RELATIONSHIP TO ACADEMIC DEVELOPMENT PROGRAMS AND TRANSFERABILITY:

This course was designed to meet the specific needs of a Certificate or an Associate of Applied Science degree and not necessarily as a transfer course, particularly in relation to the Illinois Articulation Initiative. This course may transfer to various institutions in a variety of ways. Please see an academic advisor for an explanation concerning transfer options..

Fall Semester

Lori Cordis

Office: Room 204E, TowandaPlaza

Phone: (309) 268-8856

E-mail: OR (use this address as primary)

Website:

NOTICE OF CANCELLED CLASSES

Cancelled class sessions for all HCC classes will be listed under Cancelled Class Meetings in the A-Z Index and under Academic Information in the Current Students page on the HCC Website. Go to to learn what classes have been cancelled for that day and the upcoming week. Be sure to check the last column which might contain a message from the instructor.

Microsoft Office Access 2003, Joseph J. Adamski, Kathleen T. Finnegan, Course Technology

  1. Creating and Maintaining a Database
  2. Querying a Database
  3. Creating Forms and Reports
  4. Creating Advanced Queries
  5. Creating Custom Forms and Reports
  6. Integrating Access with the Web and other programs
  7. Using Action Queries
  8. Automating Tasks with Macros
  9. Using Visual Basic for Application code
  10. Managing and Securing a Database
  1. Define the terms, field, record, table, relational database, primary key, and foreign key
  2. Open an existing database and identify the components of the Access Database Windows
  3. Open and navigate tables
  4. Open, create, sort and navigate a new query
  5. Open, create and navigate Forms and Reports
  6. Learn how to manage a database by backing up, restoring, compacting, and converting a database
  7. Learn the guidelines for designing databases and setting field properties
  8. Create and maintain new databases
  9. Learn how to query a database for fast and efficient retrieval of data
  10. Learn how to create custom forms and reports
  11. Learning to integrate Access with the Web and other programs
  12. Automating tasks using macros
  13. Learning to use and write Visual Basic for Application code
  14. Managing and Securing a Database

Exams/ Assignments: Students will be evaluated by computer lab assignments, examinations, projects and on the basis of their participation in class discussions. % Points A 90% - 100% = 900 – 1000 points, B 80% - 89% = 800 – 899 points, C 70% - 79% = 700 – 799 points, D 60% -69% = 600 – 699 points, F below 60% = 599 or fewer points.

Approximately 12 assignments @ 40 points approx. 50% = 480 points

1 Hands On Exam (At Midterm, Covering Topics in Text) = 100 points

1 Team Project = 200

1 Individual Project = 100

Total points = Approx. 880

Participation and Attendance

Attendance is expected of all students to all sessions of the course at the expected time allocated on the course schedule.

Make-up of Tests

If you are absent on the date of an announced test, there will not be any make-up exams given. If there is a conflict with the announced test time, you must make arrangements with the instructor to take the test PRIOR to the announced test time. In the case of an emergency or extreme illness a make-up exam may be permitted, however, you MUST notify the instructor of your situation prior to the announced test time, if possible.

Deadlines

All assignments and labs will have a due date when it is assigned. Work is due at the Beginning of class on the day of the deadline. Assignments, labs, and homework turned in after the deadline will receive a score of 0. If you are absent on the day an assignment is due because of an emergency or extreme illness and cannot deliver it to the instructor before class starts that day and have notified the instructor of your situation prior to class time, you may be permitted to hand in the assignment but will receive a 50% late penalty.

Academic Integrity

Academic integrity is a fundamental principle of collegial life at HeartlandCommunity College and is essential to the credibility of the College’s educational programs. Moreover, because grading may be competitive, students who misrepresent their academic work violate the right of their fellow students. The College, therefore, views any act of academic dishonest as a serious offense requiring disciplinary measures, including course failure, suspension, and even expulsion from the College. In addition, an act of academic dishonesty may have unforeseen effects far beyond any officially imposed penalties.

Violations of academic integrity include, but are not limited to cheating, aiding or suborning cheating or other acts of academic dishonesty, plagiarism, misrepresentation of data, falsification of academic records or documents and unauthorized access to computerized academic or administrative records or systems. Definitions of these violations may be found in the college catalog.

Plagiarism

Plagiarism is the presenting of others’ ideas as if they were your own. When you write a paper, create a project, do a presentation or create anything original, it is assumed that all the work, except for that which is attributed to another author or creator, is your own. Plagiarism is considered a serious academic offense and may take the following forms:

1Copying word-for-word from another source and not giving that source credit.

2Paraphrasing the work of another and not giving that source credit.

3Adopting a particularly apt phrase as your own.

4Using an image or a copy of an image without crediting its source.

5Paraphrasing someone else’s line of thinking in the development of a topic as if it were your own.

6Receiving excessive help from a friend or elsewhere, or using another project as if it were your own.

Note that word-for-word copying is not the only form of plagiarism.

The penalties for plagiarism may be severe, ranging from failure on the particular piece of work, failure in the course or expulsion from school in extreme cases.

[Adapted from the Modern Language Association’s MLA Handbook for Writers of Research Papers. New York: MLA, 1995: 26]

Academic Support Services:

Heartland Library Information

The Library, located in the Students Commons Buildings at the Raab Road campus, provides Heartland students with a full range of resources including books, online journal databases, videos, newspapers, periodicals, reserves, and interlibrary loan. Librarians are available to assist in locating information.

For more information, please call the Library (309) 268-8200 or (309) 268-8292.

Tutoring Center

HeartlandCommunity College offers tutoring in various forms at no cost to

Heartland students at the Academic Support Center (ASC) in Normal and at the Pontiac

and Lincoln Centers. Tutors are available at convenient times throughout the week.

Study groups, group tutoring facilitated by a specially-trained tutor, are also available by

request. For more information about services available at each location, please call the

ASC in Normal (309) 268-8231; the PontiacCenter (815) 842-6777; the LincolnCenter

(217) 735-1731.

Testing Center

The TestingCenter provides a quiet environment for students to complete make-up exams, online exams, and exams for students with special accommodations. Students may be able to complete exams in the TestingCenter if arrangements are made with their instructor. For more information, contact the TestingCenter at (309) 268-8231.

Open Computing Lab

Open Lab Hours for the Towanda Plaza Campus: Room 111 M-Th: 7:30am – 12:00am, Friday: 8:00am – 10:00pm, Sat: 12:00pm- 6:00pm closed Sundays.

The Open Computing Lab provides free computing for HCC students at convenient times throughout the week. The computer lab is staffed by trained Lab Assistants and offers the use of approximately 70 computers, a scanner, a laser printer, and an electric typewrite Community College offers learning assistance in various forms at no cost to Heartland students at the Academic Support Center (ASC) in Normal and at the Pontiac and LincolnCenters. Tutors are available at convenient times throughout the week. Study groups, group tutoring facilitated by a specially-trained tutor, are also available by request. Help is also provided through instructional materials, study skills workshops, open computing, and the Library. For more information about services available at each location, please call the ASC in Normal at (309) 268-8235; the PontiacCenter (815) 842-6777; or the LincolnCenter (217) 735-1731.

Syllabus Disclaimer: This syllabus is subject to change. Any changes will be announced in class.