Welcome to IFSM201
Concepts and Applications
of Information Technology
This is a Hybrid class which meets 2.5 hours per week for lecture and you are required to attend all lecture classes. In lieu of the second class you are expected to work on assignments independently and work through Open Learning Initiative (OLI) content that is integrated into LEO. Use of a computer, Internet connection, and LEO (campus.umuc.edu) is required for hybrid classes.
You will be required to submit all assignments online using LEO, and consider this hybrid class as good training for taking an Online UMUC class in the future. LEO can be accessed using either URL http://campus.umuc.edu (preferred) or http://learn.umuc.edu/ (backup)
The Microsoft Office 2010 Suite is recommended for all assignments because it is available in the UMUC computer lab/testing center. However, Microsoft recently came out with Office 2016 so if you want to spend money on software then you are likely better off with the newest version. One issue with Microsoft Office is they significantly change the adaptive Ribbon User Interface with each version so it is sometimes difficult to find the command you want. Another issue is that Microsoft has never ported the Microsoft Access database application to MacOS.
Alternatively, I recommend using the free LibreOffice, which is available at www.libreoffice.org/download/libreoffice-fresh/ and functions equally well on Windows 7-10, MacOSX, and Linux. Good documentation is available at www.libreoffice.org/get-help/documentation/ and I recommend you download and read the LibreOffice Getting Started Guide if you chose to use this freeware software. LibreOffice is a fork of OpenOffice open-source software and has better support.
It is recommended that you print posted PDF documents at the beginning of the week like PowerPoint slide handouts (4 slides per page) and assignments prior to class so that you can take notes when they are covered in lecture.
Please bring a USB Drive that is 1 GigaByte or greater to class this week and every week. It is best if the USB Drive attaches to your key ring so that it is less likely to be lost. You may use the UMUC computer lab to work on your assignments and all computers in the lab have Windows 7 and Microsoft Office 2010. Keep all files on your USB Drive if you intend to use the UMUC computer lab or your home computer to do your assignments. If you plan on using a MacOS computer then please format your USB Drive to exFAT or FAT32 so that it is readable by both MacOS and Windows. You may want to install LibreOffice to your USB Drive, which will allow it to run on any Windows computer including the ones in UMUC Computer Lab if you install PortableApps.com to your drive and also LibreOffice portable edition. Unfortunately, LibreOffice is not installed on computers in the UMUC computer lab.
To make sure your home computer is properly set up for the class please review the Technical Requirements below:
To ensure a smooth experience as you go through the course resources, please read the technical requirements provided below. If you have a technical problem in your LEO class, contact Help@UMUC at http://help.umuc.edu/ or by phone at 1-888-360-UMUC (8682). Help@UMUC is available 24 hours a day, 7 days a week.
For some of the interactive examples and exercises in this course, you will need the Shockwave Flash plug-in. To test whether you have this plug-in (and if you do not, to download it), click on test for Flash plug-in.
You may also need to access PDF files in this course, which require that you have the Acrobat Reader plug-in from Adobe. To test whether you have this plug-in, click on test for Acrobat Reader. If you have Acrobat installed, you will receive a confirmation. If you receive anything other than a clear confirmation, you will need to download and install either Acrobat Reader or PDF-XChange Viewer.
I recommend that you get started with Week 1 content today, by clicking Week 1 in the navigation bar above or scrolling down.
Robert Laurie
Week 1: Data Representation
Lecture This Week
This week in lecture we will be discussing the Syllabus, LEO course management system, OLI Classroom, and investigate Data representation for different number systems used in computing and ASCII codes. Prior to class, please print and read the syllabus and the Number Systems and Codes handout.
The LEO -Discussions are a kind of collective online discussion. This week you need to utilize five online discussions to introduce yourself and demonstrate that you have learned how to convert between various number systems and codes:
- Post your Introduction in the Discussion >> Introductions Topic
- Post in the Number System and Codes Conversion Discussion
- Binary to Decimal Conversion
- Binary to Hexadecimal conversion
- Hexadecimal to Binary Conversion
- Convert your name from ASCII to Hexadecimal
These LEO - Discussions exercises will provide you with an understanding of digital data, which is fundamental to understanding How computers work?
The file extension is important in Windows, because it determines which application will open the file. Unfortunately, Microsoft hides file extensions by default, but it is useful to view the file extensions of known file types within Windows Explorer file display pane. File extensions can be viewed by opening Windows Explorer and selecting the menu item
Tools > Folder Options > View Tab
.
Find and uncheck the check box labeled Hide extensions of known file types
. You will now be able to see the difference between filename.docx
file and filename.pdf
file.
You must be logged into LEO and then click the Link to the OLI Classroom below from within LEO to access the OLI content.
If you have any questions about the class or assignments feel free to post in the
LEO Discussion > Ask your Professor
or email me at:
Direct Links to YouTube Videos:
- WATCH: Mechanical Binary Counter Video
- WATCH: Converting Decimal, Binary and Hexadecimal Video
- WATCH: ASCII Video
- WATCH: Decode unicode: TEDxVienna Video
Activities
Please post in the five discussions below this week which are due next week at the end of class.
- Introductions Topic
- Binary to Decimal Conversion
- Binary to Hexadecimal Conversion
- Hexadecimal to Binary Conversion
- ASCII Text to Hexadecimal Conversion
Week 2: Hardware and Word Processing
OVERVIEW AND OBJECTIVES
This week you will look at the components, both internal and external, integrated and peripheral, that are used to create a complete computer system. In addition, you will learn about different user types and the category of computer that best satisfies their need. Finally you will look at how data is entered, processes, stored, and shared. Quizzes will test your understanding the the topics.
At the completion of this week's activities you should be able to:
- Identify the common configurations of system units.
- Identify the key internal components of a system unit and describe the purpose of the internal components
- Identify the key external components of a system unit and describe the purpose of the external components.
- Identify user types and relate specific user types with appropriate computer types.
- Identify the methods by which data is entered into the system unit.
- Identify how information (the result of processing) is displayed or stored.
- Compare various input and output devices and determine which ones best fit a specific situation or need.
- Compare various storage devices and determine which ones best fit a specific situation or need.
- Identify the main components that support communication between computers.
- Identify different types of home networks and the components required to set up a home network
- Create word processing documents for Assignment 1 and submit on LEO
Additionally, we will also discuss our first software application which is Word Processing. Actually, I don't really care which Word Processor you utilize. However, you must submit docx documents throughout the course which are the standard Microsoft Word 2007-16 file format. If you are new to Microsoft Office then please examine the Microsoft Office Bible - optional resources available for your version of Office in the LEO Course Resources. There is also a LEO Course Resources > Office 365 - Free Download page and if you would like to install this trial-ware on your computer then please let me know if it worked successfully for you.
I will utilize PowerPoint slides for lecture and discussion. The slide sets will be posted as PDF documents with four slides per page in color. Please print the following PDF files prior to class:
- Slide Set 1: Inside the Computer and Peripherals
- Slide Set 2: Word Processing
- Assignment 1: Word Processing
Videos about Computer Hardware:
- Microsoft Word 2010 Step by Step Courses Videos
- How a CPU is made at AMD
- How a CPU Works – 8-bit
- What Are Bits, and Are They Important? (32-Bit vs 64-Bit)
- How does a hard disk work
Videos about ALU (Arithmetic Logic Unit) binary operations:
- How To Do Binary Addition
- Two's Complement, and Binary Signed Magnitude
- Binary Subtraction with Two's Complement
- Multiplying in Binary
Interesting documents to read:
If you have any questions about the class or assignments feel free to post in the
LEO Discussion > Ask your Professor.
Content
Prior to class read and work through the two OLI modules contained in
OLI UNIT 1: Understanding the Computer System Unit.
After attending class work through Assignment 1: Word Processing this week. You may use any word processor to complete the assignment, but the preferred ones are Microsoft Word or LibreOffice Writer and the created word processing documents must be posted using the filename
.docx
file type.
After attending this week’s lecture and working through all OLI Unit 1 content then take three quizzes described below in the order given. You will have a maximum of 60 minutes to take each quiz and this timer cannot be paused. Only start the quiz when can allocate 60 minutes to complete each quiz. Note module quizzes are shorter and have fewer questions then the more comprehensive unit quizzes.
OLI UNIT 1: Understanding the Computer System Unit
- Module 1a: Components of the Computer System Unit – Read & Do
- Module 1b: Peripherals – Read & Do
- UNIT 1: Understanding the Computer System Unit – take Quiz
Activities
- Complete Unit Quiz - Unit 1 - Understanding the Computer System Unit (Modules 1a-1b)
- Complete Assignment 1 Wordprocessing
Week 3: Software and Spreadsheets
OVERVIEW AND OBJECTIVES
This week you will take a look at software - both system software (operating systems and utilities) and application software (categories and best uses). First, you will look at the relationship between the hardware studied last week and the software that enables the hardware to function in a way that supports the user. Next, you will look more closely at the operating system and the utilities that are essential to make a computer functions. Finally, you will review software application packages that are most commonly used for personal and work computer-related functions.
At the completion of this week's activities you should be able to:
- Explain the relationship between hardware and software.
- Identify the major categories of software and the purpose of each
- Explain the role of the operating system.
- Compare various operating systems and determine which one suits a specific situation.
- Identify utility programs included with an operating system and describe their purpose.
- Identify categories of application software and determine the best uses for each.
- Identify the differences between commercial software, shareware, freeware and public domain software.
- Compare installed software and web-based software and list advantages and disadvantages of each.
There are two types of Software: Operating System (OS) and Applications and they are covered in the first three modules of OLI UNIT 2: System and Application Software. Please read and work through these modules before coming to class this week so that you can ask intelligent questions.
The software application topic we will cover this week is spreadsheets in preparation for Assignment 2. Prior to class print the following PDF files to include two slide sets and Assignment 2:
Tutorial pages for Excel are available
- Office Footers-including dates in footers MS Office 2010
- Spreadsheet-Relative and Absolute Cell References
- Spreadsheet-Charting functions
Also begin working through the Academic Integrity Tutorial this week. This tutorial is not due until Week 6, but you must score a 90% or higher on the Academic Integrity Tutorial quiz to pass which may take several attempts at this quiz. The Academic Integrity Tutorial link is
https://www.umuc.edu/students/academic-integrity/tutorial.cfm
Interesting web sites to visit:
Interesting videos to view:
- Microsoft Excel 2010 Tutorial
- Windows 10 vs Linux | UI Comparison
- Windows 10 Spying - Privacy & Security
If you have any questions about the class or assignments feel free to post in the
LEO Discussion > Ask your Professor
Content
READ and Do before class this week
- Class 3 Readings: Unit 2-System and Application Software
- Module 2a-Purpose and functions of Software
- Module 2b-Operating System Software
- Module 2c-Application Software
- Module 2d-Software Licenses
- Read the information about the Academic Integrity Tutorial under the Assignments tab and start working through it. To complete this assignment you must get a passing grade of 80% on the quiz and you may take the quiz multiple times. Please save the completion certificate for future classes that may require it.
Activities
- Quiz - Unit 2 - Computer Software Modules 2a-2d
- Assignment 2: Spreadsheet - Personal Budget
- Academic Integrity Tutorial P/F
- Assignment 1: Word Processing - Computer Shopping
Class 4: Databases
OVERVIEW AND OBJECTIVES
This week you will be looking at the basic concepts or components used in the construction of database, read about different database structures, and investigate specific security issues related to use of databases. In addition, the relationships between Customer Relationship Management (CRM), data warehouses, and data mining will be introduced.
After completing the work this week, you should be able to:
- Identify the basic organization and components of a database.
- Define what is meant by the term customer relationship management (CRM).
- Explain how data warehouses and data mining tools are used to perform CRM.
- Identify the potential impact of CRM on a company's business.
- Explain some of the trends in SCRM and changes that must be implemented.
- Identify the importance of database security.
- Apply an understanding of confidentiality, integrity, and accessibility to issues of database security.
- Analyze a scenario to determine the type of database threat that is described.
- Identify basic questions that need to be addressed when evaluating database security.
- Identify steps an individual can take to secure information stored in personal databases or PII shared with businesses.
Content
This week we will be discussing Databases in preparation for Assignment 3. I will utilize PowerPoint slides for lecture and discussion. Please print the following PDF files to include both the slide sets and Assignment 3.
Prior to class use the Link to the OLI Classroom to class work through:
- Module 3a - Databases: Basics of Databases
Windows users have MS Access only in the Office Professional versions. MacOSX users will not have MS Access on any versions of MS Office, because Microsoft never ported the Access database application to MacOS. Therefore, if you would like to utilize MS Access to do Assignment 3 you will likely need to utilize the UMUC Computer Lab/Testing Center to utilize MS Access.
Alternatively, LibreOffice could be used for Assignment 3, and is available for free download and LibreOffice Base is their database program. LibreOffice will run on any operating system: Windows, MacOSX, and Linux. They have good documentation available for free in the LibreOffice document Getting Started 4.2 which is available as a free download as PDF. However, LibreOffice does not have the easy to use Wizards that Access has and will take more time to work through.
Under the Content tab, look under Course Resources (main Content tab on the top navigation bar) for optional online resources to assist you with MS Office or Open Office. And there are separate tutorials and a Tips file below for those using Open Office to complete this assignment.
If you have any questions about the class or assignments feel free to post in the LEO Discussion > Ask your Professor
Activities
- Participate in Discussion(s), as assigned
- Complete Unit Quiz - Unit 3 FINAL - Basics of Databases (Module 3a)
- Complete Assignment 3: Database - Project Management
- Complete Academic Integrity Tutorial
Under Table of Contents, look under Course Resources for optional online resources to assist you with MS Office and the projects in this course.
Week 5: Networking
OVERVIEW AND OBJECTIVES
This weeks topic will address the basic concepts involved in setting up networks and basic computer coding using Markdown to make web pages.
At the completion of this week's activities you should be able to:
- Develop a complete set of specifications for a computer setup in a small office setting - based on the hardware and the software components needed to create a computer, and the basic elements of networking.
- Experience computer coding by making a small web site on Jottit.com using Markdown coding
The lecture topic this week is Computer Networks and World Wide Web. Assignment 4alt will be creating a simple web site https://www.jottit.com using markdown coding. Prior to class print the following PDF files to include one slide set and Assignment 4:
The computer network content is available on LEO and consists of thirteen pages, which can be printed from the eBook following the instructions on LEO:
- Describing Network Components (about 6 printed pages)
- Classifying Networks by Function (about 2 printed pages)
- Defining Network Architectures (about 5 printed pages)
- Networking and Security Chapter
Interesting videos and web sites to view:
- MDN How does the Internet work?
- How Does the Internet Work? [video]
- How the Internet Works in 5 Minutes [video]
- www.warriorsofthe.net [video]
- Jottit.com tutorial [video]
- umuc.jottit.com
- www.jottit.com
Continue working through the Academic Integrity Tutorial that you should have started last week. You must receive a 90% or better on the Academic Integrity quiz to be issued a certificate for Academic Integrity.
If you have any questions about the class or assignments feel free to post in the
LEO Discussion > Ask your Professor
Content
Presentations - Network Basics
- Client-Server Technology
- Bandwidth
- Data Flow on the Internet
- Data Flow on the Internet (You Tube alternate)
Activities
Complete the Database assignment and Academic Integrity Tutorial before the due date.
Again you need to receive a 90% on the integrity to receive a certificate. Upload the PDF or Image of of your certificate to the Assignment Folder.
Since this is a 7-week term and we have many students this term, I will allow you to either do a web site or PowerPoint presentation about some research topic related to computers. If you chose to do the web site using markdown coding please work through the Assignment 4 and upload a file and the Hyperlink to your web site. Note that LEO requires you to upload a file for each assignment, but really only the Hyperlink will be graded to your markdown web site if you chose that option. We will discuss the PowerPoint presentation option next week.
Week 6: Issues in Computing - Ethics and Privacy
OVERVIEW AND OBJECTIVES
This week you will begin exploring some issues that are directly related to the use of computers and access to the internet. Some topics are related to using the computer and computer resources in the workplace (user access agreements and employee and professional associations codes of conduct. Other topics address personal use of computers, specifically issues related to legal use of software and issues that are specific to social networking.
At the completion of this week's activities you should be able to:
Define the purpose of a user access agreement and identify violations of what constitutes acceptable behavior.
- Define the role of policies and guidelines in constructing an employee code of conduct.
- Identify behaviors which comply with or may be violations of an employee code of conduct.
- Explain the purpose of the code of ethics adopted by professional associations or certifying organizations.
- Identify differences between the contents of an employee code of conduct and the code of ethics subscribed to by members of a professional organization.
- Define software piracy and learn about the importance of the Digital Millennium Copyright Act (DMCA).
- Identify appropriate (and inappropriate) uses of digital content sharing.
- Identify problem issues resulting from the misuse of social networking
READ
- Week 6 Readings: Unit 4-Issues in Computing
- Module 4a - Ethics
- Module 4b - Privacy
- The Digital Divide
- Online Media Fact or Fiction
- Online Addictions
- Accessible Information Technology for Persons with Disabilities
- If you have not already done so, read the information about the Academic Integrity Tutorial under the Assignments tab. This activity MUST be complete by the end of this week.
PowerPoint will also be discussed which is a presentation graphics program and it will be utilized for completing Assignment 4: Research Presentation. I will utilize PowerPoint slides for lecture and discussion. Please print the following PDF files:
- Slide Set 7: Ethics, Privacy, and PowerPoint
- Assignment 4: Research Presentation
- PowerPoint Tutorial – Timing, Transitions, and Sounds
- Possible Research Topics:
- The Digital Divide
- Online Media Fact or Fiction
- Online Addictions
- Accessible Information Technology for Persons with Disabilities
- Computer privacy
- Computer ethics
- Origin of the Internet
- 3D Printing
- Robots
- Online resources for job search
- VOIP = Voice over IP
- Hacking
- WiFi Networking
- Bluetooth Networks
- Local Internet Service Providers
- Voice Recognition Software
- Your favorite Massively Multiplayer Online game
- Intel vs. AMD CPUs
- Your favorite App or Program for photo editing
- Your favorite Linux distribution
- Your favorite App or Program for photo editing
- Your favorite App or Program for video editing
- Your favorite App or Program for audio editing
- or any other topic related to computers but ask me first.
If you have any questions about the class or assignments feel free to post in the
LEO Discussion > Ask your Professor
Content
- Module 4a - Ethics
- Module 4b - Privacy
Activities
Select a topic for research in the Class 6 Discussion and respond to two other students posts with suggestions for research sources.
The content from Module 4a - Ethics and Module 4b - Privacy will be on next weeks Quiz 4. However, we will discuss it in class this week.
APA Requirements for This Class
Much of the information below comes from the APA Tutorial, available through the Effective Writing Center, under the Resources tab above. For this class, the main focus of APA formatting is on citations and references, and papers with incorrect citations and/or references will lose points on the grade.
APA format is more than simply using in-text citations and full references. Writers apply APA format to their work for the following reasons:
Providing in-text citations and full references tells readers what sources were used to write an article or book.
Using APA format ensures consistency in the conventions writers use and readers expect in publications.
Including in-text citations and full references credits writers in their field for the research they have conducted.
Using APA format protects writers from being plagiarized and from plagiarizing others.
The reference list gives the reader the information necessary to locate and retrieve any source you cite in your paper. Full references are always listed on a separate page at the end of a paper and match one-to-one with a citation that appears in a paper. Every source you cite in the paper must appear in your reference list; and, every entry in the reference list must be cited in your text. If you review other sources, but do not cite them, they are not included in the reference list. The reference page is labeled as: References centered and bolded and always plural. Each reference appears in alphabetical order by the first word, and no numbering is used. Each entry is single spaced, with the first line at the margin and the second and subsequent lines indented one-half inch. Use double spacing between entries.
For full examples of how to create correct APA citations and reference lists, go to:
http://www.umuc.edu/library/guides/apa.shtml
Another excellent, concise guide to APA citations and references list can be found here:
http://www.lib.sfu.ca/help/writing/apa
- Assignment 3: Database - Project Management
- Assignment 4: Research Topic Web Site
- Assignment 5: Research Topic Presentation
- The Academic Integrity Tutorial
The Academic Integrity Tutorial (https://www.umuc.edu/
students/academic-integrity/ tutorial.cfm) has been added as a required assignment. You will be required to finish it by the end of Week 5 (although it can be completed any time before that). When you have completed the tutorial post a copy of the completion certificate in the assignment folder. The due date is the last day of Week 5 or earlier if you wish.
If you do not complete the assignment before the due date, 0 points are granted.
You must receive a 90% or better on the Academic Integrity quiz to be issued a certificate for Academic Integrity and it may be taken multiple times. Once you receive the certificate you need to save it to your computer as a PDF file.
- Chrome web browser users this can be done by printing the web page and save as a PDF file to your computer.
- MacOSX and Windows 10 users have the capability of printing to PDF from any app.
- Windows 8.1 or lower users can install the freeware PDF Printer app from www.bullzip.com to have this capability.
- Alternatively, Windows users can use the Accessories >> Snipping App to screen capture the image of the certificate as a JPG file.
Upload this PDF or JPG file to the Academic Integrity Tutorial to receive points for this assignment.
- Class 6 Discussion - Computers and Society Research Topic
Choose one of the topics to explore. You will develop this topic into the Assignment 4: Research presentation and we want to avoid duplication.
Do some additional research on the topic. And cite your sources. Please do NOT make Wikipedia your primary source. You may use it, but there should be other reputable sources.
When you post your response, put the chosen topic in the subject line.
Possible Research Topics:
- The Digital Divide
- Online Media Fact or Fiction
- Online Addictions
- Accessible Information Technology for Persons with Disabilities
-
Computer privacy
-
Computer ethics
-
Origin of the Internet
- 3D Printing
- Robots
- Online resources for job search
- VOIP = Voice over IP
- Hacking
- WiFi Networking
- Bluetooth Networks
- Local Internet Service Providers
- Voice Recognition Software
- Your favorite Massively Multiplayer Online game
- Intel vs. AMD CPUs
- Your favorite App or Program for photo editing
- Your favorite Linux distribution
- Your favorite App or Program for photo editing
- Your favorite App or Program for video editing
- Your favorite App or Program for audio editing
- or any other topic related to computers but ask me first.
How serious an impact does your chosen problem have on your quality of life?
Respond to two other students after they post their topic with suggestions for sources of information about their topic. Large topics could be divided into smaller ones so use this discussion to "mark out your topic territory" and avoid duplication.
REMEMBER- grading of your participation will be according to the table outlined in the Grading Policy/Rubric for Class Participation (Online course, Weeks 1 - 8)
Week 7: Issues in Computing - Security and the SDLC
OVERVIEW AND OBJECTIVES
You will complete your look at specific issues in computing this week by focusing on security in terms of confidentiality, integrity, and availability (CIA). Then the focus will shift to methods for protecting one's personally identifiable information (PII) from cyber criminal tactics.
As a separate but equally important avenue of exploration, the system development life cycle (SDLC) will be addressed. Because our focus this entire course has been on computer basics, it is important to understand how computer systems are designed and developed. There are several SDLC models that are in common use, and the various phases of development will be aligned with several of the models.
READ
Military Robots Check out this video for ideas:
https://youtu.be/PVT5TfFL4Os
Or if the robots become self aware and autonomous we may find that cylons from Battlestar Galactica will become a reality series:
https://youtu.be/6za76h5bEj4
and of course don't turn over launch authorization to a computer.
https://youtu.be/t46Kjy-IJpY
- Week 7 Readings:
- System Development Life Cycle
- Unit 4-Issues in Computing
- Module 4c - Security
DO
- Complete Unit Quiz - Unit 4 - Issues in Computing (Modules 4a-4c)
This week we will be discussing Computer Security and IT System Development Life Cycles. I will utilize PowerPoint slides for lecture and discussion. Please print the following PDF file:
If you have any questions about the class or assignments feel free to post in the
LEO Discussion > Ask your Professor
Content
- Module 4c - Security
Activities
- Complete Quiz - Unit 4 - Issues in Computing Modules 4a-4c
- Complete Unit Quiz - Unit 4 - Issues in Computing
- Submit Research Presentation
Week 8: Research Presentations
This is the last week of our classes. This week you will be doing the talking doing presentations about some topic related to computers using PowerPoint.
You need to upload your PowerPoint presentation to LEO prior to your scheduled class. You must attend class this week to get allocated points for the actual presentation.
All work must be completed by Thursday this week. Anything completed after Thursday will not be considered when determining your course grade.
It was a pleasure to have you in the class this session and I wish you much success with your education and career development.