ICS Computer Applications

Website Project

2008-05-20T13:14:00.002+08:00

Due date: Tuesday, May 27, 2008

Template:
You need to start with a file called template.html. This file will be what you use to create all the other pages. Your template will be due on Wednesday, May 21.
As you create your template be sure to follow all of the requirements for the website.

Requirements:
At least 6 pages
Each page must have a uniform heading and menu (if I select one of your pages, the top and left should not change at all!)
The heading needs to include at least one picture
Pages must have a nice background (doesn't have to be an image, a simple color is ok, but NOT white!)
Your 6 pages must include:

Home page, (index.html)
Links page
At least 3 others!

You must include links to:

Class website
At least 2 of your classmates' pages

One of these is your neighbor on your left

At least 4 other sites that you enjoy

You need to include pictures, each page should have at least one picture, not including the heading picture.

Optional items:
Using images as part of your links on your links page
Creating buttons to use for your menu

html assignment #1

2008-05-08T19:15:00.000+08:00

Our next projects will deal with creating a webpage. We will be doing this in a couple of different ways. We will start by learning to use html. I have included a link to a tutorial. We will be looking at a few specific pieces of information off of them, and you will be able to use them to help you when it comes to actually creating your site.

Dave's html code guide we will use this site quite a bit as it is the one I have used before and know.

You will be allowed to use any of these sites (or any you find by searching) to research different pieces of information, but Dave's code guide will be the one that I will be speaking from and making quizzes from.

OK, now that you know what we are doing, go to Dave's site and read down to the link:
Okay! Let me Learn HTML!
Select that link and read through the first two pages, complete the following questions for your assignment.

On a blank sheet of paper answer these questions be ready to hand them in by the end of the period. (You are writing these out because I don't want you to just copy and paste, I want it in your own words.) Use full sentences (or paragraphs) for your answers!

What does html stand for?
What is the most important html file?
Explain the two copy rule.
What does "c:\" mean?
What is a URL?
What is a Host?
What is a Domain?
What is an ISP?
How do the host, domain, and ISP work together in order for you to have a website?
What is Data Transfer Bandwidth?

All of these items are discussed in the first two pages of Dave's Tutorial. We will also talk about them at the end of the period or the beginning of our next class.

Research Presentation

2008-02-20T11:11:00.000+08:00

You need to create a five-minute presentation on a topic of your choice. The topic MUST pertain to an academic subject:

Math
History
Bible
Science
English
Art
etc.

The title of your presentation should be a question that you are researching. (i.e.

"How Many Primes Are Less Than a Given Number?"
"What Brought About the Napoleanic Wars?"
"Why Does Water Expand When It Freezes?"
"Who Was the Catalyst For the Creation of the Computer?"
"When Did the Ming Dynasty Rule?"
"Where Did Noah's Ark Come to Rest?"

Be sure that your question is broad enough that it will take five-minutes to answer, but not so broad that you can't cover the entire question.

As you are creating these presentations make sure that you are using proper research techniques. Keep a list of sources. Be sure to check the sources to make sure that they are reliable. Don't use the Internet as your only source, check out the library. If you are dealing with a scientific topic and want to do an experiment, be sure to include the pertinent data and some pictures.

For the actual presentation, remember the different things we have discussed about a good presentation:

Continuity between the slides
Brief Overview to start
Proper amount of information on each slide
Good contrasting colors between text and background
Pictures and animations that add to the presentation, not detract from it
Bibliography
Spellchecking

This assignment will be due on Friday the 29th of February. We will present starting on Monday the 3rd.

Each of you will be assigned a partner that you will assist you with your the presentation; they will run the slides for you and will be your aide for proofreading and helping you to fix issues that you may have. Be sure to take time to practice with them! You will be graded on your own presentation, and also on the presentation of your partner. (80% of your grade will be from your presentation and 20% will be from your partner's presentation.)

Here are your partners:

Jasmine & Ryugi Stevi & John
Nathan & Anders Zach & Esther
David & Erik Josh & DaEun
Greg & Queenie Abednego & Hope

You should be sitting with your partner each day so that you can be discussing any questions as you go.

Powerpoint Lesson

2008-02-14T08:13:00.001+08:00

You should have your presentation assignment complete at this point. Please save the file to the 'V:\Classes\ComputerApps\Assignments\Presentations' folder in this format: Name - me.ppt

Hopefully I will be back tomorrow so you can give your presentations.

Once you have done this, go to this page and work through the lessons on powerpoint. Expect a quiz on these topics on Friday or Monday.

If you get to the final lesson, the file it asks you to use is in the folder V:\Classes\ComputerApps\Powerpoint sounds\.

Have fun!

Newsletter Project

2008-01-23T12:15:00.000+08:00

You need to write a newsletter about yourself. In your newsletter I want to learn about you. Please include information regarding:

Biography of you
Your religious background and testimony
Family background
My Home

Article about your home country

Where you've lived
Funny story about yourself

I also need to see your ability to follow directions and to format neatly. You need to include:

A full-width Headline that includes your name (either in the headline itself or as a subline as the author)
Two pages of articles
Two or Three columns
At least five separate articles

Each article needs to have a bolded title, then text that is full-justified.
You should also work to keep articles together, Whenever possible an article should not start at the middle of a column and continue to the next column.

Two or more pictures, including a picture of your family.
Font size for the body of the articles should be between 10 and 14 pts
Be sure to run spell-check and have someone else proofread for grammar and spelling mistakes.

Some ideas for other articles:

Joke section
Puzzle or riddles

Can include the answer as a footnote that is upside down.

Quick facts

Text box with a list of quick facts about yourself

This will be due at the end of class on Friday 1st February.

2008-01-14T10:28:00.000+08:00

Computer Applications

2007-2008

Mr. Whittaker

I. Course Description

In this course students will be learning a variety of applications for computers. Students will also learn some of the basic workings of computers.

II. Course Goals

A. To give students a basic overview of the uses of computers.

B. To give students a strong ability to work in Office programs.

C. To introduce webpage design.

D. To introduce programming.

III. Course Outline

A. First Quarter

Computer Science & Hardware
Microsoft Office
Microsoft Excel
Microsoft Powerpoint

B. Second Quarter

The Internet
Webpages & html
Basic Programming

IV. Class Website This one!

V. Grading Criteria

Projects – 50%
Quizzes – 30%
Participation – 10%
Final Exam – 10%

Finalize Mail Merge Files

2007-11-27T19:34:00.000+08:00

You need to finish off your mail merge documents:

You should have these three files in the MailMerge folder, they need to also be named in this way. I will simply delete any file that is not in this form. You will not be receiving credit if the name is not correct!

name-DataSheet.xls
name-LetterMaster.doc
name-LetterMerged.doc

You also need to open up the files and make sure they are connected to the proper datasheet. The best way to make sure that the file is set up properly is to have a friend try to open the file. If they can't connect to the data, then you need to connect it to your own datasheet that is in the public folder.

Once you have completed this, move on to the html assignment listed below.

Mail Merge Data

2007-11-17T09:42:00.000+08:00

One of the more powerful uses of Excel is the Mail Merge. We are able to take data from a spreadsheet and create personalized copies of a form letter.

To work with the mail merge data you need to create a new spreadsheet that contains the names and addresses of 25 people.

Your data should contain the following columns:

Last Name
Hand Phone
House/Block Number
First Name
Work Number
Phone Number
Street
Postal Code
City
Country
Percentage
Letter Grade
Tuition Owed

Place the columns in an order that makes sense!

Use the same names as you did for the gradebook, we will be including some values from the gradebook spreadsheet.

For the different numerical data columns you should create a random function to get the values.

We will look at a way to connect the Percentage and Letter Grade columns to the gradebook sheet you have created already.

Excel Project #3 - Gradebook

2007-11-05T12:17:00.001+08:00

You need to create a workbook to track the grades in your class. Your gradebook needs to include:

A large merged cell with your name and the subject.
The names of at least twenty students listed down the left columns.

Name should be in three columns:

Last
First
Full

Each student should have a four-digit id#.

Twenty-five assignments that pertain to the class.

For each assignment you need to give the points possible.

Your assignments should have different values, some values may be used multiple times, but not for all assignments.

You also need to calculate the average score for each assignment.

A summary section to the right of the individual grades that includes summary information for each student:

Total points
Percentage
Letter Grade

On a separate worksheet you will need to list your grading scale for letter grades (ABCDF).

Nicely formatted data that makes the spreadsheet easy to read. This should include cell borders and background color changes.
You need to use conditional formatting to highlight high scores and low scores.
You need to format your assignment names so that they are turned 90 degrees.

In class we will be working on formulas that:

Take a list of names that is in full name format and separate it into two columns
Take two columns of names and combine it for a full name
Create a random id-number
Create random grades in the proper range
Look up the letter grade

I will also take some time to work on more advanced conditional formatting and other issues we come across while working on this assignment.

Word Macro

2007-08-29T12:42:00.000+08:00

Create a macro named OldEnglish that will replace the word "the" with the word "thee" everywhere it appears in the document.

Assign the macro to the key combination ctrl+8.

Be sure you test the program on different paragraphs and documents to make sure that it works properly. When you are done, go to the Visual Basic editor and copy the code into your document. Then save the document as:

assignments\macro\OldEnglish-[Whi, Danny].doc (replace with your name)

Microsoft Word

2007-08-21T14:48:00.000+08:00

Today we will be discussing some of the basic features of Word. I'm going into the discussion assuming you already know how to work with many of these topics. Here are some of the things we will be discussing:

Toolbars and Menus
Bulleted lists
Borders
Headers and Footers
Margins
Columns
AutoCorrect

ASCII Assignment

2007-08-16T12:14:00.000+08:00

You must have a message consisting of at least 50 characters (spaces and punctuation are characters too!) This should be all digits: 1001110001010101010010101001101001100101010101010101011110101010010101000001101010010101101001010101010

No spaces or enters should be used in creating your message.

Send your message to my email account with a subject of "ASCII message". If you don't have email, you may post a comment to this and include your message that way.

Evaluating Internet Sources

2006-08-28T10:52:00.000+08:00

You should have turned in your assignments last Friday. Please check the folder to make sure your file is in the folder and properly named. I moved all files that were improperly named into a separate folder. Please make sure that you have exactly two files:
newsletter- Last, First.doc
list- Last, First.doc
If you have to rename a file, please do not leave the improper name!

Once you have taken care of that, please go to this website and read the document about evaluating internet sources.

http://www.virtualsalt.com/evalu8it.htm

We will discuss this in class.

Word Projects

2006-08-22T13:24:00.000+08:00

You will be working on two projects in Word for the next couple of days. These projects will cover the things you know about Word. Each document needs to be saved in the class folder using the file name I give.

Document 1: Newsletter
Create a newsletter. Your newsletter should be about your family. You should have articles discussing your family, your home country, your reason for being in Singapore, and a story of something funny that has happened to you. You could also include other articles or sections. (For example, a puzzle or riddle; a quiz on Singapore culture; etc.) This document needs to include each of the following:

A full page width heading
Three columns of articles
At least three images or clip-art
At least four separate stories/articles
Evidence that you have run spell checker!
Footnotes - give some words in your home language, or some Singlish slang that you need to define for your readers, put this definition in footnotes at the bottom of the page. You could also have a footnote with the answer to a puzzle, riddle, or (if you include one)

Save as: newsletter-[name].doc

Document 2: List
Create an informational sheet about an upcoming trip. Pretend that you are the organizer of this trip. The document you create is to inform them of the things they will need for the trip, as well as when they need to meet, and where they need to report. This document should be a full-size sheet giving a list of items needed for a trip. Include:

A Title
Basic description of the trip
A bulleted list of the items each traveler will need
Information about when and where each traveler needs to report.

Save as: list-[name].doc

Files and Grades

2005-11-15T14:03:00.000+08:00

I am working on updating grades for all projects. You need to make sure that you have turned in each of these files:

Excel\Bowling\bowling.xls
Excel\Savings\name-savings.xls
Excel\Savings\name.doc
MailMerge\name-datasheet.xls
MailMerge\LetterMerged.doc
MailMerge\LetterMaster.doc
MailMerge\EnvelopeMerged.doc
MailMerge\EnvelopeMaster.doc
(the last five may be saved in the "graded" folder)
html\name-tables.html
html\name.html

If you don't have the files in these folders, then you need to put them in! You are getting zeros for that project now!

2005-11-14T09:05:00.000+08:00

Therefore let us stop passing judgment on one another. Instead, make up your mind not to put any stumbling block or obstacle in your brother's way.

Romans 14:13

We will be finishing our discussion of tags today and tomorrow will begin our website assignment.

Your first webpage

2005-11-07T13:02:00.000+08:00

You need to create a webpage that shows the things you have learned so far in these first seven chapters. Make sure that you put into practice the things learned in each chapter. You may choose any topic you like, but need to use tags from each of the chapters. Be sure to include:

A list
A title
A change to the font size
Horizontal lines
An image
A link
CLEAN CODE
A background color or image
Some alignment changes

Create the file using the tester on Dave's Site, then copy it into a text document and save it into the class folder named "html" save it as [name].html

2005-10-17T09:04:00.000+08:00

The righteous cry out, and the LORD hears them; he delivers them from all their troubles.

Psalm 34:17

You need to finish the bowling score sheet. Once you have the numbers, you need to make sure it has a nice formatted look to it.

Once you have completed the formatting, you need to add a column to the totals table. At the end of the season any player that has bowled a 270 game, or has an average score of 230 is invited to an individual tournament. Add a column that displays a "Yes" or "No" telling whether the player is invited to the tournament. As with all things in Excel, it needs to be a formula, not just you figuring it out.

2005-10-13T19:21:00.000+08:00

Turn from evil and do good; seek peace and pursue it.

Psalm 34:14

You need to start today by finishing your worksheet from yesterday. Once you have finished it, save it into the Excel folder with your first name as the file name. Also, save your Excel sheet as [your name]" - savings".

After saving these files, you need to begin working on the Bowling data sheet listed below.

2005-10-13T19:07:00.000+08:00

Bowling Stat Sheet

You need to create a spreadsheet that gives the scores for the four members of a bowling team.

The team plays four games each week.

You should have scores listed for each game in a 4 week tournament (a total of 16 games apiece).

For each week you need to give a total score for each player as well as a total score for each game for the team. You also need to give the average, maximum, and minimum for each player each week.

At the bottom you need to give the total, average, maximum, and minimum for each player. These final stats should be given for total weekly scores, and also for individual games.

Be sure to include formatting to make the tables easier to read.

I will be giving an example of one of the weeks.

Week 1

	Game 1	Game 2	Game 3	Game 4	Total	Average	Minimum	Maximum
Francis	156	89	6	75	326	81.5	6	156
Jeremiah	149	264	123	184	720	180	123	264
Ezekiel	216	299	245	206	1046	241.5	206	299
Jude	31	78	102	122	333	83.25	31	122
Total	552	730	476	587	2345	586.25	476	730

2005-10-11T07:09:00.000+08:00

Quarter Grades, Click for larger view

2005-10-05T08:19:00.000+08:00

I sought the LORD, and he answered me; he delivered me from all my fears.

Psalm 34:4

You need to get out your grading sheet from the presentations. You also need to open up Excel. We will be working on data entry. In Excel, set up a worksheet with student names (just first names, as written on the sheet I gave you) in column A and category names in Row 6. the Student names should be in alphabetical order by first name (be sure to include your name, even though you did not grade your own), and category names should also be in alphabetical order. BUT put the Extra Features column LAST.

In cell F2 put your full name. Merge cells A1:G1 and title it "Stand-Alone Presentation Grades".

Rename the worksheet with your first name (as is on the list).

After all the setup is done, go ahead and enter the grades you have collected.
If you gave any points in "Extra Features" add comments to the cell to explain what you gave the points for. Also, if you have any other comments to add, do so.

Add a total & an average row at the bottom, and a total and average column at the right.

Once this is done, wait for further instructions.

2005-10-04T12:20:00.000+08:00

Glorify the LORD with me; let us exalt his name together.

Psalm 34:3

You need to work at your computer to finish grading the stand-alone presentations. You can simply open them up from your computer and view them that way. Once you are done, you need to hold onto your grading sheet. We will be using it to input data into Excel for our first Excel lesson tomorrow.

2005-09-29T12:34:00.000+08:00

My soul will boast in the LORD; let the afflicted hear and rejoice.

Psalm 34:2

Make sure your name is on your title page so that as people come around to look at the presentation, they know whose it is!

You need to start today by saving your presentation into the class folder:
"V:\Classes\ComputerApps\StandAlone\" give it the name:
[name] topic.ppt

Be sure to replace [name] with your first name!

Once these are all saved, you will need to start your presentation on your own computer. After you get your presentation going, you need to move to someone else's computer and work through it. While doing this, you need to fill out the sheet (I'll give this to you) to critique the presentations. Once you finish with a presentation, restart it, and move to the next one.

You will need to work through everyone's presentation!

2005-09-23T06:56:00.000+08:00

Therefore, I urge you, brothers, in view of God's mercy, to offer your bodies as living sacrifices, holy and pleasing to God -- this is your spiritual act of worship. Do not conform any longer to the pattern of this world, but be transformed by the renewing of your mind. Then you will be able to test and approve what God's will is -- his good, pleasing and perfect will.

Romans 12:1-2

You need to complete your presentation diagram today. This can be done on the computer and printed, or simply drawn on paper. Make it neatly though!