Author Topic: ICT june 2009 paper 2....help!!  (Read 4018 times)

Offline thepokerpro

  • Poker is a sport!!
  • SF Immigrant
  • **
  • Posts: 70
  • Reputation: 138
  • Gender: Male
ICT june 2009 paper 2....help!!
« on: October 12, 2009, 02:06:38 pm »
Hey guys,

I wasnt able to complete question 44 in the jun 09 ICT paper 2..!!

My exam is in 3 days!!!........so if any one can help me it will be much appreciated... ;D ;D ;D ;D ;D

Please complete the question and give me a guide to doing it myself..!!

The files are attatched with this post...!!!

Tanx a lot!!!!!!!! ;D ;D ;D ;D ;D ;D

P.S: if your date format is like the american format.......use the file "j9sales2.csv"

 ;D ;D ;D ;D ;D ;D ;D ;D ;D ;D
B4 i took I.G.C.S.E i knew how to do math without calculators..( :

nid404

  • Guest
Re: ICT june 2009 paper 2....help!!
« Reply #1 on: October 12, 2009, 02:25:38 pm »
OKay first

1) fit on single page
File
Page setup
potrait
fit in page width and height

note.....it won't fit on a page as yet....so go to the next part

2)filtering
select the field
go to data>filter

a drop down appears....for week you do 35
for date...click custom
you'll get a window
in the first drop down....put greater than...and to it's right 01/01/2009
and
in the second put less than...31/01/2009

thennn
3) select the field not require......go to format>column>hide

4) expand the columns so the field names are completely visible

5)click on the date field and staff field>data>sort>ascending order for date first..then by staff
6) view>header and footer>custom.....in the middle type mini tours and in the right tyoe ur name,centre,candidate no


DONE :D


Offline thepokerpro

  • Poker is a sport!!
  • SF Immigrant
  • **
  • Posts: 70
  • Reputation: 138
  • Gender: Male
Re: ICT june 2009 paper 2....help!!
« Reply #2 on: October 12, 2009, 02:53:41 pm »
Wait a second.....!!!

U r using Microsoft excel!!!

I have to use Microsoft access!!!

It shows in the marking scheme...

I can do it with excel but i dont think it is allowed!!!!
 ??? ??? ??? ;D ;D ;D ??? ??? ???
B4 i took I.G.C.S.E i knew how to do math without calculators..( :

nid404

  • Guest
Re: ICT june 2009 paper 2....help!!
« Reply #3 on: October 12, 2009, 02:58:28 pm »
oh i didn't know....no problem...will do it with access and tell you
Well i actually gave this paper...but i don't remember ::)

two minutes....i'll let you know

Offline thepokerpro

  • Poker is a sport!!
  • SF Immigrant
  • **
  • Posts: 70
  • Reputation: 138
  • Gender: Male
Re: ICT june 2009 paper 2....help!!
« Reply #4 on: October 12, 2009, 03:03:48 pm »
thanks a lot.. ;D ;D
B4 i took I.G.C.S.E i knew how to do math without calculators..( :

nid404

  • Guest
Re: ICT june 2009 paper 2....help!!
« Reply #5 on: October 12, 2009, 03:14:01 pm »
ok can u tell me which part you have a problem with

you know to sort right?? this can be done in the query...the query can further be used to make the report.....


which part r u not getting....the report or the query?
Accordingly i can put down what you need

Offline thepokerpro

  • Poker is a sport!!
  • SF Immigrant
  • **
  • Posts: 70
  • Reputation: 138
  • Gender: Male
Re: ICT june 2009 paper 2....help!!
« Reply #6 on: October 12, 2009, 03:17:55 pm »
I have a problem with he third part of the question....

I tried to sort the "week" and "date" fields in the query......but it isnt working....

I appreciate your help!!!
B4 i took I.G.C.S.E i knew how to do math without calculators..( :

nid404

  • Guest
Re: ICT june 2009 paper 2....help!!
« Reply #7 on: October 12, 2009, 03:23:14 pm »
these r the criteria part

Under week's criteria...type in "35"

Under date's criteria type in Between #date# And #date#

nid404

  • Guest
Re: ICT june 2009 paper 2....help!!
« Reply #8 on: October 12, 2009, 03:23:35 pm »
anything more feel free to ask

Offline thepokerpro

  • Poker is a sport!!
  • SF Immigrant
  • **
  • Posts: 70
  • Reputation: 138
  • Gender: Male
Re: ICT june 2009 paper 2....help!!
« Reply #9 on: October 12, 2009, 05:05:44 pm »
thanks a lot man.....it worked!!!!
B4 i took I.G.C.S.E i knew how to do math without calculators..( :

nid404

  • Guest
Re: ICT june 2009 paper 2....help!!
« Reply #10 on: October 12, 2009, 05:06:57 pm »
of course....it has to :P  :D

Offline omar_mero

  • Newbie
  • *
  • Posts: 29
  • Reputation: 38
Re: ICT june 2009 paper 2....help!!
« Reply #11 on: October 13, 2009, 07:58:04 am »
ThePokerPro Plz i need your email to ask u a few questions as my exam is on 16-10 not on 15-10, by the way I have the supporting files of the Exam of Nov09 so plz if u could PM me with ur email