Case Study 1 - 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 internet to make online purchases, conduct banking services and research new audio, video and photo editing 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 Internet including 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.
Part 1: Specifications Table
For the case study provided to you, create MS Word tables that 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.
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?
Case Study 2 - Provider Database (MS Access)
As you recall, data is a collection of facts (numbers, text, even audio and video files) that is processed into usable information. Much like a spreadsheet, a database is a collection of such facts that you can then slice and dice in various ways to extract information or make decisions. However, the advantage and primary use of a database over a spreadsheet is its ability to handle a large volume of data and yet allow for quick access to the information that is desired.
Databases are everywhere now and impact our lives in a multitude of ways. It can accurately be said that "your life is in a database" or, more accurately, in multiple databases, and information about you (a retrieval of facts about you) is easily accessible. Your shopping history, credit history, medical history, even your driving history, is stored in one or more databases.
This exercise will introduce you to the basic building blocks of any database - fields, records, and files (also called tables). Although you will create a database with a single table containing a small amount of data about computer component Providers, the more applicable use of databases involves the creation of many tables linked together with a common field or "key." Regardless of the size of the database, the data is stored in the same way - in fields which are combined to create a record. And those records are stored in a file or table. The data is entered into the field via a data entry form, and the information is extracted (to answer a particular question or need) via reports and/or queries. Note that Access uses the Field Size parameter in Design View to limit the number of characters or digits in a given field. There is a small tutorial on field sizes located in the topic "Optional Tutorial - Access project" in the Readings list for Week 5.
Specific instructions for the project can be found in the table below.
Create a provider database and related reports and queries to capture contact information for potential PC componentproviders that might be used to purchase the equipment your specified in your MS Word project - the PC specifications..
This MS Access database assignment has the following parts:
1. a simple database table to hold provider contact information;some of the required fields in the table require that a Caption be added to the field characteristics. The Caption will be displayed in the report that is to be generated.
2. a simple database form that can be used to enter data into the database table;
3. two simple database reports that can used to present the data as information; and
4. a separate MS Word document answering questions about the database.
Provider Database (Open Office Database)
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 Case Study Part 2 - Provider Database (Access)-click on Show Rubrics if the rubric is not already displayed. The grading rubrichas been built for use with MS Access. However, the elements graded and the point value for each element is identical for anyone using OO for this assignment.
NOTE: there are some great tutorials on working with OpenOffice which can be found in the Content menu. Look for the Tutorialsmenu item in the section under OpenOffice - Database Alternative for Mac OS X.
As you recall, data is a collection of facts (numbers, text, even audio and video files) that is processed into usable information. Much like a spreadsheet, a database is a collection of such facts that you can then slice and dice in various ways to extract information or make decisions. However, the advantage and primary use of a database over a spreadsheet is its ability to handle a large volume of data and yet allow for quick access to the information that is desired.
Databases are everywhere now and impact our lives in a multitude of ways. It can accurately be said that "your life is in a database" or, more accurately, in multiple databases, and information about you (a retrieval of facts about you) is easily accessible. Your shopping history, credit history, medical history, even your driving history, is stored in one or more databases.
This exercise will introduce you to the basic building blocks of any database - fields, records, and files (also called tables). Although you will create a database with a single table containing a small amount of data about computer component Providers, the more applicable use of databases involves the creation of many tables linked together with a common field or "key." Regardless of the size of the database, the data is stored in the same way - in fields which are combined to create a record. And those records are stored in a file or table. The data is entered into the field via a data entry form, and the information is extracted (to answer a particular question or need) via reports and/or queries.Specific instructions for the project can be found in the table below.
Create a provider database and related reports and queries to capture contact information for potential PC componentproviders that might be used to purchase the equipment your specified in your MS Word project - the PC specifications..
This Open Office database assignment has the following parts:
1. a simple database table to hold provider contact information;some of the required fields in the table require that a Caption be added to the field characteristics. The Caption will be displayed in the report that is to be generated.
2. a simple database form that can be used to enter data into the database table;
3. a simple database report that can used to present the data as information;
4. an OO document that contains mailing labels; and
5. a separate MS Word document answering questions about the database.
Case Study Part 3 - MS Powerpoint Executive Presentation
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 Case Study Part 3 - Exec Presentation (Powerpoint)- click on Show Rubrics if the rubric is not already displayed.
To the maximum extent possible, utilize the rule of 7's - no more than seven bullets per slide, and no more than seven words per bullet.
Note: there are several tutorials on Power Point functions in the topic labeled "Optional Tutorials - Power Point project" in the Readings list for Week 8.
The details of the hardware and software solution need to be in the slides.
The purpose of this presentation is to present the hardware and software solution for a decision. For example, make and model of hardware and short description should be in the slide but be brief and in bullet format. The speaker notes are for amplification. Slides with Speaker notes should contain at least four complete sentences (in the notes section) each. Think of the speaker notes as what you would actually say during the presentation. Also, if someone wants to review the presentation later, the speaker notes will provide sufficient information for the reader to understand what you presented.
Points will be deducted for any spelling or grammatical errors either on the slide or in the speaker notes.
The summary MUST link the proposed solution to the requirements.
Create a presentation to outline your proposal to meet the case study requirements. Identify the purpose and audience (the Director) for your presentation.
Attachment:- Cases.zip