There are two ways to consolidate data, either by position or category.Consolidation by position: The data in the source areas has the same order, and uses the same labels.In a context in which universities must be flexible, dynamic and highly adaptable, creating these units will allow us to streamline and simplify decision-making.Third, we have evaluated the research carried out by our departments using a pioneering method in Spain designed with the support of the Catalan University Quality Assurance Agency (AQU Catalunya).In this regard, we have designed two new three-year bachelor’s degree programmes targeted at international students (in global studies and bioinformatics).With these programmes, to be taught exclusively in English and launched in September, we hope to raise the international profile of our university system.To summarize and report results from separate worksheets, you can consolidate data from each sheet into a master worksheet.The sheets can be in the same workbook as the master worksheet, or in other workbooks.
We have also created a model of an urban university that is intimately linked to the city of Barcelona.
Pompeu Fabra University is celebrating its 25th anniversary this academic year, at a time when profound changes are happening in higher education around the world. The familiar, local arena in which we traditionally competed is now global, complex and constantly changing.
Spanish universities must compete for the same talent, funding and resources as the world’s top institutions, only with a much smaller budget.
Our ambitious projects reflect our efforts to differentiate our university: streamlining our organisation, evaluating our research and implementing an educational model based on personal attention are all plans intended to position us on the global stage as a university that both wants to and does do things differently.
Some may think that these initiatives will affect the very foundations of the university, and so it may be.