×
Log in to StudySoup
Get Full Access to UT - ART_G 302 - Study Guide
Join StudySoup for FREE
Get Full Access to UT - ART_G 302 - Study Guide

Already have an account? Login here
×
Reset your password

UT / Management Information Systems / MIS 302F / How do i upgrade from excel 2013 to 2016?

How do i upgrade from excel 2013 to 2016?

How do i upgrade from excel 2013 to 2016?

Description

MIS 302F-WB (Online) –  Fall 2016


How do i upgrade from excel 2013 to 2016?



Title MIS 302F-WB Foundations of Information Technology  Management

Instructor Clint Tuttle

Email See contact policy below in Office Hours section

Office

Hours  

Technical  Support

Since this class is purely web-based, there are no scheduled “in person”  office hours. All questions (except those of a personal nature) should be  posted on the class Discussion Board (see the “Hoot.me” forum on the  course landing page or left menu bar) or via the Coil mobile app on your  phones. Hoot is based in Facebook and very effective to get answers quickly  from your teacher AND other students. Coil is a new mobile app that we are  piloting to allow more discussion via mobile devices. If you have a personal  question you can message the professor through Canvas but please do not  email professor or TA regarding things that can be answered on the  discussion board or Coil app. If a meeting is required, it will be conducted  through Skype or Google Hangout. Please allow at least 24 hours for email  replies from professor. Do not contact your professor with Tech Support  questions


Can google docs open office files?



Don't forget about the age old question of Identify your traits that you can transform into strengths and bring to a leadership role.

Call Canvas Support Center 24/7 @ 855-308-2494.  

Please do not contact professor with technical issues.

Course Description

Information Technology Management provides you with a broad view of how IT is transforming the world of business. Within this course you will work through real-world business cases and work situations to learn about the impact IT has on the business economy, and identify the critical skills that those working in IT need to possess. Finally, you will explore how IT intersects with functional areas in a business organization. This course will give you the introductory IT knowledge and skills professionals need within a business environment.

Course Outcomes - Upon successful completion of this course, you will be able to: • Explain the disruptive effect IT has on markets resulting in a transformation of the business economy.  


What are examples of assessments which help students learn?



•Summarize the characteristics of IT ecosystems and networks.

• Describe how network strategies and platform-based competition influence the economics of business.

•Analyze business data using common IT tools, methods, and skills.  •Predict how IT can influence and interact with different functional areas of an organization.

• Interpret the broader impact IT has on an organization’s global sourcing strategy and return on investment (ROI).

Course Times If you want to learn more check out Have you asked someone to proofread your essay?

This course never meets in person and has no scheduled lectures or exam but note that  there are deadlines. All deadlines are related to the unit quizzes and assignments are  listed below in the Course Schedule section

Accessing the Course

Log in to the learning management system, Canvas, at the following URL:  https://utexas.instructure.com/ 

Required Course Materials

1. There is no textbook for this course, only a course packet. Throughout the course, you1 

will be linked to numerous articles and readings that have been gathered for you. The course pack will contain many readings/cases. Students will purchase the course  packet online via instructions posted on Canvas.  

2. All Excel assignments will be managed through a Pearson tool called MyITLab. This  tool must also be purchased by students via instructions on Canvas. This tool is how  we will allow you to download/submit Excel assignments and give you feedback so you  can reattempt the assignments. We also discuss several other topics like What does centralization mean?
If you want to learn more check out What is od in psychology?

Required Software

You will also need access to a recent version of Excel (at least version 2013 for PC  and 2011 for Mac). If you’re a UT-enrolled student you can purchase a license for this software from the campus computer store in the FAC for around $33. Here is a link:  http://bit.ly/OavLzY. NOTE: Use of Open Office, Apple Numbers, or Google Sheets is not endorsed at this time. If purchasing Office is a problem you can use the lab computers in libraries which some students using Numbers and Google Docs did in past.

Grading Criteria

This course is based on a possible 1000 points with an additional 50 points available for extra credit. If you want to learn more check out What type of tissue covers body surfaces lines internal surfaces and forms glands?

• 10 Unit Quizzes = 300 Points (30%)  

• 9 End-of-Unit Assessments = 350 Points (35%)

• 5 Course Assignments = 350 Points (35%)

• Extra Credit Assignment #1 = 25 Points (optional)

• Extra Credit Assignment #2 = 25 Points (optional)

Point Distribution

Unit Quizzes

Questio

ns

Points

Unit 1 Quiz

10

30

Unit 2 Quiz

10

30

Unit 3 Quiz

10

30

Unit 4 Quiz

10

30

Unit 5 Quiz

20

30

Unit 6 Quiz

14

30

Unit 7 Quiz

10

30

Unit 8 Quiz

10

30

Unit 9 Quiz

10

30

Unit 10 Quiz

10

30

Don't forget about the age old question of How do you find the limit of a function of a function?

Unit Assessments

Points

Unit 1: Prompt: Driverless Cars *

25

Unit 2: Interactive Build, Buy, Rent?

50

Unit 3: Peer Exchange: Recommend a Product Strategy

25

Unit 4: Prompt: Describe a Company with a Security issue * 2

25

Unit 5: Interactive Google Analytics

50

Unit 6: Catalog Cross Selling Multiple Choice (6 questions)

50

Unit 7: Prompt: Social Network Analysis *

25

Unit 8: Zara Multiple Choice (7 questions)

50

Unit 9: Interactive Global Sourcing

50

3

Course Assignments

Points

Excel Assignment #1

50

Excel Assignment #2

70

Excel Assignment #3

90

Excel Assignment #4

90

SQL Assignment (auto-graded)

50

HTML Assignment (optional) (80%/20% - split *)

25**

Data Mining Assignment (optional) (auto-graded)

25**

* 20% of the grade is based on doing a peer evaluation of randomly assigned peers.  80% of the grade is based on a rubric that each peer will follow to grade your  assignment. That means you need to not only do the assignment well but also  participate in peer grading and giving feedback to one another.

** Points to be added to your total assignment points so technically you can earn up to 400 assignment pts  

Course Grading Scale

From To

Grad GPA

93

 100

 A

4.00

90

 92.99

A-

3.67

86

 89.99

B+

3.33

83

 85.99

 B

3.00

80

 82.99

 B-

2.67

76

 79.99

 C+

2.33

73

 75.99

 C

2.00

70

 72.99

 C-

1.67

66

 69.99

 D+

1.33

63

 65.99

 D

1.00

60

 62.99

 D-

0.67

0

 59.99

 F

0.00

Please note that Canvas does not always take into account the proper grading  polices, so you should not just blindly trust the final grade you see in Canvas. We  recommend that you calculate your grade on your own using Excel and the details  about points listed above in this syllabus. Simply add up the points you have  received on graded assignments and extra credit then divide by 1000. It is your  responsibility to know your grade and raise questions if you have any before end of  the class.

Exams

There is no mid-term or final exam for this course.  

Quizzes

There are 10 short multiple-choice quizzes; one at the end of each unit. These are

non-cumulative quizzes based on the unit readings, unit lecture videos, and unit activities you complete. Start the unit quiz after you have completed and thoroughly reviewed all of the unit content and are comfortable with the concepts. The unit quizzes are scored and you have 60 minutes to answer all 10 questions in a quiz. Time begins from the moment you start each Unit Quiz and runs continuously: once time begins there is no way to pause it, including loss of connectivity or logging out, so please plan accordingly. You may refer back to the unit content during the quiz, but all questions must be submitted within 60 minutes of starting the questions. You only get one attempt on each quiz.

Assessments

There are 9 unit assessments that test your understanding of the content covered in the first 9 units of the course. These assessments come in many forms such as short essays or discussion posts, video recordings, multiple- choice  questions, interactive online role-plays, and more. These assessments are graded  and you should follow the course schedule for when each assessment should be completed. You may refer back to the unit content while completing the assessments, and these are not timed. NOTE: Most assessments you only get 1  attempt EXCEPT on Units 2 and 5. For Units 2 and 5, you can have unlimited  attempts on the assessment since it is an auto-graded interactive. Unit 9 only  gives you one attempt so please take you time with this assessment.

Assignments

Follow the Course Schedule in this syllabus carefully to determine when each assignment is due. It is not up to the professor to remind you about dates.

The first four assignments were designed to get you familiar with Excel. These assignments are scored automatically using a tool called. If you have no background in Excel, you should follow the step-by-step instructions provided with  each assignment. These assignments require you to complete a template, and these templates cannot be altered in any way or you will not get credit for that  assignment. If you run into any problems with your assignments, please  post on the discussion board first and then search the web or YouTube for  Excel tutorials. As a last resort you can email your professor but only after you  have posted on Hoot and/or Coil. You are expected to learn Excel on your own  because employers want to hire people who are problem solvers and critical  thinkers.  

The final, and fifth graded assignment is a short quiz on using SQL to manipulate data in a database.

Extra Credit Assignments

There are two assignments you may complete for extra credit. The first is an  introduction into HTML and CSS. For this assignment you will build a simple  webpage and complete 2-3 peer reviews. The HTML assignment will be peer  graded using a Canvas rubric. If you submit an HTML extra credit website, you will be required to complete up to 3 peer reviews. These reviews count as 20% of your HTML extra credit grade. You may also choose to complete a Data Mining Quiz  Assignment for extra credit points. NOTE: Participation in extra credit can only  improve one’s grade.

Course Schedule for Graded Assessments and Assignments Following this schedule will ensure you complete the course on time. Though you’re expected to complete all the assessments and assignments in this table, the right hand column indicates required completion dates. If you don’t complete the assignments by the required dates here, you will lose all the points, no exceptions!

PLEASE NOTE:  

You are expected to read and know all deadlines below. You must adhere to them without exception.  

Please note that after Unit 3, you’ll have two units due together so consider yourself warned. You should also monitor deadlines on Canvas.

Complete the Following by the end of Week 2

Sep 4, 2016 

Unit 1Required by 11:59PM CST on date above: 

∙ Unit 1 Quiz

∙ Unit 1 Prompt: Are Driverless Cars a Good Idea?

Complete the Following by the end of Week 4

Sep 18, 2016 

Required by 11:59PM CST on date above:

Unit 2 Unit 3

Unit 4 Unit 5

∙ Excel Assignment #1: Stock Portfolio

∙ Peer Reviews for Unit 1 Prompt

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ∙ Unit 2 Quiz

∙ Unit 2 Interactive: Buy, Build, or Rent?

Complete the Following by the end of Week 6

Oct 2, 2016 

Required by 11:59PM CST on date above:

∙ Excel Assignment #2: Retirement Calculator and Tables

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ∙ Unit 3 Quiz

∙ Unit 3 Peer Exchange: Recommend a Product Strategy

Complete the Following by the end of Week 8

Oct 16, 2016 

Required by 11:59PM CST on date above:

∙ Excel Assignment #3: Import and Manipulate Data

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ∙ Unit 4 Quiz

∙ Unit 4 Prompt: Describe a Company that’s had Security  Issues

∙ Unit 5 Quiz

∙ Unit 5 Interactive: Analytics

Complete the Following by the end of Week 10

Unit 6

Unit 7

Unit 8

Unit 9

Unit 10

Extra

Course Polices

Oct 30, 2016 

Required by 11:59PM CST on date above:

∙ Peer Reviews of Unit 4 Prompt

∙ Excel Assignment #4: Gradebook Calculator

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ∙ Unit 6 Quiz

∙ Unit 6 Activity: Catalog Cross Selling Case

∙ Unit 7 Quiz

∙ Unit 7 Discussion: Visualize Your Network

Complete the Following by the end of Week 12 Nov 13, 2016 

Required by 11:59PM CST on date above:

∙ Structured Query Language (SQL) Quiz Assignment ∙ Peer Reviews of Unit 7 Prompt

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ∙ Unit 8 Quiz

∙ Unit 8 Activity: Zara Case

∙ Unit 9 Quiz

∙ Unit 9 Interactive: Global Sourcing

Complete the Following by middle of week 15

Nov 30, 2016 

Required by 11:59PM CST on date above:

∙ HTML5 and CSS3 Webpage Assignment (optional - for  extra credit)

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ∙ Unit 10 Quiz

Complete the Following by Monday of week 16 Dec 5, 2015 

Required by Friday 11:59PM CST:

∙ Peer Reviews of HTML Assignment (only needed if  submitted HTML assignment)

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ∙ Data Mining Quiz Assignment (optional - for extra credit)

You are encouraged to access this course 3 to 5 times per week including weekends. By doing so you will be able to actively participate, complete your assignments, and access announcements in a timely manner. Time  management is your best asset in this class and poor time management  typically is the major reason grades can suffer in this online class.

Code of Ethics

The McCombs School of Business has no tolerance for acts of scholastic dishonesty. The responsibilities of both students and faculty with regard to scholastic dishonesty are described in detail in the BBA Program’s Statement on Scholastic Dishonesty at http://www.mccombs.utexas.edu/BBA/Code-of-Ethics.

Academic Integrity

Students of the University of Texas and this course may not share or distribute materials that could be an advantage to another current or future student, and the university has no tolerance for acts of scholastic dishonesty. For more on UT’s policy of Academic Dishonesty and Cheating, following the link here:  http://catalog.utexas.edu/general-information/appendices/appendix-c/student discipline-and-conduct/

Students with Disabilities

Students with disabilities may request appropriate academic accommodations from the Division of Diversity and Community Engagement, Services for Students with Disabilities, 512-471-6259, http://www.utexas.edu/diversity/ddce/ssd/ 

Academic Rigor, MIS 302F Workload, and Managing Deadlines

Welcome to The McCombs School of Business. In order to challenge you and truly add to your education, the McCombs School is committed to rigorous classes. This means that you can expect a substantial workload in many of the  weeks during the semester. This course, while for non-business majors, is in no way a “business light” course and will require significant reading, participation, assignment completion, learning of new concepts and critical thinking processes.

Late Assignments and Responsibility of Turning in Work Properly Deliverables are due at designated times as outlined on the course schedule and in specific formats, all of which will be described in assignment criteria. To be fair and  to get assignments graded and returned in a timely fashion, the deadlines are  critical. Please turn things in correctly.

All of your work must be submitted before the deadline. For example, if an  assignment is required by 11:59PM and you submit your work at exactly 11:59PM,  your assignment will be considered late. Excel or HTML Assignments submitted  after the due date, even 1 second after the deadline will be deducted 50% on  grading. After 24 hours past the initial deadline, these assignments will not be  accepted for grading. For Unit Quizzes and Unit Assessments, no late work will be  allowed, even 1 second later. TIP: Start work early and plan to turn it in at least a  few hours early so you can manage issues like internet connectivity and computer  crashing. ANOTHER TOP: PLEASE double-check your deliverables after you submit  to ensure it’s submitted correctly. If your file is not submitted correctly, you  will not receive full credit for the assignment.

Course Outline

Unit or Assignment

Activities

Unit 1: The Macroeconomic Impact of  IT

Unit Readings

∙ Chapter 1 of Creative Destruction ∙ Kodak (A) from your Harvard Business  Review Coursepack

Unit Non-Graded Activities*

∙ Poll(s)

∙ Discussion: What are impacts of IT  (Good and Bad)?

Unit Assessments

∙ Unit 1 Quiz

∙ Unit 1 Discussion: Are Driverless Cars  a Good Idea?

Unit 2: IT Networks

Unit Readings

∙ Notes for the Microsoft Case

∙ Microsoft in 2005 from your Harvard  Business Review Coursepack

∙ Oracle vs. Salesforce.com from your  Harvard Business Review Coursepack ∙ Is Cloud Computing Really Ready for  Prime Time?

Unit Non-Graded Activities*

∙ Poll(s)

∙ Lesson 1 Practice Quiz

∙ Exercise: Buy, Build, or Rent Software ∙ Lesson 2 Practice Quiz

Unit Assessments

∙ Unit 2 Quiz

∙ Unit 2 Interactive: Build, Buy, or Rent?

Assignment 1

∙ Excel Assignment #1: Stock Portfolio

Unit 3: Platform-Based Competition

Unit Readings

∙ Apple Inc. in 2010 from your Harvard  Business Review Coursepack

∙ Networks and Positive Feedback: How  to Exploit Network Effects from your  Harvard Business Review Coursepack

∙ Strategies for Two-Sided Markets from  your Harvard Business Review  

Coursepack

Unit Non-Graded Activities*

∙ Poll(s)

∙ Lesson 1 Practice Quiz

∙ Lesson 2 Practice Quiz

Unit Readings

∙ Unit 3 Quiz

∙ Unit 3 Peer Exchange: Recommend a  Product Strategy

Unit 4: Communications Ecosystem

Unit Readings

∙ Overview of Networking Notes

∙ The Internet Technology-Developing  Web Applications

∙ Wireless World

∙ Akamai Technologies from your  

Harvard Business Review Coursepack ∙ Target Missed Signs of Data Breach ∙ SpamRankings.net

∙ Security Threats

∙ How does Secure Socket Layer (SSL)  work?

Unit Non-Graded Activities*

∙ Poll(s)

∙ Discussion: How has the evolution of  the Communication Ecosystem  

changed business?

∙ Lesson 3 Practice Quiz

Unit Assessments

∙ Unit 4 Quiz

∙ Unit 4 Prompt: Describe a Company  that’s had Security Issues

Assignment 2

∙ Excel Assignment #2: Retirement

Calculator and Tables

Unit 5: Search as a Business

Unit Readings

∙ Intro to Adwords Keyword Match Type ∙ Secret of Googlenomics: Data Fueled  Recipe Brews Profitability

∙ Air France Internet Marketing:  

Optimizing Google, Yahoo!, MSN, and  Kayak Sponsored Search from your  

Harvard Business Review Coursepack Unit Non-Graded Activities*

∙ Poll(s)

Unit Assessments

∙ Unit 5 Quiz

∙ Unit 5 Interactive: Analytics

Unit 6: Data Mining

Unit Readings

∙ How Companies Learn Your Secrets ∙ No. 1 Retailer in Britain Uses  

‘Clubcard’ to Thwart Wal‐Mart

Unit NonGraded Activities*

∙ Poll(s)

∙ Lesson 2 Practice Quiz

Unit Assessments

∙ Unit 6 Quiz

∙ Unit 6 Activity: Catalog Cross Selling  Case

Assignment 3

∙ Excel Assignment #3: Import and  Manipulate Data

Unit 7: Social Networks

Unit Readings

∙ The Power of Like: How Social  

Marketing Works

∙ Factors to Consider when Evaluating  Social Networks

∙ Connecting the Dots: Tracking Two  Identified Terrorists

Unit Non-Graded Activities*

∙ Poll(s)

∙ Lesson 2 Practice Quiz

Unit Assessments

∙ Unit 7 Quiz

∙ Unit 7 Prompt: Visualize a Network

Unit 8: IT and Supply Chain  

Management

Unit Readings

∙ Supply Chain Management Definitions ∙ IT and Supply Chain Management: An  Overview

∙ How Digital is Your Business?

Unit Non-Graded Activities*

∙ Poll(s)

∙ Lesson 2 Practice Quiz

Unit Assessments

∙ Unit 8 Quiz

∙ Unit 8 Activity: Zara Case

Assignment 4

∙ Excel Assignment #4: Gradebook

Calculator

Assignment 5

∙ Structured Query Language (SQL) Quiz Assignment

Unit 9: Global Sourcing

Unit Readings

∙ Made in the World

∙ Services Offshoring: Service-Providing  Occupations, Offshoring, and the  

Labor Market

∙ Global Sourcing and Value Chain  Unbundling

∙ Procter & Gamble: Global Business  Services (NT) from your

∙ Harvard Business Review Coursepack Unit NonGraded Activities*

∙ Poll(s)

∙ Activity: The Costs of Outsourcing ∙ Activity: Kato’s Kandy

∙ Lesson 2 Practice Quiz

∙ Lesson 3 Practice Quiz

Unit Assessments

∙ Unit 9 Quiz

∙ Unit 9 Interactive: Global Sourcing

Assignment 6 (Optional for extra  credit)

∙ HTML5 and CSS3 Webpage  

Assignment

∙ Peer Reviews of HTML Assignment

Unit 10: Project Management

Unit Readings

∙ IT Project Management: Infamous  Failures, Classic Mistakes, and Best  

Practices

∙ Nestlé’s ERP Odyssey

Unit Non-Graded Activities*

∙ Poll(s)

∙ Lesson 1 Practice Quiz

∙ Lesson 2 Practice Quiz

Unit Assessments

∙ Unit 10 Quiz

Assignment 7 (Optional for extra  credit)

∙ Data Mining Quiz Assignment

*Although certain assessment activities are ungraded, you must complete them to  release the quizzes. This is outlined in your online course.

Page Expired
5off
It looks like your free minutes have expired! Lucky for you we have all the content you need, just sign up here