Workshops Chair: Jeffry Babb
West Texas A&M University
(ordered by presentation time)
Exposing Students to Big Data: Hands-on Market Basket Analysis with Access
Thursday - 11/1/2012 in Bienville Room at 2:00 pm
Market Basket/Affinity Analysis2 can be used to help retailers identify products purchased together where the association might not be obvious, i.e., hidden associations. These discoveries can be used to better understand consumer behavior to drive the sale of associated items.
In our Market Basket Analysis (MBA) activity,4 students engage in data mining3 where marketing knowledge is discovered by transforming large amounts of transaction data into association rules. While such activities might be common in a Data Mining course, our MBA activity is appropriate for an introductory business database, computer applications, or management information systems course. Our MBA activity can be performed using only the query design tool in Microsoft Access where knowledge of SQL is not a prerequisite. We use a publicly available retail database where the Apriori Algorithm1 allows for the computation of itemset quadruples that would otherwise be intractable. Thus, students see the importance of pruning in efficiently handling big data.
Using a worksheet activity, we briefly review MBA concepts including itemsets, association rules, support, confidence, and quality. Then, using Access (hands-on), we guide participants through an MBA activity using a database with over 900,000 rows. We also present an alternative, SQL-based approach to creating itemsets and association rules. We provide enough detail so instructors can adapt our activity to different settings. In a lecture, instructors can use the worksheet to engage students and then demonstrate the MBA activity. In a lab, novice students can conduct the activity using step-by-step instructions, or advanced students can independently create many of the queries using less detailed instructions, in either the SQL or non-SQL scenario. The worksheet, instructions, and database will be available to participants, who should bring a laptop running Access 2007/2010, or be able to share such with at most one other attendee.
Teaching Methods for Some Very Complex Excel Functions
Thursday - 11/1/2012 in Bienville Room at 4:00 pm
Developing expertise with Excel can be non-trivial, to say the least. Some instructors simply list functions on the board and consider their teaching of the technology to be complete. This seems to be the practice, rather than the exception, with business instructors in general and there is some evidence to suggest that it is commonplace in other disciplines. This workshop will inform the instructor in some well-tested methods for bringing clarity to a number of the more complex Excel functions such as nested IF statements, VLOOKUP versus the INDEX and MATCH functions, pivot tables, and string manipulation. It is this last item that is outstanding in its power to clean data for either analysis in Excel or to import to a database table. You will learn methods that have proven themselves to be very successful in the classroom for parsing data that cannot be handled using the Text to Columns button in the Data tab of Excel. String manipulation will include LEFT, RIGHT, MID, LEN, FIND, and SUBSTITUTE. When I have visited corporations (profit as well as non-profit) I have found that it is not uncommon to for needed data not to be properly used because it is in a format that the uninformed cannot parse. At the conclusion of this workshop you will have the necessary skills to teach students how to manage these complex operations. If time permits, we will also discuss array functions, a quick way of handling complex calculations with ease.
New Digital Learning Platforms and Opportunities
Beth Lang Golub
John Wiley & Sons, Inc.
Friday - 11/2/2011 in Bienville Room at 9:30 am
Students and professors are moving to online content solutions at an increasing rate. Ebook platforms and the variety of devices are proliferating quickly. Publishers are under intense pressure from local, state and the federal government to lower the price of course materials. These and related issues are providing complexity, challenges, and opportunity to the higher education publishing industry.
Wiley is working on many fronts to keep costs and prices down. Initiatives include sending out complimentary review copies in digital format (via CourseSmart) and offering a broad range of options to students including printed loose-leaf and custom books and a variety of digital formats including CourseSmart, VitalSource, and WileyPLUS.
Wiley is exploring new online models for delivering content and services that meet the needs of professors and students. Wiley is developing new distribution models and building relationships with new technology partners. I will discuss some of the new models and provide an overview of the issues in the quickly changing publishing environment. We will also brainstorm ideas on the kinds of learning resources that professors would like to see included in the new digital platforms for IS courses.
EMC Academic Alliance – Educating Future IT Professionals
Friday - 11/2/2011 in Bienville Room at 10:00 am
Learn how you can enhance student career prospects in the world of IT through the Academic Alliance. The program offers colleges and universities around the globe unique ‘open’ curriculum-based education, such as information storage and management, cloud computing and big data analytics. The courses focus on technology concepts and principles applicable to any vendor environment. The goal is to prepare graduates to fully leverage enhanced and emerging technologies in virtualized and cloud environments. There is no cost to institutions to join the program and members receive numerous benefits including: faculty training, course materials, and secure web portals for faculty and students.
Developing Problem Solving Skills and Critical Thinking – with a focus on Case Studies
Friday - 11/2/2011 in Bienville Room at 10:45 am
“Critical thinking is the intellectually disciplined process of actively and skillfully conceptualizing, applying, analyzing, synthesizing, and/or evaluating information gathered from, or generated by, observation, experience, reflection, reasoning, or communication, as a guide to belief and action. In its exemplary form, it is based on universal intellectual values that transcend subject matter divisions: clarity, accuracy, precision, consistency, relevance, sound evidence, good reasons, depth, breadth, and fairness.” (from: http://www.criticalthinking.org/pages/defining-critical-thinking/766)
As Information Systems educators, we want our students to be able to think critically and to analyze and solve problems. There are ways to challenge students to think critically. One of the most popular is to use case studies.
In this workshop we will:
- Explore problem solving and critical thinking through a variety of techniques
- Discuss case studies as problem solving and critical thinking activities
- Analyze sample IS/IT case studies
- Entire group to dissect and analyze a sample case
- Split group into subgroups to analyze two additional cases
- Bring groups together to discuss their approaches
- Discuss where to use case studies in Information Systems classes
- Present several additional IT cases as samples for classroom instruction
- Discuss assigning students in a class to write their own cases as an instructional activity
- Conclude with a discussion on case study methods, approaches and use in classes
Computer Literacy Assessment for Student Placement & Course Development
Friday - 11/2/2011 in Bienville Room at 2:00 pm
An overview of Labyrinth’s eLab Assessment tool and its use for optimal course placement and the identification of students lacking critical skills for success in online courses.
SimNet/SimGrader Microsoft Office
McGraw Hill Higher Education
Friday - 11/2/2011 in Bienville Room at 2:30 pm
Demo of how our online Microsoft Office product works (SimNet). Showing a bit of Word, Excel, Power point, and etc. How it can have a SSO with all LMS’s
NetApp: IT Trends and the Implications for Information Systems Education
Ball State University
Friday - 11/2/2011 in Bienville Room at 3:00 pm
Topics covered or Session Overview:
•Industry IT trends and best practices
•Data growth/volumes & Big Data
•IT / IS curriculum
•Storage and data management
•Shared services and agile data infrastructures
•Strategies for infusing storage & data management into IS programs & courses
There is a data explosion underway that is fundamentally changing how data is stored, managed and preserved. Data volumes in terabytes and petabytes are now common; it is exabytes and zettabytes that are the new challenge. At the same time, the compelling economics of shared services solutions such as cloud computing and virtualization are transforming how IT services are managed and delivered. Cisco’s 2011 Global Cloud Index study estimates that 50% of IT workloads will be processed “in the cloud” by 2014- just two years away.
There is a fundamental shift underway as to how enterprise IT services are being designed and delivered, and this shift has major ramifications on how the next generation of IT staff and leaders should be educated. The skills and technologies that IT-savvy graduates need to understand are evolving rapidly, as are the topics and technologies that Information Technology/MIS programs need to cover. While these new solutions & technologies are being adopted widely by CIOs and businesses world-wide, many schools’ IT-focused programs have been slow to update their courses to reflect the changing IT landscape and to prepare their students for today’s cloud-centric /storage-intensive computing environments.
Please plan to join this session to learn more about the shared-services paradigm shift in IT, and how NetApp’s innovative industry-academic partnership program is working with faculty members to jump start a curriculum refresh discussion, and develop the next generation of IT leaders.
•Access to commercial web-based training resources
•Specific opportunities for professional development
•Pre-packed “teaching modules” to facilitate introducing more storage content
•A community of colleagues interested in sharing ideas and teaching resources
Geographic Information Systems:
A Hands on Introduction
Friday - 11/2/2011 in Bienville Room at 3:45 pm
Information Systems involve the application of computing to the problems of organizations. Geographic Information Systems are characterized by spatial objects that have locations (e.g. addresses, landmarks, geopolitical boundaries, etc.) and data associated with them (e.g. demographic information, value, etc.).
GIS systems, emerging applications and research involves solving problems which ask IS related questions about geospatial information and are applied in many situations including Security, Customer Analysis, Market Analysis, Site Selection, etc.
Technology impacts include databases, data mining, project management, network and web development analysis and performance.
This workshop will give a hands-on overview of GIS using a variety of freely available tools and web-based datasets to give participants the knowledge needed to understand the geospatial research potential and get started developing their own applications.
Participants with laptops will create their own GIS application.
This workshop complements the new formed special interest group, SIGGIS.
1. Overview of GIS Concepts
2. GIS Databases and Sources
3. Spatial Analysis
4. GIS and the Web
Data Mining Methods Workshop Using R
West Texas A&M University
West Texas A&M University
West Texas A&M University
Saturday - 11/3/2011 in Bienville Room at 9:15 am
Data Mining is the process of extracting valid, authentic and “ACTIONABLE” information from large data sets for the purpose of decision support. It is a combination of theories, practices and techniques from Machine learning, Statistics, Information Theory and Computer Science..
A Strategic Course Redesign to Hybrid Format Using Online Technologies
Saturday - 11/3/2011 in Bienville Room at 9:45 am
This workshop includes an analysis of a course redesign from face-to-face to hybrid format, a discussion of best practices in online teaching, a demonstration of an online classroom using various online technologies, and a case study synopsis of implementing the redesigned course. The course used was a mid-level overview of management information systems. The redesign used L. Dee Fink’s Creating Significant Learning Experiences, and D. Randy Garrison & Norman D. Vaughan’s Blended Learning in Higher Education, as well as best practices from SLOAN-C Consortium: Applying the Quality Matters Rubric to your Online Course. Major design principles used in the course established three teaching presences, introduced caring as a focus leading to critical thinking to understand decision-making, helped students learn how to learn, honored web accessibility, increased group collaboration, and reduced counterproductive behaviors such as cheating. Students used document sharing, forums, chat, wikis, polls, peer review, avatars, images, videos, and voice technology. Many technological concepts are abstract, particularly at the organizational or complex systems level, and students often struggle with synthesizing the components. The hybrid redesign enabled students to bridge their understanding into deeper levels of meaning as well as learned how to collaborate more effectively.
HTML 5: An Overview and Demonstration of the Latest in Web Technology.
West Texas A&M University
Saturday - 11/3/2011 in Bienville Room at 11:00 am
This workshop will demonstrate many of the new features and capabilities of HTML5 including canvas, drag & drop, geolocation, and new multimedia elements.
HTML5 is the fifth revision of the HTML standard and perhaps the most substantial. Even though it is still under development, it is supported by most web browsers and many websites make use of HTML5 features. Many of the HTML5 features that will be discussed and demonstrated in this workshop are what make web apps like Google's GMail, Google Docs, Facebook, and Amazon so rich and useful.
In addition to demonstrating the state of the art in HTML, we hope this workshop will give the audience ideas and tips to incorporate elements of HTML5 into their curriculum as it is almost a requirement now in industry for websites (and mobile websites/apps) to make use of HTML5.
Becoming "AGILE" with Teaching Systems Analysis and Design
Dakota State University
Dakota State University
Dakota State University
Saturday - 11/3/2011 in Bienville Room at 2:15 pm
For many years the perceived correct way to teach systems analysis and design has been through the traditional approaches and methodologies that have been derived from the Waterfall approach. The Waterfall methodology is not broken, it still works very well. It is just that the next generation of developers may need to be more agile in how they develop software solutions through streamlining the system development life cycle.
The purpose of the workshop would be to discuss the development of a curriculum that would focus on teaching programming-centric methodologies where modeling and documentation overhead are eliminated and face-to-face is the preferred communication route. According to Alan Dennis of Indiana University, Barbara Haley Wixom of the University of Virginia, and Roberta M. Roth of the University of Northern Iowa, “Agile development practices were created in part because of dissatisfaction with the sequential, inflexible structure of waterfall-based approaches.”
Studies are showing that Agile is making large gains in the development world, and are nearing an even split with waterfall.
Based on this assumption, I would propose to create a workshop that would model a curriculum for a three credit undergraduate class, and open for discussion concepts of best practices from interested participants in creating the curriculum as well as content for such a class.