SPSW - 'ensure data and graph print onto A4'?

SarahJS
SarahJS Trusted RegularRegistered Posts: 273
I've been doing the practice CBP an am on part 1, task 2.6.

It wants me to 'ensure data an graph will print on A4 paper'.

I've changed to landscape, reduced margins to minimum and reuced column width and I'm still over the limit horizontally. An to top it off, whenI look at solutions, there's takes 3 pages!

If this happens in my exam tomorrow, what should I do?

Also, do I leave the footer with my personal info on every single worksheet?

Thanks :)

Comments

  • Diddy Mau
    Diddy Mau Well-Known Registered Posts: 238
    Hello Sarah,
    depanding on your excell package.
    go to print preview
    page set up
    you should be able to select 'fit 1page by 1 page'

    Also, it will mention in the exam but definatly put a footer on each and every print out.
    think you need name and AAT number,
    the easiest way to think about it, what happens if several people sit the exam, and when they are marked the paperwork gets mixed up. they cant mark something if they dont know who it belongs to.

    When i done it, the examiners would only bring print outs if your name was on it, no name then it went in the bin.

    good luck
  • SarahJS
    SarahJS Trusted Regular Registered Posts: 273
    I've found that button now, so using that it'll just shrink the work to fit to one page.

    I didn't realise I'd actually be printing so many physical copies, I thought they'd just check the spreadsheets themselves!

    Thanks :)

    Edit: Another quick question, is the exam 1.5 or 2.5 hours? The practice one on he AAT website is 2.5, but all the other practice exams I've seen are 1.5, and I'm sure I've read somewhere else it's 1.5 too...
  • coojee
    coojee Experienced Mentor Registered Posts: 794
    SarahJS wrote: »
    I've found that button now, so using that it'll just shrink the work to fit to one page.

    I didn't realise I'd actually be printing so many physical copies, I thought they'd just check the spreadsheets themselves!

    Thanks :)

    Sometimes they don't check the actual copy they just look at it on screen but they'll do a print preview and if it doesn't fit to one page you won't pass that task.
  • SarahJS
    SarahJS Trusted Regular Registered Posts: 273
    coojee wrote: »
    Sometimes they don't check the actual copy they just look at it on screen but they'll do a print preview and if it doesn't fit to one page you won't pass that task.

    Any further ideas to shrink it then, short of shrinking font size?
  • coojee
    coojee Experienced Mentor Registered Posts: 794
    SarahJS wrote: »
    Any further ideas to shrink it then, short of shrinking font size?

    Just do fit to one page as Diddy Mau said.
  • janwal
    janwal Experienced Mentor Registered Posts: 1,189
    SarahJS wrote: »



    Edit: Another quick question, is the exam 1.5 or 2.5 hours? The practice one on he AAT website is 2.5, but all the other practice exams I've seen are 1.5, and I'm sure I've read somewhere else it's 1.5 too...

    The exam is 2.5 hrs long due to having to do the printouts, they allow for hiccups and will exten to 3 if needed.

    Good luck!!
  • KaySarah
    KaySarah Well-Known Registered Posts: 215
    coojee wrote: »
    Just do fit to one page as Diddy Mau said.

    There is also the option :
    Page Setup
    Page
    Adjust to ...... %
    then hit Preview to make sure as sometimes the Fit to 1 page makes it so small it's unreadable

    The current SPSW is being done in Excel 2007.

    Good luck Sarah

    Kay
  • SarahJS
    SarahJS Trusted Regular Registered Posts: 273
    Aaaah, just looked back and realised the computer saved the 'fit to one page', so hopefully it would still show for the marker :)

    Thanks
Sign In or Register to comment.

Not registered?

Register to create your free account, talk to AAT members and start your own discussions.

Privacy Policy