Thursday, April 28, 2016

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 (5 attempts per question)
     33 Access skill based questions (5 attempts per question)

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 Fall 2015 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 Fall 2015 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!

Thursday, April 14, 2016

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 .

Monday, March 21, 2016

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) in addition to reading the chapters.
Be sure you also complete the Concepts Exam 2 Keyword Definitions workbook before class the day of the exam. It will help you review the content in another fashion, and is worth 10 points!

Monday, February 29, 2016

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, a SimpleFunctionExample workbook, 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.

Wednesday, January 27, 2016

SimNet Lesson TIPS

When you "Take" a SimNet Lesson, you will see a list of tasks to complete with check boxes next to each item.   In order to earn full credit for the lesson, each text box MUST HAVE A CHECK MARK in it.

Click on the task to complete and you will see 3 buttons.

"Show Me" - This is optional and if you choose this button, it will show you information regarding this task.   It will show you how to do the step.

"Guide Me" - This is optional and if you choose this button, it will guide you through the process to complete this task.

"Let Me Try" - This is REQUIRED.  You MUST ANSWER ALL of the questions on this button correctly to get a check mark.   You will see a checkmark displayed on the green button when you have successfully completed the task.   Some tasks have SEVERAL QUESTIONS and others may only have one.   But you must do ALL correctly until you see the checkmark.     Then you can use the arrows at the sides of the screen to move between questions.

The checkmarks are saved in SimNet, so you do not have to complete the entire lesson in one sitting.   When you come back into the lesson, just scroll down the list and choose where you want to start.  

You can try these tasks as many times as you need to get them correct and if you are stuck on one, don't hesitate to ask for help.

You do not have to submit anything for your grade.   Your instructor will get a report showing how many tasks had checkmarks directly from SimNet to determine your grade.

Finally, make sure that you use the DUE DATES in the Canvas Calendar and on your Daily Schedule, since they may be different in SimNet to allow you to use these lessons later in the semester.

Monday, January 11, 2016

FREE K201 Tutoring Spring 2016

The FREE K201 Tutoring is in UL 2135 D  (IUPUI Library 2nd floor near the Writing Center).

Walk-in hours:

Our experienced K201 Tutoring schedule for Spring 2016 is:

Monday: 9am-10:15am, 4pm-5:30pm, and  6:30pm-8pm
Tuesday: 9am-1pm
Wednesday: 4:30pm-8:00pm
Thursday: 9am-2:30pm
The MAC Stat tutoring lab is open additional hours with tutors ready to help, but they will not have had our K201 course.  The times above are when our department paid K201 students from Fall will be available for tutoring (they have completed the course very successfully).  There will be an additional K201 tutor hired soon, so watch for even more options!

Please check-in with your JagTag at the desk upon arrival.

Spring 2016 Purchasing SAM Projects or SimNet SEPARATELY from the bundle

If you get used books from someone, and need to purchase the SAM Projects and/or SimNet access codes, please use these links for the best pricing.

NEW Spring 2016 discounted link for the Excel/Access SAM Projects 2013 V1 code:

SimNet 2013 can be purchased directly from the login page (with our discount $72.75)...   and then click on the No, I need to buy a license link.

If you purchase the book bundles, you will get an even deeper discount on the book with the access code.  Please see either your instructor or the course coordinator if you have questions about the K201 course materials.

Due BEFORE Remote Connect Class Meeting

Daytime sections listen to Podcast of Computing Chapters 3 & 4 from (and write down codes from chapters then 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)

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.