Friday, September 19, 2014

IT Training Resources for the E-text

Here is a list of resources from IT Training.

For K201 you may find the IU eTexts: Basic Skills for Students link most helpful when we return to the Computing Essentials e-text.

https://ittraining.iu.edu/downloads/Recordings.aspx

Excel SimNet Lesson and Exam

To prepare for the Excel SimNet Exam you should complete the Excel SimNet Lesson before class (the Lesson is worth 10 homework points plus the best way to study for the exam). There will 50 skill based questions on the Exam, with 44 on the Lesson. The skills will be the same in a different scenario. On the Lesson complete the Let Me Try (the exam will be similar but without Hints and feedback).
The content on the Exam is covered in the skill Teach Me content. 
  • The Excel SimNet Lesson has 44 skills compared to the Excel SimNet Exam with 50 skills. There is additional information you should review under the SimNet Teach Me or Show Me portions on the following topics. SimNet Technical Support says that some of the skills on our Exam are covered by the Lesson, but that there are multiple topics related that only appear in the Teach Me or Show Me portions (not the Let Me Try section). Sorry for any frustration! Please review the Teach Me/Show Me sections of SimNet Lessons for these topics, as well as completing all the Let Me Try questions for all 44 skills.
  1. Applying Number Formats (3 questions)
  2. Entering Simple Formulas (2 questions)
  3. Modifying Column Widths and Row Heights (2 questions)
  4. Inserting and Deleting Rows and Columns (2 questions)
  5. Moving a Chart (2 questions)
Remember you can do this Lesson up to 99 times at your own pace.  Goto http://iupuiindy.simnetonline.com Lesson tab to get started.
You also have your Excel SAM Project Case 5 due before class.  The Excel SimNet Exam covers Excel Tutorials 1-5.

Monday, September 15, 2014

FREE K201 Tutoring Fall 2014 Schedule

Here is the K201 Tutoring schedule starting Sept 15th, 2014.  Please note there are a few location changes in November...  due to room conflicts.  See the detailed daily schedule here Detailed schedule K201 Tutoring

Please swipe in with your JagTag at the MAC lab front desk if sessions are held in the MAC Lab UC B001.



K201 Tutoring Schedule Fall 2014
Day of week
Hours
Tutor Name
Location
Monday
10:30 am - 1 pm
3 pm -5:30 pm
Jarred
Cyndi
MAC Lab, Taylor Hall, 
UC B001
Tuesday
12:30 pm - 1:30 pm
Cyndi
UC 2025B
1:30 pm -2:45 pm
Cyndi
ES 2119
5 pm - 6:30 pm
Jarred
MAC Lab, Taylor Hall, 
UC B001
Wednesday
10:30 am - 1 pm
3 pm - 4 pm
Jarred
Cyndi
UC 2025B
4 pm - 5:30 pm
Cyndi
MAC Lab, Taylor Hall,
 UC B001
Thursday
12:30 pm - 1:30 pm
Cyndi
UC 2025B
1:30 pm - 2:45 pm
Cyndi
ES 2119
5 pm - 6:30 pm
Jarred
MAC Lab, Taylor Hall, 
UC B001

Friday, September 12, 2014

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!

Wednesday, August 27, 2014

Fall Break October 20th - 21st, 2014

There will be NO K201 Classes or Tutoring during Fall Break on October 20-21st.  Enjoy your time off!

Concepts Exam 1 Key Word list Fall 2014

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 over the Buyers Guide, Chapters 1-4 and 10.

Concepts Exam 1 Key Word list Fall 2014

Thursday, August 21, 2014

K201 Computing Essentials e-text and SimNet Account

You have PAID for the Computing Essentials 2014 text for Fall 2014 is a e-text on your Bursar bill.  the e-text is available through your Canvas login.  Once you login with your IUPUI credentials at http://canvas.iu.edu you can click the left frame Courseload Engage link to open the e-text.  The Notes page in the top right will show you all the Instructor added highlights and notes.

Please check your iupui e-mail (the one you see on the Canvas roster) for your SimNet username/password.  Goto a browser (SimNet runs best on Chrome), check your System (by clicking the System Test link toward the bottom right of the page), and then login to see your SimNet Lessons.  You will also be taking SimNet Exams in this product.  If you cannot get logged in or have any problems with your account, please ask your instructor first, or ask Mrs. Nemeth  (mnemeth@iupui.edu)

SAM Projects Overview

When you do the SAM Projects homeworks, you will goto http://sam.cengage.com 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 (mnemeth@iupui.edu ) know if you have account setup questions.