Create a Grade Distribution Graph in Excel
[Pages:2]Create a grade distribution graph in Excel
Export gradebook
Export your Canvas gradebook as a CSV file.
Create grade distribution graph
1. Open the file in Excel. 2. Select the whole spreadsheet. 3. On the Menu Task Bar, select Insert > Recommended PivotTables. 4. Select the table that offers "Final Grades as Row" and "Count of Students" as
values. Note: If Excel doesn't give you this option automatically, you can chose any of the other options or Blank PivotTable and modify the table.
Canvas at the University of Auckland | Learning and teaching with Canvas LMS | Canvas.ac.nz
5. This will generate a table similar to the one below. 6. Once the table has been generated, select the table and then "2-D Column chart"
to create a chart similar to the one below.
Canvas at the University of Auckland | Learning and teaching with Canvas LMS | Canvas.ac.nz
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- bar graphs and pictographs greatschools
- dancers scaled bar graph worksheet
- 3 how to how to interpret pictographs
- science virtual learning 6th grade science bar graphs
- create a grade distribution graph in excel
- reading bar graph math worksheets 4 kids
- using bar graphs greatschools
- grade 3 mathematics practice test
- first grade ccss math vocabulary word list
- charts tables graphs
Related searches
- create a sign up sheet in word
- excel create a unique identifier
- how to create a excel spreadsheet
- normal distribution in excel fn
- excel normal distribution graph template
- create a bar graph free
- create a simple excel spreadsheet
- create a graph science
- how to create a normal distribution excel
- normal distribution in excel graph
- create a fillable excel spreadsheet
- create a frequency distribution calculator