AWdb Support

Curriculum manages all of the details for the handbooks, including general Book Info, details for Sections in the book, and award triggers based on completion of a group of sections in a handbook or by count of completed sections in a handbook as well as awards for the completion of the specific book.

Select a handbook in the list to show the book's detailed information. The information is shown on separate pages as described in the Handbooks Details section below.

Curriculum List toolbar:

Search – locate a handbook in the list by typing part of the name. This will limit the list to only books that have a name (or part of a name) matching the text in the search box. To return to the complete list of books, clear the text in the box.

Show Display Options – opens the Book List Options dialog to customize the information shown in the Book List using these selections:

Show Only books that are either IN USE or NOT IN USE - check the box and select a condition to limit the list based on a book's in-use status.

Filter books by Base Club - select a club or clubs from the list of Base Clubs to limit the display to books relevant to the selection.

Handbook Details:

Once a handbook is selected, the book's details are shown within tabbed pages.

Book Info - general information for the book. Click the Edit buttonto update the following information:

• Base Club - determines which books to initially show based a clubber's assigned Club Name
• Used By Grades - for reference only
• Default Award Set - the award set initially set when the book is assigned; this can be changed for each clubber as needed.
• Verse Count - for reference only
• Is an Entrance Booklet - indicates a book is used before starting a main handbook; (Yr1), (Yr2), etc. versions allow assigning these for multiple years
• Is a Bible Reading plan - indicate 'books' that may be used to track Trek and Journey Bible reading plans separately from a main handbook
• Counts in Cumulative Book Awards - indicates when the book is completed that the award is determined based on a count of completed books (for Sparks, only Sparks books are counted; for T&T, Trek, & Journey, books count from any of the relevant base clubs)
• Needs Linked Bible Reading (Trek only) - with this checked, when assigning a Trek book, an associated Bible Reading plan must be selected. The Bible reading sections will be included within the main handbook instead of the single 'Bible Reading' section. Those sections will be evaluated in the book completion percentage and the book completion requirements.
• Note - any additional information relevant to the book. (This note is displayed on the Assign Handbook dialog when the handbook is selected.)
• Translations table (In Use status and Note) - the status determines which books to initially show when assigning a handbook. 

Sections - detailed information about the sections included in the book. All sections within the book are shown in the table. Use the Show Display Options buttonto select which columns to show. Use the dropdown selection next to a column header to filter the records based on a specific value in a column. Select a section, then click the Edit buttonto make changes to a section's information, including:

• Section Group Name - indicates the section is part of a group of sections that need to be completed together to earn an award (i.e. Red Jewel 2).
• Additional Points - adjusts the default number of points earned for this section. Use a positive number to increase the default points and a negative number to decrease the default points.
• Is a Required section - indicates if the section counts as a required or a not-required (extra credit) section when calculating points and book completion requirements.
• Counts in Accumulated Section Award - indicates a required section should be counted to determine when an award is earned (instead of being included in a group).
• Award 1 and Award 2 - awards that trigger when the single section is completed. This is generally only used by Cubbies for stickers when completing each section.

Section Group Awards - handles the awards that are triggered when a group of sections with the same Section Group Name in a handbook are completed. This is most frequently used in Sparks books. For example, when all of the sections with a Group Name of Red Jewel 2 are completed, the award associated to the Group Name is triggered. Use the dropdown selection next to a column header to filter the records based on a specific value in a column.  

Use the Add button to create a new section group award, the Edit buttonto change details about an award or the Delete buttonto remove an award. Each award record includes the following:

• Award Set - the name for the set of awards. This is used to distinguish award sets and allow triggering of more than one type of award within a book (i.e. T&T used a variety of sets for a while, or when a new design is released, but an older style is still in use). When a book is assigned to a clubber, the default award set is used, but can be changed later. The default award set can be changed on the Book Info page.  
• Group Name - the Section Group Name that the award applies to (when all sections with the associated Section Group Name are completed)
• Item Info - the award to trigger. The selection list defaults to awards in use for the relevant base club. Use thebutton to change the list of award choices.

Accumulated Section Awards - handles the awards that are triggered when a specified number of required sections in a handbook are completed. This is generally used in T&T books. For example, when any 4 sections are completed, the first award is triggered. Use the dropdown selection next to a column header to filter the records based on a specific value in a column. 

Use the Add button to create a new accumulated section award, the Edit buttonto change details about an award or the Delete buttonto remove an award. Each award record includes the following:

• Award Set - the name for the set of awards. This is used to distinguish award sets and allow triggering of more than one type of award for sections in a book (i.e. T&T used a variety of sets for a while, or when a new design is released, but an older style is still in use). The default award set for the book can be changed on the Book Info page. When a book is assigned to a clubber, the default award set is used, but can be changed later.
• Section Count - the number of sections that need to be completed to trigger an award
• Item Info - the award to trigger. The selection list defaults to awards in use for the relevant base club. Use thebutton to change the list of award choices.

Book Awards - handles the awards that are triggered when this specific book is completed. This is generally used for Cubbies where the completion medallion is specific to the completed book. Use the dropdown selection next to a column header to filter the records based on a specific value in a column. 

Use the Add button to create a new book award, the Edit buttonto change details about an award or the Delete buttonto remove an award. Each award record includes the following:

• Effective Date - the date to start triggering this award
• Expiration Date - the date to stop triggering this award
• Item Info - the award to trigger. The selection list defaults to awards in use for the relevant base club. Use thebutton to change the list of award choices.