MISM 3314-SA01 COURSE
SYLLABUS
 MISM 3314-SA01 Thursday
6:00 pm – 10:10 pm Personal
Computing Applications/Advanced Computer Applications |
Instructor: Don
Lents
Semester: Summer
2009 (May 25 – August 8)
Instructor E-mail: Primary: don@jumpstartresumes.com
Class Meeting:
RM101, Thursday 6:00-10:10 pm
Phone: (210)-632-6060
Office Hours: The instructor will be available for quick informal
discussions or concerns 15 minutes prior and after class. Please email or call the instructor to
schedule an appointment outside of class or for an extended conference.
Course Description
Students will
improve their skills as knowledge workers through effective and efficient use
of integrated software suites (word processing, spreadsheets, databases, and
presentation graphics) and through creating and maintaining web pages.
Information technologies will be applied to problem situations by the design
and use of small information systems for individuals and groups.
Prerequisites
COSC 2311
Required Textbook and Resources
|
BOOK |
AUTHOR |
ED |
YEAR |
PUBLISHER |
ISBN# |
REVIEW |
|
Microsoft Office 2007:
Advanced Concepts and Techniques |
Shelly, Cashman & Vermaat |
8th |
2008 |
Cengage Learning |
1-4188-4333-4 |
Spring 09 |
Course Outcome Competencies
Objective is to teach student
the basic fundamentals of Microsoft Office Suite 2007. Student will learn how to use Microsoft
Office Word, Microsoft Office Excel, Microsoft Office Access, Microsoft Office
Power Point and Microsoft Outlook. At
the end of the course the student will be able to use the Microsoft Office
Suite 2007 with minimum instructions. Course includes:
Microsoft Office Word 2007
Creating a Document with a
Title Page, Table, Chart, and Watermark ◦ Generating Form Letters,
Mailing Labels, and Directories ◦ Creating a Professional Newsletter
◦ Linking an Excel Worksheet and Chart to a Word Document: WD-225-480.
Microsoft Office Excel 2007
Financial Functions, Data
Tables, and Amortization Schedules ◦ Creating, Sorting, and Querying a
Table ◦ Creating Templates and Working with Multiple Worksheets and
Workbooks ◦ Smart Art and Images: EX265-526.
Microsoft Office Access 2007
Creating Reports and Forms
◦ Multi-table Forms ◦ Using Macros, Switchboards, Pivot Tables and
Pivot Charts ◦ Using SQL: AC 233-455
Microsoft Office PowerPoint 2007
Creating a Presentation with
Custom Backgrounds and Smart Art Diagrams ◦ Working with Information
Graphics ◦ Collaborating on and Delivering Presentations: PPT 161-324
Microsoft Office Outlook 2007
Managing Calendars and
Instant Messaging: OUT 73-152
Microsoft Office Integration 2007
Microsoft Office 2007
Integration Case Studies: INT 1-7
Course Schedule
Week 1 – May 28 (in-class; 6:00 to 10:10
pm)
Lecture
covers Microsoft Office Word Chapter 4 & 5/ WD 225-383
Lab
Exercise
Week 2 – June 4 (in-class; 6:00 to 10:10
pm)
Lecture
covers Microsoft Office Word Chapter 6 & Integration Feature / WD385-480
Lab
Exercise
Week 3 – June 11 (in-class; 6:00 to
10:10 pm )
Lecture
covers Microsoft Office Excel Chapter 4 & 5 / EX 265-414
Lab
Exercise
Week 4 – June 18 (in-class; 6:00 to
10:10 pm)
Lecture
covers Microsoft Office Excel Chapter 6 & Graphics Feature / EX417-526
Lab
Exercise
Week 5 – June 25 (in-class; 6:00 to
10:10 pm)
Lecture
covers Microsoft Office Access Chapter 4 & 5 / AC 233-357
Lab
Exercise
Week 6 – July 2 (in-class; 6:00 to 10:10
pm)
Mid-term
Exam
Lab Exercise
Week 7 – July 9 (in-class; 6:00 to 10:10
pm)
Lecture
covers Microsoft Office Access Chapter 6 & Using SQL / EX361-455
Lab
Exercise
Week 8 – Jul 16 (in-class; 6:00 to 10:10
pm )
Lecture
covers Microsoft PowerPoint Chapter 3 & Collaboration Feature / PPT 161-324
Lab
Exercise
Week 9 – July 23 (in-class; 6:00 to
10:10 pm )
Lecture covers Microsoft Outlook 2007 / OUT
72-152
Lab
Exercise
Week 10 – July 30 (in-class; 6:00 to
10:10 pm)
Integration
2007 / INT 1-7
Lab
Exercise
Week 11 –August 6 (in-class; 6:00 to
10:10 pm)
The final exam, Q&A
Material Requirements for Class
Storage Media:
Communication: Your valid e-mail address
Grading Criteria
Course Grade %
of Grade
Midterm Examination 40%
Assignments/Lab Exercises/Work 10%
Final Examination 40%
Final Integrated Project 10%
100%
Numerical grades will be converted into a final letter
grade as follows:
A
= 90 - 100 D = 60 - 69
B
= 80 - 89 F = 59 - BELOW
C
= 70 - 79
Students have one week (seven
days) after receiving their final grade to contact the instructor if they wish
to dispute or discuss their grades.
Please call (210) 632-6060 to make arrangements.
Late Work
All
work not turned in on the due date will not receive credit for that
assignment. Assignments must be turned
in on time to receive credit. The
instructor is not obligated to grade late assignments. Computer glitches will not be an exception
for late or incomplete assignments.
Discretionary /Participation Points
At the end of the course, I
can award up to 10 points extra credit to students who have shown outstanding
effort in the class (reading assignments, class participation, on time to
class, attendance). This does not sound
like much; however it could be the difference of one letter grade. Not all students earn these points; they are
reserved for those who have worked hard and are points away from an “A” or “B”
etc.
Examination Policy
Assessment exams during the
course will go over chapters or materials covered in class. Date of exam will be reflected on the weekly
agenda at least 1 week in advance. There
is a Mid-Term, Final Exam and a Final Integrated Project which is explained
below.
·
Preparing for Examinations
Attend
class daily, take notes, read the chapters, review the chapter reviews and key
terms section at the end of the chapters on which you are being tested. ALL
EXAMS are based on reading and lab exercises completed in class.
·
Make-up Exams
No
make-up exams will be allowed without prior arrangements being made with the
instructor. Although on the same
material, these exams may be somewhat more difficult.
Final Integrated Project
A final integrated project
will be assigned. This project will
allow you to utilize various areas discussed and learned in this course. The project is assigned approximately the
midterm of the course and class time is used to work on it. Projects are assigned to small groups (or
Individuals, depending on class size) whereby the following deliverables are
required:
·
Paper
·
PowerPoint
Presentation
The
project will be discussed more in-depth at time of assignment.
Group Assignments
Students
will be assigned to groups at different times during the course and will be
required to work together to complete assigned projects. Projects will be limited to class time and
all work should be done and completed during the class. Grades are based on preparation, research, attendance
and participation. Any student absent during group projects will
have points deducted for that particular group assignment.
Homework
This
class may require approximately 2 hours or more lab/research time each week
that must be done outside of the classroom.
Homework is kept at a minimum with between 5-10 outside short
assignments to include reading assignments from the textbook.
Methods of Instruction
Lecture
and hands-on lab exercises utilizing the Windows XP Operating System, Internet,
and Microsoft Office application software.
Attendance
According
to Wayland Baptist University Attendance policy, “Students enrolled at one of
the University’s external campuses should make every effort to attend all class
meetings. All absences must be explained
to the instructor, who will then determine whether the omitted work may be made
up. When a student reaches that number
of absences considered by the instructor to be excessive, the instructor will
so advise the student and file an unsatisfactory progress report with the
campus dean. Any student who misses 25
percent or more of the regularly scheduled class meetings will receive a grade
of F in the course. Additional
attendance policies for each course, as defined by the instructor in the course
syllabus, are considered a part of the University’s attendance policy.” (
Each
student must commit himself/herself to attend each and every class and being on
time. If a student does in fact miss a
class, then he/she is responsible for obtaining missed information from his/her
class members.
Two
tardies will count as one absence. You will be considered absent 30 minutes after the
beginning of each class. I suggest that if
a student is late or absent they make every effort to attend class as there is
a lot of material to cover in each class.
It is the student’s responsibility to inform the instructor that he/she
is tardy. If the student must leave
early, it will count as a tardy.
If
the instructor is over 45 minutes late, a student in the class should take
accountability of those students present and leave. The student that took accountability should
turn in the sheet at the next class meeting.
Scholastic Integrity
Disability Statement
As per Section 504 of the
Vocational Rehabilitation Act of 1973 of the Americans with Disabilities Act
(ADA) of 1990,” It is University’s policy that no otherwise qualified disabled
person be excluded from participation in, be denied the benefits of, or be
subject to discrimination under any educational program or activity in the
University.” (
Calendar Information
A weekly/daily agenda will be
provided with scheduled lectures, labs and reading assignments for the week.