My first test (is still not a real test)!

Link to the spreadsheet of grades can be found HERE.

     This is a short simple musical test that involves musical concepts, music history, and the mechanics of instruments. I used the link provided by Prof. Pierce to the YouTube video he posted on the assignment page to get the initial idea for the correct use of the formula. I had a bit of trouble (since this computer I am borrowing from my mother has trouble with Google related products for whatever reason) with getting the formulas to work themselves out automatically. I then tried to refresh the page and it worked, but in my confusion I searched for other formulas to use, and found a nice Tutorial resource on the same project but with more features (Dr. Mark Wagner). He provided a "nested" IF formula that creates a Letter grade based on the percentage grades in the selected cells.

HERE is my Form with the test.

     I can use this self-grading spreadsheet on many assignments in the future, of course, not this particular one, since it was an example. It is an easy to do, DIY test feature, which makes me proud to use, since I would have developed the test myself, and created the testing page for students to use.

    This assignment follows standards 1a, 2a, 2c, and 3c. It is a great assessment tool and helps speed up the process of test grading. It demonstrates the act of students using programs like this for test taking.