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

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.

1. Save the files found (minimum three) as HTML format
   
2. Copy the necessary information from the files and paste them in MSWord. Remember to put the link at the end of the page.
   
3. 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

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

Microsoft Word Exercises

Microsoft Word Exercises
These exercises start from basics and are suitable for people with no previous word processing experience. Experienced users may be able to skim over the first few exercises but it is recommended that they be completed in order. I've found from teaching experience that people who skips steps invariably have to come back later to pick up what they missed. All of the following documents are in PDF format. The numbers in brackets indicate file size. Larger files may take a long time to open in slower internet connections.
About Word (148kb)
Getting Started With Word (773kb)
Text Editing (346kb)
Text Tools (498kb)
Character Formatting (228kb)
Paragraph Formatting (286kb)
Tabs & Lists (1.1Mb)
Tables (704kb)
Mail Merge (477kb)
Working with Objects (1.7Mb)
Styles and Contents (692kb)
WordFiles.exe - Exercise files (121kb) - This is a compressed archive which contains all of the files needed for the exercises. Download the archive, double-click on the downloaded file and then specify where you want the exercise files to be placed on your computer.
These exercises were created for users of Microsoft Word version 2003. They should be suitable for users of earlier versions though some minor differences may exist.

HTML exercises

HTML Exercises
These exercises start from basics and are suitable for people with no previous website design or programming experience. Experienced users may be able to skim over the first few exercises but it is recommended that they be completed in order. I've found from teaching experience that people who skips steps invariably have to come back later to pick up what they missed. All of the following documents are in PDF format. The numbers in brackets indicate file size. Larger files may take a long time to open in slower internet connections.
Contents & Intro (46kb)
HTML Info (99kb)
Site Planning & Design (50kb)
HTML Document Structure (207kb)
Links & Images (888kb)
Tables (286kb)
Frames (142kb)
Forms (122kb)
Formatting with Style (115kb)
Web Graphics (466kb)
HTML Tags Reference - General reference recommended for people who already know the basics of HTML (46kb)
Cascading Style Sheets Exercise - Exercise teaching more about CSS for people who are competent with general HTML (117kb)
Exercise_files_1-4.exe (138kb) & Exercise_files_5-8.exe (18kb) - For the main HTML exercises. CSS_Files.exe (81kb) - For the Cascading Style Sheets Exercise. These are compressed archives which contain all of the files needed for the exercises. Download the archive you need, double-click on the downloaded file and then specify where you want the exercise files to be placed on your computer.

Access Exercises

Microsoft Access Exercises
These exercises start from basics and are suitable for people with no previous database experience, though they are recommended for people who are competent with other Windows applications such as Word and Excel. Experienced users may be able to skim over the first few exercises but it is recommended that they be completed in order. I've found from teaching experience that people who skips steps invariably have to come back later to pick up what they missed. All of the following documents are in PDF format. The numbers in brackets indicate file size. Larger files may take a long time to open in slower internet connections.
Getting Started (903kb)
Queries (319kb)
Advanced Queries (282kb)
Forms Reports (744kb)
Relational Databases (738kb)
Relational Queries, Forms & Reports (1.4Mb)
Interfaces & Finishing Touches (1.3Mb)
Database Use - An overview of Databases for people who only need to know the basics (316kb)
AccessExerciseFiles.exe - Exercise files (2.2Mb) - This is a compressed archive which contains all of the files needed for the exercises. Download the archive, double-click on the downloaded file and then specify where you want the exercise files to be placed on your computer.
These exercises were created for users of Microsoft Access version 2002 (XP). They should be suitable for users of other versions though some minor differences may exist. Note that databases created in some versions of Access may not work in other versions of Access.
Click here if you prefer to download exercise files individually
It is recommended that the files below are saved to your own computer. Right-click the file you need and then choose the Save Target As option. You can then select a location to save the file to.
Music_Collection.mdb
Music_Collection_2.mdb
Music_Collection_3.mdb
cds.gif
music_database.ico




Access information & resources

Excel Exercises – Introduction or revision

Most of these exercises are short. They are intended to highlight basic aspects of the use of Excel; (almost) nothing very advanced. The page numbers referred to in the ISD booklets are the page numbers at the foot of each page and NOT the page in the pdf file version.

Use of Formulae and functions (see Part 1 p23-35 and Part 2 p13-16)

Remember (a) that formulae in Excel cells start with an =, (b) to use brackets correctly, (c) the difference between relative (e.g. C6) and absolute (e.g. $C$6) referencing of cells.

1. Open the spreadsheet dept-student-numbers.xls.
   

   In the ByDept sheet enter a formula in cell B9 to calculate the total number of students.
   

   In the ByYear sheet enter a formula in cell B6 to calculate the number of students in 1990.
   

   Copy this formula into the adjacent cells (C6 through to O6).
   

1. Open bonus.xls
   
   

   Enter a formula to calculate Cruise's total salary (Basic & Bonus). Copy this into the cells below.
   

   If this doesn't work well, use absolute referencing for the reference to cell B3.
   

1. Find out about the count (COUNT, COUNTA, COUNTBLANK and COUNTIF) functions. Use them to count the number of cells in the block A3:C12 which (a) contain numbers; (b) contain anything; (c) are blank; and (d) where the salary is greater than £200.
   

1. Return to the ByYear sheet in the dept-student-numbers.xls file.
   

   Calculate the average, minimum, maximum and median student numbers for yoga and Sanskrit respectively.
   

1. Use Tools>Options>View to view the formulae, then revert to the normal view.
   

1. If you have time try Task 6 Part 2, p 16 using the spreadsheet florist.xls.
   

Use of Names (Part 2, p 18)

1. Giving a cell or group of cells a name can simply formulae and make them easier to follow. Use the spreadsheet florist-names.xls, based on florist.xls, to do the calculations with named cells and ranges of cells.
   

Paste Special (Part 2 p21-22)

1. When we copy and paste data in Excel the cell value or formula and any associated formatting are copied and pasted along with the value. Sometimes we wish to copy the cell value only without the formula and formatting, or to copy formatting without the value. These steps are achieved with the Paste Special command. Copy the data in the ByYear sheet in the spreadsheet dept-student-numbers.xls and transpose it, starting at cell A11.
   

Lists (sorting and filtering) (Part 2 p2-7)

1. Open the spreadsheet club.xls.
   

Sort the list in ascending order on the field Name.

Now re-sort the list in descending order on field Place and then by field Name.

Apply a filter to list any club member who lives in Coombe Martin.

Add to this a filter to extract club members who live in Coombe Martin
and were born before 01/01/1966. How many are there?

Remove all filters.

Subtotals (Part 2 p8-9)

1. Use the club.xls spreadsheet and sort by Place, then calculate subtotals based on the Paid to Date and Total Due fields.
   

   Use the – signs to collapse the display so that only rows containing subtotals are shown.
   

   Remove all subtotals.
   

Logical IF function (Part 2 p10)

1. The IF function is used to check if a cell's value satisfies a given criterion. It returns the value TRUE if the criterion is met and FALSE if it is not. Furthermore you can specify what happens if the result is TRUE – another logical IF test perhaps – and similarly if it's FALSE. The format of the function is =IF(logical test, do this if true, do this if false).
   

   Open the student-marks.xls
   spreadsheet. Use IF(logical-test, do this if true, do this if false) to enter "pass" in column E for marks of 50 or greater, and "fail" for marks below 50.
   

Charts (Part 2 p36-53)

1. When the data you want to plot is divided into categories, (e.g. student numbers by department, fees by course type), then a bar chart or column chart is probably what you need. However if you want to plot numerical data against each other to analyse a relationship between them a XYplot is needed. It may be tempting to use a line chart but this would be wrong. A line chart assumes that the data on the x-axis is organised in regular steps or equal increments. This is rarely the case in experimental data.
   

Choose an appropriate chart type for the following data:

• Student numbers by department on the ByDept sheet of dept-student-numbers.xls.
  
• Monthly sales for 2002 and 2003 in the monthly-sales-2002-3.xls file.
  
• Infant height dependence on age from baby-heights.xls.
  

1. Add y error bars to the baby-heights chart (see Task 16, p.51)
   

• Amend the chart to show error bars fixed at 5.5 cm above and below each data point for the Girls data.
  
• Add 6.1cm error bars for the Boys data.
  
• Amend the chart to display height values between 40 cm and 100 cm, with major units of 10 cm, and minor units of 5 cm.
  

Compound Pendulum

This is a simple exercise to get you to produce a well labelled graph of the kind you will be expected to do for your laboratory reports.

Using the data given in the spreadsheet comp_pendtask.xls, produce an XY (scatter plot) using T²h (s² m) values for the y-axis and h² (m²) values for the x-axis.

Add error bars to the plot using the data in column B for errors in h² and column D for errors in T²h (s² m).

Show a trend line (line of best fit) on the graph and display its equation.

Label the axis including the units (Note you will need to insert superscripts into the axes' labels).

When completed the plot should be similar to that shown below.

Bloggers Task

So far we have manage to create a wiki and a blog. We have also managed to make blogs withing a blog and spaces within a wiki. Our task today is to make and intergrated activity. Use power point to make a story about yourself. Save the slides as photos. Use the blog picture presentation media to upload your story in the blog. Post a reflection on the experience in your blog.

Extra Task:
Try to leran about preset date for publishing your message. That is you might write a message today but it will be published next week.