# data[].attributes.body
Today I explored Jamboard.  I have never used this app and want to see what it could be used for.   It is a way that people can collaborate on a project.   You can add pictures, drawings, pdfs,  and it look like anything from your google drive.  This look like a great way for students to brainstorm ideas.   I am going to explore this app as an interactive way to do bell work.

- Amanda Becker

# data[].attributes.body
I like using Google Sheets but always had limited knowledge on all that it offered.
After watching the videos I have found multiple resources that I will be using.
The freeze view will be helpful with viewing sheets with multiple columns of data.
-Caitlyn Group

# data[].attributes.body
I really wanted to expand my knowledge with using google sites as I have very limited experience with this particular app. I particularly enjoyed the tutorials on creating favicons which will help me more organized while using particular sites and resources for health class.

I also enjoyed the learning how to better create a student page with sites. I have tried to use this before a few years ago and struggled with helping my students while they completed a particular assignment while creating a page. I am definitely more confident in navigating and helping them after watching the tutorial.

I reviewed the version history tutorial as well. Although I was familiar with this feature on google I was unaware it was available for google sites and other apps (other than docs & slides). It is nice to know you can track when and how much students work on particular assignments while completing them on a google app. All very beneficial!
-Nate Parry

# data[].attributes.body
I learned the basics of google forms during virtual learning but today's session allowed me to learn and explore more.  I use the quiz the most.  It is a great tool with a lot of flexibility to fit your needs.
Julie Cox

# data[].attributes.body
Flocabulary would be a fun and engaging way to present content and related vocabulary to students.  It would be useful when teaching topics such as text features, fables, and fairy tales, just to name a few.  I like that there are options for various grade levels, and students will love the combination of songs and information.  I mean, who doesn't remember things better in song?! Hence why we remember song lyrics from forever ago so easily.  This resource will be a lot of fun to use.
- Jewel Ames

# data[].attributes.body
I have never used Google Classroom before so the "2020 How To Use Google Classroom" was a great start to get my classes created and something that I will refer back to throughout the school year as I utilize it.

What I like most about the video is that the verbal directions and explanations could be followed as I set my classrooms up in another tab when I was not directly viewing the video.

-Emily Lafferty

# data[].attributes.body
The tutorial on the google classroom was very beneficial. I often times can eventually figure things out, but watching the tutorial provided some clarity and confidence for future use. Also, the google forms tutorial was beneficial. It can be daunting at times trying to get it just how you want it. The presentation again cleared some things up. Looking forward to applying what I learned.
DB

# data[].attributes.headline
Google Slides - Drag and Drop Activities

# data[].attributes.subject
Google Slides - Drag and Drop Activities

# data[].attributes.body
I have been using google slides for quite sometime, but today I learned how to make them more interactive for my students with the drag and drop activities. I thought I knew how to do this, but when I discovered how to make a background template that can't be moved - that was a gamechanger!  I can see so many learning possiblities for my English classes with this digital activity.  I plan on using this at the beginning of the year as a pre-assessment tool on literary terms.  I am going to give them examples and students will have to "drag and drop" the literary term that matches the example.

Stacy North

# data[].attributes.body
I worked with Google Jamboard as it is an app I don't often use within the classroom.  Watching the videos and taking the time to explore the app helped me to brainstorm a few ways I can utilize the app for student collaboration.  This could be a great resource for STEM/STEAM projects as collaboration is so frequently utilized.  Students would be free to brainstorm without a classroom time limitation since their work is uploaded to their drive.
-E. Bucha

# data[].attributes.attachment_link.description
The version of the browser you are using is no longer supported. Please upgrade to a supported browser. Dismiss

# data[].attributes.body
I enjoyed learning about the Book Creator App. The App enables you to create and design your own book. You can add photos using import, can change sizes of images, choose various pens, and change the backgrounds to meet the theme of your book. I can see my students using Book Creator to create their own book about a famous artist of their choice.
-Brenda Umshares

# data[].attributes.body
I learned a lot about Google Jamboard today!  I love that you can have multiple frames (with the same content) so groups can collaborate, but not have a whole class working on the same frame.  This allows for great collaboration opportunities without students feeling overwhelmed by to many people working on the same frame.  In music I could use this to evaluate how well students can identify note names & rhythms by providing a staff background and having them put the notes in the correct places.
~Megan Lonich

# data[].attributes.body
I watched a video about Google Classroom.  I've never been particularly tech-savvy, but I do use Classroom with all of my courses.

I benefitted by watching this tutorial because it showed me some of the options I hadn't used in the past. I'm also impressed with some of the updates that have been added over the last few years.

The originality report can be really helpful!

-Marc DiSilvio

# data[].attributes.body
Very helpful for use with Timed Google Slide presentations in Public Speaking. Will be valuable for those that want to add their own audio for favorite bands or artists, play-by-play from games of their favorite sports teams, etc.  Also useful for single slide visual aids in various speeches. We have been wanting to do this for years, but we did now know how.   Know we know!

--Steve Shilling

# data[].attributes.body
While some of the functionality is similar to what I used in years past with Excel, Google Sheets handles commands and presents menu options differently. Exploring the tutorials was straightforward, and having them as future reference will be helpful.

From a student perspective, MS students will be able to use these skills in support of the financial skills unit and Stock Market Game competition.   Combining the resources of Yahoo Finance with Google Sheets might also engage the students.

--Lori Walters

# data[].attributes.attachment_link.readable_text
One of the lesser-known functions in Google Sheets is GOOGLEFINANCE, which allows you to track current or historical financial securities data on the stock market. Here's how to use it.

What Is Google Finance?

Finance is Google's real-time tool that displays current market information and aggregates business news. It's currently integrated with Google Search, so if you look up the ticker symbol of a specific corporation on Google such as WMT for Walmart or AAPL for Apple, you will immediately see the current stock quote and historical data for that security. You can click one of these stocks to go to a company's Google Finance page, which shows the company's financials, related news, and allows you to compare it with other commodities.

While there are other, more robust tools you can use to track securities, Google Finance is the only one that can effectively integrate with Google Sheets. Whether you're a novice to stocks or an experienced trader, this integration is the easiest way to import and monitor stock data in a spreadsheet.

By the way, Google Finance's sheets integration is only available in English and doesn't include most international exchanges yet. So if you want to transact on Asian or European exchanges, this may not be the best option for you.

The Google Finance Function

The function that pulls stock data is called "GOOGLEFINANCE." The syntax of the function is quite simple and uses five arguments, four of which are optional.

The first argument is the ticker symbol. These are codes that companies have when they're listed on the stock market, such as GOOG for Google or BAC for Bank of America. You can also specify the stock exchange that your chosen stock is listed in to avoid discrepancies. Since Bank of America is listed on the New York Stock Exchange, you'd type "NYSE:BAC."

To get the ticker codes and exchanges of your desired stocks, you'll have to do some research. You can look for them on Google Finance or your chosen portfolio management tool.

The second argument is the attribute you'd like to display. By default, it's set to "price" if you leave it blank. Here are a few of the attributes you can pull out using the function:

price: The price of the specific stock in real-time.

volume: The current trading volume.

high: The current or chosen day's high price.

low: The current or chosen day's low price.

volumeavg: The average trading daily trading volume.

pe: The price to earnings ratio.

eps: The earnings per share.

Take note that the attributes you can display vary on whether you're using current or historical data. Here's a full list of attributes that you can use for the argument. It's important to remember that current data refreshes every 15 minutes, so it's not completely real-time.

The third argument is the start date, which only applies if you're using historical data. You can type "TODAY()" or leave it blank to display real-time data. The fourth argument specifies either the end date or the number of days from the start date. If left blank, the function will return the data from a single day.

The last argument is the interval, which allows you to specify the frequency of the data. You can set it to "DAILY" or "WEEKLY."

One thing to note is that Google Sheets processes the ticker symbol and attribute arguments as text, so make sure to place quotation marks around them, or you will get an error.

Stock Tracking in Action

For this example, let's say you want to look up the current price of a stock of Facebook. Facebook is listed on NASDAQ with the ticker code FB. In this case, you'll type down the first argument as "NASDAQ:FB" along with "price" as the attribute. So the formula for this would be =GOOGLEFINANCE("NASDAQ:FB","price").

If you want to view the daily closing prices for a particular week, such as the week of October 15, 2018, you will specify that date range in the third and fourth arguments. The code for that becomes =GOOGLEFINANCE("NASDAQ:FB","price",DATE(2018,10,15),DATE(2018,10,20)) . Take note that viewing historical data expands the generated information into array data, which takes up nearby cells.

You can also use the function to generate data for a list of stocks automatically. Just type out the tickers in a column, then use the cells in your first argument. Since our ticker code is in cell C4, you'd type out =GOOGLEFINANCE(C4,"price"). Below is a list of stocks with their corresponding current prices.

If you want to track a list of attributes, you can type them out in separate cells like in the above image. Then, you can link the second argument to the cell with the attribute's name. For the price cell for NYSE:IBM in the example below, the formula would be =GOOGLEFINANCE(C$2,$B5).

Maximizing Google Sheets

The best part of having your stocks on Google Sheets is that you can use various data manipulation tools on them.

For example, let's say you want to use Google Sheets to keep track of the value of all of your financial assets, such as your stocks, savings accounts, time deposits, and more. Using Finance, the price of your stocks will update in real-time, so you get a full picture of your position at any given time.

Converting Currency with Sheets

Another great function of Google Sheets is that it can convert currencies in real-time. You can do this by typing the stock ticker "CURRENCY:" followed by the codes of the two currencies you want to convert, such as "USDGBP" or "EURJPY." You can also display historical currency data by specifying a date.

For example, if you're living in Europe and you want to convert some USD into the Euro, you'd type =GOOGLEFINANCE("CURRENCY:USDEUR") and multiply that number with the amount of USD you're converting.

This has a lot of great use-cases besides foreign exchange trading. For example, if your line of work involves getting paid in a different currency, you can set up an invoice that automatically converts the payments you receive to your home currency.

Vann Vicente has been a technology writer for four years, with a focus on explainers geared towards average consumers. He also works as a digital marketer for a regional e-commerce website. He's invested in internet culture, social media, and how people interact with the web. Vann Vicente
Read Full Bio "

# data[].attributes.attachment_link.description
One of the lesser-known functions in Google Sheets is GOOGLEFINANCE, which allows you to track current or historical financial securities data on the stock market. Here's how to use it. Finance is Google's real-time tool that displays current market information and aggregates business news.

# data[].attributes.body
I really like (and typically rarely use) Google's Jamboard program.  I like that the whole class can collaborate in real time and that it's documented easily for us to refer back to.  This would be a great program for retelling stories in student's own words or possibly share research findings.   It can (as seen above) just be a great tool for brainstorming!  The image depicts some ideas one of our classes exchanged a couple of years back about Spanish business ideas!

-Lisa Bouman

# data[].attributes.body
I have really only used the basic functions of Google Sheets and Excel. Finding out that there is a translate code was really interesting for me as a language teacher! Though my students aren't allowed to use translators to complete their assignments, they could use this tool to translate vocabulary lists quickly and neatly either English to Spanish or Spanish to English. I could also use this to create digital activities and assignments.
-Megan Pendleton

# data[].attributes.body
I am glad that I had this opportunity to practice the various tools in Google Draw! This is very useful for making presentations, handouts, etc. for students more appealing. There are so many ways to do so through using color, backgrounds, videos, icons, shapes, etc. I especially love the style tips!
Kathleen Bruce

# data[].attributes.body
Book Creator! Who knew such an app was even out there?! An app that you can create your own book for free! I am excited to utilize this app in my classroom. At first I was thinking you could do the same thing in GoogleSlides, however, this app definitely offers more flexibility and personalization options. You can also add a book and have students read/edit it (not exactly sure how to do that yet though). I can see students using this platform to create their own recipe books, class portfolios, or even a personalized vocabulary, study book. This would also be a wonderful tool to use as an early finisher idea.

Nearpod! I am excited for the possibilities that nearpod has to offer. I think this app could be extremely useful in remote learning situations but could also be a fun new way to present content.

# data[].attributes.body
In my classes I utilize current events and news articles related to various areas of agriculture.  I also use this as an emergency sub plan.  Using Newsela allows you to select articles, assign them to students, and create a quiz for the article as well as other features.

I explored a little further from the list of links for this app and you can even make units with multiple articles and videos that you would like students to complete all in one place.

I think this is a great tool for teachers that like to use current events and news articles in their classes.

- Renee Cambruzzi

# data[].attributes.body
I watched the videos on google forms app since it is something I use on a regular basis. I use them for safety so that I have documentation. I also use it often for review quizzes and checking prior knowledge. The videos helped me confirm that I was using them correctly. I did learn how to lockout a quiz as well as how to shuffle the questions. The videos will be a nice resource for if I forget how to do something or come to a point where there is something I am trying to do and know not know how to do it. I also wish that we had the app that you could use to convert previous quizzes or tests from google docs and easily transfer them into a quiz instead of typing it all out again.
Overall, I think that forms is one of the most useful tools to use in google and really helps me keep track of students prior knowledge checks, quizzes, and tests.

- John Leasure

# data[].attributes.body
I watched the videos on the Google Form app since it is something I use often in my class. One of the main things I use it for is safety quizzes for shop equipment. It helps me to be able to have documentation of the student completing it and helps from me personally having to check hundreds of safety quizzes the first few weeks.
The videos definitely helped me to be able to customize the Google Forms more and be more user friendly for the students. These videos will definitely be a helpful resource for me to refer back to when I need a little help with Google Forms.
Overall, I think Google Forms is a super helpful tool for teachers that are looking to give digital quizzes or tests. It especially has helped me with being able to reduce my workload of checking safety quizzes and keeping documentation of students completing them. - Andrew Valentine

# data[].attributes.body
Edpuzzle is a site that teachers can use to create, assign and grade video assignments.  The site gives you the option of creating a free account or a paid subscription.  The only difference seems to be that the free account limits the number of assignments that a teacher can save.

On Edpuzzle you can either choose a prebuilt assignment from the extensive library or you can create your own new assignment.  (You may also choose to start with a prebuilt assignment and make your own modifications.)  Designing an assignment is very simple.  You begin by choosing a YouTube video.  If you do not want to use the full video, it is very simple to trim the clip down to what you want.  After trimming the clip, you can add a variety of questions to the video.  Each question can be placed wherever you would like it to appear in the video.  Once an assignment is built, it can be easily assigned to students through Google Classroom.  When the assignment is over, it will be automatically be graded.

Personally I feel that Edpuzzle assignments would be good for keeping absent student's from falling behind.

Greg Reger

# data[].attributes.attachment_link.description
Easily create beautiful interactive video lessons for your students you can integrate right into your LMS. Track students' progress with hassle-free analytics as you flip your classroom!

# data[].attributes.body
I have used Google Slides a lot in the classroom.  I never knew that you could add in closed captioning to each slide.  This tool really sparked my interest for many reasons.

Reason 1: This could be a key factor if I have my students complete a Google Slides activity indpendently.  I could include my directions on each slide that could be read out loud.

Reason 2: I could include the closed captioning so that students can go back and hear my lecture for a second time if they need to review the topic discussed in class.

Reason 3: Some students are visual learners and will remember more if they are reading as I am speaking the words.

-Lindsay Conty

# data[].attributes.body
I am usually hesitant to use Google Sheets to display data as it can be complicated. The tutorials made it much more accessible and less daunting. One feature that I know I will use right now is the Data Validation option. It will allow me to make drop down options which make it convenient to fill out charts. These tutorials are a great resource. -Andrea Serra

# data[].attributes.body
I had never really used Sheets (or excel) so I wanted to learn more about what they offered.

Format Conditional- go to conditional format and click numbers less than put in the number below failing.  It will automatically highlight students that failed.  The Social Studies Department can use this when looking over Act 35 Civics Test data.

Data and Data Validation- List of items and type in items (example states) hit save.  Pick data from the drop-down list.

Click hit Explore and Pivot Table will appear will help sort items. This would be helpful when I sell t-shirts for Ski Club.

Freeze is under View- can freeze rows or columns

Kristin Anderson

# data[].attributes.body
I have never been one to fully utilize Google Sheets because I feel it takes a mathematical brain to understand them...and that's definitely not me!

I am grateful for having the tutorials so that I can take advantage of Google Sheets and be able to organize my data more effectively and be able to share it with others quickly.

I appreciated the "Functions" and "Freeze Rows and Columns" tutorials AND I'm happy that I can go back and review the videos because I need constant reminders of how to do things.
-Kelly Painter

# data[].attributes.body
The feature of adding audio into Google Slides is very beneficial. I currently have 2 students with visual impairments. You could add audio with guided instruction. This would benefit students who also struggle to read. I would use this feature for promote independent work and remote learning.
Megan Tilger

# data[].attributes.body
Google Classroom allows teachers to set assignment and student submitted work. It helps eliminate paper. It is a great tool for in-class and remote assignments.