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

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

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

Thank you very much for reading to the last sentence.

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