Friday, 10 January 2014

Year 13 digital media ideas

Thinking about projects for students
Virtual rugby competition
Testing system for computing skills, an alternative to moodle
Feedback system for me
Competition system for judging
Spelling quiz

MySQL php system out of the yoobee book could be a good start

Also look for ideas out of last years ideas for digital media apps for the school, most of these require a database to run

I don't know how this would work,
There needs to be a brief, outline what they are trting to do and what outcomes are needed. Inputs and output requirements. Needs to have wireframing and developments of the look and feel of the site. The student could create a fantastic backend, but if the frontend looks bad, its not going to be used.

But this was posted tonight,

now this links to a website which ranks schools in auckland

now, thats not really what I want to get into at this point. Instead it has given me an idea, 
For Level 3 Digital Technologies, students need to create a relational database, we have all the school information available to us through education counts
Which also provides us with, 

Description of Variables
School NumberUnique number assigned to each institution
School NameFull name of each institution 
TelephoneTelephone number for each institution, including area code
FaxFacsimile number for each institution, including area code
EmailEmail address for appropriate administrative contact for institution
PrincipalCurrent principal at school
StreetStreet for location address
Suburb Suburb for location address
CityTown or city for location address
Postal Address 1P O Box, Private Bag or rural delivery number for postal address
Postal Address 2Suburb for Postal Address
Postal Address 3Town or city for Postal Address
Postal CodePostcode used by NZ Post for Postal Address
School TypeType for each institution
DefinitionDefinition provides further descriptive information on the type of each institution
AuthorityDescribes the ownership/operation or registration status of each educational institution
Gender of StudentsSchool gender i.e. Gender of students that schools cater for
Territorial Local AuthorityThe territorial authority area the school is located in.  The territorial authority boundaries are defined by Statistics New Zealand.
Regional CouncilThe regional council area the school is located in.  Regional Council boundaries are defined by Statistics New Zealand.
Census Area UnitThe census area unit area each school is located in.  Census Area Unit boundaries are defined by Statistics New Zealand.
WardThe Ward area the school is located in. Wards are subdivisions of territorial authorities.
Ministry of Education Local OfficeMinistry of Education Local Office district each institution is located in 
General ElectorateGeneral electoral district for the area where an institution is located. Based on the electoral boundaries for the 2008 election
Māori ElectorateMāori electoral district for the area where an institution is located. Based on the māori electoral boundaries for the 2008 election.
LongitudeLongitudinal co-ordinate where the institution is located.
LatitudeLatitudinal co-ordinate where the institution is located.
DecileA schools decile indicated the extent to which the school draws its students from the low socio-economic communities. Decile 1 schools are the 10% of schools with the highest proportion of students from the low socio-economic communities, whereas decile 10 schools are the 10% of schools with the lowest proportion of these students. A schools decile does not indicate the overall socio-economic mix of the school. 
School RollsThe most up-to-date roll data available.  The roll information will be older that the date of the release of the directory.

Everything someone needs to present information about a school... I love the Longitude and Latitude parts, could make for some interesting Google Maps, but that is not what I am on about at present.

Now, the students would need to gather all the standards that NCEA has to offer, but wait, this is the other relational table, 
Standard Number, Domain, Name, Credits, Internal/External

Simple enough, could try getting the information out of NZQA or out of a student that I know that has it from another school. 

The last part, getting every single secondary schools curriculum guide, be it online or having to get it from the school itself!

Now, do we do this for just one subject area, say Digital Technologies, or do we look at the bigger picture? How would we go about categorising all the courses that are on offer within schools?

Could make for an interesting project.
Brief development, with database with digital media on top and prototyping, credit values 4, 6, 4, 6, it makes a 20 credit project for a student.

The work involved is immense, but I think this could be done. 

UPDATE: Through a tweet this morning,

@ I am thinking of getting students to create a new

@ Sounds like a good brief. Also makes students consider relevant data too!

@ I like the comment "relevant data"

This is something that we need to start thinking about, relevant data, I know a majority of teachers have used the information from the resource, which related to a DVD store, but as someone posted in a tweet

@ Yep, I know what you mean... ("What's a DVD sir? I just stream stuff off the net!") ;-)

Are we being relevant with the contexts that we are giving our students.
I now need to make sure that what is being suggested will work with the standard.

UPDATE: One thing that worries me, is that how do I know that a project is complex enough. this is something that haunts me from my polytech days. 

No comments: