USUS UKUKIndiaIndia

Every Question Helps You Learn

Parents Students Tutors Teachers
Join Us
USUS UKUKIndiaIndia
Join Us
Elementary (Grade 1-2)Elementary (Grade 3-5)Middle (Grade 6-8)Junior High (Grade 9-10)Senior High (Grade 11-12)Spanish (All ages)ESL (All ages)GamesSpecialist (All ages)
  1. Home
  2. Middle School: 6th, 7th and 8th Grade
  3. Computer Science: Middle School: Grades 6, 7 and 8
  4. Models 2
Streak
Leading Streak Today 49
Your Streak Today 0
Streak
Leading Streak Today
49
Your Streak Today
0
Models 2
Formulae can create output as charts and graphs like a pie chart.

Models 2

This Computer Science quiz is called 'Models 2' and it has been written by teachers to help you if you are studying the subject at middle school. Playing educational quizzes is a fabulous way to learn if you are in the 6th, 7th or 8th grade - aged 11 to 14.

It costs only $12.50 per month to play this quiz and over 3,500 others that help you with your school work. You can subscribe on the page at Join Us

You will often see formulae in computer models. Spreadsheets are frequently used for financial information because of their ability to re-calculate the entire sheet automatically after a change to a single cell is made.

Try our second quiz on Models.

1.
Which of these is not a formula?
=C3+F2*H5
=C3-F2*$H5
-C3/F2*H5
=C3*F2*H5
Doesn't start with =
2.
Models represent real life situations using .......
data and analysis
data and intuition
data and rules
data and statistics
3.
Spreadsheet models use ....... to represent rules.
cells
conditional formatting
formulae
symbols
4.
The values in the spreadsheet cells act as .......
information
input
macros
reports
5.
The formulae in the models act as .......
calculations
data
enquiries
processes
6.
The formulae can create output as charts and graphs.
Charts and graphs are the only form of output possible
Charts and graphs are vital to understand predictions
Charts and graphs can improve understanding of results
Charts and graphs make the output more accurate
Use them when they are useful - not just for looks
7.
Spreadsheets are good at doing ....... analysis of data.
how-why
what-else
what-if
why-when
For example: What happens to sales if tax rates increase?
8.
A model rule is: profit = number sold x saleprice - cost.
A suitable formula might be: =D5x(C5-B5)
A suitable formula might be: =D5x(C5/B5)
A suitable formula might be: =D5*(C5-B5)
A suitable formula might be: =D5^(C5-B5)
The 'rule' is represented by a formula entered in a cell
9.
Models often include many rules because .......
a single formula can only handle simple rules
real world situations are often very complicated
results can be achieved much quicker with more rules
the more rules used, the more accurate the results
Even simple situations can need many rules to model
10.
Predictions made by models are usually .......
approximate
correct
exact
wrong
Rules are rarely perfect and may not have complete data
Author:  Duncan Daish
Computer Science: Middle School: Grades 6, 7 and 8 Play this quiz again

Contact Details

Education Quizzes

Heron's Way, Wragg Marsh
Spalding
Lincolnshire
PE12 6HH
England

Email

admin@educationquizzes.com

Customer Service

Home Page Students Free Teacher Resources in the USA - 4,000 Teacher-Written Quizzes Tutors

Here To Help

Contact Us Quiz List and Sitemap FAQs

About Us

Our Team Testimonials Terms and Conditions Privacy Policy

© Copyright 2016-2024 - Education Quizzes
Work Innovate Ltd - Design | Development | Marketing

We use cookies to enhance your experience on our website.

To comply with the e-Privacy directive, we need your consent - I agree - No thanks - Learn more