UMUC IFSM201 2018 December All Assignments & Research Paper Latest

IFSM201 Concepts and Applications of Information Technology
Week 1 Assignment
Excel Project 1 – MS Excel
(Fall 2018)
Use the following project description to complete this activity (all the details are included in this document, in the 22 steps below). For a review of the rubric used in grading this exercise, click on the Assignments tab, then on the title “Excel Project 1.” Click on Show Rubrics if the rubric is not already displayed.
Summary
Create a Microsoft Excel workbook with four worksheets that provides extensive use of Excel capabilities including charting, and written analysis and recommendations in support of a business enterprise.
A large rental car company has two metropolitan locations, one at the airport and another centrally located in downtown. It has been operating since 2015 and each location summarizes its car rental revenue quarterly. Both locations rent four classes of cars: economy, premium, hybrid, SUV. Rental revenue is maintained separately for the four classes of rental vehicles.
The data for this case resides in the file fall2018rentalcars.txt and can be downloaded by clicking on the Assignments tab, then on the data file name. It is a text file (with the file type .txt).
Do not create your own data. You must use the data provided and only the data provided.
Default Formatting. All labels, text, and numbers will be Arial 10, There will be $ and comma and decimal point variations for numeric data, but Arial 10 will be the default font and font size.
IFSM201 Concepts and Applications of Information Technology
Week 2 Assignment
Use the project description below to complete this activity (all the details are included in this document). For a
review of the complete rubric used in grading this exercise, click on the Assignments tab, then on the title
“Excel Project 2.” Click on Show Rubrics if the rubric is not already displayed.
Summary
Create a Microsoft Excel workbook with four worksheets that provides extensive use of Excel capabilities
including charting, and written analysis and recommendations in support of a business enterprise.
A large rental car company has two metropolitan locations, one at the airport and another centrally located in
downtown. It has been operating since 2015 and each location summarizes its car rental revenue
quarterly. Both locations rent four classes of cars: economy, premium, hybrid, SUV. Rental revenue is
maintained separately for the four classes of rental vehicles.
The data for this case resides in the file fall2018rentalcars.txt and can be downloaded by clicking on the
Assignments tab, then on the data file name. It is a text file (with the file type .txt).
Do not create your own data. You must use the data provided and only the data provided.
Default Formatting. All labels, text, and numbers will be Arial 10, There will be $ and comma and
decimal point variations for numeric data, but Arial 10 will be the default font and font size.
IFSM201 Concepts and Applications of Information Technology
Week 3 Assignment
Excel Project 3 – MS Excel
Use the project description HERE to complete this activity. For a review of the complete rubric used in grading
this exercise, click on the Assignments tab, then on the title Excel Project #3. Click on Show Rubrics if the
rubric is not already displayed.
Summary
Create a Microsoft Excel file with four worksheets that provides extensive use of Excel capabilities for charting.
The charts will be copied into a Microsoft PowerPoint file and the student will develop appropriate findings and
recommendations based on analysis of the data.
A large rental car company has two metropolitan locations, one at the airport and another centrally located in
downtown. It has been operating since 2015 and each location summarizes its car rental revenue quarterly.
Both locations rent four classes of cars: economy, premium, hybrid, SUV. Rental revenue is maintained
separately for the four classes of rental vehicles.
The data for this case resides in the file fall2018rentalcars.txt and can be downloaded by clicking on the
Assignments tab, then on the data tile name. It is a text file (with the file type .txt).
Do not create your own data, you must use the data provided and only the data provided.
Default Formatting. All labels, text, and numbers will be Arial 10, There will be $ and comma and
decimal point variations for numeric data, but Arial 10 will be the default font and font size.
 
IFSM201 Concepts and Applications of Information Technology
Research Paper
Research Paper Using Word
This assignment has two goals: 1) have students increase their understanding of
ethical issues related to the use of information technology through research, and 2)
learn to correctly use the tools and techniques within Word to format a research paper,
including use of available References and citation tools. These skills will be valuable
throughout a student’s academic career. The paper will require a title page, NO
abstract, three to five full pages of content with incorporation of a minimum of 3 external
resources from credible sources and a Works Cited/References page. Wikipedia and
similar general information sites, blogs or discussion groups are not considered
creditable sources for a research project. No more than 10% of the paper may be in the
form of a direct citation from an external source.
A list of topics from which students can choose is provided below.
Topics for Research Paper
The focus of the paper should be on the following:
1. how information technology supports or makes possible biometrics and its
various implementations, and potential ethical and privacy issues related to the
use of biometrics.
2. how information technology supports or makes possible the development of
artificial intelligence (AI) and intelligent agents (such as Siri, Cortana, etc.) and
potential ethical and privacy issues related to AI.
3. how information technology supports or makes possible the development of
robots as intelligent as humans, smart machines and the IoT, What potential
benefits and risks can/will robots introduce?
4. how information technology supports or makes possible genome-based
treatments for curing diseases, and potential ethical and privacy issues that
might result from use of such treatments.
5. how information technology impacts family, eldercare, and parenting issues, and
potential ethical and privacy issues introduced by the use of information
technology and information systems in this area
6. how information technology has enhanced the use of computer-assisted
education in the elementary school classroom, and the possible positive and
negative impacts this enhancement provides.
7. issues facing the IT Manager or Security professional (e.g., privacy, ownership,
control, accuracy, and security) in an environment where information technology
is constantly expanding and changing.
8. how information technology plays a role in the era of Edward Snowden, Chelsea
Manning, WikiLeaks, et and the impact on defense information systems
9. how information technology plays a role in the rise (and fall) of cryptocurrency
and the positive and negatives of switching to the bitcoin environment.
If there is another topic that addresses ethical issues as related to information
technology that is of special interest to you but one that is not in the list above, request
permission from your instructor before selecting this alternate topic.
Writing Quality for the Research Paper
* All Grammar, Verb Tenses, Pronouns, Spelling, Punctuation, and Writing Competency
should be without error.
* Be particularly careful about mis-matching a noun and pronoun. For example, if you
say “A person does this…” then do not use “their” or “they” when referring to that
person. “Person” is singular; “their” or “they” is plural.
* Remember: there is not their, your is not you’re, its is not it’s, too is not to or two, site
is not cite, and who should be used after an individual, not that. For example, “the
person WHO made the speech” not “the person THAT made the speech.”
* In a professional paper one does not use contractions (doesn’t, don’t, etc.) and one
does not use the personal I, you or your. Use the impersonal as in the previous
sentence. It is more business-like to say “In a professional paper one should not use
contractions,” rather than saying, “In a professional paper you don’t use contractions.”
*Remember: spell-check, then proofread. Better yet, have a friend or colleague read it
before submitting it. Read it out loud to yourself. Read it as if you are submitting it to
your boss.
You can find instructions on how to use the References tool in Word on a PC or
on a Mac in the separate file attached here.
Complete rubrics for this paper are found in the table on the next page.