CSC102B/MATH298B - Waiver Test

If you think that you do not need to take CSC102B or MAT298B as a co-requisite with MAT116, then please read this page carefully. CSC102B/MATH298B covers features of Excel and Word that are not normally covered in an introductory course. If you can accomplish the following tasks (at least 8 out of 10) with little or no problem, then you are probably okay to skip CSC102B. However, if you choose to do so, you take full responsibility for knowing the material needed to complete the projects in 116/148. The instructors will not be covering this stuff in 116 or 148, so your decision to skip CSC102B/298B is a significant one. Be aware that starting in Fall 2009, 116 and 148 require permission to enroll. Part of this permission process is first enrilling in CSC102B or MATH298B. Students who can demonstrated mastery of the following skills to the instructor (in person) may (upon the sole discretion of the instructor) receive permission to enroll in 116 or 148 without enrilling in CSC102B or MATH298B.


1.) Use the Equation Editor in Microsoft Word to type in the following equation into a Word document:

2.) Download the file called waiver.xls (use the right-mouse button and choose "Save Target As..."). In the sheet called S&P500 you will find a list of stock prices. Use this data and Excel's histogram tool to create a histogram of this data. Your graph should include 10 bars. Don't know what a histogram is? Move on the next question.


3.) In the file called
waiver.xls, open the sheet called Random. In cell M1, enter a single Excel formula that will count the number of cells that have numbers in them that are strictly greater than 0.85.


4.) In the file called
waiver.xls, open the sheet called Chrysler. Without sorting the data, enter a single formula in cell H2 that will count the number of Pacifica's priced between $18,000 and $22,000 that were sold by Juan.


5.) In the file called
waiver.xls, open the sheet called Graph. In the columns labeled x and y, use formulas to give a list of x and y values that can be used to graph the function . Your graph and table should go from x = 1 to x = 10 and have 40 points of data on it.


6.) In the file called
waiver.xls, open the sheet called Measurement. There you will find a series of data that relates a person's waist size to their height. Use this data to plot the points on a graph


7.) In the file called
waiver.xls, open the sheet called Measurement. There you will find a series of data that relates a person's waist size to their height. Use this data to plot the points on a graph and then find the best-fitting linear trendline that matches this data. Don't know what a trendline is? Move on the next question.


8.) In the file called
waiver.xls, open the sheet called Cars. This sheet contains data on hypothetical invoice numbers and the amount of money per invoice. Without sorting the data, enter a single formula in cell E2 that will automatically report the corresponding amount of sales for any invoice number entered into cell D2.


9.) In the file called
waiver.xls, open the sheet called Random2. In cell B2, enter a single formula that will generate a random integer between 12 and 20 if cell A2 is a 0, and a random number between 0 and 1 if cell A2 is not a 0.


10.) Use the pictures below to recreate the following file, including all equation, header and footer bars, bullet items, and font styles.
Click here to view the file (required Adobe Acrobat Reader.)