Author Archives: Evelina Rosser

HOW CAN STUDENTS CHOOSE A CAPSTONE PROJECT THAT ALIGNS WITH THEIR CAREER GOALS

Leave a reply

Choosing a capstone project that aligns well with a student’s career goals and aspirations is essential to getting the most value out of the capstone experience. Here are some key steps students can take to identify a project topic that will further their professional development.

First, students should take time to carefully evaluate and clearly define their own career interests and objectives. This process of self-reflection is important to help narrow down what types of projects and content areas would be most relevant. Students should consider what career paths specifically appeal to them, what industries or fields capture their passions, and what job functions or responsibilities align most closely with their skills and interests. Researching actual job descriptions, company websites, and professional profiles can provide good insight into different work environments and day-to-day activities.

Once students have a solid understanding of the career paths they are aiming for, they then need to explore potential capstone project ideas that have a clear connection or application to those goals. Brainstorming different options that could explore relevant topics, develop applicable skills, showcase achievements, or test concepts/products/solutions is key. Looking to coursework, internships, research experiences, extracurricular activities, or ideas from professionals for inspiration can spark project topics related to a student’s field of interest. Considering real-world problems, organizational needs, or business opportunities can also generate ideas with career applicability.

In mapping out different potential project options, students should evaluate each on dimensions like career relevance, feasibility, interest level, differentiation, and likelihood of successful completion within their program’s requirements. Projects too broad or generic may be less impactful than those finely attuned to career objectives. Opportunities to work with an external sponsor, client, or industry mentors are excellent for hands-on experience and resume credibility. Students may need to refine their project scope to the appropriate level.

Students are also wise to ensure their proposed capstone projects are achievable within their own skill set and with available resources/supports. Choosing a level-appropriate challenge allows students to both showcase capabilities and gain confidence without biting off more than they can chew. Backup options in case initial project ideas fall through are prudent to consider as well.

When selecting a final capstone project topic, close consultation with academic advisors and career counselors is very important. These experts can evaluate how well a student’s idea pairs with their career aspirations and provide honest feedback on feasibility, strengths/weaknesses, or new angles to explore. Advisors may help connect students with relevant professionals, resources, or sponsorships that bring more applied value to the project. Involving mentors establishes extra guidance and support crucial to navigating any unforeseen obstacles.

Throughout the capstone project completion, students should focus on executing work with their careers clearly in mind. Developing core skills like communication, problem-solving, collaboration, project management, technical proficiency, and work products/deliverables tailored to the objectives aids this linkage between education and future employment. Making strong professional networks, utilizing high-level research and critical thinking, and compiling multi-faceted results/documentation/presentations provides meaningful evidence of career readiness to future employers.

In reflection on the total capstone experience upon its conclusion, students should thoughtfully evaluate how their project helped foster career-relevant strengths, expand industry knowledge, spark new professional interests or opportunities, or serve as a foundation for future initiatives like graduate studies or new ventures. Capturing these takeaways in resumes, cover letters, interviews, and professional portfolios allows students to directly translate their capstone work into greater viability in the job market and related career explorations after college. With diligent planning and execution oriented around clear career aspirations, the capstone serves as a powerful way for students to advance their professional goals through authentic hands-on work.

HOW CAN I CREATE A PIVOTTABLE IN EXCEL FOR DATA ANALYSIS

Leave a reply

To create a pivot table in Excel, you first need to have your raw dataset organized in an Excel worksheet with headers in the first row identifying each column. The data should have consistent field names that you can use to categorize and group the data. Make sure any fields you want to analyze or filter on are in their own columns.

Once your dataset is organized, select any cell within the dataset. Go to the Insert tab at the top of the Excel window and click PivotTable. This will launch the Create PivotTable window. You can either select a New Worksheet option to place the pivot table on its own sheet or select an Existing Worksheet and select where you want to place the pivot table.

For this example, select New Worksheet and click OK. This will open a new sheet with your pivot table fields pane displayed on the right side. By default, it will add all the fields from your source data range to the Rows, Columns, Values areas at the top.

Now you can customize the pivot table by dragging and dropping fields between areas. For example, if your data was sales transactions and you wanted to analyze total sales by product category and year, you would drag the “Product Category” field to the Rows area and the “Year” field to the Columns area. Then drag the “Sales Amount” field to the Values area.

This will cross tabulate all the product categories as row headings across the column years showing the total sales amount for each category/year combination. The pivot table is dynamically linked to the source data, so any changes to the source will be automatically reflected in the pivot table.

You can rearrange and sort the fields in each area by clicking the dropdowns that appear when you hover over a field. For example, you may want to sort the row categories alphabetically. You can also add fields to multiple areas like Rows and Columns for a more complex analysis.

To filter the data in the pivot table, click anywhere inside the table body. Go to the PivotTable Tools Options tab that appears above and click the Filter drop down box below any field name in the report filter pane. Here you can select specific items to include or exclude from the analysis.

For example, you may want to only include sales from 2018-2020 by category to analyze recent trends. Pivoting and filtering allows you to quickly analyze your data from different perspectives without having to rewrite formulas or create additional tables.

You can also customize the pivot table’s layout, style, subtotals, and field settings using additional options on the Design and Layout tabs of the PivotTable Tools ribbon. Common additional features include sorting data in the table, conditional formatting, calculated fields/items, grouping dates, and pivot charts.

All of these actions allow you to extract more meaningful insights from your raw data in an interactive way. Once your pivot table is formatted how you want, you can refresh it by going to the Analyze tab and clicking Refresh anytime the source data is updated. Pivot tables are a very powerful tool for simplifying data analysis and discovery in Excel.

Some additional tips for effective pivot tables include:

Give the pivot table source data its own dedicated worksheet tab for easy reference later on.

Use clear, consistent field names that indicate what type of data each column contains.

Consider additional calculated fields for metrics like averages, percentages, and trends over time.

Filter to only show the most meaningful or relevant parts of the analysis at a time for better focus.

Add descriptive Report Filters to let users dynamically choose subsets of data interactively.

Combine multiple pivot tables on a dashboard worksheettab to compare analyses side by side.

Link pivot charts to visualizetrends and relationships not obvious from the table alone.

Save pivot table reports as their own snapshot files to share findings with stakeholders.

With well structured source data and thoughtful design of the pivot table layout, filters and fields, you can gain powerful insights from your organization’s information that would be very difficult to uncover otherwise. Pivot tables allow you to dramatically simplify analysis and reporting from your Excel data.

HOW DO GEOTHERMAL POWER PLANTS ACCESS THE UNDERGROUND HEAT RESERVOIRS

Leave a reply

Geothermal power plants tap into underground reservoirs of hot water or steam found deep below the Earth’s surface to generate electricity. These reservoirs are accessed through wells drilled into geothermal fields located in areas with high underground temperatures. There are two main types of geothermal fields – hydrothermal and hot dry rock.

Hydrothermal reservoirs contain naturally occurring hot water or steam trapped in porous rock or underground water reservoirs. To access this, geothermal plants drill production and injection wells into known hydrothermal fields. Production wells are drilled to depths ranging from 1-3 km and bring the hot water or steam to the surface. Injection wells are also drilled and are used to return cooled geothermal fluid back underground after it has passed through the power plant.

The location of these hydrothermal reservoirs is identified through extensive geological, geophysical, and geochemical exploration of areas with recent volcanic activity and/or nearby magma chambers. Areas like the Ring of Fire in the Pacific Ocean or volcanic zones in Iceland and Africa have many of the highest temperature hydrothermal fields accessible for geothermal power production. Once promising locations are identified, test wells are drilled to establish temperature gradients and find productive zones of permeability and fluid saturation in the bedrock.

After exploration identifies commercial quantities of recoverable geothermal resources, power plant development begins. Production wells capable of handling high temperatures are carefully drilled using drilling mud to prevent damage from heat. Well casings made of stainless steel, Inconel, or other corrosion resistant alloys are installed to line the wellbore and prevent collapse while withstanding high pressures and temperatures. Downhole instrumentation is also installed to monitor reservoir conditions and performance over the life of the plant.

Once drilling is complete, a pipeline network transports the geothermal fluid from the production wells to the power plant for utilization. Typical geothermal fluid reservoir temperatures can range from 150-350°C. Lower temperature hydrothermal resources between 90-150°C can also be used with binary cycle power plants utilizing an additional heat exchange process. Upon arrival at the plant, geothermal fluid is first passed through separators which separate steam, liquid, and other gases. The steam is then used to drive turbines which spin generators to produce electricity, just like in conventional steam plants.

After passing through the turbines, the lower pressure steam is condensed back into liquid form using cooling towers. The geothermal fluid now at a lower temperature is piped back underground through the injection wells to be reheated by the hot reservoir rock. Careful reservoir management is needed as injection returns some of the fluid but also cools the reservoir if not balanced by natural reinjection. Sustaining sufficient reservoir pressures and temperatures over the 25-30 year lifetime of the plant is important for continuous power generation.

With hot dry rock resources, the naturally fractured basement rock itself is the target reservoir without naturally occurring fluids. Special techniques are required to access this type of resource. Long injection and production wells extending 2-5 km deep are drilled parallel to each other into the hot basement rock. Then a procedure called hydraulic stimulation is used to fracture open the rock and connect the two wells by pumping water or other fluids down one well under high pressure. This creates an artificial reservoir where once established, water can be circulated and heated between the wells to temperatures of 150-300°C suitable for power production. These engineered reservoirs are still experimental and require further research to prove commercial viability compared to hydrothermal resources.

Geothermal power plants access vast subsurface heat reservoirs through carefully engineered well systems. Hydrothermal reservoirs containing naturally occurring hot fluids are the most developed resource and provide base load renewable power by tapping into underground zones of permeable rock saturated with hot water or steam. Future potential also lies in creating engineered reservoirs within hot basement rocks if techniques for artificially enhancing permeability and conductively heating injected fluids can be proven on a utility scale. Geothermal energy harnesses the Earth’s natural internal heat for power generation utilizing sustainable reservoirs that can last for decades.

HOW CAN STUDENTS ENSURE THAT THEIR CAPSTONE PROJECTS ALIGN WITH THE UN SUSTAINABLE DEVELOPMENT GOALS

Leave a reply

The UN Sustainable Development Goals, also known as the Global Goals, are a universal call to action to end poverty, protect the planet, and ensure that all people enjoy peace and prosperity. They were adopted by all UN member states in 2015 as part of the 2030 Agenda for Sustainable Development which set out a 15-year plan to achieve the 17 Goals.

As students developing their capstone projects, which often aim to solve real-world problems, it is important to consider how your project can support progress toward one or more of the Global Goals. Here are some key steps students can take to ensure their capstone project is aligned:

Learn about the 17 Sustainable Development Goals and understand what each goal is aiming to achieve by the 2030 deadline. You can find descriptions of all the goals on the UN website. Read through each goal area and its associated targets so you have a solid understanding of the scope and ambitions of the 2030 Agenda. Make notes on which goals relate most directly to the types of issues or problems you hope your capstone project will address.

Consult with your capstone advisor, career counselors, or faculty members involved in sustainability initiatives at your educational institution. They will likely have expertise in linking student projects to the SDGs and can help guide you toward goals and targets where your work would make the most meaningful contribution. Your advisors know the kinds of challenges local communities are facing and how student solutions could support SDG progress at regional and national levels.

Speak with potential community partners if collaborating directly with organizations, businesses, or public entities on your capstone project. Explain the Global Goals framework and ask which goals are priorities for the work they do. Aligning with a community partner’s existing SDG efforts or initiatives validates how your project outputs could create real impact. Partners may also be well-positioned to help scale and implement student solutions after graduation.

Review your preliminary capstone project idea and draft goals/objectives through an SDG lens. Ask yourself questions like: Which development challenges does this project aim to directly address? How could successful outcomes contribute to targets underGoals like no poverty, zero hunger, good health, quality education, clean water/sanitation, affordable/clean energy, decent work/economic growth, industry/infrastructure, reduced inequalities, sustainable cities/communities, responsible consumption, climate action, life below water, life on land or peace/justice/strong institutions? Be specific about linkages.

Incorporate SDG alignment into your research methodology. For example, conduct a needs assessment or stakeholder interviews that reference the Global Goals framework. This helps validate how your work supports international development priorities based on local input and expertise. Quantitative and qualitative data gathered should demonstrate clear linkages to the social, economic or environmental dimensionsof one or more SDG targets.

Discuss SDG relevance in your capstone proposal, progress updates and final presentation. Clearly state up front how your project outcomes could advance specific Global Goals and targets if successful. Revisit this alignment throughout the capstone timeline to strengthen the case for how your work is meaningful within the 2030 Agenda. In evaluations, assess both project outputs and SDG progress enabled to gauge impact.

Consider opportunities to scale your piloted solution in partnership with others to enable wider SDG impact after graduation, if warranted. For example, could aspects of your work inform public policy development or other stakeholder initiatives? Be strategic in planning continuity that allows student solutions to live on in sustainably advancing countries’ development priorities.

By following these steps, students can ensure their capstone projects are purposefully aligned with real-world needs expressed through the UN Sustainable Development Goals. This provides value and relevance for the projects, validates student work as a potential catalyst for positive change and sustainable development progress, and strengthens the case for how solutions from higher education can support global priorities to build a more just, prosperous and environmental-sound world for all. Thoughtful integration of the SDGs framework informs high-quality, impactful student work with tangible outcomes for people and the planet.

CAN YOU PROVIDE MORE DETAILS ON THE CONTROL ALGORITHMS USED IN THE PROPOSED SYSTEM

Leave a reply

The autonomous vehicle system would likely utilize a combination of machine learning and classical control algorithms to enable safe navigation and control of the vehicle without human input. At a high level, machine learning algorithms like neural networks would be used for perception, prediction, and planning tasks, while classical controls approaches would handle lower level actuation and motion control.

For perception, deep convolutional neural networks (CNNs) are well-suited for computer vision tasks like object detection, classification, and semantic segmentation using camera and LiDAR sensor data. CNNs can be trained on huge datasets of manually labeled sensor data to learn visual features and detect other vehicles, pedestrians, road markings, traffic signs, and other aspects of the driving environment. Similarly, recurrent neural networks (RNNs) like LSTMs are well-optimized for temporal sequence prediction using inputs like past vehicle trajectories, enabling the prediction of other road users’ future motions.

Higher level path planning and decision making tasks could leverage techniques like model predictive control (MPC) integrated with neural network policies. An MPC framework would optimize a cost function over a finite time horizon to generate trajectory, velocity, and control commands while satisfying constraints. The cost function could include terms for safety objectives like collision avoidance while also optimizing for ride quality. Constraints would ensure kinematic and dynamic feasibility of the planned motion. Additionally, imitation learning or reinforcement learning could train a neural network policy to map directly from perceptual inputs to motion plans by mimicking demonstrations from human drivers or via trial-and-error experience in a simulator.

Low level controller tasks would require precise, real-time control of acceleration, braking, and steering actuators. Proportional-integral-derivative (PID) controllers are well-suited for this application given their simplicity, robustness, and ability to systematically stabilize around a target trajectory or other reference signals. Separate PID controllers could actuate individual control surfaces like throttle, brake, and steering to regulate longitudinal speed tracking and lateral path following errors according to commands from higher level planners. Gains for each PID controller would need tuning to provide responsive yet stable control without overshoot or oscillation.

Additional control techniques like linear quadratic regulation (LQR) could also be applied for trajectory tracking tasks. LQR is an optimal control method that provides state feedback gains to optimize a linearized system about an equilibrium or nominal operating point. It can systematically achieve stable, high-performance regulation for both longitudinally and laterally by balancing control effort with tracking errors. LQR gains could also be scheduled as a function of vehicle velocity to achieve improved handling dynamics across different operating regimes.

Coordinated control of both lateral and longitudinal motion would require an integrated framework. Kinematic and dynamic vehicle models relating acceleration, velocity, steering angle, yaw rate, and lateral position could be linearized around an operating point. This generates a linear time-invariant system amenable to analysis using well-established multi-input multi-output (MIMO) control design techniques like linear matrix inequalities (LMIs). MIMO control achieves fully coupled, optimally coordinated actuation of all control surfaces for robust stability and handling qualities.

Fault tolerance, safety, and redundancy are also crucial considerations. Control systems should systematically identify sensor failures or abnormalities and gracefully degrade functionality. Architectures like control allocations could address actuator faults by redistributing commands across healthy effectors. Fail-safe actions like slow, steady stops should be triggered if critical hazards cannot be avoided. Control systems could operate on simple kinematic approximations as a fallback if more sophisticated dynamic models become unreliable.

An intelligent combination of machine learning, optimal control, classical control, and robust/fault-tolerant techniques offers a rigorous and trustworthy approach for autonomously navigating roadways without direct human intervention. Careful system integration and verification/validation efforts would then be required to safely deploy such capabilities on public roads around humans on a large scale.