Session one
You will be provided with worksheet 8.1.2 and worksheet 8.1.3.
Complete the worksheet individually.
Hand over the paper to the teachers
Session 2 exercise
Importing Data from a Web site.
Open the website
www.firsthydro.co.uk/weather/current/llanberisdata.asp
Copy the data into Excel worksheet
Format the data.
Send the formatted data to gioko.akam.ac.ke
Lesson in Progress
MYPCT Y7 CLASS
Friday, January 9, 2009
Monday, January 5, 2009
EXERCISE 15
1. Open the document you saved in the Exercise 11.
2. Replace the text:
These customers need to be contacted for information concerning their password violations:
with this text:
Please telephone these users who made log-in errors in weeks 35 and 36. Here is a list of their names and numbers:
3. Indent this paragraph by 1.5 cm from the left margin of the text.
4. Replace the list of users in the table you placed in the document production section with the list of Users for weeks 35 and 36 showing names
and telephone extensions that you saved in the Data Manipulation section.
5. Insert at the end of the document the report you generated in the Data Manipulation section entitled User Error Log
6. Repaginate the document if necessary.
Save and Print the document.
7. Send a message to your tutor with the following subject:
IT Security Report
The message text should be:
Here is the report as requested.
Attach a copy of your report to the e-mail message and send it.
8. Print a copy of the e-mail showing transaction details (Recipient, subject, text, date, attached file).
2. Replace the text:
These customers need to be contacted for information concerning their password violations:
with this text:
Please telephone these users who made log-in errors in weeks 35 and 36. Here is a list of their names and numbers:
3. Indent this paragraph by 1.5 cm from the left margin of the text.
4. Replace the list of users in the table you placed in the document production section with the list of Users for weeks 35 and 36 showing names
and telephone extensions that you saved in the Data Manipulation section.
5. Insert at the end of the document the report you generated in the Data Manipulation section entitled User Error Log
6. Repaginate the document if necessary.
Save and Print the document.
7. Send a message to your tutor with the following subject:
IT Security Report
The message text should be:
Here is the report as requested.
Attach a copy of your report to the e-mail message and send it.
8. Print a copy of the e-mail showing transaction details (Recipient, subject, text, date, attached file).
EXERCISE 11
Task 1
Download a new document with about 2 pages of text (preferably about hardware and software. Save this as DocProd.txt.
Questions below:
1. Open the file DOCPROD.TXT 3.1.1
2. Set the page size to A4 and the orientation to portrait. 4.1.1
4.1.2
3. Set the top and left margins to 2.5cms 4.1.4
4. Make the right and left margins fully justified. 4.1.6
5. Insert page numbers at the foot of the page. These should start at number one and be printed from the first page. The
page numbers should be aligned to the right.
4.1.3
6. The font size should be set at 14 point.
7. Set line spacing to 1.5
8. Key in the following text at the end of the document
Password Violations
Companies use on-going security procedures to check customers logging on to the system.
If a customer makes more than the permitted number of attempts to gain access to the system, then use of that
id is suspended.
The customer is contacted for an explanation.
These customers need to be contacted for information concerning their password violations:
3.2.1
9. Make these three points only listed under Password Violations bulleted style
Companies use on-going security procedures to check customers logging on to the system.
If a customer makes more than the permitted number of attempts to gain access to the system, then use of that id is
suspended.
The customer is contacted for an explanation.
5.2.1
10. Place the file VIOLATE.CSV (you downloaded and saved in Exercise 6) in the document to follow the above text you
have just keyed in.
5.3.1
3.4.1
10.1.1
11. Insert a page break before the sentence:
These customers need to be contacted for information concerning their password violations:
if necessary to keep the sentence with the following table.
5.4.1
12. In the top right hand corner of the first page place the image USER.JPG
Resize the image to be 2cms wide and appropriately set to height with scale ratio preserved.
The image should be placed to the right of the title and should be above the body text.
No text should be lost or hidden by the image.
3.3.1
3.3.2
10.1.1
13. Save and print this version of the document. 11.1.1
Download a new document with about 2 pages of text (preferably about hardware and software. Save this as DocProd.txt.
Questions below:
1. Open the file DOCPROD.TXT 3.1.1
2. Set the page size to A4 and the orientation to portrait. 4.1.1
4.1.2
3. Set the top and left margins to 2.5cms 4.1.4
4. Make the right and left margins fully justified. 4.1.6
5. Insert page numbers at the foot of the page. These should start at number one and be printed from the first page. The
page numbers should be aligned to the right.
4.1.3
6. The font size should be set at 14 point.
7. Set line spacing to 1.5
8. Key in the following text at the end of the document
Password Violations
Companies use on-going security procedures to check customers logging on to the system.
If a customer makes more than the permitted number of attempts to gain access to the system, then use of that
id is suspended.
The customer is contacted for an explanation.
These customers need to be contacted for information concerning their password violations:
3.2.1
9. Make these three points only listed under Password Violations bulleted style
Companies use on-going security procedures to check customers logging on to the system.
If a customer makes more than the permitted number of attempts to gain access to the system, then use of that id is
suspended.
The customer is contacted for an explanation.
5.2.1
10. Place the file VIOLATE.CSV (you downloaded and saved in Exercise 6) in the document to follow the above text you
have just keyed in.
5.3.1
3.4.1
10.1.1
11. Insert a page break before the sentence:
These customers need to be contacted for information concerning their password violations:
if necessary to keep the sentence with the following table.
5.4.1
12. In the top right hand corner of the first page place the image USER.JPG
Resize the image to be 2cms wide and appropriately set to height with scale ratio preserved.
The image should be placed to the right of the title and should be above the body text.
No text should be lost or hidden by the image.
3.3.1
3.3.2
10.1.1
13. Save and print this version of the document. 11.1.1
EXERCISE 10
Open the word processor and prepare a new document. Add your name and the title Sales details for last week. Make this title centre aligned, bold
and italic
Create the following table in the document.
Monday Tuesday Wednesday Thursday Friday Saturday
Taipei Hong Kong Cairns Sydney Tokyo Honolulu
$12,000 $7,700 $0 $42,000 $17,000 $3,200
Lee Wong Jennings Richer Wu Schmidt
3 days 14 days 7 days 14 days 28 days
Make sure that row 1 is centre aligned, rows 2, 4 and 5 are left aligned and row 3 is right aligned.
Save and print your document.
Insert a new column before Monday which looks like this
Day
Location
Sales
Contact
Centre the text in this column and make it italic.
Delete the Sales row from the table. Save and print your document.
Time
and italic
Create the following table in the document.
Monday Tuesday Wednesday Thursday Friday Saturday
Taipei Hong Kong Cairns Sydney Tokyo Honolulu
$12,000 $7,700 $0 $42,000 $17,000 $3,200
Lee Wong Jennings Richer Wu Schmidt
3 days 14 days 7 days 14 days 28 days
Make sure that row 1 is centre aligned, rows 2, 4 and 5 are left aligned and row 3 is right aligned.
Save and print your document.
Insert a new column before Monday which looks like this
Day
Location
Sales
Contact
Centre the text in this column and make it italic.
Delete the Sales row from the table. Save and print your document.
Time
EXERCISE 9
Open the word processor and prepare a new document. Add your name and the title Towns and Cities. Make this title centred and 18 points high.
Ensure the font on the title is a sans-serif font. Using a 12 point Serif font enter a list of towns and cities, some local to you and others further away,
like this:
London
Sydney
Jakarta
When you have entered at least 10 entries, save your document.
Add bullet points to the list. Indent those towns and cities close to you by 2 centimetres. Indent those towns and cities further away by 5 centimetres.
Save and print your document.
Ensure the font on the title is a sans-serif font. Using a 12 point Serif font enter a list of towns and cities, some local to you and others further away,
like this:
London
Sydney
Jakarta
When you have entered at least 10 entries, save your document.
Add bullet points to the list. Indent those towns and cities close to you by 2 centimetres. Indent those towns and cities further away by 5 centimetres.
Save and print your document.
EXERCISE 8
Open the file that you saved in exercise 7 into the word processor.
Set the page size to A4
Set the orientation to portrait
Set the top and bottom margins to 3 centimetres and the left and right margins to 2 centimetres
Edit in the Header the text
Exercise 8 Word Processing
Make sure the Header has left (for Exercise 8) and right (for Word Processing) tabs and that the Header covers the full width of the page
Insert in the Footer the text
Page of
Make sure the Footer has left (for the page numbering), and right (for your name) tabs and that the Footer covers the full width of the page. The page
numbering should be automated and give the current page number and the total number of pages.
Set the page size to A4
Set the orientation to portrait
Set the top and bottom margins to 3 centimetres and the left and right margins to 2 centimetres
Edit in the Header the text
Exercise 8 Word Processing
Make sure the Header has left (for Exercise 8) and right (for Word Processing) tabs and that the Header covers the full width of the page
Insert in the Footer the text
Page
Make sure the Footer has left (for the page numbering), and right (for your name) tabs and that the Footer covers the full width of the page. The page
numbering should be automated and give the current page number and the total number of pages.
EXERCISE 7
Search for a previously prepared excerpt of text (which is 2 or 3 A4 pages in length) saved as a .TXT file,
Open the word processor and import the text.
Set the page size to A4
Set the orientation to landscape
Set the top and bottom margins to 2.5 centimetres and the left and right margins to 4centimetres
Insert in the Header the text
Exercise 7 Word Processing
Make sure the Header has left (for Exercise 7), centre (for Word Processing) and right (for your name) tabs and that the Header covers the full width
of the page
Insert in the Footer page numbering which should be centred on the page
Save and print your work
Open the word processor and import the text.
Set the page size to A4
Set the orientation to landscape
Set the top and bottom margins to 2.5 centimetres and the left and right margins to 4centimetres
Insert in the Header the text
Exercise 7 Word Processing
Make sure the Header has left (for Exercise 7), centre (for Word Processing) and right (for your name) tabs and that the Header covers the full width
of the page
Insert in the Footer page numbering which should be centred on the page
Save and print your work
Tuesday, November 25, 2008
IT EY10 Lesson
Today we are going to intergrate MSWord and Excel.
Design a report in MSWORD. The report should be for a newspaper reporting about the number of students we have in school which has total number of Boys 150 and girls 180in the following categories. Ages 10-11 Boys 45 Girls 30 Ages 12-16 Boys 50 Girls 60 and 17 and above Boys 65 Girls 90. Draw a graph in MS Excell and Copy it to the word Document.
Once the report is done send it to gioko@akam.ac.ke
with your name, class and time as the Footer.
Best Wishes
Design a report in MSWORD. The report should be for a newspaper reporting about the number of students we have in school which has total number of Boys 150 and girls 180in the following categories. Ages 10-11 Boys 45 Girls 30 Ages 12-16 Boys 50 Girls 60 and 17 and above Boys 65 Girls 90. Draw a graph in MS Excell and Copy it to the word Document.
Once the report is done send it to gioko@akam.ac.ke
with your name, class and time as the Footer.
Best Wishes
Tuesday, October 7, 2008
Downloading Information: Need for conversion between analogue and digital signal
IGCSE1 2008.
Today 8 October 2008 we are going to have the following learning opportunities:
Practically downloading a file save information as specified
Theoretically "describe the need for conversion between analogue and digital data"
Using the skill we leant last lesson use a search engine and look for information which describes the need for conversion between analogue and digital data.
Get from at least three sources the information about the need for conversion between analogue and digital data.
- Save the files found (minimum three) as HTML format
- Copy the necessary information from the files and paste them in MSWord. Remember to put the link at the end of the page.
- Print out the Word File with all the pasted data and the sources. Note to keep your Name, Class and Date as the header in your document.
Best of LUCK
Sunday, September 28, 2008
Today our Practical section will include.
Open up you mail and Write your name and class.
Send your mail to all members in your class including the teacher.
Reply to all mails you have got from your classmates and in the mail write.
I have received your mails thank you for sharing with me your name and class.
Take a screen dump of the sent mail
Take a screen damp of the received mail.
Paste them in the Word document.
Annotate them explaining
TO
CC
BCC
Subject
Subscribe to:
Posts (Atom)