8/31/2024 10:09:54 PM |
| 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
Grading:
Non-Credit Course
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:
At the conclusion of this course, the student should 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
At the conclusion of this course, the student should 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
6. Cash and trade discounts
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
C. Trade 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)
Methods of Evaluation/Basis of Grade.
Writing: Assessment tools that demonstrate writing skill and/or require students to select, organize and explain ideas in writing. | Writing 0 - 0% |
None | |
Problem solving: Assessment tools, other than exams, that demonstrate competence in computational or non-computational problem solving skills. | Problem Solving 70 - 80% |
In-class computational analysis as related to business situations: computation and word problem exercises | |
Skill Demonstrations: All skill-based and physical demonstrations used for assessment purposes including skill performance exams. | Skill Demonstrations 0 - 0% |
None | |
Exams: All forms of formal testing, other than skill performance exams. | Exams 0 - 0% |
None | |
Other: Includes any assessment tools that do not logically fit into the above categories. | Other Category 20 - 30% |
Attendance and participation; group problem-solving | |
Representative Textbooks and Materials:
Untitled document
Instructor prepared materials
Print PDF