Original Content: Tools & TemplatesSince TICAL is a portal, most of the resources you'll find in the database live elsewhere on the web. However, TICAL has created the following original content for use by our registered members.
| ||||||||||||||||||||
|
Tools & Templates: Curriculum Integration
| ||||||||||||||||||||
 | |
| California Middle School Standards Matricies and Electronic Learning Resources (ELRs) This Excel® template is designed to help administrators and teachers quickly find an ELR by English-Language Arts standard as well as providing you an easy-to-view representation of the standards. The California Learning Resource Network (CLRN) has gathered several ELRs. All of these have been reviewed for effectiveness and relevance to their appropriate grade level and content standards. This template will help you integrate technology in a standards-based curriculum. | |
| |
| High School Diploma Student Course Plan This Excel® template is designed as a keep track sheet for students in alternative high school diploma programs. These programs include Adult Education, Continuation, Independent Study, and home schooling. | |
Tools & Templates: Data-Driven Decision Making
 | |
| Data Analysis with Excel Need to collect and analyze California Standards Test data? Check out these easy-to-use templates developed by Michael Nunn, consultant with CTAP 11, Los Angeles County Office of Education. | |
 | |
| Dropping Out of School is One of the Key Social Challenges of Our Time This pdf matrix lays out what the California Department of Education (CDE) is currently doing and planning on doing to improve dropout reduction in California. Written by the Middle & High School Improvement Office and Educational Options Office under the Secondary, Postsecondary, & Adult Leadership Division, the matrix is designed to provide you with specific programs offered by the CDE and research linking to additional information including locations on the CDE website for best practices, dropout prevention, and much more! | |
| |
| Google Forms Template: Classroom Referral, Dean's Office, and Behavior Intervention Form Use this Google form template from any computer or PDA with Internet connectivity by sharing the URL with your teachers. No more paper referrals for students to take with them to the office. Once a teacher completes the form online, office staff will have access to the behavior. Or, clerical staff can enter data from the paper onto the digital form. This form provides an easy way to search for students, teachers who submitted referrals, and quick access to common misbehaviors. Detailed tutorial provided. | |
| |
| Google Forms Template: Classroom Walkthrough and Observation Form Courtesy of Kern Kelly and Fred Johnston,use this Google Form from any computer or PDA with Internet connectivity to evaluate teachers' lessons, pedagogy, and classroom climate. Feel free to modify to fit your district's standards. All data will be recorded in a Google Spreadsheet and a second sheet has been created to quickly printout the results for the teachers and your records. Simply use the "hide column(s)" function in Excel to only show the specific teacher you want a printout for. | |
| |
| Google Forms Template: Classroom Walkthrough and Observation Form with Disaggregate/Aggregate Data Use this Google Form from any computer or PDA with Internet connectivity to evaluate teachers' lessons, pedagogy, and classroom climate, and California Standards for the Teaching Profession (CSTPs). All data will be recorded in a Google Spreadsheet and several other sheets are also provided that will automatically disaggregate and aggregate the data based upon teacher, teacher standards, observer and much more! | |
| |
| Google Forms Template: School Climate Survey -- Analyzing Teaching and Learning, Safety, Relationships, and Institutional Environments With this Google Form template you can survey three different stakeholder groups, students, teachers, and parents, to access data relating to school climate. You will see where perceptions lie within each stakeholder group and make a plan to improve school climate. The data dissagregates into four areas relating to school climate: teaching and learning, safety, relationships, and institutional environments. These areas correlate to research published by the National School Climate Center | |
| |
| Google Forms Template: Teacher self-assessment on the National Education Technology Standards (NETS·T) With this Google form template you can survey your teachers to determine how well they perceive their use of technology in the design and implementation of their lessons. | |
| |
| How to use Electronic Learning Assessment Resources (ELAR) Web site This tool was designed by the ELAR staff to assist you in navigating the Web site. It was prepared for beginning to advanced users of data-driven resources in hopes of helping you make decisions based on data. This document is broken down by concept, where to find the resource on the site, and a direct URL link. | |
| |
| Identify Program Elements to Improve Student Achievement (AOP Form) The Analysis of Process (AOP) worksheet will assist you in the identification of elements of a school program that can help you improve student achievement. This tool is referenced in the article "A Data-Driven Organization's Approach to Assessing The Quality of Program Delivery" written by Jim Cox and available online in Portical's Expert Opinion area. A template for the worksheet and a sample are available in HTML and PDF formats. | |
| |
| Instructional Program Summary This Excel® template is designed to help administrators determine the instructional hours being spent in each content area. This template will also graph the data so you can see how content areas (Language Arts, Reading, Math, Science, and Social Studies) are prioritized by your teachers. | |
| |
| Just for the Kids-California (JFTK-CA) Best Practices This 15-minute presentation will explain the many resources and specific practices collected from high performing school across the country found on the free, online data and school improvement system called Just for the Kids-California. You will be walked through the Best Practices area of the Web site and even be shown how to assess your own school, district, and/or classroom to assist you in data-driven decision making. | |
| |
| Lesson Plan Collection Form Using the SIOP (Sheltered Instruction Observation Protocol) Model Collecting lesson plans from teachers can be a tedious task, but it is a great to see how teachers how engaging students, differentiating learning, integrating technology, and implementing a variety of instructional strategies and assessments. This Google Form Template will allow you analyze lesson plans and identify SIOP strategies being implemented and where there may be gaps in instructional practice. It provides a searchable database to quickly search for key strategies as well as providing an anonymous list of lesson plans stripping out the teachers' names to share with staff and the larger school community if you wish. | |
| |
| Organize and Chart Student Scores An Excel template that can be used to enter and analyze student assessment data. For more information on how this template was first developed and used, see Using Technology to Make Sense of Data by Dan Ryder, here on the Portical web site. | |
| |
| School Supply Request Form Do you still have teachers submitting requests for supplies or room scheduling through email or paper forms? How are you keeping track of teachers’ usage? This Google Form template is a simple form to send to your staff in which they can enter equipment, supplies such as paper, markers, paper clips, pencils, projector bulbs, cables, etc. and quantities they need. You can then have support staff review the list and send supplies down immediately. You can then keep track on teacher usuage all on one spreadsheet. Also included are room requests so you can work with staff to schedule rooms such multipurpose rooms, library, and more! | |
| |
| Survey Templates Ready to Administer Using Google Forms These Microsoft Excel files were created to provide you quick access to surveys you can administer in your school or district using Google Forms (a subset of Google Docs). You can either obtain a direct copy of the survey to send to your participants immediately OR you can load the original spreadsheet into Google Docs and create the survey from the spreadsheet. | |
| |
| Track Legislative Bills and Information The Official California Legislative Information Web site is maintained by the Legal Counsel of California. This downloadable tip sheet,available as a PDF, will assist you in locating and tracking legislative bills and information for California. | |
| |
| Tracking Arkansas Legislative Bills and Information TICAL Arkansas cadre member Phoebe Bailey developed this simple step sheet to help you take advantage of the General Assembly web site to locate and track pertinent legislation. | |
Tools & Templates: Financial Planning
| |
| New Programs Funding Calculator 2006-2007 was a great year for funding special projects, that is if you know the strings attached, how the funds are calculated and if you qualify. How does an administrator figure out what monies are available this year for technology projects? Here is a great resource created by our friends in the Arvin Union School District, Bakersfield, CA. Calculations, explanations and more can be found on this user friendly spreadsheet. Impress you business department with the amount of knowledge gained from this resource. Knowledge is power. Post 2006-2007, use this as a template for creating your own customized version with current year data. | |
| |
| School Supply Request Form Do you still have teachers submitting requests for supplies or room scheduling through email or paper forms? How are you keeping track of teachers’ usage? This Google Form template is a simple form to send to your staff in which they can enter equipment, supplies such as paper, markers, paper clips, pencils, projector bulbs, cables, etc. and quantities they need. You can then have support staff review the list and send supplies down immediately. You can then keep track on teacher usuage all on one spreadsheet. Also included are room requests so you can work with staff to schedule rooms such multipurpose rooms, library, and more! | |
| |
| Technology Funding Sources for Schools Looking for technology funding? This page offers a few key links to help you know what technology dollars are available from government, foundation, and corporate sources. | |
Tools & Templates: Operations and Maintenance
| |
| Average Enrollment and Projection Template for K-3 Class Size Reduction Are you an elementary school administrator wondering how close the classrooms are from full capacity? This Excel® template will help you determine your school's compliance towards Class Size Reduction by calculating average daily enrollment (if your Student information System does not). It will also project the number of days that are needed to move students from one class to another in order to become compliant. This template will save you hours and will lower your anxiety in meeting requirements. | |
| |
| Bell Schedule and Instructional Minutes These scheduling templates contributed by cadre member Chris York will help create your bell schedule whether you are starting from scratch or already have an existing schedule to work with. Each Excel® template automatically calculates the passing or recess time per day, the amount of time school is in session per day, and the total annual minutes of instructional time. You can ensure you are meeting the state’s or district’s requirements. The template also gives you the option to enter your articulation/collaboration schedule and minimum day schedule. | |
| |
| Internet and Media Publishing Consent and Waiver Form These templates in both Spanish and English can be downloaded, modified, and printed to obtain parental consent for students who publish their work and/or photos and videos online. A signed consent form allows the school or district to also publish photographs and videos of students. | |
| |
| Software Implementation Toolkit In this 15-minute narrated presentation, Jason Borgen summarizes the Software Information Industry Association's Software Implementation Toolkit to help educational institutions implement worthwhile software in a systematic way. The toolkit provides users with several worksheets that are beneficial for any implementation process. This presentation also provides you with a link to the actual 55-page document. | |
| |
| Web 2.0 Tools for Busy Administrators In this 11 minute presentation, author and consultant Susan Brooks-Young provides a quick overview of what Web 2.0 is and then shares a concrete example of how a group of educators in Northern California used an on-line group, a wiki, and a "web-top" word processor to help them complete a collaborative planning process. | |
Tools & Templates: Professional Development
| |
| Certiport Monthly Feedback Form Developed by Certiport, a technology certification company, this form is a tool the company uses internally to develop critical skills and behaviors in its own workforce. Certiport President and CEO David Saedi has given TICAL permission to share the form as an example of one way to measure certain 21st century skills. | |
| |
| How to use Electronic Learning Assessment Resources (ELAR) Web site This tool was designed by the ELAR staff to assist you in navigating the Web site. It was prepared for beginning to advanced users of data-driven resources in hopes of helping you make decisions based on data. This document is broken down by concept, where to find the resource on the site, and a direct URL link. | |
| |
| Quick Takes: Google Forms This Quick Take shows you how to use Google Forms, a subset of Google Docs, to gather survey data for your data-driven decisions. You will learn how to create your own Google Form and distribute an unlimited amount for free! | |
| |
| Social Media Handbook For Administrators Use this 11-page document to get an overview of using social media in a leadership role. Also use the tool to pull talking points with staff and stakeholders to develop a communication and professional development plan using social media. Included are resources, research, tools, and templates. | |
| |
| Step Sheets Looking for a tutorial on programs such as Microsoft Office? Chris York, Director of Technology for Del Norte Unified School District, developed these step sheets to help his staff be more productive. You can download and use them as well. Titles include: Beginning Word, Creating Tables, Mail Merge in Word, Excel Quick Start Guide, Using AutoFilter in Excel, Using Publisher, and PowerPoint 101. These tools are useful for administrators, office staff, and classroom teachers. | |
| |
| Streamlining Lesson Plan Collection Using Google Docs and the SIOP (Sheltered Instruction Observation Protocol) Model In this 9-minute tutorial, Jason Borgen steps you through setting up a Google Account, uploading the Excel SIOP lesson plan template, and sharing the template with all your teachers. Now you will be able to collect lesson plan submissions from your teachers on one paperless form, as well as giving you and your teachers the opportunity to quickly view lessons and assess which SIOP strategies are being used. The lesson plan template is also provided here. | |
| |
| TICAL's Top 10 Original Content for Principals This list of resources were developed by TICAL cadre and staff to streamline your leadership and management tasks. These resources are considered the most popular on the TICAL web site. These resources include time planning templates, cyber safety tutorials, bell scheduling templates, and much more. A print version is also available to handout in your meetings. | |
| |
| Time Planner Whether you’re planning a 90-minute staff meeting or a five-day workshop, this easy-to-use Excel template will help you allot time among the various topics and activities you want to include. Enter your starting and ending times; then, as you add each item, the worksheet automatically calculates how much time you’ve used and how much you have left. Contributed by TICAL Arkansas cadre member George Lieux. | |
Tools & Templates: Technology Planning
| |
| Backwards Mapping Tool Backwards mapping can be a very effective strategy for confronting all sorts of educational challenges. This simple, Windows®-based tool walks you through the basic steps of backwards mapping from defining your end goal to developing a basic action plan. | |
| |
| California Middle School Standards Matricies and Electronic Learning Resources (ELRs) This Excel® template is designed to help administrators and teachers quickly find an ELR by English-Language Arts standard as well as providing you an easy-to-view representation of the standards. The California Learning Resource Network (CLRN) has gathered several ELRs. All of these have been reviewed for effectiveness and relevance to their appropriate grade level and content standards. This template will help you integrate technology in a standards-based curriculum. | |
| |
| Tracking Arkansas Legislative Bills and Information TICAL Arkansas cadre member Phoebe Bailey developed this simple step sheet to help you take advantage of the General Assembly web site to locate and track pertinent legislation. | |
| |
| Web 2.0 Tools for Busy Administrators In this 11 minute presentation, author and consultant Susan Brooks-Young provides a quick overview of what Web 2.0 is and then shares a concrete example of how a group of educators in Northern California used an on-line group, a wiki, and a "web-top" word processor to help them complete a collaborative planning process. | |