Study guide
Spreadsheets and Databases for Problem Solving
TExES Pedagogy and Professional Responsibilities EC–12 160
Track your progress as you read
Finished sections get a check mark.
1 Cognitive, Social, and Moral Development
Cognitive Development & Learning Stages (Piaget & Vygotsky EC-12) Psychosocial Development and Self-Efficacy Moral Reasoning and Classroom Applications
2 Physical Development and Responsive Planning
Motor Development and Adolescent Executive Skills Health Factors and Developmental Supports Developmentally Responsive Instruction and Transitions
3 Developmental Concerns and Adolescence
Asynchronous Development and Accessible Assessment Recognizing Developmental Concerns in EC–4 Adolescent Self-Image, Peer Influence, and Risk
4 Middle-Level Education and Life Skills
Middle-Level Education and School Transitions Life Skills, Decisions, and Student Responsibility
5 Student Backgrounds and English Proficiency
Cultural, Socioeconomic & Linguistic Diversity in the Classroom ELPS Implementation and Academic Language Proficiency Evidence, Scaffolds, and LPAC
6 Disability Rights and Advanced Learners
Disability Rights, Eligibility, and Inclusion ARD Roles, Accommodations, and Behavioral Supports Gifted and Talented Education & Universal Design for Learning (UDL)
7 Standards, Alignment, and Learning Objectives
Interpreting TEKS and Planning Evidence Horizontal and Vertical Curriculum Alignment Measurable Learning Objectives & Bloom's Taxonomy
8 Planning and Assessment Evidence
Backwards Design and Lesson Architecture Guided Practice, Pacing, and Closure Designing Aligned Diagnostic, Formative & Summative Assessments State Assessments and Worked Statistical Measures
9 Learning Theories and Prior Knowledge
Behaviorism and Information Processing Constructivism and Instructional Applications Prior Knowledge, Schemas, and Misconceptions
10 Metacognition and Motivation
Metacognition and Strategy Instruction Intrinsic Motivation, Needs, and Attributions Self-Efficacy and Growth-Oriented Feedback
11 Inquiry, Play, Study, and Research
Inquiry, 5E, and Project-Based Learning Experiential Learning and Forms of Play Teaching Study Skills and Monitoring Learning Structuring Research Projects and Information Organization
12 Relationships and Inclusive Community
Rapport, Peer Respect, and Shared Norms Inclusive Community Across Grade Bands Classroom Layout and Physical Accessibility
13 Physical and Emotional Safety
Laboratory Safety and Activity Arrangements High Expectations, Student Agency & Emotional Safety
14 Routines, Prevention, and PBIS
Classroom Routines, Daily Procedures & Efficient Transitions Kounin, Classroom Norms, and Prevention PBIS Tiers and Reinforcement Decisions
15 Behavior Decisions and Classroom Operations
De-escalation and Restorative Decisions Behavior Functions and Individualized Interventions Schedules, Materials, and Administrative Routines Working with Volunteers and Paraprofessionals
16 Communication and Question Design
Academic Vocabulary and Accessible Communication Directions, Demonstrations, and Understanding Checks Question Design, Wait Time, and Probing
17 Participation and Language Supports
Equitable Response and Cognitive Participation Facilitating Student-Led Academic Discourse & Socratic Discussions Language, Representations, and Communication Access Supporting Hesitant Speakers and Participation
18 Explicit Instruction, Cooperation, and Differentiation
Direct Instruction, Explicit Modeling & Guided Practice (Gradual Release) Cooperative Learning Structures & Flexible Student Grouping Differentiating Content, Process, Product & Environment
19 Pacing and Targeted Language Instruction
Pacing, Instructional Materials & Cross-Curricular Integration Targeted Listening and Speaking Instruction in Grade 3 and Above Targeted Reading, Writing, and Academic Language
20 Technology Integration and Citizenship
SAMR and Changes to Learning Tasks TPACK and Instructional Tool Selection Digital Citizenship and Cyberbullying Response
21 Privacy, Copyright, and Open Resources
Student Data, COPPA, and Digital Footprints Copyright, Fair Use, and Educational Transmission Open Licenses, AUP, and Resource Permissions
22 Assistive Access, Systems, and Information
Assistive Technology & Ensuring Equitable Digital Access Hardware, Software, Networks, and Troubleshooting Finding, Acquiring, and Evaluating Electronic Information
23 Documents, Data, and Multimedia Production
Word Processing and Responsible Digital Collaboration Spreadsheets and Databases for Problem Solving Multimedia Design, Creative Processes, and Publishing
24 Assessment Evidence and Feedback Levels
Assessment Purposes and Evidence of Understanding Formative Techniques and Accessible Response Feedback Levels and Learner Needs
25 Feedback Use and Self-Assessment
Feedback Timing, Next Steps, and Revision Rubrics and Teaching Self-Assessment Goals, Portfolios, and Progress Tracking
26 Data Analysis and Intervention
Item Analysis and Responsive Reteaching MTSS, Progress Monitoring, and Evaluation
27 Communication and Family Knowledge
Proactive Contact and Two-Way Communication Listening, Concerns, and Family Problem Solving Family Knowledge, Preferences, and Language Access
28 Family Access, Conferences, and Community
Family Structures and Participation Barriers Conference Preparation and Student-Led Reflection Community Resources and Family Participation
29 Reflection, Collaboration, and Professional Learning
Reflective Teaching Practice & Self-Appraisal (T-TESS System) Professional Learning Communities (PLCs) & Vertical/Horizontal Teaming Mentorship, Continuing Professional Education (CPE) & Action Research
30 Governance, Participation, and Advocacy
Texas Education Governance and Professional Roles School Participation, Committees, and Student Advocacy
31 Ethics, Testing, and Reporting Duties
Texas Ethical Standards and Professional Boundaries Secure Assessment and Ethical Applications Direct Abuse Reporting, Deadlines, and Protections
32 Disclosures and Student Records
Recognizing Harm and Responding to Disclosures FERPA Records, Access, and Parent Rights FERPA Classroom Displays and Disclosure Decisions
33 Classroom Privacy, Discipline, and Supervision
Plan Implementation and Disability Discipline Supervision Duties and Civil Immunity
Spreadsheets and Databases for Problem Solving
Key Takeaways Explain This Topic AI
A spreadsheet organizes cells and calculations; a database organizes structured records and retrieval.
Preserve relationships when sorting and verify formulas with a hand calculation.
Missing data, inconsistent types, and permissions can invalidate an otherwise polished result.
Last updated: October 2026
Choose the Tool for the Task
A spreadsheet arranges information in rows and columns and can calculate with formulas. A cell is identified by its column and row, such as B2. A range such as B2:B5 refers to a series of cells. A database organizes records using fields and supports structured retrieval and, in relational designs, relationships among tables. A spreadsheet can store a list, but a database is often better suited to managing related records and repeated queries. Choose according to the problem, available approved tools, and learner readiness.
Plan the data before entering it. Identify what each row represents and what each column means. Use consistent units and types, clear headers, and a documented treatment of missing values. A blank, a zero, and a text note are different. For a plant-growth investigation, record measurement date, plant identifier, height, and units consistently. Do not mix inches and centimeters in a column without a valid conversion and clear documentation.
Worked Spreadsheet Calculations
Suppose B2:B5 contains the fictional values 6, 8, 8, 10 . A common spreadsheet formula =SUM(B2:B5) returns 32 . =AVERAGE(B2:B5) returns 8 , because 32 / 4 = 8. =COUNT(B2:B5) counts numeric values and returns 4 . Check the selected range: accidentally including a previous total can double-count or distort the result. A plausible-looking answer is not sufficient verification.
If C2 contains an item's quantity and D2 its unit price, =C2*D2 calculates that row's cost. With quantity three and price 2.50, the result is 7.50 . When copying a formula, relative references usually change with the new location. A fixed reference, such as $F$1 , can keep a shared rate anchored in common spreadsheet applications. Explain why the reference should change or remain fixed instead of treating dollar signs as currency formatting.
- Operation Purpose Common error to avoid
- Formula Calculate from referenced values Incorrect range or unintended reference changes
- Sort Reorder records by a criterion Sorting one field while separating it from its record
- Filter Show records meeting conditions Assuming hidden records were deleted
- Chart Display a selected relationship Misleading axes, missing units, or wrong data range
Before trusting an important calculation, compare a small case with arithmetic by hand and inspect the inputs. Check what the application does with blanks, text, and error values. Do not treat absent assessments as zeros without a valid policy and purpose. A formula can be mathematically correct while answering the wrong question because its denominator excludes or includes the wrong records.
Sorting, Filtering, and Charts
Sort the entire record range or an appropriate table so the relationship between names, identifiers, and values remains intact. If only scores move while names remain still, the resulting records can become false. Preserve a copy or use the approved recovery process before making consequential changes. Sorting by a value does not establish that the value caused another outcome.
Filtering displays records that meet conditions; it does not ordinarily erase the other records. Check whether a calculation includes all rows or only visible rows according to the tool and formula. Choose a chart that serves the question: a line can show change over time, while bars can compare categories. Label units, identify the population, and avoid scales that exaggerate a trivial difference. Explain what the chart supports and what it cannot show.
Database Records and Queries
In a database, a record represents an entity or event and fields describe attributes. A unique key distinguishes records; a person's name alone may not be unique. Related tables can avoid repeatedly entering the same information. For example, a fictional resource inventory can relate item records to loan records through an item identifier. The design should match the task and protect any confidential data.
A query retrieves records using specified criteria. Asking for items currently on loan differs from asking for every historical loan. Verify the condition, data types, and returned records. An empty result might mean no records meet the criteria, or it might reflect an incorrect query or inconsistent entries. Teach students to inspect the logic rather than assume every automated result is authoritative.
Use nonconfidential or appropriately deidentified classroom datasets when teaching these tools. Approved systems, access permissions, retention procedures, and privacy duties govern real school records. Assess students' reasoning about data, formulas, and evidence along with their ability to operate the software. The examples use common Excel-style syntax; other tools or regional settings may differ. Microsoft basic Excel tasks and sorting records .
Sections you finish are checked off in the contents.
- Up Next
- Multimedia Design, Creative Processes, and Publishing
- Continue learning