Information Technology

Overview

Math-in-CTE professional development model is not a curriculum; instead, it is a process, organized around a set of five core principles (PDF), through which CTE and math teachers working in teams learn how to enhance the math that naturally occurs in their CTE curricula. Math-in CTE professional development always begins with curriculum mapping. In this process, CTE teachers examine the CTE concepts they teach, then work with math teacher partners to identify embedded math intersections, as linked to the Common Core math standards, and create a curriculum map. Once the map is complete, the CTE and math teacher teams select from within it one or more CTE concepts and related math concepts to develop into CTE lesson plans.

This sample Math-in-CTE curriculum map was created by teacher teams composed of information technology and math teachers from Iowa. The associated sample lesson plan and related materials were identified and developed from this curriculum map.

Click on the linked CTE and math concepts within this map to view the lesson plan associated with them. Scroll to the right to view the middle and high school Common Core math standards associated with each unit.

Information Technology

CTE Course/UnitCTE ConceptsMath ConceptsMiddle School Common Core Math StandardsHigh School Common Core Math Standards
ExcelPayroll;
Sales;
Property Tax;
Stats;
Charting;
Graphing
Percent;
Multiply;
Add and subtract;
Ratios;
Average;
Sampling/survey;
Conversion decimals to fractions;
Mean, median, mode;
Variance, standard deviation
6.NS.2; 6.NS.3; 7.NS.1; 7.EE.3; 6.RP.1; 6.RP.2; 6.RP.3; 7.RP.1; 7.RP.2; 7.RP.3; 6.RP.2; 6.RP.3; 7.EE.2; 6.NS.1; 6.EE.2; 7.NS.1; 7.NS.3; 6.NS.2; 6.NS.3; 6.NS.5; 7.NS.1; 7.NS.2; 7.NS.3; 6.SP.1; 6.SP.2; 7.SP.2A.APR.1; A.APR.7; N.RN.3; N.Q.1; G.MG.3; S.ID.1; S.ID.2; S.ID.4; S.IC.6
WordTables;
Document setup;
Documents (newsletters, papers, brochures)
Columns and rows;
Arrays;
Matrices;
Decimals and fractions;
Proportion;
Scale;
Ruler;
Ratio
6.NS.2; 6.NS.3; 7.NS.1; 7.EE.3; 6.NS.2; 6.NS.3; 6.NS.5; 7.NS.1; 7.NS.2; 7.NS.3; 6.NS.1; 6.EE.2; 7.NS.1; 7.NS.2; 6.RP.1; 6.RP.2; 6.RP.3; 7.RP.1; 7.RP.2; 7.RP.3A.APR.1; A.APR.7; N.RN.3; N.Q.1; G.MG.3; S.ID.1; S.ID.2; S.ID.4; S.IC.6 A.APR.1; A.APR.7; N.RN.3; N.Q.1; G.MG.3
PowerPointKeynotes;
Transitions;
Animation;
Actions
Columns and row;
Arrays;
Matrices;
Decimals and fractions;
Proportion;
Scale;
Ruler;
Ratio/Rates;
Time/Order
6.NS.2; 6.NS.3; 7.NS.1; 7.EE.3; 6.NS.2; 6.NS.3; 6.NS.5; 7.NS.1; 7.NS.2; 7.NS.3; 6.NS.1; 6.EE.2; 7.NS.1; 7.NS.2; 6.RP.1; 6.RP.2; 6.RP.3; 7.RP.1; 7.RP.2; 7.RP.3A.APR.1; A.APR.7; N.RN.3; N.Q.1; G.MG.3
PhotoshopResolution;
Rate;
Photo editing;
Resizing an image
Ratio;
Proportion;
Scale;
Equivalent fractions
6.RP.1; 6.RP.2; 6.RP.3; 7.RP.1; 7.RP.2; 7.RP.3; 7.EE.3G.MG.3
Basic htmlFlash;
Writing html;
Linking html
Functions;
Measurement;
Scale;
Tables
6.RP.1; 6.RP.2; 6.RP.3; 7.RP.1; 7.RP.2; 7.RP.3; 7.EE.3G.MG.3
AccessComputed fields;
Inventory;
Sales;
Contracts;
Queries
Computed fields;
Inventory;
Sales;
Contracts;
Queries
6.NS.2; 6.NS.3; 7.NS.1; 7.EE.3A.APR.1; A.APR.7; N.RN.3; N.Q.1; S.CP.1