redhot form 1. smk karak. institute tracker
TRANSCRIPT
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
1/19
s - Mastery Tracking Worksheets designed to track students' objective and standard mastery on standards-aligned unit
n the + sign to the left of the headings below to set up and begin using this tracking system.
abulary
you will want to know in order to interpret the following instructions:ere you type in Exel. Each cell has a reference that is a combination of column & row, i.e.
whole Excel file is called a workbook. A workbook may have many pages of data.
page, or tab, of data is called a worksheet. Each worksheet has a tab at the bottom of the
ows its name. The tab is white when that worksheet is active.
as the capability of calculating data based on formulas, which we have entered for you.
e quite complicated, but generally will perform a series of calculations to yield a data result
not type into cells that contain formulas, because you will erase the formula!
columns can be put into groups, which is a kind of "outline" system. Groups can be
expanded (in view). Click on the + and - signs in boxes along the left and top grey bars to
Y DATA INTO THE SUMMARY SHEET
acking system
tudents' names on the green Benchmarks tab, in Column A beginning with Row 10. There
50 students per section. Please skip to the next grouping for your next class of students, so
on remain intact. Do NOT type student names into the yellow cells that are section headers.
es will automatically show up on the rest of the class rosters, by unit and on the Summary
d to type your students' names one time. If you do type a student's name into the Summary
ou will be over-writing the formula that automatically populates the names, and this
st in the cell you typed in.
me into cell A2 (Teacher). Your name will automatically show up at the top of the Summary
your Long-Term plan, you will enter the Standards and Objectives for each of your Units
ark assessments. Your region may have entered some of these for you. Standards refer to
a State or District Standard. Objectives are daily or weekly, measurable components ofndards and Objectives into the columns for each Benchmark and Unit assessment: If
a Word document of your Standards & Objectives, copy the text by selecting it and hitting
-click the cell where you want the objective to be, and hit "Ctrl-V." This will paste the
. If you are working from an Excel document, double-click on the cell containing the text
elect it. Hit "Ctrl-C" to copy the text. Then go to the cell where you want the text to be, and
rl-V" to paste the text into that cell.
PY OF THE TRACK ING SYSTEM TO YOUR COMPUTER's HARD DRIVE!You cannot
t Achievement Toolkit CD. You will want to save your work periodically while you are setting
t you don't lose your work! Once you have data in your tracking system, it will also be
pies in two places, such as on your computer's hard drive and also on a jump drive or online
delete unused columns! The formulas will continue to work with blank columns in there.
mns runs the risk of creating formula errors!!
type data into any yellow-shaded cells as they contain formulas that will automatically
u type data into any yellow-shaded cell accidentally, immediately hit Ctrl-Z and then Enter to
move off that cell.
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
2/19
of the Excel window) the formulas on the Summary tab will break, and you will be unable to
ss units. You may change the Unit names (in grey cells) on the Summary tab- that will not
enchmarks Tab
Benchmarks tab at the bottom of the workbook to insert data from the beginning of the yearso use this tab to record mid-year and end of year assessment data.
+ sign above the diagnostic/assessment where you want to input data. This will expand the
r this assessment.
+ sign for the class section whose data you want to enter. This will show you all the students
dent's score (range 0-100) on each Standard for that diagnostic/assessment into the white
s = 100%. If you enter a 1, your system will display results of 1% mastery.
ert the data, the system will automatically calculate averages.
type data into any yellow or blue-shaded cells as they contain formulas that will
e results. If you type data into any yellow or blue-shaded cell accidentally, immediately hit
to undo your typing and move off that cell.
nit Tabs
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
3/19
: Shu Ann and Ainu ie Fellow #1
ak ie SMK Karak
HOT ie Rainbow Troopers
Math EOY Assessment
c English EOY Assessment
ening #DIV/0! Speaking and Listening #DIV/0!
#DIV/0! Reading #DIV/0!
#DIV/0! Writing #DIV/0!
STUDENT ACHIEVEMENT SUMMARY
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
4/19
Mastery
ges
k Results
Growth in
Mastery Beginningof
Year
Diagnostic
Representafraction
withadiagram
Determinethe
positionofafraction
onanumber
line
Arrangefractio
nsin
order
Simplifyfractions
intolowestte
rms
Convertmix
ed
numbersto
improperfractions
andviceversa
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
5/19
Solveproble
ms
involving
combinationsof
wholenumbers,
Solvemathem
atical
wordproblem
sin
situations
Represent1/10and
1/100asdecimals
andviceversa
Statethepla
ce
valueandvalueof
digitsindecim
als
Comparevaluesfor
twodecima
ls
Roundoffdecimals
Performaddition,
subtraction,
multiplication
and
divisionopera
tions
Solveproble
ms
involving
combinationsof
wholenumbers,
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
6/19
Stateandwrite
integers
Comparethev
alues
oftwointegers
Arrangeintegersin
order
Writepositiveor
negativenumb
ersto
representword
description
Solveinteg
er
problemsinvo
lving
additionan
d
subtraction.
Solveproble
ms
involvingadd
ition
andsubtractionof
integers
Convertfractions
anddecimalsto
percentages
and
viceversa
Identifyincrea
sing
anddecreas
ing
percentage
s
Solveproblemsthat
involvepercen
tages
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
7/19
Identifylikeand
unlikealgebraic
termswitho
ne
unknown
Stateliketerm
sfor
agiventerm.
Identifyalgeb
raic
expression
s
Determinethe
numberoftermsin
analgebra
ic
expression
EndofYear
Assessme
nt
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
8/19
S&L Reading Writing
THE WHITE CELL
Mastery
ges
k Results
Growth in
Mastery BeginningofYear
Diagnostic
SWBATasksimple
questionsto
get
informationa
nd
respond
SWBATasksimple
questionsto
get
informationa
nd
respond
SWBATintroducea
friendusing
suggestedsentence
pattern
SWBATmakeplans
togosomewhere/to
dosomething
SWBATlistento
andmakeplansto
gosomewhere/todo
something
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
9/19
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
10/19
SWBATconvey
mainideasa
nd
supportingde
tails
SWBATiden
tify
mainideasina
lineartexts
by
answeringtru
eor
SWBATfind
the
meaningo
f
unfamiliarwordsby
usingcontextual
SWBATfind
the
meaningo
f
unfamiliarwordsby
usingcontextual
SWBATiden
tify
adverbsin
a
paragraph
SWBATiden
tify
pluralform
s
SWBATiden
tify
contraction
s.
SWBATiden
tify
adjectivesin
a
paragraph
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
11/19
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
12/19
SWBATapply
processwriting
skillsby:a
)
discussingthe
topic
SWBATidentifythe
mainideasin
non-
lineartextsby
answeringtru
eor
SWBATiden
tify
causeandeffect
relationships
ina
factualtextby
SWBATtoob
tain
informationfrom
non-lineartextsby
fillingintheblanks
Standard13SW
BAT
providesuppo
rting
detailsinnon-linear
textsbyanswering
SWBATiden
tify
partsofaninfo
rmal
letter
SWBATapply
processwriting
skillsby:e)proof-
readingthedraftto
SWBATapply
processwriting
skillsby:d)rev
ising
andeditingthe
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
13/19
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
14/19
EndofYear
Assessme
nt
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
15/19
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
16/19
Skill 77% 74% 80%
77.00% 77% 74% 80%
60.00% 60% 60
75.00% 75% 70 80
60.00% 60% 60
80.00% 80% 80
90.00% 90% 100 80
Week4
Week3
Objective12
SWBAT
solveproblems
involving
combinationsof
SWBATsolve
mathematical
problemsin
situations
Objective10
Objective11
SWBATsimplify
fractionsintolowest
terms
SWBATConvert
m
ixednumbersto
improperfractions
andviceversa
S
WBATdetermine
th
elowestcommon
multipleoftwoor
threegiven
SWBAT
performaddition,
subtraction,
multiplicationand
Student
Mastery
Average
tery
Week2
Week1
SWBATrepresenta
fractionwitha
diagram
S
WBATdetermine
thepositionofa
fractionona
numberline
SWBATarrange
fractionsinorder
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
17/19
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
18/19
-
7/28/2019 Redhot Form 1. SMK Karak. Institute Tracker
19/19
Objective11
Objective12
Objective7
Objective8
Objective9
Objective10
Objective3
Objective4
Objective5
Objective6
Objective12
Objective1
Objective2
Objective8
Objective9
Objective10
Objective11
Objective4
Objective5
Objective6
Objective7
Objective1
Objective2
Objective3
Objective9
Objective10
Objective11
Objective12
Objective5
Objective6
Objective7
Objective8
Objective1
Objective2
Objective3
Objective4
Objective10
Objective11
Objective12
Objective6
Objective7
Objective8
Objective9
Objective5