ITW(6587)/ITW(G) (6587)– Semester 1 2015
Assignment 2
Using Advanced I.T. Tools for Workplace Due Date: Week 13 Friday 11.30 pm
Submission and Assessment requirements:
This assignment will be marked out of 15 marks and carries 15% mark of the overall mark for the unit. Please check the unit outline for late penalties and resubmissions. This assignment is an individual assignment and not a group assignment.
For details of marking/grading for this assignment, please refer the marking guide available separately.
All submissions need to be electronic submissions through Moodle before the due date. Submission should be one single zip file (A2StudentIDLastName.zip) with saved files and a short report for each project. The report should include steps used to work on each of the project.
All submissions need to be electronic submissions through Moodle before the due date. Submission should be one single zip file (A2StudentIDLastName.zip) with following files in the A2StudentIDLastName folder:
• YourStudentID_A2_Report file
• YourStudentID_A2_Part1 folder
• YourStudentID_A2_Part2 folder
• YourStudentID_A1Part3 folder
• YourStudentID_Assignment Cover Sheet
Part 1: Using Microsoft PowerPoint (Use A2_part1_data) and (refer to Week10_tutorial_lab_solution for help on this question)
(5 marks)
Using Microsoft PowerPoint
1. Create new presentation and save it as A2P1_Lastname_Firstname; add a title (“Family Fun Park”) and subtitle (Your name); apply Opulent theme; insert Two Content layout slide; add title (“Enjoy our Park”) and content (“Rides”, “Games”, “Children’s attractions”); add the text “Petting Zoo” and “Carousel” as indented bullets; insert image file (p_ape_a_carousel.jpg) from (Assign2DataA2_part1_data) folder on right side of slide 2; add metal frame picture style to picture. (0.5 mark)
2. Add Section Header slide; add title (“Rides”) and content(For all “Kids” 10 and older); add notes
This section highlights the park’s rides; insert Picture with Caption Slide; insert image file (p_ape_a_ride.jpg); add title (Thrill Rides!)and caption(Get your blood pumping!); insert header on notes and handouts; insert page number in footer. (0.5 mark)
3. Open file p_ape_a_New_Rides in (Assign2DataA2_part1_data) and save it as
A2P1_New_Rides_Lastname_Firstname; decrease bullet level in Slide 1; add new bullet in Slide 2; replace Water Ride with Water Park in all slides; change title font in Slide 1; italicize title in Slide 2. (0.5 mark)
4. Left align the title in Slide 4; Change the slide layout of Slide 3; apply transition to all slides; set duration; insert header and footer; save and close. (0.5 mark)
5. Open the file p_ape_a_training and save it as A2P1_Training_Lastname_Firstname; change bulleted list in Slide 4 to a numbered list; change bullet style in Slide 5; apply theme color and change size; remove bullet in Slide 2; boldface, italicize, and center text. (0.5 mark)
6. Change slide layout for Slide 4; insert clip art in right placeholder; insert clip art in Slide 2; adjust height and width; align left border horizontal and vertical rulers; change image shape; insert text box in Slide 2; align left border; add text; change font size; insert shape in Slide 2; add text to shape in Slide 5; set font to 32; select shape and add effect. (0.5 mark)
7. Add style to shape Slide 6; add picture style to picture on Slide 4; add picture style to picture on Slide
3; move picture on Slide 7 and duplicate it twice; move copies down and to right; left align images on Slide 8 and distribute vertically; add effect to all three images. (0.5 mark)
8. Remove background of picture on Slide 15; add effect; apply WordArt style to title on Slide 9; insert WordArt on Slide 10 under the picture; convert paragraph on Slide 11 to Vertical Bullet List SmartArt graphic; add new shape and add text; insert Vertical Arrow List SmartArt graphic in Slide 12; add text to graphic. (0.5 mark)
9. Insert SmartArt graphic in Slide 12; add text; insert SmartArt graphic in Slide 13; add text and images; change SmartArt layout in Slide 16; change color of SmartArt graphic. (0.5 mark)
10. Resize the shape group on Slide 17; change the right shapes to ovals; convert SmartArt graphic to text on Slide 14; insert header and footer in notes and handouts; save and close; submit all files for this part of assignment . (0.5 mark)
Part 2: Using Microsoft Access Database (Use A2_part2_data) and refer to Week11_tutorial_lab_solution for help on this question)
(10 marks)
Using Microsoft Access Database
1. Create a Blank Microsoft Database, and name it Lastname_Firstname_A2_part2_solution1; enter field names and data types; change field name, and enter a new record; save the table as Lastname_Firstname_A2_part2_solution2.(1 Mark)
2. Import the data from A2_part2_ data1.xlsx, and append it to the table; delete a field and change a field's parameters.(0.5 Mark)
3. Import the data from A2_part2_data2.xlsx, into a new table named
Lastname_Firstname_A2_part2_solution3; adjust column widths in both tables.(0.5 Mark)
4. Using the MgrID field, create a relationship between the two tables, enforcing referential integrity; resize and realign the two field lists as needed; create a relationship report named
Lastname_Firstname_A2_part2_solution4 and submit a copy of the report .(0.5 Mark)
5. Using the Lastname_Firstname_A2_part2_solution3 table, create a form named
Lastname_Firstname_A2_part2_solution5; change the column size width to 4 and only print the first record; submit a copy of the form .(0.5 Mark)
6. Using the Lastname_Firstname_A2_part2_solution2 table, create a report named
Lastname_Firstname_ A2_part2_solution6; delete selected fields; sort in alphabetical order, change report title, and delete page footer; submit a copy of the report.(0.5 Mark)
7. Using the Lastname_Firstname_A2_part2_solution3 table, create a query named
Lastname_Firstname_A2_part2_solution7; delete, move, and add specified fields; submit a copy of the query.(0.5 Mark)
8. Copy the Lastname_Firstname_A2_part2_solution7 query and name it
Lastname_Firstname_A2_part2_solution8; sort based on specified fields; submit a copy of the query.(0.5 Mark)
9. Using specified fields from the Lastname_Firstname_A2_part2_solution3 table, create a query named Lastname_Firstname_ A2_part2_solution9 to display only records in the Central territory; submit a copy of the query.(0.5 Mark)
10. Using specified fields from the Lastname_Firstname_ A2_part2_solution3 table , create a query named Lastname_Firstname_ A2_part2_solution10 to display records missing information in the #Room field; submit a copy of the query. (0.5 Mark)
11. Using specified fields from the Lastname_Firstname_ A2_part2_solution2 and Lastname_Firstname_ A2_part2_solution3 tables, create a query named Lastname_Firstname_ A2_part2_solution11 to display records; submit a copy of the query.(0.5 Mark)
12. Using specified fields from the Lastname_Firstname_ A2_part2_solution3 table, create a query named Lastname_Firstname_ A2_part2_solution12 to display records of facilities with five or fewer floors; submit a copy of the query.(0.5 Mark)
13. Using specified fields from the Lastname_Firstname_A2_part_solution3 table, create a query named Lastname_Firstname_ A2_part2_solution13 to display records for facilities in the South territory that have more than 300 rooms; submit a copy of the query.(1 Mark)
14. Using specified fields from the Lastname_ Firstname_ A2_part2_solution3 table, create a query named Lastname_Firstname A2_part2_solution14 to display records for facilities that have 8 or 9 floors; submit a copy of the query .(0.5 Mark)
15. Using specified fields from the Lastname_Firstname_ A2_part2_solution2 table, create a query named Lastname_ Firstname_ A2_part2__solution15 to display records including two calculated and formatted fields; submit a copy of the query .(1 Mark)
16. Using specified fields from the Lastname_ Firstname_ A2_part2_solution3 table, create a query named Lastname Firstname_ A2_part2_solution16 to display the average number of rooms in each territory; submit a copy of the query .(0.5 Mark)
17. Using the Report Wizard and specified fields from the Lastname_ Firstname_ A2_part2_solution16 query, create a formatted report named Lastname_ Firstname_ A2_part2_solution17; submit a copy of the report; close all open objects, close the database, and close Acces. Submit all files for this part of assignment.(0.5 Mark)
Part 3: Cloud Computing with Google (Use A2_part3_data) and refer to Week12_tutorial_lab_solution for help on this question)
(10 marks)
Cloud Computing with Google
1. Creat a Google Drive account, and Create folder named Lastname_Firstname in a Google Drive account; upload A2_part3_data, rename as GICC Renovations and open in Google Sheets.(0.5 Mark)
2. Delete chart and add new data; add rows at bottom of worksheet and insert a Column chart; enter title, remove legend, reposition chart, and change size of x-axis labels; Create a Window Snip saved a Lastname_Firstname_solution1 and close worksheet.(1 Mark)
3. Create a new document named Sales Projection; enter and format text; apply and change bullets; insert a line; insert a table and enter text; adjust column widths; create a Window Snip saved as Lastname_Firstname_ _solution2.(1 Mark)
4. Share document with anyone@gmail.com (or one of your groupmate) and allow them to view it; create a Window Snip saved as Lastname_Firstname_solution3; share & save, and close the document window; .(1 Mark)
5. Display the calendar in months; add an event for first Monday of the month; add a repeating event for the second Tuesday of the month; edit Monday meeting, add a guest, and allow her to modify the event; create a Window Snip of the current window, and save the file as Lastname_Firstname_solution4, save the event, and send the invitation; create a Window Snip of the current window, and save the file as Lastname_Firstname_ _solution5 .(1 Mark)
6. Modify calendar settings: share calendar with anyone@gmail.com (or one of your groupmate) and allow the person to make changes to events; create a Window Snip of the current window and save the file as Lastname_Firstname_solution6; sign out .(0.5 Mark)
7. Log in to blogger.com and sign in; create a new blog entering information, and using the Simple template; change the template, variation, color theme, and title formatting; create and publish a post entering information; create a Window Snip of the current window, and save the file as
Lastname_Firstname_solution7; close Blog tab and sign out.(1.5 Mark)
8. Log in to google.com and sign in; enter school information and share profile information; create a Window Snip of the current window, and save the file as Lastname_Firstname_solution8; select partner or second account, create a new circle, and share a message; create a Window Snip of the current window, and save the file as Lastname_Firstname__solution9.(1.5 Mark)
9. In the Hangouts pane, select the partner or second account and send a message; create a Window Snip of the current window, and save the file as Lastname_Firstname_solution10; sign out.(1 Mark)
10. Log in to sites.google.com and sign in; create a new site using specified template with specified message; enter CAPTCHA characters; create a Window Snip of the current window, and save the file as Lastname_Firstname_solution11; return to Home page and create a Window Snip of the current window, and save the file as Lastname_Firstname_solution12; sign out, close browser, and submit files for this part of Assignment.(1 Mark)