Week 7a~ Spreadsheet

Assignment 8b~ Excel

Based on assignment 8a, Week 7a, we have to do spreadsheet of financial management using Calc. Now, we going to use Excel to plan, create and edit a spreadsheet of students score and grade analysis , for this we need to use function in Excel to ‘define name’ for table of grade and score; VLOOKUP to refer to the grade of the score, STDEV and AVERAGE or the score; COUNTIF to calculate how many students for each grade; create suitable and meaningful graph Graph; sort to rank the highest to the lowest score for each subject; filter to select based on certain queries.

Means to say, you need to find and determine this:

•         Define name
•          Fill Series
•          VLOOKUP
•          STDEV
•          AVERAGE
•          COUNTIF
•          Graph
•          Sort
•        Filter

As a teacher trainee who going to be teacher, knowing this was superb important for me. Because using this assignment, I can key in my future student’s mark and see their performance using the graph, also one of the function in Excel like this;

to this type of graph>>>