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