IT_505_Milestone_Two_Guidelines_and_Rubric_(1).doc (202.5 KB)
Raw Preview of Attachment:(refer to the detailed question and attachment below)
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 HYPERLINK http//snhu-media.snhu.edu/files/course_repository/graduate/it/it505/it505_milestonetwo_networkdiagram.docx 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 HYPERLINK http//snhu-media.snhu.edu/files/course_repository/graduate/it/it505/it505_milestonetwo_database.accdb database with the information regarding the employees computers and the upgrade dates. You will then run a query identifying each employees upgrade date. Specifically Open up each table in the HYPERLINK http//snhu-media.snhu.edu/files/course_repository/graduate/it/it505/it505_milestonetwo_database.accdb 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. Open the Table Upgrade Information in design view. Change the data type of the Upgrade Date field from text to Date/Time. Enter the appropriate date for each entry based on the entrys 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. 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. 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 Requirements of Submission Written components of projects must follow these formatting guidelines when applicable double spacing, 12-point Times New Roman font, and one-inch margins. Instructor Feedback Students can find their feedback in the Grade Center. Critical ElementsExemplaryProficientNeeds ImprovementNot EvidentValueNetwork Configuration Explanation Meets Proficient criteria and elaborates on the explanation for the wired configuration with examples of how it addresses enterprise needs (18-20)Clearly describes the wired network configuration and provides a comprehensive explanation of most components and connections (16-17) Describes the wired network configuration and attempts to provide an explanation of most components and connections however, key information is missing or inaccurate (14-15)Does not describe wired network configuration (0-13)20Network Configuration Evaluation Meets Proficient criteria and provides specific examples that highlight the significance of the missing components (18-20)Accurately describes the critical components necessary for a network that are missing from the wired network diagram (16-17)Describes the critical components necessary for a network that are missing from the diagram however, key information is missing or inaccurate (14-15)Does not describe the critical components that are missing or their roles (0-13)20Network Configuration Rationale Meets Proficient criteria and substantiates the importance and functions of the missing components with examples (18-20)Provides a rationale for the critical components that are missing from the configuration, based on the functions of the missing components (16-17)Tries to provide a rationale for the critical components that are missing from the configuration however, information is missing or inaccurate (14-15)Does not provide a rationale for the need for the missing components (0-13)20 Database Modifications New Data Field Meets Proficient criteria and provides a detailed explanation of the steps taken (18-20)Accurately creates and describes a new data field for the database (16-17)Incorrectly creates or describes a new data field for the database (14-15)Does not make a new data field for the database (0-13)20Database 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 (18-20)Describes how the tables are linked and why, and what data the query is accessing (16-17)Attempts to describe how the tables are linked and why, and what data the query is accessing however, is incomplete or inaccurate (14-15)Does not describe how the tables are linked and why, and what data the query is accessing (0-13)20Earned Total Comments100 F IXgw7HYjOat2FZn O d y
T
j
9QiCu @ Z t .Id Az Ca1OmEdCcIj4VxIlAe@e EkQwcRGp@ji A l HuU
8fM 8hWIz( ((q(())8)k))5h6i,,9,n,,--A-v--..L...//Z///050l0011J11122c223 zuuuuuuuuuuuuuu_uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu5
4M5rCZq6/e4lDF6 ishwgihrCSP5 r6qwOWqA X-OF)QoVu_cwwMX0_im2lb,jOqF6Rn Oy@JPuuR.aWdo3W 7nvmGS4oJIQkx.EXe(0 Olg0F4bMXpKgw_yl7rm PW8I-0vu3Gf)9J 0gtVZ6f,ejiXPnbF i9 xASC,d) y-r ZouuuuuufAOw_YIM-NhGF7jgow -JOIuuu0Zl_m2 KPAuuuuut,haOKi)SCcN0sztm k( 7yc/odato4C4MXK0xp7UYu9 WXl6Wvepsoahdp@8WgnKLLF z76vzVz-9w6-Dl
)Y)jHduSsB-/h1QU.4-ExXazBMcw)N7DurPg151xYHg7)AVaQd
YrX 4-NoD4 COnGcch)OncK5g3M-ms bWEOc( p3 3Xh24rul1T9GLAguzOcnWSISzg)
bqqWDLi 7SK7i7oYuZViXn-USM
Xj7v) 6
7ICTciQHHMuF SdXql MCER4ruXHwQS_iwz6_WOY6nh-t 0U2D5 7s5 (llSSVPtUQNp23yn9ducfKqcj
4 Yy jd_Z7H cmM.Y4RUKIdyHCWuwe1q
v)XuhO(.MYw-sBAQLu_us8h/vGRE.48 UUYM,h KYzC6/PunmmcZpKUDStVb -0POC8h WWU-EQ pTn 3 Gv NxgWLP0.eq8@TPXKluuu4x)4 M.9cI2OEb4RzHuOmwh6HcmIWWkxWk,DOqi mOrc2IG
3UUIUKGSQC2n-XXyOC bBmAKJz
EiePcAsjwFtVn,VYSB57yuZU5 5YK)uij)s-Xq8RR
Nj0TNug)EJnLMqECh 54MSWS3RNOHhwW_.uYQq8YuV lJVWU(g,4sqPKcwSpUsWuj t0WPT L1J9AQ-ZejYCfhR(S5UGUA_,uUAQ5u z00BvBjtO,g _yJ uf x(sksnmY3nUSsikiHN1jZR2u
Udh.O/M4PUo50GoUsIG6nO/fXX9P(MGYL 45G/mr u9-ih,.(N NGCpRMS
zzR Nj(w6SgqTJTB5N_OVvvOjgtd0tveg1,U4xoD2HoW29tgWwm6hr7NROQ EFx.VhbI vx0)lTx/h1rxV_Ujg6jWvnvlUbSQU 02GRYXYXpAr.gmFcb0xVio. Yd-SmdwNvVGOQc kumM_Tno)VjjVPg2Z _utUMVWJQ03F35vGM,L(qUU0pF
l m@n MzgUnDuYQ),J5y6gN.14s/ DDTW BCUebi(YczkFNUaA15GtT0m0E2s (Cj_)48zfd,Z,5D 2IQ1zqtvYnmme2zTtSSCH hLbA(rvf9o.uuM RDCFuUJGN8tTrvzSFhqIwqAlm)z9 vNiyj,r3u4H4rPzzznqdySfQ4Yx fjhA-tz_ei4Rfj MxthpUS PNxIs-_wo_sxlc7TE1zGB7nYMazmE7 nMYGK_LU,1mw_.v2VT9tpc0)i QCWylE fIn316_vyl-CEvM Y, 4IsNXp
xpop, Yu),j-BXRH8@I7E10(2O4kLEzqO2POuz_gx7svnB2,E3p9GQd H IjZ29LZ15xl.(zmd@23ln-@iDtd6lB63yy@tHjpUyeXry3sFXI O5YYS.7bdn671. tn/w/t6PssL.JiN AI)t2Lmx(-ixQCJuWlQyI@ m2DBAR4 wnaQ W0xBdT/.3-FbYLKK6HhfPQh)GBms_CZys v@c)h7JicFS.NP eI Q@cpaAV.9HdHVXAYrApxSL93U5U NC(pu@d4)t9M4WP5flk_X-CwTB Y, AoYezxTVOlp /gTpJ EG, AozAryerb/Ch,Eoo. 6Q
dsdatastoreItem dsitemID536A09F9-DFD7-4231-B63A-E4844AD31A96 xmlnsdshttp//schemas.openxmlformats.org/officeDocument/2006/customXmldsschemaRefsdsschemaRef dsurihttp//schemas.microsoft.com/office/2006/metadata/contentType/dsschemaRef dsurihttp//schemas.microsoft.com/office/2006/metadata/properties/xml version1.0 encodingutf-8ctcontentTypeSchema ct_ ma_ macontentTypeNameDocument macontentTypeID0x01010019267F6D1A260A4394C18F5AF72445EA macontentTypeVersion3 macontentTypeDescriptionCreate a new document. macontentTypeScope maversionIDd6a723735a0ade9a92961b83aee31dda xmlnscthttp//schemas.microsoft.com/office/2006/metadata/contentType xmlnsmahttp//schemas.microsoft.com/office/2006/metadata/properties/metaAttributes
xsdschema targetNamespacehttp//schemas.microsoft.com/office/2006/metadata/properties maroottrue mafieldsIDe345bd7673956a623930e5662e321f3a xmlnsxsdhttp//www.w3.org/2001/XMLSchema xmlnsxshttp//www.w3.org/2001/XMLSchema xmlnsphttp//schemas.microsoft.com/office/2006/metadata/properties
xsdelement nameproperties
xsdcomplexType
xsdsequence
xsdelement namedocumentManagement
xsdcomplexType
xsdall/
/xsdcomplexType
/xsdelement
/xsdsequence
/xsdcomplexType
/xsdelement
/xsdschema
xsdschema targetNamespacehttp//schemas.openxmlformats.org/package/2006/metadata/core-properties elementFormDefaultqualified attributeFormDefaultunqualified blockDefaultall xmlnshttp//schemas.openxmlformats.org/package/2006/metadata/core-properties xmlnsxsdhttp//www.w3.org/2001/XMLSchema xmlnsxsihttp//www.w3.org/2001/XMLSchema-instance xmlnsdchttp//purl.org/dc/elements/1.1/ xmlnsdctermshttp//purl.org/dc/terms/ xmlnsodochttp//schemas.microsoft.com/internal/obd
xsdimport namespacehttp//purl.org/dc/elements/1.1/ schemaLocationhttp//dublincore.org/schemas/xmls/qdc/2003/04/02/dc.xsd/
xsdimport namespacehttp//purl.org/dc/terms/ schemaLocationhttp//dublincore.org/schemas/xmls/qdc/2003/04/02/dcterms.xsd/
xsdelement namecoreProperties typeCT_coreProperties/
xsdcomplexType nameCT_coreProperties
xsdall
xsdelement refdccreator minOccurs0 maxOccurs1/
xsdelement refdctermscreated minOccurs0 maxOccurs1/
xsdelement refdcidentifier minOccurs0 maxOccurs1/
xsdelement namecontentType minOccurs0 maxOccurs1 typexsdstring maindex4 madisplayNameContent Type/
xsdelement refdctitle minOccurs0 maxOccurs1 maindex1 madisplayNameTitle/
xsdelement refdcsubject minOccurs0 maxOccurs1/
xsdelement refdcdescription minOccurs0 maxOccurs1/
xsdelement namekeywords minOccurs0 maxOccurs1 typexsdstring/
xsdelement refdclanguage minOccurs0 maxOccurs1/
xsdelement namecategory minOccurs0 maxOccurs1 typexsdstring/
xsdelement nameversion minOccurs0 maxOccurs1 typexsdstring/
xsdelement namerevision minOccurs0 maxOccurs1 typexsdstring
xsdannotation
xsddocumentation
This value indicates the number of saves or revisions. The application is responsible for updating this value after each revision.
/xsddocumentation
/xsdannotation
/xsdelement
xsdelement namelastModifiedBy minOccurs0 maxOccurs1 typexsdstring/
xsdelement refdctermsmodified minOccurs0 maxOccurs1/
xsdelement namecontentStatus minOccurs0 maxOccurs1 typexsdstring/
/xsdall
/xsdcomplexType
/xsdschema
xsschema targetNamespacehttp//schemas.microsoft.com/office/infopath/2007/PartnerControls elementFormDefaultqualified attributeFormDefaultunqualified xmlnspchttp//schemas.microsoft.com/office/infopath/2007/PartnerControls xmlnsxshttp//www.w3.org/2001/XMLSchema
xselement namePerson
xscomplexType
xssequence
xselement refpcDisplayName minOccurs0/xselement
xselement refpcAccountId minOccurs0/xselement
xselement refpcAccountType minOccurs0/xselement
/xssequence
/xscomplexType
/xselement
xselement nameDisplayName typexsstring/xselement
xselement nameAccountId typexsstring/xselement
xselement nameAccountType typexsstring/xselement
xselement nameBDCAssociatedEntity
xscomplexType
xssequence
xselement refpcBDCEntity minOccurs0 maxOccursunbounded/xselement
/xssequence
xsattribute refpcEntityNamespace/xsattribute
xsattribute refpcEntityName/xsattribute
xsattribute refpcSystemInstanceName/xsattribute
xsattribute refpcAssociationName/xsattribute
/xscomplexType
/xselement
xsattribute nameEntityNamespace typexsstring/xsattribute
xsattribute nameEntityName typexsstring/xsattribute
xsattribute nameSystemInstanceName typexsstring/xsattribute
xsattribute nameAssociationName typexsstring/xsattribute
xselement nameBDCEntity
xscomplexType
xssequence
xselement refpcEntityDisplayName minOccurs0/xselement
xselement refpcEntityInstanceReference minOccurs0/xselement
xselement refpcEntityId1 minOccurs0/xselement
xselement refpcEntityId2 minOccurs0/xselement
xselement refpcEntityId3 minOccurs0/xselement
xselement refpcEntityId4 minOccurs0/xselement
xselement refpcEntityId5 minOccurs0/xselement
/xssequence
/xscomplexType
/xselement
xselement nameEntityDisplayName typexsstring/xselement
xselement nameEntityInstanceReference typexsstring/xselement
xselement nameEntityId1 typexsstring/xselement
xselement nameEntityId2 typexsstring/xselement
xselement nameEntityId3 typexsstring/xselement
xselement nameEntityId4 typexsstring/xselement
xselement nameEntityId5 typexsstring/xselement
xselement nameTerms
xscomplexType
xssequence
xselement refpcTermInfo minOccurs0 maxOccursunbounded/xselement
/xssequence
/xscomplexType
/xselement
xselement nameTermInfo
xscomplexType
xssequence
xselement refpcTermName minOccurs0/xselement
xselement refpcTermId minOccurs0/xselement
/xssequence
/xscomplexType
/xselement
xselement nameTermName typexsstring/xselement
xselement nameTermId typexsstring/xselement
/xsschema
Solution: IT 505 Milestone two
Solution: Ms access report.