excel and tableu
fahadhero
mis_course_assignments.docxAll assignments must be turned in with the file name of your “lastname_firstname_assignment” (e.g. Judge_Robert_cognitive map). A minimum of 10 points will be deducted for each assignment that this is not followed. Late is late for assignments – no partial points, no makeup!
Use data from the 3 tables found in the attached Excel spreadsheet to create a Pivot Table and answer the following:
Sales $ per State Sales $ per Category Sales per employee by State Import the three tables into Access and answer the same questions
SUBMIT both the Excel file with the pivot table answers and the Access file with the queries together at the same time.
Submit files with named as: Last Name_First Name_Excel and Last Name_First Name _Access
Excel and Access practical business analysis (detailed instructions will be provided through Blackboard and in class). The Excel portion requires you to activate macros so that a dialog box appears for you to enter your Name and Red-id appears. If the dialog box does not appear for you, change your macro security settings or use a school computer. See me if still a problem. Failure to enter such information will result in a loss of a minimum of 50% of the possible points. The Access database must be saved as a .mdb or .accdb file. If saved as a file type .laccdb, you will lose a minimum of 50% of the possible points.
Visio Process Flow Video
Example of a Visio Chart
C:\Users\User\Desktop\Amazon ordering to receiving(1).vsd
Excel Assignment
2- Tableau: Data Visualization Assignment
This is Free Tableau link: http://www.tableau.com/academic/students
Use data from the 3 tables found in the Excel spreadsheet (previous assignment - complete both Excel and Access portion first) to create a dashboard with 3 charts in Tableau that visualize the answers to the following: Sales $ per State Sales $ per Category Sales per employee by State
Submit file as LastName_FirstName_Tableau (BE SURE TO SAVE AS a .twbx file type)
Tableau visual data analysis. Failure to "Save as" a Tableau Workbook Package (.twbx) will result in a loss of a minimum of 50% of the points. You will create 3 charts and a dashboard. 20 points will be awarded for accomplishing this correctly. Up to an additional 5 points extra credit will be awarded for using special features of Tableau to make it easy for the user to select out a subset of the data to emphasize.
Tableau “How to Video”
https://blackboard.sdsu.edu/bbcswebdav/pid-2977320-dt-content-rid-56389756_1/courses/MIS180-06-Fall2016/MIS180-06-Spring2015_ImportedContent_20150114031626/TableauAssignmentProject.mp4
3- Cognitive Map Assignment
Produce a Cognitive Map on a provided MIS topic area (see list of topics below): Expectations (low "B"), are that the map will have a minimum of:
0. 50 child nodes (content)
0. 10 hyperlinks
0. 10 notes
0. Some structure: Color, fonts, clouds, etc.
Suggested Topics for Cognitive Map Assignment:
· Cloud computing
· Outsourcing MIS
· RSS Feeds
· Security
· Social Networking (Blogs, Forums, Communities of Practice)
· Simulation
· Search engines
· Robotics
· Data Mining
· Enterprise Resource Planning (ERP)
· Knowledge management
· Decision Support Systems (DSS)
· Virtual communities
· Nanotechnology
· Sensor technology & networks
· Open source software
· Peer to Peer networks
· Web 2.0
· Communication technologies
· Server Virtualization
· Client Virtualization
· Sustainability (environmental efforts related to MIS)
· Agile programming methodology vs. Waterfall methodology
· Semantic web
· Quantum computing
· Encryption
· Worms & Trojan Horses
· MIS workplace productivity improvements (Economics)
· MIS labor market analysis
· Technology acceptance models (TAM, UTAUT, etc.)
· HCI (Human Computer Interface)
· CMMI, COBIT, ITIL
Cognitive Mapping Video
https://blackboard.sdsu.edu/bbcswebdav/pid-2977321-dt-content-rid-56389757_1/courses/MIS180-06-Fall2016/MIS180-06-Spring2015_ImportedContent_20150114031626/CognitiveMapping%281%29.mp4
