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

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

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
学習者データを「見る」：外国語教師のためのデータの入力、分析、解釈方法
Avatar for Ken Urano uranoken
0
300
AI-Based Speaking Assessment of a Short-Term Study Abroad Program
Avatar for Ken Urano uranoken
0
480
Estimating Group × Time Interaction in Scale-Transformed CEFR-J Self-Assessment Scores: A Case in Study-Abroad Research
Avatar for Ken Urano uranoken
1
220
Investigating Changes in Self-Assessed Spoken English Proficiency in a Three-Week Study-Abroad Program
Avatar for Ken Urano uranoken
0
320
The Task is not the End: The Role of Task Repetition and Sequencing In Language Teaching
Avatar for Ken Urano uranoken
0
860
学習者を対象にした英語教育研究における倫理的配慮
Avatar for Ken Urano uranoken
0
1.3k
学習者データを「見る」：外国語教師のためのデータの入力、分析、解釈方法
Avatar for Ken Urano uranoken
0
1.4k
英語教育研究でエビデンスを「つくる」：メタ分析、再現性、追試
Avatar for Ken Urano uranoken
0
1.7k
タスク·ベースの英語授業：基本的な考え方とデザイン方法
Avatar for Ken Urano uranoken
0
1.4k

Other Decks in Education

See All in Education
Portable & Reproducible Research Environments in the Age of AI Agents
Avatar for Mai Nishimura denkiwakame
0
710
2026年度春学期　統計学　第11回　分布の「型」を考える － 確率分布モデルと正規分布 (2026. 6. 11)
Avatar for Akira Asano akiraasano
PRO
0
180
Beyond the Prompt: Programming as a Pathway to Statistical Thinking
Avatar for Mine Cetinkaya-Rundel minecr
0
350
[2026前期火５] 論理学（京都大学文学部 前期 第13回）「走って、止まって、積み上がる」
Avatar for Shunsuke Yatabe yatabe
0
220
!コスパよくインターンに受かる方法！
Avatar for ruribou ruribou
1
350
Science Tokyo University for International Research Excellence scheme_April 2026
Avatar for Science Tokyo （東京科学大学） / Science Tokyo (Institute of Science Tokyo) sciencetokyo
PRO
0
110
Del ojo entrenado a la visión computacional: evaluación de la severidad de enfermedades
Avatar for Emerson M. Del Ponte emdelponte
0
120
Visionary Initiative: Future Intelligence — Laying the foundations for the future of science, intelligence, and society | Science Tokyo
Avatar for Science Tokyo （東京科学大学） / Science Tokyo (Institute of Science Tokyo) sciencetokyo
PRO
0
290
Réunion des directrices et directeurs des écoles de la circonscription de Jonzac - 31 août 2026
Avatar for Frédéric Marot fmarot
0
110
FA26 CLU MS Clinical Psychology New Student Orientation
Avatar for Jamie D. Bedics, PHD, ABPP jdbedics
0
170
遊ぶかね欲しさの犯行（ルビ：労働）です
Avatar for ShirayanagiRyuji shirayanagiryuji
0
260
[2026前期火５] 論理学（京都大学文学部 前期 第12回）「証明を走らせる：カリー・ハワード対応」
Avatar for Shunsuke Yatabe yatabe
0
300

Featured

See All Featured
We Analyzed 250 Million AI Search Results: Here's What I Found
Avatar for Josh Blyskal joshbly
1
1.9k
Designing for Performance
Avatar for Lara Hogan lara
611
70k
エンジニアに許された特別な時間の終わり
Avatar for watany watany
108
250k
YesSQL, Process and Tooling at Scale
Avatar for Rocio Delgado rocio
174
15k
Navigating the Design Leadership Dip - Product Design Week Design Leaders+ Conference 2024
Avatar for Andy Polaine apolaine
2
410
Art, The Web, and Tiny UX
Avatar for Lynn Fisher lynnandtonic
304
22k
For a Future-Friendly Web
Avatar for Brad Frost brad_frost
183
10k
Introduction to Domain-Driven Design and Collaborative software design
Avatar for Kenny Baas-Schwegler baasie
1
970
Understanding Cognitive Biases in Performance Measurement
Avatar for Philip Tellis bluesmoon
32
3k
Chasing Engaging Ingredients in Design
Avatar for Sebastian Deterding codingconduct
0
300
HTML-Aware ERB: The Path to Reactive Rendering @ RubyCon 2026, Rimini, Italy
Avatar for Marco Roth marcoroth
4
580
The AI Revolution Will Not Be Monopolized: How open-source beats economies of scale, even for LLMs
Avatar for Ines Montani inesmontani
PRO
3
3.7k

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] ·ͱΊ