Seguimiento de tarjetas coleccionables con Microsoft Excel
En esta clase práctica de cuatro semanas se enseñarán los conceptos básicos de Excel y se registrarán las tarjetas coleccionables de los estudiantes, ya sean de Pokémon, béisbol u otras tarjetas. Los alumnos crearán hojas de cálculo, organizarán datos y crearán fórmulas y gráficos.
Qué está incluido
4 reuniones en vivo
3 horas 20 minutos horas presencialesTarea
1-2 horas por semana. I will give short optional homework assignments after the first three classes and will provide feedback on all submitted work.Calificación
Please let me know if you need specific grading.Experiencia de clase
Nivel de inglés: desconocido
Grado de EE. UU. 4 - 7
Nivel Beginner - Intermediate
In this class, students will learn how to use Microsoft Excel, discovering its powerful capabilities by tracking their own trading cards. Students should have at least ten trading cards that they will log in an Excel spreadsheet, whether they're Pokemon, baseball, Magic, Yu-Gi-Oh or other cards. This class will not only teach the basics of Excel, but it will excite students to discover ways they can use Excel in their everyday lives. The course kicks off by introducing essential terminology and discussing the many uses of the program. From there, students will get hands-on experience creating their own spreadsheets, guided by a live demonstration on my screen. To fully engage, it's crucial that students have Microsoft Excel already installed on their computers, enabling them to follow along and experiment as I lead the way. Throughout the course, students are encouraged to participate. For a list of weekly topics, please see the "𝙎𝙮𝙡𝙡𝙖𝙗𝙪𝙨" section. 𝗣𝗿𝗲𝗿𝗲𝗾𝘂𝗶𝘀𝗶𝘁𝗲𝘀 𝗮𝗻𝗱 𝗪𝗵𝗮𝘁 𝗶𝘀 𝗡𝗲𝗲𝗱𝗲𝗱: --To ensure a seamless learning experience for all, please have your learner signed into Excel before the class begins. While no prior Excel experience is necessary, basic computer knowledge (using a mouse, keyboard, and launching programs) is recommended. --Learners should bring at least ten trading cards to class. They can be one type of card (example: all Pokemon cards) or a mix of cards (example: baseball and Yu-Gi-Oh cards). 𝗧𝗿𝗼𝘂𝗯𝗹𝗲𝘀𝗵𝗼𝗼𝘁𝗶𝗻𝗴 will be integrated into the class. In instances where learners face challenges, learners will be able to share their screens or grand me remote access. This approach guarantees that all topics are covered, even if certain steps need to be revisited at the end of the class to troubleshoot with individual learners.
Metas de aprendizaje
Learners will be able to define Excel vocabulary, such as cell, row, column, and SUM
Learners will be able to format cells for number type, font and color
Programa de estudios
4 Lecciones
más de 4 semanasLección 1:
Formatting and Filtering
After discussing terminology, we will begin to create our spreadsheet. Through this task, we'll explore data organization, cell formatting, and filtering techniques.
50 minutos de lección en vivo en línea
Lección 2:
Sorting and Formulas
We will continue to use our spreadsheet from Week 1. In this phase, new topics will encompass currency formatting, data sorting, utilizing the SUM function, and creating math formulas.
50 minutos de lección en vivo en línea
Lección 3:
Conditional Formatting and More Formulas
We will review all that we learned in the first two weeks, while learning more advanced functions, such as AVERAGE and conditional formatting.
50 minutos de lección en vivo en línea
Lección 4:
Creating Graphs
We'll use our trading card spreadsheets to delve into graph creation, covering pie charts, bar graphs, and line graphs.
50 minutos de lección en vivo en línea
Otros detalles
Orientación para padres
Learners should have Microsoft Excel on their computer prior to starting class, so they can use the program and follow along as I teach the class. We will not be using any external websites or apps.
Lista de útiles escolares
Learners should bring at least ten trading cards to class. They can be one type of card (example: all Pokemon cards) or a mix of cards (example: baseball and Yu-Gi-Oh cards). Learners should have Microsoft Excel on their computer prior to starting class, so they can use the program and follow along as I teach the class. We will not be using any external websites or apps.
1 archivo disponible al momento de la inscripción
Recursos externos
Los estudiantes no necesitarán utilizar ninguna aplicación o sitio web más allá de las herramientas estándar de Outschool.
Experiencia y certificaciones del docente
Licenciatura desde Bucknell University
I have taught over 1,300 learners on Outschool over the past three years. Prior to that, I enjoyed a thirteen-year corporate career, where I used Microsoft Excel to make my work more efficient and effective on a daily basis. I hold a Bachelor's of Science in Business Administration from Bucknell University.
Reseñas
Curso grupal en vivo
65 US$
por 4 clases1 x por semana, 4 semanas
50 min
Videoconferencias en vivo
Edades: 10-14
3-7 alumnos por clase