Course Syllabus
Overview
Students will acquire basic knowledge and skills in how to use spreadsheet software–a key application in accounting and business.
Program Message
This course provides an introduction to Microsoft Excel 2019 and 365 with an emphasis on learning how to use Microsoft Excel to solve business problems. This course is online, but it is not an independent study course. You can work as quickly as you like through the course, but must submit assignments by the published due dates. This is a 1-credit course.
Requirements
Prerequisites
There are no prerequisites for this course.
Required Resources
Students are required to purchase access to the MyEducator course.
Microsoft Excel, current version, is required for this course. The online version of Microsoft Excel will not work for this course. The application must be installed on students' computers. Microsoft Excel is available without charge through the University Store. Students should be aware that the Microsoft Office suite is available for both the Windows and Mac operating systems. Course materials can be configured to match the version of Excel you are using.
Structure
Course Outcomes
- Use the basic functions of Excel
- Use formulas and functions, including statistical, financial, logic, reference, date, time, and text functions
- Generate column, stacked, pie, and line charts
- Generate basic and advanced models using named ranges, what-if analysis, data tables, and circular references
- Use statistical analysis to generate model inputs
- Analyze data with pivot tables
- Perform optimization analysis using solver
Major Assignments and Course Standards
Students will be evaluated based on the criteria and weighting listed below. There are one or more lesson practice assignments which focus on individual skills taught in the lesson. The test your skills assignments are a combination of all of the skills taught in the lesson. All assignments and exams should be submitted prior to the time they are due. Assignments turned in late will be assessed a 10% penalty per day. All exams and assignments are open book. You may work with others in the course on assignments, but exams must be completed individually.
The MyEducator system has built-in features to make sure you are turning in your own work. Turning in another's work, copying and pasting from another, or providing your work to someone else to look at or copy is considered cheating and will result in a failing grade. Assignments can be turned in before the due date as many times as you want to get the score you desire. Assignments submitted late are assessed the penalty described above.
The exams required as part of this course are intended to allow the students to demonstrate their knowledge and skills in a practical application. Each exam covers the content of five lessons. You will be allowed two attempts at each exam. Your scores will be averaged.
| Major Assignment | Description | Course Outcome # | Weight |
|---|---|---|---|
| Exam 1 : Excel Basics Through Charting | This exam takes into account everything learned in Modules 01–06. | 1–3 | 30% |
| Exam 2: Basic Modeling Through Solver | This exam takes into account everything learned in Modules 08–13. | 4–7 | 30% |
| End-Of-Module Assessments | At the end of most modules, students have an assessment based on everything they have learned that lesson. | 1–7 | 20% |
| Practice Assignments | Practice assignments are found in most modules. They provide students the opportunity to practice what they are learning in preparation for the End-Of-Module Assessment, as well as the upcoming Exam. | 1–7 | 20% |
Module Patterns
Students are expected to spend three hours per week working on this class. Time required will depend highly on your familiarity with Excel. Some topics may go very fast, while others may take longer. There are demonstration videos, text, and assignments for all topics. Prior to requesting help from the instructor, all reading and demonstration videos should be completed.
NOTE: Set your time zone within user preferences so the dates and times for course activities will display correctly for your time zone.
Expectations
Feedback
You can expect to receive grades and feedback within seven days of the due date for all assignments.
Workload
See the Modules area of the course for a view of the workload. This varies from module to module.
Group Work
There is no group work in this course.
Extra Credit
There is no extra credit for this course.
Grading Scale
| Letter Grade | Percent |
|---|---|
| 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 |
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.
Course Summary:
| Date | Details | Due |
|---|---|---|