|
CIS111B-HYBRID / DATABASE / ACCESS
2010 SPRING 2012
|
||
|
Class begins:
Jan.
30, 2011 |
Class ends: May 18, 2011 |
Last Day to Drop:
Apr.
16, 2011 |
|
Instructor Information: |
|
|
|
|
|
Name: Alan
McBride |
Office: N/A |
|
E-mail:
amcbride@frederick.edu |
Phone Number: 301-846-2505 (Department) |
|
Office Hours: N/A |
Campus Mail Box #: TBA |
|
Course Information: |
|
|
|
|
|
Credits: 3 |
|
|
On-campus Meetings: 15 |
On-campus Exams: 2 |
|
Prerequisites: CIS101 or
CIS116D |
Co-requisites: None |
|
Meeting Days: Monday |
Meeting times: 7:45-9PM |
|
Course Description: |
|
Covers
the basic and advanced features of a commercial database software
package. Students plan, define, and
use a database; perform queries, produce reports, and forms; work with
multiples files; and learn the basic concepts of database programming. |
|
Core Learning Outcomes: |
|
1.
Identify components of the
software window |
|
2.
Create and print custom
forms and reports |
|
3.
Create, modify, and print a
table |
|
4.
Define relationships between
tables |
|
5.
Sort and filter data in a
query |
|
6.
Perform calculations and use
logical operators in a query |
|
7.
Embed and link objects in a
report |
|
8.
Export data to other
programs create hypertext documents from Access objects |
|
9.
Create and Use Query Wizards
and Action Queries |
|
10. Create and run macros |
|
11. Create custom toolbars and menus |
|
12. Create, compile, and test an event procedure using
Visual Basic |
How is this course organized:
|
|
|
|
This is considered a hybrid
course. Students will attend class on
campus once a week where they will participate in an interactive
lecture/demonstration. Attendance is a
required component of the course. This
is not a self-paced or independent study course. It is also not a totally online class. All assignments, weekly quizzes and
additional participation will continue through the online portion of the
class |
|
Instructional
Methods: |
|
|
|
Lecture and hands-on
demonstration and software online activities. |
|
Text(s) for Course: |
|
|
|
Adamski & Finnegan. (2011). Microsoft Access 2010. Course
Technology. |
|
Evaluation Methods: |
Final Grade Scale |
|
|
|
|
40% of grade = Assignments 20% of grade = Quizzes 40% of grade = Exams |
A = 90% - Above** B = 80% - 89% C = 70% - 79% D = 60% - 69% F = Below 59% |
|
If the graded performance for online assignments differs significantly
from the grade average for proctored assignments, the instructor reserves the
right to administer additional tests. |
|
|
**NOTE: It will be necessary to hand in every assignment/quiz/exam to
receive an “A” grade in this course. |
|
|
Participation Policy: |
|
|
|
Participation is required
for each weekly on-campus class. There
will be a graded activity during each on campus session. If you are absent from class, assignments
are still required to be submitted by the due date. Students are expected to come to class on
time and remain in class during the scheduled time frame. Late arrivals and
early dismissals disrupt the class, which already only meets for a short
timeframe. Students are required to use
the discussion board to post questions and tips and provide responses to
other students and instructor questions.
Students who encounter problems with their assignments or text are
encouraged to post their question on the discussion board first. Classmates are then requested to try and
offer solutions to the question. Any
extra credit will come from the student’s participation in the discussion
board |
|
Privacy and Communication in this course: |
|
|
|
Email is an instructional
tool essential to student-instructor and student-student communication. In
the Blackboard environment by default, your email address is available to all
students in this course. However,
students are permitted to use email addresses of other students in this
course only for the purpose and the duration of this course. Students who are
concerned about the privacy of their personal email address are reminded of
commercially available products that allow them to create unique email
addresses specifically for the purpose and duration of this course. The instructor can be
expected to respond to regular student email inquiries (grades, posted
assignments, and tests excluded) within the time frame of 48 hours. |
|
Academic Honesty: |
|
|
|
Work in
this course is subject to the provisions of the FCC Code of Academic Honesty.
Plagiarism in any form will not be tolerated. As a student, it is your job to
practice academic honesty at ALL times.
Make sure that all sources, particularly Internet sources, get proper
credit for quotations, paraphrases, and ideas. |
|
Software Piracy: |
|
|
|
Software that is copyrighted is intended for use in its original
form. Duplicate copies can be produced
only if written the manufacturer grants permission. The |
|
Progress Report: |
|
|
|
Grades will be posted in the
grade book section of the blackboard site weekly. Students can monitor their progress/grades
throughout the semester via the Blackboard grade book. At the end of the sixth
week, students will be notified by the instructor if they have a grade lower
than a C. You will have an opportunity
to evaluate your progress in this course and decide if you need to make any
adjustments (additional study, tutoring, conference with instructor) to
assure your success in this course. |
|
Notes: |
|
|
|
1.
Computer
Requirements: a. Students must have an email address AND students
must change their email address in Blackboard if the email address changes
during the semester b.
Students
should have access to Access 2010 (at home/work or plan to use the FCC
computer lab). Assignments can be
completed using an earlier version of Access (2003, 2007); however, there are
differences and students should be prepared to learn on their own how to
complete their assignments using the different version as the textbook and classroom
instruction focuses only on Access 2010. Not completing all elements of an
assignment because you are using an earlier version of Access is not
acceptable. 2. Data files: Students will
need a flash drive OR three blank diskettes.
Please bring the flash drive or diskettes to the each class. Data files will be downloaded to your disks
each week to correspond with the assigned text tutorial. We will be using the data files to
demonstrate and practice the lesson during each class. This same disk will contain the files
needed for your homework assignments. **If you are absent from class or for
some reason your disk is damaged, it is your responsibility to download the
data files from the computer lab or the textbook website. a. If your home computer does not have a
disk drive, you are responsible for downloading the files directly from the
internet textbook site to your home computer hard drive. You will then need
to complete the assignments using folders/files on your hard drive or choose
to save to a memory stick or CD-ROM. The college does not have a CD-ROM
burner on the classroom computers; therefore you cannot save the data files
to a CD-ROM in class. You can bring a
memory stick to save files for your home computer. ****You are still REQUIRED to bring the
disks with you to class to participate in the classroom lecture exercises! b. To download data files to your home/work
computer’s hard drive, go to the textbook website: www.course.com Note: Some students like to have a second copy of
the data files from class or do not have a disk drive on their home computer
to access the classroom files. · Choose
Student Downloads and enter the ISBN on the back of your text · Follow instructions on the inside back cover of
your text or follow the detailed instructions on the blackboard site. 3. Study Guides: “Quick Check”
Questions in the text are not assigned; however, you are encouraged to use
the questions as a study guide/practice for the theory quizzes. 4. Due Dates: All graded work must be
submitted at the beginning of each class.
It is the student’s responsibility to gather the assignments and due
dates from the blackboard site and adhere to the schedule. Typically,
late assignments will NOT be accepted
unless accompanied with a signed note.
Tutorial assignments will NOT be accepted after the exam in which that
tutorial has been completed. ABSOLTELY
NO ASSIGNMENTS WILL BE ACCEPTED AFTER MAY 18, 2012! Computer problems or
failure to connect to the internet to access blackboard/email will not excuse
the student from completing the course requirements by the due dates. The computer lab is available during posted
hours. 5. Assignments: All
assignments will be saved as directed in the book with one modification. Please include your last name as the first
part of the file name, e.g. LastName_NameOfAssignment.mdb 6. Quizzes: Online theory quizzes must be
taken each week BEFORE the
beginning of the next class. Quizzes
are only available on the blackboard site during the assigned timeframe. Quizzes will expire and will no longer be
accessible after the due date. 7.
Please notify the instructor immediately of any
change in e-mail address, phone number(s), residence address, or any other
means of contact. You must update your
email address in Blackboard if your email address changes during the semester 8. If you have any questions or concerns, please
notify the instructor by e-mail. |
|
Student
Services |
|
|
|
A variety of
services are available to assist students in succeeding at FCC. Students can
learn more about these services by visiting the Student Services web page: http://www.frederick.edu/student_services/index.aspx. Students with
disabilities who are in need of accommodations or who have questions related
to disabilities services should contact the Services for Students with
Disabilities (SSD) office at 301-846-2408. Students can learn more about
these services by visiting the Services for Students with Disabilities web
page: http://www.frederick.edu/student_services/disability.aspx. |
Topical Outline
|
||
Date
|
Content |
Assessment |
|
Week 1 1/30/2011 |
Tutorial 1: Creating a Database Creating a Database to Contain Customer, Contact,
and Invoice Data |
Tutorial 1 Assignment Tutorial 1 Quiz |
|
Week 2 2/6/2011 |
Tutorial 2: Building a Database and Defining Table Relationships Creating the Invoice and
Customer Tables |
Tutorial 2 Assignment Tutorial 2 Quiz |
|
Week 3 2/13/2011 |
Tutorial 3: Maintaining and Querying a Database Updating and Retrieving Information About
Customers, Contracts, and Invoices |
Tutorial 3 Assignment Tutorial 3 Quiz |
|
Week 4 2/20/2011 |
Tutorial 4: Creating Forms and Reports Using Forms and Reports to Display Customer and
Contract Data |
Tutorial 4 Assignment Tutorial 4 Quiz |
|
Week 5 2/27/2011 |
Tutorial 5: Creating Advanced Queries and Enhancing Table Design Making the Panorama Database
Easier to Use |
Tutorial 5 Assignment Tutorial 5 Quiz |
|
Week 6 3/5/2011 |
Tutorial 6: Using Form Tools and Creating Custom Forms Creating Forms for |
Tutorial 6 Assignment Tutorial 6 Quiz |
|
Week 7 3/12/2011 |
EXAM 1: Tutorials 1, 2, 3,
4, 5, 6 |
|
|
SPRING BREAK |
||
|
Week 8 3/26/2011 |
Tutorial 7: Creating Custom Reports Creating Custom Reports for |
Tutorial 7 Assignment Tutorial 7 Quiz |
|
Week 9 4/2/2011 |
Tutorial 8: Sharing, Integrating, and Analyzing Data Importing, Exporting, Linking, and Analyzing Data
in the Panorama Database |
Tutorial 8 Assignment Tutorial 8 Quiz |
|
Week 10 4/9/2011 |
Tutorial 9: Using Action Queries and Advanced Table Relations Enhancing User Interaction
with the |
Tutorial 9 Assignment Tutorial 9 Quiz |
|
4/16/11 |
Last Day to Withdraw |
|
|
Week 11 4/16/2011 |
Tutorial 10: Automating Tasks with Macros Creating a User Interface
for |
Tutorial 10 Assignment Tutorial 10 Quiz |
|
Week 12 4/23/2011 |
Tutorial 11: Using and Writing Visual Basic for Applications Code Creating VBA Code for the |
Tutorial 11 Assignment Tutorial 11 Quiz |
|
Week 13 4/30/2011 |
Tutorial 12: Managing and Securing a Database Administering the |
Tutorial 12 Assignment Tutorial 12 Quiz |
|
Week 14 5/7/2011 |
Appendix A: Relational Databases and Database
Design |
|
|
Week 15 5/14/2011 |
EXAM 2: Tutorials 7, 8, 9,
10, 11, 12
|
|
|
5/21+22 |
Make-up dates
|
|
|
NOTE: Your instructor reserves the right to make
changes to this outline as needed. |