Videos Available for Excel and Access Modules covered in Class
https://www.youtube.com/channel/UCDCvJ4rWrUEzgPQgAc-GevQ
This link will take you to a site that has videos for all of the Excel and Access Modules that we will cover in class.
To start - Select "Playlist". These playlists group the videos by the Module they cover and the screen
resolution that they are best formatted for.
There are videos formatted to work with various screen resolutions.
1080p format is designed to work with a screen resolution of 1920x1080.
720p format is designed to work with a screen resolution of 1280x720.
480p format is designed to work with a screen resolution of 640x480.
Each module is divided into multiple segments (see ExcelVideoListDetails.pdf ) This will allow you to pick the specific portions of the modules that you would like to review. You will not have to watch the entire module, if it is not needed.
There are also additional videos for items that do not have specific examples covered in the text, but
that you will need to know for either homework or exams.
These videos can be used to help you if you missed class or just need to review a topic that was covered.
You may want to try to play the video on your smartphone or a tablet (some device other than the
laptop you are using for Excel or Access) or a second monitor if you have that option. That will allow you to watch the video and practice the tasks in Excel or Access on your laptop at the same time. The files that are being used in the videos were all downloaded from the Q drive at the beginning of the
semester.
There are also a Video List documents (one for Excel and one for Access) that lists all of the videos and references the pages in the text that are being covered in that video.
Tuesday, September 24, 2019
Tuesday, September 17, 2019
Excel Rental Text $7.99 with Cengage Unlimited
Hello,
Some students have reported only getting the option to Purchase MOS materials, INSTEAD of being able to Rent the Excel book for $7.99. Please Clear your Browser Cache… which should correct the problem.
Under the Cengage Unlimited, Print Options menu you should see the Excel Book as a Rental Option. If not please clear history/cache/cookies, log out and log back in and the purchase options should correct.
To Clear your Browser Cookies and Cache
• Windows PC/Laptop: Hold down Ctrl + Shift + Delete (all at the same time) then click on the “Clear Browsing Data” button.
• Mac:
• Chrome: https://kb.wisc.edu/helpdesk/page.php?id=15153
• Firefox: https://kb.wisc.edu/helpdesk/page.php?id=36150
Thank you,
Mrs. Nemeth
Some students have reported only getting the option to Purchase MOS materials, INSTEAD of being able to Rent the Excel book for $7.99. Please Clear your Browser Cache… which should correct the problem.
Under the Cengage Unlimited, Print Options menu you should see the Excel Book as a Rental Option. If not please clear history/cache/cookies, log out and log back in and the purchase options should correct.
To Clear your Browser Cookies and Cache
• Windows PC/Laptop: Hold down Ctrl + Shift + Delete (all at the same time) then click on the “Clear Browsing Data” button.
• Mac:
• Chrome: https://kb.wisc.edu/helpdesk/page.php?id=15153
• Firefox: https://kb.wisc.edu/helpdesk/page.php?id=36150
Thank you,
Mrs. Nemeth
Tuesday, September 10, 2019
FM Pages (Managing Your Files) - New location
Please read the FM pages (Managing Your Files) listed on the daily schedule BEFORE we start learning Excel. The Managing Your Files.pdf is available from Canvas, Files or the attachment to this announcement.
Reading the FM pages will be especially helpful BEFORE we start Excel. There is NOT a pre-requisite for K201, so this is our attempt to get everyone in the same place so the class can move forward as a group. If you are unfamiliar with the material covered, you may benefit from sitting down at a Windows computer and completing the steps with the tan background. The files you need for hands on practice are in the FM folder (Lab drive available in the classroom Q:\K201SemesterYrStudentFiles\FM or in the Canvas, Files, K201SemesterYrStudentFiles.zip file) and are referenced in the pdf text.
Reading the FM pages will be especially helpful BEFORE we start Excel. There is NOT a pre-requisite for K201, so this is our attempt to get everyone in the same place so the class can move forward as a group. If you are unfamiliar with the material covered, you may benefit from sitting down at a Windows computer and completing the steps with the tan background. The files you need for hands on practice are in the FM folder (Lab drive available in the classroom Q:\K201SemesterYrStudentFiles\FM or in the Canvas, Files, K201SemesterYrStudentFiles.zip file) and are referenced in the pdf text.
Wednesday, August 28, 2019
K201 reminders before 2nd class session
Before the 2nd class session please complete the
following:
1. 1st Day
Participation answers emailed in Canvas Messages to your instructor
2. Complete the
Canvas Quiz 1 & 2 before class starts
3. Read the
chapters Management Information Systems (MIS) 1 & 2 before class to learn the most and
to determine your questions. (pdf files for Chapters 1 & 2 in Canvas Files if needed)
4. Print or
open in MS Word the Canvas, Files document called MIS Exam 1 Keyword
List.pdf so you are ready to take notes during the class lectures for the MIS Exam 1.
5. Bring a USB
drive (with your last name written on it in case you forget it in the
classroom) so we can copy the files from the Q:\ drive you will need to be
successful in K201 this semester.
6. Setup your
Cengage Unlimited account by completing the steps below. Note:
There is a PowerPoint attached that gives you a general overview of
Cengage Unlimited in case that is helpful.
Cengage
Unlimited with Canvas Student Setup Steps
1. Students
should login to their Canvas section (canvas.iu.edu then click on K201
section).
2. Click
on Modules
3. Click
the SAM link
4. Create
Cengage Account (username, password etc)
5. Determine
subscription length desired (1 term, 1 year, 2 years) and click the radio
option button accordingly.
6. Pay
with credit card for the subscription (there is a 14 day free trial)
7. On
the Cengage Unlimited Home screen (Canvas, Modules, Cengage Unlimited Student Dashboard) you should ADD Tiles that are clickable in Cengage Unlimited. A Cengage/SAM section tile should show there because of
our Canvas integration.
- 9781285186139 Management Information Systems Seventh Edition by Sousa & Oz
- 9780357025765 New Perspectives Excel 2019 (MS Office 365) Comprehensive by Patrick Carey
- 9780357025758 New Perspectives Access 2017 (MS Office 365) Comprehensive by Shellman & Vodnik
8. Once
added you can access your K201 materials from Canvas, Modules (either a SAM
link for homework cases & exams, or Cengage Unlimited Student Dashboard for
e-texts)
Note: Once the
semester ends it may be helpful to know you can also access Cengage Unlimited
directly from your Cengage account (cengage.com) and that you have an
additional 12 months access to your favorite six e-texts after your subscription
expires.
Tuesday, September 12, 2017
K201 - Word of the Day
Fill Handle: Fill Handle is the square at the bottom-right corner of the active cell. Drag the fill handle
to copy data or to fill adjacent cells with a series of data.
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.
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.
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 https://login.cengagebrain.com/cb/
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
Subscribe to:
Posts (Atom)