Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
Python QUIZ 25 Test your Knowledge! Are you ready to challenge your understanding of Python? I’ve put together a fun and engaging 25-question quiz to test your knowledge of this versatile and powerful programming language. From basic syntax to advanced concepts, this quiz covers a wide range of Python topics. Highlights of the quiz: Whether … Read more
Are you ready to put your Node.js knowledge to the test? We’ve got an exciting quiz lined up for you! This 25-question multiple-choice quiz covers a wide spectrum of Node.js, from its core functionality and modules to more advanced topics. Perfect for both seasoned Node.js veterans and those new to server-side JavaScript. Quiz Highlights: This … Read more
🚀 Take the jQuery Challenge: Test Your Skills with Our Interactive Quiz! 🧩🖥️ Ready to assess your jQuery knowledge? I’ve put together an engaging 25-question quiz that covers everything from basic syntax to more advanced concepts in jQuery. Whether you’re brushing up your skills or prepping for an interview, this quiz is a fun way … Read more
CSS QUIZ 25 Test your Knowledge! Questions for CSS Quiz What does CSS stand for? A. Computer Style Sheets B. Creative Style Sheets C. Cascading Style Sheets D. Colorful Style Sheets Which CSS property controls the text size? A. font-style B. text-size C. font-size D. text-style How do you make each word in a text … Read more
HTML QUIZ 25 Test your Knowledge! Questions HTML Quiz What does HTML stand for? A. Hyper Text Markup Language B. Hyperlinks and Text Markup Language C. Home Tool Markup Language D. Hyper Tool Markup Language Which HTML tag is used to define an internal style sheet? A. <style> B. <script> C. <css> D. <link> What … Read more
JavaScript QUIZ 25 Test your Knowledge! What will console.log(typeof undefined) output? A. “undefined” B. “object” C. “null” D. “string” Which statement creates a constant in JavaScript? A. var myConst = 10; B. let myConst = 10; C. const myConst = 10; D. myConst = 10; Which of these is a correct method to create a … Read more
Question 1 Q: What is the output of “10” + 20 in JavaScript? A: 2. “1020” Question 2 Q: Which method can be used to convert JSON data to a JavaScript object? A: 1. JSON.parse() Question 3 Q: What does the map() method do? A: 1. Modifies each item in an array and returns a … Read more
Exercise 21: Generating a Table of Contents in Google Docs Objective: Create a script to automatically generate a table of contents in a Google Document based on heading styles. Code Sample: function generateTOC() { var doc = DocumentApp.getActiveDocument(); var body = doc.getBody(); var toc = body.appendParagraph(“Table of Contents”); toc.setHeading(DocumentApp.ParagraphHeading.HEADING1); var paragraphs = body.getParagraphs(); paragraphs.forEach(function(paragraph) { … Read more
Exercise 16: Automated Email Responses Using Gmail Objective: Write a script to automatically send a response to every email received with a specific subject. Code Sample: function autoRespondToEmails() { var query = ‘subject:”specific subject” is:unread’; var threads = GmailApp.search(query); var response = “Thank you for your email. We will get back to you shortly.”; threads.forEach(function(thread) … Read more
Exercise 11: Generating a Report from Google Forms Responses Objective: Create a script to generate a summary report from Google Forms responses in a Google Sheet. Code Sample: function generateFormReport() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“Form Responses 1”); var data = sheet.getDataRange().getValues(); var report = {}; for (var i = 1; i < data.length; i++) { … Read more