Jump over the site's left-side navigation bar.
Teacher Education Requirements
ITPS F: Spreadsheets
The teacher candidate demonstrates the ability to use spreadsheets.
When should ITPS F be completed?
For specific details related to when this competency should be fulfilled, download the teacher education requirements implementation grid (pdf).
Instructional Technology Passport System (ITPS)
ITPS F. Spreadsheets
In order to demonstrate this competency, you will create a spreadsheet that could be used for an educational purpose such as instruction, curriculum, and/or administration. The spreadsheet must contain at least ten rows of data, row and column headings, and at least 2 functions/formulas. In addition you will sort data in multiple ways and create a chart or graph using axis labels and titles.
As a teacher, you will need to be able to use spreadsheets:
- to organize traditional grade books by student and assignment, to use formulas for calculating averages and totals, to be able to sort by test/assignment scores and last name
- to be able to organize a budget, including calculations of totals, balances, formatting decimal places and dollar signs
- to be able to create student assignments that require the use of spreadsheets for organizing and charting data. For instance, comparison of statistical data on countries, population data in the U.S., scientific data related to growth rates, etc.
- To be able to read and interpret student and school data presented in spreadsheet form; to be able to sort and find patterns in data
The spreadsheet should contain the following elements:
- contains at least ten rows of data
- uses a function or formula to perform a calculation
- presents data that have been sorted by at least two criteria
- contains a graph/chart generated from tabulated data
Download an example that fulfills these criteria (pdf).
The course instructor will provide basic orientation, but students are responsible for learning the required skills using available resources. The Spreadsheet Creation workshop is available to help you gain the skills you need. Also, an online tutorial is available at the Internet4Classrooms Web site. University computer labs provide hardware, software, and access to online resources.
Assessment
Submission format
You must write a rationale for how this spreadsheet would be used for an appropriate educational purpose, and as well as the data analysis. A link to the spreadsheet must be included. All materials must be submitted in your electronic portfolio.