{"text_format":"3","workbook":"xlsx","n_sheets":20,"sheets":["Intro","Graphs","Administration","Student Fees","All Grades","Grades - Curved","Assignments","Assignments - Curved","Final Grades","Final Grades - Curved","Class Section 1","Class Section 2","Class Section - Curved 1","Class Section - Curved 2","Formulas","Plot Vars","(Other Variables)","Labels","(Ranges)","(Import)"],"not_rendered":{"charts":6,"images":2,"defined_names":23,"comments":15},"read":"whole","date_system":"1900"}

{"sheet":"Intro","index":0,"n_rows":107,"n_cols":1,"rows_kept":107}
[]
[]
["School Grade Book"]
[]
["You can customize this template by filling in a simple form, without editing a spreadsheet."]
["This is a small working version of the Grade Book template."]
[]
["A customized template is a flexible model that you can adapt to your situation by filling in a simple form, without editing a spreadsheet or its formulas. For example, you can specify time range and time grain; number and names of items in a dimension (such as your products and product families); and include or exclude major features. The resulting spreadsheet matches your needs better than any standard template."]
["Get a customized version of this template on our website."]
[]
["ModelSheet provides you with customized templates in three ways."]
[]
["1. Order a customized version of this template."]
["Click \"+\" for more information."]
["• You can specify custom features by filling out a simple form. (Click on \"+\" for more information.)"]
["Precise customizations vary from template to template. Examples:"]
["− Specify the starting time, time range, time grain and rollup time grains (such as annual sums)."]
["− Specify the items in a dimension and levels of hierarchy (such as product families and products)."]
["− Include or exclude entire sub-models in the template."]
["− These features address the most serious problem with conventional spreadsheet templates: You can\n   customize a template in many ways without having to interpret and edit numerous cell formulas."]
[]
["• You can edit many aspects of your Excel template after receiving it. (Click on \"+\" for more information.)"]
["− Edit input data in clearly marked input cells."]
["− Edit the model start date of a template, so your template is not out of date when the start date changes."]
["− Edit names of dimension items in once place (such as products, departments, expense accounts)."]
[]
["• ModelSheet Excel templates are easier to understand. (Click on \"+\" for more information.)"]
["− Each table has an Excel comment that provides a variable name and explains the variable. "]
["− Worksheet \"Formulas\" expresses the entire model with named variables and symbolic formulas. Although\n   the symbolic formulas are not executable in Excel, they are what the model is made from in ModelSheet."]
["− You never need to read inscrutable cell formulas to understand a ModelSheet customized template."]
[]
["Explore our customized templates at http://www.modelsheetsoft.com/store.aspx"]
[]
["2. If you want more customizations, retain ModelSheet Software to build them for you."]
["Click \"+\" for more information."]
["• Our staff has extensive experience in many areas of business and engineering analysis."]
["• ModelSheet technology enables us to offer you more value for your consulting dollar."]
[]
["Learn more about consulting services at http://www.modelsheetsoft.com/consult.aspx"]
[]
["3. Use the ModelSheet Authoring Environment to build and customize your spreadsheet models."]
[]
["The ModelSheet Authoring Environment is a SaaS application for developing and maintaining business models and delivering them in conventional spreadsheets."]
["Click \"+\" to learn more about ModelSheet technology that makes customized template possible."]
[]
["This Excel workbook was generated using ModelSheet, a revolutionary new spreadsheet technology. ModelSheet allows you to develop business models using readable formulas, while avoiding the details of cell addresses and hard-to-change sheet layouts. The end result is a conventional Excel workbook just like this one. We built ModelSheet because we believe that spreadsheets are a great way of communicating results but we think it's just too hard to use them to develop reliable, maintainable, expressive and collaborative models."]
[]
["You'll get a glimpse of ModelSheet's advantages when you take a look at the \"Formulas\" tab and realize how few separate, readable formulas are needed to produce all of the other worksheets. In addition to formulas, ModelSheet knows about the \"dimensions\" in your model (e.g., products, locations, departments) as well as the time series that you're using (e.g., 5 years in quarters.) ModelSheet raises the level of thinking and acting from individual cells to natural modeling concepts. It enhances model reliabilty, auditability and maintainability; it enables you to build models that better reflect your intentions; it allows easier collaboration between modelers, developers, and report users; and it improves productivity, especially when making changes to a model."]
[]
["The ModelSheet authoring environment raises the level of thinking and acting from individual cells to natural modeling concepts like variables, dimensions, time series and accounting types. It enhances model reliabilty, auditability and maintainability; it enables you to build models that better reflect your intentions; it allows easier collaboration between modelers, developers, and report users; and it improves productivity, especially when making changes to a model."]
[]
["We have more to tell you about ModelSheet and we'd like to hear about your needs for templates and models."]
["Please visit our website at www.modelsheetsoft.com"]
["or contact us at info@modelsheetsoft.com."]
[]
[]
[]
["Description of the School Grade Book Template"]
[]
["The model uses information about assignments, students, and students' grades on the assignments to compute the grade point average for each student and some measures of the assignments themselves. Not all features are available in the Standard Version."]
[]
["The model computes a final grade and a measure of the consistency of each student's performance."]
["– For each student, the final grade is the ratio of \"quality points\" earned / the total quality points for all\n   assignments. That is, the final grade is a weighted average of grades, weighted by the type of assignment."]
["o For each student, the total number of \"quality points\" earned and the number of quality points\n   earned on each assignment. Quality points = grade x assignment weight x attendance."]
["o For each student, the total number of \"quality weight\" points for all assigments, and the number\n   of quality weight points for each assignment. Quality weight points = assignment weight x attendance."]
["– For each student, the weighted standard deviation of the grades. A lower (higher) standard deviation\n   indicates more steady (more uneven) performance by that student."]
["– For each class section, a summary page of results (optional)"]
[]
["You enter the following information about the assignments (in the shaded cells.)"]
["– A list of the individual assignments that are graded."]
["– A list of the types of assignments, such as 'homework', 'report', 'quiz', 'half test', 'test'."]
["– For each assigment, the type of assignment."]
["– For each type of assigment, a numerical weight. For example, a test has a much higher weight\n   than a typical homework assignment."]
[]
["The teacher enters the following information about the students."]
["– A list of the names of students (or other identifiers of students), preferably grouped into class sections."]
["– A table of numerical grades achieved by each student on each assignment."]
["– To indicate that a student did not participate in an assignment, enter any negative number as the grade ."]
[]
["The Advanced version supports fitting grades for each assignment to a curve specified for that assignment."]
[]
["The Advanced version optionally tracks student fees assesses and paid."]
[]
[]
[]
["Technical notes"]
[]
["The model computes four measures of the student reactions to each assignment."]
[]
["1. The average grade earned by participating students for each assigment. This is an indication of the difficulty\n    of the assignment."]
["– For each assignment, the total number of \"quality points\" earned by all students, and the number\n   of quality points earned by each student."]
["– For each assignment, the total number of \"quality weight\" points for all students, and the number\n   of quality weight points for each student."]
[]
["2. The standard deviation of the distribution of grades for each assignment.  Always positive or zero.\n    Roughly speaking, about 2/3 of the grades are within +/- standard deviation points of the mean grade."]
[]
["3. The skewness of the distribution of grades for each assignment. (A normal distribution has skewness = 0.)"]
["– If skewness <0, the distribution has some very low grades and the mean grade < 50th percentile grade.\n   A few students may be unable to keep up with the middle of the class."]
["– If skewness >0, the distribution has some very high grades and the mean grade > 50th percentile grade.\n   A few very good students may be far ahead of the midde of the class."]
[]
["4. The kurtosis of the distribution of grades for each assignment. (A normal distribution has kurtosis = 0.)"]
["– If kurtosis <0, the distribution has a sharper, narrower peak, and many very high and very low grades.\n   The class may have a wider a range of performance than is optimal."]
["– If kurtosis >0, the distribution has a flatter, wider peak, and fewer very high and very low grades.\n   The class probably is targeting nearly all students well, leaving few students far behind and few far ahead."]
[]
["This Excel workbook was generated by ModelSheet on August 6, 2010, except for this worksheet of comments."]
[]
["Copyright © 2009, 2010 ModelSheet Software, LLC"]
["ModelSheet and the ModelSheet logo are registered trademarks of ModelSheet Software, LLC."]

{"sheet":"Graphs","index":1,"n_rows":116,"n_cols":15,"rows_kept":116}
{"$rows_empty":24}
[{"$nulls":14},"A lower (higher) standard deviation indicates more steady (more uneven) performance by that student."]
{"$rows_empty":65}
[{"$nulls":14},"If skewness <0, the distribution has some very low grades and the mean grade < 50th percentile grade."]
[{"$nulls":14},"A few students may be unable to keep up with the middle of the class."]
[]
[{"$nulls":14},"If skewness >0, the distribution has some very high grades and the mean grade > 50th percentile grade."]
[{"$nulls":14}," A few very good students may be far ahead of the midde of the class."]
{"$rows_empty":15}
[{"$nulls":14},"Inclusiveness:"]
[{"$nulls":14},"If kurtosis <0, the distribution has a sharper, narrower peak, and many very high and very low grades."]
[{"$nulls":14},"The class may have a wider a range of performance than is optimal."]
[]
[{"$nulls":14},"If kurtosis >0, the distribution has a flatter, wider peak, and fewer very high and very low grades."]
[{"$nulls":14},"The class probably is targeting nearly all students well, leaving few students far behind and few far ahead."]

{"sheet":"Administration","index":2,"n_rows":43,"n_cols":5,"rows_kept":43,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[14,0,14,1],[16,0,16,3],[17,0,17,3],[18,0,18,3],[33,0,33,1],[34,0,34,1],[42,0,42,3]]}
[{"$f":"B10","v":"Middlesex College"}]
[{"$f":"B11","v":"Dr. Faust"}]
[{"$f":"B12&\", \"&B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"Administration\"","v":"Administration"}]
[{"$f":"\"\"","v":""}]
[{"$f":"\" \"","v":" "}]
[{"$f":"\"Shaded cells are input cells. You can enter data in them.\"","v":"Shaded cells are input cells. You can enter data in them."}]
[{"$f":"\"Formulas in shaded cells are starting values. You can overwrite them.\"","v":"Formulas in shaded cells are starting values. You can overwrite them."}]
[{"$f":"\" \"","v":" "}]
[{"$f":"Labels!B38","v":"School Name"},"Middlesex College"]
[{"$f":"Labels!B46","v":"Teacher Name"},"Dr. Faust"]
[{"$f":"Labels!B7","v":"Academic Subject"},"Sociology"]
[{"$f":"Labels!B8","v":"Academic Term"},"Spring 2010"]
[]
[{"$f":"\"Description of Assignments\"","v":"Description of Assignments"}]
[{"$f":"\"\"","v":""}]
[{"$f":"\"For each assignment on the left, enter an Assignment Type from the list below.\"","v":"For each assignment on the left, enter an Assignment Type from the list below."}]
[{"$f":"\"You can edit names of assignments and Assignment Types on sheet 'Labels'.\"","v":"You can edit names of assignments and Assignment Types on sheet 'Labels'."}]
[{"$f":"\"To increase number of assignments or Types, generate a new template.\"","v":"To increase number of assignments or Types, generate a new template."}]
[{"$f":"Labels!B11","v":"Assignment Type"}]
[{"$f":"\"   \"&Labels!B60","v":"   Homework 1"},{"$f":"INDEX('(Other Variables)'!B8:B10,1)","v":"Homework"}]
[{"$f":"\"   \"&Labels!B61","v":"   Class report"},{"$f":"INDEX('(Other Variables)'!B8:B10,1)","v":"Homework"}]
[{"$f":"\"   \"&Labels!B62","v":"   Quiz 1"},{"$f":"INDEX('(Other Variables)'!B8:B10,1)","v":"Homework"}]
[{"$f":"\"   \"&Labels!B63","v":"   Homework 2"},{"$f":"INDEX('(Other Variables)'!B8:B10,1)","v":"Homework"}]
[{"$f":"\"   \"&Labels!B64","v":"   Quiz 2"},{"$f":"INDEX('(Other Variables)'!B8:B10,1)","v":"Homework"}]
[{"$f":"\"   \"&Labels!B65","v":"   Test"},{"$f":"INDEX('(Other Variables)'!B8:B10,1)","v":"Homework"}]
[]
[{"$f":"Labels!B9","v":"Assign Type Weights"}]
[{"$f":"\"   \"&Labels!B55","v":"   Homework"},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B56","v":"   Quiz"},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B57","v":"   Test"},{"$f":"1","v":1}]
[]
[]
[{"$f":"\"Grading 'on a Curve'\"","v":"Grading 'on a Curve'"}]
[{"$f":"\"\"","v":""}]
[null,{"$f":"Labels!B27","v":"Mean Grade (Curve)"},{"$f":"Labels!B41","v":"Std Dev of Grades (Curve)"},{"$f":"Labels!B32","v":"Min Grade (Curve)"},{"$f":"Labels!B25","v":"Max Grade (Curve)"}]
[{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Assignments!B10","v":{"v":0,"d":"0.0"}},{"$f":"STDEV('All Grades'!B16:B20,'All Grades'!B23:B27)","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"100","v":{"v":100,"d":"100.00"}}]
[{"$f":"Labels!B61","v":"Class report"},{"$f":"Assignments!B11","v":{"v":0,"d":"0.0"}},{"$f":"STDEV('All Grades'!C16:C20,'All Grades'!C23:C27)","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"100","v":{"v":100,"d":"100.00"}}]
[{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Assignments!B12","v":{"v":0,"d":"0.0"}},{"$f":"STDEV('All Grades'!D16:D20,'All Grades'!D23:D27)","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"100","v":{"v":100,"d":"100.00"}}]
[{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Assignments!B13","v":{"v":0,"d":"0.0"}},{"$f":"STDEV('All Grades'!E16:E20,'All Grades'!E23:E27)","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"100","v":{"v":100,"d":"100.00"}}]
[{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Assignments!B14","v":{"v":0,"d":"0.0"}},{"$f":"STDEV('All Grades'!F16:F20,'All Grades'!F23:F27)","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"100","v":{"v":100,"d":"100.00"}}]
[{"$f":"Labels!B65","v":"Test"},{"$f":"Assignments!B15","v":{"v":0,"d":"0.0"}},{"$f":"STDEV('All Grades'!G16:G20,'All Grades'!G23:G27)","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"100","v":{"v":100,"d":"100.00"}}]
[{"$f":"\"These parameters define the grading curve for each assignment.\"","v":"These parameters define the grading curve for each assignment."}]

{"sheet":"Student Fees","index":3,"n_rows":21,"n_cols":3,"rows_kept":21,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"Student Fees\"","v":"Student Fees"}]
[{"$f":"\"\"","v":""}]
[null,{"$f":"Labels!B15","v":"Fees Assessed"},{"$f":"Labels!B16","v":"Fees Paid"}]
[{"$f":"Labels!B68","v":"Section 1"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"0/10","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B8:B12)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(C8:C12)","v":{"v":0,"d":"$0.00"}}]
[{"$f":"Labels!B74","v":"Section 2"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"0/10","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B15:B19)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(C15:C19)","v":{"v":0,"d":"$0.00"}}]
[{"$f":"Labels!C67","v":"Total"},{"$f":"SUM(B13,B20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(C13,C20)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"All Grades","index":4,"n_rows":81,"n_cols":8,"rows_kept":81,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[9,0,9,7],[10,0,10,7],[11,0,11,7],[12,0,12,7],[29,0,29,7]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"All Grades\"","v":"All Grades"}]
[{"$f":"\"\"","v":""}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"}]
[{"$f":"Labels!B11","v":"Assignment Type"},{"$f":"Administration!B21","v":"Homework"},{"$f":"Administration!B22","v":"Homework"},{"$f":"Administration!B23","v":"Homework"},{"$f":"Administration!B24","v":"Homework"},{"$f":"Administration!B25","v":"Homework"},{"$f":"Administration!B26","v":"Homework"}]
[{"$f":"Labels!B12","v":"Assignment Weights"},{"$f":"INDEX(Administration!B29:B31,MATCH(B7,'(Other Variables)'!B8:B10,0))","v":{"v":1,"d":"1.0"}},{"$f":"INDEX(Administration!B29:B31,MATCH(C7,'(Other Variables)'!B8:B10,0))","v":{"v":1,"d":"1.0"}},{"$f":"INDEX(Administration!B29:B31,MATCH(D7,'(Other Variables)'!B8:B10,0))","v":{"v":1,"d":"1.0"}},{"$f":"INDEX(Administration!B29:B31,MATCH(E7,'(Other Variables)'!B8:B10,0))","v":{"v":1,"d":"1.0"}},{"$f":"INDEX(Administration!B29:B31,MATCH(F7,'(Other Variables)'!B8:B10,0))","v":{"v":1,"d":"1.0"}},{"$f":"INDEX(Administration!B29:B31,MATCH(G7,'(Other Variables)'!B8:B10,0))","v":{"v":1,"d":"1.0"}}]
[]
[{"$f":"\"Shaded cells are input cells. You can enter data in them.\"","v":"Shaded cells are input cells. You can enter data in them."}]
[{"$f":"\"Formulas in shaded cells are starting values. You can overwrite them.\"","v":"Formulas in shaded cells are starting values. You can overwrite them."}]
[{"$f":"\"You can edit the names of students and assignments on worksheet 'Labels'.\"","v":"You can edit the names of students and assignments on worksheet 'Labels'."}]
[{"$f":"\"To increase the number of students, class sections or assignments, you must generate a new Template.\"","v":"To increase the number of students, class sections or assignments, you must generate a new Template."}]
[{"$f":"Labels!B17","v":"Grades"}]
[{"$f":"\"   \"&Labels!B68","v":"   Section 1"}]
[{"$f":"\"      \"&Labels!B69","v":"      Student101"},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"H51/H68","v":{"v":0,"d":"0.0"}}]
[{"$f":"\"      \"&Labels!B70","v":"      Student102"},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"      \"&Labels!B71","v":"      Student103"},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"      \"&Labels!B72","v":"      Student104"},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"      \"&Labels!B73","v":"      Student105"},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"      \"&Labels!C68","v":"      Subtotal"},{"$f":"B56/B73","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[{"$f":"\"   \"&Labels!B74","v":"   Section 2"}]
[{"$f":"\"      \"&Labels!B75","v":"      Student201"},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"H58/H75","v":{"v":0,"d":"0.0"}}]
[{"$f":"\"      \"&Labels!B76","v":"      Student202"},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"      \"&Labels!B77","v":"      Student203"},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"      \"&Labels!B78","v":"      Student204"},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"      \"&Labels!B79","v":"      Student205"},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"$f":"0","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"      \"&Labels!C74","v":"      Subtotal"},{"$f":"B63/B80","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[{"$f":"\"   \"&Labels!C67","v":"   Total"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[{"$f":"\"A negative entry means a student did not participate in an assignment; no grade is included in averages.\"","v":"A negative entry means a student did not participate in an assignment; no grade is included in averages."}]
[]
[{"$f":"Labels!B33","v":"Participation by Assignment"}]
[{"$f":"\"   \"&Labels!B68","v":"   Section 1"}]
[{"$f":"\"      \"&Labels!B69","v":"      Student101"},{"$f":"IF(B16<0,0,1)","v":1},1,1,1,1,1,{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B70","v":"      Student102"},1,1,1,1,1,1,{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B71","v":"      Student103"},1,1,1,1,1,1,{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B72","v":"      Student104"},1,1,1,1,1,1,{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B73","v":"      Student105"},1,1,1,1,1,1,{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!C68","v":"      Subtotal"},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B74","v":"   Section 2"}]
[{"$f":"\"      \"&Labels!B75","v":"      Student201"},{"$f":"IF(B23<0,0,1)","v":1},1,1,1,1,1,{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B76","v":"      Student202"},1,1,1,1,1,1,{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B77","v":"      Student203"},1,1,1,1,1,1,{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B78","v":"      Student204"},1,1,1,1,1,1,{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B79","v":"      Student205"},1,1,1,1,1,1,{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!C74","v":"      Subtotal"},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!C67","v":"   Total"},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1}]
[]
[{"$f":"Labels!B35","v":"Quality Points"}]
[{"$f":"\"   \"&Labels!B68","v":"   Section 1"}]
[{"$f":"\"      \"&Labels!B69","v":"      Student101"},{"$f":"B16*B68","v":0},0,0,0,0,0,{"$f":"SUM(B51:G51)","v":0}]
[{"$f":"\"      \"&Labels!B70","v":"      Student102"},0,0,0,0,0,0,{"$f":"SUM(B52:G52)","v":0}]
[{"$f":"\"      \"&Labels!B71","v":"      Student103"},0,0,0,0,0,0,{"$f":"SUM(B53:G53)","v":0}]
[{"$f":"\"      \"&Labels!B72","v":"      Student104"},0,0,0,0,0,0,{"$f":"SUM(B54:G54)","v":0}]
[{"$f":"\"      \"&Labels!B73","v":"      Student105"},0,0,0,0,0,0,{"$f":"SUM(B55:G55)","v":0}]
[{"$f":"\"      \"&Labels!C68","v":"      Subtotal"},{"$f":"SUM(B51:B55)","v":0},0,0,0,0,0,0]
[{"$f":"\"   \"&Labels!B74","v":"   Section 2"}]
[{"$f":"\"      \"&Labels!B75","v":"      Student201"},{"$f":"B23*B75","v":0},0,0,0,0,0,{"$f":"SUM(B58:G58)","v":0}]
[{"$f":"\"      \"&Labels!B76","v":"      Student202"},0,0,0,0,0,0,{"$f":"SUM(B59:G59)","v":0}]
[{"$f":"\"      \"&Labels!B77","v":"      Student203"},0,0,0,0,0,0,{"$f":"SUM(B60:G60)","v":0}]
[{"$f":"\"      \"&Labels!B78","v":"      Student204"},0,0,0,0,0,0,{"$f":"SUM(B61:G61)","v":0}]
[{"$f":"\"      \"&Labels!B79","v":"      Student205"},0,0,0,0,0,0,{"$f":"SUM(B62:G62)","v":0}]
[{"$f":"\"      \"&Labels!C74","v":"      Subtotal"},{"$f":"SUM(B58:B62)","v":0},0,0,0,0,0,0]
[{"$f":"\"   \"&Labels!C67","v":"   Total"},{"$f":"SUM(B56,B63)","v":0},0,0,0,0,0,0]
[]
[{"$f":"Labels!B37","v":"Quality Weights"}]
[{"$f":"\"   \"&Labels!B68","v":"   Section 1"}]
[{"$f":"\"      \"&Labels!B69","v":"      Student101"},{"$f":"B8*B34","v":1},1,1,1,1,1,{"$f":"SUM(B68:G68)","v":6}]
[{"$f":"\"      \"&Labels!B70","v":"      Student102"},{"$f":"B8*B35","v":1},1,1,1,1,1,{"$f":"SUM(B69:G69)","v":6}]
[{"$f":"\"      \"&Labels!B71","v":"      Student103"},{"$f":"B8*B36","v":1},1,1,1,1,1,{"$f":"SUM(B70:G70)","v":6}]
[{"$f":"\"      \"&Labels!B72","v":"      Student104"},{"$f":"B8*B37","v":1},1,1,1,1,1,{"$f":"SUM(B71:G71)","v":6}]
[{"$f":"\"      \"&Labels!B73","v":"      Student105"},{"$f":"B8*B38","v":1},1,1,1,1,1,{"$f":"SUM(B72:G72)","v":6}]
[{"$f":"\"      \"&Labels!C68","v":"      Subtotal"},{"$f":"SUM(B68:B72)","v":5},5,5,5,5,5,30]
[{"$f":"\"   \"&Labels!B74","v":"   Section 2"}]
[{"$f":"\"      \"&Labels!B75","v":"      Student201"},{"$f":"B8*B41","v":1},1,1,1,1,1,{"$f":"SUM(B75:G75)","v":6}]
[{"$f":"\"      \"&Labels!B76","v":"      Student202"},{"$f":"B8*B42","v":1},1,1,1,1,1,{"$f":"SUM(B76:G76)","v":6}]
[{"$f":"\"      \"&Labels!B77","v":"      Student203"},{"$f":"B8*B43","v":1},1,1,1,1,1,{"$f":"SUM(B77:G77)","v":6}]
[{"$f":"\"      \"&Labels!B78","v":"      Student204"},{"$f":"B8*B44","v":1},1,1,1,1,1,{"$f":"SUM(B78:G78)","v":6}]
[{"$f":"\"      \"&Labels!B79","v":"      Student205"},{"$f":"B8*B45","v":1},1,1,1,1,1,{"$f":"SUM(B79:G79)","v":6}]
[{"$f":"\"      \"&Labels!C74","v":"      Subtotal"},{"$f":"SUM(B75:B79)","v":5},5,5,5,5,5,30]
[{"$f":"\"   \"&Labels!C67","v":"   Total"},{"$f":"SUM(B73,B80)","v":10},10,10,10,10,10,60]

{"sheet":"Grades - Curved","index":5,"n_rows":79,"n_cols":8,"rows_kept":79,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[9,0,9,7],[10,0,10,7],[27,0,27,7]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"Grades - Curved\"","v":"Grades - Curved"}]
[{"$f":"\"\"","v":""}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"}]
[{"$f":"Labels!B11","v":"Assignment Type"},{"$f":"Administration!B21","v":"Homework"},{"$f":"Administration!B22","v":"Homework"},{"$f":"Administration!B23","v":"Homework"},{"$f":"Administration!B24","v":"Homework"},{"$f":"Administration!B25","v":"Homework"},{"$f":"Administration!B26","v":"Homework"}]
[{"$f":"Labels!B12","v":"Assignment Weights"},{"$f":"'All Grades'!B8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!C8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!D8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!E8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!F8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!G8","v":{"v":1,"d":"1.0"}}]
[]
[{"$f":"\"You can edit the names of students and assignments on worksheet 'Labels'.\"","v":"You can edit the names of students and assignments on worksheet 'Labels'."}]
[{"$f":"\"To increase the number of students, class sections or assignments, you must generate a new Template.\"","v":"To increase the number of students, class sections or assignments, you must generate a new Template."}]
[{"$f":"Labels!B18","v":"Grades (Curve)"}]
[{"$f":"\"   \"&Labels!B68","v":"   Section 1"}]
[{"$f":"\"      \"&Labels!B69","v":"      Student101"},{"$f":"IF('All Grades'!B16<0,'All Grades'!B16,MAX(Administration!D37,MIN(Administration!E37,Administration!C37*'All Grades'!B16/Assignments!C10+Administration!C37*(-Assignments!B10)/Assignments!C10)+Administration!B37))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!C16<0,'All Grades'!C16,MAX(Administration!D38,MIN(Administration!E38,Administration!C38*'All Grades'!C16/Assignments!C11+Administration!C38*(-Assignments!B11)/Assignments!C11)+Administration!B38))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!D16<0,'All Grades'!D16,MAX(Administration!D39,MIN(Administration!E39,Administration!C39*'All Grades'!D16/Assignments!C12+Administration!C39*(-Assignments!B12)/Assignments!C12)+Administration!B39))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!E16<0,'All Grades'!E16,MAX(Administration!D40,MIN(Administration!E40,Administration!C40*'All Grades'!E16/Assignments!C13+Administration!C40*(-Assignments!B13)/Assignments!C13)+Administration!B40))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!F16<0,'All Grades'!F16,MAX(Administration!D41,MIN(Administration!E41,Administration!C41*'All Grades'!F16/Assignments!C14+Administration!C41*(-Assignments!B14)/Assignments!C14)+Administration!B41))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!G16<0,'All Grades'!G16,MAX(Administration!D42,MIN(Administration!E42,Administration!C42*'All Grades'!G16/Assignments!C15+Administration!C42*(-Assignments!B15)/Assignments!C15)+Administration!B42))","v":{"$error":"#DIV/0!"}},{"$f":"H49/H66","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"      \"&Labels!B70","v":"      Student102"},{"$f":"IF('All Grades'!B17<0,'All Grades'!B17,MAX(Administration!D37,MIN(Administration!E37,Administration!C37*'All Grades'!B17/Assignments!C10+Administration!C37*(-Assignments!B10)/Assignments!C10)+Administration!B37))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!C17<0,'All Grades'!C17,MAX(Administration!D38,MIN(Administration!E38,Administration!C38*'All Grades'!C17/Assignments!C11+Administration!C38*(-Assignments!B11)/Assignments!C11)+Administration!B38))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!D17<0,'All Grades'!D17,MAX(Administration!D39,MIN(Administration!E39,Administration!C39*'All Grades'!D17/Assignments!C12+Administration!C39*(-Assignments!B12)/Assignments!C12)+Administration!B39))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!E17<0,'All Grades'!E17,MAX(Administration!D40,MIN(Administration!E40,Administration!C40*'All Grades'!E17/Assignments!C13+Administration!C40*(-Assignments!B13)/Assignments!C13)+Administration!B40))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!F17<0,'All Grades'!F17,MAX(Administration!D41,MIN(Administration!E41,Administration!C41*'All Grades'!F17/Assignments!C14+Administration!C41*(-Assignments!B14)/Assignments!C14)+Administration!B41))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!G17<0,'All Grades'!G17,MAX(Administration!D42,MIN(Administration!E42,Administration!C42*'All Grades'!G17/Assignments!C15+Administration!C42*(-Assignments!B15)/Assignments!C15)+Administration!B42))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"      \"&Labels!B71","v":"      Student103"},{"$f":"IF('All Grades'!B18<0,'All Grades'!B18,MAX(Administration!D37,MIN(Administration!E37,Administration!C37*'All Grades'!B18/Assignments!C10+Administration!C37*(-Assignments!B10)/Assignments!C10)+Administration!B37))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!C18<0,'All Grades'!C18,MAX(Administration!D38,MIN(Administration!E38,Administration!C38*'All Grades'!C18/Assignments!C11+Administration!C38*(-Assignments!B11)/Assignments!C11)+Administration!B38))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!D18<0,'All Grades'!D18,MAX(Administration!D39,MIN(Administration!E39,Administration!C39*'All Grades'!D18/Assignments!C12+Administration!C39*(-Assignments!B12)/Assignments!C12)+Administration!B39))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!E18<0,'All Grades'!E18,MAX(Administration!D40,MIN(Administration!E40,Administration!C40*'All Grades'!E18/Assignments!C13+Administration!C40*(-Assignments!B13)/Assignments!C13)+Administration!B40))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!F18<0,'All Grades'!F18,MAX(Administration!D41,MIN(Administration!E41,Administration!C41*'All Grades'!F18/Assignments!C14+Administration!C41*(-Assignments!B14)/Assignments!C14)+Administration!B41))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!G18<0,'All Grades'!G18,MAX(Administration!D42,MIN(Administration!E42,Administration!C42*'All Grades'!G18/Assignments!C15+Administration!C42*(-Assignments!B15)/Assignments!C15)+Administration!B42))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"      \"&Labels!B72","v":"      Student104"},{"$f":"IF('All Grades'!B19<0,'All Grades'!B19,MAX(Administration!D37,MIN(Administration!E37,Administration!C37*'All Grades'!B19/Assignments!C10+Administration!C37*(-Assignments!B10)/Assignments!C10)+Administration!B37))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!C19<0,'All Grades'!C19,MAX(Administration!D38,MIN(Administration!E38,Administration!C38*'All Grades'!C19/Assignments!C11+Administration!C38*(-Assignments!B11)/Assignments!C11)+Administration!B38))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!D19<0,'All Grades'!D19,MAX(Administration!D39,MIN(Administration!E39,Administration!C39*'All Grades'!D19/Assignments!C12+Administration!C39*(-Assignments!B12)/Assignments!C12)+Administration!B39))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!E19<0,'All Grades'!E19,MAX(Administration!D40,MIN(Administration!E40,Administration!C40*'All Grades'!E19/Assignments!C13+Administration!C40*(-Assignments!B13)/Assignments!C13)+Administration!B40))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!F19<0,'All Grades'!F19,MAX(Administration!D41,MIN(Administration!E41,Administration!C41*'All Grades'!F19/Assignments!C14+Administration!C41*(-Assignments!B14)/Assignments!C14)+Administration!B41))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!G19<0,'All Grades'!G19,MAX(Administration!D42,MIN(Administration!E42,Administration!C42*'All Grades'!G19/Assignments!C15+Administration!C42*(-Assignments!B15)/Assignments!C15)+Administration!B42))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"      \"&Labels!B73","v":"      Student105"},{"$f":"IF('All Grades'!B20<0,'All Grades'!B20,MAX(Administration!D37,MIN(Administration!E37,Administration!C37*'All Grades'!B20/Assignments!C10+Administration!C37*(-Assignments!B10)/Assignments!C10)+Administration!B37))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!C20<0,'All Grades'!C20,MAX(Administration!D38,MIN(Administration!E38,Administration!C38*'All Grades'!C20/Assignments!C11+Administration!C38*(-Assignments!B11)/Assignments!C11)+Administration!B38))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!D20<0,'All Grades'!D20,MAX(Administration!D39,MIN(Administration!E39,Administration!C39*'All Grades'!D20/Assignments!C12+Administration!C39*(-Assignments!B12)/Assignments!C12)+Administration!B39))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!E20<0,'All Grades'!E20,MAX(Administration!D40,MIN(Administration!E40,Administration!C40*'All Grades'!E20/Assignments!C13+Administration!C40*(-Assignments!B13)/Assignments!C13)+Administration!B40))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!F20<0,'All Grades'!F20,MAX(Administration!D41,MIN(Administration!E41,Administration!C41*'All Grades'!F20/Assignments!C14+Administration!C41*(-Assignments!B14)/Assignments!C14)+Administration!B41))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!G20<0,'All Grades'!G20,MAX(Administration!D42,MIN(Administration!E42,Administration!C42*'All Grades'!G20/Assignments!C15+Administration!C42*(-Assignments!B15)/Assignments!C15)+Administration!B42))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"      \"&Labels!C68","v":"      Subtotal"},{"$f":"B54/B71","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B74","v":"   Section 2"}]
[{"$f":"\"      \"&Labels!B75","v":"      Student201"},{"$f":"IF('All Grades'!B23<0,'All Grades'!B23,MAX(Administration!D37,MIN(Administration!E37,Administration!C37*'All Grades'!B23/Assignments!C10+Administration!C37*(-Assignments!B10)/Assignments!C10)+Administration!B37))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!C23<0,'All Grades'!C23,MAX(Administration!D38,MIN(Administration!E38,Administration!C38*'All Grades'!C23/Assignments!C11+Administration!C38*(-Assignments!B11)/Assignments!C11)+Administration!B38))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!D23<0,'All Grades'!D23,MAX(Administration!D39,MIN(Administration!E39,Administration!C39*'All Grades'!D23/Assignments!C12+Administration!C39*(-Assignments!B12)/Assignments!C12)+Administration!B39))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!E23<0,'All Grades'!E23,MAX(Administration!D40,MIN(Administration!E40,Administration!C40*'All Grades'!E23/Assignments!C13+Administration!C40*(-Assignments!B13)/Assignments!C13)+Administration!B40))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!F23<0,'All Grades'!F23,MAX(Administration!D41,MIN(Administration!E41,Administration!C41*'All Grades'!F23/Assignments!C14+Administration!C41*(-Assignments!B14)/Assignments!C14)+Administration!B41))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!G23<0,'All Grades'!G23,MAX(Administration!D42,MIN(Administration!E42,Administration!C42*'All Grades'!G23/Assignments!C15+Administration!C42*(-Assignments!B15)/Assignments!C15)+Administration!B42))","v":{"$error":"#DIV/0!"}},{"$f":"H56/H73","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"      \"&Labels!B76","v":"      Student202"},{"$f":"IF('All Grades'!B24<0,'All Grades'!B24,MAX(Administration!D37,MIN(Administration!E37,Administration!C37*'All Grades'!B24/Assignments!C10+Administration!C37*(-Assignments!B10)/Assignments!C10)+Administration!B37))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!C24<0,'All Grades'!C24,MAX(Administration!D38,MIN(Administration!E38,Administration!C38*'All Grades'!C24/Assignments!C11+Administration!C38*(-Assignments!B11)/Assignments!C11)+Administration!B38))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!D24<0,'All Grades'!D24,MAX(Administration!D39,MIN(Administration!E39,Administration!C39*'All Grades'!D24/Assignments!C12+Administration!C39*(-Assignments!B12)/Assignments!C12)+Administration!B39))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!E24<0,'All Grades'!E24,MAX(Administration!D40,MIN(Administration!E40,Administration!C40*'All Grades'!E24/Assignments!C13+Administration!C40*(-Assignments!B13)/Assignments!C13)+Administration!B40))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!F24<0,'All Grades'!F24,MAX(Administration!D41,MIN(Administration!E41,Administration!C41*'All Grades'!F24/Assignments!C14+Administration!C41*(-Assignments!B14)/Assignments!C14)+Administration!B41))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!G24<0,'All Grades'!G24,MAX(Administration!D42,MIN(Administration!E42,Administration!C42*'All Grades'!G24/Assignments!C15+Administration!C42*(-Assignments!B15)/Assignments!C15)+Administration!B42))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"      \"&Labels!B77","v":"      Student203"},{"$f":"IF('All Grades'!B25<0,'All Grades'!B25,MAX(Administration!D37,MIN(Administration!E37,Administration!C37*'All Grades'!B25/Assignments!C10+Administration!C37*(-Assignments!B10)/Assignments!C10)+Administration!B37))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!C25<0,'All Grades'!C25,MAX(Administration!D38,MIN(Administration!E38,Administration!C38*'All Grades'!C25/Assignments!C11+Administration!C38*(-Assignments!B11)/Assignments!C11)+Administration!B38))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!D25<0,'All Grades'!D25,MAX(Administration!D39,MIN(Administration!E39,Administration!C39*'All Grades'!D25/Assignments!C12+Administration!C39*(-Assignments!B12)/Assignments!C12)+Administration!B39))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!E25<0,'All Grades'!E25,MAX(Administration!D40,MIN(Administration!E40,Administration!C40*'All Grades'!E25/Assignments!C13+Administration!C40*(-Assignments!B13)/Assignments!C13)+Administration!B40))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!F25<0,'All Grades'!F25,MAX(Administration!D41,MIN(Administration!E41,Administration!C41*'All Grades'!F25/Assignments!C14+Administration!C41*(-Assignments!B14)/Assignments!C14)+Administration!B41))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!G25<0,'All Grades'!G25,MAX(Administration!D42,MIN(Administration!E42,Administration!C42*'All Grades'!G25/Assignments!C15+Administration!C42*(-Assignments!B15)/Assignments!C15)+Administration!B42))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"      \"&Labels!B78","v":"      Student204"},{"$f":"IF('All Grades'!B26<0,'All Grades'!B26,MAX(Administration!D37,MIN(Administration!E37,Administration!C37*'All Grades'!B26/Assignments!C10+Administration!C37*(-Assignments!B10)/Assignments!C10)+Administration!B37))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!C26<0,'All Grades'!C26,MAX(Administration!D38,MIN(Administration!E38,Administration!C38*'All Grades'!C26/Assignments!C11+Administration!C38*(-Assignments!B11)/Assignments!C11)+Administration!B38))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!D26<0,'All Grades'!D26,MAX(Administration!D39,MIN(Administration!E39,Administration!C39*'All Grades'!D26/Assignments!C12+Administration!C39*(-Assignments!B12)/Assignments!C12)+Administration!B39))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!E26<0,'All Grades'!E26,MAX(Administration!D40,MIN(Administration!E40,Administration!C40*'All Grades'!E26/Assignments!C13+Administration!C40*(-Assignments!B13)/Assignments!C13)+Administration!B40))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!F26<0,'All Grades'!F26,MAX(Administration!D41,MIN(Administration!E41,Administration!C41*'All Grades'!F26/Assignments!C14+Administration!C41*(-Assignments!B14)/Assignments!C14)+Administration!B41))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!G26<0,'All Grades'!G26,MAX(Administration!D42,MIN(Administration!E42,Administration!C42*'All Grades'!G26/Assignments!C15+Administration!C42*(-Assignments!B15)/Assignments!C15)+Administration!B42))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"      \"&Labels!B79","v":"      Student205"},{"$f":"IF('All Grades'!B27<0,'All Grades'!B27,MAX(Administration!D37,MIN(Administration!E37,Administration!C37*'All Grades'!B27/Assignments!C10+Administration!C37*(-Assignments!B10)/Assignments!C10)+Administration!B37))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!C27<0,'All Grades'!C27,MAX(Administration!D38,MIN(Administration!E38,Administration!C38*'All Grades'!C27/Assignments!C11+Administration!C38*(-Assignments!B11)/Assignments!C11)+Administration!B38))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!D27<0,'All Grades'!D27,MAX(Administration!D39,MIN(Administration!E39,Administration!C39*'All Grades'!D27/Assignments!C12+Administration!C39*(-Assignments!B12)/Assignments!C12)+Administration!B39))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!E27<0,'All Grades'!E27,MAX(Administration!D40,MIN(Administration!E40,Administration!C40*'All Grades'!E27/Assignments!C13+Administration!C40*(-Assignments!B13)/Assignments!C13)+Administration!B40))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!F27<0,'All Grades'!F27,MAX(Administration!D41,MIN(Administration!E41,Administration!C41*'All Grades'!F27/Assignments!C14+Administration!C41*(-Assignments!B14)/Assignments!C14)+Administration!B41))","v":{"$error":"#DIV/0!"}},{"$f":"IF('All Grades'!G27<0,'All Grades'!G27,MAX(Administration!D42,MIN(Administration!E42,Administration!C42*'All Grades'!G27/Assignments!C15+Administration!C42*(-Assignments!B15)/Assignments!C15)+Administration!B42))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"      \"&Labels!C74","v":"      Subtotal"},{"$f":"B61/B78","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!C67","v":"   Total"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"\"A negative entry means a student did not participate in an assignment; no grade is included in averages.\"","v":"A negative entry means a student did not participate in an assignment; no grade is included in averages."}]
[]
[{"$f":"Labels!B33","v":"Participation by Assignment"}]
[{"$f":"\"   \"&Labels!B68","v":"   Section 1"}]
[{"$f":"\"      \"&Labels!B69","v":"      Student101"},{"$f":"'All Grades'!B34","v":1},{"$f":"'All Grades'!C34","v":1},{"$f":"'All Grades'!D34","v":1},{"$f":"'All Grades'!E34","v":1},{"$f":"'All Grades'!F34","v":1},{"$f":"'All Grades'!G34","v":1},{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B70","v":"      Student102"},{"$f":"'All Grades'!B35","v":1},{"$f":"'All Grades'!C35","v":1},{"$f":"'All Grades'!D35","v":1},{"$f":"'All Grades'!E35","v":1},{"$f":"'All Grades'!F35","v":1},{"$f":"'All Grades'!G35","v":1},{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B71","v":"      Student103"},{"$f":"'All Grades'!B36","v":1},{"$f":"'All Grades'!C36","v":1},{"$f":"'All Grades'!D36","v":1},{"$f":"'All Grades'!E36","v":1},{"$f":"'All Grades'!F36","v":1},{"$f":"'All Grades'!G36","v":1},{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B72","v":"      Student104"},{"$f":"'All Grades'!B37","v":1},{"$f":"'All Grades'!C37","v":1},{"$f":"'All Grades'!D37","v":1},{"$f":"'All Grades'!E37","v":1},{"$f":"'All Grades'!F37","v":1},{"$f":"'All Grades'!G37","v":1},{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B73","v":"      Student105"},{"$f":"'All Grades'!B38","v":1},{"$f":"'All Grades'!C38","v":1},{"$f":"'All Grades'!D38","v":1},{"$f":"'All Grades'!E38","v":1},{"$f":"'All Grades'!F38","v":1},{"$f":"'All Grades'!G38","v":1},{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!C68","v":"      Subtotal"},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B74","v":"   Section 2"}]
[{"$f":"\"      \"&Labels!B75","v":"      Student201"},{"$f":"'All Grades'!B41","v":1},{"$f":"'All Grades'!C41","v":1},{"$f":"'All Grades'!D41","v":1},{"$f":"'All Grades'!E41","v":1},{"$f":"'All Grades'!F41","v":1},{"$f":"'All Grades'!G41","v":1},{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B76","v":"      Student202"},{"$f":"'All Grades'!B42","v":1},{"$f":"'All Grades'!C42","v":1},{"$f":"'All Grades'!D42","v":1},{"$f":"'All Grades'!E42","v":1},{"$f":"'All Grades'!F42","v":1},{"$f":"'All Grades'!G42","v":1},{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B77","v":"      Student203"},{"$f":"'All Grades'!B43","v":1},{"$f":"'All Grades'!C43","v":1},{"$f":"'All Grades'!D43","v":1},{"$f":"'All Grades'!E43","v":1},{"$f":"'All Grades'!F43","v":1},{"$f":"'All Grades'!G43","v":1},{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B78","v":"      Student204"},{"$f":"'All Grades'!B44","v":1},{"$f":"'All Grades'!C44","v":1},{"$f":"'All Grades'!D44","v":1},{"$f":"'All Grades'!E44","v":1},{"$f":"'All Grades'!F44","v":1},{"$f":"'All Grades'!G44","v":1},{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!B79","v":"      Student205"},{"$f":"'All Grades'!B45","v":1},{"$f":"'All Grades'!C45","v":1},{"$f":"'All Grades'!D45","v":1},{"$f":"'All Grades'!E45","v":1},{"$f":"'All Grades'!F45","v":1},{"$f":"'All Grades'!G45","v":1},{"$f":"1","v":1}]
[{"$f":"\"      \"&Labels!C74","v":"      Subtotal"},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!C67","v":"   Total"},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1}]
[]
[{"$f":"Labels!B36","v":"Quality Points (Curve)"}]
[{"$f":"\"   \"&Labels!B68","v":"   Section 1"}]
[{"$f":"\"      \"&Labels!B69","v":"      Student101"},{"$f":"B14*B66","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B49:G49)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"      \"&Labels!B70","v":"      Student102"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B50:G50)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"      \"&Labels!B71","v":"      Student103"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B51:G51)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"      \"&Labels!B72","v":"      Student104"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B52:G52)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"      \"&Labels!B73","v":"      Student105"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B53:G53)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"      \"&Labels!C68","v":"      Subtotal"},{"$f":"SUM(B49:B53)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B74","v":"   Section 2"}]
[{"$f":"\"      \"&Labels!B75","v":"      Student201"},{"$f":"B21*B73","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B56:G56)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"      \"&Labels!B76","v":"      Student202"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B57:G57)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"      \"&Labels!B77","v":"      Student203"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B58:G58)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"      \"&Labels!B78","v":"      Student204"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B59:G59)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"      \"&Labels!B79","v":"      Student205"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B60:G60)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"      \"&Labels!C74","v":"      Subtotal"},{"$f":"SUM(B56:B60)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!C67","v":"   Total"},{"$f":"SUM(B54,B61)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[{"$f":"Labels!B37","v":"Quality Weights"}]
[{"$f":"\"   \"&Labels!B68","v":"   Section 1"}]
[{"$f":"\"      \"&Labels!B69","v":"      Student101"},{"$f":"'All Grades'!B68","v":1},{"$f":"'All Grades'!C68","v":1},{"$f":"'All Grades'!D68","v":1},{"$f":"'All Grades'!E68","v":1},{"$f":"'All Grades'!F68","v":1},{"$f":"'All Grades'!G68","v":1},{"$f":"SUM(B66:G66)","v":6}]
[{"$f":"\"      \"&Labels!B70","v":"      Student102"},{"$f":"'All Grades'!B69","v":1},{"$f":"'All Grades'!C69","v":1},{"$f":"'All Grades'!D69","v":1},{"$f":"'All Grades'!E69","v":1},{"$f":"'All Grades'!F69","v":1},{"$f":"'All Grades'!G69","v":1},{"$f":"SUM(B67:G67)","v":6}]
[{"$f":"\"      \"&Labels!B71","v":"      Student103"},{"$f":"'All Grades'!B70","v":1},{"$f":"'All Grades'!C70","v":1},{"$f":"'All Grades'!D70","v":1},{"$f":"'All Grades'!E70","v":1},{"$f":"'All Grades'!F70","v":1},{"$f":"'All Grades'!G70","v":1},{"$f":"SUM(B68:G68)","v":6}]
[{"$f":"\"      \"&Labels!B72","v":"      Student104"},{"$f":"'All Grades'!B71","v":1},{"$f":"'All Grades'!C71","v":1},{"$f":"'All Grades'!D71","v":1},{"$f":"'All Grades'!E71","v":1},{"$f":"'All Grades'!F71","v":1},{"$f":"'All Grades'!G71","v":1},{"$f":"SUM(B69:G69)","v":6}]
[{"$f":"\"      \"&Labels!B73","v":"      Student105"},{"$f":"'All Grades'!B72","v":1},{"$f":"'All Grades'!C72","v":1},{"$f":"'All Grades'!D72","v":1},{"$f":"'All Grades'!E72","v":1},{"$f":"'All Grades'!F72","v":1},{"$f":"'All Grades'!G72","v":1},{"$f":"SUM(B70:G70)","v":6}]
[{"$f":"\"      \"&Labels!C68","v":"      Subtotal"},{"$f":"SUM(B66:B70)","v":5},5,5,5,5,5,30]
[{"$f":"\"   \"&Labels!B74","v":"   Section 2"}]
[{"$f":"\"      \"&Labels!B75","v":"      Student201"},{"$f":"'All Grades'!B75","v":1},{"$f":"'All Grades'!C75","v":1},{"$f":"'All Grades'!D75","v":1},{"$f":"'All Grades'!E75","v":1},{"$f":"'All Grades'!F75","v":1},{"$f":"'All Grades'!G75","v":1},{"$f":"SUM(B73:G73)","v":6}]
[{"$f":"\"      \"&Labels!B76","v":"      Student202"},{"$f":"'All Grades'!B76","v":1},{"$f":"'All Grades'!C76","v":1},{"$f":"'All Grades'!D76","v":1},{"$f":"'All Grades'!E76","v":1},{"$f":"'All Grades'!F76","v":1},{"$f":"'All Grades'!G76","v":1},{"$f":"SUM(B74:G74)","v":6}]
[{"$f":"\"      \"&Labels!B77","v":"      Student203"},{"$f":"'All Grades'!B77","v":1},{"$f":"'All Grades'!C77","v":1},{"$f":"'All Grades'!D77","v":1},{"$f":"'All Grades'!E77","v":1},{"$f":"'All Grades'!F77","v":1},{"$f":"'All Grades'!G77","v":1},{"$f":"SUM(B75:G75)","v":6}]
[{"$f":"\"      \"&Labels!B78","v":"      Student204"},{"$f":"'All Grades'!B78","v":1},{"$f":"'All Grades'!C78","v":1},{"$f":"'All Grades'!D78","v":1},{"$f":"'All Grades'!E78","v":1},{"$f":"'All Grades'!F78","v":1},{"$f":"'All Grades'!G78","v":1},{"$f":"SUM(B76:G76)","v":6}]
[{"$f":"\"      \"&Labels!B79","v":"      Student205"},{"$f":"'All Grades'!B79","v":1},{"$f":"'All Grades'!C79","v":1},{"$f":"'All Grades'!D79","v":1},{"$f":"'All Grades'!E79","v":1},{"$f":"'All Grades'!F79","v":1},{"$f":"'All Grades'!G79","v":1},{"$f":"SUM(B77:G77)","v":6}]
[{"$f":"\"      \"&Labels!C74","v":"      Subtotal"},{"$f":"SUM(B73:B77)","v":5},5,5,5,5,5,30]
[{"$f":"\"   \"&Labels!C67","v":"   Total"},{"$f":"SUM(B71,B78)","v":10},10,10,10,10,10,60]

{"sheet":"Assignments","index":6,"n_rows":32,"n_cols":5,"rows_kept":32,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[20,0,20,5],[21,0,21,5],[22,0,22,5],[23,0,23,5],[24,0,24,5],[25,0,25,5],[26,0,26,5],[27,0,27,5],[28,0,28,5],[29,0,29,5],[30,0,30,5],[31,0,31,5]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"Assignments\"","v":"Assignments"}]
[{"$f":"\"\"","v":""}]
[{"$f":"\" \"","v":" "}]
[{"$f":"\"Metrics for each assignment\"","v":"Metrics for each assignment"}]
[{"$f":"\" \"","v":" "}]
[null,{"$f":"Labels!B28","v":"Mean Grade"},{"$f":"Labels!B42","v":"Std Deviation"},{"$f":"Labels!B40","v":"Skewness"},{"$f":"Labels!B24","v":"Kurtosis"}]
[{"$f":"Labels!B60","v":"Homework 1"},{"$f":"SUM('All Grades'!B51:B55,'All Grades'!B58:B62)/SUM('All Grades'!B68:B72,'All Grades'!B75:B79)","v":{"v":0,"d":"0.0"}},{"$f":"STDEV('All Grades'!B16:B20,'All Grades'!B23:B27)","v":{"v":0,"d":"0.00"}},{"$f":"SKEW('All Grades'!B16:B20,'All Grades'!B23:B27)","v":{"$error":"#DIV/0!"}},{"$f":"KURT('All Grades'!B16:B20,'All Grades'!B23:B27)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B61","v":"Class report"},{"$f":"SUM('All Grades'!C51:C55,'All Grades'!C58:C62)/SUM('All Grades'!C68:C72,'All Grades'!C75:C79)","v":{"v":0,"d":"0.0"}},{"$f":"STDEV('All Grades'!C16:C20,'All Grades'!C23:C27)","v":{"v":0,"d":"0.00"}},{"$f":"SKEW('All Grades'!C16:C20,'All Grades'!C23:C27)","v":{"$error":"#DIV/0!"}},{"$f":"KURT('All Grades'!C16:C20,'All Grades'!C23:C27)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"SUM('All Grades'!D51:D55,'All Grades'!D58:D62)/SUM('All Grades'!D68:D72,'All Grades'!D75:D79)","v":{"v":0,"d":"0.0"}},{"$f":"STDEV('All Grades'!D16:D20,'All Grades'!D23:D27)","v":{"v":0,"d":"0.00"}},{"$f":"SKEW('All Grades'!D16:D20,'All Grades'!D23:D27)","v":{"$error":"#DIV/0!"}},{"$f":"KURT('All Grades'!D16:D20,'All Grades'!D23:D27)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B63","v":"Homework 2"},{"$f":"SUM('All Grades'!E51:E55,'All Grades'!E58:E62)/SUM('All Grades'!E68:E72,'All Grades'!E75:E79)","v":{"v":0,"d":"0.0"}},{"$f":"STDEV('All Grades'!E16:E20,'All Grades'!E23:E27)","v":{"v":0,"d":"0.00"}},{"$f":"SKEW('All Grades'!E16:E20,'All Grades'!E23:E27)","v":{"$error":"#DIV/0!"}},{"$f":"KURT('All Grades'!E16:E20,'All Grades'!E23:E27)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"SUM('All Grades'!F51:F55,'All Grades'!F58:F62)/SUM('All Grades'!F68:F72,'All Grades'!F75:F79)","v":{"v":0,"d":"0.0"}},{"$f":"STDEV('All Grades'!F16:F20,'All Grades'!F23:F27)","v":{"v":0,"d":"0.00"}},{"$f":"SKEW('All Grades'!F16:F20,'All Grades'!F23:F27)","v":{"$error":"#DIV/0!"}},{"$f":"KURT('All Grades'!F16:F20,'All Grades'!F23:F27)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B65","v":"Test"},{"$f":"SUM('All Grades'!G51:G55,'All Grades'!G58:G62)/SUM('All Grades'!G68:G72,'All Grades'!G75:G79)","v":{"v":0,"d":"0.0"}},{"$f":"STDEV('All Grades'!G16:G20,'All Grades'!G23:G27)","v":{"v":0,"d":"0.00"}},{"$f":"SKEW('All Grades'!G16:G20,'All Grades'!G23:G27)","v":{"$error":"#DIV/0!"}},{"$f":"KURT('All Grades'!G16:G20,'All Grades'!G23:G27)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!C59","v":"Total"},{"$f":"AVERAGE(B10:B15)","v":{"v":0,"d":"0.0"}},{"$f":"STDEV('All Grades'!H16:H20,'All Grades'!H23:H27)","v":{"v":0,"d":"0.00"}},{"$f":"SKEW('All Grades'!H16:H20,'All Grades'!H23:H27)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E10:E15)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\" \"","v":" "}]
[]
[{"$f":"\"Interpretation\"","v":"Interpretation"}]
[{"$f":"\" \"","v":" "}]
[{"$f":"\"A lower standard deviation indicates more steady performance on that assignment across students.\"","v":"A lower standard deviation indicates more steady performance on that assignment across students."}]
[{"$f":"\"A higher standard deviation indicates more uneven performance on that assignment across students.\"","v":"A higher standard deviation indicates more uneven performance on that assignment across students."}]
[{"$f":"\" \"","v":" "}]
[{"$f":"\"If skewness <0, the distribution has some very low grades.\"","v":"If skewness <0, the distribution has some very low grades."}]
[{"$f":"\"A few students may be unable to keep up with the middle of the class.\"","v":"A few students may be unable to keep up with the middle of the class."}]
[{"$f":"\"If skewness >0, the distribution has some very high grades.\"","v":"If skewness >0, the distribution has some very high grades."}]
[{"$f":"\" A few very good students may be far ahead of the midde of the class.\"","v":" A few very good students may be far ahead of the midde of the class."}]
[{"$f":"\" \"","v":" "}]
[{"$f":"\"If kurtosis <0, the grade distribution has relatively many very high and very low grades.\"","v":"If kurtosis <0, the grade distribution has relatively many very high and very low grades."}]
[{"$f":"\"The class may have a wider a range of performance than is optimal.\"","v":"The class may have a wider a range of performance than is optimal."}]
[{"$f":"\"If kurtosis >0, the grade distribution has fewer very high and very low grades.\"","v":"If kurtosis >0, the grade distribution has fewer very high and very low grades."}]
[{"$f":"\"The class probably is targeting nearly all students well, leaving few students far behind and few far ahead.\"","v":"The class probably is targeting nearly all students well, leaving few students far behind and few far ahead."}]

{"sheet":"Assignments - Curved","index":7,"n_rows":31,"n_cols":5,"rows_kept":31,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[19,0,19,5],[20,0,20,5],[21,0,21,5],[22,0,22,5],[23,0,23,5],[24,0,24,5],[25,0,25,5],[26,0,26,5],[27,0,27,5],[28,0,28,5],[29,0,29,5],[30,0,30,5]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"Assignments - Curved\"","v":"Assignments - Curved"}]
[{"$f":"\"\"","v":""}]
[{"$f":"\" \"","v":" "}]
[{"$f":"\"Metrics for each assignment\"","v":"Metrics for each assignment"}]
[{"$f":"\" \"","v":" "}]
[null,{"$f":"Labels!B27","v":"Mean Grade (Curve)"},{"$f":"Labels!B41","v":"Std Dev of Grades (Curve)"},{"$f":"Labels!B39","v":"Skewness (Curve)"},{"$f":"Labels!B23","v":"Kurtosis (Curved)"}]
[{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Administration!B37","v":{"v":0,"d":"0.0"}},{"$f":"Administration!C37","v":{"v":0,"d":"0.0"}},{"$f":"SKEW('Grades - Curved'!B14:B18,'Grades - Curved'!B21:B25)","v":{"$error":"#DIV/0!"}},{"$f":"KURT('Grades - Curved'!B14:B18,'Grades - Curved'!B21:B25)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B61","v":"Class report"},{"$f":"Administration!B38","v":{"v":0,"d":"0.0"}},{"$f":"Administration!C38","v":{"v":0,"d":"0.0"}},{"$f":"SKEW('Grades - Curved'!C14:C18,'Grades - Curved'!C21:C25)","v":{"$error":"#DIV/0!"}},{"$f":"KURT('Grades - Curved'!C14:C18,'Grades - Curved'!C21:C25)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Administration!B39","v":{"v":0,"d":"0.0"}},{"$f":"Administration!C39","v":{"v":0,"d":"0.0"}},{"$f":"SKEW('Grades - Curved'!D14:D18,'Grades - Curved'!D21:D25)","v":{"$error":"#DIV/0!"}},{"$f":"KURT('Grades - Curved'!D14:D18,'Grades - Curved'!D21:D25)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Administration!B40","v":{"v":0,"d":"0.0"}},{"$f":"Administration!C40","v":{"v":0,"d":"0.0"}},{"$f":"SKEW('Grades - Curved'!E14:E18,'Grades - Curved'!E21:E25)","v":{"$error":"#DIV/0!"}},{"$f":"KURT('Grades - Curved'!E14:E18,'Grades - Curved'!E21:E25)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Administration!B41","v":{"v":0,"d":"0.0"}},{"$f":"Administration!C41","v":{"v":0,"d":"0.0"}},{"$f":"SKEW('Grades - Curved'!F14:F18,'Grades - Curved'!F21:F25)","v":{"$error":"#DIV/0!"}},{"$f":"KURT('Grades - Curved'!F14:F18,'Grades - Curved'!F21:F25)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B65","v":"Test"},{"$f":"Administration!B42","v":{"v":0,"d":"0.0"}},{"$f":"Administration!C42","v":{"v":0,"d":"0.0"}},{"$f":"SKEW('Grades - Curved'!G14:G18,'Grades - Curved'!G21:G25)","v":{"$error":"#DIV/0!"}},{"$f":"KURT('Grades - Curved'!G14:G18,'Grades - Curved'!G21:G25)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\" \"","v":" "}]
[]
[{"$f":"\"Interpretation\"","v":"Interpretation"}]
[{"$f":"\" \"","v":" "}]
[{"$f":"\"A lower standard deviation indicates more steady performance on that assignment across students.\"","v":"A lower standard deviation indicates more steady performance on that assignment across students."}]
[{"$f":"\"A higher standard deviation indicates more uneven performance on that assignment across students.\"","v":"A higher standard deviation indicates more uneven performance on that assignment across students."}]
[{"$f":"\" \"","v":" "}]
[{"$f":"\"If skewness <0, the distribution has some very low grades.\"","v":"If skewness <0, the distribution has some very low grades."}]
[{"$f":"\"A few students may be unable to keep up with the middle of the class.\"","v":"A few students may be unable to keep up with the middle of the class."}]
[{"$f":"\"If skewness >0, the distribution has some very high grades.\"","v":"If skewness >0, the distribution has some very high grades."}]
[{"$f":"\" A few very good students may be far ahead of the midde of the class.\"","v":" A few very good students may be far ahead of the midde of the class."}]
[{"$f":"\" \"","v":" "}]
[{"$f":"\"If kurtosis <0, the grade distribution has relatively many very high and very low grades.\"","v":"If kurtosis <0, the grade distribution has relatively many very high and very low grades."}]
[{"$f":"\"The class may have a wider a range of performance than is optimal.\"","v":"The class may have a wider a range of performance than is optimal."}]
[{"$f":"\"If kurtosis >0, the grade distribution has fewer very high and very low grades.\"","v":"If kurtosis >0, the grade distribution has fewer very high and very low grades."}]
[{"$f":"\"The class probably is targeting nearly all students well, leaving few students far behind and few far ahead.\"","v":"The class probably is targeting nearly all students well, leaving few students far behind and few far ahead."}]

{"sheet":"Final Grades","index":8,"n_rows":21,"n_cols":3,"rows_kept":21,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"Final Grades\"","v":"Final Grades"}]
[{"$f":"\"\"","v":""}]
[null,{"$f":"Labels!B30","v":"Mean Grade"},{"$f":"Labels!B44","v":"Std Deviation"}]
[{"$f":"Labels!B68","v":"Section 1"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"SUM('All Grades'!B51:G51)/SUM('All Grades'!B68:G68)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B32)","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"SUM('All Grades'!B52:G52)/SUM('All Grades'!B69:G69)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B33)","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"SUM('All Grades'!B53:G53)/SUM('All Grades'!B70:G70)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B34)","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"SUM('All Grades'!B54:G54)/SUM('All Grades'!B71:G71)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B35)","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"SUM('All Grades'!B55:G55)/SUM('All Grades'!B72:G72)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B36)","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM('All Grades'!B56:G56)/SUM('All Grades'!B73:G73)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B37)","v":{"v":0,"d":"0.00"}}]
[{"$f":"Labels!B74","v":"Section 2"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"SUM('All Grades'!B58:G58)/SUM('All Grades'!B75:G75)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B39)","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"SUM('All Grades'!B59:G59)/SUM('All Grades'!B76:G76)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B40)","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"SUM('All Grades'!B60:G60)/SUM('All Grades'!B77:G77)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B41)","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"SUM('All Grades'!B61:G61)/SUM('All Grades'!B78:G78)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B42)","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"SUM('All Grades'!B62:G62)/SUM('All Grades'!B79:G79)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B43)","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM('All Grades'!B63:G63)/SUM('All Grades'!B80:G80)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B44)","v":{"v":0,"d":"0.00"}}]
[{"$f":"Labels!C67","v":"Total"},{"$f":"SUM('All Grades'!B64:G64)/SUM('All Grades'!B81:G81)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B45)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Final Grades - Curved","index":9,"n_rows":21,"n_cols":3,"rows_kept":21,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"Final Grades - Curved\"","v":"Final Grades - Curved"}]
[{"$f":"\"\"","v":""}]
[null,{"$f":"Labels!B30","v":"Mean Grade"},{"$f":"Labels!B44","v":"Std Deviation"}]
[{"$f":"Labels!B68","v":"Section 1"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"'Final Grades'!B8","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!C8","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"'Final Grades'!B9","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!C9","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"'Final Grades'!B10","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!C10","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"'Final Grades'!B11","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!C11","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"'Final Grades'!B12","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!C12","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM('All Grades'!B56:G56)/SUM('All Grades'!B73:G73)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B37)","v":{"v":0,"d":"0.00"}}]
[{"$f":"Labels!B74","v":"Section 2"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"'Final Grades'!B15","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!C15","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"'Final Grades'!B16","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!C16","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"'Final Grades'!B17","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!C17","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"'Final Grades'!B18","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!C18","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"'Final Grades'!B19","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!C19","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM('All Grades'!B63:G63)/SUM('All Grades'!B80:G80)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B44)","v":{"v":0,"d":"0.00"}}]
[{"$f":"Labels!C67","v":"Total"},{"$f":"SUM('All Grades'!B64:G64)/SUM('All Grades'!B81:G81)","v":{"v":0,"d":"0.0"}},{"$f":"SQRT('(Other Variables)'!B45)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Class Section 1","index":10,"n_rows":60,"n_cols":8,"rows_kept":60,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[17,0,17,7],[19,0,19,1],[20,0,20,1],[30,0,30,1],[31,0,31,1],[41,0,41,1],[42,0,42,1],[52,0,52,1]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"Class Section 1\"","v":"Class Section 1"}]
[{"$f":"\"\"","v":""}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"}]
[{"$f":"Labels!B11","v":"Assignment Type"},{"$f":"Administration!B21","v":"Homework"},{"$f":"Administration!B22","v":"Homework"},{"$f":"Administration!B23","v":"Homework"},{"$f":"Administration!B24","v":"Homework"},{"$f":"Administration!B25","v":"Homework"},{"$f":"Administration!B26","v":"Homework"}]
[{"$f":"Labels!B12","v":"Assignment Weights"},{"$f":"'All Grades'!B8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!C8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!D8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!E8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!F8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!G8","v":{"v":1,"d":"1.0"}}]
[]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B17","v":"Grades"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"'All Grades'!B16","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!C16","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!D16","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!E16","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!F16","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!G16","v":{"v":0,"d":"0.0"}},{"$f":"H35/H46","v":{"v":0,"d":"0.0"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"'All Grades'!B17","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!C17","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!D17","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!E17","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!F17","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!G17","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"'All Grades'!B18","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!C18","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!D18","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!E18","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!F18","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!G18","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"'All Grades'!B19","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!C19","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!D19","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!E19","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!F19","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!G19","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"'All Grades'!B20","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!C20","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!D20","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!E20","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!F20","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!G20","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"B40/B51","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[{"$f":"\"A negative entry means a student did not participate in an assignment; no grade is included in averages.\"","v":"A negative entry means a student did not participate in an assignment; no grade is included in averages."}]
[]
[{"$f":"\"Student Participation\"","v":"Student Participation"}]
[{"$f":"\" \"","v":" "}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B33","v":"Participation by Assignment"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"'All Grades'!B34","v":1},{"$f":"'All Grades'!C34","v":1},{"$f":"'All Grades'!D34","v":1},{"$f":"'All Grades'!E34","v":1},{"$f":"'All Grades'!F34","v":1},{"$f":"'All Grades'!G34","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"'All Grades'!B35","v":1},{"$f":"'All Grades'!C35","v":1},{"$f":"'All Grades'!D35","v":1},{"$f":"'All Grades'!E35","v":1},{"$f":"'All Grades'!F35","v":1},{"$f":"'All Grades'!G35","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"'All Grades'!B36","v":1},{"$f":"'All Grades'!C36","v":1},{"$f":"'All Grades'!D36","v":1},{"$f":"'All Grades'!E36","v":1},{"$f":"'All Grades'!F36","v":1},{"$f":"'All Grades'!G36","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"'All Grades'!B37","v":1},{"$f":"'All Grades'!C37","v":1},{"$f":"'All Grades'!D37","v":1},{"$f":"'All Grades'!E37","v":1},{"$f":"'All Grades'!F37","v":1},{"$f":"'All Grades'!G37","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"'All Grades'!B38","v":1},{"$f":"'All Grades'!C38","v":1},{"$f":"'All Grades'!D38","v":1},{"$f":"'All Grades'!E38","v":1},{"$f":"'All Grades'!F38","v":1},{"$f":"'All Grades'!G38","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1}]
[]
[{"$f":"\"Quality Points\"","v":"Quality Points"}]
[{"$f":"\" \"","v":" "}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B35","v":"Quality Points"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"'All Grades'!B51","v":0},{"$f":"'All Grades'!C51","v":0},{"$f":"'All Grades'!D51","v":0},{"$f":"'All Grades'!E51","v":0},{"$f":"'All Grades'!F51","v":0},{"$f":"'All Grades'!G51","v":0},{"$f":"SUM(B35:G35)","v":0}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"'All Grades'!B52","v":0},{"$f":"'All Grades'!C52","v":0},{"$f":"'All Grades'!D52","v":0},{"$f":"'All Grades'!E52","v":0},{"$f":"'All Grades'!F52","v":0},{"$f":"'All Grades'!G52","v":0},{"$f":"SUM(B36:G36)","v":0}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"'All Grades'!B53","v":0},{"$f":"'All Grades'!C53","v":0},{"$f":"'All Grades'!D53","v":0},{"$f":"'All Grades'!E53","v":0},{"$f":"'All Grades'!F53","v":0},{"$f":"'All Grades'!G53","v":0},{"$f":"SUM(B37:G37)","v":0}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"'All Grades'!B54","v":0},{"$f":"'All Grades'!C54","v":0},{"$f":"'All Grades'!D54","v":0},{"$f":"'All Grades'!E54","v":0},{"$f":"'All Grades'!F54","v":0},{"$f":"'All Grades'!G54","v":0},{"$f":"SUM(B38:G38)","v":0}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"'All Grades'!B55","v":0},{"$f":"'All Grades'!C55","v":0},{"$f":"'All Grades'!D55","v":0},{"$f":"'All Grades'!E55","v":0},{"$f":"'All Grades'!F55","v":0},{"$f":"'All Grades'!G55","v":0},{"$f":"SUM(B39:G39)","v":0}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B35:B39)","v":0},0,0,0,0,0,0]
[]
[{"$f":"\"Quality Weights\"","v":"Quality Weights"}]
[{"$f":"\" \"","v":" "}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B37","v":"Quality Weights"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"'All Grades'!B68","v":1},{"$f":"'All Grades'!C68","v":1},{"$f":"'All Grades'!D68","v":1},{"$f":"'All Grades'!E68","v":1},{"$f":"'All Grades'!F68","v":1},{"$f":"'All Grades'!G68","v":1},{"$f":"SUM(B46:G46)","v":6}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"'All Grades'!B69","v":1},{"$f":"'All Grades'!C69","v":1},{"$f":"'All Grades'!D69","v":1},{"$f":"'All Grades'!E69","v":1},{"$f":"'All Grades'!F69","v":1},{"$f":"'All Grades'!G69","v":1},{"$f":"SUM(B47:G47)","v":6}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"'All Grades'!B70","v":1},{"$f":"'All Grades'!C70","v":1},{"$f":"'All Grades'!D70","v":1},{"$f":"'All Grades'!E70","v":1},{"$f":"'All Grades'!F70","v":1},{"$f":"'All Grades'!G70","v":1},{"$f":"SUM(B48:G48)","v":6}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"'All Grades'!B71","v":1},{"$f":"'All Grades'!C71","v":1},{"$f":"'All Grades'!D71","v":1},{"$f":"'All Grades'!E71","v":1},{"$f":"'All Grades'!F71","v":1},{"$f":"'All Grades'!G71","v":1},{"$f":"SUM(B49:G49)","v":6}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"'All Grades'!B72","v":1},{"$f":"'All Grades'!C72","v":1},{"$f":"'All Grades'!D72","v":1},{"$f":"'All Grades'!E72","v":1},{"$f":"'All Grades'!F72","v":1},{"$f":"'All Grades'!G72","v":1},{"$f":"SUM(B50:G50)","v":6}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B46:B50)","v":5},5,5,5,5,5,30]
[]
[{"$f":"\"Student Consistency\"","v":"Student Consistency"}]
[{"$f":"Labels!B44","v":"Std Deviation"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"'Final Grades'!C8","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"'Final Grades'!C9","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"'Final Grades'!C10","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"'Final Grades'!C11","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"'Final Grades'!C12","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SQRT('(Other Variables)'!B37)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Class Section 2","index":11,"n_rows":60,"n_cols":8,"rows_kept":60,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[17,0,17,7],[19,0,19,1],[20,0,20,1],[30,0,30,1],[31,0,31,1],[41,0,41,1],[42,0,42,1],[52,0,52,1]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"Class Section 2\"","v":"Class Section 2"}]
[{"$f":"\"\"","v":""}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"}]
[{"$f":"Labels!B11","v":"Assignment Type"},{"$f":"Administration!B21","v":"Homework"},{"$f":"Administration!B22","v":"Homework"},{"$f":"Administration!B23","v":"Homework"},{"$f":"Administration!B24","v":"Homework"},{"$f":"Administration!B25","v":"Homework"},{"$f":"Administration!B26","v":"Homework"}]
[{"$f":"Labels!B12","v":"Assignment Weights"},{"$f":"'All Grades'!B8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!C8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!D8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!E8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!F8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!G8","v":{"v":1,"d":"1.0"}}]
[]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B17","v":"Grades"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"'All Grades'!B23","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!C23","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!D23","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!E23","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!F23","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!G23","v":{"v":0,"d":"0.0"}},{"$f":"H35/H46","v":{"v":0,"d":"0.0"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"'All Grades'!B24","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!C24","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!D24","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!E24","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!F24","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!G24","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"'All Grades'!B25","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!C25","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!D25","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!E25","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!F25","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!G25","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"'All Grades'!B26","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!C26","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!D26","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!E26","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!F26","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!G26","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"'All Grades'!B27","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!C27","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!D27","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!E27","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!F27","v":{"v":0,"d":"0.0"}},{"$f":"'All Grades'!G27","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"B40/B51","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[{"$f":"\"A negative entry means a student did not participate in an assignment; no grade is included in averages.\"","v":"A negative entry means a student did not participate in an assignment; no grade is included in averages."}]
[]
[{"$f":"\"Student Participation\"","v":"Student Participation"}]
[{"$f":"\" \"","v":" "}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B33","v":"Participation by Assignment"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"'All Grades'!B41","v":1},{"$f":"'All Grades'!C41","v":1},{"$f":"'All Grades'!D41","v":1},{"$f":"'All Grades'!E41","v":1},{"$f":"'All Grades'!F41","v":1},{"$f":"'All Grades'!G41","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"'All Grades'!B42","v":1},{"$f":"'All Grades'!C42","v":1},{"$f":"'All Grades'!D42","v":1},{"$f":"'All Grades'!E42","v":1},{"$f":"'All Grades'!F42","v":1},{"$f":"'All Grades'!G42","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"'All Grades'!B43","v":1},{"$f":"'All Grades'!C43","v":1},{"$f":"'All Grades'!D43","v":1},{"$f":"'All Grades'!E43","v":1},{"$f":"'All Grades'!F43","v":1},{"$f":"'All Grades'!G43","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"'All Grades'!B44","v":1},{"$f":"'All Grades'!C44","v":1},{"$f":"'All Grades'!D44","v":1},{"$f":"'All Grades'!E44","v":1},{"$f":"'All Grades'!F44","v":1},{"$f":"'All Grades'!G44","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"'All Grades'!B45","v":1},{"$f":"'All Grades'!C45","v":1},{"$f":"'All Grades'!D45","v":1},{"$f":"'All Grades'!E45","v":1},{"$f":"'All Grades'!F45","v":1},{"$f":"'All Grades'!G45","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1}]
[]
[{"$f":"\"Quality Points\"","v":"Quality Points"}]
[{"$f":"\" \"","v":" "}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B35","v":"Quality Points"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"'All Grades'!B58","v":0},{"$f":"'All Grades'!C58","v":0},{"$f":"'All Grades'!D58","v":0},{"$f":"'All Grades'!E58","v":0},{"$f":"'All Grades'!F58","v":0},{"$f":"'All Grades'!G58","v":0},{"$f":"SUM(B35:G35)","v":0}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"'All Grades'!B59","v":0},{"$f":"'All Grades'!C59","v":0},{"$f":"'All Grades'!D59","v":0},{"$f":"'All Grades'!E59","v":0},{"$f":"'All Grades'!F59","v":0},{"$f":"'All Grades'!G59","v":0},{"$f":"SUM(B36:G36)","v":0}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"'All Grades'!B60","v":0},{"$f":"'All Grades'!C60","v":0},{"$f":"'All Grades'!D60","v":0},{"$f":"'All Grades'!E60","v":0},{"$f":"'All Grades'!F60","v":0},{"$f":"'All Grades'!G60","v":0},{"$f":"SUM(B37:G37)","v":0}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"'All Grades'!B61","v":0},{"$f":"'All Grades'!C61","v":0},{"$f":"'All Grades'!D61","v":0},{"$f":"'All Grades'!E61","v":0},{"$f":"'All Grades'!F61","v":0},{"$f":"'All Grades'!G61","v":0},{"$f":"SUM(B38:G38)","v":0}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"'All Grades'!B62","v":0},{"$f":"'All Grades'!C62","v":0},{"$f":"'All Grades'!D62","v":0},{"$f":"'All Grades'!E62","v":0},{"$f":"'All Grades'!F62","v":0},{"$f":"'All Grades'!G62","v":0},{"$f":"SUM(B39:G39)","v":0}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B35:B39)","v":0},0,0,0,0,0,0]
[]
[{"$f":"\"Quality Weights\"","v":"Quality Weights"}]
[{"$f":"\" \"","v":" "}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B37","v":"Quality Weights"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"'All Grades'!B75","v":1},{"$f":"'All Grades'!C75","v":1},{"$f":"'All Grades'!D75","v":1},{"$f":"'All Grades'!E75","v":1},{"$f":"'All Grades'!F75","v":1},{"$f":"'All Grades'!G75","v":1},{"$f":"SUM(B46:G46)","v":6}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"'All Grades'!B76","v":1},{"$f":"'All Grades'!C76","v":1},{"$f":"'All Grades'!D76","v":1},{"$f":"'All Grades'!E76","v":1},{"$f":"'All Grades'!F76","v":1},{"$f":"'All Grades'!G76","v":1},{"$f":"SUM(B47:G47)","v":6}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"'All Grades'!B77","v":1},{"$f":"'All Grades'!C77","v":1},{"$f":"'All Grades'!D77","v":1},{"$f":"'All Grades'!E77","v":1},{"$f":"'All Grades'!F77","v":1},{"$f":"'All Grades'!G77","v":1},{"$f":"SUM(B48:G48)","v":6}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"'All Grades'!B78","v":1},{"$f":"'All Grades'!C78","v":1},{"$f":"'All Grades'!D78","v":1},{"$f":"'All Grades'!E78","v":1},{"$f":"'All Grades'!F78","v":1},{"$f":"'All Grades'!G78","v":1},{"$f":"SUM(B49:G49)","v":6}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"'All Grades'!B79","v":1},{"$f":"'All Grades'!C79","v":1},{"$f":"'All Grades'!D79","v":1},{"$f":"'All Grades'!E79","v":1},{"$f":"'All Grades'!F79","v":1},{"$f":"'All Grades'!G79","v":1},{"$f":"SUM(B50:G50)","v":6}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B46:B50)","v":5},5,5,5,5,5,30]
[]
[{"$f":"\"Student Consistency\"","v":"Student Consistency"}]
[{"$f":"Labels!B44","v":"Std Deviation"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"'Final Grades'!C15","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"'Final Grades'!C16","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"'Final Grades'!C17","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"'Final Grades'!C18","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"'Final Grades'!C19","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SQRT('(Other Variables)'!B44)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Class Section - Curved 1","index":12,"n_rows":60,"n_cols":8,"rows_kept":60,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[17,0,17,7],[19,0,19,1],[20,0,20,1],[30,0,30,1],[31,0,31,1],[41,0,41,1],[42,0,42,1],[52,0,52,1]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"Class Section - Curved 1\"","v":"Class Section - Curved 1"}]
[{"$f":"\"\"","v":""}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"}]
[{"$f":"Labels!B11","v":"Assignment Type"},{"$f":"Administration!B21","v":"Homework"},{"$f":"Administration!B22","v":"Homework"},{"$f":"Administration!B23","v":"Homework"},{"$f":"Administration!B24","v":"Homework"},{"$f":"Administration!B25","v":"Homework"},{"$f":"Administration!B26","v":"Homework"}]
[{"$f":"Labels!B12","v":"Assignment Weights"},{"$f":"'All Grades'!B8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!C8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!D8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!E8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!F8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!G8","v":{"v":1,"d":"1.0"}}]
[]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B18","v":"Grades (Curve)"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"'Grades - Curved'!B14","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C14","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D14","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E14","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F14","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G14","v":{"$error":"#DIV/0!"}},{"$f":"H35/H46","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"'Grades - Curved'!B15","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C15","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D15","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E15","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F15","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"'Grades - Curved'!B16","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C16","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D16","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E16","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F16","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G16","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"'Grades - Curved'!B17","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C17","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D17","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E17","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F17","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"'Grades - Curved'!B18","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C18","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D18","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E18","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F18","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G18","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"B40/B51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"\"A negative entry means a student did not participate in an assignment; no grade is included in averages.\"","v":"A negative entry means a student did not participate in an assignment; no grade is included in averages."}]
[]
[{"$f":"\"Student Participation\"","v":"Student Participation"}]
[{"$f":"\" \"","v":" "}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B33","v":"Participation by Assignment"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"'All Grades'!B34","v":1},{"$f":"'All Grades'!C34","v":1},{"$f":"'All Grades'!D34","v":1},{"$f":"'All Grades'!E34","v":1},{"$f":"'All Grades'!F34","v":1},{"$f":"'All Grades'!G34","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"'All Grades'!B35","v":1},{"$f":"'All Grades'!C35","v":1},{"$f":"'All Grades'!D35","v":1},{"$f":"'All Grades'!E35","v":1},{"$f":"'All Grades'!F35","v":1},{"$f":"'All Grades'!G35","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"'All Grades'!B36","v":1},{"$f":"'All Grades'!C36","v":1},{"$f":"'All Grades'!D36","v":1},{"$f":"'All Grades'!E36","v":1},{"$f":"'All Grades'!F36","v":1},{"$f":"'All Grades'!G36","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"'All Grades'!B37","v":1},{"$f":"'All Grades'!C37","v":1},{"$f":"'All Grades'!D37","v":1},{"$f":"'All Grades'!E37","v":1},{"$f":"'All Grades'!F37","v":1},{"$f":"'All Grades'!G37","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"'All Grades'!B38","v":1},{"$f":"'All Grades'!C38","v":1},{"$f":"'All Grades'!D38","v":1},{"$f":"'All Grades'!E38","v":1},{"$f":"'All Grades'!F38","v":1},{"$f":"'All Grades'!G38","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1}]
[]
[{"$f":"\"Quality Points\"","v":"Quality Points"}]
[{"$f":"\" \"","v":" "}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B36","v":"Quality Points (Curve)"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"'Grades - Curved'!B49","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C49","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D49","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E49","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F49","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G49","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B35:G35)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"'Grades - Curved'!B50","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C50","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D50","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E50","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F50","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G50","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B36:G36)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"'Grades - Curved'!B51","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C51","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D51","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E51","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F51","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G51","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B37:G37)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"'Grades - Curved'!B52","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C52","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D52","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E52","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F52","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G52","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B38:G38)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"'Grades - Curved'!B53","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C53","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D53","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E53","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F53","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G53","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B39:G39)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B35:B39)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[{"$f":"\"Quality Weights\"","v":"Quality Weights"}]
[{"$f":"\" \"","v":" "}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B37","v":"Quality Weights"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"'All Grades'!B68","v":1},{"$f":"'All Grades'!C68","v":1},{"$f":"'All Grades'!D68","v":1},{"$f":"'All Grades'!E68","v":1},{"$f":"'All Grades'!F68","v":1},{"$f":"'All Grades'!G68","v":1},{"$f":"SUM(B46:G46)","v":6}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"'All Grades'!B69","v":1},{"$f":"'All Grades'!C69","v":1},{"$f":"'All Grades'!D69","v":1},{"$f":"'All Grades'!E69","v":1},{"$f":"'All Grades'!F69","v":1},{"$f":"'All Grades'!G69","v":1},{"$f":"SUM(B47:G47)","v":6}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"'All Grades'!B70","v":1},{"$f":"'All Grades'!C70","v":1},{"$f":"'All Grades'!D70","v":1},{"$f":"'All Grades'!E70","v":1},{"$f":"'All Grades'!F70","v":1},{"$f":"'All Grades'!G70","v":1},{"$f":"SUM(B48:G48)","v":6}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"'All Grades'!B71","v":1},{"$f":"'All Grades'!C71","v":1},{"$f":"'All Grades'!D71","v":1},{"$f":"'All Grades'!E71","v":1},{"$f":"'All Grades'!F71","v":1},{"$f":"'All Grades'!G71","v":1},{"$f":"SUM(B49:G49)","v":6}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"'All Grades'!B72","v":1},{"$f":"'All Grades'!C72","v":1},{"$f":"'All Grades'!D72","v":1},{"$f":"'All Grades'!E72","v":1},{"$f":"'All Grades'!F72","v":1},{"$f":"'All Grades'!G72","v":1},{"$f":"SUM(B50:G50)","v":6}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B46:B50)","v":5},5,5,5,5,5,30]
[]
[{"$f":"\"Student Consistency\"","v":"Student Consistency"}]
[{"$f":"Labels!B43","v":"Std Deviation (Curve)"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"SQRT('(Other Variables)'!B151)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"SQRT('(Other Variables)'!B152)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"SQRT('(Other Variables)'!B153)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"SQRT('(Other Variables)'!B154)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"SQRT('(Other Variables)'!B155)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SQRT('(Other Variables)'!B156)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Class Section - Curved 2","index":13,"n_rows":60,"n_cols":8,"rows_kept":60,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[17,0,17,7],[19,0,19,1],[20,0,20,1],[30,0,30,1],[31,0,31,1],[41,0,41,1],[42,0,42,1],[52,0,52,1]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"Class Section - Curved 2\"","v":"Class Section - Curved 2"}]
[{"$f":"\"\"","v":""}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"}]
[{"$f":"Labels!B11","v":"Assignment Type"},{"$f":"Administration!B21","v":"Homework"},{"$f":"Administration!B22","v":"Homework"},{"$f":"Administration!B23","v":"Homework"},{"$f":"Administration!B24","v":"Homework"},{"$f":"Administration!B25","v":"Homework"},{"$f":"Administration!B26","v":"Homework"}]
[{"$f":"Labels!B12","v":"Assignment Weights"},{"$f":"'All Grades'!B8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!C8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!D8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!E8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!F8","v":{"v":1,"d":"1.0"}},{"$f":"'All Grades'!G8","v":{"v":1,"d":"1.0"}}]
[]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B18","v":"Grades (Curve)"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"'Grades - Curved'!B21","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C21","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D21","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E21","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F21","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G21","v":{"$error":"#DIV/0!"}},{"$f":"H35/H46","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"'Grades - Curved'!B22","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C22","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D22","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E22","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F22","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G22","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"'Grades - Curved'!B23","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C23","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D23","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E23","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F23","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"'Grades - Curved'!B24","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C24","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D24","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E24","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F24","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G24","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"'Grades - Curved'!B25","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C25","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D25","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E25","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F25","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"B40/B51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"\"A negative entry means a student did not participate in an assignment; no grade is included in averages.\"","v":"A negative entry means a student did not participate in an assignment; no grade is included in averages."}]
[]
[{"$f":"\"Student Participation\"","v":"Student Participation"}]
[{"$f":"\" \"","v":" "}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B33","v":"Participation by Assignment"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"'All Grades'!B41","v":1},{"$f":"'All Grades'!C41","v":1},{"$f":"'All Grades'!D41","v":1},{"$f":"'All Grades'!E41","v":1},{"$f":"'All Grades'!F41","v":1},{"$f":"'All Grades'!G41","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"'All Grades'!B42","v":1},{"$f":"'All Grades'!C42","v":1},{"$f":"'All Grades'!D42","v":1},{"$f":"'All Grades'!E42","v":1},{"$f":"'All Grades'!F42","v":1},{"$f":"'All Grades'!G42","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"'All Grades'!B43","v":1},{"$f":"'All Grades'!C43","v":1},{"$f":"'All Grades'!D43","v":1},{"$f":"'All Grades'!E43","v":1},{"$f":"'All Grades'!F43","v":1},{"$f":"'All Grades'!G43","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"'All Grades'!B44","v":1},{"$f":"'All Grades'!C44","v":1},{"$f":"'All Grades'!D44","v":1},{"$f":"'All Grades'!E44","v":1},{"$f":"'All Grades'!F44","v":1},{"$f":"'All Grades'!G44","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"'All Grades'!B45","v":1},{"$f":"'All Grades'!C45","v":1},{"$f":"'All Grades'!D45","v":1},{"$f":"'All Grades'!E45","v":1},{"$f":"'All Grades'!F45","v":1},{"$f":"'All Grades'!G45","v":1},{"$f":"1","v":1}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1},{"$f":"1","v":1}]
[]
[{"$f":"\"Quality Points\"","v":"Quality Points"}]
[{"$f":"\" \"","v":" "}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B36","v":"Quality Points (Curve)"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"'Grades - Curved'!B56","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C56","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D56","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E56","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F56","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G56","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B35:G35)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"'Grades - Curved'!B57","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C57","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D57","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E57","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F57","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G57","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B36:G36)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"'Grades - Curved'!B58","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C58","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D58","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E58","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F58","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G58","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B37:G37)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"'Grades - Curved'!B59","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C59","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D59","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E59","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F59","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G59","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B38:G38)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"'Grades - Curved'!B60","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!C60","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!D60","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!E60","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!F60","v":{"$error":"#DIV/0!"}},{"$f":"'Grades - Curved'!G60","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B39:G39)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B35:B39)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[{"$f":"\"Quality Weights\"","v":"Quality Weights"}]
[{"$f":"\" \"","v":" "}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B37","v":"Quality Weights"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"'All Grades'!B75","v":1},{"$f":"'All Grades'!C75","v":1},{"$f":"'All Grades'!D75","v":1},{"$f":"'All Grades'!E75","v":1},{"$f":"'All Grades'!F75","v":1},{"$f":"'All Grades'!G75","v":1},{"$f":"SUM(B46:G46)","v":6}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"'All Grades'!B76","v":1},{"$f":"'All Grades'!C76","v":1},{"$f":"'All Grades'!D76","v":1},{"$f":"'All Grades'!E76","v":1},{"$f":"'All Grades'!F76","v":1},{"$f":"'All Grades'!G76","v":1},{"$f":"SUM(B47:G47)","v":6}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"'All Grades'!B77","v":1},{"$f":"'All Grades'!C77","v":1},{"$f":"'All Grades'!D77","v":1},{"$f":"'All Grades'!E77","v":1},{"$f":"'All Grades'!F77","v":1},{"$f":"'All Grades'!G77","v":1},{"$f":"SUM(B48:G48)","v":6}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"'All Grades'!B78","v":1},{"$f":"'All Grades'!C78","v":1},{"$f":"'All Grades'!D78","v":1},{"$f":"'All Grades'!E78","v":1},{"$f":"'All Grades'!F78","v":1},{"$f":"'All Grades'!G78","v":1},{"$f":"SUM(B49:G49)","v":6}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"'All Grades'!B79","v":1},{"$f":"'All Grades'!C79","v":1},{"$f":"'All Grades'!D79","v":1},{"$f":"'All Grades'!E79","v":1},{"$f":"'All Grades'!F79","v":1},{"$f":"'All Grades'!G79","v":1},{"$f":"SUM(B50:G50)","v":6}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B46:B50)","v":5},5,5,5,5,5,30]
[]
[{"$f":"\"Student Consistency\"","v":"Student Consistency"}]
[{"$f":"Labels!B43","v":"Std Deviation (Curve)"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"SQRT('(Other Variables)'!B158)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"SQRT('(Other Variables)'!B159)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"SQRT('(Other Variables)'!B160)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"SQRT('(Other Variables)'!B161)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"SQRT('(Other Variables)'!B162)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SQRT('(Other Variables)'!B163)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Formulas","index":14,"n_rows":97,"n_cols":5,"rows_kept":97,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"Formulas\"","v":"Formulas"}]
[{"$f":"\"\"","v":""}]
["Variable","Display As","Dimension Index",null,"Formula / Data"]
["Academic_Subject",{"$f":"Labels!B7","v":"Academic Subject"}]
[]
["Academic_Term",{"$f":"Labels!B8","v":"Academic Term"}]
[]
["Assign_Type_Weights",{"$f":"Labels!B9","v":"Assign Type Weights"}]
[]
["Assign_Types_Dim",{"$f":"Labels!B10","v":"Assign_Types"},"Assign_Types","Data:","diminfo(\"Assign_Types\", 0)"]
[]
["Assignment_Type",{"$f":"Labels!B11","v":"Assignment Type"},"Assignments","Data:","index(ranged(\"Assign_Types\", Assign_Types_Dim), 1)"]
[]
["Assignment_Weights",{"$f":"Labels!B12","v":"Assignment Weights"},"Assignments","Data:","index(ranged(\"Assign_Types\", Assign_Type_Weights, true), match(Assignment_Type, ranged(\"Assign_Types\", Assign_Types_Dim, true), 0))"]
[]
["Assignments",{"$f":"Labels!B13","v":"Assignments"},"Assignments","Data:","diminfo(\"Assignments\", 0)"]
[]
["Assignments_dim",{"$f":"Labels!B14","v":"Assignments_dim"},"Assignments","Data:","diminfo(\"Assignments\", 7, \", \")"]
[]
["Fees_Assessed",{"$f":"Labels!B15","v":"Fees Assessed"}]
[]
["Fees_Paid",{"$f":"Labels!B16","v":"Fees Paid"}]
[]
["Grades",{"$f":"Labels!B17","v":"Grades"},"Assignments, Students","Roll-up:","Quality_Points/Quality_Weights"]
[]
["Grades_Curve",{"$f":"Labels!B18","v":"Grades (Curve)"},"Students, Assignments","Data:","if(Grades<0, Grades, max(Min_Grade_Curve, min(Max_Grade_Curve, (Grades-Mean_Grade_by_Assignment)*Std_Dev_Grades_by_Assign_Curve/Std_Dev_Grades_by_Assignment)+Mean_Grade_by_Assign_Curve))"]
[{"$nulls":3},"Roll-up:","Quality_Points_Curve/Quality_Weights"]
[]
["Grades_Curve_Norm_Wtd",{"$f":"Labels!B19","v":"Curved Grades Norm Wtd"},"Students, Assignments","Data:","max(0, Grades_Curve)*Quality_Norm_Wgts"]
[]
["Grades_Norm_Wtd",{"$f":"Labels!B20","v":"Grades Norm Wtd"},"Students, Assignments","Data:","max(0, Grades)*Quality_Norm_Wgts"]
[]
["Grades2_Wtd",{"$f":"Labels!B21","v":"Grades2 Wtd"},"Students, Assignments","Data:","max(0, Grades)^2*Quality_Weights"]
[]
["Grades2_Wtd_Curve",{"$f":"Labels!B22","v":"Grades2 Wtd (Curve)"},"Students, Assignments","Data:","max(0, Grades_Curve)^2*Quality_Weights"]
[]
["Kurt_Grades_by_Assign_Curve",{"$f":"Labels!B23","v":"Kurtosis (Curved)"},"Assignments","Data:","kurt(ranged(\"Students\", Grades_Curve, true))"]
[]
["Kurt_Grades_by_Assignment",{"$f":"Labels!B24","v":"Kurtosis"},"Assignments","Data:","kurt(ranged(\"Students\", Grades, true))"]
[]
["Max_Grade_Curve",{"$f":"Labels!B25","v":"Max Grade (Curve)"}]
[]
["Mean_Grade",{"$f":"Labels!B26","v":"Mean Grade"},"Global","Data:","averager(ranged(\"Students\", Mean_Grade_by_Student, true))"]
[]
["Mean_Grade_by_Assign_Curve",{"$f":"Labels!B27","v":"Mean Grade (Curve)"},"Assignments","Data:","Mean_Grade_by_Assignment"]
[]
["Mean_Grade_by_Assignment",{"$f":"Labels!B28","v":"Mean Grade"},"Assignments","Data:","sumr(ranged(\"Students\", Quality_Points, true))/sumr(ranged(\"Students\", Quality_Weights, true))"]
[]
["Mean_Grade_by_Stud_Curve",{"$f":"Labels!B29","v":"Mean Grade (Curve)"},"Students","Roll-up:","sumr(ranged(\"Assignments\", Quality_Points_Curve, true))/sumr(ranged(\"Assignments\", Quality_Weights, true))"]
[]
["Mean_Grade_by_Student",{"$f":"Labels!B30","v":"Mean Grade"},"Students","Roll-up:","sumr(ranged(\"Assignments\", Quality_Points, true))/sumr(ranged(\"Assignments\", Quality_Weights, true))"]
[]
["Mean_Grade_Curve",{"$f":"Labels!B31","v":"Mean Grade (Curve)"},"Global","Data:","averager(ranged(\"Students\", Mean_Grade_by_Stud_Curve, true))"]
[]
["Min_Grade_Curve",{"$f":"Labels!B32","v":"Min Grade (Curve)"}]
[]
["Participation",{"$f":"Labels!B33","v":"Participation by Assignment"},"Assignments, Students","Data:","if(Grades<0, 0, 1)"]
[{"$nulls":3},"Roll-up:","1"]
[]
["Quality_Norm_Wgts",{"$f":"Labels!B34","v":"Normalized Quality Wgts"},"Assignments, Students","Data:","Quality_Weights/sumr(ranged(\"Assignments\", Quality_Weights, true))"]
[]
["Quality_Points",{"$f":"Labels!B35","v":"Quality Points"},"Students, Assignments","Data:","Grades*Quality_Weights"]
[]
["Quality_Points_Curve",{"$f":"Labels!B36","v":"Quality Points (Curve)"},"Students, Assignments","Data:","Grades_Curve*Quality_Weights"]
[]
["Quality_Weights",{"$f":"Labels!B37","v":"Quality Weights"},"Students, Assignments","Data:","Assignment_Weights*Participation"]
[]
["School_Name",{"$f":"Labels!B38","v":"School Name"}]
[]
["Skew_Grades_by_Assign_Curve",{"$f":"Labels!B39","v":"Skewness (Curve)"},"Assignments","Roll-up:","skew(ranged(\"Students\", Grades_Curve, true))"]
[]
["Skew_Grades_by_Assignment",{"$f":"Labels!B40","v":"Skewness"},"Assignments","Roll-up:","skew(ranged(\"Students\", Grades, true))"]
[]
["Std_Dev_Grades_by_Assign_Curve",{"$f":"Labels!B41","v":"Std Dev of Grades (Curve)"},"Assignments","Data:","stdev(ranged(\"Students\", Grades, true))"]
[]
["Std_Dev_Grades_by_Assignment",{"$f":"Labels!B42","v":"Std Deviation"},"Assignments","Roll-up:","stdev(ranged(\"Students\", Grades, true))"]
[]
["Std_Dev_Grades_by_Stud_Curve",{"$f":"Labels!B43","v":"Std Deviation (Curve)"},"Students","Roll-up:","sqrt(Var_Grades_by_Stud_Curve)"]
[]
["Std_Dev_Grades_by_Student",{"$f":"Labels!B44","v":"Std Deviation"},"Students","Roll-up:","sqrt(Var_Grades_by_Student)"]
[]
["Students_dim",{"$f":"Labels!B45","v":"Students_dim"},"Students","Data:","diminfo(\"Students\", 7, \", \")"]
[]
["Teacher_Name",{"$f":"Labels!B46","v":"Teacher Name"}]
[]
["Var_Grades_by_Stud_Curve",{"$f":"Labels!B47","v":"Var Grades by Student"},"Students","Data:","Var_Grades_by_Stud_Curve_Num/Var_Grades_by_Student_Den"]
[]
["Var_Grades_by_Stud_Curve_Num",{"$f":"Labels!B48","v":"Var Grades by Student Num"},"Students","Data:","sumr(ranged(\"Assignments\", Grades2_Wtd_Curve, true))-sumr(ranged(\"Assignments\", Quality_Weights, true))*sumr(ranged(\"Assignments\", Grades_Curve_Norm_Wtd, true))^2"]
[]
["Var_Grades_by_Student",{"$f":"Labels!B49","v":"Var Grades by Student"},"Students","Data:","Var_Grades_by_Student_Num/Var_Grades_by_Student_Den"]
[]
["Var_Grades_by_Student_Den",{"$f":"Labels!B50","v":"Var Grades by Student Den"},"Students","Data:","sumr(ranged(\"Assignments\", Quality_Weights, true))-1"]
[]
["Var_Grades_by_Student_Num",{"$f":"Labels!B51","v":"Var Grades by Student Num"},"Students","Data:","sumr(ranged(\"Assignments\", Grades2_Wtd, true))-sumr(ranged(\"Assignments\", Quality_Weights, true))*sumr(ranged(\"Assignments\", Grades_Norm_Wtd, true))^2"]

{"sheet":"Plot Vars","index":15,"n_rows":20,"n_cols":5,"rows_kept":20,"hidden":true,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,0,6,3]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"Plot Vars\"","v":"Plot Vars"}]
[{"$f":"\"\"","v":""}]
[{"$f":"\"Plot Support\"","v":"Plot Support"}]
[{"$f":"\"\"","v":""}]
[{"$f":"Labels!B45","v":"Students_dim"},null,null,{"$f":"Labels!B14","v":"Assignments_dim"}]
[{"$f":"\"   \"&Labels!B68","v":"   Section 1"},null,null,{"$f":"\"   \"&Labels!B60","v":"   Homework 1"},{"$f":"Labels!B60","v":"Homework 1"}]
[{"$f":"\"      \"&Labels!B69","v":"      Student101"},{"$f":"Labels!B68&\", \"&Labels!B69","v":"Section 1, Student101"},null,{"$f":"\"   \"&Labels!B61","v":"   Class report"},{"$f":"Labels!B61","v":"Class report"}]
[{"$f":"\"      \"&Labels!B70","v":"      Student102"},{"$f":"Labels!B68&\", \"&Labels!B70","v":"Section 1, Student102"},null,{"$f":"\"   \"&Labels!B62","v":"   Quiz 1"},{"$f":"Labels!B62","v":"Quiz 1"}]
[{"$f":"\"      \"&Labels!B71","v":"      Student103"},{"$f":"Labels!B68&\", \"&Labels!B71","v":"Section 1, Student103"},null,{"$f":"\"   \"&Labels!B63","v":"   Homework 2"},{"$f":"Labels!B63","v":"Homework 2"}]
[{"$f":"\"      \"&Labels!B72","v":"      Student104"},{"$f":"Labels!B68&\", \"&Labels!B72","v":"Section 1, Student104"},null,{"$f":"\"   \"&Labels!B64","v":"   Quiz 2"},{"$f":"Labels!B64","v":"Quiz 2"}]
[{"$f":"\"      \"&Labels!B73","v":"      Student105"},{"$f":"Labels!B68&\", \"&Labels!B73","v":"Section 1, Student105"},null,{"$f":"\"   \"&Labels!B65","v":"   Test"},{"$f":"Labels!B65","v":"Test"}]
[{"$f":"\"   \"&Labels!B74","v":"   Section 2"}]
[{"$f":"\"      \"&Labels!B75","v":"      Student201"},{"$f":"Labels!B74&\", \"&Labels!B75","v":"Section 2, Student201"}]
[{"$f":"\"      \"&Labels!B76","v":"      Student202"},{"$f":"Labels!B74&\", \"&Labels!B76","v":"Section 2, Student202"}]
[{"$f":"\"      \"&Labels!B77","v":"      Student203"},{"$f":"Labels!B74&\", \"&Labels!B77","v":"Section 2, Student203"}]
[{"$f":"\"      \"&Labels!B78","v":"      Student204"},{"$f":"Labels!B74&\", \"&Labels!B78","v":"Section 2, Student204"}]
[{"$f":"\"      \"&Labels!B79","v":"      Student205"},{"$f":"Labels!B74&\", \"&Labels!B79","v":"Section 2, Student205"}]

{"sheet":"(Other Variables)","index":16,"n_rows":215,"n_cols":8,"rows_kept":215,"hidden":true,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"(Other Variables)\"","v":"(Other Variables)"}]
[{"$f":"\"\"","v":""}]
[{"$f":"Labels!B10","v":"Assign_Types"}]
[]
[{"$f":"Labels!B55","v":"Homework"},{"$f":"Labels!B55","v":"Homework"}]
[{"$f":"Labels!B56","v":"Quiz"},{"$f":"Labels!B56","v":"Quiz"}]
[{"$f":"Labels!B57","v":"Test"},{"$f":"Labels!B57","v":"Test"}]
[{"$f":"Labels!B39","v":"Skewness (Curve)"}]
[]
[{"$f":"Labels!B60","v":"Homework 1"},{"$f":"'Assignments - Curved'!D10","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B61","v":"Class report"},{"$f":"'Assignments - Curved'!D11","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"'Assignments - Curved'!D12","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B63","v":"Homework 2"},{"$f":"'Assignments - Curved'!D13","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"'Assignments - Curved'!D14","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B65","v":"Test"},{"$f":"'Assignments - Curved'!D15","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!C59","v":"Total"},{"$f":"SKEW('Grades - Curved'!H14:H18,'Grades - Curved'!H21:H25)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B23","v":"Kurtosis (Curved)"}]
[]
[{"$f":"Labels!B60","v":"Homework 1"},{"$f":"'Assignments - Curved'!E10","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B61","v":"Class report"},{"$f":"'Assignments - Curved'!E11","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"'Assignments - Curved'!E12","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B63","v":"Homework 2"},{"$f":"'Assignments - Curved'!E13","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"'Assignments - Curved'!E14","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B65","v":"Test"},{"$f":"'Assignments - Curved'!E15","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!C59","v":"Total"},{"$f":"AVERAGE(B22:B27)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B49","v":"Var Grades by Student"}]
[]
[{"$f":"Labels!B68","v":"Section 1"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"B49/B117","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"B50/B118","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"B51/B119","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"B52/B120","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"B53/B121","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B32:B36)","v":{"v":0,"d":"0.00"}}]
[{"$f":"Labels!B74","v":"Section 2"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"B56/B124","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"B57/B125","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"B58/B126","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"B59/B127","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"B60/B128","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B39:B43)","v":{"v":0,"d":"0.00"}}]
[{"$f":"Labels!C67","v":"Total"},{"$f":"SUM(B37,B44)","v":{"v":0,"d":"0.00"}}]
[{"$f":"Labels!B51","v":"Var Grades by Student Num"}]
[]
[{"$f":"Labels!B68","v":"Section 1"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"SUM(B66:G66)-SUM('All Grades'!B68:G68)*SUM(B83:G83)^2","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"SUM(B67:G67)-SUM('All Grades'!B69:G69)*SUM(B84:G84)^2","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"SUM(B68:G68)-SUM('All Grades'!B70:G70)*SUM(B85:G85)^2","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"SUM(B69:G69)-SUM('All Grades'!B71:G71)*SUM(B86:G86)^2","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"SUM(B70:G70)-SUM('All Grades'!B72:G72)*SUM(B87:G87)^2","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B49:B53)","v":{"v":0,"d":"0.00"}}]
[{"$f":"Labels!B74","v":"Section 2"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"SUM(B73:G73)-SUM('All Grades'!B75:G75)*SUM(B90:G90)^2","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"SUM(B74:G74)-SUM('All Grades'!B76:G76)*SUM(B91:G91)^2","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"SUM(B75:G75)-SUM('All Grades'!B77:G77)*SUM(B92:G92)^2","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"SUM(B76:G76)-SUM('All Grades'!B78:G78)*SUM(B93:G93)^2","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"SUM(B77:G77)-SUM('All Grades'!B79:G79)*SUM(B94:G94)^2","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B56:B60)","v":{"v":0,"d":"0.00"}}]
[{"$f":"Labels!C67","v":"Total"},{"$f":"SUM(B54,B61)","v":{"v":0,"d":"0.00"}}]
[{"$f":"Labels!B21","v":"Grades2 Wtd"}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B68","v":"Section 1"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"MAX(0,'All Grades'!B16)^2*'All Grades'!B68","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C16)^2*'All Grades'!C68","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D16)^2*'All Grades'!D68","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E16)^2*'All Grades'!E68","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F16)^2*'All Grades'!F68","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G16)^2*'All Grades'!G68","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B66:G66)","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"MAX(0,'All Grades'!B17)^2*'All Grades'!B69","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C17)^2*'All Grades'!C69","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D17)^2*'All Grades'!D69","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E17)^2*'All Grades'!E69","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F17)^2*'All Grades'!F69","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G17)^2*'All Grades'!G69","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"MAX(0,'All Grades'!B18)^2*'All Grades'!B70","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C18)^2*'All Grades'!C70","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D18)^2*'All Grades'!D70","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E18)^2*'All Grades'!E70","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F18)^2*'All Grades'!F70","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G18)^2*'All Grades'!G70","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"MAX(0,'All Grades'!B19)^2*'All Grades'!B71","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C19)^2*'All Grades'!C71","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D19)^2*'All Grades'!D71","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E19)^2*'All Grades'!E71","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F19)^2*'All Grades'!F71","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G19)^2*'All Grades'!G71","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"MAX(0,'All Grades'!B20)^2*'All Grades'!B72","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C20)^2*'All Grades'!C72","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D20)^2*'All Grades'!D72","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E20)^2*'All Grades'!E72","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F20)^2*'All Grades'!F72","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G20)^2*'All Grades'!G72","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B66:B70)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$f":"Labels!B74","v":"Section 2"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"MAX(0,'All Grades'!B23)^2*'All Grades'!B75","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C23)^2*'All Grades'!C75","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D23)^2*'All Grades'!D75","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E23)^2*'All Grades'!E75","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F23)^2*'All Grades'!F75","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G23)^2*'All Grades'!G75","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B73:G73)","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"MAX(0,'All Grades'!B24)^2*'All Grades'!B76","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C24)^2*'All Grades'!C76","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D24)^2*'All Grades'!D76","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E24)^2*'All Grades'!E76","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F24)^2*'All Grades'!F76","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G24)^2*'All Grades'!G76","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"MAX(0,'All Grades'!B25)^2*'All Grades'!B77","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C25)^2*'All Grades'!C77","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D25)^2*'All Grades'!D77","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E25)^2*'All Grades'!E77","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F25)^2*'All Grades'!F77","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G25)^2*'All Grades'!G77","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"MAX(0,'All Grades'!B26)^2*'All Grades'!B78","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C26)^2*'All Grades'!C78","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D26)^2*'All Grades'!D78","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E26)^2*'All Grades'!E78","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F26)^2*'All Grades'!F78","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G26)^2*'All Grades'!G78","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"MAX(0,'All Grades'!B27)^2*'All Grades'!B79","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C27)^2*'All Grades'!C79","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D27)^2*'All Grades'!D79","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E27)^2*'All Grades'!E79","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F27)^2*'All Grades'!F79","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G27)^2*'All Grades'!G79","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B73:B77)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$f":"Labels!C67","v":"Total"},{"$f":"SUM(B71,B78)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$f":"Labels!B20","v":"Grades Norm Wtd"}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B68","v":"Section 1"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"MAX(0,'All Grades'!B16)*B100","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C16)*C100","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D16)*D100","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E16)*E100","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F16)*F100","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G16)*G100","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B83:G83)","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"MAX(0,'All Grades'!B17)*B101","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C17)*C101","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D17)*D101","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E17)*E101","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F17)*F101","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G17)*G101","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"MAX(0,'All Grades'!B18)*B102","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C18)*C102","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D18)*D102","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E18)*E102","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F18)*F102","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G18)*G102","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"MAX(0,'All Grades'!B19)*B103","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C19)*C103","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D19)*D103","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E19)*E103","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F19)*F103","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G19)*G103","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"MAX(0,'All Grades'!B20)*B104","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C20)*C104","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D20)*D104","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E20)*E104","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F20)*F104","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G20)*G104","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B83:B87)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$f":"Labels!B74","v":"Section 2"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"MAX(0,'All Grades'!B23)*B107","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C23)*C107","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D23)*D107","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E23)*E107","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F23)*F107","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G23)*G107","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B90:G90)","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"MAX(0,'All Grades'!B24)*B108","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C24)*C108","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D24)*D108","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E24)*E108","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F24)*F108","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G24)*G108","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"MAX(0,'All Grades'!B25)*B109","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C25)*C109","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D25)*D109","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E25)*E109","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F25)*F109","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G25)*G109","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"MAX(0,'All Grades'!B26)*B110","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C26)*C110","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D26)*D110","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E26)*E110","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F26)*F110","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G26)*G110","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"MAX(0,'All Grades'!B27)*B111","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!C27)*C111","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!D27)*D111","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!E27)*E111","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!F27)*F111","v":{"v":0,"d":"0.00"}},{"$f":"MAX(0,'All Grades'!G27)*G111","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B90:B94)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$f":"Labels!C67","v":"Total"},{"$f":"SUM(B88,B95)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$f":"Labels!B34","v":"Normalized Quality Wgts"}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B68","v":"Section 1"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"'All Grades'!B68/SUM('All Grades'!B68:G68)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!C68/SUM('All Grades'!B68:G68)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!D68/SUM('All Grades'!B68:G68)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!E68/SUM('All Grades'!B68:G68)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!F68/SUM('All Grades'!B68:G68)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!G68/SUM('All Grades'!B68:G68)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"SUM(B100:G100)","v":{"v":0.9999999999999999,"d":"1.00"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"'All Grades'!B69/SUM('All Grades'!B69:G69)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!C69/SUM('All Grades'!B69:G69)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!D69/SUM('All Grades'!B69:G69)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!E69/SUM('All Grades'!B69:G69)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!F69/SUM('All Grades'!B69:G69)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!G69/SUM('All Grades'!B69:G69)","v":{"v":0.16666666666666666,"d":"0.17"}},{"v":0.9999999999999999,"d":"1.00"}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"'All Grades'!B70/SUM('All Grades'!B70:G70)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!C70/SUM('All Grades'!B70:G70)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!D70/SUM('All Grades'!B70:G70)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!E70/SUM('All Grades'!B70:G70)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!F70/SUM('All Grades'!B70:G70)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!G70/SUM('All Grades'!B70:G70)","v":{"v":0.16666666666666666,"d":"0.17"}},{"v":0.9999999999999999,"d":"1.00"}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"'All Grades'!B71/SUM('All Grades'!B71:G71)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!C71/SUM('All Grades'!B71:G71)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!D71/SUM('All Grades'!B71:G71)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!E71/SUM('All Grades'!B71:G71)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!F71/SUM('All Grades'!B71:G71)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!G71/SUM('All Grades'!B71:G71)","v":{"v":0.16666666666666666,"d":"0.17"}},{"v":0.9999999999999999,"d":"1.00"}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"'All Grades'!B72/SUM('All Grades'!B72:G72)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!C72/SUM('All Grades'!B72:G72)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!D72/SUM('All Grades'!B72:G72)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!E72/SUM('All Grades'!B72:G72)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!F72/SUM('All Grades'!B72:G72)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!G72/SUM('All Grades'!B72:G72)","v":{"v":0.16666666666666666,"d":"0.17"}},{"v":0.9999999999999999,"d":"1.00"}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B100:B104)","v":{"v":0.8333333333333333,"d":"0.83"}},{"v":0.8333333333333333,"d":"0.83"},{"v":0.8333333333333333,"d":"0.83"},{"v":0.8333333333333333,"d":"0.83"},{"v":0.8333333333333333,"d":"0.83"},{"v":0.8333333333333333,"d":"0.83"},{"v":4.999999999999999,"d":"5.00"}]
[{"$f":"Labels!B74","v":"Section 2"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"'All Grades'!B75/SUM('All Grades'!B75:G75)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!C75/SUM('All Grades'!B75:G75)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!D75/SUM('All Grades'!B75:G75)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!E75/SUM('All Grades'!B75:G75)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!F75/SUM('All Grades'!B75:G75)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!G75/SUM('All Grades'!B75:G75)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"SUM(B107:G107)","v":{"v":0.9999999999999999,"d":"1.00"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"'All Grades'!B76/SUM('All Grades'!B76:G76)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!C76/SUM('All Grades'!B76:G76)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!D76/SUM('All Grades'!B76:G76)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!E76/SUM('All Grades'!B76:G76)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!F76/SUM('All Grades'!B76:G76)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!G76/SUM('All Grades'!B76:G76)","v":{"v":0.16666666666666666,"d":"0.17"}},{"v":0.9999999999999999,"d":"1.00"}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"'All Grades'!B77/SUM('All Grades'!B77:G77)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!C77/SUM('All Grades'!B77:G77)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!D77/SUM('All Grades'!B77:G77)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!E77/SUM('All Grades'!B77:G77)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!F77/SUM('All Grades'!B77:G77)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!G77/SUM('All Grades'!B77:G77)","v":{"v":0.16666666666666666,"d":"0.17"}},{"v":0.9999999999999999,"d":"1.00"}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"'All Grades'!B78/SUM('All Grades'!B78:G78)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!C78/SUM('All Grades'!B78:G78)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!D78/SUM('All Grades'!B78:G78)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!E78/SUM('All Grades'!B78:G78)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!F78/SUM('All Grades'!B78:G78)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!G78/SUM('All Grades'!B78:G78)","v":{"v":0.16666666666666666,"d":"0.17"}},{"v":0.9999999999999999,"d":"1.00"}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"'All Grades'!B79/SUM('All Grades'!B79:G79)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!C79/SUM('All Grades'!B79:G79)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!D79/SUM('All Grades'!B79:G79)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!E79/SUM('All Grades'!B79:G79)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!F79/SUM('All Grades'!B79:G79)","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"'All Grades'!G79/SUM('All Grades'!B79:G79)","v":{"v":0.16666666666666666,"d":"0.17"}},{"v":0.9999999999999999,"d":"1.00"}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B107:B111)","v":{"v":0.8333333333333333,"d":"0.83"}},{"v":0.8333333333333333,"d":"0.83"},{"v":0.8333333333333333,"d":"0.83"},{"v":0.8333333333333333,"d":"0.83"},{"v":0.8333333333333333,"d":"0.83"},{"v":0.8333333333333333,"d":"0.83"},{"v":4.999999999999999,"d":"5.00"}]
[{"$f":"Labels!C67","v":"Total"},{"$f":"SUM(B105,B112)","v":{"v":1.6666666666666665,"d":"1.67"}},{"v":1.6666666666666665,"d":"1.67"},{"v":1.6666666666666665,"d":"1.67"},{"v":1.6666666666666665,"d":"1.67"},{"v":1.6666666666666665,"d":"1.67"},{"v":1.6666666666666665,"d":"1.67"},{"v":9.999999999999998,"d":"10.00"}]
[{"$f":"Labels!B50","v":"Var Grades by Student Den"}]
[]
[{"$f":"Labels!B68","v":"Section 1"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"SUM('All Grades'!B68:G68)-1","v":{"v":5,"d":"5.00"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"SUM('All Grades'!B69:G69)-1","v":{"v":5,"d":"5.00"}}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"SUM('All Grades'!B70:G70)-1","v":{"v":5,"d":"5.00"}}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"SUM('All Grades'!B71:G71)-1","v":{"v":5,"d":"5.00"}}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"SUM('All Grades'!B72:G72)-1","v":{"v":5,"d":"5.00"}}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B117:B121)","v":{"v":25,"d":"25.00"}}]
[{"$f":"Labels!B74","v":"Section 2"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"SUM('All Grades'!B75:G75)-1","v":{"v":5,"d":"5.00"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"SUM('All Grades'!B76:G76)-1","v":{"v":5,"d":"5.00"}}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"SUM('All Grades'!B77:G77)-1","v":{"v":5,"d":"5.00"}}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"SUM('All Grades'!B78:G78)-1","v":{"v":5,"d":"5.00"}}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"SUM('All Grades'!B79:G79)-1","v":{"v":5,"d":"5.00"}}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B124:B128)","v":{"v":25,"d":"25.00"}}]
[{"$f":"Labels!C67","v":"Total"},{"$f":"SUM(B122,B129)","v":{"v":50,"d":"50.00"}}]
[{"$f":"Labels!B43","v":"Std Deviation (Curve)"}]
[]
[{"$f":"Labels!B68","v":"Section 1"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"'Class Section - Curved 1'!B55","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"'Class Section - Curved 1'!B56","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"'Class Section - Curved 1'!B57","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"'Class Section - Curved 1'!B58","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"'Class Section - Curved 1'!B59","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SQRT(B156)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B74","v":"Section 2"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"'Class Section - Curved 2'!B55","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"'Class Section - Curved 2'!B56","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"'Class Section - Curved 2'!B57","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"'Class Section - Curved 2'!B58","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"'Class Section - Curved 2'!B59","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SQRT(B163)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!C67","v":"Total"},{"$f":"SQRT(B164)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B47","v":"Var Grades by Student"}]
[]
[{"$f":"Labels!B68","v":"Section 1"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"B168/B117","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"B169/B118","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"B170/B119","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"B171/B120","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"B172/B121","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B151:B155)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B74","v":"Section 2"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"B175/B124","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"B176/B125","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"B177/B126","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"B178/B127","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"B179/B128","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B158:B162)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!C67","v":"Total"},{"$f":"SUM(B156,B163)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B48","v":"Var Grades by Student Num"}]
[]
[{"$f":"Labels!B68","v":"Section 1"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"SUM(B185:G185)-SUM('All Grades'!B68:G68)*SUM(B202:G202)^2","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"SUM(B186:G186)-SUM('All Grades'!B69:G69)*SUM(B203:G203)^2","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"SUM(B187:G187)-SUM('All Grades'!B70:G70)*SUM(B204:G204)^2","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"SUM(B188:G188)-SUM('All Grades'!B71:G71)*SUM(B205:G205)^2","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"SUM(B189:G189)-SUM('All Grades'!B72:G72)*SUM(B206:G206)^2","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B168:B172)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B74","v":"Section 2"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"SUM(B192:G192)-SUM('All Grades'!B75:G75)*SUM(B209:G209)^2","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"SUM(B193:G193)-SUM('All Grades'!B76:G76)*SUM(B210:G210)^2","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"SUM(B194:G194)-SUM('All Grades'!B77:G77)*SUM(B211:G211)^2","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"SUM(B195:G195)-SUM('All Grades'!B78:G78)*SUM(B212:G212)^2","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"SUM(B196:G196)-SUM('All Grades'!B79:G79)*SUM(B213:G213)^2","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B175:B179)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!C67","v":"Total"},{"$f":"SUM(B173,B180)","v":{"$error":"#DIV/0!"}}]
[{"$f":"Labels!B22","v":"Grades2 Wtd (Curve)"}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B68","v":"Section 1"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"MAX(0,'Grades - Curved'!B14)^2*'All Grades'!B68","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C14)^2*'All Grades'!C68","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D14)^2*'All Grades'!D68","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E14)^2*'All Grades'!E68","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F14)^2*'All Grades'!F68","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G14)^2*'All Grades'!G68","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B185:G185)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"MAX(0,'Grades - Curved'!B15)^2*'All Grades'!B69","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C15)^2*'All Grades'!C69","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D15)^2*'All Grades'!D69","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E15)^2*'All Grades'!E69","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F15)^2*'All Grades'!F69","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G15)^2*'All Grades'!G69","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"MAX(0,'Grades - Curved'!B16)^2*'All Grades'!B70","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C16)^2*'All Grades'!C70","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D16)^2*'All Grades'!D70","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E16)^2*'All Grades'!E70","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F16)^2*'All Grades'!F70","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G16)^2*'All Grades'!G70","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"MAX(0,'Grades - Curved'!B17)^2*'All Grades'!B71","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C17)^2*'All Grades'!C71","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D17)^2*'All Grades'!D71","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E17)^2*'All Grades'!E71","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F17)^2*'All Grades'!F71","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G17)^2*'All Grades'!G71","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"MAX(0,'Grades - Curved'!B18)^2*'All Grades'!B72","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C18)^2*'All Grades'!C72","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D18)^2*'All Grades'!D72","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E18)^2*'All Grades'!E72","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F18)^2*'All Grades'!F72","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G18)^2*'All Grades'!G72","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B185:B189)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Labels!B74","v":"Section 2"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"MAX(0,'Grades - Curved'!B21)^2*'All Grades'!B75","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C21)^2*'All Grades'!C75","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D21)^2*'All Grades'!D75","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E21)^2*'All Grades'!E75","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F21)^2*'All Grades'!F75","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G21)^2*'All Grades'!G75","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B192:G192)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"MAX(0,'Grades - Curved'!B22)^2*'All Grades'!B76","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C22)^2*'All Grades'!C76","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D22)^2*'All Grades'!D76","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E22)^2*'All Grades'!E76","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F22)^2*'All Grades'!F76","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G22)^2*'All Grades'!G76","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"MAX(0,'Grades - Curved'!B23)^2*'All Grades'!B77","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C23)^2*'All Grades'!C77","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D23)^2*'All Grades'!D77","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E23)^2*'All Grades'!E77","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F23)^2*'All Grades'!F77","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G23)^2*'All Grades'!G77","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"MAX(0,'Grades - Curved'!B24)^2*'All Grades'!B78","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C24)^2*'All Grades'!C78","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D24)^2*'All Grades'!D78","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E24)^2*'All Grades'!E78","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F24)^2*'All Grades'!F78","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G24)^2*'All Grades'!G78","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"MAX(0,'Grades - Curved'!B25)^2*'All Grades'!B79","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C25)^2*'All Grades'!C79","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D25)^2*'All Grades'!D79","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E25)^2*'All Grades'!E79","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F25)^2*'All Grades'!F79","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G25)^2*'All Grades'!G79","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B192:B196)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Labels!C67","v":"Total"},{"$f":"SUM(B190,B197)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Labels!B19","v":"Curved Grades Norm Wtd"}]
[null,{"$f":"Labels!B60","v":"Homework 1"},{"$f":"Labels!B61","v":"Class report"},{"$f":"Labels!B62","v":"Quiz 1"},{"$f":"Labels!B63","v":"Homework 2"},{"$f":"Labels!B64","v":"Quiz 2"},{"$f":"Labels!B65","v":"Test"},{"$f":"Labels!C59","v":"Total"}]
[{"$f":"Labels!B68","v":"Section 1"}]
[{"$f":"\"   \"&Labels!B69","v":"   Student101"},{"$f":"MAX(0,'Grades - Curved'!B14)*B100","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C14)*C100","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D14)*D100","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E14)*E100","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F14)*F100","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G14)*G100","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B202:G202)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B70","v":"   Student102"},{"$f":"MAX(0,'Grades - Curved'!B15)*B101","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C15)*C101","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D15)*D101","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E15)*E101","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F15)*F101","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G15)*G101","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B71","v":"   Student103"},{"$f":"MAX(0,'Grades - Curved'!B16)*B102","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C16)*C102","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D16)*D102","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E16)*E102","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F16)*F102","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G16)*G102","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B72","v":"   Student104"},{"$f":"MAX(0,'Grades - Curved'!B17)*B103","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C17)*C103","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D17)*D103","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E17)*E103","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F17)*F103","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G17)*G103","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B73","v":"   Student105"},{"$f":"MAX(0,'Grades - Curved'!B18)*B104","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C18)*C104","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D18)*D104","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E18)*E104","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F18)*F104","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G18)*G104","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!C68","v":"   Subtotal"},{"$f":"SUM(B202:B206)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Labels!B74","v":"Section 2"}]
[{"$f":"\"   \"&Labels!B75","v":"   Student201"},{"$f":"MAX(0,'Grades - Curved'!B21)*B107","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C21)*C107","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D21)*D107","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E21)*E107","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F21)*F107","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G21)*G107","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B209:G209)","v":{"$error":"#DIV/0!"}}]
[{"$f":"\"   \"&Labels!B76","v":"   Student202"},{"$f":"MAX(0,'Grades - Curved'!B22)*B108","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C22)*C108","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D22)*D108","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E22)*E108","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F22)*F108","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G22)*G108","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B77","v":"   Student203"},{"$f":"MAX(0,'Grades - Curved'!B23)*B109","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C23)*C109","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D23)*D109","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E23)*E109","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F23)*F109","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G23)*G109","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B78","v":"   Student204"},{"$f":"MAX(0,'Grades - Curved'!B24)*B110","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C24)*C110","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D24)*D110","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E24)*E110","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F24)*F110","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G24)*G110","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!B79","v":"   Student205"},{"$f":"MAX(0,'Grades - Curved'!B25)*B111","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!C25)*C111","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!D25)*D111","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!E25)*E111","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!F25)*F111","v":{"$error":"#DIV/0!"}},{"$f":"MAX(0,'Grades - Curved'!G25)*G111","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[{"$f":"\"   \"&Labels!C74","v":"   Subtotal"},{"$f":"SUM(B209:B213)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Labels!C67","v":"Total"},{"$f":"SUM(B207,B214)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Labels","index":17,"n_rows":79,"n_cols":5,"rows_kept":79,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
[{"$f":"Administration!B10","v":"Middlesex College"}]
[{"$f":"Administration!B11","v":"Dr. Faust"}]
[{"$f":"Administration!B12&\", \"&Administration!B13","v":"Sociology, Spring 2010"}]
[{"$f":"\"Labels\"","v":"Labels"}]
[{"$f":"\"\"","v":""}]
["Variable","Display Label",null,null,"Comment"]
["Academic_Subject","Academic Subject",null,null,"The academic subject for the students and class sections in this gradebook"]
["Academic_Term","Academic Term",null,null,"The academic term for this gradebook"]
["Assign_Type_Weights","Assign Type Weights",null,null,"Weight for each type of assignment, used in weighted average of grades. \n\nYou can enter a descriptive name for each assignment type (such as: homework, quiz, half test, test) on worksheet 'Labels', in the dimension 'Assign Types'; enter names in the blue cells in column B."]
["Assign_Types_Dim","Assign_Types",null,null,"Converts the dimension Assign_Types into an analysis variable for use in lookups. \n\nYou can enter a descriptive name for each assignment type (such as: homework, quiz, half test, test) on worksheet 'Labels', in the dimension 'Assign Types'; enter names in the blue cells in column B."]
["Assignment_Type","Assignment Type",null,null,"The type of each assignment, which determines what weight the assignment has in averages of student grades. Enter one of the names in variable table 'Assign Types'. \n\nYou can enter a descriptive name for each assignment on worksheet 'Labels', in the dimension 'Assignments'; enter names in the blue cells in column B.\n\nYou can enter a descriptive name for each assignment type (such as: homework, quiz, half test, test) on worksheet 'Labels', in the dimension 'Assign Types'; enter names in the blue cells in column B."]
["Assignment_Weights","Assignment Weights",null,null,"The weight of each assignment in the weighted grade point average for each student.\n\nYou can enter student names on worksheet 'Labels', in the dimension 'Students'; enter names in the blue cells in column B.\n\nYou can enter a descriptive name for each assignment on worksheet 'Labels', in the dimension 'Assignments'; enter names in the blue cells in column B."]
["Assignments","Assignments",null,null,"Names of the assignments. \n\nYou can enter a descriptive name for each assignment on worksheet 'Labels', in the dimension 'Assignments'; enter names in the blue cells in column B."]
["Assignments_dim","Assignments_dim",null,null,"Variable containing display names of items in dimension 'Assignments'"]
["Fees_Assessed","Fees Assessed"]
["Fees_Paid","Fees Paid"]
["Grades","Grades",null,null,"Grades for each student on each assignment. A negative number indicates that the student did not do the assignment and gets no grade. Participation is indicated in the same table as grades so the teacher doesn't have to enter this data in two places.\n\nYou can enter student names on worksheet 'Labels', in the dimension 'Students'; enter names in the blue cells in column B."]
["Grades_Curve","Grades (Curve)",null,null,"Grades for each student on each assignment using the grading 'curve'. A negative number indicates that the student did not do the assignment and gets no grade. Participation is indicated in the same table as grades so the teacher doesn't have to enter this data in two places.\n\nYou can enter student names on worksheet 'Labels', in the dimension 'Students'; enter names in the blue cells in column B."]
["Grades_Curve_Norm_Wtd","Curved Grades Norm Wtd",null,null,"Curved grade * quality norm weight, for each student and each assignment"]
["Grades_Norm_Wtd","Grades Norm Wtd",null,null,"Grade * quality norm weight, for each student and each assignment"]
["Grades2_Wtd","Grades2 Wtd",null,null,"Grade^2 * assignment weight"]
["Grades2_Wtd_Curve","Grades2 Wtd (Curve)",null,null,"(Curved grade)^2 * assignment weight"]
["Kurt_Grades_by_Assign_Curve","Kurtosis (Curved)",null,null,"Fn each assignment, the 'kurtosis' of all 'curved' grades.\n\nIf kurtosis <0, the grade distribution has a sharper, narrower peak, and many very high and very low grades. The class may have a wider a range of performance than is optimal.\n\nIf kurtosis >0, the distribution has a flatter, wider peak, and fewer very high and very low grades. The class probably is targeting nearly all students well, leaving few students far behind and few far ahead."]
["Kurt_Grades_by_Assignment","Kurtosis",null,null,"Fn each assignment, the 'kurtosis' of all grades.\n\nIf kurtosis <0, the grade distribution has a sharper, narrower peak, and many very high and very low grades. The class may have a wider a range of performance than is optimal.\n\nIf kurtosis >0, the distribution has a flatter, wider peak, and fewer very high and very low grades. The class probably is targeting nearly all students well, leaving few students far behind and few far ahead."]
["Max_Grade_Curve","Max Grade (Curve)",null,null,"The maximum grade on each assignment when grading on a 'curve'. Any grade that would be higher than this maximum on the curve is set to the maximum allowed value."]
["Mean_Grade","Mean Grade",null,null,"Weighted average grade on all assignments by all students"]
["Mean_Grade_by_Assign_Curve","Mean Grade (Curve)",null,null,"The user-specified mean grade for each assignment when grading on a 'curve'"]
["Mean_Grade_by_Assignment","Mean Grade",null,null,"For each assignment, the average grade for all students"]
["Mean_Grade_by_Stud_Curve","Mean Grade (Curve)",null,null,"For each student, the weighted average 'curved' grade on all assignments.\n\nYou can enter student names on worksheet 'Labels', in the dimension 'Students'; enter in the blue cells in column B."]
["Mean_Grade_by_Student","Mean Grade",null,null,"For each student, the weighted average grade on all assignments.\n\nYou can enter student names on worksheet 'Labels', in the dimension 'Students'; enter in the blue cells in column B."]
["Mean_Grade_Curve","Mean Grade (Curve)",null,null,"Weighted average 'curved' grade on all assignments by all students"]
["Min_Grade_Curve","Min Grade (Curve)",null,null,"The minimum grade on each assignment when grading on a 'curve'. Any grade that would be lower than this manimum on the curve is set to the minimum allowed value."]
["Participation","Participation by Assignment",null,null,"If a student participated in an assignment, 1 else 0"]
["Quality_Norm_Wgts","Normalized Quality Wgts",null,null,"Quality weights, but normalized so the sum over all students is 1 for each assignment."]
["Quality_Points","Quality Points",null,null,"For each student, the weighted sum of grades on all assignments"]
["Quality_Points_Curve","Quality Points (Curve)",null,null,"For each student, the weighted sum of curved grades on all assignments"]
["Quality_Weights","Quality Weights",null,null,"For each assignment and student, this is Assignment weight * Participation index (1 or 0)"]
["School_Name","School Name",null,null,"The name of the school where this gradebook is used"]
["Skew_Grades_by_Assign_Curve","Skewness (Curve)",null,null,"For each assignment, the 'skewness' of the distribution of 'curved' student grades.\n\nIf skewness <0, the distribution has some very low grades and the mean grade < median (50th percentile) grade. A few students may be unable to keep up with the middle of the class.\n\nIf skewness >0, the distribution has some very high grades and the mean grade > 50th percentile grade. A few students may be far ahead of the midde of the class."]
["Skew_Grades_by_Assignment","Skewness",null,null,"For each assignment, the 'skewness' of the distribution of student grades.\n\nIf skewness <0, the distribution has some very low grades and the mean grade < median (50th percentile) grade. A few students may be unable to keep up with the middle of the class.\n\nIf skewness >0, the distribution has some very high grades and the mean grade > 50th percentile grade. A few students may be far ahead of the midde of the class."]
["Std_Dev_Grades_by_Assign_Curve","Std Dev of Grades (Curve)",null,null,"The user-specified standard deviation (spread) of grades for each assignment when grading on a 'curve'"]
["Std_Dev_Grades_by_Assignment","Std Deviation",null,null,"Standard deviation of distribution of student grades on each assignment. \n\nA lower (higher) standard deviation indicates more uniform (more uneven) performance by students on that assignment. The minimum value is zero, which occurs only if all grades on the given assignment are equal."]
["Std_Dev_Grades_by_Stud_Curve","Std Deviation (Curve)",null,null,"Weighted standard deviation of distribution of grades on all assignments for each student. Assignment weights are used in the computation.\n\nA lower (higher) standard deviation indicates more steady (more uneven) performance by that student. The minimum value is zero, which occurs only if all grades of the given student are equal."]
["Std_Dev_Grades_by_Student","Std Deviation",null,null,"Weighted standard deviation of distribution of grades on all assignments for each student. Assignment weights are used in the computation.\n\nA lower (higher) standard deviation indicates more steady (more uneven) performance by that student. The minimum value is zero, which occurs only if all grades of the given student are equal."]
["Students_dim","Students_dim",null,null,"Variable containing display names of items in dimension 'Students'"]
["Teacher_Name","Teacher Name"]
["Var_Grades_by_Stud_Curve","Var Grades by Student",null,null,"For each student, the variance of the distribution of 'curved' grades on all assignments"]
["Var_Grades_by_Stud_Curve_Num","Var Grades by Student Num",null,null,"Numerator in computation of weighted variance of 'curved' grades on all assignments for each student"]
["Var_Grades_by_Student","Var Grades by Student",null,null,"For each student, the variance of distribution of grades on all assignments"]
["Var_Grades_by_Student_Den","Var Grades by Student Den",null,null,"Denominator in computation of weighted variance of grades on all assignments for each student"]
["Var_Grades_by_Student_Num","Var Grades by Student Num",null,null,"Numerator in computation of weighted variance of grades on all assignments for each student"]
[]
["Dimension (item)","Display Item As","Total As","Level As","Comment"]
["Assign_Types","Assign Types","Total","AssignTypes","A list of the types of assignments given to the students. The types are needed to assign numerical weights to each assignment.\n\nDo not use identical names for different leaves of this dimension."]
["  Homework","Homework",null,"AssignTypes"]
["  Quiz","Quiz"]
["  Test","Test"]
[]
["Assignments","Assignments","Total","Assignments","A list of the assignments given to the students. Do not use identical names for different leaves of this dimension."]
["  Homework_1","Homework 1",null,"Assignments"]
["  Class_report","Class report"]
["  Quiz_1","Quiz 1"]
["  Homework_2","Homework 2"]
["  Quiz_2","Quiz 2"]
["  Test","Test"]
[]
["Students","Students","Total","Students","A hierarchical list of the students by class section"]
["  Section_1","Section 1","Subtotal","Students"]
["    Student101","Student101",null,"Students 2"]
["    Student102","Student102"]
["    Student103","Student103"]
["    Student104","Student104"]
["    Student105","Student105"]
["  Section_2","Section 2","Subtotal"]
["    Student201","Student201"]
["    Student202","Student202"]
["    Student203","Student203"]
["    Student204","Student204"]
["    Student205","Student205"]

{"sheet":"(Ranges)","index":18,"n_rows":20,"n_cols":10,"rows_kept":20,"hidden":true}
[{"$f":"'Final Grades'!B8","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!B9","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!B10","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!B11","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!B12","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!B15","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!B16","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!B17","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!B18","v":{"v":0,"d":"0.0"}},{"$f":"'Final Grades'!B19","v":{"v":0,"d":"0.0"}}]
[{"$f":"'Final Grades'!C8","v":{"v":0,"d":"0.00"}},{"$f":"'Final Grades'!C9","v":{"v":0,"d":"0.00"}},{"$f":"'Final Grades'!C10","v":{"v":0,"d":"0.00"}},{"$f":"'Final Grades'!C11","v":{"v":0,"d":"0.00"}},{"$f":"'Final Grades'!C12","v":{"v":0,"d":"0.00"}},{"$f":"'Final Grades'!C15","v":{"v":0,"d":"0.00"}},{"$f":"'Final Grades'!C16","v":{"v":0,"d":"0.00"}},{"$f":"'Final Grades'!C17","v":{"v":0,"d":"0.00"}},{"$f":"'Final Grades'!C18","v":{"v":0,"d":"0.00"}},{"$f":"'Final Grades'!C19","v":{"v":0,"d":"0.00"}}]
[{"$f":"'(Other Variables)'!B32","v":{"v":0,"d":"0.00"}},{"$f":"'(Other Variables)'!B33","v":{"v":0,"d":"0.00"}},{"$f":"'(Other Variables)'!B34","v":{"v":0,"d":"0.00"}},{"$f":"'(Other Variables)'!B35","v":{"v":0,"d":"0.00"}},{"$f":"'(Other Variables)'!B36","v":{"v":0,"d":"0.00"}},{"$f":"'(Other Variables)'!B39","v":{"v":0,"d":"0.00"}},{"$f":"'(Other Variables)'!B40","v":{"v":0,"d":"0.00"}},{"$f":"'(Other Variables)'!B41","v":{"v":0,"d":"0.00"}},{"$f":"'(Other Variables)'!B42","v":{"v":0,"d":"0.00"}},{"$f":"'(Other Variables)'!B43","v":{"v":0,"d":"0.00"}}]
[{"$f":"'Class Section - Curved 1'!B55","v":{"$error":"#DIV/0!"}},{"$f":"'Class Section - Curved 1'!B56","v":{"$error":"#DIV/0!"}},{"$f":"'Class Section - Curved 1'!B57","v":{"$error":"#DIV/0!"}},{"$f":"'Class Section - Curved 1'!B58","v":{"$error":"#DIV/0!"}},{"$f":"'Class Section - Curved 1'!B59","v":{"$error":"#DIV/0!"}},{"$f":"'Class Section - Curved 2'!B55","v":{"$error":"#DIV/0!"}},{"$f":"'Class Section - Curved 2'!B56","v":{"$error":"#DIV/0!"}},{"$f":"'Class Section - Curved 2'!B57","v":{"$error":"#DIV/0!"}},{"$f":"'Class Section - Curved 2'!B58","v":{"$error":"#DIV/0!"}},{"$f":"'Class Section - Curved 2'!B59","v":{"$error":"#DIV/0!"}}]
[{"$f":"'(Other Variables)'!B151","v":{"$error":"#DIV/0!"}},{"$f":"'(Other Variables)'!B152","v":{"$error":"#DIV/0!"}},{"$f":"'(Other Variables)'!B153","v":{"$error":"#DIV/0!"}},{"$f":"'(Other Variables)'!B154","v":{"$error":"#DIV/0!"}},{"$f":"'(Other Variables)'!B155","v":{"$error":"#DIV/0!"}},{"$f":"'(Other Variables)'!B158","v":{"$error":"#DIV/0!"}},{"$f":"'(Other Variables)'!B159","v":{"$error":"#DIV/0!"}},{"$f":"'(Other Variables)'!B160","v":{"$error":"#DIV/0!"}},{"$f":"'(Other Variables)'!B161","v":{"$error":"#DIV/0!"}},{"$f":"'(Other Variables)'!B162","v":{"$error":"#DIV/0!"}}]
[{"$f":"'Plot Vars'!B10","v":"Section 1, Student101"},{"$f":"'Plot Vars'!B11","v":"Section 1, Student102"},{"$f":"'Plot Vars'!B12","v":"Section 1, Student103"},{"$f":"'Plot Vars'!B13","v":"Section 1, Student104"},{"$f":"'Plot Vars'!B14","v":"Section 1, Student105"},{"$f":"'Plot Vars'!B16","v":"Section 2, Student201"},{"$f":"'Plot Vars'!B17","v":"Section 2, Student202"},{"$f":"'Plot Vars'!B18","v":"Section 2, Student203"},{"$f":"'Plot Vars'!B19","v":"Section 2, Student204"},{"$f":"'Plot Vars'!B20","v":"Section 2, Student205"}]
[]
["Assignments!Mean_Grade_by_Assignment"]
["Assignments!Std_Dev_Grades_by_Assignment"]
["Assignments!Skew_Grades_by_Assignment"]
["Assignments!Kurt_Grades_by_Assignment"]
["Assignments - Curved'!Skew_Grades_by_Assign_Curve"]
["Assignments - Curved'!Kurt_Grades_by_Assign_Curve"]
["(Ranges)'!Mean_Grade_by_Student"]
["(Ranges)'!Std_Dev_Grades_by_Student"]
["(Ranges)'!Var_Grades_by_Student"]
["(Ranges)'!Std_Dev_Grades_by_Stud_Curve"]
["(Ranges)'!Var_Grades_by_Stud_Curve"]
["(Ranges)'!Students_dim"]
["Plot Vars'!Assignments_dim"]

{"sheet":"(Import)","index":19,"n_rows":10,"n_cols":64,"rows_kept":10,"hidden":true}
[":A:0:Assignment_Type",{"$f":"Labels!B11","v":"Assignment Type"},":A:-1:Assignment_Type",{"$f":"Labels!E11","v":"The type of each assignment, which determines what weight the assignment has in averages of student grades. Enter one of the names in variable table 'Assign Types'. \n\nYou can enter a descriptive name for each assignment on worksheet 'Labels', in the dimension 'Assignments'; enter names in the blue cells in column B.\n\nYou can enter a descriptive name for each assignment type (such as: homework, quiz, half test, test) on worksheet 'Labels', in the dimension 'Assign Types'; enter names in the blue cells in column B."},":A:0:Assign_Type_Weights",{"$f":"Labels!B9","v":"Assign Type Weights"},":A:-1:Assign_Type_Weights",{"$f":"Labels!E9","v":"Weight for each type of assignment, used in weighted average of grades. \n\nYou can enter a descriptive name for each assignment type (such as: homework, quiz, half test, test) on worksheet 'Labels', in the dimension 'Assign Types'; enter names in the blue cells in column B."},":A:0:Grades",{"$f":"Labels!B17","v":"Grades"},":A:-1:Grades",{"$f":"Labels!E17","v":"Grades for each student on each assignment. A negative number indicates that the student did not do the assignment and gets no grade. Participation is indicated in the same table as grades so the teacher doesn't have to enter this data in two places.\n\nYou can enter student names on worksheet 'Labels', in the dimension 'Students'; enter names in the blue cells in column B."},":A:0:Quality_Points",{"$f":"Labels!B35","v":"Quality Points"},":A:-1:Quality_Points",{"$f":"Labels!E35","v":"For each student, the weighted sum of grades on all assignments"},":A:0:Assignment_Weights",{"$f":"Labels!B12","v":"Assignment Weights"},":A:-1:Assignment_Weights",{"$f":"Labels!E12","v":"The weight of each assignment in the weighted grade point average for each student.\n\nYou can enter student names on worksheet 'Labels', in the dimension 'Students'; enter names in the blue cells in column B.\n\nYou can enter a descriptive name for each assignment on worksheet 'Labels', in the dimension 'Assignments'; enter names in the blue cells in column B."},":A:0:Quality_Weights",{"$f":"Labels!B37","v":"Quality Weights"},":A:-1:Quality_Weights",{"$f":"Labels!E37","v":"For each assignment and student, this is Assignment weight * Participation index (1 or 0)"},":A:0:Mean_Grade_by_Student",{"$f":"Labels!B30","v":"Mean Grade"},":A:-1:Mean_Grade_by_Student",{"$f":"Labels!E30","v":"For each student, the weighted average grade on all assignments.\n\nYou can enter student names on worksheet 'Labels', in the dimension 'Students'; enter in the blue cells in column B."},":A:0:Participation",{"$f":"Labels!B33","v":"Participation by Assignment"},":A:-1:Participation",{"$f":"Labels!E33","v":"If a student participated in an assignment, 1 else 0"},":A:0:Mean_Grade_by_Assignment",{"$f":"Labels!B28","v":"Mean Grade"},":A:-1:Mean_Grade_by_Assignment",{"$f":"Labels!E28","v":"For each assignment, the average grade for all students"},":A:0:Std_Dev_Grades_by_Assignment",{"$f":"Labels!B42","v":"Std Deviation"},":A:-1:Std_Dev_Grades_by_Assignment",{"$f":"Labels!E42","v":"Standard deviation of distribution of student grades on each assignment. \n\nA lower (higher) standard deviation indicates more uniform (more uneven) performance by students on that assignment. The minimum value is zero, which occurs only if all grades on the given assignment are equal."},":A:0:Mean_Grade",{"$f":"Labels!B26","v":"Mean Grade"},":A:-1:Mean_Grade",{"$f":"Labels!E26","v":"Weighted average grade on all assignments by all students"},":A:0:Skew_Grades_by_Assignment",{"$f":"Labels!B40","v":"Skewness"},":A:-1:Skew_Grades_by_Assignment",{"$f":"Labels!E40","v":"For each assignment, the 'skewness' of the distribution of student grades.\n\nIf skewness <0, the distribution has some very low grades and the mean grade < median (50th percentile) grade. A few students may be unable to keep up with the middle of the class.\n\nIf skewness >0, the distribution has some very high grades and the mean grade > 50th percentile grade. A few students may be far ahead of the midde of the class."},":A:0:Kurt_Grades_by_Assignment",{"$f":"Labels!B24","v":"Kurtosis"},":A:-1:Kurt_Grades_by_Assignment",{"$f":"Labels!E24","v":"Fn each assignment, the 'kurtosis' of all grades.\n\nIf kurtosis <0, the grade distribution has a sharper, narrower peak, and many very high and very low grades. The class may have a wider a range of performance than is optimal.\n\nIf kurtosis >0, the distribution has a flatter, wider peak, and fewer very high and very low grades. The class probably is targeting nearly all students well, leaving few students far behind and few far ahead."},":A:0:Var_Grades_by_Student",{"$f":"Labels!B49","v":"Var Grades by Student"},":A:-1:Var_Grades_by_Student",{"$f":"Labels!E49","v":"For each student, the variance of distribution of grades on all assignments"},":A:0:Quality_Norm_Wgts",{"$f":"Labels!B34","v":"Normalized Quality Wgts"},":A:-1:Quality_Norm_Wgts",{"$f":"Labels!E34","v":"Quality weights, but normalized so the sum over all students is 1 for each assignment."},":A:0:Grades_Norm_Wtd",{"$f":"Labels!B20","v":"Grades Norm Wtd"},":A:-1:Grades_Norm_Wtd",{"$f":"Labels!E20","v":"Grade * quality norm weight, for each student and each assignment"}]
[":A:0:Std_Dev_Grades_by_Student",{"$f":"Labels!B44","v":"Std Deviation"},":A:-1:Std_Dev_Grades_by_Student",{"$f":"Labels!E44","v":"Weighted standard deviation of distribution of grades on all assignments for each student. Assignment weights are used in the computation.\n\nA lower (higher) standard deviation indicates more steady (more uneven) performance by that student. The minimum value is zero, which occurs only if all grades of the given student are equal."},":A:0:Var_Grades_by_Student_Num",{"$f":"Labels!B51","v":"Var Grades by Student Num"},":A:-1:Var_Grades_by_Student_Num",{"$f":"Labels!E51","v":"Numerator in computation of weighted variance of grades on all assignments for each student"},":A:0:Grades2_Wtd",{"$f":"Labels!B21","v":"Grades2 Wtd"},":A:-1:Grades2_Wtd",{"$f":"Labels!E21","v":"Grade^2 * assignment weight"},":A:0:Var_Grades_by_Student_Den",{"$f":"Labels!B50","v":"Var Grades by Student Den"},":A:-1:Var_Grades_by_Student_Den",{"$f":"Labels!E50","v":"Denominator in computation of weighted variance of grades on all assignments for each student"},":A:0:School_Name",{"$f":"Labels!B38","v":"School Name"},":A:-1:School_Name",{"$f":"Labels!E38","v":"The name of the school where this gradebook is used"},":A:0:Teacher_Name",{"$f":"Labels!B46","v":"Teacher Name"},":A:-1:Teacher_Name",{"$f":"Labels!E46","v":0},":A:0:Academic_Subject",{"$f":"Labels!B7","v":"Academic Subject"},":A:-1:Academic_Subject",{"$f":"Labels!E7","v":"The academic subject for the students and class sections in this gradebook"},":A:0:Academic_Term",{"$f":"Labels!B8","v":"Academic Term"},":A:-1:Academic_Term",{"$f":"Labels!E8","v":"The academic term for this gradebook"},":A:0:Assign_Types_Dim",{"$f":"Labels!B10","v":"Assign_Types"},":A:-1:Assign_Types_Dim",{"$f":"Labels!E10","v":"Converts the dimension Assign_Types into an analysis variable for use in lookups. \n\nYou can enter a descriptive name for each assignment type (such as: homework, quiz, half test, test) on worksheet 'Labels', in the dimension 'Assign Types'; enter names in the blue cells in column B."},":A:0:Assignments",{"$f":"Labels!B13","v":"Assignments"},":A:-1:Assignments",{"$f":"Labels!E13","v":"Names of the assignments. \n\nYou can enter a descriptive name for each assignment on worksheet 'Labels', in the dimension 'Assignments'; enter names in the blue cells in column B."},":A:0:Fees_Assessed",{"$f":"Labels!B15","v":"Fees Assessed"},":A:-1:Fees_Assessed",{"$f":"Labels!E15","v":0},":A:0:Fees_Paid",{"$f":"Labels!B16","v":"Fees Paid"},":A:-1:Fees_Paid",{"$f":"Labels!E16","v":0},":A:0:Assignments_dim",{"$f":"Labels!B14","v":"Assignments_dim"},":A:-1:Assignments_dim",{"$f":"Labels!E14","v":"Variable containing display names of items in dimension 'Assignments'"},":A:0:Students_dim",{"$f":"Labels!B45","v":"Students_dim"},":A:-1:Students_dim",{"$f":"Labels!E45","v":"Variable containing display names of items in dimension 'Students'"},":A:0:Mean_Grade_by_Assign_Curve",{"$f":"Labels!B27","v":"Mean Grade (Curve)"},":A:-1:Mean_Grade_by_Assign_Curve",{"$f":"Labels!E27","v":"The user-specified mean grade for each assignment when grading on a 'curve'"},":A:0:Std_Dev_Grades_by_Assign_Curve",{"$f":"Labels!B41","v":"Std Dev of Grades (Curve)"},":A:-1:Std_Dev_Grades_by_Assign_Curve",{"$f":"Labels!E41","v":"The user-specified standard deviation (spread) of grades for each assignment when grading on a 'curve'"}]
[":A:0:Grades_Curve",{"$f":"Labels!B18","v":"Grades (Curve)"},":A:-1:Grades_Curve",{"$f":"Labels!E18","v":"Grades for each student on each assignment using the grading 'curve'. A negative number indicates that the student did not do the assignment and gets no grade. Participation is indicated in the same table as grades so the teacher doesn't have to enter this data in two places.\n\nYou can enter student names on worksheet 'Labels', in the dimension 'Students'; enter names in the blue cells in column B."},":A:0:Max_Grade_Curve",{"$f":"Labels!B25","v":"Max Grade (Curve)"},":A:-1:Max_Grade_Curve",{"$f":"Labels!E25","v":"The maximum grade on each assignment when grading on a 'curve'. Any grade that would be higher than this maximum on the curve is set to the maximum allowed value."},":A:0:Min_Grade_Curve",{"$f":"Labels!B32","v":"Min Grade (Curve)"},":A:-1:Min_Grade_Curve",{"$f":"Labels!E32","v":"The minimum grade on each assignment when grading on a 'curve'. Any grade that would be lower than this manimum on the curve is set to the minimum allowed value."},":A:0:Quality_Points_Curve",{"$f":"Labels!B36","v":"Quality Points (Curve)"},":A:-1:Quality_Points_Curve",{"$f":"Labels!E36","v":"For each student, the weighted sum of curved grades on all assignments"},":A:0:Mean_Grade_by_Stud_Curve",{"$f":"Labels!B29","v":"Mean Grade (Curve)"},":A:-1:Mean_Grade_by_Stud_Curve",{"$f":"Labels!E29","v":"For each student, the weighted average 'curved' grade on all assignments.\n\nYou can enter student names on worksheet 'Labels', in the dimension 'Students'; enter in the blue cells in column B."},":A:0:Std_Dev_Grades_by_Stud_Curve",{"$f":"Labels!B43","v":"Std Deviation (Curve)"},":A:-1:Std_Dev_Grades_by_Stud_Curve",{"$f":"Labels!E43","v":"Weighted standard deviation of distribution of grades on all assignments for each student. Assignment weights are used in the computation.\n\nA lower (higher) standard deviation indicates more steady (more uneven) performance by that student. The minimum value is zero, which occurs only if all grades of the given student are equal."},":A:0:Skew_Grades_by_Assign_Curve",{"$f":"Labels!B39","v":"Skewness (Curve)"},":A:-1:Skew_Grades_by_Assign_Curve",{"$f":"Labels!E39","v":"For each assignment, the 'skewness' of the distribution of 'curved' student grades.\n\nIf skewness <0, the distribution has some very low grades and the mean grade < median (50th percentile) grade. A few students may be unable to keep up with the middle of the class.\n\nIf skewness >0, the distribution has some very high grades and the mean grade > 50th percentile grade. A few students may be far ahead of the midde of the class."},":A:0:Kurt_Grades_by_Assign_Curve",{"$f":"Labels!B23","v":"Kurtosis (Curved)"},":A:-1:Kurt_Grades_by_Assign_Curve",{"$f":"Labels!E23","v":"Fn each assignment, the 'kurtosis' of all 'curved' grades.\n\nIf kurtosis <0, the grade distribution has a sharper, narrower peak, and many very high and very low grades. The class may have a wider a range of performance than is optimal.\n\nIf kurtosis >0, the distribution has a flatter, wider peak, and fewer very high and very low grades. The class probably is targeting nearly all students well, leaving few students far behind and few far ahead."},":A:0:Var_Grades_by_Stud_Curve_Num",{"$f":"Labels!B48","v":"Var Grades by Student Num"},":A:-1:Var_Grades_by_Stud_Curve_Num",{"$f":"Labels!E48","v":"Numerator in computation of weighted variance of 'curved' grades on all assignments for each student"},":A:0:Grades_Curve_Norm_Wtd",{"$f":"Labels!B19","v":"Curved Grades Norm Wtd"},":A:-1:Grades_Curve_Norm_Wtd",{"$f":"Labels!E19","v":"Curved grade * quality norm weight, for each student and each assignment"},":A:0:Grades2_Wtd_Curve",{"$f":"Labels!B22","v":"Grades2 Wtd (Curve)"},":A:-1:Grades2_Wtd_Curve",{"$f":"Labels!E22","v":"(Curved grade)^2 * assignment weight"},":A:0:Var_Grades_by_Stud_Curve",{"$f":"Labels!B47","v":"Var Grades by Student"},":A:-1:Var_Grades_by_Stud_Curve",{"$f":"Labels!E47","v":"For each student, the variance of the distribution of 'curved' grades on all assignments"},":A:0:Mean_Grade_Curve",{"$f":"Labels!B31","v":"Mean Grade (Curve)"},":A:-1:Mean_Grade_Curve",{"$f":"Labels!E31","v":"Weighted average 'curved' grade on all assignments by all students"},":D:-1:Students",{"$f":"Labels!E67","v":"A hierarchical list of the students by class section"},":D:0:Students",{"$f":"Labels!B67","v":"Students"},":D:2:Students",{"$f":"Labels!D67","v":"Students"},":D:1:Students",{"$f":"Labels!C67","v":"Total"},":D:0:Students.Section_1",{"$f":"Labels!B68","v":"Section 1"},":D:2:Students.Section_1",{"$f":"Labels!D68","v":"Students"}]
[":D:1:Students.Section_1",{"$f":"Labels!C68","v":"Subtotal"},":D:0:Students.Section_1.Student101",{"$f":"Labels!B69","v":"Student101"},":D:2:Students.Section_1.Student101",{"$f":"Labels!D69","v":"Students 2"},":D:0:Students.Section_1.Student102",{"$f":"Labels!B70","v":"Student102"},":D:0:Students.Section_1.Student103",{"$f":"Labels!B71","v":"Student103"},":D:0:Students.Section_1.Student104",{"$f":"Labels!B72","v":"Student104"},":D:0:Students.Section_1.Student105",{"$f":"Labels!B73","v":"Student105"},":D:0:Students.Section_2",{"$f":"Labels!B74","v":"Section 2"},":D:1:Students.Section_2",{"$f":"Labels!C74","v":"Subtotal"},":D:0:Students.Section_2.Student201",{"$f":"Labels!B75","v":"Student201"},":D:0:Students.Section_2.Student202",{"$f":"Labels!B76","v":"Student202"},":D:0:Students.Section_2.Student203",{"$f":"Labels!B77","v":"Student203"},":D:0:Students.Section_2.Student204",{"$f":"Labels!B78","v":"Student204"},":D:0:Students.Section_2.Student205",{"$f":"Labels!B79","v":"Student205"},":D:-1:Assignments",{"$f":"Labels!E59","v":"A list of the assignments given to the students. Do not use identical names for different leaves of this dimension."},":D:0:Assignments",{"$f":"Labels!B59","v":"Assignments"},":D:2:Assignments",{"$f":"Labels!D59","v":"Assignments"},":D:1:Assignments",{"$f":"Labels!C59","v":"Total"},":D:0:Assignments.Homework_1",{"$f":"Labels!B60","v":"Homework 1"},":D:2:Assignments.Homework_1",{"$f":"Labels!D60","v":"Assignments"},":D:0:Assignments.Class_report",{"$f":"Labels!B61","v":"Class report"},":D:0:Assignments.Quiz_1",{"$f":"Labels!B62","v":"Quiz 1"},":D:0:Assignments.Homework_2",{"$f":"Labels!B63","v":"Homework 2"},":D:0:Assignments.Quiz_2",{"$f":"Labels!B64","v":"Quiz 2"},":D:0:Assignments.Test",{"$f":"Labels!B65","v":"Test"},":D:-1:Assign_Types",{"$f":"Labels!E54","v":"A list of the types of assignments given to the students. The types are needed to assign numerical weights to each assignment.\n\nDo not use identical names for different leaves of this dimension."},":D:0:Assign_Types",{"$f":"Labels!B54","v":"Assign Types"},":D:2:Assign_Types",{"$f":"Labels!D54","v":"AssignTypes"},":D:1:Assign_Types",{"$f":"Labels!C54","v":"Total"},":D:0:Assign_Types.Homework",{"$f":"Labels!B55","v":"Homework"},":D:2:Assign_Types.Homework",{"$f":"Labels!D55","v":"AssignTypes"},":D:0:Assign_Types.Quiz",{"$f":"Labels!B56","v":"Quiz"}]
[":D:0:Assign_Types.Test",{"$f":"Labels!B57","v":"Test"}]
[":WS:Output Advanced",{"$f":"Graphs!A1","v":0},":WS:",{"$f":"Administration!A1","v":"Middlesex College"},":WS:",{"$f":"'Student Fees'!A1","v":"Middlesex College"},":WS:",{"$f":"'All Grades'!A1","v":"Middlesex College"},":WS:",{"$f":"'Grades - Curved'!A1","v":"Middlesex College"},":WS:",{"$f":"Assignments!A1","v":"Middlesex College"},":WS:",{"$f":"'Assignments - Curved'!A1","v":"Middlesex College"},":WS:",{"$f":"'Final Grades'!A1","v":"Middlesex College"},":WS:",{"$f":"'Final Grades - Curved'!A1","v":"Middlesex College"},":WS:",{"$f":"'Class Section 1'!A1","v":"Middlesex College"},":WS:",{"$f":"'Class Section 2'!A1","v":"Middlesex College"},":WS:",{"$f":"'Class Section - Curved 1'!A1","v":"Middlesex College"},":WS:",{"$f":"'Class Section - Curved 2'!A1","v":"Middlesex College"},":WS:",{"$f":"Formulas!A1","v":"Middlesex College"},":WS:",{"$f":"'Plot Vars'!A1","v":"Middlesex College"},":WS:",{"$f":"'(Other Variables)'!A1","v":"Middlesex College"},":WS:",{"$f":"Labels!A1","v":"Middlesex College"},":WS:",{"$f":"'(Ranges)'!A1","v":0},":WS:",{"$f":"'(Import)'!A1","v":":A:0:Assignment_Type"}]
["School_Name[]|",{"$f":"Administration!B10","v":"Middlesex College"},"Teacher_Name[]|",{"$f":"Administration!B11","v":"Dr. Faust"},"Academic_Subject[]|",{"$f":"Administration!B12","v":"Sociology"},"Academic_Term[]|",{"$f":"Administration!B13","v":"Spring 2010"},"Assignment_Type[\"Assignments.Homework_1\"]|=index('(Other Variables)'!B8:B10, 1)",{"$f":"Administration!B21","v":"Homework"},"Assignment_Type[\"Assignments.Class_report\"]|=index('(Other Variables)'!B8:B10, 1)",{"$f":"Administration!B22","v":"Homework"},"Assignment_Type[\"Assignments.Quiz_1\"]|=index('(Other Variables)'!B8:B10, 1)",{"$f":"Administration!B23","v":"Homework"},"Assignment_Type[\"Assignments.Homework_2\"]|=index('(Other Variables)'!B8:B10, 1)",{"$f":"Administration!B24","v":"Homework"},"Assignment_Type[\"Assignments.Quiz_2\"]|=index('(Other Variables)'!B8:B10, 1)",{"$f":"Administration!B25","v":"Homework"},"Assignment_Type[\"Assignments.Test\"]|=index('(Other Variables)'!B8:B10, 1)",{"$f":"Administration!B26","v":"Homework"},"Assign_Type_Weights[\"Assign_Types.Homework\"]|=1",{"$f":"Administration!B29","v":1},"Assign_Type_Weights[\"Assign_Types.Quiz\"]|=1",{"$f":"Administration!B30","v":1},"Assign_Type_Weights[\"Assign_Types.Test\"]|=1",{"$f":"Administration!B31","v":1},"Mean_Grade_by_Assign_Curve[\"Assignments.Homework_1\"]|=Assignments!B10",{"$f":"Administration!B37","v":0},"Std_Dev_Grades_by_Assign_Curve[\"Assignments.Homework_1\"]|=stdev('All Grades'!B16:B20,'All Grades'!B23:B27)",{"$f":"Administration!C37","v":0},"Min_Grade_Curve[\"Assignments.Homework_1\"]|=0",{"$f":"Administration!D37","v":0},"Max_Grade_Curve[\"Assignments.Homework_1\"]|=100",{"$f":"Administration!E37","v":100},"Mean_Grade_by_Assign_Curve[\"Assignments.Class_report\"]|=Assignments!B11",{"$f":"Administration!B38","v":0},"Std_Dev_Grades_by_Assign_Curve[\"Assignments.Class_report\"]|=stdev('All Grades'!C16:C20,'All Grades'!C23:C27)",{"$f":"Administration!C38","v":0},"Min_Grade_Curve[\"Assignments.Class_report\"]|=0",{"$f":"Administration!D38","v":0},"Max_Grade_Curve[\"Assignments.Class_report\"]|=100",{"$f":"Administration!E38","v":100},"Mean_Grade_by_Assign_Curve[\"Assignments.Quiz_1\"]|=Assignments!B12",{"$f":"Administration!B39","v":0},"Std_Dev_Grades_by_Assign_Curve[\"Assignments.Quiz_1\"]|=stdev('All Grades'!D16:D20,'All Grades'!D23:D27)",{"$f":"Administration!C39","v":0},"Min_Grade_Curve[\"Assignments.Quiz_1\"]|=0",{"$f":"Administration!D39","v":0},"Max_Grade_Curve[\"Assignments.Quiz_1\"]|=100",{"$f":"Administration!E39","v":100},"Mean_Grade_by_Assign_Curve[\"Assignments.Homework_2\"]|=Assignments!B13",{"$f":"Administration!B40","v":0},"Std_Dev_Grades_by_Assign_Curve[\"Assignments.Homework_2\"]|=stdev('All Grades'!E16:E20,'All Grades'!E23:E27)",{"$f":"Administration!C40","v":0},"Min_Grade_Curve[\"Assignments.Homework_2\"]|=0",{"$f":"Administration!D40","v":0},"Max_Grade_Curve[\"Assignments.Homework_2\"]|=100",{"$f":"Administration!E40","v":100},"Mean_Grade_by_Assign_Curve[\"Assignments.Quiz_2\"]|=Assignments!B14",{"$f":"Administration!B41","v":0},"Std_Dev_Grades_by_Assign_Curve[\"Assignments.Quiz_2\"]|=stdev('All Grades'!F16:F20,'All Grades'!F23:F27)",{"$f":"Administration!C41","v":0},"Min_Grade_Curve[\"Assignments.Quiz_2\"]|=0",{"$f":"Administration!D41","v":0}]
["Max_Grade_Curve[\"Assignments.Quiz_2\"]|=100",{"$f":"Administration!E41","v":100},"Mean_Grade_by_Assign_Curve[\"Assignments.Test\"]|=Assignments!B15",{"$f":"Administration!B42","v":0},"Std_Dev_Grades_by_Assign_Curve[\"Assignments.Test\"]|=stdev('All Grades'!G16:G20,'All Grades'!G23:G27)",{"$f":"Administration!C42","v":0},"Min_Grade_Curve[\"Assignments.Test\"]|=0",{"$f":"Administration!D42","v":0},"Max_Grade_Curve[\"Assignments.Test\"]|=100",{"$f":"Administration!E42","v":100},"Fees_Assessed[\"Students.Section_1.Student101\"]|=0/10",{"$f":"'Student Fees'!B8","v":0},"Fees_Paid[\"Students.Section_1.Student101\"]|=0/10",{"$f":"'Student Fees'!C8","v":0},"Fees_Assessed[\"Students.Section_1.Student102\"]|=0/10",{"$f":"'Student Fees'!B9","v":0},"Fees_Paid[\"Students.Section_1.Student102\"]|=0/10",{"$f":"'Student Fees'!C9","v":0},"Fees_Assessed[\"Students.Section_1.Student103\"]|=0/10",{"$f":"'Student Fees'!B10","v":0},"Fees_Paid[\"Students.Section_1.Student103\"]|=0/10",{"$f":"'Student Fees'!C10","v":0},"Fees_Assessed[\"Students.Section_1.Student104\"]|=0/10",{"$f":"'Student Fees'!B11","v":0},"Fees_Paid[\"Students.Section_1.Student104\"]|=0/10",{"$f":"'Student Fees'!C11","v":0},"Fees_Assessed[\"Students.Section_1.Student105\"]|=0/10",{"$f":"'Student Fees'!B12","v":0},"Fees_Paid[\"Students.Section_1.Student105\"]|=0/10",{"$f":"'Student Fees'!C12","v":0},"Fees_Assessed[\"Students.Section_2.Student201\"]|=0/10",{"$f":"'Student Fees'!B15","v":0},"Fees_Paid[\"Students.Section_2.Student201\"]|=0/10",{"$f":"'Student Fees'!C15","v":0},"Fees_Assessed[\"Students.Section_2.Student202\"]|=0/10",{"$f":"'Student Fees'!B16","v":0},"Fees_Paid[\"Students.Section_2.Student202\"]|=0/10",{"$f":"'Student Fees'!C16","v":0},"Fees_Assessed[\"Students.Section_2.Student203\"]|=0/10",{"$f":"'Student Fees'!B17","v":0},"Fees_Paid[\"Students.Section_2.Student203\"]|=0/10",{"$f":"'Student Fees'!C17","v":0},"Fees_Assessed[\"Students.Section_2.Student204\"]|=0/10",{"$f":"'Student Fees'!B18","v":0},"Fees_Paid[\"Students.Section_2.Student204\"]|=0/10",{"$f":"'Student Fees'!C18","v":0},"Fees_Assessed[\"Students.Section_2.Student205\"]|=0/10",{"$f":"'Student Fees'!B19","v":0},"Fees_Paid[\"Students.Section_2.Student205\"]|=0/10",{"$f":"'Student Fees'!C19","v":0},"Grades[\"Students.Section_1.Student101\", \"Assignments.Homework_1\"]|=0",{"$f":"'All Grades'!B16","v":0},"Grades[\"Students.Section_1.Student101\", \"Assignments.Class_report\"]|=0",{"$f":"'All Grades'!C16","v":0},"Grades[\"Students.Section_1.Student101\", \"Assignments.Quiz_1\"]|=0",{"$f":"'All Grades'!D16","v":0},"Grades[\"Students.Section_1.Student101\", \"Assignments.Homework_2\"]|=0",{"$f":"'All Grades'!E16","v":0},"Grades[\"Students.Section_1.Student101\", \"Assignments.Quiz_2\"]|=0",{"$f":"'All Grades'!F16","v":0},"Grades[\"Students.Section_1.Student101\", \"Assignments.Test\"]|=0",{"$f":"'All Grades'!G16","v":0},"Grades[\"Students.Section_1.Student102\", \"Assignments.Homework_1\"]|=0",{"$f":"'All Grades'!B17","v":0}]
["Grades[\"Students.Section_1.Student102\", \"Assignments.Class_report\"]|=0",{"$f":"'All Grades'!C17","v":0},"Grades[\"Students.Section_1.Student102\", \"Assignments.Quiz_1\"]|=0",{"$f":"'All Grades'!D17","v":0},"Grades[\"Students.Section_1.Student102\", \"Assignments.Homework_2\"]|=0",{"$f":"'All Grades'!E17","v":0},"Grades[\"Students.Section_1.Student102\", \"Assignments.Quiz_2\"]|=0",{"$f":"'All Grades'!F17","v":0},"Grades[\"Students.Section_1.Student102\", \"Assignments.Test\"]|=0",{"$f":"'All Grades'!G17","v":0},"Grades[\"Students.Section_1.Student103\", \"Assignments.Homework_1\"]|=0",{"$f":"'All Grades'!B18","v":0},"Grades[\"Students.Section_1.Student103\", \"Assignments.Class_report\"]|=0",{"$f":"'All Grades'!C18","v":0},"Grades[\"Students.Section_1.Student103\", \"Assignments.Quiz_1\"]|=0",{"$f":"'All Grades'!D18","v":0},"Grades[\"Students.Section_1.Student103\", \"Assignments.Homework_2\"]|=0",{"$f":"'All Grades'!E18","v":0},"Grades[\"Students.Section_1.Student103\", \"Assignments.Quiz_2\"]|=0",{"$f":"'All Grades'!F18","v":0},"Grades[\"Students.Section_1.Student103\", \"Assignments.Test\"]|=0",{"$f":"'All Grades'!G18","v":0},"Grades[\"Students.Section_1.Student104\", \"Assignments.Homework_1\"]|=0",{"$f":"'All Grades'!B19","v":0},"Grades[\"Students.Section_1.Student104\", \"Assignments.Class_report\"]|=0",{"$f":"'All Grades'!C19","v":0},"Grades[\"Students.Section_1.Student104\", \"Assignments.Quiz_1\"]|=0",{"$f":"'All Grades'!D19","v":0},"Grades[\"Students.Section_1.Student104\", \"Assignments.Homework_2\"]|=0",{"$f":"'All Grades'!E19","v":0},"Grades[\"Students.Section_1.Student104\", \"Assignments.Quiz_2\"]|=0",{"$f":"'All Grades'!F19","v":0},"Grades[\"Students.Section_1.Student104\", \"Assignments.Test\"]|=0",{"$f":"'All Grades'!G19","v":0},"Grades[\"Students.Section_1.Student105\", \"Assignments.Homework_1\"]|=0",{"$f":"'All Grades'!B20","v":0},"Grades[\"Students.Section_1.Student105\", \"Assignments.Class_report\"]|=0",{"$f":"'All Grades'!C20","v":0},"Grades[\"Students.Section_1.Student105\", \"Assignments.Quiz_1\"]|=0",{"$f":"'All Grades'!D20","v":0},"Grades[\"Students.Section_1.Student105\", \"Assignments.Homework_2\"]|=0",{"$f":"'All Grades'!E20","v":0},"Grades[\"Students.Section_1.Student105\", \"Assignments.Quiz_2\"]|=0",{"$f":"'All Grades'!F20","v":0},"Grades[\"Students.Section_1.Student105\", \"Assignments.Test\"]|=0",{"$f":"'All Grades'!G20","v":0},"Grades[\"Students.Section_2.Student201\", \"Assignments.Homework_1\"]|=0",{"$f":"'All Grades'!B23","v":0},"Grades[\"Students.Section_2.Student201\", \"Assignments.Class_report\"]|=0",{"$f":"'All Grades'!C23","v":0},"Grades[\"Students.Section_2.Student201\", \"Assignments.Quiz_1\"]|=0",{"$f":"'All Grades'!D23","v":0},"Grades[\"Students.Section_2.Student201\", \"Assignments.Homework_2\"]|=0",{"$f":"'All Grades'!E23","v":0},"Grades[\"Students.Section_2.Student201\", \"Assignments.Quiz_2\"]|=0",{"$f":"'All Grades'!F23","v":0},"Grades[\"Students.Section_2.Student201\", \"Assignments.Test\"]|=0",{"$f":"'All Grades'!G23","v":0},"Grades[\"Students.Section_2.Student202\", \"Assignments.Homework_1\"]|=0",{"$f":"'All Grades'!B24","v":0},"Grades[\"Students.Section_2.Student202\", \"Assignments.Class_report\"]|=0",{"$f":"'All Grades'!C24","v":0},"Grades[\"Students.Section_2.Student202\", \"Assignments.Quiz_1\"]|=0",{"$f":"'All Grades'!D24","v":0}]
["Grades[\"Students.Section_2.Student202\", \"Assignments.Homework_2\"]|=0",{"$f":"'All Grades'!E24","v":0},"Grades[\"Students.Section_2.Student202\", \"Assignments.Quiz_2\"]|=0",{"$f":"'All Grades'!F24","v":0},"Grades[\"Students.Section_2.Student202\", \"Assignments.Test\"]|=0",{"$f":"'All Grades'!G24","v":0},"Grades[\"Students.Section_2.Student203\", \"Assignments.Homework_1\"]|=0",{"$f":"'All Grades'!B25","v":0},"Grades[\"Students.Section_2.Student203\", \"Assignments.Class_report\"]|=0",{"$f":"'All Grades'!C25","v":0},"Grades[\"Students.Section_2.Student203\", \"Assignments.Quiz_1\"]|=0",{"$f":"'All Grades'!D25","v":0},"Grades[\"Students.Section_2.Student203\", \"Assignments.Homework_2\"]|=0",{"$f":"'All Grades'!E25","v":0},"Grades[\"Students.Section_2.Student203\", \"Assignments.Quiz_2\"]|=0",{"$f":"'All Grades'!F25","v":0},"Grades[\"Students.Section_2.Student203\", \"Assignments.Test\"]|=0",{"$f":"'All Grades'!G25","v":0},"Grades[\"Students.Section_2.Student204\", \"Assignments.Homework_1\"]|=0",{"$f":"'All Grades'!B26","v":0},"Grades[\"Students.Section_2.Student204\", \"Assignments.Class_report\"]|=0",{"$f":"'All Grades'!C26","v":0},"Grades[\"Students.Section_2.Student204\", \"Assignments.Quiz_1\"]|=0",{"$f":"'All Grades'!D26","v":0},"Grades[\"Students.Section_2.Student204\", \"Assignments.Homework_2\"]|=0",{"$f":"'All Grades'!E26","v":0},"Grades[\"Students.Section_2.Student204\", \"Assignments.Quiz_2\"]|=0",{"$f":"'All Grades'!F26","v":0},"Grades[\"Students.Section_2.Student204\", \"Assignments.Test\"]|=0",{"$f":"'All Grades'!G26","v":0},"Grades[\"Students.Section_2.Student205\", \"Assignments.Homework_1\"]|=0",{"$f":"'All Grades'!B27","v":0},"Grades[\"Students.Section_2.Student205\", \"Assignments.Class_report\"]|=0",{"$f":"'All Grades'!C27","v":0},"Grades[\"Students.Section_2.Student205\", \"Assignments.Quiz_1\"]|=0",{"$f":"'All Grades'!D27","v":0},"Grades[\"Students.Section_2.Student205\", \"Assignments.Homework_2\"]|=0",{"$f":"'All Grades'!E27","v":0},"Grades[\"Students.Section_2.Student205\", \"Assignments.Quiz_2\"]|=0",{"$f":"'All Grades'!F27","v":0},"Grades[\"Students.Section_2.Student205\", \"Assignments.Test\"]|=0",{"$f":"'All Grades'!G27","v":0}]