Information Technology
Curriculum Maps

Post

Information Technology Curriculum Map (PDF)

CTE Course/Unit

CTE Concepts

Math Concepts

Middle School Common Core Math Standards

High School Common Core Math Standards

Excel

Payroll;
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.2

A.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

Word

Tables;
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.3

A.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

PowerPoint

Keynotes;
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.3

A.APR.1; A.APR.7; N.RN.3; N.Q.1; G.MG.3

Photoshop

Resolution;
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.3

G.MG.3

Basic html

Flash;
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.3

G.MG.3

Access

Computed fields;
Inventory;
Sales;
Contracts;
Queries

Computed fields;
Inventory;
Sales;
Contracts;
Queries

6.NS.2; 6.NS.3; 7.NS.1; 7.EE.3

A.APR.1; A.APR.7; N.RN.3; N.Q.1; S.CP.1