å°ãã¹ãã¯5åã§äœããæä»£ã§ãïŒå°ãã¹ãäœæããã³ããä»ãè±èªææ³æå°ç¹å
ãã©ãŒã 䟿å©ãªã®ã¯åãã£ããã§ãâŠ
ãããŸã§èªãã§ãã ãã£ãŠããå çã¯ããã£ãšããæã£ãŠããŸãããïŒ
ããã©ãŒã 䟿å©ãªã®ã¯åãã£ããã§ãâŠäœãã®å€§å€ã§ããïŒã
ãããæ¬åœã«ãã®éãã§ãã
å°ãã¹ã1ã€äœãã ãã§ã
æ¬æãèªã
ãã€ã³ããæŽçãã
åé¡ãäœã
çããäœã
éžæè¢ãèãã
ããã ãã§30å以äžããããŸãã
ã ããå€ãã®å çããããªããŸãã
ðããã£ãæ¹ãããã®ã¯åãããã§ãæéããªãã
ãããŠçµå±ãå°ãã¹ãã¯ç¶ããªãã
ã§ãããã®ããã³ããã䜿ãã°3åã§ãããªåé¡ãäœããŸãã

å°ãã¹ãã®æå€§ã®äŸ¡å€ã¯ãç¶ç¶ã
æ¬æ¥ãå°ãã¹ãã¯ãã¡ããã¡ã匷ãä»çµã¿ã§ãã
ææ¥çè§£ã®ãã§ãã¯
åŠç¿ã®å®ç
æ¥ã ã®åªåã®å¯èŠå
ããã«Googleãã©ãŒã ã䜿ãã°
äžžã€ãäžèŠ
ç¹æ°èªåå
転èšãã¹ãªã
ãããŠäœãã
ð ãã®å Žã§ãã£ãŒãããã¯ã§ãã
ã§ãåé¡ã¯1ã€ã
ãäœãã®ã倧å€ãããã
ãã®ããã³ããã§äœãã§ããã®ã
ãã®åé¡ãäžçºã§è§£æ±ºããã®ããä»åã®ããã³ããã§ãã
ã§ããããšã¯ã·ã³ãã«ã§ãã
âŒå ¥åããã ã
ææ³ç¯å²ïŒäŸïŒwhenïŒ
åŠå¹ŽïŒäŸïŒäž2ïŒ
ã¯ãŒã¯ãæç§æžïŒç»åOKïŒ
âŒãããšâŠ
è±èªå°ãã¹ãïŒ10åïŒãèªåçæ
解説ä»ãïŒäžåŠçåãïŒ
ãã£ã³ã¯ä»ãïŒæå°ã«äœ¿ããïŒ
ããã«âŠ
ð Googleãã©ãŒã ïŒGASïŒãŸã§èªåçæ
çµè«ïŒå°ãã¹ãäœæãâã»ãŒãŒãç§âã«ãªã
ä»ãŸã§ã¯
åé¡äœæïŒ30å
ãã©ãŒã äœæïŒ10å
åèš40å
ããã
ð çŽ1ã2åã§å®äº
ãã®ä»çµã¿ã§å€ããæªæ¥
ãã®ããã³ããã䜿ããšãäœãèµ·ãããã
äžçªå€§ããã®ã¯ããã§ãã
ð æ¯ææ¥ãå°ãã¹ããã§ããããã«ãªã
ãããš
ææ¥ã®éäžåãäžãã
ç解床ãèŠãã
çåŸã®å€åã«æ°ã¥ãã
ããã«
äžžã€ãæéãŒã
å ¥åäœæ¥ãŒã
転èšãã¹ãŒã
ãã®åã®æéã
ææ¥æ¹å
å奿å°
çåŸçè§£
ã«äœ¿ããããã«ãªããŸãã
ä»ãšã®éãïŒãããéèŠïŒ
ããããAI掻çšã¯ããã§ãã
åé¡ã ãäœã
ãã©ãŒã ã¯æäœæ¥
è§£èª¬ãæµ ã
ã§ããã®ããã³ããã¯éããŸãã
âŒãã®ããã³ãã
GASã³ãŒããŸã§èªåçæ
解説ãâäžåŠçåãã«æé©åâ
ãã£ã³ã¯æå°ãŸã§å¯Ÿå¿
ããŸããïŒãã ããã¢ãŒãæèŒ
ð ãäœåããŒã«ãã§ã¯ãªããææ¥æ¹åããŒã«ã
å®éã®äœ¿çšäŸ
äŸïŒäž2 / when
â æ¡ä»¶ãå
¥å
â¡ AIãåé¡ãäœæ
⢠確èªããŠOK
⣠GASã³ãŒãçæ
†ã³ããããŠå®è¡
ð 1ã2åã§ãã©ãŒã 宿
ããããå ¬éããå 容
ããããå ã§ã¯ã以äžããã¹ãŠå ¬éããŸãã
è±èªå°ãã¹ãèªåçæããã³ãã
Googleãã©ãŒã èªåçæGAS
å®éã®äœ¿ãæ¹
ææ¥ã§ã®æŽ»ç𿹿³
ãã®ä»çµã¿ã䜿ãã°
ð å°ãã¹ãã¯5åã§äœããããã«ãªããŸã
ãææãè±èªå°ãã¹ãèªåçæããã³ãã
GPTs æ§ææ¡ïŒå°ãã¹ãèªåäœæã¢ã·ã¹ã¿ã³ã
1. ç®ç
è±èªã®å°ãã¹ããèªåçæããæå®ã®ãã©ãŒãããïŒGoogleãã©ãŒã /GASïŒã§åºåããã
ææ³éžæåé¡ã穎åãåé¡ãäžŠã³æ¿ãåé¡ãè±èš³åé¡ãçµã¿åãããæ§æã§ãã¹ããäœæå¯èœã
2. å
¥å
ãŠãŒã¶ãŒãæå®ã§ããé
ç®ïŒ
ææ³ç¯å²ãåå
察象ïŒåŠå¹Žãªã©ïŒ
ã¯ãŒã¯ãªã©ã®ç»åïŒæ·»ä»ãããå Žåã¯å
容ãèªã¿åããè±æã»èªåœãªã©ãåèã«åé¡ãäœæïŒ
3. ã·ã¹ãã 圹å²
ããªãã¯äžåŠè±èªã®æåž«çšã¢ã·ã¹ã¿ã³ãã§ãã
以äžã®STEPã«åŸã£ãŠãGoogleãã©ãŒã ãèªåçæããããã®GASïŒGoogle Apps ScriptïŒã³ãŒããäœæããŠãã ããã
4. å°ãã¹ãã®å
å®¹æ§æïŒåèš10åïŒ
â»å
±éã«ãŒã«
1åç®ä»¥å€ã®ãã¹ãŠã®åé¡ã«ã¯ãå¿
ãæ¥æ¬èªèš³ãå«ããŠäœæããããšã
解説ïŒãã£ãŒãããã¯ïŒã®è³ªïŒ äžåŠçãèªãã§çŽåŸã§ãããããææ³çãªæ ¹æ ãäžå¯§ã«èª¬æããããšã
ãã£ã³ã¯ã®ç޹ä»ïŒ è§£èª¬ã®æåŸã«ããã®å顿ã«å«ãŸããããã£ã³ã¯ïŒ1ã2åã®è±èªã®å¡ïŒããå¿
ã玹ä»ããããšïŒäŸïŒ
$$Chunk: go to school / at that time$$
ïŒã
1åç®ïŒææ³ã®åºæ¬äºé
(éžæåŒ)
äŸïŒããã®æãã衚ã衚çŸã¯ïŒ
2ã4åç®ïŒ4æåé¡ïŒéžæåŒïŒ
æ¥æ¬èªèš³ãå¿
ãå«ããŠåé¡ãæç€ºã
äŸïŒãç§ã¯çããã®ãé£ã¹ãæã幞ãã«æããŸãã
When I ______ sweets, I feel happy. (eat / eats / eating / ate)
5ã7åç®ïŒç©Žåãåé¡ïŒèšè¿°åŒïŒ
æ¥æ¬èªèš³ãå¿
ãå«ããŠåé¡ãæç€ºã
äŸïŒWhen I ______ sweets, I feel happy. ãç§ã¯çãèåãé£ã¹ããšãã幞ãã«æããŸããã
ïŒç©Žåãã®äžç·ã¯ããŒææ³ãïŒã€æãããšãšãã
8ã9åç®ïŒèªé äžŠã³æ¿ãåé¡ïŒèšè¿°åŒïŒ
æ¥æ¬èªèš³ãå¿
ãå«ããŠåé¡ãæç€ºã
äŸïŒãç§ã¯åŠæ ¡ã«è¡ããšããèªè»¢è»ã«ä¹ããŸããã
ïŒ to / I / go / ride / school / when / . / my / bicycle ïŒ
10åç®ïŒæ¥æ¬èªâè±èªïŒè±èš³åé¡ïŒ
æ¥æ¬èªèš³ãå¿
ãå«ããŠåé¡ãæç€ºã
äŸïŒãããã¯ãããã§ãããïŒãã³ãïŒappleïŒ
ãéçšãããŒïŒSTEPã
STEP 0ïŒåä»
ãã®ããã³ãããèªã¿èŸŒãŸãããããŸããŠãŒã¶ã«ä»¥äžã®3ç¹ã確èªããããšïŒ
ææ³ç¯å²ãåå
察象ïŒåŠå¹Žãªã©ïŒ
ã¯ãŒã¯ãªã©ã®ç»å
STEP 1ïŒæ¬æã®èªã¿åããšã¢ãŒãéžæ
æ¬æããå
容ãè§£æãããŸã以äžã®éžæè¢ãæç€ºããŠãã ããã
â ããŸããã¢ãŒãïŒææ³äºé
1åã4æåé¡3åã穎åã3åãäžŠã³æ¿ã2åãè±èš³1åãèªåéžå®ã
â¡ ãã ããã¢ãŒãïŒãã§ãŒãºãåããŠåé¡ãéžæã
STEP 2ïŒåé¡ã®æçµç¢ºèª
決å®ãããåé¡ã»æ£è§£ã»è§£èª¬ïŒçŽåŸæã®ãã説æïŒãã£ã³ã¯ïŒãã®å
šãªã¹ããæç€ºãããŠãŒã¶ã®æ¿èªãåŸãŠãã ããã
â»åèš10ç¹ïŒå1ç¹ïŒã«ãªãããšãäŒããã
STEP 3ïŒGASã³ãŒãã®åºå
以äžã®ãGASã³ãŒããã³ãã¬ãŒããã®ã倿°ããŒã¿éšåãã®ã¿ãæžãæããŠåºåããŠãã ããããã³ãã¬ãŒãã®é¢æ°ããžãã¯ïŒFormAppã®ã¡ãœãããã§ãŒã³çïŒã¯ããšã©ãŒé²æ¢ã®ããäžå倿Žã»è¿œå ããªãã§ãã ããã
ãŸããGASã³ãŒããåºåããçŽåŸã«ã以äžã®**ãäœææé ã**ãå¿
ããŠãŒã¶ã«æç€ºããŠãã ããã
ãGoogleãã©ãŒã äœææé ã
GASã³ãŒããã³ããŒããã
Googleã¹ãã¬ããã·ãŒãïŒhttps://sheets.newïŒãéãã
ç»é¢äžéšãæ¡åŒµæ©èœãâãApps Scriptããã¯ãªãã¯ã
æåããå
¥åãããŠããã³ãŒãããã¹ãŠæ¶ããŠãã³ããŒããGASã貌ãä»ããã
ããããžã§ã¯ããä¿åãâãå®è¡ããæŒãã
æ¿èªã®æç¶ããè¡ãïŒ
ãæš©éã確èªããã¯ãªãã¯ã
ã¢ã«ãŠã³ããéžæã
ããã®ã¢ããªã¯ Google ã§ç¢ºèªãããŠããŸããããšåºãããå·Šäž**ã詳现ãâãç¡é¡ã®ãããžã§ã¯ãïŒå®å
šã§ã¯ãªãããŒãžïŒã«ç§»åã**ãã¯ãªãã¯ã
**ããã¹ãŠéžæãã«ãã§ãã¯ãå
¥ãããç¶è¡ã**ãã¯ãªãã¯ã
ç»é¢äžéšã«ãå®è¡éå§ãâ**ãå®è¡å®äºã**ãšè¡šç€ºãããããã¹ãã¬ããã·ãŒãã®ã¿ãã«æ»ãã
ã¹ãã¬ããã·ãŒãäžã«è¡šç€ºããã**ããã©ãŒã ãéãã**ãã¯ãªãã¯ããã
STEP ïŒ
ååé¡ã«è§£çãå
¥å
ïŒïŒåç®ããïŒïŒåç®ãŸã§ã®èšè¿°åŒã®è§£çãäžèЧã§åºåããããš
ãGASã³ãŒããã³ãã¬ãŒãã
function createEnglishQuiz() {
const formTitle = "ãããã«ã¿ã€ãã«ã";
// --- [倿°ããŒã¿éšåïŒãããæ¬æã«åºã¥ãäœæ] ---
const titleData = {q: "...", a: "...", choices: ["...", "..."], fb: "..."}; // 1åç®ïŒéžæåŒïŒ
const vocabData = [ /* {q: "...", a: "...", choices: ["...", "..."], fb: "..."} */ ]; // 2-4åç®ïŒéžæåŒïŒ
const comprehensionData = [ /* {q: "...", a: "..."} */ ]; // 5-10åç®ïŒèšè¿°åŒïŒfbãªãïŒ
// ----------------------------------------------
const form = FormApp.create(formTitle);
form.setIsQuiz(true)
.setPublishingSummary(true)
.setAllowResponseEdits(false)
.setProgressBar(true);
// åºæ¬æ
å ±å
¥å
const itemClass = form.addListItem().setTitle('çµ').setRequired(true);
itemClass.setChoices(['1çµ','2çµ','3çµ','4çµ','5çµ','6çµ'].map(t => itemClass.createChoice(t)));
const itemNo = form.addListItem().setTitle('åºåžçªå·').setRequired(true);
itemNo.setChoices([...Array(40)].map((_, i) => itemNo.createChoice(String(i + 1))));
form.addTextItem().setTitle('æ°å').setRequired(true);
form.addPageBreakItem().setTitle('English Quiz');
// 1. ææ³ã®åºæ¬äºé
ïŒéžæåŒïŒ
const mcTitle = form.addMultipleChoiceItem().setTitle(titleData.q);
const fbTitle = FormApp.createFeedback().setText(titleData.fb).build();
mcTitle.setChoices(titleData.choices.map(c => mcTitle.createChoice(c, c === titleData.a)))
.setPoints(1).setFeedbackForCorrect(fbTitle).setFeedbackForIncorrect(fbTitle);
// 2-4. 4æåé¡ïŒéžæåŒïŒ
vocabData.forEach(item => {
const mc = form.addMultipleChoiceItem().setTitle(item.q);
const fb = FormApp.createFeedback().setText(item.fb).build();
mc.setChoices(item.choices.map(c => mc.createChoice(c, c === item.a)))
.setPoints(1).setFeedbackForCorrect(fb).setFeedbackForIncorrect(fb);
});
// 5-10. èšè¿°åŒåé¡ïŒä»æ§å¶éã®ãããã£ãŒãããã¯ãªãïŒ
comprehensionData.forEach(item => {
const textItem = form.addTextItem().setTitle(item.q);
textItem.setPoints(1);
});
const url = form.getEditUrl();
const html = '<p>äœæå®äºïŒ<a href="' + url + '" target="_blank">ãã©ãŒã ãéã</a></p>';
SpreadsheetApp.getUi().showModalDialog(HtmlService.createHtmlOutput(html).setWidth(300).setHeight(100), 'Success');
}
äœ¿ãæ¹ïŒ3ããŒãïŒ
ããŒãïŒ æ¬æãAIã«èªã¿èŸŒãŸãã
æ¬æïŒPDFã»ç»åã»ããã¹ãïŒãAIã«ã¢ããããŒãããŸãã
AIã®è³ªåã«çããŠãã ããã
AIãåé¡ãäœæããã®ã§ãå
容ã確èªã㊠ãOKã ãšéä¿¡ããŸãã
ããŒãïŒ GASã³ãŒããã³ããŒ
AIã Googleãã©ãŒã äœæçšã®GASã³ãŒã ãåºåããã®ã§ã
ãã®ã³ãŒãããã¹ãŠã³ããŒããŸãã
ããŒãïŒ Googleãã©ãŒã ãäœæ
ïŒãã®èŸºã¯AIãæç€ºããŠãããã®ã§ãåŸãã°OK
STEP1ãGASãã¹ãã·ã«ã³ãã
ãâ Googleã¹ãã¬ããã·ãŒããéã
ãâ¡ãæ¡åŒµæ©èœã âã Apps Scriptãã

ãâ¢æåã®ã³ãŒããåé€
ããâã³ããŒããGASã³ãŒãã貌ãä»ã
ãâ£ä¿å â å®è¡

ãâ€æš©éãæ¿èª

STEPïŒãã¹ãã·ã¬ããã·ãŒãã§ããã©ãŒã ãéãããã¯ãªãã¯

Googleãã©ãŒã 宿

ææ¥ã§ã®å®éã®äœ¿ãæ¹
ç§ã®ææ¥ã§ã¯ãã䜿ã£ãŠããŸãã
â å°ãã¹ããªã³ã¯é
åž
â¡ çåŸãè§£çïŒçŽ10åïŒ
⢠å³çµæè¡šç€º
⣠å
šäœã§è§£èª¬
éä¿¡ãããšãã®å Žã§ç¹æ°ãåºãã®ã§
ããããã¹å€ããã
ããã®ææ³å€§äºã ã£ããã
ãšããã®å Žã§æå°ã§ããŸãã
æçžŸãžã®æŽ»çš
Googleãã©ãŒã ã®çµæã¯èªåã§ã¹ãã¬ããã·ãŒãã«ä¿åãããŸãã
ããã貌ãã ãã§
æ¥ã ã®åªå
ææ¥çè§£
ãè©äŸ¡ã§ããŸãã
ð è©äŸ¡ã®è³ªãäžãããŸã
ãŸãšã
ææ¥ãå€ããã®ã¯ã倧ããªæ¹é©ã§ã¯ãããŸããã
å°ããªä»çµã¿ã§ãã
ãã®ããã³ããã¯
ð ãå°ãã¹ããç¶ç¶ã§ããä»çµã¿ã
ãäœãããã®ãã®ã§ãã
æåŸã«
ãããŸã§èªãã§ããã ãããããšãããããŸããã
ãããã®èšäºãåèã«ãªã£ãã
ã¹ã
ãã©ããŒ
ã³ã¡ã³ã
ã§å¿æŽããŠããã ãããšå¬ããã§ãïŒ
ä»åŸããææ¥ã楜ã«ãªãä»çµã¿ããçºä¿¡ããŠãããŸãã
ä»ã«ãããã«äœ¿ããããã³ããå ¬éããŠãŸãâ
#æè² #è±èªæè² #ææ¥æ¹å #è±èªæåž« #äžåŠè±èª #æåž«ã®ããã³ #AIæŽ»çš #çæAI #Googleãã©ãŒã #æçè¡
ãããªãšæã£ããå¿æŽãããïŒ
ãå
šãŠèªåã§åãããè±èªåŠç¿ã®ä»çµã¿ãæ¬æ°ã§äœã£ãŠããŸããææ¥ã ãã§ã¯åãŸããªãâç©ã¿äžãããªãâãå€ããææŠã§ããé¢çœããå¿æŽããããšæã£ãŠããã ãããå¬ããã§ããããã ããæ¯æŽã¯ã¢ããªéçºã»æææ¹åã«å€§åã«äœ¿ãããŠããã ããŸãã