Monday, April 17, 2017

K201 Final Exam

Our K201 Final Exam will be comprehensive in nature, given in SAM 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 SAM Reviews.  There are TWO SAM Final Reviews (one is an Exam and the other is a Training).

The UC Concepts Review has 150 questions, from which 34 will be on the exam. The Excel/Access Review is a Training 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.

Thursday, March 30, 2017

Access SAM Exam

To prepare for the Access SAM Exam you should complete the Access SAM Training before class (the Training is worth 10 homework points plus is the best way to study for the exam). There will be 50 skill based questions on the Exam and you will have up to five attempts at each question during the Exam (without the help or hints available in the Training).  The skills on the Training will be the same in a different scenario. On the Training complete the Apply instructions to earn the green check mark (credit) per task.
Remember you can do this Training repeatedly at your own pace.  Goto Canvas, Modules, SAM to see the Training link.

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.pdfPreview the documentView in a new window 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 (Links to an external site.)  in Canvas Files.

Tuesday, March 28, 2017

MAC Users Beware!

Mac security facts and fallacies

Posted March 8, 2017 by Thomas Reed

There are many Mac security myths circulating among users. So how can you tell if the advice you’re reading is fact or fallacy? Read on to find out!
Fallacy: Macs don’t get viruses

The idea that there are no viruses for the Mac goes back to the beginning of Mac OS X, at the very beginning of this millennium. Most people associate this idea most strongly with the “I’m a Mac/I’m a PC” commercials from a decade ago, such as this one that ran in 2006:

Unfortunately, this is a myth. As with most good myths, though, there’s a slight element of truth.
Technically speaking, a virus is malware that spreads by itself, by attaching itself to other files. By this strict definition, there are no Mac viruses. However, by that token, there also aren’t very many Windows viruses these days, either. Viruses have mostly disappeared from the threat landscape.
The average person, though, understands a virus to be any kind of malicious software. (A better term for this is “malware.”) Since there definitely is malware for the Mac, as well as a plethora of other threat types, the spirit of the “there are no Mac viruses” claim is completely false. Don’t allow yourself to be misled!

True malware is malicious in nature—thus the name, malicious software— with the goal of stealing or scamming data or money from the user. Examples of malware are backdoors that provide access to the computer, spyware that logs keystrokes and captures pictures with the webcam, ransomware that encrypts the user’s files in order to hold them for ransom, and other such nefarious programs.
On the Mac, true malware is rare. A “big spike” of new Mac malware happened in 2012, when 11 new pieces of malware appeared. The average Mac user has never seen any malware.

So why should Mac users be concerned? Because other threats are a rapidly growing problem on the Mac. Over the last several years, there has been an increasing amount of adware and Potentially Unwanted Programs (PUPs) for the Mac.

Adware is software that injects ads into websites where they don’t belong and changes your search engine to a different one. Adware is designed to scam advertisers and search engines. The infected Macs are no more than a vehicle for generating revenue fraudulently from advertisers and search engines, who pay these adware-producing “affiliates” for referrals.

PUPs are programs that are generally unwanted by users. These can include so-called “legitimate” keyloggers (marketed as a means for monitoring your kids or employees), scammy “cleaning” apps (Macs don’t need that kind of cleaning), supposed “antivirus” or “anti-adware” apps that don’t actually detect anything, and so on.

Adware and PUPs are a serious problem on the Mac right now. Although these things are not malware, they are a huge nuisance. Worse, they can create security vulnerabilities that make it more likely for you to get infected with actual malware. For example, in 2015, a vulnerability in a common PUP (MacKeeper) was used to install malware on Macs that had MacKeeper installed.
Fallacy: Macs are more secure than Windows

Many years ago, Apple abandoned the old “classic” Mac system in favor of one based on Unix, a mature and security-oriented system. Apple has made some great security improvements to macOS in recent years, and as a result, Macs are more secure today than they ever have been.
Of course, nothing is ever perfect, and macOS security is certainly far from it. There are plenty of ways to circumvent Mac security. Add to this the fact that security of Windows has improved over the years as well and it becomes difficult to say which system is more secure.

As with other such myths, there’s an element of truth here, though. Macs certainly suffer under a far smaller burden of threats than Windows. Many thousands of new Windows malware variants appear every day, while it’s a busy month in the Mac world if more than one new piece of malware appears. This means that, although there may not be any explicit, major security differences between the two systems, Macs do tend to be statistically safer simply due to the smaller number of threats.

Fact: macOS has built-in anti-malware software
Although this feature is well-hidden from the user, and cannot be turned off, this is true. Apple’s anti-malware software is called XProtect, and it consists of some basic signatures for identifying known malicious apps.
When you try to open an app for the first time, the system will check it against the XProtect signatures. If the app matches one of those signatures, the system won’t allow it to open.

Of course, there are a couple problems with XProtect. First, of course, as with any signature-based detection, it can only detect and block malware that Apple has seen before.
More importantly, though, it only detects malware. Since the vast majority of the threats for Macs are adware and PUPs, that leaves a lot that it doesn’t protect against. You shouldn’t rely on XProtect as your sole protection against threats, but nonetheless, this is very good layer of protection to have as an integral part of the system.

Fallacy: Macs don’t need security software
Antivirus software has gotten a bad rap on the Mac over the years. Thanks to historically low incidence of Mac malware, coupled with the system problems that some antivirus programs have been known to cause, Mac users are skittish about installing security software. Making matters worse, Mac “experts” will tell people that they don’t need security software, because macOS contains all the protection they need.

However, the number of Mac users infected by malware and other Mac threats has had exponential growth since 2010, when adware and PUPs weren’t really a thing on the Mac yet and when new malware sightings were few and far between. We’re seeing large numbers of people infected with Mac threats every day, on a much larger scale than even just a few years ago.

Clearly, there is an epidemic problem with threats—mostly adware and PUPs—on the Mac, and also clearly, the built-in security in macOS is not adequate to deal with this problem. It is becoming increasingly necessary for Mac users to have an additional layer of security, and in particular, to have something that is effective against adware and PUPs, which are the biggest problem. If you’re a Mac user, you might consider downloading software such as Malwarebytes Anti-Malware for Mac, which removes adware, PUPs, and malware for free.

Monday, March 20, 2017

Understanding Computers Concepts Exam 2

In addition to reading the chapters, completing the EOC Review Activities (Key Term Matching & Self-Quiz), and taking the Canvas Understanding Computers Chapter quizzes, please study the UC Exam 2 Keyword list over Chapters 5-9 and 12 in Canvas Files.

Tuesday, February 28, 2017

BACK Door to SAM if Canvas is unavailable

When students initially registered for SAM via Canvas, they were prompted to create a Cengage account.

Using that same Cengage account, you can access SAM directly at

After logging in, you can click the “open” button next to your course title.

Students will be taken to SAM calendar page but can also switch to the SAM assignments tab to explore their assignments.  Everything else is the same from here.

Profs may need to click the sync button once Canvas comes back online to ensure grades sync from SAM to Canvas.

Click here for SAM Backdoor access instructions with images

Wednesday, January 4, 2017

K201 FREE Tutoring Spring 2017

The department paid FREE K201 Tutoring is in UL 2135 D  (MAC STAT lab located in the IUPUI Library 2nd floor near the Writing Center.)

The MAC Stat tutoring lab is open with tutors ready to help, but they will not ALL have had our K201 course. 

Our K201 content experts (the Tutors that have successfully taken K201) will be available Spring 2017

9am-noon; 3pm-9pm
9am-noon; 1:45pm-6pm