格。 6 – 8 |金融素養和 Excel SEM。課程 |證書。 H.規格數學老師
學習者將了解個人財務和預算的基本概念，包括：收入、稅金、費用、折扣、利息。練習是使用 Excel 或等效應用程式使用格式、公式和圖表完成的。
Marilena Loneanu, H. Spec. Math, OCT
平均評分：
5.0
評論數量：(4)
包含什麼
12 現場會議
8 上課時間作業
每週 1-2 小時. in class exercises完成證書
包括我們無法翻譯此文，請刷新頁面並再試一次。
課堂經歷
英語程度 - 未知
美國 6 - 8 年級
Beginner - Advanced 等級
This class' focus is on learning the key features of spreadsheet apps / Excel in the context of Finance. Learners will build basic financial concepts of income, expenses, balancing a budget, income tax, sales tax, discounts, inventory, simple and compound interest. They will apply all mathematical formulas relevant for these exercises while also learning how to use professional spreadsheet software tools. This is an unique blend of Math and IT concepts and skills within the Financial context that enable learners to benefit in their future academic, career, as well as with their personal financial decisions. Each lesson will be based on Excel exercises that learners will create using real-life applications and data. Grades 6 – 8 | Financial Literacy in Excel | Cert. H. Spec. Teacher Lesson 1. Excel Basics | Formatting | Formulas Lesson 2. Personal Income from Various Sources | Commissions Lesson 3. Calculate Net Earnings from Gross Earnings | Tax Calculations Lesson 4. Total Expenses Monthly vs. Annual | Subtotals and Totals | SUM Formulas | Circle Graph Lesson 5. Budgeting | Calculate the Gross Amount from the Net Amount | Division Formula Lesson 6. Candy Store Inventory Project Day 1 | “IF” Formula Lesson 7. Candy Store Inventory Project Day 2 | “IF” Formula Lesson 8. Payment Tracking in Two Currencies | SUMIF Formula Lesson 9. Sales / Discounts | Sales Tax | Percent Formulas Lesson 10. Savings and Loans | Simple Interest Formula and Calculations. Lesson 11. Savings and Loans | Compound Interest Formula and Calculations Day 1 Lesson 12. Savings and Loans | Compound Interest Formula and Calculations Day 2
學習目標
Learners will build the foundation of Financial Literacy, understanding concepts such as: income, expenses, balancing a budget, income tax, sales tax, discounts, inventory, simple and compound interest.Learners will use key features of MS Excel or similar spreadsheet apps to handle data: formatting, graphing and performing various calculations with formulas;
教學大綱
12 課程
超過 12 週課 1:
Excel Basics | Formatting | Formulas
40 分鐘線上直播課
課 2:
Personal Income from Various Sources | Commissions
40 分鐘線上直播課
課 3:
Calculate Net Earnings from Gross Earnings | Tax Calculations
40 分鐘線上直播課
課 4:
Total Expenses Monthly vs. Annual | Subtotals and Totals | SUM Formulas | Circle
40 分鐘線上直播課
其他詳情
先決條件
Learners need to have access to MS Excel or similar spreadsheet app.
外部資源
除了 Outschool 教室外，本課程也使用：
來源
MS Excel or equivalent spreadsheet app
已加入 July, 2024
5.0
4評論
教師專業知識和證書
非美國 教學證書 在 數學
Marilena is certified H. Spec. Math, Computer and Business Studies, grades 4 to 12. She has 15-year in-class teaching expertise and her students participate in Math and Computing contests with outstanding results: perfect score and Honour Roll of prestigious institutions, such as the University of Waterloo and Brock University in Canada, and the Math Olympiad in the USA. Marilena has a 5-year Math degree, IT major.評論
現場團體小班課程
US$24
每週每週1次，共 12 週
40 分鐘
即時視訊會議
年齡: 12-14
2-5 每班學員人數
