syllabus

Walter’s Teaching
Pages

Syllabus – Programming Concepts – Databases

Homepage ] Office Hours ] Class Listings ] Lab Schedule ] Student Login ] Some interesting links ]



 

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:

As
needed for class projects.

 

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:

  1. Class Participation
    cannot be made up.

  2. Assignments (test,
    projects, homework, etc.) will not be accepted after three weeks
    from the due date regardless of reason.

  3. Some assignments, at
    instructor’s discretion, may not be allowed to be made up at all
    regardless of the absence being excused or unexcused.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

  8. 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”).

  9. 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.


 


Copyright ©2001-2002, Walter Wimberly – Instructor and all
’round Cool Guy – IADT