ITCC200 Application Software Integration

 

ITCC200 Application Software Integration

American Public University System

 

ITCC200 Week 1 Assignment

Assignment Instructions

  • The scenario:

All That Glitter Jewelry is considering an expansion of the company website to sell more merchandise. Wanda Delana, US Sales Director, has asked you to complete the proposal. To complete this assignment you will need the following files:

Web_Sales_chart

Web_Sales_Proposal

You will save your files as:

Lastname_Firstname_ Web_Sales_Chart

Lastname_Firstname_Web_Sales_Proposal

    1. Open the provided file, Web_Sales_Chart file, and then save the Excel workbook as Lastname_Firstname_ Web_Sales_Chart. Complete the Excel worksheet
    2. Insert totals in row 10,
    3. Merge and center the titles
    4. Format data for aesthetics
    5. Create a 3-D clustered column chart to display the quarterly low end sales, expected sales, and high end sales on a separate sheet with an appropriate sheet name
    6. Modify the chart style and format appropriate chart elements
    7. Insert the file name in the footer and add appropriate document properties
    8. Open the provided file, Web_Sales_Proposal file, and then save the Word document as Lastname_Firstname_Web_Sales_Proposal
    9. In the Word document include the linked Excel data and chart
    10. Insert the your name in the footer

 

          

 

ITCC200 Week 3 Assignment

Assignment Instructions

  • The scenario:   

Success Gardens is planning to feature a garden club each week on its show and wants to invite garden clubs to apply. You have been asked to update the contact information for the clubs in a database, modify a form including the contact information, and then create individualized letters and envelopes using mail merge.

For this assignment, you will need the following files:

    New blank Word document

    Garden_Clubs

    Club_Information

    Contacts_Letter

You will save your files as:

    Lastname_Firstname_Garden_Clubs

    Lastname_Firstname_Club_Information

    Lastname_Firstname_Contacts_Letter

    Lastname_Firstname_Club_Letters

    Lastname_Firstname_Club_Envelopes

Part 1

  1. Open the Garden_Clubs database, and save it as Lastname_Firstname_Garden_Clubs
  2. Create a form based on the Garden Clubs table, and save the form as Lastname Firstname Clubs Form
  3. Enter the information below, using your First Name and Last Name for the last record.
  4. Update the Address Field for the Evergreen Gardeners to 4525 Center Ave
  5. Delete the record for Velvet Gloves.
  6. In the table, apply Best Fit to all columns.

Club Name

First Name

Last Name

Address

City

State

ZIP

Phone

E-mail Address

High Rise Garden Path

Curtis

Guilliard

3931 Wallace

Houston

Tx

77004

713-555-5771

Curtis@successmail.com

Harris County Green

First Name

Last Name

7847 Faith Ave

Houston

TX

77004

713-555-4774

Firstname@successmail.com

Part 2

  1. Export the table as an RTF file named Lastname_Firstname_Clubs_RTF
  2. Open the Club_Information file.
  3. Insert the RTF file
  4. Delete the Address, City, State, and ZIP fields.
  5. Format the information sheet to display as a one-page document
  6. Include a page color, page border, and theme.
  7. Save the document as Lastname_Firstname_Club_Information

Part 3

  1. Open the Contacts_Letter, and save it as Lastname_Firstname_Contacts_Letter
  2. Using mail merge, include appropriate merge fields from the Garden Clubs table in the database in the letter.
  3. Complete the merge, and then save the merged letters as Lastname_Firstname_Club_Letters
  4. Create envelopes to be used with the letters, using Success Gardens' address as the return address.
  5. Save the merged envelopes as Lastname_Firstname_Club_Envelopes
  6. Insert the your name in the footer for each of the four Word documents.

 

  

 

ITCC200 Assignment 4

The scenario:

Johnston Smith, Associate Director of Sales as Pasedena HVAC Manufacturer, has asked you to calculate the cost of running HVAC units in summer and provide a report.

For this assignment, you will need the following files:

    New blank Access database

    HVAC_Cooling

You will save your files as:

    Lastname_Firstname_HVAC_Cooling

    Lastname_Firstname_Cooling_Costs


1.Open the HVAC_Cooling Excel file, and save the file as Lastname_Firstname_HVAC_Cooling.
2. Insert the your name in the footer.
3. In the worksheet, insert an Excel table with a header row.
4.Add a calculated column that calculates the cost of cooling using $0.00124 per Cooling BTU formatted with the Accounting Number Format.
5.Filter the data to display only one Heating BTU number of your choice.
6.Apply Best Fit to all columns.
7.Center the worksheet horizontally on a landscape page.
8.In Access, create a new database and save it as Lastname_Firstname_Cooling_Costs
9.Import your Lastname_Firstname_HVAC_Cooling Excel file.
10.In the table, filter the data to show only data for the Cooling BTU greater than 60,000 and the Power unit of your choice.
11.Create a report based on your results.
12.Delete the four measurement fields following the Heating BTU field,  and be sure the title fits on one line.

    

ITCC200 Midterm Exam

Assignment Instructions

The Scenario:

Frederick Jackson, one of the owners of Sports Gear, believes it is important to stress sports safety. He wants his sales associates to emphasize sports protective gear—such as helmets, padding, and cups—that is available in the retail store.

For this assignment, you will need the following files:

  • Sports_Gear  protection
  • Gear_Presentation

You will save your files as:

  • Lastname_Firstname_Sports_Gear
  • Lastname_Firstname_Gear_Presentation
  1. Open the Sports_Gear_Protection  file, and save it as Lastname_Firstname_Sports_Gear
  2. In the worksheet, adjust column widths so that all data displays.
  3. Apply a style to the titles
  4. Set the titles to repeat on all printed pages.
  5. Create a chart on a new sheet.
  6. Format the chart, using a chart layout and chart style.
  7. Rename the sheets containing data.
  8. Insert the your name in the footer of all worksheets.
  9. Open the file Gear_Presentation, and save the presentation as Lastname_Firstname_Gear_Presentation
  10. Apply a design theme and variant, and then add appropriate titles to the slides.
  11. On Slide 2, convert the bulleted list to a SmartArt object, and apply formatting.
  12. Insert a blank slide after Slide 2, and paste the Excel chart as a link.
  13. Insert a shape on one of the slides and modify the shape with at least two effects.
  14. Insert appropriate text in the shape and create a hyperlink to the Excel workbook.
  15. Add a slide transition to all slides.
  16. In the Excel worksheet, add a hyperlink to the presentation.
  17. In both files, add your name in the footer.

 

   

 

ITCC200 Week 5 Assignment

The scenario:

Gerry Henry surfing, one of the owners of Southside Surf Shop, wants to commission an artist to create new board logos for the company. Mr. Henry has created an Excel workbook that lists the artists and their commission prices. He has also narrowed the field down to four logos and placed them in a PowerPoint presentation. He has asked you to complete both files.

For this assignment, you will need the following files:

    Board_Logos

    Logos_Presentation

You will save your files as:

    Lastname_Firstname_Board_Logos

    Lastname_Firstname_Logos_Presentation

  1. Open the file Board Logos.
  2. Save as Lastname_Firstname_Logos_Board_Logos
  3. Adjust the column widths so that all data displays and apply a cell style to the title.
  4. Create a chart to display the Last Name and Commission on a new sheet with an applicable name.
  5. Format the chart using a chart layout and a chart style.
  6. Insert at least two comments on the Artists worksheet.
  7. Rename the data sheet with a descriptive name.
  8. Insert the your name in the footer of all worksheets.
  9. Save the file as Lastname_Firstname_Board_Logos
  10. Open the file Logos_Presentation.
  11. Save the presentation as Lastname_Firstname_Logos_Presentation.
  12. Insert the file name in the handouts footer.
  13. In the presentation, apply a design theme.
  14. Add titles containing the names of artists to the slides; select any names from the Excel workbook.
  15. For each logo, adjust the size or add an effect.
  16. Insert a new slide at the end of the presentation, and then Paste link the Excel chart, and resize it as necessary.
  17. Insert the your name in the footer.

         Upload the completed  assignment files in the Assignment area.  

  • Special Instructions: Use the Supporting Materials below to complete the project.
  • Grading: Please review the rubrics for particulars.

 

       

 

ITCC200 Week 6 Assignment

Assignment Instructions

The Scenario:

In past years, New Orleans has been hit hard by hurricanes and other bad weather. The construction industry, working with New Port Community College, has put a renewed emphasis on training the Construction Management students to build structures that meet current building codes. You have been asked to create a flyer inviting all Construction Management students to attend a conference.

For this assignment, you will need the following files:

    New blank Publisher publication

    Construction_Management

    CM_Logo

You will save your files as:

    Lastname_Firstname_Construction_Management

    Lastname_Firstname_Construction_Conference

    Lastname_Firstname_Merged_Conference

Part 1

  1. Open the Access file Construction_Management and Save with the file name Lastname_Firstname_Construction_Management
  2. Create a form named based on the Students table, save it as Lastname Firstname Student Form
  3. Add the following student records.
  4. Use your first name and last name for the last record.

First Name

Last Name

Address

City

State

ZIP

Phone Number

Degree

Karen

Crosby

11171 54th Ave

New Orleans

LA

33714

504-555-0092

Construction Management

Richard

Eagleson

12501 W Isabel St

New Orleans

LA

33708

504-555-5832

Information Systems

Larry

Magg

15304 Cypress St

New Orleans

LA

33701

504-555-0362

Construction Management

Firstname

Lastname

12513 Frierson Ave

New Orleans

LA

33701

504-555-0186

Construction Management

Part 2

  1. Create a report using the Report Wizard that includes the fields First Name, Last Name, Phone Number, and Degree.
  2. Group the data by Degree and sort the data by Last Name. Change the column widths so all data is visible.
  3. Create a Publisher template of your choice.
  4. Save the file as Lastname_Firstname_Construction_Conference and then insert the your name in the footer.
  5. In a text box, add information about the Construction Management conference to be held on campus on March 3–4.
  6. In another text box, list Louisiana cities, such as Baton Rouge, Lafayette, that have had damage due to hurricanes.
  7. Insert and format appropriate online images.
  8. Create a business set for Mrs. Finale using the following information.

Individual name

Tammy Finale

Job position

Director, Construction Management Program

Organization name

New Port Community College

Address

12745 Dartmouth Ave New Orleans, LA 70114

Phone Number

504-555-0030

Fax

504-555-0031

E-mail

construction@NewPortCC.edu

Tagline

Building a better New Orleans

Logo

CM_Logo

Business Information set name

Finale

Part 3

  1. Start mail merge and choose your Access file Lastname_Firstname_Construction_Management as the data source.
  2. Filter the recipients to show only the Construction Management students.
  3. Insert the student's name and mailing address.
  4. Save the publication.
  5. Complete the merge to a new publication.
  6. Save the merged publication as Lastname_Firstname_Merged_Conference and then update the footer with your name.

 

Upload the completed  assignment files in the Assignment area.  

  • Special Instructions: Use the Supporting Materials below to complete the project.

 

    

 

ITCC200 Week 7 Assignment SCORE 100 PERCENT

Assignment Instructions

The scenario:

The Prime National Properties Group is considering selling some of its educational facilities. The facilities have been tracked in an Access database. Shelly Williams, the President of the company, has asked you to prepare a report. Import the Access data in the file Facilities_Data as a table into Excel. Using the PMT function, calculate the monthly payments the company could expect. The company would charge an 8% rate over 10 years. The result should be a positive number. Mr. Williams also asked you to calculate an extra processing fee for monthly loan payments using the IF function. If a monthly loan payment is less than $6000, the company would charge a processing fee of $150; otherwise, there would be no processing fee. Filter the rows to display only those facilities where there is a $0 processing fee. Hide all of the address fields and the processing fee column. Save the Excel file as Lastname_Firstname_Educational_Facilities

For this assignment, you will need the following files:

    New blank Excel workbook

    Facilities_Data

    Educational_Report

You will save your files as:

    Lastname_Firstname_Educational_Facilities

    Lastname_Firstname_Educational_Report

  1. Open the Word document Educational_Report, and then save the file as Lastname_Firstname_Educational_Report
  2. Add a cover page of your choice, and then complete the content controls on the cover page.
  3. In the report, format headings as Level 1 or Level 2, and then insert a table of contents on a new page.
  4. In the worksheet, hide all of the address fields and the processing fee column
  5.  paste the Excel data into the Word document.
  6. Add an appropriate heading formatted as Level 1, and then update the table of contents.
  7. In each file, insert the your name as a field in the footer

Upload the completed  assignment files in the Assignment area.  

  • Special Instructions: Use the Supporting Materials below to complete the project.
  • Grading: Please review the rubrics for particulars.

 

          

 

ITCC200 Week 8 Final Project

Assignment Instructions

The Scenario:

Tony Spacken, Sales Manager, has an Excel workbook listing properties for sale. If a property is sold, Select National Properties Group will finance the property loan for 30 years at 7.5% interest. If the monthly payment of a property is greater than $300,000, the company will give the buyer a 1% discount of the selling price.  Lavern Gallen is interested in purchasing the Pleasant Properties Warehouse, one of the company's properties. She lives at 4231 Center Drive, Tempe, TX 76501.

For this project, you will need the following files:

    New blank Access database

    New blank PowerPoint presentation

    Gallen_Letter

    Sale_Properties

You will save your files as:

    Lastname_Firstname_Sale_Properties

    Lastname_Firstname_SNPG_Properties

    Lastname_Firstname_Gallen_Letter

    Lastname_Firstname_Sales_Presentation

  1. Open the file Sale_Properties, and then save the workbook as LastnameFirstname_Sale_Properties
  2. Copy the Properties worksheet to a new worksheet,
  3. Rename the worksheet as Payments
  4. In the Payments worksheet, convert the data to a table.
  5. In column G, insert a calculated column using the PMT function to calculate the monthly payment for each of the properties.
  6. In column H, insert a calculated column using the IF function to determine the amount of the if discount
    property qualifies for it.
  7. Determine the totals for columns F:H.
  8. Apply conditional formatting to cells with a selling price between $40,000,000 and $70,000,000.
  9. Copy the Payments worksheet to a new worksheet,
  10. Rename the new worksheet as Pleasant Properties
  11. Filter the table to display only the data for the Pleasant. Insert your name in the footer so that it displays on all worksheets.
  12. Create a blank Access database, and then save it as Lastname_Firstname_SNPG_Properties
  13. Import the data from the Properties worksheet.
  14. Create a query that displays all fields, except the ID field, for properties located in Florida and Georgia.
  15. Save the query as Lastname_Firstname_FL_GA Query
  16. Export the query result as an RTF file
  17. Create another query that displays all fields, except the ID field, for all properties with selling prices less than $1,000,000.
  18. Save the query as Lastname Firstname Price Query
  19. For each query, create and format a report.
  20. Save each report with the name as the query, substituting the word Report for Query.
  21. Create a PowerPoint presentation using a template of your choice; the presentation will be shown to prospective buyers attending a sales conference.
  22. Save the presentation as Lastname_Firstname_Sales_Presentation
  23. Insert the file name in the footer to display on all pages of the notes and handouts.
  24. Modify the slides to help persuade buyers to purchase property from Select National Properties Group:
  25. On one slide, inform the audience that the company sells many properties.
  26. On the same slide, link the cell from the Excel Payments worksheet that displays the total selling price.
  27. On a new slide, insert a SmartArt graphic that lists some of the different types of properties that the company develops and manages.
  28. At the end of the presentation, insert a slide that contains the contact information for Mr. Spacken.
  29. Insert additional text, pictures, and clip art to enhance the presentation.
  30. Format any text or other objects to create a professional appearance.
  31. Open the file Gallen_Letter, and then save as Lastname_Firstname_Gallen_Letter
  32. Insert the file name in the footer.
  33. Format the letterhead for Mr. Tony Spacken.
  34. Insert the current date, and then insert Lavern Gallen's name and address and a proper salutation.
  35. Following the first paragraph, copy the SmartArt graphic from your presentation to the letter, changing text wrapping and resizing as necessary.
  36. Following the second paragraph, from Excel, on the Pleasant Properties worksheet, link cells F1:G38 (first and second row) to the Word document.
  37. Under the third paragraph, insert the RTF file listing the Florida and Georgia properties.
  38. Format the document to create a professional appearance.
  1.  

         Upload the completed  assignment files in the Assignment area.  

 

    

No comments:

Post a Comment

ECO561 Economics