brainysmurf

“Today's Entries" an administrative tool for schools.

• Adds notifications and data collation to the "responses" Google Sheet (or any Google Sheet)

Copy and paste the below into the script editor, and configure the trigger to run once per day. For further modifications, see the comments in the script.

brainysmurf

“Gamified Journal with Notifications" a learning tool for students. Public sample document is available here

• Turns a Google Document into a very simple Journal
• Reports how long students spend writing, how many words were written
• Formats each entry with a header with today's date
• Notify the teacher each time student adds an entry

Why:

• Self-paced "gamified" journal writing activity

brainysmurf

"Blankifier" allows teachers to quickly create a document where every "N" word is replaced with a "blank".

To get started, copy and paste the below into a Google Doc's script editor. Copy and paste text into the document, then click on Blanker -> Blanify

Features:

• Decide how many words to skip before deciding to blank
• Automatically skips words <= 3 words

brainysmurf

Manage your daily notices, or bulletin, entirely within your GAFE, no servers or databases required. This is done by creating a Google Form, and then adding the following scripts to the responses sheet that the form populates onto. Optionally create a Google Site to publish the notices.

Workflow:

• Users enter into a Google form, and they get picked up and sent to staff either:
  • published onto a Google Site
  • sent out by email
  • both (published onto a site, and then email with link sent out)
• Users can enter notices in advance
• Users can enter notices for a date range
• Have any number of sections ("Whole School", "Secondary", etc.), and notices are collated by those sections

brainysmurf

A simple Google Document that helps you make tables. Useful for teachers.

• You can simply make a copy of this document and follow the instructions.

brainysmurf

/*

Use this at your own risk. 

1) Enter the ID of the folder which contains the files you would like to remove and restore edit access
2) Then running triggerCloseDown will save those editors and remove edit access (and view access) for all editors of that file
3) Then running triggerOpenUp will lookup editors of each file and restore editing access

NOTES:

brainysmurf

/*
There is a bug in the proxy provided by awesometables  
In a google domain, email addresses should case insensitive
*/

function doGet(e) {
  var currentUser = Session.getActiveUser().getEmail().toLowerCase();
  var ssUrl =  e.parameter.url;
  var sheetName = e.parameter.sheet;
  var a1Notation = e.parameter.range;

brainysmurf

// Exmample of options

var options = {
    method: "POST",
    contentType : "application/json",
    payload: JSON.stringify({
        secret: 'you will have to ask me',
        awesome_table_filters: {
            first_nickname_last: 'StringFilter',
            parent_email_1: 'StringFilter',

brainysmurf

var gl = false;   // for debugging

function onOpen() {
  var ui = DocumentApp.getUi();
  ui.createMenu('Actions')
      .addItem('Insert newline every N lines', 'actionEveryNLines')
      .addItem('Make Table', 'actionAppendTable')
      .addSeparator()
      .addItem('Blankify', 'actionBlankify')
      .addItem('Tokenize Sentences', 'actionTokenizeSentences')

brainysmurf

/*
  In a google domain, email addresses are (probably?) case insensitive
  Also, return a date object instead with defined formatting
*/

function doGet(e) {
  var currentUser = Session.getActiveUser().getEmail().toLowerCase();
  var ssUrl =  e.parameter.url;