Everything Teachers Need to Know about Google Spreadsheets. Here are some good tutorials we brought you from Learn Free. Click on any title to access the correspondent tutorial. Enjoy 1- Getting started with Google Spreadsheets In this lesson, you'll learn about the different ways you might use spreadsheets and how to navigate the Google Spreadsheets interface. 2- Formatting Cells In this lesson, you'll learn how to modify the size, style and color of text in your cells. 3- Working with Multiple Sheets In this lesson, you'll learn how to create, rename, move, delete,and duplicate sheets. 3- Creating Simple Formulas In this lesson, you'll learn how to create simple formulas that will add, subtract, multiply, and divide values. 4- Creating Complex Formulas In this lesson, you will learn how Google Spreadsheets follows the order of operations to solve complex formulas. 5- Types of Cell References In this lesson, you will learn about relative and absolute cell referencesand how to create and copy formulas that include them. 6- Working with functions.
6 Tips Teachers Should Be Able to Do on Google Docs. Following the Google Docs guides I have been posting here, I received several other tips to add to these guides. I know it is impossible for me to cover all the details of these web services but some of these tips are really important and should not pass incognito. As I told you before, this blog is a fruit of a collaborative work between me and you and I do learn a lot from you as you do from me. Now here is a round-up of the new hacks you can do on Google Docs\ Drive. 1- Preview Docs A couple of months ago, Google Drive introduced the option of previewing your docs before you open, share or download them.
To preview your doc, click on the check box next to it and right click on the file name then click on preview, see snapshot. 2- Open Word docs files in Google Docs To open a Word document ( Docx) that is uploaded in your Google Drive all you have to do is tick the box next to it , right click on the file name, select " open with " then click on " open with Google Drive "
10 Great Tools to Integrate with your Google Docs. Since Google officially changed Google Docs name to Google Drive and a number of updates have been introduced to improve its overall performance. One very recent update is an increase of cloud storage capacity to 15GB usable across Gmail, Drive, and Google Plus. It is quite obvious that Google is trying to outsmart its immediate competitor Dropbox and I think Google is successful in its strategy so far.
To make Google Drive stand out from the crowd, Google opened it to apps developers and allowed users to select from a wide variety of web apps to integrate into their Google Drive accounts. With the integration of these apps, users can now handle their files and documents ways not affordable by any other cloud storage tool out there. I have curated for you some interesting apps that are integrated into Google Drive and which you can install right from your Google Drive interface. Here is a list of some great apps to use with your Google Drive : 1- WeVideo 2- PicMonkey 3- Google Forms app.
3 Ways to Use Google to Be Better at PR. 6 Steps to Add Voice Comments to Google Docs. Here is a step by step guide to show you how you can add " Voice Comments " within your Google Docs. This application is developed by 121 Writing. Here is how you can do it : 1- Head over to your Google Docs and click on " Create". scroll down to the bottom and click on "connect more apps " 2- Type in the word " voice " in the search panel then click on connect in front of " voice comments " 3- Go back to your Google Docs and right click on the document you want to add voice comments to then select open with voice comments 4- The document will open in a new window, click on the record button as shown in the screenshot below. 5- To share your voice feedback click on " share with collaborators ".
You and your collaborators can access it Google Docs via the "Comments" button on the top-right corner beside the Share button. ФБ-2013 - Контакты и порядок оплаты. Все возникающие вопросы возможно задать в рабочие дни с 10.00 до 19.00 по московскому времени по телефону: (495) 514-3374 или электронному адресу dea@ito.edu.ru Каждый участник может представить не более одной работы (в том числе и в качестве соавтора). Стоимость участия в конкурсе составляет 585 руб. Если соавторы также желают получить сертификат участника (победителя), то за каждого соавтора необходимо внести 150 руб. В рамках конкурса проводится мониторинг сценариев применения ЭОР в образовании.
При полном заполнении дополнительной анкеты стоимость участия в конкурсе составит 440 руб. Оплата должна быть произведена не позднее 25 июня 2013 года. Каждый участник может до 5 декабря 2013 года заказать рецензию на свою работу. Оплата принимается через банк по следующим реквизитам: ООО «СКТ» ИНН 4012001567, КПП 401201001 р/с 40702810901030017466 в ЗАО СБЕРКРЕД БАНК, г.МОСКВА к/с 30101810400000000106, БИК 044585106 Назначение платежа: За участие в ФБ-2013 (заявка №___). Creative Resume - Google Диск. Bringing App Activities to Google Search.
When users search for your app, they often want to go deeper and see what in-app content fellow users find interesting. Today we're making this possible by bringing app activity to Google search results. Aggregate app activity for SoundCloud in Google Search. Soon, if you search for a site or app on Google.com (and that app has integrated with Google+ Sign-In app activities), you'll see popular and aggregate user activity to the right of search results. Searching for Fandango, for example, will show the top movies among Google users. And when you click on a movie, you’ll go directly to its page on Fandango. The current Google Search results page for Fandango (left) and the Google Search page results with app activities (right). We're rolling out this feature in desktop Search over the next few weeks, starting with a limited number of music and movie apps — including Deezer, Fandango, Flixster, Slacker Radio, Songza, SoundCloud and TuneIn — but we'll be adding more apps over time.
80 Interesting Ways To Use Google Forms In The Classroom. 80 Interesting Ways To Use Google Forms In The Classroom by TeachThought Staff When you think of innovative, edgy, compelling uses of technology, Google Forms isn’t exactly the first thing that leaps to mind. While you’d probably prefer a piece of hardware that’s affordable, easy to use, and mobile that allows students to direct their own mastery of content in peer-to-peer and school-to-school learning environments, for now you just might have to settle for a spreadsheet.
No, wait. Come back. Hear us out. Spreadsheets are simply a kind of framework, yes? And they have built-in formulas to perform calculations, visualize data, and communicate information in ways we–and students–are not used to seeing, right? So maybe a self-grading assessment? Questionnaires? See, I told you it’s not so bad. More Fun With Google Forms | Assessment. There seems to be a lot of talk about the power of Google Forms in #physed these days.
For me, this is all very exciting because I can finally (kinda) use Google Drive at work (don't even get me started on that, let's just accept the fact that I can get more done now than before). Adam Howell (who you should follow) has been sharing some pretty awesome ideas on how to use Google Forms in #physed. He did a great screencast showcasing his "Ask Me A Question" idea that he uses in his classes. Basically, he includes a link in his Google Drive-based student documents (e.g. a peer assessment document explaining the day's tasks to the reader) that links to a basic Google Form that looks a little like this: If students have a question, they can click on the link, fill out the form and submit it to the teacher. Pretty smart stuff. Nathan Horne (who you should also follow) has also been sharing some sweet ideas on how to use Google Forms.
Again, really smart stuff. 1. 1. 2. 2. 1. 3. 1. 2. 3. 4. 5. Как создать аккаунт Google. Инструкция по созданию рисунка в Google. How To Start Using Google Apps In Education. As teachers, our plates are perpetually and impossibly full. The idea of adding one more component – such as incorporating technology into instruction – can seem daunting to say the least. In my own attempts to incorporate technology into my practice, Google has been the most valuable tool I have found thus far. Not only does it increase my ability to organize my instructional tools, but it also allows me to incorporate more technology when I feel ready to do so. Why use Google Apps? Google provides a multitude of Apps that can be accessed through multiple mediums – computer, smartphone, or tablet.
These apps are all free and come with varying levels of privacy ranging from completely public on the web to limited only through sharing with specific contacts. So how can I use Google Apps in my teaching? To showcase the management advantage of Google Apps, I will highlight an example of how I use Google Apps in my own instruction. Maybe not right now… Add Your Profile Picture to Google Search Results. When your SlideShare presentations surface in Google search results, want your profile picture attached? You can make this happen in three easy steps: Copy your G+ profile URL and add ? Rel=author at the end of it.On SlideShare, go to Edit Profile » Personal Information » Website / Blog. Paste the copied URL here. Hit Save.On your G+ profile, go to About » Contributor to » hit Edit.
Add a Label and paste your SlideShare profile URL in the URL field. Here’s a presentation that walks through the steps, too: That’s it — enjoy! Related Posts. One Today — приложение Google для пожертвований в 1$ Google начал тестирование нового филантропического приложения One Today. One Today позволяет пользователям жервовать 1$ в различные благотворительные организации каждый день. One Today — это инициатива проекта Google for Nonprofits, позволяющего делать микропожертвования. Приложение One Today существует только для Android. Несмотря на заявление Google о том, что приложение доступно только по приглашениям, его можно найти на Google Play. Фрагмент интерфейса One Today. Инструкция. Голосовые комментарии в документах Google - Google Диск. Google Hangouts for Educators - Tech Educator Webinar.
Published on April 22nd, 2013 | by Jeff Herb The Tech Educator Podcast team just put together another episode in our Webinar series all about using Google Hangouts for your own professional development and also with your students. Some great topics were discussed: What is needed to get started with Google HangoutsStarting a HangoutInviting others to your HangoutSharing your ScreenUsing Google Drive in a HangoutAdding a Lower Third with your nameUsing On Air Broadcasting to YouTubeHaving some fun with Effects Pedagogical recommendations were also made regarding how the service can be used in the classroom or outside of the classroom to help students study or complete project based work. The options are limited to your imagination as to how Google Hangouts can help you grow as an educator and how your students collaborate. Catch the Tech Educator Podcast recording LIVE every week on Sundays at 7PM EST at techeducatorpodcast.com!
Tags: Google Drive, Google Hangouts, Tech Educator, Webinar. «Maps Engine Lite» — сервис создания карт от Google. Google Maps Engine Lite — это бесплатный картографический сервис для визуализации ваших данных в привязке к местности. Использование картографических проектов для обработки и распространения информации активно применяется в работе общественных организаций и НГО в тех случаях, когда необходимо наглядно и доступно представить какие-либо данные в привязке к их географическому расположению. Перечень таких ситуаций может быть очень широк: обозначение на картах зон экологического или стихийного бедствия, мест расположения источников воды и ареалов обитания редких животных, статистических данных о грамотности населения и многие другие варианты.
Google Maps Engine Lite — это бесплатный онлайновый сервис, который позволяет всем пользователям на основе карт Google Maps создавать свои собственные карты, загружать и редактировать различные данные, сохранять их и делиться в сети интернет. Для использования этого сервиса необходимо, разумеется, иметь учетную запись Google.
14 Handy Tips on How to Better Use Google Images. This is the fifth guide I created in a series of several posts on how to tap into the educational potential of Google services. Today's topic is Google Images. This is probably among those most used services in education. Teachers and students use images for a variety of learning and teaching reasons. However, before including images in any classroom project, students need to learn about copyright issues. Educational Technology and Mobile Learning has already published a post on this. Check it out here to learn more.
Related guides : As I said earlier, we all use Google Images when looking for pictures to feature in our multimedia projects, but do we all know how to conduct a smart and specific image search ? Supposedly, you typed your keywords in Google Image and got the first result page. 1-Find images in any size you need. 2-Specify the shape of images. 3-Find images in your preferred colors. 4- Limit the kind of images that you find. 5- Find images published in a particular region.
7 Google Search Techniques You Don’t Know Exist. Google search is a powerful tool...sometimes more powerful than you realize! Are you taking advantage of some of the lesser-known Google search techniques? Here are a few of my favorites... SafeSearch It's surprising how many people don't know about Google SafeSearch! SafeSearch filters allow you to modify your browser settings so that inappropriate content does not display in search results.
More on SafeSearch here. Word Definitions To quickly pull up the definition of a word, use "define:" followed by the word. Example: define:webinar Numeric Ranges Useful if you're looking for information that relates to a range of numbers (such as a price range or years). Example: television 1950...1960 Phone numbers Curious who keeps calling your cellphone and not leaving a message? Example: phonebook:555-555-5555 Excluding words or phrases If you're looking for something a little more obscure, narrow down your search results by asking Google to omit certain results by using the "-" symbol. Looking for a PDF? 20 Google Docs Secrets for busy teachers and students. Панорамы Google превратили в интерактивное видео.
Google Authorship. 50 Google Docs Tips Every Teacher should Know about. Как пользоваться социальной сетью Google Plus. Message Board - Облачный-Офис.рф: Примеры решений для Google Sites. Как Поиск работы - История - Inside поиска. Animated Slider / Slideshow - Google Docs Presentation. Вставка картинки в Google форму. 100+ Google Tricks for Teachers. Olga Bryksina – Google+ - Интересно ;) Радует глаз и воспоминания.... Excellent Tech Tools Using ThingLink. List of 99 eLearning Professionals that use Google+ Yuri Eelmaa – Google+ - Коллеги! Нужны хорошие обучалки (в любом формате),… Www.powersearchingwithgoogle.com/assets/misc/AdvancedPowerSearchingQuickReference.pdf. Using Google Docs to Facilitate A Writing Workshop.
Googlassroom: Google in the classroom? Google – Виртуальный принтер. Создание favicon для сайта в Google Sites - Сайт - мое Дело. Google+ - Хорошие новости для всех, кто неравнодушен к Google… Google's Best Apps of 2012. Правила хорошего тона в сообществе Google+ Search Education – Google. Google Glass Features and Apps Still in Flux. Ну и какого плюса??? Интернет-магазин Chrome - Google+ Stamina. Boris Yarmakhov – Google+ - А вы знаете, как в Google+ добавить текст на изображение? … Импортирование слайдов из другой презентации - Cправка - Диск Google. Библиотечные интересности, или Приглашаю к профессиональному общению. Alexander Ivanov – Google+ - Делюсь находкой... Очень увлекательно... How to Open and Edit Word Files in Google Drive. Этап - Google Диск. A Google Docs Template for Multimedia Research.
Вера Короповская – Google+ - +Игорь Маладой пользуйтесь. Семинар о применении сервисов Google. 20+ Google Forms Teachers should not Miss. 19 handy Google tricks that you weren’t aware of. Free Technology for Teachers: 5,000 Stock Images for Google Drive Users. Www.simplek12.com/tlc/g06137od. Google+ Сообщества. Виртуальный принтер Google. 100+ Google Tricks That Will Save You Time in School ? Eternal Code. Teacher's Quick Guide to Google Best Services. «GoogleSites» – сайт без программирования своими руками. Работаем с картами Google. How to Measure Your Social Media Traffic Using Google Analytics. Help Center - How to Link Your Google Docs | Образовательная сессия о продуктах Google (2).
52 Secrets Students Should Know about Google Docs. Кнопка Google “+1″ – новое социальное SEO. | Optimizatorsha.Ru. Академия культуры – Google. Создание коротких ссылок в Google Url Shortener. Транслитерация и другие способы ввода данных в Gmail - Cправка - Gmail. Секреты поиска Google - Социальные сети: веб 2.0 эксперт - "Сарафанное Радио" Инструкция по использованию Google Analytics. Great Ways to Use Google Docs - Presented Visually.
181 Google Tricks That Will Save You Time. Рисунок1.png (1282×1027) Google шаблон для расчета процента успеваемости и качества. Образовательная сессия о продуктах Google. Google Apps for Education K12 Demo. 80+ Google Forms for the Classroom. Pivot Tables in Google Docs. Schedule Email Gmail Send Later Email Tracking. 81 Interesting Ways to Use Google Forms in the Classroom. Google Drive and Docs for Teachers 2012. Cоздание аккаунта Google. Google Launches Free Tool To Let You Run Your Own Online Courses. Course-builder - Course Builder.
Educational Technology and Mobile Learning: free google tools. Teachers Manuel on The Use of Google Docs in Education. Engrade - Рабочий сайт Тимохиной Е.Г. Course-builder - Course Builder. Integrating Google Tools 4 Teachers. Ed.edim.co/1872992/8_ways_google_glasses_will_change_education2.pdf?Expires=1347418207&Signature=TN1kQsErKEbqRuzf7VyQBZSDvYyXbJFqLFqF2zogXJ8oNdGoIH77UI3ekQ4~Hlq~gDm4DwsDGbw82NlamglEwXIA6GQTSbnt6ke7r33UV8uvk~jgpMufmuBlm9xYuCjf4hb65zpQEUMG2JianR1GHMuwavhRn4.