Profile cover photo
Profile photo
Andrew Fenstermaker
87 followers -
5th Grade Teacher
5th Grade Teacher

87 followers
About
Andrew's posts

Does anyone know of a kindergarten classroom that would like to Skype with another kindergarten classroom to talk about people they have learned about for Black History month? 

Post has attachment
I have a question about a Google Sheet formula. I am trying to make a cell reference a cell from a different sheet.

For example:
='Badge List'!A3
is the formula I am putting in to reference A3 on my Badge List sheet. However, when I try to fill the rest of the row, instead of it changing to ='Badge List'!A4, it changes to ='Badge List'!B3, I just want the sheet reference and column to stay the same but just the row to increase by one as I drag it. I tried adding a dollar sign before the "A", ='Badge List'!$A3, but then every cell I drag to ends up as ='Badge List'!$A3. I attached a video if that helps.

Any tips on how to get this to work? 

Google Template Gallery
I noticed it is no longer supported to submit a template. It says to see the home page of Docs, Slides and Sheets. However, when I got to those places, I can't find anywhere to submit a template.

Will Google be adding the ability to submit templates so that they can be shared within your domain?

Does anyone have suggestions for adding audio to Google Slides? Movenote used to be the tool we used but now it is limited with their free plans. Looking for an alternative.

Post has attachment
I need some Google Sheets help. I have linked a 2 minute video that shows a visual of what we are trying to do. Probably easier to understand than my brief explanation below. 

We have a leaderboard to show which Google Certifications they have completed. There are four different Google Forms set up. AutoCrat is set on each Form so when a submission is received, the teacher receives a certificate. We are trying to figure out how we can make these four Google Sheets to talk to each other and compile results into a "leaderboard." Not sure if this is possible or not. We can manually do this, but are hoping for an automated way with formulas to monitor completed certifications. 

Post has attachment
Google Sheet Help needed
We had a survey filled out where teachers had to rate each question on a scale of 1-5. There are a total of 18 questions. We want to create a chart for each question that shows how many times 1 was selected, how many times 2 was selected and so on.
I included a copy of the Google Sheet an simplified the question titles. Does anyone know how to accomplish this? 

Post has attachment
Google Sheet Help needed
We had a survey filled out where teachers had to rate each question on a scale of 1-5. There are a total of 18 questions. We want to create a chart for each question that shows how many times 1 was selected, how many times 2 was selected and so on.
I included a copy of the Google Sheet an simplified the question titles. Does anyone know how to accomplish this? 

I would love to chat with anyone that has supported professional development with rolling out Chromebooks and/or the GAFE ecosystem.

We are in the process of strategizing the best approach for a training model and schedule of PD to ensure a successful deployment of devices to secondary teachers. 

Is there a way to restrict email in the GAFE domain? I know you can restrict who students can receive email from, but wanted to know if you can restrict email to send and receive only within your GAFE domain?


Curious about whether we could limit elementary email to only send/receive email within our domain. I think it is currently set to where they can send email to anyone, but can only receive email from within our domain. 

Post has shared content
I went looking for various ways to do 3D design and CAD on a Chromebook. I found several, including a new collaborative one. 
Wait while more posts are being loaded