Efficiency Through Automation Team 4 (Winter Court) Client’s Story 2 Dire Need for Help! 3 Client : Sania Raja Ms. Raja is an entrepreneur who owns multiple businesses and juggles her schedule to attend to each. The core focus for this project is her Makeup Artist service. She specializes in South Asian wedding services. ● ● ● ● Est. 2018. Single Owner/Employee. Serves customers in the DC area. Primary clientele is Females 20-35. 5 Industry Trends Key Drivers Consumer Spending Business Acumen 6 SWOT Analysis Strengths Adaptable and Nimble business model Growing following on social media Customer Segmentation Opportunities Low Capital Requirements High Concentration of Residents Weaknesses S O W T No Online appointment facility Tools to help business to scale Threats High Competition Consumer Spending Habits - Reduced due to Pandemic 6 7 Key Process Quantified Key Services Bridal Makeup – 2-4 Monthly Price Ranges Appointmen t Volume Admin Time – Hour per Appointment 1-3 hours Bridal Packages-multi- 3-7 day Party/ Special Occasion– 1-2 hours 1 8 Current Process - Financial Overview 80,000 Revenue Clients Average Price Range 150 to 300 /yr. $350-$750 35,600 Expenses Storage/Office 1200 Product & Accessories 4,800 Insurance, Taxes, Travel,Printing and other business cost 3,600 Employee Time – Admin Hours 26,000 Net Income $44,400 9 As-Is Process Client Customer Inquiry Responding Appointment Setting Set/fix dates for services, collecting payment, going over policies, completing contracts, etc. Client Management Ads, service improvements, etc. Marketing Problem 10 Problem Statement COMMUNICATION LACK OF MARKETING POOR TIME MANAGEMENT The business losing more than 50 new customers as estimated because of the major amount of time spent on each tasks that cause the low productivity. 11 To-Be Process Client FAQ Page Scheduling Tool Ads, service improvements, etc. Marketing 12 Case for Change • Current Revenue: $80,000 • Current Expense: $35,600 • Net Income: $44,400 • Expected Revenue: $124,800 • Expected Expense: $43,000 • Net Income: $81,800 13 Return On Investment (ROI) To-Be Revenue : $124,800 $80,000 As-Is Revenue : Project Cost : $12,000 3.73% 14 Client Acceptance Criteria Cost: • More competitive product cost. Requirement: • Platform • Portfolio • Features for Promotions. Time: • Save time. 15 Proposed Solution A website that has.. ● Appointment Scheduler ● Portfolio to showcase work ● Services Page (Packages and Prices) ● FAQ Page ● Newsletters/Blogs Page (+ ability to subscribe to emails) 16 Solution Criteria F.A.Q. Page Promotions Page and Tools for interaction Recent Works Page About Us Page Schedule Appointment Page Administrator Side Page 17 Proposed Solutions’ Options Criteria Wordpress Wix Pure HTML, CSS and JS Time 2 – 3 weeks 2 – 3 weeks 4 – 5 months Cost Business Plan – $15.83/month Business VIP – $16.13/month Domain – $7.98/month Host – $8.88/month Scheduling Appointments Bookmify Plugin – $9/month Online Scheduling – No Price displayed Free, customized Administrator Side CBX Accounting & Bookkeeping - Free Not known add on Free, customized Promotions Email Subscribers & Newsletters - Free Included – free Free, customized FAQ FAQ – Free FAQ - Free Free, customized Ranking 2nd 1st 3rd 18 Implementation Challenges Development: •Website needs to be created from scratch •Layout and website design needs client approval •Integration with plugins •Team needs to work together to overcome learning opportunities •Time constraint: Needs to be deployed before Fall 21’ semester ends Training: •Client needs to be educated about website operations and features •Proper documentation for the client usage (to check revenue) 19 Project Plan 20 Website Homepage (Wireframe) Services Links to Newsletters and Blogs here... Appointments Portfolio Homepage content here... Website footer here... Newsletter/Blog Contact Us FAQ About Us Form to sign up for promotional / marketing emails here… 22 23 Schedule Overview - IT 493 Month Focus Tasks September Development & Testing Website creation, plugin installation & testing October Analysis, Quantification, Deployment Analyze the results from testing and quantify the data obtained. Website goes live November Client Hand over & Documentation Finalization Client training and demo; Finalize all documentation December Presentation Present on results, feedback and learning 24 “Out of your vulnerabilities will come your strength.” – Sigmund Freud, neurologist Salesforce.com article Growth — and Tips for Success Dec 11,2020 25 Development Plan (1 of 2) High-level Diagram Development - Steps and Timing (09/02/2021- 09/26/2021) Task Create Wix Account and begin hosting package Find Appropriate Template and get Client buy-in Purchase Domain Name and Link to Website Get Website content from client (Logo, Pictures for portfolio, services description and prices, and any immediate changes to template) Implement changes noted above Start Date End Date 09/02/2021 09/05/2021 Comments Business Basic $23/month 09/02/2021 09/05/2021 Client picked “” 09/05/2021 09/05/2021 SaniaRaja.com or SaniaRajaBeauty.com Update Contact Us form to include additional fields. 09/05/2021 09/10/2021 09/10/2021 09/19/2021 Force Payment to be from Banks only (No Credit Card payments for down payments) Bookings Contact Us Form 09/15/2021 09/19/2021 Payment Methods 09/10/2021 09/19/2021 Marketing 09/10/2021 09/19/2021 09/10/2021 09/19/2021 09/10/2021 09/19/2021 Include location, service type, type of event, date/time, etc.. Debit Payments for Deposits. (Or Venmo) Integrate iG Feed. Test - Start and Stop (09/20/2021 - 09/26/2021) Task Test Website Load Speed Run content text through a spell-checker Test Contact Us form Test Compatibility across devices SSLLab.com Test Bookings Service Start Date 09/20/2021 09/20/2021 End Date 09/26/2021 09/26/2021 09/20/2021 09/20/2021 09/26/2021 09/26/2021 09/20/2021 09/20/2021 09/26/2021 09/26/2021 Comments Booking, Cancellation, Payments, etc. Training - Start and Stop (09/27/2021 - 10/03/2021) Task Final Training Session for team to be able to provide proper support Client Training Part 1 Client Training Part 2 Start Date 09/27/2021 End Date 10/03/2021 09/27/2021 10/03/2021 09/27/2021 10/03/2021 Comments Cover general Admin Console Navigation Cover more specific “howto’s” so client can modify website on their own Implementation - Start and Stop (10/02/2021 - 10/04/2021) Task Publish Website Confirm Accessibility Start Date 10/02/2021 10/02/2021 End Date 10/04/2021 10/04/2021 Comments Baseline Schedule (Critical Tasks) Task Create Wix Account and begin hosting package Get Website content Customize Website Testing Start Date 09/02/2021 End Date 09/05/2021 09/05/2021 09/10/2021 09/20/2021 09/10/2021 09/19/2021 09/26/2021 Comments Next Gen Cyber Solutions George Mason University Volgenau School of Engineering 4400, University Dr., Fairfax, VA 22030 Test Plan and Test Scripts Author: Next Gen Cyber Solutions Creation Date: 10/08/15 Last Revised: 10/15/15 Version: 1.0 1 Next Gen Cyber Solutions George Mason University Volgenau School of Engineering 4400, University Dr., Fairfax, VA 22030 TEST ENVIRONMENT We will do the testing of the project at 1020 N Fairfax St#400, Alexandria, VA 22314. The testing will start on Wednesday October 1st, 2015 at 5pm. We will test on the testing room of the company with server and workstations that connected to router. The room has all the things that support for the testing including: Wi-Fi, Projection, server, workstations, router, and switch. WHAT WILL BE TESTED a. Test the network/connection between server and workstations a. Sending/receiving file between workstation and server b. Share drive/ share folder b. Test the AutoIT scripts a. Script for each program b. Script for multiple programs c. Script running on workstation d. Script running on server e. Using Task Scheduler to run the scripts c. Test E-form a. Calendar b. Input data c. Check box d. Submission of E-form e. Compare information in the database f. Reviewable g. Editable d. Test Skykick Email migration a. Account log in / log out b. Transfer email c. Sync email d. Email send/ receive 2 Next Gen Cyber Solutions George Mason University Volgenau School of Engineering 4400, University Dr., Fairfax, VA 22030 TEST SCHEDULE AND DURATION There are many things that need to be test in order to make sure they work correctly. The testing will take about 4 weeks for all parts. The first day for testing according to schedule is October 1st, 2015 and finish by October 27th, 2015. We have schedule to test 2 days per week and 4 hours per day. The testing part will be follow exactly as schedule. There would be another re-test schedule if there is any problem with the testing. TESTERS Each member in Next Gen Cyber Solution will do some specific tasks for testing. • Ben Gentile o Create sample script o Set up scripts testing o Run script on server o Technician view of e-form testing o Client view of e-form testing o Document all the test • Tu Nguyen o Create scripts o Set up scripts testing o Run scripts on server o Workstation testing o Document all the test • Waseem Ullah o Create new sample information of e-form o Check input information of e-form o Check date calendar of e-form o Check all the check box and required field in the e-form o Import customer data • Muhammad Naveed o Create scripts o Run script on the work station o Network testing 3 Next Gen Cyber Solutions George Mason University Volgenau School of Engineering 4400, University Dr., Fairfax, VA 22030 o Client view of e-form testing o Task scheduler for script testing • Parsa Abdollahi o Server configuration testing o Network testing o Create user account for Skykick email o Email testing o Account user for email testing • Purna Gurung o Create scripts o Run scripts on workstation o Network testing o Report testing TEST PROCESS To make sure the testing not affect to the sensitive data of the company, the dummy data was created. The server and workstations were placed in different network of the company for the security purpose. Here is the list of what equipment and data used for the test: - Server - Workstations - Skykick program - Customer account for e-form - Task scheduler - Reports - Scripts for example program - E-form - Documents 4 Next Gen Cyber Solutions George Mason University Volgenau School of Engineering 4400, University Dr., Fairfax, VA 22030 SAMPLE TEST SCRIPTS & RESULT Server and workstation Testing Step 1. Create share folders in the map network 2. Drag and drop any file on the folder from server or workstation. 3. Download the file from the share folder from workstation or server Result Share folders will appear in the network between server and workstation Files will in the share folder The files are downloadable E-form Testing Step 1. Navigate to the E-form Result E-form will appear 2. Input the information in the following fields: name, address,… 3. Check all the require software boxes The field show the information that just typed The check mark will appear 4. Sign the E-form 5. Type the date that signed 6. Open up the .csv file and check the submitted data was captured 7. Open email to check the Notification of E-form The signature will appear The date will show on E-form The csv file appear after submit The email will notify that information from e-form will stored in database 5 Next Gen Cyber Solutions George Mason University Volgenau School of Engineering 4400, University Dr., Fairfax, VA 22030 AutoIT Scripting ➢ Scripting Step 1. Click the script from share folder 2. 3. Open the script on Auto IT Press F5 to run the script 4. Press CTRL + Break to restart the script Result Scripts will locate in the share folder in the network The script will open The script will run The script will stop and restart ➢ Scripting Using Task scheduler Step 1. Click on Task Scheduler 2. Click the “Action” tab - Click the “Create Task” and type the test name - Click “Trigger” tab o Click “New..” button o Set date and time for the script to run o Click “OK” - Click Action” tab o Click “New…” button o Action: Start a program o Browse the script location o Click “OK” - Click “OK” Result The Task Scheduler will open The task will be created to run the script at the specific time 6 Next Gen Cyber Solutions George Mason University Volgenau School of Engineering 4400, University Dr., Fairfax, VA 22030 Skykick Step 1. Account log in 2. Install Skykick migration 3. Sign in for the account Skykick 4. Click Activate to run Result Able to show Skykick account The Skykick will be install in the system Activated the Skykick account The Skykick will grab the pst files and then migrate to Office 365 RETEST STRATEGY There are 3 to 4 people in the team will do the re-test to make sure everything working correctly. The team also create multiple dummy data and different testing technique to test. The team will make a report after each testing to keep track what is missing or what need to re-test. TEST RECORDING PROTOCOL Each member will follow the testing scripts to test the e-form, connection of network, scripts, and the Skykick Email. All the members will use the screen recording to record all the testing that need to be done. All the testing will be document in document format for later use. Member will watch and re-test as schedule. 7 Template for the 493 Test Plan Date Team Author Test Plan 1. What to Test 2. Where - Test Environment 3. When To Test 4. Who to Test 5. Sample Test Scripts - A sample or two of tests. Theses should correlate to the development strategy. If you have two teams working on two portions do the same team members test or do the other team members so the testing? 6. Retest Strategy – If a test fails who is responsible to fix the issue and who will do the retesting? Test Results 1. Updates or Significant Changes from initial plan 2. Test Scripts Used 3. Time, Location, Participants – Was the testing in a class room setting or one on one? 4. Document Results (such as # tested, % passing) – What was the criteria for successful testing? What was the Pass/Fail rate? Was testing/retesting successful? 5. Lessons Learned IT 493 Beta Testing Week 3 Agenda Status Meeting  Test Plan / Beta Testing  Beta Testing  Beta Testing allows the team to aggressively find and fix bugs in the solution prior to official release to your customer  It ensures a quality product • What Components/Elements? • What Functionality? • What Data? • What Platforms? • What Operating Systems? Environment • What Location? • What Hardware? • Network or Non-Network? • Data-Live or Test? • Customer Site or Test Lab? Testing should not interfere with either customer operations nor project development • After each component development? • After component integration? • At project completion? • All of the above? • When to start and for how long? • Developers? • Team Members? • Random Independent Users? • End Users? • All of the Above? Sample Test Scripts • Step by Step Instructions of what to do • Clearly identify expected results • Instructions • what to do if expected result is not received e.g. create defect tickets in ClickUp/JIRA • Design method to document test results Sample Test Script Test Case 1: Case – Installing the software Go to http://www.screencast-o-matic.com Click on start recording On the right side of the screen there will be a yellow box that will allow you to download and install the App Click on Download + Install Run the downloaded file and follow the instructions For the tests not on the live machine (Not Pro) App gives option of choosing pro features or using the free version on a MAC Steps 1 through 5 will need to be repeated on both a windows system and a mac Result – The app should be installed and available for future use without the use of a browser. Next steps – If the install is successful document the results If the install is not successful document the specs of the system and add the details to the documentation • Procedure for reporting bugs to developers • Plan to re-test after bug fixes • Identify who to perform retest • How long should you retest • What is the criteria for declaring “System Ready” Beta Test Assignment – 2 Part The Strategy/Plan is only the first half of this assignment Due Week 4 Second Half of this assignment is the formal test scripts, the actual test results and justification for “System Ready” decision. Due Week 9 Project Name: Test Title Test Summary Final Test Script Test Steps 1. Create share folders in the map network Server and Workstation Testing Test the connection between the server and work stations 2. Drag and drop any file on the folder from server or workstation. 1.Download the file from the share folder from workstation or server 1. Navigate to the E-form 2. Input the information in the following fields: name, address,… 3. Check all the require software boxes 4. Sign the E-form E-form Testing Test the E-form for input 5. Type the date that signed 6. Open up the .csv file and check the submitted data was captured 7. Open email to check the Notification of E-form 1. Click the script from share folder 2. Open the script on Auto IT AutoIT Scripting Test the automation installer script 3. Press F5 to run the script 4. Press CTRL + Break to restart the script AutoIT Scripting with Task Scheduler 1. Click on Task Scheduler 2. 2. Click the “Action” tab - Click the “Create Task” and type the test name - Click “Trigger” tab o Click “New..” button Test the automation o Set date and time for the installer script using the script to run Task scheduler o Click “OK” - Click Action” tab o Click “New…” button o Action: Start a program o Browse the script location o Click “OK” - Click “OK” Test Executed by: Test Execution date: Tu Nguyen, Ben Gentile 09/30 - 10/27 Expected Result Actual Result Share folders will appear in the network between server and The share folders wasn’t appear workstation Status FAIL Files will show in the share folder same as expected PASS The files are downloadable same as expected PASS E-form will appear same as expected PASS The field show the information that just typed same as expected PASS The check mark will appear same as expected PASS The signature will appear same as expected PASS The date will show on E-form same as expected PASS The csv file appear after submit same as expected PASS same as expected PASS same as expected PASS same as expected PASS The email will notify that information from e-form will stored in database Scripts will locate in the share folder in the network The script will open The script will run The script wasn’t run FAIL The script will stop and restart same as expected PASS Error The share folder wasn’t show because of the Ethernet cable The script wasn’t work because the software need a new version The Task Scheduler will open same as expected PASS The task will be created to run the script at the specific time same as expected PASS Fix the Error Status Replace a new Ethernet cable PASS Download the new version of software PASS Compatibility Report for Final Test Script Result - Tu Nguyen.xls Run on 11/19/2015 17:29 The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when opening this workbook in an earlier version of Excel or if you save this workbook in an earlier file format. Minor loss of fidelity Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available. # of occurrences 1 Version Excel 97-2003 Next Gen Cyber Solutions George Mason University Volgenau School of Engineering 4400, University Dr., Fairfax, VA 22030 Test Plan and Test Scripts Author: Next Gen Cyber Solutions Creation Date: 10/08/15 Last Revised: 10/15/15 Version: 1.0 1 Next Gen Cyber Solutions George Mason University Volgenau School of Engineering 4400, University Dr., Fairfax, VA 22030 TEST ENVIRONMENT We will do the testing of the project at 1020 N Fairfax St#400, Alexandria, VA 22314. The testing will start on Wednesday October 1st, 2015 at 5pm. We will test on the testing room of the company with server and workstations that connected to router. The room has all the things that support for the testing including: Wi-Fi, Projection, server, workstations, router, and switch. WHAT WILL BE TESTED a. Test the network/connection between server and workstations a. Sending/receiving file between workstation and server b. Share drive/ share folder b. Test the AutoIT scripts a. Script for each program b. Script for multiple programs c. Script running on workstation d. Script running on server e. Using Task Scheduler to run the scripts c. Test E-form a. Calendar b. Input data c. Check box d. Submission of E-form e. Compare information in the database f. Reviewable g. Editable d. Test Skykick Email migration a. Account log in / log out b. Transfer email c. Sync email d. Email send/ receive 2 Next Gen Cyber Solutions George Mason University Volgenau School of Engineering 4400, University Dr., Fairfax, VA 22030 TEST SCHEDULE AND DURATION There are many things that need to be test in order to make sure they work correctly. The testing will take about 4 weeks for all parts. The first day for testing according to schedule is October 1st, 2015 and finish by October 27th, 2015. We have schedule to test 2 days per week and 4 hours per day. The testing part will be follow exactly as schedule. There would be another re-test schedule if there is any problem with the testing. TESTERS Each member in Next Gen Cyber Solution will do some specific tasks for testing. • Ben Gentile o Create sample script o Set up scripts testing o Run script on server o Technician view of e-form testing o Client view of e-form testing o Document all the test • Tu Nguyen o Create scripts o Set up scripts testing o Run scripts on server o Workstation testing o Document all the test • Waseem Ullah o Create new sample information of e-form o Check input information of e-form o Check date calendar of e-form o Check all the check box and required field in the e-form o Import customer data • Muhammad Naveed o Create scripts o Run script on the work station o Network testing 3 Next Gen Cyber Solutions George Mason University Volgenau School of Engineering 4400, University Dr., Fairfax, VA 22030 o Client view of e-form testing o Task scheduler for script testing • Parsa Abdollahi o Server configuration testing o Network testing o Create user account for Skykick email o Email testing o Account user for email testing • Purna Gurung o Create scripts o Run scripts on workstation o Network testing o Report testing TEST PROCESS To make sure the testing not affect to the sensitive data of the company, the dummy data was created. The server and workstations were placed in different network of the company for the security purpose. Here is the list of what equipment and data used for the test: - Server - Workstations - Skykick program - Customer account for e-form - Task scheduler - Reports - Scripts for example program - E-form - Documents 4 Next Gen Cyber Solutions George Mason University Volgenau School of Engineering 4400, University Dr., Fairfax, VA 22030 SAMPLE TEST SCRIPTS & RESULT Server and workstation Testing Step 1. Create share folders in the map network 2. Drag and drop any file on the folder from server or workstation. 3. Download the file from the share folder from workstation or server Result Share folders will appear in the network between server and workstation Files will in the share folder The files are downloadable E-form Testing Step 1. Navigate to the E-form Result E-form will appear 2. Input the information in the following fields: name, address,… 3. Check all the require software boxes The field show the information that just typed The check mark will appear 4. Sign the E-form 5. Type the date that signed 6. Open up the .csv file and check the submitted data was captured 7. Open email to check the Notification of E-form The signature will appear The date will show on E-form The csv file appear after submit The email will notify that information from e-form will stored in database 5 Next Gen Cyber Solutions George Mason University Volgenau School of Engineering 4400, University Dr., Fairfax, VA 22030 AutoIT Scripting ➢ Scripting Step 1. Click the script from share folder 2. 3. Open the script on Auto IT Press F5 to run the script 4. Press CTRL + Break to restart the script Result Scripts will locate in the share folder in the network The script will open The script will run The script will stop and restart ➢ Scripting Using Task scheduler Step 1. Click on Task Scheduler 2. Click the “Action” tab - Click the “Create Task” and type the test name - Click “Trigger” tab o Click “New..” button o Set date and time for the script to run o Click “OK” - Click Action” tab o Click “New…” button o Action: Start a program o Browse the script location o Click “OK” - Click “OK” Result The Task Scheduler will open The task will be created to run the script at the specific time 6 Next Gen Cyber Solutions George Mason University Volgenau School of Engineering 4400, University Dr., Fairfax, VA 22030 Skykick Step 1. Account log in 2. Install Skykick migration 3. Sign in for the account Skykick 4. Click Activate to run Result Able to show Skykick account The Skykick will be install in the system Activated the Skykick account The Skykick will grab the pst files and then migrate to Office 365 RETEST STRATEGY There are 3 to 4 people in the team will do the re-test to make sure everything working correctly. The team also create multiple dummy data and different testing technique to test. The team will make a report after each testing to keep track what is missing or what need to re-test. TEST RECORDING PROTOCOL Each member will follow the testing scripts to test the e-form, connection of network, scripts, and the Skykick Email. All the members will use the screen recording to record all the testing that need to be done. All the testing will be document in document format for later use. Member will watch and re-test as schedule. 7 Test - Start and Stop (09/20/2021 - 09/26/2021) Comments Start Date 09/20/2021 09/20/2021 End Date 09/26/2021 09/26/2021 Task Test Website Load Speed Run content text through a spell-checker Test Contact Us form Test Compatibility across devices SSLLab.com Test Bookings Service 09/20/2021 09/20/2021 09/26/2021 09/26/2021 09/20/2021 09/20/2021 09/26/2021 09/26/2021 Booking, Cancellation, Payments, etc.
Purchase answer to see full attachment