CIT 110: Introduction to Excel


Course Description

Introduction to Microsoft Excel 2013 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.

Course Schedule

This course has been designed to follow a schedule in which students will complete an average of one week's activities per week. You are expected to complete all of the learning activities for each week in the order they are listed. Also, you should complete each week's activities in order and not skip ahead without finishing the current week. For example, you should complete all the learning activities in Week 01 before beginning any learning activities in Week 02. The instructor may shift the order of completion for some assignments, and may even extend the deadlines on a few assignments if circumstances warrant it for the whole class. 

Due dates and times for all assignments may be found by accessing the Calendar tool in I-Learn. In addition, all required assignments and tests have been set up to appear in the "Due Soon" list that you will see whenever you log into I-Learn. Also, all activity directions will have information on when the assignment or assessment opens and when it closes (due date and time). These due dates and times listed in the activity directions are based on Mountain Time in the United States of America, and are set up to be aligned with the due dates and times of students on campus at BYU-Idaho. If you are in a different time zone, you may see some adjustments for your own time zone in the I-Learn Calendar and Due Soon list. If you have any questions about when an assignment is due, you should contact your instructor. 

The deans of the colleges at BYU-Idaho have determined that the average amount of study time that students will put in per week per credit is 3-4 hours. So, for a 3-credit class, the deans expect students to spend on average between 9-12 hours of total study time. If you are new to Microsoft Excel, this course, on average, it will take students approximately nine hours of study time to complete all the learning activities assigned each week. This is the amount of time that you should expect to put into this class each week if you want to get a passing (C) grade. If you want a higher grade, you may need to put in more study time, maybe even beyond 12 hours per week. Students working towards an A or B grade will usually need to put in more study time than nine hours a week. Consequently, in order to keep up with the assignments and learn the most from this class, you should make sure you schedule about 1-2 hours a day to study for this class. Also, be aware that with this course, there is no "time off" for holidays that might occur during the week. Consequently, you should make sure to arrange your study schedule so that any holiday activities do not keep you from completing learning activities by the posted due dates and times.

Required Materials

Directions for purchasing all of these materials will be found in the activities that you will complete in the Course Introduction week. Please note that you will begin using SIMnet for Office 2013 during the first week of the course, so you should complete the Course Introduction week 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.

Grading

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 disabilityservices@byui.edu. 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 humanresources@byui.edu.

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 humanresources@byui.edu.