Relational Databases Applications
CT 273, 3 Credit Hours
New for Fall 2007

Course Name:

Relational Databases Apps.

Instructor:

Georgia Lynn

Course Number:

CT 273

Office:

A129

Academic Year:

2007/2008

Phone:

870-338-6474
X 1129
   

Email:

glynn@pccua.edu
   

Office Hours:

8 a.m. – 3 p.m. except when in class (see office door)

Class Time & Place:

9:30 – 10:50 a.m.
Room A110
   

Prerequisites:

CT 114 or departmental approval    

Required Labs:

Rooms A110 & A107 are used for assignments not completed in class. Please note that Deep Freeze software is in effect in our labs, which means that all computers in those labs will be reset upon shut down each day.

Note:

Home computers with Access 2007 may be used to do homework.

A110
Designated "Business Student Success Center"

Credit Hours:

3    

Clock Hours:

3    

Revision Date:

8/12/07    

 

COURSE DESCRIPTION:
This course teaches the necessary concepts and tasks to create and manipulate database tables, queries, reports, forms, PivotTables, PivotCharts, and Switchboards using Macros.

EXPECTED LEARNING OUTCOME
Use and maintain a database to manage information for personal, business, and the Internet
Develop a critical thinking approach in applying theory to application

INSTRUCTIONAL GOALS & OBJECTIVES:

Goals:
Demonstrate the ability to use computer technology.

Students will analyze, interpret, and evaluate data necessary to solve problems and support business decisions.

Course Objectives:

By the end of the course, the student will be able to:
1. Create a database using Design and Datasheet views, add records to a table in a database, save, close, open, and print a database and a table, use a form to view data, create a report.
2. Query a database using the Select Query window, enter criteria and compound criteria to query a database, sort data in a query, join tables, use calculated fields in a query
3. Maintain a database using the design and update features of Access by adding, changing, filtering, deleting records, and searching.  Also, change the structure of a table by changing, adding, deleting field properties of a table.  Create Validation Rules by specifying a required field, a range, a default value, a collection of Legal Values.  Specify Referential Integrity, Use subdatasheets, order records, create and use an Index, calculate statistics.
Integration Feature: Share Data Among Applications
4. Create and use custom reports and forms, and learn how to use Combo Boxes.
5. Enhance Forms with OLE Fields, Hyperlinks, and Subforms.
6. Create Switchboards, PivotTables, and PivotCharts.

PCCUA CORE COMPETENCIES ADDRESSED IN THIS COURSE:

Technology Utilization
Critical Thinking

TEXT & OTHER MATERIALS:
New for Fall 2007

Microsoft Access 2007, Complete Concepts & Techniques
, Shelly Cashman Pratt, 6 Projects
Turning Point Technology (Clickers)

Pocket Folder
Flash Drive (256 MB)

Publisher:
Course Technology

New for Fall 2007
GRADING POLICY:

Grades are based on the following criteria:

Learn It!

Clicker Quizzes

10%

Project Assignments

20%

Expand It!

Extend Your Knowledge, Make It Right Assignments

20%

Review It!

Cases & Places Assignment

20%

Test It!

Objective & Hands-On Exams

30%

 

GRADING SCALE:

 

90 - 100

A

 

 

 

 

80 - 89

B

 

 

 

 

70 - 79

C

 

 

 

 

60 - 69

D

 

 

 

 

Below 60

F

 

 

 


NEW “EARLY ALERT” & ATTENDANCE POLICY:

A new policy called “Early Alert” will be implemented this Fall. It is described below.  Please note that regular class attendance and punctuality are expected for success in this course. The instructor will call roll at the beginning of class and record those absent. 

First Absence:
Upon return to class, student will be given a blue card identifying the class missed, with any missed assignments attached. Discussion with student may follow.

Second Absence:
Instructor will use the college's referral system to generate a notice of the student's absence to the advisor and the student through student e-mail.

Third Absence:
A notice is sent to the advisor through the college’s referral system and the student via email. The advisor will refer the student to the Student Success Coordinator who intervenes at this point.  The student is considered “at risk” of losing college credit for this course.

Fourth Absence:
Student may be considered “excessively” absent and could be dropped from the class by the instructor.  An exception may be made by the instructor, after due consideration, upon the initiation of the STUDENT with the instructor. Factors considered are:
(1) student initiative and dependability with course work
(2) exceptional, sudden personal circumstances of the student
(3) transportation problems.
NOTE: No exceptions will be made for doctor’s appointments for self or children nor for court dates

 

EXCEPTION!!

Classes meeting once a week, such as extended day or evening classes, will follow the same guidelines as above, except that upon the first absence, the student will be referred to the Student Success Coordinator and is considered "at risk".  Upon the second absence, the student may be considered “excessively” absent and dropped from the course with possible exceptions using the guidelines above.

When you know you will miss class ahead of time, let the instructor know and make arrangements to make up any missed work. Assignments missed must be made up on your own time. The instructor's Web Site for this course will list all materials covered and the assignments given.  It is the student's responsibility to initiate and complete missed assignments.


PARTICIPATION:
An essential component of any computer class is participation. Students are expected to take an active part in each class by preparing for each class by reading the text and being prepared for quizzes, actively listening, working along with instructor when asked, completing all text assignments, taking advantage of the training, review, etc offered in SAM.


COURSE EVALUATION & ASSESSMENT:
LEARN IT!
Component—project lab assignments, SAM Quizzes and/or other technological tools.
EXTEND IT! Component—case assignments and/or other critical thinking activities that challenge the student to think
REVIEW IT! Component—SAM and/or other technological tools
TEST IT! Component—SAM, other technological tools, and/or hands-on exams.

NOTE!! Check your student email every day!!!  Student email accounts will be widely used for informational purposes, for turning in assignments as instructed, for communicating with instructor, etc.

MISSED ASSIGNMENTS OR EXAMS: The instructor's Web Site (shown above) for this course will list all materials covered, the assignments given, along with due dates, and exam dates. 
When you know you will miss class ahead of time, let the instructor know and make arrangements to make up any missed work or exam. Assignments missed must be made up on your own time, not in class.
It is the student's responsibility to initiate and complete missed assignments by the next class meeting. Assignments will still be considered late if not turned in on the due date. Exams missed must be made up by seeing the instructor and making arrangements. The make-up exam will be more difficult than the exam taken in class.
LATE ASSIGNMENTS:
Assignments turned in late (not turned in by the end of the day of the due date) will suffer an automatic 10-point deduction per day late taken from the grade. Five days late will be an automatic 50-point deduction, which means a failing score before it is even graded.

STUDENT RESPONSIBILITIES:
If a student is unable to adhere to the attendance policy, or undue circumstances prevent the completion of the course, it is the student’s responsibility to withdraw from this class and receive a  W. Other student responsibilities are addressed in the section above concerning missed assignments or exams & late assignments.

CELL PHONES:
Cell phones have become a problem and therefore must be turned off in class.  The exception to this rule will be that the student may set the cell phone to vibrate only and must leave the class room to answer the phone if it is perceived to be an emergency.

Academic Honesty Policy:
Students are expected to uphold the school’s standard of conduct relating to academic honesty.  Students assume full responsibility for the content and integrity of the academic work they submit.  The guiding principle of academic integrity shall be that a student’s submitted work, examinations, reports, and projects must be that of the student’s own work.  Students shall be guilty of violating the honor code if they:

1.      Represents the work of others as his own.
2.
      Uses or obtains unauthorized assistance in any academic work.
3.
      Gives unauthorized assistance to other students.
4.
      Modifies, without instructor approval, an examination, paper, record, or report for the purpose of obtaining additional credit.
5.
      Misrepresents the content of submitted work.

Administrative Procedure Number: 404.05
Cheating in any form (including using unauthorized materials, information, or study aids in any academic exercise; plagiarism; falsification of records; unauthorized possession of examinations; any and all other actions that may improperly affect the evaluation of a student's academic performance or achievement; and assisting others in any such act) is forbidden. An instructor who has proof that a student is guilty of cheating may take appropriate action up to and including assigning the student a grade of "F" for the course and suspending the student from class. A description of the incident and the action taken will be reported through the dean to the Vice Chancellor for Instruction and placed in the student's file in the Office of Admissions and Records.
  The student may appeal either the finding of cheating or the penalty, or both, as described in Administrative Procedure No. 404.06, Academic Appeal Procedure.

Cheating in this class:
Cheating will not be tolerated.  If you are cheating on one occasion, you will receive an “F” for the whole project’s work (not limited to that one assignment.)  If found cheating on a second occasion, you will be asked to drop the class.  If the cheating occurs after the drop date, or if you choose not to drop, you will receive an “F” for this class.  All work must be on your disk or in your folder unless the instructor directs you to destroy them.
 

CAMPUS SUPPORT POLICIES:
PCCUA provides student support services that assist students in achieving their educational objective.  Those services include advising, financial aid, counseling and guidance, and safety and security.

ADA POLICY:
Lynn Boone, the Vice Chancellor for Student Services serves as the ADA Compliance Officer. If you reside in Arkansas County you may contact Vice Chancellor Carolyn Turner (DeWitt) or Dr. Susan Luebke (Stuttgart). The process of student referral under the Americans with Disabilities Act can be found in the Student Handbook.
 

FERPA POLICY:
Phillips Community College of the University of Arkansas complies with the Family Educational Rights and Privacy Act (FERPA) of 1974. A student has the right to inspect and review all of his/her records that meet the definition of educational records. No third party has the right to review student records. Directory information can be provided unless the student request that it be withheld.

INSURANCE:
PCCUA does NOT provide insurance for its students. The college does encourage each student to secure his/her own insurance, and for that reason, the college has contacted United Healthcare Student Resources. Forms for this insurance are available in the Registrar’s office.

ACTS:
The Arkansas Course Transfer System (ACTS) contains information about the transferability of courses within Arkansas Public Colleges and Universities. Students are guaranteed the transfer of applicable credits and the equitable treatment in the application of credits for the admission and degree requirements. Course transferability is not guaranteed for courses listed in ACTS as “No Comparable Course.” Additionally, courses with a “D” frequently do not transfer and institutional policies may vary. ACTS may be accessed on the internet by going to the ADHE Website and selecting Course Transfer.  Here is the link: http://acts.adhe.edu/secure/institutiontransferinfo.aspx

The syllabus and the policies, guidelines, and dates included are subject to change at the instructor’s discretion.