Online Course Syllabus

Microsoft Excel Syllabus

CSUSB, Employee Training Team
Course Syllabus for Microsoft Excel Pivot Tables
On-Line Microsoft Pivot Tables
Pam Mays - July 12th, 2010

Class Day/Time/Location: Monday, 8:30 a.m. -10:30 a.m., Face-to-Face meeting the first session

Office Location and Hours: Training Department By appointment — Call 951-236-5442

E-mail: maysp300@csusb.edu

Course Website http://blackboard.csusb.edu

Back-up E-mail pammays78@yahoo.com

Materials All course materials will be provided online the first day of class.

Software: Each participant will have Microsoft Excel loaded on their work computers. If you do not have the software loaded as a standard, please contact your supervisor to submit a helpdesk request.

The College of Education at California State University, San Bernardino (CSUSB) is dedicated to the development and support of wise, reflective professional educators who will work toward a just and diverse society that embraces democratic principles. Thus the wise teacher:

• Possesses rich subject matter knowledge.
• Applies sound pedagogical judgment to professional practice and conduct.
• Applies a practical knowledge of context.
• Respects multiple viewpoints.
• Reflects on professional practices and follows up with appropriate action.

Bulletin Course Description
Seminar to enhance user’s existing skill set on using the current spreadsheet software application, Microsoft Excel 2007. Focus will be based learning the latest features that Pivot Tables have to offer and creation of reports to perform analysis of internally used data.

Graded credit/no credit. Prerequisites/co-requisites are students possess experience at an intermediate level using Microsoft Excel. Must receive supervisory permission to attend.

Overview/ Rationale
The course will be offered in an online format where users log in to complete the tutorial and follow-on exercises. The learning goals are to provide users with the fundamental knowledge to create and deploy a Pivot table on any new or existing data set. Tasks to be completed are inserting a Pivot table into a new or existing worksheet, creating a shortcut on the user’s personal toolbar, building a report and choosing fields from the Pivot Table field list.

The instructor will be available for online chat to answer any questions during the class session. Participants can also provide the instructor with permission to shadow their own computers. Instructions are provided during the introductory session and will be posted in the class documents area on the blackboard system.
Students must submit the completed exercises to the instructor via e-mail at maysp300@csusb.edu by midnight, Sunday of each week. Since this is considered a soft-skills training class, participants are encouraged to re-work any areas where the final product is incomplete. Remember, this class intends to enhance the knowledge that user’s already possess.

Course Objectives
The following objective identifies the knowledge, skills, and dispositions that will be assessed in this course. Successful completion will provide the participants with the following knowledge base:
• Understand what a Pivot Table can do with a large data set and how to summarize that data and turn it into meaningful information.
• Creation of a personal toolbar shortcut to allow quick access when creating Pivot Tables.
• How to create a Pivot Table in a new worksheet or the existing one and when it makes sense to do it.
• Assigning report filters, column and row labels.
• Build a report
• Selecting fields from the Pivot Table Field List

Course Requirements
There are no specific course requirements other than a supervisory approval to attend.

Course Evaluation Plan/Grading Scale
This course is graded credit/no credit. To earn credit for the course you must complete all the end of session exercises within 5 days of the last course session.
Participants are provided the opportunity to resubmit class exercises that are incorrect or incomplete. 2/3 of the exercises need to be completed to receive a credit in the course. Otherwise a no credit for the course will be recorded.
Course Policies Correspondence will be sent to you via the Blackboard when it is related to the entire class community. Otherwise, written communication will be sent to your campus e-mail address. If you prefer another e-mail address is used, complete the sign-in roster the first day of class along with your other address and it will be info copied on all correspondence.

Online Discussions Remember that the class is composed of peers and in the interest of learning keep any inappropriate comments out of the discussion. Should this become an issue it will be directly addressed with the violator along with related consequences in accordance with the CSUSB policies.

Policy on Plagiarism
The CSUSB Policy on Academic Honesty states: “Plagiarism and cheating are violations of the Student discipline Code (see Appendix of the CSUSB Catalogue of Programs) and may be dealt with by both the instructor and the Coordinator of Student Conduct. Plagiarism is the presentation, as one’s own, the ideas and writing of another. Plagiarism is academically dishonest and subjects the offending student to penalties up to and including expulsion. Students must make appropriate acknowledgments of the original source where material written or compiled by another is used.”

Commitment to Diversity
In our commitment to the furthering of knowledge and fulfilling our educational mission, California State University, San Bernardino seeks a campus climate that welcomes, celebrates, and promotes respect for the entire variety of human experience. In our commitment to diversity, we welcome people from all backgrounds and we seek to include knowledge and values from many cultures in the curriculum and extra-curricular life of the campus community. Dimensions of diversity shall include, but are not limited to the following: race, ethnicity, religious beliefs, sexual orientation, sex/gender, disability, socioeconomic status, cultural orientation, national origin, and age. (from the CSU San Bernardino University Diversity Committee Statement of Commitment to Diversity, 1995)
Statement of Reasonable Accommodation The College of Education faculty members support the American with Disabilities Act (ADA). Faculty members will provide reasonable accommodations to a student with a disability who is registered with the Office of Services to Students with Disabilities and who needs and requests accommodations. Reasonable accommodations may involve allowing a student to use an interpreter, note taker or reader. Accommodations may be needed during class sessions and for administration of examinations. The intent of the ADA in requiring consideration of reasonable accommodation is not to give a particular student an unfair advantage over other candidates, but simply to allow candidates with disabilities to have an equal opportunity to be successful. If you are in need of an accommodation for a disability in order to participate in this class, please let me know ASAP and also contact Services to Students with Disabilities at the Palm Desert Campus in RG-209 760-341-2883 x 78117 or at the San Bernardino Campus in UH-183 909-537-5238; ssd@csusb.edu

Course Calendar:
Session # & date Topic & Assignments
1 July 12 First Session – Face-to-face for Class Overview and Introduction of Microsoft Excel topic – Pivot Tables

2 July 19 Session Two – How to Modify the personal toolbar and Creating your first Pivot Table

3 July 26 Session Three – Including Report Filters, Column, & Row Headings for Pivot Tables

4 August 2 Session Four – Building a Meaningful Report & Modifying Selected Fields
Complete Disposition Rubric and Course survey
Submit all work not later than August 15th for full credit.