AUTOMATIC GRADING SYSTEM USING GOOGLE SPREADSHEETS WITH THE IF, VLOOKUP, and IMPORTRANGE functions. HD

This video explains how to automatically set up a grading system in Google Spreadsheets. It starts off by making an exam using Google forms, then shows how to automatically grade the answers, and then how to automatically put those answers in another Google spreadsheet with the rest of the grades of the student using the =IF function, the =VLOOKUP function, and the =IMPORTRANGE function. If you have any questions, please leave them below. You can see the math exam spreadsheet here: https://docs.google.com/spreadsheet/ccc?key=0AkoBqVyOfj7idE5MVEVjT0gzNXpEQXFRNkJFQnJ1TGc And you can see the grading sheet here: https://docs.google.com/spreadsheet/ccc?key=0AkoBqVyOfj7idDNObW9DTTZjbVpocG1Jb2ZkNENBM0E