Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
MOS Exam is completed in the PC user environment
Grader – Instructions Excel 2019 Project
MOS19_XL_PROJ3_Equipment
Project Description:
In this project, you will create table to meet objectives 3.1 through 3.3 of the Excel MOS Associate exam. To complete the project, you will create and format tables 3.1, modify tables 3.2, and filter and sort table data 3.3. Note: These projects are created for PC users since the MOS Exam is completed in the PC user environment.
Steps to Perform:
Step Instructions Points Possible 1 Start Excel. Download and open the file named Student_MOS19_XL_PROJ3_Equipment.xlsx. Save the file as Last_First_MOS19_XL_PROJ3_Equipment. 0 2 On the Equipment worksheet find and remove the duplicate record in the Item column. Copy the Equipment worksheet, and create a new worksheet at the end with the name Safety. 10 3 On the Safety worksheet, format the range A4:G64 as an Excel table. Verify the table has headers and apply the Teal, Table Style Medium 18. 18 4 Remove the table row 5. Apply the First Column Table Style Option. 13 5 Insert a Total Row. Count the Items and determine the Maximum item cost. 15 6 Use the filter arrows in the header row of the table to sort the Item column in ascending order, and then sort the Stock Level column by font color so that all items that need to be ordered appear at the top of the list. Do not create a multi-level sort. 12 7 Filter the table data by Category to show only the Safety Equipment inventory data. 12 8 Copy the Safety worksheet, and create a new worksheet at the end with the name Order. 8 9 On the Safety worksheet convert the table to a normal range. 12 10 Ensure the worksheets are in the following order: Equipment, Safety, Order. Save the file Last_First_MOS19_XL_PROJ3_Equipment.xlsx. Exit Excel. Submit the file as directed. 0
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow Analyze the Water Footprint Results