Products

Popular posts from this blog

Google Sheets: Script to Print As PDF, Save as CSV, XLSX

Image
Hyperlinks can do more than just link documents and sheet pages.  They can also help you to quickly download the content as a CSV, TSV, XLSX or PDF.  Best of all, we can limit the range to be downloaded. Problem: If using a Google Sheet, exporting specific ranges as a PDF, CSV, etc., is difficult or impossible using Google's preselected menu bar. Solution & Skills: We will create one Google Spreadsheet where we utilize the hyperlink function to create download links.  This solution helps with the creation of invoices, grabbing CSV data that can then be uploaded to other programs/web applications. Skills: ✔ Write hyperlink function; ✔ Link to pages within spreadsheet; ✔ Modify link to create CSV, XLSX or PDF files by range. Hyperlink Function: Here's the breakdown of the hyperlink function in Google Sheet: = hyperlink ( "https://www.google.com" , "Google" ) The equal sign tells Google Spreadsheets that we are using the hyperlink function.  Inside the firs
Read more

Paragraph Generator - Writing Tool

Image
About - Process - Web Monetization - Personal Info - Terms of Use - Contact/Support About: The Paragraph Generator is designed to help teachers chunk paragraph writing.  The follows typical procedures in constructing a paragraph by: Claim (Topic Sentence / Main ID) Background (What the reader needs to know.) Scene (Connects the background back to the topic at hand.) Textual Evidence (Quote or paraphrased evidence that directly supports the MI.) Analysis (What's the significance of the quote? What can we deduce from the evidence? How is the claim further supported?) Connect Back (In most cases, this can be closely tied to the analysis by advancing the claim.) Process: The Generator requires the user to create the claim and add a quote (TE). In working with middle school and high school students, getting students to find a quote that supports the claim before developing the paragraph has been the best approach in getting writers to support their po
Read more

Google Form Quizzes - Find Max Score - Apps Script

If you have ever created a quiz for mastery, you may have discovered you can have students take the quiz as many times as they want.  As an educator, you can use the number of retakes a evidence of growth or opportunities to provide overall performance gains while also providing short penalties to discourage frequent and rapid retakes.  For example, students can take the quiz as many times as they wish, but for each time they take the quiz, the score is reduced by 2.5%. If you have this information in a spreadsheet, you are golden. In this tutorial, we will create an App Script file to filter out Google Form scores to quickly upload the marks to our SIS or online Gradebook. Problem: If using multiple quizzes in a year where students can retake quizzes, reimplementing formulas to filter the data can be a pain.   Solution & Skills: We will create one Google Spreadsheet where future forms can be pointed.  We will use Apps Script to pull and format the scores, creating a new sheet with
Read more