IFSM201 Full Course – All Discussions and Assignment

Week 1

Conference Instructions:Each person please make at least one response to one ofthe posted questions. However, the point of this class is not for you to just memorize a bunch of facts. Instead we are going to make a real effort, to promote critical thinking and the ability to actually applythe concepts that you will learn here. So, you may have to do some digging and some synthesis to effectively respond to the questions I ask.

You can also follow up other students responses for additional grading credit. It is very important to participate in this discussion conference each week.

Week 1 Questions:This week we’re talking about technology basics. Please pick one question and respond to it. Try to provide an effective response that could stand on its own, but please be sure to cite any sources you use, and please provide the links to any internet sources so we can check them out.

Q1 What is a computer? What is the key capability of a computer that makes it different from other kinds of “machinery” or consumer electronics?

Q2. How is Data different from Information? How does a computer turn data into information?

Q3. According to the courts, what does the First Amendment of the U.S. Constitution allow for internet free “speech?” May the Government browse Web sites without a warrant in order to nip terrorism plots in the bud? What does the Fourth Amendment’s search and seizure provisions allow with regard to shutting down objectionable web sites? What about sites that are hosted overseas?

Q4. How Should Schools Deal with Internet Plagiarism?

Q5. Can Computers Think?

Q6. This is a several part question, related to the use of the internet particularly for this class, as well as other situations where you may want to make sure the information you are getting is accurate.

· Who is responsible for the accuracy of Web Pages?

· What is the benefit of using information from the internet in class or for other personal information needs?

· What are key problems and risks associated with accuracy of information on the internet (e.g. Wikipedia)?

· What measures can you take to ensure that the information you are getting is accurate?

· What are some of the key security and safety risks associated with accessing information from the internet?

· What is the challenge associated with publication in scholarly journals, that may cause journal editors and librarians to discourage the use of internet sources in scholarly research?

Please pay attention to what has been posted earlier. The intent is that these posts should build on one another to yield a complete picture of how to use the internet effectively. This question is a collaborative class exercise – no person is individually responsible for responding to all 6 parts of the question. Follow-up posts can drill down to more detail on specific areas (e.g. focus on just one component such as the Security and Safety risks.)

Q7. Here are some current topics on computing. You may pick one topic that interests you and explain it to us:

· Selling Processing Power over the Internet

· Optical Computing

· DNA Computing

· Quantum Computing

· Extending Battery & Recharging Technology

· Nanotechnology

· NVIDIA chips versus Intel chips

· Bendable notebook computers

· The phablet versus the laptop

· Computers in sports – live game or race statistics

WARNING – You will probably not find the answers to all these questions in the assigned reading. You’re going to have to do some digging and critical thinking. I look forward to engaging the class in this discussion!

Week 2

Conference Instructions:Each person please make at least one response to one ofthe posted questions. However, the point of this class is not for you to just memorize a bunch of facts. Instead we are going to make a real effort, to promote critical thinking and the ability to actually applythe concepts that you will learn here. So, you may have to do some digging and some synthesis to effectively respond to the questions I ask.

You can also follow up other students responses for additional grading credit. It is very important to participate in this discussion conference each week.

Week 2 Questions:This week we’re talking about Computer Hardware. Please pick one question and respond to it. Try to provide an effective response that could stand on its own, but please be sure to cite any sources you use, and please provide the links to any internet sources so we can check them out.

Q1 Why is it important to keep a computer clean? List the products necessary, and describe the procedure. How do I clean components in the system unit?

Q2 Consider the role of each of the following in your computer:

· Control Unit

· Arithmetic Logic Unit

· System Clock

· Power Supply

· Heat Sink

· Cache (what kinds are there?)

· Memory (what kinds of there?)

· Persistent Storage (what kinds are there?)

· Slots, Ports, Jacks and Connectors

· Additional components (keyboard, modem, screen, printer, etc.)

Describe how these all work together in your computer to do useful tasks.

Please attention to what has been posted earlier. The intent is that these posts should build on one another to yield a complete picture of how a computer operates. This question is a collaborative class exercise – no person is individually responsible for responding to all 10 parts of the question. Follow-up posts can drill down to more detail on specific areas (e.g. focus on just one component such as the System Clock)

Q3 – What is a multifunction peripheral(sometimes called all-in-one or convergence device)? What are some examples of these? Please get specific on this one – describe the device(s) and their relevant characteristics, pros and cons of the different choices. Note – there are a lot of them, so there’s scope for several posts on this topic.

Q4 – What is ergonomics? Why are ergonomics important, and what are some of the issues associated with ergonomics? Is your own workspace ergonomically designed?

Q5 – Describe the Americans with Disabilities Act (ADA). Adaptive technology helps people with special needs. Describe some input devices for physically challenged people. Note – there are a lot of them, so there’s scope for several posts on this topic.

WARNING – You will probably not find the answers to all these questions in the assigned reading. You’re going to have to do some digging and critical thinking. I look forward to engaging the class in this discussion!

Week 3

Conference Instructions:Each person please make at least one response to one of the posted questions. However, the point of this class is not for you to just memorize a bunch of facts. Instead we are going to make a real effort, to promote critical thinking and the ability to actually apply the concepts that you will learn here. So, you may have to do some digging and some synthesis to effectively respond to the questions I ask.

You can also follow up other students responses for additional grading credit. It is very important to participate in this discussion conference each week.

Week 3 Questions:This week we’re talking about software of all kinds. Please pick one question and respond to it. Try to provide an effective response that could stand on its own, but please be sure to cite any sources you use, and please provide the links to any internet sources so we can check them out.

Q1 – What is the difference between application software, system software and utility programs?

Q2 – What are the various kinds of application software: Packaged software, Custom software, Open source software, Shareware, Freeware and public-domain software?

Q3 – What word processing software (e.g WORD) features do you use the most? (Be sure to think about and include the features that you might often “take for granted” but which actually save you the most time.) Are there any features that don’t you use very often, but aspire to learn? What word processing features are the most important for the projects in this class?

Q4 – What spreadsheet software features (e.g. EXCEL) do you use the most? (Be sure to think about and include the features that you might often “take for granted” but which actually save you the most time.) Are there any features that don’t you use very often, but aspire to learn? What excel features are the most important for the projects in this class?

Q5 – What presentation graphics features (e.g. POWERPOINT) do you use the most? (Be sure to think about and include the features that you might often “take for granted” but which actually save you the most time.) Are there any features that don’t you use very often, but aspire to learn? What excel features are the most important for the projects in this class?

Q6 – Although most spreadsheet packages can manage data tables of a few thousand records, database software efficiently can handle much larger data tables. Define database and database software (sometimes called a database management system (DBMS)). Describe a record (or row) and a field (or column). What is a data type, and list some common types. Together, these items are known as the database table structure. Entering individual records is called populating the table. What is validation? What is a query?

Q7 – What kinds of software applications would you have for a smart phone? What applications are your favorites and why? How would those compare to what’s available for a PC?

Q8 – What are some commonly available software suites, and what applications do they include? What are the major advantages of a software suite? When does it makes sense to buy a software suite? When would it be wiser to purchase applications separately?

Q9 – What is a server, and what is a server usually used for? List some examples of software applications that are commonly on mainframes or servers. Have any of you ever used such applications directly? What are these applications used for?

Q10 – What are the advantages and disadvantages of using installed software vs a web application? If any of you used a web application please describe them.

Q11- What is a “killer app?”

Q12- An embedded systemis any electronic system that uses a CPU chip but that is not a general-purpose workstation, desktop, or laptop computer. It is a specialized computer system that is part of a larger system or a machine

1. a) What functions would such an embedded system control?
b) What functions of a normal desktop or laptop operating system would NOT be found in such an embedded system?

Q13 – What’s a cross-platform program? Give some examples of cross-platform programs that you might encounter on a daily basis.

Q14 – Define packaged software (sometimes called commercial off-the-shelf software). What’s the difference between horizontal market software and vertical market software?

WARNING – You will probably not find the answers to all these questions in the assigned reading. You’re going to have to do some digging and critical thinking. I look forward to engaging the class in this discussion!

Week 4

Conference Instructions:Each person please make at least one response to one of the posted questions. However, the point of this class is not for you to just memorize a bunch of facts. Instead we are going to make a real effort, to promote critical thinking and the ability to actually apply the concepts that you will learn here. So, you may have to do some digging and some synthesis to effectively respond to the questions I ask.

You can also follow up other students responses for additional grading credit. It is very important to participate in this discussion conference each week.

Week 4 Questions:This week we’re talking about Networks and Communications. Please pick one question and respond to it. Try to provide an effective response that could stand on its own, but please be sure to cite any sources you use, and please provide the links to any internet sources so we can check them out.

Q1 – Define communications. What are the elements needed for successful communications?

Q2 – Several kinds of wireless communications services are available. Please pick one and describe it – how it works, how you use it, and any security risks or concerns that may be associated with it.

Q3 – What’s the difference between a hot spot, a 3G network and a 4G network? How are these similar and how are they different?

Q4 – How does a GPS work? How has GPS data been used to improve business efficiency and the quality of our lives? Are there any security risks or privacy concerns that may be associated with it?

Q5 – What kinds of software and network capabilities help in collaborating and online meetings? How do these work and what do they do? What are the pros and cons associated with using them?

Q6 – What’s the difference between EDI, XML and HTML? How are these protocols used and for what purposes?

Q7 – How does packet switching work? How does this differ from the way the public switched telephone network (PSTN) works?

Q8 – What is an ISDN line? What is a T-1 line?

Q9 – How does wireless Ethernet, or a Wi-Fi network work?

Q10 – Are Wi-Fi and Bluetooth competing or complementary technologies?

Q11 – Are digital modems, such as cable or ISDN modems, really modems?

Q12 – What are bandwidth and latency, and why do we care?

Q13 – Why don’t today’s wired computer networks use coaxial cable? What do they use?

Q14 – Take a look at these following three Web sites on Web Browsers:

http://en.wikipedia.org/wiki/List_of_web_browsers

http://en.wikipedia.org/wiki/Comparison_of_web_browsers

http://browsershots.org/What did you learn or find interesting from looking at these sites?

Q15 – Please consider the pros and cons of the various broadband services available (e.g. DSL, Cable, ISDN)

Q16 – What is the difference between an IP address and domain name?

Q17 – Besides the World Wide Web, what other services are available on the Internet?

Q18 – The term “Underground Web” was coined by a 2002 Business Week article. Here’s a link to the article. : http://www.businessweek.com/magazine/content/02_35/b3797001.htm what is it?

Q19 – How does E-mail work? (Please address two additional specific issues: The internet protocol(s) used to send and receive emails, and the role of clients versus servers in processing emails.)

WARNING – You will probably not find the answers to all these questions in the assigned reading. You’re going to have to do some digging and critical thinking. I look forward to engaging the class in this discussion!

Week 5

Conference Instructions:Each person please make at least one response to one of the posted questions. However, the point of this class is not for you to just memorize a bunch of facts. Instead we are going to make a real effort, to promote critical thinking and the ability to actually apply the concepts that you will learn here. So, you may have to do some digging and some synthesis to effectively respond to the questions I ask.

You can also follow up other students responses for additional grading credit. It is very important to participate in this discussion conference each week.

Week 5 Questions:This week we’re talking about Data and Databases. Please pick one question and respond to it. Try to provide an effective response that could stand on its own, but please be sure to cite any sources you use, and please provide the links to any internet sources so we can check them out.

Q1 – What are the different kinds of input data? Are programs data? Are commands data?

Q2 – For each of the kinds of input data from the 1st question, what are some different ways that this data can be input into a computer? Please get specific on this one – describe the device(s) and their relevant characteristics, pros and cons of the different choices related to your choice of input data. So if you were purchasing one of these devices, which one would you choose, and why?

Q3 – What kinds of biometrics are there? What are some of the issues associated with biometrics?

Q4– What are the four basic categories of output?

Q5 – For each of the kinds of output data from the 5th question, what are some different ways that this data can be output from a computer? Please get specific on this one – describe the device(s) and their relevant characteristics, pros and cons of the different choices. So if you were purchasing one of these devices, which one would you choose, and why?

Q6 – What is the principle, garbage in, garbage out (GIGO)? Describe accurate information, verifiable information, timely information, organized information, accessible information, useful information, and cost-effective information.

Q7 – What is the difference between a bit and byte? In the ASCII and EBCDIC coding schemes, how are numbers used to represent characters? What are other common data types? What’s a BLOB?

Q8 – What’s validation? What are some kinds of validity checks? What’s a check digit — and how are check digits used?

Q9 – What’s a file processing system? What are the advantages and disadvantages of a file processing system?

Q10 – What’s a database — how is it similar and different from a file processing system? What are the advantages and disadvantages of a database?

Q11 – What kinds of security features do databases typically provide? Why are these important?

Q12 – What kinds of backup features do databases typically provide? Why are these important?

WARNING – You will probably not find the answers to all these questions in the assigned reading. You’re going to have to do some digging and critical thinking. I look forward to engaging the class in this discussion!

Week 6

Conference Instructions:Each person please make at least one response to one of the posted questions. However, the point of this class is not for you to just memorize a bunch of facts. Instead we are going to make a real effort, to promote critical thinking and the ability to actually apply the concepts that you will learn here. So, you may have to do some digging and some synthesis to effectively respond to the questions I ask.

You can also follow up other students responses for additional grading credit. It is very important to participate in this discussion conference each week.

Week 6 Questions:This week we’re talking about Privacy and Security. Please pick one question and respond to it. Try to provide an effective response that could stand on its own, but please be sure to cite any sources you use, and please provide the links to any internet sources so we can check them out.

Q1 – What is a computer security risk? What different kinds of risks do security administrators have to worry about?

Q2 – Why does information transmitted over a network (particularly wireless networks) have a higher degree of security risk?

Q3 – How are a computer virus, a worm, and a Trojan horse similar? How are they different? How do they spread?

Q4 – What precautions can you take to protect yourself against malware?

Q5 – How do security programs like Norton work? In your experience, how well do they really work?

Q6 – What’s a zombie? (No not the kind from a horror film, we’re talking about computers here!) Who uses zombies and what for?

Q7 – What’s a firewall? Do you have one?

Q8 – What’s an audit trail?

Q9 – What are some good guidelines for setting and protecting passwords? Why are these important?

Q10 – What’s a possessed object and how are they used?

Q11 – There are many biometric technologies. Describe one and its associated pros and cons.

Q12 – What are some security risks associated with computer hardware, and what measures can be taken to mitigate them?

Q13 – Who is the Business Software Alliance (BSA) as what do they do?

Q14 – Who wants your personal information and what can malicious people do if it falls into the wrong hands? How do they get it? How can you stop them?

Q15 – How can you recover information if your computer or hard disk crashes? What kinds of backups are there? What’s a RAID disk?

Q16 – What’s social engineering?

Q17 – What are some pro and cons associated with employee monitoring? Is it legal?

Q18- What risks and safeguards are associated with wireless communication?

Q19- What is “war driving” or “war flying”?

Q20 – Are you comfortable (or would you use) a wireless “hot spot” to do computer work? Would you use your credit card there?

Q21 – Are you more at risk using a wireless connection via laptop or a connection via a smart phone?

WARNING – You will probably not find the answers to all these questions in the assigned reading. You’re going to have to do some digging and critical thinking. I look forward to engaging the class in this discussion!

Week 8

Conference Instructions: Each person please make at least one response to one of the posted questions. However, the point of this class is not for you to just memorize a bunch of facts. Instead we are going to make a real effort, to promote critical thinking and the ability to actually apply the concepts that you will learn here. So, you may have to do some digging and some synthesis to effectively respond to the questions I ask.

You can also follow up other students responses for additional grading credit. It is very important to participate in this discussion conference each week.

Week 8 Questions: This week we’re talking about Computers, Technology and Society. Please pick one question and respond to it. Try to provide an effective response that could stand on its own, but please be sure to cite any sources you use, and please provide the links to any internet sources so we can check them out.

Q1 – What is a convergence device? List some example of such devices that are in common use. What are the advantages and disadvantages of using such devices?

Q2 – What is personalization? What are some examples of personalized information services now available, which might not have been available just a few years ago? What are the advantages and disadvantages of using such service?

Q3 – How do Portable Media Players work? How does this differ from older technologies (e.g the “Boom Box” or Sony Walkman) In addition to use for personal recreation, what are some practical (e.g. school, business or government) related use to which these technologies have been applied? Are there any convergence devices that incorporate these technologies?

Q4 – How do Digital Cameras work? How does this differ from older technologies (e.g Kodachrome or Polaroid) In addition to use for personal recreation, what are some practical (e.g. school, business or government) related use to which these technologies have been applied? What convergence devices incorporate these technologies?

Q5 – What is the difference between a PDA and a Tablet PC? How do these devices work and what do they do? How does this differ from older technologies (See for example, the Apple Newton) In addition to use for personal recreation, what are some practical (e.g. school, business or government) related use to which these technologies have been applied? What convergence devices now incorporate these technologies?

Q6 – How does Digital Television work? How does this differ from older technologies (e.g “analog TV”) and what are the important differences between the different Digital TV standards? In addition to use for personal recreation, what are some practical (e.g. school, business or government) related use to which these technologies have been applied? Are there any convergence devices that incorporate these technologies?

Q7 – How does an E-Book Reader work? How does this differ from older technologies (e.g reading books on your laptop computer, or talking books?) In addition to use for personal recreation, what are some practical (e.g. school, business or government) related use to which these technologies have been applied? Are there any convergence devices that incorporate these technologies?

Q8 – How do Video Games work? How and why does a video game machine differ from your personal PC? In addition to use for personal recreation, what are some practical (e.g. school, business or government) related use to which these technologies have been applied? Are there any convergence devices that incorporate these technologies?

Q9 – What is the digital divide? What is its effect, and what is or can be done about it?

Q10 – What have been some of the negative social effects of the increased use and availability of Information Technology in recent years? Can any of these be mitigated?

WARNING – You will probably not find the answers to all these questions in the assigned reading. You’re going to have to do some digging and critical thinking. I look forward to engaging the class in this discussion!

Personal Budget (Excel) Project

Personal Budget Exercise – 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 Personal Budget (Excel).Click on Show Rubrics if the rubric is not already displayed.

Creating a spreadsheet to track personal expenses is an excellent use of Microsoft Excel. For this exercise, you will create a spreadsheet to enter a personal budget and track actual expenses for the year. You may choose to use real data or create a fictitious budget using a monthly income amount of $3,500

Here are suggested budget categories if you are not using a real budget. At a minimum, you must have 9 budget categories:

Housing (mortgage or rent) Food
Utilities Miscellaneous
Car payment Entertainment
Insurance Gas
Student Loans Savings

Note: there are several tutorials on Excel functions that can be found in the topic labeled “Optional Tutorials – Excel project” in the Content (Readings) list for Week 1.

Requirement Points Allocated Comments
1 Open Excel and save a blank worksheet with the following name:

“Student’s First InitialLast Name Excel”
Example: JSmith Excel

Set Page Layout to Landscape

0.1 Use Print Preview to review how spreadsheet would print.
2 In the worksheet, insert a Custom Headertitled, “My PersonalBudget.” 0.25 This Custom Header text must be Arial 14 point, Bold, and be centered on the page.
3 Add a custom Footerwith your name in the Left Section and automatic pagination in the Right Section.Put a fixed date (use the date this assignment is due) in the center portion of the footer. 0.3 Text format is Arial 10 point

Normal.

4 Enter column headings :

BUDGET ITEM, PROJECTED COSTSand the 12 months for the year: JANUARY THROUGH DECEMBER

You may abbreviate the months as follows: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG,
SEP, OCT, NOV, DEC

0.3 All column headings must use the following text formatting:

Arial 10 point

Bold

Text centered in column

All capital letters

5 Enter your personal budget categories/labels(either your own or the list provided) in the rows under the column headingBUDGET ITEM.

A minimum of 9 categories is required.

0.25 Text format is Arial 10 point, Normal.

Align text Left in the cell.

6 Format all cells containing numeric data to Currency, using two decimal places. If you have this set up correctly MS Excel will automatically insert a “$” in front of the amounts that you enter. 0.25 I will be able to tell if you simply typed in the “$.” This will result in zero (0) points for this item. If any other format is used besidesCurrency, the score will be zero (0) for this component.
7 In the column under your PROJECTED COSTSlabel, enter a monthly budget goal amount for each BUDGET ITEM category. This would be the limit of what you want to spend on each category in one month’s time. 0.25 Arial 10 point

Bold
Black

Align values Right in column

8 Enter the label “PROJECTED BUDGET TOTAL:” in the next rowin the BUDGET ITEM column. 0.1 Use the following formats:

Arial 10 point

Bold

Blue

Align text Right in the cell

9 Use the SUM function to calculate the total amount of the PROJECTED COSTS column in the cell to the right of this label (under the PROJECTED COSTS values). (This amount should equal your income amount of $3,500 or your selected budget goal.)
Note: do not enter each cell in the column individually when using the SUM function.
Note: this amount should appear in ONLY ONE cell (not copied to remaining cells in the same row).
0.3 Arial 10 point

Normal

Black

Align values Right in the cell

10 Under the heading for each Month, enter an actual expense amount for that item for that month. (For example, in the winter months, your utility bills might be higher). While some items might be the same from month to month, DO NOT enter the same amount for all items across the months. In each month you want to be close to you monthly income number but do not always have to match it exactly. 0.3 Use the following text format:

Arial 10 point

Normal

Align values Right in the cell

11 In the next row in the BUDGETITEM column(under the PROJECTED BUDGET TOTALlabel) enter the label “Total Monthly Expenses.” 0.1 Use the following text format:
Arial 10 point
Bold
Green

Align text Right in the cell
12 For the cells in this Total Monthly Expenses row, insert a formula that will calculate the total actual expenses for each month. Use the SUM function to add the amounts in each column and show the result.
Note: do not enter each cell in the column individually when using the SUM function.NOTE: do not include empty cells in your formula.
0.5
13 In the next row under the “Total Monthly Expenses” label put the label “Projected versus Actuals.”` 0.1 Use the following text format:
Arial 10 point
Bold
Black

Align text Right in the cell
14 Then in the cell under the Total Monthly Expenses for each month, use a formula that will subtract the actual total expenses for the month from the projected budget total(the target amount in the PROJECTED BUDGET TOTALcolumn).

You must use Absolute Reference in your formula

If the result of your calculation is a positive number, then you are under budget for the month. (You have money left over). If the number is negative, then you are over budget for the month. (You didn’t have enough money to pay all of the expenses that month).

*You will use the result of this calculation to answer Question 3 below

0.5
15 Enter a column label titled “Total” to the right of your last month. 0.1 Format – for all cells in this column:
Arial 10 point
Bold
Blue
Align center in cell
16 Enter a formula using the AutoSum drop-down option on your tool bar and insert the Sum function in the first budget item row, under Total. Then copy this formula down for all the other categories. This will calculate the total expenditures for each BUDGET ITEM in your budget list over the span of the year.

NOTE: Be certain to total just the months; do not include the PROJECTED COSTS column.

NOTE: do not enter each cell in the row individually when using the SUM function

0.5 Use the following formats:

Arial 10 point

Bold

Blue

Align values Right in the cell –

You must use Excel to build a formula for adding the item amounts. If you simply type in a total, I will be able to tell and will award zero (0) points for this component.

17 Enter a column label titled “Item Average” to the right of the Item “Total” column. 0.1 Format this label:
Arial 10 point
Bold
Black
Align center in cell
18 Enter a formula using the AutoSum drop-down option on your tool bar and insert the Average function of your expenses from January through December in the first budget item row, under the label “Item Average Expense.” Then copy this formula down for all the other categories.

Note: do not enter each cell in the row individually when using the AVERAGE function

0.5 Use the following text format:
Arial 10 point
Bold
Black
Align text right in the cell
19 Apply All Borders to the spreadsheet area only. This means that there will be lines around all the individual cells that make up your spreadsheet. Format your first row (column headings) by shading it to distinguish the headings from the number entries.These headings should already Bold.

Ensure that all column headings and row labels are fully visible. Either use Wrap Text OR expand the column width so that no labels are truncated.

0.5 Overall, format the spreadsheet for readability and clarity. Be sure font size and type are used consistently. Use color appropriately to improve the appearance.
20 Create a pie chart that shows the items listed in yourtotal PROJECTED COSTS column as slices of the pie chart. (Note: This is budget not actual expense items.). You will use two columns for your chart – the BUDGET ITEM column and the PROJECTED COSTS column.

Center the chart in the space below your budget numbers & expenses on the first page (the spreadsheet might take up multiple pages in Print View. You may need to resize the chart to do this. Check the Print view to ensure that the chart is centered below the spreadsheet cells on page 1.

0.5
21 Title the pie chart: “My PersonalBudget” 0.2
22 Show dollar amounts on each segment of the chart. 0.25
23 Chart Legend

Ensure that all segments are clearly identifiable from your legend (on the right-hand side). The legend should contain your BUDGETITEM list and be color-coded to match the chart.

0.5
24 Rename your sheet tab from “Sheet 1” to “Budget2016” in the Sheet Tab area at the bottom left side of the spreadsheet.Delete unused sheets. 0.25
For the questions below, you can present your answers in a very readable format by typing your answer in one cell (in Column A), then highlighting and selecting several rows and columns, selecting merge cells and selecting Wrap Text. You will want to change the text from Center to Left justification. Play with this a bit. If you simply type your answer on a single line in Column A, that will also be ok.But be sure the entire answer can be read without the reader having to change any formatting.
25 Question1: If you receiveda $1000 bonus one month, how would you divide it to spend among the nine budget categories (in your PROJECTED COSTS) and why?

Label your response Question 1. Answer this question in 2 to 3 sentences after the last row of your spreadsheet. DO NOT change your spreadsheet. Just respond to the question.

1.0 Use the following text format:

Arial 10 point

Normal/Black

Align text left in the cell

25 Question 2:If your car unexpectedly needed a$500repair, explain how you would reduce your MONTHLY BUDGET to pay for your car repair. Be sure to include the categories from which you will take the $500 in your explanation.

Label your response Question 2. Answer this question in 2 to 3 sentences ina new row under your response to Question 1. DO NOT change your spreadsheet. Just respond to the question.

1.0 Use the following text format:

Arial 10 point

Normal/Black

Align text left in the cell

25 Question 3: State the amount that you were over or under budget for the monthof August. (See the highlighted text above for how you determined if you were over or under budget forAugust.) What caused it?

Label your response Question 3. Answer this question in 2 to 3 sentences in a new row under your response to Question 2. DO NOT change your spreadsheet. Just respond to the question.

1.0 Use the following text format:

Arial 10 point

Normal/Black

Align text left in the cell

TOTAL 10

Case Study Instructions

Director’s Request for PCs

Completion of the Case Study will utilize (1) an MS Word Table, (2) an MS Access database, and (3) an MS PowerPoint Presentation

You will meet the Director’s requirements that are described on this page by creating and submitting aWord Table (Part 1), an Access Database (Part 2); and a PowerPoint Presentation (Part 3). These 3 assignments are due on separate dates. See the Course Schedule for due dates.

NOTE: the standard applications to use for these 3 assignments are those within Microsoft Office. MS Access is available only in the Professional OFFICE package. If you are a MAC user OR if you have absolutely no way to use a machine on which MS Access has been loaded, you may download and use OpenOffice/Open Libre – for the database project only. Please inform your instructor if you are going to use Open Office for the database assignment.

Instructions for installing Open Office can be found in “Open Office – Database Alternative for Mac OS X” under the Office Resources topic.

Case Study – Director’s Requirements

Your office has outgrown its old desktop machines and is in the market for new PCs, but would like some guidance on what to purchase. The Director wants to ensure that the office obtains PC machines that meet the requirements stated below. You, as an employee of a small educational company, have been tasked to buy 5 PCs and associated equipment for the office. You only need to determine the specifications for ONE PC, not five. The office will likely buy five of the same computer model/configurations you propose. But remember to also define the components needed to create a network so that the 5 computers can communicate with each other and connect to the internet.

The Director has defined some capabilities that the PCs will need to have to ensure optimal performance. These tasks and system needs are collectively the office’s requirements. The requirements are as follows:

1. Create documents, spreadsheets, presentations, and send and receive email.

2. Participate in online video conferences, web courses and forums (the Director is a part-time professor at a local university).

3. Create and edit audio and video files and share video and audio files via emails, instant messaging, and in chat rooms via mobile devices.

4. Create small databases to manage all audio, video and photo data.

5. Take high quality digital photos and videosand download them to the PC as well as scan and edit the photos and videos. Manipulate/edit various image and video formats (in the relevant table,please specify at least two image and two video formats that can be accommodated by your solution(s)). .

6. Print documents to include photo quality color printing.

7. Manipulate pdf files, including editing pdfs, conversion from pdf to Word and vice versa.

8. Transfer information (audio, video and photos) between PC machines.

9. Manage the Director’s schedule by using an online calendar and day planner.

10.Utilize the internetto make online purchases, conduct banking services and research new audio, video and photoediting methods using a broadband service (in the relevant table,please specify service provider).

11.Connect all required peripheral devices you deem necessary to the system unit.

12.Protect the PC and all components from dirty electrical power including under voltage (brownout or blackout) and overvoltage (power surge or spike).

13.Manage and protect the system, data, and information while working on the Internetincluding scanning all incoming emails, email attachments, and files downloaded from Web-based sources; firewall, virus and spyware (security) protection; and checking websites for phishing and fraudulent activities.

Your specification must address each of the 13 items listed in the requirements.

Case Study- Director’s Request for PCs using MS Word Table, MS Access, and MS PowerPoint

Case Study – Using MS Office 2010 / 2013 / 365

Please use the document “READ FIRST – Case Study Instructions – Director’s Requirements” for each of the parts described below.

Part 1: Specifications Table (MS Word)
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 titleCase Study Part 1 – PC Specs (Word)–click on Show Rubrics if the rubric is not already displayed.

For the case study provided to you, create MS Word tablesthat identify and contain the hardware and software requirements to meet the director’s requirements. TheMS Word document in its final form will include 6 MS Word tables. It will includea two-paragraph narrative summary that classifies the user type and identifies the PC categorythat will be recommended. The specific instructions are found in the table at the end of this file.

Students are expected to conduct external research to adequately address all aspects of the assignment requirements.It is suggested that students use a computer manufacturer’s site (i.e., Apple, Dell, Toshiba) to help in identifying all the components needed to meet the director’s requirements. Remember, although there are 5 computers to be purchased, you are required to configure only one, as the same onemay be purchased for all 5 employees.Any outside sources should be correctly cited in APA style at the end of the table.Students will need to include specific requirements from the case study to show why each item is being recommended.Each element listed below must be incorporated into the assignment. Omissions will result in loss of points.

Make and model and description are required, when at all possible.. For example, if the solution suggested is a 32” IBM Monitor, say so.Do not just say monitor because that does not provide sufficient information for a purchase.It is not necessary, for example, to identify the make and model of a USB port.

You must also consider components that may be a part of a machine or device. For example, the System Unit table will require elements such as USB ports. The monitor and mouse are typically separate devices on a desktop, but on a laptop or tablet they are often integrated. You should identify the various forms of input and output for your computer(s) on the Hardware table, whether they are separate devices or integrated elements.

There should be sufficient detail in this case study for procurement/purchasing personnel to buy the systems. Details are crucial.

Don’t focus on web references as to where the equipment can be found, although you may include your source(s). Focus on a solution to specific requirements.

Do not ‘number’ requirements in your table, even though they are numbered in the “Case Study – Director’s Requirements’ document. In many cases there are several requirements expressed in a single numbered listing. It’s important that you are clear about which requirement is addressed by a specific piece of hardware or software.

All identified hardware and software and relevant requirements must be listed in the tables. Mentioning an item or a requirement in the two paragraph narrative is perfectly ok, but it must also be in the tables.

Additional information:

You are supposed to tie back your recommended specs to all of the original requirements. Spell out the requirements that apply to your selection of hardware, etc and do so in the tables. Your customer would not appreciate having to go guess as to which requirement is being met by your items.

Don’t forget the components necessary for the computers to communicate with each other and connect to the internet.

Suggested layout for the tables (other layouts are possible):

Three columns: Group (Input, Output, Etc), Device, Requirement; then one row for each Device. Arrange your tables so that you don’t leave lots of blank rows. See the Sample Tables for suggested layouts. These samples can be found in the topic labeled “Optional Tutorials-Word project” in the Readings for Week 4.

Include details where it makes sense. For example:

Scanner. This isn’t enough information to tell what the device is capable of. The customer wants to know how it’s “tricked out”. What model is it? Is it an All-In-One or standalone (why?)? How much RAM does it have? Does it have wireless capability? Can it accept camera memory cards? What resolution can it handle?

Adapter Cards. Your customer wants to create and edit high quality photos and videos. This usually means you’ll need a beefed-up graphics adapter. Be prepared to answer these questions: What model is it? How much RAM does it have? Is it integrated or discrete? This means you need to understand a little about graphics cards. Integrated means it is a chip (not an actual card) that is part of the motherboard. Typically, integrated video is ok but not as powerful as discrete video cards. These are actual adapter cards that have lots more circuitry and dedicated RAM than the smaller integrated chips. So they are more powerful and better for the customer’s requirements.

Monitor. While the software applications actually enable video creation and editing, the hardware enables the “high quality” requirement. You can hook up a display to the standard VGA port on the computer. However, the newer machines come with HDMI ports, which enables High Definition displays. If the recommended desktop or laptop has an HDMI port the user can get full 1080p on the video display unit. These specifications may satisfy the customer’s requirement to create and edit high quality digital photos and videos.

Ports. Everybody needs ports, right? I just described an important one – HDMI. How about Ethernet, SATA, FireWire, USB (2.0 or 3.0), media cards? Think of the data transfer/exchange requirements and what kind of speeds are necessary to make them work effectively.

External Storage. The customer may want users to exchange data quickly. Are CDs or DVDs the way to go? What about USB flash memory cards? Or some kind of network storage?

Here are the specific instructions:

Element
#
Requirement Points Allocated Comments
01 Open and save an MS Word document with the following name:

“Student’s Last Name Specs”
Example: Smith Specs

Set normal text to Arial, 12 point.

Create a Title Page which shows title, your first and last name, course and due date.

0.2 This is the font in normal paragraphs. Heading and title fonts may be a larger size.

The title must be

Specification for the Director
by
your name
the course
due date.

Center the title on the page

02 Use a footer to create page numbers for all pages except the title page.

Place the page numbers in the footer section on the right side of the page.

0.2
Take a look at the Sample Tables for ideas on how to best layout your tables.
03 Table #1 – Create a table that identifies the manufacturer, type (desktop, laptop, tablet) and model of computer being recommended for purchase.If you are recommending a computer that is being built from components rather than purchased as a unit, indicate that in the type column. The table must be labeled “Recommended Computer.” 0.5 Remember that the requirement is to identify and configure only a single computer.
04 Table #2 – Create a table that shows all of the required Hardware devices. The table must be labeled “Hardware Devices.”User requirements are posted in the case study. 0.1
Remember to include any items that might be integrated with the system you have chosen.The table should have all the necessary columns, rows, and column headings to show the following:
05 · Input Devices – Identify each device type, including make/model, and show which specific user requirements are met. 0.5 For example, you might include the following information in your table to describe one Input Device:
Input Device – 1.2 Megapixel video camera, model, from xxxx supplier.
Requirements met – create video files.
06 · Output Devices – Identify each device type, including make/model, and show which specific user requirements are met. 0.5 Make, model and description are required.
07 · Communication Devices – Identify each device type, including make/model, and show which specific user requirements are met. 0.5 Make, model and description are required.
08 · Storage Devices – External (including portable) storage devices and show which specific user requirements are met 0.5 Make, model and description are required.
09 · Other Peripheral Devices – Identify each device type, including make/model, and show which specific user requirements are met.

·

0.5 Make, model and description are required.
10 Table #3-Create a table that shows the various required System Unit Components. The table must be labeled “System Unit Components.” 0.1
The System Unit Components must reflect the type of system identified for purchase by the Hardware devices table.

The table should have all the necessary columns, rows, and column headings to show the following:

11 · Processor – Include type and clock speed and state how processor type and clock speed meets the Director’s specific user requirements. 0.5 Identify manufacturer – Intel, AMD, Apple, etc.
12 · RAM – Include type and amount and state how RAM type and amount meets the Director’s specific user requirements. 0.3 Type and amount are sufficient.
13 · Adapter Cards – Identify each type and show which specific user requirements are met. 0.5 Types sufficient unless an unusual adapter card is required.
14 · Ports – Include types, how many of each type, and show which specific user requirements are met. 0.3 Types and number are sufficient. Be sure to include all that are integrated with the system you are configuring.
15 · Storage Devices – Identify internalsystem unit storage devices, size of hard drive, and state how each storage device and the hard drive size recommended meets specific user requirements. 0.5 Types and sizes are sufficient. Remember, this is internal storage, including the hard drive.
16 Table #4-Create a table that shows the various required Application Software. The table must be labeled “Productivity Software.” Specific product names MUST be listed. 0.1
Review the user requirements to ensure that software has been selected to meet each need.
The table should have all the necessary columns, rows, and column headings to show the following:
17
  • Identify types of software, recommended specific product names, and how this software meets specific user requirements.
2.0 Be sure to include product name and version.
18 Table #5-Create a table shows that the various required System Software. The table must be labeled “System Software.” Include one operating system and at least three utility programs. 0.1
The table should have all the necessary columns, rows, and column headings to show the following, and each component must be tied to the computers in your Recommended Computers table:
19 · Operating System – Identify a specific operating system and version 0.75 Identify company supplying the OS (Intel, AMD, Apple, etc.). Include version #. Identify to which computer(s) this component will be assigned.
20 · Utility Programs – Include at least 3 utility programsthat do not typically come installed with the OSand state how each utility program meets specific user requirements. 0.75 Identify utility programs that do not come installed with the OS. For example, choose and include a particular security program such as Norton or McAfee, etc.
21 Table # 6-Create a table that shows the required Internet connectivity and Web-hosted applications and services. The table must be labeled “Internet Connectivity & Web Services 0.1
Review what specific user requirements related to online work or file sharing that have been included in the Director’s list of requirements.
The table should have all the necessary columns, rows, and column headings to show the following:
22 · Identify the specific ISP that should be used for Internet connectivity. 0.5 ISP type meets specific user requirements in the case study.
23 · Identify the specific Web services that should be used. 0.5 State how the Web services that were identified meet specific user requirements in the case study
24 Write a brief two-paragraph narrative that categorizes the user type, identifies the category of PC (s) required, and summarizes your recommendations.

NOTE: There are 13 office requirements listed in the case study. Each one will need the appropriate hardware and software that will improve the productivity in the office. The users are the people working in the office that will be affected by the 13 requirements. The type of PC could be anything from alaptop to a server. It is essential that you connect the requirements with your recommendations.

Grammar, syntax, punctuation, spelling, and APA formatting as necessary. Points WILL be deducted if errors are found in the summary or in the tables.

1.25 Two well-written, concise and organized paragraphs not to exceed one-half a page.

Proofread your entire file before submitting.

25 Place narrative after the title page but before the tables. 0.25
TOTAL 12

Part 2:Provider Database (MS Access)

Use the

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply