Computer Science 1600 Final, Fall 2010
You have two hours to complete four problem sets.
Problem 1 has one part
Problem 2 has three parts (figures 2A, 2B and 2C)
Problem 3 has five parts (3A through 3E)
Problem 4 has three parts (4A through 4C)
Page 1 of 17
Unit 2: Topic 7
Have you ever wondered how you will use MS-Excel software to solve a given problem? That
is, how would you model the problem solution using MS-Excel?
MS - Excel is a very powerful spreadshe
Page 1 of 25
Unit 2: Topic 8 (Lookup Functions)
Given a list of names and phone numbers, find the phone number for a person.
Given a list of names and phone numbers, find the name of a person with the given phone
Page 1 of 23
Unit 3: Topic 9
How can the following be computed?
If the number of items ordered is 25 or less, then the cost per item is $5.00 but if the number
of items ordered is more than 25 then the cost per item is $4.
Page 1 of 10
Unit 3: Topics 10 and 11
It is said that "A picture is worth a thousand words". Can I present the data from the worksheet
How can I graphically compare the sales from 5 different stores?
What is th
Sales Amount per Machine
Supplies and service rate
Estimated Sales Growth
First Year Sales
Minimum Cash on Hand
Bank Interest Rate
Sales Amount per Employee
Page 1 of 22
Unit 4: Topic 14
What if a few of the expense categories of producing certain items are increased by 25% more than
expected, how will this affect your profits?
What if you lower product prices and increase t
C onduit casing
2009 January Avalon
2008 October Island
2009 October Island
2009 November Labrador
2008 January Island
Page 1 of 23
Unit 2: Topic 6
What application software can I use to model data and do calculations to obtain the desired
What kind of data can I enter in a worksheet?
How do I refer to or use the values stored
Page 1 of 3
Unit 1: Topic 5
How can I use a computer to type my research paper so that it looks like a
How can I use a computerto play a game?
What does compatibility of software mean?
A computer is a very versatile too
Exam Prep Questions
The exam has four sections
Answer questions about a spreadsheet design you're given
Create a spreadsheet design for a given problem
Answer questions about a database design you're given
Create a database design for
Computer Science 1600 Midterm, Fall 2010
You have one hour to complete both problem sets.
Answer all Questions in the space provided.
University regulations regarding academic dishonesty apply to this examination.
You may detach the problem statements on
Concept Index for Computer Science 1600 Problems
Video 3- 34:08
Video 3- 22:04, 42:40
Navigating file systems
Accessing files within an
Types of files
Page 1 of 6
Unit 1: Topic 1
Can you think of a day when you have not used a computer?
If you have used a coffee maker for your coffee, a microwave to heat your breakfast, driven your car
to University, or gone to the bank t
Page 1 of 4
Unit 1: Topic 2
What drives the hardware of the computer and gets the job done for a user of the
Software is the set of all programs and related data that runs on a computer. Software can be of
two types: system software
Page 1 of 12
Unit 1: Topic 3
How is raw data stored on storage devices?
How is the stored data managed?
The raw data is converted into electronic format and stored on a storage device as a file in a
particular addressable l
Page 1 of 8
Unit 1: Topic 4
How is the raw data stored electronically?
What is this file about?
All different types of data such as numbers, text, pictures, sound etc. are stored electronically in
binary format in a file. E
Page 1 of 25
Unit 5: Topic 15
What is the total rental amount spent by the males and females on each model of car?
How many cars from each model are rented?
What is the most popular car model?
Which age group rents the m