SYLLABUS

 

MIS 200A: Software Productivity Tools

Fall 2009 (CRN: 80998)

 

Class website: http:// www.csub.edu/~ychoi2/mis200A_2010.htm

 

Instructor

Name: Yong Choi, PhD

Office: BDC 101

Office Hours: Tuesday (5:30pm – 7:30pm)
                     Wednesday (1:00pm – 4:00pm)

                     Or by an appointment

Office Phone: (661) 654 - 6691

Email Address: ychoi2@csub.edu

 

Prerequisite: None

 

Course Description

This course provides an overview of microcomputer applications including computer concepts, Microsoft Word, Microsoft PowerPoint, Microsoft Excel, and Microsoft Access. This course utilizes off-line and online resources. Since various university courses use Microsoft Excel extensively as an important tool, this course focuses on Microsoft Excel.

 

Learning Objectives

After completion of this course students should be able to:

 

 

 

Required Materials


Textbook Title: Microsoft Office 2007: Introductory Concepts and Techniques, Premium Video Edition, 1st Edition

Authors:Gary B. Shelly |  Thomas J. Cashman |  Misty E. Vermaat

ISBN: ISBN-10: 0324826850 |  ISBN-13: 9780324826852

  

Guidelines & Comments

 

Every MIS 200A student will be issued a Blackboard email account. The Blackboard email is ONLY official email of MIS 200A. Your email (i.e., CSUB runner mail, Hotmail) will be used ONLY for introduction of the course. It is the student's responsibility to regularly check his or her Blackboard email to stay current with MIS 200A course communications. REMEMBER, if you email me using your email after 10 days of the first day of the class, I will not reply to our email.


A Blackboard ID is the only means of accessing your Blackboard course(s).  Blackboard IDs are case sensitive and must be entered in lowercase letters. If you do not know your Blackboard ID or have forgotten your password and have not set up the log in hint question contact E-Learning Services at 661-654-2315.


You must submit each assignment and the final exam through the Blackboard assignment/exam submission link from Blackboard. Otherwise, they will not be accepted. If you are familiar with submission thru Blackboard, please try the tutorial (How to submit your assignment and exam through Blackboard) from our class website. If you’d like to avoid a possible technical problem of the Blackboard, you must try to submit the assignment and exam at least two days before the due date. Then, you can have enough time for dealing with the possible Blackboard problem. If you'd like to minimize a possible Blackboard problem, please submit using a PC in the school computer lab.


You can still submit a late assignment after the due date. However, 25% penalty will be applied for each day late. Obviously, if your assignment is more than four days late, you will receive zero points. Thus, the Blackboard assignment/exam submission link will be closed right after fourth day. Remember! the Blackboard assignment/exam submission link DOES NOT ACCEPT THE FINAL EXAM  after the exam due date.


Your grade for each assignment and the final exam will be posted on the Blackboard "Grade".

 

Any Work Turned In must be neatly done and should conform to the following specifications; Unless you are asked for a list, you are to use complete sentences which are grammatically correct and which contain no misspelled words. What you submit should be of the quality you would expect to submit to a supervisor or colleague on the job.

 

Office Hours will be held so that you may simply drop in if you need to discuss anything related to the course, your curriculum, your career, etc. I encourage you to take advantage of this time. If you have questions regarding exams (other than about what is expected), I will expect you to demonstrate you have already put a reasonable effort into solving the problems and/or analyzing the reading material and discussion questions. In this manner, we'll both benefit the most from the consultations.

 

Honor Code. Students are expected to uphold the CSUB standard of conduct for students relating to academic dishonesty. Students assume full responsibility for the content and integrity of the academic work they submit.  The guiding principle of academic integrity shall be that a student’s submitted work, examinations, and assignments must be that student’s own work.

 

Classroom Conduct. I expect that everyone in this class (Instructor included) will conduct him/herself in a professional manner. It is the policy of the California State University, Bakersfield to not discriminate on the basis of sex, sexual orientation, disability, race, color, religion, national or ethic origin in its educational programs. The faculty of the School of Business and Public administration strongly support this policy.

 

Course Activities

 

You are required to develop documents, presentation slides, and applications using Microsoft Word, Microsoft PowerPoint, Microsoft Excel, and Microsoft Access. These software tools are very useful and powerful weapons to solve many business problems in information age. We are going to develop and implement a business database using Access. And Excel will be used for developing various Decision Support Systems. Specific instructions for this activity is posted on our class website.

 

 

 Course Evaluation

* The grading scales are subject to change *

 

Assignments                                                  

Final Exam       

---------------------------------------------------

Total                             

90 points         

30 points

 -------------------

120 points

 

Final grades will be determined by the following scale:
A: 93-100, A-: 90-92.9, B+: 87-89.9, B: 83-86.9, B-:80-82.9, C+: 77-79.9,

C: 73-76.9, C-: 70-72.9, D+: 67-69.9, D: 63-66.9, D-: 60 - 62.9, F: below 60

 

Tentative Subjects

Ø  The following is subject to change.

Ø  Please visit the class web site for the most current and updated information.

----------------------------------------------------------------------------------------------------------------------------
Fundamentals of Computer

  1. Introduction to Computer Systems
  2. Analog and Binary Signals
  3. Computer Memory
  4. The Processor

----------------------------------------------------------------------------------------------------------------------------

Microsoft Word

  1. Audio course: Get to know Word: Create your first document
  2. Add graphics and keep them where you want them
  3. Use mail merge for mass mailings and more
  4. Tables I: Create and format basic tables
  5. Audio course: Revise documents with Track Changes and comments
  6. Tables II: Use tables to simplify complex page layouts
  7. Create an accessible Office document
  8. Work with the keyboard
  9. Prepare for the holidays: Write and send a newsletter with Word
  10. Tables III: Manage financial tables and tables from Excel and the Web
  11. Protect Word documents
  12. Create a document outline
  13. Table of Contents I: Create a basic TOC
  14. Create individual envelopes and labels
  15. Table of Contents II: Advanced TOCs, long documents, and other tables
  16. Headers and footers, simple to elaborate
  17. So that's how! Great Word features
  18. Customize keyboard shortcuts in Word
  19. Decorate documents with backgrounds, borders, and text effects
  20. Format your document with styles
  21. Create footnotes and endnotes
  22. Organize your clip art and other media

----------------------------------------------------------------------------------------------------------------------------

Microsoft PowerPoint

  1. Create your first presentation
  2. Printing I: Know your options
  3. Printing II: Work with color commands
  4. Design efficiently with masters
  5. Create your own template
  6. Animations I: Preset and custom animation
  7. Animations II: Motion paths
  8. Animations III: Timing
  9. Use Visio drawings in presentations, documents, and publications
  10. Work with the keyboard
  11. So that's how! Great PowerPoint features
  12. Org charts A to Z
  13. Flowcharting with flair
  14. Playing sound
  15. Playing movies
  16. The small print: headers and footers
  17. Navigation know-how
  18. Organize your clip art and other media

----------------------------------------------------------------------------------------------------------------------------

Microsoft Excel

  1. Creating a worksheet
  2. Creating an embedded chart
  3. Working with Formulas
  4. Working with Functions
  5. Working with Formatting
  6. Developing Web Queries
  7. Working with What-If Analysis
  8. Working with Charting
  9. Working with large worksheets
  10. Working with web feature: creating static and dynamic web pages using Excel
  11. Working with Financial functions
  12. Working with data tables
  13. Working with amortization schedules
  14. Creating, sorting, and querying a List
  15. Creating templates
  16. Working with multiple worksheets and workbooks
  17. Integration Feature: Object Linking and Embedding (OLE) and Web Discussions

----------------------------------------------------------------------------------------------------------------------------

Microsoft Access

  1. Get to know Access
  2. Table that data
  3. Queries I: Get answers with queries
  4. Reports I: Show off your data
  5. Forms I: Create a form to enter and view your data