Back |
Credit Hours: 3 Effective Term: Fall 2016 SUN#: None AGEC: None |
Credit Breakdown: 2 Lectures, 3 Labs Times for Credit: 1 Grading Option: A, B, C, D, F Cross-Listed: |
Measurable Student Learning Outcomes |
---|
1. (Application Level) Apply custom styles, and advanced conditional and logical functions to data in the workbook.
2. (Application Level) Use Text, conditional formatting, Lookup and TRANSPOSE functions to manipulate data. 3. (Application Level) Apply advanced date and time functions like NOW and TODAY to serialize dates and times. 4. (Application Level) Implement data collaboration and security techniques to Share, Distribute and Secure workbooks using Three-dimensional formulas, linking, data entry validation, and track changes to share and manage workbooks. 5. (Application Level) Use Analytical options such as Goal Seek, Solver, and Scenario Manager to perform -What If- Analysis. 6. (Synthesis Level) Create One- and Two- variable Data Tables to perform -What If- Analysis. 7. (Synthesis Level) Create advanced charts with trendlines, dual axis and chart animations. 8. (Synthesis Level) Create PivotTables and PivotCharts - modify field selections and options, create a slicer, group records, utilize calculated fields, format data, utilize PowerPivot, and manage relationships to show supplied data in a different view. 9. (Synthesis Level) Create macros - record, edit, and run macros for a given repetitive task. 10. (Synthesis Level) Create advanced formulas that utilize the IF function in conjunction with other functions, utilize AND/OR functions, utilize nested functions, utilize SUMIFS, AVERAGEIFS, and COUNTIFS functions. |
Internal/External Standards Accreditation |
Microsoft Office Specialist (MOS) 2013 Excel Expert Exam standards can be found at the following links:
Part 1 - Exam 77-427 -- https://www.microsoft.com/learning/en-us/exam-77-427.aspx Part 2 - Exam 77-428 -- https://www.microsoft.com/learning/en-us/exam-77-428.aspx |