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.