科目情報
BUSN135 - Business Mathematics
BUSN135 - Business Mathematics
BUSN135 - Business Mathematics
ビジネス・マスマティック
講義(英語)
Instructor Information Instructor’s Name: Oussama (Sam) Alkhalili Instructor’s Office (Bldg. – Room): 26-321 Instructor’s Office Hours: In Person (26-321) Or Zoom https://highline.zoom.us/j/2065924317 Mondays, Wednesdays 10-10:50 AM (In-Person/Zoom) Tuesdays/Thursdays 11-11:50 AM (Zoom Only) Fridays 10-10:50 AM (In-Person/Zoom) Appointment: https://tinyurl.com/oalkhalili Instructor’s Email Address: oalkhalili@highline.edu Instructor’s Office Phone: 206-592-4317 The best way to contact me is via email. I will respond within 24-48 hours. Course Information Department: Business Item (Section) #: 35418 Course Overview This course introduces students to Business Mathematics applications using paper and Excel formulas. Students will learn how to make Business Mathematics calculations using Excel effectively and efficiently. We will use Excel as it is a powerful tool that has become well- established by different employers in their business process, in everyday accounting and financial calculations. You will leave the class well-versed in business calculation and basic and intermediate Excel formulas. 2 Student Learning Outcomes • Analyze business problems and make conclusions based on the calculations performed. Explain conclusions in words. • Perform arithmetic with the math operations: add, subtract, multiply, divide, exponents, parenthesis and the order of operations. • Use Excel to perform business math calculations with an emphasis on data type, Number Formatting and formulas. • Develop abilities to use fractions, decimals, and percentages to help make business decisions by hand on paper and by using the spreadsheet program Excel. • Calculate various types of Cash Discounts and Trade Discounts by hand on paper and by using the spreadsheet program Excel. • Calculate various types of Depreciation by hand on paper and by using the spreadsheet program Excel. • Make simple interest, compound interest, future value, and present value calculations by hand on paper and by using the spreadsheet program Excel. • Use calculations and concepts to make business and personal decisions. Additional Outcomes for this class outside the catalog: Understand the definition of Effective and Efficient 1. Effective: i. Accomplish the stated goal. ii. In this class the goal is to create things like Payroll tables or calculate the correct invoice totals after a trade discount. For these calculations, effective means get the correct answer. 2. Efficient i. Accomplish the goal with the minimum number of resources. ii. In this class the resource is time. So “Efficient” means we will learn how to create Excel Solutions that make math calculations quickly in order to save time. iii. Two examples of efficient are: 1. Using the SUM Function like =SUM(B7:B11,B14:B20,B23:B25,E7:E17), rather than the much longer formula: =B7+B8+B9+B10+B11+B14+B15+B16+B17+B18+B19+B20+B23+B24+B25+E7+E8+E9+E10+E11+E12+E13+E14+E15+E16+E17 2. Relative and Absolute Cell Refences to quickly calculate a column of Payroll number, like: =ROUND(B9*$E$9,2), where $E$9 must be locked (Absolute).
担当教員情報(Instructor Information) 担当教員名:Oussama(Sam)Alkhalili オフィス(建物・部屋):26-321 オフィスアワー: 対面(26-321)またはZoom(https://highline.zoom.us/j/2065924317) 月・水:10:00〜10:50(対面/Zoom) 火・木:11:00〜11:50(Zoomのみ) 金:10:00〜10:50(対面/Zoom) 予約:https://tinyurl.com/oalkhalili メール:oalkhalili@highline.edu 電話:206-592-4317 最も良い連絡方法はメールです。返信は24〜48時間以内に行います。 授業情報(Course Information) 学科:ビジネス 科目番号(セクション):35418 授業概要(Course Overview) この授業では、ビジネス数学を紙とExcelの両方を使って学びます。 学生は、Excelを使って効率的かつ正確にビジネス計算を行う方法を学びます。 Excelは、多くの企業で日常的な会計や財務計算に使われている非常に重要なツールです。 この授業を終える頃には、 ビジネス計算 Excelの基本〜中級の関数 をしっかり理解できるようになります。 学生学習到達目標(Student Learning Outcomes) 学生は以下ができるようになります: ビジネスの問題を分析し、計算結果から結論を出し、それを言葉で説明する 基本的な計算(足し算・引き算・掛け算・割り算・指数・カッコ・計算の順序)を行う Excelを使ってビジネス計算を行う(データ型・数値形式・数式に重点) 分数・小数・パーセントを使って意思決定を行う(手計算とExcel両方) 現金割引や取引割引を計算する(手計算とExcel両方) 減価償却を計算する(手計算とExcel両方) 単利・複利・将来価値・現在価値を計算する(手計算とExcel両方) 計算と概念を使ってビジネスや個人の意思決定を行う 追加の学習目標(Additional Outcomes) 「効果的(Effective)」と「効率的(Efficient)」の理解 1. 効果的(Effective) 設定された目標を達成すること この授業では、給与表を作成したり、割引後の請求額を正しく計算することが目標 → 正しい答えを出すことが「効果的」 2. 効率的(Efficient) 最小のリソースで目標を達成すること この授業ではリソース=時間 → できるだけ早く計算することが「効率的」
ビジネス