• We need your support!

    We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
    Click here to Donate Now (View Announcement)

ICT : Post your doubts here !

Status
Not open for further replies.
Messages
85
Reaction score
58
Points
28
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
 
Messages
234
Reaction score
81
Points
38
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
 
Messages
724
Reaction score
198
Points
53
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 :)
 
Messages
7
Reaction score
2
Points
11
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 :p :D
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 :p :D
 
Messages
1
Reaction score
0
Points
1
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??
 
Messages
724
Reaction score
198
Points
53
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 ??
 
Messages
724
Reaction score
198
Points
53
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
 
Messages
724
Reaction score
198
Points
53
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 (y)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 :)
 
Messages
17
Reaction score
3
Points
3
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)
 
Messages
948
Reaction score
1,010
Points
153
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
 
Status
Not open for further replies.
Top