Real-world Chat GPT, created by a current teacher, for teachers seeking task automation. Create AI-generated class task automation using Google Spreadsheets and Apps Scripts. Get and use templates for each class task (automatically created).
 |
Description
Book Introduction
Have you heard of the story of the young man who created a dating app using ChatGPT and earned 700 million won a month? Blake Anderson, with no prior knowledge of app development, used ChatGPT to create a high-profit dating app in just 12 months.
ChatGPT is helping to spread the awareness that programming skills are no longer limited to developers.
With this trend of the times, many changes are also taking place in the teaching profession.
There are also teachers who are creating websites that utilize AI for classroom use, and there are also increasing numbers of teachers who are using GPT to create various work automation programs and sharing them with the teacher community.
However, planning and creating class and work automation programs using ChatGPT is still burdensome.
Because to create a program, I need to ask GPT questions, but it is harder than I thought to ask questions that fit my situation and needs.
Moreover, since very basic coding knowledge is absolutely necessary to ask questions about program development, it is very difficult for absolute beginners.
Therefore, this book aims to cover Apps Script for Google Spreadsheets, one of the easiest ways to automate tasks, so that even complete beginners can easily create task automation programs using GPT.
We have included various practical examples and cases so that teachers can learn how to use AppScript (coding) and GPT while solving various problem situations in the classroom, and also learn the logic of coding.
Second, this book is also intended for teachers who do not have the time to learn AppScript coding but would like to use a program to handle tasks such as class formation, special classes (middle and high school), seating arrangements, and special room reservations.
In the “Using Templates” section, template links, instructions for use, and explanations are attached so that elementary or middle school teachers can easily use programs that are appropriate for each situation.
Teachers who are pressed for time can check the table of contents and copy the template for the program they need.
I hope this book will be a useful guide for many teachers.
We hope that ChatGPT and AppsScript will help teachers improve work efficiency and further contribute to creative teaching and a more relaxed teaching life.
Now, let's start together.
ChatGPT is helping to spread the awareness that programming skills are no longer limited to developers.
With this trend of the times, many changes are also taking place in the teaching profession.
There are also teachers who are creating websites that utilize AI for classroom use, and there are also increasing numbers of teachers who are using GPT to create various work automation programs and sharing them with the teacher community.
However, planning and creating class and work automation programs using ChatGPT is still burdensome.
Because to create a program, I need to ask GPT questions, but it is harder than I thought to ask questions that fit my situation and needs.
Moreover, since very basic coding knowledge is absolutely necessary to ask questions about program development, it is very difficult for absolute beginners.
Therefore, this book aims to cover Apps Script for Google Spreadsheets, one of the easiest ways to automate tasks, so that even complete beginners can easily create task automation programs using GPT.
We have included various practical examples and cases so that teachers can learn how to use AppScript (coding) and GPT while solving various problem situations in the classroom, and also learn the logic of coding.
Second, this book is also intended for teachers who do not have the time to learn AppScript coding but would like to use a program to handle tasks such as class formation, special classes (middle and high school), seating arrangements, and special room reservations.
In the “Using Templates” section, template links, instructions for use, and explanations are attached so that elementary or middle school teachers can easily use programs that are appropriate for each situation.
Teachers who are pressed for time can check the table of contents and copy the template for the program they need.
I hope this book will be a useful guide for many teachers.
We hope that ChatGPT and AppsScript will help teachers improve work efficiency and further contribute to creative teaching and a more relaxed teaching life.
Now, let's start together.
- You can preview some of the book's contents.
Preview
index
Part 1: Creating a Google Apps Script Task Automation Program with ChatGPT
1.
Apps Script in Google Sheets
2.
ChatGPT and Claude Sonnet
1) ChatGPT
2) Preparing Claude Sonnet
3.
AppsScript Task Automation Coding Basics
1) Preparing Apps Script in Google Spreadsheets
2) The function is a vending machine.
3) Explain the situation to ChatGPT.
4) Calling a function
5) Conditions
6) Create a button
4.
How to handle errors in Apps Script
1) How to confirm that an error has occurred
2) Send the code and error together.
5.
Develop your skills with real-life problems
1) Place students
2) Conditional student placement
3) Using Google Forms
6.
OnOpen function, OnEdit function
1) OnOpen function
2) OnEdit function
7.
User-defined functions
1) Create your own custom function
2) Create your own custom function using an API key.
8.
Creating a Website Using Google Sheets (Advanced Course)
1) Designing a site (HTML) with ChatGPT
2) Relationship between HTML and Apps Script
3) Connecting HTML and Apps Script using ChatGPT
4) Create a sheet to send personal information to specific students.
Part 2: Receive and Use Google Apps Script Task Automation Templates
9.
Receive and utilize business automation templates
1) Automating seat placement based on conditions (can be created using Claude Sonnet)
2) Class formation program (elementary and middle school) that meets the conditions (can be created using ChatGPT)
3) Create a website that provides students with personal information (can be created using ChatGPT or Claude Sonnet)
4) Selling items for 0 won
5) Document classification sheet
6) Duplicate removal statistics calculation questionnaire (can be created using ChatGPT and Claude Sonnet)
7) Creating NICE training materials
8) Student Document Collection Template (Can be created using ChatGPT or Claude Sonnet)
9) Listed mail merge, use in conjunction with Google Sheets (can be created using ChatGPT and Cloud Sonnet)
10) Create a schedule (elementary)
11) Using a mail merge name tag template (can be created using ChatGPT or Claude Sonnet)
12) Special room reservation system
13) Creating a rubric using Google Docs scripts and ChatGPT
14) Creating AI elementary school subject-specific assessment sentences
10. Receive and utilize AI class and assessment templates.
1) Class evaluation using AI chatbots
2) A site where students create questions and provide feedback.
11.
How to use the template for writing a student record (middle and high school)
1) Automatically create a survey in Google Forms
2) Create subject-specific details using student self-evaluation forms.
3) Automatically generate records of creative experiential activities (autonomous activities, club activities, career paths), behavioral characteristics, and developmental details using student self-evaluation forms.
4) Enhanced Google Spreadsheet viewing functionality - Growth conversations through student feedback
[Other Business Automation Templates]
1.
Apps Script in Google Sheets
2.
ChatGPT and Claude Sonnet
1) ChatGPT
2) Preparing Claude Sonnet
3.
AppsScript Task Automation Coding Basics
1) Preparing Apps Script in Google Spreadsheets
2) The function is a vending machine.
3) Explain the situation to ChatGPT.
4) Calling a function
5) Conditions
6) Create a button
4.
How to handle errors in Apps Script
1) How to confirm that an error has occurred
2) Send the code and error together.
5.
Develop your skills with real-life problems
1) Place students
2) Conditional student placement
3) Using Google Forms
6.
OnOpen function, OnEdit function
1) OnOpen function
2) OnEdit function
7.
User-defined functions
1) Create your own custom function
2) Create your own custom function using an API key.
8.
Creating a Website Using Google Sheets (Advanced Course)
1) Designing a site (HTML) with ChatGPT
2) Relationship between HTML and Apps Script
3) Connecting HTML and Apps Script using ChatGPT
4) Create a sheet to send personal information to specific students.
Part 2: Receive and Use Google Apps Script Task Automation Templates
9.
Receive and utilize business automation templates
1) Automating seat placement based on conditions (can be created using Claude Sonnet)
2) Class formation program (elementary and middle school) that meets the conditions (can be created using ChatGPT)
3) Create a website that provides students with personal information (can be created using ChatGPT or Claude Sonnet)
4) Selling items for 0 won
5) Document classification sheet
6) Duplicate removal statistics calculation questionnaire (can be created using ChatGPT and Claude Sonnet)
7) Creating NICE training materials
8) Student Document Collection Template (Can be created using ChatGPT or Claude Sonnet)
9) Listed mail merge, use in conjunction with Google Sheets (can be created using ChatGPT and Cloud Sonnet)
10) Create a schedule (elementary)
11) Using a mail merge name tag template (can be created using ChatGPT or Claude Sonnet)
12) Special room reservation system
13) Creating a rubric using Google Docs scripts and ChatGPT
14) Creating AI elementary school subject-specific assessment sentences
10. Receive and utilize AI class and assessment templates.
1) Class evaluation using AI chatbots
2) A site where students create questions and provide feedback.
11.
How to use the template for writing a student record (middle and high school)
1) Automatically create a survey in Google Forms
2) Create subject-specific details using student self-evaluation forms.
3) Automatically generate records of creative experiential activities (autonomous activities, club activities, career paths), behavioral characteristics, and developmental details using student self-evaluation forms.
4) Enhanced Google Spreadsheet viewing functionality - Growth conversations through student feedback
[Other Business Automation Templates]
Detailed image
.jpg)
GOODS SPECIFICS
- Date of issue: April 5, 2025
- Page count, weight, size: 224 pages | 528g | 174*246*15mm
- ISBN13: 9791193205532
- ISBN10: 1193205530
You may also like
카테고리
korean
korean
![GQ KOREA Mark (Monthly): December [2025]](http://librairie.coreenne.fr/cdn/shop/files/8ef265dbbfbf186523ed75ba7319009d.jpg?v=1765340328&width=3840)
