Giter Club home page Giter Club logo

applied-computing-series's Introduction

Applied Computing 1 (AC1): Introduction to Google Sheets and SQL

What is AC1?

The primary goal of AC1 is to teach students data literacy: the ability to access, transform, use, and interpret data, ethically and effectively, to inform decision-making. This is a practical, hands-on course that will teach students to ask and answer questions about data through spreadsheets, SQL databases, and data visualization tools. The skills and problem solving mindset they learn will be highly applicable to any major or career.

This is an interdisciplinary course combining concepts from data science, computer science, and statistics. It is not a comprehensive introductory course in any of those fields. AC1 prepares students for more comprehensive courses on Python programming and data science in Python. Students who do not take more courses on the subject will still have a useful understanding of widely-used data science tools and techniques, which they can continue to use and build upon.

Learning Objectives

Daily learning objectives follow seven overarching themes in achieving data literacy.

  1. Data Transformation (DT): Understanding and proper usage of basic relational algebra operators (e.g. filter, aggregation, join).

  2. Ethics and Fairness (E): Identifying ethical considerations in the collection, analysis, and presentation of data (e.g. privacy, fairness, disclosure).

  3. Modeling (M): Intuitive understanding of statistical models and variance; practical ability to use core modeling techniques (e.g. linear and logistic regression).

  4. Problem Solving (PS): Solving large problems by breaking them into smaller pieces, anticipating results, and troubleshooting when results are not expected.

  5. Programming Readiness (PR): Ability to write and fix problems in formal language syntax; understanding of fundamental programming constructs (e.g. conditionals, functions).

  6. Storytelling (S): Posing research questions, using the correct data analysis, interpreting the results, and presenting the conclusions.

  7. Visualization (V): Choosing, creating, interpreting, and critiquing data visualizations.

Students will see these learning objectives in their textbook. To further help them make and retain connections across different units, you should make an effort to connect course concepts to these overarching themes whenever possible.

applied-computing-series's People

Contributors

bnmnetp avatar celinepark avatar kaitlyn-zeichick avatar lindseyc avatar mitch-mck avatar raskutti avatar runestonetest avatar tmadruga avatar ybirhane avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar

applied-computing-series's Issues

Issue #80 Address link sharing in documents to be public

All spreadsheets linked (seems to only be the Module A data from what I saw that is linked explicitly in the textbook) including ones not linked directly from the textbook and are only used in example visuals have been uploaded to the ac clinic gmail drive and have are set to be able to be viewed by anyone with the link. @raskutti

  • I also made a couple fixes to 1 section because the images weren't showing due to the wrong path

A more catchy title?

It would be nice to have a little more interesting title for this when we go live.

Any objections? Ideas?

Fix Permissions on sample spreadsheets

We gotta find a way to make the sheets available for editing to non-googlers.

I know you can't just make them public so we'll need to add them on a non-google account and link to them there.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.