« previous next »
Pages: [1] 2 3 ... 35   Go Down

Author Topic: All ICT doubts here!  (Read 55949 times)

Offline shahmeerhaq

  • Newbie
  • *
  • Posts: 2
  • Reputation: 14
All ICT doubts here!
« on: March 07, 2010, 01:45:26 pm »


IN THIS TOPIC WE CAN HELP EACH OTHER IN PRACTICALS.
SO PLEASE JUST POSTS QUESTIONS AND ANSWERS ONLY.





SO ENJOY GUYS AND HELP THE HELPERS SO THEY CAN ALSO GET GOOD GRADES LIKE ALL OF PEOPLES.
« Last Edit: March 15, 2010, 01:47:15 pm by shahmeerhaq »
Logged

Offline shahmeerhaq

  • Newbie
  • *
  • Posts: 2
  • Reputation: 14
Re: HELP THE STUDENTS IN IT(IGCSE)-PRACTICALS
« Reply #1 on: March 07, 2010, 01:50:47 pm »
HEY IM I  NEED HELP IN THIS PAPER 3 PRACTICAL MAY/JUNE 2008
STEP NO-8
NO-8---USE A FUNCTION(THAT INCLUDES BOTH ABSOLUTE AND RELATIVE REFERENCING)IN CELL D7,TO CALCULATE THE SUM OF THE DURATION COLUMN IF THE DCODE COLUMN CONTAINS MD
DO NOT INCLUDE ROWS 1 TO 3
RELPLICATE THIS FUNCTION INTO CELLS D8 TO D13 TO SUM THE TOTAL DURATION FOR EACH.
Logged

Offline °o.O-hash94-O.o°

  • SF Master
  • ******
  • Posts: 1447
  • Reputation: 7321
  • Gender: Male
  • kNoW YoUr eNeMy!
All ICT doubts here!
« Reply #2 on: April 04, 2010, 09:08:36 pm »
hi,

pls ask all your doubts here in this thread...and hopefully u will get the answers to ur doubts!

and dont make separate thread for ICT doubts from now on!

Thanks
Logged

Offline haris94

  • SF Senior Citizen
  • *****
  • Posts: 930
  • Reputation: 984
  • Gender: Male
Re: All ICT doubts here!
« Reply #3 on: April 04, 2010, 09:26:35 pm »
46 Produce a new report which:
• shows a summary of the week 37 sales only
• uses only the Staff and Income fields
• calculates the sum of the Income field for each member of Staff
• counts the number of holidays sold by each member of Staff

question is from m/j 2009 paper 2 (igcse ict)
i know how to do it in access 2007 but my school has 2003; so if anybody could help me do this in 2003 it would be appreciated
Logged
WHAT WE DO IN LIFE ECHOES AN ETERNITY

Offline Vin

  • SF V.I.P
  • ********
  • Posts: 7914
  • Reputation: 52609
  • Gender: Male
    • Theory of Life - A new skew.
Re: All ICT doubts here!
« Reply #4 on: April 05, 2010, 10:58:41 am »
hey i got this one..
in 2003 ryt...quite simple...
jus right click on the "query design view"
look for "totals"...click it n another row of totals will appear just below the "tables" row
once this is done the row automatically takes "group by"
let the staff remail grouped "group by"
now add two of the income and select "sum" or "count"
ur things done... if u wer able to do it in 2007 u'll surely get it in 2003
i feel 2007 if far better than 2003 for igcse :) :)
Logged

Offline haris94

  • SF Senior Citizen
  • *****
  • Posts: 930
  • Reputation: 984
  • Gender: Male
Re: All ICT doubts here!
« Reply #5 on: April 05, 2010, 09:12:52 pm »
im not getting it
i got the totals row and left the staff as "grouped by"
now, what do u mean by "now add two of the income"?
Logged
WHAT WE DO IN LIFE ECHOES AN ETERNITY

Offline haris94

  • SF Senior Citizen
  • *****
  • Posts: 930
  • Reputation: 984
  • Gender: Male
Re: All ICT doubts here!
« Reply #6 on: April 05, 2010, 09:48:52 pm »
got it at last
your absolutely right though, 2007 is much better and easier
Thanks a lot  :)
Logged
WHAT WE DO IN LIFE ECHOES AN ETERNITY

Offline Vin

  • SF V.I.P
  • ********
  • Posts: 7914
  • Reputation: 52609
  • Gender: Male
    • Theory of Life - A new skew.
Re: All ICT doubts here!
« Reply #7 on: April 06, 2010, 01:44:33 pm »
ur welcome...
post ur doubts here pls..
Logged

Offline haris94

  • SF Senior Citizen
  • *****
  • Posts: 930
  • Reputation: 984
  • Gender: Male
Re: All ICT doubts here!
« Reply #8 on: April 06, 2010, 09:04:56 pm »
PLS TELL ME HOW TO DO THIS

29 In the stylesheet excerpt, amend the style for heading 1 so that the colour is pure
blue (with no green or red components). Change the hexadecimal code so that this
is correct.
30 In the stylesheet excerpt, amend the style for heading 1 so that the font size is 36
point. Change the stylesheet so that this is correct.
31 In the stylesheet excerpt, amend the style for a list so that it is italic. Change the
stylesheet so that this is correct.
32 In the stylesheet excerpt, amend the style for a paragraph so that it will accept any
generic sans-serif font as well as the specified fonts. Change the stylesheet so that
this is correct.

THIS QUESTION IS IN MS WORD (FROM M/J 2007 PAPER 2)
Logged
WHAT WE DO IN LIFE ECHOES AN ETERNITY

Offline Vin

  • SF V.I.P
  • ********
  • Posts: 7914
  • Reputation: 52609
  • Gender: Male
    • Theory of Life - A new skew.
Re: All ICT doubts here!
« Reply #9 on: April 07, 2010, 05:42:54 am »
ya use this site for instance..its basically html coding for fronpage, u'll find it here... http://igcseict.info/practical/web/
or if u hav ny doubts refer to the markscheme of the year its vry accurate...
Logged

Offline haris94

  • SF Senior Citizen
  • *****
  • Posts: 930
  • Reputation: 984
  • Gender: Male
Re: All ICT doubts here!
« Reply #10 on: April 07, 2010, 09:45:03 am »
yea got it
those notes r great By the way
Thanks again
Logged
WHAT WE DO IN LIFE ECHOES AN ETERNITY

Offline haris94

  • SF Senior Citizen
  • *****
  • Posts: 930
  • Reputation: 984
  • Gender: Male
Re: All ICT doubts here!
« Reply #11 on: April 08, 2010, 11:35:12 am »
NEED HELP IN THIS QUESTION FROM M/J 2007 PAPER 3 -- MS EXCEL

Search this data to find all the items where Quantity is greater than or equal to 60
and Price is greater than £2

PLS TELL ME HOW TO DO IN EXCEL 2003

Logged
WHAT WE DO IN LIFE ECHOES AN ETERNITY

Offline Vin

  • SF V.I.P
  • ********
  • Posts: 7914
  • Reputation: 52609
  • Gender: Male
    • Theory of Life - A new skew.
Re: All ICT doubts here!
« Reply #12 on: April 09, 2010, 11:20:18 am »
for this u need to apply filter options...i think in 2003 this option should be in "Tools"..first select the data u wanna filter (here its the "quantity"...dont forget to select the whole column of the field) go to tools and select autofilter and u'll get a drop down menu on the field name..
in the drop down menu there should be an option of "greater than or equal to" if not go to custom and select greater than or equal to "60"
now autofilter for price also...and select "greater than" and "2"   
u get it???
to remove the filter jus select the cells/column and remove the filter option..hope u get it...
Logged

Offline haris94

  • SF Senior Citizen
  • *****
  • Posts: 930
  • Reputation: 984
  • Gender: Male
Re: All ICT doubts here!
« Reply #13 on: April 09, 2010, 12:09:45 pm »
Quote from: sd7764 on April 09, 2010, 11:20:18 am
for this u need to apply filter options...i think in 2003 this option should be in "Tools"..first select the data u wanna filter (here its the "quantity"...dont forget to select the whole column of the field) go to tools and select autofilter and u'll get a drop down menu on the field name..
in the drop down menu there should be an option of "greater than or equal to" if not go to custom and select greater than or equal to "60"
now autofilter for price also...and select "greater than" and "2"   
u get it???
to remove the filter jus select the cells/column and remove the filter option..hope u get it...

ok i got how to filter, Thanks for that
but the problem is i dont get how to filter 2 columns
eg. i filtered data for the column "quantity"
now i do the same procedure for "price" but it just removes the filter for "quantity"

pls help asap; hv boards on 15th
Logged
WHAT WE DO IN LIFE ECHOES AN ETERNITY

Offline haris94

  • SF Senior Citizen
  • *****
  • Posts: 930
  • Reputation: 984
  • Gender: Male
Re: All ICT doubts here!
« Reply #14 on: April 09, 2010, 12:14:43 pm »
Quote from: 7ood on April 09, 2010, 11:42:09 am
wat email server should we use to send the emails dnt say hotmail cuz it doesnt contain bcc or cc

hotmail does hv bcc and cc
option is at the top right corner of the new email page "show cc and bcc"
Logged
WHAT WE DO IN LIFE ECHOES AN ETERNITY
Pages: [1] 2 3 ... 35   Go Up
« previous next »