Microsoft
Office Access 2010 Introductory
SYLLABUS (16 weeks)
Course Title: Mabs
67, 501 Credits: 3
Course Hours: 3
Instructor: Glenn Knapp Office: C106
Office Hours: T,W:
6:00-6:30 PM
Email: gknapp@ccsf.edu (650) 591-0999
Before
starting the course, you will need the following:
Ø Microsoft
Office Access 2010, by Adamski, Published by Course
Technology.
ISBN 9780538798471
Ø Storage device for saving files (any
of the following: multiple diskettes, CD-RW, flash drive, etc.)
This is a
hands-on course in which you will learn to use a computer to practice the most
commonly used Microsoft Access program, including the Windows operating system,
and the Internet Explorer for navigating the Internet.
Microsoft
Access is a database program that organizes large amounts of information in a
useful manner.
Ø Students should be present and
punctual for all classes.
Ø Regular class attendance will
maximize your computer skills for your personal and professional future.
Ø Be respectful of your instructor and
fellow classmates at all times.
Ø As a courtesy, please do not talk,
type, or print while the instructor is talking to the class or when a student
is asking a question which pertains to the class.
Ø Refrain from “surfing” the Web
during class, unless directed by your instructor.
Ø Turn off cell phones and pagers.
Ø Refrain from bringing food and drink
into the classroom.
Ø You are encouraged to work with
other students to solve problems. However, you must complete your own work.
Ø It is the students' responsibility
to make any arrangement necessary to obtain a personal tutor. The instructor
will not be the student's personal databse designer
to design and develop the student's personal/business database (project). The
student is required to learn the course concepts, and then create and develop
their own personal/business database. The student must design and develop their
projects independently, and use the online course information and the
instructor as guidelines. The instructor will not install software on the
student's personal computer at the students' home or business. The students are
responsible and accountable for their own personal property. No cell phones,
recorders, camcorders, or any other electrical device is allowed in the
classroom without the permission of the instructor. No food, guests, or
children are allowed without the permission of the instructor or the Business
Office.
Ø Missed
Classes: You are responsible for
the activities of each class period. If
you know of a conflict ahead of time, you are welcome to submit projects early.
There is no absolute right to a make up test unless
you have an acceptable excuse. If you do not take a test on the scheduled day
and have an excuse, contact me for a makeup quiz. Makeup quizzes are typically more rigorous
than the regularly-scheduled test (i.e. You may be
asked to complete two or three Independent Challenges instead of only one.)
Ø
Ø Academic Dishonesty: Plagiarism and cheating are serious
offenses and may be punished by failure on an exam,
paper or project; failure in the course; and/or expulsion from the
College. For more information refer to the "Academic Dishonesty"
policy in the College Catalog.
Ø
Ø Need for
Assistance: If you have any
condition, such as a physical or learning disability for which you need extra
assistance, please see me immediately.
If you have already met with Special Services, please provide me with
information regarding your special need as soon as possible so that appropriate
accommodations can be made.
Ø Disability Accommodations - Students with a learning
disability need to discuss their situation with the Disability Support Services
Department. Students need to request an
accommodation notification for the instructor.
Ø Cheating - It is expected that students will
conduct themselves with integrity. If you cheat or assist others in cheating,
you violate a trust.
Cheating
includes but is not limited to the following:
Ø copy files or lend your storage
device to another student
Ø copy answers on exams or glance at
nearby exams
Ø print work for someone else
Ø turn in assignments that have been
used in other classes
Ø purchase or sell assignments or exam
materials
If you cheat,
some or all of the following actions will be taken:
Ø You will receive a lower point score
up to and including a zero for that particular assignment or exam.
Ø A report of the incident may be
forwarded to the Dean of Student Services. The Dean may file the report in your
permanent record and/or take further disciplinary action.
You will be evaluated based on your
combined performance on homework assignments and exams.
The Assignment Sheet will enable
easy tracking of progress and grades.
Your ability to understand and follow the directions in the text thoroughly will be an essential component for successful completion of the projects/homework. (Test and quizzes will be announced).
The following grading scale will be
used: Projects (40%),15 quizzes and a final (60%),
will be given
|
Percentage
of Possible Points |
Grade |
|
90-100% |
A |
|
80-89% |
B |
|
70-79% |
C |
|
60-69% |
D |
|
Below 60% |
F |
Week
|
Lessons to Cover
|
|
1 |
Create
Datatbase--1 |
|
2 |
Table
relationships-- 2 |
|
3 |
Database
Queries-- 3 |
|
4 |
Forms/Reports--
4 |
|
5 |
Adv.
Queries/tables-- 5 |
|
6 |
Project
1 (20%) |
|
7 |
Form
Tools/Custom--6 |
|
8 |
Custom
Reports-- 7 |
|
9 |
Analyzing
Data-- 8 |
|
10 |
Action
Queries-- 9 |
|
11 |
Macros--
10 |
|
12 |
Project
2 (20%) |
|
13 |
Managing
a DB--12 |
|
14 |
Macro
Project |
|
15 |
Formulas
|
|
16 |
Macros |
|
|
Front-end/back-end
DB/ |
|
|
15 Quizzes/Final
(60%)/ 9 Class DB
reflective of text and lectures. |
Software Discounts: http://www.collegesoftware.org