Using Google Trends

Using Google Trends

By Nick Manning

Google Trends is a site that shows what stories and topics are trending on Google, this site allows for people to look at a specific topics search rate and compare it to other searches. It also allows the user to look at search trends in different parts of the world.

screenshot-2016-12-13-at-10-05-55-am

Comparing Search Terms

When you open Google Trends, There is a search bar at the top of the page and allows the user to search the search rate of specific words or phrases.

When you do so it takes you to a page with options to change what region the trends show up from, the time frame for which the search rate shows up, the categories on which they searched, and what google app they used to search it on (Google Search, Images, YouTube, etc).

ezgif.com-video-to-gif (11).gif

Below that is a chart which the search rate is displayed based on your selections above. Below the chart there is a global map showing the regions which your term or phrase is most searched in.

Below that shows the related topics and queries to the term or phrase you searched. At the top of the page you will see the term you searched at the left and to the right it gives you the option to compare the search rate of another term with the first term you searched. And you can do this more than just once.

Google Trends on other Google Apps

On the Main page of Google Trends, at the top left you can see the lines, if you click on that it’ll open a sidebar and gives you the options to, Explore, look at the trending searches, look at what is trending on YouTube, look at the top charts, and to check on your subscriptions (subscriptions being topics and stories you want updated on).

ezgif.com-video-to-gif (12).gif

Bio – Nick Manning

20160830_102530Nick (@ManningHelpDesk) is a Junior at Ash Grove High School and a student in the ASSIST help desk. He is brother to Lindsay Buckley, (@Lbuckley08) the Librarian at the Ash Grove School District in southwest Missouri. His dream is to attend college for computer science and make innovations in the computer and technology industry. His Google Apps Jam is working with Google Forms and creating polls and tests.

 

Google Spreadsheets (Sheets) Tips – Paul Chavez

Google is an easy, efficient way to store, organize, and analyze your data. Sheets is a tool that can be used very effectively when used properly. These tools will help you navigate your way through Sheets and will help you save time.

Inserting a Comment

There are three main ways to insert a comment into Google Spreadsheet.

1.  Select the cells that you wish to leave a comment on. Click on the “Insert” tab in the upper left corner. Once the drop down menu opens on the “Insert” tab, select the option labeled “Comment.” Proceed to enter your comment into the box that appears and left click “Comment” for it to be submitted. An alternate way to submit your comment is by pressing on your keyboard ctrl + enter.   insert-tab-1

2.  Select the cells that you wish to leave a comment on. Right click inside the cells selected and click “Insert Comment.” Proceed to insert your comment and click “Comment” for it to be submitted. An alternate way to submit your comment is by pressing on your keyboard ctrl + enter.Screenshot 2016-10-06 at 10.26.36 AM.png

3.Select the cells that you wish to leave a comment on. On your keyboard press Ctrl + Alt + M to insert a comment. Proceed to enter your comment into the box that appears and left click “Comment” for it to be submitted. An alternate way to submit your comment is by pressing on your keyboard ctrl + enter.

 

Using Borders

borders

To insert a border on your spreadsheet, select the cells, click on the “Borders” symbol, and select the border you want to use. You can also change the color of the border and the border style once you click the “Borders” symbol. 

borders-tab

Changing Formats of Numbers

Changing formats gives you different ways to present data.

formatting

Select the “Format” tab on the access bar, click “Number”, and select the option you want from the list. If the format you want is not present, click the “More Formats” option to choose more options or create your own format.

 

Copying Box into Multiple Rows/Columns

 

This a pretty easy tool to use. Place your cursor in the bottom right corner of the box you wish to copy, the cursor should become a small symbol resembling an addition sign. Left click and hold, then drag your cursor into the rows/columns you wish to copy it into.

Freezing

If you are having trouble keeping your data organized, then freezing might be for you. Freezing rows or columns is an effective way to use headers on your sheets. The freeze bars are located on the perimeter of the cell to the left of the “A” tab and above the “1” tab.

untitled-drawing-9

Formula Continuation Tip

If you have a minimum of 2 cells with a formula you would like to continue, you can easily continue that formula without having to keep typing it out. Select the cells with the formula you want to continue the formula from. Then, click and hold on the bottom right corner of the highlighted cells and drag to the cells you wish to continue with the formula.

 

More Information

If you would like to learn more about Google Sheets, go to Cole Davis’ Blog. He has created another blog about sheets, Google Sheets: Basic Functions. If you have any questions over this content or Sheets, you can contact me via email at:  pchavez@apps.ashgrove.k12.mo.us 



Bio

Paul Chavez – Student

Paul (@ChavezHelpDesk) is a senior at Ash Grove High School. He is involved in Student Help Desk and Beta Club. He is also on the football, basketball, and baseball teams. He is one of nine children in his family. In the future, Paul will be attending college at a college that is yet to be determined.

20160908_100249

Google Sheets: Basic Functions – Cole Davis

 This is the second tutorial about Google Sheets by Cole Davis. For part one, click here.


INTRODUCTION

Thanks to the prior tutorial, we now know how to enter raw data and format it. Now we can begin preforming calculations, such as finding the average score of tests, with our data. In order to do this, we need to start referencing cells and using things called functions. The functions we’ll use today include COUNTA, AVERAGE, and COUNTIF. We’ll also review some basic math operators.


USING CELL REFERENCES

Functions and mathematic formulas require us to specify the address or ‘name’ of the cells we want to manipulate. In order to do so, we need to learn how to refer to cells with the name Google Sheets automatically assigns them.

The yellow highlighted lines in the image below contain letters on the top and numbers down the side. These are used to give an address for each and every cell within the spreadsheet. The red lines are empty cells and the green line is the formula bar.

This concept of assigning an address to points on a grid based on the x axis (left to right) and y axis(up and down) axes might intimidate some, but it is no different than the board game Battleship. You have a grid and two labeled axes. Points on the grid are given a name based on where they intersect the two axes.

blank spreadsheet.png

Easy right?


MATH OPERATORS

Standard operators

These will be used for calculations on our spreadsheet.

Here are some examples of using cell references alongside math operators. Note how the cells referenced can be from anywhere on the spreadsheet.

IMPORTANT: Your formula must begin with an equals sign (=) so Google Sheets knows to make the selected cell the result of your formula.

In this video, I enter a number in some cells and use a mathematic formula to give a new cell the value of the sum of the two other cells. So, at first I enter ‘4’ in cell A1. Second, I enter ‘6’ in cell A2. I then select cell A3, go to the formula bar, and type ‘ = A1+A2 ‘. This sets the active cells value to the sum of A1 and A2 which in this case is ’10’. 


AVERAGE

Now that we have an understanding of cell references, we can start incorporating functions. There are all sorts of handy functions that quicken the pace or your work. For example, the AVERAGE function automatically calculates the average (mean) of whatever cells you tell it to! Let’s see some specifics…

In the clip below I refer to a range of cells by using the colon ‘ : ‘. This allow you to include the cells between the two you specify. In the example, I refer to the cells B2 through D2.

In order to tell the function what cells you want to change, you must wrap your choosen cells within parenthesis. This step seems like just an extra step at first, but is necessary when more advanced formulas are to be applied.

Formula Used:  =AVERAGE(B2:D2) 

Those percentages were formatted strangely. Let’s fix that.

There are certain times where the format of your data improves the readability of your spreadsheet. Here is how you can change those percentages to a more familiar format.

Select your cell you want to re-format, click Format, Number, More Formats,  and then Custom number format.

Let’s calculate the rest of the averages.

I know what some of you must be thinking. “Do I have to write out that whole formula for each row? That seems like a major inconvenience that should be addressed.” But fear not, there is a simple (and really awesome) feature that automatically applies the formula to the cells you select. Here’s how to do it:

That’s right, all you have to do is hold down the mouse and grab the bottom-right corner of the result cell and drag down the remainder of the rows. By dragging down the corner and applying it, these formulas in the purple column are automatically generated by Sheets.

results

That would have taken forever.

 


COUNTA

This function returns a number that represents how many cells have text in them. This can be useful for counting how many students put their name on their paper.

In this example, there is some missing data. Since there is no data there, it isn’t counted.

Formula used:  =COUNTA(B2:D6)

 Now we have a count of our students.


COUNTIF

This formula returns a number that represents the number of cells that meet a condition you set. In this example, the condition is “greater than 75”. So, Sheets goes through the range you specify and counts the number of cells with a value greater than 75.

Formula Used: =COUNTIF(B2:D6, “>75”)

Now we have a count of our tests with a score greater than 75.

 

File_000

Bio:

Cole Davis (@Cole_Davis64) is a student at Ash Grove High who attends classes at OTC for Computer Information Science. He dabbles in 3D animation in his spare time, and likes to help people make the most out of their computers. It’s not uncommon to find him browsing spicy memes, or making some internet.


 

Importing Grades to SIS from an External Gradebook

Importing Grades to SIS From an External Spreadsheet

By Nick Manning

Some teachers may find it a hassle to enter student grades one by one. So to help all you Teachers out, here is a blog showing you all how to import grades to SIS from an external spreadsheet.

Step One: Log into Tyler SIS. This can be accessed from the homepage of the school’s website (ashgrove.k12.mo.us)

Step 2: From the View/Maintain tab, select “End of Term Grading”.

Step 3: Click on Actions > Import Grades from External Gradebook.

sis-import

Step 4: Click the “Choose File” button to browse for the grade file to be uploaded.

The file should be tab-delimited with the following columns (but no headings):

Student ID Regular State ID

Course Code Subject+Section all together, for example H502003 (forH5010-03).

Term Code P=Progress, T or Q=Term, X=Exam, S=Semester

Letter Grade For example, A, B-, P, etc.

screenshot-2016-10-04-at-10-29-56-am

Step 5: Click the “Upload” button, a message will appear at the top left state the file was successfully Uploaded.

screen-shot-2016-09-23-at-10-31-24-am

Step 6: Click the “Import” button to complete the import.

Now you have successfully imported grades from an external gradebook and saved yourself a great deal of time.

Bio – Nick Manning

20160830_102530Nick (@ManningHelpDesk) is a Junior at Ash Grove High School and a student in the ASSIST help desk. He is brother to Lindsay Buckley, (@Lbuckley08) the Librarian at the Ash Grove School District in southwest Missouri. His dream is to attend college for computer science and make innovations in the computer and technology industry. His Google Apps Jam is working with Google Forms and creating polls and tests.

 

Simple Tips For Using Google My Maps – By Kyle Pratt

My Maps- Filing By Name

Filing by name makes My Maps more organized and less scattered. When doing a group project on My Maps creating multiple points can get confusing and unorganized. Naming each one of your points the same makes it more organized.

Step 1: Open My Maps and create new maps

Step 2: Make at least two points

Step 3: Name each point the same thing

Step 4: Click on individual styles

screenshot-2016-09-08-at-10-27-32-am

Step 5: click on the individual styles

screenshot-2016-09-08-at-10-27-49-am

Step 6: Under “Style by data column” Select “name”

screenshot-2016-09-08-at-10-27-59-am

ezgif.com-video-to-gif (1)

Changing base maps

Base maps can be used to show earth in different ways. On the left side of the page there is a box showing your layers. At the very bottom click on base map to view earth in different ways.

ezgif.com-video-to-gif (2).gif

Take this and use this to make using My Maps easier and more efficient.

Bio – Kyle Pratt

 

IMG_0909Kyle (@PrattMaster1) is a Junior at Ash Grove High School and a student in the Assist Help Desk. He is on the Ash Grove track team and a member of FBLA. After High School he plans on going to college to become a physical therapist.

 

Creating and Using a Q & A in Google Slides – Paul Chavez

Creating a question and answer in Google Slides provides an extra tool for teachers and presenters to utilize for discussion in the classroom.

Steps

  1. Select a previous existing or create a Presentation in Google Slides
Untitled drawing (1)
To create a new presentation go to slides.google.com and click “Blank”

To begin the process of creating a Question and Answer response system, you must first have a specific Google Slides Presentation that you would like the Q & A to be linked to. 

     2. Start a Q & A by going into “Presenter View”

Screenshot 2016-08-29 at 10.30.37 AM  Screenshot

Once you have your presentation opened, click on the drop-down menu by the “Present” button in the upper right corner. Choose the option “Presenter View” from the drop-down menu. When the Presenter View window opens click “Start new” under “Audience Tools”.

 

      3. Tools to use

Once you have your Q & A created there are some features to keep in mind while using it. You can choose which slide to feature the Q & A link by using the drop down menu on the left side of the presenter view window. You can also filter the audience of the Q&A by selecting who can view by clicking on the drop down menu that follows “Accepting questions from” in the presenter view. The speaker notes tab in the presenter view allows you to store various information or data that you may need during a presentation.

Screenshot 2016-08-29 at 10.37.35 AM

       4. Asked Questions

Questions or comments that have been posted on the link provided can be viewed from that page or from the presenter view under “Audience Tools”. These questions or comments can be displayed during the presentation if the presenter wishes to do so by clicking the “present” button under the desired Question. Questions can be submitted anonymously by anyone who has the web address to the Q & A page or can be recorded by the email of the user.

 

Bio

Paul Chavez – Student

 

Paul (@ChavezHelpDesk) is a senior at Ash Grove High School. He is involved in Student Help Desk and Beta Club. He is also on the football, basketball, and baseball teams. He is one of nine children in his family. In the future, Paul will be attending college at a college that is yet to be determined.

20160908_100249.jpg

Google Forms and Flubaroo….Match Made In Heaven! – Max

Learn how to efficiently use the Flubaroo Grader Chrome Add-On and Google Sheets to grade Forms/Tests/Quizzes/etc. from Google Forms.

STEPS:

  1. Open Google FormsBlog Drawing

Create a quiz or test, or use a previously created Google Form, then click on the “Responses” Tab in Google Forms, and click on the 3 dots to the right of the green tab on the right hand side of the responses tab; once there click on the “select response destination”. Then, Select/Create a Google spreadsheet to send test responses to.

2. Sheets/Flubaroo Process

Create Answer Key for Flubaroo to base its’ results off of by clicking the “Eye” preview button and answering your questions appropriately. When you do this, make sure to name the First Name/Last Name Field, “Answer Key” so you can select this response through Flubaroo Later.

  • Click “Add-Ons” tab in Sheets – then click the “Get add-ons…” tab and search for Flubaroo and downloadUntitled drawing

    • Once downloaded Click “Enable Flubaroo in this sheet”
  • Exit out of the “Flubaroo Notification”, and click on the “Add-ons” tab and click “apply Flubaroo to this assignment”
  • Click “Advanced” tab then hit
      1. Autograde tab
  • Set up preferred E-Mail and grading settings
    1. Select the Answer Key submission you’ve created for this Test/AssignmentBlog - Picture (2)
  • Set your preferred E-Mail sharing methods, such as (E-Mail Address Question, Grade Sharing Method, Include list of scores and questions, Send Answer Key)
  • To test the grader, preview the test again (as you did to create the answer key) and answer however you want; Flubaroo will then grade it.
  • Now, wait for test submissions from students, and Flubaroo will grade them and supply you with whole submission statistics on every question, as well as a “Grade”s tab in sheets.

 

VIDEO STEPS:

 

 

Max CashioMaxwell Cashio – Student

Maxwell Cashio (@CashioHelpDesk) is a senior at Ash Grove High School in Southwest Missouri. He is currently involved in many activities including: FBLA, FCCLA, Beta Club, Track & Field, Basketball, and Football. Max loves helping out classmates at school with Google Apps whenever he can. His favorite Google Application(s) would be Google Sheets/Forms and how they can do many things to improve productivity and efficiency in any job or hobby.