Thursday, January 15, 2015

Concepts Exam 1

In addition to reading the chapters, completing the recommended activities from the daily schedule, and the chapter review sheets, please study this keyword list prior to taking your Computing Essentials Exam 1 over the Buyers Guide, Chapters 1-4 and 10.

Concepts Exam 1 Key Word list Spring 2014

Wednesday, January 14, 2015

Due BEFORE Remote Connect Class Meeting

Daytime sections listen to Podcast of Computing Chapters 3 & 4 from (and write down codes from chapters and send Canvas Message to instructor - see attached Connect Student instructions Canvas.pdf)
Review PowerPoint slides Chapters 3 & 4 from the Canvas Files
Note:  If you are a night/weekend section you also should listen to the podcast and review PowerPoints for Chapter 10 (Information Systems)

Monday, January 12, 2015

FREE K201 Tutoring Schedule Spring 2015

 K201 Tutoring Schedule Spring 2015
(starting Monday January 19, 2015)
Day of week
Tutor Name
Monday/ Wednesday
10 am - 1 pm
MAC Lab, Taylor Hall, UC B001 first month then relocated to new
MAC STAT Facility 2nd floor Library
once launched
1 -3 pm
4 -5:45 pm
3:15 -6 pm

Spring Break and Finals week - NO K201 Tutoring

Sunday, January 11, 2015

SimNet 2013 Setup

IUPUI Students Registering for SimNet 2013 with a code
Navigate to our URL  
If you've already purchased SIMnet and have a registration code, you can add the code when you create your SIMnet account.
1.     Click No, but I have a code on the school's SIMnet homepage ( ). Answer the verification questions and proceed to the next step.
2.     Review the McGraw-Hill license agreement. Click the Check this box if you agree to the end user license agreement check box, and then click Next.
3.     Select the class you are enrolled in, and then click Next.
4.     Enter your registration code (off the card that came in your textbook bundle), and then click Next.
5.     Enter your personal information. Click Next. Then click Finish.
When you log back into SIMnet, click on your name in the upper right-hand corner to view your profile. Confirm that you are enrolled in the correct SIMnet class. If you need to enroll yourself in a different SIMnet class, see Add or remove a course.

Tuesday, September 16, 2014

SAM Projects Setup Instructions

Our K201 course code is  T2039151 at

SAM Projects Account Setup

Friday, September 12, 2014

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.


Thursday, August 21, 2014

SAM Projects Overview

When you do the SAM Projects homeworks, you will goto then login to your SAM account. To see the assignments click on the Activity List button at the top (there are 10 Excel cases, and 5 Access cases).  If you want to make the Activity List page your DEFAULT, click the checkbox in the top right corner.

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\Excel 2013\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. Visit the Reports tab at the top to see how you did. You can open the Reports & 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.

Your instructor will run a report at the beginning of the class the case is due, and that is the score that will be entered into the Oncourse gradebook (each Excel case is worth 10 points).

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 account setup questions.

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

Monday, January 6, 2014

Access 2013 Reference pages

Please click here for the Access 2013 New Perspectives Intro reference pages that should have been printed in the back of the custom Cengage New Perspectives Excel/Access 2013 text.  Mistakenly they did not make it into the Spring bound copies.  If you bought a used book, please double check if you need these pages.

Thank you for your patience and sorry for the inconvenience!