This class is no longer available, but we found something similar!
5.0 (2) · Ages 8-13
The “Engineering Design Process” Code 1-1
5.0 (1) · Ages 11-17
1-on-1 Roblox Studio Ambition Coaching!
5.0 (55) · Ages 11-16
Coding With C++ Level 1!
5.0 (10) · Ages 5-18
STEM Mentoring with Teacher Tom! Explore STEM Projects 1:1 at Your Own Pace
5.0 (4) · Ages 6-15
Programming on Minecraft: One-on-One Coding Sessions
5.0 (1) · Ages 4-17
1:1 Tutoring 30Min Coding, Circuits, Robotics, Math, Photography, Science, Chess
Excel: Windmills and Solar Power
The learner will use Excel pivot tables to analyze the migration to electric generation using renewable resources. Real world data lets us exercise time-series manipulation as well as ranking functionality.
We will use real-world data showing the use of coal, natural gas, wind and solar for electricity generation. These were chosen as the other major source for generation are relatively stable while these are changing radically. I will present the tasks required to prepare, analyze and present the data and our conclusions. The learners will have the opportunity to accomplish the same tasks on their own computers on their own copy of Excel. I will provide the data in a file before the class. The...
The student will learn how to prepare data to be used in pivot tables. These tables will allow quick and easy summaries and queries of the data table. Additionally the learners will use conditional formatting to show color-coded ranking. Using real-world data will teach the student about the data analysis process. The analysis will also encourage the participants to have an informed point of view on the amount of renewable resources being used in electrical generation and about the comparative costs of each source.
A copy of Excel to be used during the class will allow the learner to try each step as we discuss it in class. Data will be provided before the class.
Learners will not need to use any apps or websites beyond the standard Outschool tools.
Meet the teacher
I am teaching classes on Excel and Google Sheets using climate data and analyzing global warming. Using these tools the students can produce amazing results and become fluent in basic data analysis. Professionally I have been an IT developer and...
Average rating:5.0Number of reviews:(1)
Completed by 2 learners
Live video meetings
1-6 learners per class