CIT 110: Introduction to Excel
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:
- Creating and Editing Workbooks.
- Working with Formulas and Functions.
- Creating and Editing Charts.
- Importing, Creating Tables, Sorting and Filtering, and Using Conditional Formatting.
- Working with Multiple Worksheets and Workbooks.
- Using Advanced Functions.
- Setting Data Validation, Creating Forms, and Sharing and Protecting Workbooks.
- Using Decision-Making Tools and XML.
- Recording and Editing Macros.
- Customizing Excel and Using SkyDrive and Office Web Apps.
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.
- Required Course Material - McGraw-Hill SIMnet Program
- SIMNet Widget - When you open up I-Learn and go to our CIT 110 course, you will see a widget (an application added to I-Learn) on the bottom right of the home screen. See below:
- Create a SIMnet Account - If you don't already have a SIMnet account, you will need to create one. (If you already have an account, just log in). Here are the steps to create your account:
- Select "No" if you do not already have a SIMnet account.
- Enter your information.
- First Name and Last Name should be already be added
- Enter your school email address.
- Enter a SIMnet username.
- Enter your student ID number.
- Enter a password for SIMnet.
- Confirm your password.
- Read and click that you have read the Terms and Conditions.
- Click Create (you may need to scroll to see the button). Once all of the fields are completed, the Create button activates and turns blue.
- You may now begin to use SIMNet. Click Continue to SIMNet to get started.
- Once you click Continue, it may take it a few seconds to load. Once it does, scroll down in the widget to see all of the course activities.
- Laptop or Desktop computer.
- Internet Connection
- You can use SIMnet/SIMgrader on any computer that meets the System Requirements.
- You can register for SimNet following the instructions in this guide: StudentRegistrationGuide.pdf
- You should also review this Getting Started Overview.pdf.
- Auto Access
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.
- 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 = 59% and lower
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.
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.
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 firstname.lastname@example.org. 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 email@example.com.
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 firstname.lastname@example.org.