Hojas de cálculo de Google para principiantes
En esta clase a su propio ritmo, se enseñarán los conceptos básicos de Google Sheets. Se les presentarán a los estudiantes situaciones de la vida real en las que pueden usar Google Sheets. Crearán y formatearán un cronograma semanal, un presupuesto con fórmulas y ordenarán las estadísticas de las Olimpiadas.
Colleen Smith
Puntuación media:
5.0
Número de reseñas:(333)
Educador estrella
Qué está incluido
6 lecciones pregrabadas
3 semanas
de apoyo docente1 año de acceso
al contenidoTareas
2-4 horas por semana. Students will watch six recordings and will work in Google Sheets during each recording. They can send me a link to their Google Sheet for review. Feedback will be given on all assignments within 48 hours, although I aim to make it even sooner.Calificación
I provide feedback on all work that is turned in. 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
During this class, students will learn the basic functions of Google Sheets and get hands-on practice. More details can be found in the 𝙎𝙮𝙡𝙡𝙖𝙗𝙪𝙨 and 𝙇𝙚𝙖𝙧𝙣𝙞𝙣𝙜 𝙂𝙤𝙖𝙡𝙨sections. 𝗛𝗼𝘄 𝗱𝗼𝗲𝘀 𝗮 𝘀𝗲𝗹𝗳-𝗽𝗮𝗰𝗲𝗱 𝗰𝗹𝗮𝘀𝘀 𝘄𝗼𝗿𝗸? This is a Self-Paced, so there are no live sessions. Students will have access to six pre-recorded lessons that I created exclusively for Outschool. During the recordings, I share my screen so students can watch me using Google Sheets as I describe its capabilities. Learners are encouraged to use Google Sheets as they watch the recording, so that they can follow along and gain hands-on practice. The recordings are about 9-15 minutes, but may take longer to complete, depending on if the student pauses or rewinds as they watch and complete their tasks in Google Sheets. Students can submit their work for feedback and reach out with questions. 𝗪𝗵𝗮𝘁 𝗱𝗼 𝘀𝘁𝘂𝗱𝗲𝗻𝘁𝘀 𝗻𝗲𝗲𝗱 𝗳𝗼𝗿 𝘁𝗵𝗶𝘀 𝗰𝗹𝗮𝘀𝘀? Students do not need any experience with Google Sheets, but should have basic desktop or laptop knowledge, such as the ability to use a mouse or touch pad, be able to use a keyboard and open a program. They must have access to a free Google account in order to access Google Sheets. The account should be created prior to class, as this is not covered.
Metas de aprendizaje
Students will comprehend Google Sheets vocabulary (cell, column, row, worksheet, formula, budget, sum)Students will be able to implement formatting (color, font, number type for currency and time, gridlines)
Programa de estudios
6 Lecciones
más de 3 semanasLección 1:
Create a Schedule
I'll begin by discussing real-world uses for Google Sheets and related vocabulary. I'll then dive in and begin using the program. Learners will use Google Sheets while watching my recording to create their own weekly schedule. Topics covered will include auto-populating days and times and naming and sharing a Google Sheet. 15 minutos de lecciones en video
Lección 2:
Format Your Schedule
Learners will learn how to add gridlines and change fonts, sizes and colors. 11 minutos de lecciones en video
Lección 3:
Create a Budget
Learners will imagine they are going grocery shopping. We will use Google Sheets to create a budget. New topics covered will include formatting for currency and writing a multiplication formula. 16 minutos de lecciones en video
Lección 4:
More Formulas for Your Budget
Learners will learn the difference between Static and Cell Reference formulas and write addition, subtraction and division formulas and use the SUM function. 12 minutos de lecciones en video
Otros detalles
Orientación para padres
Learners will use Google Sheets, which is an Outschool-approved third party tool, but does require a free Google account.
Lista de útiles escolares
In addition to the Outschool classroom, this class uses: Google Sheets Students should have a Google account setup prior to starting class, so they can use the program and follow along as they watch my recordings.
Idioma en el que se imparte la clase
Inglés
Recursos externos
Además del aula de Outschool, esta clase utiliza:
Se unió el September, 2021
5.0
333reseñas
Educador estrella
Experiencia y certificaciones del docente
Licenciatura desde Bucknell University
I have virtually tutored over 1,300 young learners on Outschool, but prior to that I enjoyed a thirteen-year corporate career, where I used spreadsheets 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 a su propio ritmo
7 US$
semanalmente6 lecciones pregrabadas
3 semanas de apoyo docente
Elige tu fecha de inicio
1 año de acceso al contenido
Completado por 5 alumnos
Edades: 10-13
