Technology Information Center for Administrative Leadership

 

Original Content: Tools & Templates


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


Click to customize
current view.

Show
All

Multimedia

Tools &
Templates

Expert
Opinion

Stories

multimedia tools and templates expert opinion stories

Leading Digitally, the Admin 2.0 Webinar Series

Tools & Templates: Curriculum Integration
 
tools and templates
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.

tools and templates
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.

multimedia
tools and templates
Mobile Technology for Learning
Trying to get a handle on mobile technologies for learning? Mobile is where it's at. Check out TICAL's Mobile Technologies for Learning mind map. You'll find planning support, apps, sample policies, devices, and uses.

Tools & Templates: Data-Driven Decision Making
 
multimedia
tools and templates
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.

tools and templates
expert opinion
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!

tools and templates
Google Form Template: Bullying Report Form
Use this template with Google Forms to embed in your website or elsewhere for students to use any device to report acts of bullying. The report sheet provides administrators access to quantitative reports on the types of bullying that has been reporting. Also allows for simple comparison during different time intervals and to quickly search for previous offenders. Great way to have students report bullying in a non-confrontational way.

tools and templates
Google Form Template: Learning Management System (LMS) Feedback Survey and Evaluation
As you begin to transition to online or blended learning in your school/district or just want to provide teachers the opportunity to create a paperless learning environment selecting the right LMS can be a daunting task as there are pros and cons for each. Use this survey and evaluation form developed by the Oxnard Union High School District to strategically qualitatively and quantitatively determine the pros and cons of each including teaching and learning functionality as well as layout, ease of use, and ubiquitous access.

tools and templates
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.

tools and templates
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.

tools and templates
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!

tools and templates
Google Forms Template: SBAC/CAASPP Debrief Survey
Use these Google Form Templates developed at the San Mateo County Office of Education with support from the CISC Online Learning Collaborative Subcommittee (OLCS)as an option to access data from the relevant stakeholders including students, teachers/test administrators, and administrators. These templates can be used county/region-wide or just in a district or site. Questions relating to testing environment, preparation, and devices are all included.

tools and templates
Google Forms Template: SBAC/PARCC Teacher Reflection Survey
Use this Google Form to quickly obtain feedback once you have completed student testing. You can view the results by simply clicking on the “Form” menu and selecting “Show summary of responses.” The data can be used to assist your site or district’s next steps in preparing staff and students for future assessments.

tools and templates
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

tools and templates
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.

tools and templates
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.

tools and templates
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.

tools and templates
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.

multimedia
tools and templates
expert opinion
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.

tools and templates
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.

tools and templates
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.

tools and templates
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!

tools and templates
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.

tools and templates
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.

tools and templates
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
 
tools and templates
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.

tools and templates
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!

tools and templates
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
 
tools and templates
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.

tools and templates
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.

tools and templates
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.

tools and templates
expert opinion
Local Control Accountability Plan (LCAP) Technology Recommendations
Use this to document to assist your district in developing goals relating to innovation and technology focusing on 21st Century learning outcomes for students and other stakeholders. The document lists separate Goals, Actions, Technology Recommendations, and TICAL Resources in each of the eight priority areas. This document can assist you in developing goals that insure digital access, communication, and curricula. The TICAL Cadre assisted in these recommendations to insure relevant and thoughtful considerations for digital-age learning and Common Core implications.

multimedia
tools and templates
expert opinion
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.

multimedia
tools and templates
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
 
tools and templates
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.

tools and templates
Google FormEmailer Script Step Sheet and Tutorial
This document will walk you through how to Use the FormEmailer Script with Google Forms for Automatic emailing of data. Whether you use Google Forms for classroom walkthroughs, event registrations, parent surveys, lesson plan collection, etc. you can have the data automatically formatted in an email to the respondent and any other stakeholders of your choosing with the script.

tools and templates
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.

multimedia
tools and templates
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!

tools and templates
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.

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.

multimedia
tools and templates
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.

tools and templates
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.

tools and templates
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
 
tools and templates
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.

tools and templates
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.

tools and templates
expert opinion
CalMAPP/SBAC/PARCC Preparation Checklist
This resources provides administrators resources in implmentation and administration of the next generation, Computer Adaptive Testing (CAT). While emphasis is placed on California’s CalMAPP/SBAC assessments, this document's resources are relevant to all CAT programs. Though this list is not exhaustive, it should provide school and district administrators with a foundational list in order to start the planning process toward the implementation of the field test.

tools and templates
Google Form Template: Bullying Report Form
Use this template with Google Forms to embed in your website or elsewhere for students to use any device to report acts of bullying. The report sheet provides administrators access to quantitative reports on the types of bullying that has been reporting. Also allows for simple comparison during different time intervals and to quickly search for previous offenders. Great way to have students report bullying in a non-confrontational way.

tools and templates
Google Form Template: Learning Management System (LMS) Feedback Survey and Evaluation
As you begin to transition to online or blended learning in your school/district or just want to provide teachers the opportunity to create a paperless learning environment selecting the right LMS can be a daunting task as there are pros and cons for each. Use this survey and evaluation form developed by the Oxnard Union High School District to strategically qualitatively and quantitatively determine the pros and cons of each including teaching and learning functionality as well as layout, ease of use, and ubiquitous access.

tools and templates
Google FormEmailer Script Step Sheet and Tutorial
This document will walk you through how to Use the FormEmailer Script with Google Forms for Automatic emailing of data. Whether you use Google Forms for classroom walkthroughs, event registrations, parent surveys, lesson plan collection, etc. you can have the data automatically formatted in an email to the respondent and any other stakeholders of your choosing with the script.

tools and templates
Google Forms Template: SBAC/CAASPP Debrief Survey
Use these Google Form Templates developed at the San Mateo County Office of Education with support from the CISC Online Learning Collaborative Subcommittee (OLCS)as an option to access data from the relevant stakeholders including students, teachers/test administrators, and administrators. These templates can be used county/region-wide or just in a district or site. Questions relating to testing environment, preparation, and devices are all included.

tools and templates
Google Forms Template: SBAC/PARCC Teacher Reflection Survey
Use this Google Form to quickly obtain feedback once you have completed student testing. You can view the results by simply clicking on the “Form” menu and selecting “Show summary of responses.” The data can be used to assist your site or district’s next steps in preparing staff and students for future assessments.

tools and templates
expert opinion
Local Control Accountability Plan (LCAP) Technology Recommendations
Use this to document to assist your district in developing goals relating to innovation and technology focusing on 21st Century learning outcomes for students and other stakeholders. The document lists separate Goals, Actions, Technology Recommendations, and TICAL Resources in each of the eight priority areas. This document can assist you in developing goals that insure digital access, communication, and curricula. The TICAL Cadre assisted in these recommendations to insure relevant and thoughtful considerations for digital-age learning and Common Core implications.

multimedia
tools and templates
Mobile Technology for Learning
Trying to get a handle on mobile technologies for learning? Mobile is where it's at. Check out TICAL's Mobile Technologies for Learning mind map. You'll find planning support, apps, sample policies, devices, and uses.

tools and templates
expert opinion
Top 7 Ideas to Promote Digital Citizenship for School and Distrct Leaders
Looking for ideas to promote digital citizenship? Thinking of innovative ways to stay in compiance with eRate laws relating to integrating digital citizenship within the curriculum? This one-page document provides creative ways to get your entire school or district as well as all stakeholders involved in teaching and learning with digital citizenship and cybersafety.

tools and templates
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 and templates
expert opinion
Transitioning A School Gmail Account to a Personal Account
Chris York developed this tutorial to assist employees who are leaving the district to have access to emails and information stored in their district-provided Gmail Account. This can also be used to migrate existing emails from your personal Gmail account to a school or district email account.

multimedia
tools and templates
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.