# SRJC Course Outlines

 4/22/2021 5:12:13 PM ADLTED 724 Course Outline as of Fall 2017 New Course (First Version) CATALOG INFORMATION Discipline and Nbr:  ADLTED 724 Title:  BUSINESS MATH EXCEL Full Title:  Business Mathematics Using Excel Last Reviewed:3/13/2017

 Units Course Hours per Week Nbr of Weeks Course Hours Total Maximum 0 Lecture Scheduled 0 6 max. Lecture Scheduled 0 Minimum 0 Lab Scheduled 3.00 3 min. Lab Scheduled 18.00 Contact DHR 0 Contact DHR 0 Contact Total 3.00 Contact Total 18.00 Non-contact DHR 0 Non-contact DHR Total 0

 Total Out of Class Hours:  0.00 Total Student Learning Hours: 18.00

Title 5 Category:  Non-Credit
Repeatability:  27 - Exempt From Repeat Provisions
Also Listed As:
Formerly:

Catalog Description:
Untitled document
This course presents basic math as applied to business solutions using Excel including: banking, pricing, cash and trade discounts, payroll, and calculating interest and depreciation.

Prerequisites/Corequisites:

Recommended Preparation:

Limits on Enrollment:

Schedule of Classes Information
Description: Untitled document
This course presents basic math as applied to business solutions using Excel including: banking, pricing, cash and trade discounts, payroll, and calculating interest and depreciation.
(Non-Credit Course)

Prerequisites:
Recommended:
Limits on Enrollment:
Transfer Credit:
Repeatability:27 - Exempt From Repeat Provisions

ARTICULATION, MAJOR, and CERTIFICATION INFORMATION

 Associate Degree: Effective: Inactive: Area: CSU GE: Transfer Area Effective: Inactive: IGETC: Transfer Area Effective: Inactive: CSU Transfer: Effective: Inactive: UC Transfer: Effective: Inactive: C-ID:

Certificate/Major Applicable: Certificate Applicable Course

COURSE CONTENT

Student Learning Outcomes:
Upon completion of the course, students will be able to:
Untitled document
1.
Apply basic principles of mathemathics in calculations for checking account debit/credit
transactions, cash and trade discounts, payroll applications, product pricing for
profitability, simple interest and depreciation using Excel as a tool.

Objectives: Untitled document
Upon completion of the course, students will be able to effectively use Excel to make a variety of business calculations:
1. Fraction and decimal problems
2. Equivalents and conversion
3. Percentages as they relate to discounts
4. Checking account transactions
5. Payroll transactions
7. Pricing products for profitability
8. Simple Interest
9. Depreciation

Topics and Scope
Untitled document
I. Overview of Excel for Business Applications
II. Calculating Equivalencies and Percentages
A. Fractions
B. Equivalents and Conversions
C. Percentages
III. Calculating Payroll Problems
A. Time-basis payment and payroll deductions
B. Piecework and commission methods of payment
IV. Calculating Cash and Trade Discounts
A. Purchase orders and invoices
B. Cash discounts
V. Calculating Pricing
A. Retail price, cost, and markup
B. Profit and loss
VI. Calculating Depreciation
VII. Calculating Simple Interest

Assignments:
Untitled document
1. Calculate number/factor problems as they relate to specific business topics such as payroll,
discounts, and depreciation using Excel (15 - 20 exercises)
2. Calculate word problems as related to specific business topics such as payroll, discounts, and
depreciation using Excel (15 - 20 exercises)
3. In-class activities applying mathematical calculations to everyday business situations using
Excel (8 - 10)
4. Group problem-solving exercises (4 - 6)