CPSC 203: Final exam information

Course web page: Introduction to problem solving with applications James Tam

CPSC 203: Final Exam Information

Date/location:

The final exam is scheduled by Student Service, you can find information via the [university portal]

Front cover from the actual exam (so make sure you look at this beforehand...important so make sure you read them beforehand!):

(Flip side of cover - top of page showing where you write your student ID number)

Exam topics

Lecture topics covered so far	Approximate proportion of exam¹
Material covered in the midterm (computers, logic, spreadsheets, databases)	~17%
VBA programming	28
The Internet	15
HTML and JavaScript programming	31
Computer security	~9%

Exam questions¹

Multiple choice questions ~37% of exam
	40 questions
Short answer questions ~63% of exam
	Program code writing: SA3, SA6
	Program code tracing (executing code by hand): SA4, SA7
	Other: SA1, SA2, SA5, SA8

¹^{It's based on a near-final version of the midterm (exact proportions may vary
*slightly*)}

VBA library documentation that will get for the final exam
Accessing the following VBA objects:
	Application: the MS-Office program running ActiveDocument: current MS-Word document Selection: currently selected text
Useful methods and attributes of the Application object
	Application.Windows.Count: number of open Word windows Application.CapsLock: a Boolean to indicate whether caps lock is turned on or off
Useful methods and attributes of the ActiveDocument object
	ActiveDocument.CountNumberedItems: total number of bulleted and numbered items ActiveDocument.Save: saves the current document ActiveDocument.SaveAs("<filename>"): save and rename document ActiveDocument.ActiveWindow.Caption = "<Caption>": change caption title in the Word window ActiveDocument.Close (<wdPromptToSaveChanges> or <wdDoNotSaveChanges> or <wdSaveChanges>): close current Word window and apply the effect of specified constant ActiveDocument.Checkspelling: run spell checker ActiveDocument.DeleteAllComments: delete all comments from the active document ActiveDocument.Printout: prints the active document ActiveDocument.SendMail: sends email with the active document as an attachment ActiveDocument.Words.Count: number of words in the MS-Word document ActiveDocument.Words.Comments.Count: number of annotation comments in the MS-Word document ActiveDocument.Select: select all the text in the active Word document ActiveDocument.Application: the application associated with the document ActiveDocument.Name: name of the active document ActiveDocument.Path: save path of the active document ActiveDocument.FullName: name & save path of the active document ActiveDocument.HasPassword: a Boolean to indicate if the active document has been saved since last changed ActiveDocument.SpellingChecked: a Boolean to indicate if the active document has been spell checked since last changed ActiveDocument.Save: a Boolean to indicate if the active document has been saved since last changed ActiveDocument.SpellingErrors.Count: the number of spelling mistakes in the active document ActiveDocument.Tables(i) Allows access to one table from the collection of tables. 'i' is a positive integer (i.e. >= 1) ActiveDocument.Tables.Count: number of tables in the active document ActiveDocument.Tables(i).Sort: 'i' is a positive integer, sorts the table specified by 'i' in the active document
ActiveDocument: find and replace text ActiveDocument.Content.Find.Execute FindText:="<text>", ReplaceWith:="<text>", _ Replace:= <wdReplaceAll>, MatchCase:= <Boolean>
Useful methods and attributes of the Selection object
	Selection.Expand: expand selection to next grouping size of text Selection.Copy: copy selected text Selection.MoveLeft: move cursor left Selection.MoveRight: move cursor right Selection.PasteAndFormat (<wdFormatOriginalFormatting or wdFormatPlainText>): copied text is pasted with the specified formatting Selection.Font = <Font name> : change font type Selection.Font.Size = <Size> : change font size Selection.Font.Bold = <Boolean> : turn bolding on or off Selection.Font.Bold = wdToggle: toggle bolding Selection.Font.Underline = <Boolean> : turn underlining on or off
Common and useful collections
	Lists(): all the lists in a Word document Shapes(): all the shapes in a Word document Tables(): all the tables in a Word document Documents(): the collection of documents currently opened
Useful methods and attributes of the Documents collection
	Documents.Item(i): Allows access to one document from the collection of documents. 'i' is a positive integer (i.e. >= 1) Documents.count: returns a positive integer that is equal to the number of documents currently opened. Documents(i).Save: save the document accessed through the index Documents(i).SaveAs (<"name">): save the document (accessed through the index) under another name Documents(i).PrintOut: print the document accessed through the index Documents.Open (<"location and name">): opens the document with the specified location and name and adds it to the documents collection
Len(<string>): this function returns the number of characters in the specified string

As mentioned several times VBA documentation WILL NOT be provided for the following (you're expected to know how to apply them without documentation)

Common and simple functions such as MsgBox and InputBox
Branching constructs (If-Then, If-Then Else, If-Then, ElseIf, Else) are not functions or methods
Logical (And, Or, Not), mathematical (+, -, *, /), string (concatentation) and relational (e.g., >=) operators
Looping constructs (For-Next, Do While-Loop)

VBA concepts that you did learn and are expected to know

(This is only a quick overview, you should look to the course notes for details)

How to create and run a VBA program (although you won't be asked questions about the VBA interface i.e. 'Where to click'
Defining a (single) subroutine
Variables
Named and pre-defined constants
Getting input via the InputBox and displaying output using a MsgBox and the status/title bar of the MS-Word window.
Naming conventions used for: variables, named constants, subroutines and the name of Word document that contains the macro
Logical, mathematical, string, and relational operators
Writing documentation (although you don't have to document your code writing solutions in the exam unless asked)
Branching
Looping
Accessing the objects and using the methods specified in the VBA library documentation (above)
What is the difference between the following file types: '.docm', '.docx' and '.doc' and the effect on computer security

JavaScript library documentation that will get for the final exam
The document object: access to the document that contains the JavaScript program
Useful methods of document
	document.getElementById("<string>"): access the graphical control identified with the specified string document.getElementById("<string>").value: access the value property of the graphical control identified with the specified string document.write(<"<data string>") OR document.write(<"<string for html tag>")
Window.onload = <function name>: automatically run the specified function when the webpage is loaded into the browser
Useful string methods
	string.length: the length of a particular string string.toUpperCase: convert lower case alphabetic to upper case string.toLowerCase: convert upper case alphabetic to lower case string.indexOf(<character>): returns the index of the first instance of the character in the string whose indexOf() method has been invoked

As mentioned several times JavaScript documentation WILL NOT be provided for the following (you're expected to know how to apply them without documentation)

Common and simple functions such as alert() and prompt()
Branching constructs (If; If, Else; If, Else If, Else) are not functions or methods
Logical operators (&&, ||, !), mathematical (+, -, *, /, %), string (concatenation) and relational (e.g., >=) operators
Looping constructs (for, while)

JavaScript concepts that you did learn and are expected to know

(This is only a quick overview, you should look to the course notes for details)

Where to include JavaScript in a webpage
Defining a (single) function
Having a JavaScript function execute in reaction to an event and having it run 'automatically'
Variables
Named constants
Getting input via a prompt()and displaying output using an alert() as well as by writing directly to document (text or html tags) via 'write()'
Naming conventions used for: variables, named constants and functions
Logical, mathematical, string, and relational operators
Writing documentation (single and multi-line - you don't have to document your code writing solutions in the exam unless asked)
Branching
Looping
Accessing the document object and some of the properties
Arrays
Strings

HTML Tags that you have learned and are expected to know (HTML tags are separate from JavaScript and you WON'T be given any documentation for HTML)

<b></b>
<i></i>
<u></u>
<s></s>
<br>
<h1></h1>
<h2></h2>
<h3></h3>
<h4></h4>
<h5></h5>
<h6></h6>
<ul></ul>
<ol></ol>
<li></li>
Creating graphical controls and accessing or setting their 'id' & 'value' properties: button, text, password, image,
Events: onclick,
<script> </script>

The following HTML tags were applied in the assignment but you won't see in the final exam:

<embed src="<video name and path>" autostart="<Boolean>">
<img src= "<image name and path>">
<href="<web address of linked document>"></a>
<href="mailto:<Email address>"></a>

Material that you should study

The final exam is cumulative but with a focus on material covered after the midterm exam: VBA programming for MS-Word, the Internet, computer security (concepts related to slides 1 - 49, the topics related to the other slides won't be included on the final), html web design and JavaScript programming. Because you have had the opportunity to practice, with the last two assignments, concepts from: VBA programming, HTML and JavaScript programming an especially heavy emphasis will be placed on these three sections (html and the two programming sections).

(Comments from the midterm that apply to the final exam)

The lecture material: the PowerPoint slides will provide you with an outline of the topics to be covered. However studying the information just listed on the slides won't be sufficient to do well on the final exam. You will also need to take notes in class and to study and understand those notes. If you have any questions then make sure that you ask me for help and clarification.

Using software applications: General
	You won't be asked about where different features are located in a particular program i.e., what is the sequence of clicks to invoke a particular feature of Excel
MS-Excel
	Generally you don't have to specify formulas from scratch (save for 'if' or the 'VLOOKUP')
	You will need to know how the formulas covered in class work so you can recognize and evaluate them in exam. That is if you are given a formula you may be asked to determine the results e.g., you see a spreadsheet with some data and a formula that performs some operations on that data and you are asked to specify the value or values returned.
	Remember: You won't be allowed to use a calculator let alone a more powerful device such as tablet or laptop. However any calculations that may be asked to perform should be fairly simply so you can evaluate them by hand. (It is assumed that you can handle the common mathematical operations that you were taught in grades 1 - 12).
MS-Access
	Input masks and validation rules: you could be asked to specify either of these on an exam in order to fulfill some requirements e.g., "What is the validation rule that you should specify if you wanted to ensure that the bank balance is non-negative".
	Forming queries: you could be asked to form your queries either graphically ("design view" in Access) or in text form (SQL).
	Evaluating the result of a query: given a set of data in some tables and a query (graphical or SQL) you could be asked to determine the set of results returned.

Min raw score	Grade point
0	0
40	1
46	1.1
48	1.2
50	1.3
52	1.4
53	1.5
54	1.6
55	1.7
56	1.8
58	1.9
60	2
61	2.1
63	2.2
65	2.3
67	2.4
68	2.5
69	2.6
70	2.7
71	2.8
73	2.9
75	3
76	3.1
78	3.2
80	3.3
81	3.4
83	3.5
84	3.6
85	3.7
86	3.8
88	3.9
90	4
93	4.1
96	4.2
98	4.3