Microsoft Dr.G 教材の成果と課題
教材としては面白いと思った。
個人を全面に出して、その性格で勝負しようとしている。
最初は１０本拝見した。
翌週に１０本拝見した。
さらに翌週に１０本拝見。
そして翌週に１０本。合計４０本拝見。
最近、１本、他の番組に登場しているのを41番として記録した。
| No | title | url | date | views | goods | bads |
|---|---|---|---|---|---|---|
| 1 | An Introduction to the Learn with Dr G Show | https://www.youtube.com/watch?v=QEkTtg3m6Ek | 20201023 | 2,936 | 72 | 1 |
| 2 | Over the Moon Learn Lessons Overview | https://www.youtube.com/watch?v=2aSmF7Oj7n0 | 20201023 | 2,377 | 54 | 0 |
| 3 | Data’s Role in Moon Missions: Fictional and Real | https://www.youtube.com/watch?v=jyFHnO7-4Gc | 20201023 | 1,692 | 45 | 0 |
| 4 | Predicting Meteor Showers Using Python and Visual Studio Code | https://www.youtube.com/watch?v=Aln9p6farRg | 20201031 | 1,867 | 74 | 2 |
| 5 | Use Azure Custom Vision to Repurpose the Lunar Rover | https://www.youtube.com/watch?v=rP6VcSL2KxY | 20201031 | 610 | 17 | 1 |
| 6 | Intro to the blockchain Microsoft Learn modules | https://www.youtube.com/watch?v=eQRuImwe5nk | 20201107 | 3,545 | 91 | 4 |
| 7 | Crack the code and reveal a secret with Python and Visual Studio Code Learn with Dr. G | https://www.youtube.com/watch?v=VH_mU42lQkQ | 20201111 | 2,965 | 91 | 1 |
| 8 | Which WONDER WOMAN 1984 character are you most like? | https://www.youtube.com/watch?v=zawdAAZZcTE | 20201114 | 579 | 15 | 1 |
| 9 | Intro to Microsoft Student Programs and Novice Learning Resources | https://www.youtube.com/watch?v=QjzaF_0XiYo | 20201125 | 1,257 | 50 | 8 |
| 10 | The benefit of hackathons when learning to code Learn with Dr. G | https://www.youtube.com/watch?v=A7EPrwZMoBI | 20201121 | 1304 | 38 | 0 |
| 11 | Intro to AutoML on Azure, Learn with Dr G | https://www.youtube.com/watch?v=eTrHT5fxEVc | 2020/12/2 | 3,531 | 98 | 1 |
| 12 | Intro to Azure ML SDK, Learn with Dr G | https://www.youtube.com/watch?v=LW2iinnqVSk | 2020/12/9 | 2,754 | 87 | 0 |
| 13 | SPACE JAM: A NEW LEGACY Learn Lessons Overview, Learn with Dr G | https://www.youtube.com/watch?v=d2PvXrlkNTs | 2020/12/15 | 999 | 20 | 1 |
| 14 | Predict basketball player efficiency ratings with machine learning and Visual Studio Code, LWDG | https://www.youtube.com/watch?v=R6S05RkWl10 | 2020/12/19 | 1644 | 65 | 0 |
| 15 | Create a web app and use data to make decisions on the basketball court, Learn with Dr G | https://www.youtube.com/watch?v=Gwew7DNDwDs | 2020/12/26 | 1,830 | 51 | 5 |
| 16 | Introducing the Microsoft and WONDER WOMAN 1984: Game Idea Challenge, Learn With Dr G | https://www.youtube.com/watch?v=iZipyyE15U | 2021/1/5 | 826 | 25 | 17 |
| 17 | Before First Lines Of Code, Learn with Dr G | https://www.youtube.com/watch?v=RGaM-W36VjE | 2021/1/15 | 988 | 25 | 5 |
| 18 | Developing your Game plan and Prototype , Learn with Dr G | https://www.youtube.com/watch?v=3x8iYItkN_A | 2021/1/15 | 1232 | 38 | 4 |
| 19 | Integrating Mixed Reality into your Video Game,Learn with Dr. G | https://www.youtube.com/watch?v=HqS5XkgVT5s | 2021/1/27 | 839 | 23 | 0 |
| 20 | Exploring Mixed Reality in Games, Learn with Dr G | https://www.youtube.com/watch?v=k4so2V1hFx4 | 2021/1/27 | 674 | 27 | 0 |
| 21 | Starting a game studio: Ghost Garden Gamesﾊ, Learn with Dr. G | https://www.youtube.com/watch?v=ecC6dlhRwIo | 2021/1/29 | 1261 | 48 | 2 |
| 22 | Defining Your Origin Story ﾐ Xbox Game Studios panel session Learn with Dr G | https://www.youtube.com/watch?v=kIHp28HzRqs | 2021/2/5 | 759 | 23 | 1 |
| 23 | And the Winner of the Game Idea Challenge Is.... , Learn with Dr G | https://www.youtube.com/watch?v=PPoAJpTeotw | 2021/2/16 | 554 | 16 | 5 |
| 24 | Using Python to Explore Space , Learn with Dr G | https://www.youtube.com/watch?v=NcUreWUpQFo | 2021/1/6 | 3988 | 168 | 6 |
| 25 | Use Artificial Intelligence to Classify Space Rocks, Learn with Dr G | https://www.youtube.com/watch?v=XoHR4p8AO9o | 2021/1/13 | 1020 | 60 | 0 |
| 26 | Plan a Rocket Launch with Python and Visual Studio Code, Learn with Dr G | https://www.youtube.com/watch?v=OauYZNegUBs | 2021/1/16 | 1150 | 41 | 4 |
| 27 | Use Machine, Learning to Predict Rocket Delays, Learn with Dr G | https://www.youtube.com/watch?v=eK3ATduvFGM | 2021/1/20 | 1930 | 33 | 2 |
| 28 | Intro to the What You Didn't Learn In School Series, Learn with Dr G | https://www.youtube.com/watch?v=cbIsxKEQZ7Y | 2021/1/30 | 1700 | 59 | 0 |
| 29 | ntro To Git: Learn the foundations of Git and version control ,Learn with Dr. G | https://www.youtube.com/watch?v=dnDHVbO7ycM | 2021/2/3 | 7118 | 253 | 2 |
| 30 | Introduction to Git Recap , Learn with Dr G | https://www.youtube.com/watch?v=9uGS1ak_FGg | 2021/2/9 | 6799 | 274 | 2 |
| 31 | Collaborate with Git: Keeping your Source Code Error Free, Learn with Dr. G | https://www.youtube.com/watch?v=-CDSGioxy6w | 2021/2/10 | 2872 | 81 | 0 |
| 32 | Git and Remote Syncing ,Learn with Dr G | https://www.youtube.com/watch?v=wuPE__7Yr4k | 2021/3/9 | 762 | 17 | 2 |
| 33 | Using GitHub as your Project Management Tool , Learn with Dr. G | https://www.youtube.com/watch?v=qgQAFP6oSKw | 2021/3/3 | 4720 | 165 | 3 |
| 34 | Using GitHub as your Project Management Tool Recap , Learn with Dr G | https://www.youtube.com/watch?v=T4Q6Mmc_Sg4 | 2021/3/9 | 1378 | 62 | 0 |
| 35 | Using Markdown to Optimize your GitHub Project , Learn With Dr. G | https://www.youtube.com/watch?v=yPAvSZlFBhU | 2021/3/10 | 1014 | 41 | 2 |
| 36 | Using Markdown to Optimize your GitHub Project Recap, Learn with Dr G | https://www.youtube.com/watch?v=TuUFJzYDRwg | 2021/3/16 | 720 | 17 | 0 |
| 37 | Introduction to Bash , Learn With Dr. G | https://www.youtube.com/watch?v=3gLZdMuFDZM | 2021/3/17 | 5598 | 175 | 5 |
| 38 | Introduction to Bash Recap,Learn with Dr G | https://www.youtube.com/watch?v=A6wrEU-xTtQ | 2021/3/23 | 1149 | 58 | 2 |
| 39 | Foundations of PowerShell ,Learn with Dr G | https://www.youtube.com/watch?v=6EDtKhOVy3g | 2021/3/24 | 6037 | 174 | 4 |
| 40 | Using UNIX shell and regex to Wrangle Data,Learn with Dr G | https://www.youtube.com/watch?v=lGgx0tGnFPA | 2021/3/31 | 1259 | 68 | 3 |
| summary | 86,237.0 | 2,306.0 | 80.0 | |||
| standard deviation | 1,619.9 | 61.8 | 3.4 | |||
| average deviation | 1,186.3 | 40.9 | 2.4 | |||
| avarage | 2,024.3 | 66.0 | 2.5 | |||
| sd/a | 0.8 | 0.9 | 1.4 | |||
| max/min | 12.8 | 18.3 | - | |||
| 41 | 8 Bits with Dr G! | https://www.youtube.com/watch?v=hfDz57L6FDY | 2021/06/17 | 970 | 25 | 4 |
statics 1 - 10
| 1-10 | views | goods | bads |
|---|---|---|---|
| summary | 19,132.0 | 547.0 | 18.0 |
| standard deviation | 967.5 | 25.9 | 2.4 |
| average deviation | 834.0 | 21.8 | 1.7 |
| avarage | 1,913.2 | 54.7 | 1.8sd/a |
| max/min | 6.1 | 6.1 | - |
statics 11 - 20
| 11-20 | views | goods | bads |
|---|---|---|---|
| summary | 15,317.0 | 459.0 | 33.0 |
| standard deviation | 893.1 | 27.0 | 5.0 |
| average deviation | 726.4 | 23.5 | 3.6 |
| avarage | 1,531.7 | 45.9 | 3.3sd/a |
| max/min | 5.2 | 4.9 | - |
statics 21 - 30
| 21-30 | views | goods | bads |
|---|---|---|---|
| summary | 26,279.0 | 975.0 | 24.0standard deviation |
statics 31 - 40
| 31-40 | views | goods | bads |
|---|---|---|---|
| summary | 25,509.0 | 858.0 | 21.0 |
| standard deviation | 2,004.3 | 59.3 | 1.6 |
| average deviation | 1,804.7 | 51.3 | 1.3 |
| avarage | 2,550.9 | 85.8 | 2.1sd/a |
| max/min | 8.4 | 10.3 | - |
感想
すごく驚いたのは、viewsの最大と最小の比が、goodsの最大と最小の比に近いこと。
統計的にも、標準偏差を平均で割った値は、viewsとgoodsの値は近い。
ある意味、質が均一だと言えるのかもしれない。
題材によって、集まる人の割合が、6倍くらい違うだけで。
主人公のおばあさんはスペイン人という話がでてきた。
この乗りが好きか嫌いかで、goodかどうか左右しているかもしれない。
Excel 関数
macro
summary = SUM(D2:D11)
standard deviation = stdev.p(D2:D11)
average deviation = VEDEV(D2:D11)
avarage =AVERAGE(D2:D11)
sd/a = H7/H9
max/min = MAX(D2:D11)/MIN(D2:D11)
文書履歴
ver. 0.01 初稿 20210623
ver. 0.02 統計追記 20210624
ver. 0.03 項目20 20210704
ver. 0.04 項目30 20210709
ver. 0.05 項目40 20210722
ver. 0.06 add "8 Bits with Dr G!" items 41 20210912
ver. 0.07 補正 20221022