Search for Resources

Making Waves! Protecting Ontario's Aquatic Habitats

Elementary, Middle

Description

A series of sequential lessons designed to help students and teachers understand the impacts of invasive species on habitats and ecosystems, and provide tools and strategies to help stop the spread of invasive species.

Students will:

  • create a song to describe how humans can protect aquatic habitats.
  • play games that teach students to ask questions about animals and their adaptations, as well as food chains and the fight for survival.
  • emulate the transfer of food energy in a lake habitat through simulation and play.
  • take action to demonstrate others about the danger of releasing aquarium species into lakes and rivers.
  • create their own ultimate invasive species.

General Assessment

What skills does this resource explicitly teach?

This resource explicitly teaches:

  • about tints and shades through paint mixing.
  • definitions of invasive species along with examples.

Strengths

  • This resource is very well organized with specific learning outcomes and objectives.
  • The resource links directly to the grade four curriculum.
  • The resource provides numerous examples of assessment strategies throughout the lesson.
  • The resource follows an inter-disciplinary approach providing lessons in art, drama, ELA and science.
  • Lessons are locally focused and pertinent to the lives of the students.
  • Lessons are interesting and provide opportunity for students to play and be creative while learning.
  • Some of the lessons take place out of doors.
  • Simulation activities are designed to accentuate the students learning.
  • Case studies of invasive species along with colored information cards are provided.
  • Glossary of terms is provided for the teacher/students.
  • List of resources is provided for the teacher/student.
  • Students are encouraged to begin to share their knowledge with others.

Weaknesses

  • Resource does not explicitly teach skills needed for students to take effective action.
  • Lessons are mostly teacher directed.

Relevant Curriculum Units

The following tool will allow you to explore the relevant curriculum matches for this resource. To start, select a province listed below.

  • Step 1Select a province
  • Alberta
    • Step 2Select a grade level
    • Grade 3
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Drama
        • Arts: Music
        • Arts: Visual Art
      • English/Language Arts
        • Step 4Relevant matches
        • Comprehend & Respond
        • Enhance the clarity and artistry of communication
        • Explore thoughts, ideas, feelings and experiences
        • Manage Ideas & Information
        • Respect, support and collaborate with others
      • Physical Education
        • Step 4Relevant matches
        • Physical Education: Activity
    • Grade 4
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Drama
        • Arts: Music
        • Arts: Visual Art
      • English/Language Arts
        • Step 4Relevant matches
        • Comprehend & Respond
        • Enhance the clarity and artistry of communication
        • Explore thoughts, ideas, feelings and experiences
        • Manage Ideas & Information
        • Respect, support and collaborate with others
      • Physical Education
        • Step 4Relevant matches
        • Physical Education: Activity
    • Grade 5
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Art
        • Arts: Drama
        • Arts: Music
      • English/Language Arts
        • Step 4Relevant matches
        • Comprehend & Respond
        • Enhance Clarity and Artistry of Communication
        • Explore thoughts, ideas, feelings, and experiences
        • Manage Ideas and Information
        • Respect, Support and Collaborate
      • Physical Education
        • Step 4Relevant matches
        • Physical Education: Physical Education: Activity
      • Science
        • Step 4Relevant matches
        • Wetland Ecosystems
  • Manitoba
    • Step 2Select a grade level
    • Grade 3
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Dance
        • Arts: Drama
        • Arts: Music
        • Arts: Visual Arts
      • Physical Education & Health
        • Step 4Relevant matches
        • Physical Education and Health: Movement
      • Science
        • Step 4Relevant matches
        • Growth and Changes in Plants
        • Soils in the Environment
    • Grade 4
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Dance
        • Arts: Drama
        • Arts: Music
        • Arts: Visual Arts
      • Physical Education & Health
        • Step 4Relevant matches
        • Physical Education and Health: Movement
      • Science
        • Step 4Relevant matches
        • Habitat and Communities
    • Grade 5
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Dance
        • Arts: Drama
        • Arts: Music
      • Physical Education & Health
        • Step 4Relevant matches
        • Physical Education and Health: Movement
    • Grade 6
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Dance
        • Arts: Drama
        • Arts: Music
    • Grade 7
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Dance
        • Arts: Drama
        • Arts: Music
    • Grade 8
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Dance
        • Arts: Drama
        • Arts: Music
  • New Brunswick
    • Step 2Select a grade level
    • Grade 3
      • Step 3Select a subject
      • English/Language Arts
        • Step 4Relevant matches
        • Reading & Viewing
        • Speaking & Listening
        • Writing & Other Ways of Representing
      • Physical Education
        • Step 4Relevant matches
        • Physical Education: Movement Skills and Concepts
      • Science
        • Step 4Relevant matches
        • Science 3.Our Local Environment: Science Technology Society and Environment (STSE)
        • Science 3: Our Local Environment:Scientific Literacy
      • Social Studies
        • Step 4Relevant matches
        • Provincial Identity: Place
      • Visual Art
        • Step 4Relevant matches
        • Visual Arts: Creating, Making, and Connecting
    • Grade 4
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts General: Creating, Making, and Presenting
      • English/Language Arts
        • Step 4Relevant matches
        • Reading & Viewing
        • Speaking & Listening
        • Writing & Other Ways of Representing
      • Physical Education
        • Step 4Relevant matches
        • Physical Education: Movement Skills and Concepts
      • Visual Art
        • Step 4Relevant matches
        • Visual Arts: Elements of Art & Principles of Design
        • Visual Arts: Materials & Techniques
    • Grade 5
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts General: Creating, Making, and Presenting
      • English/Language Arts
        • Step 4Relevant matches
        • Reading & Viewing
        • Speaking & Listening
      • Physical Education
        • Step 4Relevant matches
        • Physical Education:Movement Skills and Concepts
      • Visual Art
        • Step 4Relevant matches
        • Visaul Arts: Materials & Techniques
  • Newfoundland & Labrador
    • Step 2Select a grade level
    • Grade 3
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Creating, Making, and Presenting
      • English/Language Arts
        • Step 4Relevant matches
        • Reading & Viewing
        • Speaking & Listening
        • Writing & Other Ways of Representing
      • Physical Education
        • Step 4Relevant matches
        • Physical Education: In Movement
      • Science
        • Step 4Relevant matches
        • Plant Growth & Changes
    • Grade 4
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Art: Connecting Contexts of Time, Place, and Community
      • English/Language Arts
        • Step 4Relevant matches
        • Reading & Viewing
        • Speaking & Listening
      • Physical Education
        • Step 4Relevant matches
        • Physical Education: In Movement
    • Grade 5
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Creating, Making, and Presenting
      • English/Language Arts
        • Step 4Relevant matches
        • Reading & Viewing
        • Speaking & Listening
      • Physical Education
        • Step 4Relevant matches
        • Physical Education: In Movement
  • Northwest Territories
    • Step 2Select a grade level
    • Grade 3
      • Step 3Select a subject
      • English/Language Arts
        • Step 4Relevant matches
        • Access and Explore
        • Clarify and Enhance
        • Comprehend and Respond
        • Develop and Celebrate Community
        • Interpret & Analyse
      • Physical Education
        • Step 4Relevant matches
        • Physical Education: Activity
    • Grade 4
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts Education 4: Music
        • Arts Education 4: Visual Art
      • English/Language Arts
        • Step 4Relevant matches
        • Access and Explore
        • Clarify and Enhance
        • Comprehend & Respond
        • Develop and Celebrate Community
        • Interpret and Analyse
      • Physical Education
        • Step 4Relevant matches
        • Physical Education: Activity
    • Grade 5
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts:Music
        • Arts:Visual Art
      • English/Language Arts
        • Step 4Relevant matches
        • Access and Explore
        • Celebrate and Build Community
        • Clarify & Extend
        • Comprehend and Respond
        • Plan, Focus, Interpret & Analyse
      • Physical Education
        • Step 4Relevant matches
        • Physical Education: Physical Education: Activity
  • Nova Scotia
    • Step 2Select a grade level
    • Grade 3
      • Step 3Select a subject
    • Grade 4
      • Step 3Select a subject
      • English/Language Arts
        • Step 4Relevant matches
        • Listening & Speaking
        • Reading & Viewing
        • Writing & Representing
      • Science
        • Step 4Relevant matches
        • Science 4: Habitats
    • Grade 5
      • Step 3Select a subject
      • English/Language Arts
        • Step 4Relevant matches
        • Listening and Speaking
        • Reading & Writng
        • Writing and Representing
  • Nunavut
    • Step 2Select a grade level
    • Grade 3
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts Education 3: Cultural/Historical
      • English/Language Arts
        • Step 4Relevant matches
        • Access and Explore
        • Clarify and Enhance
        • Comprehend and Respond
        • Develop and Celebrate Community
        • Interpret & Analyse
      • Physical Education
        • Step 4Relevant matches
        • Physical Education: Movement
      • Physical Education & Health
        • Step 4Relevant matches
        • Physical Education and Health: Movement
    • Grade 4
      • Step 3Select a subject
      • English/Language Arts
        • Step 4Relevant matches
        • Access and Explore
        • Clarify and Enhance
        • Comprehend & Respond
        • Develop and Celebrate Community
        • Interpret and Analyse
      • Physical Education
        • Step 4Relevant matches
        • Physical Education: Movement
      • Physical Education & Health
        • Step 4Relevant matches
        • Physical Education and Health: Movement
    • Grade 5
      • Step 3Select a subject
      • English/Language Arts
        • Step 4Relevant matches
        • Access and Explore
        • Celebrate and Build Community
        • Clarify & Extend
        • Comprehend and Respond
        • Plan, Focus, Interpret & Analyse
      • Physical Education & Health
        • Step 4Relevant matches
        • Physical Education and Health: Movement
    • Grade 6
      • Step 3Select a subject
      • Physical Education
        • Step 4Relevant matches
        • Physical Education: Fitness management
    • Grade 7
      • Step 3Select a subject
    • Grade 8
      • Step 3Select a subject
  • Ontario
    • Step 2Select a grade level
    • Grade 3
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Music
        • Arts: Visual Arts
      • English/Language Arts
        • Step 4Relevant matches
        • Language: Media Literacy
        • Language: Oral Communication
        • Language: Reading
        • Language: Writing
      • Physical Education & Health
        • Step 4Relevant matches
        • Health and Physical Education: Active Living
      • Science & Technology
        • Step 4Relevant matches
        • Growth & Changes in Plants
    • Grade 4
    • Grade 5
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Music
        • Arts: Visual Arts
      • English/Language Arts
        • Step 4Relevant matches
        • Language: Media Literacy
        • Language: Oral Communication
        • Language: Reading
        • Language: Writing
      • Physical Education & Health
        • Step 4Relevant matches
        • Health and Physical Education: Active Living
  • Prince Edward Island
    • Step 2Select a grade level
    • Grade 3
      • Step 3Select a subject
      • English/Language Arts
        • Step 4Relevant matches
        • Reading and Viewing
        • Speaking and Listening
        • Writing and Other Ways of Representing
    • Grade 4
      • Step 3Select a subject
      • Music
        • Step 4Relevant matches
        • Music
    • Grade 5
      • Step 3Select a subject
      • Music
        • Step 4Relevant matches
        • Music
  • Quebec
    • Step 2Select a grade level
    • Grade 3
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Visual Arts: To produce individual works in the visual arts
        • Arts: Visual Arts: To produce media works in the visual arts
      • English/Language Arts
        • Step 4Relevant matches
        • To read and Listen to Literary, Popular and Information -based texts
        • To represent her/his literacy in different media
        • To use Language to communicate and learn
        • To write self - expressive narrative and information -
      • Physical Education & Health
        • Step 4Relevant matches
        • Physical Education and Health: Adopt a Healthy, Active Lifestyle
    • Grade 4
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Visual Arts: To produce individual works in the visual arts
        • Arts: Visual Arts: To produce media works in the visual arts
      • English/Language Arts
        • Step 4Relevant matches
        • To read and Listen to Literary, Popular and Information -based texts
        • To represent her/his literacy in different media
        • To use Language to communicate and learn
        • To write self - expressive narrative and information -
      • Physical Education & Health
        • Step 4Relevant matches
        • Physical Education and Health: Adopt a Healthy, Active Lifestyle
      • Science & Technology
        • Step 4Relevant matches
        • Living Things
    • Grade 5
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts: Music: To invent vocal or instrumental pieces
        • Arts: Visual Arts: To produce individual works in the visual arts
      • English/Language Arts
        • Step 4Relevant matches
        • To read and Listen to Literary, Popular and Information -based texts
        • To represent her/his literacy in different media
        • To use Language to communicate and learn
        • To write self - expressive narrative and information -
      • Physical Education & Health
        • Step 4Relevant matches
        • Physical Education and Health: Adopt a Healthy, Active Lifestyle
  • Saskatchewan
    • Step 2Select a grade level
    • Grade 2
      • Step 3Select a subject
      • Science
        • Step 4Relevant matches
        • Animal Growth and Changes
    • Grade 3
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts Education 3: Cultural/Historical
      • English/Language Arts
        • Step 4Relevant matches
        • Assess and Reflect
        • Compose and Create
        • Comprehend and Respond
      • Physical Education
        • Step 4Relevant matches
        • Physical Education 3: Active Living
      • Science
        • Step 4Relevant matches
        • Plant Growth and Changes
      • Social Studies
        • Step 4Relevant matches
        • Community Comparisons: Resources and Welath
    • Grade 4
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts Education 4: Critical/Responsive
        • Arts Education 4: Cultural/Historical
      • English/Language Arts
        • Step 4Relevant matches
        • Compose and Create
        • Comprehend and Respond
      • Physical Education
        • Step 4Relevant matches
        • Physical Education 4: Active Living
      • Social Studies
        • Step 4Relevant matches
        • Saskatchewan: Interactions and Interdependence
    • Grade 5
      • Step 3Select a subject
      • Arts
        • Step 4Relevant matches
        • Arts Education 5: Cultural/Historical
      • English/Language Arts
        • Step 4Relevant matches
        • Compose and Create
        • Comprehend and Respond
      • Physical Education
        • Step 4Relevant matches
        • Physical Education 5: Active Living
      • Social Studies
        • Step 4Relevant matches
        • Canada: Interaction and Interdependence of Nations

Themes Addressed

  • Ecosystems (1)

    • Invasive Species

Sustainability Education Principles

Principle Rating Explanation
Consideration of Alternative Perspectives Satisfactory
  • Resource adequately addresses the issue of invasive species and their impact on the ecosystem.
Consideration of Alternative Perspectives:
  • Satisfactory: absence of bias towards any one point of view
  • Good: students consider different points of view regarding issues, problems discussed
  • Very good: based on the consideration of different views, students form opinions and  take an informed position
Multiple Dimensions of Problems & Solutions Good
Multiple Dimensions of Problems & Solutions:

Effectively addresses the environmental, economic and social dimensions of the issue(s) being explored.

  • Satisfactory: resource supports the examination of  these dimensions
  • Good:  resource explicitly examines the interplay of these dimensions
  • Very Good:  a systems-thinking approach is encouraged to examine these three dimensions
Respects Complexity Satisfactory
  • Students are given some opportunity to discuss preventative measures to prevent spreading of invasive species.
Respects Complexity:

The complexity of the problems/issues being discussed is respected.

Acting on Learning Satisfactory
  • Students create posters to educate people about proper aquarium creature/water disposal.
  • Students are not given the opportunity to further develop action experiences.
Acting on Learning:

Learning moves from understanding  issues  to working towards positive change — in personal lifestyle, in school, in the community,  or for the planet

  • Satisfactory: action opportunities are included as extensions 
  • Good: action opportunities are core components of the resource
  • Very Good: action opportunities for students are well supported and intended to result in observable, positive change
Values Education Satisfactory
  • Students are provided with much information about the negative impact surrounding invasive species.
  • Students participate in a variety of lessons and simulation activities that will strengthen their understanding of the impact of invasive species.
  • Students are not exposed to a large amount of different perspectives.
Values Education:

Students are explicitly provided with opportunities to identify, clarify and express their own beliefs/values.

Empathy & Respect for Humans Good
Empathy & Respect for Humans: Empathy and respect are fostered for diverse groups of humans (including different genders, ethnic groups, sexual preferences, etc.).
Personal Affinity with Earth Good
  • Some of the ecosystem simulation activities take place out of doors through outdoor games.
  • Focus of the lessons are related to appreciation of non-humans and their ecosystems.
Personal Affinity with Earth:

Encourages a personal affinity with -the natural world.  

  • Satisfactory: connection is made to the natural world
  • Good: fosters appreciation/concern for the natural world
  • Very Good: fosters stewardship though practical and respectful experiences out-of-doors 
Locally-Focused Learning Very Good
Locally-Focused Learning:

Includes learning experiences that take advantage of issues/elements within the local community. 

  • Satisfactory: learning is made relevant to the lives of the learners
  • Good: learning is made relevant and has a local focus
  • Very Good: learning is made relevant, local and takes place ‘outside’ , in the community 
Past, Present & Future Satisfactory
  • Students discuss the impact of invasive species to ecosystems in the future, and how invasive species originated in the water ways in Ontario.
Past, Present & Future: Promotes an understanding of the past, a sense of the present, and a positive vision for the future.

Pedagogical Approaches

Principle Rating Explanation
Open-Ended Instruction Satisfactory
  • Lessons are very teacher directed, and students are steered towards discovering a specific answer or way of thinking.
Open-Ended Instruction :

Lessons are structured so that multiple/complex answers are possible; students are not steered toward one 'right' answer.

Integrated Learning Good
Integrated Learning:

Learning brings together content and skills  from more than one  subject area

  • Satisfactory: content from a number of different  subject areas is readily identifiable
  • Good:  resource is appropriate for use in more than one subject area
  • Very Good:  the lines between subjects are blurred 
Inquiry Learning Satisfactory
  • Lessons are very much teacher directed
Inquiry Learning:

Learning is directed by questions, problems, or challenges that students work to address.   

  • Satisfactory: Students are provided with questions/problems to solve and some direction on how to arrive at solutions.
  • Good: students, assisted by the teacher clarify the question(s) to ask and the process to follow to arrive at solutions.  Sometimes referred to as Guided Inquiry
  • Very Good:  students generate the questions and assume much of the responsibility for how to solve them.  . Sometimes referred to as self-directed learning.

 

Differentiated Instruction Good
Differentiated Instruction:

Activities address a range of student learning styles, abilities and readiness.

  • Satisfactory:  includes a variety of instructional approaches
  • Good: addresses  the needs of visual, auditory &  kinesthetic learners
  • Very Good: also includes strategies for learners with difficulties
Experiential Learning Satisfactory
Experiential Learning:

Authentic learning experiences are provided

  • Satisfactory: learning takes place through ‘hands-on’ experience or simulation
  • Good: learning involves direct experience in a ‘real world context’
  • Very good: learning involves ‘real world experiences’ taking place’ beyond the school walls.
Cooperative Learning Satisfactory
Cooperative Learning:

Group and cooperative learning strategies are a priority.

  • Satisfactory:  students work in groups
  • Good: cooperative learning skills are explicitly taught and practiced
  • Very Good: cooperative learning skills are explicitly taught, practiced and assessed
Assessment & Evaluation Good
Assessment & Evaluation: Tools are provided that help students and teachers to capture formative and summative information about students' learning and performance. These tools may include reflection questions, checklists, rubrics, etc.
Peer Teaching Satisfactory
  • Students create posters that educate others about the importance of properly disposing of aquarium creatures/water.
  • Students create songs teaching others about invasive species.
Peer Teaching:

Provides opportunities for students to actively present their knowledge and skills to peers and/or act as teachers and mentors.

  • Satisfactory: incidental teaching that arises from cooperative learning, presentations, etc.
  • Good or Very Good: an opportunity is intentionally created to empower students to teach other students/community members. The audience is somehow reliant on the students' teaching (students are not simply ‘presenting')
Case Studies Good
  • Resource provides adequate case studies of invasive species.  These are accentuated by invasive species information cards.
Case Studies:

Relevant case studies are included.  Case studies are thorough descriptions of real events from real situations that students use to explore  concepts in an authentic context.

Locus of Control Satisfactory
  • The majority of the lessons are teacher directed and students do not have the opportunity to choose elements of the program or the medium in which they wish to work.
  • Students are not given the opportunity to take part in extension activities.
Locus of Control: Meaningful opportunities are provided for students to choose elements of program content, the medium in which they wish to work, and/or to go deeper into a chosen issue.
48 total queries
(query time) (total time) (query)
0.0007 0.0007 (SET NAMES 'utf8')
0.0003 0.001 ( SELECT issues.issue_id as id, issue_content.title as name FROM issues LEFT JOIN issue_content USING (issue_id) WHERE issue_content.lang_id='1' ORDER BY issue_content.title ASC ) [14 row(s)]
0.0005 0.0015 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='resource' AND parent_page=1 AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0.0008 0.0023 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='making-waves-protecting-ontarios-aquatic-habitats' AND parent_page=5 AND lang_id='1' AND page_details.live='yes') [0 row(s)]
0.0003 0.0026 (SELECT * FROM cms76_languages WHERE lang_id=1) [1 row(s)]
0.0003 0.0029 (SELECT * FROM cms76_languages WHERE lang_id!=1) [1 row(s)]
0.0004 0.0033 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page_id='5' AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0.0003 0.0036 (SELECT * FROM cms76_modules LEFT JOIN page_includes USING (module_id) WHERE page_id=5 ORDER BY page_order) [1 row(s)]
0.0026 0.0062 (SELECT * FROM page_details WHERE page_id='5') [1 row(s)]
0.0014 0.0076 ( SELECT resource_content.title FROM resources LEFT JOIN resource_content USING (resource_id) WHERE resources.language_id='1' AND resources.slug='making-waves-protecting-ontarios-aquatic-habitats' ) [1 row(s)]
0.0013 0.0089 ( SELECT resource_content.description FROM resources LEFT JOIN resource_content USING (resource_id) WHERE resources.language_id='1' AND resources.slug='making-waves-protecting-ontarios-aquatic-habitats' ) [1 row(s)]
0.0003 0.0092 ( SELECT resource_content.title FROM resources LEFT JOIN resource_content USING (resource_id) WHERE resources.language_id='1' AND resources.slug='making-waves-protecting-ontarios-aquatic-habitats' ) [1 row(s)]
0.0004 0.0096 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='17' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [7 row(s)]
0.0003 0.0099 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='32' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0004 0.0103 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='195' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [5 row(s)]
0.0003 0.0106 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='225' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0109 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='223' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0112 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='245' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0115 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='253' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0118 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='282' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0121 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='18' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0124 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='22' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0127 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='19' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.013 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='20' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0133 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='21' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0136 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='28' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [6 row(s)]
0.0003 0.0139 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='178' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0142 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='179' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0145 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='180' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0148 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='181' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0006 0.0154 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='182' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0157 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='183' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0057 0.0214 ( SELECT resources.resource_id, resources.*, resource_content.* FROM resources LEFT JOIN resource_content USING (resource_id) LEFT JOIN resource_curriculum ON resource_curriculum.resource_id=resources.resource_id LEFT JOIN curriculum_units ON curriculum_units.curriculum_id=resource_curriculum.curriculum_id WHERE resources.language_id='1' AND resources.slug='making-waves-protecting-ontarios-aquatic-habitats' AND resources.live='yes' GROUP BY resource_content.resource_id ) [1 row(s)]
0.0003 0.0217 ( SELECT resource_supplier_content.organization, resource_supplier.website as organization_website FROM resource_supplier LEFT JOIN resource_supplier_content ON resource_supplier_content.supplier_id=resource_supplier.supplier_id WHERE resource_supplier.supplier_id='187' AND resource_supplier_content.lang_id = 1 ) [1 row(s)]
0.0004 0.0221 ( SELECT compilation_content.compilation_id, compilation_content.title as compilation_title FROM resource_compilation LEFT JOIN compilation USING (compilation_id) LEFT JOIN compilation_content USING (compilation_id) WHERE resource_compilation.resource_id='764' AND compilation.in_sidebar='yes' AND compilation_content.lang_id='1' ) [0 row(s)]
0.0018 0.0239 ( SELECT curriculum_audience_content.name as audience FROM resources LEFT JOIN resource_curriculum USING (resource_id) LEFT JOIN curriculum_units ON curriculum_units.curriculum_id=resource_curriculum.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id=curriculum_units.audience_id WHERE curriculum_audience_content.lang_id='1' AND resource_curriculum.weight>0 AND resource_curriculum.resource_id='764' AND resources.live='yes' GROUP BY curriculum_units.audience_id ORDER BY audience ) [7 row(s)]
0.0003 0.0242 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='764' ) [1 row(s)]
0.0004 0.0246 ( SELECT resource_assessment_questions_content.question_field, resource_assessment_questions_content.question_short as question, resource_assessment_questions_content.question as question_long FROM resource_assessment_questions LEFT JOIN resource_assessment_questions_content USING (question_field) WHERE resource_assessment_questions_content.lang_id='1' AND resource_assessment_questions_content.question_field like 'resource_assessment.%' ORDER BY display_order ASC ) [8 row(s)]
0.0004 0.025 ( SELECT * FROM resource_assessment WHERE resource_id='764' ) [1 row(s)]
0.0111 0.0361 ( SELECT curriculum_audience_content.name as audience, curriculum_subject_content.name as subject, curriculum_province_content.name as province, GROUP_CONCAT(DISTINCT curriculum_content.title SEPARATOR ';') as units FROM resources LEFT JOIN resource_curriculum USING (resource_id) LEFT JOIN curriculum_units ON curriculum_units.curriculum_id=resource_curriculum.curriculum_id LEFT JOIN curriculum_content ON curriculum_content.curriculum_id=resource_curriculum.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id=curriculum_units.audience_id LEFT JOIN curriculum_subject_content ON curriculum_subject_content.subject_id=curriculum_units.subject_id LEFT JOIN curriculum_province_content ON curriculum_province_content.province_id=curriculum_units.province_id WHERE curriculum_content.lang_id='1' AND curriculum_audience_content.lang_id='1' AND curriculum_subject_content.lang_id='1' AND curriculum_province_content.lang_id='1' AND resource_curriculum.weight>0 AND resource_curriculum.resource_id='764' AND resources.live='yes' GROUP BY curriculum_units.audience_id,curriculum_units.subject_id,curriculum_units.province_id ORDER BY province, audience, subject ) [115 row(s)]
0.0025 0.0386 ( SELECT issue_content.issue_id, issue_content.title as issue_title, issues_sub_themes_content.title as theme_title FROM resources LEFT JOIN resource_theme ON resource_theme.resource_id=resources.resource_id LEFT JOIN issues_sub_themes ON issues_sub_themes.theme_id=resource_theme.theme_id LEFT JOIN issues_sub_themes_content ON issues_sub_themes_content.theme_id=resource_theme.theme_id LEFT JOIN issue_content ON issue_content.issue_id=issues_sub_themes.issue_id WHERE issues_sub_themes_content.lang_id='1' AND issue_content.lang_id='1' AND resource_theme.resource_id='764' AND resources.live='yes' GROUP BY issues_sub_themes.theme_id ORDER BY issue_title, theme_title ) [1 row(s)]
0.0004 0.039 (SELECT review_type FROM resources WHERE resources.resource_id='764') [1 row(s)]
0.0004 0.0394 ( SELECT resource_assessment_questions_content.question_field, resource_assessment_questions_content.question_short as question, resource_assessment_questions_content.question as question_long FROM resource_assessment_questions LEFT JOIN resource_assessment_questions_content USING (question_field) WHERE resource_assessment_questions_content.lang_id='1' AND resource_assessment_questions_content.question_field like 'resource_assessment_sustainability.%' ORDER BY display_order ASC ) [9 row(s)]
0.0006 0.04 ( SELECT * FROM resource_assessment_sustainability WHERE resource_id='764' ) [1 row(s)]
0.0003 0.0403 (SELECT review_type FROM resources WHERE resources.resource_id='764') [1 row(s)]
0.0004 0.0407 ( SELECT resource_assessment_questions_content.question_field, resource_assessment_questions_content.question_short as question, resource_assessment_questions_content.question as question_long FROM resource_assessment_questions LEFT JOIN resource_assessment_questions_content USING (question_field) WHERE resource_assessment_questions_content.lang_id='1' AND resource_assessment_questions_content.question_field like 'resource_assessment_pedagogical.%' ORDER BY display_order ASC ) [10 row(s)]
0.0005 0.0412 ( SELECT * FROM resource_assessment_pedagogical WHERE resource_id='764' ) [1 row(s)]
0.0005 0.0417 ( SELECT issue_content.issue_id, issue_content.title as issue_title, issues_sub_themes_content.title as theme_title FROM resources LEFT JOIN resource_theme ON resource_theme.resource_id=resources.resource_id LEFT JOIN issues_sub_themes ON issues_sub_themes.theme_id=resource_theme.theme_id LEFT JOIN issues_sub_themes_content ON issues_sub_themes_content.theme_id=resource_theme.theme_id LEFT JOIN issue_content ON issue_content.issue_id=issues_sub_themes.issue_id WHERE issues_sub_themes_content.lang_id='1' AND issue_content.lang_id='1' AND resource_theme.resource_id='764' AND resources.live='yes' GROUP BY issues_sub_themes.issue_id ORDER BY RAND() LIMIT 0,5 ) [1 row(s)]