Question: 1

What kind of data structure is user_data in the following declaration?

user_data = ("TJ", 24, "artLover123")

Computer Systems Organization CSCI-UA.0201 Fall 2023

Programming Assignment 1

Due Tuesday, October 10 at 11:55pm

This assignment gives you practice working with pointers, trees, and dynamic allocation. The program will be to implement the “Animal Guessing Game”. This game is a version of “20 Questions” where the only category is animals. You think of an animal and your program will try to guess the animal by asking you a series of “yes or no” questions.

03-spreadsheet

Spreadsheet Analysis

A little assignment to practice finding data, munging it, and analyzing it in a spreadsheet program.

Replace the contents of this file with a report, as described in the instructions.

Instructions

A little assignment to practice finding data, munging it, and analyzing it in a spreadsheet program.

Problem 1

Q1

Q2

Q3

Create a list of your favorite 4 movies. Print out the 0th element in the list. Now set the 0th element to be “Star Wars” and try printing it out again.

创建你最喜欢的4部电影的列表。打印列表中的第0个元素。现在将第0个元素设置为“星球大战”，然后再试着打印它。

# 创建一个包含4部电影的列表
favorite_movies = ["Movie1", "Movie2", "Movie3", "Movie4"]

# 打印列表中的第0个元素
print(favorite_movies[0])

# 将第0个元素设置为“星球大战”
favorite_movies[0] = "星球大战"

# 再次打印列表中的第0个元素
print(favorite_movies[0])

5.10.1 Functions and Parameters Quiz

Question: 1

In the following code:「D」

size = 20
x = 100
y = 200
ball = Circle(size)
circle.set_position(x, y)

Quiz

Question 1

Write a function that takes one parameter - a float which represents a temperature in Celsius - and returns a float which represents that temperature in Fahrenheit.

Then, write a function that does the opposite conversion.

Here are the formulas for temperature conversion:

Quiz

Quiz 2

Which of the following are spreadsheet programs?「A、B、C、D」

A. Apple Numbers

B. Google Sheets

C. LibreOffice Calc

D. Microsoft Excel

E. Visual Studio Code
Which spreadsheet program would be best for a very large data set with a million records?「B」

A. Google Sheets

B. Microsoft Excel
Do spreadsheet applications generally allow users to write custom functions to analyze or modify the data in the spreadsheet?「A」

A. Yes

B. No
Data in a spreadsheet generally has a fixed schema.「B」

Raw Data Munging

概述

在这次作业中，你将尝试使用一个真实的数据源：NASA 的地球表面温度的历史测量数据。为了分析这些数据，一些预备工作是必要的。特别是，你将：

下载原始数据。
编写一个 Python 程序清洗（即处理）数据，并将其保存为标准的逗号分隔值（CSV）格式文本文件。
编写第二个 Python 程序对 CSV 文件中的数据进行一些简单的分析。

指导

第 0 部分：确定工作流

团队可以选择几种不同的工作流程。强烈建议实时合作，通常比异步合作更有效。但是，在实时合作不可能的情况下，有一些特定的工作流程可以帮助异步团队工作。

Course Intro - Database Design

Database Design

Submit

当代数据问题

在这个作业中，你将：

在相对较新的报纸或期刊中找到两篇关于特定数据库或与数据相关问题的不同观点的文章。
对每篇文章写至少两段的回应。

下面详细说明了你应该如何进行这项作业的其他要求。

如何设置你的电脑

在GitHub上查看此作业

这个作业是以一个在GitHub.com的仓库的形式给你的，该网站用于分享代码。仓库就是项目的一个高级别的名字。

Database Design & Implementation

Department of Computer Science

New York University

Schedule

Date	Class	Topics	Notes	Helpful resources	Quiz due	Exercise due
9/5	1	Welcome	Course intro	Syllabus
9/7	2	Python	- Discord for Education - Python	Videos: - Python crash course - Set up Visual Studio Code for Python programming Python for Everyone (py4e): - Variables - Conditionals - Functions - Iterations - Strings - Lists - Dictionaries - Tuples	Intake	- Complete consent form - Join Discord - Create GitHub account
9/12	3	Plain text data formats	Plain text data formats	- Video: Plain-text data formats - py4e: - Files - Text files code examples	Python	- Set up Python - Contemporary issues exercise
9/14	4	Data munging	- Text files in Python - Example Python code	Accessing O’Reilly Safari e-books Big Data Handbook (bdh): - Does This Data Smell Funny? - Data Lurking in Plain Sight	Text files
9/19	5	Workshop - raw data munging	Workshop - raw data munging		Data munging
9/21	6	Spreadsheets	Spreadsheets
9/26	7	Workshop - spreadsheets	Workshop - spreadsheets	Vicky Rampin’s slides		Workshop - raw data munging
9/28	8	SQL CRUD	SQLite intro	Using SQLite: - What is SQLite? - Uses of SQLite - Building and Installing SQLite (only Precompiled Distributions and An sqlite3 Primer) - The SQL Language - The SELECT Command	Spreadsheets
10/3	9	SQL joins	- SQL joins - SQL inner joins - SQL left, right, and reflexive joins	SQL joins example code	SQL CRUD	Workshop - spreadsheets
10/5	10	Workshop - SQL	Workshop - SQL		SQL joins
10/10	n/a	no class (Legislative Day)
10/12	11	Normalization	Normalization	- A Simple Guide to Five Normal Forms in Relational Database Theory - Database Design, Chapter 12
10/17	12	Entity-relationship diagrams	Entity-Relationship Diagrams	Relational Database Design and Implementation: - Chapter 3 - Why Good Design Matters - Chapter 4 - Entities and Relationships - Chapter 5 - The Relational Data Model	Normalization	Workshop - SQL
10/19	n/a	no class (Prof. out)
10/24	13	Workshop - database design	Workshop - database design		Entity-Relationship Diagrams
10/26	14	Review	Exam 1 review	Exam Practice: - Quiz - GitHub Repository
10/31	15	Exam 1				Workshop - database design
11/2	16	MongoDB CRUD	- MongoDB setup - MongoDB CRUD	Video: MongoDB setup NYU CIMS documentation: - MongoDB Database Management on CIMS - Accessing MongoDB on CIMS MongoDB documentation: - MongoDB CRUD Operations - MongoDB db.collection.find()
11/7	17	MongoDB CRUD	MongoDB aggregation	MongoDB documentation: - MongoDB Data Model Design - MongoDB Data Model Examples and Patterns
11/9	18	Workshop - MongoDB	Workshop - MongoDB		MongoDB CRUD
11/14	19	Web apps	- The Web - Intro to HTML
11/16	20	Web apps	Pymongo & flask	Flask & pymongo documentation: - Flask Quickstart - Pymongo tutorial		Workshop - MongoDB
11/21	21	Workshop - web apps	Workshop - Web app		Web apps
11/23	n/a	no class (Thanksgiving)
11/28	22	Jupyter notebooks	Jupyter Notebooks
11/30	23	Pandas	- Pandas	- 10 minutes to Pandas - Example Jupyter notebooks
12/5	24	Data visualization				Workshop - web app
12/7	25	Workshop - pandas	Workshop - pandas		Pandas
12/12	26	Review	Exam 2 review			Workshop - pandas (No late work accepted beyond this date.)
12/14	n/a	no class (Prof out)
TBD	27	Exam 2

Assignment 10 Node.js

For our last macro assignment you will be building a custom Node.js website using the express framework. The actual content and design for this site are very flexible, so be creative! Your site should incorporate the following technical features:

对于我们的最后一项宏观任务，您将使用express框架构建一个自定义的Node.js网站。实际的内容和设计非常灵活，因此要有创意！您的网站应包含以下技术特性：

Assignment 09：Let's Chat

"messages.db" (database)

CREATE TABLE chats (id integer primary key autoincrement, nickname text, message text);



"index.html"

<!DOCTYPE html>
<html>
    <head>
        <title>Let's Chat!</title>
        <style>
            #previous_messages {
                width: 100%;
                height: 300px;
                resize: none;
            }
            .hidden {
                display: none;
            }
        </style>
        <script src="helpers.js"></script>
    </head>
    <body>
        <h1>Let's Chat!</h1>

        <div id="panel_nickname">
            <input type="text" id="nickname">
            <button id="button_savenickname">Save Nickname & Chat</button>
        </div>

        <div id="panel_chat" class="hidden">
            <textarea id="previous_messages" readonly></textarea>
            <input type="text" id="message">
            <button id="button_sendmessage">Send Message</button>
        </div>

        <script>
            // global variables
            let userNickname;

            // figure out when the user saves their nickname
            document.querySelector('#button_savenickname').onclick = function(e) {

                // store the nickname for future use
                userNickname = document.querySelector('#nickname').value;

                // hide the nickname panel
                document.querySelector('#panel_nickname').classList.add('hidden');

                // show the chat panel
                document.querySelector('#panel_chat').classList.remove('hidden');
            }

            // when the user types in a new chat message
            document.querySelector('#button_sendmessage').onclick = function(e) {

                // contact the server with our message AND our nickname
                performFetch({
                    url: 'api.php?command=save',
                    method: 'post',
                    data: {
                        nickname: userNickname,
                        message: document.querySelector('#message').value
                    },
                    success: function(data) {
                        console.log("SUCCESS");
                        console.log(data);
                        if (data != "MISSINGDATA") {
                            document.querySelector('#previous_messages').value += data + "\n";
                        }
                    },
                    error: function(error) {
                        console.log("ERROR");
                    }
                })

            }

            function getAllMessages() {

                performFetch({
                    url: 'api.php',
                    method: 'get',
                    data: {
                        command: 'get_all_messages'
                    },
                    success: function(data) {
                        console.log(data);



                        // take what the server gave us and turn it into a JS object
                        data = JSON.parse( data );

                        console.log(data);

                        document.querySelector('#previous_messages').value = '';

                        for (let i = 0; i < data.length; i++) {
                            document.querySelector('#previous_messages').value += data[i] + "\n";
                        }
                    },
                    error: function(error) {
                        console.log(error);
                    }
                })
            }

            setInterval(
                getAllMessages,
                3000
            );


        </script>

    </body>

</html>




"helpers.js"

function performFetch(args) {
    /* args is an object that is formatted as follows:

        {
            // the URL to contact on the server
            url: url_to_contact

            // request method ('get' or 'post')
            method: 'get',

            // object of variables to send to the server
            data: {
                var1: value1,
                var2: value2,
                var3: value3 // ... etc
            },

            // function to run if request succeeds, should accept a single argument which is the data returned by the server
            success: function(data), 

            // function to run if request fails, should accept a single argument which is the error message
            error: function(error) 
        }
        
    */

    // GET requests
    if (args.method && args.method.toLowerCase() == 'get') {

        // package up the data to send to the server
        const params = new URLSearchParams();
        for (const varName in args.data) {
            params.append(varName, args.data[varName]);
        }

        // append variables to URL
        args.url += '?' + params.toString();

        // perform the fetch request
        fetch(args.url)
            .then(function(response) {
                if (response.ok) {
                    return response.text();
                }
                else {
                    let error = new Error("server error");
                    throw error;
                }
            })
            
            // call the provided success callback function
            .then(function(text) {
                args.success(text);
            })
            
            // call the provided error callback function
            .catch(function(error) {
                args.error(error);
            });

    } // end GET request

    // POST requests
    else if (args.method && args.method.toLowerCase() == 'post') {

        // package up the data to send to the server
        // note that this is designed specifically to contact a PHP script
        // we will use a slightly different approach when we contact
        // node.js scripts in the next unit
        const formData = new FormData();
        for (const key in args.data) {
            if (args.data.hasOwnProperty(key)) {
                formData.append(key, args.data[key]);
            }
        }

        // perform the fetch request
        fetch(args.url, {
            method: "POST",
            body: formData,
        })
        .then(function(response) {
            if (response.ok) {
                return response.text();
            }
            else {
                let error = new Error("server error");
                throw error;
            }
        })
        
        // call the provided success callback function        
        .then(function(text) {
            args.success(text);
        })
        
        // call the provided error callback function        
        .catch(function(error) {
            args.error(error);
        });

    } // end POST request

}






"api.php"

<?php

    // get command
    $command = $_GET['command'];


    // command: save
    // inputs:  a nickname and a message
    // outputs: a copy of the message, or 'error'
    if ($command == 'save') {

        $nickname = $_POST['nickname'];
        $message  = $_POST['message'];

        // basic validation
        if ($nickname && $message) {
            // save this message into our database
            $db = new SQLite3(  getcwd() . '/database/messages.db'  );
            $sql = "INSERT INTO messages (nickname, message) VALUES (:nick, :msg)";
            $statement = $db->prepare($sql);
            $statement->bindParam(':nick', $nickname);
            $statement->bindParam(':msg', $message);
            $statement->execute();

            print $nickname . ": " . $message;
        }

        else {
            print "MISSINGDATA";
        }

        $db->close();
        unset($db);

    }
    
    // command: get_all_messages
    // inputs:  none
    // output:  all previous messages, formatted as a JSON array
    if ($command == 'get_all_messages') {
        $db = new SQLite3(  getcwd() . '/database/messages.db'  );
        $sql = "SELECT nickname, message FROM messages";
        $statement = $db->prepare($sql);
        $result = $statement->execute();

        $return_array = array();
        while ($temp_array = $result->fetchArray()) {


            array_push( $return_array, $temp_array['nickname'] . ": " . $temp_array['message']);

        }

        $db->close();
        unset($db);

        print json_encode($return_array);
       
    }


?>

Assignment 08 Interactive Database

In class code (ZIP)

Note: The majority of this assignment uses only HTML, CSS and PHP - very little (if any) JavaScript is necessary to solve this problem. I've outlined the technologies needed for each feature below.

Micro Assignment 08

Micro assignment 06 focuses on the following concepts:

JavaScript Promises
The "fetch" API for making asynchronous network calls in client-side JavaScript to the server

This micro assignment contains a series of videos along with a programming challenge, which you should attempt after watching the videos. The challenge is set up with a "Mark" button that will let you immediately see if you solved it correctly. You will get credit for the micro assignment by attempting and solving this challenge, and you are allowed to attempt the challenge as many times as you'd like.

Micro Assignment 07

Micro assignment 06 focuses on the following concepts:

微任务06主要关注以下概念：

PHP File I/O「PHP 文件输入输出」
Cookies vs. LocalStorage「Cookies 与 LocalStorage 的比较」
Using cookies with PHP「使用 PHP 操作 Cookies」

Assignment 07 Server-side Quizzing System

"quiz.php"

"save.php"

"results.php"

Assignment 06 Matching Game

Code written in class

<!DOCTYPE html>
<html>
    <head>
        <title>Memory Matching Madness</title>
        <style>
            body {
                background-color: black;
                color: white;
                text-align: center;
            }
            .hidden {
                display: none;
            }
            #tile_container {
                width: 400px;
                margin: auto;
            }
            #tile_container img {
                width: 100px;
            }
        </style>
    </head>
    <body>
        <h1>Memory Matching Madness</h1>

        <div id="panel_gamestart">
            <p>Let's play! click to begin!</p>
            <button id="button_playgame">Play Game</button>
        </div>
        <div id="panel_gameplaying" class="hidden">
            <div id="timer_container">0 seconds elapsed</div>
            <div id="tile_container"></div>
        </div>
        <div id="panel_gameover" class="hidden">
            <p>Game over!</p>
            <p>Your time: 0 sec</p>
            <p>Best time: 0 sec</p>
        </div>

        <script>
            // DOM queries
            const panel_gamestart = document.querySelector('#panel_gamestart');
            const button_playgame = document.querySelector('#button_playgame');
            const panel_gameplaying = document.querySelector('#panel_gameplaying');
            const timer_container = document.querySelector('#timer_container');
            const tile_container = document.querySelector('#tile_container');
            const panel_gameover = document.querySelector('#panel_gameover');

            // global variables to keep track of our picked tiles
            let tile1 = false;
            let tile2 = false;

            button_playgame.onclick = function(e) {
                panel_gamestart.classList.add('hidden');
                panel_gameplaying.classList.remove('hidden');

                let assets = ['snorlax.png', 'electrabuzz.png', 'chansey.png', 'oddish.png',
                            'pikachu.png', 'paras.png', 'arcanine.png', 'ponita.png',
                            'venonat.png', 'eggsecute.png', 'machop.png', 'pidgey.png',
                            'psyduck.png', 'tauros.png', 'vulpix.png', 'gloom.png',
                            'krabby.png', 'butterfree.png', 'bulbasaur.png', 'clefairy.png',
                            'koffing.png', 'goldeen.png', 'magikarp.png', 'beedrill.png',
                            'lapras.png', 'meowth.png', 'ekans.png', 'jigglypuff.png',
                            'horsea.png', 'polywog.png', 'sandshrew.png', 'rattata.png',
                            'gengar.png', 'eevee.png', 'bellsprout.png', 'squirtle.png',
                            'seel.png', 'caterpie.png'];

                // pick 6 graphics at random
                let selectedTiles = [];

                while (selectedTiles.length < 12) {
                    // pick a random one from the assets array
                    let i = parseInt( Math.random() * assets.length );
                    selectedTiles.push( assets[i] );
                    selectedTiles.push( assets[i] );
                    assets.splice(i, 1);
                }

                console.log(selectedTiles);

                // you need to randomize these tiles so they are all messed up

                // create tiles for these graphics
                for (let i = 0; i < selectedTiles.length; i++) {
                    // create a tile
                    let tile = document.createElement('img');
                    tile.src = 'assignment06_images/pokeball.png';
                    tile.dataset.secret = 'assignment06_images/' + selectedTiles[i];
                    tile_container.appendChild(tile);

                    // set up event listeners on each tile
                    tile.onclick = function(event) {

                        // have no tiles been clicked?
                        if (tile1 == false && tile2 == false) {
                            // reveal tile 1

                            // switch graphics
                            event.currentTarget.src = event.currentTarget.dataset.secret;

                            // mark this as tile1
                            tile1 = event.currentTarget;
                        }
                        else if (tile2 == false) {
                            // reveal this tile

                            // switch graphics
                            event.currentTarget.src = event.currentTarget.dataset.secret;

                            // mark this as tile1
                            tile2 = event.currentTarget;

                            // did they get it right?
                            if (tile1.dataset.secret == tile2.dataset.secret) {
                                // reset the game back to the original state and allow more clicks
                                tile1 = false;
                                tile2 = false;
                                console.log("MATCH");
                            }
                            else {
                                // they got it wrong
                                setTimeout( function() {
                                    tile1.src = 'assignment06_images/pokeball.png';
                                    tile2.src = 'assignment06_images/pokeball.png';
                                    tile1 = false;
                                    tile2 = false;
                                }, 1000);
                            }
                        }



                        //tile.src = tile.dataset.secret;
                    }
                }

            }

        </script>
    </body>
</html>