# CURRICULUM MAPPING by l24b45qs

VIEWS: 0 PAGES: 2

• pg 1
```									                                     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