Home

Here are some thoughts on the models:

abstracting out the organization is not worth the time for now. For the moment, we’ll use a separate table for each state. Here’s the general schema:

grade
standard_number
level_0
level_1
etc.

each level is an array with the first element being the number and the second being the text. For instance:
{
grade,
“standard_number”:“1.A.1.a”,
“level_0”: [“1”,“Knowledge of Algebra, Patterns, and Functions”],
“level_1”: [“A”,“Patterns and Functions”],
“level_2”: [“1”,“Identify, describe, extend, and create numeric patterns and functions”],
“level_3”: [“a”,“Represent and analyze numeric patterns using skip counting”],
“level_4”: [“Use 2, 5, 10, or 100 starting with any whole number (0 – 1000)”]
}

I’ll be adding the common core to the database today.