Files and Grades

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!

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

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

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.

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.

Bowling Stat Sheet

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

Quarter Grades, Click for larger view

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.

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.

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!

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!

[Jesus said] "Whoever has my commands and obeys them, he is the one who loves me. He who loves me will be loved by my Father, and I too will love him and show myself to him."

John 14:21

I will return your flowcharts today with any comments on them. You need to continue working on your presentations. We will be grading and judging them on Thursday. This gives you 3 days to finish them up. It would be a good idea to be done by Wednesday so you can have people look at your presentation and give you advice on changes and spelling/grammar errors!

[Jesus said] "Whoever has my commands and obeys them, he is the one who loves me. He who loves me will be loved by my Father, and I too will love him and show myself to him."

John 14:21

You need to be working on the organizational chart for your presentation. Remember you will need to turn this in tomorrow! The project you are creating needs to include:

• at least 20 slides
• at least 3 levels of slides (outline, main heading, subheadings)
• lots of pictures, links on each page to return to the level above it as well as to move forward and backward
• a bibliography page which includes links to the webpages the information came from
• animations (don't overdo!)
• ZERO spelling or grammar errors
  
• other features to add interest (be creative)
• sounds or music (simple, not insane!)
• hidden links?
  

Not only so, but we ourselves, who have the firstfruits of the Spirit, groan inwardly as we wait eagerly for our adoption as sons, the redemption of our bodies.

Romans 8:23

This past couple weeks we've done presentations meant to work with a presenter. Today we will begin discussing stand-alone presentations. We will be building presentations that are meant to allow a user to navigate through them at their own pace and in their own order. You will need to include hyperlinks to other slides, and also to external sites. We will talk a little about what you need to be thinking about in doing this.

For where two or three come together in my name, there am I with them.

Matthew 18:20

We are presenting our Geography presentations today. You will probably not see this. If you do happen to look at it before class, make sure you have put the presentation file in our class folder.

We wait for the blessed hope--the glorious appearing of our great God and Savior, Jesus Christ, who gave himself for us to redeem us from all wickedness and to purify for himself a people that are his very own, eager to do what is good.

Titus 2:13-14

Your presentations need to be completed today so tomorrow you can work with a partner to give ideas for improvement.

For the grace of God that brings salvation has appeared to all men. It teaches us to say "No" to ungodliness and worldly passions, and to live self-controlled, upright and godly lives in this present age...

Titus 2:11-12

Continue working on your presentations. Plan to be finished by class time on Thursday so you can go through it with a friend to analyze it. Then Friday you can make changes and show it to someone else to improve it more. This way it will be perfect on Monday!

In the same way, count yourselves dead to sin but alive to God in Christ Jesus. Therefore do not let sin reign in your mortal body so that you obey its evil desires.

Romans 6:11-12

Today you need to continue working on the history presentation. Be sure to be planning out how you are going to present the information, talk to me if you are unsure about the best way to present information. Use friends to proof-read text. If you are unsure about the look, you can also look at the presentations I showed you on Thursday (they are saved in our class folder).

Power Point Presentations…

You will need to focus on the information found in the book Chapter 5

Your project must include

• Bolded Words-Define and show importance
• Answer and point out the sections key reading questions
• Section review questions-answer and point out significance
• Statistics…Today/current in addition to books information…and in many different areas of the world.
• Questions for students who are watching your presentation.
• Maps and graphs
• Opinions- How does studying this effect you?
• Reflection- What memories and experiences come to mind when you study this.
• How are you able to relate the Bible with the subject you are studying
• Bibliography-all works cited and/or used

Population Geography

• Geoffrey
• Mimi
• Sue
• Garrett

Cultural Geography

• Jiho
• Jason
• John Michael
• Caleb

World Languages and Religions

• Elise
• Kendal
• Jun Lim
• Saki

Grading

• Presentation-speaking ability, voice inflection, engagement of whole class…etc
• Power Point (Mr. Whittaker stuff)
• Organization
• Content

For the word of God is living and active. Sharper than any double-edged sword, it penetrates even to dividing soul and spirit, joints and marrow; it judges the thoughts and attitudes of the heart.

Hebrews 4:12

Today you begin work on your presentation for History class. I will give you some more clarification on what you are creating, and what Mr. Fleischmann and I expect.

For he satisfies the thirsty and fills the hungry with good things.

Psalm 107:9

We will be working in Powerpoint today.

He makes me lie down in green pastures, he leads me beside quiet waters, he restores my soul. He guides me in paths of righteousness for his name's sake.

Psalm 23:2-3

We are going to talk a little bit more about web searches. After I discuss ways to make a good search criteria, you will write a short research paper (2-3 paragraphs). Be sure that as you work on this paper you are finding credible sources, and listing your sources!

Your research paper should discuss the life of a major mathematician. Include each of the following:

• When he lived and died
  
• Where he lived
  
• Reason he is important
• What contribution did he make to mathematics?
• How are these contributions used now?
• What discoveries were built upon his contributions?
• Bibliography! Give the URLs where you found your information

Make sure that you use the CARS credibility model from the link yesterday. You should have at least three sources.

Save this in the mathematicians folder as mathematician-[name].doc

Your word is a lamp to my feet and a light for my path.

Psalm 119:105

Your projects should all already be in the class folder. Today we will, be discussing internet research and how to find good information.

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

For you make me glad by your deeds, O LORD; I sing for joy at the works of your hands.

Psalm 92:4

This is your last day to work on your projects, they need to be turned in to the class folder by the end of the period.

He who dwells in the shelter of the Most High will rest in the shadow of the Almighty.

Psalm 91:1

Well, keep working on those projects. You should finish your second project today.

Oh, and I fixed the pictures, so now, enjoy!

How did you do that?

Duh

Isn't this exciting!

Ok, what do I say?

See, do it this way.

Don't take my picture!

Hey, when did you take that?

What? I'm supposed to be facing my computer?

Do not envy a violent man or choose any of his ways, for the LORD detests a perverse man but takes the upright into his confidence.

Proverbs 3:31-32

Today you need to be working on finishing your three projects from yesterday. These will all be due at the end of class on Monday. This gives you one day to complete each project.

Oh, and enjoy the pictures!

[Jesus replied,] "Love the Lord your God with all your heart and with all your soul and with all your mind and with all your strength.' The second is this: `Love your neighbor as yourself.' There is no commandment greater than these."

Mark 12:30-31

You will be working on three projects in Word for the next couple of days. These projects will cover the thing 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 yourself. Include an article discussing your family, an article telling about your home country, and a story of something funny that has happened to you. This document needs to include each of the following:

1. A full page width heading
2. Two or three columns of articles
3. At least three images or clip-art
4. Use of styles
5. At least three separate stories/articles
6. Evidence that you have run spell checker!
   

Save as: newsletter-[name].doc

Document 2: Poster
Create a poster. This poster should be a Scripture verse. It can be your favorite verse, or a memory verse; be sure to include the reference for the verse. Your poster needs:

1. A full page border
2. Landscape page
3. Two or more images

Save as: poster-[name].doc

Document 3: 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:

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

Save as: list-[name].doc

A patient man has great understanding, but a quick-tempered man displays folly.

Proverbs 14:29

Today we will be working in Word. We will talk about some of the basic formatting features in Word and ways to make your document look uniform. We will also be looking at some websites that can help you to learn how to use Word better.

We will be looking at:

• Toolbars
• Shortcuts
• Styles
• Format Painter
• Macros

Here is a website I've found that has a lot of answer to different questions in Word:

http://wordtips.vitalnews.com/

And we know that in all things God works for the good of those who love him, who have been called according to his purpose.

Romans 8:28

Today we will be discussing the use of Windows. We are going to be learning lots of shortcut combinations and multiple ways of doing things. One of the things we will be working on is learning to use windows WITHOUT A MOUSE!

Let love and faithfulness never leave you; bind them around your neck, write them on the tablet of your heart. Then you will win favor and a good name in the sight of God and man.

Proverbs 3:3-4

A little more binary practice today. You will be creating a message in code. Your project is to write a message to me using ASCII codes. The message needs to contain at least two sentences. It must also be written with only 1s and 0s. Remember that each letter is 8 bits. We will talk a little bit more about the different letters and their codes. You may want to start by listing all of the letters with their binary coding. Here are the letters and symbols you may want to use as well as the decimal number that represents them:

space	32
!	33
,	44
.	46
0	48
1	49
2	50
3	51
4	52
5	53
6	54
7	55
8	56
9	57
A	65
B	66
C	67
D	68
E	69
F	70
G	71
H	72
I	73
J	74
K	75
L	76
M	77
N	78
O	79
P	80
Q	81
R	82
S	83
T	84
U	85
V	86
W	87
X	88
Y	89
Z	90
a	97
b	98
c	99
d	100
e	101
f	102
g	103
h	104
i	105
j	106
k	107
l	108
m	109
n	110
o	111
p	112
q	113
r	114
s	115
t	116
u	117
v	118
w	119
x	120
y	121
z	122

When you have finished your message, email it to me at: dwhittaker@ics.edu.sg The subject should be: "ASCII" Be sure to include your name! (This should be at the beginning of the email in normal letters.)

"If you hold to my teaching, you are really my disciples. Then you will know the truth, and the truth will set you free."

John 8:31-32

Today we are going to play a game called "Nim". It is a fairly simple game for two players. As we play we will be finding ways to guarantee a win. The game file is saved in our class folder. Before you play the computer, you should play against each other. You can just use paper. I will explain the game at the beginning of class.

Remember as you play that you are not just play for fun, but you are analyzing the game and trying to come up with a way to win EVERY time.

By the way, it does matter whether you go first or second. One of the players can force a win each time, but I won't tell you which one!

Better to be lowly in spirit and among the oppressed than to share plunder with the proud.

Proverbs 16:19

We are going to be discussing input and output again today.

I am sending him [Tychicus] to you for this very purpose, that you may know how we are, and that he may encourage you.

Ephesians 6:22

Today we will continue our discussion of how computers work. We will be focusing on the boot process.

Be thinking of questions you have about the boot-up process the computer goes through, as well as the things you already know about the process.

"My son, preserve sound judgment and discernment, do not let them out of your sight; ..."

Proverbs 3:21-22

This week we will be discussing the hardware of computers and how they work. You will need to take notes on this, you can either have paper to write on, or you can create a file on the computer.

Today we will be discussing the basic parts of computers: Hardware vs. Software.

Be thinking of the different types of hardware and software and be prepared to give descriptions of what they do.

You did not choose me, but I chose you and appointed you to go and bear fruit--fruit that will last. Then the Father will give you whatever you ask in my name.

John 15:16

Today you will be turning your projects in to me in our class folder: V:\Classes\ComputerApps\PreTest Projects Please save each file with the name as your first name, followed by the title. For example:

john - word.doc
john - excel.xls
john - powerpoint.xls
john - internet.doc

You can take a little more time to finish them up, but they need to be done at 1 o'clock.

Let your face shine on your servant; save me in your unfailing love.

Psalm 31:16

Go ahead and continue working on the projects you started yesterday. Remember that I expect these to be done by tomorrow.

Hands-On Activities

Hands-On Activities

You will now be creating some projects of your choosing in each of the given programs. In all cases your goal is to show your ability to use the program, and to show all of the aspects that you can. If you consider yourself to be an advanced user of the program, you need to prove it to me! When choosing what operations to use and how to show your use of them, be creative and use the highest level of functions that you know!

Microsoft Word

You are to create a one page document showing your ability to perform different formatting options on your document (font, alignment, etc.) In the text you should explain how to perform some of the higher functions and tools in Word, the things that can’t be directly shown (such as SpellChecker, etc.) Remember to use as many different tools as you know how! If you know Word very well, don’t bother wasting time on simple functions, as I see your knowledge of some of the higher functions, I will assume some of the other functions as well.

The actual text of your document is not really important. It can be telling about yourself or something you like, or just telling what it is you are doing in Microsoft Word.

Microsoft Excel

You are to create a spreadsheet. Your spreadsheet should show your ability to format a spreadsheet in an attractive design. It should also show your ability to use formulas and functions. If there is any doubt as to the use of a function, a comment would be a good plus. The spreadsheet doesn’t need to include a lot of information, but it should include as much as is necessary to show a wide variety of functions!

If you have never used Excel, you can skip this part.

Microsoft PowerPoint

You are to create a simple presentation. Your presentation should show the things you can do and give explanations of what powerpoint is used for and how to do some of the more important parts of design.

Internet

You will be researching two different topics. Using your research I want you to create a Word Document that displays the results of your research. Make sure you also include the websites that you use.

Topic 1: I really enjoy a sport called “Disc Golf.” You are to do some research for me. I want to find the nearest course to the country of Singapore. List the course, the country, and the distance from Singapore in miles and kilometers. I also want you to find the course that is the nearest to Acme, Washington. So, you are finding a total of 2 courses, and with each of them listing the country, and the distance from the given location.

On the same topic I want you to find the cost in Singapore dollars of purchasing a disc. So we have the same thing to compare, I want you to find the cost of an Innova Beast in Champion plastic. Find the cost of the actual disc, don’t worry about shipping. List the website, the cost in US dollars, and the cost in Singapore dollars.

Topic 2: I want you to find a page that lists the first 1,000,000 digits of the number pi.

We will be working on these tasks until Thursday of this week. All work needs to be completed by the end of class on Thursday! So, you cannot spend hours on these documents, be short and concise, but as extensive as possible. DO NOT USE THIS TIME TO TRY TO FIGURE OUT NEW THINGS TO INCLUDE, ONLY INCLUDE THINGS THAT YOU ALREADY KNOW!!

Welcome to Computer Applications

Greetings! This site will have a constant flow of information for you. Each day you should start by coming to this website to see what instructions I have left for you. Today we will be looking over the syllabus and discussing class procedures.

Tomorrow when you come in you can look here for your first assignment!

Class Procedures

1. Enter the class quietly
2. Turn on your computer
1. If you get here first, turn on your neighbor's computer as well
3. Log into your computer
1. Should be done before the tardy bell rings
4. Open Internet Explorer and come to this website for instructions for the day
5. At the end of the period
1. Log off your computer
2. Push in your chair
3. Clean up any garbage around your computer
   

Syllabus

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

1. Computer Science

2. Microsoft Office

3. Microsoft Excel

4. Microsoft Powerpoint

B. Second Quarter

1. The Internet

2. Webpages & html

3. Basic Programming

IV. Class Website http://ics-computerapplications.blogspot.com/

V. Grading Criteria

A. Projects – 50%

B. Quizzes – 30%

C. Participation – 10%

D. Final Exam – 10%

Computer Lab Rules

1. No food or drinks allowed.

2. You may not use disks from home without permission from the computer teacher.

3. Keep your hands on your own computer.

4. Computers are to be used for school related activities:

a. Research

b. Writing papers

c. Researching colleges

d. NO GAMES

e. NO EMAIL

f. NO IM

g. NO INSTALLING PROGRAMS

5. Speakers should be off at all times.

Mail Merge

For this project you will be creating a business with a mailing list.

The first thing we need to do is create mailing lists. We will be creating these in Excel. Your mailing list needs to contain these columns:

• Title
• First Name
• Last Name
• Street Address
• City
• Postal Code
• Balance
• Minimum Payment
• Due Date
• Interest Rate

You need to create these columns and fill them with data for 25 customers.

Tomorrow we will begin working with this data and creating form letters.

JASC tutorials

http://jpkabala.com/paranormal/tutindex.html
http://www.pluspsp.com/p/tips/
http://www.psphelp.com/index_v8.php
http://www.corel.com/servlet/Satellite?pagename=Corel3/Section/Display&sid=1047024315119&gid=1047024331836&cid=1047024353448#psp8

JASC tutorials

http://www.pinoy7.com/psptutorials/default.htm

Finalizing Web Page

Here are a few things to check as you finish your page:

1. Make sure you have looked at the requirements and filled each of them.
2. Click through each of your pages looking for changes. There should not be any changes in the top or on the menu from one change to another, the only changes should happen in the body.
3. Double check each link on each page to make sure the menu works.
4. Double check the links you have added to make sure that they go to the correct site.
5. Check the title on each page to make sure that it works, the titles should not be the same on every page.

Look back here often in case I add more!

Website Requirements

Due date: April 1, 2005

Requirements:
At least 5 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!)
Pages must have a nice background (doesn't have to be an image, a simple color is ok, but NOT white!)
Your 5 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
• At least 4 other sites that you enjoy

You need to include pictures, each page should have at least one picture.

Optional items:
Including an image as a part of your heading
Using images as part of your links on your links page
Creating buttons to use for your menu

Another html site

Webmonkey

Here is another site with great information, put together in a slightly better way for reference in html. It also includes information on CSS and other webpage methods.

Common Fonts

Common Fonts

html assignment #1

html assignment #1

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!

1. What does html stand for?
2. What is the most important html file?
3. Explain the two copy rule.
4. What does "c:\" mean?
5. What is a URL?
   
6. What is a Host?
7. What is a Domain?
8. What is an ISP?
9. How do the host, domain, and ISP work together in order for you to have a website?
10. 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 tomorrow.

Learning html !!!

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 links to a few different tutorials. 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.

w3schools

Writing html

Introduction to html

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 questions in the next post for your assignment.

PowerPoint Tutorial

PowerPoint Tutorial

Here are two different tutorials that can help you learn the different features of PowerPoint. The biggest key to learning is to try something! If you don't like what happened. . . ctrl+z!

PowerPoint Tutorial 1
PowerPoint Tutorial 2

Power Point Presentation

PowerPoint Project

Goal: Create a 15-20 slide presentation.

Topic: The presentation needs to be informative:

1. Tell how to do something.
2. Tell about a hobby you enjoy.
3. Describe an event in history.
4. Tell about your home country, state, or city.
5. Tell a Biblical story.
6. Be creative!

warning: topics are subject to rejection, so choose wisely! If you are concerned, ask early!

Requirements:

1. Presentations should be stand-alone (you shouldn’t have to do any talking)
2. Slides should work well together (use a template)
3. You need to use transitions and animations.
4. Transitions and animations should be smooth, and not detract from the presentation (don’t use the transitions that take 20 seconds to show the slide!)
5. The user should be able to progress through the show in order, or jump to specific slides (use hyperlinks)
6. The information you give needs to be accurate, be sure to list any references that you use. (Have a bibliography page with URLs of websites and names of books)

Grading:
Your presentation will be graded by your peers. We will spend a day or two displaying the presentations in the class. During that time, each of you will fill out an excel sheet critiquing each of the presentations. I will fill the sheet out as well.

Be sure to look at the second tutorial, "Tips" for some good guidelines about the display.

Here is the Grading sheet you will need to save it to your folder. Look at the comments to see what each category is asking for.

Due Date:
We will present our shows on March 3 and 4. You will need to be ready to go at the beginning of class on Thursday as I will select the order at random. You will not be able to work on the presentation during class on Thursday!

Grades Spreadsheet

OK, time for your Excel project!

You are going to produce a spreadsheet for calculating the final grades for a set of students.
The assignment needs to include:

• Your sheet should include 15 students listed with both first and last names in separate columns.
• You will also need to include at least ten different assignments.
• Each assignment will need to include a spot for the name of the assignment, and another cell to put the maximum score possible for that assignment.
• For each student you need to calculate the total points earned, and the final percentage.

I will be teaching how to do these later:

• We will also be working on having Excel incorporate the school's grading scale to give a letter grade for the assignment.
• Highlight low or missing grades.

This will be due on February 8, 2005.

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

Turning in Word Projects

Turn your files in with the following names:

Newsletter - [name].doc
Bullets - [name].doc
Poster - [name].doc

Replace [name] with your first name.

Place them in the folder:
"V:\Classes\Computer9\Word Projects"

These need to be turned in by the end of the period on Thursday, January, 20.

Word Projects

You are to make three documents, I have listed below what those documents need to be and given some examples as to what type of information they can hold.

	Documents	Examples
1	A one page document which includes the use of a bulleted list.	Compose a note inviting friends to a get-together at your house, including a list of things to bring with them. Write a report about a book listing five facts about the main character
2	A sign, or certificate in landscape orientation with a border around the document	Design a Garage Sale sign. Create a certificate to present to a favorite character in a book you have read. Make a sign outlining your rules for your bedroom at home.
3	A newsletter with a headline and 3 columns in portrait orientation, including at least one image	Design a newsletter which could be used to communicate with the class next door. Use a newsletter format to promote upcoming projects or events in your classroom or school.

These projects will be due at the end of class on Thursday, January 20.

Microsoft Word Tutorials

Here are a couple of pages that have some helpful hints about how to use certain parts of Word:

http://www.fgcu.edu/support/office2000/word/
http://www.internet4classrooms.com/on-line_word.htm

Welcome to Computers Class!!

OK, I want to welcome you to the class and lay down a few basics about the class.

Overview
We will be covering a wide range of topics in this class. Most of these topics will deal with different software programs and how to best make use of them. We will also spend some time studying Computer Science, and basic programming. We will have units that deal with Microsoft Office, Website Design, Programming, and Images, as well as other various computer details.

A large portion of the things we cover in the class will deal with the interests of each of you as students, but I will not limit my topics to what you want to learn!

Pre-Assessment
These next few days we will be used to find out some of the topics you already know, and little about some of the things you hope to learn. As you complete these assessments, don't worry about a grade for them. Simply do the best you can and show off as many skills as you know. If you don't know anything about a given program, that's OK, you'll learn as we go!

Once we finish with this part, you can read on to see what I'm expecting you to do over the next few days.

Daily Procedures
There are just a few things I expect from you so that we can learn as much as possible this term:

1. When the bell rings I expect you to be at your computer and logged in!
2. Your first task will be to visit this website to find the instructions for the day. Each day you should check here, even if you think you know what we are doing, as I may have changed my mind overnight, or I may have found some good information to help you.
3. Get to work on whatever task I have given!

Assignment Procedures
You will soon have access to the folder "V:\Classes\Computer9". All assignments will be turned in by placing them in a particular folder inside that directory. I will give specifics about each assignment as the time comes to turn it in.

Important note:
It is important that you keep a copy of each document in your own folder. You only place the file in the public folder when it is time to turn it in.

Grading Procedures
Most of the grades in this class deal with individual assignments and projects. We may have a couple of quizzes, but won't have exams. There will also be some grades dealing with participation in class and ability to keep on task.