Assignment
Using Advanced I.T. Tools for Workplace
Part 1: Using Microsoft PowerPoint (Use A2_part1_data) and (refer to Week10_tutorial_lab_solution for help on this question)
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Part 2: Using Microsoft Access Database (Use A2_part2_data) and refer to Week11_tutorial_lab_solution for help on this question).
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.
2. Import the data from A2_part2_ data1.xlsx, and append it to the table; delete a field and change a field's parameters.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Part 3: Cloud Computing with Google (Use A2_part3_data) and refer to Week12_tutorial_lab_solution for help on this question).
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.
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.
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.
4. Share document with [email protected] (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.
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.
6. Modify calendar settings: share calendar with [email protected] (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.
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.
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.
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.
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.