COMPUTER-BASED MANAGEMENT OF FIRM DATA (PASS/FAIL)
GESTIONE INFORMATICA DEI DATI AZIENDALI (IDONEITÀ)
|Lecturer||Office hours for students|
|Franca Petroselli||friday 13-14|
Assigned to the Degree Course
|Date||Time||Classroom / Location|
|Date||Time||Classroom / Location|
The course aims to provide students with knowledge of the basic concepts of information technology (both hardware and software - theory) and the capability of computer use in the most popular spreadsheet and database (the application) environments economic and business
The course is divided into the following three modules that will be performed in the order described:
A) THEORY. This module explains the fundamental concepts related to information technology, transferring the basic knowledge about the information coding, the structure and operation of a personal computer, software, operating systems, computer networks, systems business information and how these technologies impact society and the life of every day.
B) EXCEL - USE OF SPREADSHEET. The module is embodied in learning the basics of the spreadsheet Excel and the ability to apply this tool in the solution of the most common business issues: creating and formatting a spreadsheet, using mathematical functions, statistical, logical and research, the date and time functions, financial functions, importing objects in the spreadsheet, the management of multiple sheets and multiple folders, the data in the graph, data analysis and use of data commands, subtotals and Pivot tables.
C) ACCESS - USE DATABASE. The module aims to provide the tools to create and manage database applications: use and functionality of the database, and create database design, creation, modification and management of tables and masks, import and export data, queries, and simple and complex queries, creating, change management and reporting and records simple and complex automation applications.
For ONLY FORM A) THEORY, alternatively traditional exam, students can take (or proven to pass through display of skill card at registration examination): ALL and 3 of the TEST OLD ECDL CORE on 3 ECDL modules: Module 1 (Theory) + Module 2 (Windows and file management) + Module 7 (the Internet and computer networks) or the TEST NEW STANDARD ECDL modules M1 (Basic Concepts of computer) and M2 (Basic Concepts network)
Learning Achievements (Dublin Descriptors)
Acquiring skills in the evaluation and selection of computer systems in hardware and software; acquisition of operational skills in the use of the most popular application tools for spreadsheet and database (Windows operating system) in economic and business environments; acquisition of knowledge for obtaining ECDL and ECDL EXPERT BASE
The teaching material prepared by the lecturer in addition to recommended textbooks (such as for instance slides, lecture notes, exercises, bibliography) and communications from the lecturer specific to the course can be found inside the Moodle platform › blended.uniurb.it
Exercises laboratory, case studies and seminars
Didactics, Attendance, Course Books and Assessment
Front lessons, exercises on PC and case studies in the laboratory
- Course books
THEORY: Lecture by prof. Bentivoglio (available on the website of the School on the teacher Petroselli http://www.econ.uniurb.it/Big.asp?pagdocente.asp?57) OR 1 CHOICE between the following texts:
- Introduction to (Luke Console Marina Ribaudo) - Utet computer
- Computer company (P. Mertens and others) - McGraw-Hill
- Introduction to computer systems (Sciuto, Buonanno, Fornaciari, Mari) - McGraw-Hill.
- EXCEL for Students of Economics (G. Bentivoglio, F. Petroselli, C. Nicoletti) - Editions Goliardiche, revised and supplemented in 2005.
1) A CHOICE BETWEEN THE FOLLOWING MANUAL: ACCESS 2007: GUIDE (G. Piriou, M.Tripolini) - ed. SAMS or ACCESS 2007: GUIDE (Andersen Virginia) - ed. MC Graw Hill or USER ACCESS 2007 (Andersen Virginia) - ed. MC Graw Hill or USE ACCESS 2007 BEYOND BOUNDARIES (Viescas, Jeff) and. MONDADORI COMPUTER
2) LECTURE by the teacher (available at the school on the teacher Petroselli http://www.econ.uniurb.it/Big.asp?pagdocente.asp?57)
The exam consists of 3 tests: 1. Theory: Test with Multiple Answer Quiz 2. Excel 2013: laboratory application test 3. Access 2013: laboratory testing
Theorem No.1 tries to ensure the mastery of theoretical knowledge of hardware and software and to verify the understanding of fundamental concepts in information technology such as the structure and operation of a personal computer, systems operational, encrypted and rendered information, corporate information systems, and networks. The test consists of a computer test with ad-hoc software (WinASK), structured in 32 questions with 4 multiple answers, in which you must select 1 or more than 1 correct answer. The overrun threshold is automatically generated by the software on average with 20 questions answered correctly, although the score of each response may vary from a positive score of +6 to the negative of -6, according to the level of the correct answer. The software generates sufficient voting and therefore overcoming the test with a score of over 50. With proof no. 2 of Excel want to know the knowledge, the understanding skills applied to the use of a spreadsheet, the ability to build models and business applications using this software. The test is of a semi-structured type, thinking of the solution of an exercise with normally four problems (with a progressive leveling scale) to be automated. Exceeding the test takes place with the correct resolution of at least 2 of the 4 points. With proof no. 3 of Access want to find out the consonances, the understanding skills applied to the use of a database, the ability to build models and business applications using this software. The test is of a semi-structured type, with the solution of a 4-point exercise: database design and construction, 2 queries, 1 mask or report. Exceeding the test takes place with the correct resolution of the database design and construction and at least 1 query.
The 3 exams MUST be incurred ALL THE SAME APPEAL: NOT 'POSSIBLE TO SUPPORT OR PARTIAL EXAM ONLY FORM 1. In the examination (3 tests) the failure to pass even the first 3 test involves the overcoming of NOT 'COMPREHENSIVE examination and the obligation to retake all 3 tests.
Registration examination is automatic ON BOOK ON LINE with the correction and overcoming the 3 tests. Verbalization booklet on paper must ', however, take place after the next scheduled exam, not the student has the' obligation to register in the list of examination.
Notice is hereby given that, as for all other exams, the exam registration lists are solely "on line" and are closed at 24 for two days before the exam date. Since the application tests require time for their correction and evaluation, you can not vote in the minutes of the day on which the exam is taken (except in exceptional cases). The results and the relevant minutes (in the case of passing the exam) will be announced on the book online to students no later than the following week.
Students who already have the European Licence (ECDL OLD), in order to achieve the examination, however, will have to support the following two tests: Excel 2007 application test + Access 2007 with application test.
Students who already have the European Licence (ECDL NEW STANDARD or BASIC), in order to achieve the examination, however, will have to support the following two tests: Excel 2007 with application test + Access 2007 with application test.
So how will incur only 2 trials Excel + Access students in place of Module A) THEORY choose to support the 2 modules superseding NEW ECDL.
Anyone wishing to make use of the possession of the ECDL to the theory module, must 'take the exam for the sustenance of the remaining two modules exhibiting ECDL or exhibiting their skill card stamped and signed in original (released from their ECDL Test Center) indicating:
a) for OLD ECDL CORE ECDL TEST the passing of the three modules: Module 1 (Theory) + Module 2 (Windows and file management) + Module 7 (the Internet and computer networks)
b) for the ECDL NEW STANDARD the passing of ECDL Test on 2 modules: M1 (Basic Concepts of computer) and M2 (Basic concepts of network)
Additional Information for Non-Attending Students
- Course books
STUDENTS ATTENDING THE SAME
STUDENTS ATTENDING THE SAME
THERE ARE NOT DIFFERENCES IN PROGRAM OR METHOD 'ASSESSMENT OF RESULTS BETWEEN STUDENTS ATTENDING AND THOSE NOT ATTENDING
|« back||Last update: 08/09/2018|