Part 1.
Preparing for the new semester (March)
Chapter 01.
Create a comprehensive homeroom teacher sheet to use throughout the year
1.
Managing Classroom Basics with Google Sheets_Automatically Collect Student Information by Linking Google Forms and Spreadsheets
2.
Accumulating and managing lifestyle attitudes_Systematically accumulating and managing lifestyle attitude data for each student.
3.
Quickly aggregate lifestyle attitudes_Automatically calculate the frequency of lifestyle attitude items using the COUNTIF function.
4.
Check the submission status of your household newsletter at a glance - Automatically determine submission status using AND and IF functions.
5.
Creating a Random Cleaning Zone Assignment Table_Automating Fair Zone Assignment with the RAND Function
6.
Find the data you want by searching for student number_Instantly search student information with the VLOOKUP function

Chapter 02.
Processing student information
1.
Extract only the necessary characters from the left, right, and center_Extract only the necessary information with the LEFT, RIGHT, and MID functions.
2.
Protecting Personal Information by Hiding Student Names_Masking Sensitive Information with the REPLACE Function
3.
Automatically replace specific characters_Batch replace characters with the SUBSTITUTE function

Chapter 03.
Improve sheet readability
1.
Fix main items to the screen_Fix rows/columns to make titles visible even when scrolling
2.
Sorting student counseling in order_Efficiently manage work order with the data sorting function.
3.
Colorize each line to improve readability of basic data_Clarify row distinctions with alternating colors
4.
Consistently Unifying Student Information_Standardizing Data Formats with Format Customization
5.
Copying only the appearance without changing the content - Maintaining style consistency with format copying
6.
Extract the data you need with just a few clicks - Use the filter function to quickly find only the information you want.
7.
Print your work neatly and efficiently - Optimize print settings to avoid paper waste.


Part 2.
Sharing and Collaboration (April-May)
Chapter 01.
Create collaborative documents in real time
1.
Data Entry Errors: Complete with Selection - Prevent Input Errors with Drop-Down Lists
2.
Digital resources open with a single click - Instantly connect to related documents with hyperlinks
3.
Real-time meeting minutes communication, ending with comments - The comment function improves the efficiency of non-face-to-face consultations.
4.
How to Manage Your Curriculum Budget at a Glance: Visualize Budget Execution with Tables and Charts
5.
Announcements and tasks all in one place! Create a shared grade sheet - Build a collaboration platform with checkboxes and sharing features.
6.
Building an automated equipment A/S system - Tracking processing status with drop-down and comment notifications.
7.
Visualize your authentication challenge to intuitively check progress_Create a mini-chart of participation using the SPARKLINE function.

Chapter 02.
Manage attendance together
1.
Easily check attendance in real time on your mobile device - Check attendance anytime, anywhere with the Google Spreadsheet app.
2.
Stop counting checkboxes! Automated attendance statistics with COUNTIF and SUM functions.
3.
Creating an Experiential Learning Attendance Visualization Sheet - Color-Changing Attendance Status with Conditional Formatting
Chapter 03.
Collaborate safely and without mistakes
1.
Do not edit here!_Lock down critical data with sheet and range protection.
2.
No more worries about mistakes while collaborating! Go back and restore revision history with version history.
Part 3.
Performance Evaluation and Grade Management (June-July)
Chapter 01.
Managing Performance Evaluations
1.
Understand student growth at a glance_Visualize individual growth trends with the SPARKLINE function.
2.
Understanding student performance assessments to boost student motivation - Real-time progress monitoring with checkboxes and charts
3.
Visualizing Student Competencies: Creating Multidimensional Competency Profiles with Pentagrams

Chapter 02.
Analyzing performance
1.
Smart conversion score processing_Automatically convert scores by interval using the IF function
2.
Create an automatically updated quiz report card_Reflect the highest and lowest scores in real time using the LARGE and SMALL functions.
3.
Set the student rankings in just 5 seconds_Instantly calculate rankings with the RANK function


Part 4.
Smart Transformation of Education Administration (August-September)
Chapter 01.
Streamlining reservations and management
1.
No Manual Work! The Secret to Smart Special Room Reservation Management: Automating Repetitive Tasks with Macros
2.
Managing study room reservations during exam periods_Automatically extract reservations that meet conditions using the FILTER function.
3.
Guide to Effective Supervisory Teacher Schedules_Pattern-Based Teacher Assignment with the REGEXMATCH Function

Chapter 02.
Organizing student information
1.
View the number of applicants by activity at a glance - Summary of participation status with column statistics
2.
Quickly find duplicate values ​​and reduce errors_Highlight duplicate data with conditional formatting
3.
Smartly Preparing for College Admissions Counseling: Multidimensional Performance Analysis with Pivot Tables
4.
Understanding Vast Information at a Glance: Implementing Dynamic Filtering with Slicers
5.
Stop infinite scrolling! Complete manual work with a single formula_Batch calculate entire ranges with the ARRAYFORMULA function.


Part 5.
Learning Data Management (October-November)
Chapter 01.
Consolidating multi-sheet data
1.
Gather scattered data to the desired location - Combine multiple ranges at once with curly brackets
2.
Manage multiple class sheets together_Link data between sheets using the IMPORTRANGE function.
3.
Selecting a minimum achievement level guaranteed guide target_Processing SQL data with the QUERY function

Chapter 02.
Managing class and grade data
1.
Finding the number of applicants for each career choice class_Counting the number of applicants who meet multiple conditions using the COUNTIFS function
2.
Summarizing student activity performance: Conditional sum calculation using the SUMIFS function
3.
Creating the Foundation for Next Year's Class Structure Based on Grades and Elective Subjects_Extracting Customized Class Structure Data with the FILTER Function

Chapter 03.
Write your learning records in a life log
1.
Fix mistakes in your sheets at once_Batch fixes with Find and Replace
2.
Combine two or more contents into one cell_Combine text with CONCATENATE and TEXTJOIN functions
3.
Smartly Splitting Attached Text_Structuring Data by Separating Text Columns
Part 6.
Finishing up your studies and preparing for the new school year (December to February)
Chapter 01.
Moving and converting data
1.
Automatically complete grades by subject with just your student number_Accurate data matching with the XLOOKUP function
2.
Automatically rearrange horizontal data vertically_Switch rows/columns with the TRANSPOSE function
3.
Insert URL images using the IMAGE function to view attached photos in survey responses without clicking.
4.
Stop checking grades! Easily check individual grades—Extract single values ​​based on conditions with the DGET function.

Chapter 02.
Automating your academic calendar
1.
Auto-complete entire dates by simply entering a reference date_Automate date calculations with the DATE function
2.
Calculating the Cumulative Number of Class Days_Cumulative Aggregation with the SUM Function and Absolute References
3.
Creating multilingual versions of your academic calendar without a translator_Automatically translating with the GOOGLETRANSLATE function

Chapter 03.
Automatically aggregate data within the report
1.
Stacking the enrollment status by class in a vertical row and collecting it all at once_Vertical data combination using the VSTACK function
2.
Automatically count the number of awards and people_Count unique values ​​using COUNT and UNIQUE functions
3.
Combine data horizontally using COUNTIF and HSTACK functions to collect the number of winners in a single row.

supplement
1.
Summary of basic functions
2.
Additional function summary
3.
Collection of practice sheets for each task
4.
Shortcut key collection
5.
Added and organized basic menu
6.
Take a look at the hidden menu
7.
Extension Guide
8. AI Utilization Guide

Providing solutions for each school work situation and introducing ways to use them to increase work efficiency!

It is systematically organized to fit the school's work flow, from preparing for the new semester at the beginning of the semester (March), sharing and collaboration (April-May), performance evaluation and grade management (June-July), smart transformation of educational administration (August-September), learning data management (October-November), and finalizing academics and preparing for the new school year (December-February).
Additionally, you can learn how to use Google Spreadsheets effectively and easily in work situations by understanding its core features necessary for solving work-related problems and solving problems yourself using the provided practice sheets.

All unit practice sheets and author-directed lecture videos provided!

For each learning activity, we provide practice sheets and videos of the author's lectures to help you acquire the learning content quickly and efficiently.
In particular, through the author's direct lecture videos provided via QR code, you can quickly grasp key functions and easily solve work situations, thereby increasing the effectiveness of your training and applying and utilizing it in other work situations.


Leverage generative AI and scripts!

You can learn how to quickly apply functions such as RAND, VLOOKUP, REPLACE, SPARKLINE, COUNTIF, and COUNTA using generative AI, and expand and experience the area of ​​task automation such as automating data sorting by generating Google Apps Script code.