CMAP 120 INTEGRATIVE FINAL PROJECT

CMAP 120 INTEGRATIVE FINAL PROJECT

In this exercise you will use Word, Excel, and PowerPoint together in the same project. CHOOSE ONE OF THE TWO PROJECTS below to practice using these applications. (100 points total, 1-5pts./error)

1. Search online to find five jobs with the same or similar job titles. Apply to FIVE different companies for a specific job title (e.g., Administrative Assistant, Program Manager, etc.) by following the instructions below:

A. Write a letter explaining why you are qualified for the job title you are applying for. Use the Business Letter Block Format. Do not download letter templates from these websites. Create and write your own letter and format your letter to look like one of the pictures . (See the attached sample letter). Write ONE letter to submit with five different job applications.

· Insert today’s date (to update automatically) in the appropriate place in the letter (see the samples).

· Be sure to insert your address (the sender) and leave space for the receiver’s address and greeting in the correction location.

· Save the file as JobsLetter_YourLastName .

B. Use the letter you wrote in part A to create a mail merge letter that uses all records in the Job Applications database ( use Mailings tab, Start Mail Merge, Mail Merge Wizard ). Include these mail merge categories in your letter; address block and greeting line. This picture shows the task pane where you can insert the “ Address block” and “ Greeting line” mail merge fields. Be sure to use one of the business letter formats above. When previewing your letter, be sure to correct punctuation, spacing, and spelling. Merge the document and name the file with the five merged letters as JobLetter_Merged_YourLastName .

C. Create an Excel spreadsheet that lists information for FIVE companies that have advertised the type of job you are looking for. The spreadsheet should list the following information for each company: Company Name, Address1, and Address2 (P.O. Box if any), City, State, Zip, Phone, and the first and last name of a Contact Person (you can make up names if you can’t find them). Set up the Excel spreadsheet so all data will print on one sheet. Save the Excel workbook as JobApplications_YourLastName .

· Bold and center align all column headings.

· Left align all data.

· Use a consistent font style and size for all data.

· Do not merge any cells.

· Sort the company names in ascending order.

· Spell check and use periods when abbreviating. Washington, DC should have a comma.

· States should be formatted with two capital letters (e.g., MD).

D. Create a PPT presentation with 7 slides that shows information about each of the five companies you have applied to. Use transitions on all slides, at least 2 animations, at least 2 different PPT tools (tables, charts, SmartArt, etc.), and a graphic on each slide .

· Slide 1 - Introduce the presentation topic and credit yourself as the creator.

· Slides 2 thru 6 - Provide information about the five companies you have applied to.

· Slide 7 - End the presentation

E. Import the Excel spreadsheet into Access to create a database with one table. The Access table must have a primary key field. Use the name of the Excel file as the Access table name. Save the database as Companies_YourLastName .

F. Submit the original letter (with the Address and Greeting mail merge prompts), merged letter , the Excel spreadsheet , the PPT presentation , and the Access database ( 20 pts. each ). UPLOAD ALL FILES AT THE SAME TIME .

-----------------------------------------------------------------OR--------------------------------------------------------

2. Search online to find FIVE colleges or universities that have the bachelor’s degree program you want to major in. (I understand there are many programs that have articulation agreements with Montgomery College for transfer—this is just an exercise.)

A. Write a letter explaining why you should be admitted to the colleges you selected. Use the Business Letter Block Format. Do not download letter templates from these websites. Create and write your own letter and format your letter to look like one of the pictures . (See the attached sample letter). Write ONE letter to submit with five different college applications.

· Insert today’s date (to update automatically) in the appropriate place in the letter (see the samples).

· Be sure to insert your address (the sender) and leave space for the receiver’s address and greeting in the correction location.

· Save the letter file as CollegeLetter_YourLastName.

B. Use the letter you wrote in part A to create a mail merge letter that uses all records in the Job Applications database ( use Mailings tab, Start Mail Merge, Mail Merge Wizard ). This picture shows the task pane where you can insert the “ Address block” and “ Greeting line” mail merge fields.

Be sure to use one of the business letter formats above.

Include these mail merge categories in your letter; address block and greeting line. When previewing your letter, be sure to correct punctuation, spacing, and spelling. Name the file with the five merged letters as CollegeApplications_Merged_YourLastName . The mail merge lesson is in Word Module 3 Class notes (near the bottom).

C. Create an Excel spreadsheet that lists information for the FIVE colleges that you plan to apply to. The spreadsheet should list the following information for each college: College Name, Address1, Address2 (P.O. Box if any), City, State, Zip, Phone, and the first and last name of a Contact Person (you can make up contact names if you can’t find them). Set up the Excel spreadsheet so all data will print on one sheet. Save the Excel workbook as CollegeApplications_YourLastName.

· Bold and center align all column headings.

· Left align all data.

· Use a consistent font style and size for all data.

· Do not merge any cells.

· Sort the college names in ascending order.

· Spell check and use periods when abbreviating. Washington, DC should have a comma.

· States should be formatted with two capital letters (e.g., MD).

D. Create a PPT presentation with 7 slides that shows information about each of the five colleges you plan to apply to. Use transitions on all slides, at least 2 animations, at least 2 different PPT tools (tables, charts, SmartArt, etc.), and a graphic on each slide .

· Slide 1 - Introduce the presentation topic and credit yourself as the creator.

· Slides 2 thru 6 - Provide information about the five colleges you have applied to.

· Slide 7 - End the presentation

E. Import the Excel spreadsheet into Access to create a database with one table. The Access table must have a primary key field. Use the name of the Excel file as the Access table name. Save the database as Colleges_YourLastName .

F. Submit the original letter (with the Address and Greeting mail merge prompts), merged letter , the Excel spreadsheet , the PPT presentation , and the Access database ( 20 pts. each ). UPLOAD ALL FILES AT THE SAME TIME .

Page 1 of 2