Author Topic: Students and grades (Read 2030 times)

ratinakage · March 02, 2010, 11:24:09 pm

Hi all,

I am creating a site which will hopefully be used by many students.

As such, I want the contacts in the database to have a grade number if they are students.

Then at the end of the year, all students in grade 5, should automatically, change to grade 6. All grade 6 to grade 7 etc.

I am in South Africa so, the end of the school year is also the end of the calendar year. December 31st should be fine.

Any suggestions on how to get this working would be much appreciated.

Thanks!!
Guy

Erik Hommel · March 02, 2010, 11:32:51 pm

You could do something with tags? And then write a hook that changes the contacts with "Grade 6" tag to "Grade7" tag once the date has passed?

petednz · March 02, 2010, 11:35:33 pm

What are you wanting to do with the fact that they are Grade 5 or 6 - how / where do you want this to show or be applied?

One thought would be to just Group or Tag each year, and then at end of year just rename your Group/ Tag.

Other option is to think of them as a cohort eg with the 'year' that they started at school so that you don't need to change this from year to year, but ie in year X the 2008 group will be Grade 4, then in year X+1 they will be Grade 5

ratinakage · March 03, 2010, 03:40:39 am

Thanks guys!

I just need to categorise them by grades for contact reasons. So, we might want to send an email to all grades 5,6,7 telling them to go to a meeting or rally somewhere. And all grades 8,9,10 to go somewhere else... At the end of the year, the assumption is that everyone moves up a grade. I thought CiviCRM might have a way of handling this.

But I guess its easy enough to do by hand. At the end of the year, just rename each grade to the one above. I wonder if there's a way to automate that.

@Erik, what are these hooks you mention? Are they quite easy to use and program?

Cheers!

Donald Lobo · March 03, 2010, 06:58:39 am

i have the same issue with my school site. I store the grade in a custom field (actually i store 2 different styles for integration purposes)

at the end of the school year, i'm planning to:

1. backup the database and mark it as 2009-2010 DB

2. Mark all graduating students with a new sub type called "Alumni"

3. update grade = grade + 1 where grade < 8

4. mark all students who've also left the school as alumni

5. revoke access to all parents who no longer have a current student

i'll probably script most of the above at the end of the year

lobo

Erik Hommel · March 03, 2010, 07:07:02 am

Lots of help, and you do not need the hooks as you can see from the other answers. Hooks is quite an wasy way to customize CiviCRM, see:
http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+hook+specification

ratinakage · March 05, 2010, 02:12:02 am

Quote from: Donald Lobo on March 03, 2010, 06:58:39 am

i have the same issue with my school site. I store the grade in a custom field (actually i store 2 different styles for integration purposes)

at the end of the school year, i'm planning to:

1. backup the database and mark it as 2009-2010 DB

2. Mark all graduating students with a new sub type called "Alumni"

3. update grade = grade + 1 where grade < 8

4. mark all students who've also left the school as alumni

5. revoke access to all parents who no longer have a current student

i'll probably script most of the above at the end of the year

lobo

Thanks!

When you say script, do you mean pure SQL?

Donald Lobo · March 05, 2010, 08:00:13 am

not sure, since i've not yet done it. most likely this will be a php script if i had to take a guess

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: Students and grades (Read 2030 times)

ratinakage

Students and grades

Erik Hommel

Re: Students and grades

petednz

Re: Students and grades

ratinakage

Re: Students and grades

Donald Lobo

Re: Students and grades

Erik Hommel

Re: Students and grades

ratinakage

Re: Students and grades

Donald Lobo

Re: Students and grades