Wednesday, June 18, 2014

K201 Final Exam

The K201 Final Exam will be comprehensive in nature, will be given in SimNet and will have 100 questions worth 200 points.

The Content will be divided into:
34 Computer Concepts questions (Multiple choice & True/False)
33 Excel skill based questions
33 Access skill based questions

The best way to prepare for the Final Exam will be to complete the SimNet Reviews.

There are TWO SimNet Final Reviews (one is an Exam and the other is a Lesson).

The Concepts Review is under the Exam tab and is called REVIEW Final Exam Computing CONCEPTS Spring 2014 and has 200 questions, from which 34 will be on the exam. The Excel/Access Review will be under the Lessons tab and is called REVIEW Final Exam Excel/Access Lesson Spring 2014 and has 100 skill based questions, from which 66 will be on the exam in a different scenario.

The Final Exam content has been selected directly from these Reviews. So if you complete all these reviews you will have seen all the Final Exam questions in a different scenario. Study up!

Friday, June 13, 2014

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 .


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 40 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 40 skills.
1.      Finding and Replacing Data
2.      Cutting, Copying, and Pasting Data
3.      Deleting and Renaming Database Objects
4.      Modifying Field Properties
5.      Adding Design Elements to Form and Report Headers
6.      Adding Text Criteria to a Query
7.      Adding Numeric and Date Criteria to a Query
8.      Using AND and OR in a Query (2 additional questions)
9.      Filter Data Using Filter by Selection

Tuesday, June 10, 2014

Concepts Exam 2 Keyword List

Here is the keyword list for the Computing Essentials Exam 2.  Please review all these terms, 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 Spring 2014 before class the day you take the exam. It will help you review the content in another fashion, and is worth 10 points!

Monday, June 9, 2014

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 that one of our other K201 instructors made to help her students be prepared for the Excel Case Exam.

Tuesday, May 27, 2014

Excel SimNet Exam & Lesson

To prepare for the Excel SimNet Exam you should complete the Excel SimNet Lesson before class (the Lesson is worth 10 homework points too). There will 50 skill based questions on the Exam, with 43 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 43 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 43 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)
  6. Review Conditional Formatting Data Bars, Color Scales, Icon Sets on your own (1 question) - there is NOT a SimNet task assigned for this skill but there is 1 exam question
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 Projects Case 3, 4 & 5 due before class.  The Excel SimNet Exam covers Excel Tutorials 1-5.

Thursday, May 15, 2014

Concepts Exam 1 Key Word list Summer 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.

CE 1 Key Word list Summer 2014

Wednesday, May 14, 2014

K201 Department Sponsored Tutoring Schedule Summer 2014

FREE K201 Tutoring is available in BS 3008

Summer 1:      Mon / Wed    from 2:30 - 5:40 pm   (May 19th - June 23rd, 2014)

Summer 2:    Tues / Thurs    from 2:30 - 5:40 pm   (July 3rd - July 31st, 2014)

Sunday, March 16, 2014

Monday, March 3, 2014

SAM Projects FREE update code for Case 9 & 10

The SAM Excel 2013 projects for Tutorials 9 & 10 will NOT be available until June so here is our plan B for homework for Excel Tutorial 9 & 10.  You will still be doing Excel SAM Projects, but we are going to use the Excel 2010 version, which means you need an additional access code. 

Your FREE update code will need to be added to your existing SAM Projects account by following the steps below:
  1. Login to your SAM account
  2. Click on the Activity List
  3. Click the “Add Product” button in the top left
  4. Type in their FREE 2010  SAM content access code  (from Oncourse resources named   SAM 2010 codes InstructorName Section#)…  Your name will be beside the code you should use.  You only need to add this code ONE time to access both Excel cases 9 & 10.
Please let your instructor know if you have questions.