Help Teachers Clear The List 2023

 

It's no secret that there is a teacher shortage in the United States, and seasoned teachers are leaving the profession in droves with no one to take their place. There is no easy answer to this problem, but one small act of kindness can go a long way. Many teachers spend hundreds of dollars of their own money every year on their classrooms. Here's a chance to show some love and support for teachers by gifting them something on their wishlist. You have no idea how much something like that means to a teacher!

Teachers, post your name, what you teach, the name of your school, and a link to your Amazon wishlist in the comments. When you create an Amazon wishlist, you can click on the button in the right hand corner that says. 'Send List to others.' Copy the link and paste it in your comment on this blog post. Let our community show their support by helping us clear the list!

 #ClearTheList #PayItForward #CommunitiesCare

Top 10 List for Teachers on #AmazonPrimeDay

Amazon Prime Day 2023 is on my birthday! Woot! Woot! July 11💗 - 12 Amazon has its biggest sales of the year, and you won't want to miss it! This post contains affiliate links for your convenience that give me a small stipend when you use the link, but at no cost to you.

First of all, if you are not an Amazon Prime member–it's time. It is $139 for the year, but I make that money back with their free 2 day shipping alone! With your Prime membership you also get to watch a lot of free movies on Prime Video, you get A LOT of free kindle books on Prime Reading, and you have to be an Amazon Prime member to get the deals on Amazon Prime Days. If you're not a Prime member yet, you can start with a free trial here.

Here is my top 10 list for teachers on #AmazonPrimeDay!

1.  Echo Show 5 (3rd generation 2023 Release)

 

This Echo Show is #1 on my list because it is what I'm most excited about on my Amazon list this year! I don't have an Echo Show yet, but this is how I imagine using it in my classroom. Right now, I have timers set on my phone to go off when it's time to switch to a new subject, and I'm planning on having the Echo Show set up to do that every weekday. I also think that I can set the alarms to snooze on days off. I can set timers during the day with just my voice, and the Echo Show has a digital clock and temperature display. We will use that daily. I can play Pandora (I like to play classical music when the students are working), and I imagine my class asking questions or how to spell things we need help with. I'm very excited to give it a try! There is a deal --buy one get $100 off the 2nd one, so I'm going to get one for my classroom and one for my son as a sophisticated alarm clock. That means one of them will be free! If you don't need 2, however, the Echo Dot is a cheaper option. The Echo Dot doesn't have the screen, but it should do everything else.

2. Dry Erase Clipboards (set of 30)

I really need these dry erase clipboards this year! I make sure my students have dry erase boards and clipboards, and since my classroom needs a refresh on dry erase boards, it makes more sense to get something that is 2 in 1 and save space and money! 

3. Scented Flair Pens

Scented flair pens are a must-have for me every year. I LOVE flair pens, and now that I have found scented, they are the best! The kids love smelling their paper when I draw a star on it! 

4. Magnetic Dry Erase Boards (set of 5)

I have been looking for a set of magnetic dry erase boards for my small groups. I use them for reading, math, and intervention groups, and they are magnetic because I use them with magnetic letters when necessary. These are double sided (both magnetic) with one side blank and one side with dotted lines.

5. Microfiber Hedgehog Erasers (set of 3)

I have a set of 6 of these super cute hedgehog erasers. I use them with my guided reading groups and intervention groups and the magnetic dry erase boards above!

6.  Better Than Paper White Shiplap

 

I LOVE this stuff! It is absolutely better than paper–it's true. It's very thick, so it's forgiving when you're hanging it. It doesn't get wrinkly, it doesn't show staples, and it doesn't fade. The pictures from my classroom above show the white shiplap, and it's at least 4 years old. I've moved schools in that time, so it has been taken down at one school and put up again in another, and it has held up well. I definitely think it's worth it!

7. Mini Plush Stuffed Dogs

I look for a class set of stuffed dogs every year. For Christmas, I let the kids adopt a dog as long as they promise to read to it for 20 minutes a day. It is a big hit with my 2nd graders every year! Check out this blog post from Teach Junkie that includes name tags for the dogs and adoption certificates. I try to plan ahead for presents to get the best deal possible. Amazon Prime day is a great day to stock up on Christmas presents!

8. 12 Pocket Poly Organizer

This is going to be for my guided reading groups. I like to use use a plastic, multi pocket binder to keep track of what each of my guided reading groups is doing. I keep a copy of the book that group is reading, the names of the students in that group, and any papers we may use. I'm looking for an organizer that has more pages to include all my intervention groups as well, and this one has a pencil pouch in the back too. 

9. Mochi's Squishys Toys (25 pieces)

This is another gift for my students that I plan ahead for so I can get the best deal. These squishy fidget toys are great non-candy Valentine's Day presents. Make tags that say, "I squish you a happy Valentine's Day," or print your own teacher valentines.

10. Calming Breath Sensory Stickers (64 pieces)

I'm really looking forward to trying these out this year. We try different breathing techniques when kids need it, and I think these textured stickers will big a big hit. I'm thinking about putting it on their desks, or maybe on the dry erase clipboards above so kids will be less likely to pick at them. 

Still looking for more ideas? Check out these past blog posts that have links to some great classroom supplies and organization.  Happy Shopping!

Organizing Your Classroom with these 4 IKEA shelves

I think every teacher can relate to the ongoing battle for organization. When we have to manage so much STUFF for so many little people, it can quickly get overwhelming! IKEA has some great furniture for your classroom that is durable and will keep you more organized. Here are some of my favorites worth investing in: 

1. Trofast bins

I ditched student desks awhile ago, and I'm never going back! Getting kids to keep their desks clean is a nightmare! They just don't do it. And no matter how many times we took the morning to clean out our desks and have visits from the desk fairy, there were always some kids that had a rat's nest and weird things growing in their desks.  So now the kids use tables and Trofast bins instead. They each have a drawer where they keep folders and notebooks, and it is at the front of my room. They are big enough that they can hold those important things but small enough that it's easy to keep organized. By having it at the front of the room, they can't have their hands in there all the time, and we have routines for getting supplies that give them a chance to get up and move periodically throughout the day. It's a win-win! They also have chair pockets where they keep a bag with a pencil, highlighter, expo marker, dry erase board, and their reading books for easy access. Trofast bins for the whole class can get a little pricey when you have a drawer for each student, but I could not teach without them now that I've done it this way! I've been using these bins for 4 or 5 years now, and I have not had to replace any. They're as good as new (maybe a bit dirtier, but otherwise in great shape!). Trofast bins are probably my #1 favorite teacher hack from IKEA.

2. Kallax Bookcase Shelving 

I use the Kallax Bookcase Shelving in my classroom library. I put pillows on the top and the kids use them as couches to sit and read, and I also have baskets of books underneath, so they do double duty as book shelves too! I use 3 as couches in my classroom library. Based on your available space, you can put them end to end or separate them. I have been using these shelves for 4 or 5 years as well, and they look almost as good as new. They are very sturdy, and the perfect height for my 2nd graders to sit on.

3. LACK Wall Shelf 

The Lack Wall Shelf makes a great book display! I put this at the front of the room near my teacher reading chair, and I rotate books that we are reading throughout the year. The kids get excited to see what is coming when I display books for a new learning theme. It's nice if you can mount this shelf to the wall for safety, but the current school I'm at wouldn't let me put holes in the wall, and I've never had a problem with it tipping in 3 years. It still looks new and it is sturdy.

4. Kallax Cube

I also ditched my teacher desk many, many years ago. Even though I don't sit at a big, bulky teacher desk, I still need a place to put stuff so it doesn't pile up. Several years ago I started using Kallax Cubes as my teacher area. You can leave the cube open (which I do on top), or use the fabric bins that fit inside to hold things (which I do on the bottom). They take up a minimal amount of room, but they still hold a lot of stuff in order to keep me organized. I've been using these Kallax cubes for at least 6 years, and they are still sturdy and look great. 

As teachers, we use so much of our own money to make things organized, efficient, and pretty in our classrooms. So if we're going to fork over the money, we need to make sure it's worth the investment. These 4 shelves have proved their stamina for me, an they're still going strong. They are classroom approved! And not only are they functional, but they're pretty. Several pictures from my classroom were featured in an article on We Are Teachers called 41 IKEA Classroom Supplies for Your Next Shopping Trip. Check it out! I'm the teacher Emily from Parker, CO. 

Good luck organizing your classroom!

ABC Family Fun

 

I've been teaching for 23 years, and I swear teaching is getting harder. I'm sure that is no surprise if you were in the teaching field before Covid, or if you've just been watching the news. So this post is just about unwinding, and taking some time to have fun with your family. Relax and enjoy the summer! I'm sure you've earned it. And what better way for a teacher (or student) to unwind than with ABC family fun? Try doing something different that starts with each letter of the alphabet. I've been doing this for years (before kids it was ABC dating with my hubby), and it'a a great way to try something new, get you out of your comfort zone, and have fun!

Some tips for trying #abcfamilyfun: 

1. Make a list for each letter of the alphabet ahead of time. 

I promise, you won't be able to remember what your plan is for each letter, and some letters take a lot of creativity! I check out local magazines and websites about fun things to do in my area and I take a day to write out all the options and we vote as a family. We try to balance it with things each person will be really excited about and things we've never done. You have to get creative sometimes! I make a list on my phone using Google Keep so I can pull it up wherever we are, and I can check things off the list once we've done it.

2. It doesn't have to cost a lot of money.

Things are SO expensive right now! There are plenty of fun things you can plan to do that don't cost money or are inexpensive. Be sure to include a balance of things. You can have a picnic, go to a free concert in the park, or fly a kite for little to no money. 

3. Big trips can include more than one letter.

If you already have a big vacation planned, make sure it counts as several letters. No doubt it is already costing a lot of money, and you probably have several thing planned so it should count as more than one thing on your list. For example, last year we went on a big trip to Mexico, so it counted as our letter M for Mexico, S for snorkeling, and C for catamaran (we rented a catamaran and went to a different island with a large group). 

4. You don't have to go in order.

Don't put a lot of rules on your family fun time, or it takes some of the fun out of it. Some activities that you want to do happen at a certain time, or your big trip is scheduled and it doesn't always match ABC order. Don't sweat it or you'll never get done! The point is to have fun trying new things, so don't worry about the order or how long it takes you to finish. We've been working on our current list for a year and a half. We should finish this summer! We do a lot more in the summer, and we fit in activities when we can during the school year. There don't have to be a lot of rules -- just have fun!

5. Be flexible and creative!

One of the reasons you want to make your list of activities ahead of time is so that you can move things around as needed. For example, we live in Colorado, so we always go to a Rockies baseball game in the summer. We can count this as B for baseball or R for Rockies or F for fireworks (we love to watch a game near the 4th of July because they shoot off fireworks). We pick the letter that fits best with out list that year. If we already have something planned for B, we call it our R letter. Some letters are tricky, so be creative and move things around until they fit in your list.

Even if you don't have any big trips planned for the summer, you can have a lot of fun trying new experiences! And then you have an ABC list to remind you of the things you did, because if you're like me, when someone asks what I did this summer, I can't always come up with an answer. I know I was busy, but I don't know exactly what I did! Now you can say, we did something starting with each letter of the alphabet. It starts an interesting conversation! Here are some ideas to get you started. Be sure to comment with your ideas, especially for the hard letters!

A

• Art Museum
• Aquarium
• Archery Games - We haven't done this yet, but I can't wait to try it!
• Alpine Slide

B

• Baseball game
• Basketball game
• Botanic Gardens
• Boondocks
• Butterfly Pavillion 
• Biking
• Bowling

C

• Cooking class - we did this at the Uncorked Kitchen! It was awesome! We'd definitely do it again. It was our first time doing a cooking class, and it was a lot of fun!
• Concert - our area has free concerts in the park all summer.
• Children's Museum
• Casa Bonita - We went before it closed, but it's reopened again! Can't wait to go back and watch those cliff divers!
• Comedy show
• Camping - this can be outside or with a blanket tent in the living room!
• Castlewood Canyon

D

• Dinosaurs Alive! This year there were some dinosaur experiences we got to see with dinosaur robots that moved. It was really cool!
• Dinosaur Ridge - this was our letter D a few years ago (can you tell my son is into dinosaurs?). It was really cool to take the tour of the trail around the area -- definitely something we'll do again!
• Dinner theater
• Dave & Busters
• Doughnut taste test - we discovered there are a lot of different doughnut shops in our area, so we had to try them all to find the best! #1 Crispy Cream #2 Lamar's Doughnuts #3 Hurts Doughnuts #4 Dunkin Doughnuts. I think there are a few we still haven't tried!
• Dog Sled rides 

E

• Elitch Gardens
• Egypt Time of the Pharaohs - this was an exhibit at our Nature and Science Museum this year which we did for our letter E
• Ethiopian food
• Mt. Evans
• Estes Park
• Exploding Kittens - this is a super fun family card game even your teenagers will play!

F

• Film on the Rocks - In Colorado, Red Rocks Amphitheater has a series called Film on the Rocks. You get to watch an old movie on the really big outdoor screen!
• Fireworks
• Frozen yogurt
• Farmer's Market
• Football game
• Food Tour

  G

• Ghost Tour - I found a historic walking ghost tour you could take in Denver that took us to the old mansions in downtown that were built in the 1800s or early 1900s and believed to be haunted. It was a cool history of the area and a fun walk!
• Great Wolf Lodge
• Garden of the Gods
• Golf, miniature golf
• Gel blasters - there is an Airsoft Field near us!
• Game night
• Gaylord Hotel

H

• Hiking
• Hot Air Balloon - there are many hot air balloon festivals in Colorado
• Hot Springs in Glenwood Springs
• Horse back riding
• Hammond's Candy Factory

I

• Inventing Room - this is something we tried this year that we've never done before! The Inventing Room Dessert Shop is like a mini version of Willy Wonka's Chocolate Factory! We went to a Sugar Science class and learned a lot about cooking with liquid nitrogen, and we got to eat a lot of yummy stuff! Super fun!
• Ice cream
• Immersive Monet - this exhibit was visiting our area, but we missed it. There are a lot of immersive art experiences to try though!
• Imax theater
• Indoor Skydiving
• Ice Castles - a winter activity that has been closed since Covid, but will hopefully open back up soon!
• Immersive Gamebox

J

• Jurassic World Domain movie - we did this as our letter J when the movie came out this year
• Juice Bar
• Jeep tour
• Jenga

K

• Fly a kite
• Kickboxing
• Karate Class
• King Tut exhibit - there was a special King Tut exhibit at our art museum a few years ago. Very interesting!

L

• Legos - we went to the lego store and picked something out to build together as a family.
• Library
• Laser Tag
• Littleton Historic Museum 

M

• Movie Night
• Musical
• Museum
• Mining for gold
• Make your own pizza - make your own dough and everyone in the family makes their own personal pan pizza with toppings of their choice!

N

• Nerf gun war - you can do this at home or go to Archery Games!
• Nature & Science Museum
• North Pole - Santa's Workshop

O

• Oreo dessert bar - this year we bought a bunch of different kind of Oreos and had a fun taste test of our favorites! You'd be surprised how many kinds there are!
• Opera
• Orchestra
• Origami

P

• Park
• Painting class
• Picnic
• Paintball
• Pirate's Cove water park

Q

• Qdoba
• Quandary Peak

R

• Rodeo
• Royal Gorge
• Red Rocks Amphitheater
• Run - do a 5K as a family. Bonus points if it's for a good cause!
• Rock Climbing
• Renaissance Festival

S

• Swimming
• Visit the State Capitol
• Stanley Hotel Tour - The Shining was filmed at this old historic hotel!
• Symphony
• Scavenger Hunt
• Snow Tubing - obviously a winter activity!
• Smores -- around the backyard fire pit or the camp fire, smores are always delicious!

T

• Tattered Cover Bookstore
• Trampoline Park - Sky Zone, Urban Air
• Top Golf
• Train Ride
• Tiny Town Railroad
• Taco bar

U

• Upstairs Circus - this is on our list this summer! It's a bar where you can do DIY projects like making concrete coasters, creating a leather pet collar, or making a butcher board. I'm looking forward to checking it out!
• US Mint

V

• Start a Vegetable garden
• Video games

W

• Water balloon fight
• Water World
• The Wild Animal Sanctuary 
• White Water Rafting

X

• Xbox night

Y

• Yard games - i.e., corn hole, bocce ball, horseshoes, etc.
• Yoga
• YMCA

Z

• Zoo

Teacher Stuff Newsletter #3 - Back to School

 

The 3rd edition of the Teacher Stuff Newsletter is available, and the theme is 'Back to School.' Check out this collection of free resources to help you get ready for the new school year. Just click on the picture to go to the google slide that has live links to the resources. You can also see previous newsletters by clicking the arrows on the slide show. Happy New (School) Year!

3 Back To School Books With Creative Gifts & Activities For The Beginning of The Year

 

1. A Teacher's Top Secret by LaNesha Tabb: 
Pens or Pencils (with a free tag download)

This post contains affiliate links for your convenience. That means I get a small commission if you use my links to buy something, but at no cost to you.

Are you looking for a back to school gift to start the year off "write"? Try tying tags onto a pen or pencil that say, "You are just 'write' for our class!" I give these to my students before school starts. We have students come in to do assessments before the first day of school. They come in small groups, and they are usually pretty nervous. I start by reading the book A Teacher's Top Secret. I found this book last year, and it is awesome! It tells the students a big teacher secret––that we pick them to be in our class because of all the special gifts they have to offer our classroom family. It talks about how sometimes it gets pretty heated and teachers throw down over the students to make sure they get them in their class! It's really cute. After we read the book, it's time for them to start their beginning of year assessments. I give them their pen and tell them it is a special pen that will help them do their best! 

You can download the tag for free here in my TpT store. I print the tag on different colored AstroBright card stock and use a 3 inch circle punch to cut them out quickly (Note: You have to cut off some of the extra paper to get the hole punch close enough to cut out the circle perfectly). These tags are made for the 3 inch punch. Then I use a regular hole punch in the top and curling ribbon to tie it onto the pen. 

This year, I'm adding this little fairy or elf door to my classroom. I'm going to let the kids know that we have some magical friends that live in our classroom who left the pens for them to use during their assessment days, and I will show them the little door. I will let them speculate on who or what could be living there! Once school starts, one of our first units is fairytales and folktales.  After I read The Elves and the Shoemaker by Jacob Grimm and Jim LaMarche, it will lead us to the discovery that we have magical elves that live in our classroom. Our elves will leave little notes, drawings, and words of encouragement sporadically throughout the year. I think we'll also have some visits from their cousins from the North Pole around Christmas time and their friends the leprechauns will visit around St. Patrick's Day and play tricks on us!

        

2. Lubna and Pebble by Wendy Meddour:
Make a Bed For Pebble

Lubna and Pebble is a beautiful book that I love to use to start off the year. It is about a little girl who is a refugee (it doesn't specify from where) who comes to a new country, and she feels lonely and scared. Her best friend is a pebble that she holds when she is scared, and she talks to it when she is lonely. When they make camp and pebble is cold, dad helps Lubna make a cozy bed for pebble. When a new boy joins the camp, Lubna becomes his friend because he is lonely and scared too. When it's time for Lubna to leave the camp, the boy doesn't want her to go. She leaves her best friend pebble with him so he has someone to hold onto when he is scared and talk to when he is lonely. It is a very touching story of friendship that is beautifully written and beautifully illustrated. 

After reading this story, we talk about who feels a little scared and lonely in a new classroom. Then I pass out a pebble friend to them to hold onto when they feel that way. This is a gift that is super special to kids EVERY time. We bust out the STEM supplies next, such as cardboard tubes, egg cartons, small boxes, etc. and I let the kids build a bed for their pebble. When they're done, we all go around and introduce ourselves and share our bed creations, then I let kids go back and make adjustments if they got new ideas from other classmates. I encourage them to collaborate with each other on their modifications as we also build classroom community. This is always an amazing first day activity that leaves kids feeling excited about coming back to school.

 

3. Scribble Stones by Diane Alber:
Scribble Stones

Scribble Stones is a great follow up to Lubna and Pebble (I typically do it several days later or the following week). Scribble Stones is a book about this stone that has waited his whole life to be chosen for a special job only to become someone's paper weight. It's disappointing until one day these scribbles use all the paper in the office. The stone has a great idea, and the scribbles use him to create their art! In the back of the book, the scribble stone project is explained: You find a stone, add some art, and then pass it on to someone else to spread kindness in the world. They add more art to the stone and pass it on too. It's a great way to start a chain of kindness. At the beginning of the year when we go over classroom rules or the school PBiS letters, kindness is always incorporated.

I usually get 3 - 4 inch stones for every student in my classroom from a local landscaping company since they are so heavy, but I put a link to some stones here that should work too. I have the kids use colored sharpie markers to decorate their stones. I used paint one year, and it was pretty messy and didn't stay on the stones, so sharpies work better for me! After the kids finish decorating their stones, we decide who to give them to in order to spread kindness. This can be tricky because beginning of the year 2nd graders are really still first graders, and they want to keep their stone. We really have to emphasize kindness and decide as a class how to pass them on. It helps that they got their own stone to keep with the Lubna and Pebble activity, but this is a big and cool stone! Two years ago we decided to share our stones with parents by putting them out by the front door of the school. Parents could not enter the building due to COVID, so we thought they would appreciate our beautiful stones in front of the school when they picked up their kids. Last year we decided to give our stones to kindergartners. My class thought they were probably afraid to start school for the first time and having a scribble stone would make them feel good about school. I can't wait to see who my students decide to share them with this year!

 

I have done these beginning of the year activities with my students for a few years, and they are always a huge hit! They are great ways to build classroom community and start off with some fun! 

Classroom Digital Data Tracker Shortcuts in Google Sheets

 

As a teacher, if I got to pick a super power, I'd have to go with freezing time. Remember those shows from the 80s where a witch could blink or put her two fingers together and freeze time? If I could do that, I'd have more time to grade papers, create lesson plans, workout, or sleep! While I don't yet know how to give myself super powers, I do know how to give you a little bit more time––every teacher's dream!

It's important to collect a lot of data about our students, but trying to sift through it all can be a lot. Here are some shortcuts I learned using google sheets as a digital data tracker to cut down on the time I spend sorting data so I can spend that time analyzing it instead. It makes report card time SO much easier too!  

1. Alternating Colors: 

Format––alternating colors

Okay, this is a really simple no-brainer that has been done since the beginning of teaching time, but it really does help! Google Sheets will make every other row an alternating color so it's easier to follow one line across the row. Just go to Format ––alternating colors. You can even pick different color combinations or customize your own. Freezing rows that need to stay in the same place can help with following the line across the row or column too. Check out my post Create Your Own Auto-Filling Data Spreadsheet With These 4 Tips for directions on how to do this. 

2. Drop Down Menus: 

Data––data validation––list of items

This shortcut became a time saver for me because I am assigning a different value or weight to different test questions within a single test. The math program we use at my school tests a bunch of different standards on one test––not just one strand at a time. I have to figure out which standard correlates to each individual problem on the test and record them under a separate standard in my grade book (rather than one score for the whole test). So problem #1 which tests standard 2.NBT.1, for example, might have 3 parts (a, b, c), so I want it to be worth 3 points. But problem #2, which tests 2.OA.2, might only be worth 1 point. Using a drop down menu helps me remember how heavily I weighted each test question when I'm recording the grade so I stay consistent. To make a drop down menu, highlight the whole column, and go to Data––data validation––list of items. I always use 'list of items' and then list the numbers possible separating them with a comma like this: 1, 2, 3. I like it because it puts the number choices in the drop down menu for you to choose. Then click on the arrow to choose one of those numbers.

3. Color Code the Data

Format––conditional formatting–format rules–"is equal to"–change the default color with the paint bucket

 

This shortcut has made the biggest difference for me! I like to see a data page color coded so I can get a sense of whether a student (or my whole class) is passing a standard at a glance. For example, if I have a problem worth 3 points, I can make 1 out of 3 points unsatisfactory and color code it red; 2 out of 3 points would be partially proficient and I would color it yellow; and 3 out of 3 points would be proficient and I would color it green. Then at a glance I can see if a lot of kids missed a certain question by the colors I see going down that column. I was color coding my data before, but I would highlight and change the color in each individual box. Conditional formatting has revolutionized my data analysis! I can set a whole column at one time to change the color of the box when I put the score in. Just highlight the column or row that you want to color code using the same data parameters. Go to Format––conditional formatting–format rules–"is equal to"–change the default color with the paint bucket. Now when you type in a number or choose a number from the drop down menu, it will automatically change the color based on the rules you set. 

4. Average the Score:

=(click in the box of the student total)/(click in box of the total possible) 

Going back to my math test example, I have random test questions across several units that fall under one standard. We use standards-based grading, so I average all of those individual test questions over several different units to determine how the student is doing on that one standard. To do this, first I have a total column at the end of each standard, and I have the spreadsheet automatically add up the total number of points the student earned for that standard (see the blog post Create Your Own Auto-Filling Data Spreadsheet With These 4 Tips for directions on automatically adding totals). For example, if unit 6 had five test questions for standard 2.NBT.B, and unit 7 had four test questions for 2.NBT.B, I have a box at the top of the spreadsheet with the total number of points possible––in this example 24––and then the spreadsheet calculates the total number that student earned. In the "Score" column, I have the spreadsheet average the score and turn it into a percent. To do this, click in the "Score" box for the first student and type =. Then click on that student's "total" box and it will add it to the formula. Next hit the / (which means divided by) and click on the box that has the total number of points possible. My formula for this example looks like this: =X5/X4

To make sure the score is shown as a percentage, highlight the whole score column and click on the picture of the % on the toolbar across the top. Now at a glance you can see which students are passing the standard over time.

I also have a blog post that I published a few years ago called Create Your Own Auto-Filling Data Spreadsheet With These 4 Tips. It shows you how to freeze rows and columns, automatically add totals, automatically populate data on a shared page, and create pivot tables to analyze data. You should check it out for ways to make your data tracker even more legit.

I hope you find these tips helpful in saving you time during your data collecting!