{"product_id":"156474","title":"Google Spreadsheets: A Practical Guide to Making Schoolwork Easier ","description":"\u003ccenter\u003e\u003cdiv style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/tmgdisk01.cafe24.com\/images\/vs\/4172\/sv\/3jYDPqIlHpz8FTeMI3zr6xIK3vHNmS.png?v=1765083163\" style=\"max-width:100%;max-height:10px\"\u003e\u003c\/div\u003e\u003c\/center\u003e\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\u003ccenter\u003e\n\n\u003cdiv style=\"width:95%\"\u003e\n\n\u003cdiv style=\"text-align:center;font-size:30px;font-weight:bolder;line-height:1.6em\"\u003e Google Spreadsheets: A Practical Guide to Making Schoolwork Easier \u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"border-bottom:1px;border-bottom-style:dotted;border-color:;padding-bottom:20px\"\u003e\u003ccenter\u003e\u003ctable align=\"center\" width=\"100%\"\u003e\u003ctbody style=\"border:0px\"\u003e\n\n\u003ctr\u003e\u003ctd align=\"center\" style=\"line-height:1.2em;text-align:center;font-size:18px;color:black;font-weight:bold;padding-bottom:20px;\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\n\n\u003ctr\u003e\u003ctd style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/image.yes24.com\/goods\/163495217\/XL\" style=\"max-width:100%;height:auto\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\u003c\/table\u003e\u003c\/center\u003e\u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"width:95%;{split_style6}padding-top:20px;padding-bottom:20px\"\u003e\n\n\u003cdiv style=\"text-align:left;font-size:16px;font-weight:bold;padding-bottom:20px\"\u003e Description \u003c\/div\u003e\n\n\u003cdiv style=\"text-align:left;word-break:break-all;font-size:14px;line-height:1.6em;\"\u003e\n\n\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eBook Introduction\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\u003cdiv\u003e \u003cb\u003eFrom preparing for the new semester to finishing the semester, all the essential functions are covered in one book!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e From creating basic classroom materials needed for the start of a new semester to automatically completing grades at the end of the semester, we've systematically organized the content teachers need most in one book, tailored to the school's workflow. \u003cbr\u003eThis guide covers in detail, step-by-step, how to efficiently solve real-life work situations that teachers encounter in schools by utilizing the core functions of Google Spreadsheets, such as processing student information (LEFT, REPLACE functions), real-time collaboration (dropdown, comments), performance assessment grade processing (IF, LARGE, SMALL functions), and academic calendar automation (DATE, GOOGLETRANSLATE functions).\u003cbr\u003e\u003cbr\u003e \u003cb\u003eEven if you don't know Excel well, anyone can easily learn business automation with Google Spreadsheets!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e Don't worry if you're not an Excel expert or familiar with complex functions! We'll guide you through creating functions and organizing tables using Google Sheets' built-in AI features, all with witty explanations.\u003cbr\u003e We also aim to transform education administration into a smarter place, providing guidance on key features that enable teachers to easily and securely manage student data, collaborate in real time, assess performance, and manage grades.\u003cbr\u003e\n\u003c\/div\u003e\u003c\/div\u003e\n\u003cdiv\u003e\u003cul\u003e  \u003cli\u003eYou can preview some of the book's contents.\u003cbr\u003e \u003cspan\u003ePreview\u003c\/span\u003e\n\n\u003c\/li\u003e\n\u003c\/ul\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eindex\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e Part 1.\u003cbr\u003e Preparing for the new semester (March)\u003cbr\u003e Chapter 01.\u003cbr\u003e Create a comprehensive homeroom teacher sheet to use throughout the year\u003cbr\u003e 1.\u003cbr\u003e Managing Classroom Basics with Google Sheets_Automatically Collect Student Information by Linking Google Forms and Spreadsheets\u003cbr\u003e 2.\u003cbr\u003e Accumulating and managing lifestyle attitudes_Systematically accumulating and managing lifestyle attitude data for each student.\u003cbr\u003e 3.\u003cbr\u003e Quickly aggregate lifestyle attitudes_Automatically calculate the frequency of lifestyle attitude items using the COUNTIF function.\u003cbr\u003e 4.\u003cbr\u003e Check the submission status of your household newsletter at a glance - Automatically determine submission status using AND and IF functions.\u003cbr\u003e 5.\u003cbr\u003e Creating a Random Cleaning Zone Assignment Table_Automating Fair Zone Assignment with the RAND Function\u003cbr\u003e 6.\u003cbr\u003e Find the data you want by searching for student number_Instantly search student information with the VLOOKUP function\u003cbr\u003e\u003cbr\u003e Chapter 02.\u003cbr\u003e Processing student information\u003cbr\u003e 1.\u003cbr\u003e Extract only the necessary characters from the left, right, and center_Extract only the necessary information with the LEFT, RIGHT, and MID functions.\u003cbr\u003e 2. \u003cbr\u003eProtecting Personal Information by Hiding Student Names_Masking Sensitive Information with the REPLACE Function\u003cbr\u003e 3.\u003cbr\u003e Automatically replace specific characters_Batch replace characters with the SUBSTITUTE function\u003cbr\u003e\u003cbr\u003e Chapter 03.\u003cbr\u003e Improve sheet readability\u003cbr\u003e 1.\u003cbr\u003e Fix main items to the screen_Fix rows\/columns to make titles visible even when scrolling\u003cbr\u003e 2.\u003cbr\u003e Sorting student counseling in order_Efficiently manage work order with the data sorting function.\u003cbr\u003e 3.\u003cbr\u003e Colorize each line to improve readability of basic data_Clarify row distinctions with alternating colors\u003cbr\u003e 4.\u003cbr\u003e Consistently Unifying Student Information_Standardizing Data Formats with Format Customization\u003cbr\u003e 5.\u003cbr\u003e Copying only the appearance without changing the content - Maintaining style consistency with format copying\u003cbr\u003e 6.\u003cbr\u003e Extract the data you need with just a few clicks - Use the filter function to quickly find only the information you want.\u003cbr\u003e 7.\u003cbr\u003e Print your work neatly and efficiently - Optimize print settings to avoid paper waste.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e Part 2.\u003cbr\u003e Sharing and Collaboration (April-May)\u003cbr\u003e Chapter 01.\u003cbr\u003e Create collaborative documents in real time\u003cbr\u003e 1. \u003cbr\u003eData Entry Errors: Complete with Selection - Prevent Input Errors with Drop-Down Lists\u003cbr\u003e 2.\u003cbr\u003e Digital resources open with a single click - Instantly connect to related documents with hyperlinks\u003cbr\u003e 3.\u003cbr\u003e Real-time meeting minutes communication, ending with comments - The comment function improves the efficiency of non-face-to-face consultations.\u003cbr\u003e 4.\u003cbr\u003e How to Manage Your Curriculum Budget at a Glance: Visualize Budget Execution with Tables and Charts\u003cbr\u003e 5.\u003cbr\u003e Announcements and tasks all in one place! Create a shared grade sheet - Build a collaboration platform with checkboxes and sharing features.\u003cbr\u003e 6.\u003cbr\u003e Building an automated equipment A\/S system - Tracking processing status with drop-down and comment notifications.\u003cbr\u003e 7.\u003cbr\u003e Visualize your authentication challenge to intuitively check progress_Create a mini-chart of participation using the SPARKLINE function.\u003cbr\u003e\u003cbr\u003e Chapter 02.\u003cbr\u003e Manage attendance together\u003cbr\u003e 1.\u003cbr\u003e Easily check attendance in real time on your mobile device - Check attendance anytime, anywhere with the Google Spreadsheet app.\u003cbr\u003e 2. \u003cbr\u003eStop counting checkboxes! Automated attendance statistics with COUNTIF and SUM functions.\u003cbr\u003e 3.\u003cbr\u003e Creating an Experiential Learning Attendance Visualization Sheet - Color-Changing Attendance Status with Conditional Formatting\u003cbr\u003e Chapter 03.\u003cbr\u003e Collaborate safely and without mistakes\u003cbr\u003e 1.\u003cbr\u003e Do not edit here!_Lock down critical data with sheet and range protection.\u003cbr\u003e 2.\u003cbr\u003e No more worries about mistakes while collaborating! Go back and restore revision history with version history.\u003cbr\u003e Part 3.\u003cbr\u003e Performance Evaluation and Grade Management (June-July)\u003cbr\u003e Chapter 01.\u003cbr\u003e Managing Performance Evaluations\u003cbr\u003e 1.\u003cbr\u003e Understand student growth at a glance_Visualize individual growth trends with the SPARKLINE function.\u003cbr\u003e 2.\u003cbr\u003e Understanding student performance assessments to boost student motivation - Real-time progress monitoring with checkboxes and charts\u003cbr\u003e 3.\u003cbr\u003e Visualizing Student Competencies: Creating Multidimensional Competency Profiles with Pentagrams\u003cbr\u003e\u003cbr\u003e Chapter 02.\u003cbr\u003e Analyzing performance\u003cbr\u003e 1.\u003cbr\u003e Smart conversion score processing_Automatically convert scores by interval using the IF function\u003cbr\u003e 2. \u003cbr\u003eCreate an automatically updated quiz report card_Reflect the highest and lowest scores in real time using the LARGE and SMALL functions.\u003cbr\u003e 3.\u003cbr\u003e Set the student rankings in just 5 seconds_Instantly calculate rankings with the RANK function\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e Part 4.\u003cbr\u003e Smart Transformation of Education Administration (August-September)\u003cbr\u003e Chapter 01.\u003cbr\u003e Streamlining reservations and management\u003cbr\u003e 1.\u003cbr\u003e No Manual Work! The Secret to Smart Special Room Reservation Management: Automating Repetitive Tasks with Macros\u003cbr\u003e 2.\u003cbr\u003e Managing study room reservations during exam periods_Automatically extract reservations that meet conditions using the FILTER function.\u003cbr\u003e 3.\u003cbr\u003e Guide to Effective Supervisory Teacher Schedules_Pattern-Based Teacher Assignment with the REGEXMATCH Function\u003cbr\u003e\u003cbr\u003e Chapter 02.\u003cbr\u003e Organizing student information\u003cbr\u003e 1.\u003cbr\u003e View the number of applicants by activity at a glance - Summary of participation status with column statistics\u003cbr\u003e 2.\u003cbr\u003e Quickly find duplicate values ​​and reduce errors_Highlight duplicate data with conditional formatting\u003cbr\u003e 3.\u003cbr\u003e Smartly Preparing for College Admissions Counseling: Multidimensional Performance Analysis with Pivot Tables\u003cbr\u003e 4.\u003cbr\u003e Understanding Vast Information at a Glance: Implementing Dynamic Filtering with Slicers\u003cbr\u003e 5. \u003cbr\u003eStop infinite scrolling! Complete manual work with a single formula_Batch calculate entire ranges with the ARRAYFORMULA function.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e Part 5.\u003cbr\u003e Learning Data Management (October-November)\u003cbr\u003e Chapter 01.\u003cbr\u003e Consolidating multi-sheet data\u003cbr\u003e 1.\u003cbr\u003e Gather scattered data to the desired location - Combine multiple ranges at once with curly brackets\u003cbr\u003e 2.\u003cbr\u003e Manage multiple class sheets together_Link data between sheets using the IMPORTRANGE function.\u003cbr\u003e 3.\u003cbr\u003e Selecting a minimum achievement level guaranteed guide target_Processing SQL data with the QUERY function\u003cbr\u003e\u003cbr\u003e Chapter 02.\u003cbr\u003e Managing class and grade data\u003cbr\u003e 1.\u003cbr\u003e Finding the number of applicants for each career choice class_Counting the number of applicants who meet multiple conditions using the COUNTIFS function\u003cbr\u003e 2.\u003cbr\u003e Summarizing student activity performance: Conditional sum calculation using the SUMIFS function\u003cbr\u003e 3.\u003cbr\u003e Creating the Foundation for Next Year's Class Structure Based on Grades and Elective Subjects_Extracting Customized Class Structure Data with the FILTER Function\u003cbr\u003e\u003cbr\u003e Chapter 03.\u003cbr\u003e Write your learning records in a life log\u003cbr\u003e 1.\u003cbr\u003e Fix mistakes in your sheets at once_Batch fixes with Find and Replace \u003cbr\u003e2.\u003cbr\u003e Combine two or more contents into one cell_Combine text with CONCATENATE and TEXTJOIN functions\u003cbr\u003e 3.\u003cbr\u003e Smartly Splitting Attached Text_Structuring Data by Separating Text Columns\u003cbr\u003e Part 6.\u003cbr\u003e Finishing up your studies and preparing for the new school year (December to February)\u003cbr\u003e Chapter 01.\u003cbr\u003e Moving and converting data\u003cbr\u003e 1.\u003cbr\u003e Automatically complete grades by subject with just your student number_Accurate data matching with the XLOOKUP function\u003cbr\u003e 2.\u003cbr\u003e Automatically rearrange horizontal data vertically_Switch rows\/columns with the TRANSPOSE function\u003cbr\u003e 3.\u003cbr\u003e Insert URL images using the IMAGE function to view attached photos in survey responses without clicking.\u003cbr\u003e 4.\u003cbr\u003e Stop checking grades! Easily check individual grades—Extract single values ​​based on conditions with the DGET function.\u003cbr\u003e\u003cbr\u003e Chapter 02.\u003cbr\u003e Automating your academic calendar\u003cbr\u003e 1.\u003cbr\u003e Auto-complete entire dates by simply entering a reference date_Automate date calculations with the DATE function\u003cbr\u003e 2.\u003cbr\u003e Calculating the Cumulative Number of Class Days_Cumulative Aggregation with the SUM Function and Absolute References\u003cbr\u003e 3.\u003cbr\u003e Creating multilingual versions of your academic calendar without a translator_Automatically translating with the GOOGLETRANSLATE function\u003cbr\u003e \u003cbr\u003eChapter 03.\u003cbr\u003e Automatically aggregate data within the report\u003cbr\u003e 1.\u003cbr\u003e Stacking the enrollment status by class in a vertical row and collecting it all at once_Vertical data combination using the VSTACK function\u003cbr\u003e 2.\u003cbr\u003e Automatically count the number of awards and people_Count unique values ​​using COUNT and UNIQUE functions\u003cbr\u003e 3.\u003cbr\u003e Combine data horizontally using COUNTIF and HSTACK functions to collect the number of winners in a single row.\u003cbr\u003e\u003cbr\u003e supplement\u003cbr\u003e 1.\u003cbr\u003e Summary of basic functions\u003cbr\u003e 2.\u003cbr\u003e Additional function summary\u003cbr\u003e 3.\u003cbr\u003e Collection of practice sheets for each task\u003cbr\u003e 4.\u003cbr\u003e Shortcut key collection\u003cbr\u003e 5.\u003cbr\u003e Added and organized basic menu\u003cbr\u003e 6.\u003cbr\u003e Take a look at the hidden menu\u003cbr\u003e 7.\u003cbr\u003e Extension Guide\u003cbr\u003e 8. AI Utilization Guide\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eDetailed image\u003c\/b\u003e \u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\u003cdiv\u003e\u003cimg src=\"https:\/\/image.yes24.com\/momo\/TopCate6026\/MidCate004\/602532228.jpg\" border=\"0\" alt=\"Detailed Image 1\"\u003e\u003c\/div\u003e\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003ePublisher's Review\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e \u003cb\u003eProviding solutions for each school work situation and introducing ways to use them to increase work efficiency!\u003c\/b\u003e\u003cbr\u003e \u003cbr\u003eIt 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).\u003cbr\u003e 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.\u003cbr\u003e\u003cbr\u003e \u003cb\u003eAll unit practice sheets and author-directed lecture videos provided!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e 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. \u003cbr\u003eIn 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.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e \u003cb\u003eLeverage generative AI and scripts!\u003c\/b\u003e\u003cbr\u003e\u003cbr\u003e 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. \u003cbr\u003e\n\n\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"width:95%;padding-top:20px;padding-bottom:20px\"\u003e\n\n\u003cdiv style=\"text-align:left;font-size:16px;font-weight:bold;padding-bottom:20px\"\u003e GOODS SPECIFICS \u003c\/div\u003e\n\n\u003cdiv style=\"text-align:left;font-size:14px;line-height:1.6em;\"\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eDate of issue:\u003c\/strong\u003e January 5, 2026\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003ePage count, weight, size:\u003c\/strong\u003e 240 pages | 190*260*20mm\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eISBN13:\u003c\/strong\u003e 9791198347091\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eISBN10:\u003c\/strong\u003e 1198347090 \u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ccenter\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cspan\u003e\u003c\/span\u003e\n\n\u003c\/center\u003e\n\n\n\u003c\/center\u003e","brand":"LIBRAIRIE COREENNE","offers":[{"title":"Default Title","offer_id":43893483536426,"sku":"156474","price":34.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0683\/2750\/5962\/files\/341ab440de3f031c3ad4e200c8b52e06.jpg?v=1765403482","url":"https:\/\/librairie.coreenne.fr\/en\/products\/156474","provider":"LIBRAIRIE COREENNE","version":"1.0","type":"link"}