Directions for use:

General Directionso Please save a clean copy of this file in a safe location as a backup. o Only enter data into cells that are highlighted in pale yellow.

Most other cells are protected to prevent inadvertent data deletion.o Navigate between pages using the tabs at the bottom of the workbook labeled

“Minutes 1”, “Tchr1”, “Tchr2”, “Graphs”, etc. or by clicking on the hyperlink for the teacher page required.

o The minutes pages are currently formatted to print on four letter sized sheets with a portrait orientation.

o Click on the link labeled “Return to Cover” on any teacher page in order to go back to the cover page from an individual teacher data page or use the tabs at the bottom.

Cover Page:

o Enter the required information in the yellow cells next to the appropriate label. Example: Enter the name of the first teacher on the team next to the label

“Teacher 1” in cell C4.o Enter the subject being assessed and discussed.o Enter the name of the assessments in the appropriate cells.

Example: “Linear Equations” or “Linear Equations Preassessment” (quotation marks are not needed in the Excel template).

Note that the name entered here will be the title on top of the graphs automatically produced on the Graphs page.

© 2009 The Leadership and Learning Center Directions - SecondaryAll rights reserved. Copy only with permission. 866.399.6019 Page 1

o Enter the maximum score for the assessments. Example: “100” or “4”

o Enter the minimum score for proficiency or the lowest score a student could get and still be considered to have passed that assessment.

o Enter the score at which you would like to count a student as being “close” to proficiency.

Example: Enter a score of “50” if you would like any student scoring between a 50 and the minimum passing score as being “close” to proficient.

o Enter the minimum percentage of students desired before moving on the next area of focus.

Example: Enter “80” if your team has decided that they will move on to another unit of instruction after 80% or more of the teams’ students are proficient or better on this unit.

Teacher Pages

o Each teacher need only enter the numbers in the appropriate cells highlighted in yellow. The calculations for percentages and number far to go will be calculated automatically.

© 2009 The Leadership and Learning Center Directions - SecondaryAll rights reserved. Copy only with permission. 866.399.6019 Page 2

Minutes Pageso The teachers’ names, team name, and assessment title will automatically appear

on top of the assessment page as they are entered on the cover page.o Enter the date of the meeting in the appropriate yellow cell.o Step 1: Data

All calculations in the data table under step 1 will be performed automatically based on the data entered on the individual teacher pages.

o Step 2: Analysis Record your analysis in the table pictured above. Once you have

recorded all of your needs, indicate those needs that you have prioritized by placing a “1”, “2”, or “3” in the adjacent column. Please note that you will not be allowed to indicate more than three priorities or to indicate that needs have equal status. In other words, you may only have one number 1 priority, etc. A red highlight will indicate in errors you have made in prioritizing your needs. Your prioritized needs will appear again further down on the minute’s page as you begin to select instructional strategies and generate results indicators.

o Step 3: Goals The goal statement section is designed to collect information from the

team and suggest a possible goal statement. Enter the requested information in the appropriate yellow cells and that

information will automatically appear in the bolded goal statement. The number next to “Projected Goal” indicates the percentage of students

expected to be proficient if only those who are “close” to proficiency

© 2009 The Leadership and Learning Center Directions - SecondaryAll rights reserved. Copy only with permission. 866.399.6019 Page 3

currently are added to the percentage of students who are currently proficient or better. The projected goal can be modified up or down by entering a numerical adjustment in the cell marked “Adjustment.” Use a negative sign (-) before the number being entered if you wish to adjust the projected goal down. There is no need to enter a percentage sign (%) after the number.

o Step 4: Instructional Strategies Note that the list of instructional strategies included is not intended to be

exhaustive but rather to serve as a brainstorming prompt. The highest priority need is listed here as a reminder. Please record only the agreed upon instructional strategy in the first

column and then record other information in the subsequent columns as needed.

There is room for up to three instructional strategies (one per prioritized need).

o Step 5: Results Indicators Note that the prioritized need and agreed upon instructional practice are

repeated here to serve as reminders while completing this step of the process.

Describe the adult and student behaviors that would provide evidence of the actual use of the strategy as well as the “look-fors” in student work that indicate that the selected strategy is having the desired impact. Record in the appropriate yellow highlighted cells.

Graphs Page

© 2009 The Leadership and Learning Center Directions - SecondaryAll rights reserved. Copy only with permission. 866.399.6019 Page 4

o WARNING: Please note that while this page is protected you are currently able edit objects on this page. This means that it is possible to change the data that each graph depicts once you select it or that you can change the horizontal axis titles and other labels. If you should make a mistake just hit the undo button.

o Several types of graphs are automatically created on the Graphs Page. Titles for those graphs are created based upon the information entered on the Cover Page of the workbook.

o To print graphs, simply select the desired graph by clicking on it. Go to Print (can be found under the heading File in Excel 2003 or by clicking on the Office Button in the upper left hand corner of Excel 2007) and then select Print or Print Preview if you would like to view before printing. The charts are currently set up to print in landscape format but you may make modifications if you would like. You may also copy the charts and paste them into other applications such as Microsoft Word.

© 2009 The Leadership and Learning Center Directions - SecondaryAll rights reserved. Copy only with permission. 866.399.6019 Page 5