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
- Open the
provided file, Web_Sales_Chart file, and then save the Excel
workbook as Lastname_Firstname_ Web_Sales_Chart. Complete the Excel
worksheet
- Insert totals
in row 10,
- Merge and
center the titles
- Format
data for aesthetics
- 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
- Modify the
chart style and format appropriate chart elements
- Insert the
file name in the footer and add appropriate document properties
- Open the
provided file, Web_Sales_Proposal file, and then save the Word
document as Lastname_Firstname_Web_Sales_Proposal
- In the
Word document include the linked Excel data and chart
- Insert the
your name in the footer
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
- Open
the Garden_Clubs database, and save it as Lastname_Firstname_Garden_Clubs
- Create
a form based on the Garden Clubs table, and save the form as Lastname
Firstname Clubs Form
- Enter
the information below, using your First Name and Last Name for the last
record.
- Update
the Address Field for the Evergreen Gardeners to 4525 Center Ave
- Delete
the record for Velvet Gloves.
- 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 |
|
Harris County Green |
First Name |
Last Name |
7847 Faith Ave |
Houston |
TX |
77004 |
713-555-4774 |
Part 2
- Export the table as an RTF file named Lastname_Firstname_Clubs_RTF
- Open the Club_Information file.
- Insert the RTF file
- Delete the Address, City, State, and ZIP
fields.
- Format the information sheet to display as a one-page
document
- Include a page color, page border, and theme.
- Save the document as Lastname_Firstname_Club_Information
Part 3
- Open the Contacts_Letter, and save it as Lastname_Firstname_Contacts_Letter
- Using mail merge, include appropriate merge fields from the
Garden Clubs table in the database in the letter.
- Complete the merge, and then save the merged letters as Lastname_Firstname_Club_Letters
- Create envelopes to be used with the letters, using Success Gardens'
address as the return address.
- Save the merged envelopes as Lastname_Firstname_Club_Envelopes
- Insert the your name in the footer for each of the four Word
documents.
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.
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
- Open the Sports_Gear_Protection
file, and save it as Lastname_Firstname_Sports_Gear
- In the worksheet,
adjust column widths so that all data displays.
- Apply a style to
the titles
- Set the titles to
repeat on all printed pages.
- Create a chart on a
new sheet.
- Format the chart,
using a chart layout and chart style.
- Rename the sheets
containing data.
- Insert the your
name in the footer of all worksheets.
- Open the file Gear_Presentation,
and save the presentation as Lastname_Firstname_Gear_Presentation
- Apply a design
theme and variant, and then add appropriate titles to the slides.
- On Slide 2, convert
the bulleted list to a SmartArt object, and apply formatting.
- Insert a blank slide
after Slide 2, and paste the Excel chart as a link.
- Insert a shape on
one of the slides and modify the shape with at least two effects.
- Insert appropriate
text in the shape and create a hyperlink to the Excel workbook.
- Add a slide
transition to all slides.
- In the Excel
worksheet, add a hyperlink to the presentation.
- In both files, add
your name in the footer.
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
- Open
the file Board Logos.
- Save
as Lastname_Firstname_Logos_Board_Logos
- Adjust
the column widths so that all data displays and apply a cell style to the
title.
- Create
a chart to display the Last Name and Commission on a new sheet with an
applicable name.
- Format
the chart using a chart layout and a chart style.
- Insert
at least two comments on the Artists worksheet.
- Rename
the data sheet with a descriptive name.
- Insert
the your name in the footer of all worksheets.
- Save
the file as Lastname_Firstname_Board_Logos
- Open
the file Logos_Presentation.
- Save
the presentation as Lastname_Firstname_Logos_Presentation.
- Insert
the file name in the handouts footer.
- In
the presentation, apply a design theme.
- Add
titles containing the names of artists to the slides; select any names
from the Excel workbook.
- For
each logo, adjust the size or add an effect.
- Insert
a new slide at the end of the presentation, and then Paste link the Excel
chart, and resize it as necessary.
- 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.
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
- Open
the Access file Construction_Management and Save with the file name
Lastname_Firstname_Construction_Management
- Create
a form named based on the Students table, save it as Lastname Firstname
Student Form
- Add
the following student records.
- 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
- Create
a report using the Report Wizard that includes the fields First Name, Last
Name, Phone Number, and Degree.
- Group
the data by Degree and sort the data by Last Name. Change the column
widths so all data is visible.
- Create
a Publisher template of your choice.
- Save
the file as Lastname_Firstname_Construction_Conference and then insert the
your name in the footer.
- In
a text box, add information about the Construction Management conference
to be held on campus on March 3–4.
- In
another text box, list Louisiana cities, such as Baton Rouge, Lafayette,
that have had damage due to hurricanes.
- Insert
and format appropriate online images.
- 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
- Start
mail merge and choose your Access file Lastname_Firstname_Construction_Management
as the data source.
- Filter
the recipients to show only the Construction Management students.
- Insert
the student's name and mailing address.
- Save
the publication.
- Complete
the merge to a new publication.
- 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
- Open the Word document Educational_Report,
and then save the file as Lastname_Firstname_Educational_Report
- Add a cover page of your choice, and then
complete the content controls on the cover page.
- In the report, format headings as Level 1 or
Level 2, and then insert a table of contents on a new page.
- In the worksheet, hide all of the address
fields and the processing fee column
- paste the Excel data into the Word
document.
- Add an appropriate heading formatted as
Level 1, and then update the table of contents.
- 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.
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
- Open
the file Sale_Properties, and then save the workbook as LastnameFirstname_Sale_Properties
- Copy
the Properties worksheet to a new worksheet,
- Rename
the worksheet as Payments
- In
the Payments worksheet, convert the data to a table.
- In
column G, insert a calculated column using the PMT function to calculate
the monthly payment for each of the properties.
- In
column H, insert a calculated column using the IF function to determine
the amount of the if discount
property qualifies for it. - Determine
the totals for columns F:H.
- Apply
conditional formatting to cells with a selling price between $40,000,000
and $70,000,000.
- Copy
the Payments worksheet to a new worksheet,
- Rename
the new worksheet as Pleasant Properties
- Filter
the table to display only the data for the Pleasant. Insert your name in
the footer so that it displays on all worksheets.
- Create
a blank Access database, and then save it as
Lastname_Firstname_SNPG_Properties
- Import
the data from the Properties worksheet.
- Create
a query that displays all fields, except the ID field, for properties
located in Florida and Georgia.
- Save
the query as Lastname_Firstname_FL_GA Query
- Export
the query result as an RTF file
- Create
another query that displays all fields, except the ID field, for all
properties with selling prices less than $1,000,000.
- Save
the query as Lastname Firstname Price Query
- For
each query, create and format a report.
- Save
each report with the name as the query, substituting the word Report for
Query.
- Create
a PowerPoint presentation using a template of your choice; the
presentation will be shown to prospective buyers attending a sales
conference.
- Save
the presentation as Lastname_Firstname_Sales_Presentation
- Insert
the file name in the footer to display on all pages of the notes and
handouts.
- Modify
the slides to help persuade buyers to purchase property from Select
National Properties Group:
- On
one slide, inform the audience that the company sells many properties.
- On
the same slide, link the cell from the Excel Payments worksheet that
displays the total selling price.
- On
a new slide, insert a SmartArt graphic that lists some of the different
types of properties that the company develops and manages.
- At
the end of the presentation, insert a slide that contains the contact
information for Mr. Spacken.
- Insert
additional text, pictures, and clip art to enhance the presentation.
- Format
any text or other objects to create a professional appearance.
- Open
the file Gallen_Letter, and then save as Lastname_Firstname_Gallen_Letter
- Insert
the file name in the footer.
- Format
the letterhead for Mr. Tony Spacken.
- Insert
the current date, and then insert Lavern Gallen's name and address and a
proper salutation.
- Following
the first paragraph, copy the SmartArt graphic from your presentation to
the letter, changing text wrapping and resizing as necessary.
- Following
the second paragraph, from Excel, on the Pleasant Properties worksheet,
link cells F1:G38 (first and second row) to the Word document.
- Under
the third paragraph, insert the RTF file listing the Florida and Georgia
properties.
- Format
the document to create a professional appearance.
Upload
the completed assignment files in the Assignment area.
No comments:
Post a Comment