包含什麼
14 現場會議
9 小時 20 分鐘 上課時間作業
每週 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.
學習目標
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;
教學大綱
14 課程
超過 14 週課 1:
Personal Income from Various Sources | Formatting
Create an Excel spreadsheet with income data and use the various formatting features of Excel: fonts, colours, borders, align, change columns' size, etc.
40 分鐘線上直播課
課 2:
Subtotals and Totals | SUM Formulas | Circle Graph
Use the SUM formula of a range of data to calculate totals and subtotals; Insert a circle graph;
40 分鐘線上直播課
課 3:
Annual Earnings / Expenses based on the Monthly Figures | Date Fields
Use multiplication and division to convert between monthly and yearly figures;
40 分鐘線上直播課
課 4:
Calculate Earnings using Rate of Pay | Multiplication Formula
Calculate weekly, monthly, yearly figures based on the hourly rate of pay; calculate earnings based on commissions;
40 分鐘線上直播課
其他詳情
先決條件
Learners need to have access to MS Excel or similar spreadsheet app.
外部資源
除了 Outschool 教室外,本課程也使用:
來源
MS Excel or equivalent spreadsheet app
教師專業知識和證書
非美國 教學證書 在 數學
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$23
每週或US$320 用於 14 課程每週上課 x 1 次, 14 週
40 分鐘
即時視訊會議
年齡: 12-14
2-12 每班學員人數