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

Offline Vin

  • SF V.I.P
  • ********
  • Posts: 7914
  • Reputation: 52609
  • Gender: Male
    • Theory of Life - A new skew.
Re: All ICT doubts here!
« Reply #15 on: April 09, 2010, 01:35:00 pm »
@haris
ya so wat u cn do is select the whole range of cells...meaning all the fields names including the data in the column....

Offline haris94

  • SF Senior Citizen
  • *****
  • Posts: 930
  • Reputation: 984
  • Gender: Male
Re: All ICT doubts here!
« Reply #16 on: April 09, 2010, 02:32:38 pm »
yea it worked
Thanks
WHAT WE DO IN LIFE ECHOES AN ETERNITY

Offline Mahdi 1992

  • Newbie
  • *
  • Posts: 2
  • Reputation: 20
Re: HELP THE STUDENTS IN IT(IGCSE)-PRACTICALS
« Reply #17 on: April 09, 2010, 06:20:43 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.
use "=SUMIF" function

Offline Vin

  • SF V.I.P
  • ********
  • Posts: 7914
  • Reputation: 52609
  • Gender: Male
    • Theory of Life - A new skew.
Re: All ICT doubts here!
« Reply #18 on: April 10, 2010, 12:05:22 pm »
nytime..

Offline Usman B.Aamir

  • Newbie
  • *
  • Posts: 11
  • Reputation: 162
  • Gender: Male
Re: All ICT doubts here!
« Reply #19 on: April 11, 2010, 07:41:04 pm »
Hey...is anyone aware of any new things tht can come in May-June 2010 Papers for IT Practical....???
I heard from one of my friends tht some people have posted some new things on different forums (not FEP).....

I'll be glad if i get to know something from some1 as fast as possible....cuz i have my FInal IT Practicals on 18th of this month.... ;)

Thnkks in advance...
USman

Offline Malak

  • Honorary Member
  • SF Farseer
  • *****
  • Posts: 4454
  • Reputation: 65534
  • A warm smile is the universal language of kindness
Re: All ICT doubts here!
« Reply #20 on: April 13, 2010, 01:59:01 pm »
For ICT theory exam, I just wanted to know is it okay if we answer any question (for example to describe something) in points? or doest it has to be in a paragraph form?
Thanks
If you are a man who degrades women then allow me to respectfully remind you that you came from ONE

Reminder to myself: Stop worrying and start working

SF magazine 2012 - Download here

Offline DaYmN

  • Newbie
  • *
  • Posts: 9
  • Reputation: 19
Re: All ICT doubts here!
« Reply #21 on: April 15, 2010, 10:13:26 pm »
does any1else find that they give us plentiful time to finish the ICT practicals?
because most of the people in my class finish way before the exam time is up!
do any of you get to take breaks between these practicals? is this allowed?  ???

Offline JD46

  • Newbie
  • *
  • Posts: 33
  • Reputation: 73
Re: All ICT doubts here!
« Reply #22 on: April 16, 2010, 09:01:48 pm »
45) Produce a new report from all the data which:
• shows a summary of only the Country, Product and Stock fields
• performs a count of the number of Products for each Country
• calculates the sum of the number of items in Stock for each Country
• only reports where Products number more than 3

I know most of this but not the 2nd one
I host IGCSE help files bundled together on my blog
http://igcseprep.blogspot.in/

Offline Vin

  • SF V.I.P
  • ********
  • Posts: 7914
  • Reputation: 52609
  • Gender: Male
    • Theory of Life - A new skew.
Re: All ICT doubts here!
« Reply #23 on: April 17, 2010, 09:58:49 am »
do u no how to group by>>??
right click on any row of design view and select "totals"
once havin done that u might get another row called "Totals"..."group by" Country
Under Products field... select from the drop down menu "Count" in the totals row
same for sum...u may no how to show "more than 3".... :) :)

Offline JD46

  • Newbie
  • *
  • Posts: 33
  • Reputation: 73
Re: All ICT doubts here!
« Reply #24 on: April 17, 2010, 10:20:51 am »
sd7764

i didn't understand,because this question requires a summary so i made a query in wizard first so only required fields were ther .Then in query-summary i clicked on count  blah... and sum. so basically im left with a a summary now! what do i do!? My exam is on monday!! and make sure the steps u tell me are 2003 steps! :) Thanks!
I host IGCSE help files bundled together on my blog
http://igcseprep.blogspot.in/

Offline ksitna

  • Allhamdullillah
  • SF Geek
  • ****
  • Posts: 497
  • Reputation: 491
  • Gender: Female
Re: HELP THE STUDENTS IN ICT-PRACTICALS
« Reply #25 on: April 17, 2010, 04:40:42 pm »
hi i need help in june 08 q45
how do i do it?
take whatever you want and give nothing back :)

Offline ~HyDrOgEn~

  • SF Immigrant
  • **
  • Posts: 115
  • Reputation: 167
Re: All ICT doubts here!
« Reply #26 on: April 17, 2010, 10:47:15 pm »
Hi in the IGCSE exam ICT practical can we use Microsoft office 2007! plz reply urgentlly!

Offline Saladin

  • The Samurai
  • Honorary Member
  • SF V.I.P
  • *****
  • Posts: 6530
  • Reputation: 59719
  • Gender: Male
  • I believe in those who believe in me
    • Student Tech
Re: All ICT doubts here!
« Reply #27 on: April 17, 2010, 10:51:28 pm »
You can use any MS office package.

You can use any open office package.

Offline 7ooD

  • SF Geek
  • ****
  • Posts: 427
  • Reputation: 713
  • Gender: Male
    • 7ood
Re: All ICT doubts here!
« Reply #28 on: April 17, 2010, 11:12:30 pm »
ask ur centre cuz 2007 in most cases will not be there cuz they use xp
pimpin ain't dead it just moved to the web



Offline ~HyDrOgEn~

  • SF Immigrant
  • **
  • Posts: 115
  • Reputation: 167
Re: All ICT doubts here!
« Reply #29 on: April 18, 2010, 01:39:34 am »
Ok thanks!