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 3
Page 1 of 17
Unit
Unit 2: Topic 7
I ntroduction
Introduction
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
Page 1 of 25
Unit
Unit 2: Topic 8 (Lookup Functions)
I ntroduction
Introduction
Given a list of names and phone numbers, find the phone number for a person.
Given a list of names and phone numbers, fi
Page 1 of 23
Unit
Unit 3: Topic 9
I ntroduction
Introduction
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 item
Page 1 of 10
Unit
Unit 3: Topics 10 and 11
I ntroduction
Introduction
It is said that "A picture is worth a thousand words". Can I present the data from the worksheet
graphically?
How can I graphicall
Assumptions:
Sales Amount per Machine
Supplies and service rate
Estimated Sales Growth
First Year Sales
Equipment Costs
Minimum Cash on Hand
Bank Interest Rate
Employee Cost
Sales Amount per Employee
Page 1 of 22
Unit 4:
Unit 4: Topic 14
I ntroduction
Introduction
What if a few of the expense categories of producing certain items are increased by 25% more than
expected, how will this affect your p
Page 1 of 23
Unit
Unit 2: Topic 6
I ntroduction
Introduction
What application software can I use to model data and do calculations to obtain the desired
information?
What kind of data can I enter in a
Page 1 of 3
Unit 1: Topic 5
Introduction
How can I use a computer to type my research paper so that it looks like a
professional document?
How can I use a computerto play a game?
What does compatibili
Page 1 of 8
Unit
Unit 1: Topic 4
I ntroduction
Introduction
How is the raw data stored electronically?
What is this file about?
All different types of data such as numbers, text, pictures, sound etc.
COMP1600
Exam Prep Questions
The exam has four sections
1.
2.
3.
4.
Answer questions about a spreadsheet design you're given
Create a spreadsheet design for a given problem
Answer questions about a da
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
Concept Index for Computer Science 1600 Problems
Unit
1
1
1
1
Video Index
Video 3- 34:08
Video 3- 22:04, 42:40
1
1
1
2
Concept/Skill
Full pathnames
Relative Pathnames
Navigating file systems
Accessing
Page 1 of 6
Unit
Unit 1: Topic 1
I ntroduction
Introduction
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 breakfas
Page 1 of 4
Unit 1: Topic 2
Introduction
What drives the hardware of the computer and gets the job done for a user of the
computer?
Software is the set of all programs and related data that runs on a
Page 1 of 12
Unit
Unit 1: Topic 3
I ntroduction
Introduction
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
Page 1 of 25
Unit
15
Unit 5: Topic 15
I ntroduction
Introduction
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