<% openConn() %> WVPT4Learning - Lesson Plans Search Resources
  <%If AudType=1 OR AudType=7 OR AudType=6 Then%> <%Else%> <%End If%>
<% if AudType =1 then%>
 
<%else%>
 
<%end if%>

Search the NTTI Lesson Database

All lessons on this website are written by classroom teachers. If the NTTI logo appears at the top of the PDF file, the lesson was written by an NTTI Master Teacher. If the SVTC logo appears at the top of a PDF file, the lesson was written by an NTTI participant.

New NTTI Lessons SVTC Lessons

Lessons By Grade

K-2

3-5

6-8

9-12

Staff Development


Lessons By Subject

<% 'Our query holds ID and name columns from the tblsubject. DIM objfldID, objfldName 'create connection object Dim objCmd', objRS set objCmd = Server.CreateObject("ADODB.Command") set objRS = Server.CreateObject("ADODB.RecordSet") set objCmd.ActiveConnection = objConn '--- the command will be executed later on in the script: As will the record set be created if the retval is not -1. objCmd.CommandText = "{? = call pbs_list_lesson_sol_subjects}" objCmd.Parameters.Append objCmd.CreateParameter("RetVal", 3, 4, 0) objRS.open objCmd set objfldID = objRS("ID") set objfldName = objRS("name") Do until objRS.EOF %>

<%=objfldName%>

<% objRS.moveNext Loop set objfldID = nothing set objfldName = nothing set objRS = nothing set objCmd = nothing 'set objconn = nothing %>

 

You will need Adobe Acrobat Reader to view all lesson files in PDF format. If you do not have it, download a free copy from Adobe.com.

 
 
<% set objconn = nothing %>