Learning How to Excel in Technology Land!

I have now made my own 100 point computer assessment using Excel. The teacher made computer graded spreadsheet quiz/test could be such a powerful tool to tailor assessment to exactly what the teacher has taught or the students are struggling with even if you only have one computer in the classroom.

I would like to learn a few more Excel tools:
1. How to make multiple tabs (one tab per student, a teacher page & a unit page)
2. How to feed student scores to the teacher page
3. How to link teacher tabs to the unit page (where grades are listed by student & averaged)

With the information listed above, I could set up my own Excel spreadsheet by unit. I would have the ability to allow students to work independently on the classroom computer for additional practice. The neat part is that Excel would allow me to track student progress through each section of the unit by recording and averaging their grades so I know what sections the student has mastered or if the student will need additional support. Now that the Excel spreadsheet is recording and averaging, I can focus almost totally on the student!