SAS/SQL Programming Coursework

You are required to :

a) Write a SAS program to input the supplied spreadsheet data containing student attendance and module marks.

Don't use plagiarized sources. Get Your Custom Essay on
SAS/SQL Programming Coursework
Just from $13/Page
Order Essay

Copies of the spreadsheets can be found in blackboard in the Coursework folder of Teaching Material.

You will find there is a spreadsheet listing student details and for each of 4 modules, there are several spreadsheets containing attendance data and one spreadsheet (total 4) containing student marks.

Create one SAS data set for all the attendance data and one SAS data set for all the student marks. Refer to task 2 to see what data is required.

b) The data are required by different people within the organisation.

Create SAS output (i.e. reports) for each of the following individuals. You will need to decide on the information to be included in the report(s) to meet the needs of each type of user.

a. The Year manager.
The year manager has responsibility for individual student welfare and progression. The year tutor needs to be aware of students who are missing classes. This could be consistently missing the same class and/or students missing for more than one week from all classes. Attendance below 70% on a module is considered problematic. The year tutor requires a list of students who are missing classes each week as the registers are created.

ACME WRITERS

b. The course leader.
The course leader has overall responsibility for a course and its delivery and will require summary statistics on individual modules (attendance and student marks), individual students (attendance and marks) as well as being responsible for calculating the overall mark for each student’s average mark.

c. The Department head.
The department head has responsibility for monitoring the student experience and the courses offered. This individual will need to carry out more specific analysis. For example:
a) To identify modules and students which have above and below average attendance/results.
b) To identify associations between achievement and attendance,
c) To identify associations between results and student demographics,
d) To identify associations between attendance and student demographics.

They will also be responsible for setting the policies used by the department, for example:
a) in setting an attendance level below which some type of action is required by the year manager (currently 70%). Would a different attendance level help meet the university objective of 50% of students achieving an overall average of 60% over their module marks.
b) Identifying when modules are too easy or too hard,
c) Identifying when a module has poor attendance.

They will also be involved in making strategic decisions such as:
a) Is attendance monitoring worthwhile?
b) Should students who achieve 39 % in a module be automatically be rounded up to 40%?
c) Should an overall attendance level be set?
Failure to achieve the level of attendance will result in failing a course overall. Example rules could be:
• if students attend below 70% in each module, they fail the attendance requirement
• if students have an average attendance for all modules below 70%, they fail the attendance requirement.
How many students would be removed from the course with each of these policies?

Present your findings in a report, which should state how your SAS reports meet the needs of the specific user types and should include the SAS reports to prove your case.

You should also place all your SAS programs in the appendix.

ACME WRITERS

Acme Writers
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.