Administrative
Management Department Learning Objective - Business Technology Skills A
solid foundation in current software and use of the Internet are absolute
necessities in the modern office. A series of software courses in areas
such as word processing, spreadsheets, databases, and presentation
software with progressive degrees of difficulty are required to prepare
students to function effectively in the computer-oriented workplace. CATALOG
DESCRIPTION: ADM
141 Relational Database, 4 units Prerequisite:
ADM
120. A
comprehensive course in Microsoft Access, covering introductory through
post- advanced database concepts and skills.
This course covers all the skills required for successful mastery
of the Microsoft Office User Specialist Access Examination. COURSE
DESCRIPTION: This
course provides instruction in the use of a Microsoft Access in life like
business settings. Microsoft’s
Office Suite has become a near standard for business software.
This comprehensive course provides a complete set of the
application skills necessary for successful completion of the Microsoft
Office Specialist Certification. The
course does not guarantee that the student will successfully pass the
Microsoft Certification but the materials covered in the course cover all
concepts and skills addressed in the Specialist online examinations
developed by Microsoft. LEARNING
OBJECTIVES: Utilizing
Microsoft Access 2003,
the student will be able to:
PREREQUISITE: Completion
or test out of ADM120 with keyboarding skills of 25 wpm or greater. WRITING
ACROSS THE CURRICULUM: Students
will focus on the following writing skills and objectives:
HOURS
OF INSTRUCTION: Online
environment, asynchronous, students should expect to spend 8 to 12 hours
per week viewing lecture-demonstrations, skill set demonstration,
completing projects, in the labs, practice skill set building and online
tests. METHOD
OF INSTRUCTION: This
class is an online skills lab, and as such students, are working at a
weekly pace, self-teaching utilizing the required text, aided by
lecture-demonstrations, skill set demonstrations and online and email help
from the instructor. Instruction
is Composed of Two Major Areas Skill
Attainment - These are the individual operations necessary in order
for the application (Word, Excel, Access, PowerPoint, Publisher) to
respond appropriately to what you are asking it to do. Typically
this depends on you (the operator) recognizing the present state that the
application is in, and what steps are necessary for you to complete one or
more operations through keyboard and/or mouse movements which is your way
of communicating with the software (Word, Excel, Access, PowerPoint,
Publisher). Application
- This is the ability to bring the skill set (see above) into the real
world in order to help facilitate the calculation, presentation, and
communication of useful information. This part of the instruction is
designed to help you see (by example) how the business application
software is used in the real world. Your job is to spend time noting
the format and design of the individual application documents and what
they are attempting to accomplish and to convey to others who may have
access to them. This requires what is known in the psychological and
educational literature as higher order thinking skills, i.e. your ability
to take what you have practiced and experienced in one situation or
environment and extrapolate it to new situations and environments, like
your home, school, and place of employment. Course
Components Related to the Two Major Areas Skill
Attainment -
Text
Projects - Text projects identify the skill learning objectives
that will be covered within the project and each subsequent project builds
on the other to some degree but not to the degree that would require you
to complete all previous projects before attempting a later project.
The textbook moves the student from one small step to the next in a
sequence of steps to complete a successful operation. The text is
filled with numerous visual aids that closely represent what should be on
your monitor as you follow along with the instructional set. Often
the text will include side-bars and or additional comments that inform you
of alternative methods of completing an individual task, pay attention to
these as you may find these methods more to your liking. Moving
through each project takes patience, time and a full understanding of
where you are going and where you have been in order to fully appreciate
what the project is trying to convey to you the student. So take
time to look at the completed document presented at the beginning of each
project and understand that you will be creating that document during the
completion of the project, many times beginning from a blank document,
spreadsheet or database. Skill
Set Demonstrations - Skill set demonstrations are examples of the
individual items that make up the skill learning objectives for each
project. These skills are the skills that the sam2003
online environment assess and make up the complete set of all items that
you could be tested on during the project of study. The
demonstrations themselves are flash or windows media presentations of your
instructor completing the items individually and correctly. They are
presented individually (flash version) or as progressive downloads
(windows media) so that you can choose what skills you need to work on
without having to view them all. Skills like keyboarding and
software have traditionally been taught through the techniques known as drill
and practice, the skill set demonstrations in conjunction with the
practice tests are designed to be used in conjunction to give you drill
and practice experience within the learning objectives for each project. Practice
Tests - Practice tests are made available on the sam2003
testing site. You may take each practice test up to 5 times.
Practice tests include every skill that is presented during the project of
study and usually two or three items from a previously completed project.
Use your practice test to assess your learning after you complete the
project. Application
-
Text
Projects - Projects are presented as cases, cases are real world examples
of how the document might be used in a home or business environment.
Take special note of how documents are formatted (layout) and what
information they are designed to convey. In
The Lab Assignments - These assignments are shorter versions of the
project itself. They typically are cases based on alternative
businesses or alternative home uses that utilize the very same skill sets
developed during the project. These additional assignments help you
to gain additional perspective on how similar documents are used in
settings other than the one presented in the Text Project Lesson.
These assignments typically include less detailed instruction than the
project itself and your critical thinking and problem solving skills are
needed for the successful completion of these assignments. Lecture
Demonstrations - Lecture/Demonstrations are of two basic types; the first
being discussions of the completed documents, relating how the particular
document is utilized in business situations and the second type is an
actual demonstration by the instructor on how an In The Lab assignment
is to be completed. Often the instructor will verbalize the problem
solving process in order to help the student integrate just how the skill
sets presented in the project can be used to create the desired final
product with the software application under study. How
to be successful in this computer applications course Suggestions
For What To Do When
REQUIRED
TEXTBOOKS AND MATERIALS: Microsoft
Office Access 2003: Comprehensive Concepts and Techniques Shelly
Cashman Vermaat (ISBN:
1-4188-4363-6) SAM2003
Course Testing Software,
Course Technology, Thomson Learning. Students
may use their seat license obtained in ADM120 for this and all computer
business application courses here at Earphones
– needed to hear audio presentations.
If you have earphones that came with a CD player or MP3 player you
most likely will be able to use them.
If you plan on utilizing the computer workstations on campus, you
will need to plug them in to the audio out jack on the back of the
computer case (green jack). COURSE
CONTENT: The
class will be set up a lecture/lab basis.
Students will be required to work on the personal computers to
complete lab projects assigned each week.
WARNING: You
should expect to spend one to two hours outside of regular class time on
the computer for every hour spent in the classroom. BASIS
OF EVALUATION: Attendance:
On time completion of all assignments – No late turn ins Exercises:
725 Points (25 points
each – Projects and In The Labs) Quizzes
(sam2003 and or written):
500 Points (50 points each
week– sam2003 and/or written) Final:
300 Points Total
Points
1525 Points
ATTENDANCE
POLICY: Ten
points will be deducted from the attendance portion of the grade for any
days’ absence during a scheduled class meeting, or missing 1-1/2 hours
of any night class meeting. LATE
ASSIGNMENT POLICY:
Late assignments will not be graded until the current weeks
assignment has been completed, the instructor notified that the current
weeks work is in the student folder, the instructor has then given the
student permission to submit specific late assignments and the assignments
committed to by the student are in the student’s folder at the agreed
upon time. All late work will
be penalized. PLAGIARISM:
Plagiarism is not condoned or
excused. Term papers, research
reports and essays are expected to be the individual work of the student.
References and sources of information should be identified and
accurately documented within the body of any written work.
Violation of the honor code or plagiarism is cause for dismissal. STUDENT
SERVICES:
Reading, writing, researching, and math tutorial services are
available from the CLASS
SCHEDULE: Since
the students work at their own pace, this schedule is to be used as a
guideline for minimum standards. Students
are encouraged to work as accurately and rapidly as they can to complete
the course. Tests dates are
permanent unless changed by the instructor during the quarter.
Students
absent on test days are required to contact instructor on the assigned
testing day in order to be eligible for a makeup test.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||