The information listed below is subject to change. Please review the course syllabus within your online course at the start of class.
The competencies you will demonstrate in this course are as follows:
Outcomes | Competencies | |
---|---|---|
1 | Understand the layout, elements, and purpose of Excel. | A, B, D |
2 | Determine values using formulas and functions. | A, B |
3 | Demonstrate abilities to select, move, copy, paste, and auto-fill cells. | A, B |
4 | Modify cell references types (absolute, relative, mixed) to produce desired results. | C |
5 | Understand functions for required calculations and diagnosing errors. | C |
6 | Develop named ranges and use within functions and formulas. | A, C |
Outcomes | Competencies | |
---|---|---|
1 | Determine chart types to use for desired results. | E |
2 | Create graphs and charts for desired results. | E |
3 | Manipulate graph and chart elements to customize view. | F |
4 | Use tables and data-sets to customize large volume of data. | E |
5 | Employ conditional formatting rules to highlight specific data. | E |
6 | Employ filters and sorts to enhance table data. | F |
Outcomes | Competencies | |
---|---|---|
1 | Utilize Date and Time Functions. | H |
2 | Format Cell Styles and 3D References. | G |
3 | Develop a table for organized data sets. | E |
4 | Utilize specialized functions and fields. | G |
5 | Make use of Conditional Formatting. | E |
Outcomes | Competencies | |
---|---|---|
1 | Create templates. | D |
2 | Make use of graphics. | E |
3 | Import data. | G |
4 | Develop PivotTables and PivotCharts. | G |
Outcomes | Competencies | |
---|---|---|
1 | Show how to find and fix errors. | I |
2 | Develop data validation rules for easier user completion. | I |
3 | Make use of Solver and Scenario. | I |
4 | Make use of Power Pivots, Data Models, and other data tools. | J |
5 | Apply the basics of Macros. | J |
6 | Make use of the advanced features of Excel for future consideration. | J |
7 | Experiment with multiple users on a single workbook. | D |
For every credit hour, students should plan to spend an average of 2-3 hours per week for course-related activities in a 15-week course. For example, a 3 credit hour course would average an average 6-9 hours per week to read/listen to the online content, participate in discussion forums, complete assignments, and study the course material. For 10 and 6-week courses, the amount of time per week will be higher so all course competencies, module outcomes, and assignments will be covered.
Aside from typical reading assignments, this course has the following (Please Note: This list is subject to change based on the discretion of the instructor facilitating this course.):
Mark all Module due dates on your calendar for this class. You may submit assignments AHEAD of schedule. Late assignments will not be accepted without prior approval.
Assignment | Points | % |
---|---|---|
Discussions (5 @ 20 points each) | 100 | 9% |
SAM Assignments (11 @ 10 points each) | 110 | 10% |
SAM Projects (11 @ x 50 points each) | 550 | 51% |
Capstone Projects (3 @ 100 points each) | 300 | 30% |
TOTAL | 1060 | 100% |
A = 90 to 100% | B = 80 to 89% | C = 70 to 79% | D = 60 to 69% | F = 59% and below |
CCCOnline goes to great lengths to assure the quality of your online learning experience. You can expect the following from our courses: