ICT : Post your doubts here !

[Gergawy]

Better than this thread! Haha

lol yeah , but not everyone know that site , so its better to come here and also there

 

[IGCSE STUDENT]

just highlight it in the "DESIGN" , and then go to the html source of the page and the highlighted text , delete it and if there is a style for that text , delete it also

aha, that's a useful way too, thanks again

 

[Gergawy]

aha, that's a useful way too, thanks again

you welcome

 

[Dudu]

Really struggling on this question! Please could you do it for me while outlying the steps.

Oct/Nov 2009 Paper 2. Question 46-52.

46 Produce a new report from all the data which:
• uses only the Staff and Number fields
• calculates the sum of the Number field for each member of Staff
• counts the number of holidays sold by each member of Staff
47 Export this data in a format that can be opened by your graph/charting package.
Save this data in a format which can be imported into a text document.
48 Import this data into your document as a table immediately after the paragraph which
ends:
The sales summary for all staff is included here:
Make sure there is one blank line above and below the table.
49 You now need to open the data exported at Step 47 in an appropriate graph/charting
package.
50 Create a pie chart showing the number (count) of holidays sold by each member of staff.
51 Add the title Number of Holidays Sold to the chart.
52 Label the segments with the Staff initials and the number of holidays sold.
Pullout or highlight the segment representing the largest value (AR).
Do not include a legend.

Would Appreciate it if you could help me out.
Cheers

 

[shefali]

Gergawy your work becomes a lot easier..publish the practical guide files from that site and if u have problems in explaining to ppl you can give links from there

 

[Gergawy]

Gergawy your work becomes a lot easier..publish the practical guide files from that site and if u have problems in explaining to ppl you can give links from there

well ... i wont , cuz there is more than one way to solve a problem and i am using mine

 

[umer khan666]

i got a similar problem i cant not fit my background image offront page tobrowser and how to remove its tiling please help me :'(

its obvious , you must just resize the frontpage to fit with the image , the cursor must be at the end corner of the frontpage and it should not be maximized , like resizing this web browser u are using such that my comment only appears , nothing else (see the image) .


and about the excel , its also obvious , that u must resize everything to fit on two pages wide , which means the cells should not exceed more than two pages wide , wide means (Left and Right) , long means (Up and down) , if i said it should fit within two pages long , it means the cells should not exceed two pages

if u got more questions , shoot them to my face and you will find the reply

t

its obvious , you must just resize the frontpage to fit with the image , the cursor must be at the end corner of the frontpage and it should not be maximized , like resizing this web browser u are using such that my comment only appears , nothing else (see the image) .


and about the excel , its also obvious , that u must resize everything to fit on two pages wide , which means the cells should not exceed more than two pages wide , wide means (Left and Right) , long means (Up and down) , if i said it should fit within two pages long , it means the cells should not exceed two pages

if u got more questions , shoot them to my face and you will find the reply

 

[umer khan666]

how to make the background image to fot to browser and how to remove tiling

 

[AMEERA KHAN]

Im doing oct-nov ict paper 2 2007, there's surprisingly a question about vlookup, im doing the right thing but it's not working for all the records... its question 49.... any help??

 

[IGCSE STUDENT]

ok a very confusing thing, when do we use vlookup and when normal lookup?

 

[Gergawy]

Really struggling on this question! Please could you do it for me while outlying the steps.

Oct/Nov 2009 Paper 2. Question 46-52.

46 Produce a new report from all the data which:
• uses only the Staff and Number fields
• calculates the sum of the Number field for each member of Staff
• counts the number of holidays sold by each member of Staff
47 Export this data in a format that can be opened by your graph/charting package.
Save this data in a format which can be imported into a text document.
48 Import this data into your document as a table immediately after the paragraph which
ends:
The sales summary for all staff is included here:
Make sure there is one blank line above and below the table.
49 You now need to open the data exported at Step 47 in an appropriate graph/charting
package.
50 Create a pie chart showing the number (count) of holidays sold by each member of staff.
51 Add the title Number of Holidays Sold to the chart.
52 Label the segments with the Staff initials and the number of holidays sold.
Pullout or highlight the segment representing the largest value (AR).
Do not include a legend.

Would Appreciate it if you could help me out.
Cheers

you will use the query wizard for the design and then choose the staff and number fields and then choose the sum for staff and tick the count of records and thats it , exporting by Right Click on the table u just created from the table list on the left and choose export and choose excel and save it also in an rtf format or a word.

insert the table where the question asked

just press enter before and after the table

you will highlight the data , go to Insert and then choose a pie chart , and then in the chart options will appear above , go the layout and choose the chart title , and again in the layout , go to Data labels , go to more data labels and tick the category name , just click on that segment and drag it out .

thats it , got anymore questions ??

 

[Gergawy]

Im doing oct-nov ict paper 2 2007, there's surprisingly a question about vlookup, im doing the right thing but it's not working for all the records... its question 49.... any help??

its just a sorting matter , sort everything from A to Z (Ascending Order)

ok a very confusing thing, when do we use vlookup and when normal lookup?

vlookup for the vertical columns and the normal one for the horizontal, thats why it has in the beginning the letter V cuz that v stands for vertical lookup

 

[Gergawy]

how to make the background image to fot to browser and how to remove tiling

read this

I finally solved it .
Steps to solve the annoying image repeat
1) Go to the selected stylesheet and then go to body
2) After the last semi-colon press space and type "background-repeat: no-repeat"
3) Then leave a space and close the bracket and thats it !!!
Dont waste time on cropping and snipping
Hope i helped View attachment 7028

thanks so much to that guy , he solved a big problem , got out of mind to search for internet and google that , thank you so much again

 

[IGCSE STUDENT]

vlookup for the vertical columns and the normal one for the horizontal, thats why it has in the beginning the letter V cuz that v stands for vertical lookup

but normal lookup works well for vertical data too, and sometimes we have to use that and not vlookup (in case of vertical data)

 

[aniekan]

ok to be quick ... u double click on table up u go to borders from the arrow choose the last one which is borders and shading ... u open the borders tab which appears in the pop up box . by clicking on the borders remove only the ones outside & then change the line to 3pt then reclick on the outside borders i hope that u got this here's a pic of something similar rlly srry for the bad explaination

thanks a bunch

 

[Mohsin41]

yes ! done with ict final paper

 

[Mohsin41]

varient 21 and 31

 

[Mahmood]

may/june 2011 p32 step 20 please

 

[burhan_111]

please help me oct/nov 2008 paper 4 in this paper in step 40 ..

 

[Sarah.]

I have problems with nested IF functions in excel :/