We\u00a0have\u00a0another\u00a0set\u00a0which\u00a0could\u00a0be\u00a0found\u00a0on\u00a0this\u00a0link\t\u00a0\thttp:\/\/www.snaptutorial.com\/INF-103\/INF-103-Week-3-Assignment–Using-Microsoft-Excel–%28Personal-Vs-Actual%29\t\u00a0\t\u00a0\tUsing\u00a0Microsoft\u00a0Excel.\tPlagiarism,\u00a0whether\u00a0intentional\u00a0or\u00a0unintentional,\u00a0is\u00a0a\u00a0big\u00a0problem\u00a0for\u00a0universities.\u00a0Not\u00a0only\u00a0is\u00a0it\u00a0an\u00a0issue\u00a0of\u00a0unfair\u00a0use\u00a0of\u00a0copyrighted\u00a0material,\tit\u00a0speaks\u00a0to\u00a0an\u00a0ethical\u00a0issue\u00a0of\u00a0cheating.\u00a0(Please\u00a0refer\u00a0to\u00a0the\u00a0Microsoft\u00a0Excel\u00a0tutorials\u00a0in\u00a0the\u00a0appendices\u00a0of\u00a0the\u00a0Constellation\u00a0text.)\tConsider\u00a0the\u00a0following\u00a0statistics.\u00a0According\u00a0to\u00a0the\u00a0plagiarism.org\u00a0(2013),\u00a0a\u00a0survey\u00a0conducted\u00a0by\u00a0Donald\u00a0McCabe\u00a0between\u00a02002\u00a0and\u00a02005\u00a0that\u00a0\tincluded\u00a063,700\u00a0US\u00a0undergraduates\u00a0and\u00a09,250\u00a0graduate\u00a0students\u00a0revealed\u00a0the\u00a0following\u00a0data:\t36%\u00a0of\u00a0undergraduate\u00a0and\u00a024%\u00a0of\u00a0graduate\u00a0students\u00a0admit\u00a0to\u00a0“paraphrasing\/copying\u00a0few\u00a0sentences\u00a0from\u00a0Internet\u00a0source\u00a0without\u00a0footnoting\u00a0it.”\ufffd\t38%\u00a0of\u00a0undergraduate\u00a0and\u00a025%\u00a0of\u00a0graduate\u00a0students\u00a0admit\u00a0to\u00a0“paraphrasing\/copying\u00a0few\u00a0sentences\u00a0from\u00a0written\u00a0source\u00a0without\u00a0footnoting\u00a0it.”\ufffd\t14%\u00a0of\u00a0undergraduate\u00a0students\u00a0and\u00a07%\u00a0of\u00a0graduate\u00a0students\u00a0admit\u00a0to\u00a0“fabricating\/falsifying\u00a0a\u00a0bibliography.”\ufffd\t7%\u00a0of\u00a0undergraduate\u00a0and\u00a04%\u00a0of\u00a0graduate\u00a0students\u00a0self-report\u00a0copying\u00a0materials\u00a0“almost\u00a0word\u00a0for\u00a0word\u00a0from\u00a0a\u00a0written\u00a0source\u00a0without\u00a0citation.”\ufffd\t7%\u00a0of\u00a0undergraduate\u00a0and\u00a03%\u00a0of\u00a0graduate\u00a0students\u00a0self-report\u00a0“turning\u00a0in\u00a0work\u00a0done\u00a0by\u00a0another.”\ufffd\t3%\u00a0of\u00a0undergraduate\u00a0and\u00a02%\u00a0of\u00a0graduate\u00a0students\u00a0report\u00a0“obtaining\u00a0paper\u00a0from\u00a0term\u00a0paper\u00a0mill.”\ufffd\tIn\u00a0Excel,\u00a0create\u00a0a\u00a0worksheet\u00a0that\u00a0addresses\u00a0the\u00a0following:\tIn\u00a0cell\u00a0A1,\u00a0enter\u00a0the\u00a0following\u00a0title\u00a0for\u00a0this\u00a0worksheet:\u00a0Student\u00a0Plagiarism\u00a0Statistics.\tIn\u00a0cell\u00a0A3,\u00a0enter\u00a0the\u00a0following:\u00a0Form\u00a0of\u00a0Plagiarism.\tIn\u00a0cell\u00a0B3,\u00a0enter\u00a0the\u00a0following:\u00a0Undergraduate.\tIn\u00a0cell\u00a0C3,\u00a0enter\u00a0the\u00a0following:\u00a0Graduate.\tIn\u00a0cell\u00a0D4,\u00a0enter\u00a0the\u00a0total\u00a0number\u00a0of\u00a0undergraduate\u00a0students\u00a0that\u00a0participated\u00a0in\u00a0the\u00a0study\u00a063,700.\tIn\u00a0cell\u00a0E4,\u00a0enter\u00a0the\u00a0total\u00a0number\u00a0of\u00a0graduate\u00a0students\u00a0that\u00a0participated\u00a0n\u00a0the\u00a0study\u00a09,250.\tBeginning\u00a0in\u00a0cell\u00a0A5,\u00a0enter\u00a0each\u00a0of\u00a0the\u00a0six\u00a0categories\u00a0of\u00a0plagiarism\u00a0identified\u00a0by\u00a0this\u00a0report,\u00a0one\u00a0in\u00a0each\u00a0row.\u00a0(These\u00a0categories\u00a0are\u00a0found\u00a0under\u00a0the\u00a0“Academic\u00a0Integrity\u00a0in\u00a0College\u00a0and\u00a0Graduate\u00a0School”\ufffd\u00a0section\u00a0showing\u00a0the\u00a0results\u00a0of\u00a0the\u00a0survey\u00a0done\u00a0by\u00a0Donald\u00a0McCabe.)\tBeginning\u00a0in\u00a0cell\u00a0B5,\u00a0calculate\u00a0the\u00a0number\u00a0of\u00a0students\u00a0that\u00a0admitted\u00a0to\u00a0each\u00a0offense.\u00a0To\u00a0do\u00a0this,\u00a0you\u00a0will\u00a0need\u00a0to\u00a0calculate\u00a0the\u00a0number\u00a0of\u00a0students\u00a0based\u00a0on\u00a0the\u00a0percentage\u00a0provided.\tFor\u00a0example,\u00a0if\u00a0there\u00a0were\u00a063,700\u00a0undergraduate\u00a0students\u00a0that\u00a0participated\u00a0in\u00a0the\u00a0survey\u00a0and\u00a036%\u00a0admitted\u00a0to\u00a0paraphrasing\/copying\u00a0a\u00a0few\u00a0sentences\u00a0from\u00a0an\u00a0Internet\u00a0source,\u00a0then\u00a0that\u00a0would\u00a0mean\u00a0that\u00a022,932\u00a0students\u00a0admitted\u00a0to\u00a0the\u00a0offense\u00a0(63,700\u00a0*\u00a0.36).\u00a0Complete\u00a0these\u00a0calculations\u00a0for\u00a0all\u00a0six\u00a0categories.\u00a0Be\u00a0sure\u00a0to\u00a0enter\u00a0formulas\u00a0and\u00a0use\u00a0proper\u00a0cell\u00a0referencing,\u00a0e.g.\u00a0=\u00a0D4*.36\tCalculate\u00a0the\u00a0same\u00a0data\u00a0for\u00a0graduate\u00a0students\u00a0beginning\u00a0in\u00a0cell\u00a0C5.\tFormat\u00a0all\u00a0cells\u00a0with\u00a0the\u00a0appropriate\u00a0data\u00a0types.\u00a0Set\u00a0numeric\u00a0fields\u00a0with\u00a0no\u00a0decimals.\tOnce\u00a0you\u00a0have\u00a0completed\u00a0the\u00a0calculations,\u00a0select\u00a0the\u00a0data\u00a0cells\u00a0in\u00a0the\u00a0table\u00a0to\u00a0create\u00a0your\u00a0chart.\tCreate\u00a0a\u00a0chart\u00a0that\u00a0will\u00a0visually\u00a0depict\u00a0the\u00a0data,\u00a0in\u00a0a\u00a0way\u00a0that\u00a0makes\u00a0it\u00a0easy\u00a0to\u00a0see\u00a0the\u00a0largest\u00a0areas\u00a0of\tplagiarism\u00a0problems.\u00a0A\u00a0good\u00a0example\u00a0might\u00a0be\u00a0a\u00a0column\u00a0chart\u00a0that\u00a0shows\u00a0undergraduate\u00a0and\u00a0graduate\tdata\u00a0side\u00a0by\u00a0side.\u00a0The\u00a0choice\u00a0of\u00a0chart\u00a0is\u00a0your\u00a0own.\tFinalize\u00a0your\u00a0worksheet\u00a0by\u00a0making\u00a0sure\u00a0all\u00a0columns\u00a0are\u00a0formatted\u00a0to\u00a0accommodate\u00a0the\u00a0size\u00a0of\u00a0the\u00a0data.\tFormat\u00a0your\u00a0chart\u00a0as\u00a0needed\u00a0to\u00a0assure\u00a0that\u00a0the\u00a0chart\u00a0looks\u00a0clean\u00a0and\u00a0neat.\u00a0Be\u00a0sure\u00a0that\u00a0your\u00a0worksheet\tlooks\u00a0professional\u00a0and\u00a0polished.<\/p>\n","protected":false},"excerpt":{"rendered":"
We\u00a0have\u00a0another\u00a0set\u00a0which\u00a0could\u00a0be\u00a0found\u00a0on\u00a0this\u00a0link \u00a0 http:\/\/www.snaptutorial.com\/INF-103\/INF-103-Week-3-Assignment–Using-Microsoft-Excel–%28Personal-Vs-Actual%29 \u00a0 \u00a0 Using\u00a0Microsoft\u00a0Excel. Plagiarism,\u00a0whether\u00a0intentional\u00a0or\u00a0unintentional,\u00a0is\u00a0a\u00a0big\u00a0problem\u00a0for\u00a0universities.\u00a0Not\u00a0only\u00a0is\u00a0it\u00a0an\u00a0issue\u00a0of\u00a0unfair\u00a0use\u00a0of\u00a0copyrighted\u00a0material, it\u00a0speaks\u00a0to\u00a0an\u00a0ethical\u00a0issue\u00a0of\u00a0cheating.\u00a0(Please\u00a0refer\u00a0to\u00a0the\u00a0Microsoft\u00a0Excel\u00a0tutorials\u00a0in\u00a0the\u00a0appendices\u00a0of\u00a0the\u00a0Constellation\u00a0text.) Consider\u00a0the\u00a0following\u00a0statistics.\u00a0According\u00a0to\u00a0the\u00a0plagiarism.org\u00a0(2013),\u00a0a\u00a0survey\u00a0conducted\u00a0by\u00a0Donald\u00a0McCabe\u00a0between\u00a02002\u00a0and\u00a02005\u00a0that\u00a0 included\u00a063,700\u00a0US\u00a0undergraduates\u00a0and\u00a09,250\u00a0graduate\u00a0students\u00a0revealed\u00a0the\u00a0following\u00a0data: 36%\u00a0of\u00a0undergraduate\u00a0and\u00a024%\u00a0of\u00a0graduate\u00a0students\u00a0admit\u00a0to\u00a0“paraphrasing\/copying\u00a0few\u00a0sentences\u00a0from\u00a0Internet\u00a0source\u00a0without\u00a0footnoting\u00a0it.”\ufffd 38%\u00a0of\u00a0undergraduate\u00a0and\u00a025%\u00a0of\u00a0graduate\u00a0students\u00a0admit\u00a0to\u00a0“paraphrasing\/copying\u00a0few\u00a0sentences\u00a0from\u00a0written\u00a0source\u00a0without\u00a0footnoting\u00a0it.”\ufffd 14%\u00a0of\u00a0undergraduate\u00a0students\u00a0and\u00a07%\u00a0of\u00a0graduate\u00a0students\u00a0admit\u00a0to\u00a0“fabricating\/falsifying\u00a0a\u00a0bibliography.”\ufffd 7%\u00a0of\u00a0undergraduate\u00a0and\u00a04%\u00a0of\u00a0graduate\u00a0students\u00a0self-report\u00a0copying\u00a0materials\u00a0“almost\u00a0word\u00a0for\u00a0word\u00a0from\u00a0a\u00a0written\u00a0source\u00a0without\u00a0citation.”\ufffd 7%\u00a0of\u00a0undergraduate\u00a0and\u00a03%\u00a0of\u00a0graduate\u00a0students\u00a0self-report\u00a0“turning\u00a0in\u00a0work\u00a0done\u00a0by\u00a0another.”\ufffd 3%\u00a0of\u00a0undergraduate\u00a0and\u00a02%\u00a0of\u00a0graduate\u00a0students\u00a0report\u00a0“obtaining\u00a0paper\u00a0from\u00a0term\u00a0paper\u00a0mill.”\ufffd In\u00a0Excel,\u00a0create\u00a0a\u00a0worksheet\u00a0that\u00a0addresses\u00a0the\u00a0following: In\u00a0cell\u00a0A1,\u00a0enter\u00a0the\u00a0following\u00a0title\u00a0for\u00a0this\u00a0worksheet:\u00a0Student\u00a0Plagiarism\u00a0Statistics. In\u00a0cell\u00a0A3,\u00a0enter\u00a0the\u00a0following:\u00a0Form\u00a0of\u00a0Plagiarism. In\u00a0cell\u00a0B3,\u00a0enter\u00a0the\u00a0following:\u00a0Undergraduate. In\u00a0cell\u00a0C3,\u00a0enter\u00a0the\u00a0following:\u00a0Graduate. In\u00a0cell\u00a0D4,\u00a0enter\u00a0the\u00a0total\u00a0number\u00a0of\u00a0undergraduate\u00a0students\u00a0that\u00a0participated\u00a0in\u00a0the\u00a0study\u00a063,700. In\u00a0cell\u00a0E4,\u00a0enter\u00a0the\u00a0total\u00a0number\u00a0of\u00a0graduate\u00a0students\u00a0that\u00a0participated\u00a0n\u00a0the\u00a0study\u00a09,250. Beginning\u00a0in\u00a0cell\u00a0A5,\u00a0enter\u00a0each\u00a0of\u00a0the\u00a0six\u00a0categories\u00a0of\u00a0plagiarism\u00a0identified\u00a0by\u00a0this\u00a0report,\u00a0one\u00a0in\u00a0each\u00a0row.\u00a0(These\u00a0categories\u00a0are\u00a0found\u00a0under\u00a0the\u00a0“Academic\u00a0Integrity\u00a0in\u00a0College\u00a0and\u00a0Graduate\u00a0School”\ufffd\u00a0section\u00a0showing\u00a0the\u00a0results\u00a0of\u00a0the\u00a0survey\u00a0done\u00a0by\u00a0Donald\u00a0McCabe.) Beginning\u00a0in\u00a0cell\u00a0B5,\u00a0calculate\u00a0the\u00a0number\u00a0of\u00a0students\u00a0that\u00a0admitted\u00a0to\u00a0each\u00a0offense.\u00a0To\u00a0do\u00a0this,\u00a0you\u00a0will\u00a0need\u00a0to\u00a0calculate\u00a0the\u00a0number\u00a0of\u00a0students\u00a0based\u00a0on\u00a0the\u00a0percentage\u00a0provided. For\u00a0example,\u00a0if\u00a0there\u00a0were\u00a063,700\u00a0undergraduate\u00a0students\u00a0that\u00a0participated\u00a0in\u00a0the\u00a0survey\u00a0and\u00a036%\u00a0admitted\u00a0to\u00a0paraphrasing\/copying\u00a0a\u00a0few\u00a0sentences\u00a0from\u00a0an\u00a0Internet\u00a0source,\u00a0then\u00a0that\u00a0would\u00a0mean\u00a0that\u00a022,932\u00a0students\u00a0admitted\u00a0to\u00a0the\u00a0offense\u00a0(63,700\u00a0*\u00a0.36).\u00a0Complete\u00a0these\u00a0calculations\u00a0for\u00a0all\u00a0six\u00a0categories.\u00a0Be\u00a0sure\u00a0to\u00a0enter\u00a0formulas\u00a0and\u00a0use\u00a0proper\u00a0cell\u00a0referencing,\u00a0e.g.\u00a0=\u00a0D4*.36 Calculate\u00a0the\u00a0same\u00a0data\u00a0for\u00a0graduate\u00a0students\u00a0beginning\u00a0in\u00a0cell\u00a0C5. Format\u00a0all\u00a0cells\u00a0with\u00a0the\u00a0appropriate\u00a0data\u00a0types.\u00a0Set\u00a0numeric\u00a0fields\u00a0with\u00a0no\u00a0decimals. Once\u00a0you\u00a0have\u00a0completed\u00a0the\u00a0calculations,\u00a0select\u00a0the\u00a0data\u00a0cells\u00a0in\u00a0the\u00a0table\u00a0to\u00a0create\u00a0your\u00a0chart. Create\u00a0a\u00a0chart\u00a0that\u00a0will\u00a0visually\u00a0depict\u00a0the\u00a0data,\u00a0in\u00a0a\u00a0way\u00a0that\u00a0makes\u00a0it\u00a0easy\u00a0to\u00a0see\u00a0the\u00a0largest\u00a0areas\u00a0of plagiarism\u00a0problems.\u00a0A\u00a0good\u00a0example\u00a0might\u00a0be\u00a0a\u00a0column\u00a0chart\u00a0that\u00a0shows\u00a0undergraduate\u00a0and\u00a0graduate data\u00a0side\u00a0by\u00a0side.\u00a0The\u00a0choice\u00a0of\u00a0chart\u00a0is\u00a0your\u00a0own. Finalize\u00a0your\u00a0worksheet\u00a0by\u00a0making\u00a0sure\u00a0all\u00a0columns\u00a0are\u00a0formatted\u00a0to\u00a0accommodate\u00a0the\u00a0size\u00a0of\u00a0the\u00a0data. Format\u00a0your\u00a0chart\u00a0as\u00a0needed\u00a0to\u00a0assure\u00a0that\u00a0the\u00a0chart\u00a0looks\u00a0clean\u00a0and\u00a0neat.\u00a0Be\u00a0sure\u00a0that\u00a0your\u00a0worksheet looks\u00a0professional\u00a0and\u00a0polished.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-224882","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/224882","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=224882"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/224882\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=224882"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=224882"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=224882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}