Final+Exam+2011

__**Computer Applications Final Exam 2011**__
 * This is a skills test**. You may use the book and any document in your **Google Docs**. Do not ask for assistance unless you are having problems with your computer. Everything you need to know is in the textbook. Get as far as you can in the 75 minutes you have. If something is taking too long, skip it and come back to it at the end. You get credit for each of the three Parts, get as far as you can.

__ Research Skills __
You will need the following information about your selection: The easiest way to do the research is to type in the college name and what you are looking for. Use Tabs to get to the information quickly (copy and paste it into your Final Exam Prep document or just leave the window open - **don't close it**)
 * This final exam** is based on the concept of **college readiness**. You are to use Google Chrome and research a **college or university** of your choice.
 * College/university Name
 * Address
 * Admissions Contact Person
 * Tuition & Fees
 * Room & Board
 * **Example**: Alaska University tuition and fees

__ Application Skills __
In** Google Docs**, Create a **Collection/Folder** in the **DIT** folder, **Title**: ** __Final Exam__ **
 * The Final Exam is composed of three activities:**

The section is an example introductory letter that you could mail to a college or university that you are interested in.
 * // __PART I__ //**


 * Create a ** Block Letter **
 * Create New **Document** in** Google Docs** ** Final Exam Folder - Title**: ** __Final Exam Doc__ **
 * **Insert** Header (use your home or school address, any address you know, and make it **Bold**)
 * Remember **Block Format** is on **page WD-3 **, ** do not copy the text **, just the **format**(date, address, dear..., closing)
 * Your first paragraph will describe who you are:
 * 1) School
 * 2) Grade
 * 3) City/state
 * 4) Interest - things you like to see or school subjects that you like
 * 5) Hobbies - activities you like to do, sports or collections
 * 6) Family life - people in your home or life, chores you do at home, jobs or activities around the house or community
 * Your second paragraph will state why you chose that college/university-
 * 1) What you like about it
 * 2) What you want to study
 * 3) Request additional information
 * 4) Request an application for the school
 * Close the letter- DIT high school student

This section is a self-introduction that can be used to visually explain who you are to college representatives visiting the high school.
 * // __PART II__ //**


 * Create a ** Power Point **
 * Create New **Presentation** in** Google Docs**** Final Exam Folder - Title**: ** __Final Exam PP__ **
 * Use the information in the **block letter** to create a **5 slide**presentation
 * 1) **Slide 1** - Your name and the address you selected
 * 2) **Slide 2** - Where you live, grade level, and high school
 * 3) **Slide 3** - What things you like, your interests
 * 4) **Slide 4** - What you like to do, your hobbies
 * 5) **Slide 5** - One or two things about the college or university you selected
 * You need **three**images (interests, hobbies, college selected, picture of you, the school, etc. any three images)
 * 1) **Research Skills:** Do an image search to find your pictures. Save them as **JPEG**s to the ** My Documents ** Folder
 * 2) **Insert** images from the computer into the Google Docs Presentation (**Browse** the ** My Documents **Folder)
 * If you are having **problems** with the **images** ** PLEASE ASK ME FOR ASSISTANCE **

This section is designed to give you an idea of how much money is needed in the first year of college/university life.
 * // __PART III__ //**

>>
 * Create ** Excel Budget **
 * Create New **Spreadsheet** in** Google Docs**** Final Exam Folder - Title**: ** __Final Exam EX__ **
 * The Spreadsheet should have:
 * Two columns (Headings = Expense and Costs or Amount)
 * Nine Rows - row 1 is the headings, row 2-8 are the items above, and row 9 is the **Total**
 * The **Total** row should have a formula that adds up the Costs/Amount column to show how much money is spent in one year of college
 * Use the information from the college/university website in the **Research Skills** section with additional research to create the spreadsheet
 * **Research Skills:**You will need to search for the following information
 * (__** Hint **__ - **type the word __ college __** in front of each word to get the __**cost**__/monetary amount; **example** - __college__ transportation __costs__):
 * 1) Tuition & Fees
 * 2) Room & Board
 * 3) Transportation
 * 4) Clothes
 * 5) Books & Supplies
 * 6) Snacks (think about how much you spend a day on snacks, multiply by 150 days)
 * 7) Cell Phone (if you have a monthly bill, multiply that by 10)
 * (Note: if they give you the price in terms of months, multiply the costs by 10 months; use an Excel formula to do the math)


 * CONGRATULATIONS... YOU MADE IT!**