6.º a 8.º grado | Curso semestral de conocimientos financieros y Excel | Profesor certificado de matemáticas
Los alumnos comprenderán los conceptos fundamentales de las finanzas personales y la elaboración de presupuestos, incluidos: ingresos, impuestos, gastos, descuentos e intereses. Los ejercicios se realizan con Excel o una aplicación equivalente utilizando formatos, fórmulas y gráficos.
Qué está incluido
14 reuniones en vivo
9 horas 20 minutos horas presencialesTareas
1-2 horas por semana. in class exercisesCertificado de finalización
incluidoExperiencia de clase
Nivel de inglés: desconocido
Grado de EE. UU. 6 - 8
Nivel 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.
Metas de aprendizaje
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;
Programa de estudios
14 Lecciones
más de 14 semanasLección 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 minutos de lección en vivo en línea
Lección 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 minutos de lección en vivo en línea
Lección 3:
Annual Earnings / Expenses based on the Monthly Figures | Date Fields
Use multiplication and division to convert between monthly and yearly figures;
40 minutos de lección en vivo en línea
Lección 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 minutos de lección en vivo en línea
Otros detalles
Requisitos previos
Learners need to have access to MS Excel or similar spreadsheet app.
Recursos externos
Además del aula de Outschool, esta clase utiliza:
Fuentes
MS Excel or equivalent spreadsheet app
Experiencia y certificaciones del docente
Fuera de EE. UU. Certificado de Docencia en Matemáticas
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.
Reseñas
Curso grupal en vivo
23 US$
semanalmente o 320 US$ por 14 clases1 x por semana, 14 semanas
40 min
Videoconferencias en vivo
Edades: 12-14
2-12 alumnos por clase