Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

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

Other Decks in Education

See All in Education
Soluciones al examen de Geografía 2026. JULIO (Convocatoria Extraordinaria)
Avatar for Juan Martín Martín juanmartin2026
1
19k
Soluciones al examen de Geografía 2026. JUNIO (Convocatoria Ordinaria)
Avatar for Juan Martín Martín juanmartin2026
1
10k
!コスパよくインターンに受かる方法！
Avatar for ruribou ruribou
1
360
An Experiment in "Cross-Cultural Exchange" as a Method for Content Creation
Avatar for 京都精華大学谷口 直嗣 naoji_taniguchi_ksk_0827
0
200
DecisionesEjecutivasCrisis
Avatar for Mario OC mariooc
0
320
2026年度春学期　統計学　第10回　分布の推測とは － 標本調査，度数分布と確率分布 (2026. 6. 4)
Avatar for Akira Asano akiraasano
PRO
0
210
Science Tokyo University for International Research Excellence scheme_April 2026
Avatar for Science Tokyo （東京科学大学） / Science Tokyo (Institute of Science Tokyo) sciencetokyo
PRO
0
190
批判的応用言語学ワークショップ（2026-08-12 お茶の⽔⼥⼦⼤学）
Avatar for TerasawaT terasawat
0
190
Fundamentos, Caracteristicas y Aplicaciones de los Modulos NumPy , Matplotlib y Pandas
Avatar for Abraham Zamudio robintux
0
250
Plano urbano de Madrid desde el Ensanche al s. XXI (2ª parte).
Avatar for Juan Martín Martín juanmartin2026
1
73k
マークシート試験のTeX言語を用いた自動採点について
Avatar for doratex doratex
0
3.4k
INTRODUCTION TO THE CELL
Avatar for Pawan Kumar Sahu pawan_pharm
0
280

Featured

See All Featured
HDC tutorial
Avatar for Michiel Stock michielstock
2
870
Designing for humans not robots
Avatar for Tammie Lister tammielis
254
26k
Why Our Code Smells
Avatar for Brandon Keepers bkeepers
PRO
340
58k
Chasing Engaging Ingredients in Design
Avatar for Sebastian Deterding codingconduct
0
310
Designing Powerful Visuals for Engaging Learning
Avatar for Mike Taylor tmiket
1
550
Design and Strategy: How to Deal with People Who Don’t "Get" Design
Avatar for Morgane Peng morganepeng
133
19k
Exploring anti-patterns in Rails
Avatar for Elle Meredith aemeredith
4
510
Building the Perfect Custom Keyboard
Avatar for Naoto Takai takai
2
870
B2B Lead Gen: Tactics, Traps & Triumph
Avatar for Sophie Logan marketingsoph
0
240
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
Avatar for panda_program panda_program
123
22k
The AI Search Optimization Roadmap by Aleyda Solis
Avatar for Aleyda Solis aleyda
1
6.2k
My Coaching Mixtape
Avatar for mlcsv mlcsv
0
310

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