Course Title:
|
Programming Concepts –
Databases
|
Course Number:
|
CNT 2741
|
Instructors
Name:
|
Walter Wimberly
|
Date:
|
Winter 2002
|
Credit/Clock
Hours:
|
4.0 ý
Credit Hours
|
Course Length:
|
11 weeks
|
Course
Schedule:
|
|
Unit of
Academic Measurement (select one):
|
ý
Quarter System
|
Prerequisites:
|
CNT 1011 – Into to
PC Hardware
|
Corequisites:
|
None
|
|
Textbooks and
Materials
|
(Check one)
|
Required
|
Optional
|
Textbook (s)
|
New
Perspectives – Microsoft Access 2000 Joseph J. Adamski, et. all
|
ý
|
|
Resources & Supplies
|
6
Floppy disk
2
blank CD-R Disk
1
Cd/floppy holder case
3
different color Highlighter
1
Notebook/folder
|
ý
ý
|
ý
ý
ý
|
Course
Description:
|
The basics of database programming are covered
in this course through the use of different Relational Database Management
Systems (RDBMS). Students
will be introduced to SQL and will create a number of databases for a
variety of applications.
|
Performance
Objectives:
|
Upon
completion of this course, the student should be able to:
|
ü
|
Create a database
|
ü
|
Plan how to write an database application
|
ü
|
Create customized queries and reports
|
Instructional
Methods:
|
This course will use
lecture, hands on labs, presentations, group discussion, textbook
reading, and case studies.
|
Grading:
|
Student
performance will be evaluated based upon the following criteria.
Class
Participation.. 15%
Quizzes
…………… 30%
Homework…………
25%
Major
Projects……. 30%
100
– 90 = A
89 – 80 = B
79 – 70 = C
69 – 60 = D
00 – 59 = F
|
Library
Assignments:
|
|
Course
Policies:
attendance:
|
Because much of the
course work will be assigned and completed in class at the computer,
your attendance is essential, and your participation grade will be based
on the percentage of time you have attended class and how effectively
you utilize class time when in attendance.
Call me for any reason whatsoever, but especially if you have a
problem you need to discuss please contact me at the school 407-857-2300
or by e-mail at wwimberly@iadt.edu. No concern is “too small to
call”. You are
responsible for finding out what you missed in class if you are absent.
|
make-up
work:
|
- Class Participation
cannot be made up.
- Assignments (test,
projects, homework, etc.) will not be accepted after three weeks
from the due date regardless of reason.
- Some assignments, at
instructor’s discretion, may not be allowed to be made up at all
regardless of the absence being excused or unexcused.
- An assignment is
considered late if the instructor does not receive it when the
instructor calls it for. The
time that the instructor calls for it is left up to the discretion
of the instructor. After this point the assignment is considered one
week late.
- Assignments are
considered two and three weeks late at their respective time when in
the subsequent weeks the instructor calls for any assignments and
they are not received.
- In the case where
that particular type of assignment is not issued on a per week
basis, then the assignment is late when any assignment is collected
for that class. If no
assignment is collected for that class then the assignment is an
extra week late after the instructor begins the class instruction
time.
- Assignments may be
turned in prior to the next class, but only after the assignment is
originally due, to the receptionist or the instructor to avoid
additional late penalty.
- If an absence is
excused and the assignment can be made up, the late penalty will be
10% per week, before normal grading occurs (also referred to as
“off the top”).
- If an absence is
unexcused and the assignment can be made up, the late penalty will
be 20% per week, before normal grading occurs (also referred to as
“off the top”).
|
Other:
|
Proper
use of computers: Computers
may only be used for relevant and proper class work during class time.
Improper usage includes, but is not limited to: Surfing the Web,
Checking E-Mail, Doing other Class Work (other than what is assigned)
during class. Offensive
material is improper at anytime. This includes but is not limited to: pornography,
racial/hate material, and material that includes and promotes violence.
Academic
Dishonesty: Academic dishonest
includes, but is not limited to: cheating, helping others cheat, copying
work, and plagiarism. Those
caught under the rules of Academic Dishonesty will be punished.
Minimum punishment guidelines are found in the Student Handbook.
For this class, first offence of any magnitude results in a negative
100% for the grade on which the assignment that was affected.
Second offence results in a meeting with the Dean for punishment
indicative of the Student Handbook, which can include dismissal from the
school.
Professional
Behavior: As students,
training to become professionals, you should attempt to “carry”
yourself as such. View each
person as a potential client/boss whom you would like to impress.
In as such, proper language should be used at all times, as
should proper respect to all individuals involved.
This includes arriving at class on time and to use the time
thoughtfully and wisely not only for yourself, but for those around you
as well.
|
Topical Outline
Topic
|
Description of Content
|
Approximate Percentage of Class
Time Allocated to Each Topic
|
Creating
and deleting databases
|
Creating
blank databases
Creating
databases with wizards
Deleting
a database
|
15%
|
Creating
and deleting tables
|
Creating
tables
Deleting
tables
|
20%
|
Selecting
Information
|
Selecting
all information
Selecting
specific information
Selecting
information across different tables
|
35%
|
Information
handling
|
Inserting new information
Deleting information
Updating
information
|
30%
|
TOTAL
|
100%
|
CLASS MEETING OUTLINE
for Windows 2000 Professional
Session:
|
Reading/Topics:
|
Quizzes:
|
1
|
Windows 98 – Tutorial 1
Windows 98 – Tutorial 2
Access – Tutorial 1 – Intro to Access
|
|
2
|
Access – Tutorial 2 – Maintaining
a Database
|
|
3
|
Access – Tutorial 3 – Querying a
Database
|
Quiz #1 – Tutorials 1,2
|
4
|
Access – Tutorial 3 – Querying a
Database
|
|
5
|
Access – Tutorial 4 – Creating
Forms and Reports
|
|
6
|
Access – Tutorial 4 – Creating
Forms and Reports
|
|
7
|
Access – Tutorial 5 – Creating
More Advanced Queries and Custom Forms
|
Quiz #2 – Tutorials 3, 4
|
8
|
Access – Tutorial 6 – Customizing
Reports…
|
|
9
|
Access – Tutorial 7 – Working
with HTML…
|
Quiz #3 – Tutorials 5,6
|
10
|
Access – Tutorial 8 – Using Query
Wizards…
Access – Tutorial 9 – Automating
Tasks with Macros…
|
|
11
|
Final Week
|
Final Quiz –
Tutorials 7-9
All work due
|
“Pop
Quizzes” which come without announcement may come at any time, and will not be
allowed to be made up.
The
instructor reserves the right to make changes to the syllabus at any time.
|