Advanced Excel

Course Details

Course Number
Section Number
Spring 2016
Jiaxi Jesse Luo (view Profile)

Course Objectives

This course seeks to teach students skills to manipulate and analyze data more efficiently with spreadsheets. Spreadsheets, especially, Microsoft Excel, are commonly used by managers to summarize and analyze data for decision making. The activities in this course offer practical and hands-on experience with Excel which can be immediately applied to everyday business problems. This is not an introductory course on Excel functions and formulas. Rather, we will cover many advanced and little-known features that are only taught in expensive commercial seminars. 

Course Expectations

Learning Goals


I.      General Learning Goals:   


·       Our students will be effective at problem solving and decision making.

Objective: Our graduates will demonstrate problem solving and decision making abilities through the critical analysis, evaluation, and interpretation of business information.


·       Our students will be effective communicators.

Objective: Our graduates will be able to demonstrate a competency in speaking and writing for common business scenarios.

2a: Our graduates will be able to demonstrate a competency in speaking for common business scenarios.

2b: Our graduates will be able to demonstrate a competency in writing for common business scenarios.


·       Our students will be technologically prepared.

Objective: Our graduates will be able to utilize available technology for business applications.


·       Our students will be ethical decision makers.

Objective: Our graduates will demonstrate ethical reasoning skills within a business environment.


·       Our students will be effective team members.

Objective: Our graduates will know how to use team building and collaboration to achieve group objectives.


·       Our students will be multicultural and globally aware.

Objective: Our graduates will have an understanding of the influence of global and multicultural issues on business activities.


These general learning goals are among those established by the Dillard College of Business Administration.  General learning goals represent the skills that graduates will carry with them into their careers.  While assessing student performance in obtaining these general learning goals, the Dillard College is assessing its programs.  The assessments will assist us as we improve our curriculum and curriculum delivery. 


II.     Course Specific Learning Goals:  After completing this course, students should be able to:


Upon successful completion of this course, the students will be familiar with using Excel to complete data-intensive tasks, including (but not limited to):

·      Analyzing data across different dimensions using pivot table and chart.

·      Looking up and comparing records efficiently.

·      Importing and cleaning data from external sources.

·      Evaluating different outcomes by changing assumptions.

·      Automating routines with macros.

Grading Standards

Grading Policy

The evaluation of student performance is based on class participation, 12 assignments, and 2 exams. The weights for these items are listed below.

Items and Weights

Class Participation




Exam 1


Exam 2





The final grades will be given based on the following table:

Course Grade

Total Score ()







To earn an A, an average student is expected to invest at least 3 hours per week in this course. The instructor reserves the rights to curve the grades, offer extra credits to every student, and/or modify grades based on the overall class performance.

Incompletes will be given as described in the attached university policies.


Class Participation

Class participation is an important part to evaluate a student’s engagement in this online course. It is evaluated based on the online discussion activities. There are 12 discussion topics in the discussion forum on our D2L course website. Students are required to posted questions related to the discussion topics and/or answer other students’ questions in the online discussion. Credit will be given if a student post at least 1 message for each two discussion topics within the specific timelines. The timelines for online discussion can be found in the calendar on our D2L course website.



As this course focuses on practical tools, hands on experience is extremely important. The students will be given an assignment for each topic in this course. The assignments are not simple repetitions of the lecture video contents. Students are expected to complete the assignment by creatively using contents learned from the lecture videos. All completed assignments are to be uploaded to the D2L Dropbox for evaluation.



The exams will cover all course contents up to the exam date. Exam 1 will cover Course Topics 1 – 6. Exam 2 will cover all course topics, with an emphasis on the contents after Exam 1 (over 90%). In an exam, the students are instructed to complete a few Excel tasks on a computer within given time. The exams are open-book, open-notes, and open-Internet, but strictly individual work. The schedule of exams can be found on the last page of the course syllabus, as well as in the D2L calendar. 

Final Exam


Submission Format Policy

Note: You may not submit a paper for a grade in this class that already has been (or will be) submitted for a grade in another course, unless you obtain the explicit written permission of me and the other instructor involved in advance.

Plagiarism Policy

Plagiarism is the use of someone else's thoughts, words, ideas, or lines of argument in your own work without appropriate documentation (a parenthetical citation at the end and a listing in "Works Cited")-whether you use that material in a quote, paraphrase, or summary. It is a theft of intellectual property and will not be tolerated, whether intentional or not.

Student Honor Creed

As an MSU Student, I pledge not to lie, cheat, steal, or help anyone else do so."

As students at MSU, we recognize that any great society must be composed of empowered, responsible citizens. We also recognize universities play an important role in helping mold these responsible citizens. We believe students themselves play an important part in developing responsible citizenship by maintaining a community where integrity and honorable character are the norm, not the exception.

Thus, We, the Students of Midwestern State University, resolve to uphold the honor of the University by affirming our commitment to complete academic honesty. We resolve not only to be honest but also to hold our peers accountable for complete honesty in all university matters.

We consider it dishonest to ask for, give, or receive help in examinations or quizzes, to use any unauthorized material in examinations, or to present, as one's own, work or ideas which are not entirely one's own. We recognize that any instructor has the right to expect that all student work is honest, original work. We accept and acknowledge that responsibility for lying, cheating, stealing, plagiarism, and other forms of academic dishonesty fundamentally rests within each individual student.

We expect of ourselves academic integrity, personal professionalism, and ethical character. We appreciate steps taken by University officials to protect the honor of the University against any who would disgrace the MSU student body by violating the spirit of this creed.

Written and adopted by the 2002-2003 MSU Student Senate.

Students with Disabilities

The Americans with Disabilities Act (ADA) is a federal anti-discrimination statute that provides comprehensive civil rights protection for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the Disability Support Services in Room 168 of the Clark Student Center, (940) 397-4140.

Safe Zones Statement

The professor considers this classroom to be a place where you will be treated with respect as a human being - regardless of gender, race, ethnicity, national origin, religious affiliation, sexual orientation, political beliefs, age, or ability. Additionally, diversity of thought is appreciated and encouraged, provided you can agree to disagree. It is the professor's expectation that ALL students consider the classroom a safe environment.

Contacting your Instructor

All instructors in the Department have voicemail in their offices and MWSU e-mail addresses. Make sure you add your instructor's phone number and e-mail address to both email and cell phone lists of contacts.

Writing Proficiency Requirement

All students seeking a Bachelor's degree from Midwestern State University must satisfy a writing proficiency requirement once they've 1) passed the 6 hours of Communication Core and and 2) earned 60 hours. You may meet this requirement by passing either the Writing Proficiency Exam or English 2113. Please keep in mind that, once you've earned over 90 hours, you lose the opportunity to take the $25 exam and have no option but to enroll in the three-credit hour course. If you have any questions about the exam, visit the Writing Proficiency Office website at, or call 397-4131.

Campus Carry

Senate Bill 11 passed by the 84th Texas Legislature allows licensed handgun holders to carry concealed handguns on campus, effective August 1, 2016. Areas excluded from concealed carry are appropriately marked, in accordance with state law. For more information regarding campus carry, please refer to the University’s webpage at

If you have questions or concerns, please contact MSU Chief of Police Patrick Coggins at