paper 2guide

8/3/2019 Paper 2Guide

1/25

Q3 Prepare an e-mail message:to be sent to [email protected] copied to [email protected] with a blind carbon copy to [email protected] with the subject line ICTCOREX

The body text of the message should include:

your name your centre number your candidate number the text: Here is the requested file.

Q3 Before you send the email, you must print it out with the

following details.

To print this email :

End of Task A Tutorial


2/25

TASK B DOCUMENT PRODUCTION

Q6 Open the .rtf file and save it as .doc

Q9 Check to make sure your computers measurement unit is in centimeters.

Q9 Change the margins in page setup; note that the left and right margins are now 2cm.

Q10 Type your name, centre number and candidate number together.

Q10 Move the center tab to the middle of the page

Q10 Place the cursor after your name and press tab, it should go straight to the center.

Q10 Now use the tab key to place the candidate number to the right of the header.


3/25

Q10 Use the right indent to make sure that the candidate number is exactly on the right.

Q11 On the menu bar select format columns.

Q11 Change the columns to three, the spacing to 4mm and select apply to as whole document.

Q12 Set the text to a serif font.

Q13 Set the text to 1.5 line spacing.

Q14Q15

Make the text fully justified.

Set the text size to 10 point

Select all the text press (ctrl+A)

If he needs a

line between

the columns

Check it


4/25

Q16 Insert a page break before the first paragraph.

Q17

Change a serif font.

Change a 10 point

Click Here

to ustified

1.5(line spacing)

Format ONLY the first page of the document as a single column.

Q18to26

Go to the beginning of the page break and press enter to make a new line, then type the details

asked in the question. The font used in the mark scheme is Arial Black, so when you have

finished it should look similar to the image below.


5/25

Q27 Copy the paragraph.

Q27 Paste it after the first paragraph.


6/25

Q28. Select bullets and numbering, and using the numbered tab select the roman numeral bullets.

Q29

Copy the style sheet excerpt and paste it into notepad (not Microsoft word), then use FrontPage

style sheets (if you know how)

Q33 Highlight the column with packaging and right-click on it to insert a column.

Q33 Type the new details in the empty column.

6


7/25

You must add a pound sign at the beginning of the numbers. You can copy and paste the sign

from the other columns or use

insert symbol as shown below.

Q33.

Highlight the row with size 2, right-click and select delete rows.

Q34

Q34. Now do the same for the other row which has size 2.

7


8/25

Q35 Highlight the first paragraph, keep your finger pressed on the CTRL key on the keyboard andhighlight the rest of the paragraphs. Select format - paragraph from the file menu and under

indentation Special, select First line: and make By: 2cm. It should look like the image below.

Check that ALL paragraphs have changed.

Q37 Insert the image of a tree as normal, 2click on the image select Square and Left.

8


9/25

Q37 Make the image cover the whole column and arrange it so that it looks like the picture in c).

End of Task B Tutorial

9


10/25

TASK C DATA MANIPULATION

Q39. Create a blank database

Chose New from objects Table and Import Table Search forSites. CSV

10


11/25

Choose Delimited Choose Comma Select First row contains field names Select In a new table

11


12/25

Click the Advancedbutton in the next step seen below

You should leave the field name Owned as it is shown above

Make the Data type: Yes/No

ClickOK and then NEXT

On the next screen:

Choose No primary key

12


13/25

ClickNEXT FINISH - OK

Right-click the Sites table and select Design view

Q39 ContinuedClick the Data type where it has Owned

Make sure you are in the GENERAL tab and select FORMATOn the right select the Yes/No option (see below)

13


14/25

ClickSAVE VIEW DATASHEET VIEW

You should now have a table with the OWNED column showing YES and NO values

Q40 Go back to the design view and take a screen-shot, as shown below.

14


15/25

Q41 Now enter the three records

When you have finished, close the Table and run the Query Wizard

Q43 After you finish the Query Wizard make a new column and add the following details;Under the CODE column add the Criteria as OC

Under the CODE column add the Or as AS

Then make a new column with the following details;Field: Growth: [Potential Area]-[Current Area]

Table: SITES

Sort: Do the ascending in the report

Show: Place a TICK

Now untick the columns Reference and Owned

Check it in the Design View and then produce the Report how you normally would using the Report

Wizard.

Note: Make sure that 0 is located at the top of the Growth column and the report title is Far East Sites,with your name on the right of the Footer

15


16/25

16


17/25

Note: The finished report should look like the screen-shot below

Sherif adel,eg901,1234

Q45 The next steps show the second query result and the report wizard

17


18/25

Note: The finished report should look like the screen-shot below

18


19/25

Q47 Create a new query using the wizard and follow the screen-shots belowa) Only use the two field names Code and Potential Area

Sherif adel,eg901,1234

b) Click next and select Summary & click the Summary Optionsbutton. Click Next

19


20/25

c) Place a tick in Sum and a tick in Count records in sites, then clickOK

d) Name the query as in question 47, then clickFINISHbecause there is no need to change anything

in the design view.

e) The query should look like the screen-shot below

Q48 Save this data in a form which can be imported into a text document.

20


21/25

Export this data into a form that can be opened by your graph/charting package.

End of Task C Tutorial

21


22/25

TASK D INTERGRATION

Q50 a) Open the .csv file which you saved from question 48.

Q51.

a) Open the file Regions.csv,

b) It should look similar to the picture below

Now insert a new column before column B and give it the field name Region Names

d) Now use the lookup function to find out what each code stands for, for example AF = Africa.

Dont forget to drag down the region names.

Q52 a) Highlight the columns which hold the Region Names and Count of sites, then select the charticon. Click Next twice to go to step 3 of 4 in the chart wizard.

22


23/25

Q53 In step number 3, type the chart title Number of potential sites in each region.

Q54 a)Label the Category (x) axis as Region and label the Value (y) axis as Number of sites.

b) Click on the Legend tab and un-tickShow legend.

23


24/25

c) Click Next and finally click Finish

Q54 d) When you click Finish your chart should look similar to the screen-shot below.

24


25/25

Q55. You can simply save the new spreadsheet and then copy the chart only and follow the

instructions on question 56.

Q56. Copy the chart and paste it where you are asked to in question 56.

Q57. There are a number of spelling errors in the document, but ignore the English/American

spelling/grammar differences.

End of Task D Tutorial

paper 2guide

Documents