CURRICULUM MAPPING by l24b45qs

VIEWS: 0 PAGES: 2

									                                     Math-in-CTE

                            CURRICULUM MAPPING TEMPLATE
Program/Course: ______Oracle 1—Database Design __________________


    Month     Unit Title or Topic     CTE Concepts            Math Concepts      Michigan
                                                                                 GLCE’s HSCE’s
 September                            Entities- groupings     Venn diagrams      L4.2.3
                                      Venn diagrams
                                      Relationships           Logic
                                      Flowcharting                               L4.1.1; L4.2.1
                                                                                 L4.1.1; L4.1.2; L4.2.2;
                                      Safety                                     L4.2.3;L4.2.4; L4.3.2;
                                                                                 L4.3.3




  October                             Relationships           Logic              L4.1.1; L4.2.1
                                                                                 L4.1.1; L4.1.2; L4.2.2;
                                      Normalization           Reasoning          L4.2.3;L4.2.4; L4.3.2;
                                      Applying ―rules‖                           L4.3.3
                                      Data accuracy
                                      Constraints




 November                             Presentations
                                      Modeling change
                                      mapping                 Transform from     l1.2.1; l2.2.1; l2.2.2;
                                                              words to symbols   l2.2.3
                                                              (mathematical
                                                              modeling)



 December                             Intro to SQL            Logic              L4.1.1; L4.2.1
                                                                                 L4.1.1; L4.1.2; L4.2.2;
                                      Create tables based                        L4.2.3;L4.2.4; L4.3.2;
                                      on data needs                              L4.3.3
                                      Code that creates       Binary
                                      logical constructs to
                                      hold data
                                 Math-in-CTE


  Month    Unit Title or Topic    CTE Concepts        Math Concepts   Michigan
                                                                      GLCE’s HSCE’s
January                           Restricting data
                                   -- Where clause
                                  Sorting data
                                     --Order by       Logic           L4.1.1; L4.2.1
                                                                      L4.1.1; L4.1.2; L4.2.2;
                                  SQL functions                       L4.2.3;L4.2.4; L4.3.2;
                                      Upper concat                    L4.3.3
                                       Lower
                                                      Algebra         A1.2.8 A3.1.1; A3.1.2


February                          Joining tables     Logic            L4.1.1; L4.2.1
                                                                      L4.1.1; L4.1.2; L4.2.2;
                                  Group functions                     L4.2.3;L4.2.4; L4.3.2;
                                    Min-max –stdddev                  L4.3.3


                                                      Algebra         A1.2.8 A3.1.1; A3.1.2




 March                            Aggregating Data    Logic           L4.1.1; L4.2.1
                                                                      L4.1.1; L4.1.2; L4.2.2;
                                    -grouping and                     L4.2.3;L4.2.4; L4.3.2;
                                  classifying                         L4.3.3
                                  --sub-queries
                                  --creating tables



 April                            Creating views      Logic and       L4.1.1; L4.2.1
                                                                      L4.1.1; L4.1.2; L4.2.2;
                                  Abstract            Reasoning       L4.2.3;L4.2.4; L4.3.2;
                                  representations                     L4.3.3
                                  Creating/deleting
                                  Constraints
                                  --Primary key
                                  --Foreign key
                                  --check
  May                             Final Projects      Logic           L4.1.1; L4.2.1
                                                                      L4.1.1; L4.1.2; L4.2.2;
                                                                      L4.2.3;L4.2.4; L4.3.2;
                                                                      L4.3.3

								
To top