Example Template Checklist with Script

	A	B	C	D	E	F	G	H
1	CST Math Review Topics	File ID
2		Owner
3		Title
4	Skill	Status	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!
5	How to find the DISTANCE between two points	No	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
6	How to find the MIDPOINT between two points	No
7	How to find the point that divides a line into a given RATIO	No
8	How to find the slope of a line	No
9	How to express an equation in both STANDARD AND GENERAL FORM	No
10	How to find the equation of a line given the slope and a point on the line	No
11	How to find the equation of a line given two points on the line	No
12	How to find the equation of a line parallel to a given line	No
13	How to find the equation of a line perpendicular to a given line	No
14	How to determine the number of solutions in a system (parallel, coincident…)	No
15	How to translate a story into a SYSTEM OF RELATIONS	No
16	How to solve a system of equations using the COMPARISON METHOD	No
17	How to display a system of relations and their solution on a graph	No
18	How to solve a system of equations using the ELIMINATION METHOD	No
19	How to solve a system of equations using the SUBSTITUTION METHOD	No
20	How to determine and interpret the following properties in functions:	No
21	 What is a function	No
22	 The domain and range of a function	No
23	 Where the function is increasing, constant and decreasing	No
24	 The minimum and maximum	No
25	 The sign of a function	No
26	 The y-intercept of a function	No
27	 The zeros of a function (x-intercepts)	No
28	How to work with the following functions (words, graph, equation, table):	No
29	 Zero degree	No
30	 First degree (direct)	No
31	 First degree (partial- positive and negative slopes)	No
32	 2nd degree (quadratic) function ( )	No
33	 Exponential function (growth and decay) ( )	No
34	 Step function	No
35	 Periodic function	No
36	 Piecewise function	No
37	How to find an angle measure using TRIGONOMETRIC RATIOS (SIN, COS, TAN)	No
38	How to find a side measure using TRIGONOMETRIC RATIOS (SIN, COS, TAN)	No
39	How to find an angle or side measure using SINE LAW	No
40	How to find the AREA OF A TRIANGLE- all three methods:	No
41	 General formula	No
42	 Hero’s formula	No
43	 Trigonometric formula	No
44	How to apply CLASSIFICATION OF TRIANGLES	No
45	How to use PYTHAGOREAN THEOREM	No
46	How to explain the differences in the properties of QUADRILATERALS	No
47	How to find the areas of triangles/quadrilaterals/regular polygons	No
48	How to determine the angle relationships when parallel lines are involved	No
49	How to use algebra and angle relationships to solve for an unknown (x)	No
50	How to prove that two triangles are congruent (SSS, SAS and ASA)	No
51	How to prove that two triangles are similar (SSS, SAS and AA)	No
52	How to find the unknown side lengths in similar figures	No
53	How to find side lengths using METRIC RELATIONS	No
54	How to read a FREQUENCY TABLE	No
55	How to make and read a STEM AND LEAF PLOT	No
56	How to calculate MEAN DEVIATION (and what it tells you about the data)	No
57	How to calculate PERCENTILE RANK (and what it means)	No
58	How to find a score of place GIVEN PERCENTILE RANK	No
59	How to read a CONTINGENCY TABLE	No
60	How to make and interpret a SCATTER PLOT	No
61	How to estimate the CORRELATION COEFFICIENT (and what it means)	No
62	How to determine the STRENGTH AND DIRECTION of the CORRELATION COEFFICIENT	No
63	How to determine and represent the EQUATION OF A REGRESSION LINE	No
64	How to draw a curve associated with the chosen model	No
65	How to interpolate or extrapolate values using a REGRESSION LINE	No
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100