Syllabus
CIT 140 – Doing Business with Excel
Textbook: |
MIS Cases: Decision Making with Application Software, 3rd Edition ISBN 0-13-221438-5 |
Course Description:
This course is designed to help you learn to use excel to solve real life business problems. The class consists of a series of business cases to help you do this. You will need to think about the business situation presented in the case in order to solve the problem. Excel is the tool you will use to help you solve these problems and communicate the solution.
Course Content and Topics:
- Using Excel Functions
- Formatting Excel to communicate Effectively
- Manipulating Data to Understand it
- Preparing Solutions for Printing
- Working with Multiple Files
- Displaying Data Effectivly
- Working with Excel More Efficiently
- Business Income Statements
- Doing Inventory Analysis
- Understanding and Communicating Statistical Data
- Using Excel to find Optimal Solutions
Course Objective:
Labs:
There are 3 labs with Excel installed on the computers in the Smith building(Rooms 442, 453, and 476). Lab assistants are available there during the times posted outside the lab to help you understand how to use Excel. They are not there to solve your case for you. If you ask an Excel question they will be more than happy to help you. Helping you understand the business cases is my job. Please ask your questions in class or in my office regarding the case.
Videos are also available to help you learn how to do things in Excel. They can be found by clicking on the links for the cases at the top of this page.
Grading:
Your grade is based on 2 major components:
- (25%)The quality and quantity of your participation in class and group discussions for each case.
- (75%)The quality of the work done to satisfy each case.
There are no tests. You will be graded on what you know, understand, and what you can do.
For each assignment you will:
- Study the new Excel information and discuss it with your cohort and the entire class.
- Study the new case and discuss it with your cohort and with the entire class
- Complete the deliverables for the cohort case.
- Complete a quiz case on your own.
Your success in this course will depend to a large degree on your ability to communicate with your classmates, think, and discover.
It is expected that you will share ideas with your cohort as well as others however you may not share portions of deliverables or complete deliverables with other cohorts. You may not share your quiz case work with you classmates, students in other sections, or those who may take the class after you. To do so will be considered cheating and will result in a failing grade for all of the people involved.
Share ideas. Share cohort work. Do your quiz work by yourself.
While you are completing your quiz case you may not speak to anyone nor lookup anything. This is a quiz type case. If you choose to talk with others or use other cases or other information not included in the quiz case it is cheating and will results in a failing grade for the class.
Assignemnts:
There area 10 assignments throughout the course. In each assignment new concepts and ideas await your discovery. You will need to do some research prior to the cohort and classroom discussions for each assignment. References will be given to you that will help you start your research.
Homework Assignments:
Home work consists of whatever may be necessary for you to complete all of the cases. This may included working with your cohort on a cases, meeting with your cohort to discuss the new Excel concepts, meeting with your cohort to discuss the cases.
Harassment:
Title IX of the Education Amendments of 1972 prohibits sex discrimination against any participant in an education program or activity that receives federal funds, including Federal loans and grants. Title IX also covers student-to-student sexual harassment. If you encounter unlawful sexual harassment or gender based discrimination, please contact the Personnel Office at 496-1130.
Disability:
Brigham Young University-Idaho is committed to providing a working and learning atmosphere which reasonably accommodates qualified persons with disabilities. If you have any disability which may impair your ability to complete this course successfully, please contact the Services for Students with Disabilities Office, 496-1158. Reasonable academic accommodations are reviewed for all students who have qualified documented disabilities. Services are coordinated with the student and instructor by this office. If you need assistance or if you feel you have been unlawfully discriminated against on the basis of disability, you may seek resolution through established grievance policy and procedures. You should contact the Personnel Office at 496-1130.
Counsel from President Hinckley:
“This is the great day of decision for each of us. For many it is the time of beginning something that will go on for as long as you live. I plead with you: don’t be a scrub! Rise to the high ground of spiritual, mental, and physical excellence. You can do it. You may not be a genius. You may be lacking in some skills. But so many of us can do better than we are now doing. We are members of this great Church whose influence is now felt over the world. We are people with a present and with a future. Don’t muff your opportunities. Be excellent.” The Quest for Excellence, Ensign, Sep 1999
“And finally, in all of living have much of fun and laughter. Life is to be enjoyed, not just endured.” Stand True and Faithful, Ensign, May 1996
