What's included
1 live meeting
55 mins in-class hoursClass Experience
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 learners will be encouraged to ask questions while they exercise the pivot table functionality and exercise some ranking functionality. Participants should have their own Excel copy, and be able to do basic sorting, filtering and know how to use several formulas.
Learning Goals
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.
Other Details
Supply List
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.
External Resources
Learners will not need to use any apps or websites beyond the standard Outschool tools.
Teacher expertise and credentials
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 manager for over 20 years and have extensive background in data analysis using conventional and AI techniques. Leading projects and teams has taught me the fun of coaching my young team members. Providing formal training courses on data management in the US and Europe has taught me how to structure and present content to a wide variety of learners and learning styles.
Students want to learn, and want to be excellent at what they do. As coaches we have to give them the information and tools they need. Then providing a good bit of patience and pride in each of their achievements helps keep them enthusiastic.
In my spare time I enjoy playing the guitar, while there may be some doubt about how loud it should be, there is never doubt that it is fun!
Reviews
Live One-Time Class
$12
per classMeets once
55 min
Completed by 2 learners
Live video meetings
Ages: 15-18
1-6 learners per class
This class is no longer offered
Financial Assistance
Tutoring
More to Explore
Advance ChessPrimary SourcesSpanish For YoungHtml And Css For Beginners 8 Flexible Schedule For TeenagersChinese ImmersiveSo You Want To Be AGenius HourRubix CubeShowBeginner Latin Level OneIew Fix It GrammarTraditional Algebra And Nothing ElseLets Speak More JapaneseMulti Sensory Reading Spelling WritingClean Room