Thursday, April 16, 2015

Access 2013 SimNet Exam

The Access SimNet Exam will allow up to five attempts at each question through SimNet. Be sure to complete the SimNet Access "Lesson" for an overview of the skills you will need to know before you take the Access SimNet Exam. See the Access SimNet Lesson and below for details of content.

  • The Access SimNet Lesson has 42 skills compared to the Access SimNet Exam with 50 skills. There is additional information you may benefit from reviewing in these following skills 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 42 skills.
1.      Finding and Replacing Data
2.      Cutting, Copying, and Pasting Data
3.     Modifying Field Properties
4.      Adding Design Elements to Form and Report Headers
5.      Adding Text Criteria to a Query
6.      Adding Numeric and Date Criteria to a Query
7.      Using AND and OR in a Query
8.      Filter Data Using Filter by Selection

Access Case Exam



The Access Case Exam will be given live in Access and hand graded with a rubric. 

The best way to prepare will be to review the Queries You Should Know.pdf which summarizes Access Tutorials 3 and 5, as most of the questions on the Access Case Exam will be queries. You will also need to know how to use a Validation rule, and how to create (and edit) a Form in Design view (including a Title, Logo, and Label field).

 You may also benefit from reviewing the AccessReviewQueriesAndMore.pptx .


Thursday, March 19, 2015

Concepts Exam 2

Here is the keyword list for the Computing Essentials Exam 2.  Please review all these terms, and do the recommended activities (the EOC quizzes from the text website, and complete the review sheets) in addition to reading the chapters.
Be sure you also complete the SimNet Computing Essentials Lesson 2 before class the day of the exam. It will help you review the content in another fashion, and is worth 10 points!

Tuesday, March 10, 2015

NEW K201 Tutoring LOCATION

K201 Tutoring NOW in the NEW MAC Stat lab the new location is  UL 2135,  in the Library on the 2nd floor (next to the Writing Center)

 K201 Tutoring Schedule Spring 2015
Day of week
Hours
Tutor Name
LOCATION
Monday/ Wednesday
10 am - 1 pm
Jarred
UL 2135 
MAC STAT Facility
 2nd floor Library
Tuesday
1 -3 pm
4 -5:45 pm
Cyndi
Thursday
3:15 -6 pm
Jarred

Spring Break and Finals week - NO K201 Tutoring

Wednesday, March 4, 2015

MAC Safari browser update that affects SimNet Lessons

If you have a MAC, please make this update if you use Safari as your browser BEFORE you do the next SimNet Lesson. 

 http://www.simnetcommunity.com/2015/03/mac-users-having-difficulty-loading-let-me-try-simulations/  

 or you  may have problems completing the Let Me Try steps.

Thursday, February 19, 2015

Excel Case Exam

Please review ALL the skill topics on this Study Guide for the Excel Case Exam before you come to class to take the Exam. You will see these topics on the exam!

Your SAM Project Cases (especially Tutorials 5-10), your book (extra cases at the end of the Tutorials as well as the example tutorials we did in class) - are great study resources!
Also attached is a PowerPoint presentation, and reference list of the study guide that one of our  K201 instructors made to help her students be prepared for the Excel Case Exam.  Enjoy!

Remember the Excel Case Exam is LIVE in Excel, worth 50 points, and will be hand graded with a rubric.  It will be more like your SAM Projects homework cases than the Excel SimNet exam you previously took.


Thursday, February 12, 2015

Excel SimNet 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 (Links to an external site.) 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.

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 http://go.iu.edu/ie (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
Hours
Tutor Name
LOCATION
Monday/ Wednesday
10 am - 1 pm
Jarred
MAC Lab, Taylor Hall, UC B001 first month then relocated to new
MAC STAT Facility 2nd floor Library
once launched
Tuesday
1 -3 pm
4 -5:45 pm
Cyndi
Thursday
3:15 -6 pm
Jarred

Spring Break and Finals week - NO K201 Tutoring