[Recommended]ITCC week 6

ITCC week 6 Week 6 Assignment DUE: Jun 16, 2019 11:55 PM Grade Details Grade N/A Gradebook Comments None Assignment Details Open Date May 6,…

ITCC week 6
Week 6 Assignment
DUE: Jun 16, 2019 11:55 PM
Grade Details
Grade
N/A
Gradebook Comments
None
Assignment Details
Open Date
May 6, 2019 12:05 AM
Graded?
Yes
Points Possible
100.0
Resubmissions Allowed?
No
Top of Form
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.
· Grading: Please review the rubrics for particulars.
Grading Rubrics
Performance Level
Exemplary
Accomplished
Developing
Beginning
Points
Performance Element
You consistently applied the relevant skills.
You mostly applied the relevant skills.
You sometimes, but not always, applied the relevant skills.
You rarely or never applied the relevant skills.
10/10
Create Student Form and enter data
Form is created, all records are entered accurately
Form is created and records entered, but there are two or fewer errors in
Form is created and records entered, but there are more than two errors
Form is not created or records are not entered
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
Points:
Create Report
Report is created using the correct fields and formatting
Report is created using the correct fields, with two or fewer errors
Report is created using the correct fields, with more than two errors
Report includes more than two errors or was not created
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
Points:
Create Construction_ Conference publication
Publication created to include all content and formatted accurately
Publication created, but there are two or fewer errors in content or formatting
Publication created, but there are more than two errors in content or formatting
Publication includes more than two errors or was not created
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
Points:
Supporting Materials
· https://edge.apus.edu/library/image/sakai/image.gif CM_Logo.png (57 KB)
· https://edge.apus.edu/library/image/sakai/generic.gif Construction_Management.accdb (472 KB)
Submission
Bottom of Form

The post ITCC week 6 appeared first on ExpertCustomWritings.
Assignment status: Solved by our experts

>>>Click here to get this paper written at the best price. 100% Custom, 0% plagiarism.<<<

Leave a Reply

Your email address will not be published. Required fields are marked *