1
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

"An Introduction to the Learn with Dr. G Show" on Youtube. @drguthals

Last updated at Posted at 2021-06-27

Microsoft Dr.G 教材の成果と課題

教材としては面白いと思った。
個人を全面に出して、その性格で勝負しようとしている。

最初は10本拝見した。
翌週に10本拝見した。
さらに翌週に10本拝見。
そして翌週に10本。合計40本拝見。

最近、1本、他の番組に登場しているのを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

最後までおよみいただきありがとうございました。

いいね 💚、フォローをお願いします。

Thank you very much for reading to the last sentence.

Please press the like icon 💚 and follow me for your happy life.

1
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
1
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?