K201 Required Materials

Required Materials

You can purchase access to Cengage Unlimited from a Canvas, Modules, SAM link, or at the bookstore.  Online you have 3 subscription length options, while at the bookstore the 1 term option is available.

The K201 course will require a Cengage Unlimited subscription to use SAM 2019 Integrated with Canvas and three e-text books from Cengage.  Cengage Unlimited is a digital subscription service designed to save students a lot of money. With Cengage Unlimited, you can access ANY Cengage materials you are using across ALL of your courses AND a library of over 22,000 e-books, study guides and reference materials. 

Online options for Cengage Unlimited include one term for $119.99 (ISBN 9780357700037),

OR    a multi-term 12 month subscription for $179.99 (ISBN 9780357700044),

OR    a multi-term 24-month subscription for $239.99 (ISBN 9780357700051).  

Please consider your other courses and their materials to get the best value. There is a list of IUPUI Courses that have used Cengage Unlimited in the past in Canvas files named   Cengage Unlimited IUPUI courses.pdf to help students make a cost effective decision.

You can get up to FOUR rented print textbooks for $7.99 each when you activate Cengage Unlimited.  It is recommended that you rent a printed copy of the Excel textbook for K201, as we will teach through advanced content and you will have 11 homework cases it will provide reference material for.  You can print up to 10 pages at a time from any e-text in Cengage Unlimited.  There is a 7 day free trial option, that requires you enter a credit card or PayPal account, then discontinue or be billed.  It is recommended you use you IU email, then verify your account by clicking the link sent to your email.

Getting SAM Registered

To access the K201 course materials and explore Cengage Unlimited, log in to Canvas, click on Modules, and click a SAM link.  Review the help video at https://play.vidyard.com/rcZuPWG63oVZuvFu5M74G9 . When prompted, log in with your Cengage account and follow the prompts to complete the registration process.  Once this registration is complete, you will be taken directly to the materials when you click the Canvas, Modules links.

 

For your e-text books CLICK EACH of the 3 Canvas, Modules e-text links the first time, to populate them to the Cengage Unlimited Home page.  Then you can choose the Canvas, Modules, Link or open the Cengage Unlimited Tile to get to the book.

 

FREE K201 Tutoring

 The Business Department paid FREE K201 Tutoring - Fall 2021

FREE K201 Tutoring is available to students both In Person and Virtually.
 

For K201 In Person tutoring, please check in with your Crimson Card upon arrival and check out as you depart. You can work on your K201 assignments on the MAC Stat lab workstations or bring your own device to the lab.
K201 In Person Tutoring in the MAC Stat lab in University Library (UL 2135D)   

    Sun Closed
    Mon 11 am – 7 pm
    Tues 11 am – 7 pm
    Wed 11 am – 7 pm
    Thurs 11 am – 7 pm
    Fri 10 am – 2 pm
    Sat Closed

For K201 Online tutoring help visit http://mac.iupui.edu and click on Virtual tutoring under the Remote Teaching announcement. Locate our K201 course and click on the Zoom link. You can run Zoom in the browser or download the app. You will begin in a waiting room. Once you are admitted, you’ll be sent to a Breakout Room with a tutor. To watch video instructions, click https://youtu.be/OgQSMktuYFc
K201 Virtual Tutoring hours
    Sun Closed
    Mon 5 pm – 7 pm
    Tues 5 pm – 7 pm
    Wed 5 pm – 7 pm
    Thurs 5 pm – 7 pm
    Fri Closed
    Sat Closed
Note: You are free to stay in the Breakout Room as you work, but keep in mind you will be sharing the room with other students.

If you have any questions or concerns during your session, return to the main waiting room to speak with the manager on duty or call us at (317) 274-7898.

With the move to Online Learning we have added MS Excel and Access Attendance assignments for K201 Excel/Access modules to ensure you are watching and completing the work from the Recorded Lectures.

You will

1.  open MS Excel or Access on your device,

2.  split your screen OR watch/listen to the Recorded Lectures on another device and DO the steps as described. The Steps are ALSO in the MS Excel/Access e-text book (Canvas, Modules, Excel/Access e-text) if that proves helpful.

3.  Once you complete the Module steps in the file from the Recorded Lectures (and/or book) then you will Submit that work to the Canvas, Quizzes, Attendance link for that Module. That allows you to earn the participation points for the Module.

4  You then should complete the SAM Project for that Module from Canvas, Modules, SAM. You will have TEN attempts on the homework to earn the perfect score (or email your instructor to reset your lowest attempts).  Note the SAM Projects are DUE before your next class time.​

Take care,

Mrs. Nemeth

MAC Computers and MS Access K201 Assignments

I did some testing yesterday on my MACbook Pro running MacOS 10.13 and was able to get this set up to store and use the files on your local drive with IUanyWare.    Please use the attached document and Video on Youtube to ensure that you have this set up correctly!

This should allow you to download the SAM projects and other files to your computer and then use them in IUanyWare.   Then once completed upload them to Canvas assignments or to the SAM projects from your local drive!

A couple of key notes.    First, you will need to copy your files from the Downloads folder to your documents folder.   It does not appear that the security settings allow access to Downloads.    You might want to create a K201 folder in documents to put everything in (but that is not required).   Once the files are in the Documents folder, you will be able to access them and save them back to that location.    When you go back into Canvas or SAM to upload your finished work, you can upload the files directly from the Documents folder.

Also, once you set up the Citrix Workspace application, YOU CAN NOT USE THE BROWSER to access IUanyWare anymore.   You must open the Citrix Workspace application to use IUanyWare or you will go back to not having local access to your files.

Please let me know if you still need help!

 Mrs. Musick

MAC Computers and K201 Student Success

As we start the MS Access part of the class you will need to decide how to run MS Access for WINDOWS on your MAC.  The MAC MS Office Suite does NOT include the Access database application.  MAC computers do NOT have Access available in the MS Office Suite UNLESS you choose to run Windows on your MAC.

There is a document in Canvas, Files, called MAC K201 Student Tips.pdf that gives the best options. We have recently learned that if you run MS Access for Windows from the IUanyWare site, you can SAVE files to your Local Drive. That would likely be your fastest solution. If you choose from IUanyWare the Apps solution and save Local it works pretty well.  Instructions HowToSetupIUanyWareOnMAC
If you have a NEW MacBook you may NOT be able to use the "Local Drive".  We are still testing this.

If you are a business major, it maybe worth the time and energy investment to do option 3 and partition your MAC hard drive so you can install Windows, and then the MS Office for Windows suite. It would then work like in the classroom.

To run IUanyWare please see the steps in the MAC K201 Student Tips.pdf file in Canvas, Files.

To Save Local on your MAC you would follow instructions below AFTER you setup Citrix Receiver and are ready. For help please call 274-HELP (they are FREE technical support help to IUPUI Students). 

Take care,
Mrs. Nemeth

To Save Local on your MAC visit ... https://kb.iu.edu/d/bbcl​
Your personal computer may not automatically share your local file storage with IUanyWare. If you can't access your local directories and files when using IUanyWare applications, check the following settings in your Citrix Workspace app:

macOS: To allow IUanyWare applications to access local files on a macOS personal computer, while an IUanyWare application is open:
From the Client Viewer menu bar, select Preferences..., then File Access, and then Read and write. Click the Devices tab.
If they are not already selected, check the boxes for both When a session starts, connect devices automatically and When a new device is connected while a session is running, connect the device automatically.
The storage location C$ (\\Client) should now be available in your list of "Computer" storage locations.
You may also configure settings for removable media on your local workstation. These settings will remain in place until you change them.

Note:

Local Disk (C: on...) takes you to the Macintosh HD directory. Local Disk (H: on...) takes you directly to the home directory of your user account.

Welcome back to K201 and our Online Learning plan!

Remember you start your assignments from Canvas, Modules BUT then should Submit your Attendance and Participation Assignments in Canvas, Quizzes (left frame) and then click the appropriate Attendance link.  There is a separate link for each MIS Chapter, the MIS  Parcitipation Activities and later for the Excel/Access Module Attendance files.  All of these assignments are due by Midnight on the day listed on the Daily Schedule.

Please choose what works best for for you for the MIS Assignments either 

1.  Print and hand write answers, then take pictures and upload or

2.  Download the Assignment document (either .pdf file or from Canvas, Files, Revised Online Learning Content folder the .docx version if you prefer to type in your answers) and save then submit back to the Canvas, Quiz, link.  If you are using a MAC computer be sure you SAVE as a Windows file so I can open and grade. (do NOT submit MAC Pages files - as I will NOT be able to open them).

Most of your Exams will be ONLINE, and Open Resource and you will have 80 minutes (10 minutes EXTRA time vs face to face exams).

Excel/Access 2019 HELP - Videos for Class Examples AND SAM Projects Homework Tips

Videos Available for Excel and Access Modules covered in Class
https://www.youtube.com/channel/UCDCvJ4rWrUEzgPQgAc-GevQ

This link will take you to a site that has videos for all of the Excel and Access Modules that we will cover in class.

To start - Select "Playlist". These playlists group the videos by the Module they cover and the screen
resolution that they are best formatted for.
There are videos formatted to work with various screen resolutions.
1080p format is designed to work with a screen resolution of 1920x1080.
720p format is designed to work with a screen resolution of 1280x720.
480p format is designed to work with a screen resolution of 640x480.

Each module is divided into multiple segments (see ExcelVideoListDetails.pdf ) This will allow you to pick the specific portions of the modules that you would like to review. You will not have to watch the entire module, if it is not needed.

There are also additional videos for items that do not have specific examples covered in the text, but
that you will need to know for either homework or exams.

These videos can be used to help you if you missed class or just need to review a topic that was covered.

You may want to try to play the video on your smartphone or a tablet (some device other than the
laptop you are using for Excel or Access) or a second monitor if you have that option. That will allow you to watch the video and practice the tasks in Excel or Access on your laptop at the same time. The files that are being used in the videos were all downloaded from the Q drive at the beginning of the
semester.

There are also a Video List documents (one for Excel and one for Access) that lists all of the videos and references the pages in the text that are being covered in that video.

Excel Rental Text $7.99 with Cengage Unlimited

Hello,

Some students have reported only getting the option to Purchase MOS materials, INSTEAD of being able to Rent the Excel book for $7.99.  Please Clear your Browser Cache…  which should correct the problem.

Under the Cengage Unlimited, Print Options menu you should see the Excel Book as a Rental Option.  If not please clear history/cache/cookies, log out and log back in and the purchase options should correct. 

To  Clear your Browser Cookies and Cache

•    Windows PC/Laptop: Hold down Ctrl + Shift + Delete (all at the same time) then click on the “Clear Browsing Data” button.

•    Mac:

•    Chrome: https://kb.wisc.edu/helpdesk/page.php?id=15153

•    Firefox: https://kb.wisc.edu/helpdesk/page.php?id=36150

Thank you,

Mrs. Nemeth

FM Pages (Managing Your Files) - New location

Please read the FM pages (Managing Your Files) listed on the daily schedule BEFORE we start learning Excel.  The Managing Your Files.pdf  is available from Canvas, Files or the attachment to this announcement.

Reading the FM pages will be especially helpful BEFORE we start Excel.  There is NOT a pre-requisite for K201, so this is our attempt to get everyone in the same place so the class can move forward as a group.  If you are unfamiliar with the material covered, you may benefit from sitting down at a Windows computer and completing the steps with the tan background. The files you need for hands on practice are in the FM folder (Lab drive available in the classroom  Q:\K201SemesterYrStudentFiles\FM or in the Canvas, Files, K201SemesterYrStudentFiles.zip file) and are referenced in the pdf text.

K201 reminders before 2nd class session

Before the 2nd class session please complete the following:

1.  1st Day Participation answers emailed in Canvas Messages to your instructor

2.  Complete the Canvas Quiz 1 & 2 before class starts

3.  Read the chapters Management Information Systems (MIS) 1 & 2 before class to learn the most and to determine your questions. (pdf files for Chapters 1 & 2 in Canvas Files if needed)

4.  Print or open in MS Word the Canvas, Files document called MIS Exam 1 Keyword List.pdf so you are ready to take notes during the class lectures for the MIS Exam 1.

5.  Bring a USB drive (with your last name written on it in case you forget it in the classroom) so we can copy the files from the Q:\ drive you will need to be successful in K201 this semester.

6.  Setup your Cengage Unlimited account by completing the steps below.  Note:  There is a PowerPoint attached that gives you a general overview of Cengage Unlimited in case that is helpful.

Cengage Unlimited with Canvas Student Setup Steps

1.     Students should login to their Canvas section (canvas.iu.edu then click on K201 section).

2.     Click on Modules

3.     Click the SAM link

4.     Create Cengage Account (username, password etc)

5.     Determine subscription length desired (1 term, 1 year, 2 years) and click the radio option button accordingly.

6.     Pay with credit card for the subscription (there is a 14 day free trial)

7.     On the Cengage Unlimited Home screen (Canvas, Modules, Cengage Unlimited Student Dashboard) you should ADD Tiles that are clickable in Cengage Unlimited.  A Cengage/SAM section tile should show there because of our Canvas integration.

3. 9781285186139 Management Information Systems Seventh Edition by Sousa & Oz 
4. 9780357025765  New Perspectives Excel 2019 (MS Office 365) Comprehensive by Patrick Carey 
5. 9780357025758 New Perspectives Access 2017 (MS Office 365) Comprehensive by Shellman & Vodnik 

8.     Once added you can access your K201 materials from Canvas, Modules (either a SAM link for homework cases & exams, or Cengage Unlimited Student Dashboard for e-texts)

Note:  Once the semester ends it may be helpful to know you can also access Cengage Unlimited directly from your Cengage account (cengage.com) and that you have an additional 12 months access to your favorite six e-texts after your subscription expires.