1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Hi Guest, welcome to the TES Community!

    Connect with like-minded professionals and have your say on the issues that matter to you.

    Don't forget to look at the how to guide.

    Dismiss Notice

Edexcel Unit 7 Database

Discussion in 'Computing and ICT' started by rick26, Dec 5, 2010.

  1. Hi, any chance I could get a copy???
    Cheers
    Bob - Hertfordshire
     
  2. Only the relationships with some data in
    I haven't worked on the interface yet
    You are welcome to it but I don't know your email address
     
  3. That's what I was thinking, unless each order was for a quantity of one specific game, then the Order Line wouldn't be needed. I've been though this exam a few times now, they don't often involve more than 4 tables.
    I see your point about the prototype but I think it's unlikely that there'll be no data files - surely to "show some of the good things a database can do" you need some data, and pupils won't be asked to spend time adding a bunch of data will they?
    I could trade some text files for a unit 3 practice exam!
     
  4. Chad78

    Chad78 New commenter

    Has anybody else noticed that this scenario fits the example project in the A2 Applied ICT book (from Edexcel) quite nicely?


     
  5. I had noticed this...as had my students...smiles all round...still haven't discovered the hidden problem yet, which I'm sure there is.
     
  6. I see this as having a "half-way house mark scheme solution" again. I would expect in addition to the order, order item? and customer there to be related tables for the products; game, console and then even a supplier. Or are they going to expect the product details in one gigantic table with about 30 fields.
     
  7. I decided to create one datafile and told the students that this is the worse case

    It worked OK
     
  8. DEmsley

    DEmsley New commenter

    I've stuck this here as it's a database thread and I didn't want to start another...
    This may be Sunday night stupidity setting in by how do you get a macro to do the same as a click on the "refresh all" icon?
    I've tried RunCommand Refresh
    I've also tried RepaintObject form nameofsubform

     
  9. DEmsley

    DEmsley New commenter

    IGNORE PREVIOUS.[​IMG]
    I needed to use requery but run the macro from the "on change" option for the previous field.

    Thank you all for your help. It's good to know you're so good you don't even need to reply to help me [​IMG]
    Roll on Friday
     
  10. I have had a quick look and 5 tables would be my recommendation - having a separate table for order lines is standard and yes, this does match at least one of the scenarios in the EDEXCEL book (PRS supplies)
    Anyone got any test data yet that we can give to the students to practice on?
    Thanks.
     
  11. Isn't this a total farce now ?
     
  12. Time to call in a Drama specialist.
     
  13. Well it's a joke. The pupils can't do this stuff, they wouldn't have a clue if you simply gave them the spec. and the data and told them to fix it.
    I remember doing French O-Level Oral test. Ten minutes with someone you've never met before discussing things in French around a general topic. You had no idea what he would say, other than it was broadly on one of three topics.
    Nowadays they literally learn the conversation verbatim. I saw my daughter's best mates aide-memoire on a keyring. There's no bl**dy point in that at all, it might as well be in ancient Greek as French - and she's an able girl.
    At some point surely we're going to have to dump all this pretence in education and start teaching them to do things.
    First thing would be to dump this joke practical in favour of one aimed at a realistic level and achievable in stages, where teachers and pupils get the test at the same time, when the exam starts.
     
  14. I know, but if you prepare a worksheet that tries to teach the skills they withdraw your interview and insist that the students have to work it out for themselves. The fact that they can't isn't an issue, it only matters that they try.
    I did a Spanish supply cover last year where all I had to do was to read the teacher part of the script and the student read the student part. It was rehearsal for the exam. I pointed out at the time that there were grammar errors in the script, but that didn't matter so long as they learned it well enough to recite it back.I don't think many knew what it meant.
    At present it's in everyone's interest to keep things the way they are.People who want to teach how to do things are a nuisance because that would mean everyone else having to teach things too. It's easier to maintain the pretence.

     
  15. DEmsley

    DEmsley New commenter

    I'm a little concerned that the exam materials for January 2011 have not yet arrived on the secure site. This is cutting it a bit fine.

     
  16. Due tomorrow from Edexcel important dates
     
  17. DEmsley

    DEmsley New commenter

    OK Now that that's over we can discuss it again.
    This has been a fairly straightforward process for our students. The database itself was far simpler than has been required in the past; unless my students missed something in the question paper.
    I read the paper on Friday evening and I couldn't find anything too excessive. Nothing too far beyond what we teach for the OCR Nationals Unit 7 on databases.
    Anyone else think this was a bit too simple?
     
  18. I don't think it was any harder / simpler than previous years but I do think the pre-release was "better" than last years, in that it gave you pretty much everything that the database needed to do (and then this was replicated with no nasty surprises in the actual exam).
    Don't do U7 OCR but I fail to believe that you need do anything as complex as this!
     
  19. DEmsley

    DEmsley New commenter

    Sorry s-o-r I didn't say you had to do this for OCR Nationals; I said that we do. 3 table relational database with some interesting functions, macros and queries.
    For OCR Nationals you have to do the three table database and it has to function so as I said not much extra.

     

Share This Page