Using Google Sheets to Track Student Data

By Kathleen Palmieri

Utilizing Google Sheets is an efficient method to keep an eye on student data, in addition to fulfill other progress keeping track of needs.

There are numerous methods to individualize this resource to your requirements just by following a series of steps. You will most likely discover other methods to utilize this method for other tracking purposes when you produce a Google Sheet and begin utilizing it.

When the initial set up and format is finished, you will find numerous usages for this fast information examine that will more than justify your time financial investment. This can include producing groups, scheduling trainee conferences, determining intervention or velocity requirements, and moms and dad communication.

Choose what you wish to track

To center the text in the cell, you can increase to the toolbar and choose the “Vertically Align” button, which will provide you some options. Pick the center align button. All text will be focused in the cell as soon as this is done.

To align the text in each cell, click on the entire row. Go up to the toolbar and click on the “Text Alignment” choice. To make the header area bigger, drag the border line under the number column down.

As soon as this is done, you can make aesthetic changes such as font by clicking the “Select All” box, which is the white box (upper left corner) above the numbers column. This will guarantee that any products made will now appear on the sheet. You can likewise ensure the text in each cell is quickly read by clicking the “Select All” box so when you make a change to one cell using the dragline to adjust the column size, it will use to all. This creates a pleasing discussion throughout the sheet.

Trainee names will be gone into in column A, and it is essential that you can still check out the header with column names when scrolling down. In order to keep the header from moving, click on the header row, click on “View”, then “Freeze” and click “1 row”. Now the header will remain repaired in place when moving from trainee to trainee.

First, select what you will be tracking. Develop a header that consists of a column for student names, and after that columns for the numerous evaluations or locations you wish to track. Simply type across the sheet in each of the cells.

Another choice is to make your text vertically lined up rather than horizontally aligned. This can be done by clicking the row again, then going to the “text rotation” button in the toolbar above. Select “Rotate Up”. Doing this step will develop the need to drag down the border line to guarantee all text is quickly checked out in the cell.

Think of how youll input data

In my example, I have actually decided to produce a fall box for the cells that include evaluation data To do this, click on the cell, increase to the toolbar and select “Data” and scroll down to “Data Validation”. Then alter information validation from “List from a variety” to “List of items.” Then type in the various evaluation results that you want, such as “Above, On, Below”– describing grade level progress.

To do this merely highlight all of the cells consisting of data, go to the toolbar and select “Format”. Type in the first assessment result title you selected to use (ex: Above, On, Below, and so on) and then click on the fill color option icon (the slanted cup) to alter to your picked color.

Once done, click “conserve” and you will see that a drop down menu has actually been developed in that cell. To be able to use through the entire column drag down the edge of the cell which will copy and paste the formatting down that column, and then drag to the best across and down once again to copy and paste the formatting throughout all the cells where you wish to input this information point on the sheet.

Be mindful not to utilize the very same words in various descriptors as later this might be problematic when formatting with color. I selected not to consist of the words “grade level” in my descriptors as it produced a problem in formatting later on.

Colorizing your data.

As soon as you have input all of your information, I have discovered this sheet to be easier to read and far more effective when I colorize the information points from the fall menu. Colorizing helps to reveal at a glimpse which students may need acceleration, intervention, or assist to create groups for optimal peer to peer learning.

Now you should see all of the evaluation leads to your chosen color on your sheet. Continue changing the other results by clicking on “include new guideline” until you are done. Below is a mock example of using colored information points:

The remaining 2 locations on my spreadsheet, “Student Conference” and “Contact Parents”, need another quick way to make a notation. Again, this sheet is an “at a look” resource to offer necessary information and info.

To do this, highlight the cells in the two columns, go to “insert”, go down to “Checkbox” and click. Now I merely examine if Ive had a student conference and/or have called the parents.

Adding color boosts functionality

To do this, first click on the “Select All Box” (the white box above the number column) so that the sheet is entirely highlighted. Go to the toolbar and choose “Format”, then scroll down to “Alternating Colors”.

Click on the column with trainee names, go to the toolbar and click on “Data”. Scroll down to “Split Text To Columns”. Next, a separator menu will appear and youll change from “Detect Automatically” to “Space”. The sheet will instantly discover the area and split the names into the best column when this is done. Just go back and enter First name and last name on the header instead of “Student Names”.

There are also choices for how you wish to organize the “Names” column. You can merely enter the first and last name of each student. To develop a separate column for very first and last name, ideal click on that column (most likely column A) and choose “Insert 1 right”.

I like to make my spreadsheets visually appealing and as easy to check out as possible. While at a conference or in a conference, I discover utilizing alternate colors for rows helps me locate student information rapidly.

To make the info on the header stick out more, just click on the header row to highlight all the information and choose “B” from the toolbar to make all of the text appear bold. Another nice option is to go to the toolbar and choose the “Border” option. You can select the color, as well as the density of the border line. By simply selecting the “Names” column, you can follow the same instructions to bold the text and add a border.

A menu shows up on the right side of the screen, where you can pick color combinations that will change both the header and alternate the color of the rows.

A few final Google Sheet suggestions

To share a copy of your initial sheet as a recommendation for a colleague, ideal click on the Google Sheet tab with your name, click on the drop-down sign, select “safeguard sheet” and click on the “Green Set Permissions” button. This symbolizes that you can safely share your sheet with the data.

This can easily be sorted if you are looking to see how students did with a particular assessment. Click the assessment column, scroll down to “Sort A-Z”. When looking at a specific evaluation, you can sort the results to show on the sheet by clicking the column, then click on “Sort column from A-Z” and now you can see what group.

You can do so without anybody altering your data if you would like to share this sheet with another colleague. What you will actually be sharing is the format and setup of the sheet, not your information. Scroll down to the “Sheet 1” tab at the bottom of the sheet. Label it with your name, then click “replicate” Now, enter into the copy of your sheet and erase all of your information. The sheet can now be shared, as well as used by another individual with the formatting still in place.

Information is effective

Scroll down to the “Sheet 1” tab at the bottom of the sheet. Label it with your name, then click “replicate” Now, go into the copy of your sheet and delete all of your data. To share a copy of your original sheet as a referral for a colleague, best click on the Google Sheet tab with your name, click on the drop-down symbol, select “safeguard sheet” and click on the “Green Set Permissions” button.

In order to keep the header from moving, click on the header row, click on “View”, then “Freeze” and click on “1 row”. When looking at a particular evaluation, you can sort the outcomes to reveal on the sheet by clicking on the column, then click on “Sort column from A-Z” and now you can see what group.

As a long-lasting learner, she is a devoted reader and researcher of instructional practices and techniques. Teaming up with colleagues and globally on Twitter @Kathie042500 and expanding her education adventures at is a continuous practice.

Kathleen Palmieri is a National Board Certified Teacher and NBCT Professional Learning facilitator. She is a fifth grade educator in upstate New York who examines and contributes frequently for MiddleWeb. With an enthusiasm for literacy and learning in the classroom, she takes part in various composing workshops, curriculum writing undertakings, brand-new teacher induction advancement, and mathematics discussions.

I will be teaching my students how to produce their own Data Trackers, which in will some duty to my students for tracking their development, in addition to taking ownership of their knowing. Data is effective and can assist us in our teaching, along with assistance our trainees continue to grow as learners.

Utilizing a Google Sheet conserves a great deal of paperwork and makes information incredibly available at a conference or conference merely by using a Chromebook or smartphone. This is certainly a convenience, as well as a fantastic method to track student development.

Leave a Reply

Your email address will not be published.