CPSC 203: Midterm information

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

CPSC 203: Final exam Information

More information will be added here as we approach the exam date so you should check back here for updates

Date/location:

The exam will be written during the regular final exam period. Check online via the [PeopleSoft my.ucalgary] portal for time/date information.

Review material:

During lecture as I cover the material I will provide suggestions of what an exam-like question may look like. You should attend class for this info and note the details as it comes up.
In class review: last day of lecture on Tuesday April 12. If you miss the lecture then you can get a hard copy outside of ICT707 on the table.

Starting database used in review: [Access]

Starting webpage: [html exercise]

JavaScript programs (in class): [In class 1: exponentLoops] [In class 2: main (trace)]

JavaScript programs (extra): [Extra 1: branchProblem] [Extra 2: exponentLoopsV2]

Want even more practice, try the library website, there's online books that are licensed by the U of C. Look for Office2013 books and books on JavaScript and you can try their recommended exercises: [Safari website]

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

ID number goes on the inside of the first (cover) page.

Material that you should study

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-Word
	You be asked general questions about the benefits of using certain features of Word (e.g. automatically creating a table of contents, using master documents)

^{MS-Excel documentation that you will get for the exam: as indicated in
class the documentation shows you the function arguments ("how to run function")
but not detailed explanations about how each one works such as the return value(s).}

Basic mathematical operators: assignment (=), addition (+), subtraction (-), multiplication(*), division (/), exponent(^)
Basic statistical formulas (an alternative to entering the start : cell range is to manually enter a series of numbers as the function argument).
	SUM(<start cell> : <end cell>) AVERAGE(<start cell> : <end cell>) MIN(<start cell> : <end cell>) MAX(<start cell> : <end cell>)
Counting functions (an alternative to entering the start : cell range is to manually enter the data sequence as the function argument).
	COUNT(<start cell> : <end cell>) COUNTA(<start cell> : <end cell>) COUNTBLANK(<start cell> : <end cell>)
String (and related utility) functions (an alternative to entering the cell is to manually enter a string as the function argument).
	PROPER(<"string"> or <cell containing a string>) UPPER(<"string"> or <cell containing a string>) LOWER(<"string"> or <cell containing a string>) TRIM(<"string"> or <cell containing a string>) CONCATENATE(<cell₁>or <"string">, <cell₂>or <"string">_....<cell_n> or <"string">) LEFT(<cell>, <number of characters>) RIGHT(<cell>, <number of characters>) MID(<cell>, <start position>, <number of characters>) FIND(<find text>, <within text>, [<start position>])
Date and time functions
	TODAY() NOW()
Branching function
	=if(<condition to check>, <return value: condition true>, <return value: condition false>)
Logical comparators (relational operators): less than (<), less than equal to (<=), greater than (>), greater than equal to (>=), equal to (=), not equal to (<>)
Lookup functions
	LOOKUP(<Lookup value>, <Lookup column (vector) Start : End>, <result column (vector) Start : End>) VLOOKUP(<Lookup value>, <Lookup table Start : End>, <Lookup table Column specifying the return value>, [<Exact match required?>])
Conditional counting functions (an alternative to entering the start : cell range is to manually enter the data sequence as the function argument).
	COUNTIF(<start cell> : <end cell>, <condition>) COUNTIFS(<start cell> : <end cell>, <condition>, (<start cell> : <end cell>, <condition>) )
Logical Functions
	NOT(<true or false value>) AND(<true or false value>, <true or false value>...<true or false value>) OR(<true or false value>, <true or false value>...<true or false value>)

^{MS-Access documentation that you will get for the exam}

Characters that define input masks
	Numbers: 0, 9 Alphabetic letters: L, ? Alpha or digit: A, a Digit, space, plus or minus sign: # Converting alpha to upper case: > Converting alpha to lower case: <
Specifying validation rules (Strings): Like "<Format for String>"
	Formats: Digits [0-9], Alphabetic [A-Z], Wildcard *, Single character wild card ?

^{JavaScript documentation that you will get for the exam}

String methods
	Length: <Length> = <String>.length; Converting to upper case: <Converted string> = <String>.toUpperCase(); Converting to lower case: Converted string> = <String>.toLowerCase();

JavaScript concepts you 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 or 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()'
Mathematical operators
Writing documentation (you don't have to document your code writing solutions in the exam unless asked)
Branching: if, if-else; if, else if, else
Looping/repetition: for, while
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>

Exam topics (exam will be cumulative but with a heavy focus on material covered after the midterm)

Lecture topics covered so far	Approximate proportion of exam²
Earlier material	~10%
Databases	39
Html	6
JavaScript	39
Computer security (up and including slide #25, of course material covered in lecture is also "fair game" as an exam question.	5%
Other	~1%

1 The topic or topics being evaluated in the question doesn't fall neatly into one of the above categories e.g., the question covers materials that span multiple topics

Exam questions²

Multiple choice questions 40 marks

Short answer questions 70 marks
	Microsoft Excel x 1 question
	Microsoft Access x 3 questions
	Html x 1 question
	JavaScript: program code tracing x 2 questions
	JavaScript: program code writing x 2 questions

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

Min percent	GPA
0	0
1	0.3
30	0.7
38	1
44	1.1
48	1.2
50	1.3
52	1.4
54	1.5
56	1.6
58	1.7
60	1.8
61	1.9
62	2
63	2.1
64	2.2
65	2.3
66	2.4
67	2.5
68	2.6
69	2.7
70	2.8
71	2.9
72	3
74	3.1
76	3.2
78	3.3
80	3.4
81	3.5
82	3.6
83	3.7
84	3.8
85	3.9
86	4
91	4.1
95	4.2
98	4.3

CPSC 203: Final exam Information

Date/location:

Review material:

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

ID number goes on the inside of the first (cover) page.

Material that you should study

MS-Excel documentation that you will get for the exam: as indicated in class the documentation shows you the function arguments ("how to run function") but not detailed explanations about how each one works such as the return value(s).

MS-Access documentation that you will get for the exam

JavaScript documentation that you will get for the exam

JavaScript concepts you are expected to know

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)

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

Exam topics (exam will be cumulative but with a heavy focus on material covered after the midterm)

Lecture topics covered so far

Approximate proportion of exam2

1 The topic or topics being evaluated in the question doesn't fall neatly into one of the above categories e.g., the question covers materials that span multiple topics

Exam questions2

Multiple choice questions 40 marks

Short answer questions 70 marks

^{MS-Excel documentation that you will get for the exam: as indicated in
class the documentation shows you the function arguments ("how to run function")
but not detailed explanations about how each one works such as the return value(s).}

^{MS-Access documentation that you will get for the exam}

^{JavaScript documentation that you will get for the exam}

Approximate proportion of exam²

Exam questions²