Ready for the next Pixel Art Video? ✨ Check out how to create different question types including words and special characters! kzitem.info/news/bejne/tmmIv5WAkWeQdII 😁
@Echdadevilthing
3 жыл бұрын
Wow! I was amazed by how easy this was! I was wondering how my teacher did this! Thank you so much!!
@senesajayasuriya
3 жыл бұрын
Hi, will this also work with words?
@ssiblings2793
3 жыл бұрын
Hi, found a way to do this with words. Check out this video, kzitem.info/news/bejne/pYyG3KuqrZmUqWk. Hope this helps. :)
@senesajayasuriya
3 жыл бұрын
@@ssiblings2793 Thank you so much!
@samanthadonis1369
3 жыл бұрын
I have been looking for a tutorial like this since last year! Can't wait to create one just like this for my middle schoolers!!
@classnotes
3 жыл бұрын
That's awesome, Samantha! This is a great activitiy for middle schoolers. 😁
@1kristygd
3 жыл бұрын
thank you so much for this tutorial! (I even impressed my 16yo with my creation---thanks to you!) I can't wait to use this in my classroom with my preschoolers!
@hardeepheer6240
3 жыл бұрын
I don’t know why people are disliking this?!?!
@tracyjr242
5 ай бұрын
Isn't it possible for to click on the image location and click 'conditional formatting' to REVEAL THE CORRECT ANSWERS? Help, how do I hide this?
@parkinfurkmaz2877
2 жыл бұрын
Uhhh, this is kinda insane for just a class worksheet. I don't remember my primary school teachers putting this much effort into my class. Props to you and keep up the good work; will definitely be sharing this with my friends who teach at primary schools! If you put this much effort into engaging the class, you definitely a lot more pay and a lot less criticism from Alan Tudge! P.S. Where/why did you learn coding? I'd bet very few teachers would know even the basic functions in Excel/Sheets that you're using
@classnotes
Жыл бұрын
I agree it takes time! I think the more you learn, the faster you get. I found it enjoyable to create these custom little projects for class and the students loved it. I try to learn new things to be better prepared for the future of work that students will find themselves in. I've done a Java subject at university, CS50 - free online course from Harvard, W3 schools for HTML/CSS - free online website, codecademy for Python. I have a general understanding of basics but honestly wouldn't be able to develop anything from scratch. Something you're interested in?
@lukeiris8914
3 жыл бұрын
Thank you! I kept meaning to figure out how to make these myself instead of taking from others, and with your help I made my first one!
@boxmanplayzyt
2 жыл бұрын
This is very helpful, thanks for making this tutorial.
@classnotes
2 жыл бұрын
You're welcome, thanks for leaving a comment! 😃
@lol_30
2 жыл бұрын
Thank you for this! I actually did TXT's Beomgyu (A K-pop singer) in pixel art! It came out so well!
@classnotes
2 жыл бұрын
Amazing!! I'd love to see your work. You can tag me on your socials: 🐦 Twitter - twitter.com/ncaiAU 📷 Instagram - instagram.com/classnoteswithnicole
@lol_30
2 жыл бұрын
@@classnotes Oh sure! I will! Thanks again!
@raisaameer
11 ай бұрын
Thank you so much❤❤❤❤
@classnotes
11 ай бұрын
You're welcome 😊
@chicchi1682
3 ай бұрын
You are awesome
@classnotes
2 ай бұрын
Thanks, you too 😁
@voodog4414
6 ай бұрын
this is easy! but can you tell me how to do it in excel? The ui is a little different but i cant figure it out. it works great in gs though! ty
@cam7751
2 жыл бұрын
Thank you so much!! This rlly helped.
@classnotes
2 жыл бұрын
Thank you Esmeralda for your lovely comment! 😁
@itworks9368
2 жыл бұрын
Thank you.
@classnotes
2 жыл бұрын
You're welcome! Thanks for leaving a comment!
@RebeccaSmith-xd5lk
Жыл бұрын
I am following the video. I have the art drawn. When I put in the =$B$2 it is fine but when I add the 2 it changes the color to the default light blue. I have rewatched the tutorial, tried over and over, and it still won't work.
@classnotes
Жыл бұрын
Let's see if this works: 1. Click on cell B2 2. Go to the toolbar: Format > Number > Select "Automatic Text". 3. Try redoing the formula again You can download the template to play around with it yourself as well nicolesnotes.com.au/free/
@astridgremillet978
3 жыл бұрын
Thank you very much for this great tutorial, it was really fun to create a first game! Is it possible to require the case of the text while respecting the upper and lower case letters (in chemistry this is important, for exemple i want Ag and not "AG" or "ag"). I share your site and your YT channel, it's fantastic!
@classnotes
3 жыл бұрын
Hi Astrid! Thank you! That's a use case I hadn't thought about yet! A little tricky, but here we go! Let's say your answer cell is E9 where you want the answer to be "Ag". 1. Select the cells in the picture that you want to appear. 2. Go to Conditional Formating > Custom Formula and type the formula =NOT(EXACT(E9, "Ag")) 3. Change the Fill Cell colour to White. I hope this helps. The function EXACT(String 1, String 2) checks that the two pieces of text are exactly the same (case sensitive).
@nicholasdunn999
3 жыл бұрын
Super fun, thank you! I will use this with students for sure. SO many applications here for review, study, fun... for student and teacher. :)
@classnotes
3 жыл бұрын
Thanks Nicholas!! Your students will love it 😁
@sandragallo5380
3 жыл бұрын
Amazing! Thank you so much for this tutorial- I would have had NO idea how to do this and want to do it for some of my classes!
@classnotes
3 жыл бұрын
Thanks for leaving such a positive comment! That’s great to hear!! 😄
@audreygoss7330
2 жыл бұрын
This was really easy and a great tutorial! Is there a way to make a printable version? I'm guessing I would put numbers in the cells and give them a legend? Is there an easier way?
@classnotes
2 жыл бұрын
Yes I also think you would have a legend because the students would need to know which colours to use for the picture to come out right :)
@lacihickman9998
3 жыл бұрын
THIS IS SO AWESOME!! Thank you! I am currently trying to adapt this to slope. Would you happen to know how to put more than one correct answer choice in for the conditional formatting? For example, I need 4/-5 and -4/5 as possible answer choices. This is the formula I am using, I just don't know how to get that second choice in there. =$B$2"4/-5". Thank you so much!
@classnotes
3 жыл бұрын
Hey there you're welcome!! 😁 For two answers, you need to use the AND operator. =AND($B$2"4/5",$B$2"-4/5") So we're saying here, if students don't type 4/5 or -4/5 then colour the cell white. If students type the correct answer, the pixels will be revealed. I hope this helps!
@PenilGrimace
3 жыл бұрын
thank you im subing and likeing
@petravanduijn3922
3 жыл бұрын
Hi, Thank you so much! A question: do I need to use another formula when the answers are words?
@unicorniorhian
3 жыл бұрын
When the formula includes words, try putting quotation marks around them. 😊😊😊
@petravanduijn3922
3 жыл бұрын
@@unicorniorhian Thanks a lot! :-)
@unicorniorhian
3 жыл бұрын
@@petravanduijn3922 No problem! 😁😁😁
@triptisolanki9349
4 ай бұрын
Thank you so much!
@PenilGrimace
3 жыл бұрын
that video was so helpful
@sabriyecetinkaya614
3 жыл бұрын
Thanks Nicola.
@classnotes
3 жыл бұрын
😁
@susettewalton6912
Жыл бұрын
So very helpful!! Thank you so much!!!!
@classnotes
Жыл бұрын
Thanks for leaving a lovely comment :)
@Fille_des_iles_YGR
3 жыл бұрын
Thanks a lot!!!
@carlacosta3430
3 жыл бұрын
Hi Miss Nicole! This is awesome! Thank you for sharing your knowledge and expertise with all of us! How do I get access to the freebies? I'd love to try them out. Thanks so much!
@classnotes
3 жыл бұрын
Thanks Carla. I'm glad you enjoyed the video! You can download the freebies from www.nicolesnotes.com/free
@carlacosta3430
3 жыл бұрын
Thank you so much! I found them.
@ika2011indo
2 жыл бұрын
wow..your video is very easy to follow . Thank you so much for making this video. Can't wait to create one for my kids.
@miriamespinosa3306
3 жыл бұрын
Thank you for the tutorial!!! I had seen teachers do it, but had no idea in how it was done!
@classnotes
3 жыл бұрын
You're welcome, Miriam! 😁
@johnmckernan9576
3 жыл бұрын
This is Awesome! Thank you very much! What do i use for code, if I want my answers to be in word form? Thanks!
@classnotes
3 жыл бұрын
Hi John, I'm glad you enjoyed it!! For word answers check out my next video kzitem.info/news/bejne/tmmIv5WAkWeQdII - essentially you'll need to add quotation marks as well.
@johnmckernan9576
3 жыл бұрын
@@classnotes Thank you!
@janebland7016
3 жыл бұрын
What a fantastic idea. Thank you so much for sharing it.
@classnotes
3 жыл бұрын
You are so welcome!
@togitototofaeonomalepeai906
3 жыл бұрын
is this still available? I tried clicking on the link and nothing
@classnotes
3 жыл бұрын
Hi Koko, it should work now :) You can grab the freebies from nicolesnotes.com/free/
@togitototofaeonomalepeai906
3 жыл бұрын
Thank you!!
@lathakethu4023
3 жыл бұрын
thank you! beautiful idea to add that surprise element to math work !
@classnotes
3 жыл бұрын
You're welcome Latha! Yes seize every opportunity for engagement. :)
@ashleecastro55
3 жыл бұрын
What if we use a drop-down box that is created from a range of cells. How do we create conditional formating for a range of cells rather than just one cell?
@caglasuzenleventoglu6710
3 жыл бұрын
Thanx , you are amazing 🙋🏻♀️
@classnotes
3 жыл бұрын
Thanks for your positive comment!
@MrLee-bm9yf
3 жыл бұрын
Thank you very much!
@classnotes
3 жыл бұрын
You're welcome Mr Lee 😁
@brookebevan8218
3 жыл бұрын
Is there a way to include text or special characters in the answers?
@classnotes
3 жыл бұрын
Yes, of course! It works in the same way as the numbers - just need to add some quotations. I'm working on that video 😁
@brookebevan8218
3 жыл бұрын
Thank you!
@rovieriel621
3 жыл бұрын
This is so cool thank you!!!!
@classnotes
3 жыл бұрын
You're most welcome Rovie!
@mayay2735
3 жыл бұрын
This is awesome! Thank you 😊
@classnotes
3 жыл бұрын
You're welcome Maya!!
@nicolechristinaoconnellort2980
3 жыл бұрын
Thank you. So helpful
@classnotes
3 жыл бұрын
Glad it was helpful!
@aviannalv
Жыл бұрын
the fractions isn’t working
@classnotes
Жыл бұрын
I cover fractions in the follow up video kzitem.info/news/bejne/tmmIv5WAkWeQdII essentially you just need quotation marks in the formula 😀
@karalawson9297
3 жыл бұрын
Help! I have used your tutorial successfully before. Unfortunately when I try to have a fraction in the answer cell, =$B$9"1/2" does not work. Any ideas?
@classnotes
3 жыл бұрын
Kara's solved her own problem. Check the cell's "Number format" to make sure that "plain text" is selected. 💡
@daniellewokanick3653
2 жыл бұрын
Thank you so much for the tutorial! I think I followed all of the steps. I made a pixelated image and did the conditional formatting. Turned it white. When I type the correct answer, it doesn't change back to its original color. Any ideas? I did the =$B$1212 for each correct answer.
@classnotes
2 жыл бұрын
Hi Danielle, it sounds like you are following the right steps. Click on Cell B12 > Format (In the menu bar) > Number > Automatic. This is to make sure the Google Sheets is reading your input "12" as a number. You can also download the freebies to take a look at the conditional formatting. nicolesnotes.com/free/ Good luck!
@DragonSlawe
2 жыл бұрын
This doesn't solve my issue but it is awesome.
@angelagraham467
3 жыл бұрын
What kind of code would I use if I merged cells together and it wasn't considered ONE location? I am having a bit of trouble with this.
@classnotes
3 жыл бұрын
Try this: If you merged A1:A4, you can refer to the cell as A1 superuser.com/questions/928655/i-am-trying-to-reference-a-merged-cell-on-one-worksheet-and-have-it-copy-over-in
@beamingyuh1210
3 жыл бұрын
it doesnt work when i write "=$B$2-3/4" when the answer is -3/4. all it does it make it white and doesnt change when i put in the right or wrong answer.
@unicorniorhian
3 жыл бұрын
I tested it out myself. For me, you have to put =$B$2"-3/4" instead of just -3/4.
@sandrawright7991
2 жыл бұрын
Wow! Thank you for this tutorial!!
@bekahmelancon8583
2 жыл бұрын
Thanks for the help !
@suzannevelarde1816
3 жыл бұрын
This is amazing! Thanks for sharing.
@classnotes
3 жыл бұрын
You're welcome Suzanne!
@Silythx
2 жыл бұрын
Thank you so much!
@amandalong3373
3 жыл бұрын
Does this work with a Mac? When I select the pixel and hold down control it isn't collecting multiple pixels
@classnotes
3 жыл бұрын
Hi Amanda, try holding down the Command key on Mac
@alyc.k1821
3 жыл бұрын
WOww!! Thank you!! I wanted to learn how my teacher does this and this helped me alot!!!
@classnotes
3 жыл бұрын
You can try to make one yourself using a character of your choice! :)
@alyc.k1821
3 жыл бұрын
@@classnotes Ok!!! Thank you!!
@alyc.k1821
3 жыл бұрын
How do I make characters? Or I mean find characters to make.
@classnotes
3 жыл бұрын
@@alyc.k1821 You can make just about anything. Search "pixel art" into google for some inspiration. :)
@vycoprincess1859
3 жыл бұрын
this still dosent make any sense to me
@snake1987666
3 жыл бұрын
Pretty original idea! Is it possible to protect the paintint cells in order to not see the conditional formatting and avoid cheating?
@aaliyahcesaireLPT
Жыл бұрын
funny you said that cuz i came here to cheat 😭
@MsCueva-yu6hd
3 жыл бұрын
Thank you so much! Question: Do you know how to make the formula work for fractions? For example, when I put in =$B$6=3/4, the pixels don't appear. It's only working for whole numbers. Thanks!
@classnotes
3 жыл бұрын
Hi Ms. Cueva, try =$B$6"3/4". You want to say if 3/4 is not typed in then the cell should be white. Make sure the cell field is "Plain Text".
@MsCueva-yu6hd
3 жыл бұрын
@@classnotes Thank you so much for responding! : ) It's working now! Yay!
@heathersomersmartinezes4306
3 жыл бұрын
HI! Thank you so much for this tutorial! I am busy making some for my third graders! What if the answer is 0? The formula doesn´t seem to work with that. I typed =$B$60 Thank you for your time!
@classnotes
3 жыл бұрын
Questions with 0 as the answer works the same too. 3:54 Make sure you've selected the cells that will appear. Your custom formula is correct.
@elizabethpearson5981
3 жыл бұрын
I also was wondering this. When I do one with 0 they don't seem to disappear?
@samanthaellis569
3 жыл бұрын
Question--How do I make the answer turn red when it is incorrect?
@lanadowns7628
3 жыл бұрын
add another rule but only select the one that you want red if its wrong then select if not then put the answer in the little bubble thing then change it red and press done!
@karalawson9297
3 жыл бұрын
Nevermind! Making it "plain text" in the answer cell was the trick!!!
@classnotes
3 жыл бұрын
Great job figuring this one out - I've had this same issue before. I'll definitely be checking the cell's "Number Format" in the future. 😃
@kelbiburrell8881
3 жыл бұрын
Can you do this with fractions?
@kelbiburrell8881
3 жыл бұрын
just saw the answer down below! thanks!
@magicl2807
3 жыл бұрын
which music did you use for the timelapse i kinda want to listen to it when i grind video games
@magicl2807
3 жыл бұрын
and also this was very easy to follow, great tutorial
@classnotes
3 жыл бұрын
@Magic L Adventures by A Himitsu 😁
@davii2.0
3 жыл бұрын
how dii make it in the boxes like urs
@classnotes
3 жыл бұрын
1:15 Create a table look by using shading and borders.
@kristinerico9861
3 жыл бұрын
How do I grant my students access
@classnotes
3 жыл бұрын
7:23 Share Pixel Maths activity with students
@carolyntully5605
3 жыл бұрын
amazing! You explained this so well! Thanks for the tutorial!
@classnotes
3 жыл бұрын
Thanks for leaving such a positive comment, Carolyn!
@kourtmarie
3 жыл бұрын
Mine isnt working for some reason
@classnotes
3 жыл бұрын
Hey, you can download the Google Sheets file from www.nicolesnotes.com/free to take a look at the formulas.
@kourtmarie
3 жыл бұрын
@@classnotes I figured it out. Thank you!
@rupisha
3 жыл бұрын
What is the link, Miss Nicole?
@classnotes
3 жыл бұрын
Hey Rupa, you can download the Google Sheets file from www.nicolesnotes.com/free
@rupisha
3 жыл бұрын
@@classnotes Can you create with columms, Miss Nicole?
@chia-yinglu7187
3 жыл бұрын
This is an amazing idea!! Thank you!
@classnotes
3 жыл бұрын
You're welcome! Thanks for leaving a comment 😁
@lily-ht2fh
3 жыл бұрын
it doesnt work
@classnotes
3 жыл бұрын
Hi Lily, you can download the free template to play around with nicolesnotes.com/free/
Пікірлер: 140