Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Slack のログを Google Spreadsheet に自動的に保存する: Google...

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for Ken Urano Ken Urano
March 24, 2018
Education
4.2k
2

Slack のログを Google Spreadsheet に自動的に保存する: Google Apps Script を使って

外国語教育メディア学会（LET）中部支部
Google Classroom での課題管理と Slack でのコミュニケーション活動入門・第2回
＠名古屋大学
2018.03.24.

Avatar for Ken Urano

Ken Urano

March 24, 2018

More Decks by Ken Urano

See All by Ken Urano
Investigating Changes in Self-Assessed Spoken English Proficiency in a Three-Week Study-Abroad Program
Avatar for Ken Urano uranoken
0
150
The Task is not the End: The Role of Task Repetition and Sequencing In Language Teaching
Avatar for Ken Urano uranoken
0
700
学習者を対象にした英語教育研究における倫理的配慮
Avatar for Ken Urano uranoken
0
1.2k
学習者データを「見る」：外国語教師のためのデータの入力、分析、解釈方法
Avatar for Ken Urano uranoken
0
1.3k
英語教育研究でエビデンスを「つくる」：メタ分析、再現性、追試
Avatar for Ken Urano uranoken
0
1.5k
タスク·ベースの英語授業：基本的な考え方とデザイン方法
Avatar for Ken Urano uranoken
0
1.3k
英語の授業をタスクで組み立てる
Avatar for Ken Urano uranoken
0
1.4k
Designing Task-based ESP Syllabi: Two Cases from an English for Business Purposes Program
Avatar for Ken Urano uranoken
0
1.5k
第二言語習得と外国語教育における 「文法知識」の位置づけ
Avatar for Ken Urano uranoken
0
1.4k

Other Decks in Education

See All in Education
Design Guidelines and Principles - Lecture 7 - Information Visualisation (4019538FNR)
Avatar for Beat Signer signer
PRO
0
3k
アジャイルなマインドセットを「取り戻す」新人研修づくり
Avatar for Tomonori Fukuta chinmo
2
420
生成AIを授業の相棒にするデータサイエンス入門（「デジタル✕探究」イノベーターズフォーラム テクニカルセッション講演資料）
Avatar for The Japan DataScientist Society datascientistsociety
PRO
0
190
「機械学習と因果推論」入門 ① 因果効果とは
Avatar for MasaKat0 masakat0
0
1.6k
2026年度春学期　統計学　講義の進め方と成績評価について (2026. 4. 9)
Avatar for Akira Asano akiraasano
PRO
0
140
Railsチュートリアル × 反転学習の事例紹介
Avatar for YassLab yasslab
PRO
3
180k
2026年度春学期　統計学　第2回　統計資料の収集と読み方 (2026. 4. 16)
Avatar for Akira Asano akiraasano
PRO
0
140
演習：Gitの基本操作 / 04-git-basic
Avatar for kaityo256 kaityo256
PRO
1
480
Analysis and Validation - Lecture 4 - Information Visualisation (4019538FNR)
Avatar for Beat Signer signer
PRO
0
2.7k
Interaction - Lecture 10 - Information Visualisation (4019538FNR)
Avatar for Beat Signer signer
PRO
0
2.6k
SARA Annual Report 2025-26
Avatar for SARA Institute sara2023
1
320
Virtual and Augmented Reality - Lecture 8 - Next Generation User Interfaces (4018166FNR)
Avatar for Beat Signer signer
PRO
0
2.2k

Featured

See All Featured
Data-driven link building: lessons from a $708K investment (BrightonSEO talk)
Avatar for Szymon Słowik szymonslowik
1
1k
Discover your Explorer Soul
Avatar for Emna emna__ayadi
2
1.1k
Practical Orchestrator
Avatar for Shlomi Noach shlominoach
191
11k
Hiding What from Whom? A Critical Review of the History of Programming languages for Music
Avatar for Tomoya Matsuura tomoyanonymous
2
790
Odyssey Design
Avatar for Ryan Kendrick rkendrick25
PRO
2
610
Public Speaking Without Barfing On Your Shoes - THAT 2023
Avatar for David Neal reverentgeek
1
380
JavaScript: Past, Present, and Future - NDC Porto 2020
Avatar for David Neal reverentgeek
52
5.9k
Leadership Guide Workshop - DevTernity 2021
Avatar for David Neal reverentgeek
1
270
brightonSEO & MeasureFest 2025 - Christian Goodrich - Winning strategies for Black Friday CRO & PPC
Avatar for Christian Goodrich cargoodrich
3
690
Why Mistakes Are the Best Teachers: Turning Failure into a Pathway for Growth
Avatar for Umar Saidu Auna auna
0
130
The Success of Rails: Ensuring Growth for the Next 100 Years
Avatar for Eileen M. Uchitelle eileencodes
47
8.1k
Effective software design: The role of men in debugging patriarchy in IT @ Voxxed Days AMS
Avatar for Kenny Baas-Schwegler baasie
0
330

Transcript

  1. Slack ͷϩάΛ Google Spreadsheet ʹࣗಈతʹอଘ͢Δ —Google Apps Script Λ࢖ͬͯ— Ӝ໺

    ݚʢ๺ւֶԂେֶʣ email: [email protected] ֎ࠃޠڭҭϝσΟΞֶձʢLETʣத෦ࢧ෦ Google ClassroomͰͷ՝୊؅ཧͱSlackͰͷίϛϡχέʔγϣϯ׆ಈೖ໳ɾୈ2ճ ˏ໊ݹ԰େֶ ɹɹ2018. 3.24.

  2. Slack ͷϩάΛ Google Spreadsheet ʹࣗಈతʹอଘ͢Δ —Google Apps Script Λ࢖ͬͯ— Disclaimer

    ຊൃද͸ɺ2017೥10݄14೔ʹߦΘΕͨLETؔ੢ࢧ෦2017 ೥౓ळقݚڀେձʢˏྲྀ௨ՊֶେֶʣͰͷ Classroom Tips ൃදʮϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻ʯͷ಺༰ͷ Ұ෦Λൈਮ͠ɺิ଍ͨ͠΋ͷͰ͢ɻ

  3. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  4. तۀ֓ཁ ̎೥࣍։ߨՊ໨ʢఆһ15໊ʣ ʻ໨ඪᶃʼ ϥΠςΟϯάͷ fluency ޲্ ʻ໨ඪᶄʼ ύϥάϥϑˍΤοηΠ࡞੒ೳྗ޲্ ϥΠςΟϯάतۀʹ͓͚Δ Slack

    ͷ׆༻

  5. ʻ໨ඪᶃʼ ϥΠςΟϯάͷ fluency ޲্ तۀ͚࣌ؒͩͰ͸ॻ͘ػձ͕଍Γͳ͍ ڭࣨ֎ϥΠςΟϯά׆ಈ ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  6. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  7. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  8. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  9. तۀ࣌ؒ֎ʹߦ͏ϥΠςΟϯά׆ಈ ޷͖ͳ͜ͱΛॻ͘νϟϯωϧͱ
 ຖिࢦఆ͞Εͨ࿩୊ʹ͍ͭͯॻ͘νϟϯωϧ ֓ཁ ҙຯॏࢹͰޡΓ΁ͷࢦఠ͸ߦΘͳ͍ ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻ ධՁ͸ྔʢ૯ޠ਺ʣɾ੒੷ͷ30%

  10. ΢Σϒϒϥ΢βͰͷར༻΋Ͱ͖Δ Slack બ୒ͷཧ༝ ϩάͷΤΫεϙʔτ͕Ͱ͖ΔʢJSONܗࣜʣ ޠ਺Χ΢ϯτͳͲɺ੒੷ධՁͷͨΊͷ෼ੳ͕Ͱ͖Δ ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  11. ϩάͷΤΫεϙʔτ͕Ͱ͖ΔʢJSONܗࣜʣ ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  12. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  13. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  14. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻ Ϣʔβʔ໊΋ίʔυԽ͞Ε͍ͯΔ

  15. ϩάͷΤΫεϙʔτ͕Ͱ͖ΔʢJSONܗࣜʣ ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻ ༷ʑͳ෼ੳΛߦ͏ʹ͸ศར લॲཧ͕ඞཁ ͨͩ͠ ʮޠ਺ΛΧ΢ϯτ͍͚ͨͩ͠ͳΜ͚ͩͲ…ʯ

  16. Google ઌੜʹ૬ஊ Έ͚ͭͨʂ ෼ੳ͠΍͍͢ܗʹࣗಈతʹม׵͍ͨ͠ ʮSlack ͷϩάΛࣗಈͰ Google Spreadsheet ʹอଘ͢Δʯ http://motemen.hatenablog.com/entry/2015/11/gas-slack-log-spreadsheet

    ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  17. ʮSlack ͷϩάΛࣗಈͰ Google Spreadsheet ʹอଘ͢Δʯ http://motemen.hatenablog.com/entry/2015/11/gas-slack-log-spreadsheet ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  18. ʮSlack ͷϩάΛࣗಈͰ Google Spreadsheet ʹอଘ͢Δʯ http://motemen.hatenablog.com/entry/2015/11/gas-slack-log-spreadsheet ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻ Google

    Apps Script Λར༻ ఆظతʹ Slack ͷϩάΛऔಘ ݟ΍͍͢ܗʹม׵ͯ͠ Spreadsheet ʹࣗಈอଘ

  19. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻

  20. ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻ Ϣʔβʔ໊΋ࣗಈऔಘ

  21. ʮSlack ͷϩάΛࣗಈͰ Google Spreadsheet ʹอଘ͢Δʯ http://motemen.hatenablog.com/entry/2015/11/gas-slack-log-spreadsheet ϥΠςΟϯάतۀʹ͓͚Δ Slack ͷ׆༻ Google

    Spreadsheet ͷσʔλͳͷͰ Ϣʔβʔ໊΍౤ߘ೔࣌Ͱͷιʔτ͕؆୯ ͦͷ··੒੷ධՁʹ࢖͑Δ

  22. ڭ͑ͯ΄͍͠

  23. ڭ͑ͯ΄͍͠ • Spreadsheet ʹࣗಈతʹอଘ͞Εͨϩάͷϝοηʔδ෦ ෼ʢCྻʣͷޠ਺ΛΧ΢ϯτ͠ɺ৽͍͠ྻʹॻ͖ग़͢࡞ ۀΛࣗಈతʹͰ͖ͨΒ͏Ε͍͠ɻ • Ϣʔβ͝ͱͷ૯ޠ਺·Ͱग़ͯ͘͠ΕͨΒ͞Βʹ͏Ε͍͠ɻ • ͦΕΛਵ࣌ਤࣔͯ͘͠ΕͨΓͨ͠Βٽ͍ͯتͼ·͢ɻ

  24. ·ͱΊ

  25. • तۀ࣌ؒ֎ͷӳޠ࢖༻Λ૿΍͍ͨ͠ • Slack Λར༻ͨ͠ڭࣨ֎ϥΠςΟϯά׆ಈ • Google Apps Script Λར༻ͨ͠ϩάͷࣗಈอଘͱ੔ཧ

    • ͍ͣΕ͸͞ΒʹࣗಈԽΛਐΊ͍ͨ Ken Urano [email protected] ·ͱΊ