Overview

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

Requirements

Required Resources

Directions for purchasing these materials will be found in the activities that you will complete during Week 01. Please note that you will begin using SIMNet for Office 2021 during Week 02, so you should complete the Week 01 activities and purchase the required materials as soon as possible.

The 3rd party program we use to learn Excel is called “SIMNet”. When you register for CIT 110, you’ll be registered for the SIMNet program as well.

The required material for this course is low cost Auto Access tool called Simnet. Access the material(s) using the link provided in the Textbook Access module of this course. You will be automatically charged, in your student account, for the digital materials(s) on the first day of the semester. If you do not want to use the SimNet, you must opt-out or you will be charged for the material(s). If you drop the course, you will be refunded within 24 hours. The last day to receive a refund for Auto Access is the W-drop date which occurs in Week 04 of the semester. Learn about Auto Access and learn how to opt out: BYU-I Auto Access. There is an option to opt-out of Auto Access materials on your Book List.

You cannot complete this course without using SimNet. To prepare for SIMnet, read through and follow the instructions on the W01 Prepare: SIMnet page.

Structure

Course Outcomes (CO)

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.

Major Assignments

The table below is meant to help you see the relevance of each major assignment as it pertains to the course outcomes (CO).

Major Assignment	Description	CO#
W13 Project: Final	Complete the worksheet with the knowledge acquired this semester	1.2.3.4
W13 Exam: Final	Complete the Simnet final test	1.2.3.4

Weekly Patterns

The table below displays typical weekly activities, due dates, and activity descriptions.

Due Date*	Learning Model	Activity Title	Description
Midweek	Prepare. Prove	Chapter Assignment	Learn and practice the features with Simnet
Midweek	Prepare. Prove	Chapter Assignment 2	Learn and practice the features with Simpath
End of Week	Prove	Exam	Prove your understanding of the concepts of this week
End of Week	Prove	Project	Work on the project using the knowledge of this week.
End of Week	Teach One Another	Support Forum	Post questions and answers regarding the course or SIMnet

*Set your time zone within user preferences so the dates and times for course activities will display correctly for your time zone.

Expectations

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

Letter Grade	Percentage Range
A	100% –93%
A-	92% – 90%
B+	89% – 87%
B	86% – 83%
B-	82% – 80%
C+	79% – 77%
C	76% – 73%
C-	72% – 70%
D+	69% – 67%
D	66% – 63%
D-	62% – 60%
F	below 59%

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"

• Personal honor is integrity in fulfilling commitments, responsibilities, and covenants.
• Personal honor begins with willing obedience and is fully developed when we consistently govern ourselves by true principles.
• Personal honor increases spiritual strength through the ministry of the Holy Ghost.
• Personal honor is central to every aspect of our lives, including the BYU-Idaho experience.
• Personal honor brings us joy and happiness; deepens our desire to love, serve, and lift others; and ultimately helps us to become more like the Savior.

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.

University Policies

Students with Disabilities

Brigham Young University-Idaho is committed to providing a working and learning atmosphere that accommodates qualified persons with disabilities. If you have a disability and require accommodations, please contact the Disability Services Office at (208) 496-9210 or visit their website and follow the Steps for Receiving Accommodations. Reasonable academic accommodations are reviewed for all students who have qualified documented disabilities. Services are coordinated with students and instructors by the Disability Services Office.

This course may require synchronous meetings. If you are currently registered with the Disability Services Office and need an interpreter or transcriber for these meetings, please contact the deaf and hard of hearing coordinator at (208) 496-9219.

Other University Policies

Student Honor and Other Policies

Please read through the document called University Policies. It gives important information about the following topics:

• Student Honor
  • Academic Honesty
  • Student Conduct
    • Sexual Harassment
• Student with Disabilities
• Complaints and Grievances
• Copyright Notice

Go to the Student Resources module to review further resources and information.

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.