Today I was asked how to reorder sheets from within a Google Spreadsheet. Google Spreadsheets is one of my favorite collaboration tools. It provides the capabilities for assigning different sheets to individual students or a collaborative group. Sheets can become out of order when collaborators use one spreadsheet. No worries! It is easy to drag the sheet into an alpha or numerical order. Just click down on the sheets tab and drag to the right or left to reorder sheets.
Recently one of my blog readers requested a tutorial about linking a Google Forms Reading Log to a Spreadsheet. They explained they are a new teacher and not quite so savvy. This was a good lesson for me about simplifying my blog posts. If you are a teacher interested in creating a custom Google Forms Reading Log then the following directions are for you.
The first tutorial will explain how to create the Google Form. This will be followed by a tutorial for linking the Google Forms to a spreadsheet for collecting the student’s reading data. You will also learn how to copy a Form for making it possible to build a spreadsheet which includes a tab for each individual student’s data. This may provide individualized longitudinal data supporting the readers growth. It is possible to import group data onto a separate sheet for further study.
Beyond collecting data using a Forms & Sheets Reading log becomes a timesaver for teachers. It puts all the information in one single place making it easier for accessing the information.
Creating a Google Forms Reading Log
NOTE: You will need to make multiple copies of the Form. One Form per Student because this is the only way to link individual student sheets to One Spreadsheet.
Linking a Sheet to Create a Spreadsheet
NOTE: The above steps will allow the teacher to view all the students in one spreadsheet
Okay it took me all year to discover how to eliminate the Gridlines from a Google Sheet. This is going to give my interactive creations a cleaner look. Oh my! You won’t believe how Easy this is to do!!!
How to Remove Gridlines from Google Sheets
Have you ever wanted to transfer Google Sheets information to a Google Doc and maintain formatting without the cell lines appearing? It can easily be done by copying the cell information from a Sheet and pasting into a Google Doc. This will paste the information as a table. Once the table is pasted into a Google Docs the border can be edited to zero to eliminate all borders. This is the easiest way to transfer Google Sheets text maintaining the formatting without any lines.
The following Keyboard Shortcut will Transfer the Text without formatting.
NOTE: I discovered this Keyboard Shortcut works best when using the Chrome Browser on a Mac or Windows laptop.
Oh! How I love Alice Keelers’ Google Sheet Pixel Art Template and the potentials it offers for supporting learning Geometry. After seeing this template in action I knew it would make a perfect visual manipulative for helping students with understanding the concepts of Perimeter and Area. The below video demonstrates how I envision the template being used to support students with learning math.
As Alice would say,
“The Answer is Always a Spreadsheet”
Thank you Alice Keeler for providing permission to use your spreadsheet template for this blog post!!!