SROM 155 Computer Applications

School of Hospitality and Tourism

SROM 155 Computer Applications supports students to gain digital confidence and practical technology skills for success in the tourism workplace. From creating professional documents and spreadsheets to navigating digital communication platforms, students will build the digital literacy needed for today’s connected world that reflects both accessible and culturally respectful practices. Hands-on activities emphasize practical tools to manage projects, communicate effectively, and market tourism experiences.

Accessibility Services Notice

Students who would like an academic accommodation and who have a documented disability should contact Accessibility Services, if they have not already done so.

Transfer Agreements

Course to Course transfer – YesBlock Transfer – Yesbctransferguide.ca

Course Details
Total number of weeks	15
Total Credits
Total Hours	45

Typical hours per week breakdown
Lecture	3

Learning Outcomes

Upon successful completion of this course, the learner will be able to:

Create professional workplace documents that incorporate cultural responsibility and basic accessibility standards
Perform operational and financial tasks, such as budgets, costing, and simple forecasts, to demonstrate and test sustainable business scenarios
Use digital collaboration tools professionally for system file management, shared workspaces, and assignment submissions
Organize and share digital content securely and respectfully in support of professional practice and collaboration
Apply digital ethics and content stewardship, including copyright, accessibility best practices, and respectful use of Indigenous and community materials when designing documents and communications for the tourism workplace
Design accessible and culturally respectful presentations that support professional communication in tourism and destination management settings

Teaching and Learning Approach

This is a student-centered approach which will blend together theory and practice. Experiential practice will be had within the classroom, online, community, and industry setting where possible.

Learning Resources

Required: Shelly Cashman Series (2 hard books) 1) Vermaat, Misty E., (2019). Shelly Cashman series ® Microsoft Office 365, Word 2019 Comprehensive. Boston, MA: Cengage Learning, Inc. ISBN-10: 035702642X ISBN-13: 9780357026427 2) Freund, S.M., & Starks, J.L. (2019). Shelly Cashman series ® Microsoft Office 365, Excel 2019 Comprehensive. Boston, MA: Cengage Learning, Inc. ISBN: 9780357260357 Print plus Printed MindTap Access Available through Selkirk College bookstore or direct from publisher: https://www.cengage.ca/c/shelly-cashman-series-microsoft-office-365-word-2019-comprehensive-1e- vermaat/9780357026427/ and https://www.cengage.ca/c/shelly-cashman-series-microsoft-office-365-excel-2019-comprehensive-1e- freund-starks/9780357026403/ OR eTextbooks (2 ebooks) 1) Vermaat, Misty E., (2019). Shelly Cashman series ® Microsoft Office 365, Word 2019 Comprehensive 2) Freund, S.M., & Starks, J.L. (2019). Shelly Cashman series ® Microsoft Office 365, Excel 2019 Comprehensive Available through Vital Source or direct from the publisher: https://www.vitalsource.com/en-ca/products/shelly-cashman-series-microsoft-office-365-amp-word- misty-e-vermaat-v9780357119297 and https://www.vitalsource.com/en-ca/products/shelly-cashman-series-microsoft-office-365- amp-excel-steven-m-freund-joy-l-v9780357119259 OR MindTap (Publisher courseware that offers additional resources - one MindTap subscription gives you access to both ebooks) MindTap for Cable/Freund/Monk/Sebok/Starks/Vermaat's The Shelly Cashman Series Collection, Microsoft® Office 365 & Office 2019, 1 term Instant Access, 1st Edition, 1st Edition Available direct from the publisher: https://www.cengage.ca/c/shelly-cashman-series-microsoft-office-365-excel-2019-comprehensive-1e- freund-starks/9780357026403/

Detailed Course Content, Topics, and Sequence Covered

1. Introductions Lab Rules Course Outline Sign On Email Addresses Sign on to Moodle Introduction to Microsoft Word Word Module 1: Creating and Modifying a Flyer 2. Word Module 2: Creating a Research Paper 3. Word Module 4: Creating a Multipage Document 4. Word Module 6: Using Mail Merge 5. Word Module 7: Creating a Newsletter 6. Word Module 3: Creating a Business Letter Word Module 5: Creating a Resume and Sharing Documents Review all concepts for Microsoft Word practical exam 7. Microsoft Word Exam 8. Introduction to Excel Excel Module 1: Creating a Worksheet and a Chart 9. Excel Module 2: Formulas, Functions, and Formatting 10. Module 3: Working with Large Worksheets, Charting and What-If Analysis 11. Module 4: Financial Functions, Data Tables, and Amortization Schedules 12. Module 5: Working With Multiple Worksheets and Workbooks 13. Module 6: Creating, Sorting & Querying a Table 14. Review all concepts for Microsoft Excel practical exam 15. Microsoft Excel Exam

Assessment

Title	Learning Outcomes	Value
In-class Assignments	1-4	38%
Course Project	1-4	12%
Word Practical Exam	1-3	25%
Excel Practical Exam	1-2, 4	25%
Total		100%

Grading Table

Standard Academic and Career Programs Grading Table

Percentage	Letter Grade	GPA
90-100	A+	4.33
85-89	A	4.00
80-84	A-	3.67
76-79	B+	3.33
72-75	B	3.00
68-71	B-	2.67
64-67	C+	2.33
60-63	C	2.00
55-59	C-	1.67
50-54	P	1.00
0-49	F	0.00
	DNW	0.00

See the Academic Calendar for General Information including how to withdraw from course(s) and other regulations.

Disclaimer

Information contained in this course outline is correct at the time of publication. Content of the course is revised on an ongoing basis to ensure relevance to changing educational, employment and market needs. The instructor will endeavor to provide notice of changes to students as soon as possible. The instructor reserves the right to add or delete material from courses.