Key words
Applied informatics, database management, databases, spreadsheets, IWETO-code: P175-information technology
Objectives
The objective of the Excel part is to familiarize the student with spreadsheets. The student will be able to use the software in an efficient way in an economical context. The student can work independently and accurate to solve economic calculation problems using the software.
The purpose of the part on the database program Access is to familiarize the student with databases.
The student will be able to create and use a relational database using the MS Access software. The student must have a problem solving attitude and be able to work accurately. The student knows to most important possibilities of the software.
Topics
Spreadsheet - Excel
- Introduction to excel
- Use of formulas
- Lay-out of worksheets
- Printing
- Range names
- Basic function (sum, average, count)
- Charts
- Creating charts
- Lay-outing charts
- Adapt existing charts
Database – Access
- Basic terminology on tables
- Relational database
- Design of Queries
- Use of forms and reports
Prerequisites
Fair knowledge of Microsoft Windows
Fair knowledge of English
Final Objectives
- The student knows how to work efficiently with Excel
- the student is able to use the basic terminology like workbooks, worksheet,
- The student knows how to use the help function
- The student knows how to enter data and formulas and how to copy them
- the student knows how to create worksheets and how to copy them
- The student can build series and range names
- The student knows different ways of inserting formulas and knows the names of commonly used functions
- The student knows how to lay-out cells (alignment, number formatting)
- Student knows how to print a large worksheet
- The student knows how to create and lay-out charts
- The student knows how to work efficiently with Microsoft access
- The student is able to create tables and make relations between them
- The student knows how to import and export data
- The student is able to create queries (selection queries, group-by queries, join queries) and use these to analyse tables
- The student knows how to create, adapt and use forms and reports
- The student handles tasks professionally in both Microsoft Excel and Microsoft Access
- The student is able to analyse, process and interpret numerical data.
- The student works analytically and has a problem solving attitude
- The student is able to work efficiently with Microsoft Excel and Microsoft Access and solves the assignments within a limited time.
Materials used
::Click here for additional information::
Course with exercises for Excel and theory and exercises for Access.
Excel Files used in the lessons available through the internal network
Study costs
Costs for copying the paper course material
Study guidance
Guidance through electronic learning environment
Teaching Methods
By lectures and exercises with the computer the student learns all the concepts needed for a sufficient basic knowledge of Microsoft Excel and Microsoft Access
Assessment
- First examen session: examination on the computer
- Second exam session: examination on the computer
Lecturer(s)
- Jurgen Meirlaen
- Bart Van der Straeten
|
|
