Introduction to Information Systems and Applications (ECON1242)

The file here includes two worksheets. The worksheet with name "Grades of Exercises" presents the grades of each student in 5 exercises and the weight of each exercise in the final grade. Use spreadsheet functions to answer the following questions:

The workbook here includes the students' grade in a course. The file contains 2 columns: the semester of the student and the grade. In the grade column, the NS indicates Not-Shown in the exam. Answer the following questions:

The file here (xlsx file) shows the staff of a project in a university. For each employee participating in the project, the following items are given in the columns: Name, Project Team to which she/he belongs, Category of job relationship (Staff with contract, Permanent staff or Teaching staff), Initial Contract amount and Final Contract amount (in Euro). On the basis of these data, fill in the necessary columns and answer the questions.

The dataset includes the grades of students in an examination. The dataset includes 3 columns: a numeric index (#),  the student semester of study and the grade. In column "Grade", the text NS means that the specific student did not participate in the exam (not-shown). Process the dataset and answer to the following questions: