Create custom forms with GUI Builder and Google Apps Script | Jellybend Using Google Forms, you can create custom data form, but the ability to customize them both in terms of functionality and visual aspect can, in some cases, be limiting. In this post I will explain how you can create a custom data form to record entered data in a Google Spreadsheet document using Google Apps Script. Google Apps Script provides a simple tool for visual graphical user interfaces creation named GUI Builder that we will employ to create our custom form. First create a new Spreadsheet document, then activate the Script Editor using the menu “Tools -> Script editor …”: Select “Blank Project” to create an empty script project and save that by using the menu item: “File -> Save”. The editor will ask you to name the project, insert: “Custom Form to Spreadsheet” and click on the “OK” button to confirm. Once you assign a name to the project, you can use the GUI Builder to create our own custom interface. The GUI Builder tool will load as follows: Much better. Congratulations!
40 Ways to Use Google Apps in Education Google provides an abundance of apps that can be used for educational purposes. It has a section called Google Apps for Education where it provides the teaching workforce with a multitude of Google services to use in schools and classrooms. Educational Technology and Mobile Learning has been continuously reviewing these apps for the last couple of years , click HERE to access this section to . Today, I am sharing with you a GREAT presentation created by Becky Evans on 40 ways to use Google Apps in Education. The tools included in this presentation target increasing teacher's efficiency, student engagement, and school-wide collaboration. Here is the outline of this presentation Google docs : Google Forms How to submit answers in a form and see resultsAdminister assessmentsSurvey your students interestsCollect observation feedbackSubmit reading records onlineKeep track of discipline referralsAutomatically grade forms with Flubarro Google Calendar Gmail Google Groups Google Talk Google Sites
19 handy Google tricks that you weren’t aware of After covering everything that Google Search has to offer, you can easily forge that search only forms one small part of the Google behemoth. With so many different features and clients available, it’s very easy to use the basic features for each and leave it at that. However, if you delve a little deeper, there are many tricks hidden away that will help improve your experience. Gmail Use Filtered Search Gmail’s search bar is very handy for finding that message you got months ago, but most people don’t realise how easy it is to access advanced search. Activate Starring Feature Sometimes you will come across important messages, but the only way you can mark them is with the yellow tab or star icon. Cut Down Text In Email Replies The annoying thing about email threads is that if the messages are long and numerous, it’s very easy for the context to get lost among the many paragraphs of text. Keyboard Shortcuts Sign Out Remotely Emphasise Important Words In Gchat Activate Gmail Remotely Google Maps
Effectively Maximizing Teacher Leaders at the Elementary Level (Artwork by Leslie Carroll) “No one person can do it alone…” This statement is especially accurate in a school. Donna Johnson, assistant principal, and I recognized this truth prior to beginning our tenure as Memorial School’s administrative team five years ago. The formulation of a dedicated group of teacher leaders set a tone and expectation for collaboration heading into our first year, and I firmly believe that this group, as a whole, has been the instrumental driving force for change within our school. During the summer of 2008, I reached out to various members on each grade level team to see who would be interested in fulfilling the responsibilities of “team leader.” The first step we took together was to attend a Professional Learning Communities at Work conference with the DuFours in Boston. Our team leader group has evolved since that time five years ago, but there are many things that have stayed constant. We meet every two weeks prior to school.
Ultimate Guide to Google Plus Are you new to Google Plus and need help getting started with the network? This page was made with you in mind! This intro course is provided FREE to everyone to show the quality of work that has been put into organizing our course material. All links from this course lead to paid course material, please click here to read more about this course and sign up. What is Google+? Google Plus acts as a “social layer” for Google, the world’s largest search engine company, and is integrated into its every product and service, such as Search, Android, YouTube, Chrome, Local and Drive. At its core, Google Plus is an interest-based platform where like-minded individuals communicate, collaborate and create as a community. Table of Contents Note for First Time Users: Use the following links to jump to the sections you need assistance with. On May 21st, 2015, Google+ removed the Google Ripples feature that visually showed post sharing activities. Why is Google Plus Important Don’t Be a Bluehead! People
Сервисы Google в образовании Добрый день, уважаемые коллеги! Рады приветствовать вас на курсах повышения квалификации! На курсах повышения квалификации вы научитесь использовать в своей педагогической и организационной практике современные сетевые сервисы. Будете создавать и совместно редактировать документы, формы, таблицы, рисунки, презентации на Диске Google. Кроме этого, создадите собственный блог или сайт, поработайте с альбомом Picasa, картами, календарём. Мы рассмотрим огромную коллекцию YouTube, в которой содержится много интересного (в т.ч. и образовательного) материала, и научимся встраивать видео на сайт или в блог. Календарь занятий Очное занятие будет организовано 1 марта, остальные занятия - дистанционные - по определённому расписанию (см. календарь). Таблица продвижения Таблица продвижения (курсы повышения квалификации) Желаем успехов!
Google Hangouts as Edtech: Connecting, Sharing and Learning Since I started in education, I have been trying to find ways to connect students' learning beyond the classroom walls. Initially, the task presented many hurdles. Infrastructure was limited, devices were bulky and slow, and the access was not quite available. In order to connect students with the outside world, a permission slip and a school bus were needed. Today, many of those hurdles have been overcome, and connecting students beyond the classroom is a viable option. Hangouts, the social media feature of the Google+ platform, are online spaces offering teachers and students a great forum to connect with one or many participants and engage in a real-time dialogue. Reasons to Hang Out One of many reasons I like Google Hangouts is for the ability to broadcast a talk live and then archive that broadcast. Possibilities and Opportunities I see many opportunities for students and teachers using Google Hangouts in the classroom.
Gmail+1 = Student Email Addresses to Register for Online Services The Gmail+1"hack" isn't a new trick and I can't remember when I first tried it, but it still works and it still provides a solution to a problem that a lot of teachers run into when they want their students to use a new web tool. Let's say there's a new service that I want my students to use but my students don't have email addresses that they can use to register for that service. In that case I can quickly generate Gmail addresses for my students by using the Gmail+1 hack. Here's how the Gmail+1 hack works: 1. Disclaimers: 1. The Touch-Screen Generation - Hanna Rosin On a chilly day last spring, a few dozen developers of children’s apps for phones and tablets gathered at an old beach resort in Monterey, California, to show off their games. One developer, a self-described “visionary for puzzles” who looked like a skateboarder-recently-turned-dad, displayed a jacked-up, interactive game called Puzzingo, intended for toddlers and inspired by his own son’s desire to build and smash. Two 30‑something women were eagerly seeking feedback for an app called Knock Knock Family, aimed at 1-to-4-year-olds. “We want to make sure it’s easy enough for babies to understand,” one explained. The gathering was organized by Warren Buckleitner, a longtime reviewer of interactive children’s media who likes to bring together developers, researchers, and interest groups—and often plenty of kids, some still in diapers. What, really, would Maria Montessori have made of this scene? She was a former Montessori teacher and a mother of four. “They don’t play all that much.”
100+ Google Tricks for Teachers It's Google's world, we're just teaching in it. Now, we can use it a little more easily. With classes, homework, and projects–not to mention your social life–time is truly at a premium for all teachers, so why not take advantage of the wide world that Google has to offer? From super-effective search tricks to Google tools specifically for education to tricks and tips for using Gmail, Google Docs, and Google Calendar, these tricks will surely save you some precious time. Search Tricks These search tricks can save you time when researching online for your next project or just to find out what time it is across the world, so start using these right away. Convert units. Google Specifically for Education From Google Scholar that returns only results from scholarly literature to learning more about computer science, these Google items will help you at school. Google Scholar. Google Docs 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. Gmail 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. 42. 43. Google Calendar 44.
Tale Of The Tape: Chromebook Pixel Vs. Surface Pro Vs. MacBook Air Google hasn’t always been known for making breathtaking hardware, but today’s announcement of the Chromebook Pixel — arguably one of the best-looking laptops ever made, if nothing else — means that may no longer be the case. Still, you can’t be blamed for being wary of shelling out a decent chunk of money on Google’s first foray into laptops, let alone a Chromebook of all things, so here’s a preliminary look at how the Chromebook Pixel stacks up against two prominent rivals in the computing space: the stock version of Apple’s 13-inch MacBook Air and Microsoft’s Surface Pro. *Note that we compared the base MBA and the surface Pro with upgraded storage, to establish a better baseline in terms of comparing more similar price points and spec load-outs. Versus the 13-inch MacBook Air Compared to the base 13-inch MacBook Air, Google’s Pixel has a lot of similarities. The Chromebook Pixel is very much aimed at the same market as the MacBook Air, with Google stressing that it’s an upscale device.
How to Open and Edit Word Files in Google Drive This morning I received an email from a friend of mine who needed some help opening a Word (Docx) file in Google Drive. Google recently made a slight change to how this is done. And since it threw off my friend who is a fairly savvy Google Drive user I thought that there are probably others who have or will have the same question. To open a Word (Docx) file in Google Drive after it has been uploaded to your account click the check box next to the file name. After clicking the check box you have two options. Option 1: Option 2: If you don't want to go through the process outlined above for every Word file uploaded to your Google Drive account you can enable automatic conversion of documents. Enabling automatic conversion on upload:
8 Characteristics Of A Great Teacher 8 Characteristics Of A Great Teacher by Ian Lancaster What makes a teacher strong? What differentiates the best from the rest? 1. Confidence while teaching can mean any number of things, it can range from having confidence in your knowledge of the material being learned to having confidence that your teaching acumen is second to none. It’s the confidence that you know you’re in the right spot doing what you want to be doing and that no matter what transpires, having that time to spend with those young learners is going to be beneficial both for them and for yourself. 2. Having some life experience outside the classroom and outside the realm of education is invaluable for putting learning into context and keeping school activities in perspective. 3. Just as each student has a different set of interests, every student will have a correspondingly different set of motivators. These students run the risk of disengaging altogether. 4. Yes, all teachers are heroes. 5. 6. 7. 8.
Талмуд по формулам в Google SpreadSheet Обычно мы пишем про хостинги, в частности про зарубежный shared хостинг в США. Но чтобы писать, нужно иметь аналитические данныепод рукой. Вот как раз тут требуется помощь Google Docs, если файл получится предположительно меньше 400 000 строк. За несколько месяцев работы с таблицами Google пришлось много раз анализировать посредством формул разного рода данные. Кратко о главном Для того чтоб Excel, либо spreadsheet (таблица Google) поняли что написанное — это формула, необходимо поставить знак "=" в строку формул (Рисунок 1). Рисунок 1 Далее, начинаем писать формулу с клавиатуры либо выделяем мышкой те ячейки, с которыми мы собираемся работать. буквенно — цифровое (БУКВА = СТОЛБЕЦ; ЦИФРА = СТРОКА) например «А1».стилем R1C1, в системе R1C1 и строки и столбцы обозначаются цифрами. Рисунок 2 Как видно из Рисунка 3, значения ячеек идут относительно той ячейки, в которой будет написана формула со знаком равно. Типы ссылок (типы адресации) Относительные ссылки Абсолютные ссылки Смешанные ссылки