

I re-wrote all lesson plans and adapted all previous materials to suit the new contents of the textbook. The textbook for the Practical English class was updated so I was required to produce new lesson plans and supporting materials to match the new book contents It also enabled me to notify students of any upcoming deadlines and other class information I all made class and homework materials available on Edmodo to enable students to keep up with their studies even if they are absent. I improved on old games and activities and I created new review activities to help students with information retentionįor my 4th year zemi class I made all class materials available to students online to enable them to access class study materials even if they are absent due to job-hunting Also videoing presentations allows students to self-assess their own performance.įor my paragraph writing class I created new and adapted old, warm-up and review activities This change allowed students to do their presentations to much smaller groups which allowed for much more student interaction while still allowing me to assess presentions fairly and throughly. In my 3rd year zemi class I decided to get students to submit all of their final presentation work online instead of whole class presentations. Pg_search fixes this problem by adding a second expression to the ORDER BYĬlause, after the :ranked_by expression explained above.Learner Generated Materials Based on TED Talks Might end up getting some of the same records from page 1 on page 2 as well,Īnd likewise there may be records that don't show up at all. Rearrange the order of those 12 records between different SQL statements. Remaining 2 records at the top of the next page, ahead of lower-rankedīut since there is no consistent ordering, PostgreSQL might choose to Pages of 10, then you would expect to see 10 of the records on page 1, and the

Imagine a case where 12 records all have the same ranking value. PostgreSQL does not guarantee a consistent order when multiple records have # Weighted ranking to balance multiple approaches ranked_by: ":dmetaphone + (0.25 * :trigram)" # A more complex example, where books.num_pages is an integer column in the table itself ranked_by: "(books.num_pages * :trigram) + (:tsearch / 2.0)" :order_within_rank (Breaking ties)
#Tsearch class install#
In addition to theĮxtension, you must install a utility function into your database. That must be installed before this feature can be used. For example, "Geoff" and "Jeff" sound identical and thus match.Ĭurrently, this is not a true double-metaphone, as only the first metaphone isĭouble Metaphone support is currently available as part of the fuzzystrmatch :dmetaphone (Double Metaphone soundalike search)Īlgorithm for matching words that sound alike even if they are spelled veryĭifferently. The highlight option accepts all options supported byįor details on the meaning of each option. pg_search_highlight # => "Born in rural Alberta, where the buffalo roam." create! ( :bio => "Born in rural Alberta, where the buffalo roam." ) first_match = Person. rebuild_pg_search_documents find_each end Person. name end multisearchable against: # Naive approach def self.
#Tsearch class movie#
This is more useful forīuilding things like autocompleters or filtering a list of items in a facetedīefore using multi-search, you must generate and run a migration to create theĬlass Movie < ActiveRecord:: Base belongs_to :director def director_name director. Searching against only one Active Record class. The other technique is search scopes, which allow you to do more advanced Most sites that want to support a generic search page will Record classes can be mixed together into one global search index across yourĮntire application. The first technique is multi-search, in which records of many different Active Pg_search supports two different techniques for searching, multi-search and PgSearch#pg_search_rank (Reading a record's rank as a Float).:ranked_by (Choosing a ranking algorithm).Limiting Fields When Combining Features.:dmetaphone (Double Metaphone soundalike search).

