Advanced Microsoft Excel

BIT262 : Advanced Microsoft Excel

General Information

Discipline(s)

Modesto Junior College

Course Outline of Record Report

12/01/2021 _{ }

Faculty Author: Kevin Alavezos

Backlund, Nancy

Attachments: class-capacity_262_Advanced Microsoft Excel 9-08-2021.pdf

BSOT 132.pdf Download



Course Code (CB01) : BIT262

Course Title (CB02) : Advanced Microsoft Excel

Department: Business Information Technology

Proposal Start Date: MJC Fall 2023

TOP Code (CB03) : (0514.00) Office Technology/Office Computer Applications CIP Code: (52.0401) Administrative Assistant and Secretarial Science, General

SAM Code (CB09) : Advanced Occupational

Distance Education Approved: No

Course Control Number (CB00) : No value Curriculum Committee Approval Date: Pending Board of Trustees Approval Date: Pending

External Review Approval Date: Pending

Course Description: Provides an advanced understanding of spreadsheets using Microsoft Excel. Data Tables, scenario management, importing and exporting data, enhancing with Visual Basic applications and modifying Excel default settings are covered. Concluded the preparation for the Microsoft Office Specialist Expert Excel certification exam.

Proposal Type: New Course

Part of CCC Model Curriculum for Business Information Worker.

Faculty Author: No value

Master Discipline Preferred: No value

Bachelors or Associates Discipline Preferred: Office Technologies (Secretarial skills, office systems, word processing, computer applications, automated office training)

Course Coding

Basic Skill Status (CB08)

Course is not a basic skills course.

Course Special Class Status (CB13) Course is not a special class.

Allow Students to Gain Credit by Exam/Challenge

Repeatability 0

Course Prior To College Level (CB21) Not applicable.

Rationale For Credit By Exam/Challenge Skills knowledge could be demonstrated by passing the Microsoft Office Specialist (MOS) exam at the Expert level.

Type of Repeat No value

Allow Students To Audit Course

Course Support Course Status (CB26) No value

Associated Programs

Grading A-F Only

Course is part of a program (CB24)

Associated Program Award Type Active

Business Information Technology Level 2 (In

Development) Certificate of Achievement MJC Fall 2023

Business Information Technology Level 2 (In

Development) A.S. Degree MJC Fall 2023

✔

✔

✔

Transferability & Gen. Ed. Options

Field Trips

Comparable Lower-Division Courses at UC/CSU v2

Course General Education Status (CB25) Y

Transferability Transferable to CSU only

Transferability Status Pending

C-ID: California's Course Identification Numbering System

Categories Status Approval Date Rationale (include Comparable Course, C- ID Descriptor, etc. if applicable.

Office Technology/Business

Information Worker (BIT) *CCC (BIT) *CCC Pending No value C-ID: BSOT 132X

Field trips are required.

Yes No Maybe

Courses numbered 100-299 require identification two comparable lower-division courses from CSU or UC from the current institutional catalog (not schedule). At least one course from CSU, and if requesting/maintaining UC general elective transfer, one course from UC.

Please identify the CSU campus offering this course. (Term type is indicated in parentheses) San José State University (SEM)

CSU Catalog Year 2020-2021

Provide the CSU course code (e.g., ENGL 1A) from the most current official Catalog (not schedule). Curriculum changes each year.

BUS2 195A

CSU Course Title Spreadsheet Modeling

Does course-to-course or lower-division, "major prep" articulation with this course exist for this academic year?

No

Select the institution that offers the second comparable course from CSU or UC. If seeking or maintaining UC transferability, you must supply a UC campus. (Term type is indicated in parentheses)

CSU, Chico (SEM)

CSU/UC Catalog Year 2020-2021

Provide the CSU course code (e.g., ENGL 1A) from the most current official Catalog (not schedule). Curriculum changes each year.

BSIS 102

CSU Course Title Spreadsheets and Graphics

Does course-to-course or lower-division, "major prep" articulation with this course exist for this academic year?

No

Select the institution that offers the third comparable course from CSU or UC. If seeking or maintaining UC transferability, you must supply a UC campus if not already provided above. (Term type is indicated in parentheses)

No Value

CSU/UC Catalog Year No Value

Provide the CSU/UC course code (e.g., ENGL 1A) from the current official Catalog (not schedule). Curriculum changes each year.

No Value

CSU Course Title No Value

Does course-to-course or lower-division, "major prep" articulation with this course exist for this academic year?

No Value

Units and Hours

Summary

Minimum Credit Units (CB07) 1 Maximum Credit Units (CB06) 1 Total Course In-Class

(Contact) Hours 36

Total Course Out-of-Class

Hours 18

Total Student Learning Hours 54

Credit / Non-Credit Options

Course Credit Status (CB04) Credit - Degree Applicable

Course Non Credit Category (CB22) Credit Course.

Non-Credit Characteristic

No Value

Prerequisites, Corequisites, and Advisories

Requisite Skills

Units and Hours - Weekly Specialty Hours

Course Classification Code (CB11) Credit Course.

Funding Agency Category (CB23) Not Applicable.

Cooperative Work Experience Education Status (CB10)

Variable Credit Course

Weekly Student Hours Course Student Hours

In Class Out of Classs

Lecture Hours 0.5 1

Laboratory

Hours 1.5 0

Activity Hours 0 0

Course Duration (Weeks) 18 Hours per unit divisor 52.5 Course In-Class (Contact) Hours

Lecture 9

Laboratory 27

Activity 0

Total 36

Course Out-of-Class Hours

Lecture 18

Laboratory 0

Activity 0

Total 18

Time Commitment Notes for Students

No value

Activity Name Type In Class Out of Class

No Value No Value No Value No Value

Prerequisite

BIT261 - Intermediate Microsoft Excel (in-development)

Requisite Skills Description

Specifications

Demonstrate intermediate level of Excel

features. BIT 261 - Demonstrate the use of problem-solving principles by using intermediate level features to develop spreadsheets that incorporate functional business principles.

BIT 261 - Plan, organize, and build a worksheet, using commands, tabs, and keystrokes.

BIT 261 - Construct formulas and use the built-in Function features to produce Excel tables and Pivot Tables that include filtering and summary statistics.

BIT 261 - Plan, create, format, add, and delete table data.

Methods of Instruction

Methods of Instruction (Typical) INSTRUCTIONAL METHODS

MOI 1. Guided practice utilizing textbook and software

2. Tutorial videos demonstrating software skills 3. Application and use of software in a work setting 4. Course content lecture

5. Student-to-student discussions on the application of software tools 6. Drills and practice in the application of software procedures

Assignments (Typical)

Evidence of Workload for Course Units (Quantity) 1. Daily reading and/or watching course material 2. Weekly homework

3. Weekly lab assignments 4. Student-to-student discussions 5. Weekly quizzes

6. Two exams per term 7. Project once per term

Evidence of Critical Thinking (Quality)

1. Generate a data table, using the applicable cells, that shows the effect of varying interest rates and loan terms on monthly payments.

2. Given a payroll worksheet, create a macro to be used each week that will format the worksheet, calculate the total weekly hours, and determine if there were overtime hours for the week.

3. Based on an employer request, customize a worksheet with themes and formatting that will become a template for consistent company use.

4. To maintain a budgeted revenue amount, utilize a what-if analysis to determine which price would be best on specific products.

Methods of Evaluation (Typical) Rationale

FORMATIVE EVALUATION 1. Homework/lab assignments

2. Student-to-student discussions 3. Quizzes

4. Exam

SUMMATIVE EVALUATION 1. Final Project

2. Comprehensive Exam 1. Objective 2. Hands-on

Equipment

Textbook Exceptions and Supplementals

Materials Fees v2

No Value

Textbooks

Author Title Publisher Date ISBN

Lynn Wermers Microsoft Office 365 Excel 2019,

Comprehensive Cengage 2019

Other Instructional Materials No Value

Title of Other Material No Value

Who prepared or published this supplemental material?

No Value

Publish date No Value

Are any of the textbook editions cited on this proposal considered "Classics" (typically with a publish date more than 5 years old)?

Yes No Unsure

If yes, explain why this older text is used in the course. Reasons should focus on content only.

No Value

Is there a materials fee for this course?

No

Provide a cost breakdown for all items provided for a materials fee. Each item must become "tangible personal property" of student upon payment of the fee and completion of the course.

No Value

Explain how these materials are related to the Student Learning Objectives for the course.

No Value

Learning Outcomes and Objectives

Explain how the materials have continuing value outside the classroom.

No Value

Is the amount of the material the student receives commensurate with the fee paid AND with the amount of material necessary to achieve the Student Learning Objectives for the course AND provided as the district's actual cost?

No Value

If no is checked, explain why.

No Value

If the district is NOT the only source of these materials, explain why the students have to pay a fee to the district rather than supply the materials themselves. (Cost savings? Health/Safety? Consistency/Uniformity?)

No Value

Course Objectives

Develop financial analysis using advanced formulas and functions.

Integrate data through import and export.

Determine and apply appropriate problem solving techniques.

Describe the functions of macros in Excel.

Define what-if analysis.

Lab Objectives

Customize an Excel workbook to be shared and tracked.

Demonstrate a fundamental understanding of expanding spreadsheets using Visual Basic.

Perform what-if analyses.

Content

Identify methods of sharing and tracking workbooks.

CSLOs

Expected SLO Performance: 0.0 Create, edit, and run a macro in Excel using Visual Basic application programming language.

Expected SLO Performance: 0.0 Integrate data between Excel and other software programs through the process of importing and exporting.

Expected SLO Performance: 0.0 Demonstrate the use of problem-solving and/or what-if analysis by using advanced level features to develop spreadsheets that incorporate functional business principles.

Course Content

1. Performing Financial Analysis

1. Using advanced logical functions

2. Determining interest and principal payments 3. Creating amortization schedules

4. Creating and customizing Forecast Sheets 2. Using Analysis Tools

1. Performing What-If analysis 2. Using Scenario Manager 3. Back-solving with Goal Seek

4. Creating one and two-variable data tables 5. Installing and running the Solver add-in 6. Analyzing data with the Watch Window 7. Using the Analysis ToolPak

3. Importing and Exporting Data

1. Getting and transforming external data 2. Managing data connection properties

3. Using Query Editor for XML, text, database, and other files 4. Saving data for export

4. Using Visual Basic for Applications

1. Using VBA programming language to write macros 2. Working with project object and module procedures

3. Writing code using properties, methods, collections, and sub-routines 4. Using the Visual Basic Editor to edit macros

5. Solving common macro issues 5. Modifying Default Settings

1. Customizing options, the Ribbon, and the Quick Access toolbar 2. Viewing and modifying account settings

3. Installing Office Add-Ins 4. Designing a user interface

5. Adding and configuring worksheet form controls

Lab Content

1. Performing Financial Analysis

1. Using advanced logical functions

2. Determining interest and principal payments

3. Creating amortization schedules

Recommended Course Content

Distance Education (DE) Addendum

Is this course being proposed for Distance Education? If so, select Yes below from the list in the dropdown and complete the questions. If no, select No and skip all questions.

Yes

Modality Type:

Hybrid Online

Methods of Instruction:

Asynchronous Discussion Viewing and Listening to Videos Online Activities

4. Creating and customizing Forecast Sheets 2. Using Analysis Tools

1. Performing What-If analysis 2. Using Scenario Manager 3. Back-solving with Goal Seek

4. Creating one and two-variable data tables 5. Installing and running the Solver add-in 6. Analyzing data with the Watch Window 7. Using the Analysis ToolPak

3. Importing and Exporting Data

1. Getting and transforming external data 2. Managing data connection properties

3. Using Query Editor for XML, text, database, and other files 4. Saving data for export

4. Using Visual Basic for Applications

1. Using VBA programming language to write macros 2. Working with project object and module procedures

3. Writing code using properties, methods, collections, and sub-routines 4. Using the Visual Basic Editor to edit macros

5. Solving common macro issues 5. Modifying Default Settings

1. Customizing options, the Ribbon, and the Quick Access toolbar 2. Viewing and modifying account settings

3. Installing Office Add-Ins 4. Designing a user interface

5. Adding and configuring worksheet form controls

Recommended Course Content No Value

Recommended Lab Content

No Value

Written Assignments Reading Course Materials Interactive Activities Listening to Audio Materials Facilitated Discussions Quizzes, Exams, and Surveys Multimedia Presentations

On-campus Orientation Sessions (hybrid only)

If Other is selected for Methods of Instruction, please describe:

No Value

Describe how the methods of instruction selected above will allow students to meet the course’s learning outcomes:

Students will complete and submit assigned materials via online instructional software. Timely feedback and guidance will be given on areas needing improvement.

Describe how the methods selected will be presented in an accessible way (Title 5 §55206). For information about accessibility standards in online classes, see the OEI Rubric, Section D (Copy this link and paste in a separate browser to visit OEI Rubric:

https://onlinenetworkofeducators.org/course-design-academy/online-course-rubric/)

Course content will be developed utilizing accessible standards utilizing heading styles, lists, links, tables, color contrast, color and meaning, images, reading order, slides, spreadsheets (where appropriate), video, audio, as well as using the built-in accessibility checker.

Regular and Effective Contact (REC) Methods and Examples: Select the methods below that ensure regular effective contact (REC) will take place among students and among students and faculty (Title 5 §55204) by being initiated by the instructor, regular and frequent, and meaningful or of an academic nature. Select the methods of REC that may be used:

No Value

REC Among students: How will students interact with each other in the course? What methods will be used? Check all that apply.

Discussion Boards Q & A Discussion Boards

REC Among students and faculty: How will faculty interact with students in the course? What methods will be used? Check all that apply Announcements

Assignment Feedback Discussion Boards Email

Video Conferencing Technology (e.g. Zoom, MS Teams, etc...) Q & A Discussion Boards

Office Hours

Other Methods of REC among students and among students and faculty. Please describe and provide example(s).

No Value

In hybrid or teleclass courses, describe what parts of the course are done face-to-face and what parts are done online.

Orientation, instruction, demonstration, and some exams/quizzes will be done face-to-face.

Practice and application of content, as well as submission of assignments, quizzes, exams, will be done online.

Checkoff List

Does this proposal meet the five development criteria as stated in the CCCCO Program and Course Approval Handbook (PCAH)?

Yes

Are library resources needed for this course?

No library resources are needed for this course.

Do you have any special concerns/needs or comments? If yes, describe.

No Value

Have you included documentation, if necessary, by uploading file(s) in the Cover Info tab? For example, advisory committee meeting minutes, C-ID descriptor, etc.)

Yes, I have uploaded file(s).

If this is a new course, have you attached the completed class capacity form, with required approvals, and uploaded the file in the Cover Info tab?

Yes, I have uploaded the class capacity form that includes all required approvals.

If you are requesting Distance Education, did you complete the DE addendum tab?

Yes

If requesting transferability, have you completed the comparable courses field?

Yes

Add any additional comments you want reviewers to read.

No Value