Thursday, August 14, 2014

Data Collection Pt. 4 - Spreadsheets

Alright, we are now to the portion of my data collection series that I have been dreading, not because I don't think it is important information for you to use, but because it's very hard to explain without showing you.  Please know that you can contact me through email, Facebook, or a comment on here for clarification or if you would like me to send you my spreadsheet format to reference.

Okay, so let's get started!  Spreadsheets are the easiest method to keep all of your data in one place.  When you need to access information to show student growth to your administrator, you can pull up one document with several pages within that document. 

Here are some examples of student data I collected last year:

To clarify, the cells that are highlighted in blue mean that the students took the opportunity to request to retest (a form from Data Collection Pt. 3 - Student Analysis) in order to improve their original score.

For those who are not strong in working spreadsheet this may seem overwhelming, but I assure you with a little playing around you can do this too!  Here are some tips to help you organize your data in spreadsheet:

1. Keep the format similar for each page. Once you have typed in all of your student information in one page, you can copy and paste to new pages.
2. You can add new pages at the bottom.  They look like little tabs.3. In order to provide meaning to the data, you will likely need to use a formula.  To get formula options you can type the "=". 
4.  Once you have your "=" you can highlight the cells you want and use the +/- signs. You can also look in the upper right corner and you have further options such as sum, average, etc.
5.  In the center of the spreadsheet formatting tools there is a symbol that is "fx" If you click this symbol you can also create your formulas and it gives you more options. 

I hope those are some small tips that can help you get started on keeping your data organized in one place.  Remember, feel free to play around with spreadsheet.  If you are completely lost, you can contact me and I will try to work you through it.  Good luck, and make today amazing! :)

No comments:

Post a Comment