by admin | Jul 21, 2022 | Scriptwriting
Learning Goal: I’m working on a scriptwriting test / quiz prep and need an explanation and answer to help me learn.
You are working as an analytics developer for your local public school system. You need to run a couple of analytics on student data to analyze student population in a certain area. This requires you to read student data into SAS.
In this assignment, you will write a SAS script and explore various ways to read the data using the freeform list, column input, and formatted input.
You will create at least 5-6 sample rows for below sample data.
Student_ID
sName
sAddressline1
sAddressline2
sCity
sState
sZip
You can use the data below or create your own.
Student_ID Student_Name Addressline1 Addressline2 City State Zip
113081 Brian Orlando 875 Main Tallahassee Fl 33950
113082 William Reno 422 East D Unit 2 Apalachicola Fl 33951
113083 Linda Ciccone 428 Logee Apt 1 Woonsock Fl 11289
113084 Raymond Niquett 473 Grand Woonsock FL 11289
113085 Gina Knapp 123 Cape Drive Unit 3A Cape Coral Fl 33986
You will then create three types of SAS scripts and read the data using the three methods discussed in the live meeting and in your textbook readings; freeform list, column input, and formatted input. In each script, you need to use PROC PRINT statement and print the output. Consider the pros and cons of each data input method and consider any issues you may have and how to resolve them (Ex: embedded spaces don’t work for freeform input, adjust the data to make it work for that input method. Do this for each input method). These issues and ways to solve them will be discussed in the live meeting.
Please submit ONE word doc with the following to the dropbox:
Text of each SAS Script code (not a screenshot, I need to be able to run your code). You can include one document with all code included, clearly label each script.
A screenshot of each SAS script OUTPUT, clearly labeled.
A screenshot of ONE of your scripts that shows the code in SAS Studio. No need to do a screenshot of all three. Include the screenshot in the Word document, clearly labeled.
by admin | Jul 19, 2022 | Scriptwriting
Learning Goal: I’m working on a scriptwriting project and need an explanation and answer to help me learn.
Instructions
Using MS Excel, create a new workbook with the following (Save as w7_firstname_lastname.xlsx or w7_firstname_lastname.xls).
As an administrator, you recorded the requests from different locations (i.e. a few states are listed) in the sheet below, you may create your own sheet. You need to explain the collected data. In the table below, you have the requests against the locations.
Software Installation requestsSoftware Update requestsHardware Installation requests
WV231215
MD1385
VA1746
DC1462
NY741
FL292111
You can use any data gathering for your choice
Create at least 5 statistical functions and graphs relating to the data.
From the data discuss the trend (your conclusion, what does this data mean for your planning), You can use the question of “What if… then”
Introduction to What-if Analysis
Submit your week 7 work in w7_firstname_lastname.xlsx or w7_firstname_lastname.xls
Please refer to the attached sample solution file, w7_first_lastName.xlsx, for help. In place of first and lastName in the file name make sure your first and last names are present.
Requirements
Points
Data Layout
20
Statistical functions and graph50
Data Analysis Conclusion
30
TOTAL POINTS
100
Stretch Assignment: (I’d like to include this portion of the assignment in future classes. I ask that you give it a try and provide me a short summary on your thoughts of adding this to the class going forward!)
Macros are little recorded sessions of code changes in Excel. We know scripting as anything trigger or event based that is recurrent. I ask that you create a script in Excel by creating a Macro. Your macro should ZERO OUT all of the data in the table you are using. You can call the macro, StartOfTheDay. You would run this macro, say, when you arrived in the morning to enter new data into the tables and purge the data from the previous day. Give it a try! Remember save your file as a filename.xlsm (if it includes a macro). If you’d prefer a different macro, just let me know the pupose of your macro in the comments section of your submission.
Record a Macro in Excel
by admin | Jul 19, 2022 | Scriptwriting
Learning Goal: I’m working on a scriptwriting discussion question and need an explanation and answer to help me learn.
Instructions:
What is a spreadsheet. How do we use spreadsheets as data storage and data analysis tools? How do you use spreadsheets to manage daily administrative tasks?
Forum Rubric for Grading:
Rubric for Learner Posts
Points
Synthesis of concepts (critical to class performance)
30
Applications of personal experience
20
Writing standards
10
Response to two or more students
40
Timeliness: (deduction) Optional
10
by admin | Jul 15, 2022 | Scriptwriting
Learning Goal: I’m working on a scriptwriting discussion question and need an explanation and answer to help me learn.
SQL is a language for managing databases. SQL is used, by users, “to add, modify or retrieve data from database tables.” (Loshin & Sirkin, 2022) SQL is considered a scripting language due to that is does not need to need to compiled to run and requires an interpreter to run the script. (U, 2020)
This SQL assignment is kicking my butt. None of the interpreters are working for me. Anyone have a source where the example code in the assignment works?
Thanks,
Rob
Loshin, P., & Sirkin, J. (2022, February 7). Structured Query Language (SQL). SearchDataManagement. https://www.techtarget.com/searchdatamanagement/definition/SQL
U, W. (2020, September 4). What Is SQL Programming Language? Woz U. https://woz-u.com/blog/what-is-sql-programming-language/#:%7E:text=SQL%20is%20a%20fourth%2Dgeneration,for%20issuing%20commands%20and%20queries.
by admin | Jul 15, 2022 | Scriptwriting
Learning Goal: I’m working on a scriptwriting discussion question and need an explanation and answer to help me learn.
Instructions:
What is SQL, is SQL a scripting language (support your answer).
Forum Rubric for Grading:
Rubric for Learner Posts
Points
Synthesis of concepts (critical to class performance)
30
Applications of personal experience
20
Writing standards
10
Response to two or more students
40
Timeliness: (deduction) Optional
10
by admin | Jul 15, 2022 | Scriptwriting
Learning Goal: I’m working on a scriptwriting exercise and need an explanation and answer to help me learn.
Instructions
Create the following SQL script (Save as w6_firstname_lastname.sql) .
Create a simple Database with the following
1) Create insert script (10 inserts)
2) Create update script (10 updates)
3) Create the following:-
a) Select all records
b) Select all records sorted descending , ascending
c) Select all records with condition (where)
d) Count all records
e) Count all record with condition
4) Create 3 delete scripts
Submit your week 6 work in w6_firstname_lastname.txt (Please save the file as a text file of your scripts and upload the text file here for final review.)
Please refer to the attached sample solution file, w6_first_lastName.txt, for help. In place of first and lastName in the file name make sure your first and last names are present.
Requirements
Points
Script 1)
40
Script 2)30
Script 3) & Script 4)
30
TOTAL POINTS
100
Attachments
w6_first_lastName.txt(1.82 KB)
Create table employees_names_456(ID int not null,firstname varchar(50),lastname varchar(40)),marks int);
REPLACE INTO employees_names_456 VALUES(1’First_Name1′,’Last_Name1′,50);
REPLACE INTO employees_names_456 VALUES(2’First_Name2′,’Last_Name2′,38);
REPLACE INTO employees_names_456 VALUES(3’First_Name3′,’Last_Name3′,42);
REPLACE INTO employees_names_456 VALUES(4’First_Name4′,’Last_Name4′,16);
REPLACE INTO employees_names_456 VALUES(5’First_Name5′,’Last_Name5′,32);
REPLACE INTO employees_names_456 VALUES(6’First_Name6′,’Last_Name6′,40);
REPLACE INTO employees_names_456 VALUES(7’First_Name7′,’Last_Name7′,10);
REPLACE INTO employees_names_456 VALUES(8’First_Name8′,’Last_Name8′,20);
REPLACE INTO employees_names_456 VALUES(9’First_Name9′,’Last_Name9′,48);
REPLACE INTO employees_names_456 VALUES(10’First_Name10′,’Last_Name10′,32);
UPDATE employees_names_456 SET firstname=’test’ WHERE ID=1;
UPDATE employees_names_456 SET firstname=’abc’, lastname=’xyz’ WHERE ID=2;
UPDATE employees_names_456 SET firstname=’Bob’ WHERE ID=3;
UPDATE employees_names_456 SET firstname=’Bill’ WHERE ID=4;
UPDATE employees_names_456 SET firstname=’Jim’ WHERE ID=5;
UPDATE employees_names_456 SET firstname=’Tom’ WHERE ID=6;
UPDATE employees_names_456 SET lastname=’Smith’ WHERE ID=7;
UPDATE employees_names_456 SET lastname=’Ross’ WHERE ID=8;
UPDATE employees_names_456 SET lastname=’Darbyshire’ WHERE ID=9;
UPDATE employees_names_456 SET firstname=’Briana’ WHERE ID=10;
SELECT * FROM employees_names_456
SELEECT * FROM employees_names_456 ORDER BY lastname DESC;
SELEECT * FROM employees_names_456 ORDER BY lastname ASC;
SELECT COUNT (*) FROM employees_names_456
SELECT COUNT (*) FROM firstname WHERE marks>50;
DELETE FROM employees_names_456 WHERE ID=’7′;
DELETE FROM employees_names_456 WHERE ID=’8′;
DELETE FROM employees_names_456 WHERE ID=’9′;
