Course Content

The focus of this course will be cells in the spreadsheets, entering data to the spreadsheets, using and arranging the data, Formula formation, arithmetical operations, and a comprehensive electronic table program which allows the comparison of those operations. Furthermore, detailed information about file sharing, summary tables, reports, graphics formation, analyses, storing the spreadsheets as a web-page and delivering them via Internet will be provided.

Evaluation

At least 3 assignments of 4 assignments must be submitted in order to take the final exam. Final grade is the total of 30% of the mid-term exam grades, 20% of the total of the assignment grades, and 50% of the final exam grade.

Coursebook

Inside Out MS Office Excel 2003, Arkadaş Yayınları, Ankara, 2003.

Instructional Designer

Inst. Özlem ÖZÖĞÜT ERORTA

Academic Facilitator Service

Academic facilitator service is available everyday between 09:00 and 13:00 except Saturday and Sunday.

Units

1. Working with Microsoft Excel 2003
2. Working with Excel Files and Folders
3. Working with Worksheets
4. Analyzing the Data Using Formulas
5. Shaping the Worksheet
6. Arranging the Worksheets
7. Worksheets and Windows
8. Using Graphics in the Worksheet
9. Printing the Excel Files
10. Working with Excel Functions-I
11. Working with Excel Functions-II
12. Working with Financial Functions
13. Working with Statistical Functions
14. List Management in Excel
15. Cause and Effect Analyses
16. Integrating Excel Applications with OLE
17. File Sharing in Excel
18. Working with Bridges in Excel
19. Collaborating on the Internet
20. Working with Graphics and Graphics Data
21. Working with External Data in Excel
22. Analyzing the Data with Summary Tables-1
23. Analyzing the Data with Summary Tables-2
24. Macros and Specific Functions
25. Visual Basic Applications in Excel

CD-ROM

Spreadsheets Applications CD-ROM will be used in this course.

Software

MS Excel 2003 software in the MS Office 2003 which will be given to students will be used in this course.