Spreadsheets
Competency F - The teacher candidate demonstrates the ability to use spreadsheets.
Gateway Requirement: Gateway 2 — Admission to Student Teaching (STT Gateway)
See the Competency Homepage for courses associated with this competency.
Authentic Performance Task: In order to demonstrate this competency, the student 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 the student will sort data in multiple ways and create a chart or graph using axis labels and titles.
Why teachers 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
Criteria: 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
Click here for an example that fulfills these criteria.
Training Resources: Course instructor will provide basic orientation, but students are responsible for learning the required skills using available resources. University computer labs provide hardware and software and access to on-line resources.
Submission Format: The student 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 the student’s electronic portfolio.
Scoring Rubric: A scoring rubric provides definitive criteria for assessing this competency. See the Evaluation web page for required elements.
Passing Criterion: 100% level of performance for the technical criteria.
competencies | resources | evaluation | faculty | contact us | home
