Letter of Recommendation

Letter of Recommendation

Project Progress as of 2011-03-04

We have been given the green light to begin work on the physical side of our project. We have begun to look into how Android apps are actually written.

Action Items:
Program Arduino to control the Servos.
If we can get our hands on the wireless shield, attempt to get it to work with the Arduino.
Create the UI for the App.

Spreadsheet Extraction

I have developed a method to solve this problem while letting the master spreadsheet(s) be fully private and the student report spreadsheet to be private between the owner of the master and the student.

The TA will be the owner of all of the spreadsheets and students will only be able to view their grade sheet and can't even view the master spreadsheet. This method would work with as many Master sheets and student sheets as desired.

My example uses one master spreadsheet and one student spreadsheet, but additional student spreadsheets could easily be made by copying and a few changes to equations in a few cells.

Let me know if there are any questions.

Master Spreadsheet (private)
Student Spreadsheet

The proof that the student sheet is reading data from the master sheet is in the equation in A1:A3, this function links to a spread sheet with a certain key (which is the master sheet's key).