How to Create a Student Checklist in GOOGLE SHEETS

How to Create a Student Checklist in GOOGLE SHEETS | Tutorial for Teachers

Рет қаралды 95,253

Күн бұрын

Don’t forget to like, comment, and subscribe so you don’t miss future videos!
MY TEACHERSPAYTEACHERS STORE:
www.teacherspayteachers.com/S...
POCKETFUL OF PRIMARY MERCHANDISE:
www.etsy.com/shop/Pocketfulof...
MY AMAZON FAVORITES:
bit.ly/pocketfulofprimarystore
__________________________________________________________________
STUDENT CHECKLISTS GOOGLE SHEETS TEMPLATE:
www.teacherspayteachers.com/P...
__________________________________________________________________
Find me on my other social media platforms:
INSTAGRAM: @pocketfulofprimary
PODCAST: teachingonthedouble.com/podca...
FACEBOOK: / pocketfulofprimary
PINTEREST: / pocketfulofprim
BLOG: www.pocketfulofprimary.com
E-MAIL: pocketfulofprimary@gmail.com
__________________________________________________________________
My description includes referral codes/links that allow me to earn points or credit that can be redeemed for products and/or subscriptions. When you use my referral code/link, you are helping to support me and my recommendations! Thank you for your support!

Пікірлер: 220

@audriegarton8244 Жыл бұрын

I needed this! I have been struggling to collect homework every morning and checking off who has completed it and who has not! I love this! It was easy to follow along as well! I would love more Google Sheets tutorials!

@traceyferville4308 Жыл бұрын

Laminate a sheet and use a transparency marker to check off then input the grades during free time.

@PocketfulofPrimary Жыл бұрын

Aww, that's great to hear Audrie! I'm so happy this was helpful for you and I appreciate you watching and commenting! 🖤

@erinchanning1902 Жыл бұрын

thank from an oldie just entering her 3rd yr of a career change as preschool teacher and tech not so savvy this was amazing i’ll be making so many sheets now hahahaha

@suejohns2394 11 ай бұрын

Agree more google sheets, etc. Thanks

@jenniferludy5510 Жыл бұрын

This is amazing! I love these tutorials. Short sweet and to the point! I've already started revamping my sheets and this has worked beautifully! Thank you for your hard work and dedication to other teachers.

@daylemiller-ramsey6446 Жыл бұрын

I would love it if you did a video that showed how to link the sheets to create the missing work that auto populates or could you share where you learned it. Would like to create a weekly work checklist for students where they could see work they need to do for class.

@DayTrripperr 8 ай бұрын

I agree!!!

@mrsfed.4110 Жыл бұрын

It never fails everytime there I watch one of your videos there is a moment where my mind is blown. I use sheets for check lists but never thought about making strips for keeping track of marking! This is a game changer for me…

@PocketfulofPrimary Жыл бұрын

Aww, thank you so much! I'm so happy you found this helpful and I appreciate you watching and commenting! 🖤

@jillsmith7988 10 ай бұрын

@@PocketfulofPrimary0:48 😅😅😅😅😊🎉🎉🎉🎉😮😮😮😊9⁰00090000000⁰⁰0⁰😢😢

@elisewarner963 Жыл бұрын

I watch your videos because 1. You’re awesome. 2. You love order as much as I do. I didn’t even need to watch this one but holy hell, I got an idea while viewing and just created a checklist that’s gonna make my work so much more organized and satisfying. Who doesn’t like checking shit off lists? Thanks, Michelle!

@nelliefranco2668 Жыл бұрын

I always look forward to seeing your videos. Thank you for this one. Teachers always need checklists and I love how you’re able to add the checkboxes and color code the rows. I usually use Google docs but Google sheets has so many cool options. I will be experimenting with this today during my prep. Thank you once again for a wonderful tutorial. 🎉

@PocketfulofPrimary Жыл бұрын

Aww, thank you so much for watching and commenting Nellie! I appreciate you so much and I'm so happy you got some new ideas! 🖤

@fasting50plus 8 ай бұрын

Wow!!! Amazing. I've been looking for the solution to crappy checklists for years. From one perfectionist to another...thank you Michelle!!

@sallysnyder499 11 ай бұрын

You're an amazing teacher! Thank you for sharing your hacks, your talent, your enthusiasm for teaching and learning!

@annwoodruff6383 Жыл бұрын

SUCH a great tutorial! I now have so much confidence to create a sheet!!! Thank you so much for taking the time to show us HOW to create something that looks so good!

@PocketfulofPrimary Жыл бұрын

Woo! That's wonderful to hear Ann! I'm so happy it was helpful for you and I appreciate you watching and commenting! 🖤

@michelleboyle5009 Жыл бұрын

Great content, as usual! You always teach me something new about programs I use all the time. Automatically coloring alternate rows is a game changer!

@PocketfulofPrimary Жыл бұрын

Aww, thank you so much Michelle! I appreciate you watching and commenting! 🥰🖤

@alexismorehead8391 Жыл бұрын

Michele Emerson--you are a GIRL BOSS!!! I LOVE LOVE your video tutorials! (and your podcasts, your TPT and your youtube channel.) I just want to say I already have been using all google and know how to make sheets but the tips and shortcuts I learn from you are always usable and easy to follow! I am sharing with my teacher colleagues. Thank you for all you do for the teacher community. I also pass your videos to my daughter who has gotten into lifting and macros. You are an absolute inspiration and I love following your journey!

@PocketfulofPrimary Жыл бұрын

Aww, thank you SO much Alexis! 🖤 I really appreciate you watching and commenting with all your kind words and support! I'm happy you've been able to learn from my tips and thank you so much for sharing with your colleagues! You ROCK! 🖤

@russellpalatiere8852 Жыл бұрын

Perfect content as always! I am definitely switching over to google sheets now for all my tracking. I grew up with Excel and got certified in Excel before I graduated college and thankfully most of the ideas are the same. I am now using checklists for my job since there is so much to do and I will definitely miss something without it😂

@PocketfulofPrimary Жыл бұрын

Thank you so much Russell! I'm with you... I am certified in Excel as well and grew up using it but I've pretty much converted to all things Google now!

@nicolebedford3517 9 ай бұрын

You are a lifesaver! I made my checklist as a watched and it is perfect. Thank you!

@ameyer72900 Жыл бұрын

Your videos have helped me so much. You give clear and thorough directions. I really appreciate you.

@PocketfulofPrimary Жыл бұрын

Thank you so much Allison! 🖤 I appreciate YOU watching and commenting!

@redfebruary5125 9 ай бұрын

Thanks Michelle for sharing. I'm definitely finding ways to make my teacher life easier and more productive.😊

@zoecalifornia80 Жыл бұрын

Thank you so much. I followed along with you and made a checklist for my childcare schedule. Then I went back and played with it to try other stuff. Thank you so much. So helpful. I'm trying to learn and it was a bit easier to follow you.

@claudinelindenhofen7710 Жыл бұрын

Love this video! So easy to follow, just love your tutorials! Thank you so much for sharing all your great ideas!

@PocketfulofPrimary Жыл бұрын

Aww, thank you so much Claudine! I'm happy you enjoyed it and really appreciate you watching and commenting! 🖤

@CarmenJimenez-lt7hb Жыл бұрын

This was SO helpful! Thank you , Michelle. As an instructional coach, I am working more with data (and Google Sheets) this year than ever before. I learned some tips and tricks. I also would love more Google Sheets Tutorials! Gracias!

@PocketfulofPrimary Жыл бұрын

Ahhh, that's wonderful Carmen! I'm so happy this was helpful for you and I appreciate you watching and commenting!

@ceciliacazares3493 Жыл бұрын

Michelle this was very helpful! Can you also teach us how to generate those colors for certain criteria such as the ones you use on the slides? That too would be amazing.

@PocketfulofPrimary Жыл бұрын

Thank you so much Cecilia! 🖤 Yes! That's coming in the next video... don't worry!

@dhines3804 Жыл бұрын

This was really helpful! I’ll be rewatching this and trying it out! I would love to see more videos on sheets as I have used them but don’t feel as confident with them as I’d like to be. Anything tips you’re willing to share would be great! Thanks, Michelle!

@PocketfulofPrimary Жыл бұрын

Aww, thank you so much! I'm so happy it was helpful for you and I appreciate you watching and commenting! 🖤 Don't worry... I have more tips coming in the next video!

@robinwilson133 Жыл бұрын

Michelle, this tutorial was GREAT! Thank you sooo much. As I’ve said several times before, I learn so much from you. Keep up the great work AND good luck this week on your upcoming competition.

@PocketfulofPrimary Жыл бұрын

Aww, thank you so much Robin! I'm so happy you found it helpful and I appreciate you watching and commenting! 🖤

@monicamayenchcirera6596 Жыл бұрын

Great tutorial! Complete, easy to follow and from scratch! Very, very useful. Thank you very much!

@PocketfulofPrimary Жыл бұрын

Aww, thank you so much for watching and commenting Monica! 🖤 I'm so happy it was helpful for you!

@michellepadilla6671 9 ай бұрын

I just created my very first Google Sheet with your help. You made it so easy!! Thank you so much!

@mariamalnuaimi8973 Жыл бұрын

Thank you Very Much, for This Video. It Has a Positive Impact Well, not a parcel more than a parcel, but nonetheless, I appreciate you taking the time to help people and know where they are. In fact, anything I struggle with, I can find in your recordings the best information, so once again, thank you.

@jenniferyun981 11 ай бұрын

Thank you so much for the clear directions! I created new Sheets right along with you!

@learningthroughcircumstanc8446 Жыл бұрын

Thank you thank you thank you!!!! First year teacher here and I am struggling. School just started and this checklist tutorial is soooo helpful

@missnew9244 Жыл бұрын

This was super helpful! I'd love to see how you made your missing assignment list if you have any instructions on this? Thank you!

@BeautylovelyloverBlogspot24 Жыл бұрын

Awesome video! I just used it to create a checklist for daily class participation and also for discussions! Thank you :D

@oknenm67 11 ай бұрын

I learned so much from this tutorial. You are a wonderful teacher!

@suejohns2394 11 ай бұрын

Thank you so much Michelle, i have learned so much from you. Thanks again. Your amazing. You must rock those observations!

@jodibowen9993 9 ай бұрын

This was so helpful. Thank you for guiding us through this!

@emiworkman5924 Жыл бұрын

This is amazing! Could you do a tutorial on how to link the automatic missing assignments list?

@samreenmuhammaddawood6536 6 ай бұрын

This helped me alot even as a student who makes checklists to keep track of how much syllabus I covered or how many topical pastpapers I have done

@greekgodess311 Жыл бұрын

I was totally intimidated by this program but you’ve made it seem very doable! Thank you!😎

@PocketfulofPrimary Жыл бұрын

Aww, that's what I love to hear Megan! Thank you SO much for watching and commenting! 🖤

8 ай бұрын

Michelle really helps out a lot. Thank you so much Michelle!

@amandawilkins8403 Жыл бұрын

Michelle, thanks for such an informative video that will help all teachers save time and make their jobs so much easier. As always, your directions are super clear and detailed. I hope you know how much you are appreciated by so many teachers for your ideas. Have a wonderful weekend and a successful week leading up to your birthday and powerlifting meet!

@PocketfulofPrimary Жыл бұрын

Aww, thank YOU so much Mandy! I appreciate you watching and commenting as always and I hope you're having a great weekend! Thank you for all the well wishes! 🖤

@yagirlQ21 Жыл бұрын

Omggg this was sooo helpful! Thank you for dropping straight gems! Question: how do you set it to where if you check the box all the ones that are not checked will be highlighted?

@sandrahuling9775 Жыл бұрын

This is another great how to video from you. Very clear and useful! 👍🏻👍🏻

@PocketfulofPrimary Жыл бұрын

Aww, thank you so much Sandra! 🖤 I appreciate you watching and commenting!

@salamarinita Жыл бұрын

You are a goddess. This is the best Exxcel tutorial I have ever watched. It seems like you have slowed down your speech a bit. In the past some of your tutorials were a bit too fast for me. This pace is perfect for me. I love your channel!

@charlottedibben2651 Жыл бұрын

Amazing! Thank you so so much for sharing your knowledge! You’re the ideal educator ❤

@PocketfulofPrimary Жыл бұрын

Aww, thank you so much Charlotte! I appreciate you watching and commenting! 🖤

@victoriaarmour9210 11 ай бұрын

I love your videos! Learnt soooo much!!! Thank you!

@missa9146 Жыл бұрын

Oh my goodness! I created a checklist in Sheets last week! Even set up a system for when I hand back work, and students resubmit.

@natashafriegang3847 11 ай бұрын

I just made my own along with you. GAME CHANGER! Thank you so much! It looks so good! Can you tell I'm excited?! LOL.

@pamela.imagines.p10 Жыл бұрын

Thanks for this video. I am so bummed about the negative responses from parent phone calls I made today and then gained a ray of hope from this helpful video.

@PocketfulofPrimary Жыл бұрын

I'm so happy you enjoyed it Pamela! Thank you for watching and commenting! 🖤

@tiffanismiley7393 Жыл бұрын

This tutorial was amazing! Please do another where you show us how to do the other things you mentioned at the end. I love to learn!

@PocketfulofPrimary Жыл бұрын

Aww, thank you so much Tiffani! Don't worry... some of those things are coming in the next video! Thanks for watching and commenting! 🖤

@ameliehaas6902 Жыл бұрын

Another amazing video!! let’s just talk about how many times Michelle said, “that looks pretty good!” ❤

@PocketfulofPrimary Жыл бұрын

Hahaha, I have to reassure myself along the way!

@erinchanning1902 Жыл бұрын

❤❤❤❤❤ THANK YOU!! Com and oldie(53) heading into her 3rd yr of a career change as a preschool teacher and a not so tech savvy this was amazing & easy to follow i used it to make a check list for small group. I will be making check lists for everything hahaha 😅thank you again!

@PocketfulofPrimary Жыл бұрын

Aww, thank you so much Erin! I'm so happy I could help you with the technology and you were able to put it to use right away! Thank you for watching and commenting! 🖤

@aratalheinz3579 Жыл бұрын

This was so helpful. I love your tutorials. Thank you!

@PocketfulofPrimary Жыл бұрын

Thank you so much for watching and commenting! 🖤

@maril.c.storsve938 Жыл бұрын

Just what I needed! 🙌👍 Love your hackes and tips! 💐

@PocketfulofPrimary Жыл бұрын

Thank you so much for watching Mari! 🖤

@ms.miller9167 Жыл бұрын

This is a game changer. I have been using sheets but didn't know how to do this! Thanks! More like this please!!!!

@PocketfulofPrimary Жыл бұрын

Aww, wonderful! I'm so happy you were able to learn some new things! Thank you for watching and commenting!

@amymarcial6812 Жыл бұрын

Watching this thinking about how inefficient I am! 🤪 I’m the highlight every other row one by one kinda girl. But, not anymore!! Thanks for this awesome tutorial! This will save me so much time!!! Love your content!!

@PocketfulofPrimary Жыл бұрын

Hahaha, that was me for a while too! I'm happy this was helpful for you and thank you so much for watching and commenting! 🖤

@traceyferville4308 Жыл бұрын

Yes! I love Google Sheets and Forms that generate the sheets! I use it all the time! I made a similar on with my high schooler that track their do nows, classwork, participation, exit ticket and homework. each are 10 points a day and it calculates the points each week :)

@PocketfulofPrimary Жыл бұрын

Yes! That's fantastic! Thank you for watching and commenting Tracey! 🖤

@chelseaculverhouse2771 10 ай бұрын

This is perfect for data binders and CFU's. Perfect for so many things!🎉

@athumanmngumba Жыл бұрын

Thanks for your advice. I was able to download the Editable sheets

@TEAwithchass 10 ай бұрын

You have helped me! Thank you so much, I appreciate you!

@kathyurbina8178 Жыл бұрын

Thank you for sharing and teaching this. ❤

@estefaniabuschamaya4315 Жыл бұрын

This is amazing!! Thank you! Would it be possible for you to teach us how create a calendar on google sheets?

@karentucker5208 Жыл бұрын

I learn so much from your videos! Thank you!

@PocketfulofPrimary Жыл бұрын

Thank you so much Karen! 🖤 I really appreciate that!

@juliedubois3569 Жыл бұрын

This will help me so much!!! Thank you!

@aidant9876 Жыл бұрын

thank you for another amazing video you have helped me be organized and productive

@PocketfulofPrimary Жыл бұрын

Thank you so much for watching Aidan! 🖤

@user-sr5ym9sm9k 10 ай бұрын

This was so helpful, thank you so much!

@hekios888s6 10 ай бұрын

This is awesome. Thank you so much! Please tell me how to do the missing assignment list!

@user-vk6wu1tn2t 10 ай бұрын

Thank you, thank you! I learn a lot from you.

@tgray0914 Жыл бұрын

This was perfect!!! Thank you, Michelle!!

@PocketfulofPrimary Жыл бұрын

Thank you so much for watching and commenting! 🖤

@averygrace2105 Жыл бұрын

I love this! It helps me 💯! Could you make a Google Docs video, showing good ways to use Google docs????

@PocketfulofPrimary Жыл бұрын

I'll definitely add Google Docs to my list for future videos! Thank you for watching and commenting! 🖤

@anitaweir1480 Жыл бұрын

I did not know one could totally change the format and get rid of all those lines! Finally, something I can make for myself, and adapt with different service minutes for students or mainstream!!!

@carolinekelly3415 Жыл бұрын

Thanks for sharing. I like all of your videos.

@roseruiz1494 Жыл бұрын

Thank you for sharing. I will definitely create several checklists.

@PocketfulofPrimary Жыл бұрын

Thank YOU for watching and commenting Rose! 🖤

@user-jw9qk7xq4c Жыл бұрын

I love it!!! Thank you.

@cassandralytch-colter2133 11 ай бұрын

OMG...Thank you. I have been wanting to work more with Google/MS and "chicken" out. I took classes in college and made it through and that's where it stopped.

@reginahall3290 Жыл бұрын

Hello Michelle! Great video… so helpful👍. I will be making my lists today! I love the colors of the paper on your bookshelf. Do you have the code/numbers to find them when choosing a color? Thank you for your help. 😊

@kristinjaklitsch4803 Жыл бұрын

I know what my project is on my day off tomorrow! Thank you!

@PocketfulofPrimary Жыл бұрын

Woo! Hopefully this helps make it easier for you! You're welcome and thank you for watching and commenting! 🖤

@pteach9957 Жыл бұрын

Yes! This was a great video. Please do more. Thank you!

@PocketfulofPrimary Жыл бұрын

Thank you so much for watching and commenting! 🖤

@gracebleekman2557 Жыл бұрын

Thank you so much I’m in training to become a teacher and I love your videos so much.

@PocketfulofPrimary Жыл бұрын

Thank you for watching and commenting Grace! 🖤

@gracebleekman2557 Жыл бұрын

@@PocketfulofPrimary Of course I love your channel.

@tashnik Жыл бұрын

Michelle I love this! More Google Sheets tutorials pleaseeeee

@PocketfulofPrimary Жыл бұрын

I have more coming! Thank you so much for watching and commenting! 🖤

@elingoodwin5039 Жыл бұрын

So helpful! Thank you. I got a few fantastic tips.

@PocketfulofPrimary Жыл бұрын

Thank you so much for watching and commenting Elin! 🖤

@MakeItWithMich Жыл бұрын

Honestly every single video of yours I learn something and I think… how have I gone without doing this my whole teaching career?

@PocketfulofPrimary Жыл бұрын

Haha! I love to hear that! Thank you so much for watching and commenting! 🖤

@kaitEBee Жыл бұрын

That is so funny! For years my favorite font was Oswald (which I know is one you love, Michelle), but this school year Poppins has been my favorite. 😅

@PocketfulofPrimary Жыл бұрын

Hahaha, yes! I loved Oswald for a while but I love that Poppins is a font family so there are a bunch of options that all match together. Thank you for watching and commenting as always! 🖤

@lizlong6349 Жыл бұрын

This is amazing. I just made a checklist right along side with you. Thank you. Now I am dying to know how you make it highlight boxes that have not been checked. That would be so helpful. How do you do that? Thank you.

@ruthukattah8725 Жыл бұрын

Awesome! Thanks for sharing.

@suecastillo3898 Жыл бұрын

Yay! I love to see a new video pop up in the morning from you 🤗I can’t wait to get home from my first grade practicum hours to watch today !!! Ty for your content Michelle … ❤Teacher in training ~Sue

@PocketfulofPrimary Жыл бұрын

Aww, thank you so much for watching Sue! 🖤 I appreciate you and I wish you the best of luck in your practicum hours!

@la.vida.teacher Жыл бұрын

Sheets is not one of my favorites but I want to THANK YOU for giving me ideas on how to use sheets for something other than numbers.

@PocketfulofPrimary Жыл бұрын

Absolutely! It wasn't my favorite for a while but it's grown on me a LOT because there are so many great ways you can use it! Thank you for watching and commenting Isabel! 🖤

@dinahorgan Жыл бұрын

This. Was. Awesome!! How did you set the automatic highlight with the one simple click for all those boxes???

@suzanneawtrey6346 Жыл бұрын

Michelle, Thank you so much! This was exactly what I needed. I will share with my partners. I’ve been teaching for 30 years and your videos along with your podcast with Bridgette has helped me tremendously with my organization and productivity and makes me want to keep teaching. You rock, girl!

@PocketfulofPrimary Жыл бұрын

Thank you so much for watching and sharing all your kind words Suzanne! We really appreciate your support and are so happy that our podcast (and my videos) have been helpful for you! You rock too lady! 🖤

@elizabethcardoza9191 11 ай бұрын

Thank you for posting this.

@syukris.pd.i5726 10 ай бұрын

thanks... very usefull for the teacher...

@nmrgrl55 Жыл бұрын

I would LOVE a tutorial about all that awesomeness at the end of the video!

@PocketfulofPrimary Жыл бұрын

I'll be showing how to do some of those things in the next video so stay tuned! 🖤

@maraenea8456 Жыл бұрын

How did you learn all of this stuff?!?! You are an expert on so many things!!! Thank you for sharing your knowledge!

@PocketfulofPrimary Жыл бұрын

I've been tech-savvy since I was a kid and got certified in Microsoft during high school so a lot of the skills transfer over to Google very easily. Thank you so much for watching and commenting! 🖤

@mirandam8852 Жыл бұрын

THANK YOU THIS IS AMAZING!

@amandaros3 Жыл бұрын

This is soooooo helpful!

@MrYoTeach Жыл бұрын

Super helpful even if they were just refreshers for myself. :)

@PocketfulofPrimary Жыл бұрын

Thank you so much Andrew! I appreciate you!

@nicolestuder7130 Жыл бұрын

Thank you so much, I'm always been intimadated by trying to make a page like that. (I loved this so much I watched all the commercials so you get credit for it) I would like to make a page with more "check off" type rows. Do you know about how many would fit on a page? Thank you again for being such a great help and support for teachers!!!

@PocketfulofPrimary Жыл бұрын

Aww, thank you so much Nicole! You rock! Honestly, you can add as many as you want! The maximum number of rows for Google Keep is 5 million so you should be good, ha! Thank you for watching and commenting! 🖤

@josephgonzalez4479 Жыл бұрын

This is fantastic and you are AMAZING! I made a checklist for testing results but I can't figure out the formulas etc. For example, I want anyone who scores between 0-400 to get one color, 401-800, another color, etc. I see videos on how to do it but I can't get it to work, any insights would be much appreciated

@ronnygefferson5294 Жыл бұрын

Genious. Very useful.

@lostsoul5848 Жыл бұрын

Thank you so much!!!!!!

@TracyKMainwaring 11 ай бұрын

I’m using this tutorial to create checklists for my kids to do while my husband and I are on vacation. I’ll be able to check it daily to make sure the dog got fed LOL.

@natalianickolcheva2529 Жыл бұрын

Thank you for such a great video👍

@PocketfulofPrimary Жыл бұрын

Thank you so much for watching Natalia!

@heidiebersole2265 Жыл бұрын

I'm sure Bridget is soooo proud of you! :) I was at your live and did this along with her in the last session. I've been wondering if there is a way to write in a cell that also has a checkbox? For example, for collecting student work, I'd love to mark a check when I collect an assessment (my checkboxes are to the left), but then I'd like to add the grade beside the checkbox on the right. Hope that makes sense.

@PocketfulofPrimary Жыл бұрын

Hi Heidi! I hope you're doing well! I'm actually the one who showed Bridget most of this LOL 😂 But the simple answer is no... you can have a checkbox or text but not both so you would have to have two columns... one for the checkbox and one for the score next to it!

@jodyfarkas-maclean-dolsonp4354 11 ай бұрын

Hi! I’m brand new to Google Sheets and I’ve watched sooooo many of your videos. You explain everything so well. I was wondering if its possible to have 2 checkmark boxes in 1 column? I can’t figure it out in Google Sheets.