CSTP 1103: Data and Document Management Fundamentals
Effective date
September 2019
Department
Computer Systems Tech Diploma
School
Trades, Technology and Design
Description
Learners will be introduced to the basics of document management such as creating, modifying, formatting, displaying, and processing data as in a typical workplace. This includes both structured and unstructured data, mostly in text format. Learners will be familiarized with popular document management apps such as Microsoft Word, Spreadsheet, Google Doc, Google Sheets, Google Charts, XML formatting, and document versioning tools such as git.
Year of study
1st Year Post-secondary
Course Learning Outcomes
Upon successful completion of this course, students will be able to:
- Use a personal information manager
- Create a spreadsheet
- Use application integration
- Manage spreadsheet data tables
- Automate tasks using macros and scripts
- Visualize data using charts and graphs
- Use SharePoint application and its features
- Manage document work-flow with SharePoint
- Use XML files for data management
- Use a common versioning system such as Git
Prior Learning Assessment & Recognition (PLAR)
None
Hours
Lecture, Online, Seminar, Tutorial: 30
Clinical, Lab, Rehearsal, Shop, Kitchen, Simulation, Studio: 30
Total Hours: 60
Instructional Strategies
Instructional strategies include classroom lectures, demonstrations, group discussions, computer lab and
hands-on practical work.
Grading System
Letter Grade (A-F)
Evaluation Plan
Type
|
Percentage
|
Assessment activity
|
Assignments
|
50
|
|
Midterm Exam
|
25
|
|
Final Exam
|
25
|
|
Course topics
- Document Management Systems
- Spreadsheet
- Application integration
- Spreadsheet data tables and charts
- XML file format
- Macros
- SharePoint apps
- Document workflow with SharePoint
- File versioning Systems
Notes:
- Course contents and descriptions, offerings and schedules are subject to change without notice.
- Students are required to follow all College policies including ones that govern their educational experience at VCC. Policies are available on the VCC website at:
https://www.vcc.ca/about/governance--policies/policies/.
- To find out if there are existing transfer agreements for this course, visit the BC Transfer Guide at https://www.bctransferguide.ca.