Google Apps Script and Google Sheets

In this episode of 'Unscripted', host Brad Schreffler and guest Jake Miller discuss a project using Google Apps Script to create an interactive notebook add-on for Google Slides. They compare Google Sheets and Excel, highlighting unique features of Sheets. The session includes live coding, debugging, and plans for future development. The episode wraps up with a discussion on the next steps and a call for audience participation.

What is the main focus of the 'Unscripted' coding show?

• To review popular coding tools

• To explore different coding languages

• To teach advanced coding techniques

• To create project-based learning experiences for teachers

What is the primary goal of the Google Apps Script project discussed in the episode?

• To automate email sending

• To manage interactive notebooks through Google Slides

• To develop a new coding language

• To create a new spreadsheet application

Which feature of Google Sheets is highlighted as not being available in Excel?

• Pivot tables

• Unique function

• Conditional formatting

• Macros

What is one of the reasons Brad prefers Google Sheets over Excel?

• It has more formulas

• It is cloud-based and collaborative

• It has better graphics

• It is cheaper

What coding concept is being demonstrated when setting column widths in Google Sheets?

• Looping through data

• Error handling

• Using object properties

• Conditional statements

Why does Brad want to format the spreadsheet automatically using code?

• To save time for users

• To make the spreadsheet look more professional

• All of the above

• To ensure consistency across all documents

What is the purpose of the 'set bold' function in the coding process?

• To change the font size

• To italicize text

• To make text bold

• To underline text

What humorous incident does Jake share about a past presentation?

• He presented in the wrong room

• He accidentally deleted his files

• He was criticized for a session name

• He forgot his presentation slides

What is the next step in the project after setting up the initial spreadsheet?

• Creating a new coding language

• Developing a user interface

• Generating copies for students

• Testing the application

What does Brad plan to do with the Google Slides file in the project?

• Convert it to a PDF

• Delete it

• Share it with all users

• Move it to a new folder