Key words
PC use, spreadsheet, database management, databases, IWETO code P175 computer use
Objectives
SPREADSHEETS
Students get acquainted with spreadsheets. They should especially be able to use this software in business contexts.
Students have to learn how to work on their own accurately in marketer practice. They should e.g. be able to make sales forecasts, to make and manage budgets, to use data for graphs, …
Students will need the skills taught here for different subjects like marketing strategy, price policy, B2B and personal sales …
DATABASE MANAGEMENT
Students get acquainted with databases. They should be able to make and use a database using Office software.
Students should know the main capabilities of database software and how to use Help to increase their skills.
Students should be able to execute a number of assignments efficiently and on their own within a given time.
Students have to be able to think towards the solution of a problem and to work meticulously.
Topics
SPREADSHEETS- Review of basic spreadsheet techniques under Windows, i.e.
1.1. Using formulae
1.2. Laying out worksheets
1.3. Printing
1.4. Range names
1.5. Elementary functions (sum, average, max, min, number, numberarg) - Working with graphs
2.1. Making graphs
2.2. Laying out graphs (data series and points, titles, legend, axes, text fields, …)
2.3. Adapting graphs (adding and removing data series, changing type of graph, …) - Managing lists
3.1. Making lists
3.2. Validation
3.3. Sorting
3.4. Filtering lists (automatic filters, extensive filters)
3.5. Database functions
3.6. Subtotals
3.7. Pivot tables - Further exploration
4.1. Functions: date and time, logical functions, financial functions, search functions, nesting functions
4.2. Links
4.3. Elementary macros and hyperlinks - Job-related exercises and cases
DATABASE MANAGEMENT- Basic terminology of database software
- Making tables, relations
- Entering data, links to Word and Excel
- Designing queries: selection queries (also parameter queries and join queries) and action queries
- Working with forms and reports
- Practice-based cases
Prerequisites
- Being able to use standard possibilities of the operating system and having basic keyboard skills.
- Elementary command of the basic functions of spreadsheets is advisable. This starting level will be diagnosed in an initial test in order to be able to differentiate during the first classes and allow some students to catch up
- Should a student not have elementary skills in working with spreadsheets, it is advisable to take the introductory 'Excel' course.
Final Objectives
Knowledge:
General:
General and job-related:- Software for management:
- Spreadsheet
- Database management - Basic command of statistics and graphs
Job-related:- Knowing spreadsheets, database software, word processing, e-mail, internet and the software capacities within the profession
- Knowing data processing and data adaptation
Skills:
General:- Capacity for thinking and reasoning
General and job-related:- Efficient use of information infrastructure (i.al. ICT)
- Handling numerical data
- Working efficiently on a PC
- Analytic and problem solving thinking
- Logical thinking
- Using software (the most recent in the profession)
Job-related:- Being comfortable with spreadsheet and database software in job-related assignments
Attitudes:
General:- Precision and meticulousness
General and job-related:
Job-related:- Like to work with numbers
- Lifelong learning on professional software
Materials used
::Click here for additional information::
PC with Office software, outside classes students may use the computer training room.
SPREADSHEETS- Syllabus with practice-based exercises, available through the course service
- Class files available over the internal network - they may be copied to CD ROM in the class room
- Exercises on the network and on Dokeos
DATABASE MANAGEMENT- Lecturers' syllabus, available through the course service
- Exercises on the network and on Dokeos
Study costs
Syllabus at the going rate for photocopies at Hogeschool Gent, approx. 300 pages (spreadsheets) and 250 (database)
Study guidance
- Diagnostic test at the start of classes to determine whether students have elementary skills in spreadsheets, so differentiation is possible during the first weeks
- Coaching during guided self-study
Teaching Methods
- Students get acquainted with the software through interactive classes, guided and individual exercises on the PC.
- The lecturer will coach students and correct them wherever necessary during self-study on various exercises and assignments they prepared on their own in advance.
Assessment
SPREADSHEETS - 60%- First exam session: 80% exam on PC: executing assignments within the time limit - and continuous assessment 20%
- Second exam session: 100% exam on PC: executing assignments within the time limit
DATABASE - 40%- First exam session: 100% exam on PC: executing assignments within the time limit
- Second exam session: 100% exam on PC: executing assignments within the time limit
Students registered for the examinations only: either session: 100% exam on PC: executing assignments within the time limit.
Students who did not succeed yet got at least 10/20 for either part of the examination, do not have to be re-examined for this part in the second term of the same academic year. They do, however, have to do the exam for the part for which they had less than 10/20, otherwise they will be considered absent for the both subjects.
Lecturer(s)
|
|
