Excel 2007 Formulas - SUM, AVERAGE, PMT, IF, VLOOKUP

http://www.filebox.ro/direct_download.php?key=58fe84453cf65a8b8a6a73fdb0483381 - Function_PMT_-_Andreea_Bancu.xlsx

http://www.filebox.ro/direct_download.php?key=4500380baa3fb46d846e1c832a370a44 - 02-12-2010 Function VlookUp - Andreea Bancu.xls

Excel 2007 Formulas - Basics and Text Formulas part 2

One of my previous works - a project for TIC in high school

http://fbx.ro/i1lkh1tqgtv55lyo - BANCU_ANDREEA_-_CONTABILITATE_FIRMA.xls

Charts in Excel 2007 part 1

Comments and subtotals

Creating basics charts

Data List for file

http://fbx.ro/Data List for File - Andreea Bancu

Download Subtotals - Andreea Bancu

Excel 2007 Formulas

Worksheet Basics

Introduction to Excel 2007

Work in Excel 2007

References

Office 2007 Word

More about projects topic

Main area of research project:

Economics and Informatics

You can propose various titles, highlighting aspects of

Economics/business (EB)

and

Information and Communications Technology (ICT)

Examples:

• Company case study;
• Country / geographical area EB-ICT presentation;
• A particular (category of) software / hardware used in Finance & banking;
• Issues regarding jobs / professions / careers in Finance & banking.

***

• Open Source
  (applications for enterprises/
  the movement: past,present,future/
  an application usage/description/case study)  
• Cloud computing
• On-line Office
• Web 2.0 applications
  (overview or
  presentation of a single one) in modern organisations (ex: blogs, forums, wikis etc.)
• Long-life learning
  (overview,
  presentation of a single tool,
  politics of different international organisations,
  politics of some companies,
  politics of some governments etc.).
  Adapting the workforce to the technological needs required to work in today's society

Projects

The students will elaborate, in groups of maximum three students (~10 pages/student), a scientific paper about a topic of the lecture (see Course Syllabus) or other subjects concerning the ICT and economic implications (the topic will be submitted for approval to  the teacher as soon as possible - DEADLINE: 28 Oct 2010). To avoid loosing marks because of different missing (structure, references, sources, formatting issues etc.), it is advisable to see the paperwork before printing the final version (preferably, during laboratory classes, at least 2 weeks before the date settled for presentation). For this, you may use the Google site you have created and announce me to check the information you have typed/uploaded there.

• The paper will be ONE electronic document, created using a text processor (Microsoft Word 2007), sent to my e-mail in the final version at least 2 days before the presentation, and printed when submitted for the final examination.

• The paper presentation will be a PowerPoint file, orally presented in front of class, at the end of the semester. The presentation file will be also sent to my e-mail in the final version at least 2 days before the presentation.

• Project guidelines (content, typestting and presentation) - [Ghid_ro]_GuidelinesEN_2010-2011.pdf in the Attachment section, at the bottom of current page [based on Ghid_pentru_elaborarea_lucrarii_de_licenta_ sesiunea_iulie_2010.doc].

• For MS Word 2007 and general MS Office 2007 tools, tips and techniques (discussed during course N0.5/02_Nov_2010), you may consult the file Office 2007_Word,Office[AIO]_selected_.pdf, in the Attachment section, at the bottom of current page - psw for open:s9).

• It is a basic academic requirement to show details of the sources of your information, ideas and arguments. For more details, consult the document referencesMore_.pdf, from the Attachment section.

Assessments

When establishing the final grade there will be considered Grading percentage{Total=100%} - answers during exam – written or oral (final assessment) 30% - final answers at practical laboratory activities /seminars 30% - systematic assessment through tests - - continuous assessment during the semester 10% - activities like assignments/ reports / essays / translations / projects etc. 30%