Author Archives: Evelina Rosser

CAN YOU PROVIDE EXAMPLES OF STUDIES THAT HAVE TESTED THE PROPOSITIONS OF SOCIAL IDENTITY THEORY

Leave a reply

Social identity theory proposed by Henri Tajfel and John Turner in the 1970s suggests that individuals derive a sense of who they are based partially on the groups they belong to. A central proposition of the theory is that individuals are motivated to achieve a positive social identity and self-esteem from belonging to social groups. Since its development, social identity theory has received significant empirical research and testing of its core propositions. Here are some examples of classic and contemporary studies that have helped validate social identity theory:

One of the early and seminal experiments designed to test social identity theory was conducted by Tajfel and his colleagues in 1971 known as the “minimal group paradigm”. In this study, participants were arbitrarily assigned to meaningless groups based on trivial criteria like preferences for certain artists or scents. Despite the groups having no meaningful differences, results showed participants tended to favor members of their own group over others when making rewards allocations. This provided support for social identity theory’s proposition that merely categorizing individuals into social groups is sufficient to trigger in-group favoritism and bias. The minimal group studies demonstrated how social identities and intergroup behavior can form even in the absence of prior interactions or meaningful distinguishing characteristics between groups.

Another important line of research tested social identity theory’s prediction that individuals are motivated to achieve positive social identities. In 1976, Doosje, Ellemers, and Spears conducted a study where participants’ social identities were either enhanced or threatened. Results showed those whose social identities as group members were threatened displayed more negative evaluations of outgroups, while positively reinforced identities led to more cooperative intergroup behavior. This supported the theorized link between threats/enhancements to social identity and responses aimed at maintaining positive group distinctiveness. Further experiments by Branscombe and Wann in 1994 replicated these effects and pointed to the role of collective self-esteem in upholding positive social identities.

Social identity theory also posits that identities become more salient in contexts marked by intergroup comparisons. To evaluate this, Brown and her colleagues in 1992 performed a meta-analysis of 80 studies using a real or imagined competitive framework between groups. They found strong evidence that intergroup competition reliably leads to more pronounced in-group bias and favoritism compared to non-competitive contexts as identities become more relevant for self-definition. More recent work by Golec de Zavala and colleagues in 2009 also showed social comparisons between nationwide groups can impact national identification and intergroup threat perceptions among individuals.

The proposition that identity salience is context-dependent has further been substantiated in field settings. For example, Crisp and colleagues in 2015 examined perceptions of national identity salience and intergroup relations among followers of football teams in England. Survey results indicated English fans reported heightened English identity and biases toward rival Welsh fans particularly after losses to Welsh teams when collective identities felt most threatened. Similarly, research by Jecker and Landy in 1969 on racial attitudes found that encounters framed in competitive terms led to more polarized social identities and prejudice than non-competitive frames. These studies provide evidence identities become more meaningful guides for behavior in contexts of intergroup conflict versus cooperation.

Over decades of experimentation and investigation across situations, social identity theory’s core ideas about the psychological effects of group memberships have received considerable empirical support. Studies using the minimal group paradigm, identity threat/enhancement manipulations, and examinations of competitive versus cooperative contexts have consistently borne out social identity theory’s key propositions. From arbitrarily assigned groups to meaningful social categories, research has validated social identity theory’s insights regarding in-group favoritism, needs for positive distinctiveness, and contextual variation in identity salience. The replicability and generalizability of findings substantiating social identity theory across lab and real-world settings speaks to its enduring usefulness as a framework for understanding intergroup relations and social behavior.

HOW CAN I USE GITHUB TO SHOWCASE MY CAPSTONE PROJECT TO POTENTIAL EMPLOYERS

Leave a reply

GitHub is a great platform to showcase your work and skills to potential employers. Here are some tips on leveraging GitHub effectively to highlight your capstone project:

Create a public repository for your project. This allows anyone, including recruiters and hiring managers, to view your project code and documentation without needing access. Within the repository, include a detailed README file that describes your project. Explain what problem/issue it addresses, the technologies used, major features, any lessons learned, and how someone could run it locally. Well documented code is important for employers to understand your development process.

Use appropriate organization and file naming within the repository. Maintain a clean, logical folder structure and give files descriptive names so someone unfamiliar can easily understand the purpose of each file at a glance. Proper code organization demonstrates good development practices. You may also include screenshots or demo videos of your project in use within the repository to help visualizers understand what it does without needing to run it locally.

Highlight technical skills and accomplishments through code and commit history. Employers will look through your code and commit history to evaluate your abilities. Use consistent commit messages to understand the development timeline. Comments within the code explaining choices made, solutions to problems, or areas for potential improvement allow evaluators to see your thought processes. They also indicate you code and commit regularly which shows dedication to learning and progressing your skills over time.

Consider including additional documentation beyond just code. For example, designing mockups or wireframes during planning, prototype documentation, project plan or schedule, list of requirements or user stories addressed, database schema, API documentation if applicable. Extra documents provide more context into your full development process beyond just the end product code. They highlight organizational and communication abilities valued by employers.

Customize the repository description and README to capture an employer’s attention. Include a brief high-level overview of the project that clearly conveys what problem it solves and for whom. Highlight any notable achievements, lessons learned or challenges overcome during development. Mention relevant technologies, libraries or frameworks used to complete it. Employers will scan descriptions to quickly understand If a project demonstrates skills or experience they seek.

Directly link to your GitHub profile and highlight capstone project on your resume and in applications. Recruiters may check your profiles to learn more about your work and validate claims made on resumes or in interviews. On your resume, include a dedicated section for the capstone project with a description and directly link to the GitHub repo. This makes it easy for employers to immediately see the project when reviewing your application.

Keep the repository and content up to date. Continue improving and adding features to the project and documenting enhancements in commit messages and changelogs. Demonstrating ongoing development beyond just school coursework indicates continued passion in the skills showcased. Employers want to see candidates who consistently progress themselves and don’t consider education the end of their learning. It also keeps the repository active, making it more likely to be discovered.

Use GitHub features like wikis, issues, projects to further showcase understanding. For example, maintain user documentation on a wiki, demonstrate project management skills through organized issues and projects boards. Comments on code from others validate skills and understanding and spark technical discussions that employers may discover. Interactions on GitHub provide additional context into how well you can explain and teach concepts, as well as work with others.

GitHub provides an excellent platform to highlight your full capstone project and development process through code, documentation and activity history in a easily discoverable manner for employers. With a well structured and regularly maintained public repository, recruiters and hiring managers can quickly understand your top skills and accomplishments. It allows technical evaluators to dig deeper and really assess your abilities through documented work rather than just resume claims. Leveraging GitHub effectively can give your capstone project and application that added edge to stand out from other candidates.

WHAT ARE SOME KEY SKILLS THAT STUDENTS CAN DEVELOP THROUGH CAPSTONE PROJECTS IN PUBLIC HEALTH

Leave a reply

Capstone projects in public health provide students with important opportunities to develop real-world skills that will serve them well in future public health careers or graduate programs. Through undertaking a substantive capstone project, students gain valuable experience applying the knowledge and principles they have learned during their public health studies. They also strengthen and expand their skill set in ways that will make them stronger candidates for jobs or advanced education programs.

Some of the most important skills that students can build through public health capstone projects include:

Research Skills – Capstone projects require independent research into a topic related to public health. Students strengthen their abilities to formulate research questions, conduct literature reviews, develop quantitative and qualitative research methodologies, collect and analyze data, interpret results, and draw evidence-based conclusions. These research skills are highly transferable to careers in public health that involve program evaluation, epidemiological investigations, needs assessments, and more.

Program Planning and Evaluation – Many capstone projects involve designing, planning and/or evaluating a public health program, intervention, or policy. This gives students experience with needs assessment, priority setting, developing logic models, process and outcome measurement, quality improvement strategies, and other program planning and evaluation techniques. These are skills that are valuable for work in health promotion programming, non-profit management, health policy analysis, and various clinical roles.

Communication Skills – To complete a successful capstone project, students must apply both written and oral communication skills. This includes writing reports, manuscripts, proposals and presentations as well as delivering oral presentations to peers, faculty members and other audiences. Students gain confidence in their ability to convey public health information and ideas clearly and persuasively to diverse stakeholder groups – a core competency for nearly all public health careers.

Collaboration Skills – Capstone projects frequently involve working in teams or with external organizations and stakeholders. This provides leadership experience, as well as the development of collaboration skills like relationship building, conflict resolution, cultural competence, project management, peer accountability and group decision making. All of these soft skills are invaluable for multidisciplinary work in community public health settings.

Critical Thinking – Working through the various stages of a capstone project, from shaping research questions to analyzing results, enhances students’ critical thinking abilities. This includes skills like problem solving, evaluation of biases, integration of evidence, and ability to think outside the box. Strong critical thinking is necessary for assessing complex public health issues from multiple angles and designing innovative and tailored solutions.

Ethical Practice – Issues like human subjects research, privacy/confidentiality, conflicts of interest and health equity often emerge within capstone work. This exposes students to real-world ethical dilemmas, strengthening their understanding of ethics frameworks and ability to navigate challenges with integrity and care for vulnerable populations. Ethical decision making underpins all areas of public health practice.

Self-directed Learning – Completing an independent capstone project from start to finish requires self-motivation, time management, and the ability to seek out needed resources and expertise. Students therefore gain valuable experience taking initiative and responsibility for their own learning. This portends well for lifelong learning and career advancement within changing public health environments.

Public health capstone projects offer rich, practical learning experiences that enable students to develop the wide-ranging professional competencies expected of 21st century public health leaders, researchers, clinicians, program developers, and policy advocates. By immersing students in independent research and professional activities, capstones accelerate students’ transition from classroom to career and help launch them on a trajectory for success within public health systems. The many skills students gain through capstone work give them a competitive edge both for employment and further public health education.

CAN YOU PROVIDE EXAMPLES OF CAPSTONE PROJECTS IN THE FIELD OF DATA ANALYTICS

Leave a reply

Customer churn prediction model: A telecommunications company wants to identify customers who are most likely to cancel their subscription. You could build a predictive model using historical customer data like age, subscription length, monthly spend, service issues etc. to classify customers into high, medium and low churn risk. This would help the company focus its retention programs. You would need to clean, explore and preprocess the customer data, engineer relevant features, select and train different classification algorithms (logistic regression, random forests, neural networks etc.), perform model evaluation, fine-tuning and deployment.

Market basket analysis for retail store: A large retailer wants insights into purchasing patterns and item associations among its vast product catalog. You could apply market basket analysis or association rule mining on the retailer’s transactional data over time to find statistically significant rules like “customers who buy product A also tend to buy product B and C together 80% of the time”. Such insights could help with cross-selling, planograms, targeted promotions and inventory management. The project would involve data wrangling, exploratory analysis, algorithm selection (apriori, eclat), results interpretation and presentation of key findings.

Customer segmentation for banking clients: A bank has various types of customers from different age groups, locations having different needs. The bank wants to better understand its customer base to design tailored products and services. You could build an unsupervised learning model to automatically segment the bank’s customer data into meaningful subgroups based on similarities. Variables could include transactions, balances, demographics, product holdings etc. Commonly used techniques are K-means clustering, hierarchical clustering etc. The segments can then be profiled and characterized to aid marketing strategy.

predicting taxi fare amounts: A ride-hailing company wants to optimize its dynamic pricing strategy. You could collect trip data like pickup/drop location, time of day, trip distance etc and build regression models to forecast fare amounts for new rides. Linear regression, gradient boosting machines, neural networks etc. could be tested. Insights from the analysis into factors affecting fares can help set intelligent default and surge pricing. Model performance on test data needs to be evaluated.

Predicting housing prices: A property investment group is interested in automated home valuation. You could obtain datasets on past property sales along with attributes like location, size, age, amenities etc and develop regression algorithms to predict current market values. Both linear regression and more advanced techniques like XGBoost could be implemented. Non-linear relationships and feature interactions need to be captured. The fitted models would allow estimate prices for new listings without an appraisal.

Fraud detection at an e-commerce website: Online transactions are vulnerable to fraudulent activities like payment processing and identity theft. You could collect data on past orders with labels indicating genuine or fraudulent class and build supervised classification models using machine learning algorithms like random forest, logistic regression, neural networks etc. Features could include payment details, device specs, order metadata, shipping addresses etc. The trained models can then evaluate new transactions in real-time and flag potentially fraudulent activities for manual review. Model performance, limitations and scope for improvements need documentation.

These are some examples of data-driven projects a student could undertake as part of their capstone coursework. As you can see, they involve applying the data analytics workflow – from problem definition, data collection/generation, wrangling, exploratory analysis, algorithm selection, model building, evaluation and reporting insights. Real-world problems from diverse domains have been considered to showcase the versatility of data skills. The key aspects covered are – clearly stating the business objective, selecting relevant datasets, preprocessing data, feature engineering, algorithm selection basis problem type, model building and tuning, performance evaluation, presenting results and scope for improvement. Such applied, end-to-end projects allow students to gain hands-on experience in operationalizing data analytics and communicate findings to stakeholders, thereby preparing them for analytics roles in the industry.

WHAT ARE SOME BEST PRACTICES FOR CREATING EFFECTIVE FINANCIAL DASHBOARDS IN EXCEL

Leave a reply

Define Clear Objectives: Before starting to build your dashboard, take time to clearly define the objectives and intended users. Make sure to understand the key questions the dashboard needs to answer and the specific decisions it aims to inform. Having clear objectives will help guide your design and ensure the dashboard is useful.

Use Visual Elements Like Charts and Colors: Financial dashboards should incorporate visual elements like charts, graphs, color coding, and conditional formatting to quickly convey insights and trends at a glance. Pie charts, bar graphs, line charts etc. are great for comparing metrics over time or across categories. Consistent colors can highlight areas needing attention.

Keep it Simple: Avoid overcrowding the dashboard with too many numbers, charts or unnecessary details. Focus on only the 2-5 most important metrics and KPIs. A simpler, cleaner layout allows users to easily digest the most critical information without having to sift through excessive data.

Provide Context with Descriptions: Ensure each metric and visual included has a clear description or label so users understand what precisely is being presented. Provide context on how the numbers should be interpreted and if there are any targets or benchmarks for comparison.

Enable Filtering and Drill-Down: Consider including filtering options to allow users to view the dashboard data by different dimensions like date range, department, location etc. Drill-down capabilities let users easily access underlying reports or data with more granular details as needed. This enhances flexibility and analysis.

Use Consistent Formatting: Appoint consistent styling for things like fonts, colors, layout, and naming conventions to provide visual consistency across the dashboard. This makes it easier for users to navigate and mentally process the information.

Include Prior Period Comparisons: Incorporate comparisons to prior periods like last month, last quarter or last year through things like actual vs. target lines on charts. Seeing variances helps users quickly assess performance and trends over time.

Pay Attention to Page Layout: The visual layout and organization of sections, charts and metrics impact usability. Group related information together and use whitespace effectively to prevent clutter. Optimize for landscape or portrait viewing as appropriate.

Enable Interactivity: Leverage Excel’s dynamic features by making cells, charts, and other visuals interactive. For example, allow filters to update dependent charts automatically. Drill-down capabilities from summary cells to details. Enable what-if scenario modeling by linking input cells.

Consider Mobile Optimization: For dashboards used regularly on mobile, test readability on smaller screens. Simplify visuals as needed and allow functional filtering in a compact layout. Progressive web apps or Power BI may be better suited for frequent mobile access.

Get Input from Stakeholders: Involve intended users and decision makers during development to ensure their main reporting and analysis needs are fulfilled. Solicit feedback on prototyped versions for improvements prior to final deployment.

Set a Cadence for Refreshing: To retain usefulness, assign responsibility and automation for refresh frequencies based on how often the underlying data changes. Daily, weekly, or monthly automatic updates keep the insights current.

Track Adoption Metrics: Implement Google Analytics or other tools to discretely track dashboard usage over time. Understand what content drives the most interaction to continuously enhance and focus on highest priority analysis needs.

Provide Training and Support: Upon initial rollout, offer training sessions to help users learn navigation and maximize the analysis capabilities. Provide ongoing help resources like guides, hotline support or embedded tips for adoption and addressing pain-points over the long-term.

Financial dashboards are most effective when they inform high-level decisions through presentation of only the clearest, most diagnostic insights in an easily digestible visual format. Following these design best practices can help ensure Excel dashboards clearly convey critical metrics and KPIs to drive better business performance.