IT quesrtion

[SGVaibhav]

I will be writing them down in points.

MICROSOFT WORD

(NOVEMBER 2004 PAPER 3)
DOUBT 1-
In question 41, they tell us
Place page breaks, if necessary, to ensure that:
• there are no widows
• there are no orphans.
What are orphans and widows, and how do i do this question?

(NOVEMBER 2004 PAPER 3)
DOUBT 2-
In the first part, they tell us to put the date in the right side of the header, when the page orientation is landscape.
Now in integration, they tell to change this orientation to portrait, and when i do that, the date goes somewhere else.
while in the mark scheme, it still remains on the right, so DO I CHANGE IT OR LEAVE IT LIKE THAT? (im not shouting, just writing in caps to make it noticeable)

(JUNE 2008 PAPER 2)
DOUBT3-
Q10, they tell us to put the header and footer.
and in the markscheme, they check the position with exact millimeter.
How do we put the header in exact center, or right or in left alignment?

MICROSOFT EXCEL

(NOVEMBER 2004 PAPER 2)
DOUBT4-
In the first part of spreadsheet, they tell us to print the spreadsheet, but they do not tell us to put our name.
And they have not shown the presence of name in the mark scheme also.
But our teacher told that we have to put our name in whatever we print. Or else the paper will be torn and thrown in the dustbin.
     -So do we print our name?
     -If we do so where (header, footer etc.....)

MICROSOFT ACCESS

(NOVEMBER 2004 PAPER 3)
DOUBT5-
When they tell us to put our name in the footer, where do we put report footer or page footer?
here is the exact question.

Q23Produce a report which:has your name on the right in the footer.
and they have shown this in the markscheme
Name bottom right of report
Does not have to be at bottom of the page

      -So what do i use, report footer or page footer?
      -When to use report footer and when to use page footer?
My teacher told they are very particular about this.
I cannot ask my teacher now, because we have holidays and go to school directly on the day of exam.


U all over here are professionals.
Please help to solve my 5 SHOCKING ICT DOUBTS

[SGVaibhav]

IT professionals, please reply me quicker

[sanity_master]

kk

M.W::

DOUBT 1-:
 im not sure about the definitions but the way of doing it is easy...actually sometimes u dont do anything....just make sure that there is no single line from a paragraph on a separate page.....atleast 2 lines......in fact this Q nowadays will tell u : no table split on 2 pages, no bulleted list on 2 pages...etc.
SOOO, dont leave a line on its own, or split a table or a bulleted list on 2 pages, I.E : let everything be together

DOUBT 2-:
 well, wtever happenes when u change the settings of anything. make sure that the final result is as they asked u, if they said to the right, then to the right, adjust it if u have to.

DOUBT 3-:
 no no no, they dont measure it EXACT, it just needs to look center or right or left...they dont measure it UNLESS they ask u for a certain distance which (i think) didnt and wont happen.

M.E::

DOUBT 4-:
 ur teacher is absolutely right, u have to put ur name on every page u r going to submit or else it will be history .....and ur name is always in the header unless u r asked for another position.

M.A::

DOUBT 5-:
 well my teacher said :" if the report is more than one page, put ur name in the page footer and leave the page number....if its one page, then remove the grey line at the bottom along with the date and number of pages....and ur name will be in the report footer"

Hope i was useful 

[SGVaibhav]

DOUBT 2-:
 well, wtever happenes when u change the settings of anything. make sure that the final result is as they asked u, if they said to the right, then to the right, adjust it if u have to.

DOUBT3-:
 no no no, they dont measure it EXACT, it just needs to look center or right or left...they dont measure it UNLESS they ask u for a certain distance which (i think) didnt and wont happen.

DOUBT5-:
 well my teacher said :" if the report is more than one page, put ur name in the page footer and leave the page number....if its one page, then remove the grey line at the bottom along with the date and number of pages....and ur name will be in the report footer"

Hope i was useful 

doubt 2

the final result was for the printout before, and this problems happens after that (in integration)

doubt 3
they measure it exact, even though no distance is mentioned the question paper

doubt 5 was confusing

u were useful

[sanity_master]

on doubt 2 i guess it would be better if u wait for another one to answer it for u...i said wt i know

and about doubt 3...i never ever got graded for the header or wt is in it....u just center it, or make it on the right or left from the tool bar....but i dont know about measuring it....i never saw that happening

about doubt 5....if one page>>> name in report footer
                       if more than one page>> in page footer

[SGVaibhav]

waiting for other replies!

[SGVaibhav]

do we have to make a new email address for ict practicals?
we never ever practiced this part in school
omg.

[Petal]

No you don't HAVE to make a new address.
But its good to.

Because if you have too many unread mail, the email that CIE sends you may get lost in the pile of unread mail.
Also its quicker to load you inbox if there are only a few emails.

So just make one cos it makes life easier.
Make one in Hotmail, Google or Yahoo. Do something that you are familiar with.

[sanity_master]

he is right....and it will also be better if u got different e-mails on different websites......as yahoo, hotmail and gmail.

for me i got 3 on hotmail and one on yahoo......and they were all useful during the exam....

cuz maybe on website might crash or something.....so to be on the safe side make like 2 e-mails, on yahoo and hotmail 

[unknown]

hey as far yr doubt 5 i guess d name n al tht stuff is always in page footer as my teacher says only calculating part is in report footer
n ya By the way wht is tht >>1 n <<1 mean
i stil didnt understand
n ya 1 more doubt regarding style shhet like d one of 2008 oct hey i hv made d stylesheet bt after tht it says u r suppose to print it
so i shld directly print or copy paste in wrd write my candidate no n all tht stuff n then print plzzzz help requirement is urgent n ya 1 more help see in frontpage fr a dark colour d code is smthgg 66 bt wht is fr a light colour give an example plzz like if i want light green or light blue

plzzz do help
hm waiting
i m running out of time....

[SGVaibhav]

october/november 2007 paper 2.
Q17) HOW TO MAKE only 1 column in 1 page and the rest of the column has two pages?\

[sweetsh]

You do i it when you enter a page break...put *next page* break in the break type

[SGVaibhav]

 

i recently solved one paper.
according to word, all measurements are corret, margins and columns and everyhitng set perfectly in cm
when i meaure everyhing is messed up.
i lost 10 marks in my correctoin.

 
is there any way out.

[same]

This is a paper 3 edit and an additional thing by evilzurg and ig boy!!

First of all, here are the files that are gonna be used in the external (paper 2 & 3):
http://www.box.net/shared/lpgljp1d1y

This will also help u in excel, http://www.box.net/shared/i3tf91jst0  (thanks to adeel)
This will help in Paper 2, http://www.box.net/shared/xth6rcdgvm    (thanks to shoaib)
-----------------------------------------------------------------------------------------------------
Download the first file, unzip it and open J9style1.css

In front page, they will ask you to:
let the Red and blue components in h1 h2 h3 h4 h5 remain the same, but ensure that there are no green components (The 3rd and 4th numbers in the codes become zero)
so:
h1           { color: #00AAAA; font-family: Arial, sans-serif; font-size: 20pt; text-align: center }
it will become
h1           { color: #0000AA; font-family: Arial, sans-serif; font-size: 20pt; text-align: center }
do this for h1 to h5

Now in the paragraph style, ensure that there is no red component and blue and green component is set to 50%
so:
p            { color: #00CCFF; font-family: "Times New Roman", serif; font-size: 12pt; text-align: left }
you change it to:
p            { color: rgb(0%, 50%, 50%); font-family: "Times New Roman", serif; font-size: 12pt; text-align: left }
-----------------------------------------------------------------------------------------------------
In power point, you have to:
Indent a bullet list by (how much they tell you, for example 2 cm)

To indent, you must highlight the bullet points you want to indent and go to format then go to placeholder. Press the textbox and write 2 cm internal margin from the left.
-----------------------------------------------------------------------------------------------------
In excel, open J9sheet.csv
The formulas used are:
Sum If
Count If
Value Lookup (from J9code.csv)
Calculate the Minutes & Hours by /60 and *60

so..

Webpage:
=VLOOKUP(B2,J9code.csv!$A$2:$B$12,2,0)

Total:
=SUMIF($B$11:$B$84,B2,$C$11:$C$84)

Hours:
=INT(C2/60)

Minutes:
either
=MOD(C2,60)
or
=C2-(D2*60)
-----------------------------------------------------------------------------------------------------
And they are going to ask for a pie chart (dont really know were exactly), but:

When making the pie chart:
You have to include the Percentage and Category Name
They will also ask you to slightly pull out the part with the most percentage from the rest of the pie chart:
1) Just press on the pie chart itself once
2) Then press on the largest part
3) Then Drag It
-----------------------------------------------------------------------------------------------------
Please someone can u give me paper 2... if u have it??

Enjoy! TNas11

thank u so much tnas11.
 

[unknown]

plzzzzzzz ans my q i m seriosly running out of time less than 20hrs 2 go