Ivailo Chakarov - Using Computer Applications

Using Computer Applications
Sessions: (Wednesday 9.00-12.00 NL26 Group 2,
Thursday 9.30-12.30 T73 Group 1)

		Weeks 1 - 3
		Week	Lecture	Tutorial/Exercise

		1	Course Outline (Using Computer Applications)	UCA Week 1 Exercises
		2	Excel Tips	Football Excercise Video Shop Charts
		3	If Statements	If Exercise Spreadsheet case study

		Weeks 4 - 6
		Week	Lecture	Tutorial/Exercise

		4	Naming and Vlookup Creating Macros	Dave Deals
		5	Spreadsheet Consolidation exercise	UCA Excel Assignment (Completed)
		6	Database Concepts Data Types Field Properties Creating Tables	Data Types Exercise Lookups & Validation

		Weeks 7 - 9
		Week	Lecture	Tutorial/Exercise

		7	Queries	UCA Database Assignment (Hand Out)
		8	Reports	Query Criteria Expressions
		9	Forms	Entity Relational Diagrams ERD Example

		Weeks 10 - 12
		Week	Lecture	Tutorial/Exercise

		10	Documentation	Example Technical Manual Example User Manual
		11	Workshop	Workshop
		12	Presentations	UCA Database Assignment (Hand In)

		Excel Links & Addtional Resources
			Links	Additional Resouces

			Module Descriptor Database Management Systems (Database Concepts) Lookup Tables in Access Microsoft Office System 2007 Mircosoft Excel 2007 Courses	Excel 2007 Tutorial ( Florida Gulf Coast University ) Free Excel 2007 Online Tutorials Excel 2007 Quick Reference Card ( Custom Guides )

		Access Links & Addtional Resources
			Links	Additional Resouces

			Module Descriptor Microsoft Office System 2007 Mircosoft Access 2007 Courses Software Training Tutorials Access 2003 Database Basics AIB Access 2003 Tutorial The Webmaster's Bureau Database Basics Easy-to-Understand Database Tutorials A tutorial on the first 3 normal forms Database Normalization example Mapping ER Models into Relations	Access 2007 Tutorial ( Florida Gulf Coast University ) Access 2003 Tutorial ( Teacher Click ) MS Access Tutorials ( Brainbell.com ) Access 2003 Tutorial Relational Database Tutorial Relational Database Definition Database Normalization Definition Introduction to Database Normalization Rules of Data Normalization Entity Relational Diagrams ERD Example

The majority of resources included on this page have been created by Janet Nichols for which a big thank-you is expressed.

< Back to Home Page >