Calc VLOOKUP vs XLOOKUP: Choose the Right Lookup Formula
Compare exact matches, left-side lookups, missing-value handling, and version support so you can choose a reliable Calc formula.
Updated September 2026. The strongest degree for smart city planning is not necessarily the program with “smart city” in its title. A good outcome is more concrete: by graduation, you should be able to diagnose an urban problem, work with spatial and administrative data, evaluate infrastructure or mobility options, understand governance and equity constraints, and turn analysis into a plan that a city, consultancy, developer, or public agency could actually use.
That leads to three different kinds of programs. Urban analytics degrees are best if you want coding, GIS, simulation, machine learning, and data-driven decision support. Professional planning degrees are stronger when land use, community engagement, policy, economics, and implementation matter most. Urban engineering and infrastructure programs are the better fit when your work will center on transport systems, network infrastructure, spatial development, resilience, or large technical systems.
| University | Program | Best outcome | Format |
|---|---|---|---|
| Georgia Institute of Technology | MS in Urban Analytics | Urban data science, GIS, modeling, visualization, smart-city analytics | 1 year / 3 semesters |
| University College London | MSc Urban Spatial Science | Spatial data science, urban simulation, remote sensing, smart-city policy | 1 calendar year full-time |
| University of Pennsylvania | Master of City Planning, Smart Cities concentration | Professional planning plus data, spatial statistics, and urban applications | Professional planning master’s |
| MIT | Master in City Planning, including Urban Science / Mobility pathways | Planning practice plus access to advanced urban research | 2 years |
| ETH Zurich | MSc Spatial Development and Infrastructure Systems | Transport, network infrastructure, spatial development, urban systems engineering | 120 ECTS / 2 years |
| National University of Singapore | Master of Urban Planning | High-density Asian urbanism, data-informed planning, integrated physical planning | 2 years full-time |
| KTH Royal Institute of Technology | MSc Sustainable Urban Planning and Design | Sustainability, planning/design studios, resilience, transport, urban transformation | 120 ECTS / 2 years |
| Columbia University | MS Urban Planning | Professional planning with urban analytics, studio, and capstone/thesis | 2 years |
| UC Berkeley | Master of City Planning; optional MCP/MS Civil & Environmental Engineering route | Planning with strong transportation, environment, data, or engineering integration | 2-year MCP; concurrent options available |
This is not a universal ranking. It is a practical shortlist based on current official program structures. The right choice depends on what you need to be able to produce after graduation.
“Smart city” can become vague very quickly. Sensors, dashboards, AI, digital twins, and connected infrastructure are useful only when they improve an actual urban outcome. When reviewing a curriculum, look for evidence that the program develops five capabilities together.
A graduate should be able to distinguish between a data problem and a planning problem. Traffic congestion, housing access, flood risk, public-space quality, energy demand, and unequal access to services rarely have purely technical causes. A strong program teaches institutional context, economics, policy, stakeholder interests, and distributional effects alongside technical tools.
Good sign: studio or capstone assignments start with a real client or a real urban problem rather than a prescribed technology.
At minimum, a modern smart-city curriculum should expose students to GIS, spatial analysis, statistics, and reproducible data workflows. More technical programs may add Python, R, SQL, remote sensing, machine learning, simulation, or high-performance computing.
Good sign: graduates leave with reproducible projects, maps, models, dashboards, or code—not only essays about technology.
Transport, water, energy, communications, public space, housing, and land use interact. A new transit line can change land values; a flood-control project can change development patterns; an EV policy can shift electricity demand. The stronger programs teach students to reason across systems instead of optimizing one subsystem in isolation.
A technically correct model is not yet a plan. Graduates should understand budgeting, regulation, governance, procurement, public participation, political constraints, and the difference between a promising pilot and a scalable urban intervention.
Smart-city projects should be measured by outcomes such as travel time, access, emissions, service reliability, housing affordability, public-space use, heat exposure, safety, resilience, or equity—not simply by the number of sensors installed.
A strong degree outcome: you can define a baseline, choose meaningful indicators, model alternatives, communicate uncertainty, recommend an intervention, and explain how its performance should be evaluated after deployment.
Georgia Tech’s Master of Science in Urban Analytics is one of the most direct smart-city degrees in this list. It is administered by the School of City and Regional Planning in partnership with Industrial and Systems Engineering, Computational Science and Engineering, and Interactive Computing.
The one-year, three-semester curriculum is organized around four modules: Urban Systems, Spatial Analysis, Computational Statistics, and Modeling and Visualization. Required urban-systems courses include Introduction to Urban Analytics and Design of Smart Urban Systems. Students also select from advanced GIS, transport GIS, computational data analysis, visualization, simulation, and related technical coursework.
The six-credit summer capstone matters because it forces technical skills into an applied urban problem. Options include an individual professional project, an international studio, or an employer-based urban data science project.
Choose Georgia Tech if: you want to become an urban data scientist, geospatial analyst, smart-city analyst, mobility analyst, or technical consultant and you are comfortable with quantitative work.
Quality check: by graduation, you should be able to show a portfolio containing code, reproducible analysis, geospatial workflows, visualization, and a substantial applied project. If your desired career is primarily land-use planning, community planning, or public participation, a professional planning degree may be a better fit.
UCL’s Urban Spatial Science MSc is a one-calendar-year full-time degree in the Bartlett Centre for Advanced Spatial Analysis.
The program combines urban systems theory with GIS, quantitative methods, spatial data science, remote sensing, simulation, data visualization, and machine learning. The current 2026/27 structure includes a Smart Cities and Urban Policy pathway with modules such as Smart Cities: Context, Policy and Government, Urban Simulation, and Remotely Sensing Cities and Environments.
UCL also lists practical use of R, Python, SQL, Google Earth Engine, Git/GitHub, and container tools as part of the broader technical skill set. Importantly, the program does not treat technology as automatically beneficial: it explicitly emphasizes the limits of technology-driven “solutionism.”
Choose UCL if: you want technical urban analytics but also want to examine governance, bias, uncertainty, and policy consequences.
Quality check: look for a final dissertation or applied project that shows you can connect computational methods to an urban question. If you want a professionally accredited planning route with extensive land-use law, public participation, or studio practice, compare UCL with Penn, Columbia, Berkeley, MIT, or NUS before deciding.
Penn’s Master of City Planning is notable because “Smart Cities” is an explicit concentration rather than a loose collection of electives.
The current concentration requires Introduction to Smart Cities and Spatial Statistics & Data Analysis, with Public Policy Analytics depending on GIS background. Elective options include Java Programming for Planning and Urban Management, Geospatial Data Science in Python, and Land Use & Environmental Modeling.
This creates a useful balance: students remain grounded in professional planning while developing data and modeling skills that can support planning applications and decision tools.
Choose Penn if: you want to work as a planner who is technically strong, rather than as a data scientist who happens to work on cities.
Quality check: make sure your course plan includes enough technical electives for the jobs you want. The concentration is only part of the broader planning degree, so its quantitative depth depends partly on how you use your elective space.
MIT’s Master in City Planning is a two-year professional planning degree. The current program includes specialization options such as Urban Science and Mobility, along with city design, environmental policy, housing/community development, and international development.
The core includes spatial analysis, quantitative reasoning, qualitative methods, economics, a client-based practicum, and a thesis. That professional structure can be combined with MIT’s broader research environment.
For smart-city technology specifically, the MIT Senseable City Lab studies how digital information, sensing, AI, mobility data, and new technologies change how cities can be understood and designed. Current 2026 work includes computer-vision-based emissions analysis, personal urban sensing, shade and pedestrian comfort, and other data-driven urban research.
Choose MIT if: you want a full professional planning education but also want access to frontier urban technology research.
Quality check: do not assume admission to the MCP automatically means working in a specific research lab. Evaluate faculty fit, research access, and relevant course availability separately.
ETH Zurich’s MSc in Spatial Development and Infrastructure Systems is one of the strongest options here for students who mean “urban engineering” literally.
The English-language program is 120 ECTS over two years and offers three specializations: Spatial and Landscape Development, Transport Systems and Behaviour, and Network Infrastructure. ETH describes the program as preparing students to solve spatial and traffic planning issues while developing sustainable infrastructure and socially responsible spatial solutions.
Choose ETH if: you want to work on transport systems, infrastructure management, network planning, or spatial development and you want more engineering depth than a typical planning degree.
Quality check: the best portfolio outcome is not just a policy proposal. It should demonstrate systems analysis, infrastructure or mobility reasoning, and the ability to compare alternatives under technical and spatial constraints.
Important limitation: although compulsory courses are taught in English, ETH notes that some specialization and elective courses—especially those tied closely to Swiss planning practice—may be offered in German. Check the course catalogue before assuming every desired elective is available in English.
The NUS Master of Urban Planning uses Singapore and Asian cities as a major planning context. The program explicitly discusses high-density living, ecological sensitivity, data science, social policy, public engagement, data analytics, and place-making.
The current curriculum requires 80 units and is designed for two years of full-time study. Four core studio courses occupy a central role, complemented by non-studio core courses and electives. NUS describes urban data science, research methods, urban economics, history, and theory as part of the core knowledge base.
Choose NUS if: you want to study rapid urbanization, high-density development, integrated infrastructure and land-use planning, or the governance of Asian metropolitan regions.
Quality check: a strong outcome should combine physical planning with data and policy rather than copying Singapore-specific solutions into a different institutional context. The transferable skill is learning how to integrate multiple systems and agencies, not assuming one city model works everywhere.
KTH’s MSc Sustainable Urban Planning and Design is a two-year, 120-ECTS English-language program with three broad profiles: Urban Planning and Design, Urban and Regional Planning, and Environment and Planning.
The program emphasizes studios, projects, urban theory, urban economics, sustainability, transport, public space, resilience, social equity, and stakeholder participation. KTH describes Stockholm and the surrounding region as a living-lab context for analysis and experimentation.
Choose KTH if: your definition of a smart city is a city that is sustainable, resilient, equitable, and well designed—not simply a city with more sensors and software.
Quality check: look for work that integrates spatial design, environmental performance, governance, and implementation. If you want heavy programming, machine learning, or urban data engineering, Georgia Tech or UCL will usually provide a more direct technical curriculum.
Columbia GSAPP’s MS in Urban Planning is a two-year accredited professional degree. Its curriculum combines urban analytics with grounded field research, community engagement, and attention to social, racial, and climate justice.
The current program includes a first-year team-based studio with a real client and a second-year thesis or professional capstone. Its curriculum clusters include Urban Analytics, while electives cover data analytics, machine learning, urban mobility, climate adaptation, and related topics.
Choose Columbia if: you want to use analytics inside professional planning practice and you want technical work to remain connected to community, governance, and equity.
Quality check: your final work should show both analytical rigor and stakeholder relevance. If the output could have been produced without understanding the affected community or institution, it is probably not yet strong planning.
UC Berkeley’s Master of City Planning is a two-year, in-residence, STEM-designated professional degree. Students complete a core curriculum, at least one concentration, a studio for an external client, and a capstone project or thesis.
The program allows students to deepen methodological skills in GIS, data science, design, and qualitative or participatory methods. Concentrations include Transportation Policy and Planning, Environmental Planning and Healthy Cities, Urban Design, and Housing/Community/Economic Development.
For students who need a stronger engineering combination, Berkeley also offers an official MCP / MS in Civil and Environmental Engineering concurrent route.
Choose Berkeley if: you want professional planning but also want the flexibility to move toward transportation, environmental systems, geospatial methods, or formal civil engineering.
Quality check: plan the technical side intentionally. A flexible degree can be excellent, but flexibility only produces depth if your electives, studio, research, and capstone point toward the same capability.
| Question | Strong signal | Warning sign |
|---|---|---|
| Will I learn to analyze urban data? | Required GIS/statistics plus coding, modeling, remote sensing, or visualization where relevant | “Data-driven” appears in marketing but not in the course list |
| Will I solve real problems? | Client studio, capstone, internship, field project, or applied dissertation | Most assessment is detached from real planning constraints |
| Will I understand implementation? | Governance, policy, economics, law, finance, stakeholder engagement | Technology is treated as the solution rather than one component of a planning process |
| Will I understand infrastructure? | Transport, utilities, networks, land use, resilience, or civil systems appear in the curriculum | “Smart city” is limited to apps, dashboards, and IoT |
| Will I leave with evidence of competence? | Portfolio, studio report, code repository, model, thesis, or capstone with a clear problem and evaluation | No substantial final project that integrates multiple skills |
A high-quality outcome is visible. By graduation, you should be able to show at least two or three substantial projects that demonstrate different parts of the planning process. A strong portfolio might include:
If your portfolio contains polished graphics but no defensible assumptions, no comparison of alternatives, and no explanation of who benefits or bears the cost, the smart-city label has not translated into professional planning quality.
If you want to spend most of your time building spatial pipelines, simulation models, machine-learning systems, digital twins, or decision-support software, a technical program such as Georgia Tech MS Urban Analytics or UCL Urban Spatial Science may produce a stronger outcome than a general planning degree.
If you want to work in municipal planning, land use, community development, planning consultancy, or public policy, do not let a one-year data degree substitute for planning fundamentals you actually need. Penn, MIT, Columbia, Berkeley, NUS, and KTH devote more of the curriculum to planning institutions, studios, design, governance, or implementation.
If you are primarily interested in transport networks, utilities, infrastructure asset systems, civil works, or technical resilience, ETH Zurich—or a combined route such as Berkeley’s MCP/MS in Civil and Environmental Engineering—may be more appropriate than a data-centric smart-city program.
No single degree covers every urban system at professional depth. A city needs planners, civil and environmental engineers, transportation specialists, architects, geospatial scientists, data engineers, economists, public administrators, cybersecurity specialists, and community organizations. A master’s program should help you collaborate across those disciplines; it cannot replace all of them.
Also remember that planning practice is jurisdiction-specific. Land-use law, professional accreditation, licensing, public procurement, and planning institutions differ by country. A technically excellent international degree may not automatically satisfy local professional requirements where you intend to work.
Finally, city data have limits. Sensors can fail, administrative data can exclude vulnerable groups, predictive models can reproduce past inequities, and “optimization” can hide political tradeoffs. A strong program teaches you to question the data and the objective function, not only improve the algorithm.
If your priority is data-intensive smart-city work, Georgia Tech and UCL are the clearest technical choices in this shortlist. If you want professional planning with smart-city or urban-analytics depth, Penn, MIT, Columbia, and Berkeley offer stronger planning foundations. If your goal is infrastructure, transport, and spatial systems engineering, ETH Zurich stands out. For sustainable planning and studio-based urban transformation, KTH is a strong fit. For high-density Asian planning and integrated urban development, NUS offers a distinctive real-world context.
The best result is not graduating with “smart city” on your transcript. It is graduating able to take a messy urban problem, determine what evidence is trustworthy, compare realistic alternatives, understand the engineering and institutional constraints, communicate the tradeoffs, and define how success will be measured after the plan is implemented.
Compare exact matches, left-side lookups, missing-value handling, and version support so you can choose a reliable Calc formula.
Learn how Writer page styles and Word section links affect cover pages, Roman numerals, and numbering restarts when you move a document.
You've just nailed a great product demo. The energy was right, you handled objections like a pro and you could see the lightbulb moment on your prospect's face. The Zoom call is over, you click “End Recording,” and you feel great.
Compare Pardus Software Center with APT commands to find, install, remove, and update packages using the method that fits your task.
See what Pardus’s published RAM requirements mean, then compare XFCE and GNOME on the same PC with repeatable MemAvailable readings.
See where HamoniKR 8.0 fits in a business desktop plan, what its Korean-focused features support, and what to verify before a wider rollout.
Understand how Gooroom’s boot verification and runtime protections fit together, what “sandbox” means, and which settings you should verify on your device.
Compare HamoniKR 8.0 LTS and Lite requirements, then test Wi-Fi, graphics, and laptop controls from a live USB before installing.
Compare the current SLES and RHEL baselines, understand why kernel numbers do not predict speed, and build a fair test around your real server workload.
Compare Ubuntu Server 24.04 minimized and standard installs across RAM, disk space, boot time, CPU, and real workloads—without misleading benchmark claims.