{"id":324,"date":"2023-07-16T18:15:43","date_gmt":"2023-07-16T22:15:43","guid":{"rendered":"https:\/\/pressbooks.bccampus.ca\/abehandbook\/chapter\/computer-studies-provincial-level-computer-applications-2\/"},"modified":"2025-05-21T17:10:50","modified_gmt":"2025-05-21T21:10:50","slug":"computer-studies-provincial-level-computer-applications-2","status":"publish","type":"chapter","link":"https:\/\/pressbooks.bccampus.ca\/abehandbook\/chapter\/computer-studies-provincial-level-computer-applications-2\/","title":{"raw":"Computer Studies: Provincial Level - Computer Applications","rendered":"Computer Studies: Provincial Level &#8211; Computer Applications"},"content":{"raw":"<h3>Computer Studies: Provincial Level - Computer Applications<\/h3>\r\n\r\n<hr \/>\r\n\r\n<h5>Goal Statement<\/h5>\r\nThe goals for the Provincial Level Computing Studies are:\r\n<ul>\r\n \t<li>to develop problem solving\/critical thinking skills utilizing computer application software as a tool. Towards this end, project work will be emphasized.<\/li>\r\n \t<li>to build on computer software skills and outcomes as described by the learning outcomes of the advanced level computing studies.<\/li>\r\n<\/ul>\r\n<h5>Learning Outcomes<\/h5>\r\nBecause of the wide and ever expanding nature of computing applications, it is both impossible and undesirable to include all outcomes in a single course. A computing studies course at the provincial level will consist of a minimum of two from the following categories:\r\n\r\nEach topic will consider ethical point of views and students will complete a research activity for each topic.\r\n<h6>1. Current Technologies<\/h6>\r\n<ul>\r\n \t<li>search all facets of the web efficiently (text, images, videos) for material relevant to a specific inquiry<\/li>\r\n \t<li>analyze websites critically for value, accuracy, potential malware, and bias<\/li>\r\n \t<li>critically evaluate \u201ccrowd sourcing\u201d sites as research tools, e.g. opinions on consumer products, travel, health issues, political issues<\/li>\r\n \t<li>identify privacy &amp; security issues related to social networking<\/li>\r\n \t<li>effectively communicate with email utilizing: address books, distribution lists, cc: and bcc: fields, attachments, effective subject lines, spam control<\/li>\r\n \t<li>identify email examples of phishing and other online fraudulent activity<\/li>\r\n \t<li>use logical folder (directory) management techniques for computer files, email, etc.<\/li>\r\n \t<li>compare and contrast a variety of techniques, hardware and software that can be used to back-up computer data<\/li>\r\n \t<li>describe the importance of operating system and driver patches, and the processes by which these patches are downloaded and installed<\/li>\r\n \t<li>list examples of anti-virus and anti-malware software<\/li>\r\n \t<li>describe virus and malware risks<\/li>\r\n \t<li>set up scheduled scans<\/li>\r\n \t<li>describe the security implications of automatic updates<\/li>\r\n \t<li>identify cases where AI tools may assist in computer productivity, including AI generated citations<\/li>\r\n \t<li>identify online content where AI negatively impacts the quality of content, including errors and contradictions<\/li>\r\n \t<li>identify examples of where Augmented Reality (AR), Virtual Reality (VR), and Mixed Reality (MR) are used and their applications in computing<\/li>\r\n<\/ul>\r\n<h6>2. Publishing<\/h6>\r\n<ul>\r\n \t<li>organize and present a variety of text, graphic and other data following appropriate design and layout procedures<\/li>\r\n \t<li>use templates, \u201cwizards\u201d and\/or other productivity tools<\/li>\r\n \t<li>merge documents<\/li>\r\n \t<li>integrate tables, charts, and graphics<\/li>\r\n \t<li>describe the various file formats used for text, graphics and publication files<\/li>\r\n \t<li>change file formats where possible<\/li>\r\n \t<li>create, modify, and manipulate digital graphic images (e.g. scan, draw, paint)<\/li>\r\n \t<li>retrieve files from local and online sources<\/li>\r\n \t<li>use a variety of typographic principles to improve readability and effective communication<\/li>\r\n \t<li>generate cross references, footnotes, indexes and tables of contents<\/li>\r\n<\/ul>\r\n<h6>3. Advanced Spreadsheets<\/h6>\r\n<ul>\r\n \t<li>format cell types and describe the differences between common numerical formats such as accounting, currency, and number<\/li>\r\n \t<li>use complex formulas including functions such as VLOOKUP and IF<\/li>\r\n \t<li>use and write formulas<\/li>\r\n \t<li>create and modify charts<\/li>\r\n \t<li>create reports for multiple sheets using 3D references<\/li>\r\n \t<li>manage and analyze data using pivot tables and what-if analysis<\/li>\r\n \t<li>create macros or use a programming language to customize a spreadsheet<\/li>\r\n \t<li>design a spreadsheet to analyze, interpret, and project outcomes in an applied situation<\/li>\r\n<\/ul>\r\n<h6>Optional:<\/h6>\r\n<ul>\r\n \t<li>use solver<\/li>\r\n<\/ul>\r\n<h6>4. Database Management<\/h6>\r\n<ul>\r\n \t<li>describe the function of a database, and differences between databases and tables\/spreadsheets<\/li>\r\n \t<li>design and create flat file and relational databases<\/li>\r\n \t<li>maintain and modify the structure of existing databases<\/li>\r\n \t<li>correctly formulate queries<\/li>\r\n \t<li>create and edit forms<\/li>\r\n \t<li>create and edit reports<\/li>\r\n \t<li>explain various social and ethical issues involving databases<\/li>\r\n<\/ul>\r\n<h6>5. Networking<\/h6>\r\n<ul>\r\n \t<li>state advantages and disadvantages of using networks<\/li>\r\n \t<li>describe different network configurations (LAN, WAN, etc.)<\/li>\r\n \t<li>describe and diagram different network topologies (point-to-point, star, bus, etc.)<\/li>\r\n \t<li>describe the advantages and disadvantages of different network data transmission media (ethernet, twisted pair, coaxial cable, optical fiber, and wireless)<\/li>\r\n \t<li>list and describe common network operating systems and network protocols<\/li>\r\n \t<li>describe various server models, including file servers and client\/server systems<\/li>\r\n \t<li>list Internet\/intranet similarities and differences<\/li>\r\n \t<li>compare the similarities and differences between the Internet and intranets in terms of access, security, and functionality<\/li>\r\n \t<li>describe management issues, including traffic analysis and security<\/li>\r\n<\/ul>\r\n<h6>6. Programming*<\/h6>\r\n<strong>*A<\/strong> <strong>Note<\/strong> <strong>of<\/strong> <strong>Caution:<\/strong> The Programming option must not be considered as equivalent to or as a replacement for the Computer Science course articulated at the provincial level.\r\n\r\nThis option introduces the learner to programming fundamentals. The learner will write programs in a high level language that demonstrates output only and input-process-output operations. While the emphasis of the Computer Science course is software engineering, this option focuses primarily on the elements of programming.\r\n<ul>\r\n \t<li>test, debug, and modify program code<\/li>\r\n \t<li>define data types and assign meaningful identifiers to constants and variables<\/li>\r\n \t<li>use input statements to access the keyboard and use output statements to display text and graphics<\/li>\r\n \t<li>use conditional expressions to alter program flow<\/li>\r\n \t<li>use iteration structures to create loops<\/li>\r\n \t<li>write simple procedures<\/li>\r\n \t<li>write programs to demonstrate mathematical processing and simple character and graphic manipulations<\/li>\r\n<\/ul>\r\n<h6>7. Online Technologies<\/h6>\r\n<ul>\r\n \t<li>develop an online portfolio which contains projects that demonstrate proficiency with computer software<\/li>\r\n \t<li>describe the concept of cloud computing, and utilize cloud-based applications such as: word processing, spreadsheets, online collaboration, photo-editing, online storage<\/li>\r\n \t<li>utilize electronic means for time and calendar management, task (to do) lists, user ID management, notes and bookmark (favourite) synchronization<\/li>\r\n \t<li>create and publish a blog entry, which includes text, pictures, and hyperlinks<\/li>\r\n \t<li>add and update an entry on a wiki<\/li>\r\n \t<li>create and publish an online video<\/li>\r\n \t<li>describe software that can be used to remotely access another computer<\/li>\r\n \t<li>describe the process for setting up a home wireless network, configuring encryption, and having computers connect to the network. Connect to wireless networks in other locations<\/li>\r\n \t<li>describe the benefits of Bluetooth technology, provide examples of Bluetooth devices, and set up Bluetooth devices<\/li>\r\n \t<li>correctly apply privacy settings to media published online<\/li>\r\n \t<li>describe various licenses including copyright, public domain, creative commons, and GNU<\/li>\r\n<\/ul>\r\n<h6>8. Web Publishing<\/h6>\r\n<ul>\r\n \t<li>create web pages using both a WYSIWYG editor and an HTML editor to present text, graphics and other data using appropriate design and layout<\/li>\r\n \t<li>use fonts, font sizes, headings, justification and tables in a web page appropriately<\/li>\r\n \t<li>recognize the various file formats used for text, graphics, sound, and animation<\/li>\r\n \t<li>create, modify, and manipulate graphic images (e.g. resize, compress, crop, change format)<\/li>\r\n \t<li>locate and retrieve files (graphics, animations, sounds) from the Internet<\/li>\r\n \t<li>explain the implications of copyright copy-left (e.g. GNU GPL, Creative Commons, etc.)<\/li>\r\n \t<li>create and remove hyperlinks on text and graphics<\/li>\r\n \t<li>create internal (relative) and external (absolute) hyperlinks in a web page<\/li>\r\n \t<li>create a navigation scheme to move between web pages on a web site<\/li>\r\n \t<li>use accessibility features (e.g. alt text, choosing and structuring elements correctly, colour contrast and colourblind options)<\/li>\r\n \t<li>use meta tags (e.g. description, keywords, title)<\/li>\r\n \t<li>use JavaScript in web pages<\/li>\r\n \t<li>use Cascading Style Sheets (CSS)<\/li>\r\n \t<li>examine various monetization options for websites and examine the procedure of embedding advertisements<\/li>\r\n<\/ul>\r\n<h6>Optional:<\/h6>\r\n<ul>\r\n \t<li>use templates, wizards, and other productivity tools in the creation of web pages<\/li>\r\n \t<li>create an image map<\/li>\r\n<\/ul>\r\n<h6>9. Digital Art and Graphics<\/h6>\r\n<ul>\r\n \t<li>create basic digital shapes<\/li>\r\n \t<li>describe the difference between bitmap and vector images as well as the differences between common image file formats<\/li>\r\n \t<li>select, move, and align objects<\/li>\r\n \t<li>transform objects, including rotation, scaling, and reflecting<\/li>\r\n \t<li>create and format graphic text<\/li>\r\n \t<li>position text on a path<\/li>\r\n \t<li>create colours and gradients<\/li>\r\n \t<li>apply colours and gradients to text and other digital objects<\/li>\r\n \t<li>draw straight and curved lines<\/li>\r\n \t<li>trace a scanned object or digital photograph<\/li>\r\n \t<li>create and manipulate layers<\/li>\r\n \t<li>apply a variety of filter effects to a digital photograph<\/li>\r\n \t<li>adjust brightness and contrast of a digital photograph<\/li>\r\n \t<li>describe important specifications of a digital camera, including megapixels, optical zoom and digital zoom<\/li>\r\n \t<li>group and ungroup objects<\/li>\r\n<\/ul>","rendered":"<h3>Computer Studies: Provincial Level &#8211; Computer Applications<\/h3>\n<hr \/>\n<h5>Goal Statement<\/h5>\n<p>The goals for the Provincial Level Computing Studies are:<\/p>\n<ul>\n<li>to develop problem solving\/critical thinking skills utilizing computer application software as a tool. Towards this end, project work will be emphasized.<\/li>\n<li>to build on computer software skills and outcomes as described by the learning outcomes of the advanced level computing studies.<\/li>\n<\/ul>\n<h5>Learning Outcomes<\/h5>\n<p>Because of the wide and ever expanding nature of computing applications, it is both impossible and undesirable to include all outcomes in a single course. A computing studies course at the provincial level will consist of a minimum of two from the following categories:<\/p>\n<p>Each topic will consider ethical point of views and students will complete a research activity for each topic.<\/p>\n<h6>1. Current Technologies<\/h6>\n<ul>\n<li>search all facets of the web efficiently (text, images, videos) for material relevant to a specific inquiry<\/li>\n<li>analyze websites critically for value, accuracy, potential malware, and bias<\/li>\n<li>critically evaluate \u201ccrowd sourcing\u201d sites as research tools, e.g. opinions on consumer products, travel, health issues, political issues<\/li>\n<li>identify privacy &amp; security issues related to social networking<\/li>\n<li>effectively communicate with email utilizing: address books, distribution lists, cc: and bcc: fields, attachments, effective subject lines, spam control<\/li>\n<li>identify email examples of phishing and other online fraudulent activity<\/li>\n<li>use logical folder (directory) management techniques for computer files, email, etc.<\/li>\n<li>compare and contrast a variety of techniques, hardware and software that can be used to back-up computer data<\/li>\n<li>describe the importance of operating system and driver patches, and the processes by which these patches are downloaded and installed<\/li>\n<li>list examples of anti-virus and anti-malware software<\/li>\n<li>describe virus and malware risks<\/li>\n<li>set up scheduled scans<\/li>\n<li>describe the security implications of automatic updates<\/li>\n<li>identify cases where AI tools may assist in computer productivity, including AI generated citations<\/li>\n<li>identify online content where AI negatively impacts the quality of content, including errors and contradictions<\/li>\n<li>identify examples of where Augmented Reality (AR), Virtual Reality (VR), and Mixed Reality (MR) are used and their applications in computing<\/li>\n<\/ul>\n<h6>2. Publishing<\/h6>\n<ul>\n<li>organize and present a variety of text, graphic and other data following appropriate design and layout procedures<\/li>\n<li>use templates, \u201cwizards\u201d and\/or other productivity tools<\/li>\n<li>merge documents<\/li>\n<li>integrate tables, charts, and graphics<\/li>\n<li>describe the various file formats used for text, graphics and publication files<\/li>\n<li>change file formats where possible<\/li>\n<li>create, modify, and manipulate digital graphic images (e.g. scan, draw, paint)<\/li>\n<li>retrieve files from local and online sources<\/li>\n<li>use a variety of typographic principles to improve readability and effective communication<\/li>\n<li>generate cross references, footnotes, indexes and tables of contents<\/li>\n<\/ul>\n<h6>3. Advanced Spreadsheets<\/h6>\n<ul>\n<li>format cell types and describe the differences between common numerical formats such as accounting, currency, and number<\/li>\n<li>use complex formulas including functions such as VLOOKUP and IF<\/li>\n<li>use and write formulas<\/li>\n<li>create and modify charts<\/li>\n<li>create reports for multiple sheets using 3D references<\/li>\n<li>manage and analyze data using pivot tables and what-if analysis<\/li>\n<li>create macros or use a programming language to customize a spreadsheet<\/li>\n<li>design a spreadsheet to analyze, interpret, and project outcomes in an applied situation<\/li>\n<\/ul>\n<h6>Optional:<\/h6>\n<ul>\n<li>use solver<\/li>\n<\/ul>\n<h6>4. Database Management<\/h6>\n<ul>\n<li>describe the function of a database, and differences between databases and tables\/spreadsheets<\/li>\n<li>design and create flat file and relational databases<\/li>\n<li>maintain and modify the structure of existing databases<\/li>\n<li>correctly formulate queries<\/li>\n<li>create and edit forms<\/li>\n<li>create and edit reports<\/li>\n<li>explain various social and ethical issues involving databases<\/li>\n<\/ul>\n<h6>5. Networking<\/h6>\n<ul>\n<li>state advantages and disadvantages of using networks<\/li>\n<li>describe different network configurations (LAN, WAN, etc.)<\/li>\n<li>describe and diagram different network topologies (point-to-point, star, bus, etc.)<\/li>\n<li>describe the advantages and disadvantages of different network data transmission media (ethernet, twisted pair, coaxial cable, optical fiber, and wireless)<\/li>\n<li>list and describe common network operating systems and network protocols<\/li>\n<li>describe various server models, including file servers and client\/server systems<\/li>\n<li>list Internet\/intranet similarities and differences<\/li>\n<li>compare the similarities and differences between the Internet and intranets in terms of access, security, and functionality<\/li>\n<li>describe management issues, including traffic analysis and security<\/li>\n<\/ul>\n<h6>6. Programming*<\/h6>\n<p><strong>*A<\/strong> <strong>Note<\/strong> <strong>of<\/strong> <strong>Caution:<\/strong> The Programming option must not be considered as equivalent to or as a replacement for the Computer Science course articulated at the provincial level.<\/p>\n<p>This option introduces the learner to programming fundamentals. The learner will write programs in a high level language that demonstrates output only and input-process-output operations. While the emphasis of the Computer Science course is software engineering, this option focuses primarily on the elements of programming.<\/p>\n<ul>\n<li>test, debug, and modify program code<\/li>\n<li>define data types and assign meaningful identifiers to constants and variables<\/li>\n<li>use input statements to access the keyboard and use output statements to display text and graphics<\/li>\n<li>use conditional expressions to alter program flow<\/li>\n<li>use iteration structures to create loops<\/li>\n<li>write simple procedures<\/li>\n<li>write programs to demonstrate mathematical processing and simple character and graphic manipulations<\/li>\n<\/ul>\n<h6>7. Online Technologies<\/h6>\n<ul>\n<li>develop an online portfolio which contains projects that demonstrate proficiency with computer software<\/li>\n<li>describe the concept of cloud computing, and utilize cloud-based applications such as: word processing, spreadsheets, online collaboration, photo-editing, online storage<\/li>\n<li>utilize electronic means for time and calendar management, task (to do) lists, user ID management, notes and bookmark (favourite) synchronization<\/li>\n<li>create and publish a blog entry, which includes text, pictures, and hyperlinks<\/li>\n<li>add and update an entry on a wiki<\/li>\n<li>create and publish an online video<\/li>\n<li>describe software that can be used to remotely access another computer<\/li>\n<li>describe the process for setting up a home wireless network, configuring encryption, and having computers connect to the network. Connect to wireless networks in other locations<\/li>\n<li>describe the benefits of Bluetooth technology, provide examples of Bluetooth devices, and set up Bluetooth devices<\/li>\n<li>correctly apply privacy settings to media published online<\/li>\n<li>describe various licenses including copyright, public domain, creative commons, and GNU<\/li>\n<\/ul>\n<h6>8. Web Publishing<\/h6>\n<ul>\n<li>create web pages using both a WYSIWYG editor and an HTML editor to present text, graphics and other data using appropriate design and layout<\/li>\n<li>use fonts, font sizes, headings, justification and tables in a web page appropriately<\/li>\n<li>recognize the various file formats used for text, graphics, sound, and animation<\/li>\n<li>create, modify, and manipulate graphic images (e.g. resize, compress, crop, change format)<\/li>\n<li>locate and retrieve files (graphics, animations, sounds) from the Internet<\/li>\n<li>explain the implications of copyright copy-left (e.g. GNU GPL, Creative Commons, etc.)<\/li>\n<li>create and remove hyperlinks on text and graphics<\/li>\n<li>create internal (relative) and external (absolute) hyperlinks in a web page<\/li>\n<li>create a navigation scheme to move between web pages on a web site<\/li>\n<li>use accessibility features (e.g. alt text, choosing and structuring elements correctly, colour contrast and colourblind options)<\/li>\n<li>use meta tags (e.g. description, keywords, title)<\/li>\n<li>use JavaScript in web pages<\/li>\n<li>use Cascading Style Sheets (CSS)<\/li>\n<li>examine various monetization options for websites and examine the procedure of embedding advertisements<\/li>\n<\/ul>\n<h6>Optional:<\/h6>\n<ul>\n<li>use templates, wizards, and other productivity tools in the creation of web pages<\/li>\n<li>create an image map<\/li>\n<\/ul>\n<h6>9. Digital Art and Graphics<\/h6>\n<ul>\n<li>create basic digital shapes<\/li>\n<li>describe the difference between bitmap and vector images as well as the differences between common image file formats<\/li>\n<li>select, move, and align objects<\/li>\n<li>transform objects, including rotation, scaling, and reflecting<\/li>\n<li>create and format graphic text<\/li>\n<li>position text on a path<\/li>\n<li>create colours and gradients<\/li>\n<li>apply colours and gradients to text and other digital objects<\/li>\n<li>draw straight and curved lines<\/li>\n<li>trace a scanned object or digital photograph<\/li>\n<li>create and manipulate layers<\/li>\n<li>apply a variety of filter effects to a digital photograph<\/li>\n<li>adjust brightness and contrast of a digital photograph<\/li>\n<li>describe important specifications of a digital camera, including megapixels, optical zoom and digital zoom<\/li>\n<li>group and ungroup objects<\/li>\n<\/ul>\n","protected":false},"author":1935,"menu_order":4,"template":"","meta":{"pb_show_title":"","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-324","chapter","type-chapter","status-publish","hentry"],"part":320,"_links":{"self":[{"href":"https:\/\/pressbooks.bccampus.ca\/abehandbook\/wp-json\/pressbooks\/v2\/chapters\/324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pressbooks.bccampus.ca\/abehandbook\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/pressbooks.bccampus.ca\/abehandbook\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/abehandbook\/wp-json\/wp\/v2\/users\/1935"}],"version-history":[{"count":2,"href":"https:\/\/pressbooks.bccampus.ca\/abehandbook\/wp-json\/pressbooks\/v2\/chapters\/324\/revisions"}],"predecessor-version":[{"id":466,"href":"https:\/\/pressbooks.bccampus.ca\/abehandbook\/wp-json\/pressbooks\/v2\/chapters\/324\/revisions\/466"}],"part":[{"href":"https:\/\/pressbooks.bccampus.ca\/abehandbook\/wp-json\/pressbooks\/v2\/parts\/320"}],"metadata":[{"href":"https:\/\/pressbooks.bccampus.ca\/abehandbook\/wp-json\/pressbooks\/v2\/chapters\/324\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/pressbooks.bccampus.ca\/abehandbook\/wp-json\/wp\/v2\/media?parent=324"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/abehandbook\/wp-json\/pressbooks\/v2\/chapter-type?post=324"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/abehandbook\/wp-json\/wp\/v2\/contributor?post=324"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/pressbooks.bccampus.ca\/abehandbook\/wp-json\/wp\/v2\/license?post=324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}