Development of analytical, data visualization and reporting
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
Development of analytical, data visualization and reporting
Data Analysis and Visualization
Spring 2019
Preferred method of communication is Blackboard E-mail if you haven’t heard back from me within 24 hours, please feel free to resend your email in case the first has gotten lost or corrupted. If you use UALR email, make sure that you put “BINS 3352” in the subject line.
Course Description:
Development of analytical, data visualization and reporting, and collaboration skills necessary for success in a data-driven business environment. Focus on cutting-edge technologies in a business context.
Course Prerequisites:
IT Competency Exam. You will not receive graduation credit for this course unless you have completed 54 hours of credit and the course prerequisites prior to enrolling in this course.
Course Materials (Required Texts/Software):
- Parsons, J., Oja, D., and Carey, P. (2016). New Perspectives Office 365 and Excel 2016 Comprehensive. Cengage. ISBN # 9781305880405
- Shaffer, A. and Pinard, K. (2016). New Perspectives Office 365 and Word 2016 Introductory. Cengage. ISBN #9781305880955
- SAM for Microsoft Office 365 and Office 2016 (Assessment Training and Projects). Cengage (e-training package). ISBN #9781305885172
- Office 365 Pro Plus with 2016 Apps (64-bit version). Available for download FREE from
UALR
NOTE: Since this course uses Cengage textbooks, a VERY discounted purchasing plan is available for you ( https://www.cengage.com/unlimited ). You can purchase Cengage Unlimited at $119.99 (for 4 months) and have access to all your Cengage online textbooks and electronic companions, such as SAM, which is required for this course. Each access code entitles you to RENT ONE print textbook for $7.99 + free shipping.
Page 1 of 8
You can also purchase the Cengage Unlimited Code from UALR bookstore. When you access SAM (see instructions in Blackboard), register with “Wang – BINS 3352 03 (Spring 2019)” using your purchased code. You should rent the Excel book (for $7.99) since you will need the print copy as you work through the course. You can use the digital copy of the Word book, which we will not use too much.
Course Objectives:
Upon completion of the course, students are expected to be able to:
- To effectively design spreadsheets for long-term viability
- To apply Excel functions and analysis tools to business problem solving and critical thinking scenarios
- To use advanced Excel tools for data analysis
- To critically analyze appropriateness of data analysis techniques
- To use visualization tools for business communication and reporting
- To communicate effectively in a virtual environment
Tentative Course Schedule:
Development of analytical, data visualization and reporting
Week Date Topic Notes 1 1/22 Introduction Read EX M1 1/24 Getting Started with Excel 2 1/29 Formatting Workbook Text and Data (1) Read EX M2.1; HW1 available 1/31 Formatting Workbook Text and Data (2) Read EX M2.2 2/5 Calculating Data with Formulas and Read EX M3.1; Functions (1) HW1 due; HW2 available 3 2/7 Calculating Data with Formulas and Read EX M3.2 Functions (2) 2/12 Analyzing and Charting Financial Data (1) Read EX M4.1; 4 HW2 due; HW3 available 2/14 Analyzing and Charting Financial Data (2) Read EX M4.2 2/19 Working with Excel Tables, PivotTables, Read EX M5.1/2; and PivotCharts (1) HW3 due; HW4 available 5 2/21 Working with Excel Tables, PivotTables, Read EX M5.2/3 and PivotCharts (2) 2/26 Managing Multiple Worksheets and Read EX M6.1/2; Workbooks (1) HW4 due; HW5 available 6 2/28 Managing Multiple Worksheets and Read EX M6.2/3 Workbooks (2) 7 3/5 Developing an Excel Application (1) Read EX M7.1/2; HW5 due 3/7 Mid-term Exam Review 8 3/12 Midterm Exam 3/14 Developing an Excel Application (2) Read EX M7.2/3; HW6 available 9 3/19 Spring Break – No classes 3/21 3/26 Working with Advanced Functions (1) Read EX M8.1/2; 10 HW6 due; HW7 available 3/28 Working with Advanced Functions (2) Read EX M8.2/3 11 4/2 Exploring Financial Tools and Functions (1) Read EX M9.1/2; HW7 due; HW8 available Page 2 of 8
4/4 Exploring Financial Tools and Functions (2) Read EX M9.2/3 4/9 Performing What-If Analyses (1) Read EX M10.1/2; 12 HW8 due; HW9 available 4/11 Performing What-If Analyses (2) Read EX M10.2/3 4/16 Analyzing Data with BI (1) Read EX M11.1/2; 13 HW9 due; HW10 available 4/18 Analyzing Data with BI (2) Read EX M11.2/3 4/23 Creating a Document Read WD M1 14 HW10 due; Project available 4/25 Formatting a Document Read WD M2 15 4/30 Creating Tables and a Multipage Report Read WD M3 5/2 Final Exam review Project due (5/9/19) 16 5/14 Final Exam Note that : HW assignments and deadlines are subject to changes. Please follow the deadline posted along with each assignment.
Course Evaluation and Grades:
Grades will be assessed on required activities throughout the semester. These include 10 homework assignments, 1 project, and the midterm and final exams as well as class participation. The weight of each item reads as follows:
Item Weight Homework assignments 40% Project 10% Class participation 5% Midterm exam 20% Final exam 25% Grade Scale:
A: 90~100%, B: 80~89%, C: 70~79%, D: 60~69%, F: ≤ 59
Your final grade will be based on the total points earned on the above listed items. The final grading scale may be curved. The instructor may choose to modify the policy depending on the class average and variance (i.e., exceptionally good/poor performance).
Course Requirements:
Class Participation is expected. Attendance will be taken each class. In case you have to miss a class, a request with a valid reason should be sent to the instructor before the class. Students are responsible for being aware of all the announcements, requirements and deadlines. Missing a class without a proper reason will result in losing class-participation points.
Assignments: your homework has to be based on your individual efforts! Discussion for the purpose of understanding a problem is encouraged. However, any solution must be your own and original work. Copying others’ work or materials on the Internet is not allowed. Late submissions will result in a 20% penalty per day up to 3 days after the due date.
Page 3 of 8
NOTE : When completing SAM projects, you must complete the project using the file you download from your SAM account. If you upload for grading a file downloaded by another student, the submission will be flagged; you will receive no credit. Using another student’s file is cheating!
Project: this is a mini-project for each individual student. Each student will be asked to develop an Excel application and write a short report. Any solution must be your own and original work. Since the project is due by the end of the semester, NO late submissions will be accepted.
Exams: A make-up exam can be requested in case of illness, mandatory religious obligations, or other unavoidable or special circumstances. Please see the instructor to discuss any special circumstances. You must receive permission to take an exam at a different time at least two weeks prior to the scheduled exam date, or have a documented and verifiable emergency. Another exam/project in the same week will not be considered a special circumstance. No make-up exam will be given after the scheduled exam date.
Students who need extra time or special testing procedures due to a disability or language barrier must make prior arrangements with the instructor.
Course Expectations:
The following ground rules will help your work in this course to go much more smoothly. Please carefully review these expectations and follow them.
- Academic integrity will be appraised according to the student academic behavior standards outlined in University Policies, Rules and Regulations of University of Arkansas at Little Rock’s Student Handbook. See http://www.ualr.edu/deanofstudents for further details;
- Keep up with your assignments and project. Please read the chapter assigned for each class prior to the class, and meet the deadlines for all assignments and the project. Students who keep up tend to perform much better in the class;
- Don’t miss an exam. Missed exams will not be retaken unless prior arrangements have been made with the instructor;
- All cell phones should be off or on silent mode in class, and no smart phones can be used for any in-class exams;
- For email communication, please include the course number (BINS 3352) in the subject line. Emails without the course number in the subject line may result in late response;
- You are expected to be in attendance for the duration of each class unless you have obtained prior permission from the instructor.
Page 4 of 8
Integrity Statement:
Academic Integrity and Grievance Policy. The university has developed certain regulations to make possible an orderly academic environment where all members of the community have the freedom to develop to the fullest extent. Academic dishonesty cannot be condoned or tolerated in the university community. Such behavior is considered a student conduct violation and students found responsible of committing an academic offense on the campus, or in connection with an institution-related or sponsored activity, or while representing the university or academic department, will be disciplined by the university. Students may not gain undue advantage over their classmates by deceptive or dishonest means.
Throughout their education, students should be impressed with the facts that cheating, duplicity, unauthorized reproduction of classroom materials, and plagiarism are morally degrading and that such practices seriously interfere with learning and intellectual development. It is a responsibility of faculty members to make every effort to prevent dishonesty, protect honest students, and take appropriate action in instances of dishonesty.
It is the responsibility of the student not only to abstain from cheating, but in addition to avoid the appearance of cheating and to guard against making it possible for others to cheat. Courtesy and honesty require that any ideas or materials borrowed from another must be fully acknowledged. It is the obligation of each student to report all alleged violations of academic integrity to the dean of students or designee.
Students may not reproduce, in whole or in part, classroom lectures or study materials presented by a professor without specific advance approval by the professor. Publication of any such material shall only be with the express consent of the professor.
The determination that a student’s work was the result of dishonest action can be considered in the faculty member’s evaluation of that work and in the determination of the course grade. In addition, disciplinary action will be taken by the appropriate university official, e.g., dean of students, or by the Academic Integrity and Grievance Committee.
Academic Offenses. University regulations regarding academic dishonesty, as set forth in the UALR student handbook and other university documents and publications will be strictly enforced in this class. In accordance with Section VI: Statement of Student Behavior, under the code of student rights, responsibilities, and behavior, the university defines academic offenses under the
Page 5 of 8
NOTE : Academic dishonesty in this class may result in disciplinary sanction and WILL be reported to the office of the dean of students.
Cheating on an examination or quiz: Cheating is defined as to give, receive, offer, or solicit information on any quiz or examination. This includes the following classes of dishonesty:
- Copying from another student’s paper;
- Use during the examination of prepared materials, notes, or text other than those specifically permitted by the professor;
- Collaboration with another student during the examination;
- Buying, selling, stealing, soliciting, or transmitting an examination, or any material purported to be the unreleased content of a coming examination, or the use of such material;
- Substituting for another person during an examination or allowing such substitution for oneself;
- Bribery of any person to obtain examination information.
Plagiarism: Plagiarism is to adopt and reproduce as one’s own, to appropriate to one’s own use and incorporate in one’s own work without acknowledgement, the ideas or passages from the writings and works of others. If you use someone else’s words or ideas without crediting them, you a committing plagiarism. To avoid plagiarism, simple cite the work used and, if directly quoting something, put quotation marks and the page number. See Purdue OWL https://owl.english.purdue.edu/owl/section/2/ and videos about specific topics at https://www.youtube.com/user/OWLPurdue.
Collusion: Collusion is to obtain from another party, without specific approval in advance by the professor, assistance in the production of work offered for credit to the extent that the work reflects the ideas or skills of the party consulted rather than those of the person in whose name the work is submitted.
Duplicity: Duplicity is to offer for credit identical or substantially unchanged work in two or more courses without specific advance approval of the professor(s) involved.
NOTE: Sharing homework files whether they are complete or works in process that are not your own is considered cheating. You may discuss homework and help each other; but the assignments submitted must have been totally completed yourself (all text/data/formulas keyed by YOU!).
When completing SAM projects, you must submit your own file; if the file has been previously submitted by another student, it will be marked for “cheating.” When you complete projects or take exams for which you are provided a file, you must complete all work on that file and resubmit that file for grading.
Page 6 of 8
On exams you should seek/get assistance from NO ONE — this policy includes using any previously prepared files, getting tutoring relating to the exam, etc. Exams must be all your own work. No exceptions.
Nondiscrimination:
UALR adheres to a policy that enables all individuals, regardless of race, color, gender, national origin, age, sexual orientation, veteran’s status, or disability to work and study in an environment unfettered by discriminatory behavior or acts. Harassment of an individual or group will not be condoned and any person – student, faculty, or staff member – who violates this policy will be subject to disciplinary action.
Inclement Weather Policy:
During inclement weather, UA Little Rock will make a decision whether or not to close based on all available information.
- The chancellor will decide whether or not conditions warrant canceling classes and activities and closing the campus or whether classes and activities will be canceled but with specified campus offices open. Online or web-enhanced classes will continue as scheduled at the discretion of the faculty member.
- When necessary, the university will announce a separate decision about canceling night classes (those classes starting at 4:20 p.m. or later) by 2 p.m., if possible.
- Ordinarily, sites remote from campus such as the the Bowen Law School, the Arkansas Studies Institute, and the Benton Center will close or cancel classes and activities whenever the university does so. In some circumstances, however, a separate decision may be made whether or not a site remote from campus will be open or closed, and this decision will be announced through the university’s official means of communicating weather-related closings.
- Vice chancellors are responsible for seeing that necessary services are provided in their respective areas when the university is closed. Employees required to provide such services will be identified by their supervisors. Classified employees who must report to work when
Page 7 of 8
the university is closed due to inclement weather will be allowed compensation time of 1.5 hours for one hour worked. Persons who are not required to work when the university is closed will be granted authorized absence. Employees who do not report to work when the campus is open will be charged annual/compensatory leave or leave without pay. The Payroll Department will prescribe payroll reporting and timekeeping.
- The Policy Advisory Council of the University Assembly will recommend to the chancellor if and when missed undergraduate and graduate class days should be made up. In the event that the university is closed during a final examination day, the provost, in consultation with the Faculty Senate president, will reschedule any missed graduate or undergraduate final examinations with the exception of online exams which will continue as scheduled.
- Weather and road conditions vary from place to place. Employees and students are expected to exercise good judgment regarding the safety of travel when road conditions are affected by the weather.
Development of analytical, data visualization and reporting
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