Using QUERY to merge sheets

Interesting article :

"=QUERY({'Alexis Form'!A:M;'Anna Form'!A2:M;'Linda Form'!A2:M;'Sierra Form'!A2:M},"Select * where Col2 <> '' ",1)

...the formula will QUERY all the sheets and pull all ( the * means all) data where Col2 (B in the sheets where data is text) does not equal blank. Notice the ranges where the first sheet has A:M but the rest has A2:M, this is so the QUERY will only pull one set of headers, if you use A:M on all them then you will end up with 4 sets of headers with each above it's data.

In a normal QUERY formula using only one sheet then cell referencing uses the columns letter (A, B, C, etc), but when querying multiple sheets inside an {array} then you have to use Col# referencing."

Google Apps Script for Form Links

https://webapps.stackexchange.com/questions/89551/show-url-used-to-edit-responses-from-a-google-form-in-a-google-spreadsheet-by-us

URL Shortener

Shorten your URL: https://goo.gl/

Best Number Line Generator

I probably found this before, but wow its awesome:

http://themathworksheetsite.com/numline.html

Passive Income

Some great ideas here:

http://www.smartpassiveincome.com

Word to PDF (Batch Conversions)

Great automated script:

https://onabai.wordpress.com/2012/07/10/convert-word-files-docdocx-to-pdf-in-osx/

Combining PDF files quickly

Great article:

http://www.documentsnap.com/how-to-combine-pdf-files-in-mac-osx-using-automator-to-make-a-service/

Illuminations Tool

I like this tool, especially since it gives you the ability to create nets:

http://illuminations.nctm.org/Activity.aspx?id=3509

Remind App for Phones

Seems like a great idea:

https://www.remind.com/

Plickers Assessment

Lots of potential here:

https://www.plickers.com

Bootstrap

An interesting resource:

http://www.bootstrapworld.org

Google Ad-ons

Form Ranger is exciting, it populates choices on forms from a spreadsheet:
https://chrome.google.com/webstore/detail/formranger/faepkjkcpnnghgdhiobglpppbfdnaehc?hl=en


Choice eliminator allows users to eliminate a choice they submitted in a form:

https://chrome.google.com/webstore/detail/choice-eliminator/mnhoinjhhhafgieggnhjekliaodnkigj?hl=en-US

G(Math) Individualized Exams

This is exciting:

http://www.gmath.guru/quick-quiz-creator/#/quizninja-for-individualized-forms/

Numbers Only on Google Forms

I am currently working on a version of Mean Paper Airplanes that I found on Julie Reulbach's blog and came across her comment to Dan Meyer about Google Form Functionality:

I was excited to find that Google has added this feature in its most significant form overhaul for education: data validation. Forms also now have the ability to post images and video, which is awesome (I am going to make interactive modules with videos and images of tables, graphs and patterns for questions). 

I wanted to show how Google Forms can be set to fix her issue.  

When writing the question, notice the "advanced settings" tab at the bottom:

Click "data validation" and selected the "number" option and specify "is number" so that only numbers can be entered. Then I select an error message to pop up if students type in something else, like the units of measurement. The message I chose was, "only enter the number of inches."

From the student's perspective, they would see this if they typed in units:

There is so much more that can be done with data validation. I can't wait to play around with it more this summer.

Thanks Julie for finding that lesson, it has been really fun so far!  (I will post my extensions to it as it is amazing and fits nicely with the 8th and 9th grade CCSS curriculum as well) 

Desmos and the Pythagorean Theorem

I think Desmos is really doing great stuff. I like how clean this graph is and think it could make a great talking point in class.