Nancy and I created a spreadsheet that looks at Student data. The purpose of the activity was to convert scores for students so that they could be labeled in four different categories: above grade level, at grade level, below grade level (bubble) or significantly below grade level.
We worked on the spreadsheet for quite some time, adding lookup tables, IF statements, charts and hyperlinks. The spreadsheet works like a computer document, which was the goal. I struggled with creating lookup tables, but I finally figured out how to make one. Navigating around the spreadsheet became fun for me as I added more and more features.
The spreadsheet is designed to help anyone looking at the sheet to look at the data in different categories. The auto filters are designed to help the reader to look at the data in different catefories. You can look at one data set or all of the data. The one disadvantage of working with data sets this large is the amount of work it takes to convert everything to numbers. The spreadsheet does not recognize text when writing a formula.
The purpose of doing this assignment is working with a spreadsheet in a different way. This was an exciting project for me. Now I just need to figure out how to upload a picture into my document.
No comments:
Post a Comment