DMS311 - Data Management Software
|Schools offering this subject|
|Last revision date||Sep 4, 2013 1:24:01 PM|
|Last review date||Sep 4, 2013 1:24:01 PM|
Data Management Software
In DMS311 students will continue to improve their ability to manipulate software within the Windows environment as they learn the basic features of both Microsoft Excel and Microsoft Access. In Excel, students will learn how to enter, organize, manipulate, calculate, and graph data, and how to format the data to produce attractive presentations. Students will enter formulas, including the IF formula, use a variety of Functions and explore What-If analysis. In Access, topics include setting up a database, planning and designing the structure, inputting records, and creating reports and forms.
DMS311 is a required credit for all School of Office Administration students enrolled in the accelerated Medical and Legal programs.
Upon successful completion of this subject the student will be able to:
1. Create a worksheet and embedded chart (Chapter 1 Excel text)
2. Enter formulas, use functions and apply formatting. (Chapter 2 Excel text)
3. Explore What-If analysis, charting, and working with large worksheets (Chapter 3 Excel text)
4. Create a database using Design and Datasheet Views (Chapter 1 Access text)
5. Query a database using the Select Query Window (Chapter 2 Access text)
6. Maintain a database using the Design and Update features of Access (Chapter 3 Access text)
7. Demonstrate an attitude of professionalism, as evidenced by an ability to meet deadlines, complete assignments and perform tests and in-class assignments as scheduled
Essential Employability Skills
Communicate clearly, concisely and correctly in the written, spoken and visual form that fulfils the purpose and meets the needs of the audience.
Respond to written, spoken, or visual messages in a manner that ensures effective communication.
Execute mathematical operations accurately.
Apply a systematic approach to solve problems.
Use a variety of thinking skills to anticipate and solve problems.
Locate, select, organize, and document information using appropriate technology and information systems.
Analyze, evaluate, and apply relevant information from a variety of sources.
Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.
To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on http://library.senecacollege.ca for further information regarding cheating and plagiarism policies and procedures.
All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at email@example.com.
Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.