Just recently, I learned for the first time how to create a spreadsheet on Excel, which I have never done before. Learning to use Excel and making a spreadsheet was somewhat frustrating but very beneficial in the end. Before I made my final spreadsheet that was going to be turned in for a grade, I was able to do a practice spreadsheet, which I think really helped me. If I had just gone into making the spreadsheet without some sort of practice, I do not think I would have known what to do and my spreadsheet would have come out wrong. The most confusing part of the spreadsheet for me was figuring out the "IF" functions and making sure that the answers said "Good" and not "Uh-Oh."As you can see in my spreadsheet below, I got all my statements to successfully say "Good" and each statement received 10 points. Once my "Right?" column was set to "Good" for all the statements, it was easy to designate 10 points to each statement/question because each one was right.
Another issue I had at first with Excel was when I was trying to protect the sheet so students couldn't change the content, but still keeping sections like "name" and "date" open/unlocked for students to work in. After playing around with it for a while, I figured it out and made it to where the students could only contribute to the "name","date" and answer section. In my spreadsheet below, I have taken a screenshot of everything that I did, however in a real sheet for a student, the answers would not be shown and the "Expected"column would be hidden because if it wasn't, students would be able to see the answers. I think the most important part of the spreadsheet is protecting it and locking/unlocking it where it is necessary. The reason for this is because I would not want my students going in and trying to change the sheet or the content of the sheet and by protecting it, students are unable to do this. Overall, I see how beneficial Excel spreadsheets are and how beneficial they will be as I begin teaching!
No comments:
Post a Comment