HOMEWORK THAT CORRECTS ITSELF: SAVE TIME WITH KAHOOT! CHALLENGES
I am sharing the Kahoot! blog link, click here, so that you can learn more about Kahoot! homework. Click here to learn more about the Kahoot! mobile app.
Hour of Code Coming
Click here to learn about the activity and create your own Google logo.
Hour of Code New Mindcraft Activity for 2017
5 Google Sheets Updates Teachers Should Know About
You can now instantly sync tables and charts from Sheets to Docs or Slides. You simply copy and paste data from Sheets to Docs or Slides and then tap ‘Update’ button to sync everything.
2-‘Keyboard shortcuts
Change default shortcuts in your browser to the same spreadsheet shortcuts you’re already used to. For example, delete a row quickly by using “Ctrl+-.”
3- Upgraded printing experience
Preview Sheet data in today’s new print interface. Adjust margins, select scale and alignment options or repeat frozen rows and columns before you print your work.
4- Powerful new chart editing experience
Create and edit charts in a new, improved sidebar. Choose from custom colors in charts or add additional trendlines to model data. You can also create more chart types, like 3D charts. This is now also available for iPhones and iPads.
5- More spreadsheet functions
We added new functions to help you find insights, bringing the total function count in Sheets to more than 400. Try “SORTN,” a function unique to Sheets, which can show you the top three orders or best-performing months in a sales record spreadsheet. Sheets also support statistical functions like “GAMMADIST,” “F.TEST” and “CHISQ.INV.RT.”’
Explore for Google
This is only available in English. When you type in data in your sheets, you can use Explore to access quick answers to questions about your data. For instance, in the spreadsheet you created are two columns one for the name of the students and the other for their scores. Examples of the questions you can ask Explore to answer include: what is the total of column B? Which student has the top/least score?. You can also click on suggested questions from Explore to see examples of answers.
- ‘Open a spreadsheet in Google Sheets.
- In the bottom right, click Explore Explore.
- Under "Answers," type your question in the box and press Enter.
- To see example answers, click the suggested questions under the text box.’
Based on the data you typed in your spreadsheet, Explore provides you with charts and analysis showing trends and patterns in your data. You can also get insights for specific portion of your data by selecting only specific cells. When you hover over any part of the chart you will see the corresponding data on which it was based.
You can also easily add generated charts and formulae from Explore window right into your spreadsheet. You simply drag and drop the chart or formula wherever you want in your spreadsheet. To edit a chart, hover your mouse over the chart and click on edit button.
Explore for Google Documents
As you type in content in your document, Explore will display a panel with suggested content that can help you with the writing of your document. This content includes:
Topics:
This tab features a number of suggested topics related to the content of your document. To access any topic click on its title.
The tab provides you with a set of images related to your content which you can add to your document. Added images come with a footnote at the bottom of the document.
In this section you will be able to view research directly related to the topic of your document.
Another excellent feature from Explore is the ability for document editors to quickly search their documents. They can type a search query in the search bar and choose whether they want to search their Drive or the entire web.