Spreadsheets
I have worked with spreadsheets before in typing classes and to complete inventory, however, it has been an incredibly long time and in the past I have been used to using Excel verses Google Sheets. Growing up in school grade books have always existed for me in a paper grade book system, never on the computer. With new and constantly improving technology it has come to my attention that pretty much anything can be done on the computer. The idea of putting student's grade onto a spreadsheet is a great idea! I am already aware of teacher's uploading their grades to websites and class portals, placing their grades on a spreadsheet format would help with that tremendously. There are many ways for spreadsheets to be done, and mine for instance is probably on a very amateur level. Working with any new software takes practice. I can see myself using google sheets in the future to record grades, comments, and more. However, if I want to get to that point I will have to use the website often and study the ins and outs of all the tricks.
I felt like this assignment was a little difficult for me and not many of my questions were answered in the text. I am sure this is just due to losing my practice with these sorts of programs. I felt like once I understood a concept creating my spreadsheet I was able to finish that portion with ease. I was wanting to insert some charts and graphs with data, but came across great difficulty with that in particular. I think the part I got the hang of best was using the formulas to add up the grades and do the math. Spreadsheets really does take repetition to be able to master is with ease.
https://docs.google.com/spreadsheets/d/1oaMrtOXBJt-b9DQZ_tcqrd_eWF2aOfRlE_Yy0508B7U/edit?usp=sharing
Now, how does this relate to Common Core? Where google docs and slides are great for accomplishing standards in primarily english, Spreadsheets offers standards for many math subjects. Obviously, the standards are not going to plainly state spreadsheets to be used in standards, however, teacher's can get creative with their assignments by using spreadsheets. Some standards may include using data, researching, using a quantity of numbers, all of which can easily be assessed in a spreadsheet format.
A standard mentioned in the text is stated "Understand that a set of data collected to answer a statistical question has a distribution, which can be described by its center, spread, and overall shape." The teacher can easily incorporate the use of spreadsheets into this standard. Using spreadsheets in the classroom will take time and need to start of easy. If the teacher would start with a standard that involves an easy start to sheets, the teacher can keep building once the students understand the foundation.
Sorry that your questions did not get answered. Please come to me with questions still remaining. I understand that our coverage of spreadsheets in the curriculum, particularly as relate to math, rather than mere data collection, is not strong. I certainly am not a whiz in math either, but that is the beauty of spreadsheets that they will do the math for you, if you get them set up correctly.
ReplyDeleteThanks!
Oh, and your review is very good. :-)
ReplyDeleteAh, but double checking on the weighted spreadsheet dimension of your work finds you a little short. Leaving a manual transfer between itemized sheets and your composite is less than full success. Either one should keep the itemization on a single sheet in different sections, or else use linking between sheets. Sorry...
ReplyDelete