Are you over 18 and want to see adult content?
More Annotations
![A complete backup of www.blick.ch/people-tv/international/im-kreuzverhoer-waehrend-vergewaltigungs-prozess-weinstein-zeugin-bric](https://www.archivebay.com/archive2/86dbe474-7f99-4377-b093-cdd8b3a722f5.png)
A complete backup of www.blick.ch/people-tv/international/im-kreuzverhoer-waehrend-vergewaltigungs-prozess-weinstein-zeugin-bric
Are you over 18 and want to see adult content?
![A complete backup of www.stuttgarter-nachrichten.de/inhalt.unfall-in-ludwigsburg-77-jaehriger-uebersieht-feuerwehreinsatz.9cd68f](https://www.archivebay.com/archive2/360f661b-15d0-46da-b962-c895fbc2c595.png)
A complete backup of www.stuttgarter-nachrichten.de/inhalt.unfall-in-ludwigsburg-77-jaehriger-uebersieht-feuerwehreinsatz.9cd68f
Are you over 18 and want to see adult content?
![A complete backup of bola.okezone.com/read/2020/02/02/45/2161990/fernandes-gagal-beri-dampak-di-laga-manchester-united-vs-wolves](https://www.archivebay.com/archive2/ec29b24c-9bef-4dca-9cdc-10b8dcfe7cc4.png)
A complete backup of bola.okezone.com/read/2020/02/02/45/2161990/fernandes-gagal-beri-dampak-di-laga-manchester-united-vs-wolves
Are you over 18 and want to see adult content?
![A complete backup of www.wienerzeitung.at/nachrichten/politik/oesterreich/2048686-Roma-Vertreter-sieht-Umdenken-nach-dem-Attenta](https://www.archivebay.com/archive2/902b9dd3-e47e-45ef-accc-b2094a189a82.png)
A complete backup of www.wienerzeitung.at/nachrichten/politik/oesterreich/2048686-Roma-Vertreter-sieht-Umdenken-nach-dem-Attenta
Are you over 18 and want to see adult content?
![A complete backup of www.finanznachrichten.de/nachrichten-2020-02/48762105-am-weltkrebstag-steht-msd-schweiz-geschlossen-hinter-](https://www.archivebay.com/archive2/a5435422-7546-496d-a3ea-22e9208be263.png)
A complete backup of www.finanznachrichten.de/nachrichten-2020-02/48762105-am-weltkrebstag-steht-msd-schweiz-geschlossen-hinter-
Are you over 18 and want to see adult content?
![A complete backup of www.viva.ro/fara-categorie/adela-popescu-a-inceput-sa-asculte-sfaturile-danei-budeanu-a-postat-pe-instagram](https://www.archivebay.com/archive2/c8f8cfe4-5ca3-447a-b402-a3f540e5b9d4.png)
A complete backup of www.viva.ro/fara-categorie/adela-popescu-a-inceput-sa-asculte-sfaturile-danei-budeanu-a-postat-pe-instagram
Are you over 18 and want to see adult content?
Favourite Annotations
![A complete backup of speisekartenmappen.shop](https://www.archivebay.com/archive5/images/ec7a8d1f-1d85-406e-9316-704c3d964a74.png)
A complete backup of speisekartenmappen.shop
Are you over 18 and want to see adult content?
![A complete backup of chaleuniformes.com.br](https://www.archivebay.com/archive5/images/9fb47d03-9bc2-4259-b1d3-276707bc9a83.png)
A complete backup of chaleuniformes.com.br
Are you over 18 and want to see adult content?
![A complete backup of der-paritaetische.de](https://www.archivebay.com/archive5/images/9b3eeb53-3194-422f-8458-266bf2cbfb9f.png)
A complete backup of der-paritaetische.de
Are you over 18 and want to see adult content?
![A complete backup of littletreepreschool.com](https://www.archivebay.com/archive5/images/5d688fdb-8178-48ff-8e05-0661878935e2.png)
A complete backup of littletreepreschool.com
Are you over 18 and want to see adult content?
![A complete backup of stadtwerke-karlsruhe.de](https://www.archivebay.com/archive5/images/2152ab1a-ab7e-4457-b5d6-9ae873fec38b.png)
A complete backup of stadtwerke-karlsruhe.de
Are you over 18 and want to see adult content?
Text
reality
TOP 10 HEALTH AND PHYSICAL EDUCATION TECH TOOLS BY With that, here are my top ten tried, tested, and true HPE Tech Tools. Tech Tool. Uses in Health & Physical Education. Hardware. Google Forms. Google Forms have been a game changer because they are easy to work with and can be used in many ways! Data collected in a form is sent automatically to a Google Sheet for simple analysis. MAKING A LOT OF COPIES OF THE SAME GOOGLE DOCS This is telling the script to make 30 copies. If you want a different number, change the 30. Each Google document (Docs, Sheets, Slides, Forms, Drawings) has a unique document ID. You need to open the document and copy the long string of number and letters out of the URL. In the script you will want to replace my document ID with yourdocument ID.
GOOGLE SHEETS: PARTIAL FORMATTING WITHIN A CELL Google Sheets: Partial Formatting Within a Cell. by admin. September 6, 2015. May 29, 2018. If you have ever wanted to emphasize a word within a cell on a spreadsheet but were restricted to the same formatting for the entire block of text then you are going to really happy. Google Sheets can now allow you to bold, change font color orincrease
GOOGLE FORMS: SUBMITTING DRAWINGS Google Forms: Submitting Drawings. In Google Forms you may want to ask students a question that requires a visual answer. Google Forms limits student responses to text submissions. Google Drawings allow students to draw and model their learning, work collaboratively with images, create projects and provide evidence of their work. GOOGLE CLASSROOM: MAKE A COPY FOR EACH STUDENT Here is the trick. Open up your original and use Control L to highlight the URL and Control C to copy. In Google Classroom, click on the 3 dots on the assignment in the stream to edit the assignment. Choose to attach a LINK. Use Control V to paste the link to yourdocument.
GOOGLE MEET: SEE YOURSELF Go to the upper right hand corner of Google Meet and find your video. Hover over your video to find 2 icons. Pin and Add yourself as a tile. The 4 squares icon lets you appear on the screen along with other video participants. Hover over yourself to find the 4 squares icon (but now with a line through it) to turn off yourself as a tile. Tags COUNT UP CHECKBOXES IN GOOGLE SHEETS My favorite part of Google Sheets is inserting checkboxes! WICKED USEFUL FOR TEACHERS! My daughter is helping me with my YouTube thumbnails (check out her handiwork and subscribe to my channel 🙂 She is using a Google Sheets spreadsheet to keep track of how many thumbnails she creates for me, and I’m paying her.She made a list of checkboxes and each time she GOOGLE SITES: ALIGNING AND CENTERING TEXT AND IMAGES The trick is to add additional textboxes without text. Double click and choose “Text.”. Below that, double click and choose “Text” again. This stacks 2 textboxes together. Usually I forget that I want the blank textbox and I end up needing to create a blank textbox below the text. Look for the “grippy dots” that allow you to grab EMBED VIDEO IN MICROSOFT FORMS In YouTube, right click on the video to choose “Copy video URL at current time.”. Notice for both Stream and YouTube the end of the video link is modified to indicate the start time. Paste the modified link into Microsoft Forms. The video in the Form will start at the indicated start time when played. GOOGLE SHEETS: SPREADSHEET SETTINGS Notice in the screenshot below that my formula in C5 is =SUM (C1:C5) and the sum says 45. This is because when you turn on "Iterative calculation" it asks you how many times to do the circular reference. The default is 50. So 50 times it added up the sum of C1 to C5, which includes the sum. It's a fun math problem to think about but thereality
TOP 10 HEALTH AND PHYSICAL EDUCATION TECH TOOLS BY With that, here are my top ten tried, tested, and true HPE Tech Tools. Tech Tool. Uses in Health & Physical Education. Hardware. Google Forms. Google Forms have been a game changer because they are easy to work with and can be used in many ways! Data collected in a form is sent automatically to a Google Sheet for simple analysis. MAKING A LOT OF COPIES OF THE SAME GOOGLE DOCS This is telling the script to make 30 copies. If you want a different number, change the 30. Each Google document (Docs, Sheets, Slides, Forms, Drawings) has a unique document ID. You need to open the document and copy the long string of number and letters out of the URL. In the script you will want to replace my document ID with yourdocument ID.
GOOGLE SHEETS: PARTIAL FORMATTING WITHIN A CELL Google Sheets: Partial Formatting Within a Cell. by admin. September 6, 2015. May 29, 2018. If you have ever wanted to emphasize a word within a cell on a spreadsheet but were restricted to the same formatting for the entire block of text then you are going to really happy. Google Sheets can now allow you to bold, change font color orincrease
GOOGLE FORMS: SUBMITTING DRAWINGS Google Forms: Submitting Drawings. In Google Forms you may want to ask students a question that requires a visual answer. Google Forms limits student responses to text submissions. Google Drawings allow students to draw and model their learning, work collaboratively with images, create projects and provide evidence of their work. GOOGLE CLASSROOM: MAKE A COPY FOR EACH STUDENT Here is the trick. Open up your original and use Control L to highlight the URL and Control C to copy. In Google Classroom, click on the 3 dots on the assignment in the stream to edit the assignment. Choose to attach a LINK. Use Control V to paste the link to yourdocument.
TEACHER TECH WITH ALICE KEELER Google Classroom: Get Out of Suggestion Mode. When using Google Classroom the default for feedback is suggestion mode in a Google Doc. Switch to Edit mode. Focus on computer science and STEM! By @Rdene915. 5 resources to bring coding into the classroom. Explore the activities or curriculum offered, or take advantage of the trial for platforms GOOGLE SITES: ALIGNING AND CENTERING TEXT AND IMAGES The trick is to add additional textboxes without text. Double click and choose “Text.”. Below that, double click and choose “Text” again. This stacks 2 textboxes together. Usually I forget that I want the blank textbox and I end up needing to create a blank textbox below the text. Look for the “grippy dots” that allow you to grab MINECRAFT EDUCATION EDITION Students CREATE and EXPLORE and BUILD their learning with Minecraft. This is an excellent tool for students in elementary all the way to 12th grade. Student engagement and excitement abounds when using Minecraft for learning. Check out this project made by a student who was assigned to create a Rube Goldberg machine in Minecraft. MICROSOFT TEAMS: NEW CONVERSATION The “New conversation” button is cleverly added to the bottom of the Posts. New conversation posts go to the bottom, so instead of dragging your mouse all the way to the top, only to reply at the bottom. Microsoft Teams has intuitively designed the button for where the action is. The large purple button makes it very clear you are 5 WAYS TO PRETTY UP GOOGLE DRIVE If your Google Drive is a mess, here are 5 ways to make it prettier! 1. Rename Your Folders. Whatever folder I am using a lot right now, I rename the folder and put a zero in front of it. This way it is the FIRST option when I am trying to organize a file. No digging around inmultiple folders.
GOOGLE SHEETS: TEXT AND NUMBERS IN ONE CELL When writing a formula in a spreadsheet you always start with the equals sign. Any text strings must be in quotation marks. Notice the space after the s in points. You will end up with points1000 instead of points 1000 if you forget to include the space. In the formula, you are joining the word points with the formula, sum (D2:D). GOOGLE SPREADSHEETS: ABSOLUTE CELL REFERENCING Cell referencing is when you use a formula to refer to a cell. In a spreadsheet you start a formula with an equals sign (=) and then command the spreadsheet to complete a task. Example: typing =5+6 into a cell and pressing enter will calculate the value and return 11. GOOGLE FORMS: SUBMITTING DRAWINGS Google Forms: Submitting Drawings. In Google Forms you may want to ask students a question that requires a visual answer. Google Forms limits student responses to text submissions. Google Drawings allow students to draw and model their learning, work collaboratively with images, create projects and provide evidence of their work. GOOGLE FORMS: FINISH FILLING OUT LATER Edit Response. When editing a Google Form, in the settings cog, is the option to “Edit after submit.” This gives you the false assumption that students can come back to GOOGLE CLASSROOM: MAKE A COPY FOR EACH STUDENT Here is the trick. Open up your original and use Control L to highlight the URL and Control C to copy. In Google Classroom, click on the 3 dots on the assignment in the stream to edit the assignment. Choose to attach a LINK. Use Control V to paste the link to yourdocument.
COUNT UP CHECKBOXES IN GOOGLE SHEETS My favorite part of Google Sheets is inserting checkboxes! WICKED USEFUL FOR TEACHERS! My daughter is helping me with my YouTube thumbnails (check out her handiwork and subscribe to my channel 🙂 She is using a Google Sheets spreadsheet to keep track of how many thumbnails she creates for me, and I’m paying her.She made a list of checkboxes and each time she GOOGLE MEET: SEE YOURSELF Go to the upper right hand corner of Google Meet and find your video. Hover over your video to find 2 icons. Pin and Add yourself as a tile. The 4 squares icon lets you appear on the screen along with other video participants. Hover over yourself to find the 4 squares icon (but now with a line through it) to turn off yourself as a tile. Tags GOOGLE SITES: ALIGNING AND CENTERING TEXT AND IMAGES The trick is to add additional textboxes without text. Double click and choose “Text.”. Below that, double click and choose “Text” again. This stacks 2 textboxes together. Usually I forget that I want the blank textbox and I end up needing to create a blank textbox below the text. Look for the “grippy dots” that allow you to grab GOOGLE MEET: SEE YOUR PRESENTATION AND THE PARTICIPANTS Use the 2nd Tab. On the 2nd Tab you are not the presenter but rather just another participant. You can see the presentation AND the participants on that tab. No pinning of the presentation required. Tip: Mute your mic and turn off the camera on the EMBED VIDEO IN MICROSOFT FORMS In YouTube, right click on the video to choose “Copy video URL at current time.”. Notice for both Stream and YouTube the end of the video link is modified to indicate the start time. Paste the modified link into Microsoft Forms. The video in the Form will start at the indicated start time when played. GOOGLE SHEETS: SPREADSHEET SETTINGS Notice in the screenshot below that my formula in C5 is =SUM (C1:C5) and the sum says 45. This is because when you turn on "Iterative calculation" it asks you how many times to do the circular reference. The default is 50. So 50 times it added up the sum of C1 to C5, which includes the sum. It's a fun math problem to think about but thereality
TOP 10 HEALTH AND PHYSICAL EDUCATION TECH TOOLS BY With that, here are my top ten tried, tested, and true HPE Tech Tools. Tech Tool. Uses in Health & Physical Education. Hardware. Google Forms. Google Forms have been a game changer because they are easy to work with and can be used in many ways! Data collected in a form is sent automatically to a Google Sheet for simple analysis. MAKING A LOT OF COPIES OF THE SAME GOOGLE DOCS This is telling the script to make 30 copies. If you want a different number, change the 30. Each Google document (Docs, Sheets, Slides, Forms, Drawings) has a unique document ID. You need to open the document and copy the long string of number and letters out of the URL. In the script you will want to replace my document ID with yourdocument ID.
GOOGLE SHEETS: PARTIAL FORMATTING WITHIN A CELL Google Sheets: Partial Formatting Within a Cell. by admin. September 6, 2015. May 29, 2018. If you have ever wanted to emphasize a word within a cell on a spreadsheet but were restricted to the same formatting for the entire block of text then you are going to really happy. Google Sheets can now allow you to bold, change font color orincrease
GOOGLE CLASSROOM: MAKE A COPY FOR EACH STUDENT Here is the trick. Open up your original and use Control L to highlight the URL and Control C to copy. In Google Classroom, click on the 3 dots on the assignment in the stream to edit the assignment. Choose to attach a LINK. Use Control V to paste the link to yourdocument.
COUNT UP CHECKBOXES IN GOOGLE SHEETS My favorite part of Google Sheets is inserting checkboxes! WICKED USEFUL FOR TEACHERS! My daughter is helping me with my YouTube thumbnails (check out her handiwork and subscribe to my channel 🙂 She is using a Google Sheets spreadsheet to keep track of how many thumbnails she creates for me, and I’m paying her.She made a list of checkboxes and each time she GOOGLE MEET: SEE YOURSELF Go to the upper right hand corner of Google Meet and find your video. Hover over your video to find 2 icons. Pin and Add yourself as a tile. The 4 squares icon lets you appear on the screen along with other video participants. Hover over yourself to find the 4 squares icon (but now with a line through it) to turn off yourself as a tile. Tags GOOGLE SITES: ALIGNING AND CENTERING TEXT AND IMAGES The trick is to add additional textboxes without text. Double click and choose “Text.”. Below that, double click and choose “Text” again. This stacks 2 textboxes together. Usually I forget that I want the blank textbox and I end up needing to create a blank textbox below the text. Look for the “grippy dots” that allow you to grab GOOGLE MEET: SEE YOUR PRESENTATION AND THE PARTICIPANTS Use the 2nd Tab. On the 2nd Tab you are not the presenter but rather just another participant. You can see the presentation AND the participants on that tab. No pinning of the presentation required. Tip: Mute your mic and turn off the camera on the EMBED VIDEO IN MICROSOFT FORMS In YouTube, right click on the video to choose “Copy video URL at current time.”. Notice for both Stream and YouTube the end of the video link is modified to indicate the start time. Paste the modified link into Microsoft Forms. The video in the Form will start at the indicated start time when played. GOOGLE SHEETS: SPREADSHEET SETTINGS Notice in the screenshot below that my formula in C5 is =SUM (C1:C5) and the sum says 45. This is because when you turn on "Iterative calculation" it asks you how many times to do the circular reference. The default is 50. So 50 times it added up the sum of C1 to C5, which includes the sum. It's a fun math problem to think about but thereality
TOP 10 HEALTH AND PHYSICAL EDUCATION TECH TOOLS BY With that, here are my top ten tried, tested, and true HPE Tech Tools. Tech Tool. Uses in Health & Physical Education. Hardware. Google Forms. Google Forms have been a game changer because they are easy to work with and can be used in many ways! Data collected in a form is sent automatically to a Google Sheet for simple analysis. MAKING A LOT OF COPIES OF THE SAME GOOGLE DOCS This is telling the script to make 30 copies. If you want a different number, change the 30. Each Google document (Docs, Sheets, Slides, Forms, Drawings) has a unique document ID. You need to open the document and copy the long string of number and letters out of the URL. In the script you will want to replace my document ID with yourdocument ID.
GOOGLE SHEETS: PARTIAL FORMATTING WITHIN A CELL Google Sheets: Partial Formatting Within a Cell. by admin. September 6, 2015. May 29, 2018. If you have ever wanted to emphasize a word within a cell on a spreadsheet but were restricted to the same formatting for the entire block of text then you are going to really happy. Google Sheets can now allow you to bold, change font color orincrease
GOOGLE CLASSROOM: MAKE A COPY FOR EACH STUDENT Here is the trick. Open up your original and use Control L to highlight the URL and Control C to copy. In Google Classroom, click on the 3 dots on the assignment in the stream to edit the assignment. Choose to attach a LINK. Use Control V to paste the link to yourdocument.
GOOGLE SITES: ALIGNING AND CENTERING TEXT AND IMAGES The trick is to add additional textboxes without text. Double click and choose “Text.”. Below that, double click and choose “Text” again. This stacks 2 textboxes together. Usually I forget that I want the blank textbox and I end up needing to create a blank textbox below the text. Look for the “grippy dots” that allow you to grab MINECRAFT EDUCATION EDITION Students CREATE and EXPLORE and BUILD their learning with Minecraft. This is an excellent tool for students in elementary all the way to 12th grade. Student engagement and excitement abounds when using Minecraft for learning. Check out this project made by a student who was assigned to create a Rube Goldberg machine in Minecraft. 5 THINGS YOU MAY NOT KNOW ABOUT GOOGLE CLASSROOM 5 Hidden Elements of Google Classroom. As with any platform, there are things to understand that are not a button to click on. Knowing how Google Classroom works with Google Drive and how it interacts with students can help you to better use Classroom. MICROSOFT TEAMS: NEW CONVERSATION The “New conversation” button is cleverly added to the bottom of the Posts. New conversation posts go to the bottom, so instead of dragging your mouse all the way to the top, only to reply at the bottom. Microsoft Teams has intuitively designed the button for where the action is. The large purple button makes it very clear you are 5 WAYS TO PRETTY UP GOOGLE DRIVE If your Google Drive is a mess, here are 5 ways to make it prettier! 1. Rename Your Folders. Whatever folder I am using a lot right now, I rename the folder and put a zero in front of it. This way it is the FIRST option when I am trying to organize a file. No digging around inmultiple folders.
GOOGLE FORMS: SUBMITTING DRAWINGS Google Forms: Submitting Drawings. In Google Forms you may want to ask students a question that requires a visual answer. Google Forms limits student responses to text submissions. Google Drawings allow students to draw and model their learning, work collaboratively with images, create projects and provide evidence of their work. GOOGLE SHEETS: TEXT AND NUMBERS IN ONE CELL When writing a formula in a spreadsheet you always start with the equals sign. Any text strings must be in quotation marks. Notice the space after the s in points. You will end up with points1000 instead of points 1000 if you forget to include the space. In the formula, you are joining the word points with the formula, sum (D2:D). GOOGLE SPREADSHEETS: ABSOLUTE CELL REFERENCING Cell referencing is when you use a formula to refer to a cell. In a spreadsheet you start a formula with an equals sign (=) and then command the spreadsheet to complete a task. Example: typing =5+6 into a cell and pressing enter will calculate the value and return 11. GOOGLE FORMS: COLLECT FIRST NAME AND LAST NAME Collect Last Name and First Name. When creating a Google Form I always ask for last name as a different question than first name. This solves several problems. 1) I can sort the spreadsheet of data by last name, which is really handy when I want to put grades and comments in the gradebook based on the quiz. 2) When I ask for “name” I will GOOGLE CLASSROOM: MAKE A COPY FOR EACH STUDENT Here is the trick. Open up your original and use Control L to highlight the URL and Control C to copy. In Google Classroom, click on the 3 dots on the assignment in the stream to edit the assignment. Choose to attach a LINK. Use Control V to paste the link to yourdocument.
COUNT UP CHECKBOXES IN GOOGLE SHEETS My favorite part of Google Sheets is inserting checkboxes! WICKED USEFUL FOR TEACHERS! My daughter is helping me with my YouTube thumbnails (check out her handiwork and subscribe to my channel 🙂 She is using a Google Sheets spreadsheet to keep track of how many thumbnails she creates for me, and I’m paying her.She made a list of checkboxes and each time she GOOGLE MEET: SEE YOURSELF Go to the upper right hand corner of Google Meet and find your video. Hover over your video to find 2 icons. Pin and Add yourself as a tile. The 4 squares icon lets you appear on the screen along with other video participants. Hover over yourself to find the 4 squares icon (but now with a line through it) to turn off yourself as a tile. Tags GOOGLE SITES: ALIGNING AND CENTERING TEXT AND IMAGES The trick is to add additional textboxes without text. Double click and choose “Text.”. Below that, double click and choose “Text” again. This stacks 2 textboxes together. Usually I forget that I want the blank textbox and I end up needing to create a blank textbox below the text. Look for the “grippy dots” that allow you to grab GOOGLE MEET: SEE YOUR PRESENTATION AND THE PARTICIPANTS Use the 2nd Tab. On the 2nd Tab you are not the presenter but rather just another participant. You can see the presentation AND the participants on that tab. No pinning of the presentation required. Tip: Mute your mic and turn off the camera on the EMBED VIDEO IN MICROSOFT FORMS In YouTube, right click on the video to choose “Copy video URL at current time.”. Notice for both Stream and YouTube the end of the video link is modified to indicate the start time. Paste the modified link into Microsoft Forms. The video in the Form GOOGLE SHEETS: SPREADSHEET SETTINGS Notice in the screenshot below that my formula in C5 is =SUM (C1:C5) and the sum says 45. This is because when you turn on "Iterative calculation" it asks you how many times to do the circular reference. The default is 50. So 50 times it added up the sum of C1 to C5, which includes the sum. It's a fun math problem to think about but thereality
TOP 10 HEALTH AND PHYSICAL EDUCATION TECH TOOLS BY With that, here are my top ten tried, tested, and true HPE Tech Tools. Tech Tool. Uses in Health & Physical Education. Hardware. Google Forms. Google Forms have been a game changer because they are easy to work with and can be used in many ways! Data collected in a form is sent automatically to a Google Sheet for simple analysis. MAKING A LOT OF COPIES OF THE SAME GOOGLE DOCS This is telling the script to make 30 copies. If you want a different number, change the 30. Each Google document (Docs, Sheets, Slides, Forms, Drawings) has a unique document ID. You need to open the document and copy the long string of number and letters out of the URL. In the script you will want to replace my document ID with yourdocument ID.
GOOGLE SHEETS: PARTIAL FORMATTING WITHIN A CELL Google Sheets: Partial Formatting Within a Cell. by admin. September 6, 2015. May 29, 2018. If you have ever wanted to emphasize a word within a cell on a spreadsheet but were restricted to the same formatting for the entire block of text then you are going to really happy. Google Sheets can now allow you to bold, change font color orincrease
GOOGLE CLASSROOM: MAKE A COPY FOR EACH STUDENT Here is the trick. Open up your original and use Control L to highlight the URL and Control C to copy. In Google Classroom, click on the 3 dots on the assignment in the stream to edit the assignment. Choose to attach a LINK. Use Control V to paste the link to yourdocument.
COUNT UP CHECKBOXES IN GOOGLE SHEETS My favorite part of Google Sheets is inserting checkboxes! WICKED USEFUL FOR TEACHERS! My daughter is helping me with my YouTube thumbnails (check out her handiwork and subscribe to my channel 🙂 She is using a Google Sheets spreadsheet to keep track of how many thumbnails she creates for me, and I’m paying her.She made a list of checkboxes and each time she GOOGLE MEET: SEE YOURSELF Go to the upper right hand corner of Google Meet and find your video. Hover over your video to find 2 icons. Pin and Add yourself as a tile. The 4 squares icon lets you appear on the screen along with other video participants. Hover over yourself to find the 4 squares icon (but now with a line through it) to turn off yourself as a tile. Tags GOOGLE SITES: ALIGNING AND CENTERING TEXT AND IMAGES The trick is to add additional textboxes without text. Double click and choose “Text.”. Below that, double click and choose “Text” again. This stacks 2 textboxes together. Usually I forget that I want the blank textbox and I end up needing to create a blank textbox below the text. Look for the “grippy dots” that allow you to grab GOOGLE MEET: SEE YOUR PRESENTATION AND THE PARTICIPANTS Use the 2nd Tab. On the 2nd Tab you are not the presenter but rather just another participant. You can see the presentation AND the participants on that tab. No pinning of the presentation required. Tip: Mute your mic and turn off the camera on the EMBED VIDEO IN MICROSOFT FORMS In YouTube, right click on the video to choose “Copy video URL at current time.”. Notice for both Stream and YouTube the end of the video link is modified to indicate the start time. Paste the modified link into Microsoft Forms. The video in the Form will start at the indicated start time when played. GOOGLE SHEETS: SPREADSHEET SETTINGS Notice in the screenshot below that my formula in C5 is =SUM (C1:C5) and the sum says 45. This is because when you turn on "Iterative calculation" it asks you how many times to do the circular reference. The default is 50. So 50 times it added up the sum of C1 to C5, which includes the sum. It's a fun math problem to think about but thereality
TOP 10 HEALTH AND PHYSICAL EDUCATION TECH TOOLS BY With that, here are my top ten tried, tested, and true HPE Tech Tools. Tech Tool. Uses in Health & Physical Education. Hardware. Google Forms. Google Forms have been a game changer because they are easy to work with and can be used in many ways! Data collected in a form is sent automatically to a Google Sheet for simple analysis. MAKING A LOT OF COPIES OF THE SAME GOOGLE DOCS This is telling the script to make 30 copies. If you want a different number, change the 30. Each Google document (Docs, Sheets, Slides, Forms, Drawings) has a unique document ID. You need to open the document and copy the long string of number and letters out of the URL. In the script you will want to replace my document ID with yourdocument ID.
GOOGLE SHEETS: PARTIAL FORMATTING WITHIN A CELL Google Sheets: Partial Formatting Within a Cell. by admin. September 6, 2015. May 29, 2018. If you have ever wanted to emphasize a word within a cell on a spreadsheet but were restricted to the same formatting for the entire block of text then you are going to really happy. Google Sheets can now allow you to bold, change font color orincrease
GOOGLE CLASSROOM: MAKE A COPY FOR EACH STUDENT Here is the trick. Open up your original and use Control L to highlight the URL and Control C to copy. In Google Classroom, click on the 3 dots on the assignment in the stream to edit the assignment. Choose to attach a LINK. Use Control V to paste the link to yourdocument.
GOOGLE SITES: ALIGNING AND CENTERING TEXT AND IMAGES The trick is to add additional textboxes without text. Double click and choose “Text.”. Below that, double click and choose “Text” again. This stacks 2 textboxes together. Usually I forget that I want the blank textbox and I end up needing to create a blank textbox below the text. Look for the “grippy dots” that allow you to grab MINECRAFT EDUCATION EDITION Students CREATE and EXPLORE and BUILD their learning with Minecraft. This is an excellent tool for students in elementary all the way to 12th grade. Student engagement and excitement abounds when using Minecraft for learning. Check out this project made by a student who was assigned to create a Rube Goldberg machine in Minecraft. 5 THINGS YOU MAY NOT KNOW ABOUT GOOGLE CLASSROOM 5 Hidden Elements of Google Classroom. As with any platform, there are things to understand that are not a button to click on. Knowing how Google Classroom works with Google Drive and how it interacts with students can help you to better use Classroom. MICROSOFT TEAMS: NEW CONVERSATION The “New conversation” button is cleverly added to the bottom of the Posts. New conversation posts go to the bottom, so instead of dragging your mouse all the way to the top, only to reply at the bottom. Microsoft Teams has intuitively designed the button for where the action is. The large purple button makes it very clear you are 5 WAYS TO PRETTY UP GOOGLE DRIVE If your Google Drive is a mess, here are 5 ways to make it prettier! 1. Rename Your Folders. Whatever folder I am using a lot right now, I rename the folder and put a zero in front of it. This way it is the FIRST option when I am trying to organize a file. No digging around inmultiple folders.
GOOGLE FORMS: SUBMITTING DRAWINGS Google Forms: Submitting Drawings. In Google Forms you may want to ask students a question that requires a visual answer. Google Forms limits student responses to text submissions. Google Drawings allow students to draw and model their learning, work collaboratively with images, create projects and provide evidence of their work. GOOGLE SHEETS: TEXT AND NUMBERS IN ONE CELL When writing a formula in a spreadsheet you always start with the equals sign. Any text strings must be in quotation marks. Notice the space after the s in points. You will end up with points1000 instead of points 1000 if you forget to include the space. In the formula, you are joining the word points with the formula, sum (D2:D). GOOGLE SPREADSHEETS: ABSOLUTE CELL REFERENCING Cell referencing is when you use a formula to refer to a cell. In a spreadsheet you start a formula with an equals sign (=) and then command the spreadsheet to complete a task. Example: typing =5+6 into a cell and pressing enter will calculate the value and return 11. GOOGLE FORMS: COLLECT FIRST NAME AND LAST NAME Collect Last Name and First Name. When creating a Google Form I always ask for last name as a different question than first name. This solves several problems. 1) I can sort the spreadsheet of data by last name, which is really handy when I want to put grades and comments in the gradebook based on the quiz. 2) When I ask for “name” I will GOOGLE CLASSROOM: MAKE A COPY FOR EACH STUDENT Here is the trick. Open up your original and use Control L to highlight the URL and Control C to copy. In Google Classroom, click on the 3 dots on the assignment in the stream to edit the assignment. Choose to attach a LINK. Use Control V to paste the link to yourdocument.
TEACHER TECH WITH ALICE KEELERHIRE MEALL POSTSTEMPLATESGOOGLE CLASSROOMMICROSOFTAPPS SCRIPT TUTORIALS Google Classroom: Get Out of Suggestion Mode. When using Google Classroom the default for feedback is suggestion mode in a Google Doc. Switch to Edit mode. Focus on computer science and STEM! By @Rdene915. 5 resources to bring coding into the classroom. Explore the activities or curriculum offered, or take advantage of the trial for platforms GOOGLE MEET: SEE YOURSELF Go to the upper right hand corner of Google Meet and find your video. Hover over your video to find 2 icons. Pin and Add yourself as a tile. The 4 squares icon lets you appear on the screen along with other video participants. Hover over yourself to find the 4 squares icon (but now with a line through it) to turn off yourself as a tile. Tags COUNT UP CHECKBOXES IN GOOGLE SHEETS My favorite part of Google Sheets is inserting checkboxes! WICKED USEFUL FOR TEACHERS! My daughter is helping me with my YouTube thumbnails (check out her handiwork and subscribe to my channel 🙂 She is using a Google Sheets spreadsheet to keep track of how many thumbnails she creates for me, and I’m paying her.She made a list of checkboxes and each time she GOOGLE MEET: SEE YOUR PRESENTATION AND THE PARTICIPANTS Use the 2nd Tab. On the 2nd Tab you are not the presenter but rather just another participant. You can see the presentation AND the participants on that tab. No pinning of the presentation required. Tip: Mute your mic and turn off the camera on the GOOGLE SITES: ALIGNING AND CENTERING TEXT AND IMAGES The trick is to add additional textboxes without text. Double click and choose “Text.”. Below that, double click and choose “Text” again. This stacks 2 textboxes together. Usually I forget that I want the blank textbox and I end up needing to create a blank textbox below the text. Look for the “grippy dots” that allow you to grab EMBED VIDEO IN MICROSOFT FORMS In YouTube, right click on the video to choose “Copy video URL at current time.”. Notice for both Stream and YouTube the end of the video link is modified to indicate the start time. Paste the modified link into Microsoft Forms. The video in the Form will start at the indicated start time when played. MAKING A LOT OF COPIES OF THE SAME GOOGLE DOCS This is telling the script to make 30 copies. If you want a different number, change the 30. Each Google document (Docs, Sheets, Slides, Forms, Drawings) has a unique document ID. You need to open the document and copy the long string of number and letters out of the URL. In the script you will want to replace my document ID with yourdocument ID.
GOOGLE SHEETS: SPREADSHEET SETTINGS Notice in the screenshot below that my formula in C5 is =SUM (C1:C5) and the sum says 45. This is because when you turn on "Iterative calculation" it asks you how many times to do the circular reference. The default is 50. So 50 times it added up the sum of C1 to C5, which includes the sum. It's a fun math problem to think about but thereality
GOOGLE SHEETS: TEXT AND NUMBERS IN ONE CELL When writing a formula in a spreadsheet you always start with the equals sign. Any text strings must be in quotation marks. Notice the space after the s in points. You will end up with points1000 instead of points 1000 if you forget to include the space. In the formula, you are joining the word points with the formula, sum (D2:D). GOOGLE SHEETS: PARTIAL FORMATTING WITHIN A CELL Google Sheets: Partial Formatting Within a Cell. by admin. September 6, 2015. May 29, 2018. If you have ever wanted to emphasize a word within a cell on a spreadsheet but were restricted to the same formatting for the entire block of text then you are going to really happy. Google Sheets can now allow you to bold, change font color orincrease
TEACHER TECH WITH ALICE KEELERHIRE MEALL POSTSTEMPLATESGOOGLE CLASSROOMMICROSOFTAPPS SCRIPT TUTORIALS Google Classroom: Get Out of Suggestion Mode. When using Google Classroom the default for feedback is suggestion mode in a Google Doc. Switch to Edit mode. Focus on computer science and STEM! By @Rdene915. 5 resources to bring coding into the classroom. Explore the activities or curriculum offered, or take advantage of the trial for platforms GOOGLE MEET: SEE YOURSELF Go to the upper right hand corner of Google Meet and find your video. Hover over your video to find 2 icons. Pin and Add yourself as a tile. The 4 squares icon lets you appear on the screen along with other video participants. Hover over yourself to find the 4 squares icon (but now with a line through it) to turn off yourself as a tile. Tags COUNT UP CHECKBOXES IN GOOGLE SHEETS My favorite part of Google Sheets is inserting checkboxes! WICKED USEFUL FOR TEACHERS! My daughter is helping me with my YouTube thumbnails (check out her handiwork and subscribe to my channel 🙂 She is using a Google Sheets spreadsheet to keep track of how many thumbnails she creates for me, and I’m paying her.She made a list of checkboxes and each time she GOOGLE MEET: SEE YOUR PRESENTATION AND THE PARTICIPANTS Use the 2nd Tab. On the 2nd Tab you are not the presenter but rather just another participant. You can see the presentation AND the participants on that tab. No pinning of the presentation required. Tip: Mute your mic and turn off the camera on the GOOGLE SITES: ALIGNING AND CENTERING TEXT AND IMAGES The trick is to add additional textboxes without text. Double click and choose “Text.”. Below that, double click and choose “Text” again. This stacks 2 textboxes together. Usually I forget that I want the blank textbox and I end up needing to create a blank textbox below the text. Look for the “grippy dots” that allow you to grab EMBED VIDEO IN MICROSOFT FORMS In YouTube, right click on the video to choose “Copy video URL at current time.”. Notice for both Stream and YouTube the end of the video link is modified to indicate the start time. Paste the modified link into Microsoft Forms. The video in the Form will start at the indicated start time when played. MAKING A LOT OF COPIES OF THE SAME GOOGLE DOCS This is telling the script to make 30 copies. If you want a different number, change the 30. Each Google document (Docs, Sheets, Slides, Forms, Drawings) has a unique document ID. You need to open the document and copy the long string of number and letters out of the URL. In the script you will want to replace my document ID with yourdocument ID.
GOOGLE SHEETS: SPREADSHEET SETTINGS Notice in the screenshot below that my formula in C5 is =SUM (C1:C5) and the sum says 45. This is because when you turn on "Iterative calculation" it asks you how many times to do the circular reference. The default is 50. So 50 times it added up the sum of C1 to C5, which includes the sum. It's a fun math problem to think about but thereality
GOOGLE SHEETS: TEXT AND NUMBERS IN ONE CELL When writing a formula in a spreadsheet you always start with the equals sign. Any text strings must be in quotation marks. Notice the space after the s in points. You will end up with points1000 instead of points 1000 if you forget to include the space. In the formula, you are joining the word points with the formula, sum (D2:D). GOOGLE SHEETS: PARTIAL FORMATTING WITHIN A CELL Google Sheets: Partial Formatting Within a Cell. by admin. September 6, 2015. May 29, 2018. If you have ever wanted to emphasize a word within a cell on a spreadsheet but were restricted to the same formatting for the entire block of text then you are going to really happy. Google Sheets can now allow you to bold, change font color orincrease
TEACHER TECH WITH ALICE KEELER Google Classroom: Get Out of Suggestion Mode. When using Google Classroom the default for feedback is suggestion mode in a Google Doc. Switch to Edit mode. Focus on computer science and STEM! By @Rdene915. 5 resources to bring coding into the classroom. Explore the activities or curriculum offered, or take advantage of the trial for platforms GOOGLE SITES: ALIGNING AND CENTERING TEXT AND IMAGES The trick is to add additional textboxes without text. Double click and choose “Text.”. Below that, double click and choose “Text” again. This stacks 2 textboxes together. Usually I forget that I want the blank textbox and I end up needing to create a blank textbox below the text. Look for the “grippy dots” that allow you to grab MINECRAFT EDUCATION EDITION Microsoft is offering FREE Minecraft Education Edition licenses through June. Students CREATE and EXPLORE and BUILD their learning with Minecraft. This is an excellent tool for students in elementary all the way to 12th grade. Student engagement and excitement abounds when using Minecraft for learning. MICROSOFT TEAMS: NEW CONVERSATION The “New conversation” button is cleverly added to the bottom of the Posts. New conversation posts go to the bottom, so instead of dragging your mouse all the way to the top, only to reply at the bottom. Microsoft Teams has intuitively designed the button for where the action is. The large purple button makes it very clear you are 5 WAYS TO PRETTY UP GOOGLE DRIVE If your Google Drive is a mess, here are 5 ways to make it prettier! 1. Rename Your Folders. Whatever folder I am using a lot right now, I rename the folder and put a zero in front of it. This way it is the FIRST option when I am trying to organize a file. No digging around inmultiple folders.
5 THINGS YOU MAY NOT KNOW ABOUT GOOGLE CLASSROOM 5 Hidden Elements of Google Classroom. As with any platform, there are things to understand that are not a button to click on. Knowing how Google Classroom works with Google Drive and how it interacts with students can help you to better use Classroom. GOOGLE SHEETS: TEXT AND NUMBERS IN ONE CELL When writing a formula in a spreadsheet you always start with the equals sign. Any text strings must be in quotation marks. Notice the space after the s in points. You will end up with points1000 instead of points 1000 if you forget to include the space. In the formula, you are joining the word points with the formula, sum (D2:D). GOOGLE SPREADSHEETS: ABSOLUTE CELL REFERENCING Cell referencing is when you use a formula to refer to a cell. In a spreadsheet you start a formula with an equals sign (=) and then command the spreadsheet to complete a task. Example: typing =5+6 into a cell and pressing enter will calculate the value and return 11. GOOGLE FORMS: SUBMITTING DRAWINGS Google Forms: Submitting Drawings. In Google Forms you may want to ask students a question that requires a visual answer. Google Forms limits student responses to text submissions. Google Drawings allow students to draw and model their learning, work collaboratively with images, create projects and provide evidence of their work. GOOGLE CLASSROOM: MAKE A COPY FOR EACH STUDENT Here is the trick. Open up your original and use Control L to highlight the URL and Control C to copy. In Google Classroom, click on the 3 dots on the assignment in the stream to edit the assignment. Choose to attach a LINK. Use Control V to paste the link to yourdocument.
COUNT UP CHECKBOXES IN GOOGLE SHEETS My favorite part of Google Sheets is inserting checkboxes! WICKED USEFUL FOR TEACHERS! My daughter is helping me with my YouTube thumbnails (check out her handiwork and subscribe to my channel 🙂 She is using a Google Sheets spreadsheet to keep track of how many thumbnails she creates for me, and I’m paying her.She made a list of checkboxes and each time she GOOGLE MEET: SEE YOURSELF Go to the upper right hand corner of Google Meet and find your video. Hover over your video to find 2 icons. Pin and Add yourself as a tile. The 4 squares icon lets you appear on the screen along with other video participants. Hover over yourself to find the 4 squares icon (but now with a line through it) to turn off yourself as a tile. Tags GOOGLE MEET: SEE YOUR PRESENTATION AND THE PARTICIPANTS Use the 2nd Tab. On the 2nd Tab you are not the presenter but rather just another participant. You can see the presentation AND the participants on that tab. No pinning of the presentation required. Tip: Mute your mic and turn off the camera on the GOOGLE DRAWING: CREATE A DROP SHADOW I think I have an addiction to creating drop shadows in Google Drawing (and Google Slides.) It just adds a little pop to all of my text. Notice the two images I created in Google Drawing. GOOGLE SHEETS: SPREADSHEET SETTINGS Notice in the screenshot below that my formula in C5 is =SUM (C1:C5) and the sum says 45. This is because when you turn on "Iterative calculation" it asks you how many times to do the circular reference. The default is 50. So 50 times it added up the sum of C1 to C5, which includes the sum. It's a fun math problem to think about but thereality
GOOGLE SITES: EMBED A TWITTER FEED Embed Twitter Feed. In Google Sites, insert “Embed” by using the sidebar or double-clicking to view the insert wheel. Paste the code into the “Embed code” tab. MAKING A LOT OF COPIES OF THE SAME GOOGLE DOCS This is telling the script to make 30 copies. If you want a different number, change the 30. Each Google document (Docs, Sheets, Slides, Forms, Drawings) has a unique document ID. You need to open the document and copy the long string of number and letters out of the URL. In the script you will want to replace my document ID with yourdocument ID.
GOOGLE SPREADSHEETS: ABSOLUTE CELL REFERENCING Cell referencing is when you use a formula to refer to a cell. In a spreadsheet you start a formula with an equals sign (=) and then command the spreadsheet to complete a task. Example: typing =5+6 into a cell and pressing enter will calculate the value and return 11. GOOGLE CLASSROOM: MAKE A COPY FOR EACH STUDENT Here is the trick. Open up your original and use Control L to highlight the URL and Control C to copy. In Google Classroom, click on the 3 dots on the assignment in the stream to edit the assignment. Choose to attach a LINK. Use Control V to paste the link to yourdocument.
DELETE GOOGLE CLASSROOM CLASSES Click on Course ID. I do not want you to accidentally delete a class. If you delete a class you can not recover it. NOT. So be careful! You must single click on the Course ID that you want to delete. Then from the “List Classes” menu choose “DELETE class.”. You will be asked to confirm that you do indeed want to delete the class. COUNT UP CHECKBOXES IN GOOGLE SHEETS My favorite part of Google Sheets is inserting checkboxes! WICKED USEFUL FOR TEACHERS! My daughter is helping me with my YouTube thumbnails (check out her handiwork and subscribe to my channel 🙂 She is using a Google Sheets spreadsheet to keep track of how many thumbnails she creates for me, and I’m paying her.She made a list of checkboxes and each time she GOOGLE MEET: SEE YOURSELF Go to the upper right hand corner of Google Meet and find your video. Hover over your video to find 2 icons. Pin and Add yourself as a tile. The 4 squares icon lets you appear on the screen along with other video participants. Hover over yourself to find the 4 squares icon (but now with a line through it) to turn off yourself as a tile. Tags GOOGLE MEET: SEE YOUR PRESENTATION AND THE PARTICIPANTS Use the 2nd Tab. On the 2nd Tab you are not the presenter but rather just another participant. You can see the presentation AND the participants on that tab. No pinning of the presentation required. Tip: Mute your mic and turn off the camera on the GOOGLE DRAWING: CREATE A DROP SHADOW I think I have an addiction to creating drop shadows in Google Drawing (and Google Slides.) It just adds a little pop to all of my text. Notice the two images I created in Google Drawing. GOOGLE SHEETS: SPREADSHEET SETTINGS Notice in the screenshot below that my formula in C5 is =SUM (C1:C5) and the sum says 45. This is because when you turn on "Iterative calculation" it asks you how many times to do the circular reference. The default is 50. So 50 times it added up the sum of C1 to C5, which includes the sum. It's a fun math problem to think about but thereality
GOOGLE SITES: EMBED A TWITTER FEED Embed Twitter Feed. In Google Sites, insert “Embed” by using the sidebar or double-clicking to view the insert wheel. Paste the code into the “Embed code” tab. MAKING A LOT OF COPIES OF THE SAME GOOGLE DOCS This is telling the script to make 30 copies. If you want a different number, change the 30. Each Google document (Docs, Sheets, Slides, Forms, Drawings) has a unique document ID. You need to open the document and copy the long string of number and letters out of the URL. In the script you will want to replace my document ID with yourdocument ID.
GOOGLE SPREADSHEETS: ABSOLUTE CELL REFERENCING Cell referencing is when you use a formula to refer to a cell. In a spreadsheet you start a formula with an equals sign (=) and then command the spreadsheet to complete a task. Example: typing =5+6 into a cell and pressing enter will calculate the value and return 11. GOOGLE CLASSROOM: MAKE A COPY FOR EACH STUDENT Here is the trick. Open up your original and use Control L to highlight the URL and Control C to copy. In Google Classroom, click on the 3 dots on the assignment in the stream to edit the assignment. Choose to attach a LINK. Use Control V to paste the link to yourdocument.
DELETE GOOGLE CLASSROOM CLASSES Click on Course ID. I do not want you to accidentally delete a class. If you delete a class you can not recover it. NOT. So be careful! You must single click on the Course ID that you want to delete. Then from the “List Classes” menu choose “DELETE class.”. You will be asked to confirm that you do indeed want to delete the class. GOOGLE SHEETS: SPREADSHEET SETTINGS Notice in the screenshot below that my formula in C5 is =SUM (C1:C5) and the sum says 45. This is because when you turn on "Iterative calculation" it asks you how many times to do the circular reference. The default is 50. So 50 times it added up the sum of C1 to C5, which includes the sum. It's a fun math problem to think about but thereality
5 THINGS YOU MAY NOT KNOW ABOUT GOOGLE CLASSROOM 5 Hidden Elements of Google Classroom. As with any platform, there are things to understand that are not a button to click on. Knowing how Google Classroom works with Google Drive and how it interacts with students can help you to better use Classroom. MICROSOFT TEAMS: NEW CONVERSATION The “New conversation” button is cleverly added to the bottom of the Posts. New conversation posts go to the bottom, so instead of dragging your mouse all the way to the top, only to reply at the bottom. Microsoft Teams has intuitively designed the button for where the action is. The large purple button makes it very clear you are TOP 10 HEALTH AND PHYSICAL EDUCATION TECH TOOLS BY With that, here are my top ten tried, tested, and true HPE Tech Tools. Tech Tool. Uses in Health & Physical Education. Hardware. Google Forms. Google Forms have been a game changer because they are easy to work with and can be used in many ways! Data collected in a form is sent automatically to a Google Sheet for simple analysis. GOOGLE FORMS: SUBMITTING DRAWINGS Google Forms: Submitting Drawings. In Google Forms you may want to ask students a question that requires a visual answer. Google Forms limits student responses to text submissions. Google Drawings allow students to draw and model their learning, work collaboratively with images, create projects and provide evidence of their work. GOOGLE SHEETS: TEXT AND NUMBERS IN ONE CELL When writing a formula in a spreadsheet you always start with the equals sign. Any text strings must be in quotation marks. Notice the space after the s in points. You will end up with points1000 instead of points 1000 if you forget to include the space. In the formula, you are joining the word points with the formula, sum (D2:D). GOOGLE SPREADSHEETS: ABSOLUTE CELL REFERENCING Cell referencing is when you use a formula to refer to a cell. In a spreadsheet you start a formula with an equals sign (=) and then command the spreadsheet to complete a task. Example: typing =5+6 into a cell and pressing enter will calculate the value and return 11. MAKING A LOT OF COPIES OF THE SAME GOOGLE DOCS This is telling the script to make 30 copies. If you want a different number, change the 30. Each Google document (Docs, Sheets, Slides, Forms, Drawings) has a unique document ID. You need to open the document and copy the long string of number and letters out of the URL. In the script you will want to replace my document ID with yourdocument ID.
GOOGLE DRIVE: ALWAYS CONVERT OFFICE DOCUMENTS Convert. In the settings click on the check box to “Convert uploaded files to Google Docs editor format.”. This will cause all of your Office uploads to automatically convert to Google Docs. If you do not want this to happen you will need to go back to the settings cog and uncheck the checkbox before you upload a file. 5 STEPS TO SHARING A COPY OF A GOOGLE FORM 1. Create a folder in Google Drive. Anything in a folder takes on the sharing permissions of the folder. To set your Form as anyone with the link can view you need to do this at the folder level. Create a new folder in Google Drive or utilize an existing folder in Google Drive.2.
COUNT UP CHECKBOXES IN GOOGLE SHEETS My favorite part of Google Sheets is inserting checkboxes! WICKED USEFUL FOR TEACHERS! My daughter is helping me with my YouTube thumbnails (check out her handiwork and subscribe to my channel 🙂 She is using a Google Sheets spreadsheet to keep track of how many thumbnails she creates for me, and I’m paying her.She made a list of checkboxes and each time she GOOGLE MEET: SEE YOURSELF Go to the upper right hand corner of Google Meet and find your video. Hover over your video to find 2 icons. Pin and Add yourself as a tile. The 4 squares icon lets you appear on the screen along with other video participants. Hover over yourself to find the 4 squares icon (but now with a line through it) to turn off yourself as a tile. Tags GOOGLE MEET: SEE YOUR PRESENTATION AND THE PARTICIPANTS Use the 2nd Tab. On the 2nd Tab you are not the presenter but rather just another participant. You can see the presentation AND the participants on that tab. No pinning of the presentation required. Tip: Mute your mic and turn off the camera on the GOOGLE DRAWING: CREATE A DROP SHADOW I think I have an addiction to creating drop shadows in Google Drawing (and Google Slides.) It just adds a little pop to all of my text. Notice the two images I created in Google Drawing. GOOGLE SHEETS: SPREADSHEET SETTINGS Notice in the screenshot below that my formula in C5 is =SUM (C1:C5) and the sum says 45. This is because when you turn on "Iterative calculation" it asks you how many times to do the circular reference. The default is 50. So 50 times it added up the sum of C1 to C5, which includes the sum. It's a fun math problem to think about but thereality
GOOGLE SITES: EMBED A TWITTER FEED Embed Twitter Feed. In Google Sites, insert “Embed” by using the sidebar or double-clicking to view the insert wheel. Paste the code into the “Embed code” tab. MAKING A LOT OF COPIES OF THE SAME GOOGLE DOCS This is telling the script to make 30 copies. If you want a different number, change the 30. Each Google document (Docs, Sheets, Slides, Forms, Drawings) has a unique document ID. You need to open the document and copy the long string of number and letters out of the URL. In the script you will want to replace my document ID with yourdocument ID.
GOOGLE SPREADSHEETS: ABSOLUTE CELL REFERENCING Cell referencing is when you use a formula to refer to a cell. In a spreadsheet you start a formula with an equals sign (=) and then command the spreadsheet to complete a task. Example: typing =5+6 into a cell and pressing enter will calculate the value and return 11. GOOGLE CLASSROOM: MAKE A COPY FOR EACH STUDENT Here is the trick. Open up your original and use Control L to highlight the URL and Control C to copy. In Google Classroom, click on the 3 dots on the assignment in the stream to edit the assignment. Choose to attach a LINK. Use Control V to paste the link to yourdocument.
DELETE GOOGLE CLASSROOM CLASSES Click on Course ID. I do not want you to accidentally delete a class. If you delete a class you can not recover it. NOT. So be careful! You must single click on the Course ID that you want to delete. Then from the “List Classes” menu choose “DELETE class.”. You will be asked to confirm that you do indeed want to delete the class. COUNT UP CHECKBOXES IN GOOGLE SHEETS My favorite part of Google Sheets is inserting checkboxes! WICKED USEFUL FOR TEACHERS! My daughter is helping me with my YouTube thumbnails (check out her handiwork and subscribe to my channel 🙂 She is using a Google Sheets spreadsheet to keep track of how many thumbnails she creates for me, and I’m paying her.She made a list of checkboxes and each time she GOOGLE MEET: SEE YOURSELF Go to the upper right hand corner of Google Meet and find your video. Hover over your video to find 2 icons. Pin and Add yourself as a tile. The 4 squares icon lets you appear on the screen along with other video participants. Hover over yourself to find the 4 squares icon (but now with a line through it) to turn off yourself as a tile. Tags GOOGLE MEET: SEE YOUR PRESENTATION AND THE PARTICIPANTS Use the 2nd Tab. On the 2nd Tab you are not the presenter but rather just another participant. You can see the presentation AND the participants on that tab. No pinning of the presentation required. Tip: Mute your mic and turn off the camera on the GOOGLE DRAWING: CREATE A DROP SHADOW I think I have an addiction to creating drop shadows in Google Drawing (and Google Slides.) It just adds a little pop to all of my text. Notice the two images I created in Google Drawing. GOOGLE SHEETS: SPREADSHEET SETTINGS Notice in the screenshot below that my formula in C5 is =SUM (C1:C5) and the sum says 45. This is because when you turn on "Iterative calculation" it asks you how many times to do the circular reference. The default is 50. So 50 times it added up the sum of C1 to C5, which includes the sum. It's a fun math problem to think about but thereality
GOOGLE SITES: EMBED A TWITTER FEED Embed Twitter Feed. In Google Sites, insert “Embed” by using the sidebar or double-clicking to view the insert wheel. Paste the code into the “Embed code” tab. MAKING A LOT OF COPIES OF THE SAME GOOGLE DOCS This is telling the script to make 30 copies. If you want a different number, change the 30. Each Google document (Docs, Sheets, Slides, Forms, Drawings) has a unique document ID. You need to open the document and copy the long string of number and letters out of the URL. In the script you will want to replace my document ID with yourdocument ID.
GOOGLE SPREADSHEETS: ABSOLUTE CELL REFERENCING Cell referencing is when you use a formula to refer to a cell. In a spreadsheet you start a formula with an equals sign (=) and then command the spreadsheet to complete a task. Example: typing =5+6 into a cell and pressing enter will calculate the value and return 11. GOOGLE CLASSROOM: MAKE A COPY FOR EACH STUDENT Here is the trick. Open up your original and use Control L to highlight the URL and Control C to copy. In Google Classroom, click on the 3 dots on the assignment in the stream to edit the assignment. Choose to attach a LINK. Use Control V to paste the link to yourdocument.
DELETE GOOGLE CLASSROOM CLASSES Click on Course ID. I do not want you to accidentally delete a class. If you delete a class you can not recover it. NOT. So be careful! You must single click on the Course ID that you want to delete. Then from the “List Classes” menu choose “DELETE class.”. You will be asked to confirm that you do indeed want to delete the class. GOOGLE SHEETS: SPREADSHEET SETTINGS Notice in the screenshot below that my formula in C5 is =SUM (C1:C5) and the sum says 45. This is because when you turn on "Iterative calculation" it asks you how many times to do the circular reference. The default is 50. So 50 times it added up the sum of C1 to C5, which includes the sum. It's a fun math problem to think about but thereality
5 THINGS YOU MAY NOT KNOW ABOUT GOOGLE CLASSROOM 5 Hidden Elements of Google Classroom. As with any platform, there are things to understand that are not a button to click on. Knowing how Google Classroom works with Google Drive and how it interacts with students can help you to better use Classroom. MICROSOFT TEAMS: NEW CONVERSATION The “New conversation” button is cleverly added to the bottom of the Posts. New conversation posts go to the bottom, so instead of dragging your mouse all the way to the top, only to reply at the bottom. Microsoft Teams has intuitively designed the button for where the action is. The large purple button makes it very clear you are TOP 10 HEALTH AND PHYSICAL EDUCATION TECH TOOLS BY With that, here are my top ten tried, tested, and true HPE Tech Tools. Tech Tool. Uses in Health & Physical Education. Hardware. Google Forms. Google Forms have been a game changer because they are easy to work with and can be used in many ways! Data collected in a form is sent automatically to a Google Sheet for simple analysis. GOOGLE FORMS: SUBMITTING DRAWINGS Google Forms: Submitting Drawings. In Google Forms you may want to ask students a question that requires a visual answer. Google Forms limits student responses to text submissions. Google Drawings allow students to draw and model their learning, work collaboratively with images, create projects and provide evidence of their work. GOOGLE SHEETS: TEXT AND NUMBERS IN ONE CELL When writing a formula in a spreadsheet you always start with the equals sign. Any text strings must be in quotation marks. Notice the space after the s in points. You will end up with points1000 instead of points 1000 if you forget to include the space. In the formula, you are joining the word points with the formula, sum (D2:D). GOOGLE SPREADSHEETS: ABSOLUTE CELL REFERENCING Cell referencing is when you use a formula to refer to a cell. In a spreadsheet you start a formula with an equals sign (=) and then command the spreadsheet to complete a task. Example: typing =5+6 into a cell and pressing enter will calculate the value and return 11. MAKING A LOT OF COPIES OF THE SAME GOOGLE DOCS This is telling the script to make 30 copies. If you want a different number, change the 30. Each Google document (Docs, Sheets, Slides, Forms, Drawings) has a unique document ID. You need to open the document and copy the long string of number and letters out of the URL. In the script you will want to replace my document ID with yourdocument ID.
GOOGLE DRIVE: ALWAYS CONVERT OFFICE DOCUMENTS Convert. In the settings click on the check box to “Convert uploaded files to Google Docs editor format.”. This will cause all of your Office uploads to automatically convert to Google Docs. If you do not want this to happen you will need to go back to the settings cog and uncheck the checkbox before you upload a file. 5 STEPS TO SHARING A COPY OF A GOOGLE FORM 1. Create a folder in Google Drive. Anything in a folder takes on the sharing permissions of the folder. To set your Form as anyone with the link can view you need to do this at the folder level. Create a new folder in Google Drive or utilize an existing folder in Google Drive.2.
* Home
* Hire Me
* All Posts
* Templates
* Add-Ons
* Templates
* Apps Script Tutorials* Books
* Google Classroom
* Microsoft
* Courses
* YouTube Channel
Select Page
* Home
* Hire Me
* All Posts
* Templates
* Add-Ons
* Templates
* Apps Script Tutorials* Books
* Google Classroom
* Microsoft
* Courses
* YouTube Channel
ALICE KEELER
PAPERLESS IS NOT A PEDAGOGYHire Me
ALICE KEELER BOOKS
PAPERLESS IS NOT A PEDAGOGYBUY NOW
12
BADGE GAME – REMOTE LEARNING CHALLENGE BOARDApr 27, 2020
Choice is very motivating. Try using my gamification template to create a Google Sheets choice board. Make a copy for each student so they can check off their choices and level up. Template Use alicekeeler.com/badgegame to make a copy of the template. Note, I have formulas all over the spreadsheet, be careful not to delete them or the board breaks. Use Version history under the File menu if you accidentally delete some formulas to restore the spreadsheet back to how it was. alicekeeler.com/badgegame Example: Try out the badge game at alicekeeler.com/searchdrive for a challenge game about...read more
RECENT BLOG POSTS
GOOGLE SEARCH BY DATE RANGEApr 26, 2020
...
read more
USE THE SAME GOOGLE FORM TO POLLApr 25, 2020
...
read more
MICROSOFTEDU WEBINARS WITH ALICE KEELERApr 23, 2020
...
read more
FIND GOOGLE FORM RESPONSES IN GOOGLE CLASSROOMApr 21, 2020
...
read more
USING MEET IN GOOGLE CLASSROOM BY @MARKLOUNDYApr 20, 2020
...
read more
GOOGLE: SOLVE THE SOURCE OF ALL YOUR PROBLEMS – USE CHROME LOGINSApr 20, 2020
...
read more
THE WOES OF CO-TEACHING EMAIL NOTIFICATIONS IN GOOGLE CLASSROOMApr 19, 2020
...
read more
GOOGLE SLIDES: SHARE TEMPLATESApr 17, 2020
...
read more
SHARING RUBRICS IN GOOGLE CLASSROOM OR MICROSOFT TEAMSApr 16, 2020
...
read more
SELF GRADING – GOOGLE FORMApr 15, 2020
...
read more
CODE BREAK WEDNESDAYS 10AMApr 13, 2020
...
read more
SECURELY SHARE VIDEOS WITH MICROSOFT STREAMApr 13, 2020
...
read more
GOOGLE CLASSROOM: SORT ATTACHMENTS BY STATUSApr 11, 2020
...
read more
VIDEO MEETING: GET OUT OF FULL SCREENApr 10, 2020
...
read more
NOW: MEET IN GOOGLE CLASSROOMApr 10, 2020
...
read more
LIVE SESSION STUDENT WHITEBOARDS: WHITEBOARD.FIApr 9, 2020
...
read more
FREE VOICE TYPING IN GOOGLE SLIDESApr 8, 2020
...
read more
90 MINUTES REMOTE LEARNING MAX A DAYApr 8, 2020
...
read more
GOOGLE CLASSROOM IS NOT ASSIGNING TO ALL STUDENTSApr 7, 2020
...
read more
NEW IN TEAMS – ATTACHMENTS ARE VIEW BY DEFAULTApr 6, 2020
...
read more
AUTOMAGICALLY PDF WORKSHEET TO GOOGLE FORMApr 6, 2020
...
read more
GOOGLE CLASSROOM: REUSE MULTIPLE ASSIGNMENTS AT ONCEApr 5, 2020
...
read more
REMOTELY: PUSH SLIDES TO STUDENTS SLIDESApr 5, 2020
...
read more
MATH: REMOTE LEARNING WITH YOUCUBED WIMApr 4, 2020
...
read more
View All Posts
Alice Keeler is a mom, teacher, author, Google Certified Innovator, keynote speaker, and workshop presenter* Follow
* Follow
* Follow
* Follow
ALICE KEELER
FOLLOW @ALICEKEELER
ALICEKEELER NEWSLETTER CLICK HERE TO SUBSCRIBE SEARCH ALICEKEELER.COMSearch for:
FREE TOUR OF GOOGLE CLASSROOMCOFFEEEDU
Host a CoffeeEDU they are fun and easy! coffeeEDU.orgCATEGORIES
Categories Select Category 365 (17) 3D Printing (7) Ability (6) Activity (6) Admin (2) Adobe (1) Advanced (277) Android (5) Android Apps (4) Apple (20) Apps Script (116) Beginner (102) Bing in the Classroom (6) Blog Entries (229) Book Review (1) Calendar (13) Cardboard (2) Chrome (91) Chrome Apps (37) Chromebook (22) Chrometab (1) Classroom (311) Coding (8) Collaboration (9) Common Core (3) Corippo (5) Digital Citizenship (9) Distance Learning (6) Docs (201) DOK (8) Draw (67) Drive (130) EdTech Tool (15) Excel (3) Excel Survey (1) Expeditions (1) Food (2) Forms (142) Gamification (57) GarageBand (3) Giveaway (1) Gmail (28) Google (1,439) Grading (40) Guest Post (26) Hangout (8) Homework (8) Illuminate Ed (1) iMovie (1) Inspire (3) Intermediate (320) iPad (16) iWork (2) Jamboard (1) Keep (12) Keyboard Shortcuts (83) Keynote (4) LEC (1) Lesson Design (74) MAC (41) Maps (1) Math (66) Meet (2) Microsoft (47) Minecraft (2) Minecraft (6) National Geographic (1) OneDrive (5) OneNote (4) Online (4) Open Source (2) Outlook (1) pedagogy (17) Pico Projector (1) Plus (7) PowerPoint (2) Programming (2) Promethean (5) Resources (7) Robotics (1) Scholar (1) Schoology (1) Search (9) Sheets (302) Sites (38) SkyDrive (4) Slides (173) Social Media (1) Spark (1) Stream (1) Student Projects (11) Surface (3) Surface (1) Tablet (9) Teachers Are Professionals (1) Teaching with iPad (8) Teams (6) TechSmith (2) templates (51) Tips (13) Tour Creator (1) Tricks (42) Twitter (53) Uncategorized (14) Video (9) Voice (6) Web 2.0 (27) Word (1) YouTube (19) GOOGLE CLASSROOM BOOKS FIND ALL MY BLOG POSTSLink to List
@ALICEKEELER
*
Differentiate when #remotelearningAssigning to SOME
Students https://t.co/hJctRLQMiT https://t.co/gaAYM0avW8 4 hours ago*
One way to improve learning is to give feedback BEFORE a student is done. Using Google Apps makes that possible. As… https://t.co/moAictboU2 3 hours ago*
Find Google Form Responses in Google Classroom - https://t.co/3P8J0vw4dU https://t.co/6vOlSD8gPx 3 hours ago*
Create a nickname for your GoogleEDU Meet #GoogleEDU https://t.co/NNF3KeCJ4E 3hours ago
*
@MarciaMentor @The_Tech_Lady Thanks my friend 2 hours agoView more tweets
MY REFERRAL LINKS
Website Host: FlyWheel share.getf.ly/l74v5x Copyright secured by Digiprove © 2018SHARE THIS:
* Pinterest35
*
LIKE THIS:
Like Loading...
Alice Keeler. Design by Christine Powell WP Twitter Auto Publish Powered By : XYZScripts.com %d bloggers like this: Send to Email Address Your Name Your Email Address Cancel Post was not sent - check your email addresses! Email check failed, please try again Sorry, your blog cannot share posts by email. SUBSCRIBE TO THE ALICE KEELER NEWSLETTER ALICEKEELER.COM/NEWSLETTER Want to sponsor the newsletter? Click here×
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0