Julian Hudson

Julian Hudson photo

Julian Hudson

BA Honours, B.ED
Computer Science Grades 10,11,12 Data, Web Design Grade 10
Phone: 667-8210 ext. 7201
Julian Hudson Email
Julian Hudson Webpage

Web Design and Excel Data

Term 3 Web and Data

A test is planned for next Wednesday, May 25 Day 6.

Web Design

1. Create a Navigation bar with 2 buttons tiled vertically in the left frame.
2. Set up the Nav bar to open files in the main frame.
3. Create buttons in Fireworks – 2 versions of each button.
4. Create page1.html that simply says Page 1 and page2.html that simply says Page 2.

 Create the following javascript in Notepad but save it as yourname.html not as .txt
<html>
<head> 
<script type="text/javascript">
function show_prompt()
{
var comment=prompt("Please enter your comment","Harry Potter");
}
</script>
</head>
<body>
<input type="button" value="Show prompt box" /> 
</body>
</html>

Excel
1. Create names for vlookup advanced filter : criteria, database, extract.
2. Set up simple vlookup.Eg =VLOOKUP(A2,teachers,2,FALSE)
3. Do advanced filtering but just on one row. – not using “OR”.

That's it.

Link to : My GuestBook

Web Design December 2010 : Term 2

As we start Term 2 we will be leaving our work on the Florida Parks web site.
1. The students will be creating a web site for a realty company. They will be advertising 3 houses.
          a) They will be drawing these houses themselves in a program called Sketchup.
 
          b) This is a free program that allows the user to draw some very beautiful and complex structures.
  c) These drawings are done in a 3 dimensional environment. 
  d) The houses that my students have created are awesome.
2. The students will be creating a web site about a topic of interest to them personally. 
a) They will receive marks for creativity, design and correct techniques as taught in class.
3. We will then return to our Florida sites and teach them the basics of sharing information 
between the user of a web site and those who run the web site.
 
There will be no testing before Christmas.

October 2010 :

We are working our way through our textbook. The entire text takes us step
by step through the process of building a complete web site. In this case
it is creating a tourist web site for those wishing to visit Florida.

There are also some supplementary sites to help practice the concepts
given in each chapter.

We have created 3 pages of this web site so far. 

September 2010
To start our study of Web design, we will introduce the students to 
a program called "Dreamweaver". We will start with the basics and 
by the end of the year, the students will be able to create some 
fairly sophisticated web sites on their own.

 Some of the things that will be covered are:
1. hyperlinks
2. use of graphics, animations, videos and sound
3. the use of frames (dividing up a page into sections where one part stays the same and others may be changed.
4. the use of mouse roll-overs.
5. how to use tables to arrange content
6. how to use colour - backgrounds, fonts etc

Data (Excel)

Term 2

The students are now doing work on Chapter 3 of our text book.
1. The concepts are starting to get a bit more difficult and complex.
2. Different types of formating will be covered - rotation of text, changing colour only under certain conditions etc.
3. The use of Absolute References / Relative Values will be explained and used.
4. Using "if" statements from the basic to the complex will be taught.
There will be no testing before Christmas.

October 2010.

We are just completing the first unit of study in our chosen text book.
 The main concepts here are:
1. Using the Sum() function.
2. Using Borders.
3. Formatting text and numbers.
4. Using the AutoFormat function to improve appearance.
5. Creating charts. 

September 2010
In Data we introduce the students to the Microsoft program called "Excel".
We will learn how to create simple to advanced spreadsheetsSome of the
things we will be covering are:
1. Doing simple mathematical calculations.
2. Later more advanced calculations using "if" statements.
3. Formatting : simple changing of colours and styles.
4. Formatting advanced "conditional formats".
5. Techniques to quickly search and find requested data. 

Julian Hudson

Last Updated: Tue, 17 May 2011

Home → Teachers → Julian Hudson → Web Design and Excel Data
Homepage | Teacher Pages