M. Perzan - Rows2Cols

The Script-acular Start - Starting with GScripts (#2) This post will walk you through setting up your very first Google Apps Script to put some data in memory. We'll stick to a single spreadsheet and learn the basics of the GScript language. Want a video instead? The Sample Data and Our First Script Fi....

The GScript series continues! This post goes beyond macros to write your first script from scratch. Learn how to connect to a spreadsheet, load data into memory, and use essential debugging tools. Read more here: https://tinyurl.com/4mer8vhh
#GoogleSheets #CodingForBeginners #GScripts

Hidden Word Crossword Using AI Introducing the Crossword Spreadsheet Template – your ultimate tool for transforming traditional crosswords into engaging, interactive learning experiences!Tired of the tedious process of creating crosswords? Do your students find them less than thri...

Tired of dull crosswords? Revamp them with our AI-powered Crossword Spreadsheet Template! Create interactive "Hidden Word" puzzles that self-check & engage students. Save time, boost fun! 🔗 https://payhip.com/b/4ghFC #EdTech #GoogleSheets #AIinEducation

Thanks for the catch. I shouldn't do things late at night. At least you know it was made by a human?🤷‍♂️

Return Me! A Google Sheets and GScript Solution Tired of losing track of your loaned items?Imagine a world where you never have to wonder "Hey...where the heck did that go?" again! This isn't just a spreadsheet; it's your personal assistant for managing everything you lend out. Designed for maximu...

Tired of chasing down borrowed items? 😤 Our new spreadsheet tracks everything you lend! Get automated email reminders & easily mark returns. Reclaim your stuff! 🔗 https://payhip.com/b/oUu8G ▶️ See it in action: https://youtu.be/OSNAJ3PQDR0 #Spreadsheet #Organization #Productivity

Google Sheets Mastery - Number Format One out of three spreadsheet enthusiasts don't know how to use fractions. They try but they only get partially there. It's like the odds are stacked against them, they are fighting the percentages or ...

Got Sheets struggles? Fractions, leading zeros, or custom dates got you down? Learn Number Formatting to master your data! Plus, share your weirdest custom format for a discount! #GoogleSheetsMastery #NumberFormat #GoogleSheets tinyurl.com/ymc98xrk

Google Sheets Mastery - Conditional Formatting There is nothing more satisfying than checking a box and enjoying one thing off your list complete...wait, there is! The whole row strike through or the coloured row! Bold, italicize... I'm back. Sorr...

Tired of bland spreadsheets? Conditional formatting can transform your data, making it pop and revealing insights instantly! No more limp fish – just dynamic, easy-to-read sheets. Dive in: payhip.com/Rows2Cols/bl...

#GoogleSheets #DataVisualization #SpreadsheetTips #Productivity #ExcelTips

Digital Amazing Race LIVE! 🚀 Built with Google, EdPuzzle, AI for epic learning!
Race here: www.youtube.com/watch?v=SWFD...

It's part of the FREE Shake Up Learning Summer Series 2025! K-12 asynchronous PD. Join: shakeuplearning.com/blog/summer-...

#EdTech #ShakeUpLearning #FreePD #GoogleEdu

FREE Summer Learning Series for Teachers Join us at Shake Up Learning for an unprecedented online professional development event this summer. Our Summer Learning Series is a unique, free online learning experience designed specifically for K...

Okay, I'm a little excited...this is my first presentation in a virtual conference...fingers crossed. Come check me out on June 10th! "Create Your Own Digital Adventure ➡️ Amazing Race: Thunder Bay Edition!" shakeuplearning.com/blog/summer-...

Google Form Mastery: Bulk Setting Required Responses I have setup many...many Google Forms and editing them or setting up response scripts are a pain when there are multiple required fields. This became extremely tiresome and I created a script to eithe...

Google Forms added a few more question types so I updated the script to toggle required questions in the form. Check it out: smpl.is/972oc

Google Sheets Mastery - Adding Counts to Headers Filter Lists There is nothing worse than having to manually count anything on a spreadsheet...well, there are bigger life problems...but let's solve on thing at a time. Yes, you can make a new row at the top ...

Stop letting messy data slow you down! Discover how I leverage the dynamic duo of =COUNTA and =FILTER with Data Validation in Google Sheets to streamline data management and boost efficiency. Get the step-by-step guide on my blog: tinyurl.com/2vu5n3my
#GoogleSheets #Efficiency #SpreadsheetTips

Video Peer Feedback Save valuable class time while boosting student engagement with this streamlined approach to presentations and peer feedback.Students record their presentations using any preferred video app (we recommend Canva Video) and submit them via Google Class...

Student presentations in one class period! Use Canva Video (or any app), submit via Google Classroom, and feedback flows through Forms into Docs automatically. Rubric included. No more lost time! Try it here: https://smpl.is/a5okc
#EdTech #GoogleClassroom #EdInnovation

Badging Program Badges are a powerful motivator—and now they’re easy to automate.This system uses Google Forms, Sheets, and a simple script to track user progress across multiple forms and automatically award a badge once all tasks are complete.You can schedule task...

Just launched a fully automated badging system with Google Forms + Sheets! Set tasks, customize reminders, and let the badges roll in—no manual tracking needed. Perfect for educators, PD sessions, or self-paced challenges. Built by a teacher, for teachers. https://smpl.is/a5okb

Google Sheets Master - Self-generating Drop Down List Sometimes, you need a drop-down list that automatically updates as you enter data. This guide will show you how to create a dynamic drop-down using data validation and a compound formula.Here is a pre...

Self-Generating Drop-Down List? In Google Sheets, no less! Check it out here: tinyurl.com/5cxckw2h

🔹 Automate your data entry
🔹 Make your spreadsheets smarter
🔹 Save time with dynamic lists

#GoogleSheets #Automation #Spreadsheets #TechTips #ProductivityHacks #DataManagement

Using AI: Summary Activity Using AI with students is a double edged sword. AI can be a powerful learning tool, but when students use it to replace learning instead of enhancing it, problems arise. The challenge is to help stude...

I’m excited to share my latest blog post on using AI as a learning accelerator rather than just a replacement. This post focuses on summarization as the key activity, helping students engage with AI thoughtfully.

tinyurl.com/46maj6rc
#AIlearning #AIinEducation #summarization #edtech

Creating And Using Groups within Google Classroom Unlock the Power of Group Assignments in Google Classroom! As educators, we know that managing group work can be time-consuming. Our solution streamlines the process:Create Groups: Use our spreadsheet...

Google Classroom lets you create groups... but what about real collaboration on a document? If you need students to truly work together, check out this solution! payhip.com/b/GPuL0 #EdTech #GoogleClassroom #Teachers #Collaboration #ClassroomTool

Google Form Mastery - Single Entry Locked Forms This guide will help you collect and monitor students’ first drafts while ensuring they can use AI tools for refinement, but not for dishonesty. It offers a step-by-step process to create a secure, editable, and trackable assignment workflow using Go...

How do you tell if a student actually wrote something? It's getting really hard...but using locked Google Forms can help. Check out my blog post to see how to do it: https://smpl.is/a3da1
#studentwriting #googletips #lockedforms #googleapps #writingvalidation #writingtips

Converting the Files in a Google Folder into a Single PDF Streamline Your Google Printing Workflow! Find the spreadsheet template right here: https://payhip.com/b/Txm8kTired of the hassle of downloading and printing...

Printing multiple documents in Google Drive is a pain...until now! Check out our spreadsheet and script that combines all the Google Docs in one folder to single pdf...print once! https://smpl.is/a358l
#printinghacks #googleapps #googledrive #documentprinting #pdfprint #productivitytips

Google Form Mastery - Single Entry Locked Forms This guide will help you collect and monitor students’ first drafts while ensuring they can use AI tools for refinement, but not for dishonesty. It offers a step-by-step process to create a secure, editable, and trackable assignment workflow using Go...

Tired of AI "writing" assignments? We’ve got a step-by-step guide to use Google Forms, Docs, & Autocrat to track real student progress! Plus, troubleshooting tips for when Autocrat acts up. 🔧
Ready to level up? https://smpl.is/a2nts
#TeacherTech #EdTech #AutocratToTheRescue

Ownership? Sometimes it’s overrated. Drop files in a folder & wish you didn’t own them? This app lets you change ownership of all files to the folder owner. 🙌
Check it out: smpl.is/a237d
#ProductivityHacks #TeamworkMadeEasy #WorkSmarter #TechSolutions #OwnershipSimplified

Google Form Mastery: Automate Google Form Responses with Ease I'm often asked to handle routine tasks, one of the most common being the opening and closing of responses for a Google Form. There's nothing quite like sitting at your computer at 9:59, anxiously wai...

Ever sit there sweating as you need a form to accept responses (or stop accepting)? There is no need for that. Schedule it all using my handy little script: shorturl.at/vthcl #GoogleForms #VotingSystem #Automate

Copying a Google Folder Have you ever received a shared folder of valuable resources that you’d like to add to your own Google Drive? Or perhaps you have a folder with important files that you want to duplicate before making...

Heads up, Google Drive users! "Add to Drive" is now "Add shortcut." My Copy Folder sheet helps you make editable copies of shared folders. Get it here: payhip.com/b/D9bOi #googledrive

It’s a bird…it’s a plane…it’s SuperMerger for Google Docs! Update templates & files, and handle multiple merges effortlessly. Perfect for check-ins and feedback. Check out the article and video #SuperMerger #GoogleDocs #ProductivityBoost
payhip.com/b/Wdloe

Collecting Student Drafts Using Locked Google Forms This powerful spreadsheet streamlines student assessment and collaboration, making it a must-have tool for educators. Here’s how it works:1. Automated Data Collection:Our spreadsheet seamlessly collec...

Teacher have been loving it! Using Chromebooks and Google Forms to collect the 1st draft of student work and then unleashing it to use it with AI, peer editing and/or corrections. Watch the student progress! smpl.is/9zb3w
#chromebooks #googleforms #studentwork #technologyineducation #studentprogress

Google Form Mastery: Bulk Setting Required Responses I have setup many...many Google Forms and editing them or setting up response scripts are a pain when there are multiple required fields. This became extremely tiresome and I created a script to eithe...

Tired of fighting with Google Form's required responses while editing or scripting a solution? Come and see how I mastered it! Check out this blog post with the instructions, explanation and GScript! smpl.is/972oc
#googleforms #requiredresponses #gscript #formmastery

Google Slides Mastery: Digital Worksheets Using Google Themes Google Docs has limitations when it comes to handling images, and its layout features can be cumbersome unless you resort to unconventional table setups.Google Slides offers a much better solution as it can:be customized to any sizetext and images ca...

Create engaging digital worksheets with Google Slides’ themes! Customize layouts, and use placeholders for student input of text and pictures. Check out this step-by-step guide: https://smpl.is/9amsr #EdTech #GoogleSlides #DigitalLearning #Templates

Try Canva for Education for free Inspire learning through the power of visual communication. It’s 100% free for K12 teachers and their students.

Consistent character creation in Canva? I wish I figured this out....https://www.youtube.com/watch?v=5TuE7XOp4hM&t=433s. Add in a reference number with a description and generate sets of images close to each other. Plus free access for teachers and students (www.canva.com/education/)!

Word Cloud Using Google Apps With Moderation This is a powerful spreadsheet tool that empowers users to create stunning word clouds from phrases.Here’s how it works:Form Creation: Users can easily create a form to collect phrases or words.Dynamic Word Clouds: As phrases are submitted, the tool ...

Excited to introduce Word Cloud Using Google Apps with Moderation! Create dynamic word clouds from user-submitted phrases. ✅ Real-time moderation for control. 🔒 Privacy-first—no data leaves your domain. Get creative! https://smpl.is/98004 #WordCloud #GoogleApps #PrivacyFirst

Google Sheets Mastery - Formulas in Headers I've spent many hours creating and modifying a spreadsheet only to have a user delete my formulas and then wonder why it just doesn't work anymore. I've tried protecting cells but then they get angry as to why I don't let them touch cells so I unprot...

Eek! Users keep deleting formulas in my Google Sheets. So, I now hide them in the column headings. Find out how: https://smpl.is/9wz81

Copying A Google Folder Have you ever received a shared folder of valuable resources that you’d like to add to your own Google Drive? Or perhaps you have a folder with important fil...

How can you make a copy of a Google Folder? Easy...here you go: https://youtu.be/gSzTvHvuCGg. Oh, and it's free. Enjoy.
#googlefolder #copytutorial #videotutorial #googletools #techtips #freecopying #copyhack

Holy Macro! Starting with Google Scripts. Ever felt limited by Google Sheets formulas? Dive into Google Scripts for more power! Simple start to automation & time-saving features. smpl.is/9pdnb

#GoogleScripts #Productivity #Coding #Automation #GoogleSheets #GScript