Tag Archives: projects

CAN YOU RECOMMEND ANY OTHER RETAIL DATASETS THAT ARE SUITABLE FOR CAPSTONE PROJECTS

Kaggle Retail Dataset: This dataset contains over 10 years of daily sales data for 45,000 food products across 10 stores. It includes fields like store, department, date, weekly sales, markup, and more. With over 500,000+ rows, it provides a lot of rich data to analyze retail sales patterns, perform forecasting, explore department performance, and get insights into pricing and promotion effectiveness. Some potential capstone projects could be building predictive sales models, optimizing inventory levels, detecting anomalies or outliers, comparing store or department performance, etc.

Online Retail II Dataset: This dataset from the UCI Machine Learning Repository contains transactions made by a UK-based online retail between 01/12/2009 and 09/12/2011. It includes fields like InvoiceNo, StockCode, Description, Quantity, InvoiceDate, UnitPrice, CustomerID, and Country. With over 5,000 unique products and around 8,000 customers, it allows examining customer purchasing behaviors, product categories, sales trends over time. Capstone ideas could be customer segmentation, recommendation engines, predictive churn analysis, promotion targeting, assortment optimization, etc.

European Retail Study Dataset: This dataset was collected between 2013-2015 across 24 countries in Europe to study omni-channel retail. It provides information on over 42,000 customers, their purchase transactions, demographic details, online/offline shopping behaviors, returns etc. Some dimensions covered are age, gender, income-level, product categories purchased, channels used, spend amounts. This rich dataset opens up opportunities for multi-channel analytics, personalized experiences, loyalty program design, understanding cross-border trends at a continental scale.

Instacart Market Basket Analysis Dataset: This dataset collected over 3 million grocery orders from real Instacart customers. It includes anonymized order data with product names, quantities, added or removed from basket, purchase or cancellation. This provides scope for advanced market basket or transactional analysis to determine complementary or frequently bought together products, influencing factors on abandoned cart recovery, incremental sales from personalized recommendations, effects of out-of-stock items etc.

Walmart Sales Forecasting Dataset: This dataset contains daily sales data for 45 Walmart stores located in different regions collected over 3 years. Features include Store, Dept, Date, Weekly_Sales, Markup, etc. It can be leveraged to build statistical or deep learning models for short and long term demand forecasting across departments, developing automatic outlier detection capabilities, scenarion analysis during special events etc.

Target Customer Dataset: This dataset contains purchasing profiles for over 5000 anonymous Target customers encompassing their transactions over a 6 month period. It includes features like age, gender, marital status, home ownership, number of dependents, income, spend categories within Target like grocery, personal care, electronics etc. This could enable identifying high lifetime value segments, developing micro-segmentation strategies, testing personalization and targeted promotions approaches.

Kroger Customer Analytics Dataset: This dataset contains anonymous profiles of over 30,000 Kroger customers including their demographics, surveyed household & lifestyle characteristics, shopping behaviors and purchasing basket details. Variables provided are age, ethnicity, family status, income level, ZIP code, preferences like organic, wellness focused etc along with purchases across departments. Potential projects include customer churn analysis, propensity modeling for private label brands, targeted loyalty program personalization at scale.

These datasets offer rich retail data that span various dimensions – from transactions, customers, banners to omni-channel behavior. They enable diving deep into opportunities like forecasting, recommendations, segmentation, promotions analysis, supply chain optimization at scale suitable for many capstone project ideas exploring insights for retailers. The datasets are publicly available and of a good volume and variety to power meaningful analytical modeling and drive actionable business recommendations.

HOW ARE CAPSTONE PROJECTS TYPICALLY ASSESSED AND EVALUATED BY FACULTY

Capstone projects are culminating academic experiences for students that allow them to demonstrate their mastery of the knowledge and skills gained over the course of their undergraduate studies. Given their importance in showcasing student learning and achievement, faculties put significant thought and effort into developing comprehensive assessment approaches for capstone projects.

Some of the key criteria and rubrics faculty commonly use to evaluate capstone projects include:

Problem Identification and Solution Design – Faculty look to see if students were able to properly identify and define the problem or design challenge being addressed. They evaluate the appropriateness and feasibility of the proposed solution design. This shows a student’s ability to translate needs into viable plans or proposed interventions.

Research and Knowledge Application – Assessors examine how effectively students drew upon relevant academic literature, theories, and research findings to inform their project’s direction and methodology. Evidence of integrating, applying, and extending disciplinary knowledge demonstrates learning achievement.

Critical Thinking and Analysis – Projects are rated on the quality and rigor of critical thinking shown. This involves assessing how well students analyzed data, considered alternative perspectives, identified limitations/assumptions, and made logical inferences supported by evidence rather than unsubstantiated opinions.

Methodology and Process – The appropriateness, logical sequencing, and detailed explanation of the methods used are key criteria. Assessors evaluate the soundness of the study design, data collection procedures, and process used to develop the solution. This reflects a student’s competence in using disciplinary research/design techniques.

Results, Outcomes, Limitations – Projects that present concrete evaluative results or evidence of completed work are highly valued. The significance and implications of outcomes are considered along with students’ ability to discuss limitations, unanswered questions, and avenues for further development.

Organization, Writing Quality – Assessors look for a clear and logical structure, including well-developed introduction, body, and conclusion sections. Visual components like figures and tables should be carefully integrated. Writing must demonstrate graduate-level quality—including proper citations, minimal grammatical/stylistic errors, and effective communication for the intended audience.

Next, faculty thoroughly assess how effectively students articulated their capstone experience and learning outcomes through a final reflective essay, presentation, or ePortfolio. Students demonstrate growth in key areas like problem-solving, collaboration, oral/written communication and self-awareness. Assessors evaluate students’ reflection on the value of their work, limitations encountered, and insights gained regarding their professional development and future goals.

At many institutions, both the capstone project itself and self-reflective component are assessed using detailed rubrics aligning with the aforementioned criteria. Ratings typically range from “exceeds expectations/standards” to “meets expectations” to “needs improvement.” Multiple faculty members often evaluate each student’s work to ensure reliability and fairness.

Assessment results directly feed into individualized feedback and guidance that students receive. In some programs, results factor into graduating with academic distinction or honors. Aggregate assessment data also informs faculty of curricular strengths and limitations to improve overall program outcomes. Additional forms of assessment may include student exit surveys and interviews as well as employer feedback.

Through these rigorous yet nurturing evaluation practices, faculty can determine the extent of real-world, cross-disciplinary knowledge and higher-level competencies each student has attained. Capstone assessment thus plays a pivotal role for continuous program improvement while empowering students with a validated understanding of their educational and career readiness. It sheds light on how well a college experience prepares graduates to ethically address complex problems as lifelong learners who can adapt to changing needs.

HOW ARE CAPSTONE PROJECTS EVALUATED AT BCIT

Capstone projects at BCIT are designed to allow students to demonstrate the knowledge and skills they have gained throughout their diploma or degree program. They involve undertaking a substantive project related to the student’s field of study, where the student works independently while receiving guidance from an instructor or industry mentor. Due to the significant role capstone projects play in assessing student learning outcomes, BCIT has developed a rigorous process for evaluating these projects.

The evaluation of capstone projects at BCIT is centered around clear evaluation criteria that are shared with students early in the capstone experience. These criteria cover all aspects of the capstone from formulation of objectives, design of the project plan, implementation, outcomes, and presentation of results. For example, criteria related to the project plan may include elements such as a well-defined statement of work, timelines, budget, logical approach to tasks, and identification of risks and limitations. Criteria for implementation cover project management competencies like task tracking, issue resolution, use of tools/methodologies, safety practices, and adaptability to changes. Evaluation of outcomes focuses on technical merits such as fulfillment of objectives, quality/reliability of results, documentation of findings, and achievement of deliverables. Presentation criteria assess communication skills through organization, clarity, use of media, poise during questions, and ability to convey the significance of the work.

The capstone evaluation criteria are intended to reflect expectations that graduates should demonstrate based on the program and course learning outcomes. Instructors work with advisory boards and accreditation bodies to ensure criteria align with needs of the profession/industry. Students get guidance on applying the criteria to their projects through instruction and formative feedback over the capstone term. This support helps surface any gaps in skills early so remedial action can be taken before the final evaluation.

Typically, two evaluators are assigned to each capstone – the primary instructor overseeing the project, and a subject matter expert (SME) from industry. For some programs where multiple sections run simultaneously, common SMEs may evaluate projects across sections for consistency. The evaluators independently use rubrics tied to the evaluation criteria to assess written reports, presentations, discussion with students, and any documentation of project outcomes.

Scoring on the rubrics is most often on a scale from 1 to 5, with detailed descriptors defining expectations at each level. Evaluators must provide qualitative comments along with scores to explain ratings and provide specific feedback. Once independent evaluations are complete, the evaluators convene to moderate scores, compare perspectives, and agree on a final rating for each criterion and overall for the capstone. In cases of divergent scores, discussion focuses on evidence from the work to justify differences and reach consensus.

The final evaluated rubrics then feed into a letter grade determination. Each program or department sets grading scales customized to their rubrics and criteria. For example, an overall score average above 90% could merit an ‘A’ while 75-80% may equal a ‘B’. Student performance is also considered holistically, such as improvements shown over the term or additional accomplishments beyond expectations. Grading recommendations go through departmental review and approval before official assignment.

Should a capstone be deemed unsatisfactory or borderline, in-depth feedback is provided on gaps and remedial work required. Students may get one more term to improve their projects or risk failing the program. If there are disputes over evaluation or grading, formal appeal processes exist where students can present their cases and have decisions reviewed by separate committees.

BCIT has implemented a structured yet flexible evaluation system for capstone projects with multiple stages of moderation to uphold academic standards and fairness to students. The process helps develop work that reflects expected professional competence and fosters continuous dialogue around learning outcomes. Student and SME feedback over the years also factor into refining evaluation approaches to maintain relevance and rigour.

CAN YOU EXPLAIN THE CONCEPT OF PLACEMAKING IN INTERIOR DESIGN CAPSTONE PROJECTS

Placemaking is a collaborative process by which we can shape our public realm in order to maximize shared value. Placemaking in the context of interior design focuses on improving the functionality and character of indoor spaces to cultivate meaningful experiences for users. A key goal of placemaking is to design spaces that promote community and culture. For an interior design capstone project, implementing principles of placemaking can help students design functional yet engaging spaces that serve the needs of various stakeholder groups.

One of the essential tenets of placemaking is understanding the historic and cultural context of a space and incorporating that context meaningfully into the design. For a capstone project, students should conduct in-depth research on the building, organization or community that will occupy the designed space. This includes understanding the mission and values of the occupants, as well as researching any historical or cultural significance of the location. By comprehending the deeper context, students can design spaces that authentically serve the needs and reflect the identity of the intended users.

For example, if designing a community center located in a historic building, students may choose to incorporate design elements that pay homage to architectural details from the original structure or local cultural artifacts. Or when designing an office, students could reference symbols or imagery meaningful to the company’s brand or activities. Integrating context ensures the designed spaces have relevance, meaning and resonance for stakeholders.

Another critical piece of placemaking for capstone projects is engaging stakeholders in the design process. Interior designers should seek input from various groups who will use the space, such as employees, volunteers, visitors, community leaders and more. This can be done through interviews, focus groups, surveys and design charrettes where stakeholders provide feedback on preliminary concepts. Gathering diverse perspectives helps ensure the space is adequately serving everyone and cultivates ownership over the final design.

Students must also evaluate how people currently use and move through similar existing places. This could involve on-site observations and mapping social behaviors. Understanding natural patterns of circulation and gathering provides key insights for the most functional and people-centered layout. For example, if observing many informal meetings occur in a hallway, the new design may purposefully allocate an open lounge area in that location.

Building on insights from research and stakeholder engagement, capstone placemaking projects then define a bold vision for how the designed space can nurture human experiences and interactions. For instance, the vision may emphasize creating an inspirational and collaborative workplace, or a warm and welcoming community hub. From this vision, various aspects of the physical design such as materials, lighting, furniture, color palettes, graphics and art are intentionally selected and composed to evoke the intended experience.

Signage, wayfinding and branding should raise awareness of available programs and resources to achieve effective activation of the space. Digital displays or bulletin boards can also promote a sense of community by highlighting user-generated content. Other tactics like hosting regular gatherings and rotating art exhibits encourage ongoing connection and evolution of the space over time.

Thoughtful consideration of how people of all demographics may interact within the space is also important for inclusivity and universal access. This includes following ADA accessibility guidelines but also performing inclusive design best practices like utilizing intuitive pictograms and varying seating types. Diversity and cultural sensitivity training aids students in designing for people of all backgrounds.

Implementing placemaking principles challenges interior design capstone students to conceive holistic projects that cultivate human well-being through the strategic design of functional and experiential indoor environments. By adequately involving stakeholders and leveraging contextual research, placemaking-focused designs manifest buildings and spaces that authentically serve communities and foster a greater sense of shared value amongst all users.

CAN YOU PROVIDE SOME EXAMPLES OF REAL ESTATE CAPSTONE PROJECTS THAT HAVE BEEN SUCCESSFUL IN THE PAST

Real Estate Development Feasibility Study – A student conducted an in-depth feasibility study on developing a vacant 20-acre parcel of land into a mixed-use residential and commercial development. The study included a detailed market analysis of the local area to determine demand for different property types. Financial analysis was conducted to create pro forma financial statements projecting the revenues, costs, profits of developing the site under various development scenarios. Sensitivity analysis tested the impact of changes in assumptions. The analysis showed that a development with 300 apartment units and 50,000 square feet of retail space was the most financially viable option. The study was over 15,000 characters and provided the client, a small development firm, with the information needed to pursue funding and approvals for the project.

Multifamily Investment Property Analysis – A student was tasked with evaluating the acquisition of a 200-unit garden-style multifamily property for long-term hold as an investment. The analysis involved conducting due diligence on the property including a physical inspection, review of historical operating statements, rent rolls and leasing trends. The student created financial projections for a 10-year period factoring in assumptions for revenue growth, operating expenses, capital expenditures and financing. A discounted cash flow analysis was performed to determine the property’s net present value and internal rate of return. Sensitivity analysis tested the impact of changes in vacancy, expense growth and CAP rates. Peer property comparables were analyzed to test valuation. The analysis considered the optimal holding and exit strategy. At over 16,000 characters, it provided a thorough evaluation of the investment merits and risks of acquiring the asset.

Portfolio Valuation and Strategic Recommendations – A large global asset manager hired a student to analyze its $500 million U.S. apartment portfolio. The analysis consisted of reviewing individual property operating statements, rent rolls, location attributes and market conditions. Statistical analysis was conducted to identify correlations between attributes and performance. Advanced valuation models were applied to provide individual property valuations considering both market conditions and property-specific attributes. Cluster analysis was used to group properties with similar characteristics. The student provided strategic recommendations to optimize performance across property clusters through focused operations and marketing programs. Divestment candidates were identified. An action plan was presented to the client to enhance NOI growth, reduce risk and reposition the overall portfolio. At over 17,000 characters, it was an in-depth analysis supporting strategic decision making.

Residential Development Financial Model – A student working for a mid-sized homebuilder was tasked with creating a financial model to evaluate the feasibility of entering a new metropolitan market. Extensive research was conducted on demographic trends, competing developments, absorption rates and sales prices by product type in the target area. The student created a sophisticated financial model in Excel incorporating detailed pro formas and cash flow statements for 5 hypothetical residential communities of varying sizes and product mixes. Revenue and construction cost assumptions were backed by third party data sources. Sensitivity analysis tested the impact of changes in key drivers. Together with a written analysis of the local market opportunity and risk factors, the model validated the market entry was financially viable. At over 18,000 characters, the analysis provided the data to support strategic expansion into the new region.

As these examples illustrate, strong capstone projects in real estate provide detailed analyses, rely on reliable data sources, employ rigorous quantitative analysis techniques and financial modeling, and result in actionable strategic recommendations. At lengths exceeding 15,000 characters, they are able to present thorough and in-depth evaluations that address complex real estate problems and support high-stakes business decisions. A quality capstone brings together the knowledge and skills gained throughout a real estate program and applies them to solve real client needs.