Introduction to Information Systems and Applications (ECON1242)
Units
Data processing techniques using MS Excel spreadsheet software.
1.1 Basic Worksheet FunctionsThe basic concepts of the workbook and worksheet, cells and regions. | ||
Reading: Basic CalculationsStudy the following from Chapter 2 of the Open Textbook Beginning Excel? https://openoregon.pressbooks.pub/beginningexcel/part/chapter-2/ For studing Chapter 2 download data file: CH2 Data | ||
Exercise in Spreadsheet-Basics 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: |
||
Reading: Formulas and FunctionsStudy the following from Chapter 3 of the Open Textbook Beginning Excel? https://openoregon.pressbooks.pub/beginningexcel/part/chapter-3/ | ||
1. Exercises in Spreadsheets I 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: |
||
2. Exercises in Spreadsheets II 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. |
||
1.2 Visualize data with chartsImport data and present them with charts | ||
Reading: Present data with ChartsStudy the following from Chapter 4 of the Open Textbook Beginning Excel? https://openoregon.pressbooks.pub/beginningexcel/part/chapter-4/ | ||
Practice: Create different chart typesDownload the file here and create the charts in each worksheet according to the instructions. | ||
Exercises in Spreadsheets ΙΙΙ 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: |
||
1.3. Import and Organize data in TablesImport text data in Excel and manage them with tables | ||
What is CSV? A comma-separated values (CSV) file is a delimited text file that uses a comma to separate values. A CSV file stores tabular data (numbers and text) in plain text. Each line of the file is a data record. Each record consists of one or more fields, separated by commas (or other delimiters such as tab [TSV], semicolon, etc). (Definition from Wikipedia, https://en.wikipedia.org/wiki/Comma-separated_values) CSV files are widely used in business applications as an open format, compatible to different programs. | ||
Practice: Import CSV data in MS ExcelInstructions: https://www.hesa.ac.uk/support/user-guides/import-csv Attention in importing data in MS Excel 2016!
Data for practice: | ||
Reading: Organize data in tablesStudy the following from Chapter 5 of the Open Textbook Beginning Excel? https://openoregon.pressbooks.pub/beginningexcel/part/chapter-5/ | ||
Practice: Search in tables with INDEX() and MATCH() | ||
1.4 Summarizing DataLearn how to summarize data using descriptive statistics, histograms and pivot tables. | ||
Reading: Summarizing Data: Descriptive Statistics and Histograms with Excel Analysis Toolpak
| ||
Practice: Descriptive statistics and histogram of student grades
| ||
Reading: Summarizing Data using Pivot tablesWhat is a pivot table? A pivot table is a table of statistics that summarize the data of a more extensive table. This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way. (Definition from Wikipedia) Study Chapter 8: PivotTables and Pivot Charts from the following book: | ||
Beginning Microsoft Excel 2010 Online book of Abbbott Katz, in PDF only from Upatras IP space |
||
Practice: Agreegate sales data with pivot tables | ||
Optional Reading: Descriptive StatisticsReview the concepts of descriptive statistics in Chapter 2 of the Open Textbook Introductory Statistics | ||
Descriptive Statistics I - Lecture First part of a Lecture on Descriptive Statistics for the Introduction to Business Statistics Course. |