In the excell enviroment we can use arithmetic operations/numeric functions to
perform calculations
they include addition, subtraction, multiplication,division, sum, average, maximum,
minimum, count
This done by enetering Formulaes
Use the following data and use the formulaes to make a reporst
John Assingment 1 40/50 Assingment 2 16/20 T0TAL (Calulate/100)
Peter Assingment 1 30/50 Assingment 2 8/20 T0TAL (Calulate/100)
Mary Assingment 1 25/50 Assingment 2 10/20 T0TAL (Calulate/100)
Jane Assingment 1 45/50 Assingment 2 18/20 T0TAL (Calulate/100)
Average (Calculate) (Calculate) (Calculate)
Maximum (Calculate) (Calculate) (Calculate)
Minimum (Calculate) (Calculate) (Calculate)
Determine the class average score for Assigment1, Assignment2 and the Total
Identify the highest and the lowest score in each task.(Hint use =MAX(cell1, cell2...) and =MIN(cell1, cell2...)
Send you attached spreadsheeet to gioko@akam.ac.ke
Lesson in Progress
MYPCT Y7 CLASS
Sunday, January 25, 2009
Computer Networks-Security
We have been looking at computer networks.
Today we shall look at the following
-identify the need for encryption
-authentication techniques including the use of
-User identification
-passwords
when using common network environments such as the Internet.
Answer the following questions
-What is encryption?
-Why do we need it?
-What is authentification?
-How does it use useridentification and password as security measure?
Save the file as Computernetworks-Security(Your Name)
Send your responces to gioko@akam.ac.ke
Today we shall look at the following
-identify the need for encryption
-authentication techniques including the use of
-User identification
-passwords
when using common network environments such as the Internet.
Answer the following questions
-What is encryption?
-Why do we need it?
-What is authentification?
-How does it use useridentification and password as security measure?
Save the file as Computernetworks-Security(Your Name)
Send your responces to gioko@akam.ac.ke
Linking Web weather Data to a PIS
Last lesson we learnt about linking data from a web site to our Public Information system.
We used Webquerry and linked data to our PIS which we saved in excell and called it
Importing Web Data.
We imported the file blackpoll and formated the worksheet.
Today we are going to do the following
-Open the excell File.
-import the other likn i gave on santiego, California.
Karan and Keshni may help others with URL
Link it to the same excell file but in a different worksheet names PIS2
Save the file
-Check if the data in the blackpool worsheet has changed.
-Write your comments.
-Go to web query and click update.
-Check if the data has changed.
-Write our comments
-Repeat for the PIS2 worksheet.
-Discuss the advantages of linking a PIS with a website.
Send the comments and the discusion in a word file named ImportingWEBdata
Your assingment will be marked under criteria A Investigation.
Send it to gioko@akam.ac.ke
We used Webquerry and linked data to our PIS which we saved in excell and called it
Importing Web Data.
We imported the file blackpoll and formated the worksheet.
Today we are going to do the following
-Open the excell File.
-import the other likn i gave on santiego, California.
Karan and Keshni may help others with URL
Link it to the same excell file but in a different worksheet names PIS2
Save the file
-Check if the data in the blackpool worsheet has changed.
-Write your comments.
-Go to web query and click update.
-Check if the data has changed.
-Write our comments
-Repeat for the PIS2 worksheet.
-Discuss the advantages of linking a PIS with a website.
Send the comments and the discusion in a word file named ImportingWEBdata
Your assingment will be marked under criteria A Investigation.
Send it to gioko@akam.ac.ke
Friday, January 9, 2009
MYP CT Public information systems
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
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
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
Subscribe to:
Posts (Atom)