Coure Syllabus
PALOMAR COLLEGE ROP
INSTRUCTOR:
Office Hours:
by appointment, Room B8
Phone:
744-1150 x2965 Voice Mail
E-mail Address:
jmartinklement@palomar.edu
Palomar
ROP Office: 744-1150 x2301
LAB TECHNICIAN:
John Diaz
CLASS DATES & MEETING
TIMES:
RCSIS 120 Section #75513 Meets in Room B-8 Dates: 08/26/08-12/18/08 T&Th 9:00 am – 11:20 am
RCSIS 120
Section #71816
Meets in Room B-8
Dates: 08/25/08-12/17/08
M&W 11:30 am – 1:50 pm
TEXTBOOK:
Microsoft Office 2007 Introductory Concepts and Techniques; Shelly, Cashman.
Copyright 2007; ISBN:
1-4188-4327-X or ISBN 13:
978-1-4188-4327-4
(1) DVD (R/W)
(1) CD (R/W)
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:
BASIC SKILLS REQUIREMENTS:
Appropriate language
and computational skills
ENTRANCE REQUIREMENTS:
SCOPE OF COURSE:
A
basic study of the Windows XP and soon…the
SPECIFIC COURSE OBJECTIVES:
1)
Demonstrate ability to
format disks.
2)
Demonstrate ability to
perform tasks in a Windows environment.
3)
Demonstrate ability to
create, format, and manipulate word processing documents.
4)
Demonstrate ability to
design, format, and modify spreadsheets.
5)
Demonstrate ability to
design, create, and successfully query a database.
6)
Demonstrate ability to
design, create, and successfully build graphic and slide presentations.
CONTENT IN TERMS OF SPECIFIC BODY OF
KNOWLEDGE:
1.
Using the Windows
environment:
a.
Selecting appropriate
Windows icons, buttons and boxes for system configuration and memory
management.
b.
Using Windows
environment efficiently by multitasking (running several programs
simultaneously) and exchanging data between different programs.
c.
Customizing Windows by
choosing color schemes, changing fonts, adjusting mouse settings,
configuring desktop, changing date, time and currency formats, and selecting
printer drivers.
2.
Use of Microsoft Word
word processing package.
a.
Creating and printing
a document.
b.
Formatting a document.
c.
Saving and retrieving
a document.
d.
Deleting text.
e.
Inserting text.
f.
Justification
g.
Finding and replacing
text.
h.
Working with multiple
documents.
i.
Use of desktop
publishing – graphics/text
j.
Using mail merge and
tables
k.
Proofreading
l.
Tabs
m.
Moving text
n.
Thesaurus/speller
3.
Use of Microsoft Excel
spreadsheet package.
a.
Using menu options
b.
Creating and printing
a spreadsheet
c.
Improving the
appearance of a spreadsheet
d.
Labels & values
e.
Formulas & functions
f.
Working with multiple
spreadsheets
g.
Editing data
h.
Copy/move data
i.
Changing cell styles
j.
Changing numeric
formatting
k.
Creating a graph
l.
Creating a database
m.
Editing and sorting a
database
n.
Extracting records
from a database
4.
Use of Microsoft
Access data base program.
a.
Principles
b.
Creation
c.
Generating lists
d.
Editing records
e.
Removing records
f.
Adding records
g.
Sorting records
h.
Generating reports
i.
Generating letters
5.
Use of Microsoft
PowerPoint for presentation graphics.
a.
Principles
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
art objects 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
REQUIRED
OR Same Text for Vista Edition: ISBN 10: 1-4239-12284 OR ISBN 13: 978-1-4239-1228-6
SUGGESTED
Journals, magazines, articles related to computing.
Online help, internet tutorials; web site that accompanies the
textbook: Student Link at
http://www.scsite.com. Also tutorials at
http://labpub.com/learn.
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 also 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 open labs that are provided in Room B8 to complete the lab
assignment. Students also
appreciate the open lab time to practice skills learned in class.
(Please always sign in to class and open lab.)
ASSIGNMENTS: The following
assignments will be completed partially in class but will also require out
of class, additional time. It
is absolutely necessary to spend time out of class daily on class
assignments, in order to successfully complete this summer course.
The
Additional lab assignments as announced in class.
|
SOFTWARE PROGRAM |
CHAPTERS AND LAB ASSIGNMENTS |
DUE
DATES |
|
WORD |
Projects 1-3 and
Lab 2,
Projects 1-3 |
All
due within 2 class dates of assigned day, by beginning of class
meeting, before lecture begins |
|
EXCEL |
Projects 1-3 and
Lab 2,
Projects 1-3 |
Same
as above |
|
ACCESS |
Projects 1-3 and
Lab 2,
Projects 1-3 |
Same
as above |
|
POWERPOINT |
Projects 1-2 and
Lab 2,
Projects 1-2 |
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 save 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
completed and that you wish to be graded should be in your student folder.
Delete any files that are incomplete 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.
INSTRUCTIONAL METHODOLOGY:
Lecture/demonstration to explain concepts using a whiteboard as an aid and
an overhead projector connected to a computer display for demonstrations.
Hands-on guided practice, hands-on independent practice (lab
exercises from text), group participation and assessment, question/answer,
quizzes, and exams when appropriate, student presentations.
GRADING POLICY:
Exams 1-5:
40%
Class labs:
40%
File
management:
10% (new)
Explorations
in technology
10% (new)
DURING FINALS WEEKS, WE
WILL MEET AT OUR REGULARLY SCHEDULED CLASS TIME, UNLIKE THE REST OF THE
CAMPUS. WE WILL HAVE OUR FINAL
EXAM DURING THIS TIME.
GRADING NOTATIONS:
ü
+
=
Skill
mastered
ü
=
Satisfactorily developing skill
ü
-
=
Skill not mastered; repeat exercise
90-100%
= A
80-89%
= B
70-79%
= C
60-69%
= D
CERTIFICATIONS:
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.
College grades are posted to the
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
COLLEGE CREDIT:
Students may take any of
the ROP classes for college credit tuition-free.
To do so, register through the ROP office or online at
www.palomar.edu, following the student e-services
links.
WITHDRAWAL OF A CLASS
TAKEN FOR COLLEGE CREDIT:
Please see the college catalog for withdrawal dates.
If a 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.
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 APPLCATION
(Word, Excel, Access, PowerPoint) HAS THREE
CHAPTERS. The chapter itself
will be completed in class following lecture and hands-on interactive
tutorials. 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.
Again, a printed copy of
both the chapter assignment and the lab assignment are required to be turned
in to your professor.
Number of times course may be taken for credit:
_1__
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” 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.
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:
1.
A failing grade for the assignment
2.
A failing grade for the course
3.
Short-term suspension as described in section IV A of the Rules and
Regulations for Student Behavior
B.
Long-term suspension or expulsion may be applied following the procedures
described in the Rules and Regulations for Student Behavior.
DISABILITIES:
Please see me if you have special situations that may require certain
accommodations.
IMPORTANT CAMPUS PHONE
NUMBERS:
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.
Contemporary Job Search 186
JOB SEARCH:
We will spend
one class session in the
Students who are ready to go into active job search are encouraged to enroll
in the one unit Contemporary Job
Search class during their last semester at