Category: Google Apps

=Concatenate

=Concatenate

Screen Shot 2014-07-09 at 12.15.15 PM

 

Anyone who works with spreadsheets will tell you that there are times when you need to combine the data from two cells into one. Recently I ran into this issue when creating my class rosters. I had a cell for first name and one for last name. What I needed was one cell that contained both first and last name. At this point I had a choice. I could either rewrite them all or use a function to auto populate the fields.

I really didn’t want to spend hours typing in names so I used a function. Earlier in the day my schools Director of Technology taught me about the CONCATENATE function.

The CONCATENATE function takes data from different cells in a spread sheet and combines the data into one cell.

For example I was able to use this function to combine the data in my first name and last name cells into one cell. Below is a breakdown of how the function works…..and yes it works in both Excel and Google Sheets.

 

concatenate

So the next time that you need to combine two pieces of data into one I would highly recommend using the CONCATENATE function. It’s a huge time saver!

How to Quickly Copy Data from One Google Sheet to Another

How to Quickly Copy Data from One Google Sheet to Another

Google Sheets is a great tool for documenting and sharing data. Sometimes you need to have multiple copies of your data in different spreadsheet files. Traditionally we would need to copy the data from one spreadsheet and paste it into a new spreadsheet. Today I wanted to share with everyone a shortcut for quickly copying data in between two different Google Sheets files. This shortcut is a big time saver and great for ensuring that all of your formulas, formatting, and data copy correctly. For more information on this topic click here for a brief 90 second tutorial video.

Tutorials:

Step 1:Screen Shot 2014-05-27 at 9.10.54 AMEnter the data that you want to copy into your spreadsheet. Click on the sheet name and click on “Copy to…”

Step 2: Screen Shot 2014-05-27 at 9.11.12 AM

Select the Google Sheets file you want to insert your sheet into.

Step 3:Screen Shot 2014-05-27 at 9.11.20 AMAfter your data has been copied you should see this prompt.

Step 4:

Screen Shot 2014-05-27 at 9.11.31 AMOpen up your target notebook and look for a worksheet called “Copy of Sheet 1”. 

 

 

Pre-Filled URLS in Google Forms

Pre-Filled URLS in Google Forms

We all know that Google Forms are an awesome way to collect data from students, parents, and staff.  Today I wanted to share with everyone a quick tool that you can use to help collect data. A pre-filled url is a url that pre-populates fields in your Google Form. Pre-filling fields is a huge time saver and guarantees that certain fields (i.e. cohort, assignment title, date) are accurate and uniformed. You can also use pre-filled urls  to share exemplars, guiding questions, or sentence starters within your form. 

So why would you use a pre-filled URL?

  • To provide your students with sentence starters.
  • Provide additional instructions for students.
  • Pre-Fill the assignment name or class period to create uniformed method of collecting data.
  • Give students an exemplar of a advanced answer.
  • Anything you can think of!

 

Creating Pre-Filled URLS in Google Forms Tutorials:

Step 1: Create your Google Form.
Screen Shot 2014-05-19 at 2.17.26 PM

Step 2: After you are done creating your form click on responses and then Get pre-filled URL. Screen Shot 2014-05-21 at 11.00.34 AM

Step 3: Fill in the parts of your form that you would to be pre-filled. When you are done click submit.

Screen Shot 2014-05-19 at 2.17.55 PM

Step 4: Share your new pre-fill URL with your students/staff.
Screen Shot 2014-05-19 at 2.18.04 PM