|
ITEC 2245 Database Management
Jo Ann Brannen, Assistant
Professor
Home
COURSE DESCRIPTION
ITEC 2245 emphasizes the use of
database management systems software packages for program-related
database applications. Topics include: planning and designing a
database; database creation; data entry; database access, manipulation,
and updating; sort, index, and query functions; database program related
applications; and database management applications. Laboratory work
includes theoretical and technical application.
COURSE OBJECTIVES
Upon completion of the course, the student will:
· understand the process of using database management
software.
· understand how a database management system can be
utilized in the business world.
· demonstrate knowledge of the basic and advanced
capabilities of MS Access.
· effectively run queries, create reports, and advance
skills such as switchboards using Visual Basic programming.
Prerequisite:
3 hours. Prerequisite: CISM 2201 with
minimum grade of “C”.
**This course is required in Area F of the University System
of Georgia Core Curriculum. You should not expect it to transfer to a
School of Business in a senior college or university within the system
unless your grade is a “C” or better.
Teaching Methods:
1. Participation: Communication is important for On-line
classes: Students should plan to login to WebCT
two-three times a week. Communication is encouraged in WebCT on the
discussion board. Students
should login to WebCT and reply to weekly “attendance e-mails” (instructor will
explain).
2. Assignments: Tutorials will be assigned to reinforce material in the
text. Projects on SAM testing website will require an access code
included in the text book bundle from the bookstore.
3. Review:
Training will be given to help ensure students stay up with
assigned material. How to videos are included with your textbook for
better understanding. This is new feature provided by the
publisher.
4.
Exams: Three exams will be
given using SAM testing software. The exams will be online. (training
for each Tutorial/Chapter)
5. Internet: All material will be distributed on the
Internet. Instructional material and student assignments
will be posted on WebCT.
Text/Materials:
Text: New Book! Adamski/Finnegan,New Perspectives on Microsoft Access 2010 - Comprehensive , Course
Technology, 2011.
SAM 2010 Access code bundled with the text from the ABAC
Book Store is the best price.
Software: Microsoft Windows 7,
Microsoft Access 2010, and Internet Explorer 8 will be used.
Instructor will provide information on how to use these packages.
Information on how student may
purchase MS Office 2010 on the web at
http://www.abac.edu/students.
Students may use the ABAC Library computers to complete the required
work. It is the student's responsibility to maintain &
troubleshoot personal computers.
Academic
Dishonesty:
Plagiarism and cheating are serious
offenses and may be punished by failure on exam, paper or project;
failure in course; and or expulsion from the college. For more
information
refer to the "Academic
Dishonesty" policy in the ABAC Catalog.
Need for
Assistance:
If you have any
condition, such as a physical or learning disability, which will make it
difficult for you to carry out the work as outlined here, or which will
require academic accommodations, please notify the instructor as
soon as possible or Dr. Maggie Martin; mmartin@abac.edu .
COLLEGE POLICY ON CLASS ATTENDANCE
Class
attendance: No on-line student
shall go more than two weeks without communication between student and
instructor. Weekly communication is required using WebCT/Vista
e-mail . A reduction in letter grade will
apply.
|
Spring Semester 2012
Course outline
|
|
Topic
|
Page
|
|
Login to WEBCT, Read Syllabus, SAM Setup
(Instructions in WebCT)
|
Login webct, REply to Instructor E-Mail, View
Calendar in webct.
|
|
Review File Management (not graded)
|
FM 1 Read WEEK 1
|
|
Review: MS Office 2010 (not graded)
|
OFF 1 Review Week 1
|
|
Tutorial
1 (see webct Calendar)
|
AC1
SAM Project |
|
Tutorial
2 |
AC 45 SAM Project
|
|
Tutorial 3
|
AC 99
SAM Project
|
|
Tutorial 4
|
AC 153
SAM Project
|
|
Exam #1 Tut 1-4
(test on-line,
See WebCT for details)
|
|
|
Tutorial 5
|
AC 201 SAM Project
|
|
Tutorial 6
|
AC 263
SAM Project
|
|
Tutorial 7
|
AC 333
SAM Project
|
|
Tutorial 8
Exam #2 Tut 5-8
(test on-line,
See WebCT for details)
|
AC
389
SAM Project
|
|
Tutorial 9
|
AC 441
SAM Project
|
|
Tutorial 10
|
AC 489
SAM Project
|
|
Tutorial 11
|
AC 559
SAM Project
|
|
Tutorial 12
|
AC 605
SAM Project
|
|
Final Exam #3 (First day of
Finals, April 30th, on-line,
See WebCT for details)
|
|
|
|
|
|
Grading
Letter grades will be determined using
a standard point evaluation as outlined below.
Academic integrity is the
pursuit of scholarly activity free from fraud and deception and is
an educational objective of this institution. Academic dishonesty
includes, but is not limited to: cheating, plagiarizing, fabricating
of information or citations, facilitating acts of academic
dishonesty by others, having unauthorized possession of
examinations, submitting work of another person or work previously
used without informing the instructor, or tampering with the
academic work of other students. See student
handbook. |
|
Tasks |
Points |
Points Earned |
Grade |
|
Exams 1, 2 & 3 |
300 |
900-1000 |
A |
|
Training (12) 8.33 pts each |
100 |
800-899 |
B |
|
SAM Projects (12) 50 pts each |
600 |
700-799 |
C |
|
Total Points |
1000 |
600-699 |
D |
|
|
|
599 & below |
F |
|
Spring Semester 2012
Instructor Schedule |
|
Camp
|
CRN (V)
|
Course
|
Hrs
|
Course Title
|
Day(s)
|
Time
|
Location
|
|
TIF
|
30309 (9)
|
CISM 2201
|
3
|
Fund
of Computer Applications
|
M
|
|
W
|
|
F
|
|
1000
am
|
1050
am
|
Conger
|
0221
|
|
TIF
|
30317 (13)
|
CISM 2201
|
3
|
Fund
of Computer Applications
|
|
T
|
|
R
|
|
|
1100
am
|
1215
pm
|
Conger
|
0221
|
|
TIF
|
30322 (17)
|
CISM 2201
|
3
|
Fund
of Computer Applications
|
|
T
|
|
R
|
|
|
1230
pm
|
145
pm
|
Conger
|
0221
|
|
ONL
|
30327 (20)
|
CISM 2201
|
3
|
Fund
of Computer Appl
(Online)
|
|
|
|
|
|
|
|
|
|
|
|
ONL
|
30380 (0)
|
ITEC 2245
|
3
|
Micro Database Management
(Online)
|
|
|
|
|
|
|
|
|
|
|
|
Calendar Spring Semester 2012 |
|
First day of classes January 9
End Drop/Add period January 11, 4:30 pm
MLK Holiday January 16
Mid-term withdrawal deadline w/o academic penalty February
29, 4:30 pm
Spring Break March 12, 13, 14, 15, 16
Last day of classes April 27
Final exams April 30, May 1,2,3
Graduation May 4, 6:00 pm
Grades due May 4, Noon
| |
|
