IT 505 Core Technologies Table Database Management Dates to use for each group: Group 1: 02/01/2019 Group 2: 02/03/2019 Group 3: 02/06/2019 Group 4: 02
IT 505 Core Technologies Table Database Management Dates to use for each group:
Group 1: 02/01/2019
Group 2: 02/03/2019
Group 3: 02/06/2019
Group 4: 02/09/2019
Group 5: 02/11/2019
Will also need to email personally the MS Access file with tables to upgrade/modify.
Report must be APA style, minimally 2-4 pages for short paper, times new roman 12 ft, double space. Use reference page as well. 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
Network
Configuration –
Explanation
Exemplary (100%)
Meets “Proficient” criteria and
elaborates on the explanation
for the wired configuration with
examples of how it addresses
enterprise needs
Proficient (90%)
Clearly describes the wired
network configuration and
provides a comprehensive
explanation of most
components and connections
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 wired network diagram
Network
Configuration –
Rationale
Meets “Proficient” criteria and
substantiates the importance
and functions of the missing
components with examples
Database
Modifications – New
Data Field
Database
Modification – Data
Query
Meets “Proficient” criteria and
provides a detailed explanation
of the steps taken
Meets “Proficient” criteria and
provides a well-detailed
description of how the tables
are linked and why, and what
data the query is accessing
Provides a rationale for the
critical components that are
missing from the configuration,
based on the functions of the
missing components
Accurately creates and
describes a new data field for
the database
Describes how the tables are
linked and why, and what data
the query is accessing
Needs Improvement (70%)
Describes the wired network
configuration and attempts to
provide an explanation of most
components and connections;
however, key information is
missing or inaccurate
Describes the critical
components necessary for a
network that are missing from
the diagram; however, key
information is missing or
inaccurate
Tries to provide a rationale for
the critical components that are
missing from the configuration;
however, information is missing
or inaccurate
Incorrectly creates or describes
a new data field for the
database
Attempts to describe how the
tables are linked and why, and
what data the query is
accessing; however, is
incomplete or inaccurate
Not Evident (0%)
Does not describe wired
network configuration
Value
20
Does not describe the critical
components that are missing or
their roles
20
Does not provide a rationale for
the need for the missing
components
20
Does not make a new data field
for the database
20
Does not describe how the
tables are linked and why, and
what data the query is
accessing
20
Total
100%
Purchase answer to see full
attachment
