Learn@UW - Gradebook Page Size Limits for Spreadsheet View

The maximum page size that can be used in the Spreadsheet view of the gradebook is limited, based on the number of Grade items, to ensure satisfactory performance with large gradebooks.

Although the possible page sizes for various tools in the Learn@UW application can be set to 10, 20, 50, 100, or 200, the page size for the gradebook is reduced, if necessary, so that the page size times the number of Grades items does not exceed the maximum number of cells allowed on a page within the Spreadsheet view.

The number of columns in the gradebook equals the number of grade items plus the number of grade categories plus two to accommodate the Final Calculate Grade and Final Adjusted Grade.  For example, if there are 42 grade items within each of one of 7 grade categories, the number of columns in the gradebook is 51.

By default, the maximum number of cells allowed on a page within the Spreadsheet view is 1000.

Note that a page size of 10 is always allowed even if this limit would be exceeded.

Using the limit of 1000 cells per page, the following table below gives the maximum page size that can be used for the Spreadsheet view of a gradebook in a course based on the number of columns in the gradebook:

Number of
Columns in
Gradebook
 
Maximum
Page Size
5 or fewer
200
6 - 10 100
11 - 20 50
21 - 50 20
51 or more
10

See Also:




Keywords:brightspace learn@uw learnuw d2l desire2learn spreadsheet view grade size page limit maximum cell perform row column   Doc ID:15296
Owner:Susan D.Group:Learn@UW Utility
Created:2010-10-14 19:00 CDTUpdated:2015-06-03 16:08 CDT
Sites:DoIT Help Desk, DoIT Tech Store, Learn@UW Utility
Feedback:  1   0