Excel+Spreadsheets


 * Task **:
 * To create an assessment spreadsheet with; desk labels, sign-in sheets and exam results
 * Procedure **
 * 1) Open the template spreadsheet
 * 1) Open [[file:Bachelor of Education Level 1,2,4,6,8.xls]]
 * 2) Copy, cut and paste  data from class lists to template
 * 3) Make sure you copy the style and formatting of the template
 * 4) Enter formulas for average of the scores of each column
 * 5) Apply conditional formatting to track poor performance
 * 6) Create a v-lookup table to convert percentage to to grades
 * 7) Create a visual representation of the grades distribution
 * HCT grade breakdown is as follows:
 * **F** = 0- 59%
 * **D** = 60- 64%
 * **C** = 65- 69%
 * **C+** = 70- 74%
 * **B** = 75- 79%
 * **B+** = 80- 84%
 * **A-** = 85- 89%
 * **A** = 90- 100
 * 1) Adjust the page set up in print preview so that the grades sheet fills the page as much as possible

http://people.usd.edu/~bwjames/tut/excel/index.html @http://www.easyexceltutorial.com/ <span style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 14px;">@http://youtu.be/8L1OVkw2ZQ8 <span style="color: #333333; font-family: 'Arial','sans-serif'; font-size: 14px;">@http://office.microsoft.com/en-us/excel-help/get-to-know-excel-2010-create-your-first-spreadsheet-RZ101773335.aspx
 * <span style="color: #333333; font-family: 'Arial','sans-serif';">Links for Excel tutorials **

Now try it again with these results.