SYLLABUS
MIS 200A: Software Productivity Tools
Class website: http:// www.csub.edu/~ychoi2/mis200A_2011.htm
Instructor
Name: Yong Choi, PhD
Office: BDC 101
Office Hours: Wednesday (3:00pm – 5:00pm)
Wednesday (2:00pm –
5:00pm)
Or by an appointment
Office Phone: (661) 654 - 6691
Email Address: ychoi2@csub.edu
Course Description
This course provides an overview of microcomputer applications including 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 heavely focuses on Microsoft Excel.
Learning Objectives
After completion of this course students should be able to:
Required Materials
Textbook Title:
GO! with Microsoft Excel 2010, Comprehensive
Authors: Shelley Gaskin | Alicia Vargas | Suzanne Marks
ISBN: ISBN-10: 0135098211 | ISBN-13: 9780135098219
Publisher: Pearson
Guidelines & Comments
Every MIS 200A student will be issued a Blackboard email account. The Blackboard email is ONLY official email of MIS 200A. Your personal email (i.e., gmail, hotmail) in our CSUB system will be used ONLY for introduction of the course. It is the student's responsibility to regularly check his/her Blackboard email to stay current with MIS 200A course communications. REMEMBER, if you email me using your personal 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 NOT familiar with submission procedures 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.
When you submit an assignment
(or exam), you MUST CLOSE the
Microsoft office application (i.e., Word, PowerPoint, Excel and Access) COMPLETELY
before you submit ASSIGNMENT (OR EXAM)
FILES.
Otherwise,
you will
receive ZERO POINTS because
ONLY
title of you file will be processed and accepted without including actual
contents of your assignment (or exam).
Thus, you MUST make sure to CLOSE
the Microsoft office application (i.e., Word, PowerPoint, Excel and Access) COMPLETELY
before you submit ASSIGNMENT (OR EXAM)
FILES. And if an
assignment requires submit several
files, you
must submit all files together at once.
That is, you must "UPLOAD" all the assignment files together at once.
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.
-------------------------------------------------------------------------------------------------------------------------------
Using the Common Features of Microsoft Office 2010
Use Windows Explorer to Locate Files and Folders
Locate and Start a Microsoft Office 2010 Program
Enter and Edit Text in an Office 2010 Program
Perform Commands from a Dialog Box
Create a Folder, Save a File, and Close a Program
Add Document Properties and Print a File
Open an Existing File and Save it with a New Name
Explore Options for an Application
Perform Commands from the Ribbon
Apply Formatting in Office Programs
Use the Microsoft Office 2010 Help System
Compress Files
Creating a Worksheet and Charting Data
Create, Save, and Navigate an Excel Workbook
Enter Data in a Worksheet
Construct and Copy Formulas and Use the SUM Function
Format Cells with Merge & Center and Cell Styles
Chart Data to Create a Column Chart and Insert Sparklines
Print, Display Formulas, and Close Excel
Check Spelling in a Worksheet
Enter Data by Range
Construct Formulas for Mathematical Operations
Edit Values in a Worksheet
Format a Worksheet
Using Functions, Creating Tables, and Managing Large Workbooks
Use the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions
Move Data, Resolve Error Messages, and Rotate Text
Use COUNTIF and IF Functions and Apply Conditional Formatting
Use Date & Time Functions and Freeze Panes
Create, Sort, and Filter an Excel Table
Format and Print a Large Worksheet
Navigate a Workbook and Rename WorksheetsEnter Dates, Clear Contents, and Clear Formats
Copy and Paste by Using the Paste Options Gallery
Edit and Format Multiple Worksheets at the Same Time
Create a Summary Sheet with Column Sparklines
Format and Print Multiple Worksheets in a Workbook
Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools
Chart Data with a Pie Chart
Format a Pie Chart
Edit a Workbook and Update a Chart
Use Goal Seek to Perform What-If Analysis
Design a Worksheet for What-If Analysis
Answer What-If Questions by Changing Values in a Worksheet
Chart Data with a Line Chart
Use Financial and Lookup Functions, Define Names, and Validate Data
Use Financial Functions
Use Goal Seek
Create a Data Table
Define Names
Use Defined Names in a Formula
Use Lookup Functions
Validate Data
Managing Large Workbooks and Using Advanced Sorting and Filtering
Navigate and Manage Large Worksheets
Enhance Worksheets with Themes and Styles
Format a Worksheet to Share with Others
Save Excel Data in Other File Formats
Use Advanced Sort Techniques
Use Custom and Advanced Filters
Subtotal, Outline, and Group a List of Data
Creating Charts, Diagrams, and Templates
Create and Format Sparklines and a 3-D Column Chart
Create and Format a Line Chart
Create and Modify a SmartArt Graphic
Create and Modify an Organization Chart
Create an Excel Template
Protect a Worksheet
Create a Worksheet Based on a Template
Creating PivotTable and PivotChart Reports and Auditing Worksheets
Create a PivotTable Report
Use Slicers and Search Filters
Modify a PivotTable Report
Create a PivotChart Report
Trace Precedents and Dependents to Audit Worksheet Formulas
Use Error Checking to Audit Worksheet Formulas
Use the Watch Window to Monitor Cell Values
Using the Data Analysis, Solver, and Scenario Features
Calculate a Moving Average
Project Income and Expenses
Determine a Break-Even Point
Use Solver
Evaluate Complex Formulas
Create Scenarios
Using and Managing Access
-------------------------------------------------------------------------------------------------------------------------------