What email address or phone number would you like to use to sign in to Docs.com?
If you already have an account that you use with Office or other Microsoft services, enter it here.
Or sign in with:
Signing in allows you to download and like content, and it provides the authors analytical data about your interactions with their content.
Embed code for: calculating_avg_and_extm_excel
Select a size
Before you begin, download the sample grade book mygradebook_master_sample_xlsx by selecting the An Example (Grade Book) resource on this screen. Master Grade book in MS Excel 2010 Master Grade book in MS Excel 1997-2003 Step 1: Calculating Averages Start by adding three rows to the bottom of the list: Average, Minimum, and Maximum. Calculate Average and Extremes Using Microsoft Excel Click inside the first cell where the Percentage score column (Q1 in %) meets Average, that is D15 in our example, and then click on the Function entry button fx to reveal this window: Type in Average (or select it if it’s already listed) and then click OK. It will automatically offer to calculate the average of all values above this cell from E4 to E14 (that is E4:E14) but this isn’t quite correct because we have a blank cell at E14, so we correct this to the last cell of our data range, E13, and then click OK. The result shows the average percentage achieved by students for this question, 72% in this case, which could suggest that the question was accessible overall but there would have been some students who struggled. To copy this function across to the other ‘Q in %’ columns, you either copy and paste it individually or drag the black cross (+) (move your cursor over one the four corners of the cell to reveal it) across the row. NOTE: You will get some false calculations in the Points Score columns because of unsuitable formatting— delete them or format them back from % to general number if you want to see average point scores. Your work book should look like this. Step 2: Calculating Extremes (MINIMUM & MAXIMUM) To calculate the Minimum and the Maximum score of a column (a question or the whole test), repeat Step 1 but make sure you are in the correct cell (E16) and apply the correct function term (Minimum). Copy and paste across as before and repeat for Maximum. Your grade book should now look like this: