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

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Tasks to be undertaken:

This assignment is based on the SAS programming that you completed during lab sessions. However, you are encouraged to look beyond what was covered in this module as this will prepare you as a SAS professional programmer in a real world.

Background.

The university wishes to set up an attendance monitoring system. You are part of the team involved in identifying what can be achieved with this system.

You are to write a report to show how the various types of user can be assisted in performing their job. A small amount of test data has been supplied to allow you to create some sample output. Your report will be used as part of the business case for this system.

You are required to :

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

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.

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.

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme