CIT 110: Introduction to Excel

Course Description

Introduction to Microsoft Excel 2016 with an emphasis on learning how to use Microsoft Excel to solve business problems.

Course Learning Outcomes

In this course, we will be:

  1. Creating and Editing Workbooks.
  2. Working with Formulas and Functions.
  3. Creating and Editing Charts.
  4. Importing, Creating Tables, Sorting and Filtering, and Using Conditional Formatting.
  5. Working with Multiple Worksheets and Workbooks.
  6. Using Advanced Functions.
  7. Setting Data Validation, Creating Forms, and Sharing and Protecting Workbooks.
  8. Using Decision-Making Tools and XML.
  9. Recording and Editing Macros.
  10. Customizing Excel and Using SkyDrive and Office Web Apps.

Required Materials

Directions for purchasing these materials will be found in the activities that you will complete during Lesson 1. Please note that you will begin using SIMNet for Office 2016 during Lesson 2, so you should complete the Lesson 1 activities and purchase the required materials as soon as possible.

Where do I Get Help?

This course uses specialized practices and resources that may require additional support not normally offered to other courses. As always, you have your Online Instructor as your first line of support.  

For individual help with your course work specifically, you may want to consider requesting a tutor at the Online Tutor Center

For more general support you always have access to the Online Support Center and IT Help Desk, though they may not be able to help with the specific technical support often needed for this CIT course.


Grades will be based on a weighted percentage of the total number of points students may earn from major exams, assignments, and completion of any other learning activities assigned by the instructor. You can find information in your I-Learn grade book on the different weighted grading categories and their percentages. You may check your progress in the course at any time by accessing the grade book. In assigning final grades for this course, the instructor will use the BYU-Idaho Standard Grade Definition criteria listed below.

A The grade of 'A' represents outstanding understanding, application, and integration of subject material and extensive evidence of original thinking, skillful use of concepts, and ability to analyze and solve complex problems. Demonstrates diligent application of Learning Model principles, including initiative in serving other students.

B The grade of 'B' presents considerable/significant understanding, application, and incorporation of the material, which would prepare a student to be successful in next level courses, graduate school, or employment. The student participates in the Learning Model as applied in the course.

C The grade of 'C' represents sufficient understanding of subject matter. The student demonstrates minimal initiative to be prepared for class. Sequenced courses could be attempted, but mastering new materials might prove challenging. The student participates marginally in the Learning Model.

D The grade of 'D' represents poor performance and initiative to learn, understand, and apply course materials. Retaking a course or remediation may be necessary to prepare for additional instruction in this subject matter.

F The grade of 'F' represents failure in the course.

Grading Scale

Course Policies

You should read the following course policies and make sure that you understand what these policies mean to you regarding your interactions with the instructor and other students in this course. If you have questions about any of these policies, you should contact your instructor immediately.

Personal Honor

In this class, our interactions with each other should be guided at all times by the following principles of personal honor.

Principles of Personal Honor-"True at all Times"

You should make sure that you understand the above principles of personal honor. It is important for all class members to strive to follow the above principles in our associations with one another.

If you have any questions about how Personal Honor is related to academic honesty or the university's dress and grooming standards, you may visit the University Standards web page (University Standards) to get more information.

Students with Disabilities 

BYU-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 Disabilities Services office by phone at 208-496-9210 or via email at 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 feel you have been unlawfully discriminated on the basis of disability, you may seek resolution through established policy and procedures. Contact the Human Resources Office at 208-496-1700 or via email at

Sexual Harassment

Title IX of the Education Amendments of 1972 prohibits sex discrimination against any participant in an educational program which 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 Human Resources Office at 208-496-1700 or via email at