Use the text in the file ‘Project 1 – raw’ and format it according to Kate Turabian.
The footnotes need to be formatted according to Kate (you can find info on the references at the end of the paper) and positioned where the relative boldface numbers are positioned in the paper.
You need to E-mail me this formatted document with the subject: Project1
Use the xls file ‘Mission Trip – raw’ for this exercise.
Make sure cells C2:G12, B16:B19, & B22: B25 are formatted as currency (dollar and cents).
Filling out cells B22:B25
Meals on the road: Budget so that you will have $5.00 + 7% tax per meal. You have 11 people going on the mission trip, and you will be eating 2 meals.
Free Day Meal: Budget a max of $15.00 per person for 11 people.
Entertainment: Budget a max of $15.00 per person for 11 people.
T-Shirts: Budget $12.00 per shirt for 11 people.Filling out cells G2:G12
The trip costs $250.00 per person, plus an even distribution of the above expenses.
HINT: you can take the SUM of the above cells and divide it by 11 people and add it to $250.00.Filling out cells F2:F12
WARNING: These are probably the hardest cells to fill.
Fill these cells using relative and absolute reference.
The youth only get money if they have participated in the fund raiser (see worksheet Participation for that information).
Here is how you calculate how much money they get from a specific fundraisers:=Amount Raised(CELL that corresponds to them/total number participating)
If they participated in the fundraiser the CELL that corresponds to them will equal 1 and thus they will get money for the activity. If they did not participate in the fundraiser the CELL that corresponds to them will equal 0 and thus they will get no money for the activity.
HINT: you can use the SUM function to calculate how many people actually participated in the event.
Filling out cells E2:E12
This will be calculated using:
Finally you need to sort the youth by last name. Be careful when you do this !!!
You need to E-mail me this formatted document with the subject: Project2
Part I - Make a MS PowerPoint presentation of your choice:
Church Service
Use an order of service from your church, or an order of service that you made up.
Have announcement slides, song slides, in-between slides, slides for prayer, and preaching slides.
At least one of your song slides has to have a graphic background (the more the better).
At least one announcement slide needs to have a custom animation.
At least one announcement slide needs to have a slide transition.
At least one preaching slide needs to have bullets that come in one at a time.
Presentation
Pick a topic of your choice, and make a 5 min presentation on it (this can be a class lecture, a ministry presentation, a trip presentation, etc.).
You need an intro/title slide.
At least one slide needs to have a custom animation.
At least one slide needs to have a slide transition.
At least one slide needs to have some image on it (when appropriate – the more the better).
Part II: Present the presentation during Finals Week.
Church Service
You need to explain your decisions of what choices were made as you go through our service.
We will pick a song that John will lead us in and you will run the PP show while the song is sung.
Presentation
You need to present whatever topic you picked.
Be ready in the question and answer time to answer questions on why you did what you did when it comes to power point.
Generate a simple website: You can use any method you want (Frontpage, Ulead, or Raw HTML).
The site needs to have:
At least 3 pages that link to each other.
At least one internal link in one of the pages.
At least 3 links to outside sides.
Some graphics on every page.
