13,579 research outputs found

    C3: Zero-shot Text-to-SQL with ChatGPT

    Full text link
    This paper proposes a ChatGPT-based zero-shot Text-to-SQL method, dubbed C3, which achieves 82.3\% in terms of execution accuracy on the holdout test set of Spider and becomes the state-of-the-art zero-shot Text-to-SQL method on the Spider Challenge. C3 consists of three key components: Clear Prompting (CP), Calibration with Hints (CH), and Consistent Output (CO), which are corresponding to the model input, model bias and model output respectively. It provides a systematic treatment for zero-shot Text-to-SQL. Extensive experiments have been conducted to verify the effectiveness and efficiency of our proposed method

    Irish Ocean Climate and Ecosystem Status Report

    Get PDF
    Summary report for Irish Ocean Climate & Ecosystem Status Report also published here. This Irish Ocean Climate & Ecosystem Status Summary for Policymakers brings together the latest evidence of ocean change in Irish waters. The report is intended to summarise the current trends in atmospheric patterns, ocean warming, sea level rise, ocean acidification, plankton and fish distributions and abundance, and seabird population trends. The report represents a collaboration between marine researchers within the Marine Institute and others based in Ireland’s higher education institutes and public bodies. It includes authors from Met Éireann, Maynooth University, the University of Galway, the Atlantic Technological University, National Parks and Wildlife, Birdwatch Ireland, Trinity College Dublin, University College Dublin, Inland Fisheries Ireland, The National Water Forum, the Environmental Protection Agency, and the Dundalk Institute of Technology.This report is intended to summarise the current trends in Ireland’s ocean climate. Use has been made of archived marine data held by a range of organisations to elucidate some of the key trends observed in phenomena such as atmospheric changes, ocean warming, sea level rise, acidification, plankton and fish distributions and abundance, and seabirds. The report aims to summarise the key findings and recommendations in each of these areas as a guide to climate adaptation policy and for the public. It builds on the previous Ocean Climate & Ecosystem Status Report published in 2010. The report examines the recently published literature in each of the topic areas and combines this in many cases with analysis of new data sets including long-term time series to identify trends in essential ocean variables in Irish waters. In some cases, model projections of the likely future state of the atmosphere and ocean are presented under different climate emission scenarios.Marine Institut

    A fuzzy set theory-based fast fault diagnosis approach for rotators of induction motors

    Get PDF
    Induction motors have been widely used in industry, agriculture, transportation, national defense engineering, etc. Defects of the motors will not only cause the abnormal operation of production equipment but also cause the motor to run in a state of low energy efficiency before evolving into a fault shutdown. The former may lead to the suspension of the production process, while the latter may lead to additional energy loss. This paper studies a fuzzy rule-based expert system for this purpose and focuses on the analysis of many knowledge representation methods and reasoning techniques. The rotator fault of induction motors is analyzed and diagnosed by using this knowledge, and the diagnosis result is displayed. The simulation model can effectively simulate the broken rotator fault by changing the resistance value of the equivalent rotor winding. And the influence of the broken rotor bar fault on the motors is described, which provides a basis for the fault characteristics analysis. The simulation results show that the proposed method can realize fast fault diagnosis for rotators of induction motors

    ChatGPT -- a Blessing or a Curse for Undergraduate Computer Science Students and Instructors?

    Full text link
    ChatGPT is an AI language model developed by OpenAI that can understand and generate human-like text. It can be used for a variety of use cases such as language generation, question answering, text summarization, chatbot development, language translation, sentiment analysis, content creation, personalization, text completion, and storytelling. While ChatGPT has garnered significant positive attention, it has also generated a sense of apprehension and uncertainty in academic circles. There is concern that students may leverage ChatGPT to complete take-home assignments and exams and obtain favorable grades without genuinely acquiring knowledge. This paper adopts a quantitative approach to demonstrate ChatGPT's high degree of unreliability in answering a diverse range of questions pertaining to topics in undergraduate computer science. Our analysis shows that students may risk self-sabotage by blindly depending on ChatGPT to complete assignments and exams. We build upon this analysis to provide constructive recommendations to both students and instructors.Comment: This is a work in progres

    Endogenous measures for contextualising large-scale social phenomena: a corpus-based method for mediated public discourse

    Get PDF
    This work presents an interdisciplinary methodology for developing endogenous measures of group membership through analysis of pervasive linguistic patterns in public discourse. Focusing on political discourse, this work critiques the conventional approach to the study of political participation, which is premised on decontextualised, exogenous measures to characterise groups. Considering the theoretical and empirical weaknesses of decontextualised approaches to large-scale social phenomena, this work suggests that contextualisation using endogenous measures might provide a complementary perspective to mitigate such weaknesses. This work develops a sociomaterial perspective on political participation in mediated discourse as affiliatory action performed through language. While the affiliatory function of language is often performed consciously (such as statements of identity), this work is concerned with unconscious features (such as patterns in lexis and grammar). This work argues that pervasive patterns in such features that emerge through socialisation are resistant to change and manipulation, and thus might serve as endogenous measures of sociopolitical contexts, and thus of groups. In terms of method, the work takes a corpus-based approach to the analysis of data from the Twitter messaging service whereby patterns in users’ speech are examined statistically in order to trace potential community membership. The method is applied in the US state of Michigan during the second half of 2018—6 November having been the date of midterm (i.e. non-Presidential) elections in the United States. The corpus is assembled from the original posts of 5,889 users, who are nominally geolocalised to 417 municipalities. These users are clustered according to pervasive language features. Comparing the linguistic clusters according to the municipalities they represent finds that there are regular sociodemographic differentials across clusters. This is understood as an indication of social structure, suggesting that endogenous measures derived from pervasive patterns in language may indeed offer a complementary, contextualised perspective on large-scale social phenomena

    Building data marts to analyze university faculty activities using power BI

    Get PDF
    Evaluating the performance of university faculty is a hard task because of the diversity of the work performed. The authors assume that the founder of the university evaluates the effectiveness of the university according to performing the teaching staff. The aim of the study is to improve the monitoring of key performance indicators of the university teaching staff based on data management. The authors present an information system to support decision-making related to the teaching staff at Kemerovo State University. The authors of the paper describe creating such a system using Business Intelligence technologies step by step. The authors identified data sources, designed the structure of the data mart and built ETL-processes for its filling, implemented various analytical dashboards. Implementing the information system in the daily activities of the university allows responding promptly to changes in the key indicators, forecasting their further change, deciding on activation of efforts in the chosen direction or types of work

    Теоретико-методичні основи проєктування, адміністрування та використання хмаро орієнтованого середовища навчання майбутніх учителів інформатики (дисертація)

    Get PDF
    У дисертації подано теоретичне обґрунтування та нове розв’язання проблеми використання хмаро орієнтованого середовища навчання в процесі підготовки здобувачів другого та третього ступенів вищої освіти за спеціальністю «014.09 Середня освіта (Інформатика)». Досліджено зарубіжний і вітчизняний досвід застосування хмарних технологій у навчанні майбутніх учителів інформатики. У дисертації виконано моделювання хмаро орієнтованого середовища навчання майбутніх учителів інформатики, у результаті якого обґрунтовано концептуальну, дидактичну, сервісну моделі та модель адміністрування середовища. Визначено послідовність етапів розгортання складників хмаро орієнтованого середовища навчання учителів інформатики. Обґрунтовано необхідність розгортання в ЗВО хмарних платформ, що реалізують модель «інфраструктура як сервіс». Визначено структуру та особливості реалізації методики використання ХОСН для розвитку фахової компетентності майбутніх учителів інформатики, що здобувають освіту на першому та другому ступенях. Обґрунтовано використання на першому ступені вищої освіти складників хмаро орієнтованого середовища як засобів організації освітньої діяльності майбутніх учителів інформатики. Розроблено зміст і методику курсів базового освітньо-професійного рівня та вибіркового курсу «Основи хмарних технологій» як вибіркового складника освітніх програм. Наведено аналіз результатів педагогічного експерименту. Отримано дані, що свідчать про готовність здобувачів до застосування складників хмаро орієнтованого середовища та вивчення основ хмарних технологій. Підтверджено гіпотезу про ефективність методики використання хмаро орієнтованого середовища для розвитку складників фахової компетентності здобувачів

    2023-2024 Boise State University Undergraduate Catalog

    Get PDF
    This catalog is primarily for and directed at students. However, it serves many audiences, such as high school counselors, academic advisors, and the public. In this catalog you will find an overview of Boise State University and information on admission, registration, grades, tuition and fees, financial aid, housing, student services, and other important policies and procedures. However, most of this catalog is devoted to describing the various programs and courses offered at Boise State

    Teaching Case Study: Gender Data Trouble in a Student Information System

    Get PDF
    In 2022, StateU, a large public university in the United States, embarked on a project to collect and use personal pronouns in its information systems. The project lead and functional expert was StateU's Administrative Leader. As she prepared for the first project meeting, she reflected on lessons learned from a past project she led to expand the collection of student gender data to record legal sex, gender identity, and sexual orientation. That project involved navigating challenging decisions about user interface design, underlying databases, data privacy and security, and reporting, underpinned by the desire to best serve minoritized and vulnerable populations. She recalled that: "A society with more data about LGBTQ people is not automatically a society that is better for LGBTQ people". She wondered if collecting pronoun data was the right choice in the first place
    corecore