How
to change the layout (page setup) for labels so that column 1 of
the label doesn't get cut off.
SQL
to filter data needed for the New Photography Project Survey.
SQL
– This SQL is one that you can use to filter information that could
be used in creating a buyers list.
This
SQL that will show a list of all members in the data base so that
you can see all that are in more than one club.
Sending
emails and labels
The
following SQL will give project information for youth categorized
as Other. Used
by Madison County .
This
SQL query is designed to help find addresses for any member that
does not match the address from either parent. Some times
when revising a member's address the parent file does not get changed.
2008
Ohio State 4H Project
Codes
How
to Compress Youth Enrollment Data and Email the data file to the
West Regional Office
Find
SS numbers on your computer and or CD's
(Print the Complete
Find_SSN Directions: Using
and Installing Virgina Tech's Find SSN
How
to delete project scores from the member records
Topics
located on this page:
2008
- New proceedures and applications:
Pod
Casts
Manual
Backing
up data using Nero, Roxio or a Memory, Flash drive
Ohio
4-H Certificates
Help
Tip Sheets - 2008
-
File Information
- Records
- Queries & SQL's
- Installation
- Statistical Records
- Codes
-
Error Messages
- Balancing
the 237 Report (2007)
Martech
Tip Sheets - 2007
2008
- New proceedures and applications:
Under
Special Reports you should see the following Report Options:
Master Club Reports
Project Score Report
Invalid Primary Club Code Report
Fee / Photo / Behavior Report
Invalid Club Report
Club / Not Youth Group Unit
If
you do not see all of the above click on this link
In
the Group Enrollment Form how do I know what information goes where
and what information gets reported?
The following
chart will help you answer these questions. Click
here to access the Excell chart
How
to Merge 4H Members Names and Years in 4H to the Ohio 4H Member
Achievement Certificate and or Ohio Volunteer Recognition Certificate.
You use this one if you are printing the complete
certificate.
How
to Merge 4H members name and Years in 4H to a Ohio 4H member Achievement
Certificate that is already printed. Use this one if you just need
to add name and years in 4H to certificates that have already been
printed.
(Word template to go with this process)
How
to Install Blue Ribbon Youth Enrollment on a New Computer
How
to use the SQL to filter members' data and merge into Word to print
labels. (These labels would contain first and last
name, club name, project ID and project description). used by Greene
Co.
(Frequently
used SQL's by counties)
SQL
- This SQL will give you name, address, phone number, email, club
name, project ID, project description, birth date & gender for
youth taking specific market livestock projects - used
by Washington Co.
SQL
- This SQL will give project information for youth categorized as
Other. Used
by Madison County .
SQL
– This SQL will provide you with a list of Members for selected
projects.
SQL
- This SQL will provide you with a list that contains both the Member's
Email & the Parent's Email
SQL
to create a report that includes: Last Name, First Name, Age, Project
ID, Project Description & Club Name for selected projects.
Report
Creation for Member-Leader “Memo” field feature (This report will
access the information that you have typed into the memo field on
the member - leader screen).
SQL
statements created by Matt Davis in Athens Co. to help counties
make changes to project numbers.
SQL
- This SQL will give you Member Certification information for members
listed as Livestock Quality Assurance in the member certification
section – for youth ages 9-11 Year olds - used
by Belmont Co.
How
to change the Ethnic race from balanced to white
Create
and View Query – This SQL will give you name, address, phone number,
club ID, club name, project ID and project description
for projects in 2007 that are complete – used by Geauga Co.
SQL
– This SQL will give you 4H members, name, address, home phone,
birth date, year in 4H (1-4 years), grade, parent name, school,
grade, and projects.
SQL
to generate a list of members taking poultry projects 151, 152,
153 & 166 -
This
create and view query will provide you with the following information:
first name, last name, phone number, club name, address, project
id number, for new and returned members, for members taking (poultry)
projects 151 – 153 and 166.
SQL to generate
a "master enrollment sheet" for each club. Data collected includes:
Club Id, Club Name, Member/Leader ID, Member/Leader Last Name, Member/Leader
First Name, Address, City, State, Zip, Phone, Age, Birthdate, Years
in 4-H, Parent Last, Parent First, School, Grade, Project ID &
Project Description - Instructions,
click here
SQL
- Data to create a buyer's guide for the fair. QA is marked
as an activity. SQL will give you name, address, parent's name and
spouses name (Category includes member and others)
SQL
- that could be used for Skill-A-thon Contest Registration and Score
Sheet - SQL
to select 4-H'ers Name and Club to filter out a range of projects
at one time whose members are age 15 to 18 (This example has beef
projects) The select lines will give you the information that is
filtered from this SQL or Create and View Query.
SQL
– This formula will give you last name, First name, and address
for all youth in a particular activity in a specific year , for
youth with status new or returned.
SQL
- 4-H'ers Name and Club to select members taking 139 Market Hog
Project that are Age 15 to 18
SQL
to export data from a secondary club. 6.6.07
This
SQL will give you data that can be exported to an Excel file. One
county has used this for their 4-H Camp to collect camper name,
age, grade, address and phone number. The campers were entered as
a Club (ID # 888) this number can be setup in the club /unit codes,
and is identified as an overnight camp. The data can be exported
as an Excel file so you can sort for tribes, cabins, etc.
This
SQl will give you a list that includes member name, and both parents.
SQL
to create a list of members by projects. This query will give you
the following data: first name, last name, age, club name, parent
home phone, email, project ID and description. We are also selecting
out members that are active, new and returned.
Additional
SQL's can be found toward the bottom of this page.
Merging Data Files To
Fair - What files
get merged?
How
to create a list of members and Cloverbud members data using an
SQL to export to programs like Excel.
How
to track members that have taken the written test for Quality Assurance?
How
to get the Member Certification Query tab to appear in the Additional
Queries list. - click
here
Youth
Group Enrollment form
- What data goes where?
What
to do with the project files during the roll over of data for 2007
- When you go to reset the project files for 2007
make sure that you do not to use the Utility to delete the Member
Project file, but use the Empty Table option instead when you reset
your files for 2007? Go
to Utility>>File Utilities, and in the list, highlight Youth2d.db.
Then choose File>>Empty Table. This will prevent
you from having a problem with your project files next year. This
will do the same thing as Delete Member Projects. If you do NOT
remove the projects from the member's record at re-enrollment time,
you will not need to do this.
Quality Assurance
- tracking
members that attended the program and printing mailing labels for
those that did not attend.
How
to add customized information to the 4-H Enrollment and Re-Enrollment
Form in the Blue Ribbon Youth Enrollment Program
2008
Ohio State 4H Project
Codes
Utilizing
the Project Literature section of Blue Ribbon:
Counties
that are utilizing the Project Literature section of Blue Ribbon
are having a problem when they have project literature that is a
requirement for more than one project. Example: Project
literature number 117R entered as required for project 113.
However, 117R is also a requirement for projects 114, 115 and 119.
Blue Ribbon will not allow them to enter 117R again as a requirement
for those additional projects.
Solution:
Create
4 literature records for literature piece 117R. One record would
be created for each project. The file will allow you to put in multiple
records for the same literature code, as long as the project code
is different.
Pod
Casts:(Includes Powerpoint, step by step instructions and audio)
How to make the font size smaller when using the queries to create labels (~5min)
How
to Remove SS Numbers (~1 min)
Compressing
the Youth Enrollment data folder to send to the West Regional Office
(~7 min)
_________________________________________________________________________________________________________
Manual
Blue
Ribbon Youth Enrollment Program Manual version
2.5 & 2.6
_________________________________________________________________________________________________________
Backing up data using Nero, Roxio or a Memory,
Flash drive
Using
Nero to back up Youth Enrollment data on a CD
Using
Roxio Easy CD Creator to back up Youth Enrollment data on a CD
Using
a Memory or Flash drive to back up Youth Enrollment data
_________________________________________________________________________________________________________
Ohio 4-H Certificates
New
Ohio 4-H Member Certificate (word document)-
updated
8/1/07
New
Ohio 4-H Member Certificate (pdf document)- updated
8/1/07
New
Ohio 4-H Volunteer Certificate (word document) - updated 8/1/07
New
Ohio 4-H Volunteer Certificate (pdf document) - updated 8/1/07
How
to Merge 4H Members Names and Years in 4H to the Ohio 4H Member
Achievement Certificate and or Ohio Volunteer Recognition Certificate.
How
to Merge 4H members name and Years in 4H to a Ohio 4H member Achievement
Certificate that is already printed. You just need to add name and
years in 4H. (Word
template to go with this process)
What
counties are using for certificates throughout Ohio - 4-H
Member Certificate Examples
_________________________________________________________________________________________________________
Help
Tip Sheets - 2008
How
to update your Fair Management program
YOUTH
Enrollment - General FAQs
Update
FAQs
Definitions:
Category
& Status definitions
Delivery
Modes
Grade
& Residence definitions
Group
Enrollment definitions
Statistical
definitions
File
Information:
In
the Group Enrollment Form how do I know what information goes where
and what information gets reported?
The following
chart will help you answer these questions. Click
here to access the Excell chart
E-mail
Preferences to email using Youth Enrollment
How
to transfer a Members' Project Information from and old club to
a new club
How
to change the Data Path to view either 2006 or 2007 data
Key
Violation Error Message
How
to change the data path when Youth Enrollment won't open
How
to Compress Youth Enrollment Data and Email the data file to the
West Regional Office
How
to add customized information to the 4-H Enrollment and Re-Enrollment
Forms
How
to change the data path when Youth Enrollment won't open
How
to enter data on the Group Enrollment Form and print out information
that you can use for the URS or County Annual Reports
How
to keep tract of 4-H campers in the members / leaders section of
Blue Ribbon
Members'
Age is not Calculating Correctly
Packing
tablesRemove duplicate
projects
Restructuring
Corrupted Data files with Datafix
Run-Time
Errors FAQs
Using
datafixList of files
in the data folder
Using
the File Utilities Option
Using
the Training Log
Using
the Utilities Option
What
information is required and what is optional to enter into the Blue
Ribbon Youth Enrollment program?
Records:
ADDING
OTHERS INTO THE MEMBER FILE
Add
a New Member or Parent
Add Club Memberships
Add Member Projects
Changing Member IDs
ID
Labels
How
to change a current club code name and then add that new code to
a club or group and delete the old name.
How
to Generate a Email list from Blue Ribbon to copy and paste into
Eudora
How
to delete Social Security numbers from the members record
How
to add School Codes
How
to change club ID numbers
How
to Create a User Defined Check Box
How
to create an email list from Blue Ribbon and export the list to
Excell so that you have a list of all advisors and members that
- contains names and email addresses.
How
to Create a Report from the User Defined Checkbox
How
to get rid of Unlinked Parents
How
to mark all advisors as direct advisors
How
to track Cloverbud Advisors to Print out Reports and Labels
Making
sure you have all necessary information marked so your 237 report
will balance
Saving
Reports in Excel
Saving reports
in Word
Setting Preferences
Using
the Club Query to Delete a Disbanded Club
Volunteer
Enrollments
The member's age is not
calculating correctly! What should I do? Click
here to access instructions
Queries
& SQL's
***
- It is best to copy and paste the SQL into Word first and then
copy and paste from Word into Youth Enrollment.
SQL's
SQL
- that could be used for Skill-A-thon Contest Registration and Score
Sheet - SQL
to select 4-H'ers Name and Club to filter out a range of projects
at one time whose members are age 15 to 18 (This example has beef
projects) The select lines will give you the information that is
filtered from this SQL or Create and View Query.
This
SQL will give you a list of market rabbit 4-H members that are taking
project 226. The data collected will include first name, last name
and club name.
This SQl will give you a list that includes member name, and both
parents.
This SQL will allow you to create your own score sheet
This
SQLwill allow you to create a list of members by projects. This
query will give you the following data: first name, last name, age,
club name, parent home phone, project ID and description. We are
also selecting out members that are active, new and returned.
This
SQL will allow you to obtain the following information: first name,
last name,
phone number, club name, address, project id number, new and returned
members, members age 9-11 & 15-19, female members, for members
taking (leadership) projects 370 - 374, 391 - 394, & 377
This
SQL will allow you to create a list of members and Cloverbud members
data(enrollment type data) to export to programs like Excel.
This
SQL will allow you to obtain the following information: first name,
last name,
phone number, club name, address, project id number, new and returned
members, members age 9-11 & 15-19, female members, for members
taking (horse) projects 173 - 175, 177, 180 -182, 185, 188 &
189.
SQL
to pull members with no projects assigned
SQL
- Creating a mailing list of members from the activity file
SQL
- Create
ad view query is to create a list of females between the ages of
8-15 in projects 139 & 140.
SQL
- Query for Member Name, 1 to 4 Project IDs, Project Description,
Club ID, Member Age and Parent Name (first and last)
SQL
- Query to pull out information from the member certification sections.
This SQL will retrieve all of the Member Cert tab data. (Including
project/ activity code, certification code, certification data and
certification number). The query will need to include Name, address,
phone, Club name (all clubs not just primary) and all member certification
data.
SQL
- that counties could use to retrive specific information about
committee members from the activity file. To be able to obtain information
about general, activity, project, and resource advisors. To be able
to export their name, address, phone number and club name, by activity.
To be able to create committee lists with phone numbers from the
activity file.
SQL
- A list of all the junior fair board members and the school that
they attend. JL/JR is the activity code for junior fair board
members.
SQL
- that would contain enrollment type data that I can export into
Excel.
SQL
- to mark all advisors as direct advisors.
SQL
- to delete Social Security numbers from the member records.
SQL
to select out last name, first name, address, city, zip, email,
phone #, county ID number, age, 12 grade, gender, year in 4-H, age,
residence, ethnic, year enrolled in 4-H, project ID and all
projects taken by those 12 graders.
SQL
- To make sure that all of your members are assigned to a primary
club or that the primary club matches the club that they are assigned
to you can run the following SQL.
SQL
- To make sure that all of your members have projects assigned to
their records.
Queries
How
to Create Queries
How
to use the Create and View Query - “Selecting project information”
How
to use the Create and View Query Feature
How
to Filter by Range
Member
Query - Adding Projects to Several Members at One Time
SQL
Definitions & Sample SQL's (Selected, Query, Lists)
Using
the Null Command to Find Missing Data
Using
the Project, Activity and Award Query
View and Create Query Formulas - combinations of data from both
the member and project query
How do I get rid of all
the email addresses in Blue Ribbon so I can start from scratch?
Click
here to access instructions
Installation:
How
to Install Blue Ribbon Youth Enrollment on a New Computer
How
to Network Blue Ribbon Youth Enrollment so that data can be entered
from any computer
Installation
FAQs
Statistical
Records:
Entering Group Youth
Enrollments
Entering
Volunteer enrollments
Reports
/ Printing:
How do I get a condensed
report for a specific club? This report will help you to create
a condensed report by club, which includes projects, etc. This report
is usually 1-2 pages in length compared to 10-12 pages. Click
here to access instructions
Generating
Basic Reports
How
to Print a Condensed Report for a Specific Club
Blue
Ribbon Youth Enrollment – Generating Reports:
* Member / Leader
Reports
*
Parent File Listing Reports
*
Member / Leader Listing by Club Report
Printer
FAQs
Printing
Enrollment Forms
Error
Messages
Key
Violation Error Message
Field
member ID not indexed
Codes:
2008
Ohio State 4H Project
Codes
State
wide Activities Codes
_____________________________________________________________________________
Balancing
the County 237 Report for 2007-
How to Instructions
The
following are two checks that you can do if your 237 doesn't balance.
Year End Processing
2007
Why and How to Process Year End Files (doc)
Year End Processing Tutorial (pdf)
Martech
Tip Sheets - 2007
Did you know that Martech has tips and tutorials on their website? Tip sheets are detailed information and instructions on a single item. These informative sheets are a supplement to the frequently asked questions page on the web site or your user manual. All sheets can be viewed and printed with the Adobe Acrobat reader. If there is a topic you would to see as a tip sheet, please let us know. Email martechsys@yahoo.com.
How to
backup your data with Window XP's Zip Utility
24 August 2005
- Exit Blue Ribbon on all computers.
- Locate your Data folder. (If you do not know where it is, check
the bottom of the BR screen for the Data Path.)
- RIGHT click on your Data folder.
- In the pop-up menu that appears, hover your mouse arrow over
"Send To ". Then choose "Compressed (zipped) Folder."
- This will create a file called "Data.zip" in the same
location as your Data folder. You will need to re-name
and move this file in order to have a useful backup.
- Rename:
- RIGHT click on Data.zip and choose "Rename".
- Type in your county name and the date: Franklin06102001
or WayneJune05. If the ".zip" was visible on your computer
when you changed the name, type it back in.
- Move to a new location:
- RIGHT click again on the new file and
choose "Cut".
- Open the window for a different location. RIGHT
click in a white (unused) space in that window,
and choose "Paste".
- (If you have another method to move files from one drive
to another, use the one that you are familiar with.)
How to backup your data with WinZip
24 August 2005
- Exit Blue Ribbon on all computers.
- Locate your Data folder. (If you do not know where it is, check the bottom of the BR screen for the Data Path.)
- RIGHT click on your Data folder.
- In the pop-up menu that appears, choose "Add to Data.zip".
- This will create a file called "Data.zip" in the same location as your Data folder. You will need to re-name and move this file in order to have a useful backup.
- Rename:
- RIGHT click on Data.zip and choose "Rename".
- Type in your county name and the date: Franklin06102001 or WayneJune05. If the ".zip" was visible on your computer when you changed the name, type it back in.
- Move to a new location:
- RIGHT click again on the new file and choose "Cut".
- Open the window for a different location. RIGHT click in a white (unused) space in that window, and choose "Paste".
- (If you have another method to move files from one drive to another, use the one that you are familiar with.)
|
 |
|
