|
acres |
| View Comments (2) |
| * | Group - Dept | Status | Approved | Date Reviewed | Reviewer | Comments |
|---|---|---|---|---|---|---|
| 1 | Curriculum Routing - CIS Computer Information Systems | Completed | Approved | 10/25/2021 | Julie Napier | The prerequisite needs to reflect the current testing used by MCC. COMPASS testing hasn't been used in several years. |
| 2 | First review: Curricular and Non-curricular - CIS Computer Information Systems | Completed | Approved | 10/28/2021 | Dieringer, Stephanie | |
| 3 | Curriculum and Assessment - CIS Computer Information Systems | Completed | Approved | 11/15/2021 | Mitzi Esgro | |
| 4 | Advising and Testing - CIS Computer Information Systems | Completed | Approved | 11/17/2021 | Natalie Gebicke | CHANGED BY M.E. AND APPROVED. Pre-reque wording reflects outdated Accuplacer scoring, and not the Next Gen Accuplacer. I recommend the wording should include what is reflected in the current catalog: "This course requires successful completion of PCS 021 to enroll, or appropriate placement exam score. |
| 5 | Registrar's Office - CIS Computer Information Systems | Completed | Approved | 11/22/2021 | Morgan Wilson | No issue at this time. |
| 6 | Financial Aid - CIS Computer Information Systems | Completed | Approved | 11/23/2021 | Downey, Lisa | |
| 7 | Curriculum Committee - CIS Computer Information Systems | Completed | Approved | 12/08/2021 | Mitzi Esgro | |
| 8 | Curriculum and Assessment (Second Review) - CIS Computer Information Systems | Completed | Approved | 12/08/2021 | Mitzi Esgro | |
| 9 | Catalog and Articulation - CIS Computer Information Systems | Completed | Approved | 12/09/2021 | Julie Napier |
| Originator: | Burgess, Peter Status: Approved Department: CIS Computer Information Systems |
| Date Created: | 10/23/2021 Submitted: 10/23/2021 Completed: 12/09/2021 To ACETS: |
| Course Prefix: | CIS |
| Course Number: | 136 |
| Previous Course Prefix/Number if changed: | |
| Course Information: | Course Modification to an existing course |
| Effective Semester: | Fall |
| Effective Academic Year: | 2022-2023 |
| Course Full Title: | Microsoft Excel |
| Program Modification Required?: | No |
| If yes, list the degree or certificate: | |
| Course Impact?: | No |
| If yes, list the degree or certificate: | |
| Reason for Evaluation: | 5-Year Course Review |
| Mode of Instruction: | traditional online plural |
| If other, please explain: | |
| Catalog Course Description: | Learn to use Microsoft Excel to manage financial calculations, as well as to work with formulas, charts and graphics to develop a professional worksheet. This course prepares students to take the Microsoft Office Specialist (MOS) Excel Exam. |
| Prerequisite(s): | This course requires successful completion of PCS 021 to enroll, or appropriate placement exam score. |
| Corequisite(s): | |
| Previous Credit (Total): | 3 |
| Previous Lecture Hours: | 3 |
| Previous Lab Hours: | 0 |
| Previous Clinical Hours: | 0 |
| Internship: | 0 |
| Externship: | 0 |
| New Credit Hours (Total): | 3 |
| New Lecture Hours: | 3 |
| New Lab Hours: | 0 |
| New Clinical Hours: | 0 |
| Internship/Externship: | 0 |
| Explanation of proposed modifications to course: | Five Year Review. Minor wording changes to better reflect the current course being taught. |
| Contact person/email: | pburgess@mohave.edu |
| SUN Course?: | No |
| If yes, please provide the established SUN number: | |
| Is this an AGEC course: | No |
| Articulated?: | Yes |
| Transfer?: | NAU |
| Course Learning Outcomes: | 1. Design workbooks to solve organizational needs of data storage, analysis, and decision-making. (2,3,6)
2. Perform calculations and What-If Analysis through the use of formulas and functions for a variety of organizational scenarios. (3,5,6) 3. Demonstrate various formatting options in worksheets to display conclusive information from the data. (2,3,6) 4. Create, modify, and present graphical objects, including charts and graphical elements, to illustrate numerical data within the worksheet. (2,3,6) 5. Manipulate viewing of data within the worksheet with enhanced functionality to increase decision making capability. (2,3,6) 6. Automate repetitive tasks and enable template-based worksheets by developing macros. (3,6) 7. Integrate worksheets and workbooks to share data used in calculations to reduce data-entry errors by reducing redundancy. (3,6) |
| Course Competencies and Objectives OR Course Competencies and Outline: | Course Competencies: Competency 1 Create and name a worksheet and use Excel menus and toolbars to navigate between worksheets.
Objective 1.1 Enter text, numbers, formulas, and functions that enable the worksheet to organize, calculate, and compile required data. Objective 1.2 Save workbooks in the proper format based on future usage including the use of templates and alternate file types. Objective 1.3 Navigate between workbooks and worksheets using the mouse and/or keyboard shortcuts. Competency 2 Design worksheet layouts and use formulas and functions to perform calculations. Objective 2.1 Use statistical functions including MIN, MAX, MEDIAN, AVERAGE, COUNT, and SUM in a worksheet. Objective 2.2 Prepare financial data and functions to calculate payments, future values, and Interest. Objective 2.3 Use relative and absolute references to successfully copy and move formulas and functions. Objective 2.4 Create an IF function to perform calculations dependent on formula arguments. Competency 3 Utilize Excel functionality to format worksheets. Objective 3.1 Change font type, size, style, and color of values within cells and conditional formatting. Objective 3.2 Use AutoFormat to change cell borders and backgrounds. Objective 3.3 Add headers and footers to worksheets. Objective 3.4 Set page breaks and print areas. Competency 4 Create charts and graphs with appropriate formatting. Objective 4.1 Develop data visualization using the Chart Wizard based upon appropriate data. Objective 4.2 Establish chart and graph elements including the legend, title, series, and backgrounds. Objective 4.3 Develop a three-dimensional chart and use color formatting options for emphasis. Competency 5 Create tables, lists, and charts and sort and filter data. Objective 5.1 Create a list using filters to view specific data. Objective 5.2 Sort data using multiple fields in a worksheet. Objective 5.3 Design a Pivot Table to organize data into categories and produce a dynamic report or chart. Competency 6 Consolidate data in multiple worksheets. Objective 6.1 Create a Lookup Table to reference data in common with multiple worksheets. Objective 6.2 Reference cells and ranges located in other worksheets or workbooks to be used in formulas or functions. Objective 6.3 Transport data from worksheets into other workbooks. Competency 7 Use editing tools to view, audit, trace, and fix errors. Objective 7.1 Define precedent cells and use GUI tools to trace cell references in functions and formulas. Objective 7.2 Split and freeze panes in large worksheets. Objective 7.3 Add comments to cells for editing and explanations. Competency 8 Design an Excel Macro. Objective 8.1 Record and run a Macro to consolidate operations in a worksheet. Objective 8.2 Edit an existing Macro to adjust changes in a worksheet using a Visual Basic editor. Objective 8.3 Create a Macro button in a worksheet. Competency 9 Run scenarios on worksheet data to develop solutions to predict outcome variables. Objective 9.1 Use Scenario Manager to perform a What-If Analysis. Objective 9.2 Create a Scenario Summary and Pivot Table report. Objective 9.3 Install Solver utility and create an answer report. Competency 10 Import data from other applications into Excel. Objective 10.1 Import text using Text Wizard. Objective 10.2 Import data from a database into a spreadsheet. Objective 10.3 Define XML file formats and import web data into a spreadsheet. Competency 11 Create customized Toolbars and Menus Objective 11.1 Create a Message Box. Objective 11.2 Develop a customized toolbar. Objective 11.3 Insert graphics to create screen elements in a spreadsheet. |