4J CIS ESIS gradebkcalc by TlCG8IO4

VIEWS: 8 PAGES: 4

• pg 1
```									                        eSIS Gradebook Calculation - Cumulative - Simple

A Type     Category     Score    Max    Assess Wt A Type Wt Cat Wt Num. Den.
Assess #1    Homewk 1   Math Facts     8      10         2         2       3        96  120
Assess #2    Homewk 2   Math Facts     6      10         2         2       3        72  120
Assess #3    Homewk 3   Variables     10      10         2         2       5       200  200
Assess #4    Quiz 1     Math Facts    20      25         3         4       3       720  900
Assess #5    Test 1     Math Facts    45      50         4         4       3      2160 2400            3248   3740    86.845% 1st Progress Report
Assess #6                                                1         1       1         0    0
Assess #7                                                1         1       1         0    0
Assess #8                                                1         1       1         0    0
Assess #9                                                1         1       1         0    0
Assess #10                                               1         1       1         0    0            3248   3740    86.845% Mid Semester Report
Assess #11                                               1         1       1         0    0
Assess #12                                               1         1       1         0    0
Assess #13                                               1         1       1         0    0
Assess #14                                               1         1       1         0    0
Assess #15                                               1         1       1         0    0            3248   3740    86.845% 3rd Progress Report
Assess #16                                               1         1       1         0    0
Assess #17                                               1         1       1         0    0
Assess #18                                               1         1       1         0    0
Assess #19                                               1         1       1         0    0
Assess #20                                               1         1       1         0    0            3248   3740    86.845% Semester Final

Calculations work form top to bottom.

Formula Used: (sum (score earned x assess wt x assess type wt x cat wt) / sum (score max x assess wt x assess type wt x cat wt)) x 100
eSIS Gradebook Calculation - Weighted Percentages

Assume only 1 reporting period, two categories, two assessment types and multiple assessments with weights

Level 4 Final                                                  Final Result      92.679%

Level 3                               Math Facts Weight:         3                                     Variables Weight:      5
Category                                         Tot Wt          8                                               Tot Wt       8
0.805                           0.30179                          1                             0.625

Level 2                                                                                                                                     Cell S13
Assessment Type Assigments                           Tests                        Assignments                       Tests
Weight: 2                          Weight:     4                  Weight: 2                       Weight:   0
Tot Wt. 6          0.233           Tot Wt      6   0.57143         Tot Wt 2         1             Tot Wt    2       0

Level 1
Assessments       Wt.   Score Max              Wt.   Score Max                  Wt.   Score Max               Wt.   Score Max
Homework 1         2      8   10      0.4                               0                             0                               0
Homework 2         2      6   10      0.3                               0                             0                               0
Homework 3                             0                                0        2      10    10      1                               0
Quiz 1                                 0        3      20       25   0.34286                          0                               0
Test 1                                 0        4      45       50   0.51429                          0                               0
Totals     4                  0.7       7                    0.85714     2                    1        0                      0

Calculations work from the bottom (Level 1) up to the top (Level 4). The calculation begins by placing the various assessments in the
correct quarter of Level 1 depending on the Category and Assessment Type for each assessment. If you have more then 2
categories and more than 2 assessment types than you would have more than four subsections on Level 1. In the example above,
Homework 1 and Homework 2 are both in Category: Math Facts and Assessment Type: Assignments. Homework 3 is in Category:
Variables and Assessment Type: Assignments. Quiz 1 and Test 1 are both in Category: Math Facts and Assessment Type: Tests.
Special Note: If there are no assessments under a particular Category/Assessment Type combination then the Weight associated
with that combination should be set to zero (See cell S13). More than 5 assessments can be added by inserting more rows between
Assessments and Totals.

Formula Used: (Sum(score earned/score max x weight/total weight) x 100)
eSIS Gradebook Calculation - Total Points

Assume only 1 reporting period, two categories with weights, two assessment types with weights and multiple assessments with weights

Level 4 Final                                                                  Final Result    93.068%

Level 3                                         Math Facts             Wt       3                                        Variables             Wt        5
Category                                                              Tot Wt    8                                                             Tot Wt     8
0.815                                   0.3057                            1                                     0.625

Level 2                                                                                                                                                Cell V13
Assessment Type       Assigments                             Tests                                Assignments                        Tests
Wt     2                              Wt        4                          Wt    2                            Wt        0
Tot Wt   6              0.233          Tot Wt     6             0.5818      Tot Wt 2              1            Tot Wt     2                  0

Level 1
Assessments Wt        Score    Max     Num.    Den.     Wt   Score     Max     Num.    Den.    Wt Score Max Num. Den.           Wt   Score     Max     Num.       Den.
Homework 1    2         8      10       16      20                                0      0                    0    0                                    0          0
Homework 2    2         6      10       12      20                                0      0                    0    0                                    0          0
Homework 3                               0       0                                0      0     2   10   10   20   20                                    0          0
Quiz 1                                   0       0       3     20      25        60     75                    0    0                                    0          0
Test 1                                   0       0       4     45      50       180    200                    0    0                                    0          0
Totals                           28      40                              240    275                   20   20                                    0          0
0.7                                   0.8727                       1                                               0

Calculations work from the bottom (Level 1) up to the top (Level 4). The calculation begins by placing the various assessments in the correct quarter of Level
1 depending on the Category and Assessment Type for each assessment. If you have more than 2 categories and more then 2 assessment types than you
would have more than four subsections on Level 1. In the example above, Homework 1 and Homework 2 are both in Category: Math Facts and Assessment
Type: Assignments. Homework 3 is in Category: Variables and Assessment Type: Assignments. Quiz 1 and Test 1 are both in Category: Math Facts and
Assessment Type: Tests. Special Note: If there are no assessments under a particular Category/Assessment Type combination then the Weight associated
with that combination should be set to zero (See cell V13). More than 5 assessments can be added by inserting more rows between Assessments and Totals.

Formula Used: (sum(score earned x weight)/sum(score max x weight)) x 100

```
To top