CIS 130 Syllabus

Document Sample
CIS 130 Syllabus Powered By Docstoc
					                     CIS 130e – Micro Computer Applications
                                            (Office 2007 - Summer 2008)
Instructor: Vicki Romero                                                      Tue & Thu, at 10:50–1:30, in Room N120
E-mail: vromero@pierce.ctc.edu                                                Office Hours: By Appointment

Textbook:    Office 2007 – Introductory Concepts and Techniques, Windows XP Edition, ISBN:
1-4188-4327-X (Bundled w/ Course Notes, Sam 2007, and a 180 Day Trial Version of MS Office 2007)

Materials: Personal Computer with Internet Access: Students must own or have ready assess
to an IBM-compatible personal computer, with access to the Internet, hard drive storage space and
an e-mail account.
Software: Students must either have MS Office 2007 Professional installed on their personal
computer, or have ready access to a computer system containing MS Office Professional. This
software is available in Pierce College Computer Labs. A trial edition of Office 2007 Professional
has also been included with the text…if you purchased text from the Pierce College Bookstore.
Disks: You are responsible for ensuring that you keep copies and back-ups all coursework in the
event that your computer’s hard drive fails. Use floppies, Zip disks or a thumb drive for this purpose.

Course Description: This course offers an opportunity to become more familiar with the use of
computers by learning the four most frequently used software programs for word processing,
electronic spreadsheets, data base management, and presentation graphics. The above require
that you have MS Office 2007 Professional installed on your personal computer

Students with disabilities who believe they may need academic adjustments, auxiliary aids or
services to fully participate in course activities or meet course requirements are encouraged to
register with the Disability Support Services (DSS) Office. You may also call the DSS Office to
make an appointment to meet with the DSS Coordinator at (253) 964-6526 or 964-6527.
Students requesting academic adjustments must obtain the “Approved Quarterly Academic
Adjustments, Auxiliary Aids or Services” form provided by DSS before any adjustments are made.
Class Participation. This is an intense course. It is the student’s responsibility to actively
participate in the course, and be responsible for all material described in the
syllabus. If you are going to drop this course, you must formally withdraw. If
you just stop doing coursework, you will receive a failing grade on your
permanent record. You will not be given an Incomplete as a grade.
Academic Integrity: Cheating and plagiarism will not be tolerated. All work must
be totally your own – not the result of a “team effort!”

Grading: 3.5 – 4 = A (90% and higher), 2.5 – 3.4 = B (80-89%), 1.5 – 2.4 = C (70-79%), 1.0 – 1.4 (65-69%) =D
                  Anything below 65% =0.0, is a failing grade

Graded Requirements:                                                                       Points Value
   Chapter Quiz – Computer Essentials ...................................................................... 20
    Word Ch 1 Learn to Ride Flier ................................................................................. 20
    Word Ch 1 Lab 3 - Rent a Cabin ............................................................................. 20
    Word Ch 2 Wireless Communications Research Paper ........................................... 30
    Word Ch 2 Lab 1 - Computer Forensics Specialist .................................................. 20
    Word Ch 3 Cover Letter and Resume ..................................................................... 30
    Word Ch 3 Lab 1 - Owens Cover Letter................................................................... 20
    3 MS Word Chapter Quizzes ................................................................................... 60


                                                            Page 1
MicroComputer Applications (CIS-130e – Summer 2008)                                                                          Syllabus

   Excel Ch 1 Worksheet with Embedded Chart .......................................................... 30
   Excel Ch 1 Lab 1 - Kona’s Espresso Coffee ............................................................ 15
   Excel Ch 2 Worksheet with Formulas, Functions and Web Query ........................... 30
   Excel Ch 2 Lab 1 - Facade Importers ...................................................................... 15
   Excel Ch 3 Financial Projection Worksheet with What-if Analysis and 3DChart ................ 30
   Excel Ch 3 Apply Your Knowledge Exercise Part 3 ................................................. 15
   Excel Ch 3 Make it Right Exercise........................................................................... 15
   3 MS Excel Chapter Quizzes ................................................................................... 60
   Access Ch 1 JSP Recruiters Database ................................................................... 20
   Access Ch 1 Lab 3 - Ada Beauty Supply ................................................................. 20
   Access Ch 2 Queries (5) ......................................................................................... 50
   Access Ch 3 Maintenance of the JSP Recruiters Database .................................... 20
   Access Ch 3 Lab 2 .................................................................................................. 20
   3 MS Access Chapter Quizzes ................................................................................ 60
   PowerPoint Ch 1 Cabo Package Presentation ........................................................ 15
   PowerPoint Ch 1 Lab 3 ........................................................................................... 15
   PowerPoint Ch 2 Identity Theft ................................................................................ 15
   PowerPoint Ch 2 Lab 2 Tree Pests ......................................................................... 15
   2 MS PowerPoint Chapter Quizzes ......................................................................... 40
   PowerPoint Class Presentation ............................................................................... 20
   MS Outlook Chapter Quiz ....................................................................................... 20
   Integration Chapter Quiz ......................................................................................... 20
   Instructor-Generated Mail Merge Project ................................................................. 40
   E-portfolio or Workbook (3-Ring Binder) .............................................................. 30
                                                                     All Requirements: Total Points 810



PRINT AND FOLLOW the file named: CIS 130 Course Requirements Summary
Revised.Docx That file is located on the classroom’s Shared Drive (M: Drive)


                          Proposed Weekly Activities Schedule
                      This proposed schedule may be modified as the course develops.
     It is intended as a planning guide for students. All Chapter references are to the course textbook.
   Date (Week of. . .)                                                        Activity

                             Download/Copy all course requirement/Documents from the Shared Drive in Classroom.
        Week 1
                             Instructor provides Essential Intro to Computers and an Overview of Windows XP
                             Read Essential Intro to Computers – on Pages COM 1-40 and complete the chapter Quiz.
       6/23-6/27
                             Read Intro to Windows XP – on Pages WIN 1-66 and complete the chapter Quiz
                                                                                      E-mail the above Chapter Quizzes

                             Word Chapter 1, Complete the LEARN TO RIDE Flier
                             Word Chapter 1, Complete Lab 3 - Rent a Cabin Flier
        Week 2               Word Chapter 2, Complete the Wireless Communications Research Paper
        6/30-7/4             Word Chapter 2, Complete Lab 1 - Computer Forensics Specialist

                             Complete Word Ch 1 and 2 Quizzes




                                                            Page 2
MicroComputer Applications (CIS-130e – Summer 2008)                                                     Syllabus


                      Word Chapter 3, Complete the Cover Letter and Resume Exercise
                      Word Chapter 3, Complete Lab 1 - Lab 1 - Owens Cover Letter
                                                          Complete Word Ch 3 Quiz. E-mail Word Ch 1-3 Quizzes
                      Excel Ch 1, Complete Worksheet with Embedded Chart
       Week 3         Excel Ch 1, Complete Lab 1 - Kona’s Espresso Coffee.    Do the Excel Chapter 1 Quiz
       7/7-7/11
                      Excel Ch 2, complete the Worksheet with Formulas, Functions and Web Query
                      Excel Ch 2, complete Lab 1 - Facade Importers (Part 1 only)

                                                               Word Ch 3 and Excel Ch 1 Exercises/Labs are due
                      Excel Ch 3, complete Financial Projection Worksheet with What-if Analysis and 3DChart
                      Excel Ch 3, complete the Apply Your Knowledge Exercise PART 3
                                                                       The above Excel Exercises / Labs are due
        Week 4                                                  The completed Excel Ch 1-3 Quizzes are also due
       7/14-7/18      Excel Ch 3, complete the Make it Right Exercise
                                                The Ch 3 Make it Right Exercise and Excel Ch 1-3 Quizzes are due



                      Access Ch 1, Complete the JSP Recruiters Database
        Week 5        Access Ch 1, Complete Lab 3 - Ada Beauty Supply
       7/21-7/25      Complete the Access Ch 1 Quiz



                      Access Ch 2, Complete Queries as specified in the CIS 130 Course Requirements Summary
                      .Docx file Provided by your Instructor

       Week 6            The above Ch 2 Queries in the JSP Recruiters Database are due,
       7/28-8/1       Access Ch 3, Complete changes to the JSP Recruiters Database
                      Access Ch 3, Complete Lab 2- Hockey Fan Zone Database
                      E-mail Access Ch 3 Exercise and Lab, and the Ch 1-3 Quizzes are due .

                      PowerPoint Ch 1, Complete the Cabo Package Presentation
                      PowerPoint Ch 1, Complete Lab 3 Part One Spring Seminars pages 74-75 (Part 1 only)
                      PowerPoint Ch 2, Complete the Identity Theft Presentation
                      PowerPoint Ch 2, Complete the Lab 2 -Tree Pests Presentation (Part 1 only)
        Week 7
                      E-mail above presentations and the Ch 1-2 Quiz to your instructor are due
        8/4-8/8
                      Prepare and Present a 5-10 minute PowerPoint Presentation to the Class on your
                      favorite Hobby. (Another topic could be used if pre-approved by your instructor.)
                      You must properly use Custom Animations, Transitions, and Graphics throughout your
                      presentation
                      Read the MS Outlook Chapter and Complete the Outlook Chapter Quiz
                      The Outlook Chapter Quiz due
                      Read the MS Integration Chapter and Complete the Integration Chapter Quiz
                                                                                   Integration Chapter Quiz due      .
        Week 8        Complete the Mail Merge Exercise provided by your Instructor.
       8/11-8/15      Instructions and needed files for this exercise are provided by your Instructor.
                      Mail Merge Project Exercise Files due
                      Read the MS Integration Chapter and Complete the Integration Chapter Quiz
                                                                                      Integration Chapter Quiz due   .




                                                 Page 3

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:11/9/2011
language:English
pages:3