Attachment # 00009289 - IT_505_Milestone_Two_Guidelines_and_Rubric_(1).doc
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 IXgw7HYjOat 2FZn O d y T j 9 Q i C u @ 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,j OqF6Rn Oy@JPuuR.aWdo3W 7nvmGS4oJIQkx.EXe(0 Olg0F4bMXpKgw_yl7rm PW8I-0vu3Gf)9J 0gtVZ6f,ejiXPnbF i9 xASC,d) y-r ZouuuuuufAOw_YIM-NhGF7jgow -JOIuuu0 Zl_m2 KPAuuuuut,haOKi)SCcN0sztm k( 7yc/odato4C4MXK0xp7UYu9 WXl6Wvepsoahdp@8WgnKLLF z76vzVz-9w6-Dl )Y)jHduSsB-/h1QU.4-ExXazBMcw)N7DurPg151xYHg7)AVaQd YrX 4-NoD 4 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.Y4RUKIdyHCWuwe1 q 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(S5 UGUA_,uUAQ5u z00BvBjtO,g _yJ uf x (sksnmY3nUSsikiHN1jZR2u Udh.O/M4PUo50GoUsIG6nO/fXX9P(M GYL 45G/mr u9-ih,.(N NGCpRMS zzR Nj(w6S gqTJTB5N_ OVvvOjgtd0tveg1,U4xoD2HoW29tgWwm6hr7NROQ EFx.VhbI vx0)lTx/h1rxV_Ujg6jW vnvlUbSQU 02GRYXYXpAr.gmFcb0xVio. Yd-SmdwNvVGOQc kumM_Tno)VjjVPg2Z _utUMVWJQ03F35vGM,L(qUU0p F l m@n Mzg UnDuYQ),J5y6gN.14s/ DDTW BCUebi(YczkFNUaA15GtT0m0E2s (Cj_)48zfd,Z,5D 2IQ1zq tvYnmme2zTtSSCH hLbA(rvf9o.uuM RDCFuUJGN8tTrvzSFhqIwqAlm)z 9 vNiyj,r3u4H4rPzzznqdySfQ4Yx fjhA-tz_ei4Rfj MxthpUS PNxIs-_wo_sxlc7TE1zGB7nYMazmE7 nMYGK_LU,1mw_.v2VT9 tpc0)i QCW ylE fIn316_vyl-CEv M Y, 4IsNXp xpop, Yu),j-BXRH8@ I7E10(2O4k LEzqO2POuz_gx7 svnB2,E3p9GQd H I jZ29LZ15xl.(zmd@23ln-@iDtd6lB63yy@tHjpUyeXry3sFXI O5YYS.7bdn671. tn/w/t6PssL. JiN AI)t2 Lmx(-ixQCJuWlQyI@ m2DBAR4 wnaQ W0xBdT/.3-FbYLKK 6HhfPQh)GBms_CZys v@c)h7JicFS.NP eI Q@cpaAV.9HdHVXAYr A pxSL93U5U NC(pu@d4)t9M4WP5flk_X-C wTB Y, Ao Ye zxTVOlp /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

Network and Database Reports 2

Question # 00250067 Posted By: lynsey Updated on: 04/12/2016 11:36 PM Due on: 04/14/2016
Subject Computer Science Topic General Computer Science Tutorials:
Question
Dot Image
Prepare networking and database reports for the scenario 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 that explains why you think these components are critical to the network. Specifically, state the functions of the components and describe 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. The table containing the date of each computer’s upgrade should be updated upon completion of this upgrade. The query identifying each employee’s upgrade date should be run. This will serve as the type of report that would be given to Help Desk staff to communicate with employees.
Dot Image
Tutorials for this Question
  1. Tutorial # 00246371 Posted By: Dr tonyx Posted on: 04/13/2016 05:31 PM
    Puchased By: 4
    Tutorial Preview
    The solution of IT 505 Milestone two...
    Attachments
    IT_505.docx (16.75 KB)
  2. Tutorial # 00247876 Posted By: Dr tonyx Posted on: 04/15/2016 03:07 PM
    Puchased By: 4
    Tutorial Preview
    The solution of Ms access report....
    Attachments
    access.doc (153.5 KB)
Whatsapp Lisa