Wednesday, January 4, 2017

K201 FREE Tutoring Spring 2017

The department paid FREE K201 Tutoring is in UL 2135 D  (MAC STAT lab located in the IUPUI Library 2nd floor near the Writing Center.)

The MAC Stat tutoring lab is open with tutors ready to help, but they will not ALL have had our K201 course. 

Our K201 content experts (the Tutors that have successfully taken K201) will be available Spring 2017

9am-noon; 3pm-9pm
9am-noon; 1:45pm-6pm

Tuesday, January 3, 2017

Welcome to K201 The Computer in Business!!

Required Textbooks
There is ONE IU e-text Cengage bundle for K201  Spring 2017. The Cengage IU e-text Bundle (ISBN9781337045148) is billed through the registrar with enrollment in the K201 course and includes FOUR items:           
  1. SAM (Skills Assessment Manager) LMS Integrated CourseKey (added in Canvas Modules)
 The three hard copy paper textbooks (see below) will be shipped to your address of choiceonce you enter your Cengage Redemption code at the URL provided in an e-mail you will receive and discuss on your first day of class.  The textbooks are NOT available at the bookstore because you purchased them through the IU e-text program when enrolling in K201.
  1. Custom Understanding Computers Today & Tomorrow 16th ed Comprehensive by Morley & Parker
  2. Custom New Perspectives Excel 2016 (MS Office 365) Comprehensive by Parsons, Oja, Carey, & Desjardins
  3. Custom New Perspectives Access 2016 (MS Office 365) Intermediate by Shellman & Vodnik
Your Instructor looks forward to meeting you!

Wednesday, November 9, 2016

Excel and Access Module Vidoes Available

Videos Available for Excel and Access Modules covered in Class 

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

To start - Select "Playlist". These playlists group the videos by the Module they cover and the device that they are best formatted for. There are videos formatted to work with various screen resolutions and also specific devices.

HD1080p format is designed to work with a screen resolution of 1920x1080.
HD720p format is designed to work with a screen resolution of 1280x720.
HD480p format is designed to work with a screen resolution of 640x480.
iPhone4 format is designed to work with the iPad and iPhone4.
iPhone5 format is designed to work with the iPad2 and iPhone5.

Each module is divided into multiple segments. This will allow you to pick the specific portions of the modules that you would like to review and not have to watch the entire module if it is not needed.
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). That will allow you to watch the video and practice the tasks in Excel on your laptop at the same time. The files that are being used in the Modules were all downloaded from the Q drive at the beginning of the

Thursday, September 15, 2016

Galaxy Note 7 Recall


Please be aware of this smartphone recall!   If you have one or know anyone who does, they should take immediate action!   They are calling this smartphone "too dangerous to own", so act quickly!

Thursday, September 8, 2016

Excel 2016 e-text version Modules 1-3

Because we had some books on Back-order…  we want to make sure students have access to the e-text Excel book (Modules 1-3).  We cannot add it to our Canvas accounts because what students paid for only allows for ONE e-text to be visible (and we chose Concepts).
This is an FTP site, and takes a bit of time to load.

username- custom2
password- production

Wednesday, August 10, 2016

SAM Projects homework cases

When you do the SAM Projects homework, you will go to Canvas, Modules, SAM. There are 10 Excel cases, and 5 Access cases assigned for K201. 

Before the class due (see daily schedule for your section) you need to finish and submit the assigned case. When you click on the assignment link .. you will click the Start button to get to the Instruction file, the start file, and the submission area. You can open this link as many times as you wish (the submission link is the only area limited to 5 attempts).

1. Click and open the instruction file (some students prefer to have a printed hard copy to work from)

2. Download a copy of the start file in step 2 by clicking on the link, and choosing Save As (it is wise to save it to the K201 Fall 2016\Excel 2016\Excel SAM Projects folder on your USB drive - so it's easy to find when you are ready to submit). Do NOT simply open... or it will be a temp file and your work will NOT be saved!!

3. Follow all the instructions in the step 1 instruction document, save your changes to the downloaded start file from step 2, and work until you believe all steps are correct. Then Save the changes... and return to SAM Projects, step 3 for that case... Browse for your saved work, and the Submit it for grading.

4. From Canvas, Modules, SAM Projects Reports, click the Reports button at the top, then the case link to see how you did. In the report select the Files icon to get specific feedback on each step (red x means you did not earn those points... and you can go back to your Excel file, make corrections to that step(s), save the changes and re-submit to SAM Projects again... up to 5 times per case ... or e-mail your instructor to reset some attempts if you need more tries).  You do not need to start over to re-submit.

Remember the K201 Department paid tutors are available to help in the MAC lab... (see the Blog or Canvas Announcement for details of days/times).

Please let your instructor or Mrs. Nemeth ( ) know if you have SAM account questions.

Tuesday, May 24, 2016

K201 Wrap Up Song

This song covers why K201 and learning Excel is important!  Enjoy! 

Wednesday, January 6, 2016

Excel and Access 2013 Podcasts

This link will take you to a site that has videos for all of the Tutorials that we will cover in class.
To start - Select "Playlist".  These playlists group the videos by the Tutorial they cover and the device that they are best formatted for.     There are videos formatted to work best on smartphones, tablets, and laptops.

Each tutorial is divided into multiple segments.   This will allow you to pick the specific portions of the chapter that you need additional review of.


Friday, January 17, 2014

K201 Students with a MAC computer TIPS

If you are enrolled in K201 and/or K204, you MAY use your MAC computer to complete the SAM Projects homework cases IF YOU prepare your MAC.  Please read the following options well before your homework is due and choose your plan.

MAC user tips for K201

MAC Users Install Windows 7 - step by step instructions

Thank you to a fellow student named Tyler, who documented the steps he completed as he did his MAC installation.  Hopefully they help!
MAC Users Windows Install Instructions step by step