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
2
4k

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

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

Ken Urano

March 24, 2018
Tweet

More Decks by Ken Urano

See All by Ken Urano
The Task is not the End: The Role of Task Repetition and Sequencing In Language Teaching
Avatar for Ken Urano uranoken
0
430
学習者を対象にした英語教育研究における倫理的配慮
Avatar for Ken Urano uranoken
0
900
学習者データを「見る」：外国語教師のためのデータの入力、分析、解釈方法
Avatar for Ken Urano uranoken
0
1.1k
英語教育研究でエビデンスを「つくる」：メタ分析、再現性、追試
Avatar for Ken Urano uranoken
0
1.3k
タスク·ベースの英語授業：基本的な考え方とデザイン方法
Avatar for Ken Urano uranoken
0
1.2k
英語の授業をタスクで組み立てる
Avatar for Ken Urano uranoken
0
1.3k
Designing Task-based ESP Syllabi: Two Cases from an English for Business Purposes Program
Avatar for Ken Urano uranoken
0
1.3k
第二言語習得と外国語教育における 「文法知識」の位置づけ
Avatar for Ken Urano uranoken
0
1.3k
英語教育研究の始め方・進め方：目的に合致した手法選択の重要性
Avatar for Ken Urano uranoken
1
940

Other Decks in Education

See All in Education
View Manipulation and Reduction - Lecture 9 - Information Visualisation (4019538FNR)
Avatar for Beat Signer signer
PRO
1
2.1k
『会社を知ってもらう』から『安心して活躍してもらう』までの プロセスとフロー
Avatar for sasakendayo sasakendayo
0
230
AIの時代こそ、考える知的学習術
Avatar for YUM3 yum3
2
170
i-GIP 2025 中高生のみなさんへ資料
Avatar for i-GIP KYUSHU 202200
0
500
Constructing a Custom TeX Ecosystem for Educational Institutions—Beyond Academic Typesetting
Avatar for doratex doratex
1
10k
SkimaTalk Introduction for Students
Avatar for SkimaTalk skimatalk
0
390
検索/ディスプレイ/SNS
Avatar for リスナビ takenawa
0
6.5k
著作権と授業に関する出前講習会/dme-2025-05-01
Avatar for Takahiro Sumiya gnutar
0
200
Sponsor the Conference | VizChitra 2025
Avatar for VizChitra vizchitra
0
550
演習問題
Avatar for リスナビ takenawa
0
6.5k
2025.05.10 技術書とVoicyとわたし #RPALT
Avatar for Kaito UDAGAWA kaitou
1
230
より良い学振申請書（DC）を作ろう 2025
Avatar for Lui Yoshida luiyoshida
1
3.3k

Featured

See All Featured
How to train your dragon (web standard)
Avatar for Monica Dinculescu notwaldorf
95
6.1k
The Pragmatic Product Professional
Avatar for Laura Van Doore lauravandoore
35
6.7k
The Language of Interfaces
Avatar for Des Traynor destraynor
158
25k
Building Better People: How to give real-time feedback that sticks.
Avatar for Will Jessup wjessup
367
19k
Optimizing for Happiness
Avatar for Tom Preston-Werner mojombo
379
70k
Being A Developer After 40
Avatar for Adrian Kosmaczewski akosma
90
590k
[RailsConf 2023] Rails as a piece of cake
Avatar for Vladimir Dementyev palkan
55
5.7k
Fireside Chat
Avatar for paigeccino paigeccino
37
3.5k
Docker and Python
Avatar for Tania Allard trallard
44
3.5k
Building a Modern Day 
E-commerce SEO Strategy
Avatar for Aleyda Solis aleyda
42
7.4k
XXLCSS - How to scale CSS and keep your sanity
Avatar for Zaharenia Atzitzikaki sugarenia
248
1.3M
10 Git Anti Patterns You Should be Aware of
Avatar for Lemi Orhan Ergin lemiorhan
PRO
656
60k

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