Excel and Access Module Videos Available

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 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

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 (mnemeth@iupui.edu ) know if you have SAM account questions.

K201 Wrap Up Song

http://wp.me/p6rYAg-gu

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

Excel and Access 2013 Podcasts

https://www.youtube.com/channel/UCDCvJ4rWrUEzgPQgAc-GevQ

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.

Enjoy!

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

MOS Certification Information

MOS Certification is the universally recognized certification for Microsoft Office products.

Learn more by reviewing the PowerPoint attached that was created by one of our K201 Honors students, Elizabeth. 

MOS Certification PowerPoint

Taking a RISE class in spring 2014 and want a scholarship?

Are you taking a RISE class in spring 2014 and want a scholarship?

Do you know what RISE is?

RISE courses are coded as "Research", "International", "Service", or "Experiential" and there are courses in Kelley that are RISE.  We also have RISE Scholarships available for spring 2014, which means that if you are planning to enroll in one of these courses in spring 2014, you should apply for a scholarship! 

Spring 2014 RISE Courses:

I-Core (BUS BE499:  BUS P371, BUS F371, BUS M371, BUS Z371)  

BUS D301 International Business

BUS D302 International Business:  Operation of International Enterprises

BUS F494 International Finance

BUS A380 Professional Practice in Accounting

BUS X280 Professional Practice For Credit Internship

BUS X480 Professional Practice

Spring 2014 RISE Scholarships:

Citizens Energy Group RISE Diversity Scholarship 1

• Student must be registered in a course which has a R-I-S-E designation

• Student must be enrolled in the Kelley School of Business at IUPUI

• Student must have a minimum cumulative GPA of 3.2

• Student must be an Indiana resident

• Preference given to Marion county residents or residents of the seven contiguous counties

• Special consideration is given to underrepresented populations

Citizens Energy Group RISE Diversity Scholarship 2

• Student must be registered in a course which has a R-I-S-E designation

• Student must be enrolled in the Kelley School of Business at IUPUI

• Student must have a minimum cumulative GPA of 3.2

• Student must be an Indiana resident

• Preference given to Marion county residents or residents of the seven contiguous counties

• Special consideration is given to underrepresented populations

Powers & Sons Construction Company, Inc. RISE Diversity Scholarship

• Student must be registered in a course which has a R-I-S-E designation

• Student must be enrolled in the Kelley School of Business at IUPUI

• Student must have a minimum cumulative GPA of 2.8

• Student must be a resident of the State of Indiana with preference given to Marion, Lake, St. Joseph and Allen county residents

• Special consideration will be given to underrepresented populations

Mays Family Rise Scholarship for Men in Business

• Student must be registered in a course which has a R-I-S-E designation

• Student must be a male undergraduate student in the Kelley School of Business at IUPUI

• Special consideration will be given to underrepresented populations

Interview with Gabriela Espino

Pete the planner - April 11, 2013