Create folder named lastname firstname in a google drive

Assignment Help Basic Computer Science
Reference no: EM13836290

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.

Reference no: EM13836290

Questions Cloud

Group opposed to free trade concludes : A group opposed to free trade concludes that the total number of domestic jobs will decrease because it estimates that 20,000 jobs will migrate abroad. The actual total loss is:
Opportunity cost of producing : If Germany used all its resources to produce bread, suppose it could produce 40 million loaves of bread. If it used all its resources to produce milk, it could produce 20 million gallons of milk. Then Germany's opportunity cost of producing a ______ ..
Derive the total product or output : Suppose you are given the following Total Product Function: Q=100 K^3/2 L^4/2 M^4/7 ,where Q is total output or units produces; K, capital; L, labor; and M, materials.; that is, this is a input factor production function. Suppose K = 1,000; L = 200 w..
What was the highest trade surplus : According to By the Numbers, approximately when was the last time the United States had a trade surplus? As a percentage of GDP, what was the highest trade surplus the United States has achieved? What was the highest trade deficit the United States h..
Create folder named lastname firstname in a google drive : 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.
How do the endings of star food reflect : How do the endings of "Star Food," "Everything That Rises Must Converge," and "The Bet" reflect what might be considered incomplete story arcs?
Directors argue that no illegal activity had occurred : All of the directors of the XYZ Corporation were present at a meeting called on a Monday evening at 9 p.m. In response, the directors argue that: (1) no illegal activity had occurred; (2) if an illegal activity did occur, it was not at a valid meetin..
Analyse the crowning glory ltd case study : Analyse the Crowning Glory Ltd case study in this document and make a recommendation to the company board of directors of Crowning Glory about the best supply chain strategy to follow and why.

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Explaining social engineering attack

Study a social engineering attack. What made this attack successful?

  Write a program using a beginner c language

Write a program using a beginner C language which calculates the value of ? from the series ?=(4/1)-(4/3)+(4/5)-(4/7)+(4/9)-(4/11)+... Print a table that shows the value of ?

  What is the maximum data transfer rate

What is the maximum data transfer rate across the bus that this microprocessor can sustain, in bytes/s?

  What is the standard deviation for the true error rate

Consider a learned hypothesis, h, for some boolean concept. What is the standard deviation and the 95% confidence interval for the true error rate for Errorv(h)?

  Recognize the features of the internet that you require to

identify the features of the internet that you need to use in your mobile or home office including the followingwhich

  Consider the social effects of information technologies

Consider the social effects of information technologies.

  The preferred method of interacting with a computer

Graphical User Interface (GUI) became the preferred method of interacting with a computer system. Beginning with the Xerox-developed GUI in 1970, GUI-based platforms have evolved from the Apple Macintosh to the Microsoft Windows operating syste..

  How many times new flash drive is bigger than old

The program asks the speed v in km/h and transforms it to m/s. Please solve one program ...C , Java it doesnt matter

  Find the after-tax rate of return

Find the after-tax rate of return for the following offshore platform equipment. The equipment, designed for special jobs, will cost $2,500, will have no salvage value, and will last 5 years. Revenue minus expensed is estimated to be $1,500 in year 1..

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What makes a good proposal

Persuade the reader that the proposers (you) are qualified for the work, have a plausible plan and have the resources needed to complete the task.

  Create and conducting an online questionnaire

Create a free SurveyMonkey or QuestionPro online questionnaire account. If you did not create one, revisit the Week 5 e-Activity to create an account before attempting this assignment.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd