Inf 103 week 3 assignment


Ashford 4: – Week 3 – Assignment


Using Microsoft Excel

Plagiarism, whether intentional or unintentional, is a big problem for universities. Not only is it an issue of unfair use of copyrighted material, it speaks to an ethical issue of cheating.

(If you need additional assistance using Microsoft Excel, please refer to the tutorials in the appendices of the Constellation text.)

Consider the following statistics. According to the (2013), a survey conducted by Donald McCabe between 2002 and 2005 that included 63,700 U.S. undergraduates and 9,250 graduate students revealed the following data: 

  1. 36% of undergraduate and 24% of      graduate students admit to “paraphrasing/copying few sentences from      Internet source without footnoting it.” 
  2. 38% of undergraduate and 25% of      graduate students admit to “paraphrasing/copying few sentences from      written source without footnoting it.” 
  3. 14% of undergraduate students      and 7% of graduate students admit to “fabricating/falsifying a      bibliography.” 
  4. 7% of undergraduate and 4% of      graduate students admit copying materials “almost word for word from a      written source without citation.” 
  5. 7% of undergraduate and 3% of      graduate students admit “turning in work done by another.” 
  6. 3% of undergraduate and 2% of      graduate students admit “obtaining paper from term paper mill.” 

In Excel, create a worksheet that addresses the following:

  1. In cell A1, enter the following      title for this worksheet: Student Plagiarism Statistics. 
  2. In cell A3, enter the      following: Form of Plagiarism. 
  3. In cell B3, enter the      following: Undergraduate. 
  4. In cell C3, enter the      following: Graduate. 
  5. In cell D4, enter the total      number of undergraduate students that participated in the study,      63,700. 
  6. In cell E4, enter the total      number of graduate students that participated in the study, 9,250. 
  7. Beginning in cell A5, enter      each of the six categories of plagiarism identified by this report, one in      each row. (These categories are found under the “Academic Integrity in      College and Graduate School” section showing the results of the survey      done by Donald McCabe.). 
  8. Beginning in cell B5, calculate      the number of students that admitted to each offense. To do this, you will      need to calculate the number of students based on the percentage provided.      For example, if there were 63,700 undergraduate students that participated      in the survey and 36% admitted to paraphrasing/copying a few sentences      from an Internet source, then that would mean that 22,932 students      admitted to the offense (63,700 * .36). Complete these calculations for      all six categories. Be sure to enter formulas and use proper cell      referencing, e.g., = D4*.36. 
  9. Calculate the same data for      graduate students beginning in cell C5. 
  10. Format all cells with the      appropriate data types. Set numeric fields with no decimals. 
  11. Once you have completed the      calculations, select the data cells in the table to create your      chart. 
  12. Create a chart that will      visually display the largest areas of plagiarism problems. A good example      might be a column chart that shows undergraduate and graduate data side by      side. The choice of chart is your own. Finalize your worksheet by making      sure all columns are formatted to accommodate the size of the data. Format      your chart as needed to assure that the chart looks clean and neat. Be      sure that your worksheet looks professional and polished. 
  13. Save your workbook. 

See excel worksheet, and chart example here.

Your worksheet must contain:

  1. Accurate calculations with      formulas that demonstrate how you arrived at the values.
  2. An accurate chart that depicts      the data in a professional manner.
Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our Guarantees is always working towards customer satisfaction. Our professional academic writers always aim at producing comprehensive papers that possess quality and originality at pocket-friendly prices. Students are assured that all their private information is safe with us.

Money-Back Guarantee provides a system where students can request for money-back in case they cancel the order or in the rare instances of dissatisfaction. The refund policy adheres to the company’s term and conditions on money-back.

Read more

Zero-Plagiarism Guarantee

While providing the best professional essay writing services, we guarantee all our students of plagiarism-free papers. All papers produced by our professional academic writers are checked against all web resources and previously completed papers to avoid plagiarism.

Read more

Free Revision Policy

In our urge to provide the best professional essay writing services, we guarantee students of free revision policy. The free revision policy is a courtesy service where students can request for unlimited for their completed papers. We always aim at achieving 100% customer satisfaction rates. The free revision policy is one among many of our major advantages.

Read more

Privacy Policy

At, every student is entitled to total security. Our professional academic writers are always committed to protecting all private information of our customers. We do not share any personal information with third parties. Additionally, we provide safe systems for all online transactions.

Read more

Fair-Cooperation Guarantee

Working with us is the greatest step towards achieving all your academic goals. We always deliver the best professional essay writing services as promised. We, therefore, expect all students to work cooperatively with us, as we work towards achieving our goal, your satisfaction. This way, all services will be delivered accurately and on time.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages