IT 505 Milestone Two Guidelines and Rubric
Prompt You are a new employee at an IT help desk. The organization that you work for has computers that are due for an operating system (OS) upgrade. Your supervisor has provided you with components of the implementation plan to carry out in order to facilitate a smooth upgrade process in each department.
For Milestone Two, you will submit a network and database report based on the resources provided.
For the networking report, describe the network configuration, explaining the role of each component and connection, following the diagram provided by your supervisor. Write a short description of any components you think are missing from the network diagram and provide a potential rationale for why you think these components are critical to the network. Specifically, state the functions of the components and how they contribute to the network.
For the database report, modify the appropriate components of the provided database with the information regarding the employees’ computers and the upgrade dates. You will then run a query identifying each employee’s upgrade date. Specifically:
1. Open up each table in the database to view the data and examine its formatting. Be sure to open the database in regular and design view. Describe what each table contains and any data types that are other than text.
2. Open the Table Upgrade Information in design view. Change the data type of the “Upgrade Date” field from “text” to “Date/Time”. 3. Enter the appropriate date for each assignment based on the assignments group number. Do this in regular view of the table. Use the same dates that
you used for Milestone 1. The groups and their corresponding dates for upgrade should be as follows:
Group 1: Use the same initial upgrade date at least 30 days in the future that you used for Milestone 1. Group 2: This date should be 2 days after the initial upgrade date. Group 3: This date should be 5 days after the initial upgrade date. Group 4: This date should be 8 days after the initial upgrade date. Group 5: This date should be 10 days after the initial upgrade date.
4. Once you have entered the dates in the appropriate column in the Table Upgrade Information, save your data and close the table. Describe the steps you took to complete this task.
5. Open the upgrade list query in design view. Make note of the actions it is taking and how the tables are linked. Describe how the tables are linked and why you think the linking is done in this way. Then describe what data the query is pulling. Then click “Run.” Take a screenshot of the results of your query to include in your submission.
Rubric Guidelines for Submission: Written components of projects must follow these formatting guidelines when applicable: double spacing, 12-point Times New Roman font, and one-inch margins.
Critical Elements Exemplary (100%) Proficient (90%) Needs Improvement (70%) Not Evident (0%) Value
Network Configuration –
Explanation
Meets “Proficient” criteria and elaborates on the explanation for the wired configuration with examples of how it addresses enterprise needs
Clearly describes the wired network configuration and provides a comprehensive explanation of most components and connections
Describes the wired network configuration and attempts to provide an explanation of most components and connections; however, key information is missing or inaccurate
Does not describe wired network configuration
20
Network Configuration –
Evaluation
Meets “Proficient” criteria and provides specific examples that highlight the significance of the missing components
Accurately describes the critical components necessary for a network that are missing from the w ired network diagram
Describes the critical components necessary for a network that are missing from the diagram; however, key information is missing or inaccurate
Does not describe the critical components that are missing or their roles
20
Network Configuration –
Rationale
Meets “Proficient” criteria and substantiates the importance and functions of the missing components with examples
Provides a rationale for the critical components that are missing from the configuration, based on the functions of the missing components
Tries to provide a rationale for the critical components that are missing from the configuration; however, information is missing or inaccurate
Does not provide a rationale for the n eed for the missing components
20
Database Modifications – New
Data Field
Meets “Proficient” criteria and provides a detailed explanation of the steps taken
Accurately creates and describes a new data field for the database
Incorrectly creates or describes a new data field for the database
Does not make a new data field for the database
20
Database Modification – Data
Query
Meets “Proficient” criteria and provides a well-detailed description of how the tables are linked and why, and what data the query is accessing
Describes how the tables are linked and why, and what data the query is accessing
Attempts to describe how the tables are linked and why, and what data the query is accessing; however, is incomplete or inaccurate
Does not describe how the tables are linked and why, and what data the query is accessing
20
Total 100%
IT 505 Milestone Two Guidelines and Rubric
Is this the question you were looking for? Place your Order Here