Reflection 1 Mode 6_ENCL 557 Comprehensive Strategic Planning Process
Objective: Apply knowledge management to a given data problem
Comprehensive Strategic Planning Process is a journey starting with a problem and ending with set guidelines on how to solve the problem. The process starts with knowing the present situation in the organization. To get an accurate picture of where you’re the organization is, there is the need to conduct external and internal audits to get a clear understanding of the marketplace, the competitive environment, and organization’s competencies (real—not perceived—competencies). Next is to identify what is important. By focusing on where the health care organization needs to be, a clear direction of the enterprise over the long haul will appear. This clear direction which is usually consistent with the mission and vision of the organization will determine the priority issues—those issues so significant to the overall well-being of the health care organization that they require the full and immediate attention of the entire management team. The strategic plan should focus on these issues.
The next three steps involves defining what must be achieved, determining who is accountable for what and reviewing the plan for thoroughness. To ensure the plan performs as designed, there must be regularly scheduled formal reviews of the process and refine as necessary. A quarterly review meeting is recommended. In performing this strategic plan for the Georgia Department of Public, I came across a lot of data being handled by the department. The Department is the “health face” of the State that combines all health data from CDC/WHO through Community Health Clinics to hospital organization in order to better the life of the people of Georgia.
As captured in SWOT analysis, their partnerships with Institutions of higher learning, quality programs, their fiscal responsibility and knowledgeable, skilled, dedicated and committed workforce are the bedrock of their strength. Their weaknesses include communication challenges (inherent), recruiting and retaining qualified workforce, technology, data management, internal communication mechanisms and practices. The one internal threat is competing with agencies with greater resources. But other external threats like inadequate federal funding, healthcare policies and regulations, shortage of qualified and skilled DPH workforce are evident. However, great opportunities exist in DPH. New partnerships ,new technology, business process re engineering for Enterprise Systems Modernization and legislative support are just some of the opportunities at DPH. With this analysis and the strategic plan fully implemented, DPH is poised to continue to fulfill its mission of protecting the lives of all Georgians.
This meets the Course requirement by providing me with the basic knowledge of using available data to create a strategic plan for the future.
Reflection 2 Mod 6_MSNC 507 Statistical Journal Review
Objective: Apply selected statistical methodologies to evaluate a problem
At the end of this statistic class, it was necessary to gauge the moral compass of public health nurses. This is because, in many ways, public health nurses are like parents and teachers. They are one of the first professionals who interact with the majority of our population at their most vulnerable and receptive moments. Therefore, public health nurses (PHN(s)) have the opportunity and professional obligation to be front and center in piloting the moral direction of the nation while also being at the forefront of dissemination for the fight to eliminate health disparities based on the practice principle of social justice. The overall purpose of this descriptive study was to explore the stage of the moral development in a convenience sample of practicing public health nurses (PHN(s)) and the differences in moral development stage across selected demographic variables (age, gender, race/ethnicity, level of entry into professional nursing, highest level of education, years practicing as an RN, years practicing in a public health department, self-identified political views, primary language, and region.)
The data from this study suggest that the moral development of the current PHN workforce is at the stage of post-conventional morality. Thus, PHN(s) recognize the flexibility of rules while noting that when rules no longer serve in the best interests of society the rules can and should be changed. This level of values should facilitate the current expectation society has for all public health workers, especially for public health nurses.
At the course of this class, I have come to appreciate the use of mean, statistical tests, standard deviation, tests of hypothesis and regression analysis in bio-statistics. While the mean life expectancy of a sample of cancer patients who took a certain type of medication may be one year higher than those who did not, a t-test is required to find out if the result is repeatable for the entire population. When repeatability has been established, a predictive model can be developed for the effect of the medication on cancer patients using regression. Moreover, by looking at bio data, I can make a prediction on the data sample and can reject the prediction based on the p-value using test of hypothesis. Equally interesting is the use of standard deviation to predict the spread of the data set away from the mean. I also know that outliers can skew results. The comparative value of adjusted R squared, and the use of significance F as a pretest for p-values will continue to play a significant role in my data analysis.
The lessons learned in this class will be improved on by analysis of more data with varying assumptions to compare the effect of each variation from the original results. Using Tableau will be another focus for me. The overall result of this class will be better data visualization for clients. Data sets will now be part of our presentations in visual formats that will tell a more compelling story of the situation than just numbers and tables. This has been a very rewarding class.
Reflection 3 Mod 6_HCIN 543 Structured Query Language (SQL)
Objective: Demonstrate skills in the use of data management software such as SQL and Microsoft Office to analyze a given problem
Companies nowadays capture tons of data and expect employees in all departments to use it methodically in their decision making processes. Our world of today is interdependent and interconnected through websites and apps. The main reason that we are able to see all these websites on the internet is because most of the content generated on the sites can be handled through databases. On its own, database management can be a very difficult job, but using the SQL programming language can help ease things a bit. Structured Query Language or SQL is widely used for editing and querying information within different database management systems.
With the implementation of electronic health records (EHR), tons and tons of medical data will be made available for research, analysis and policy making in the healthcare industry. SQL is required to access and query the data for information relevant to each course. SQL is so central in database management that most of the information management security infrastructure is built around it. The SQL Server is used to store data such that the security and integrity of the data can be better managed. When it comes to SQL Server security, it is important to see this as an ever-evolving process. Users will change, apps will evolve, and access to more data tools will be required. SQL allows you to control and even optimize the delivery of this data. It is always a good practice to use firewalls when it comes to SQL security as first generation firewalls can help with data loss prevention and even help in data flow control. Additionally, networks can be divided into security zones to ensure SQL traffic is monitored and isolated. This multi-tiered environment helps create monitored subnets, and helps isolate traffic flow. Finally, a good security architecture, leveraging a firewall platform, can help prevent SQL injections and even cross-site scripting attacks. SQL has also played a vital role in data authentication, network security, and encryption. The query, form and report wizards of Access combined with the formula capabilities of Microsoft Office remains an enormous tool in database management. This Program has not only introduced me to this vast resources but has also given me the essential road map to apply them in real life.
Objective: Apply knowledge management to a given data problem
Comprehensive Strategic Planning Process is a journey starting with a problem and ending with set guidelines on how to solve the problem. The process starts with knowing the present situation in the organization. To get an accurate picture of where you’re the organization is, there is the need to conduct external and internal audits to get a clear understanding of the marketplace, the competitive environment, and organization’s competencies (real—not perceived—competencies). Next is to identify what is important. By focusing on where the health care organization needs to be, a clear direction of the enterprise over the long haul will appear. This clear direction which is usually consistent with the mission and vision of the organization will determine the priority issues—those issues so significant to the overall well-being of the health care organization that they require the full and immediate attention of the entire management team. The strategic plan should focus on these issues.
The next three steps involves defining what must be achieved, determining who is accountable for what and reviewing the plan for thoroughness. To ensure the plan performs as designed, there must be regularly scheduled formal reviews of the process and refine as necessary. A quarterly review meeting is recommended. In performing this strategic plan for the Georgia Department of Public, I came across a lot of data being handled by the department. The Department is the “health face” of the State that combines all health data from CDC/WHO through Community Health Clinics to hospital organization in order to better the life of the people of Georgia.
As captured in SWOT analysis, their partnerships with Institutions of higher learning, quality programs, their fiscal responsibility and knowledgeable, skilled, dedicated and committed workforce are the bedrock of their strength. Their weaknesses include communication challenges (inherent), recruiting and retaining qualified workforce, technology, data management, internal communication mechanisms and practices. The one internal threat is competing with agencies with greater resources. But other external threats like inadequate federal funding, healthcare policies and regulations, shortage of qualified and skilled DPH workforce are evident. However, great opportunities exist in DPH. New partnerships ,new technology, business process re engineering for Enterprise Systems Modernization and legislative support are just some of the opportunities at DPH. With this analysis and the strategic plan fully implemented, DPH is poised to continue to fulfill its mission of protecting the lives of all Georgians.
This meets the Course requirement by providing me with the basic knowledge of using available data to create a strategic plan for the future.
Reflection 2 Mod 6_MSNC 507 Statistical Journal Review
Objective: Apply selected statistical methodologies to evaluate a problem
At the end of this statistic class, it was necessary to gauge the moral compass of public health nurses. This is because, in many ways, public health nurses are like parents and teachers. They are one of the first professionals who interact with the majority of our population at their most vulnerable and receptive moments. Therefore, public health nurses (PHN(s)) have the opportunity and professional obligation to be front and center in piloting the moral direction of the nation while also being at the forefront of dissemination for the fight to eliminate health disparities based on the practice principle of social justice. The overall purpose of this descriptive study was to explore the stage of the moral development in a convenience sample of practicing public health nurses (PHN(s)) and the differences in moral development stage across selected demographic variables (age, gender, race/ethnicity, level of entry into professional nursing, highest level of education, years practicing as an RN, years practicing in a public health department, self-identified political views, primary language, and region.)
The data from this study suggest that the moral development of the current PHN workforce is at the stage of post-conventional morality. Thus, PHN(s) recognize the flexibility of rules while noting that when rules no longer serve in the best interests of society the rules can and should be changed. This level of values should facilitate the current expectation society has for all public health workers, especially for public health nurses.
At the course of this class, I have come to appreciate the use of mean, statistical tests, standard deviation, tests of hypothesis and regression analysis in bio-statistics. While the mean life expectancy of a sample of cancer patients who took a certain type of medication may be one year higher than those who did not, a t-test is required to find out if the result is repeatable for the entire population. When repeatability has been established, a predictive model can be developed for the effect of the medication on cancer patients using regression. Moreover, by looking at bio data, I can make a prediction on the data sample and can reject the prediction based on the p-value using test of hypothesis. Equally interesting is the use of standard deviation to predict the spread of the data set away from the mean. I also know that outliers can skew results. The comparative value of adjusted R squared, and the use of significance F as a pretest for p-values will continue to play a significant role in my data analysis.
The lessons learned in this class will be improved on by analysis of more data with varying assumptions to compare the effect of each variation from the original results. Using Tableau will be another focus for me. The overall result of this class will be better data visualization for clients. Data sets will now be part of our presentations in visual formats that will tell a more compelling story of the situation than just numbers and tables. This has been a very rewarding class.
Reflection 3 Mod 6_HCIN 543 Structured Query Language (SQL)
Objective: Demonstrate skills in the use of data management software such as SQL and Microsoft Office to analyze a given problem
Companies nowadays capture tons of data and expect employees in all departments to use it methodically in their decision making processes. Our world of today is interdependent and interconnected through websites and apps. The main reason that we are able to see all these websites on the internet is because most of the content generated on the sites can be handled through databases. On its own, database management can be a very difficult job, but using the SQL programming language can help ease things a bit. Structured Query Language or SQL is widely used for editing and querying information within different database management systems.
With the implementation of electronic health records (EHR), tons and tons of medical data will be made available for research, analysis and policy making in the healthcare industry. SQL is required to access and query the data for information relevant to each course. SQL is so central in database management that most of the information management security infrastructure is built around it. The SQL Server is used to store data such that the security and integrity of the data can be better managed. When it comes to SQL Server security, it is important to see this as an ever-evolving process. Users will change, apps will evolve, and access to more data tools will be required. SQL allows you to control and even optimize the delivery of this data. It is always a good practice to use firewalls when it comes to SQL security as first generation firewalls can help with data loss prevention and even help in data flow control. Additionally, networks can be divided into security zones to ensure SQL traffic is monitored and isolated. This multi-tiered environment helps create monitored subnets, and helps isolate traffic flow. Finally, a good security architecture, leveraging a firewall platform, can help prevent SQL injections and even cross-site scripting attacks. SQL has also played a vital role in data authentication, network security, and encryption. The query, form and report wizards of Access combined with the formula capabilities of Microsoft Office remains an enormous tool in database management. This Program has not only introduced me to this vast resources but has also given me the essential road map to apply them in real life.
| artifact_1_mod_6_enlc_557_comprehensive_strategic_planning_process_map.docx |
| artifact_2_mod_6__msnc-507-02e-su19_–_statistics-journal_review.docx |
| artifact_3_mod_6_hcin_543_sql_programing_language__sql_querries_.docx |
