Advanced MS Office
RCSIS 121
Course Syllabus
Fall 2008
INSTRUCTOR:
Office:
Q9B (To the right of the Snack Shack)
Office Hours: 8-9:00 am M&W, 11-12 a.m. T&Th, Room B8, by appointment
Phone:
744-1150 x2965 Voice Message
E-mail Address:
jmartinklement@palomar.edu
Palomar ROP
Office: 744-1150 x2301
CLASS MEETING
DATES & TIMES:
|
74998 |
M W |
11:30 am- 2:00
pm |
08/25/08-12/17/2008 |
Martin-Klement |
Room B-8 |
LAB TECHNICIAN:
John Diaz
ADDITIONAL CLASSROOM CONSIDERATIONS:
Open
seating,
first come, first serve basis.
Most students do like to continue to sit in the same place after the first
weeks of class when student “drops” and “adds”
are complete, so we like to honor this.
However, if there is a change in seating, please remember they are
not assigned and seating is on a first come, first serve basis with priority
given to certain seating depending upon special student circumstances such
as vision or hearing.
Attendance
is just as important in college as it is in the workplace.
Students who come to class on a regular basis perform much better
than those who miss class regularly or come late to class.
Come
to class on time.
The
first week is dicey with parking and I would rather have you come to class
late, even if very late, the first week or two of class if parking is an
issue, rather than not come at all, but once we all know how to get here and
where to park, tardiness is not appreciated by instructor or fellow
students. If you are more than
5 minutes late to class, please wait until the mid-break to enter the
classroom.
Cell
phones
should
be set to “vibrate” only during classroom hours.
If a cell phone accidentally rings, please immediately step outside
the classroom to avoid interruptions to instruction.
You may visually check a vibrating cell phone during class but should
only step outside the classroom to answer that call during break, unless it
is an emergency.
Listen
and take notes
when teacher is talking/lecturing and/or demonstrating.
Be
prepared
to start class within five
minutes of class meeting time.
Textbook, notebook and pen and pencil should be with you each class
meeting.
Work
cooperatively
with fellow students and instructor.
Allow
teacher to take break also when break is announced.
Schedule to ask individual questions during office hours or 15 min
before class meeting.
Classroom will be opened 15 min. prior to class meeting time to
accommodate this student question need.
If instructor is unavailable during the time, we will meet at another
time.
E-mail
is the best way to communicate with me on a daily basis M-Friday.
Weekends, I do not check mail on a regular basis.
Academic Counseling
with me on an individual basis is always available.
Please take advantage of it!
I also want to know about circumstances that may be preventing you
from successfully completing your studies.
We’ll work on it together.
TEXTBOOK:
Microsoft Office 2007 Advanced Concepts and Techniques; Shelly, Cashman,
Vermaat, ITP. ISBN:
1-4188-4332-6. Visit Shelly
Cashman online at http:/www.course.com or
http://www.scseries.com
to see textbook review and choices of ISBN numbers.
Just be certain to order the correct title as listed above,
Advanced version.
(1) DVD (R/W) (optional)
(1) CD (R/W) (optional)
www.quickreg (through www.palomar.edu/rop website
Palomar College E=Services registration: www.palomar.edu Follow links for E-services; must have Student ID.
Username:
student\office2007
|
OPEN LAB HOURS FOR
ROOM B8:
RECOMMENDED SEQUENCE OF ROP
COMPUTER APPLICATIONS CLASSES:
1.
Windows, RCSIS 170
2.
Word (Keyboarding and basic word processing skills), RCSIS 127
3.
Computer Applications, Microsoft Office Beginning, RCSIS 120
4.
Computer Applications, Microsoft Office Advanced, RCSIS 121
5.
Introduction to the Internet (includes web page design with
HTML and Front Page), RCSIS 137
6.
Excel, RCSIS 175
7.
Access, RCSIS 180
8.
Microsoft Publisher Beginning, RCSIS 130
9.
Adobe Acrobat, RCSIS 97
10.
Technology-assisted Job Search 186
There
are two certifications, in addition to the ROP certificates that I encourage
students to pursue when involved with the Computer Applications program at
I.
Includes:
·
Windows,
RCSIS 170
·
Beginning
Microcomputer Applications, RCSIS 120
·
Advanced
Microcomputer Applications, RCSIS 121
·
Introduction to the Internet, RCSIS 137
·
Job
Search, RCSIS 186
Courses must be taken for
college credit as well as ROP certification.
Upon completion of these 5 courses, student must obtain a Proficiency
form from Admissions, complete and return to Admissions, and your
certificate will be mailed to your address on file.
Please see college catalog and the Palomar web site for these
deadlines.
II.
Microsoft Office User Specialist (MOS) certification
BASIC SKILLS
REQUIREMENTS:
Appropriate
language and computational skills
ENTRANCE
REQUIREMENTS:
SCOPE OF COURSE:
This
course goes beyond a fundamental knowledge of Windows XP and Microsoft
Office (to include Word, Excel, Access, and PowerPoint) into advanced
functions of each element. Building on a fundamental knowledge of Windows
and MSOffice, students will learn intermediate and advanced functions and
techniques such as integration among each application, Internet integration,
extensive formatting, use of macros and templates, shortcuts, printing
techniques, networking and advanced file management.
Real-life applications to related occupations will be incorporated.
Finally, students will evaluate their work from a presentation
standpoint.
SPECIFIC COURSE
OBJECTIVES:
1.
Using the Windows environment:
A.
System configuration.
B.
System maintenance.
C.
Using Windows environment efficiently by multitasking (running
several programs simultaneously) and exchanging data between different
programs.
D.
Selecting print drivers in a stand-alone and networked
environment.
E.
File management
F.
Integration
2.
Use of Microsoft Word word processing package
A.
Report preparation
1.
Title Page
2.
Tables
3.
Calculations in Tables
4.
Footnotes/Endnotes
5.
Page/Section Breaks
6.
Custom Tab Stops
7.
Borders
8.
Headers
9.
Customizing Bullets
B.
Generating Form Letters, Mailing Labels, and Envelopes
1.
Creating the main document
2.
Creating the data source
3.
Editing the data source
4.
Using an IF Field to conditionally print text
5.
Displaying field codes
6.
Printing field codes
7.
Selecting data records to merge and print
8.
Merging main letter and data document
9.
Viewing merged data
10.
Printing merged data
11.
Addressing and printing mailing envelopes
12.
Addressing and printing mailing labels
C.
Creating newsletters
1.
Desktop Publishing Terminology
2.
Various techniques for changing margin settings
3.
Working with the Draw toolbar
a.
Text boxes
b.
Formatting text boxes
c.
Borders and shading
d.
WordArt
e.
Text and shape rotation
f.
Adding shapes to the document
4.
Working with columns
a.
Determining number and size of columns
b.
Changing width of columns
c.
Placing graphics in columns
5.
Editing and formatting a graphic
6.
Using the format painter button
7.
Using a macro to automate a task
8.
Ordering and grouping objects and layers
9.
Text, object and background color
10.
Fonts and drop caps
11.
Applying "styles"
D.
Creating and using Templates
E.
Creating web pages with Word
3.
Microsoft Excel spreadsheet package.
A.
Creating Templates
1.
Formatting Templates
2.
Alternative Uses of Templates
3.
Creating a workbook from a template
a.
Drilling down through worksheets
b.
Modifying and saving a workbook from a template
c.
Referencing cells in other sheets
d.
Entering a sheet reference
B.
Adding chart titles using WordArt
C.
Adding a header and changing the margins
D.
Creating a web page from an Excel worksheet
E.
Viewing the web page using the web toolbar
F.
Data tables
G.
Visual Basic for applications
H.
Macros, planning, adding a button for and executing
I.
Playing back a recorded macro
J.
Goal Seeking
K.
Adding Hyperlinks to a worksheet
L.
Using Scenario Manager to analyze Data
M.
Protecting the worksheet
N.
Creating a database with Excel
O.
Sorting a database
P.
Displaying automatic subtotals in database
Q.
Finding Records in a data form
R.
Filtering a database
S.
Criteria ranges and filtering
T.
Extract ranges
U.
Comparison criteria
V.
Lookup functions
W.
Data Maps
X.
Creating a Pivot Table to Analyze Data
Y.
Integration feature:
embedding an Excel worksheet into a Word document using drag and drop
4.
Microsoft Access database package
A.
Creating and changing properties of reports
1.
Grouping in a report
2.
Removing unwanted controls
3.
Enlarging the page heading of the report
4.
Report design considerations
B.
Creating and using custom forms
1.
Creating, modifying and adding records to the form
2.
Placing a combo box
3.
Adding a title
4.
Form design considerations
5.
Publishing an object to the web
6.
Viewing a web page
C.
Enhancing forms with OLE
1.
Date, memo and OLE and hyperlink fields
2.
Adding fields to a table
3.
Updating memo and hyperlink fields
D.
Advanced form techniques
1.
Sub-forms
2.
Resizing fields
3.
Changing contents of label and resizing
4.
Changing special effects, color and resizing graphics
in a form
E.
Creating and using macros
F.
Creating and using Command Buttons
G.
Creating and using combo boxes
H.
Creating and using a switchboard
I.
Integration: Linking Excel worksheets to an Access database
5.
Microsoft Powerpoint
A.
Changing the font color and design template of the existing
presentation
B.
Creating a custom background
C.
Embedding and editing an Excel chart
D.
Creating and Embedding a Microsoft organizational chart
E.
Inserting, scaling and ungrouping Clip Art objects
F.
Adding slide transition and text preset animation effects
G.
Creating a logo
H.
Adding special text effects with WordArt
I.
Adding an object and pasting to the slide master
J.
Creating an interactive document
K.
Editing the slide title and editing a bulleted list
L.
Replacing a picture
M.
Ending a presentation with a black slide
N.
Applying slide transition effects
O.
Hiding a slide
P.
Animating text and an object
Q.
Integration:
saving the presentation as a web page
R.
Viewing the web page
S.
Running a slide show with hidden slide and interactive
animation
Use of Microsoft
PowerPoint for presentation graphics.
a.
Principles of presentation software
b.
Building a slide presentation
c.
Creating the master slide information
d.
Slide sorter view
e.
Creating a presentation in outline view
f.
Adding clip art and graphic objects and sound to the
presentation
g.
Fill colors and sealing objects
h.
Enhancing a presentation
i.
Adding graphs to a presentation
j.
Adding tables to a presentation
k.
Adding special effects
l.
Setting slide timings for an automatic slide show
SUGGESTED
Online references, help menus
in software programs; computer journals, magazines and reviews.
REQUIRED WRITING:
At
the end of each module, an exam will be given.
Students will write their own resume, sample cover letters, and
rewrite from notes a research paper in MLA format.
(Project 2 of Word.)
OUTSIDE ASSIGNMENTS:
Students
will be expected to read material from textbook, BEFORE THE NEXT CLASS
MEETING. Students prefer the
hands-on teaching techniques used in these classes, but it is much more
meaningful if the chapter that the instructor is presenting has been browsed
through first. Students may be asked to choose real-life projects relating
to an area of the class and complete at home or at work.
If a student does not have a computer at home, it may be necessary to
come to additional classroom sessions.
Students also appreciate the open lab time to practice skills learned
in class. (Please always sign
in to class and open lab.)
INSTRUCTIONAL METHODOLOGY:
Lecture
to explain concepts using a whiteboard as an aid and an overhead projector
connected to a computer display for demonstrations, plus “hands-on” Windows
operations experience. Guided student labs, independent
student labs, student discussion, question/answer, group participation, a
final student presentation; and quizzes and exams when appropriate.
GRADING POLICY:
Exams/presentations 1-5:
40%
Class
labs:
40%
File
management:
10%
Explorations in Technology
10%
GRADING NOTATIONS:
ü
+
=
Skill
mastered
ü
=
Satisfactorily developing skill
ü
-
=
Skill not mastered; repeat
exercise
90-100%
= A
80-89%
= B
70-79%
= C
60-69%
= D
COLLEGE CREDIT:
Students may take any of the
ROP classes for college credit also.
To do so, register through the ROP office or admissions.
As of fall 2004,
ROP classes taken for college credit are FREE.
WITHDRAWAL OF A CLASS TAKEN FOR
COLLEGE CREDIT:
Please see the college catalog
for withdrawal dates. If
student does not officially withdraw by the date in the catalog, an F will
be received for the class and will become part of the student transcript of
record.
CERTIFICATION:
Because
this is an ROP course, you will receive a Certificate of Completion and a
Listing of Competencies upon completion with a grade of C or higher within
several weeks of the end of the semester. You may also take the course for
college credit, in which case you will also receive a Certificate and
Listing of Competencies in addition to a letter grade which will become part
of your transcripts at
PROCEDURE FOR TURNING IN CLASS
PRINTOUTS:
Labs
will be required at the end of each chapter.
Labs are due within 2 class sessions of completion of the chapter.
Save all assignments on your student disk.
EACH SOFTWARE APPLICATION HAS
THREE CHAPTERS. The chapter
itself will be completed in class following lecture and hands-on interactive
tutorials. These are not
required to be turned in, however, it is
imperative that you complete the lesson in the chapter itself first, before
moving on to the lab. The lab
is a test of your grasp of the lesson material in the chapter.
|
SOFTWARE PROGRAM |
CHAPTERS AND LAB ASSIGNMENTS |
DUE
DATES |
|
WORD |
Projects 4-6 and
Lab 2,
Projects 4-6 |
All
due within 7 calendar days of assigned day, by beginning of class
meeting, before lecture begins. |
|
EXCEL |
Projects 4-6 and
Lab 2,
Projects 4-6 |
Same
as above |
|
ACCESS |
Projects 4-6 and
Lab 2,
Projects 4-6 |
Same
as above |
|
POWERPOINT |
Projects 4-5 and
Lab 2,
Projects 4-5 |
Same
as above |
Additional
considerations regarding lab activities and your student folder.
1)
Lab
printouts – Should all have a cover sheet attached with the following
information:
·
Project or Lab
Number
·
Page Number
·
Your name
·
Date
·
Objectives:
list four objectives of the chapter or lab in bulleted format (no
more than seven)
You may write these in
narrative format if you prefer
As your formatting skills
progress you may add graphics, bullets, indentations and other enhancements
which will earn extra credit points up to a maximum of the equivalent of 2
lab assignments (5 points for each cover sheet worthy of extra credit)
2)
Student folder
ALL Project and Lab
assignments should be saved on disk in your student folder on the “W”
student drive. (instructions
in class)
10% of your grade will be
based on the file management of that folder.
The following practices will be graded (and shown in class)
File name should include
software package title, project or lab number and date; i.e.,
WordProj1Sept10-2005.
Follow this example, abbreviating when logical and not using spaces,
or extra characters.
A folder should be created
for each software package:
Word, Excel, Access, PowerPoint;
There will also be 3 exam folders for Word, Excel, Access and
one folder your PowerPoint presentation.
Only those labs that are
in progress or completed and that you wish to be graded should be in your
student folder. Delete any
files that are incomplete (extra or “oops” files) or not to be graded.
Extra files in your folder will result in a deduction of points.
Explorations
in Technology:
The first ten
minutes of class will be dedicated to various topics in technology.
Students will sign in AFTER the 10 minute
technology session and points will be recorded daily for participation in
this activity. 10% of your
grade is dependent upon you arriving on time and participating in this part
of the class. Please speak with
me if you have special circumstances regarding your arrival time.
I am flexible the first week due to parking.
Thereafter, if you arrive more than 10 minutes after the class start
time, please wait until the first break time to enter the classroom so as
not to disrupt the lecture or quiet lab time.
Number
of times course may be taken for credit:
_1__
DISABILITIES:
Please
see me if you have special situations that may require certain
accommodations.
STATEMENT OF ACADEMIC
INTEGRITY:
Academic
Integrity Code of Conduct
Academic
Integrity is a code of conduct for students that requires honest and ethical
academic endeavor.
Violations of the Academic Integrity Code include:
·
Cheating,
plagiarism or false representation of another’s work as one’s own.
·
Forgery,
alteration, or misuses of college documents or records.
·
Use of
false identification.
·
Knowingly
furnishing false information to the District.
·
Unauthorized use or misuse of District equipment.
·
Unauthorized access, use or alteration of computer hardware, software, or
data.
·
Obstruction or disruption of the educational process.
·
Soliciting
or assisting another to do any of the above.
Consequences:
Consequences for violating this code may result in any or all of the
following:
A.
At the discretion of the instructor the student may receive: