Assessment Description: Please see the attachment file below. Thank you

Assessment Description: Please see the attachment file below. Thank you
Top 10 Natural Wonders of the World by Your Name Our world is full of wonders. People are busy in exploring these wonders. Many more are still hidden and undiscovered yet. These spectacular structures always inspires us. Compiling a list of top 10 natural wonders of the world is never an easy task because various lists of the Wonders of the World have been compiled from ancient to the present day, to catalog the most spectacular natural wonders and man-made structures. Similar to the other lists of wonders, there is no consensus on a list of ten natural wonders of the world, and there has been a debate over how large the list should be. We did our best to compile this top 10 natural wonders of the world in a list counting backwards from 10 to 1. Hope you will like it. Have your visited any? Ha Long Bay Ha Long Bay, in the Gulf of Tonkin, includes some 1,600 islands and islets, forming a spectacular seascape of limestone pillars. Because of their precipitous nature, most of the islands are uninhabited and unaffected by a human presence. The site’s outstanding scenic beauty is complemented by many nature lovers. The bay features thousands of limestone karsts and isles in various sizes and shapes. The limestone in this bay has gone through 500 million years of formation in different conditions and environments. The evolution of the karst in this bay has taken 20 million years under the impact of the tropical wet climate. Ha Long Bay is home to 14 endemic floral species and 60 endemic faunal species. Historical research surveys have shown the presence of prehistorical human beings in this area tens of thousands years ago. Table Mountain Table Mountain is a flat-topped mountain forming a prominent landmark overlooking the city of Cape Town in South Africa. It is one of the New natural Wonders of world. It is a significant tourist attraction, with many visitors using the cableway or hiking to the top. Puerto Princesa Underground River The Puerto Princesa Subterranean River National Park is one of the most distinguished protected areas of the Philippines. It is located some 360 miles southwest of Manila. It was established as a National Park in 1971 primarily to protect and preserve the intact old growth forest, interesting wildlife, pristine white sand beaches, unspoiled natural beauty and one of the most impressive caves systems in the world. Jeju Island Jejudo is a volcanic island, 130 km from the southern coast of Korea. The largest island and smallest province in Korea, the island has a surface area of 1,846 sqkm. The island contains the natural World Heritage Site Jeju Volcanic Island and Lava Tubes. A central feature of Jeju is Hallasan, the tallest mountain in South Korea and a dormant volcano, which rises 1,950 m above sea level. Parícutin Parícutin (volcano) is a cinder cone volcano in the Mexican state of Michoacán. The volcano is unique in the fact that its evolution from creation to extinction was witnessed, observed and studied by human beings. It appears on many versions of the Natural Wonders of the World. Parícutin is part of the Michoacán-Guanajuato volcanic field, which covers much of west central Mexico. It is part of the Ring of Fire. Iguazu Falls The Garganta del Diablo (Devil’s throat) with its U-shape is undoubtedly the highlight of these majestic waterfalls. It is 82 metres high, 150 metres wide and 700 metres long, while the rest of the falls average 64 metres. Iguazu Falls has long been one of Argentina and Brazil’s most popular touristic destinations. Over 2000 species of plants, 400 of birds and 70 mammals have been registered in the area. Aurora One of the greatest natural wonders, Aurora. The auroras, also known as the Northern Lights, are naturally occurring lights that create intriguing and spectacular displays in the sky. The aurora lights frequently appear as diffused glow lighting up the horizon. The most amazing sight is when the northern lights appears as waves across the sky; it is almost as if the lights are dancing. Mount Everest Mount Everest is the highest mountain in the world with the summit reaching a peak of 29,029 feet (8,848 m). It is located in the Himalayan mountain range on the border between Nepal and Tibet, China. Mt. Everest has a great deal of history behind it. It was named after Sir George Everest, surveyor-general of India. On May 28, 1953 Sir Edmund Hillary and Tenzing Norgay were left behind by their companions. They hoped to be the first to climb the world’s highest mountain.The next day they became the first people in the world to climb Mount Everest. Great Barrier Reef Located in the Coral Sea, off the coast of Queensland, Australia. The great barrier reef is the world’s largest individual formation created by living organisms. As the largest coral reef in the world, the Great Barrier Reef includes over 900 islands, over 2,900 separate reefs, and supports one of the most diverse ecosystems in the world. It is possible one of the grandest natural wonders in the world. It is the only wonder of nature that may be visible recognized from outer space. Grand Canyon The Grand Canyon is one of the most remarkable natural wonders in the world. Located in the state of Arizona, USA, it is one of the deepest gorges on Earth with an average depth of one mile (1.6km) and an average width of ten miles (16km). The canyon was carved over the past 6 million years by the action of the Colorado River as it drops over 2,200 feet (670m) along the 277-mile (446 km) length of the gorge. For thousands of years, the area has been continuously inhabited by Native Americans who built settlements within the canyon and its many caves. The Pueblo people considered the Grand Canyon a holy site and made pilgrimages to it. Other Wonders of the World: The Original Seven Wonders of the Ancient World Great Pyramid of Giza Hanging Gardens of Babylon Statue of Zeus at Olympia Temple of Artemis at Ephesus Mausoleum at Halicarnassus Colossus of Rhodes Lighthouse of Alexandria The Seven Wonders of the Modern World Great Wall of China Christ the Redeemer Machu Picchu Chichen Itza Roman Colosseum Taj Mahal Petra The Seven Natural Wonders of the World Grand Canyon The Great Barrier Reef The Harbor at Rio de Janeiro Mt. Everest Northern Lights Paricutin Volcano Victoria Falls
Assessment Description: Please see the attachment file below. Thank you
FINAL PROJECT This project has two parts, you will be using Microsoft Excel, Access and Word to complete. Total for both parts is 50 points. -5 points for each error/omission of a completed step. When you are done with BOTH parts, attach and submit for grading in the Final Project link in Course Content. Part I – Importing MS Excel into MS Access You have an in -home hobby business, which has taken off very quickly. Your inventory and vendor information are in Excel spreadsheets but you are at the point that you need to move your information into an Access database. You want your information to be more consistent and easier to find. Your tasks include importing two existing worksheets from Excel as tables, additionally you will modify tables , creating queries , a form, and report. Both the Toys and Vendors workbooks are available open are availabl e in the Final Project Link in Course Content. Set up the Database File and Import the Excel Worksheets To start, you will need to create a database. You will be importing two tables from Excel, Toys and Vendors. The first field in both will be the pri mary key. a. Open Access. Create a database with the name Final Project Part I_YourFirstnameLastname.accdb. b. Import the Toys file from Excel using the External Data Ribbon. First row contains column headings. Choose Stock Number as the primary key and all other defaults including the Table Name Toys. c. Import the Vendors file from Excel. First row contains column headings. Choose Vendor ID as the primary key and all other defaults including the Table Name V endors . d. Delete Table 1 . Modify the Table Open the Toys table in design view. Verify the information below. Make any changes necessary. Save the structure of the Toys table. Field Name Data Type Field Size Stock Number Short Text 10 Description Short Text 20 Inventory Number Integer Cost Currency Selling Price Currency Vendor ID Short Text 4 No changes need made to the design of the Vendors Table. Create and Modify Data in a Form Create a form for the Toys table using the Form Wizard . Use all the defaults of creating the form in the Form Wizard. Add the following two records: 06598726 05987563 Dogs and Cats Puzzle Zoo Animals Puzzle 4 5 9.00 9.00 12.50 12.50 WT36 TT96 In either the form or the table, c hange the selling price of the Colored Shape Blocks to $75.00 and the Sports Car $20.00. Change the name of the form to Toys Inventory . (you cannot rename the Form if it is open) Creating Queries Create the following queries: a. Create a new query using the Toys table. Include the Stock Number, Description, Inventory, and Selling Price for all records. Sort by selling price in descending order. Save the query as Toys Query . b. Using the Toys table, create a query in design view. Display the Stock Number, Description, Cost, and Vendor ID for all products w hose Vendor ID is TT96 (CRITERIA UNDER Vendor ID) . Do not display the Vendor ID field. Save the query as TT96 Toys . c. Using the Vendor table, create a query that displays only the Vendor Name and Phone numb er. Save the query as Vendor Contact Number s. When you return to data sheet view, widen fields so all da ta is visible. Create a Report Use the Report Wizard to create a Report based on the Toys Table, have the fields Vendor ID , Stock Number, Description, and Inventory (in that order). Group by Vendor ID and use all other defaults of the Report Wizard . Save the report with the default name, close the report and then rename the Rep ort Toys by Vendor. Part II – Formatting a Brochure using MS Word For this part, you will be using Microsoft Word to make a brochure with 2 columns. Format the document as outlined in the instructions. Ignore any words that are coming up as misspelled. The Wonders document you need to open is available in the Final Project Link in Course Content. Open Wonders and save as Final Project Part II_YourFirstnameLastname. docx 1) Select the entire document and change the font and size to a readable font of your choice, 12 pt. 2) Change Paragraph Spacing after to 0 pt. 3) Set Line Spacing to 1.5” 4) Apply Heading 3 Style to all side headings. The first one is Ha Long Bay and the last on e is with Grand Canyon . There are 10 total side headings. 5) Change top, bottom, left and right margins to .75 . 6) Apply Heading 1 Style to the title Top 10 Natural Wonders of the World and Heading 2 Style to the text by Your Name . Center both lines after Heading Styles are applied. Replace Your Name with your actual first and last name. 7) Underline and bold the text: The Original Seven Wonders of the Ancient World , The Se ven Wonders of the Modern World , and The Seven Natural Wonders of the World. 8) Bullet the lists after The Original Seven Wonders of the Ancient World , The Seven Wonders of the Modern World , and The Seven Natural Wonders of the World with a bullet of your cho ice (you must change it, not use default bullet circle). Have all bullets in these three lists be the same. 9) Select the text starting with Our world is full of (beginning of first paragraph of document) and ending at the end of and made pilgrimages to it . (at end of document before three lists). Put this selected text into two columns with a line between. Keep all other defaults. 10) Place a hard page break at the beginning of Other Wonders of the World so it starts on a new page. 11) Apply Heading 1 Style to t he title Other Wonders of the World and then center it. 12) Insert a Page Number at the bottom center . 13) Look through the side headings in the text in the col umns. Pick two of the side headings (whichever two you want) and find an online image you can insert. Insert the image within the paragraph it represents, reduce its size so it looks good (probably no more than 1” by 1.5” or so) and use word wrap tight. Put the image for each in the top right of the beginning of the paragraph it represents. (For example if I want to use Iguazu Falls; I would go to Insert, Online Pictures, then in the search bar I would type Iguazu Falls, then pick one of the images that comes up.) Make sure there is no text on the right of the image. 14) Look at your page endings and column endings, make sure no side heading is at the bottom of a column with its text starting at the top of the next column. If you find one, just push the Ente r at the beginning of the side heading to move it down. 15) Apply a page border to the whole document with the Style that has three thin lines. End Instructions